namespace Admin.NET.Core.Service; /// /// 系统参数配置服务 /// [ApiDescriptionSettings(Name = "系统配置", Order = 193)] public class SysConfigService : IDynamicApiController, ITransient { private readonly SqlSugarRepository _sysConfigRep; private readonly ISysCacheService _sysCacheService; public SysConfigService(SqlSugarRepository sysConfigRep, ISysCacheService sysCacheService) { _sysConfigRep = sysConfigRep; _sysCacheService = sysCacheService; } /// /// 获取参数配置分页列表 /// /// /// [HttpGet("/sysConfig/page")] public async Task> GetConfigPage([FromQuery] PageConfigInput input) { return await _sysConfigRep.AsQueryable() .WhereIF(!string.IsNullOrWhiteSpace(input.Name?.Trim()), u => u.Name.Contains(input.Name)) .WhereIF(!string.IsNullOrWhiteSpace(input.Code?.Trim()), u => u.Code.Contains(input.Code)) .OrderBy(u => u.Order).ToPagedListAsync(input.Page, input.PageSize); } /// /// 获取参数配置列表 /// /// [HttpGet("/sysConfig/list")] public async Task> GetConfigList() { return await _sysConfigRep.GetListAsync(); } /// /// 增加参数配置 /// /// /// [HttpPost("/sysConfig/add")] public async Task AddConfig(AddConfigInput input) { var isExist = await _sysConfigRep.IsAnyAsync(u => u.Name == input.Name || u.Code == input.Code); if (isExist) throw Oops.Oh(ErrorCodeEnum.D9000); await _sysConfigRep.InsertAsync(input.Adapt()); } /// /// 更新参数配置 /// /// /// [HttpPost("/sysConfig/update")] public async Task UpdateConfig(UpdateConfigInput input) { var isExist = await _sysConfigRep.IsAnyAsync(u => (u.Name == input.Name || u.Code == input.Code) && u.Id != input.Id); if (isExist) throw Oops.Oh(ErrorCodeEnum.D9000); var config = input.Adapt(); await _sysConfigRep.AsUpdateable(config).IgnoreColumns(true).ExecuteCommandAsync(); await _sysCacheService.DelCacheKey(config.Code); } /// /// 获取参数配置详情 /// /// /// [HttpGet("/sysConfig/detail")] public async Task GetConfig([FromQuery] ConfigInput input) { return await _sysConfigRep.GetFirstAsync(u => u.Id == input.Id); } /// /// 删除参数配置 /// /// /// [HttpPost("/sysConfig/delete")] public async Task DeleteConfig(DeleteConfigInput input) { var config = await _sysConfigRep.GetFirstAsync(u => u.Id == input.Id); if (config.SysFlag == YesNoEnum.Y) // 禁止删除系统参数 throw Oops.Oh(ErrorCodeEnum.D9001); await _sysConfigRep.DeleteAsync(config); await _sysCacheService.DelCacheKey(config.Code); } /// /// 获取参数配置缓存 /// /// /// [NonAction] public async Task GetConfigCache(string code) { var value = await _sysCacheService.GetStringAsync(code); if (string.IsNullOrEmpty(value)) { var config = await _sysConfigRep.GetFirstAsync(u => u.Code == code); value = config != null ? config.Value : ""; await _sysCacheService.SetStringAsync(code, value); } return value; } }