/// <summary>
/// 问答分区表增加数据
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public static Boolean insertQuesArea(quesArea info)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
db.quesArea.Add(info);
db.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public string quesAnswAreaUpdate(quesArea area)
{
try
{
if (toolsHelpers.updateToolsController.updateQuesArea(u => u.areaId == area.areaId, area) == true)
{
Response.Redirect("/backStage/quesAnswManagement/quesAnswAreaIndex");
return("success");
}
return("修改失败");
}
catch
{
return("修改出错！");
}
}
public string quesAnswAreaDelete(quesArea area)
{
try
{
//删除问答回复表中的信息，问答表中的信息和问答分区表中的信息
if (toolsHelpers.deleteToolsController.deleteAllQuesAreaInfo(area.areaId) == true)
{
Response.Redirect("/backStage/quesAnswManagement/quesAnswAreaIndex");
return("true");
}
return("false");
}
catch
{
return("问答分区删除出错！");
}
}
/// <summary>
/// 查找问答分区表中的数据
/// </summary>
/// <typeparam name="TKey"></typeparam>
/// <param name="whereLambda"></param>
/// <param name="orderBy"></param>
/// <returns></returns>
public static quesArea[] selectQuesArea <TKey>(Expression <Func <quesArea, bool> > whereLambda, Expression <Func <quesArea, TKey> > orderBy)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
DbQuery <quesArea> dataObject = db.quesArea.Where(whereLambda).OrderBy(orderBy) as DbQuery <quesArea>;
quesArea[] infoList = dataObject.ToArray();
return(infoList);
}
}
catch
{
quesArea[] nullInfo = new quesArea[0];
return(nullInfo);
}
}
public ActionResult changeQuesAnswArea(int areaId)
{
try
{
quesArea[] areaInfoList = toolsHelpers.selectToolsController.selectQuesArea(u => u.areaId == areaId, u => u.areaId);
if (areaInfoList.Length == 0 || areaInfoList == null)
{
return(Content("没有这个分区！"));
}
quesArea 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 updateQuesArea(Expression <Func <quesArea, bool> > whereLambda, quesArea info)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
DbQuery <quesArea> dataObject = db.quesArea.Where(whereLambda) as DbQuery <quesArea>;
quesArea oldInfo = dataObject.FirstOrDefault();
oldInfo.areaBrief = info.areaBrief;
oldInfo.areaName = info.areaName;
db.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public string quesAnswAreaAdd(quesArea area)
{
try
{
//检查是否存在相同的分区名
if (toolsHelpers.selectToolsController.selectQuesArea(u => u.areaName == area.areaName, u => u.areaId).Length != 0)
{
return("存在相同的问答分区名");
}
if (toolsHelpers.insertToolsController.insertQuesArea(area) == true)
{
Response.Redirect("/backStage/quesAnswManagement/quesAnswAreaIndex");
return("success");
}
return("增加问答分区失败");
}
catch
{
return("增加问答分区出错");
}
}
