SysConfigController.cs 5.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160
  1. using Infrastructure;
  2. using Infrastructure.Attribute;
  3. using Infrastructure.Enums;
  4. using Infrastructure.Extensions;
  5. using Infrastructure.Model;
  6. using Mapster;
  7. using Microsoft.AspNetCore.Authorization;
  8. using Microsoft.AspNetCore.Mvc;
  9. using SqlSugar;
  10. using ZR.Admin.WebApi.Extensions;
  11. using ZR.Admin.WebApi.Filters;
  12. using ZR.Common;
  13. using ZR.Model.Dto;
  14. using ZR.Model.System;
  15. using ZR.Model.System.Dto;
  16. using ZR.Service.System;
  17. namespace ZR.Admin.WebApi.Controllers
  18. {
  19. /// <summary>
  20. /// 参数配置Controller
  21. /// </summary>
  22. [Verify]
  23. [Route("system/config")]
  24. public class SysConfigController : BaseController
  25. {
  26. /// <summary>
  27. /// 参数配置接口
  28. /// </summary>
  29. private readonly ISysConfigService _SysConfigService;
  30. public SysConfigController(ISysConfigService SysConfigService)
  31. {
  32. _SysConfigService = SysConfigService;
  33. }
  34. /// <summary>
  35. /// 查询参数配置列表
  36. /// </summary>
  37. /// <returns></returns>
  38. [HttpGet("list")]
  39. [ActionPermissionFilter(Permission = "system:config:list")]
  40. public IActionResult QuerySysConfig([FromQuery] SysConfigQueryDto parm)
  41. {
  42. var predicate = Expressionable.Create<SysConfig>();
  43. predicate = predicate.AndIF(!parm.ConfigType.IsEmpty(), m => m.ConfigType == parm.ConfigType);
  44. predicate = predicate.AndIF(!parm.ConfigName.IsEmpty(), m => m.ConfigName.Contains(parm.ConfigType));
  45. predicate = predicate.AndIF(!parm.ConfigKey.IsEmpty(), m => m.ConfigKey.Contains(parm.ConfigKey));
  46. predicate = predicate.AndIF(!parm.BeginTime.IsEmpty(), m => m.Create_time >= parm.BeginTime);
  47. predicate = predicate.AndIF(!parm.BeginTime.IsEmpty(), m => m.Create_time <= parm.EndTime);
  48. var response = _SysConfigService.GetPages(predicate.ToExpression(), parm);
  49. return SUCCESS(response);
  50. }
  51. /// <summary>
  52. /// 查询参数配置详情
  53. /// </summary>
  54. /// <param name="ConfigId"></param>
  55. /// <returns></returns>
  56. [HttpGet("{ConfigId}")]
  57. [ActionPermissionFilter(Permission = "system:config:query")]
  58. public IActionResult GetSysConfig(int ConfigId)
  59. {
  60. var response = _SysConfigService.GetId(ConfigId);
  61. return SUCCESS(response);
  62. }
  63. /// <summary>
  64. /// 根据参数键名查询参数值
  65. /// </summary>
  66. /// <param name="configKey"></param>
  67. /// <returns></returns>
  68. [HttpGet("configKey/{configKey}")]
  69. [AllowAnonymous]
  70. public IActionResult GetConfigKey(string configKey)
  71. {
  72. var response = _SysConfigService.Queryable().First(f => f.ConfigKey == configKey);
  73. return SUCCESS(response?.ConfigValue);
  74. }
  75. /// <summary>
  76. /// 添加参数配置
  77. /// </summary>
  78. /// <returns></returns>
  79. [HttpPost]
  80. [ActionPermissionFilter(Permission = "system:config:add")]
  81. [Log(Title = "参数配置添加", BusinessType = BusinessType.INSERT)]
  82. public IActionResult AddSysConfig([FromBody] SysConfigDto parm)
  83. {
  84. if (parm == null)
  85. {
  86. throw new CustomException("请求参数错误");
  87. }
  88. var model = parm.Adapt<SysConfig>().ToCreate(HttpContext);
  89. return SUCCESS(_SysConfigService.Insert(model, it => new
  90. {
  91. it.ConfigName,
  92. it.ConfigKey,
  93. it.ConfigValue,
  94. it.ConfigType,
  95. it.Create_by,
  96. it.Create_time,
  97. it.Remark,
  98. }));
  99. }
  100. /// <summary>
  101. /// 更新参数配置
  102. /// </summary>
  103. /// <returns></returns>
  104. [HttpPut]
  105. [ActionPermissionFilter(Permission = "system:config:update")]
  106. [Log(Title = "参数配置修改", BusinessType = BusinessType.UPDATE)]
  107. public IActionResult UpdateSysConfig([FromBody] SysConfigDto parm)
  108. {
  109. if (parm == null)
  110. {
  111. throw new CustomException("请求实体不能为空");
  112. }
  113. var model = parm.Adapt<SysConfig>().ToUpdate(HttpContext);
  114. var response = _SysConfigService.Update(w => w.ConfigId == model.ConfigId, it => new SysConfig()
  115. {
  116. ConfigName = model.ConfigName,
  117. ConfigKey = model.ConfigKey,
  118. ConfigValue = model.ConfigValue,
  119. ConfigType = model.ConfigType,
  120. Update_by = model.Update_by,
  121. Update_time = model.Update_time,
  122. Remark = model.Remark
  123. });
  124. return SUCCESS(response);
  125. }
  126. /// <summary>
  127. /// 删除参数配置
  128. /// </summary>
  129. /// <returns></returns>
  130. [HttpDelete("{ids}")]
  131. [ActionPermissionFilter(Permission = "system:config:remove")]
  132. [Log(Title = "参数配置删除", BusinessType = BusinessType.DELETE)]
  133. public IActionResult DeleteSysConfig(string ids)
  134. {
  135. int[] idsArr = Tools.SpitIntArrary(ids);
  136. if (idsArr.Length <= 0) { return ToResponse(ApiResult.Error($"删除失败Id 不能为空")); }
  137. int sysCount = _SysConfigService.Count(s => s.ConfigType == "Y" && idsArr.Contains(s.ConfigId));
  138. if (sysCount > 0) { return ToResponse(ApiResult.Error($"删除失败Id: 系统内置参数不能删除!")); }
  139. var response = _SysConfigService.Delete(idsArr);
  140. return SUCCESS(response);
  141. }
  142. }
  143. }