#中间表对接：订单接收优化

LSH

2023-01-04 6021df21a6eaca3cf48db8f3ec38db6793d1fb97

#中间表对接：订单接收优化

 src/main/java/com/zy/ints/task/scheduler/ErpDetTbScheduler.java

@@ -12,11 +12,8 @@
import com.zy.asrs.service.MatService;
import com.zy.asrs.service.OrderDetlService;
import com.zy.asrs.service.OrderService;
import com.zy.common.model.DetlDto;
import com.zy.ints.entity.ErpDetTb;
import com.zy.ints.entity.ErpDetTbBak;
import com.zy.ints.entity.Prdt;
import com.zy.ints.entity.PrdtBak;
import com.zy.ints.erp.ErpSqlServer;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
@@ -24,7 +21,7 @@
import org.springframework.scheduling.annotation.Scheduled;
import org.springframework.stereotype.Component;

import java.util.ArrayList;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
@@ -151,6 +148,7 @@
                            }
                        }
                    } else if (status == 1) {
                        String format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(now);
                        HashMap<String, Object> condition = new HashMap<>();
                        condition.put("bill_no", "'" + erpDetTb.getBillNo() + "'");
                        condition.put("prd_no", "'" + erpDetTb.getPrdNo() + "'");
@@ -159,7 +157,7 @@
                        condition.put("qty", "'" + erpDetTb.getQty() + "'");
                        condition.put("prd_mark", "'" + erpDetTb.getPrdMark() + "'");
                        condition.put("wh", "'" + erpDetTb.getWh() + "'");
                        condition.put("billdate", "'" + erpDetTb.getBilldate() + "'");
                        condition.put("billdate", "'" + format + "'");
                        condition.put("status", "'" + erpDetTb.getStatus() + "'");
                        condition.put("temp1", "'" + erpDetTb.getTemp1() + "'");
                        condition.put("temp2", "'" + erpDetTb.getTemp2() + "'");
@@ -167,9 +165,9 @@
                        erpSqlServer.insert(ErpDetTbBak.class, condition);

                        HashMap<String, String> condition2 = new HashMap<>();
                        condition.put("bill_no", "'" + erpDetTb.getBillNo() + "'");
                        condition2.put("bill_no", "'" + erpDetTb.getBillNo() + "'");
                        condition2.put("prd_no", "'" + erpDetTb.getPrdNo() + "'");
                        condition.put("prd_mark", "'" + erpDetTb.getPrdMark() + "'");
                        condition2.put("prd_mark", "'" + erpDetTb.getPrdMark() + "'");
                        erpSqlServer.delete(ErpDetTb.class, condition2);
                    } else if (status == 2) {