商品档案全量导出修改

pang.jiabao

2024-04-18 cddfcdf68ff7fff6b1be82bc5edf822458de6749

 src/main/java/com/zy/asrs/controller/OrderController.java

@@ -395,16 +395,18 @@
            String maktx = dataFormatter.formatCellValue(row.getCell(1));
            // 商品编码
            String matnr = dataFormatter.formatCellValue(row.getCell(2));
            // 商品编码
            String batch = dataFormatter.formatCellValue(row.getCell(3));
            // 数量
            Double anfme = Double.parseDouble(dataFormatter.formatCellValue(row.getCell(3)));
            Double anfme = Double.parseDouble(dataFormatter.formatCellValue(row.getCell(4)));
            // 下单时间
            String timeStr = dataFormatter.formatCellValue(row.getCell(4));
            String timeStr = dataFormatter.formatCellValue(row.getCell(5));

            if (Cools.isEmpty(timeStr)) {
                timeStr = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss").format(now);
            }
            // 单据类型
            Long orderType = Long.parseLong(dataFormatter.formatCellValue(row.getCell(5)));
            Long orderType = Long.parseLong(dataFormatter.formatCellValue(row.getCell(6)));
            Date time = null;
            try {
                time = DateUtils.convert(timeStr, DateUtils.yyyyMMddHHmmss_F);
@@ -468,7 +470,7 @@
            if (orderDetl == null) {
                orderDetl = new OrderDetl();
                orderDetl.sync(mat);
                orderDetl.setBatch(null);
                orderDetl.setBatch(batch);
                orderDetl.setAnfme(anfme);
                orderDetl.setOrderId(order.getId());
                orderDetl.setOrderNo(order.getOrderNo());