package QCM.QCM02.QCM0203;

import CoreFS.SA01.CoreIComponent;
import CoreFS.SA06.CoreReturnObject;
import QCM.COMMUNAL.subCommunal;

public class Query extends CoreIComponent {
	private CoreReturnObject cro = null;	
	private StringBuffer sqlucomm =null ;
	//根据轧批号、订单号、产品规范描述查询
	public CoreReturnObject QueryPHYResult(String MaxBatchNo,String MinBatchNo,String ORDER_NO,String PscDesc){
		sqlucomm=new StringBuffer();
		cro=new CoreReturnObject();
		sqlucomm.append("select "+
				"DESIGN_KEY,SMP_NO,PSC,PSC_DESC,HEAT_NO,BATCH_NO,INSPECTION_LOT,DELIVERY_STATE_CODE,"+
				"DELIVERY_STATE_DESC,THICK,WIDTH,LENGTH,PLINE_CODE,PLINE_NAME,MSC_PLINE,PROCESS_CODE,"+
				"CERT_INST_CODE,CERT_INST_NAME,SMP_TYPE_CODE,SMP_TYPE_NAME,SMELTING_CNT,PRODUCT_CNT,"+
				"ASSAY_NO_CP,ASSAY_NO_RL,CIC_ID,PHY_ID,JUDGE_STATUS,JUDGE_RESULT_CODE,JUDGE_RESULT_DESC,"+
				"JUDGE_NAME,JUDGE_TIME,JUDGE_MEMO"+
				" from QCM_JHY_SAMPLE_R_ORD where 1=1");
		if(!"".equals(MinBatchNo)){
			sqlucomm.append(" and to_number(BATCH_NO)>="+subCommunal.sub(MinBatchNo));
		}
		if(!"".equals(MaxBatchNo)){
			sqlucomm.append(" and to_number(BATCH_NO)<="+subCommunal.sub(MaxBatchNo));
		}
		if(!"".equals(PscDesc)){
			sqlucomm.append(" and PSC_DESC='"+PscDesc+"'");
		}
		cro=this.getDao("KgDao").ExcuteQuery(sqlucomm.toString());
		return cro;
	}
}