excel导出优化

zhangchao

2024-11-04 59f80df1e377e8775969ca4acadfa2eadd6e37ae

 src/main/java/com/zy/asrs/entity/param/LocDetlAdjustParam.java

@@ -21,7 +21,7 @@
    @Data
    public static class LocDetlAdjust {

        // 单据号
        // 物料号
        private String matnr;

        // 序列码
@@ -30,10 +30,30 @@
        // 变更数量
        private Double count;

        public LocDetlAdjust(String matnr, String batch, Double count) {
        // 销售订单号
        private String orderNo;

        // 销售订单号
        private String threeCode;

        //销售订单行号
        private String deadTime;

        //货架码
        private String suppCode;

        // 工序
        private Integer processSts;

        public LocDetlAdjust(String matnr, String batch, Double count, String orderNo,String threeCode, String deadTime, String suppCode, Integer processSts) {
            this.matnr = matnr;
            this.batch = batch;
            this.count = count;
            this.orderNo = orderNo;
            this.threeCode = threeCode;
            this.deadTime = deadTime;
            this.suppCode = suppCode;
            this.processSts = processSts;
        }
    }

@@ -45,14 +65,14 @@
        for (LocDetlAdjust adjust : list) {
            boolean exit = false;
            for (LocDetlAdjust copy : copyList) {
                if (adjust.getMatnr().equals(copy.getMatnr()) && Cools.eq(adjust.getBatch(), copy.getBatch())) {
                if (adjust.getMatnr().equals(copy.getMatnr()) && Cools.eq(adjust.getBatch(), copy.getBatch()) && Cools.eq(adjust.getSuppCode(),copy.getSuppCode()) && Cools.eq(adjust.getThreeCode(),copy.getThreeCode()) && Cools.eq(adjust.getDeadTime(),copy.getDeadTime())) {
                    copy.setCount(copy.getCount() + adjust.getCount());
                    exit = true;
                    break;
                }
            }
            if (!exit) {
                copyList.add(new LocDetlAdjustParam.LocDetlAdjust(adjust.getMatnr(), adjust.getBatch(), adjust.getCount()));
                copyList.add(new LocDetlAdjustParam.LocDetlAdjust(adjust.getMatnr(), adjust.getBatch(), adjust.getCount(),adjust.getOrderNo(), adjust.getThreeCode(), adjust.getDeadTime(),adjust.getSuppCode(),adjust.getProcessSts()));
            }
        }
        list = copyList;