From a5e195c4d1cf661ec0f1c03517ce3b5436b7e5b2 Mon Sep 17 00:00:00 2001 From: cy <1664593601@qq.com> Date: 星期五, 24 十一月 2023 17:03:49 +0800 Subject: [PATCH] feat: 对仓库内物品按型号进行预警判断 --- consum-base/src/main/java/com/consum/base/service/LWhGoodsRecordDetailsService.java | 14 +++++++++++++- 1 files changed, 13 insertions(+), 1 deletions(-) diff --git a/consum-base/src/main/java/com/consum/base/service/LWhGoodsRecordDetailsService.java b/consum-base/src/main/java/com/consum/base/service/LWhGoodsRecordDetailsService.java index a77f32a..f93b26e 100644 --- a/consum-base/src/main/java/com/consum/base/service/LWhGoodsRecordDetailsService.java +++ b/consum-base/src/main/java/com/consum/base/service/LWhGoodsRecordDetailsService.java @@ -3,12 +3,14 @@ import com.walker.jdbc.service.BaseServiceImpl; import org.apache.commons.lang3.StringUtils; import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.beans.factory.annotation.Value; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.jdbc.core.namedparam.MapSqlParameterSource; import org.springframework.jdbc.core.namedparam.SqlParameterSource; import org.springframework.jdbc.core.simple.SimpleJdbcCall; import org.springframework.stereotype.Service; +import javax.annotation.PostConstruct; import java.util.List; import java.util.Map; @@ -23,10 +25,20 @@ private final JdbcTemplate jdbcTemplate; private SimpleJdbcCall simpleJdbcCall; + @Value("${spring.datasource.dataBaseName}") + private String dataBaseName; + + @PostConstruct + public void init() { + this.simpleJdbcCall = new SimpleJdbcCall(jdbcTemplate) + .withCatalogName(dataBaseName) + .withProcedureName("insert_WH_GOODS_RECORD_DETAILS"); + } + + @Autowired public LWhGoodsRecordDetailsService(JdbcTemplate jdbcTemplate) { this.jdbcTemplate = jdbcTemplate; - this.simpleJdbcCall = new SimpleJdbcCall(jdbcTemplate).withProcedureName("insert_WH_GOODS_RECORD_DETAILS"); } public void sameGoodsInsertMore(List<Long> outGoodsId, long whGoodsRecordId, short thisType) { -- Gitblit v1.9.1