public async Task <ResultPageData <RspApp> > GetPageList(ParamPage <ParamAppSearchFilter> param)
{
var list =
await Context.Apps.AsNoTracking()
.OrderBy(x => x.CreateDate.ToString("yyyy-MMMM-dd HH:mm:ss", CultureInfo.InvariantCulture))
.WhereIf(!string.IsNullOrEmpty(param.Filter.AppId), x => x.AppId.Contains(param.Filter.AppId))
.Select(x => new RspApp()
{
Id = x.Id,
AppId = x.AppId,
AppName = x.AppName,
AppDesc = x.AppDesc,
CreateDate = x.CreateDate,
LastUpdate = x.LastUpdate,
AppSecret = x.Secret.ToString()
})
.GetPageList(param.Index, param.Size);
return(new ResultPageData <RspApp>()
{
Data = list,
Total = await Context.Apps.CountAsync(),
Pagesize = param.Size,
Pageindex = param.Index
});
}
public async Task <ResultPageData <RpsConfig> > GetPageList(ParamPage <ParamConfigSearchFilter> param)
{
var query = Context.Configs.AsNoTracking()
.OrderBy(x => x.CreateDate.ToString("yyyy-MMMM-dd HH:mm:ss", CultureInfo.InvariantCulture))
.WhereIf(!string.IsNullOrEmpty(param.Filter.AppId), x => x.AppId.Contains(param.Filter.AppId))
.WhereIf(!string.IsNullOrEmpty(param.Filter.EnvId), x => x.EnvId.Contains(param.Filter.EnvId))
.Where(x => x.Status == 0);
var list =
await query
.Join(Context.Apps.AsNoTracking(), x => x.AppId, y => y.AppId, (x, y) =>
new RpsConfig
{ Id = x.Id,
AppId = x.AppId,
AppName = y.AppName,
ConfigDesc = x.ConfigDesc,
ConfigId = x.ConfigId,
ConfigValue = x.ConfigValue,
CreateDate = x.CreateDate,
EnvId = x.EnvId,
LastUpdate = x.LastUpdate,
LastTimeSpan = x.LastTimespan, })
.GetPageList(param.Index, param.Size);
return(new ResultPageData <RpsConfig>()
{
Data = list,
Total = await query.CountAsync(),
Pagesize = param.Size,
Pageindex = param.Index
});
}
public async Task <ResultPageData <RpsUser> > GetPageList(ParamPage <ParamUserSearchFilter> param)
{
var query = Context.Users.AsNoTracking().Where(x => x.Status != 2)
.WhereIf(!string.IsNullOrEmpty(param.Filter.Name), x => x.Name.Contains(param.Filter.Name))
.WhereIf(param.Filter.Status.HasValue, x => x.Status == param.Filter.Status)
.WhereIf(!string.IsNullOrEmpty(param.Filter.UserId), x => x.UserId.Contains(param.Filter.UserId));
var list = await query
.OrderBy(x => x.CreateDate.ToString("yyyy-MMMM-dd HH:mm:ss", CultureInfo.InvariantCulture))
.Select(x => new RpsUser()
{
Id = x.Id,
Name = x.Name,
UserId = x.UserId,
Status = x.Status,
CreateDate = x.CreateDate,
LastUpdate = x.LastUpdate
}).
GetPageList(param.Index, param.Size);
return(new ResultPageData <RpsUser>()
{
Data = list,
Total = await query.CountAsync(),
Pageindex = param.Index,
Pagesize = param.Size
});
}
public async Task <ResultPageData <RpsReqLog> > GetPageList(ParamPage <ParamReqLogSearchFilter> param)
{
var query = Context.ReqLogs.AsNoTracking();
var list = await query
.WhereIf(!string.IsNullOrEmpty(param.Filter.AppId), x => x.AppId.Contains(param.Filter.AppId))
.WhereIf(!string.IsNullOrEmpty(param.Filter.ClientIp), x => x.ClientIp.Contains(param.Filter.ClientIp))
.WhereIf(!string.IsNullOrEmpty(param.Filter.EnvId), x => x.AppEnv.Contains(param.Filter.EnvId))
.OrderBy(x => x.LastDate.ToString("yyyy-MMMM-dd HH:mm:ss", CultureInfo.InvariantCulture))
.Select(x => new RpsReqLog()
{
Id = x.Id,
ClientIp = x.ClientIp,
AppEnv = x.AppEnv,
AppId = x.AppId,
FirstDate = x.FirstDate,
LastConfigDate = x.LastConfigDate,
LastDate = x.LastDate,
ReqTimes = x.ReqTimes
})
.GetPageList(param.Index, param.Size);
return(new ResultPageData <RpsReqLog>()
{
Data = list,
Pageindex = param.Index,
Pagesize = param.Size,
Total = await query.CountAsync()
});
}
public async Task <IActionResult> GetPageList(ParamPage <object> param)
{
return(await ActionWrapAsync(async() =>
{
ResultPageData <RpsEnv> result = new ResultPageData <RpsEnv>();
result = await _envService.GetPageList(param);
return result;
}));
}
public async Task <IActionResult> GetPageList(ParamPage <ParamAppSearchFilter> param)
{
return(await ActionWrapAsync(async() =>
{
ResultPageData <RspApp> result = new ResultPageData <RspApp>();
result = await _appService.GetPageList(param);
return result;
}));
}
public async Task <ResultPageData <RpsEnv> > GetPageList(ParamPage <object> param)
{
var list =
await Context.Envs.AsNoTracking()
.OrderBy(x => x.CreateDate.ToString("yyyy-MMMM-dd HH:mm:ss", CultureInfo.InvariantCulture))
.Select(x => new RpsEnv()
{
Id = x.Id,
EnvId = x.EnvId,
EnvDesc = x.EnvDesc,
CreateDate = x.CreateDate,
LastUpdate = x.LastUpdate
})
.GetPageList(param.Index, param.Size);
return(new ResultPageData <RpsEnv>()
{
Data = list,
Total = await Context.Envs.CountAsync(),
Pagesize = param.Size,
Pageindex = param.Index
});
}
public async Task <ResultPageData <RpsUser> > GetPageList(ParamPage <ParamUserSearchFilter> param)
{
return(await _userRepository.GetPageList(param));
}
public async Task <ResultPageData <RspApp> > GetPageList(ParamPage <ParamAppSearchFilter> param)
{
return(await _appRepository.GetPageList(param));
}
public async Task <ResultPageData <RpsConfig> > GetPageList(ParamPage <ParamConfigSearchFilter> param)
{
return(await _configRepository.GetPageList(param));
}
public async Task <ResultPageData <RpsReqLog> > GetPageList(ParamPage <ParamReqLogSearchFilter> param)
{
return(await _reqLogRepository.GetPageList(param));
}
public async Task <IActionResult> GetPageList(ParamPage <ParamUserSearchFilter> param)
{
return(await ActionWrapAsync(async() => await _userService.GetPageList(param)));
}
public async Task <ResultPageData <RpsEnv> > GetPageList(ParamPage <object> param)
{
return(await _envRepository.GetPageList(param));
}
