public async Task <PageResult <AppResponseDTO> > Query([FromBody] AppRequestDTO input) { string likevalue = $"%{input.Name}%"; var query = pcontext.App.Where(u => EF.Functions.Like(u.Name, likevalue)) .Select(u => new AppResponseDTO { Id = u.Id, Name = u.Name, Code = u.Code, CreateTime = u.CreateTime }); var count = await query.CountAsync(); var data = await query.OrderBy(o => o.Name).Skip((input.PageIndex - 1) * input.PageSize).Take(input.PageSize) .ToListAsync(); return(new PageResult <AppResponseDTO>(count, data)); }
public async Task <PageResult <ApiResource> > Query([FromBody] AppRequestDTO input) { string likevalue = $"%{input.Name}%"; var query = context.ApiResources.AsNoTracking().Where(u => EF.Functions.Like(u.Name, likevalue) || EF.Functions.Like(u.DisplayName, likevalue)); var count = await query.CountAsync(); var clients = await query .Include(x => x.Secrets) .Include(x => x.Scopes) .ThenInclude(s => s.UserClaims) .Include(x => x.UserClaims) .Include(x => x.Properties) .OrderBy(o => o.Name).Skip((input.PageIndex - 1) * input.PageSize).Take(input.PageSize) .ToListAsync(); var model = clients.Select(c => c.ToModel()).ToList(); return(new PageResult <ApiResource>(count, model)); }
public async Task <PageResult <Client> > Query([FromBody] AppRequestDTO input) { string likevalue = $"%{input.Name}%"; var query = context.Clients.AsNoTracking().Where(u => EF.Functions.Like(u.ClientId, likevalue) || EF.Functions.Like(u.ClientName, likevalue)); var count = await query.CountAsync(); var clients = await query .Include(x => x.AllowedGrantTypes) .Include(x => x.RedirectUris) .Include(x => x.PostLogoutRedirectUris) .Include(x => x.AllowedScopes) .Include(x => x.ClientSecrets) .Include(x => x.Claims) .Include(x => x.IdentityProviderRestrictions) .Include(x => x.AllowedCorsOrigins) .Include(x => x.Properties) .OrderBy(o => o.ClientId).Skip((input.PageIndex - 1) * input.PageSize).Take(input.PageSize) .ToListAsync(); var model = clients.Select(c => c.ToModel()).ToList(); return(new PageResult <Client>(count, model)); }