| | |
|---|
| | | @Transactional(rollbackFor = Throwable.class) |
|---|
| | | @Scheduled(cron = "${erp.refreshtime}") |
|---|
| | | public void InHedTBScheduler() { |
|---|
| | | log.info("InHedTBScheduler开始了"); |
|---|
| | | //log.info("InHedTBScheduler开始了"); |
|---|
| | | if (!erpEnabled) return; |
|---|
| | | String sqlInHed = "select * from erp_InHedTB where LKName='中扬二期'"; |
|---|
| | | List<InHedTB> inHeds = erpSqlServer.select(sqlInHed, InHedTB.class); |
|---|
| | | if (!inHeds.isEmpty()) { |
|---|
| | | for (InHedTB inHed : inHeds) { |
|---|
| | | System.out.println(inHed); |
|---|
| | | HashMap<String, String> condition = new HashMap<>(); |
|---|
| | | condition.put("BillNo", "'" + inHed.getBillNo() + "'"); |
|---|
| | | List<InDetTB> inDetTBS = erpSqlServer.selectList(InDetTB.class, condition); |
|---|
| | |
|---|
| | | hedAndDet.put("det", inDetTBS); |
|---|
| | | boolean result = inMS.createInOrder(inHed, inDetTBS); |
|---|
| | | if (result) { |
|---|
| | | log.info("入库单据成功,{}", inHed.getBillNo()); |
|---|
| | | move(hedAndDet); |
|---|
| | | } else { |
|---|
| | | String sql = "UPDATE erp_InHedTB SET Temp3 = ‘fault’ WHERE BillNo = '" + inHed.getBillNo() + "'"; |
|---|
