From 20249c17d5b28c588e88451545af291995271f9c Mon Sep 17 00:00:00 2001
From: futian.liu <liufutianyoo@163.com>
Date: 星期五, 15 十二月 2023 14:07:21 +0800
Subject: [PATCH] 1.出库手续回显 2.调拨申请时库存查询更换接口
---
consum-base/src/main/java/com/consum/base/service/impl/LWhGoodsServiceImpl.java | 29 +++++++++++++++++++++++++++++
1 files changed, 29 insertions(+), 0 deletions(-)
diff --git a/consum-base/src/main/java/com/consum/base/service/impl/LWhGoodsServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/impl/LWhGoodsServiceImpl.java
index cab1558..caeb70c 100644
--- a/consum-base/src/main/java/com/consum/base/service/impl/LWhGoodsServiceImpl.java
+++ b/consum-base/src/main/java/com/consum/base/service/impl/LWhGoodsServiceImpl.java
@@ -66,6 +66,35 @@
return queryForInt(sql.toString(), paramts);
}
+ @Override
+ public int queryGoodsModelInWareHouseNum(Integer warehouseType, List<Long> warehouseId, Long baseGoodsModelsId,
+ Integer states, Integer buyType) {
+ StringBuilder sql = new StringBuilder(query_Goods_Model_Num);
+ Map<String, Object> paramts = new HashMap<>();
+
+ if (warehouseType != null) {
+ sql.append(" and WAREHOUSE_TYPE=:warehouseType");
+ paramts.put("warehouseType", warehouseType);
+ }
+ if (warehouseId != null) {
+ sql.append(" and WAREHOUSE_ID in (:warehouseId)");
+ paramts.put("warehouseId", warehouseId);
+ }
+ if (baseGoodsModelsId != null) {
+ sql.append(" and BASE_GOODS_MODELS_ID=:baseGoodsModelsId");
+ paramts.put("baseGoodsModelsId", baseGoodsModelsId);
+ }
+ if (states != null) {
+ sql.append(" and STATES=:states");
+ paramts.put("states", states);
+ }
+ if (buyType != null) {
+ sql.append(" and BUY_TYPE=:buyType");
+ paramts.put("buyType", buyType);
+ }
+ return queryForInt(sql.toString(), paramts);
+ }
+
/**
* 鍑哄簱鏃跺�欙紝鍏堝叆搴撶殑鍏堝嚭搴擄紝鍚屾椂鍏ュ簱鐨勶紝鎸変环鏍奸珮鐨勫厛鍑哄簱
*
--
Gitblit v1.9.1