Example #1
0
        public async Task <ReturnPaginSelectDto <ReturnUserDto> > QueryPaginAsync(SelectUserDto model)
        {
            var result = new ReturnPaginSelectDto <ReturnUserDto>();
            var user   = (from u in _context.Users
                          join p in _context.Positions on u.PositionId equals p.Id
                          select new ReturnUserDto
            {
                Education = u.Education,
                EntryTime = u.EntryTime,
                IdNumber = u.IdNumber,
                IncumbencyStatus = u.IncumbencyStatus,
                JobNumber = u.JobNumber,
                Jurisdiction = u.Jurisdiction,
                LoginTime = u.LoginTime,
                Name = u.Name,
                Phone = u.Phone,
                Position = p.Name,
                RegisteredResidence = u.RegisteredResidence,
                Remarks = u.Remarks,
                CreateTime = u.CreateTime
            }).AsQueryable();

            result.Amount = model.Amount;
            result.Total  = await user.CountAsync();

            result.PageNumber = model.PageNumber;
            result.Items      = await user.Pagin(model).OrderBy(i => i.CreateTime).ToListAsync();

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

            return(Ok(result));
        }