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/line-materials")] [AllowAnonymous] [NonUnify] public class AdoS0MfgLineMaterialsController : ControllerBase { private readonly SqlSugarRepository _rep; public AdoS0MfgLineMaterialsController(SqlSugarRepository rep) { _rep = rep; } [HttpGet] public async Task GetPagedAsync([FromQuery] AdoS0MfgLineMaterialQueryDto q) { var page = q.EffectivePage; var pageSize = q.PageSize; (page, pageSize) = PagingGuard.Normalize(page, pageSize); var query = _rep.AsQueryable() .WhereIF(q.CompanyRefId.HasValue, x => x.CompanyRefId == q.CompanyRefId!.Value) .WhereIF(q.FactoryRefId.HasValue, x => x.FactoryRefId == q.FactoryRefId!.Value) .WhereIF(!string.IsNullOrWhiteSpace(q.Keyword), x => (x.EquipmentCode != null && x.EquipmentCode.Contains(q.Keyword!)) || (x.RequiredSkillCode != null && x.RequiredSkillCode.Contains(q.Keyword!)) || (x.Remark != null && x.Remark.Contains(q.Keyword!))) .WhereIF(q.IsEnabled.HasValue, x => x.IsEnabled == q.IsEnabled!.Value); var total = await query.CountAsync(); var list = await query.OrderByDescending(x => x.CreatedAt).Skip((page - 1) * pageSize).Take(pageSize).ToListAsync(); return Ok(new { total, page, pageSize, list }); } [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] AdoS0MfgLineMaterialUpsertDto dto) { var entity = new AdoS0MfgLineMaterial { CompanyRefId = dto.CompanyRefId, FactoryRefId = dto.FactoryRefId, ProductionLineId = dto.ProductionLineId, MaterialId = dto.MaterialId, OperationId = dto.OperationId, WorkCenterId = dto.WorkCenterId, EquipmentCode = dto.EquipmentCode, StdCapacityPerUnit = dto.StdCapacityPerUnit, ChangeoverTime = dto.ChangeoverTime, EquipmentTypeCode = dto.EquipmentTypeCode, MoldTypeCode = dto.MoldTypeCode, RequiredSkillCode = dto.RequiredSkillCode, MaterialRole = dto.MaterialRole, Remark = dto.Remark, IsEnabled = dto.IsEnabled, CreatedAt = DateTime.Now }; await _rep.AsInsertable(entity).ExecuteReturnEntityAsync(); return Ok(entity); } [HttpPut("{id:long}")] public async Task UpdateAsync(long id, [FromBody] AdoS0MfgLineMaterialUpsertDto dto) { var entity = await _rep.GetByIdAsync(id); if (entity == null) return NotFound(); entity.CompanyRefId = dto.CompanyRefId; entity.FactoryRefId = dto.FactoryRefId; entity.ProductionLineId = dto.ProductionLineId; entity.MaterialId = dto.MaterialId; entity.OperationId = dto.OperationId; entity.WorkCenterId = dto.WorkCenterId; entity.EquipmentCode = dto.EquipmentCode; entity.StdCapacityPerUnit = dto.StdCapacityPerUnit; entity.ChangeoverTime = dto.ChangeoverTime; entity.EquipmentTypeCode = dto.EquipmentTypeCode; entity.MoldTypeCode = dto.MoldTypeCode; entity.RequiredSkillCode = dto.RequiredSkillCode; entity.MaterialRole = dto.MaterialRole; entity.Remark = dto.Remark; entity.IsEnabled = dto.IsEnabled; entity.UpdatedAt = DateTime.Now; await _rep.AsUpdateable(entity).ExecuteCommandAsync(); return Ok(entity); } [HttpPatch("{id:long}/toggle-enabled")] public async Task ToggleEnabledAsync(long id, [FromBody] AdoS0ToggleEnabledDto dto) { var entity = await _rep.GetByIdAsync(id); if (entity == null) return NotFound(); entity.IsEnabled = dto.IsEnabled; entity.UpdatedAt = 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 = "删除成功" }); } }