From d5f446da1b638fe1024c35f9732e72c12d71f1f8 Mon Sep 17 00:00:00 2001 From: baiXiao8813 <516776535@qq.com> Date: 星期二, 27 七月 2021 14:14:37 +0800 Subject: [PATCH] 立库日入库、出库导出列顺序调整 --- src/main/java/com/zy/common/service/erp/ErpService.java | 10 +++++----- 1 files changed, 5 insertions(+), 5 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 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; -- Gitblit v1.9.1