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 UIF041030 extends CoreIComponent 
{
	public CoreReturnObject Query_Group_Info(String Condition,String GrpType)
	{
		try
		{
			CoreReturnObject rtnobj=new CoreReturnObject();
			String Sql = "";
			if(GrpType.equals("ΊρΆΘ"))
			{
				Sql = XmlSqlParsersFactory.getSql("UIF041030.Query_THKGrp_List");
			}
			else
			{
				Sql = XmlSqlParsersFactory.getSql("UIF041030.Query_WTHGrp_List");
			}
			Sql = Sql + Condition;
			rtnobj=this.getDao("KgDao").ExcuteQuery(Sql);
			return rtnobj;
		}
		catch(Exception ex)
		{
			CoreReturnObject err = new CoreReturnObject();
			err.SetErrInfo(ex.toString());
			return err;
		}
	}
	public CoreReturnObject Add_Group_Info(String AddSql)
	{
		try
		{
			CoreReturnObject rtnobj=new CoreReturnObject();
			rtnobj=this.getDao("KgDao").ExcuteNonQuery(AddSql);		
			return rtnobj;
		}
		catch(Exception ex)
		{
			CoreReturnObject err = new CoreReturnObject();
			err.SetErrInfo(ex.toString());
			return err;
		}
	}
	public CoreReturnObject Edit_Group_Info(String EditSql)
	{
		try
		{
			CoreReturnObject rtnobj=new CoreReturnObject();
			rtnobj=this.getDao("KgDao").ExcuteNonQuery(EditSql);		
			return rtnobj;
		}
		catch(Exception ex)
		{
			CoreReturnObject err = new CoreReturnObject();
			err.SetErrInfo(ex.toString());
			return err;
		}
	}
	public CoreReturnObject Delete_Group_Info(String EditSql)
	{
		try
		{
			CoreReturnObject rtnobj=new CoreReturnObject();
			rtnobj=this.getDao("KgDao").ExcuteNonQuery(EditSql);		
			return rtnobj;
		}
		catch(Exception ex)
		{
			CoreReturnObject err = new CoreReturnObject();
			err.SetErrInfo(ex.toString());
			return err;
		}
	}
	public CoreReturnObject Query_Sql(String Sql)
	{
		try
		{
			CoreReturnObject rtnobj=new CoreReturnObject();
			
			rtnobj=this.getDao("KgDao").ExcuteQuery(Sql);
			return rtnobj;
		}
		catch(Exception ex)
		{
			CoreReturnObject err = new CoreReturnObject();
			err.SetErrInfo(ex.toString());
			return err;
		}
	}
}