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

public class QueryPhy extends CoreIComponent  {

	CoreReturnObject cro = new CoreReturnObject();	
	
	//������Ŀ���Ʋ�ѯ
	public CoreReturnObject Query(String phyGrpDesc){
		StringBuffer sqlucomm = new StringBuffer();
		sqlucomm.append("select PHY_GRP_CODE,PHY_GRP_DESC,PHY_CODE_L,PHY_DESC_L,PHY_CODE_M,PHY_DESC_M,PHY_CODE_S,PHY_NAME_S,"+
				"ITEM_CODE_D,ITEM_DESC_D,ITEM_CODE_T,ITEM_DESC_T,ITEM_CODE_S,ITEM_DESC_S,PHY_UNIT,OS1_PHY_GRP_CODE,OS1_PHY_GRP_DESC,"+
				"OS2_PHY_GRP_CODE,OS2_PHY_GRP_DESC,HOUR_READY,HOUR_TEST,DEFECT_TYPE_CODE,DEFECT_TYPE_DESC,DEFECT_SEQ,ROUND_OFF_RULES_CODE,"+
				"ROUND_OFF_RULES_NAME,ROUND_OFF_DIGITS,ROUND_OFF_GAP,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_PHY"+
				" where VALIDFLAG='1' ");
		if(!"".equals(phyGrpDesc)){
			sqlucomm.append(" and PHY_GRP_DESC like '%"+phyGrpDesc+"%' ");
		}
		cro=this.getDao("KgDao").ExcuteQuery(sqlucomm.toString());
		return cro;
	}
}