| | |
| | | package com.vci.web.dao.impl; |
| | | |
| | | import com.vci.client.omd.provider.BtmProvider; |
| | | import com.vci.starter.web.constant.QueryOptionConstant; |
| | | import com.vci.starter.web.exception.VciBaseException; |
| | | import com.vci.starter.web.pagemodel.PageHelper; |
| | |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Repository; |
| | | import org.springframework.util.CollectionUtils; |
| | | import plm.bs.bom.clientobject.ClientBusinessObject; |
| | | import plm.vo.omd.btm.common.BtmProvider; |
| | | |
| | | import java.util.*; |
| | | |
| | |
| | | //先查询明细,明细应该不会有1000条 |
| | | Map<String,String> conditionMap = new HashMap<String, String>(); |
| | | conditionMap.put("ruleOid",ruleOid); |
| | | String sql = " select a.oid as oid from " + BtmProvider.getInstance().getBTMTableName(BtmIdConstant.OS_CODE_ENUM_BTM_TYPE) + " a left join " |
| | | + BtmProvider.getInstance().getBTMTableName(BtmIdConstant.OS_CODE_RULE_ELEMENT_BTM_TYPE) + " b on a.pkCodeRuleElement = b.oid where b.pkCodeRule = :ruleOid"; |
| | | String sql = " select a.oid as oid from " + BtmProvider.getInstance().getBTTableName(BtmIdConstant.OS_CODE_ENUM_BTM_TYPE) + " a left join " |
| | | + BtmProvider.getInstance().getBTTableName(BtmIdConstant.OS_CODE_RULE_ELEMENT_BTM_TYPE) + " b on a.pkCodeRuleElement = b.oid where b.pkCodeRule = :ruleOid"; |
| | | List<com.vci.client.bof.ClientBusinessObject> enumCbos = boService.queryBySql(sql, conditionMap); |
| | | if(CollectionUtils.isEmpty(enumCbos)){ |
| | | return new ArrayList<OsCodeEnumDO>(); |