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