From e19d9742d5d14823bc414b1d1d47778b3daee227 Mon Sep 17 00:00:00 2001
From: futian.liu <liufutianyoo@163.com>
Date: 星期二, 19 十二月 2023 09:24:56 +0800
Subject: [PATCH] 盘点时库存查询不分仓库类型
---
consum-base/src/main/java/com/consum/base/service/impl/BaseGoodsModelsServiceImpl.java | 11 +++++++++++
1 files changed, 11 insertions(+), 0 deletions(-)
diff --git a/consum-base/src/main/java/com/consum/base/service/impl/BaseGoodsModelsServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/impl/BaseGoodsModelsServiceImpl.java
index 8b34c8a..f83629a 100644
--- a/consum-base/src/main/java/com/consum/base/service/impl/BaseGoodsModelsServiceImpl.java
+++ b/consum-base/src/main/java/com/consum/base/service/impl/BaseGoodsModelsServiceImpl.java
@@ -145,4 +145,15 @@
return select(sql.toString(), paramts, new MapperUtil());
}
+ @Override
+ public List<BaseGoodsModels> queryGoodsModelByGoodsTemplatesId(Long baseGoodsModelsId) {
+ StringBuilder sql = new StringBuilder("select * from base_goods_models where states != 3 ");
+ HashMap<String, Object> param = new HashMap<>();
+ if (baseGoodsModelsId != null) {
+ sql.append("and goods_templates_id=:baseGoodsModelsId");
+ param.put("baseGoodsModelsId", baseGoodsModelsId);
+ }
+ return select(sql.toString(), param, new BaseGoodsModels());
+ }
+
}
--
Gitblit v1.9.1