/// <summary>
/// 分页列表
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public async Task <BasePageQueryOutput <QueryRoleDto> > GetPageList(QueryRolesInput input)
{
var list = new List <Role>();
var totalNumber = 0;
var query = await _dbContext.Queryable <Role>()
.WhereIF(input.DeptId.HasValue, o => o.DeptId == input.DeptId.Value)
.ToPageListAsync(input.Page, input.PageSize, totalNumber);
list = query.Key;
totalNumber = query.Value;
var result = new List <QueryRoleDto>();
if (list != null && list.Count > 0)
{
list.ForEach(o =>
{
var parent = _dbContext.Queryable <Organize>().First(it => it.KeyId == o.DeptId);
result.Add(new QueryRoleDto
{
DeptName = parent?.Name,
KeyId = o.KeyId,
CreateTime = o.CreateTime,
DeptId = o.DeptId,
Name = o.Name,
Codes = o.Codes,
CreateId = o.CreateId
});
});
}
return(new BasePageQueryOutput <QueryRoleDto> {
Page = input.Page, Rows = result, Total = totalNumber
});
}
/// <summary>
/// 查询列表
/// </summary>
public async Task <IEnumerable <Permissions> > GetListByUserTypeAsync(Guid userId, int type = 2)
{
var query = await _dbContext.Queryable <Permissions>()
.Where(o => o.UserId == userId)
.Where(o => o.Types == type)
.ToListAsync();
return(query);
}
/// <summary>
/// 分页列表
/// </summary>
public async Task <BasePageOutput <ConfigReRoutes> > GetPageList(PageInput input)
{
var list = new List <ConfigReRoutes>();
var totalNumber = 0;
var query = await _dbContext.Queryable <ConfigReRoutes>()
.ToPageListAsync(input.Page, input.PageSize, totalNumber);
list = query.Key;
totalNumber = query.Value;
return(new BasePageOutput <ConfigReRoutes> {
Page = input.Page, Rows = list, Total = totalNumber
});
}
/// <summary>
/// 分页列表
/// </summary>
public async Task <BasePageOutput <ApiResource> > GetPageList(PageInput input)
{
var list = new List <ApiResource>();
var totalNumber = 0;
var query = await _dbContext.Queryable <ApiResource>()
.WhereIF(!input.Name.IsNullOrEmpty(), o => o.Name.Contains(input.Name))
.ToPageListAsync(input.Page, input.PageSize, totalNumber);
list = query.Key;
totalNumber = query.Value;
return(new BasePageOutput <ApiResource> {
Page = input.Page, Rows = list, Total = totalNumber
});
}
/// <summary>
/// 分页列表
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public async Task <BasePageQueryOutput <QueryUserDto> > GetPageList(QueryUsersInput input)
{
var list = new List <User>();
var totalNumber = 0;
var query = await _dbContext.Queryable <User>()
.WhereIF(input.DeptId.HasValue, o => o.DeptId == input.DeptId.Value)
.WhereIF(input.Account.IsNotNullAndWhiteSpace(), o => o.Account == input.Account)
.WhereIF(input.RealName.IsNotNullAndWhiteSpace(), o => o.RealName == input.RealName)
.WhereIF(input.Mobile.IsNotNullAndWhiteSpace(), o => o.Mobile == input.Mobile)
.WhereIF(input.Email.IsNotNullAndWhiteSpace(), o => o.Email == input.Email)
.WhereIF(input.Status.HasValue, o => o.Status == input.Status.Value)
.ToPageListAsync(input.Page, input.PageSize, totalNumber);
list = query.Key;
totalNumber = query.Value;
var result = new List <QueryUserDto>();
if (list != null && list.Count > 0)
{
list.ForEach(o =>
{
var parent = _dbContext.Queryable <Organize>().First(it => it.KeyId == o.DeptId);
result.Add(new QueryUserDto
{
DeptName = parent?.Name,
KeyId = o.KeyId,
Account = o.Account,
CreateTime = o.CreateTime,
DeptId = o.DeptId,
Email = o.Email,
HeadPic = o.HeadPic,
Mobile = o.Mobile,
NickName = o.NickName,
RealName = o.RealName,
Sex = o.Sex,
Status = o.Status,
UpLoginDate = o.UpLoginDate,
StatusText = o.Status ? "启用" : "停用"
});
});
}
return(new BasePageQueryOutput <QueryUserDto> {
Page = input.Page, Rows = result, Total = totalNumber
});
}
/// <summary>
/// 分页列表
/// </summary>
public async Task <BasePageOutput <ClientsDto> > GetPageList(PageInput input)
{
var list = new List <Clients>();
var totalNumber = 0;
var query = await _dbContext.Queryable <Clients>()
.WhereIF(!input.Name.IsNullOrEmpty(), o => o.ClientId.Contains(input.Name))
.ToPageListAsync(input.Page, input.PageSize, totalNumber);
list = query.Key;
totalNumber = query.Value;
var result = new List <ClientsDto>();
if (list != null && list.Count > 0)
{
foreach (var o in list)
{
var grantTypes = await _dbContext.Queryable <ClientGrantType>()
.Where(t => t.ClientId == o.Id).Select(t => t.GrantType).ToListAsync();
var scopes = await _dbContext.Queryable <ClientScope>()
.Where(t => t.ClientId == o.Id).Select(t => t.Scope).ToListAsync();
result.Add(new ClientsDto
{
ClientId = o.ClientId,
ClientName = o.ClientName,
Description = o.Description,
Enabled = o.Enabled,
AllowedGrantTypes = grantTypes,
AllowedScopes = scopes,
Id = o.Id
});
}
;
}
return(new BasePageOutput <ClientsDto> {
Page = input.Page, Rows = result, Total = totalNumber
});
}
/// <summary>
/// 分页列表
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public async Task <BasePageQueryOutput <LogDto> > GetPageList(QueryLogsInput input)
{
var list = new List <LogDto>();
var totalNumber = 0;
var query = await _dbContext.Queryable <Log>()
.WhereIF(input.Level.IsNotNullAndWhiteSpace(), o => o.Level == input.Level)
.Select(o => new LogDto
{
Id = o.Id,
Application = o.Application,
BusinessId = o.BusinessId,
BusinessType = o.BusinessType,
Level = o.Level,
Message = o.Message,
TimeStamp = o.TimeStamp
})
.ToPageListAsync(input.Page, input.PageSize, totalNumber);
list = query.Key;
totalNumber = query.Value;
return(new BasePageQueryOutput <LogDto> {
Page = input.Page, Rows = list, Total = totalNumber
});
}
/// <summary>
/// 分页列表
/// </summary>
public async Task <BasePageOutput <ReRoute> > GetPageList(ReRoutePageInput input)
{
var list = new List <ReRoute>();
var totalNumber = 0;
var query = await _dbContext.Queryable <ReRoute>()
.WhereIF(!input.Name.IsNullOrEmpty(), o => o.UpstreamPathTemplate.Contains(input.Name))
.WhereIF(input.ItemId.HasValue, o => o.ItemId == input.ItemId.Value)
.ToPageListAsync(input.Page, input.PageSize, totalNumber);
list = query.Key;
totalNumber = query.Value;
return(new BasePageOutput <ReRoute> {
Page = input.Page, Rows = list, Total = totalNumber
});
}
