Exemplo n.º 1
0
        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);
        }
Exemplo n.º 2
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);
        }