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