From 5d7ab4ea0ef70f7930cc7b3a4209ded1b1c83115 Mon Sep 17 00:00:00 2001
From: cy <1664593601@qq.com>
Date: 星期四, 26 十月 2023 20:14:21 +0800
Subject: [PATCH] feat: 根据调拨单生成出库单，根据出库单id进行出库
---
consum-base/src/main/java/com/consum/base/service/LWhGoodsService.java | 25 +++++++++++++++++++++----
1 files changed, 21 insertions(+), 4 deletions(-)
diff --git a/consum-base/src/main/java/com/consum/base/service/LWhGoodsService.java b/consum-base/src/main/java/com/consum/base/service/LWhGoodsService.java
index 3275512..3d769c0 100644
--- a/consum-base/src/main/java/com/consum/base/service/LWhGoodsService.java
+++ b/consum-base/src/main/java/com/consum/base/service/LWhGoodsService.java
@@ -4,6 +4,7 @@
import com.walker.jdbc.service.BaseServiceImpl;
import org.springframework.stereotype.Service;
+import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
@@ -115,10 +116,26 @@
* @param toWarehouseName
* @return
*/
- private static String MOD_GOODS_TRANSFERING = "";
+ private static String MOD_GOODS_TRANSFERING_PREFIX = "update L_WH_GOODS set";
- public int modGoodsTransfering(List<Long> whGoods, Long toWarehouseId, String toWarehouseName) {
-//upda
- return 0;
+ public int modGoodsTransfering(List<Long> whGoods, Long toWarehouseId, String toWarehouseName, Short states) {
+ StringBuilder sql = new StringBuilder(MOD_GOODS_TRANSFERING_PREFIX);
+ ArrayList<Object> params = new ArrayList<>();
+ if (toWarehouseId != null) {
+ sql.append(", WAREHOUSE_ID=?");
+ params.add(toWarehouseId);
+ }
+ if (toWarehouseName != null) {
+ sql.append(", WAREHOUSE_NAME=?");
+ params.add(toWarehouseName);
+ }
+ if (states != null) {
+ sql.append(", STATES=?");
+ params.add(states);
+ }
+ sql.deleteCharAt(22);
+ sql.append(" where id in(?)");
+ params.add(whGoods);
+ return update(sql.toString(), params.toArray());
}
}
--
Gitblit v1.9.1