XinYu_LZMES/.svn/pristine/59/591d84d7eb9b116bea85dd3af3d6c7361a0bc7d8.svn-base

package QCM.QCM02.QCM0202;

import CoreFS.SA01.CoreIComponent;
import CoreFS.SA06.CoreReturnObject;

public class Query extends CoreIComponent  {
	CoreReturnObject cro = new CoreReturnObject();
	//¸ù¾Ý¯ºÅ¡¢ÅƺŲéѯ
	public CoreReturnObject QueryElements(String HeatNo, String SteelName) {
		StringBuffer sqlucomm = new StringBuffer();
		sqlucomm.append("select STEEL_NAME,HEAT_NO,ASSAY_TYPE,Als,Alt,Al,A0,B,Cu,Cr,Ca,C,Mn,Mo,Ni,N,Nb,O,P,Si,Sn,S,V,W,Ti,Zn,Pb "+
				" from view_QcmElements where 1=1");
		if(!("").equals(HeatNo)){
			sqlucomm.append(" and HEAT_NO='"+HeatNo+"'");
		}
		if(!("").equals(SteelName)){
			sqlucomm.append(" and  STEEL_NAME='"+SteelName+"'");
		}
		cro=this.getDao("KgDao").ExcuteQuery(sqlucomm.toString());
		return cro;
	}	

}