From 12b37691692364c8cb3f76fdc7f3ffddc89eb891 Mon Sep 17 00:00:00 2001 From: futian.liu <liufutianyoo@163.com> Date: 星期一, 18 十二月 2023 17:05:42 +0800 Subject: [PATCH] 调拨出库回显时间 --- consum-base/src/main/java/com/consum/base/service/impl/BaseGoodsTemplateServiceImpl.java | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/consum-base/src/main/java/com/consum/base/service/impl/BaseGoodsTemplateServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/impl/BaseGoodsTemplateServiceImpl.java index 1df8590..2f11f09 100644 --- a/consum-base/src/main/java/com/consum/base/service/impl/BaseGoodsTemplateServiceImpl.java +++ b/consum-base/src/main/java/com/consum/base/service/impl/BaseGoodsTemplateServiceImpl.java @@ -236,7 +236,7 @@ */ @Override public BaseGoodsTemplate getByGoodsNameAndCategoryId(String goodsName, Long categoryId) { - StringBuilder sql = new StringBuilder("SELECT * FROM base_goods_template WHERE 1 = 1 "); + StringBuilder sql = new StringBuilder("SELECT * FROM base_goods_template WHERE STATES != 3 "); HashMap<String, Object> paramts = new HashMap<>(); // 鐗╁搧鍚嶇О @@ -334,7 +334,7 @@ * @return */ @Override - public List<BaseGoodsTemplate> queryGoodsTemplateByCategoryId(Long agencyId, Long categoryId, Short states, + public List<BaseGoodsTemplate> queryGoodsTemplateByCategoryId(Long agencyId, Long categoryId, Integer states, String goodsName) { StringBuilder sql = new StringBuilder("SELECT * FROM base_goods_template WHERE 1=1 "); Map<String, Object> params = new HashMap<>(); -- Gitblit v1.9.1