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 UIF061020 extends CoreIComponent 
{
	/**
	 * 查询未生产重卷计划
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject queryReelPlanCoils() throws SQLException
	{
		try
		{
			String Sql = XmlSqlParsersFactory.getSql("UIF061020_01.SELECT");
		    return this.getDao("KgDao").ExcuteQuery(Sql);
		}
		catch(Exception ex)
		{
			CoreReturnObject err = new CoreReturnObject();
			err.SetErrInfo(ex.toString());
			return err;
		}
	}
	public CoreReturnObject queryPLTCMReelPlanCoils() throws SQLException
	{
		try
		{
			String Sql = XmlSqlParsersFactory.getSql("UIF061020_02.SELECT");
		    return this.getDao("KgDao").ExcuteQuery(Sql);
		}
		catch(Exception ex)
		{
			CoreReturnObject err = new CoreReturnObject();
			err.SetErrInfo(ex.toString());
			return err;
		}
	}
	public CoreReturnObject queryHotPlanCoils() throws SQLException
	{
		try
		{
			String Sql = XmlSqlParsersFactory.getSql("UIF061020_03.SELECT");
		    return this.getDao("KgDao").ExcuteQuery(Sql);
		}
		catch(Exception ex)
		{
			CoreReturnObject err = new CoreReturnObject();
			err.SetErrInfo(ex.toString());
			return err;
		}
	}
	public CoreReturnObject querySxPlanCoils() throws SQLException
	{
		try
		{
			String Sql = XmlSqlParsersFactory.getSql("UIF061020_04.SELECT");
		    return this.getDao("KgDao").ExcuteQuery(Sql);
		}
		catch(Exception ex)
		{
			CoreReturnObject err = new CoreReturnObject();
			err.SetErrInfo(ex.toString());
			return err;
		}
	}
}