package UIK.UIK01;

import java.sql.SQLException;

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

public class UIK010060 extends CoreIComponent{

	public CoreReturnObject DoQuery(String starttiem,String endtime,Boolean flag) throws SQLException
	{
			CoreReturnObject cro = new CoreReturnObject();
			
			String str = "ACID_CONCENT_1,TEMPERATURE_1,FE_CONCENT_1,ACID_CONCENT_2,TEMPERATURE_2,FE_CONCENT_2,ACID_CONCENT_3,TEMPERATURE_3,FE_CONCENT_3,BEGIN_TIME,END_TIME,REG_ID,TO_CHAR(REG_DTIME,'YYYY-MM-DD HH24:MI:SS') REG_DTIME,ALTER_DTIME,REG_ACID,REG_FE,NEW_ACID,DIS_ACID,DIS_FE,TO_CHAR(SAM_TATE,'YYYY-MM-DD') SAM_TATE,SAM_TIME,SAM_ADDRESS,CL_DEEP";
			
			if(!flag)
			{
				
					String sqlQuery	=	"select " + str+" from C_TBK01_SX_RESULT";
				       
					cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
					
					return cro;

					
			}
			else
			{
								
					String sqlQuery	=	"select " + str+" from C_TBK01_SX_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;
				
			}

	}

}