package UIF.UIF04;

import java.sql.SQLException;

import UIB.COM.XmlSqlParsersFactory;

import CoreFS.SA01.CoreIComponent;
import CoreFS.SA06.CoreReturnObject;

public class UIF042040 extends CoreIComponent {
	public CoreReturnObject query01() throws SQLException
	{
		CoreReturnObject cro=new CoreReturnObject();
		StringBuffer str = new StringBuffer();
		str.append("SELECT T.COIL_NO          \n");
		str.append("       ,T.C_COIL_NO       \n");
		str.append("       ,T.THK_AIM         \n");
		str.append("       ,T.WTH_AIM         \n");
		str.append("       ,T.ROLL_MANA_NO    \n");
		str.append("FROM C_TBF03_SPEC_MILL T  \n");
		str.append("WHERE T.STATUS_CD <> 'C'  \n");
		str.append("ia \n");

		String sql = str.toString();
		cro=this.getDao("KgDao").ExcuteQuery(sql);
		
		System.out.println(cro);
		return cro;
	}
	
	public CoreReturnObject query02(String rollManaNO) throws SQLException
	{
		CoreReturnObject cro=new CoreReturnObject();
		StringBuffer str = new StringBuffer();
		str.append("SELECT B.ROLL_MANA_NO																			\n");
		str.append("       ,B.ROLL_COIL_SEQ                                   \n");
		str.append("       ,B.COIL_NO                                         \n");
		str.append("       ,B.C_COIL_NO                                       \n");
		str.append("       ,B.COIL_THK                                        \n");
		str.append("       ,B.COIL_WTH                                        \n");
		str.append("       ,B.COIL_LEN                                        \n");
		str.append("       ,B.COIL_WGT                                        \n");
		str.append("       ,B.ORD_THK                                         \n");
		str.append("       ,B.THK_AIM                                         \n");
		str.append("       ,B.THK_MINI                                        \n");
		str.append("       ,B.THK_MAXI                                        \n");
		str.append("       ,B.ORD_WTH                                         \n");
		str.append("       ,B.WTH_AIM                                         \n");
		str.append("       ,B.WTH_MINI                                        \n");
		str.append("       ,B.WTH_MAXI                                        \n");
		str.append("       ,B.ORD_WGT                                         \n");
		str.append("       ,B.ORD_WGT_MIN                                     \n");
		str.append("       ,B.ORD_WGT_MAX                                     \n");
		str.append("       ,D.CUR_PROG_CD                                     \n");
		str.append("       ,B.STATUS_CD                                       \n");
		str.append("       ,B.ORD_NO                                          \n");
		str.append("       ,B.ORD_SEQ                                         \n");
		str.append("       ,E.C_SPEC_STL_GRD                                  \n");
		str.append("       ,E.C_SPEC_ABBSYM                                   \n");
		str.append("       ,E.DEL_TO_DATE                                     \n");
		str.append("       ,E.PROD_LINE                                       \n");
		str.append("FROM C_TBF03_SPEC_MILL B                                \n");
		str.append("     ,C_TBF03_SPEC_MILL_D C                               \n");
		str.append("     ,C_TBK02_COIL_COMM D                                 \n");
		str.append("     ,TBE02_ORD_PRC E                                     \n");
		str.append("WHERE   B.COIL_EDT_SEQ = C.COIL_EDT_SEQ                     \n");
		str.append("AND   B.COIL_NO = D.COIL_NO                               \n");
		str.append("AND   B.ORD_NO = E.ORD_NO                                 \n");
		str.append("AND   B.ORD_SEQ = E.ORD_SEQ                               \n");
		str.append("AND   B.ROLL_MANA_NO = :1								  \n");	
		str.append("ORDER BY B.ROLL_COIL_SEQ								  \n");	
		
		String sql = str.toString();
		cro=this.getDao("KgDao").ExcuteQuery(sql,new Object[]{rollManaNO});
		
		System.out.println(cro);
		return cro;
	}
	
	public CoreReturnObject query03() throws SQLException
	{
		CoreReturnObject cro=new CoreReturnObject();
		StringBuffer str = new StringBuffer();
		str.append("SELECT T.COIL_NO          \n");
		str.append("       ,T.C_COIL_NO       \n");
		str.append("       ,T.THK_AIM         \n");
		str.append("       ,T.WTH_AIM         \n");
		str.append("       ,T.ROLL_MANA_NO    \n");
		str.append("FROM C_TBF03_SPEC_MILL T  \n");
		str.append("WHERE T.STATUS_CD <> 'C'  \n");
		str.append("ORDER BY ROLL_MANA_NO,ROLL_COIL_SEQ \n");

		String sql = str.toString();
		cro=this.getDao("KgDao").ExcuteQuery(sql);
		
		System.out.println(cro);
		return cro;
	}
	
	public CoreReturnObject update01(String rollNO) throws SQLException
	{
		CoreReturnObject cro=new CoreReturnObject();
		StringBuffer str = new StringBuffer();
		str.append("SELECT T.COIL_NO          \n");
		str.append("       ,T.C_COIL_NO       \n");
		str.append("       ,T.THK_AIM         \n");
		str.append("       ,T.WTH_AIM         \n");
		str.append("       ,T.ROLL_MANA_NO    \n");
		str.append("FROM C_TBF03_SPEC_MILL T  \n");
		str.append("WHERE T.STATUS_CD <> 'C'  \n");
		str.append("ORDER BY ROLL_MANA_NO,ROLL_COIL_SEQ \n");

		String sql = str.toString();
		cro=this.getDao("KgDao").ExcuteQuery(sql);
		
		System.out.println(cro);
		return cro;
	}
	//根据XML执行SQL的通用方法
	public CoreReturnObject QueryByXML(String Condition,String XMLName)
	{
		try
		{
			CoreReturnObject rtnobj=new CoreReturnObject();
			String Sql = XmlSqlParsersFactory.getSql(XMLName);
			Sql = Sql + Condition;
			rtnobj=this.getDao("KgDao").ExcuteQuery(Sql);
			return rtnobj;
		}
		catch(Exception ex)
		{
			CoreReturnObject err = new CoreReturnObject();
			err.SetErrInfo(ex.toString());
			return err;
		}
	}
}