#中间表对接：日志文件优化

LSH

2023-01-04 0757cb23d78e43b9bcd768932b8ea8ee7ca329cd

#中间表对接：日志文件优化

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

@@ -150,7 +150,7 @@
                                        callApiLogSave(erpDetTb, "erp_det_tb", "接收ERP下发订单接收成功！！", true);
                                    } else {
                                        erpSqlServer.update(sqlUpDateErpDetTbTwo + ",temp1='添加订单明细档失败！！！'" + "where 1=1 and prd_no=" + "'" + erpDetTb.getPrdNo() + "'");
                                        callApiLogSave(erpDetTb, "erp_det_tb", "接收ERP下发订单接收失败！！", false);
                                        callApiLogSave(erpDetTb, "erp_det_tb", "ERP下发订单接收失败！！", false);
                                    }
                                }
                            }
@@ -172,7 +172,7 @@
                        condition.put("temp3", "'" + erpDetTb.getTemp3() + "'");
                        erpSqlServer.insert(ErpDetTbBak.class, condition);

                        callApiLogSave(erpDetTb, "erp_det_tb_bak", "erp下发订单备份成功！！", true);
                        callApiLogSave(erpDetTb, "erp_det_tb_bak", "ERP下发订单备份成功！！", true);

                        HashMap<String, String> condition2 = new HashMap<>();
                        condition2.put("bill_no", "'" + erpDetTb.getBillNo() + "'");
@@ -180,7 +180,7 @@
                        condition2.put("prd_mark", "'" + erpDetTb.getPrdMark() + "'");
                        erpSqlServer.delete(ErpDetTb.class, condition2);

                        callApiLogSave(erpDetTb, "erp_det_tb", "erp下发订单备份后删除成功！！", true);
                        callApiLogSave(erpDetTb, "erp_det_tb", "ERP下发订单备份后删除成功！！", true);

                    } else {
                        callApiLogSave(erpDetTb, "erp_det_tb", "接收ERP下发订单失败！！！状态异常！！！", false);

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

@@ -82,6 +82,9 @@
                                    erpSqlServer.update(sqlUpDatePrdtTwo + "'" + prdt.getPrdNo() + "'");
                                    callApiLogSave(prdt, "erp_prdt", "接收ERP下发商品信息失败！！！添加商品信息失败！！！", false);
                                }
                            } else {
                                erpSqlServer.update(sqlUpDatePrdtTwo + "'" + prdt.getPrdNo() + "'");
                                callApiLogSave(prdt, "erp_prdt", "接收ERP下发商品信息失败！！！商品已存在！！！", false);
                            }
                        } else if (type == 2) {
                            Mat mat = matService.selectByMatnr(prdt.getPrdNo());
@@ -109,7 +112,7 @@
                                }
                            }
                        } else {
                            callApiLogSave(prdt, "erp_prdt", "商品信息出现异常资料！", false);
                            callApiLogSave(prdt, "erp_prdt", "商品信息出现异常资料未处理！", false);
                        }
                    } else if (prdt.getStatus() == 1) {
                        HashMap<String, Object> condition = new HashMap<>();
@@ -126,8 +129,8 @@
                        condition2.put("prd_no", "'" + prdt.getPrdNo() + "'");
                        erpSqlServer.delete(Prdt.class, condition2);
                        callApiLogSave(prdt, "erp_prdt_bak", "ERP下发商品信息备份后删除成功！", true);
                    } else{
                        callApiLogSave(prdt, "erp_prdt", "商品信息出现异常资料！", false);
                    } else {
                        callApiLogSave(prdt, "erp_prdt", "商品信息出现异常资料未处理！", false);
                    }
                }
            }