public ActionResult addAnswer(quesAnswReply info) { try { //先判断有无回复的userId if (toolsHelpers.selectToolsController.selectUserInfo(u => u.userId == info.userId, u => u.userId).Length == 0) { return(Content("回复者不存在,请重新输入回复者Id")); } //判断有误此postId if (toolsHelpers.selectToolsController.selectQuesAnswInfo(u => u.quesAnswId == info.quesAnswId, u => u.quesAnswId).Length == 0) { return(Content("此论坛不存在!")); } info.replyTime = DateTime.Now; info.isAgree = 0; //判断插入是否成功 if (toolsHelpers.insertToolsController.insertQuesAnswReply(info) == true) { return(Content("增加回答成功!")); } return(Content("增加回答失败!")); } catch { return(Content("增加回答出错!")); } }
/// <summary> /// 向问答回复表中插入信息 /// </summary> /// <param name="info"></param> /// <returns></returns> public static Boolean insertQuesAnswReply(quesAnswReply info) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { db.quesAnswReply.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 quesAnswReply[] selectQuesAnswReply <TKey>(Expression <Func <quesAnswReply, bool> > whereLambda, Expression <Func <quesAnswReply, TKey> > orderBy) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { DbQuery <quesAnswReply> dataObject = db.quesAnswReply.Where(whereLambda).OrderBy(orderBy) as DbQuery <quesAnswReply>; quesAnswReply[] infoList = dataObject.ToArray(); return(infoList); } } catch { quesAnswReply[] nullInfo = new quesAnswReply[0]; return(nullInfo); } }
public void QuestionReply(int quesId, string reply, int userId) { quesAnswReply qarInfo = new quesAnswReply { quesAnswId = quesId, userId = userId, replyTime = DateTime.Now, replyContent = reply, isAgree = 0 }; using (LazyfitnessEntities db = new LazyfitnessEntities()) { db.quesAnswReply.Add(qarInfo); db.SaveChanges(); Response.Redirect(Url.Action("QuestionDetail", "Home", new { num = quesId })); } }