public UserSearchOutput GetUsers(UserSearchInput input = null) { if (input == null) { input = new UserSearchInput(); } Logger.Info(" 查询用户信息,查询内容: " + input); var inputUser = input.MapTo <Core.System.User>(); var total = _userRepository.GetAllList().Count; var users = _userRepository.GetUsers(inputUser); if (users == null) { throw new UserFriendlyException("未查询到数据。"); } var rows = users.MapTo <List <UserDto> >(); rows = rows.Skip(input.Offset).Take(input.Limit).ToList(); return(new UserSearchOutput { Total = total, Rows = rows }); }
public UserSearchOutput Search(UserSearchInput input) { //throw new UserFriendlyException("test"); int rowCount; var data = _userRepository.GetAll().SearchByInputDto(input, out rowCount); var output = new UserSearchOutput { Datas = data.ToList().Select(s => { var temp = s.MapTo <UserOutput>(); if (s.IsDeleted) { temp.State = "注销"; } else { temp.State = s.IsActive ? "正常" : "锁定"; } return(temp); }).ToList(), Page = new Pager(input.Page) { TotalCount = rowCount } }; return(output); }
public byte[] ExportUserBytes(UserSearchInput input) { using (var session = DatabaseSession.OpenSession()) { var sql = @"SELECT A.""Id"" 标识, A.""UserName"" 工号, ""Name"" 姓名, C.GROUP_NAME 地区, B.NAME 部门, CASE WHEN A.""IsDeleted"" = 1 THEN '注销' WHEN A.""IsActive"" = 0 THEN '锁定' ELSE '正常' END 状态, a.""CreationTime"" 创建时间, a.""LastLoginTime"" 最后登录时间 FROM ""AbpDepartment"" B, ""AbpUsers"" A LEFT JOIN ""AbpDistrict"" C ON A.""GroupId"" = C.ID WHERE ""TenantId"" = {0} AND A.""DepartmentId"" = B.ID".FormatWith(AbpSession.TenantId); const string whereString = ""; var orderString = input.Order != null ? @" ORDER BY A.""{0}"" {1}".FormatWith(input.Order.Name, input.Order.Type) : ""; var reader = session.ExecuteReader(new DataCommandDefinition(sql + whereString + orderString)); return(_exportProvider.ExportBig(reader, ExportFileType.Excel)); } }
/// <summary> /// 首页 /// </summary> /// <returns></returns> public IActionResult Index(int pageIndex = 1) { var search = new UserSearchInput { PageIndex = pageIndex }; return(View(search)); }
/// <summary> /// 用户列表 /// </summary> /// <param name="input"></param> /// <returns></returns> public async Task <IActionResult> List(UserSearchInput input) { var model = new Page <UserDto>(); var items = await _userService.GetUserPageList(input); model.CurrentPage = input.PageIndex; model.Items = Mapper.Map <List <User>, List <UserDto> >(items.Item1); model.TotalRecords = items.Item2; return(PartialView("_ListPartial", model)); }
/// <summary> /// 根据条件用户列表 - 分页 /// </summary> /// <param name="input">用户搜索输入</param> /// <returns>用户列表</returns> public async Task <Tuple <List <User>, int> > GetUserPageList(UserSearchInput input) { var query = _Context.Users.AsQueryable(); if (!string.IsNullOrEmpty(input.Name)) { query = query.Where(x => x.Name.Contains(input.Name)); } // to do: list query condition var total = query.Count(); var userList = await query.OrderBy(i => i.Id).Skip(input.PageSize * (input.PageIndex - 1)).Take(input.PageSize).ToListAsync(); return(new Tuple <List <User>, int>(userList, total)); }
public UserSearchOutput GetUsers(UserSearchInput input) { Logger.Info(" 查询用户信息,查询内容: " + input); var user = input.MapTo <User>(); var data = _userRepository.GetAllUsers(user); if (data == null) { throw new UserFriendlyException("未查询到数据。"); } return(new UserSearchOutput { Users = data.MapTo <List <UserDto> >() }); }
public ActionResult ExportUser(UserSearchInput input) { var result = _userService.ExportUserBytes(input); return(File(result, "application/x-xls", "{0}.xlsx".FormatWith("技术管理平台工号"))); }
public Task <IEnumerable <UserInListDto> > GetAllAsync(UserSearchInput filter) { throw new NotImplementedException(); }
/// <summary> /// 根据条件用户列表 - 分页 /// </summary> /// <param name="input">用户搜索输入</param> /// <returns>用户列表</returns> public async Task <Tuple <List <User>, int> > GetUserPageList(UserSearchInput input) { var query = await _userRepository.GetUserPageList(input); return(query); }
public ActionResult IndexList(UserSearchInput input) { return(Json(_userService.GetUsers(input))); }