XinYu_LZMES/.svn/pristine/73/7352cdd4c0f3348f453b90754cedb5dfcace3cfd.svn-base

package UIF.UIF04;

import java.sql.SQLException;

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

public class UIF043010 extends CoreIComponent {
	public CoreReturnObject query01(String castNO,String insTimeBgn,String insTimeEnd,String millTimeBgn,String millTimeEnd) throws SQLException
	{
		CoreReturnObject cro=new CoreReturnObject();
		StringBuffer str = new StringBuffer();
		str.append("SELECT \n");
		str.append("a.ROLL_MANA_NO           --羅齡데禱뵀	    	\n");
		str.append(",a.ROLL_COIL_SEQ         --데禱코埼뵀			\n");																																		
		str.append(",a.COIL_EDT_SEQ          --羅齡埼뵀			\n");																																	
		str.append(",a.C_COIL_NO             --잤얩뵀				\n");																																
		str.append(",a.COIL_NO               --훑얩뵀				\n");																																
		str.append(",a.SPEC_STL_GRD          --擧羅탬뵀				\n");																																	
		str.append(",a.STL_GRD               --훑羅탬뵀				\n");																																	
		str.append(",a.STL_GRP_CD            --멀뵀莉				\n");																																
		str.append(",a.COIL_THK              --훑얩비똑				\n");																																	
		str.append(",a.COIL_WTH              --훑얩욱똑				\n");																																	
		str.append(",a.COIL_WGT              --훑얩路좆				\n");																																	
		str.append(",b.CUR_LOAD_LOC          --뚜렴貫零				\n");																																	
		str.append(",a.ORD_NO                --북谿뵀				\n");																																
		str.append(",a.ORD_SEQ               --땐데뵀				\n");																																
		str.append(",a.ORD_THK               --땐데비똑				\n");																																	
		str.append(",a.ORD_WTH               --땐데욱똑				\n");																																	
		str.append(",a.ORD_WGT               --땐데路좆				\n");																																	
		str.append(",a.ORD_WGT_MIN           --땐데苟掘				\n");																																	
		str.append(",a.ORD_WGT_MAX           --땐데�掘				\n");																																	
		str.append(",a.ORD_INDIA             --땐데코쓺				\n");																																	
		str.append(",a.ORD_OUTDIA            --땐데棍쓺				\n");																																	
		str.append("FROM c_tbf03_spec_mill a, 	\n");
		str.append("c_tbk02_coil_comm b 		\n");
		str.append("WHERE a.COIL_NO = b.COIL_NO \n");
		str.append("and   a.ROLL_MANA_NO = :1 	\n");
		str.append("and   a.REG_DTIME between :2||'000000' and :3||'999999' 	\n");
		str.append("and   b.MILL_DTIME between :4||'000000' and :5||'999999' 	\n");
		//str.append("and   b.ORD_NO = :6 	\n");
		//str.append("and   b.ORD_SEQ = :7 	\n");
		str.append("ORDER BY a.ROLL_MANA_NO,a.ROLL_COIL_SEQ 	\n");

		String sql = str.toString();
		cro=this.getDao("KgDao").ExcuteQuery(sql,new Object[]{castNO,insTimeBgn,insTimeEnd,millTimeBgn,millTimeEnd});
		
		System.out.println(cro);
		return cro;
	}
}