/// <summary> /// 新增 /// </summary> /// <returns></returns> public ActionResult InsertSupplierbasic(SYS_Suppliers Suppliers) { string strMsg = "failed"; try { var SuppliersCount = (from tbSuppliers in myModels.SYS_Suppliers where tbSuppliers.SuppliersID == Suppliers.SuppliersID || tbSuppliers.SuppliersName == Suppliers.SuppliersName select tbSuppliers).Count(); if (SuppliersCount == 0) { myModels.SYS_Suppliers.Add(Suppliers); myModels.SaveChanges(); strMsg = "success"; } else { strMsg = "该供应商名称已经存在,不需要重复输入数据!"; } } catch (Exception e) { strMsg = "failed"; } return(Json(strMsg, JsonRequestBehavior.AllowGet)); }
public ActionResult UpdateSupplierbasic(SYS_Suppliers Suppliers) { var strMsg = "failed"; try { //判断修改后的数据是否与数据库重复 var oldSuppliersRow = (from tbSuppliers in myModels.SYS_Suppliers where tbSuppliers.SuppliersID != Suppliers.SuppliersID && (tbSuppliers.SuppliersFirm == Suppliers.SuppliersFirm) select tbSuppliers).Count(); if (oldSuppliersRow == 0) { myModels.Entry(Suppliers).State = System.Data.Entity.EntityState.Modified; //保存数据库 myModels.SaveChanges(); strMsg = "success"; } else { strMsg = "该客户信息已经存在,不需要重复录入!"; } } catch (Exception) { strMsg = "failed"; } return(Json(strMsg, JsonRequestBehavior.AllowGet)); }
public ActionResult InsertSuppliers(SYS_Suppliers sys_Suppliers)//新增或修改供应商表 { int SuppliersID = sys_Suppliers.SuppliersID; try { if (SuppliersID == 0) { myModels.SYS_Suppliers.Add(sys_Suppliers); myModels.SaveChanges(); } else { myModels.Entry(sys_Suppliers).State = System.Data.Entity.EntityState.Modified; myModels.SaveChanges(); } } catch (Exception) { return(Json(false, JsonRequestBehavior.AllowGet)); } return(Json(true, JsonRequestBehavior.AllowGet)); }