package UIK.UIK01;

import java.sql.SQLException;

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

public class UIK010030 extends CoreIComponent{

	public CoreReturnObject DoQuery(String starttiem,String endtime,Boolean flag ) throws SQLException
	{
			CoreReturnObject cro = new CoreReturnObject();
			
			String str = "DENSITY,VISCOSITY,FLASH_POINT,FREEZ_POINT,STABILITY,CONCENT,ESI,ACID,PH,CONDUCTIVITY,SAPONIFICATION_VALUE,FE_VALUE,ASH_VALUE,C_VALUE,CL_VALUE,BACTERIA_FUNGI,TEMPERATURE,REG_ID,TO_CHAR(REG_DTIME,'YYYY-MM-DD HH24:MI:SS') REG_DTIME,MAG_OIL,BER_CON,TO_CHAR(SAM_DATE,'YYYY-MM-DD') SAM_DATE,SAM_TIME,SAM_ADDRESS,CANYOU,CATIE,STL_GRD,TYPH";
			
			if(!flag)
			{
				
					String sqlQuery	=	"select " + str+" from C_TBK01_RH_RESULT";
				       
					cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
					
					return cro;
					
			}
			else
			{
								
					String sqlQuery	=	"select " + str+" from C_TBK01_RH_RESULT where REG_DTIME >=  TO_DATE('"+starttiem+"','YYYY-MM-DD HH24:MI:SS') and REG_DTIME <=  TO_DATE('"+endtime+"','YYYY-MM-DD HH24:MI:SS')";
					
					cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
					
					return cro;
				
			}
	}

}