public async Task <ActionResult> GetGuests(DataTableQuery query)
{
IEnumerable <PageQueryItem> getPageQueryItems()
{
yield return(new PageQueryItem(nameof(Guest.Name), query.Search.Value, ExpressionOperate.Like));
yield return(new PageQueryItem(nameof(Guest.PinYin), query.Search.Value, ExpressionOperate.Like));
yield return(new PageQueryItem(nameof(Guest.IsFemale), BoolLikeStr(nameof(Guest.IsFemale), query.Search.Value), ExpressionOperate.Equal));
yield return(new PageQueryItem(nameof(Guest.Title), query.Search.Value, ExpressionOperate.Like));
yield return(new PageQueryItem(nameof(Guest.Company), query.Search.Value, ExpressionOperate.Like));
yield return(new PageQueryItem(nameof(Guest.Description), query.Search.Value, ExpressionOperate.Like));
yield return(new PageQueryItem(nameof(Guest.Telephone), query.Search.Value, ExpressionOperate.Like));
yield return(new PageQueryItem(nameof(Guest.Guid), query.Search.Value, ExpressionOperate.Equal));
}
var input = new GenericPagingInput(
query.Start,
query.Length,
list: getPageQueryItems().ToList());
//input.Sorting = "CreationTime asc";
var page = await _guestAppService.GetAllAsync(input);
return(Json(new DataTableResult <GuestDto>(page)));
}
public async Task <JsonResult> JsonGetUsersNotInOrganization(int draw, DataTableQuery query, long organizationUnitId, string usernameLike)
{
IEnumerable <PageQueryItem> getPageQueryItems()
{
yield return(new PageQueryItem(nameof(Adbp.Zero.Authorization.Users.User.UserName), query.Search.Value, ExpressionOperate.Like));
}
var input = new GenericPagingInput(query.Start, query.Length, list: getPageQueryItems().ToList());
var page = await _organizationUnitAppService.GetUsersNotInOrganizationAsync(input, organizationUnitId);
return(Json(new DataTableResult <OrganizationUserOuput>(page)));
}
public virtual async Task <PagedResultDto <AuditLogDto> > GetAuditLogsAsync(GenericPagingInput input)
{
var page = await GetAll <AuditLog, long, GenericPagingInput, AuditLogDto>(_auditLogRepository.GetAll(), input);
var users = await _userRepository.GetAllListAsync();
foreach (AuditLogDto item in page.Items)
{
if (item.UserId != null)
{
item.UserStr = users.FirstOrDefault(x => x.Id == item.UserId)?.UserStr;
}
}
return(page);
}
public async Task <ActionResult> GetUsers(DataTableQuery query)
{
IEnumerable <PageQueryItem> getPageQueryItems()
{
yield return(new PageQueryItem(nameof(Adbp.Zero.Authorization.Users.User.Name), query.Search.Value, ExpressionOperate.Like));
yield return(new PageQueryItem(nameof(Adbp.Zero.Authorization.Users.User.Surname), query.Search.Value, ExpressionOperate.Like));
yield return(new PageQueryItem(nameof(Adbp.Zero.Authorization.Users.User.UserName), query.Search.Value, ExpressionOperate.Like));
}
var input = new GenericPagingInput(
query.Start,
query.Length,
list: getPageQueryItems().ToList());
//input.Sorting = "CreationTime asc";
var page = await _userAppService.GetUsers(input);
return(Json(new DataTableResult <UserDto>(page)));
}
public async Task <ActionResult> GetUserLoginAttempts(DataTableQuery query)
{
IEnumerable <PageQueryItem> getPageQueryItems()
{//UserLoginAttempt
yield return(new PageQueryItem(nameof(UserLoginAttempt.BrowserInfo), query.Search.Value, ExpressionOperate.Like));
yield return(new PageQueryItem(nameof(UserLoginAttempt.ClientName), query.Search.Value, ExpressionOperate.Like));
yield return(new PageQueryItem(nameof(UserLoginAttempt.ClientIpAddress), query.Search.Value, ExpressionOperate.Like));
yield return(new PageQueryItem(nameof(UserLoginAttempt.UserNameOrEmailAddress), query.Search.Value, ExpressionOperate.Like));
yield return(new PageQueryItem(nameof(UserLoginAttempt.Result),
EnumLikeStr <AbpLoginResultType>(query.Search.Value), ExpressionOperate.Contains));
}
var input = new GenericPagingInput(
query.Start,
query.Length,
list: getPageQueryItems().ToList());
var page = await _analasyAppService.GetUserLoginAttemptsAsync(input);
return(Json(new DataTableResult <UserLoginAttemptDto>(page)));
}
public async Task <ActionResult> GetAuditLogs(DataTableQuery query)
{
IEnumerable <PageQueryItem> getPageQueryItems()
{//AuditLog
if (query.Search.Value?.Trim() == ZeroConsts.SearchCmds.SymbolException)
{
yield return(new PageQueryItem(nameof(Abp.Auditing.AuditLog.Exception), query.Search.Value, ExpressionOperate.IsNotNull));
yield break;
}
yield return(new PageQueryItem(nameof(Abp.Auditing.AuditLog.BrowserInfo), query.Search.Value, ExpressionOperate.Like));
yield return(new PageQueryItem(nameof(Abp.Auditing.AuditLog.ClientIpAddress), query.Search.Value, ExpressionOperate.Like));
yield return(new PageQueryItem(nameof(Abp.Auditing.AuditLog.ClientName), query.Search.Value, ExpressionOperate.Like));
yield return(new PageQueryItem(nameof(Abp.Auditing.AuditLog.Exception), query.Search.Value, ExpressionOperate.Like));
yield return(new PageQueryItem(nameof(Abp.Auditing.AuditLog.MethodName), query.Search.Value, ExpressionOperate.Like));
yield return(new PageQueryItem(nameof(Abp.Auditing.AuditLog.Parameters), query.Search.Value, ExpressionOperate.Like));
yield return(new PageQueryItem(nameof(Abp.Auditing.AuditLog.ServiceName), query.Search.Value, ExpressionOperate.Like));
yield return(new PageQueryItem(nameof(Abp.Auditing.AuditLog.UserId),
UserLikeStr(_userRepository, query.Search.Value), ExpressionOperate.Contains));
}
var input = new GenericPagingInput(
query.Start,
query.Length,
list: getPageQueryItems().ToList());
var page = await _analasyAppService.GetAuditLogsAsync(input);
return(Json(new DataTableResult <AuditLogDto>(page)));
}
public virtual async Task <PagedResultDto <UserDto> > GetUsers(GenericPagingInput input)
{
return(await GetAll <User, long, GenericPagingInput, UserDto>(_userRepository.GetAll(), input));
}
public virtual async Task <PagedResultDto <UserLoginAttemptDto> > GetSelfLoginAttemptsAsync(GenericPagingInput input)
{
long userId = AbpSession.GetUserId();
var page = await GetAll <UserLoginAttempt, long, GenericPagingInput, UserLoginAttemptDto>(
_userLoginAttemptRepository.GetAll().Where(x => x.UserId == userId),
input);
return(page);
}
public virtual async Task <PagedResultDto <UserLoginAttemptDto> > GetUserLoginAttemptsAsync(GenericPagingInput input)
{
var page = await GetAll <UserLoginAttempt, long, GenericPagingInput, UserLoginAttemptDto>(_userLoginAttemptRepository.GetAll(), input);
return(page);
}
public virtual async Task <PagedResultDto <TEntityDto> > GetAllAsync(GenericPagingInput input = null)
{
return(await GetAllAsync <TEntity, TPrimaryKey, TEntityDto>(_Repository, input));
}
protected virtual async Task <PagedResultDto <TEntityDto> > GetAllAsync <TEntity, TPrimaryKey, TEntityDto>(IRepository <TEntity, TPrimaryKey> repository, GenericPagingInput input = null)
where TEntity : class, IEntity <TPrimaryKey>
{
PermissionChecker.Authorize(GetRetrievePermissionNames <TEntity>());
var predicate = await GetLoginFilter <TEntity>(GetSysObjectName <TEntity>());
return(await GetAll <TEntity, TPrimaryKey, GenericPagingInput, TEntityDto>(
repository.GetAll().Where(predicate), input));
}
/// <summary>
/// 内部调用，不加权限控制
/// </summary>
/// <param name="input"></param>
/// <param name="organizationUnitId"></param>
/// <returns></returns>
protected virtual async Task <PagedResultDto <OrganizationUnitUserDto> > GetOrganizationUnitUserDtosAsync(GenericPagingInput input, long?organizationUnitId)
{
var queryable = from user in _userRepository.GetAll()
join uou in _userOrganizationUnitRepository.GetAll() on user.Id equals uou.UserId
join ou in _organizationUnitRepository.GetAll() on uou.OrganizationUnitId equals ou.Id
join zuou in _zeroUserOrganizationUnitRepository.GetAll() on uou.Id equals zuou.Id into zuouInto
from zuou in zuouInto.DefaultIfEmpty() //连接zou表, 如果zou没匹配上时, 使用默认值代替
select new OrganizationUnitUserDto
{
Id = user.Id,
UserName = user.UserName,
Name = user.Name,
Surname = user.Surname,
CreationTime = uou.CreationTime,
CreatorUserId = uou.CreatorUserId,
OrganizationUnitId = ou.Id,
OrganizationUnitName = ou.DisplayName,
IsStatic = zuou.IsStatic
};
if (organizationUnitId != null)
{
queryable = queryable.Where(x => x.OrganizationUnitId == organizationUnitId);
}
return(await GetAll <OrganizationUnitUserDto, long, GenericPagingInput, OrganizationUnitUserDto>(queryable, input));
}
public virtual async Task <PagedResultDto <OrganizationUserOuput> > GetUsersNotInOrganizationAsync(GenericPagingInput input, long organizationUnitId)
{
var uouQueryable = _userOrganizationUnitRepository.GetAll();
var queryable = _userRepository.GetAll().Where(x => !uouQueryable.Any(uou => uou.UserId == x.Id && uou.OrganizationUnitId == organizationUnitId));
queryable = ApplyWhere <User, long, GenericPagingInput>(queryable, input);
var totalCount = await AsyncQueryableExecuter.CountAsync(queryable);
queryable = ApplySorting <User, long, GenericPagingInput>(queryable, input);
queryable = ApplyPaging <User, long, GenericPagingInput>(queryable, input);
var items = (await AsyncQueryableExecuter.ToListAsync(queryable)).Select(x => new OrganizationUserOuput
{
UserId = x.Id,
UserName = x.UserName,
Name = x.Name,
Surname = x.Surname,
LastModificationTime = x.LastModificationTime ?? x.CreationTime
}).ToList();
return(new PagedResultDto <OrganizationUserOuput>(totalCount, items));
}
public virtual async Task <PagedResultDto <OrganizationUnitUserDto> > GetOrganizationUnitUserPageAsync(GenericPagingInput input, long organizationUnitId)
{
return(await GetOrganizationUnitUserDtosAsync(input, organizationUnitId));
}
public virtual async Task <PagedResultDto <RoleDto> > GetRoles(GenericPagingInput input = null)
{
return(await GetAll <Role, int, GenericPagingInput, RoleDto>(
_roleRepository.GetAll(), input));
}
