package UIK.UIK05;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Map;

import org.springframework.jdbc.support.rowset.SqlRowSet;

import UIB.COM.XmlSqlParsersFactory;

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

public class UIK050100 extends CoreIComponent {
	
	public CoreReturnObject DoQuery(String in_start_time,String in_end_time,String C_SPEC_STL_GRD,String I_C_OUT_YARD,Integer queryType) throws SQLException
	{
			CoreReturnObject cro = new CoreReturnObject();
			if(queryType == 0)
			{
				String sqlQuery = XmlSqlParsersFactory.getSql("UIK050100_01.SELECT");
				cro = this.getDao("KgDao").ExcuteQuery(sqlQuery,new Object[]{in_start_time, in_end_time,I_C_OUT_YARD,in_start_time, in_end_time,I_C_OUT_YARD,in_start_time,in_end_time, C_SPEC_STL_GRD});			
				return cro;
			}
			if(queryType == 1)
			{
				String sqlQuery = XmlSqlParsersFactory.getSql("UIK050100_02.SELECT");
				cro = this.getDao("KgDao").ExcuteQuery(sqlQuery,new Object[]{in_start_time, in_end_time,I_C_OUT_YARD,in_start_time, in_end_time,I_C_OUT_YARD,in_start_time,in_end_time, C_SPEC_STL_GRD});			
				return cro;
			}
			if(queryType == 2)
			{
				String sqlQuery = XmlSqlParsersFactory.getSql("UIK050100_03.SELECT");
				cro = this.getDao("KgDao").ExcuteQuery(sqlQuery,new Object[]{in_start_time, in_end_time,I_C_OUT_YARD,in_start_time, in_end_time,I_C_OUT_YARD,in_start_time,in_end_time, C_SPEC_STL_GRD});			
				return cro;
			}
			return cro;
	}
}