/// <summary> /// 获取页面列表数据 /// </summary> /// <param name="qModel"></param> /// <returns></returns> public async Task <ResultDto <ShowRoomDto> > GetPageDataAsync(ShowRoomQueryModel qModel) { var result = new ResultDto <ShowRoomDto>(); var query = _liveShowDB.ShowRoom.AsNoTracking() /*.Include(x => x.User)*/.Where(x => !x.IsDeleted); try { query = qModel.Status.HasValue && ShowRoomStatusEnum.Default.GetHashCode() != qModel.Status ? query.Where(x => x.Status == qModel.Status) : query; var queryData = query.Select(s => new ShowRoomDto() { Id = s.Id, Name = s.Name, Title = s.Title, Status = s.Status, //StatusName= }); queryData = queryData.OrderBy(o => o.LastActivateTime); 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(ShowRoomQueryModel qModel) { var resultTask = _showRoomSvc.GetPageDataAsync(qModel); return(Json(await resultTask)); }