From d8fb6d11aa24b77b8bbcc5740140d31f5692837d Mon Sep 17 00:00:00 2001
From: cy <1664593601@qq.com>
Date: 星期四, 16 十一月 2023 16:11:05 +0800
Subject: [PATCH] feat: 调拨调整
---
consum-base/src/main/java/com/consum/base/service/LGoodsWhRecordServiceImpl.java | 13 ++++++-------
1 files changed, 6 insertions(+), 7 deletions(-)
diff --git a/consum-base/src/main/java/com/consum/base/service/LGoodsWhRecordServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/LGoodsWhRecordServiceImpl.java
index 3a20477..53975c5 100644
--- a/consum-base/src/main/java/com/consum/base/service/LGoodsWhRecordServiceImpl.java
+++ b/consum-base/src/main/java/com/consum/base/service/LGoodsWhRecordServiceImpl.java
@@ -1,6 +1,7 @@
package com.consum.base.service;
import com.walker.jdbc.service.BaseServiceImpl;
+import org.apache.commons.lang3.StringUtils;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
@@ -17,25 +18,23 @@
@Service
@Transactional(rollbackFor = Exception.class)
public class LGoodsWhRecordServiceImpl extends BaseServiceImpl {
- private static String insert_new_record = "INSERT INTO L_GOODS_WH_RECORD (WAREHOUSE_FLOW_ID,DEAL_TIME,LAST_RECORD, WH_GOODS_ID,WAREHOUSE_TYPE, WAREHOUSE_ID)SELECT ?, ?,1,ID, WAREHOUSE_TYPE, WAREHOUSE_ID FROM L_WH_GOODS WHERE ID IN (?)";
+ private static String insert_new_record = "INSERT INTO L_GOODS_WH_RECORD (WAREHOUSE_FLOW_ID,DEAL_TIME,LAST_RECORD, WH_GOODS_ID,WAREHOUSE_TYPE, WAREHOUSE_ID)SELECT ?, ?,1,ID, WAREHOUSE_TYPE, WAREHOUSE_ID FROM L_WH_GOODS WHERE ID IN (";
public int insertNewRecord(List<Long> outGoodsIds, long lWarehouseFlowId, long dealTime) {
this.updSetNotLast(outGoodsIds);
ArrayList<Object> params = new ArrayList<>();
params.add(lWarehouseFlowId);
params.add(dealTime);
- params.add(outGoodsIds);
- return this.update(insert_new_record, params.toArray());
+ return this.update(insert_new_record + StringUtils.join(outGoodsIds, ",") + ")", params.toArray());
+
}
/**
* 璁剧疆涓洪潪鏈�鏂�
*/
- private static String updSetNotLast = "update L_GOODS_WH_RECORD set LAST_RECORD = 0 where WH_GOODS_ID in(?) and LAST_RECORD=1";
+ private static String updSetNotLast = "update L_GOODS_WH_RECORD set LAST_RECORD = 0 where LAST_RECORD=1 and WH_GOODS_ID in(";
public int updSetNotLast(List<Long> outGoodsIds) {
- ArrayList<Object> params = new ArrayList<>();
- params.add(outGoodsIds);
- return this.update(updSetNotLast, params.toArray());
+ return this.update(updSetNotLast + StringUtils.join(outGoodsIds, ",") + ")", new String[]{});
}
}
--
Gitblit v1.9.1