public async Task <ResultDto <MessageContentDto> > GetPageDataAsync(MessageContentQueryModel qModel)
        {
            var result = new ResultDto <MessageContentDto>();

            try
            {
                var query     = _liveShowDB.MessageContent.AsNoTracking().Where(x => !x.IsDeleted);
                var queryData = query.Select(s => new MessageContentDto()
                {
                    Id                = s.Id,
                    CategoryId        = s.CategoryId,
                    Title             = s.Title,
                    SenderId          = s.SenderId,
                    SenderName        = s.SenderName,
                    SendTime          = s.SendTime,
                    Content           = s.Content,
                    ReceiveObjectType = s.ReceiveObjectType,
                    ReceiveObjectIds  = s.ReceiveObjectIds,
                    Status            = s.Status,
                    ErrorMessage      = s.ErrorMessage
                });
                queryData           = queryData.OrderByDescending(o => o.CreateTime);
                queryData           = queryData.Skip((qModel.Page - 1) * qModel.PageSize).Take(qModel.PageSize);
                result.ActionResult = true;
                result.Message      = "Success";
                result.List         = await queryData.ToListAsync();
            }
            catch (Exception ex)
            {
                result.Message = ex.Message;
            }
            return(result);
        }
Exemple #2
0
        public async Task <JsonResult> GetPageAsync(MessageContentQueryModel qModel)
        {
            var resultTask = _messageContentSvc.GetPageDataAsync(qModel);

            return(Json(await resultTask));
        }