// Admin.NET 项目的版权、商标、专利和其他相关权利均受相应法律法规的保护。使用本项目应遵守相关法律法规和许可证的要求。 // // 本项目主要遵循 MIT 许可证和 Apache 许可证(版本 2.0)进行分发和使用。许可证位于源代码树根目录中的 LICENSE-MIT 和 LICENSE-APACHE 文件。 // // 不得利用本项目从事危害国家安全、扰乱社会秩序、侵犯他人合法权益等法律法规禁止的活动!任何基于本项目二次开发而产生的一切法律纠纷和责任,我们不承担任何责任! namespace Admin.NET.Core.Service; /// /// 系统租户配置参数服务 🧩 /// [ApiDescriptionSettings(Order = 440, Description = "租户配置参数")] public class SysConfigTenantService : IDynamicApiController, ITransient { private readonly SysCacheService _sysCacheService; private readonly SqlSugarRepository _sysConfigRep; public SysConfigTenantService(SysCacheService sysCacheService, SqlSugarRepository sysConfigRep) { _sysCacheService = sysCacheService; _sysConfigRep = sysConfigRep; } /// /// 获取配置参数分页列表 🔖 /// /// /// [DisplayName("获取配置参数分页列表")] public async Task> Page(PageConfigTenantInput 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)) .WhereIF(!string.IsNullOrWhiteSpace(input.GroupCode?.Trim()), u => u.GroupCode.Equals(input.GroupCode)) .OrderBuilder(input) .ToPagedListAsync(input.Page, input.PageSize); } /// /// 获取配置参数列表 🔖 /// /// [DisplayName("获取配置参数列表")] public async Task> List(PageConfigTenantInput input) { return await _sysConfigRep.AsQueryable() .WhereIF(!string.IsNullOrWhiteSpace(input.GroupCode?.Trim()), u => u.GroupCode.Equals(input.GroupCode)) .ToListAsync(); } /// /// 增加配置参数 🔖 /// /// /// [ApiDescriptionSettings(Name = "Add"), HttpPost] [DisplayName("增加配置参数")] public async Task AddConfig(AddConfigTenantInput 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()); } /// /// 更新配置参数 🔖 /// /// /// [ApiDescriptionSettings(Name = "Update"), HttpPost] [DisplayName("更新配置参数")] [UnitOfWork] public async Task UpdateConfig(UpdateConfigTenantInput 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); //// 若修改国密SM2密匙则密码重新加密 //if (input.Code == ConfigConst.SysSM2Key && CryptogramUtil.CryptoType == CryptogramEnum.SM2.ToString()) //{ // var sysUserRep = _sysConfigRep.ChangeRepository>(); // var sysUsers = await sysUserRep.AsQueryable().Select(u => new { u.Id, u.Password }).ToListAsync(); // foreach(var user in sysUsers) // { // user.Password = CryptogramUtil.Encrypt(CryptogramUtil.Decrypt(user.Password)); // } // await sysUserRep.AsUpdateable(sysUsers).UpdateColumns(u => new { u.Password }).ExecuteCommandAsync(); //} var config = input.Adapt(); await _sysConfigRep.AsUpdateable(config).IgnoreColumns(true).ExecuteCommandAsync(); RemoveConfigCache(config); } /// /// 删除配置参数 🔖 /// /// /// [ApiDescriptionSettings(Name = "Delete"), HttpPost] [DisplayName("删除配置参数")] public async Task DeleteConfig(DeleteConfigTenantInput input) { var config = await _sysConfigRep.GetByIdAsync(input.Id); // 禁止删除系统参数 if (config.SysFlag == YesNoEnum.Y) throw Oops.Oh(ErrorCodeEnum.D9001); await _sysConfigRep.DeleteAsync(config); RemoveConfigCache(config); } /// /// 批量删除配置参数 🔖 /// /// /// [ApiDescriptionSettings(Name = "BatchDelete"), HttpPost] [DisplayName("批量删除配置参数")] public async Task BatchDeleteConfig(List ids) { foreach (var id in ids) { var config = await _sysConfigRep.GetByIdAsync(id); // 禁止删除系统参数 if (config.SysFlag == YesNoEnum.Y) continue; await _sysConfigRep.DeleteAsync(config); RemoveConfigCache(config); } } /// /// 获取配置参数详情 🔖 /// /// /// [DisplayName("获取配置参数详情")] public async Task GetDetail([FromQuery] ConfigTenantInput input) { return await _sysConfigRep.GetByIdAsync(input.Id); } /// /// 根据Code获取配置参数 /// /// /// [NonAction] public async Task GetConfig(string code) { return await _sysConfigRep.GetFirstAsync(u => u.Code == code); } /// /// 根据Code获取配置参数值 🔖 /// /// /// [DisplayName("根据Code获取配置参数值")] public async Task GetConfigValueByCode(string code) { return await GetConfigValueByCode(code); } /// /// 获取配置参数值 /// /// /// [NonAction] public async Task GetConfigValueByCode(string code) { if (string.IsNullOrWhiteSpace(code)) return default; var value = _sysCacheService.Get($"{CacheConst.KeyConfig}{code}"); if (string.IsNullOrEmpty(value)) { value = (await _sysConfigRep.CopyNew().GetFirstAsync(u => u.Code == code))?.Value; _sysCacheService.Set($"{CacheConst.KeyConfig}{code}", value); } if (string.IsNullOrWhiteSpace(value)) return default; return (T)Convert.ChangeType(value, typeof(T)); } /// /// 更新配置参数值 /// /// /// /// [NonAction] public async Task UpdateConfigValue(string code, string value) { var config = await _sysConfigRep.GetFirstAsync(u => u.Code == code); if (config == null) return; config.Value = value; await _sysConfigRep.AsUpdateable(config).ExecuteCommandAsync(); RemoveConfigCache(config); } /// /// 获取分组列表 🔖 /// /// [DisplayName("获取分组列表")] public async Task> GetGroupList() { return await _sysConfigRep.AsQueryable() .GroupBy(u => u.GroupCode) .Select(u => u.GroupCode).ToListAsync(); } /// /// 批量更新配置参数值 🔖 /// /// /// [ApiDescriptionSettings(Name = "BatchUpdate"), HttpPost] [DisplayName("批量更新配置参数值")] public async Task BatchUpdateConfig(List input) { foreach (var config in input) { var configInfo = await _sysConfigRep.GetFirstAsync(u => u.Code == config.Code); if (configInfo == null) continue; await _sysConfigRep.AsUpdateable().SetColumns(u => u.Value == config.Value).Where(u => u.Code == config.Code).ExecuteCommandAsync(); RemoveConfigCache(configInfo); } } /// /// 清除配置缓存 /// /// private void RemoveConfigCache(SysConfigTenant config) { _sysCacheService.Remove($"{CacheConst.KeyConfig}Value:{config.Code}"); _sysCacheService.Remove($"{CacheConst.KeyConfig}Remark:{config.Code}"); _sysCacheService.Remove($"{CacheConst.KeyConfig}{config.GroupCode}:GroupWithCache"); _sysCacheService.Remove($"{CacheConst.KeyConfig}{config.Code}"); } }