From 65844ce578c4b09d95f50cd7a259d3db0c3c8d9c Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@163.com>
Date: 星期六, 19 六月 2021 13:27:00 +0800
Subject: [PATCH] #
---
src/main/java/com/zy/common/service/erp/ErpService.java | 10 +++++-----
src/main/java/com/zy/common/service/erp/ErpModeController.java | 4 ++--
src/main/java/com/zy/common/service/erp/entity/StockCheckRecord.java | 11 ++++++-----
3 files changed, 13 insertions(+), 12 deletions(-)
diff --git a/src/main/java/com/zy/common/service/erp/ErpModeController.java b/src/main/java/com/zy/common/service/erp/ErpModeController.java
index 6293fb0..f6bd74f 100644
--- a/src/main/java/com/zy/common/service/erp/ErpModeController.java
+++ b/src/main/java/com/zy/common/service/erp/ErpModeController.java
@@ -71,8 +71,8 @@
* 搴撳瓨鐩樼偣
*/
@GetMapping("/checkStockEntity")
- public R checkStockEntity(@RequestParam Integer FItemID, @RequestParam Integer FEntryID, @RequestParam Double qty) {
- return R.ok().add(erpService.checkStockEntity(FItemID, FEntryID, qty));
+ public R checkStockEntity(@RequestParam String FNumber, @RequestParam Double qty) {
+ return R.ok().add(erpService.checkStockEntity(FNumber, qty));
}
}
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 623c72a..de28db0 100644
--- a/src/main/java/com/zy/common/service/erp/ErpService.java
+++ b/src/main/java/com/zy/common/service/erp/ErpService.java
@@ -228,14 +228,14 @@
/**
* 搴撳瓨鐩樼偣
- * @param FItemID 鐗╂枡鍐呯爜
+ * @param FNumber 鐗╂枡鍐呯爜
* @param qty 鏁伴噺锛堟琛ㄧず鐩樼泩銆佽礋琛ㄧず鐩樹簭锛�
*/
- public boolean checkStockEntity(Integer FItemID, Integer FEntryID, Double qty){
- String sql = "insert [dbo].[StockCheckRecord] ([FItemID],[FEntryID], [CheckQty],[Fflag_rw],[Fflag_finish]) values ({0,number,#}, {1,number,#}, {2,number,#}, 0, 0);";
- sql = MessageFormat.format(sql, FItemID, FEntryID, qty);
+ public boolean checkStockEntity(String FNumber, Double qty){
+ String sql = "insert [dbo].[StockCheckRecord] ([FNumber],[CheckQty],[Fflag_rw],[Fflag_finish],[sync_id]) values (''{0}'', {1,number,#}, 0, 0, -1);";
+ sql = MessageFormat.format(sql, FNumber, qty);
if (erpSqlServer.update(sql) == 0) {
- log.error("{}鏂板鐩樼偣璁板綍澶辫触", FItemID);
+ log.error("{}鏂板鐩樼偣璁板綍澶辫触", FNumber);
return false;
}
return true;
diff --git a/src/main/java/com/zy/common/service/erp/entity/StockCheckRecord.java b/src/main/java/com/zy/common/service/erp/entity/StockCheckRecord.java
index 0bd8df3..07e3237 100644
--- a/src/main/java/com/zy/common/service/erp/entity/StockCheckRecord.java
+++ b/src/main/java/com/zy/common/service/erp/entity/StockCheckRecord.java
@@ -9,11 +9,8 @@
@Data
public class StockCheckRecord {
- // 鐗╂枡鍐呯爜
- private Integer FItemID;
-
- // 鍒嗗綍鍙�
- private Integer FEntryID;
+ // 鐗╂枡鐮�
+ private String FNumber;
// 鐩樼偣鏁伴噺
private Double CheckQty;
@@ -27,4 +24,8 @@
// 瀹屾垚鏍囪
private Integer Fflag_finish;
+ private Integer id;
+
+ private Integer sync_id;
+
}
--
Gitblit v1.9.1