using Admin.NET.Plugin.AiDOP.Dto.S0.Manufacturing; using Admin.NET.Plugin.AiDOP.Dto.S0.Sales; using Admin.NET.Plugin.AiDOP.Entity.S0.Manufacturing; using Admin.NET.Plugin.AiDOP.Infrastructure; namespace Admin.NET.Plugin.AiDOP.Controllers.S0.Manufacturing; [ApiController] [Route("api/s0/manufacturing/work-centers")] [AllowAnonymous] [NonUnify] public class AdoS0MfgWorkCentersController : ControllerBase { private readonly SqlSugarRepository _rep; public AdoS0MfgWorkCentersController(SqlSugarRepository rep) { _rep = rep; } [HttpGet] public async Task GetPagedAsync([FromQuery] AdoS0WorkCtrMasterQueryDto q) { var page = q.Page; var pageSize = q.PageSize; (page, pageSize) = PagingGuard.Normalize(page, pageSize); var domain = q.Domain.Trim(); var query = _rep.AsQueryable() .Where(x => x.Domain == domain) .WhereIF(!string.IsNullOrWhiteSpace(q.Keyword), x => x.WorkCtr.Contains(q.Keyword!) || (x.Descr != null && x.Descr.Contains(q.Keyword!)) || (x.Department != null && x.Department.Contains(q.Keyword!))); var total = await query.CountAsync(); var list = await query .OrderByDescending(x => x.UpdateTime ?? x.CreateTime) .Skip((page - 1) * pageSize) .Take(pageSize) .ToListAsync(); // DepartmentName:展示字段(源平台左联 DepartmentMaster);当前阶段无部门主数据表时返回占位空串。 var shaped = list.Select(x => new { id = x.Id, workCtr = x.WorkCtr, descr = x.Descr, department = x.Department, departmentName = "", isActive = x.IsActive, domain = x.Domain, createUser = x.CreateUser, createTime = x.CreateTime, updateUser = x.UpdateUser, updateTime = x.UpdateTime, }).ToList(); return Ok(new { total, page, pageSize, list = shaped }); } [HttpGet("{id:long}")] public async Task GetAsync(long id) { var item = await _rep.GetByIdAsync(id); return item == null ? NotFound() : Ok(item); } [HttpPost] public async Task CreateAsync([FromBody] AdoS0WorkCtrMasterUpsertDto dto) { var now = DateTime.Now; var entity = new AdoS0WorkCtrMaster { WorkCtr = dto.WorkCtr.Trim(), Descr = dto.Descr, Department = dto.Department, IsActive = dto.IsActive, Domain = dto.Domain.Trim(), CreateUser = dto.CreateUser ?? dto.UpdateUser, CreateTime = dto.CreateTime ?? dto.UpdateTime ?? now, UpdateUser = dto.UpdateUser, UpdateTime = dto.UpdateTime }; await _rep.AsInsertable(entity).ExecuteReturnEntityAsync(); return Ok(entity); } [HttpPut("{id:long}")] public async Task UpdateAsync(long id, [FromBody] AdoS0WorkCtrMasterUpsertDto dto) { var entity = await _rep.GetByIdAsync(id); if (entity == null) return NotFound(); entity.WorkCtr = dto.WorkCtr.Trim(); entity.Descr = dto.Descr; entity.Department = dto.Department; entity.IsActive = dto.IsActive; entity.Domain = dto.Domain.Trim(); entity.UpdateUser = dto.UpdateUser; entity.UpdateTime = dto.UpdateTime ?? DateTime.Now; await _rep.AsUpdateable(entity).ExecuteCommandAsync(); return Ok(entity); } [HttpDelete("{id:long}")] public async Task DeleteAsync(long id) { var item = await _rep.GetByIdAsync(id); if (item == null) return NotFound(); await _rep.DeleteAsync(item); return Ok(new { message = "删除成功" }); } }