AdoS0MfgOrderScheduleCyclesController.cs 6.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129
  1. using Admin.NET.Plugin.AiDOP.Dto.S0.Manufacturing;
  2. using Admin.NET.Plugin.AiDOP.Entity.S0.Manufacturing;
  3. using Admin.NET.Plugin.AiDOP.Infrastructure;
  4. namespace Admin.NET.Plugin.AiDOP.Controllers.S0.Manufacturing;
  5. [ApiController]
  6. [Route("api/s0/manufacturing/order-schedule-cycles")]
  7. [NonUnify]
  8. public class AdoS0MfgOrderScheduleCyclesController : ControllerBase
  9. {
  10. private readonly SqlSugarRepository<AdoS0OrderScheduleCycle> _rep;
  11. public AdoS0MfgOrderScheduleCyclesController(SqlSugarRepository<AdoS0OrderScheduleCycle> rep) => _rep = rep;
  12. private static string NormalizeOrderType(string? orderType) => orderType?.Trim() ?? string.Empty;
  13. [HttpGet]
  14. public async Task<IActionResult> GetPagedAsync([FromQuery] AdoS0OrderScheduleCycleQueryDto q)
  15. {
  16. if (!AdoS0TenantScope.TryResolveRequired(out var tenantId, out var tenantError)) return tenantError!;
  17. var page = q.EffectivePage;
  18. var pageSize = q.PageSize;
  19. (page, pageSize) = PagingGuard.Normalize(page, pageSize);
  20. var query = _rep.AsQueryable()
  21. .Where(x => x.TenantId == tenantId)
  22. .WhereIF(q.CompanyRefId.HasValue, x => x.CompanyRefId == q.CompanyRefId!.Value)
  23. .WhereIF(q.FactoryRefId.HasValue, x => x.FactoryRefId == q.FactoryRefId!.Value)
  24. .WhereIF(!string.IsNullOrWhiteSpace(q.DomainCode), x => x.DomainCode == q.DomainCode)
  25. .WhereIF(!string.IsNullOrWhiteSpace(q.OrderType), x => x.OrderType == q.OrderType)
  26. .WhereIF(q.IsActive.HasValue, x => x.IsActive == q.IsActive.Value)
  27. .WhereIF(!string.IsNullOrWhiteSpace(q.Keyword),
  28. x => x.OrderType.Contains(q.Keyword!)
  29. || (x.DomainCode != null && x.DomainCode.Contains(q.Keyword!))
  30. || (x.Remarks != null && x.Remarks.Contains(q.Keyword!)));
  31. var total = await query.CountAsync();
  32. var list = await query.OrderByDescending(x => x.CreateTime).Skip((page - 1) * pageSize).Take(pageSize).ToListAsync();
  33. return Ok(new { total, page, pageSize, list });
  34. }
  35. [HttpGet("{id:long}")]
  36. public async Task<IActionResult> GetAsync(long id)
  37. {
  38. if (!AdoS0TenantScope.TryResolveRequired(out var tenantId, out var tenantError)) return tenantError!;
  39. var item = await _rep.AsQueryable().Where(x => x.Id == id && x.TenantId == tenantId).FirstAsync();
  40. return item == null ? NotFound() : Ok(item);
  41. }
  42. [HttpPost]
  43. public async Task<IActionResult> CreateAsync([FromBody] AdoS0OrderScheduleCycleUpsertDto dto)
  44. {
  45. if (!AdoS0TenantScope.TryResolveRequired(out var tenantId, out var tenantError)) return tenantError!;
  46. var (companyId, factoryId) = await AdoS0OrgScope.ResolveAsync(_rep.Context, tenantId);
  47. if (companyId <= 0 || factoryId <= 0) return AdoS0OrgScope.NotConfiguredError("订单排程周期");
  48. var orderType = NormalizeOrderType(dto.OrderType);
  49. if (await _rep.IsAnyAsync(x => x.TenantId == tenantId && x.FactoryRefId == factoryId && x.OrderType == orderType))
  50. return AdoS0ApiErrors.Conflict(AdoS0ErrorCodes.DuplicateCode, "该工厂与订单类型组合已存在订单排程周期标准");
  51. var now = DateTime.Now;
  52. var entity = new AdoS0OrderScheduleCycle
  53. {
  54. TenantId = tenantId,
  55. // 组织字段后端强制 stamp 当前租户内解析出的组织,忽略 payload 组织值(杜绝跨租户组织引用)。
  56. CompanyRefId = companyId,
  57. FactoryRefId = factoryId,
  58. DomainCode = dto.DomainCode,
  59. OrderType = orderType,
  60. StdHours = dto.StdHours,
  61. Remarks = dto.Remarks?.Trim(),
  62. IsActive = dto.IsActive,
  63. CreateUser = dto.CreateUser,
  64. CreateTime = now,
  65. UpdateUser = dto.UpdateUser,
  66. UpdateTime = null
  67. };
  68. await _rep.AsInsertable(entity).ExecuteReturnEntityAsync();
  69. return Ok(entity);
  70. }
  71. [HttpPut("{id:long}")]
  72. public async Task<IActionResult> UpdateAsync(long id, [FromBody] AdoS0OrderScheduleCycleUpsertDto dto)
  73. {
  74. if (!AdoS0TenantScope.TryResolveRequired(out var tenantId, out var tenantError)) return tenantError!;
  75. var entity = await _rep.AsQueryable().Where(x => x.Id == id && x.TenantId == tenantId).FirstAsync();
  76. if (entity == null) return NotFound();
  77. var orderType = NormalizeOrderType(dto.OrderType);
  78. if (await _rep.IsAnyAsync(x => x.TenantId == tenantId && x.Id != id && x.FactoryRefId == entity.FactoryRefId && x.OrderType == orderType))
  79. return AdoS0ApiErrors.Conflict(AdoS0ErrorCodes.DuplicateCode, "该工厂与订单类型组合已存在其他记录");
  80. // 组织字段 pin 到既有原值,忽略 payload 组织值:既杜绝篡改成他租户组织,
  81. // 也不因一次普通编辑就顺手迁移历史 CROSS-TENANT 存量。
  82. entity.DomainCode = dto.DomainCode;
  83. entity.OrderType = orderType;
  84. entity.StdHours = dto.StdHours;
  85. entity.Remarks = dto.Remarks?.Trim();
  86. entity.IsActive = dto.IsActive;
  87. entity.UpdateUser = dto.UpdateUser;
  88. entity.UpdateTime = DateTime.Now;
  89. await _rep.AsUpdateable(entity).ExecuteCommandAsync();
  90. return Ok(entity);
  91. }
  92. [HttpPatch("{id:long}/toggle-enabled")]
  93. public async Task<IActionResult> ToggleActiveAsync(long id, [FromBody] AdoS0OrderScheduleCycleToggleActiveDto dto)
  94. {
  95. if (!AdoS0TenantScope.TryResolveRequired(out var tenantId, out var tenantError)) return tenantError!;
  96. var entity = await _rep.AsQueryable().Where(x => x.Id == id && x.TenantId == tenantId).FirstAsync();
  97. if (entity == null) return NotFound();
  98. entity.IsActive = dto.IsEnabled;
  99. entity.UpdateTime = DateTime.Now;
  100. await _rep.AsUpdateable(entity).ExecuteCommandAsync();
  101. return Ok(entity);
  102. }
  103. [HttpDelete("{id:long}")]
  104. public async Task<IActionResult> DeleteAsync(long id)
  105. {
  106. if (!AdoS0TenantScope.TryResolveRequired(out var tenantId, out var tenantError)) return tenantError!;
  107. var item = await _rep.AsQueryable().Where(x => x.Id == id && x.TenantId == tenantId).FirstAsync();
  108. if (item == null) return NotFound();
  109. await _rep.DeleteAsync(item);
  110. return Ok(new { message = "删除成功" });
  111. }
  112. }