/// <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));
}
