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