单表的数据修改
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
开发工具与关键技术: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);
}
然后把修改后的数据返回回页面