S8WatchRuleService.cs 6.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145
  1. using System.Text.Json;
  2. using Admin.NET.Plugin.AiDOP.Entity.S8;
  3. using Admin.NET.Plugin.AiDOP.Service.S8.Rules;
  4. namespace Admin.NET.Plugin.AiDOP.Service.S8;
  5. public class S8WatchRuleService : ITransient
  6. {
  7. private readonly SqlSugarRepository<AdoS8WatchRule> _rep;
  8. private readonly SqlSugarRepository<AdoS8DataSource> _dataSourceRep;
  9. private readonly SqlSugarRepository<AdoS8SceneConfig> _sceneRep;
  10. public S8WatchRuleService(
  11. SqlSugarRepository<AdoS8WatchRule> rep,
  12. SqlSugarRepository<AdoS8DataSource> dataSourceRep,
  13. SqlSugarRepository<AdoS8SceneConfig> sceneRep)
  14. {
  15. _rep = rep;
  16. _dataSourceRep = dataSourceRep;
  17. _sceneRep = sceneRep;
  18. }
  19. public async Task<List<AdoS8WatchRule>> ListAsync(long tenantId, long factoryId) =>
  20. await _rep.AsQueryable()
  21. .Where(x => x.TenantId == tenantId && x.FactoryId == factoryId)
  22. .ToListAsync();
  23. public async Task<AdoS8WatchRule> CreateAsync(AdoS8WatchRule body)
  24. {
  25. await ValidateAsync(body);
  26. body.Id = 0;
  27. body.CreatedAt = DateTime.Now;
  28. await _rep.InsertAsync(body);
  29. return body;
  30. }
  31. public async Task<AdoS8WatchRule> UpdateAsync(long id, AdoS8WatchRule body)
  32. {
  33. var e = await _rep.GetByIdAsync(id) ?? throw new S8BizException("记录不存在");
  34. await ValidateAsync(body, id);
  35. body.Id = id;
  36. body.CreatedAt = e.CreatedAt;
  37. body.UpdatedAt = DateTime.Now;
  38. await _rep.UpdateAsync(body);
  39. return body;
  40. }
  41. public async Task DeleteAsync(long id) => await _rep.DeleteByIdAsync(id);
  42. /// <summary>
  43. /// R4 安全更新:只更新 params_json 与 enabled。expression / rule_code / data_source_id /
  44. /// scene_code / watch_object_type / rule_type / source_object_type 一律不通过此路径修改。
  45. /// 当 RuleType 非空时,按对应 evaluator 的 Params.Parse 进行 schema 校验,解析失败抛 S8BizException。
  46. /// </summary>
  47. public async Task<AdoS8WatchRule> UpdateParamsAsync(long id, S8WatchRuleParamsPayload payload)
  48. {
  49. var entity = await _rep.GetByIdAsync(id) ?? throw new S8BizException("记录不存在");
  50. var paramsJson = payload.ParamsJson?.Trim();
  51. if (!string.IsNullOrEmpty(paramsJson))
  52. {
  53. ValidateParamsJsonByRuleType(entity.RuleType, paramsJson);
  54. }
  55. entity.ParamsJson = string.IsNullOrEmpty(paramsJson) ? null : paramsJson;
  56. entity.Enabled = payload.Enabled;
  57. entity.UpdatedAt = DateTime.Now;
  58. await _rep.UpdateAsync(entity);
  59. return entity;
  60. }
  61. private static void ValidateParamsJsonByRuleType(string? ruleType, string paramsJson)
  62. {
  63. try
  64. {
  65. switch (ruleType)
  66. {
  67. case S8TimeoutRuleEvaluator.RuleTypeCode:
  68. {
  69. var p = S8TimeoutParams.Parse(paramsJson);
  70. if (string.IsNullOrWhiteSpace(p.DueAtField)
  71. || string.IsNullOrWhiteSpace(p.StatusField)
  72. || string.IsNullOrWhiteSpace(p.ExceptionTypeCode))
  73. throw new S8BizException("TIMEOUT params 缺少必填字段:dueAtField / statusField / exceptionTypeCode");
  74. break;
  75. }
  76. case S8ShortageRuleEvaluator.RuleTypeCode:
  77. {
  78. var p = S8ShortageParams.Parse(paramsJson);
  79. if (string.IsNullOrWhiteSpace(p.TargetQtyField)
  80. || string.IsNullOrWhiteSpace(p.ActualQtyField)
  81. || string.IsNullOrWhiteSpace(p.ExceptionTypeCode))
  82. throw new S8BizException("SHORTAGE params 缺少必填字段:targetQtyField / actualQtyField / exceptionTypeCode");
  83. break;
  84. }
  85. case S8OutOfRangeRuleEvaluator.RuleTypeCode:
  86. {
  87. var p = S8OutOfRangeParams.Parse(paramsJson);
  88. if (string.IsNullOrWhiteSpace(p.MeasuredValueField))
  89. throw new S8BizException("OUT_OF_RANGE params 缺少必填字段:measuredValueField");
  90. if (p.LowerBound == null && p.UpperBound == null
  91. && string.IsNullOrWhiteSpace(p.LowerBoundField)
  92. && string.IsNullOrWhiteSpace(p.UpperBoundField))
  93. throw new S8BizException("OUT_OF_RANGE params 必须提供 upperBound / lowerBound 或对应行内字段之一");
  94. break;
  95. }
  96. default:
  97. // RuleType 为空或非三类已知值:仅做 JSON 合法性校验,避免阻塞历史数据。
  98. using (JsonDocument.Parse(paramsJson)) { }
  99. break;
  100. }
  101. }
  102. catch (JsonException ex)
  103. {
  104. throw new S8BizException($"params_json 不是合法 JSON:{ex.Message}");
  105. }
  106. }
  107. public async Task<object> TestAsync(long id)
  108. {
  109. var entity = await _rep.GetByIdAsync(id) ?? throw new S8BizException("记录不存在");
  110. await ValidateAsync(entity, id);
  111. return new { id, success = true, message = "规则基础校验通过", pollIntervalSeconds = entity.PollIntervalSeconds };
  112. }
  113. private async Task ValidateAsync(AdoS8WatchRule body, long? id = null)
  114. {
  115. if (string.IsNullOrWhiteSpace(body.RuleCode) || string.IsNullOrWhiteSpace(body.SceneCode))
  116. throw new S8BizException("规则编码和场景编码必填");
  117. var exists = await _rep.AsQueryable()
  118. .AnyAsync(x => x.Id != (id ?? 0) && x.TenantId == body.TenantId && x.FactoryId == body.FactoryId && x.RuleCode == body.RuleCode);
  119. if (exists) throw new S8BizException("监视规则编码已存在");
  120. var dataSource = await _dataSourceRep.GetFirstAsync(x => x.Id == body.DataSourceId)
  121. ?? throw new S8BizException("关联数据源不存在");
  122. if (!dataSource.Enabled) throw new S8BizException("关联数据源未启用");
  123. var scene = await _sceneRep.GetFirstAsync(x => x.TenantId == body.TenantId && x.FactoryId == body.FactoryId && x.SceneCode == body.SceneCode)
  124. ?? throw new S8BizException("关联场景不存在");
  125. if (!scene.Enabled) throw new S8BizException("关联场景未启用");
  126. if (body.PollIntervalSeconds <= 0) throw new S8BizException("轮询间隔必须大于 0");
  127. }
  128. }