package UIF.UIF05;

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 UIF051020 extends CoreIComponent 
{
	//获得基础数据信息
	public CoreReturnObject Query_BaseData() throws SQLException
	{
		try
		{
			CoreReturnObject cro=new CoreReturnObject();
			java.util.ArrayList rtn_list = new java.util.ArrayList();
			rtn_list.add(Query_PMData());
			rtn_list.add(Query_YYData());
			cro.setResult(rtn_list);
			return cro;
		}
		catch(Exception ex)
		{
			CoreReturnObject err = new CoreReturnObject();
			err.SetErrInfo(ex.toString());
			return err;
		}
	}
	//获得交货状态基础信息
	private Object Query_PMData()
	{
		try
		{
			Object obj = new Object();
			String Sql = XmlSqlParsersFactory.getSql("UIF051020_04.SELECT");
			obj=this.getDao("KgDao").ExcuteQuery(Sql).getResult();
			return obj;
		}
		catch(Exception ex)
		{
			System.out.print(ex.toString());
			return null;
		}
	}
	//获得申报原因基础信息
	private Object Query_YYData()
	{
		try
		{
			Object obj = new Object();
			String Sql = XmlSqlParsersFactory.getSql("UIF051020_03.SELECT");
			obj=this.getDao("KgDao").ExcuteQuery(Sql).getResult();
			return obj;
		}
		catch(Exception ex)
		{
			System.out.print(ex.toString());
			return null;
		}
	}
	//查询可申报的冷卷
	public CoreReturnObject Get_CCoilData(String where) throws SQLException
	{
		try
		{
			CoreReturnObject cro=new CoreReturnObject();
			String Sql = XmlSqlParsersFactory.getSql("UIF051020_01.SELECT");
			Sql = Sql + where;
			cro = this.getDao("KgDao").ExcuteQuery(Sql);
			return cro;
		}
		catch(Exception ex)
		{
			CoreReturnObject err = new CoreReturnObject();
			err.SetErrInfo(ex.toString());
			return err;
		}
	}
	//查询已连退申报的信息
	public CoreReturnObject Get_DCLData(String where) throws SQLException
	{
		try
		{
			CoreReturnObject cro=new CoreReturnObject();
			String Sql = XmlSqlParsersFactory.getSql("UIF051020_02.SELECT");
			Sql = Sql + where;
			cro = this.getDao("KgDao").ExcuteQuery(Sql);
			return cro;
		}
		catch(Exception ex)
		{
			CoreReturnObject err = new CoreReturnObject();
			err.SetErrInfo(ex.toString());
			return err;
		}
	}
}