package cn.iocoder.yudao.module.mes.controller.admin.pro.route.vo; import cn.idev.excel.annotation.ExcelProperty; import lombok.Data; import java.math.BigDecimal; import java.util.List; /** 多工作表完整工艺路线导入数据,所有关联通过业务编码定位。 */ @Data public class MesProRouteCompleteImportWorkbook { private List routes; private List products; private List processes; private List outputs; private List inputs; @Data public static class RouteRow { @ExcelProperty("路线编码") private String routeCode; @ExcelProperty("路线名称") private String name; @ExcelProperty("路线说明") private String description; @ExcelProperty("备注") private String remark; } @Data public static class ProductRow { @ExcelProperty("路线编码") private String routeCode; @ExcelProperty("产品物料编码") private String itemCode; @ExcelProperty("仓库编码") private String warehouseCode; @ExcelProperty("库区编码") private String locationCode; @ExcelProperty("库位编码") private String areaCode; @ExcelProperty("生产数量") private Integer quantity; @ExcelProperty("生产用时") private BigDecimal productionTime; @ExcelProperty("时间单位") private String timeUnitType; @ExcelProperty("备注") private String remark; } @Data public static class ProcessRow { @ExcelProperty("路线编码") private String routeCode; @ExcelProperty("工序编码") private String processCode; @ExcelProperty("排序") private Integer sort; @ExcelProperty("工艺参数模板ID") private Long paramTemplateId; @ExcelProperty("工序收率") private BigDecimal yieldRate; @ExcelProperty("与下一工序关系") private Integer linkType; @ExcelProperty("准备时间(分钟)") private Integer prepareTime; @ExcelProperty("等待时间(分钟)") private Integer waitTime; @ExcelProperty("甘特图颜色") private String colorCode; @ExcelProperty("关键工序(是/否)") private String keyFlag; @ExcelProperty("质检工序(是/否)") private String checkFlag; @ExcelProperty("倒冲(是/否)") private String backflushFlag; @ExcelProperty("备注") private String remark; } @Data public static class OutputRow { @ExcelProperty("路线编码") private String routeCode; @ExcelProperty("工序编码") private String processCode; @ExcelProperty("产出物料编码") private String itemCode; @ExcelProperty("归属产品编码(空为通用)") private String productCode; @ExcelProperty("排序") private Integer sort; @ExcelProperty("备注") private String remark; } @Data public static class InputRow { @ExcelProperty("路线编码") private String routeCode; @ExcelProperty("工序编码") private String processCode; @ExcelProperty("归属产品编码") private String productCode; @ExcelProperty("投料物料编码") private String itemCode; @ExcelProperty("用料比例") private BigDecimal quantity; @ExcelProperty("备注") private String remark; } @Data public static class GuideRow { @ExcelProperty("工作表") private String sheet; @ExcelProperty("填写说明") private String description; public GuideRow(String sheet, String description) { this.sheet = sheet; this.description = description; } } }