package QCM.QCM01.QCM0103;
import CoreFS.SA01.CoreIComponent;
import CoreFS.SA06.CoreReturnObject;

public class QueryTol extends CoreIComponent   {

	CoreReturnObject cro = new CoreReturnObject();	
	
	//������Ŀ����
	public CoreReturnObject Query(String tolName){
		StringBuffer sqlucomm = new StringBuffer();
		sqlucomm.append("select \n"+ 
				"tol_code,tol_name,auto_cacl,defect_type_code,defect_type_desc, \n"+
				"defect_seq,os1_tol_code,os1_tol_name,os2_tol_code,os2_tol_name,validflag, \n"+
				"memo,create_id,create_name,TO_CHAR(create_time,'YYYY-MM-DD HH24:MI:SS')  create_time,update_id,update_name, \n"+
				"TO_CHAR(update_time,'YYYY-MM-DD HH24:MI:SS') update_time,delete_id,delete_name, TO_CHAR(delete_time,'YYYY-MM-DD HH24:MI:SS') delete_time \n"+
				" from QCM_BASE_TOLERANCE"+
				" where VALIDFLAG='1'");
		if(!"".equals(tolName)){
			sqlucomm.append(" and TOL_NAME like '%"+tolName+"%' ");
		}
		cro=this.getDao("KgDao").ExcuteQuery(sqlucomm.toString());
		return cro;
	}
}