From b8dc4ccc6ee580b084aa860e64af2d90d1cb5979 Mon Sep 17 00:00:00 2001
From: 石广澎 <shiguangpeng@163.com>
Date: 星期三, 29 十一月 2023 10:11:52 +0800
Subject: [PATCH] feat: 1、首页接口对接 2、部门物品分发
---
consum-base/src/main/java/com/consum/base/service/LWhGoodsRecordDetailsService.java | 17 ++++++++++++++---
1 files changed, 14 insertions(+), 3 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 6925783..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,18 +3,19 @@
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;
/**
* @ClassName LWhGoodsRecordDetailsService
- * @Author cy
* @Date 2023/10/31
* @Description
* @Version 1.0
@@ -24,15 +25,25 @@
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) {
SqlParameterSource in = new MapSqlParameterSource()
- .addValue("WHGOODSIDList", StringUtils.join(outGoodsId))
+ .addValue("WHGOODSIDList", StringUtils.join(outGoodsId, ","))
.addValue("WH_GOODS_RECORD_ID", whGoodsRecordId)
.addValue("THIS_TYPE", thisType);
Map<String, Object> out = simpleJdbcCall.execute(in);
--
Gitblit v1.9.1