package com.consum.base.service;
|
|
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
|
* @Date 2023/10/31
|
* @Description
|
* @Version 1.0
|
**/
|
@Service
|
public class LWhGoodsRecordDetailsService extends BaseServiceImpl {
|
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;
|
}
|
|
public void sameGoodsInsertMore(List<Long> outGoodsId, long whGoodsRecordId, short thisType) {
|
SqlParameterSource in = new MapSqlParameterSource()
|
.addValue("WHGOODSIDList", StringUtils.join(outGoodsId, ","))
|
.addValue("WH_GOODS_RECORD_ID", whGoodsRecordId)
|
.addValue("THIS_TYPE", thisType);
|
Map<String, Object> out = simpleJdbcCall.execute(in);
|
System.out.println("Procedure result: " + out);
|
}
|
|
}
|
