| | |
| | | HashMap<String, Object> content = new HashMap<>(); |
| | | content.put("BillNo", "'" + order.getOrderNo() + "'"); |
| | | content.put("IoKindID", "'" + order.getDocType() + "'"); |
| | | content.put("ObjectId", "'" + order.getCstmr() + "'"); |
| | | content.put("ObjectName", "'" + order.getCstmrName() + "'"); |
| | | content.put("Remark", "'" + order.getMemo() + "'"); |
| | | if (!Cools.isEmpty(order.getCstmr())) content.put("ObjectId", "'" + order.getCstmr() + "'"); |
| | | if (!Cools.isEmpty(order.getCstmrName())) content.put("ObjectName", "'" + order.getCstmrName() + "'"); |
| | | if (!Cools.isEmpty(order.getMemo())) content.put("Remark", "'" + order.getMemo() + "'"); |
| | | content.put("LKName", "'中扬二期'"); |
| | | content.put("bPass", "1"); |
| | | int insert = erpSqlServer.insert(InHedTB.class, content); |
| | | String sql = "UPDATE lk_InHedTB SET bPass = 1, LKName='中扬二期' WHERE BillNo = '" + order.getOrderNo() + "'"; |
| | | int update = erpSqlServer.update(sql); |
| | | if (update == 1) { |
| | | //String sql = "UPDATE lk_InHedTB SET bPass = 1, LKName='中扬二期' WHERE BillNo = '" + order.getOrderNo() + "'"; |
| | | //int update = erpSqlServer.update(sql); |
| | | if (insert == 1) { |
| | | log.info("入库单表头回传成功:" + content); |
| | | return true; |
| | | } else { |
| | |
| | | HashMap<String, Object> content = new HashMap<>(); |
| | | content.put("BillNo", "'" + order.getOrderNo() + "'"); |
| | | content.put("IoKindID", "'" + order.getDocType() + "'"); |
| | | content.put("ObjectId", "'" + order.getCstmr() + "'"); |
| | | content.put("ObjectName", "'" + order.getCstmrName() + "'"); |
| | | content.put("Remark", "'" + order.getMemo() + "'"); |
| | | if (!Cools.isEmpty(order.getCstmr())) content.put("ObjectId", "'" + order.getCstmr() + "'"); |
| | | if (!Cools.isEmpty(order.getCstmrName())) content.put("ObjectName", "'" + order.getCstmrName() + "'"); |
| | | if (!Cools.isEmpty(order.getMemo())) content.put("Remark", "'" + order.getMemo() + "'"); |
| | | content.put("LKName", "'中扬二期'"); |
| | | content.put("bPass", "1"); |
| | | int insert = erpSqlServer.insert(OutHedTB.class, content); |
| | | String sql = "UPDATE lk_OutHedTB SET bPass = 1, LKName='中扬二期' WHERE BillNo = '" + order.getOrderNo() + "'"; |
| | | int update = erpSqlServer.update(sql); |
| | | if (update == 1) { |
| | | //String sql = "UPDATE lk_OutHedTB SET bPass = 1, LKName='中扬二期' WHERE BillNo = '" + order.getOrderNo() + "'"; |
| | | //int update = erpSqlServer.update(sql); |
| | | if (insert == 1) { |
| | | log.info("入库单表头回传成功:" + content); |
| | | return true; |
| | | } else { |
| | |
| | | |
| | | private Map<String, Object> getMap(OrderDetl orderDetl) { |
| | | Map<String, Object> content = new HashMap<>(); |
| | | if (!Cools.isEmpty()) content.put("BillNo", "'" + orderDetl.getOrderNo() + "'"); |
| | | if (!Cools.isEmpty()) content.put("iNO", "'" + orderDetl.getINO() + "'"); |
| | | if (!Cools.isEmpty()) content.put("detId", orderDetl.getThreeCode()); |
| | | if (!Cools.isEmpty()) content.put("ItemId", "'" + orderDetl.getThreeCode() + "'"); |
| | | if (!Cools.isEmpty()) content.put("ItemCode", "'" + orderDetl.getMatnr() + "'"); |
| | | if (!Cools.isEmpty()) content.put("ItemBatch", "'" + orderDetl.getBatch() + "'"); |
| | | if (!Cools.isEmpty()) content.put("proType", "'" + orderDetl.getProType() + "'"); |
| | | if (!Cools.isEmpty()) content.put("remark", "'" + orderDetl.getMemo() + "'"); |
| | | if (!Cools.isEmpty()) content.put("OrderNo", "'" + orderDetl.getOutOrderNo() + "'"); |
| | | if (!Cools.isEmpty()) content.put("MainNum", orderDetl.getQty()); |
| | | if (!Cools.isEmpty()) content.put("WareId", "'" + orderDetl.getWareId() + "'"); |
| | | if (!Cools.isEmpty()) content.put("WareName", "'" + orderDetl.getWareName() + "'"); |
| | | if (!Cools.isEmpty()) content.put("Packing", "'" + orderDetl.getPacking() + "'"); |
| | | if (!Cools.isEmpty()) content.put("LuHao", "'" + orderDetl.getLuHao() + "'"); |
| | | if (!Cools.isEmpty()) content.put("sPgNO", "'" + orderDetl.getSPgNO() + "'"); |
| | | if (!Cools.isEmpty()) content.put("temp1", "'" + orderDetl.getTemp1() + "'"); |
| | | if (!Cools.isEmpty()) content.put("temp2", "'" + orderDetl.getTemp2() + "'"); |
| | | if (!Cools.isEmpty()) content.put("temp3", "'" + orderDetl.getTemp3() + "'"); |
| | | if (!Cools.isEmpty()) content.put("LKName", "'中扬二期'"); |
| | | if (!Cools.isEmpty(orderDetl.getOrderNo())) content.put("BillNo", "'" + orderDetl.getOrderNo() + "'"); |
| | | if (!Cools.isEmpty(orderDetl.getINO())) content.put("iNO", "'" + orderDetl.getINO() + "'"); |
| | | if (!Cools.isEmpty(orderDetl.getThreeCode())) content.put("detId", orderDetl.getThreeCode()); |
| | | if (!Cools.isEmpty(orderDetl.getThreeCode())) content.put("ItemId", "'" + orderDetl.getThreeCode() + "'"); |
| | | if (!Cools.isEmpty(orderDetl.getMatnr())) content.put("ItemCode", "'" + orderDetl.getMatnr() + "'"); |
| | | if (!Cools.isEmpty(orderDetl.getBatch())) content.put("ItemBatch", "'" + orderDetl.getBatch() + "'"); |
| | | if (!Cools.isEmpty(orderDetl.getProType())) content.put("proType", "'" + orderDetl.getProType() + "'"); |
| | | if (!Cools.isEmpty(orderDetl.getMemo())) content.put("remark", "'" + orderDetl.getMemo() + "'"); |
| | | if (!Cools.isEmpty(orderDetl.getOutOrderNo())) content.put("OrderNo", "'" + orderDetl.getOutOrderNo() + "'"); |
| | | if (!Cools.isEmpty(orderDetl.getQty())) content.put("MainNum", orderDetl.getQty()); |
| | | if (!Cools.isEmpty(orderDetl.getWareId())) content.put("WareId", "'" + orderDetl.getWareId() + "'"); |
| | | if (!Cools.isEmpty(orderDetl.getWareName())) content.put("WareName", "'" + orderDetl.getWareName() + "'"); |
| | | if (!Cools.isEmpty(orderDetl.getPacking())) content.put("Packing", "'" + orderDetl.getPacking() + "'"); |
| | | if (!Cools.isEmpty(orderDetl.getLuHao())) content.put("LuHao", "'" + orderDetl.getLuHao() + "'"); |
| | | if (!Cools.isEmpty(orderDetl.getSPgNO())) content.put("sPgNO", "'" + orderDetl.getSPgNO() + "'"); |
| | | if (!Cools.isEmpty(orderDetl.getTemp1())) content.put("temp1", "'" + orderDetl.getTemp1() + "'"); |
| | | if (!Cools.isEmpty(orderDetl.getTemp2())) content.put("temp2", "'" + orderDetl.getTemp2() + "'"); |
| | | if (!Cools.isEmpty(orderDetl.getTemp3())) content.put("temp3", "'" + orderDetl.getTemp3() + "'"); |
| | | content.put("LKName", "'中扬二期'"); |
| | | return content; |
| | | } |
| | | |
| | | |
| | | } |