public ActionResult AddTravelFeedComment(ETravelComment comment) { comment.CommentUserId = Passport.User.Id; var newComment = _travelService.AddTravelFeedComment(comment); return JsonResult(newComment, "发表成功"); }
public ETravelComment AddTravelFeedComment(ETravelComment comment) { comment.CommentTime = DateTime.Now; _rep.Add(comment); var sb = new StringBuilder(); sb.Append("select c.*,"); sb.Append("u0.NickName as ExtCommentTargetNickName,u0.UserAvatar as ExtCommentTargetUserAvatar,"); sb.Append("u1.NickName as ExtCommentNickName,u1.UserAvatar as ExtCommentUserAvatar "); sb.Append("from travel_comment c "); sb.Append("left join core_user u0 on c.CommentTargetUserId=u0.Id "); sb.Append("left join core_user u1 on c.CommentUserId=u1.Id "); sb.Append("where c.TravelTargetType=" + (int)EnumTravelTargetType.Feed + " "); sb.Append("and c.Id=" + comment.Id+";"); sb.Append("update travel_travel_feed set FeedCommentCount=FeedCommentCount+1 where Id=" +comment.CommentTargetId + ";"); //获取评论 return _rep.GetTSqlCommand(sb.ToString()).ToEntity<ETravelComment>(); }