public async Task <QueryAppConfigListOutput> QueryAppConfigList(QueryAppConfigListInput input) { var totalNumber = 0; // 环境库 Enum.TryParse <Env>(input.Environment, out var env); var tableName = string.Empty; switch (env) { case Env.dev: tableName = $"tb_appconfig_{Env.dev.ToString()}"; break; case Env.pro: tableName = $"tb_appconfig_{Env.pro.ToString()}"; break; default: throw new BucketException("plm_001", "环境不存在"); } // 执行 var result = await _dbContext.Queryable <AppConfigInfo>().AS(tableName) .WhereIF(!string.IsNullOrWhiteSpace(input.AppId), it => it.ConfigAppId == input.AppId) .WhereIF(!string.IsNullOrWhiteSpace(input.NameSpace), it => it.ConfigNamespaceName == input.NameSpace) .ToPageListAsync(input.PageIndex, input.PageSize, totalNumber); return(new QueryAppConfigListOutput { Data = result.Key, CurrentPage = input.PageIndex, Total = result.Value }); }
public async Task <QueryAppConfigListOutput> QueryAppConfigList(QueryAppConfigListInput input) { var totalNumber = 0; var result = await _dbContext.Queryable <AppConfigInfo>() .WhereIF(!string.IsNullOrWhiteSpace(input.AppId), it => it.ConfigAppId == input.AppId) .WhereIF(!string.IsNullOrWhiteSpace(input.NameSpace), it => it.ConfigNamespaceName == input.NameSpace) .ToPageListAsync(input.PageIndex, input.PageSize, totalNumber); return(new QueryAppConfigListOutput { Data = result.Key, CurrentPage = input.PageIndex, Total = totalNumber }); }
public BasePageOutput <object> QueryAppConfigList([FromQuery] QueryAppConfigListInput input) { var totalNumber = 0; // 环境库 var tableName = _configService.GetConfigTableName(input.Environment); // 执行 var lst = _adminDbContext.Queryable <AppConfigModel>().AS(tableName) .WhereIF(!string.IsNullOrWhiteSpace(input.AppId), it => it.ConfigAppId == input.AppId) .WhereIF(!string.IsNullOrWhiteSpace(input.NameSpace), it => it.ConfigNamespaceName == input.NameSpace) .ToPageList(input.PageIndex, input.PageSize, ref totalNumber); return(new BasePageOutput <object> { Data = lst, CurrentPage = input.PageIndex, Total = totalNumber }); }
public async Task <QueryAppConfigListOutput> QueryAppConfigList([FromQuery] QueryAppConfigListInput input) { return(await _configBusniess.QueryAppConfigList(input)); }