package com.consum.base.service;
|
|
import com.consum.base.core.WhBusinessEnum;
|
import com.consum.model.po.LWhProcureModel;
|
import com.walker.jdbc.service.BaseServiceImpl;
|
import org.springframework.stereotype.Service;
|
|
import java.util.HashMap;
|
import java.util.List;
|
|
/**
|
* @ClassName LWhProcureModelService
|
|
* @Date 2023/10/24
|
* @Description
|
* @Version 1.0
|
**/
|
@Service
|
public class LWhProcureModelService extends BaseServiceImpl {
|
|
private static String GET_MODEL_BY_FORM = "SELECT * FROM L_WH_PROCURE_MODEL WHERE 1=1 ";
|
|
/**
|
* 通过单据类型 单据ID查询该订单关联的设备型号以及数量
|
*
|
* @return
|
*/
|
public List<LWhProcureModel> getModelByForm(WhBusinessEnum businessType, Long businessId) {
|
StringBuilder sql = new StringBuilder(GET_MODEL_BY_FORM);
|
HashMap<String, Object> paramts = new HashMap<>();
|
//项目阶段id
|
if (businessType != null) {
|
sql.append(" and BUSINESS_TYPE=:businessType ");
|
paramts.put("businessType", businessType.getValue());
|
}
|
if (businessId != null) {
|
sql.append(" and BUSINESS_ID=:businessId ");
|
paramts.put("businessId", businessId);
|
}
|
return this.select(sql.toString(), paramts, new LWhProcureModel());
|
}
|
}
|
