单表的数据修改

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

开发工具与关键技术：Adobe Dreamweaver JavaScript

作者：周乐献

撰写时间：2020年8月8日

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 

//打开修改模态框

  点击修改按钮,弹出修改模态框,获取到点击行的学院ID,

通过获取到学院ID到控制器查询该学院ID所对应的数据,然后把查询到的数据直接回填到所对应的输入框

 

        function modificationFaculty(facultyID) {

            condition = false;

            $("#modification").modal('show');

            $("#formModification input[type='reset']").click();

 

            $.post("@Url.Content("~/college/modificationSelect")", { facultyID: facultyID }, function (jsonData) {

                if (jsonData != null) {

                    $("#facultyID").val(jsonData.facultyID);

                    $("#ModFacultyName").val(jsonData.facultyName);

                    $("#ModFacultySite").val(jsonData.facultySite);

                    $("#ModFacultyCode").val(jsonData.facultyCode);

                } else {

                    layer.alert("参数异常");

                }

            })

        };

 

根据页面传递过来的ID查询所对应的信息

public ActionResult modificationSelect(int facultyID)

        {

            try

            {

                S_Academy dbAcademy = (from tbAcademy in myModel.S_Academy

                                       where tbAcademy.facultyID == facultyID

                                       select tbAcademy).Single();

                return Json(dbAcademy, JsonRequestBehavior.AllowGet);

            }

            catch (Exception e)

            {

                Console.WriteLine(e);

                return Content("数据异常");

            }

           

        }

然后根据自己需求对输入框内容进行修改

在输入框内内容修改后点击确认按钮提交到控制器

public ActionResult modificationFaculty(S_Academy dbAcademy)

        {

            ReturnJson msg = new ReturnJson();

            try

            {

                if (!string.IsNullOrEmpty(dbAcademy.facultyName))

                {

                    if (!string.IsNullOrEmpty(dbAcademy.facultySite))

                    {

                        if (!string.IsNullOrEmpty(dbAcademy.facultyCode) || Regex.IsMatch(dbAcademy.facultyCode, "^[0-9]{2}$"))

                        {

                           int facultyCodeCount = (from tbAcademy in myModel.S_Academy

                                                    where (tbAcademy.facultyCode ==

dbAcademy.facultyCode || tbAcademy.facultyName == dbAcademy.facultyName) && tbAcademy.facultyID != dbAcademy.facultyID  //判断不和当前修改的学院信息进行查询重复操作

                          if (facultyCodeCount == 0)

                            {

                                myModel.Entry(dbAcademy).State = System.Data.Entity.EntityState.Modified;

                                if (myModel.SaveChanges() > 0)

                                {

                                    msg.State = true;

                                    msg.Text = "修改成功";

                                }

                                else

                                {

                                    msg.Text = "修改失败";

                                }

                            }

                            else

                            {

                                msg.Text = "该学院名称或者学院编号已经存在,不能添加";

                            }

                        }

                        else

                        {

                            msg.Text = "学院编号由两位数字组成";

                        }

                    }

                    else

                    {

                        msg.Text = "学院地址不能为空";

                    }

                }

                else

                {

                    msg.Text = "学院名称不能为空";

                }

            }

            catch (Exception e)

            {

                Console.WriteLine(e);

                msg.Text = "数据异常";

            }

            return Json(msg, JsonRequestBehavior.AllowGet);

        }

然后把修改后的数据返回回页面