public ActionResult quesAnswInvitationUpdate(quesAnswInfo info)
{
try
{
//读取数据
quesAnswInfo[] infoList = toolsHelpers.selectToolsController.selectQuesAnswInfo(u => u.quesAnswId == info.quesAnswId, u => u.quesAnswId);
if (infoList == null || infoList.Length == 0)
{
return(Content("没有此问答帖子！"));
}
//获取分区列表
quesArea[] areaList = toolsHelpers.selectToolsController.selectQuesArea(x => x == x, u => u.areaId);
if (areaList == null || areaList.Length == 0)
{
return(Content("没有分区，请至少添加一个分区！"));
}
ViewBag.quesArea = areaList;
ViewBag.allInfo = infoList[0];
return(View());
}
catch
{
return(Content("查询问答帖子出错！"));
}
}
public ActionResult changeQuesAnswInfo(quesAnswInfo info)
{
try
{
if (toolsHelpers.updateToolsController.updateQuesAnswInfo(u => u.quesAnswId == info.quesAnswId, info) == true)
{
Response.Redirect("/backStage/quesAnswManagement/quesAnswInvitationIndex");
return(Content("success"));
}
return(Content("修改问答帖子失败！"));
}
catch
{
return(Content("修改问答帖子出错！"));
}
}
/// <summary>
/// 问答表增加数据
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public static Boolean insertQuesAnswInfo(quesAnswInfo info)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
db.quesAnswInfo.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 quesAnswInfo[] selectQuesAnswInfo <TKey>(Expression <Func <quesAnswInfo, bool> > whereLambda, Expression <Func <quesAnswInfo, TKey> > orderBy)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
DbQuery <quesAnswInfo> dataObject = db.quesAnswInfo.Where(whereLambda).OrderBy(orderBy) as DbQuery <quesAnswInfo>;
quesAnswInfo[] infoList = dataObject.ToArray();
return(infoList);
}
}
catch
{
quesAnswInfo[] nullInfo = new quesAnswInfo[0];
return(nullInfo);
}
}
/// <summary>
/// 将所保存的记录保存在数据库并清除现有记录
/// </summary>
/// <returns></returns>
public bool SaveToDB()
{
rwl.EnterWriteLock();
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
foreach (PageViewRecord record in records)
{
switch (record.RegionId)
{
case 0:
resourceInfo rinfo = db.resourceInfo.Where(article => article.resourceId == record.Id).FirstOrDefault();
if (rinfo == null)
{
break;
}
rinfo.pageView += record.PageView;
break;
case 1:
quesAnswInfo qinfo = db.quesAnswInfo.Where(ques => ques.quesAnswId == record.Id).FirstOrDefault();
if (qinfo == null)
{
break;
}
qinfo.pageView += record.PageView;
break;
case 2:
postInfo pinfo = db.postInfo.Where(post => post.postId == record.Id).FirstOrDefault();
if (pinfo == null)
{
break;
}
pinfo.pageView += record.PageView;
break;
default: break;
}
}
db.SaveChanges();
records.Clear();
rwl.ExitWriteLock();
}
return(true);
}
public void QuestionSubmit(int areaId, int userId, string title, string editor, int money)
{
userInfo info = Tools.GetUserInfo(userId);
if (info.userAccount == null)
{
info.userAccount = 0;
}
if (info.userAccount < money)
{
money = (int)info.userAccount;
}
else
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
DbQuery <userInfo> dbsearch = db.userInfo.Where(u => u.userId == userId) as DbQuery <userInfo>;
userInfo _userinfo = dbsearch.FirstOrDefault();
_userinfo.userAccount -= money;
db.SaveChanges();
}
}
quesAnswInfo qaInfo = new quesAnswInfo
{
areaId = areaId,
quesAnswTitle = title,
userId = userId,
quesAnswTime = DateTime.Now,
pageView = 0,
isPost = 0,
quesAnswStatus = 1,
amount = money,
quesAnswContent = editor
};
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
db.quesAnswInfo.Add(qaInfo);
db.SaveChanges();
Response.Redirect(Url.Action("QuestionPart", "Home", new { partId = areaId }));
}
}
public string quesAnswInvitationDelete(quesAnswInfo info)
{
try
{
//判断postId是否存在
if (toolsHelpers.selectToolsController.selectQuesAnswInfo(u => u.quesAnswId == info.quesAnswId, u => u.quesAnswId).Length == 0)
{
return("此问答帖子不存在！");
}
if (toolsHelpers.deleteToolsController.deleteAllQuesAnswInfo(info.quesAnswId) == true)
{
Response.Redirect("/backStage/quesAnswManagement/quesAnswInvitationIndex");
return("succes");
}
return("删除失败！");
}
catch
{
return("论坛帖子删除出错！");
}
}
public string quesAnswInvitationAdd(quesAnswInfo info)
{
try
{
if (toolsHelpers.selectToolsController.selectUserInfo(u => u.userId == info.userId, u => u.userId).Length == 0)
{
return("没有此用户，不能增加论坛帖子");
}
info.quesAnswTime = DateTime.Now;
info.pageView = 0;
if (toolsHelpers.insertToolsController.insertQuesAnswInfo(info) == true)
{
Response.Redirect("/backStage/quesAnswManagement/quesAnswInvitationIndex");
return("success");
}
return("false");
}
catch
{
return("论坛帖子增加出错！");
}
}
/// <summary>
/// 问答详细页
/// </summary>
/// <param name="num">问答贴id</param>
/// <returns></returns>
public ActionResult QuestionDetail(int num = 1)
{
//增加浏览量
if (HttpContext.Application["PageViewHelper"] is PageViewHelper helper)
{
helper.PageViewAdd(1, num, 1);
}
ViewBag.QuestionId = num;
ViewBag.IsSolved = false;
quesAnswInfo info = Tools.GetQuestionInfo(num);
ViewBag.QuesInfo = info;
ViewBag.QuesUserInfo = Tools.GetUserInfo((int)info.userId);
quesAnswReply[] replys = Tools.GetQuestionReply(num);
ViewBag.QuestionReplys = replys;
userInfo[] replyerInfo = new userInfo[replys.Length];
for (int count = 0; count < replys.Length; count++)
{
replyerInfo[count] = Tools.GetUserInfo((int)replys[count].userId);
}
ViewBag.ReplyerInfo = replyerInfo;
return(View());
}
public ActionResult sureAnswer(int quesAnswId)
{
try
{
//有此帖子时候返回帖子所属分区名，帖子的作者，帖子的信息
//先返回帖子信息
quesAnswInfo[] infoList = toolsHelpers.selectToolsController.selectQuesAnswInfo(u => u.quesAnswId == quesAnswId, u => u.quesAnswId);
//查看有无此贴
if (infoList == null || infoList.Length == 0)
{
return(Content("没有这篇问答帖子"));
}
//得到分区名
int areaId = infoList[0].areaId;
quesArea[] areaList = toolsHelpers.selectToolsController.selectQuesArea(u => u.areaId == areaId, u => u.areaId);
//得到帖子作者
int userId = infoList[0].userId.Value;
userInfo[] userList = toolsHelpers.selectToolsController.selectUserInfo(u => u.userId == userId, u => u.userId);
if (areaList == null || userList == null || areaList.Length == 0 || userList.Length == 0)
{
return(Content("此片问答帖子存在错误信息不可读，请及时删除此问答帖子"));
}
quesAnswInfo quesAnswInfo = infoList[0];
string areaName = areaList[0].areaName;
string ownerName = userList[0].userName;
ViewBag.areaName = areaName;
ViewBag.ownerName = ownerName;
ViewBag.quesAnswInfo = quesAnswInfo;
return(View());
}
catch
{
return(Content("获取问答帖子信息出错！"));
}
}
/// <summary>
/// 修改问答帖子表中的数据
/// </summary>
/// <param name="whereLambda"></param>
/// <param name="info"></param>
/// <returns></returns>
public static Boolean updateQuesAnswInfo(Expression <Func <quesAnswInfo, bool> > whereLambda, quesAnswInfo info)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
DbQuery <quesAnswInfo> dataObject = db.quesAnswInfo.Where(whereLambda) as DbQuery <quesAnswInfo>;
quesAnswInfo oldInfo = dataObject.FirstOrDefault();
oldInfo.areaId = info.areaId;
oldInfo.quesAnswTitle = info.quesAnswTitle;
oldInfo.pageView = info.pageView;
oldInfo.isPost = info.isPost;
oldInfo.amount = info.amount;
oldInfo.quesAnswStatus = info.quesAnswStatus;
oldInfo.quesAnswContent = info.quesAnswContent;
db.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
