AdoS0MfgWorkCentersController.cs 3.9 KB

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