public ActionResult UpdateProject(SYS_RepairItem RepairItem) { var strMsg = "failed"; try { //判断修改后的数据是否与数据库数据重复 var oldProjectRow = (from tbProject in myModels.SYS_RepairItem where tbProject.RepairItemID != RepairItem.RepairItemID && (tbProject.RepairItemName == RepairItem.RepairItemName || tbProject.RepairItemNum == tbProject.RepairItemNum) select tbProject).Count(); if (RepairItem.MaintenanceID != 0) { if (RepairItem.RepairClassID != 0) { if (RepairItem.RepairItemNum != null) { if (RepairItem.RepairItemName != null) { myModels.Entry(RepairItem).State = System.Data.Entity.EntityState.Modified; //保存数据库 myModels.SaveChanges(); strMsg = "success"; } else { strMsg = "项目名称不能为空,请输入完整信息"; } } else { strMsg = "项目编号不能为空,请输入完整信息"; } } else { strMsg = "修理大类不能为空,请输入完整信息"; } } else { strMsg = "维修工艺不能为空,请输入完整信息"; } } catch (Exception) { strMsg = "failed"; } return(Json(strMsg, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 新增 /// </summary> /// <param name="Sales"></param> /// <returns></returns> public ActionResult InsertProject(SYS_RepairItem RepairItem) { string strMsg = "failed"; try { //判断销售客户表中是否已经存在新增的销售客户信息 var ProjectCount = (from tbProject in myModels.SYS_RepairItem where tbProject.RepairItemID == RepairItem.RepairItemID || tbProject.RepairItemNum == RepairItem.RepairItemNum select tbProject).Count(); if (RepairItem.MaintenanceID != 0) { if (RepairItem.RepairClassID != 0) { if (RepairItem.RepairItemNum != null) { if (RepairItem.RepairItemName != null) { myModels.SYS_RepairItem.Add(RepairItem); myModels.SaveChanges(); strMsg = "success"; } else { strMsg = "项目名称不能为空,请输入完整信息"; } } else { strMsg = "项目编号不能为空,请输入完整信息"; } } else { strMsg = "修理大类不能为空,请输入完整信息"; } } else { strMsg = "维修工艺不能为空,请输入完整信息"; } } catch (Exception e) { strMsg = "failed"; } return(Json(strMsg, JsonRequestBehavior.AllowGet)); }