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 UIF041010 extends CoreIComponent 
{
	//根据基料卷的类型(酸轧基料卷/连退基料卷)分析得到基料的数据结构
	//Slab_Type:PL/TCM
	//			CAL
	public CoreReturnObject Query_Slab_State(String Slab_Type) throws SQLException
	{
		try
		{
			CoreReturnObject cro=new CoreReturnObject();
			java.util.ArrayList rtn_list = new java.util.ArrayList();
			if(Slab_Type.equals("PL/TCM"))
			{
				rtn_list.add(PLTCM_Query_Slab_Height());
				rtn_list.add(PLTCM_Query_Slab_Width());
				rtn_list.add(PLTCM_Query_Slab_Appearance());
				rtn_list.add(PLTCM_Query_Slab_ColdTime());
				rtn_list.add(PLTCM_Query_Slab_Steel());
				rtn_list.add(PLTCM_Query_Slab_Commodity());
			}
			else if(Slab_Type.equals("CAL")){
				rtn_list = countCalCoil();
			}
			cro.setResult(rtn_list);
			return cro;
		}
		catch(Exception ex)
		{
			CoreReturnObject err = new CoreReturnObject();
			err.SetErrInfo(ex.toString());
			return err;
		}
	}
	//根据厚度分析得到冷轧原料的数据结构
	private Object PLTCM_Query_Slab_Height()
	{
		try
		{
			Object obj = new Object();
			String Sql = XmlSqlParsersFactory.getSql("UIF041010.PLTCM_Query_Slab_Height");
			obj=this.getDao("KgDao").ExcuteQuery(Sql).getResult();
			return obj;
		}
		catch(Exception ex)
		{
			System.out.print(ex.toString());
			return null;
		}
	}
	//根据宽度分析得到冷轧原料的数据结构
	private Object PLTCM_Query_Slab_Width()
	{	
		try
		{
			Object obj = new Object();
			String Sql = XmlSqlParsersFactory.getSql("UIF041010.PLTCM_Query_Slab_Width");
			obj=this.getDao("KgDao").ExcuteQuery(Sql).getResult();
			return obj;
		}
		catch(Exception ex)
		{
			System.out.print(ex.toString());
			return null;
		}
	}
	//根据表面登记分析得到冷轧原料的数据结构
	private Object PLTCM_Query_Slab_Appearance()
	{
		try
		{
			Object obj = new Object();
			String Sql = XmlSqlParsersFactory.getSql("UIF041010.PLTCM_Query_Slab_Appearance");
			obj=this.getDao("KgDao").ExcuteQuery(Sql).getResult();
			return obj;
		}
		catch(Exception ex)
		{
			System.out.print(ex.toString());
			return null;
		}
	}
	//根据冷却时长分析得到冷轧原料的数据结构
	private Object PLTCM_Query_Slab_ColdTime()
	{
		try
		{
			Object obj = new Object();
			String Sql = XmlSqlParsersFactory.getSql("UIF041010.PLTCM_Query_Query_Slab_ColdTime");
			obj=this.getDao("KgDao").ExcuteQuery(Sql).getResult();
			return obj;
		}
		catch(Exception ex)
		{
			System.out.print(ex.toString());
			return null;
		}
	}
	//根据牌号分析得到冷轧原料的数据结构
	private Object PLTCM_Query_Slab_Steel()
	{
		try
		{
			Object obj = new Object();
			String Sql = XmlSqlParsersFactory.getSql("UIF041010.PLTCM_Query_Slab_Steel");
			obj=this.getDao("KgDao").ExcuteQuery(Sql).getResult();
			return obj;
		}
		catch(Exception ex)
		{
			System.out.print(ex.toString());
			return null;
		}
	}
	//根据交货状态分析得到冷轧原料的数据结构
	private Object PLTCM_Query_Slab_Commodity()
	{
		try
		{
			Object obj = new Object();
			String Sql = XmlSqlParsersFactory.getSql("UIF041010.PLTCM_Query_Slab_Commodity");
			obj=this.getDao("KgDao").ExcuteQuery(Sql).getResult();
			return obj;
		}
		catch(Exception ex)
		{
			System.out.print(ex.toString());
			return null;
		}
	}
	
	private ArrayList<Object> countCalCoil(){
		ArrayList<Object> retObj = new ArrayList<Object> ();
		
		retObj.add(this.getDao("KgDao").ExcuteQuery(XmlSqlParsersFactory.getSql("UIF051010_01.SELECT")).getResult());
		retObj.add(this.getDao("KgDao").ExcuteQuery(XmlSqlParsersFactory.getSql("UIF051010_02.SELECT")).getResult());
		retObj.add(this.getDao("KgDao").ExcuteQuery(XmlSqlParsersFactory.getSql("UIF051010_03.SELECT")).getResult());
		retObj.add(this.getDao("KgDao").ExcuteQuery(XmlSqlParsersFactory.getSql("UIF051010_04.SELECT")).getResult());
		retObj.add(this.getDao("KgDao").ExcuteQuery(XmlSqlParsersFactory.getSql("UIF051010_05.SELECT")).getResult());
		retObj.add(this.getDao("KgDao").ExcuteQuery(XmlSqlParsersFactory.getSql("UIF051010_06.SELECT")).getResult());
		
		return retObj;
	}
}