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); }
public async Task <JsonResult> GetPageAsync(MessageContentQueryModel qModel) { var resultTask = _messageContentSvc.GetPageDataAsync(qModel); return(Json(await resultTask)); }