XinYu_LZMES/.svn/pristine/5f/5f56fb2b0e1a1e519fb66bcf47375fb5e9c5934c.svn-base

package UIB.JHY;

import java.util.ArrayList;

import org.springframework.jdbc.support.rowset.SqlRowSet;

import UIB.COM.XmlSqlParsersFactory;
import CoreFS.SA01.CoreIComponent;
import CoreFS.SA06.CoreReturnObject;

/**
 * 
 * @desc   按检验项目对原始数据查询   
 * @author meiguiping
 * @date   2014/3/27
 */
public class UIB100220 extends	CoreIComponent
{
	/**
	 * qltyCD2 二级编码 即：拉力，冲击等区分
	 * qltyCD3 三级编码 即：伸长率，屈服强度，抗拉强度等   
	 * wtbh  委托编号
	 */
	public  CoreReturnObject doQltyCdQuery(String qltyCD2 ,String qltyCD3 ,String wtbh ,String strArr , String strSendTP ,String qltyCD)throws Exception
	{
		//获取所有的检化验编码，如a,b,Lo,S等
		
		CoreReturnObject	cro	=	new CoreReturnObject();
		String				sqlOne	=	XmlSqlParsersFactory.getSql("UIB100220_03.SELECT");
		cro	=	this.getDao("JhyDao").ExecutequeryForRowSet(sqlOne , new Object[]{qltyCD2 });
		SqlRowSet			srs		=	(SqlRowSet)cro.getResult();
		
		//获取目的SQL
		String				repSql	=	",MAX(DECODE('{2}', T1.QLTY_OPE_CD , T1.QLTY_VAL , NULL)) \"{3}\"";
		String				temp	=	"";
		StringBuffer		sBuffer	=	new StringBuffer(350);
		String				qltyNm	=	"";
		while(srs.next())
		{
			temp	=	repSql.replaceFirst("[{]+[2]+[}]+", srs.getString(1)).replaceFirst("[{]+[3]+[}]+", srs.getString("QLTY_OPE_CFNM"));//检验项目
			sBuffer.append(temp);
		}
		String	sqlAim			=	XmlSqlParsersFactory
													.getSql("UIB100220_04.SELECT")
													.replaceFirst("[{]+[1]+[}]+", sBuffer.toString());
		
		cro	=	this.getDao("JhyDao").ExcuteQuery(sqlAim , new Object[]{wtbh , qltyCD2 , wtbh , qltyCD2 , qltyCD3 /*,strArr , strSendTP*/ , qltyCD} );

		return cro;
	}
}