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