package QCM.QCM01.QCM0105;

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


public class QueryDefect extends CoreIComponent  {

	CoreReturnObject cro = new CoreReturnObject();	
	
	//ȱ����Ŀ����
	public CoreReturnObject Query(String defectTypeDesc){
		StringBuffer sqlucomm = new StringBuffer();
		sqlucomm.append("select " +
				" PLINE_CODE,PLINE_NAME,DEFECT_CODE,DEFECT_DESC,DEFECT_TYPE_CODE,DEFECT_TYPE_DESC,OS1_DEFECT_CODE," +
				"OS1_DEFECT_NAME,OS2_DEFECT_CODE,OS2_DEFECT_NAME,VALIDFLAG,MEMO,CREATE_ID,CREATE_NAME,"+
				"TO_CHAR(CREATE_TIME,'YYYY-MM-DD HH24:MI:SS') CREATE_TIME,UPDATE_ID,UPDATE_NAME,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" +
				" from QCM_BASE_DEFECT"+
				" where VALIDFLAG='1'");
		if(!"".equals(defectTypeDesc)){
			sqlucomm.append(" and DEFECT_DESC like '%"+defectTypeDesc+"%' ");
		}
		cro=this.getDao("KgDao").ExcuteQuery(sqlucomm.toString());
		return cro;
	}
}