public async Task <ResultDto <CommentDto> > GetPageDataAsync(CommentQueryModel qModel)
        {
            var result = new ResultDto <CommentDto>();
            var query  = _testDB.Comment.AsNoTracking().Where(x => !x.IsDelete);

            query = qModel.State.HasValue ? query.Where(x => x.Status == qModel.State) : query;
            var queryData = query.Select(x => new CommentDto()
            {
                Id         = x.Id,
                ArticleId  = x.ArticleId,
                Content    = x.Content,
                Status     = x.Status,
                ParentId   = x.ParentId.HasValue ? x.ParentId.Value : 0,
                Creator    = x.Creator,
                CreateTime = x.CreateTime
            });

            queryData           = queryData.OrderBy(o => o.CreateTime);
            queryData           = queryData.Skip((qModel.PageIndex - 1) * qModel.PageSize).Take(qModel.PageSize);
            result.ActionResult = true;
            result.Message      = "Success";
            result.List         = await queryData.ToListAsync();

            return(result);
        }
        public async Task <JsonResult> GetPageAsync(CommentQueryModel qModel)
        {
            var id   = UserId;
            var name = UserName;

            var res = await _commentSvc.GetPageDataAsync(qModel);

            return(Json(res));
        }
        public async Task <IResultModel> Query(CommentQueryModel model)
        {
            var result = new QueryResultModel <CommentEntity>
            {
                Rows  = await _repository.Query(model),
                Total = model.TotalCount
            };

            return(ResultModel.Success(result));
        }
        public async Task <IList <CommentEntity> > Query(CommentQueryModel model)
        {
            var paging = model.Paging();

            var query     = Db.Find();
            var joinQuery = query.LeftJoin <TopicEntity>((t1, t2) => t1.TopicId == t2.Id)
                            .LeftJoin <UserEntity>((t1, t2, t3) => t1.To == t3.Id)
                            .LeftJoin <UserEntity>((t1, t2, t3, t4) => t2.UserId == t4.Id);

            joinQuery.WhereNotNull(model.TopicId, (t1, t2, t3, t4) => t1.TopicId == model.TopicId);
            joinQuery.WhereNotNull(model.UserId, (t1, t2, t3, t4) => t1.UserId == model.UserId);
            joinQuery.WhereNotNull(model.To, (t1, t2, t3, t4) => t1.To == model.To);

            if (!paging.OrderBy.Any())
            {
                joinQuery.OrderByDescending((t1, t2, t3, t4) => t1.Id);
            }

            joinQuery.Select((t1, t2, t3, t4) => new
            {
                t1,
                TopicTitle = t2.Title,
                ToNickName = t3.NickName,
                ToAvatar   = t3.Avatar,
                ToSex      = t3.Sex,
                t4.NickName,
                t4.Avatar,
                t4.Sex
            });

            var result = await joinQuery.PaginationAsync(paging);

            model.TotalCount = paging.TotalCount;

            return(result);
        }
Exemple #5
0
 public Task <IResultModel> Query([FromQuery] CommentQueryModel model)
 {
     return(_service.Query(model));
 }
        public async Task <JsonResult> GetPageAsync(CommentQueryModel qModel)
        {
            var result = await _commentSvc.GetPageDataAsync(qModel);

            return(Json(result));
        }