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