From 74496088032dc5570671a81c3f79e3980381e758 Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@63.com>
Date: 星期五, 24 九月 2021 13:46:43 +0800
Subject: [PATCH] 1
---
src/main/java/com/zy/asrs/service/impl/OutStockServiceImpl.java | 5 ++++-
1 files changed, 4 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/zy/asrs/service/impl/OutStockServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/OutStockServiceImpl.java
index db288b2..50b88fd 100644
--- a/src/main/java/com/zy/asrs/service/impl/OutStockServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/OutStockServiceImpl.java
@@ -94,9 +94,11 @@
String sql = "update OutStockbillEntry set FAuxCommitQty = (FAuxCommitQty + {0,number,#}) where 1=1 and Fnumber = ''{1}'' and FInterID = {2,number,#}";
sql = MessageFormat.format(sql, increment, Fnumber, FInterID);
if (jdbcTemplate.update(sql) > 0) {
+ log.info("step 1 ======>> {}", sql);
sql = "select * from OutStockbillEntry where 1=1 and Fnumber = ''{0}'' and FInterID = {1,number,#}";
sql = MessageFormat.format(sql, Fnumber, FInterID);
- List<OutStockBillEntry> select = jdbcTemplate.queryForList(sql, OutStockBillEntry.class);
+ List<OutStockBillEntry> select = this.selectList(new EntityWrapper<OutStockBillEntry>().eq("Fnumber", Fnumber).eq("FInterID", FInterID));
+ log.info("step 2 ======>> {}", sql);
OutStockBillEntry outStockBillEntry = select.get(0);
boolean complete = false;
if (outStockBillEntry.getFQty().compareTo(BigDecimal.ZERO) == 1) {
@@ -123,6 +125,7 @@
private boolean completeCPakOut(String FBillNo){
String sql = "update OutStockbill set Fflag_finish = 1 where FBillNo = ''{0}''";
sql = MessageFormat.format(sql, FBillNo);
+ log.info("step 3 ======>> {}", sql);
return jdbcTemplate.update(sql) > 0;
}
--
Gitblit v1.9.1