数据修改的先去查询数据:
public ActionResult SelectSpecialtyByID(int SpecialtyID)
{
var specialty = (from tbSpecialty in myModel.SYS_Specialty
where tbSpecialty.SpecialtyID == SpecialtyID
select new
{
tbSpecialty.SpecialtyID,
tbSpecialty.SpecialtyName,
tbSpecialty.SpecialtyCode
}).Single();
return Json(specialty, JsonRequestBehavior.AllowGet);
}
在视图里定义修改的方法:
function openUpdate(SpecialtyID){
blInsert=false;
$("#formSpecialty input[type=‘reset’]").click();
$("#modalSpecialty .modal-header h6").text(“修改数据信息”);
$("#modalSpecialty").modal();
$.getJSON(“SelectSpecialtyByID?SpecialtyID=”+SpecialtyID,function(data){
$("#SpecialtyID").val(data.SpecialtyID);
$("#SpecialtyName").val(data.SpecialtyName);
KaTeX parse error: Expected 'EOF', got '#' at position 3: ("#̲SpecialtyCode")…("#formSpecialty input[type=‘reset’]").click();”为重置表单
下面的一句是显示模态窗体的标题文字
再下一句就是弹出模态窗体
最后就是数据回填了,就是把要修改的数据回填到模态窗体中:
function savaInfor(){
var SpecialtyName=KaTeX parse error: Expected 'EOF', got '#' at position 3: ("#̲SpecialtyName")…("#SpecialtyCode").val();
if (SpecialtyName!=""&&SpecialtyCode!="") {
var SpecialtyID=$("#SpecialtyID").val();
$.post(“UpdateSpecialty”,
{AcademeID:AcademeID,
SpecialtyName:SpecialtyName,
SpecialtyCode:SpecialtyCode,
SpecialtyID:SpecialtyID},
function(msg){
KaTeX parse error: Expected 'EOF', got '#' at position 3: ("#̲modalSpecialty"…("#modalSpecialty").modal(“hide”);” 是关闭模态窗体
最后在控制器中定义修改数据方法:
public ActionResult UpdateSpecialty(int AcademeID, string SpecialtyName, string SpecialtyCode, int SpecialtyID)
{
SYS_Specialty modalSpecialty = new SYS_Specialty();
ReturnJson msg = new ReturnJson();
msg.State = false;
if (AcademeID != 0 && !string.IsNullOrEmpty(SpecialtyName) && !string.IsNullOrEmpty(SpecialtyCode) && SpecialtyID != 0)
{
modalSpecialty.AcademeID = AcademeID;
modalSpecialty.SpecialtyName = SpecialtyName;
modalSpecialty.SpecialtyCode = SpecialtyCode;
modalSpecialty.SpecialtyID = SpecialtyID;
myModel.Entry(modalSpecialty).State = System.Data.Entity.EntityState.Modified;
if (myModel.SaveChanges() > 0)
{
msg.State = true;
msg.Text = “数据修改成功!”;
}
else
{
msg.Text = “数据修改失败!”;
}
}
else
{
msg.Text = “数据名称或代码为空,请检查数据!”;
}
return Json(msg, JsonRequestBehavior.AllowGet);
}
第一if语句判断传送过来的数据是否为空或者等于0的,如果是的话就弹出提示框来提示你,不为空的话就执行下面的代码,第一与第二if语句之间的代码是修改的操作 。