package com.consum.base.service;
|
|
import com.walker.jdbc.service.BaseServiceImpl;
|
import org.springframework.stereotype.Service;
|
|
import java.util.HashMap;
|
import java.util.Map;
|
|
/**
|
* @ClassName LWhGoodsService
|
* @Author cy
|
* @Date 2023/10/24
|
* @Description
|
* @Version 1.0
|
**/
|
@Service
|
public class LWhGoodsService extends BaseServiceImpl {
|
|
|
/**
|
* @param warehouseId 所属仓库仓库编号
|
* @param baseGoodsModelsId 规格型号编号
|
* @param states （0=在途调拨；1=入库未分发；2=已下发；3=报废）
|
* @param buyType 采购方式（1：集采；2=自采）
|
* @return 查询某个型号在仓库中的数量
|
*/
|
private static String query_Goods_Model_Num = "SELECT COUNT(1) from L_WH_GOODS where 1=1";
|
|
public int queryGoodsModelNum(Long warehouseId, Long baseGoodsModelsId, Short states, Short buyType) {
|
StringBuilder sql = new StringBuilder(query_Goods_Model_Num);
|
Map<String, Object> paramts = new HashMap<>();
|
|
if (warehouseId != null) {
|
sql.append(" and WAREHOUSE_ID=:warehouseId");
|
paramts.put("warehouseId", warehouseId);
|
}
|
if (baseGoodsModelsId != null) {
|
sql.append(" and BASE_GOODS_TEMPLATE_ID=:businessId");
|
paramts.put("baseGoodsModelsId", baseGoodsModelsId);
|
}
|
if (states != null) {
|
sql.append(" and STATES=:STATES");
|
paramts.put("states", states);
|
}
|
if (buyType != null) {
|
sql.append(" and BUY_TYPE=:buyType");
|
paramts.put("buyType", buyType);
|
}
|
return queryForInt(sql.toString(), paramts);
|
}
|
}
|
