From aae2a9ba3a33136e4106e36e47fbd5b5c31c4fd9 Mon Sep 17 00:00:00 2001
From: 18516761980 <4761516tqsxp>
Date: 星期四, 16 十二月 2021 15:16:24 +0800
Subject: [PATCH] #
---
src/main/java/com/zy/common/service/erp/ErpService.java | 11 ++++++++---
src/main/java/com/zy/common/service/erp/task/ErpScheduler.java | 5 -----
src/main/java/com/zy/common/service/erp/ErpSqlServer.java | 1 +
3 files changed, 9 insertions(+), 8 deletions(-)
diff --git a/src/main/java/com/zy/common/service/erp/ErpService.java b/src/main/java/com/zy/common/service/erp/ErpService.java
index 18e85d3..9d73ea9 100644
--- a/src/main/java/com/zy/common/service/erp/ErpService.java
+++ b/src/main/java/com/zy/common/service/erp/ErpService.java
@@ -86,7 +86,8 @@
* @param fInterID 鍗曟嵁鍐呯爜
*/
private List<InStockBillEntry> getInStockBillEntry(Integer fInterID) {
- String sql = "select * from InStockBillEntry where 1=1 and FSourceBillNo!='' and FAuxCommitQty=0 and FInterID = " + fInterID;
+// String sql = "select * from InStockBillEntry where 1=1 and FSourceBillNo!='' and FAuxCommitQty=0 and FInterID = " + fInterID;
+ String sql = "select * from InStockBillEntry where 1=1 and FAuxCommitQty=0 and FInterID = " + fInterID;
return erpSqlServer.select(sql, InStockBillEntry.class);
}
@@ -103,7 +104,8 @@
* 鎻愬彇涓棿琛ㄦ垚鍝佸叆搴撳崟鎹�
*/
public List<CPICMO> getReadyCPICMO() {
- String sql = "select * from CPICMO where 1=1 and FSourceBillNo!='' and FAuxCommitQty=0 and Fflag_rw = 0";
+// String sql = "select * from CPICMO where 1=1 and FSourceBillNo!='' and FAuxCommitQty=0 and Fflag_rw = 0";
+ String sql = "select * from CPICMO where 1=1 and FAuxCommitQty=0 and Fflag_rw = 0";
return erpSqlServer.select(sql, CPICMO.class);
}
@@ -155,13 +157,16 @@
return erpSqlServer.executeQueryCount(sql,"qty");
}
+
/**
* 鏌ヨerp涓棿琛ㄨ〃浣揙utStockbillEntry鏁版嵁
* @param FInterID
* @return
*/
public List<OutStockBillEntry> syncOutStockDetail(Integer FInterID) {
- return erpSqlServer.select("SELECT * FROM xtyasrs_dual.dbo.OutStockBillEntry where FSourceBillNo!='' and FAuxCommitQty=0 and FInterID=" + FInterID, OutStockBillEntry.class);
+// String sql = "SELECT * FROM xtyasrs_dual.dbo.OutStockBillEntry where FSourceBillNo!='' and FAuxCommitQty=0 and FInterID=" + FInterID;
+ String sql = "SELECT * FROM xtyasrs_dual.dbo.OutStockBillEntry where FAuxCommitQty=0 and FInterID=" + FInterID;
+ return erpSqlServer.select(sql, OutStockBillEntry.class);
}
/**
diff --git a/src/main/java/com/zy/common/service/erp/ErpSqlServer.java b/src/main/java/com/zy/common/service/erp/ErpSqlServer.java
index 37c7b15..481444b 100644
--- a/src/main/java/com/zy/common/service/erp/ErpSqlServer.java
+++ b/src/main/java/com/zy/common/service/erp/ErpSqlServer.java
@@ -92,6 +92,7 @@
}
}
+
public Number executeQueryCount(String sql, String column) {
Number value = 0;
Connection conn = null;
diff --git a/src/main/java/com/zy/common/service/erp/task/ErpScheduler.java b/src/main/java/com/zy/common/service/erp/task/ErpScheduler.java
index 1ff3a2e..b137659 100644
--- a/src/main/java/com/zy/common/service/erp/task/ErpScheduler.java
+++ b/src/main/java/com/zy/common/service/erp/task/ErpScheduler.java
@@ -71,18 +71,13 @@
}
continue;
}
- log.info("璧板埌涓�鍙蜂綅缃�");
if (Cools.isEmpty(dto) || Cools.isEmpty(dto.getInStockBillEntries())) {
- log.info(Cools.isEmpty(dto)+"#@@@");
- log.info(Cools.isEmpty(dto.getInStockBillEntries())+"###@");
continue;
}
- log.info("璧板埌浜屽彿浣嶇疆");
for (InStockBillEntry entry : dto.getInStockBillEntries()) {
MatCode matCode = matCodeService.selectById(entry.getFnumber());
if (null != matCode) {
// 鐢熸垚鍏ュ簱閫氱煡鍗�
- log.info("璧板埌涓夊彿浣嶇疆");
WaitPakin waitPakin = new WaitPakin();
waitPakin.setMemo("鍘熸潗鏂�");
waitPakin.setStatus("Y"); // 鐘舵��
--
Gitblit v1.9.1