public string forumAreaUpdate(postArea area)
{
try
{
if (toolsHelpers.updateToolsController.updatePostArea(u => u.areaId == area.areaId, area) == true)
{
Response.Redirect("/backStage/forumManagement/forumAreaIndex");
return("success");
}
return("修改失败");
}
catch
{
return("修改出错！");
}
}
/// <summary>
/// 论坛分区表增加数据
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public static Boolean insertPostArea(postArea info)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
db.postArea.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 postArea[] selectPostArea <TKey>(Expression <Func <postArea, bool> > whereLambda, Expression <Func <postArea, TKey> > orderBy)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
DbQuery <postArea> dataObject = db.postArea.Where(whereLambda).OrderBy(orderBy) as DbQuery <postArea>;
postArea[] infoList = dataObject.ToArray();
return(infoList);
}
}
catch
{
postArea[] nullInfo = new postArea[0];
return(nullInfo);
}
}
public string forumAreaDelete(postArea area)
{
try
{
//删除论坛回复表中的信息，论坛表中的信息和论坛分区表中的信息
if (toolsHelpers.deleteToolsController.deleteAllPostAreaInfo(area.areaId) == true)
{
Response.Redirect("/backStage/forumManagement/forumAreaIndex");
return("true");
}
return("false");
}
catch
{
return("论坛分区删除出错！");
}
}
public ActionResult changeforumArea(int areaId)
{
try
{
postArea[] areaInfoList = toolsHelpers.selectToolsController.selectPostArea(u => u.areaId == areaId, u => u.areaId);
if (areaInfoList.Length == 0 || areaInfoList == null)
{
return(Content("没有这个分区！"));
}
postArea areaInfo = areaInfoList[0];
ViewBag.areaInfo = areaInfo;
return(View());
}
catch
{
return(Content("加载出错！"));
}
}
/// <summary>
/// 修改论坛分区表中的数据
/// </summary>
/// <param name="whereLambda"></param>
/// <param name="info"></param>
/// <returns></returns>
public static Boolean updatePostArea(Expression <Func <postArea, bool> > whereLambda, postArea info)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
DbQuery <postArea> dataObject = db.postArea.Where(whereLambda) as DbQuery <postArea>;
postArea oldInfo = dataObject.FirstOrDefault();
oldInfo.areaBrief = info.areaBrief;
oldInfo.areaName = info.areaName;
db.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public string forumAreaAdd(postArea area)
{
try
{
//检查是否存在相同的分区名
if (toolsHelpers.selectToolsController.selectPostArea(u => u.areaName == area.areaName, u => u.areaId).Length != 0)
{
return("存在相同的论坛分区名");
}
if (toolsHelpers.insertToolsController.insertPostArea(area) == true)
{
Response.Redirect("/backStage/forumManagement/forumAreaIndex");
return("success");
}
return("增加论坛分区失败");
}
catch
{
return("增加论坛分区出错");
}
}
