AdoS0MfgOrderScheduleCyclesController.cs 4.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118
  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. [AllowAnonymous]
  8. [NonUnify]
  9. public class AdoS0MfgOrderScheduleCyclesController : ControllerBase
  10. {
  11. private readonly SqlSugarRepository<AdoS0OrderScheduleCycle> _rep;
  12. public AdoS0MfgOrderScheduleCyclesController(SqlSugarRepository<AdoS0OrderScheduleCycle> rep) => _rep = rep;
  13. private static string NormalizeOrderType(string? orderType) => orderType?.Trim() ?? string.Empty;
  14. [HttpGet]
  15. public async Task<IActionResult> GetPagedAsync([FromQuery] AdoS0OrderScheduleCycleQueryDto q)
  16. {
  17. var page = q.EffectivePage;
  18. var pageSize = q.PageSize;
  19. (page, pageSize) = PagingGuard.Normalize(page, pageSize);
  20. var query = _rep.AsQueryable()
  21. .WhereIF(q.CompanyRefId.HasValue, x => x.CompanyRefId == q.CompanyRefId!.Value)
  22. .WhereIF(q.FactoryRefId.HasValue, x => x.FactoryRefId == q.FactoryRefId!.Value)
  23. .WhereIF(!string.IsNullOrWhiteSpace(q.DomainCode), x => x.DomainCode == q.DomainCode)
  24. .WhereIF(!string.IsNullOrWhiteSpace(q.OrderType), x => x.OrderType == q.OrderType)
  25. .WhereIF(q.IsActive.HasValue, x => x.IsActive == q.IsActive.Value)
  26. .WhereIF(!string.IsNullOrWhiteSpace(q.Keyword),
  27. x => x.OrderType.Contains(q.Keyword!)
  28. || (x.DomainCode != null && x.DomainCode.Contains(q.Keyword!))
  29. || (x.Remarks != null && x.Remarks.Contains(q.Keyword!)));
  30. var total = await query.CountAsync();
  31. var list = await query.OrderByDescending(x => x.CreateTime).Skip((page - 1) * pageSize).Take(pageSize).ToListAsync();
  32. return Ok(new { total, page, pageSize, list });
  33. }
  34. [HttpGet("{id:long}")]
  35. public async Task<IActionResult> GetAsync(long id)
  36. {
  37. var item = await _rep.GetByIdAsync(id);
  38. return item == null ? NotFound() : Ok(item);
  39. }
  40. [HttpPost]
  41. public async Task<IActionResult> CreateAsync([FromBody] AdoS0OrderScheduleCycleUpsertDto dto)
  42. {
  43. var orderType = NormalizeOrderType(dto.OrderType);
  44. if (await _rep.IsAnyAsync(x => x.FactoryRefId == dto.FactoryRefId && x.OrderType == orderType))
  45. return AdoS0ApiErrors.Conflict(AdoS0ErrorCodes.DuplicateCode, "该工厂与订单类型组合已存在订单排程周期标准");
  46. var now = DateTime.Now;
  47. var entity = new AdoS0OrderScheduleCycle
  48. {
  49. CompanyRefId = dto.CompanyRefId,
  50. FactoryRefId = dto.FactoryRefId,
  51. DomainCode = dto.DomainCode,
  52. OrderType = orderType,
  53. StdHours = dto.StdHours,
  54. Remarks = dto.Remarks?.Trim(),
  55. IsActive = dto.IsActive,
  56. CreateUser = dto.CreateUser,
  57. CreateTime = now,
  58. UpdateUser = dto.UpdateUser,
  59. UpdateTime = null
  60. };
  61. await _rep.AsInsertable(entity).ExecuteReturnEntityAsync();
  62. return Ok(entity);
  63. }
  64. [HttpPut("{id:long}")]
  65. public async Task<IActionResult> UpdateAsync(long id, [FromBody] AdoS0OrderScheduleCycleUpsertDto dto)
  66. {
  67. var entity = await _rep.GetByIdAsync(id);
  68. if (entity == null) return NotFound();
  69. var orderType = NormalizeOrderType(dto.OrderType);
  70. if (await _rep.IsAnyAsync(x => x.Id != id && x.FactoryRefId == dto.FactoryRefId && x.OrderType == orderType))
  71. return AdoS0ApiErrors.Conflict(AdoS0ErrorCodes.DuplicateCode, "该工厂与订单类型组合已存在其他记录");
  72. entity.CompanyRefId = dto.CompanyRefId;
  73. entity.FactoryRefId = dto.FactoryRefId;
  74. entity.DomainCode = dto.DomainCode;
  75. entity.OrderType = orderType;
  76. entity.StdHours = dto.StdHours;
  77. entity.Remarks = dto.Remarks?.Trim();
  78. entity.IsActive = dto.IsActive;
  79. entity.UpdateUser = dto.UpdateUser;
  80. entity.UpdateTime = DateTime.Now;
  81. await _rep.AsUpdateable(entity).ExecuteCommandAsync();
  82. return Ok(entity);
  83. }
  84. [HttpPatch("{id:long}/toggle-enabled")]
  85. public async Task<IActionResult> ToggleActiveAsync(long id, [FromBody] AdoS0OrderScheduleCycleToggleActiveDto dto)
  86. {
  87. var entity = await _rep.GetByIdAsync(id);
  88. if (entity == null) return NotFound();
  89. entity.IsActive = dto.IsEnabled;
  90. entity.UpdateTime = DateTime.Now;
  91. await _rep.AsUpdateable(entity).ExecuteCommandAsync();
  92. return Ok(entity);
  93. }
  94. [HttpDelete("{id:long}")]
  95. public async Task<IActionResult> DeleteAsync(long id)
  96. {
  97. var item = await _rep.GetByIdAsync(id);
  98. if (item == null) return NotFound();
  99. await _rep.DeleteAsync(item);
  100. return Ok(new { message = "删除成功" });
  101. }
  102. }