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