ASP.NET MVC 排球计分程序 （二）一些排球计分的基本实现方式

@{

    ViewBag.Title = "Index";

}

 

Index


@using(Html.BeginForm("Indexa","Home")) {

 

  id:  @Html.TextBox("id",1);

  name: @Html.TextBox("name");

 

"submit">提交

}

public ActionResult Indexa()

        {

            SqlConnection conn = new SqlConnection();

            conn.ConnectionString = @"Data Source=.;Initial Catalog=paiqiu;Integrated Security=True";

            SqlCommand comm = new SqlCommand();

            comm.Connection = conn;

            string aa=Request["id"].ToString();

            int c = int.Parse(aa);

            string aaa = Request["name"].ToString();

         

            comm.CommandText = "insert into yifu (id,name) values ("+c+",‘"+aaa+"‘)";

            conn.Open();

            int a = comm.ExecuteNonQuery();

            conn.Close();

            if (a > 0)

            {

                ViewBag.S = "插入成功";

                ViewBag.J = "插入结果为";

                comm.CommandText = "select *from yifu";

                conn.Open();

                SqlDataReader dr = comm.ExecuteReader();

                if (dr.HasRows)

                {

                    ViewBag.a = "";

                    while (dr.Read())

                    {

                        ViewBag.a += "";

                    }

                }

                ViewBag.a += "


编号
名字



" + dr["id"] + "


" + dr["name"] + "


";

 

 

            }

            else

            {

                ViewBag.a += "插入失败";

                ViewBag.S = "";

                ViewBag.J = "";

            }

            return View();

        }

public ActionResult Indexb()
        {
            
            return View();
        }

@{
    ViewBag.Title = "Indexb";
}

Indexb

@using (Html.BeginForm("Indexc", "Home"))
{ 
    string str=ViewBag.ccc;
    if (string.IsNullOrEmpty(str))
    {
        str = "0";
    }
    @Html.TextBox("number",str);
    "submit">得分
}

   public ActionResult Indexc()

        {

           int a=int.Parse( Request["number"]);



           if (a 5)

           {

               a++;

           }

            ViewBag.ccc = a.ToString();

            return View("Indexb");

        }