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