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

public class QueryChem extends CoreIComponent   {
	CoreReturnObject cro = new CoreReturnObject();	
	// 根据化学元素名称查询 或者 全查询
	public CoreReturnObject Query(String chemName) {
		StringBuffer sqlucomm = new StringBuffer();
			sqlucomm.append("select \n"+
				"CHEM_CODE,CHEM_NAME,CHEM_TYPE,CHEM_FORMULA,DEFECT_TYPE_CODE,DEFECT_TYPE_DESC, \n"+
				"CHEM_CODE_1LG,CHEM_CODE_2LG,ROUND_OFF_RULES_NAME,ROUND_OFF_RULES_CODE,ROUND_OFF_DIGITS,VALIDFLAG, \n"+
				"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 \n"+
				" FROM QCM_BASE_CHEM \n"+
				" WHERE  VALIDFLAG='1' ");
		if(!"".equals(chemName)){
			sqlucomm.append(" and lower(CHEM_NAME)=lower('"+chemName+"') ");
		}
		cro=this.getDao("KgDao").ExcuteQuery(sqlucomm.toString());
		return cro;
	}
}