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