package UIF.UIF06;

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 UIF061050 extends CoreIComponent 
{
	//获得基础数据信息
	public CoreReturnObject queryBaseData() throws SQLException
	{
		try
		{
			CoreReturnObject cro=new CoreReturnObject();
			java.util.ArrayList rtn_list = new java.util.ArrayList();
			rtn_list.add(queryPMData());
			rtn_list.add(queryBMData());
			rtn_list.add(querySleeve());
			rtn_list.add(querySPMMode());
			rtn_list.add(querySPMWet());
			cro.setResult(rtn_list);
			return cro;
		}
		catch(Exception ex)
		{
			CoreReturnObject err = new CoreReturnObject();
			err.SetErrInfo(ex.toString());
			return err;
		}
	}
	//获得交货状态基础信息
	private Object queryPMData()
	{
		try
		{
			Object obj = new Object();
			String Sql = XmlSqlParsersFactory.getSql("UIF061010_04.SELECT");
			obj=this.getDao("KgDao").ExcuteQuery(Sql).getResult();
			return obj;
		}
		catch(Exception ex)
		{
			System.out.print(ex.toString());
			return null;
		}
	}
	//获得表面要求基础信息
	private Object queryBMData()
	{
		try
		{
			Object obj = new Object();
			String Sql = XmlSqlParsersFactory.getSql("UIF061010_05.SELECT");
			obj=this.getDao("KgDao").ExcuteQuery(Sql).getResult();
			return obj;
		}
		catch(Exception ex)
		{
			System.out.print(ex.toString());
			return null;
		}
	}
	//获得套筒类型
	private Object querySleeve()
	{
		try
		{
			Object obj = new Object();
			String Sql = XmlSqlParsersFactory.getSql("UIF061010_06.SELECT");
			obj=this.getDao("KgDao").ExcuteQuery(Sql).getResult();
			return obj;
		}
		catch(Exception ex)
		{
			System.out.print(ex.toString());
			return null;
		}
	}
	//获得平整模式
	private Object querySPMMode()
	{
		try
		{
			Object obj = new Object();
			String Sql = XmlSqlParsersFactory.getSql("UIF061010_07.SELECT");
			obj=this.getDao("KgDao").ExcuteQuery(Sql).getResult();
			return obj;
		}
		catch(Exception ex)
		{
			System.out.print(ex.toString());
			return null;
		}
	}
	//获得湿平标识
	private Object querySPMWet()
	{
		try
		{
			Object obj = new Object();
			String Sql = XmlSqlParsersFactory.getSql("UIF061010_08.SELECT");
			obj=this.getDao("KgDao").ExcuteQuery(Sql).getResult();
			return obj;
		}
		catch(Exception ex)
		{
			System.out.print(ex.toString());
			return null;
		}
	}
	//根据条件获得重卷基料卷信息
	public CoreReturnObject queryHotCoil(String where) throws SQLException
	{
		try
		{
			CoreReturnObject cro=new CoreReturnObject();
			String Sql = XmlSqlParsersFactory.getSql("UIF061050_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 queryPltcmReelCoil(String where) throws SQLException
	{
		try
		{
			CoreReturnObject cro=new CoreReturnObject();
			String Sql = XmlSqlParsersFactory.getSql("UIF061010_09.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 queryReelData() throws SQLException
	{
		try
		{
			CoreReturnObject cro=new CoreReturnObject();
			String Sql = XmlSqlParsersFactory.getSql("UIF061050_11.SELECT");
			cro = this.getDao("KgDao").ExcuteQuery(Sql);
			return cro;
		}
		catch(Exception ex)
		{
			CoreReturnObject err = new CoreReturnObject();
			err.SetErrInfo(ex.toString());
			return err;
		}
	}
	
	//获取编制的重卷的明细信息
	public CoreReturnObject queryHotList() throws SQLException
	{
		try
		{
			CoreReturnObject cro=new CoreReturnObject();
			String Sql = XmlSqlParsersFactory.getSql("UIF061050_03.SELECT");
			cro = this.getDao("KgDao").ExcuteQuery(Sql);
			return cro;
		}
		catch(Exception ex)
		{
			CoreReturnObject err = new CoreReturnObject();
			err.SetErrInfo(ex.toString());
			return err;
		}
	}
	public CoreReturnObject querypltcmReelList() throws SQLException
	{
		try
		{
			CoreReturnObject cro=new CoreReturnObject();
			String Sql = XmlSqlParsersFactory.getSql("UIF061010_10.SELECT");
			cro = this.getDao("KgDao").ExcuteQuery(Sql);
			return cro;
		}
		catch(Exception ex)
		{
			CoreReturnObject err = new CoreReturnObject();
			err.SetErrInfo(ex.toString());
			return err;
		}
	}
}