using Furion.DependencyInjection;
using Furion.DynamicApiController;
using Furion.FriendlyException;
using Mapster;
using Microsoft.AspNetCore.Mvc;
using System.Collections.Generic;
using System.Threading.Tasks;
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/pageList")]
public async Task> GetConfigPageList([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);
var config = input.Adapt();
await _sysConfigRep.InsertAsync(config);
}
///
/// 更新参数配置
///
///
///
[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);
}
///
/// 获取参数配置缓存
///
///
///
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;
}
}
}