/// <summary>
/// 新增
/// </summary>
/// <param name="Maintenance"></param>
/// <returns></returns>
public ActionResult InsertMaintenance(SYS_MaintenanceCus MaintenanceCus)
{
string strMsg = "failed";
try
{
//判断维修客户表中是否已经存在新增的维修客户信息
var SelectCount = (from tbMaintenanceCus in myModels.SYS_MaintenanceCus
where tbMaintenanceCus.MaintenanceCusID == MaintenanceCus.MaintenanceCusID ||
tbMaintenanceCus.IdNumber == MaintenanceCus.IdNumber
select tbMaintenanceCus).Count();
if (SelectCount == 0)
{
myModels.SYS_MaintenanceCus.Add(MaintenanceCus);
myModels.SaveChanges();
strMsg = "success";
}
else
{
strMsg = "该维修客户信息已经存在，不需要重复输入数据！";
}
}
catch (Exception e)
{
strMsg = "failed";
}
return(Json(strMsg, JsonRequestBehavior.AllowGet));
}
public ActionResult UpdateMaintenance(SYS_MaintenanceCus Maintenance)
{
var strMsg = "failed";
try
{
//判断修改后的数据是否与数据库重复
var oldMaintenanceCusRow = (from tbMaintenance in myModels.SYS_MaintenanceCus
where tbMaintenance.MaintenanceCusID != Maintenance.MaintenanceCusID &&
(tbMaintenance.IdNumber == Maintenance.IdNumber)
select tbMaintenance).Count();
if (oldMaintenanceCusRow == 0)
{
myModels.Entry(Maintenance).State = System.Data.Entity.EntityState.Modified;
//保存数据库
myModels.SaveChanges();
strMsg = "success";
}
else
{
strMsg = "该客户信息已经存在，不需要重复录入！";
}
}
catch (Exception)
{
strMsg = "failed";
}
return(Json(strMsg, JsonRequestBehavior.AllowGet));
}
public ActionResult InsertMaintenanceCus(SYS_MaintenanceCus sys_MaintenanceCus)//新增或修改维修客户表
{
int MaintenanceCusID = sys_MaintenanceCus.MaintenanceCusID;
try
{
if (MaintenanceCusID == 0)
{
myModels.SYS_MaintenanceCus.Add(sys_MaintenanceCus);
myModels.SaveChanges();
}
else
{
myModels.Entry(sys_MaintenanceCus).State = System.Data.Entity.EntityState.Modified;
myModels.SaveChanges();
}
}
catch (Exception)
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
return(Json(true, JsonRequestBehavior.AllowGet));
}
