package UIF.UIF04;

import java.sql.SQLException;
import java.util.ArrayList;
import java.lang.Object;
import CoreFS.SA01.CoreIComponent;
import CoreFS.SA06.CoreReturnObject;
import UIB.COM.XmlSqlParsersFactory;

public class UIF041050 extends CoreIComponent 
{
	public CoreReturnObject Query_GrpLen_Info(String GrpType)
	{
		try
		{
			CoreReturnObject rtnobj=new CoreReturnObject();
			String Sql = "";
			if(GrpType.equals("ΊρΆΘ"))
			{
				Sql = XmlSqlParsersFactory.getSql("UIF041050.Query_THKLen_List");
			}
			else
			{
				Sql = XmlSqlParsersFactory.getSql("UIF041050.Query_WTHLen_List");
			}
			rtnobj=this.getDao("KgDao").ExcuteQuery(Sql);
			return rtnobj;
		}
		catch(Exception ex)
		{
			CoreReturnObject err = new CoreReturnObject();
			err.SetErrInfo(ex.toString());
			return err;
		}
	}
	public CoreReturnObject Commit_GrpLen_Info(String ExeSql)
	{
		try
		{
			CoreReturnObject rtnobj=new CoreReturnObject();
			rtnobj=this.getDao("KgDao").ExcuteNonQuery(ExeSql);		
			return rtnobj;
		}
		catch(Exception ex)
		{
			CoreReturnObject err = new CoreReturnObject();
			err.SetErrInfo(ex.toString());
			return err;
		}
	}
	public CoreReturnObject Query_GRP_DATA() throws SQLException
	{
		try
		{
			CoreReturnObject cro=new CoreReturnObject();
			java.util.ArrayList rtn_list = new java.util.ArrayList();
			rtn_list.add(Query_THK_GRP());
			rtn_list.add(Query_WTH_GRP());
			
			cro.setResult(rtn_list);
			return cro;
		}
		catch(Exception ex)
		{
			CoreReturnObject err = new CoreReturnObject();
			err.SetErrInfo(ex.toString());
			return err;
		}
	}
	private Object Query_THK_GRP()
	{
		try
		{
			Object obj = new Object();
			String Sql = XmlSqlParsersFactory.getSql("UIF041050.Query_THK_GRP");
			obj=this.getDao("KgDao").ExcuteQuery(Sql).getResult();
			return obj;
		}
		catch(Exception ex)
		{
			System.out.print(ex.toString());
			return null;
		}
	}
	private Object Query_WTH_GRP()
	{
		try
		{
			Object obj = new Object();
			String Sql = XmlSqlParsersFactory.getSql("UIF041050.Query_WTH_GRP");
			obj=this.getDao("KgDao").ExcuteQuery(Sql).getResult();
			return obj;
		}
		catch(Exception ex)
		{
			System.out.print(ex.toString());
			return null;
		}
	}
}