From 584a165a8d4c0c82479663c9df988fc20226b714 Mon Sep 17 00:00:00 2001
From: luqingyang <lqy5492@163.com>
Date: 星期五, 27 十月 2023 17:23:27 +0800
Subject: [PATCH] 出入库管理 相关代码
---
consum-base/src/main/java/com/consum/base/service/LWhGoodsService.java | 29 +++++++++++++++++++++++------
1 files changed, 23 insertions(+), 6 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..25bf8ac 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;
@@ -38,11 +39,11 @@
paramts.put("warehouseId", warehouseId);
}
if (baseGoodsModelsId != null) {
- sql.append(" and BASE_GOODS_TEMPLATE_ID=:baseGoodsModelsId");
+ sql.append(" and BASE_GOODS_MODELS_ID=:baseGoodsModelsId");
paramts.put("baseGoodsModelsId", baseGoodsModelsId);
}
if (states != null) {
- sql.append(" and STATES=:STATES");
+ sql.append(" and STATES=:states");
paramts.put("states", states);
}
if (buyType != null) {
@@ -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