创建数据库:

create database duizhan go use duizhan go create table duizhan ( Code varchar(20) not null primary key, Name varchar(20) not null, Sex varchar(20) not null, Blood int, Attack int, Defence int, Mingzhong int, Shanbi int, Speed int, Experience int, Lv int, )

  DBconnect.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;

namespace 对战
{
    public class DBconnect
    {
        private static string connstring = "server=.;database=duizhan;user=sa;pwd=diushiDEwutong0";

        public static SqlConnection conn
        {
            get
            {
                return new SqlConnection(connstring);
            }
        }

    }
}

  

duizhan.cs

 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace 对战
{
public class duizhan
{
private string code;

public string Code
{
get { return code; }
set { code = value; }
}

private string name;

public string Name
{
get { return name; }
set { name = value; }
}

private string sex;

public string Sex
{
get { return sex; }
set { sex = value; }
}

private int blood;

public int Blood
{
get { return blood; }
set { blood = value; }
}

private int attack;

public int Attack
{
get { return attack; }
set { attack = value; }
}

private int defence;

public int Defence
{
get { return defence; }
set { defence = value; }
}

private int mingzhong;

public int Mingzhong
{
get { return mingzhong; }
set { mingzhong = value; }
}

private int shanbi;

public int Shanbi
{
get { return shanbi; }
set { shanbi = value; }
}

private int speed;

public int Speed
{
get { return speed; }
set { speed = value; }
}

private int experience;

public int Experience
{
get { return experience; }
set { experience = value; }
}

private int lv;

public int Lv
{
get { return lv; }
set { lv = value; }
}

}
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;

namespace 对战
{
    public class duizhanDA
    {
        private SqlConnection _conn;
        private SqlCommand _cmd;
        private SqlDataReader _dr;

        //用构造函数来初始化连接对象,命令对象
        public duizhanDA()
        {
            _conn = DBconnect.conn;
            _cmd = _conn.CreateCommand();
        }

        //添加数据

        public bool Add(string code, string name, string sex)
        {
            int seed = (int)Convert.ToChar(name.Substring(0, 1)) + (int)Convert.ToChar(name.Substring(1, 1));
            Random rand = new Random(seed);
            //Random rand = new Random();

            int blood = 3000 + rand.Next(3000);
            int attack = 600 + rand.Next(400);
            int defence = 10 + rand.Next(90);
            int minzhong = rand.Next(50) + 50;
            int shanbi = rand.Next(50) + 10;
            int speed = 100 + rand.Next(50);
            int exprience = 0;
            int lv = 1;

            _cmd.CommandText = "insert into duizhan values(@code,@name,@sex,@blood,@attack,@defence,@minzhong,@shanbi,@speed,@experience,@lv)";
            _cmd.Parameters.Clear();
            _cmd.Parameters.AddWithValue("@code", code);
            _cmd.Parameters.AddWithValue("@name", name);
            _cmd.Parameters.AddWithValue("@sex", sex);
            _cmd.Parameters.AddWithValue("@blood", blood);
            _cmd.Parameters.AddWithValue("@attack", attack);
            _cmd.Parameters.AddWithValue("@defence", defence);
            _cmd.Parameters.AddWithValue("@minzhong", minzhong);
            _cmd.Parameters.AddWithValue("@shanbi", shanbi);
            _cmd.Parameters.AddWithValue("@speed", speed);
            _cmd.Parameters.AddWithValue("@experience", exprience);
            _cmd.Parameters.AddWithValue("@lv", lv);

            _conn.Open();
            int n = _cmd.ExecuteNonQuery();
            _conn.Close();

            if (n > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        //查询所有数据
        public List<duizhan> Select()
        {
            _cmd.CommandText = "select * from duizhan";
            _conn.Open();
            _dr = _cmd.ExecuteReader();


            //定义一个空的集合
            List<duizhan> list = new List<duizhan>();

            if (_dr.HasRows)
            {
                while (_dr.Read())
                {
                    //造一个duizhan对象
                    duizhan data = new duizhan();

                    data.Code = _dr[0].ToString();
                    data.Name = _dr[1].ToString();
                    data.Sex = _dr[2].ToString();
                    data.Blood = (int)_dr[3];
                    data.Attack = (int)_dr[4];
                    data.Defence = (int)_dr[5];
                    data.Mingzhong = (int)_dr[6];
                    data.Shanbi = (int)_dr[7];
                    data.Speed = (int)_dr[8];
                    data.Experience = (int)_dr[9];
                    data.Lv = (int)_dr[10];

                    //扔到集合里面
                    list.Add(data);
                }
            }
            _conn.Close();
            return list;
        }



        //根据姓名查询
        public List<duizhan> Select(string name)
        {
            _conn.Open();
            _cmd.CommandText = "select * from duizhan where name=@name";
            _cmd.Parameters.Clear();
            _cmd.Parameters.AddWithValue("@name", name);

            _dr = _cmd.ExecuteReader();


            List<duizhan> list = new List<duizhan>();

            if (_dr.HasRows)
            {
                while (_dr.Read())
                {
                    //造一个duizhan对象
                    duizhan data = new duizhan();

                    data.Code = _dr[0].ToString();
                    data.Name = _dr[1].ToString();
                    data.Sex = _dr[2].ToString();
                    data.Blood = (int)_dr[3];
                    data.Attack = (int)_dr[4];
                    data.Defence = (int)_dr[5];
                    data.Mingzhong = (int)_dr[6];
                    data.Shanbi = (int)_dr[7];
                    data.Speed = (int)_dr[8];
                    data.Experience = (int)_dr[9];
                    data.Lv = (int)_dr[10];

                    //扔到集合里面
                    list.Add(data);
                }
            }
            _conn.Close();
            return list;
        }

        //更改经验数据
        public bool update(int experience, string name)
        {
            _cmd.CommandText = "update duizhan set experience ='" + experience + "' where name=@name";
            _cmd.Parameters.Clear();
            _cmd.Parameters.AddWithValue("@name", name);
            _conn.Open();
            int n = _cmd.ExecuteNonQuery();
            _conn.Close();

            if (n > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        //升级
        public bool update(string name)
        {
            List<duizhan> list = Select(name);
            
            list[0].Blood += 300;
            list[0].Attack += 50;
            list[0].Defence += 10;
            list[0].Lv += 1;
            _cmd.CommandText = "update duizhan set  Blood=" + list[0].Blood + ",Attack=" + list[0].Attack + ",Defence=" + list[0].Defence  + ",lv=" + list[0].Lv+ " where Name=@name";
            _cmd.Parameters.Clear();
            _cmd.Parameters.AddWithValue("@name", name);
            _conn.Open();
            int n = _cmd.ExecuteNonQuery();
            _conn.Close();
            if (n > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        //删除程序
        public bool delete(string name)
        {
            _cmd.CommandText = "delete  from duizhan where name=@name";
            _cmd.Parameters.Clear();
            _cmd.Parameters.AddWithValue("@name", name);
            _conn.Open();
            int n = _cmd.ExecuteNonQuery();
            _conn.Close();

            if (n > 0)
            {
                return true;
            }
            else
            {
                return false;
            }

        }

        //对战
        public List<duizhan> PK(List<duizhan> list1, List<duizhan> list2)
        {

            int s1 = list1[0].Speed;
            int s2 = list2[0].Speed;
            while (list1[0].Blood > 0 && list2[0].Blood > 0)
            {
                Random mz = new Random();
                while (s1 != 0 && s2 != 0)
                {
                    s1--;
                    s2--;
                   
                }
                Console.ForegroundColor = ConsoleColor.Blue;
                Console.WriteLine(list1[0].Name + "速度值:" + s1 +"---"+ list2[0].Name + "速度值:" + s2);
                Console.ForegroundColor = ConsoleColor.Black;
                if (s1 == 0)
                {
                    Console.WriteLine(list1[0].Name + "攻击");
                    if (mz.Next(101) < list1[0].Mingzhong)
                    {
                        Random sb = new Random();
                        if (sb.Next(101) < list2[0].Shanbi)
                        {
                            Console.ForegroundColor = ConsoleColor.Green;
                            Console.WriteLine(list1[0].Name + "未命中");
                            Console.ForegroundColor = ConsoleColor.Black;

                        }
                        else
                        {
                            Console.ForegroundColor = ConsoleColor.Red;
                            list2[0].Blood = list2[0].Blood - list1[0].Attack * (1-(list2[0].Defence / 300));
                            Console.WriteLine(list1[0].Name + "输出" + (list1[0].Attack * (1 - list2[0].Defence / 300)) + "伤害");
                            Console.ForegroundColor = ConsoleColor.Black;
                        }
                    }
                    else
                    {
                        Console.ForegroundColor = ConsoleColor.Green;
                        Console.WriteLine(list1[0].Name + "未命中");
                        Console.ForegroundColor = ConsoleColor.Black;
                    }
                    Console.ForegroundColor = ConsoleColor.Red;
                    Console.WriteLine(list2[0].Name + "血量:" + (list2[0].Blood < 0 ? 0 : list2[0].Blood) + "———" + list1[0].Name + "血量:" + (list1[0].Blood < 0 ? 0 : list1[0].Blood));
                    Console.ForegroundColor = ConsoleColor.Black;
                    s1 = list1[0].Speed;
                }
                else if (s2 == 0)
                {
                    Console.WriteLine(list2[0].Name + "攻击");
                    if (mz.Next(101) < list2[0].Mingzhong)
                    {
                        Random sb = new Random();
                        if (sb.Next(101) < list1[0].Shanbi)
                        {
                            Console.ForegroundColor = ConsoleColor.Green;
                            Console.WriteLine(list2[0].Name + "未命中");
                            Console.ForegroundColor = ConsoleColor.Black;
                        }
                        else
                        {
                            Console.ForegroundColor = ConsoleColor.Red;
                            list1[0].Blood = list1[0].Blood - (list2[0].Attack * (1-(list1[0].Defence / 300)));
                            Console.WriteLine(list2[0].Name + "输出" + (list2[0].Attack * (1 - (list1[0].Defence / 300))) + "伤害");
                            Console.ForegroundColor = ConsoleColor.Black;
                        }
                    }
                    else
                    {
                        Console.ForegroundColor = ConsoleColor.Green;
                        Console.WriteLine(list2[0].Name + "未命中");
                        Console.ForegroundColor = ConsoleColor.Black;
                    }
                    Console.ForegroundColor = ConsoleColor.Red;
                    Console.WriteLine(list2[0].Name + "血量:" + (list2[0].Blood < 0 ? 0 : list2[0].Blood) + "———" + list1[0].Name + "血量:" + (list1[0].Blood < 0 ? 0 : list1[0].Blood));
                    Console.ForegroundColor = ConsoleColor.Black;
                    s2 = list2[0].Speed;
                }
                System.Threading.Thread.Sleep(1000);
                Console.WriteLine();

            }
            if (list1[0].Blood < 0)
            {
                List<duizhan> fanhui = list2;
                return fanhui;
            }
            else
            {
                List<duizhan> fanhui = list1;
                return fanhui;
            }







        }




    }

}

  主函数:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;

namespace 对战
{
class Program
{

static void Main(string[] args)
{
Console.BackgroundColor = ConsoleColor.White;
Console.ForegroundColor = ConsoleColor.Black;
string[] AR = new string[] { "code", "姓名", "性别", "血量", "攻击", "防御", "命中", "闪避", "速度", "经验", "等级" };

Console.WriteLine("添加还是查询?添加输入1,查询输入2,战斗输入3");
string s = Console.ReadLine();
duizhanDA da = new duizhanDA();
string code = "";
string name = "";
if (s == "1")
{
//添加数据
while (true)
{
Console.WriteLine("添加数据程序");
Console.WriteLine("请输入您要添加的成员代号");
code = Console.ReadLine();
Console.WriteLine("请输入您要添加的成员姓名");
name = Console.ReadLine();
Console.WriteLine("请输入您要添加的成员性别");
string sex = Console.ReadLine();
if (da.Add(code, name, sex))
{
Console.WriteLine("添加成功");
}
else
{
Console.WriteLine("添加失败");
}
Console.WriteLine("是否继续添加,继续请输入1,跳出输入任意键");
string a = Console.ReadLine();
if (a == "1")
{
Console.WriteLine("继续输入");
}
else
{
Console.WriteLine("程序跳出");
break;
}
}
}
else if (s == "2")
{
Console.WriteLine("输出属性");

Console.WriteLine("可查询的人员名单:");
List<duizhan> List = new List<duizhan>();
while (true)
{
List = da.Select();
if (List.Count() != 0)
{

int i = 0;

while (i < List.Count())
{
Console.Write(List[i].Name + "\t");
i++;
}

Console.Write("\n");
break;
}
else
{
Console.WriteLine("输入错误,请重新输入");
code = Console.ReadLine();
}

}

Console.WriteLine("请输入要查询的姓名");
name = Console.ReadLine();


while (true)
{
List = da.Select(name);
if (List.Count() != 0)
{

int i = 0;
while (i < 11)
{
Console.Write(AR[i] + "\t");
i++;
}
Console.Write("\n");

Console.Write(List[0].Code + "\t");
Console.Write(List[0].Name + "\t");
//Console.Write(((List[0].Sex == "True") ? "男" : "女") + "\t");
Console.Write(List[0].Sex + "\t");
Console.Write(List[0].Blood + "\t");
Console.Write(List[0].Attack + "\t");
Console.Write(List[0].Defence + "\t");
Console.Write(List[0].Mingzhong + "\t");
Console.Write(List[0].Shanbi + "\t");
Console.Write(List[0].Speed + "\t");
Console.Write(List[0].Experience + "\t");
Console.Write(List[0].Lv + "\t");

Console.Write("\n");
break;
}
else
{
Console.WriteLine("输入错误,请重新输入");
code = Console.ReadLine();
}

}
}
else if (s == "3")
{
Console.WriteLine("战斗序列");
Console.WriteLine("可以选择的对战人员为:");
List<duizhan> List = new List<duizhan>();
while (true)
{
List = da.Select();
if (List.Count() != 0)
{

int i = 0;

while (i < List.Count())
{
Console.Write(List[i].Name + "\t");
Console.Write("等级"+List[i].Lv + "\t");
i++;
}

Console.Write("\n");
break;
}
else
{
Console.WriteLine("输入错误,请重新输入");
code = Console.ReadLine();
}

}

Console.WriteLine("请输入参与战斗的人员");
Console.WriteLine("请输入第一位参加战斗的人员姓名");
string name1 = Console.ReadLine();
Console.WriteLine("请输入第二位参加战斗的人员姓名");
string name2 = Console.ReadLine();
List<duizhan> List1 = da.Select(name1);
List<duizhan> List2 = da.Select(name2);


List<duizhan> jieguo = da.PK(List1, List2);
Console.WriteLine(jieguo[0].Name + "胜利");
int experience = 0;
if (jieguo[0].Name == List1[0].Name)
{
experience = 50 * List2[0].Lv + List1[0].Experience;
da.update(experience, List1[0].Name);
Console.WriteLine(jieguo[0].Name+"获得经验"+experience);
}
else
{
experience = 50 * List1[0].Lv + List2[0].Experience;
da.update(experience, List2[0].Name);
Console.WriteLine(jieguo[0].Name + "获得经验" + experience);
}
//升级需要经验50,100,200,400,800,1600,3200,6400,12800
int[] lvexp = new int[] {0, 50,100,200,400,800,1600,3200,6400,12800};
List<duizhan> uplv = da.Select(jieguo[0].Name);
int lv = uplv[0].Lv;
while (true)
{
if (lvexp[lv] <= uplv[0].Experience)
{
Console.WriteLine("升级了");
da.update(uplv[0].Name);
Console.WriteLine("属性改变为:");
while (true)
{
List = da.Select(uplv[0].Name);
if (List.Count() != 0)
{

int i = 0;
while (i < 11)
{
Console.Write(AR[i] + "\t");
i++;
}
Console.Write("\n");
Console.Write(List[0].Code + "\t");
Console.Write(List[0].Name + "\t");
//Console.Write(((List[0].Sex == "True") ? "男" : "女") + "\t");
Console.Write(List[0].Sex + "\t");
Console.Write(List[0].Blood + "\t");
Console.Write(List[0].Attack + "\t");
Console.Write(List[0].Defence + "\t");
Console.Write(List[0].Mingzhong + "\t");
Console.Write(List[0].Shanbi + "\t");
Console.Write(List[0].Speed + "\t");
Console.Write(List[0].Experience + "\t");
Console.Write(List[0].Lv + "\t");
Console.Write("\n");
break;
}

}
lv++;
}
else
{
break;
}
}

}
else
{
Console.WriteLine("删除数据");
}

 

Console.ReadLine();

}
}
}

posted on 2016-09-18 09:02  Lovetolaugh  阅读(219)  评论(0编辑  收藏  举报