Beispiel #1
0
        public async Task <ReturnPagin <List <ReturnPositionDto> > > QueryPaginAsync(SelectPositionDto model)
        {
            var result = new ReturnPagin <List <ReturnPositionDto> >();

            var positions = _context.Positions.Include(i => i.Department).AsNoTracking();

            result.Items = await positions.OrderByDescending(i => i.CreateTime).Pagin(model).Select(i => new ReturnPositionDto
            {
                DepartmentName = i.Department.Name,
                Id             = i.Id,
                LastUpTime     = i.LastUpTime,
                CreateTime     = i.CreateTime,
                Name           = i.Name
            }).ToListAsync();

            result.Count = await positions.CountAsync();

            result.Number = model.Number;
            result.Page   = model.Page;
            return(result);
        }
        public async Task <IActionResult> QueryPaginAsync(SelectPositionDto model)
        {
            var result = await _service.QueryPaginAsync(model);

            return(Ok(result));
        }
        public async Task <ReturnPaginSelectDto <ReturnPositionDto> > QueryPaginAsync(SelectPositionDto model)
        {
            var result   = new ReturnPaginSelectDto <ReturnPositionDto>();
            var position = _context.Positions.AsNoTracking();

            result.Total = await position.CountAsync();

            result.PageNumber = model.PageNumber;
            result.Amount     = model.Amount;
            result.Items      = _mapper.Map <List <ReturnPositionDto> >(await position.Pagin(model).OrderBy(i => i.CreateTime).ToListAsync());

            return(result);
        }