using Admin.NET.Plugin.AiDOP.Dto.S0.Manufacturing; 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/process-flow-cards")] [AllowAnonymous] [NonUnify] public class AdoS0MfgProcessFlowCardsController : ControllerBase { private readonly SqlSugarRepository _rep; public AdoS0MfgProcessFlowCardsController(SqlSugarRepository rep) => _rep = rep; [HttpGet] public async Task GetPagedAsync([FromQuery] AdoS0ProcessFlowCardQueryDto 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.DomainCode), x => x.DomainCode == q.DomainCode) .WhereIF(!string.IsNullOrWhiteSpace(q.WorkOrderNo), x => x.WorkOrderNo.Contains(q.WorkOrderNo!)) .WhereIF(!string.IsNullOrWhiteSpace(q.FlowCardNo), x => x.FlowCardNo.Contains(q.FlowCardNo!)) .WhereIF(!string.IsNullOrWhiteSpace(q.ItemNum), x => x.ItemNum.Contains(q.ItemNum!)) .WhereIF(q.IsActive.HasValue, x => x.IsActive == q.IsActive.Value) .WhereIF(!string.IsNullOrWhiteSpace(q.Keyword), x => x.WorkOrderNo.Contains(q.Keyword!) || x.FlowCardNo.Contains(q.Keyword!) || x.ItemNum.Contains(q.Keyword!) || (x.ItemName != null && x.ItemName.Contains(q.Keyword!)) || (x.DrawingNo != null && x.DrawingNo.Contains(q.Keyword!))); var total = await query.CountAsync(); var list = await query.OrderByDescending(x => x.CreateTime).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] AdoS0ProcessFlowCardUpsertDto dto) { var flowCardNo = dto.FlowCardNo.Trim(); if (await _rep.IsAnyAsync(x => x.FactoryRefId == dto.FactoryRefId && x.FlowCardNo == flowCardNo)) return AdoS0ApiErrors.Conflict(AdoS0ErrorCodes.DuplicateCode, "同工厂下流转卡号已存在"); var now = DateTime.Now; var entity = new AdoS0ProcessFlowCard { CompanyRefId = dto.CompanyRefId, FactoryRefId = dto.FactoryRefId, DomainCode = dto.DomainCode, WorkOrderNo = dto.WorkOrderNo.Trim(), WorkOrderBatchNo = dto.WorkOrderBatchNo?.Trim(), FlowCardNo = flowCardNo, Nature = dto.Nature?.Trim(), ItemNum = dto.ItemNum.Trim(), ItemName = dto.ItemName?.Trim(), DrawingNo = dto.DrawingNo?.Trim(), BomVersion = dto.BomVersion?.Trim(), RoutingCode = dto.RoutingCode?.Trim(), Remarks = dto.Remarks?.Trim(), IsActive = dto.IsActive, CreateUser = dto.CreateUser, CreateTime = now, UpdateUser = dto.UpdateUser, UpdateTime = null }; await _rep.AsInsertable(entity).ExecuteReturnEntityAsync(); return Ok(entity); } [HttpPut("{id:long}")] public async Task UpdateAsync(long id, [FromBody] AdoS0ProcessFlowCardUpsertDto dto) { var entity = await _rep.GetByIdAsync(id); if (entity == null) return NotFound(); var flowCardNo = dto.FlowCardNo.Trim(); if (await _rep.IsAnyAsync(x => x.Id != id && x.FactoryRefId == dto.FactoryRefId && x.FlowCardNo == flowCardNo)) return AdoS0ApiErrors.Conflict(AdoS0ErrorCodes.DuplicateCode, "同工厂下流转卡号已存在"); entity.CompanyRefId = dto.CompanyRefId; entity.FactoryRefId = dto.FactoryRefId; entity.DomainCode = dto.DomainCode; entity.WorkOrderNo = dto.WorkOrderNo.Trim(); entity.WorkOrderBatchNo = dto.WorkOrderBatchNo?.Trim(); entity.FlowCardNo = flowCardNo; entity.Nature = dto.Nature?.Trim(); entity.ItemNum = dto.ItemNum.Trim(); entity.ItemName = dto.ItemName?.Trim(); entity.DrawingNo = dto.DrawingNo?.Trim(); entity.BomVersion = dto.BomVersion?.Trim(); entity.RoutingCode = dto.RoutingCode?.Trim(); entity.Remarks = dto.Remarks?.Trim(); entity.IsActive = dto.IsActive; entity.UpdateUser = dto.UpdateUser; entity.UpdateTime = DateTime.Now; await _rep.AsUpdateable(entity).ExecuteCommandAsync(); return Ok(entity); } [HttpPatch("{id:long}/toggle-enabled")] public async Task ToggleActiveAsync(long id, [FromBody] AdoS0ProcessFlowCardToggleActiveDto dto) { var entity = await _rep.GetByIdAsync(id); if (entity == null) return NotFound(); entity.IsActive = dto.IsEnabled; entity.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 = "删除成功" }); } }