查询

service
//k2018.11.28
StringBuilder conNumSb = new StringBuilder("(");
StringBuilder projNumSb = new StringBuilder("(");
StringBuilder stageCodeSb = new StringBuilder("(");

	Set<String> conNumSet = new HashSet<String>();
	Set<String> stageCodeSet = new HashSet<String>();
	Set<String> projNumSet = new HashSet<String>();
	
	List<SrmConAuthorization> srmConAuthorizationList = srmConAuthorizationDao.getUserAuthorizationByUserId(userId);
	for(SrmConAuthorization auth : srmConAuthorizationList) {
		if(org.apache.commons.lang.StringUtils.isNotBlank(auth.getConNum())) {
			conNumSet.add(auth.getConNum());
			conNumSb.append("'").append(auth.getConNum()).append("',");
		}
		if(org.apache.commons.lang.StringUtils.isNotBlank(auth.getStageCode()) && !conNumSet.contains(auth.getConNum())) {
			stageCodeSet.add(auth.getStageCode());
			stageCodeSb.append("'").append(auth.getStageCode()).append("',");
		}
		if(org.apache.commons.lang.StringUtils.isNotBlank(auth.getProjNum()) && !conNumSet.contains(auth.getConNum()) && !stageCodeSet.contains(auth.getStageCode())) {
			projNumSb.append("'").append(auth.getProjNum()).append("',");
		}
	}
	String conNumStr = null ;
	String projNumStr = null ;
	String stageCodeStr = null ;
	if(conNumSb.length() >1) {
		conNumStr = conNumSb.substring(0,conNumSb.length()-1)+")";
	}
	if(projNumSb.length() >1) {
		projNumStr = projNumSb.substring(0,projNumSb.length()-1)+")";
	}
	if(stageCodeSb.length() >1) {
		stageCodeStr = stageCodeSb.substring(0,stageCodeSb.length()-1)+")";
	}
	return conHeaderDao.listAllAndUnion(dto, pageIndex, pageSize, orgIdList, userId,conNumStr,projNumStr,stageCodeStr);

dao
sb.append(" AND ( 1 = 2 ");
if (StringUtils.isNotEmpty(conNumStr)) {
sb.append("OR t.CONTRACT_NUM in ").append(conNumStr);
//params.put(“contractNum”, conNumStr);
}
if (StringUtils.isNotEmpty(stageCodeStr) ) {
sb.append("OR t.BYSAG_NUM in ").append(stageCodeStr);
//params.put(“bysagNum”, stageCodeStr);
}
if (StringUtils.isNotEmpty(projNumStr)) {
sb.append("OR t.PROJ_NUM in ").append(projNumStr);
//params.put(“projNum”, projNumStr);
}

	sb.append(")");
	if(StringUtils.isEmpty(conNumStr) && StringUtils.isEmpty(stageCodeStr) && StringUtils.isEmpty(projNumStr)) {
		sb.append( "AND 1 = 2 ");
	}