AdoS0MfgWorkCentersController.cs 4.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123
  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/work-centers")]
  8. [AllowAnonymous]
  9. [NonUnify]
  10. public class AdoS0MfgWorkCentersController : ControllerBase
  11. {
  12. private readonly SqlSugarRepository<AdoS0WorkCtrMaster> _rep;
  13. private readonly AdoS0ReferenceChecker _refChecker;
  14. public AdoS0MfgWorkCentersController(SqlSugarRepository<AdoS0WorkCtrMaster> rep, AdoS0ReferenceChecker refChecker)
  15. {
  16. _rep = rep;
  17. _refChecker = refChecker;
  18. }
  19. [HttpGet]
  20. public async Task<IActionResult> GetPagedAsync([FromQuery] AdoS0WorkCtrMasterQueryDto q)
  21. {
  22. var page = q.Page;
  23. var pageSize = q.PageSize;
  24. (page, pageSize) = PagingGuard.Normalize(page, pageSize);
  25. var domain = q.Domain.Trim();
  26. var query = _rep.AsQueryable()
  27. .Where(x => x.Domain == domain)
  28. .WhereIF(!string.IsNullOrWhiteSpace(q.Keyword),
  29. x => x.WorkCtr.Contains(q.Keyword!)
  30. || (x.Descr != null && x.Descr.Contains(q.Keyword!))
  31. || (x.Department != null && x.Department.Contains(q.Keyword!)));
  32. var total = await query.CountAsync();
  33. var list = await query
  34. .OrderByDescending(x => x.UpdateTime ?? x.CreateTime)
  35. .Skip((page - 1) * pageSize)
  36. .Take(pageSize)
  37. .ToListAsync();
  38. // DepartmentName:展示字段(源平台左联 DepartmentMaster);当前阶段无部门主数据表时返回占位空串。
  39. var shaped = list.Select(x => new
  40. {
  41. id = x.Id,
  42. workCtr = x.WorkCtr,
  43. descr = x.Descr,
  44. department = x.Department,
  45. departmentName = "",
  46. isActive = x.IsActive,
  47. domain = x.Domain,
  48. createUser = x.CreateUser,
  49. createTime = x.CreateTime,
  50. updateUser = x.UpdateUser,
  51. updateTime = x.UpdateTime,
  52. }).ToList();
  53. return Ok(new { total, page, pageSize, list = shaped });
  54. }
  55. [HttpGet("{id:long}")]
  56. public async Task<IActionResult> GetAsync(long id)
  57. {
  58. var item = await _rep.GetByIdAsync(id);
  59. return item == null ? NotFound() : Ok(item);
  60. }
  61. [HttpPost]
  62. public async Task<IActionResult> CreateAsync([FromBody] AdoS0WorkCtrMasterUpsertDto dto)
  63. {
  64. if (!await _refChecker.DepartmentExistsAsync(dto.Department))
  65. return AdoS0ApiErrors.InvalidReference(AdoS0ErrorCodes.ReferenceNotFound,
  66. $"部门编码 '{dto.Department}' 不存在于部门主数据");
  67. var now = DateTime.Now;
  68. var entity = new AdoS0WorkCtrMaster
  69. {
  70. WorkCtr = dto.WorkCtr.Trim(),
  71. Descr = dto.Descr,
  72. Department = dto.Department,
  73. IsActive = dto.IsActive,
  74. Domain = dto.Domain.Trim(),
  75. CreateUser = dto.CreateUser ?? dto.UpdateUser,
  76. CreateTime = dto.CreateTime ?? dto.UpdateTime ?? now,
  77. UpdateUser = dto.UpdateUser,
  78. UpdateTime = dto.UpdateTime
  79. };
  80. await _rep.AsInsertable(entity).ExecuteReturnEntityAsync();
  81. return Ok(entity);
  82. }
  83. [HttpPut("{id:long}")]
  84. public async Task<IActionResult> UpdateAsync(long id, [FromBody] AdoS0WorkCtrMasterUpsertDto dto)
  85. {
  86. if (!await _refChecker.DepartmentExistsAsync(dto.Department))
  87. return AdoS0ApiErrors.InvalidReference(AdoS0ErrorCodes.ReferenceNotFound,
  88. $"部门编码 '{dto.Department}' 不存在于部门主数据");
  89. var entity = await _rep.GetByIdAsync(id);
  90. if (entity == null) return NotFound();
  91. entity.WorkCtr = dto.WorkCtr.Trim();
  92. entity.Descr = dto.Descr;
  93. entity.Department = dto.Department;
  94. entity.IsActive = dto.IsActive;
  95. entity.Domain = dto.Domain.Trim();
  96. entity.UpdateUser = dto.UpdateUser;
  97. entity.UpdateTime = dto.UpdateTime ?? DateTime.Now;
  98. await _rep.AsUpdateable(entity).ExecuteCommandAsync();
  99. return Ok(entity);
  100. }
  101. [HttpDelete("{id:long}")]
  102. public async Task<IActionResult> DeleteAsync(long id)
  103. {
  104. var item = await _rep.GetByIdAsync(id);
  105. if (item == null) return NotFound();
  106. await _rep.DeleteAsync(item);
  107. return Ok(new { message = "删除成功" });
  108. }
  109. }