Example #1
0
        /// <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));
        }