/// <summary>
/// 导出用户
/// </summary>
/// <param name="queryInput"></param>
/// <returns></returns>
public async Task <UserExcelOutput> Export(UserQueryInput queryInput)
{
var query = queryInput.Adapt <UserQuery>();
var users = await _userRep.GetListAsync(query);
var exportData = users.Select(a => new Dictionary <string, string> {
{ "姓名", a.Name },
{ "性别", a.Gender.ToDescription() },
{ "出生日期", a.Birthday.ToDateTimeString() },
{ "手机号", a.Phone },
{ "邮箱", a.Email },
{ "微信", a.WeChat },
{ "状态", a.Enabled.IsTrue()?"启用":"注销" },
{ "最后登录时间", a.LastLoginTime.ToDateTimeString() },
{ "最后登录地点", a.LastLoginIP }
});
string fileName = $"{Guid.NewGuid()}.xlsx";
string rootPath = _appSettings.FilePath.ExportExcelPath;
H_File.CreateDirectory(rootPath);
string filePath = Path.Combine(rootPath, $"{fileName}");
await H_Excel.ExportByEPPlus(filePath, exportData);
return(new UserExcelOutput {
FileName = fileName, FileId = _protector.Protect(fileName.Split('.')[0], TimeSpan.FromSeconds(5))
});
}
/// <summary>
/// 获取用户列表
/// </summary>
/// <param name="queryInput"></param>
/// <returns></returns>
public async Task <Paged <UserOutput> > GetPaged(UserQueryInput queryInput)
{
var query = queryInput.Adapt <UserQuery>();
query.CurrentRoleLevel = _currentUser.RoleLevel;
var users = await _userRep.GetPagedAsync(query);
var result = users.Adapt <Paged <UserOutput> >();
return(result);
}
