今天写出了一个游戏的升级方法

来源：互联网发布：便宜耳机推荐知乎编辑：程序博客网时间：2024/06/07 00:10

动态生成按钮，在按钮里是一个游戏的升级方法，挺多的！套了很多层的数据库！

希望能看懂

void btn_Command(object sender, CommandEventArgs e)
    {
        int mydengji=0;
        int myjingyan=0;
        int dengji=0;
        int jingyan=0;
        int myzhandou = 0;
        int zhandou = 0;
        string mynicheng = "";
        if (e.CommandName == "bit")
        {
            string mysql="select nicheng,dengji,jingyan from users where name=@name";
            try
            {
                DataTable mydt = SqlHelper.ExecuteTable(mysql, new SqlParameter("@name", Session["name"].ToString()));

                foreach (DataRow myrow in mydt.Rows)
                {
                    mynicheng = Convert.ToString(myrow[0]);
                     mydengji = Convert.ToInt32(myrow[1]);
                     myjingyan = Convert.ToInt32(myrow[2]);
                    myzhandou=(mydengji+12)*108/100;
                }
                string sql = "select dengji,jingyan from users where nicheng=@nicheng";
                try
                {
                    DataTable dt = SqlHelper.ExecuteTable(sql, new SqlParameter("@nicheng", e.CommandArgument.ToString()));
                    foreach (DataRow row in dt.Rows)
                    {
                        dengji = Convert.ToInt32(row[0]);
                        jingyan = Convert.ToInt32(row[1]);
                        zhandou = (dengji + 12) * 108 / 100;
                    }

                        string jieguo="";
                        if (zhandou > myzhandou)
                        {
                            jieguo = "你主动与" + e.CommandArgument.ToString() + "乐斗，却被人家摆平了！获得了20点经验值。";
                            string str = "insert into content (name1,name2,jieguo) values (@name1,@name2,@jieguo)";
                            try
                            {
                                int i = SqlHelper.ExecuteNonQuery(str, new SqlParameter("@name1", mynicheng.ToString()), new SqlParameter("@name2", e.CommandArgument.ToString()), new SqlParameter("@jieguo", jieguo.ToString()));
                                if (i == 1)
                                {

                                    string change="update users set dengji=@dengji,jingyan=@jingyan,zhandou=@zhandou where nicheng=@nicheng";
                                    try
                                    {
                                        if (jingyan + 50 >= 100)
                                        {
                                            jingyan = jingyan + 50 - 100;
                                            dengji = dengji + 1;
                                            this.Response.Write("恭喜您升级了！");
                                        }
                                        int j = SqlHelper.ExecuteNonQuery(change, new SqlParameter("@dengji", dengji), new SqlParameter("@jingyan", jingyan), new SqlParameter("@zhandou", zhandou),new SqlParameter("@nicheng",e.CommandArgument.ToString()));
                                        if (j == 1)
                                        {

                                        }
                                    }
                                    catch (Exception ex)
                                    {
                                        Response.Write(ex.Message);
                                    }

                                    string changemy = "update users set dengji=@mydengji,jingyan=@myjingyan,zhandou=@myzhandou where nicheng=@mynicheng";
                                    try
                                    {
                                        if (myjingyan + 20 >= 100)
                                        {
                                            myjingyan = jingyan + 20 - 100;
                                            mydengji = mydengji + 1;
                                            this.Response.Write("恭喜您升级了！");
                                        }
                                        int j = SqlHelper.ExecuteNonQuery(changemy, new SqlParameter("@mydengji",mydengji), new SqlParameter("@myjingyan", myjingyan), new SqlParameter("@myzhandou", myzhandou), new SqlParameter("@mynicheng", mynicheng));
                                        if (j == 1)
                                        {

                                        }
                                    }
                                    catch (Exception ex)
                                    {
                                        Response.Write(ex.Message);
                                    }
                                }
                            }
                            catch (Exception ex)
                            {
                                Response.Write(ex.Message);
                            }
                        }
                        else
                        {
                            jieguo = "你主动与" + e.CommandArgument.ToString() + "乐斗，把他打得落花流水！获得了50点经验值。";
                            string str = "insert into content (name1,name2,jieguo) values (@name1,@name2,@jieguo)";
                            try
                            {
                                int i = SqlHelper.ExecuteNonQuery(str, new SqlParameter("@name1", mynicheng.ToString()), new SqlParameter("@name2", e.CommandArgument.ToString()), new SqlParameter("@jieguo", jieguo.ToString()));
                                if (i == 1)
                                {
                                    string change = "update users set dengji=@dengji,jingyan=@jingyan,zhandou=@zhandou where nicheng=@nicheng";
                                    try
                                    {
                                        if (jingyan + 20 >= 100)
                                        {
                                            jingyan = jingyan + 20 - 100;
                                            dengji = dengji + 1;
                                            this.Response.Write("恭喜您升级了！");
                                        }
                                        int j = SqlHelper.ExecuteNonQuery(change, new SqlParameter("@dengji", dengji), new SqlParameter("@jingyan", jingyan), new SqlParameter("@zhandou", zhandou), new SqlParameter("@nicheng", e.CommandArgument.ToString()));
                                        if (j == 1)
                                        {

                                        }
                                    }
                                    catch (Exception ex)
                                    {
                                        Response.Write(ex.Message);
                                    }

                                    string changemy = "update users set dengji=@mydengji,jingyan=@myjingyan,zhandou=@myzhandou where nicheng=@mynicheng";
                                    try
                                    {
                                        if (myjingyan + 50 >= 100)
                                        {
                                            myjingyan = myjingyan + 50 - 100;
                                            mydengji = mydengji + 1;
                                            this.Response.Write("恭喜您升级了！");
                                        }
                                        int j = SqlHelper.ExecuteNonQuery(changemy, new SqlParameter("@mydengji",mydengji), new SqlParameter("@myjingyan", myjingyan), new SqlParameter("@myzhandou", myzhandou), new SqlParameter("@mynicheng", mynicheng));
                                        if (j == 1)
                                        {

                                        }
                                    }
                                    catch (Exception ex)
                                    {
                                        Response.Write(ex.Message);
                                    }
                                }
                            }
                            catch (Exception ex)
                            {
                                Response.Write(ex.Message);
                            }
                        }

                }
                catch (Exception ex)
                {
                    Response.Write(ex.Message);
                }
            }
            catch (Exception ex)
            {
                Response.Write(ex.Message);
            }



        }