AdoS0MfgElementParamsController.cs 4.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120
  1. using Admin.NET.Plugin.AiDOP.Dto.S0.Manufacturing;
  2. using Admin.NET.Plugin.AiDOP.Dto.S0.Sales;
  3. using Admin.NET.Plugin.AiDOP.Entity.S0.Manufacturing;
  4. using Admin.NET.Plugin.AiDOP.Infrastructure;
  5. namespace Admin.NET.Plugin.AiDOP.Controllers.S0.Manufacturing;
  6. [ApiController]
  7. [Route("api/s0/manufacturing/element-params")]
  8. [NonUnify]
  9. public class AdoS0MfgElementParamsController : ControllerBase
  10. {
  11. private readonly SqlSugarRepository<AdoS0DevMonitor> _rep;
  12. public AdoS0MfgElementParamsController(SqlSugarRepository<AdoS0DevMonitor> rep)
  13. {
  14. _rep = rep;
  15. }
  16. [HttpGet]
  17. public async Task<IActionResult> GetPagedAsync([FromQuery] AdoS0DevMonitorQueryDto q)
  18. {
  19. if (!AdoS0TenantScope.TryResolveRequired(out var tenantId, out var tenantError)) return tenantError!;
  20. var page = q.Page;
  21. var pageSize = q.PageSize;
  22. (page, pageSize) = PagingGuard.Normalize(page, pageSize);
  23. // 去 domain 化(S0-DOMAIN-FILTER-REMOVAL-READONLY-1):不再按 Domain 过滤,租户隔离由实体 ITenantIdFilter 自动生效;保留 CodeType 业务条件。
  24. var query = _rep.ScopedTo(tenantId)
  25. .WhereIF(!string.IsNullOrWhiteSpace(q.Keyword),
  26. x => x.DeviceNumber.Contains(q.Keyword!)
  27. || (x.DeviceDescr != null && x.DeviceDescr.Contains(q.Keyword!))
  28. || x.MessageCode.Contains(q.Keyword!)
  29. || (x.CodeDescr != null && x.CodeDescr.Contains(q.Keyword!)))
  30. .Where(x => x.CodeType == "Prod");
  31. var total = await query.CountAsync();
  32. var list = await query
  33. .OrderByDescending(x => x.UpdateTime ?? x.CreateTime)
  34. .Skip((page - 1) * pageSize)
  35. .Take(pageSize)
  36. .ToListAsync();
  37. return Ok(new { total, page, pageSize, list });
  38. }
  39. [HttpGet("{id:long}")]
  40. public async Task<IActionResult> GetAsync(long id)
  41. {
  42. if (!AdoS0TenantScope.TryResolveRequired(out var tenantId, out var tenantError)) return tenantError!;
  43. var item = await _rep.ByIdScopedAsync(id, tenantId);
  44. return item == null ? NotFound() : Ok(item);
  45. }
  46. [HttpPost]
  47. public async Task<IActionResult> CreateAsync([FromBody] AdoS0DevMonitorUpsertDto dto)
  48. {
  49. if (!AdoS0TenantScope.TryResolveRequired(out var tenantId, out var tenantError)) return tenantError!;
  50. var now = DateTime.Now;
  51. var entity = new AdoS0DevMonitor
  52. {
  53. TenantId = tenantId,
  54. Domain = dto.Domain.Trim(),
  55. CodeType = "Prod",
  56. DeviceNumber = dto.DeviceNumber.Trim(),
  57. DeviceDescr = dto.DeviceDescr,
  58. MessageCode = dto.MessageCode.Trim(),
  59. CodeDescr = dto.CodeDescr,
  60. ValueType = dto.ValueType,
  61. UM = dto.UM,
  62. StdValue = dto.StdValue,
  63. TopLimit = dto.TopLimit,
  64. LowLimit = dto.LowLimit,
  65. Ufld1 = dto.Ufld1,
  66. CreateUser = dto.CreateUser ?? dto.UpdateUser,
  67. CreateTime = dto.CreateTime ?? dto.UpdateTime ?? now,
  68. UpdateUser = dto.UpdateUser,
  69. UpdateTime = dto.UpdateTime
  70. };
  71. await _rep.AsInsertable(entity).ExecuteReturnEntityAsync();
  72. return Ok(entity);
  73. }
  74. [HttpPut("{id:long}")]
  75. public async Task<IActionResult> UpdateAsync(long id, [FromBody] AdoS0DevMonitorUpsertDto dto)
  76. {
  77. if (!AdoS0TenantScope.TryResolveRequired(out var tenantId, out var tenantError)) return tenantError!;
  78. var entity = await _rep.ByIdScopedAsync(id, tenantId);
  79. if (entity == null) return NotFound();
  80. entity.Domain = dto.Domain.Trim();
  81. entity.CodeType = "Prod";
  82. entity.DeviceNumber = dto.DeviceNumber.Trim();
  83. entity.DeviceDescr = dto.DeviceDescr;
  84. entity.MessageCode = dto.MessageCode.Trim();
  85. entity.CodeDescr = dto.CodeDescr;
  86. entity.ValueType = dto.ValueType;
  87. entity.UM = dto.UM;
  88. entity.StdValue = dto.StdValue;
  89. entity.TopLimit = dto.TopLimit;
  90. entity.LowLimit = dto.LowLimit;
  91. entity.Ufld1 = dto.Ufld1;
  92. entity.UpdateUser = dto.UpdateUser;
  93. entity.UpdateTime = dto.UpdateTime ?? DateTime.Now;
  94. await _rep.AsUpdateable(entity).ExecuteCommandAsync();
  95. return Ok(entity);
  96. }
  97. [HttpDelete("{id:long}")]
  98. public async Task<IActionResult> DeleteAsync(long id)
  99. {
  100. if (!AdoS0TenantScope.TryResolveRequired(out var tenantId, out var tenantError)) return tenantError!;
  101. var item = await _rep.ByIdScopedAsync(id, tenantId);
  102. if (item == null) return NotFound();
  103. await _rep.DeleteAsync(item);
  104. return Ok(new { message = "删除成功" });
  105. }
  106. }