/// <summary>
/// 删除
/// </summary>
/// <param name="FittingsType"></param>
/// <returns></returns>
public ActionResult UpdateFittingsType(SYS_FittingsType FittingsType)
{
var strMsg = "failed";
try
{
//判断配件大类表中是否已经存在新增的配件大类信息
var oldFittingsTypeRow = (from tbFittingsType in myModels.SYS_FittingsType
where tbFittingsType.FittingsTypeID != FittingsType.FittingsTypeID &&
(tbFittingsType.FittingsTypeNum == FittingsType.FittingsTypeNum)
// && tbFittingsType.FittingsTypeName == FittingsType.FittingsTypeName
select tbFittingsType).Count();
if (oldFittingsTypeRow == 0)
{
myModels.Entry(FittingsType).State = System.Data.Entity.EntityState.Modified;
//保存数据库
myModels.SaveChanges();
strMsg = "success";
}
else
{
strMsg = "该配件大类已经存在，不需要重复输入数据！";
}
}
catch (Exception)
{
strMsg = "failed";
}
return(Json(strMsg, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 新增
/// </summary>
/// <param name="FittingsType"></param>
/// <returns></returns>
public ActionResult InsertFittingsType(SYS_FittingsType FittingsType)
{
string strMsg = "failed";
try
{
//判断配件大类表中是否已经存在新增的配件大类信息
var SelectCount = (from tbFittingsType in myModels.SYS_FittingsType
where tbFittingsType.FittingsTypeID == FittingsType.FittingsTypeID ||
tbFittingsType.FittingsTypeNum == FittingsType.FittingsTypeNum &&
tbFittingsType.FittingsTypeName == FittingsType.FittingsTypeName
select tbFittingsType).Count();
if (SelectCount == 0)
{
myModels.SYS_FittingsType.Add(FittingsType);
myModels.SaveChanges();
strMsg = "success";
}
else
{
strMsg = "该配件大类已经存在，不需要重复输入数据！";
}
}
catch (Exception e)
{
strMsg = "failed";
}
return(Json(strMsg, JsonRequestBehavior.AllowGet));
}
