多表的修改

开发工具与关键技术：VS、ASP.NET

作者：#33

撰写时间：撰写时间：2019年07月07日

接上一个文献的多表新增，这里就是多表修改，false为修改弹出层，并且Title修改为：编辑仓库。查询数据，get方式获取查询数据（也就是通过仓库ID查询的数据），弹出层的数据回填。

//---------修改仓库模态窗体--传递ID--------- function updateWarehouse(WarehouseID) {       BLWarehouseInfor = false;       $("#formWarehouse input[type='reset']").click();//获取from表单的ID-重置表单       $.get("SelectWarehouseID?WarehouseID=" + WarehouseID, function (data) {           $("#WarehouseID").val(WarehouseID);           $("#WarehouseName").val(data.WarehouseName);           $("#WarehouseNum").val(data.WarehouseNum);           $("#WarehouseDefaultStatus").val(data.WarehouseDefaultStatus);           $("#Remark").val(data.Remark);           $("#SendOutGoodsID").val(SendOutGoodsID);           $("#Contacts").val(data.Contacts);           $("#ContactPhone").val(data.ContactPhone);           $("#ContactAddress").val(data.ContactAddress);           $("#ZipCode").val(data.ZipCode);           $("#Mailbox").val(data.Mailbox); }); layerIndex = layer.open({type: 1,//页面层area: ["750px", "490px"],offset: "10px",//默认坐标，即垂直水平居中title: "编辑仓库",content: $("#modalWarehouse")});}

通过仓库ID查询出仓库信息： public ActionResult SelectWarehouseID(int WarehouseID) {    try{var listWarehouseInfor = (from tbWarehouse in myModel.S_Warehouse                                  where tbWarehouse.WarehouseID == WarehouseID                                  join tbSendOutGoods in myModel.D_SendOutGoods on tbWarehouse.SendOutGoodsID equals tbSendOutGoods.SendOutGoodsID                                  select new {  tbWarehouse.WarehouseID, tbWarehouse.WarehouseName, tbWarehouse.WarehouseNum,  tbWarehouse.WarehouseState, tbWarehouse.WarehouseDefaultStatus, tbWarehouse.Remark,  tbSendOutGoods.SendOutGoodsID, tbSendOutGoods.Contacts, tbSendOutGoods.ContactPhone,  tbSendOutGoods.ContactAddress, tbSendOutGoods.ZipCode, tbSendOutGoods.Mailbox,                                   }).Single();  return Json(listWarehouseInfor, JsonRequestBehavior.AllowGet); } catch (Exception e) { Console.WriteLine(e); return Json(null, JsonRequestBehavior.AllowGet); }}

修改的时，判断是否重复添加仓库，通过仓库表创建新的对象和发货表新的对象接收数据，获取修改的数据后更新到数据库。

public ActionResult UpdateWarehouseInfor(S_Warehouse UmodWarehouse, D_SendOutGoods UmodSendOutGoods) {    ReturnJson msg = new ReturnJson();     if (!string.IsNullOrEmpty(UmodWarehouse.WarehouseName)) {    try { var oldCount = (from tbWarehouse in myModel.S_Warehouse                         where tbWarehouse.WarehouseID != UmodWarehouse.WarehouseID&& tbWarehouse.WarehouseName == UmodWarehouse.WarehouseName.Trim()                         select tbWarehouse).Count(); if (oldCount == 0) { var listSendOutGoods = (from tbSendOutGoods in myModel.D_SendOutGoods where tbSendOutGoods.SendOutGoodsID != UmodSendOutGoods.SendOutGoodsID&& tbSendOutGoods.Contacts == UmodSendOutGoods.Contacts.Trim() select tbSendOutGoods).Single();       UmodWarehouse.SendOutGoodsID = listSendOutGoods.SendOutGoodsID;       myModel.Entry(UmodWarehouse).State = System.Data.Entity.EntityState.Modified;    if (myModel.SaveChanges()>0) {      myModel.Entry(UmodSendOutGoods).State = System.Data.Entity.EntityState.Modified;       msg.State = true;       msg.Text = "保存成功！";     }else { msg.Text = "保存失败！"; }    }else{msg.Text = "仓库已经存在！"; }   }catch (Exception e) {  Console.WriteLine(e);  msg.Text = "数据异常！";}  } else{  msg.Text = "请填写完整！"; } return Json(msg, JsonRequestBehavior.AllowGet);}