package UIK.UIK09;

import java.sql.SQLException;

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

public class UIK090010 extends CoreIComponent{

	public CoreReturnObject DoQuery(String starttime,String endtime,Boolean flag ) throws SQLException
	{
			System.out.println(starttime + "---" + endtime + "--" + flag);
			CoreReturnObject cro = new CoreReturnObject();
			
			String sqlQuery = "select reg_id, reg_dtime, alter_dtime, sam_date, sam_time, sam_address, dis_fe, dis_acid, "
				+ " reg_fe, reg_acid, new_cl, new_acid, acid_concent, fe_concent, cl_content, water from tbs03_l2_inspection_snd";
			
			if(!flag)
			{
				
					cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
					
					return cro;
					
			}
			else
			{
								
					sqlQuery	=	sqlQuery+" where reg_dtime >=  '" + starttime + "' and reg_dtime <= '" + endtime + "'";
					
					cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
					
					return cro;
				
			}
	}

}