public ActionResult updateArea(resourceArea area) { try { if (Request.Cookies["managerId"] != null) { //获取Cookies的值 HttpCookie cookieName = Request.Cookies["managerId"]; var cookieText = Server.HtmlEncode(cookieName.Value); } else { return(Content("未登录")); } //判断有无此分区 if (toolsHelpers.selectToolsController.selectResourceArea(u => u.areaId == area.areaId, u => u.areaId).Length == 0) { return(Content("没有此分区")); } //有分区的时候修改为当前值 if (toolsHelpers.updateToolsController.updateResourceArea(u => u.areaId == area.areaId, area) == true) { Response.Redirect("/backStage/articleManagement/areaManagement"); return(Content("success")); } return(Content("修改失败")); } catch { return(Content("修改出错")); } }
public string addArea(resourceArea area) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { //先检查分区名存不存在 resourceArea[] isExistArea = toolsHelpers.selectToolsController.selectResourceArea(u => u.areaName == area.areaName, u => u.areaId); if (isExistArea.Length != 0) { return("存在相同的名字"); } resourceArea obResourceArea = new resourceArea { areaName = area.areaName.Trim(), areaBrief = area.areaBrief.Trim(), }; if (toolsHelpers.insertToolsController.insertResourceArea(obResourceArea) == true) { Response.Redirect("/backStage/articleManagement/areaManagement"); return("success"); } return("增加分区失败"); } } catch { return("增加分区出错"); } }
/// <summary> /// 往文章分区表插入数据 /// </summary> /// <param name="info"></param> /// <returns></returns> public static Boolean insertResourceArea(resourceArea info) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { db.resourceArea.Add(info); db.SaveChanges(); return(true); } } catch { return(false); } }
/// <summary> /// 查找文章分区表中的数据 /// </summary> /// <typeparam name="TKey"></typeparam> /// <param name="whereLambda"></param> /// <param name="orderBy"></param> /// <returns></returns> public static resourceArea[] selectResourceArea <TKey>(Expression <Func <resourceArea, bool> > whereLambda, Expression <Func <resourceArea, TKey> > orderBy) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { DbQuery <resourceArea> dataObject = db.resourceArea.Where(whereLambda).OrderBy(orderBy) as DbQuery <resourceArea>; resourceArea[] infoList = dataObject.ToArray(); return(infoList); } } catch { resourceArea[] nullInfo = new resourceArea[0]; return(nullInfo); } }
/// <summary> /// 往文章分区表修改数据 /// </summary> /// <param name="whereLambda"></param> /// <param name="info"></param> /// <returns></returns> public static Boolean updateResourceArea(Expression <Func <resourceArea, bool> > whereLambda, resourceArea info) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { DbQuery <resourceArea> dataObject = db.resourceArea.Where(whereLambda) as DbQuery <resourceArea>; resourceArea oldInfo = dataObject.FirstOrDefault(); oldInfo.areaName = info.areaName; oldInfo.areaBrief = info.areaBrief; db.SaveChanges(); return(true); } } catch { return(false); } }