ASP.NET MVC之增删查改绑定下拉框

开发工具与关键技术：VS  MVC

作者：陈芝番

撰写时间：2019.4.15

查询：

public ActionResult SelectById(int Id)

        {

            try

            {

 SYS_  sys = (from tb in myModel.SYS_              

 where tb. ID == Id                                        

select tb).Single();

                return Json(sys, JsonRequestBehavior.AllowGet);

            }

            catch (Exception e)

            {

                Console.WriteLine(e);

                return Json("", JsonRequestBehavior.AllowGet);

            }

        }

新增：

public ActionResult Insert (SYS_  sys)

        {

            ReturnJson returnJson = new ReturnJson();           

            try

            {

                    if (oldCount == 0)

                    {

                      myModel.SYS_.Add(sys);

                        if (myModel.SaveChanges() > 0)

                        {

                            returnJson.State = true;

                            returnJson.Text = "";

                        }

                        else

                        {

                            returnJson.State = false;

                            returnJson.Text = "";

                        }

                    }

            catch (Exception e)

            {

                Console.WriteLine(e);

                returnJson.State = false;

                returnJson.Text = "";

            }

            return Json(returnJson, JsonRequestBehavior.AllowGet);

        }

 修改：

public ActionResult Update (SYS_ sys)

        {

            ReturnJson returnJson = new ReturnJson();

            try

            {

                    if (myModel.SaveChanges() > 0)

                    {

                        returnJson.State = true;

                        returnJson.Text = "";

                    }

                    else

                    {

                        returnJson.State = false;

                        returnJson.Text = "";

                    }

            catch (Exception e)

            {

                Console.WriteLine(e);

                returnJson.State = false;

                returnJson.Text = "数据异常！";

            }

            return Json(returnJson, JsonRequestBehavior.AllowGet);

        }

删除：       

public ActionResult Delete (int  Id)

        {

            ReturnJson returnJson = new ReturnJson();

            try

            {

                int intRow = (from tb in myModel.SYS_

                                   where tb.ID == Id

                                   select tb).Count();

                if (intRow > 0)

                {

                    returnJson.State = false;

                    returnJson.Text = "";

                    return Json(returnJson, JsonRequestBehavior.AllowGet);

                }                   

绑定下拉框：

public ActionResult Select(int ID)

         {



            List<Select> list= (from tb in myModels.SYS_

                                      where tb.ID == ID

                                      select new Select

                                      {

                                          id = tb.ID,

                                          text = tb.Name

                                      }).ToList();

            return Json(list, JsonRequestBehavior.AllowGet);

        }

结语：对于下拉框绑定基本上已全部囊括进去,万变不离其宗。