package QCM.QCM01.QCM0104;

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

public class QueryDete extends CoreIComponent  {

	CoreReturnObject cro = new CoreReturnObject();	
	//������̽������
	public CoreReturnObject Query(String detectionName){
		StringBuffer sqlucomm = new StringBuffer();
		sqlucomm.append("select DETECTION_CODE,DETECTION_NAME,OS1_DETECTION_CODE,OS1_DETECTION_NAME,OS2_DETECTION_CODE,OS2_DETECTION_NAME,"+
				"DEFECT_TYPE_CODE,DEFECT_TYPE_DESC,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_DETECTION"+
				" where VALIDFLAG='1' ");
		if(!"".equals(detectionName)){
			sqlucomm.append(" and DETECTION_NAME like '%"+detectionName+"%' ");
		}
		cro=this.getDao("KgDao").ExcuteQuery(sqlucomm.toString());
		return cro;
	}
}