public List <CommentNReplies> GetList(int postId, string postType, string openId = "") { List <CommentNReplies> comments = new List <CommentNReplies>(); try { var dao = new CommentsDao(mysqlConnection); comments.AddRange(dao.GetList(postId, postType)); if (!string.IsNullOrEmpty(openId)) { comments.AddRange(dao.GetPendingList(postId, postType, openId)); //发表评论的人可以看到自己发表但未审核的评论 } //读取作者对评论的回复 comments.ForEach(comment => { comment.Replies = dao.GetAuthorReplies(comment.comment_id); }); } catch (Exception ex) { logger.Error("获取评论失败", ex); } return(comments.OrderByDescending(comm => comm.createdAt).ToList()); }
public CommentsAuditList GetPendingAuditList(int pageIndex = 1, int pageSize = 10, string openId = "") { CommentsAuditList result = new CommentsAuditList(); List <CommentsEx> comments = new List <CommentsEx>(); try { var dao = new CommentsDao(mysqlConnection); StringBuilder sb = new StringBuilder(); if (!string.IsNullOrEmpty(openId)) { sb.Append($" comment_user_id='{openId}'"); } comments = dao.GetAuditList(0, pageIndex, pageSize, sb.ToString()); Int64 count = dao.GetAuditListCount(0); result.lists = comments; result.count = count; } catch (Exception ex) { logger.Error("获取评论失败", ex); } return(result); }
public ResponseEntity <string> AddAuthorComments(Comments comments) { var responseEntity = new ResponseEntity <string>(true, "添加成功", string.Empty); try { bool success = new CommentsDao(mysqlConnection).AddAuthorComment(comments); } catch (Exception ex) { logger.Error("评论管理-添加失败!", ex); responseEntity = new ResponseEntity <string>(false, "添加失败", string.Empty); } return(responseEntity); }
public ResponseEntity <string> GetCommentsByPostID(Comments comments) { var responseEntity = new ResponseEntity <string>(true, "审核成功", string.Empty); try { bool success = new CommentsDao(mysqlConnection).AuditComments(comments); } catch (Exception ex) { logger.Error("评论管理-审核失败!", ex); responseEntity = new ResponseEntity <string>(false, "审核失败", string.Empty); } return(responseEntity); }
public ResponseEntity <string> Reject(int commentId) { var responseEntity = new ResponseEntity <string>(true, "拒绝成功", string.Empty); try { bool success = new CommentsDao(mysqlConnection).AuditReject(commentId); } catch (Exception ex) { logger.Error("评论管理-审核失败!", ex); responseEntity = new ResponseEntity <string>(false, "审核失败", string.Empty); } return(responseEntity); }
public Int64 GetPendingAuditCount() { try { var dao = new CommentsDao(mysqlConnection); Int64 count = dao.GetAuditListCount(0); return(count); } catch (Exception ex) { logger.Error("获取评论失败", ex); } return(0); }
public long GetPendingCount(string openId = "") { long count = 0; try { var dao = new CommentsDao(mysqlConnection); count = dao.GetPendingCount(openId); } catch (Exception ex) { return(0); } return(count); }
public void GetList_GettingData_ReturnList() { var data = CreateCommentData(); var storMock = new Mock <IStorage>(); storMock.Setup(x => x.GetComments(It.IsNotNull <int?>())).Returns(data); var sut = new CommentsDao(storMock.Object); var result = sut.GetList(1, null, 0, 0, 0).ToList(); Assert.AreEqual(data.Count, result.Count); Assert.AreSame(data[0], result[0]); result = sut.GetList(1, "Id", 1, 0, 1).ToList(); Assert.AreEqual(data.Count, result.Count); Assert.AreSame(data[data.Count - 1], result[0]); }
public CommentsAuditList GetRejectedAuditList(int pageIndex = 1, int pageSize = 10) { CommentsAuditList result = new CommentsAuditList(); List <CommentsEx> comments = new List <CommentsEx>(); try { var dao = new CommentsDao(mysqlConnection); comments = dao.GetAuditList(2, pageIndex, pageSize); Int64 count = dao.GetAuditListCount(2); result.lists = comments; result.count = count; } catch (Exception ex) { logger.Error("获取评论失败", ex); } return(result); }
public List <CommentNReplies> GetListForMyProfile(int postId, string postType) { List <CommentNReplies> comments = new List <CommentNReplies>(); try { var dao = new CommentsDao(mysqlConnection); comments.AddRange(dao.GetListForMyProfile(postId, postType)); //读取作者对评论的回复 comments.ForEach(comment => { comment.Replies = dao.GetAuthorReplies(comment.comment_id); }); } catch (Exception ex) { logger.Error("获取评论失败", ex); } return(comments.OrderByDescending(comm => comm.createdAt).ToList()); }