/// <summary>
/// 添加
/// </summary>
public int Add(E_Comment model)
{
string sql = @"INSERT INTO [comment].[dbo].[dp_comment]([userid],[areaid],[classinfoid],[sex],[ageround],[domain],[job],[contents],[addtime])
VALUES(@userid,@areaid,@classinfoid,@sex,@ageround,@domain,@job,@contents,@addtime);SELECT @@IDENTITY;";
using (IDbConnection conn = new SqlConnection(DapperHelper.GetConStr()))
{
return(Convert.ToInt32(conn.ExecuteScalar(sql, model)));
}
}
public ActionResult CommentContent(E_Comment eComment)
{
E_User eUser = HttpContext.Session["user"] as E_User;
ViewBag.userinfo = eUser;
ViewBag.listCommentType = dCommentType.GetListByThemeid(new E_CommentType()
{
themeid = eComment.themeid
});
ViewBag.listCommentItem = dCommentItem.GetCommentItemByThemeID(eComment.themeid);
ViewBag.listopinion = dOpinion.GetList(new E_Opinion()
{
themeid = eComment.themeid
});
ViewBag.CommentInfo = eComment;
return(View("~/views/App/CommentContent.cshtml"));
}
public JsonResult SaveCommentContent(E_Comment eComment)
{
string msg = "提交失败！";
bool result = false;
eComment.addtime = DateTime.Now;
eComment.commentid = dComment.Add(eComment);
if (eComment.commentid > 0)
{
foreach (var item in eComment.commentcommentitem)
{
item.commentid = eComment.commentid;
dCommentCommentItem.Add(item);
}
foreach (var item in eComment.commentopinion)
{
item.commentid = eComment.commentid;
dCommentOpinion.Add(item);
}
msg = "提交成功！";
result = true;
}
return(Json(new { result = result, msg = msg }, JsonRequestBehavior.AllowGet));
}