/// <summary> /// 编辑保存 /// </summary> /// <param name="ModuleTable"></param> /// <returns></returns> public ActionResult Updatabianji(B_ModuleTable ModuleTable) { //定义返回 string strMsg = "fail"; //查询除了自身外查询是否已经存在 int oldCount = (from tbModuleTable in myDYXTEntities.B_ModuleTable where tbModuleTable.ModuleID != ModuleTable.ModuleID && tbModuleTable.Name.Trim() == ModuleTable.Name.Trim() select tbModuleTable).Count(); if (oldCount == 0) { try { ModuleTable.UpdateTime = DateTime.Now; //修改公告类型 myDYXTEntities.Entry(ModuleTable).State = System.Data.Entity.EntityState.Modified; if (myDYXTEntities.SaveChanges() > 0) { strMsg = "success"; } } catch (Exception e) { Console.WriteLine(e); } } else { strMsg = "exist";//已经存在 } return(Json(strMsg, JsonRequestBehavior.AllowGet)); }
public ActionResult DeleteModule(int ModuleID) { string strMsg = "fail"; try { B_ModuleTable varFundCost = (from tModuleTable in myDYXTEntities.B_ModuleTable where tModuleTable.ModuleID == ModuleID select tModuleTable).Single(); //删除数据 myDYXTEntities.B_ModuleTable.Remove(varFundCost); myDYXTEntities.SaveChanges(); strMsg = "success"; } catch (Exception e) { } return(Json(strMsg, JsonRequestBehavior.AllowGet)); }