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 UIF052010 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_BMData());
			rtn_list.add(Query_Sleeve());
			rtn_list.add(Query_SPMMode());
			rtn_list.add(Query_SPMWet());
			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("UIF052010_04.SELECT");
			obj=this.getDao("KgDao").ExcuteQuery(Sql).getResult();
			return obj;
		}
		catch(Exception ex)
		{
			System.out.print(ex.toString());
			return null;
		}
	}
	//获得表面要求基础信息
	private Object Query_BMData()
	{
		try
		{
			Object obj = new Object();
			String Sql = XmlSqlParsersFactory.getSql("UIF052010_05.SELECT");
			obj=this.getDao("KgDao").ExcuteQuery(Sql).getResult();
			return obj;
		}
		catch(Exception ex)
		{
			System.out.print(ex.toString());
			return null;
		}
	}
	//获得套筒类型
	private Object Query_Sleeve()
	{
		try
		{
			Object obj = new Object();
			String Sql = XmlSqlParsersFactory.getSql("UIF052010_06.SELECT");
			obj=this.getDao("KgDao").ExcuteQuery(Sql).getResult();
			return obj;
		}
		catch(Exception ex)
		{
			System.out.print(ex.toString());
			return null;
		}
	}
	//获得平整模式
	private Object Query_SPMMode()
	{
		try
		{
			Object obj = new Object();
			String Sql = XmlSqlParsersFactory.getSql("UIF052010_07.SELECT");
			obj=this.getDao("KgDao").ExcuteQuery(Sql).getResult();
			return obj;
		}
		catch(Exception ex)
		{
			System.out.print(ex.toString());
			return null;
		}
	}
	//获得湿平标识
	private Object Query_SPMWet()
	{
		try
		{
			Object obj = new Object();
			String Sql = XmlSqlParsersFactory.getSql("UIF052010_08.SELECT");
			obj=this.getDao("KgDao").ExcuteQuery(Sql).getResult();
			return obj;
		}
		catch(Exception ex)
		{
			System.out.print(ex.toString());
			return null;
		}
	}
	//根据条件获得连退基料卷信息
	public CoreReturnObject Query_CAL_Coil(String where) throws SQLException
	{
		try
		{
			CoreReturnObject cro=new CoreReturnObject();
			String Sql = XmlSqlParsersFactory.getSql("UIF052010_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 Query_CAL_Data() throws SQLException
	{
		try
		{
			CoreReturnObject cro=new CoreReturnObject();
			String Sql = XmlSqlParsersFactory.getSql("UIF052010_02.SELECT");
			cro = this.getDao("KgDao").ExcuteQuery(Sql);
			return cro;
		}
		catch(Exception ex)
		{
			CoreReturnObject err = new CoreReturnObject();
			err.SetErrInfo(ex.toString());
			return err;
		}
	}
	
	//获取编制的连退的明细信息
	public CoreReturnObject Query_CAL_List() throws SQLException
	{
		try
		{
			CoreReturnObject cro=new CoreReturnObject();
			String Sql = XmlSqlParsersFactory.getSql("UIF052010_03.SELECT");
			cro = this.getDao("KgDao").ExcuteQuery(Sql);
			return cro;
		}
		catch(Exception ex)
		{
			CoreReturnObject err = new CoreReturnObject();
			err.SetErrInfo(ex.toString());
			return err;
		}
	}
}