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)); }