Cacher is the code snippet organizer for pro developers

//没有金库编号默认所有金库
	            if(null==clrCenterNo) {
	            	qryTransferNo+= " and str.CLR_CENTER_NO in (select CLR_CENTER_NO from CLR_CENTER_TABLE)) ";
	            }else {
	            	sqlParas.add(new SQLPara("CLR_CENTER_NO",Types.VARCHAR,clrCenterNo));
	            	qryTransferNo+= " and str.CLR_CENTER_NO = ? ";
	            }
	            
	            qryTransferNo+="order by str.CLR_CENTER_NO";