XinYu_RZMES/.svn/pristine/3e/3e94595265536fded2b4f8310bce7d4773260f0b.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL TRACKING">
   <query id="NIG02COMM_LF1_TRACKING" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
         	UPDATE TBG02_STLMAKE_TRACKING T 
			SET L1_PROC_CD = ?
			    ,T.L1_CHARGE_NO = ?
			    ,T.L1_STATION_NO = ?
			    ,T.L1_LD_NO = ?
			    ,T.L1_STL_GRD = ?
			    ,T.L1_IRON_WGT = ?
			    ,T.L1_IRON_TEMP = ?
			    ,T.L1_LF_START_DTIME = ?
			    ,T.L1_TREAT_HOUR = ?
        ]]>
    </query>
    <query id="NIG02COMM_LF2_TRACKING" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
         	UPDATE TBG02_STLMAKE_TRACKING T 
			SET L2_PROC_CD = ?
			    ,T.L2_CHARGE_NO = ?
			    ,T.L2_STATION_NO = ?
			    ,T.L2_LD_NO = ?
			    ,T.L2_STL_GRD = ?
			    ,T.L2_IRON_WGT = ?
			    ,T.L2_IRON_TEMP = ?
			    ,T.L2_LF_START_DTIME = ?
			    ,T.L2_TREAT_HOUR = ?
        ]]>
    </query>
    <query id="NIG02COMM_LF3_TRACKING" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
         	UPDATE TBG02_STLMAKE_TRACKING T 
			SET L3_PROC_CD = ?
			    ,T.L3_CHARGE_NO = ?
			    ,T.L3_STATION_NO = ?
			    ,T.L3_LD_NO = ?
			    ,T.L3_STL_GRD = ?
			    ,T.L3_IRON_WGT = ?
			    ,T.L3_IRON_TEMP = ?
			    ,T.L3_LF_START_DTIME = ?
			    ,T.L3_TREAT_HOUR = ?
        ]]>
    </query>
  	<query id="NIG02COMM_LF3_TRACKING" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
         	UPDATE TBG02_STLMAKE_TRACKING T 
			SET T.L1_PROC_CD = ?
			    ,T.L1_CHARGE_NO = ?
			    ,T.L1_STATION_NO = ?
			    ,T.L1_LD_NO = ?
			    ,T.L1_STL_GRD = ?
			    ,T.L1_IRON_WGT = ?
			    ,T.L1_IRON_TEMP = ?
			    ,T.L1_LF_START_DTIME = ?
			    ,T.L1_TREAT_HOUR = ?
        ]]>
    </query>
    <query id="NIG02COMM_RH1_TRACKING" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
         	UPDATE TBG02_STLMAKE_TRACKING T
			SET T.R1_PROC_CD = ?
			    ,T.R1_CHARGE_NO = ?
			    ,T.R1_STATION_NO = ?
			    ,T.R1_LD_NO = ?
			    ,T.R1_STL_GRD = ?
			    ,T.R1_STEEL_WEIGHT = ?
			    ,T.R1_WEIGHT_TIME = ?
			    --,T.R1_STEEL_TEMP = ?
			    --,T.R1_TEMP_TIME = ?
			    --,T.R1_RH_START_DTIME = ?
			    --,T.R1_TREAT_HOUR = ?
        ]]>
    </query>
    <query id="NIG02COMM_RH2_TRACKING" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
         	UPDATE TBG02_STLMAKE_TRACKING T
			SET T.R1_PROC_CD = ?
			    ,T.R1_CHARGE_NO = ?
			    ,T.R1_STATION_NO = ?
			    ,T.R1_LD_NO = ?
			    ,T.R1_STL_GRD = ?
			    --,T.R1_STEEL_WEIGHT = ?
			    --,T.R1_WEIGHT_TIME = ?
			    ,T.R1_STEEL_TEMP = ?
			    ,T.R1_TEMP_TIME = ?
			    --,T.R1_RH_START_DTIME = ?
			    --,T.R1_TREAT_HOUR = ?
        ]]>
    </query>
    <query id="NIG02COMM_RH3_TRACKING" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
         	UPDATE TBG02_STLMAKE_TRACKING T
			SET T.R1_PROC_CD = ?
			    ,T.R1_CHARGE_NO = ?
			    ,T.R1_STATION_NO = ?
			    ,T.R1_LD_NO = ?
			    ,T.R1_STL_GRD = ?
			    --,T.R1_STEEL_WEIGHT = ?
			    --,T.R1_WEIGHT_TIME = ?
			    --,T.R1_STEEL_TEMP = ?
			    --,T.R1_TEMP_TIME = ?
			    ,T.R1_RH_START_DTIME = ?
			    ,T.R1_TREAT_HOUR = ?
        ]]>
    </query>
    <query id="NIG02COMM_RH4_TRACKING" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
         	UPDATE TBG02_STLMAKE_TRACKING T
			SET T.R2_PROC_CD = ?
			    ,T.R2_CHARGE_NO = ?
			    ,T.R2_STATION_NO = ?
			    ,T.R2_LD_NO = ?
			    ,T.R2_STL_GRD = ?
			    ,T.R2_STEEL_WEIGHT = ?
			    ,T.R2_WEIGHT_TIME = ?
			    --,T.R2_STEEL_TEMP = ?
			    --,T.R2_TEMP_TIME = ?
			    --,T.R2_RH_START_DTIME = ?
			    --,T.R2_TREAT_HOUR = ?
        ]]>
    </query>
    <query id="NIG02COMM_RH5_TRACKING" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
         	UPDATE TBG02_STLMAKE_TRACKING T
			SET T.R2_PROC_CD = ?
			    ,T.R2_CHARGE_NO = ?
			    ,T.R2_STATION_NO = ?
			    ,T.R2_LD_NO = ?
			    ,T.R2_STL_GRD = ?
			    --,T.R2_STEEL_WEIGHT = ?
			    --,T.R2_WEIGHT_TIME = ?
			    ,T.R2_STEEL_TEMP = ?
			    ,T.R2_TEMP_TIME = ?
			    --,T.R2_RH_START_DTIME = ?
			    --,T.R2_TREAT_HOUR = ?
        ]]>
    </query>
    <query id="NIG02COMM_RH6_TRACKING" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
         	UPDATE TBG02_STLMAKE_TRACKING T
			SET T.R2_PROC_CD = ?
			    ,T.R2_CHARGE_NO = ?
			    ,T.R2_STATION_NO = ?
			    ,T.R2_LD_NO = ?
			    ,T.R2_STL_GRD = ?
			    --,T.R2_STEEL_WEIGHT = ?
			    --,T.R2_WEIGHT_TIME = ?
			    --,T.R2_STEEL_TEMP = ?
			    --,T.R2_TEMP_TIME = ?
			    ,T.R2_RH_START_DTIME = ?
			    ,T.R2_TREAT_HOUR = ?
        ]]>
    </query>
    <query id="NIG02COMM_KR1_TRACKING" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
		      UPDATE TBG02_STLMAKE_TRACKING T
		      SET T.K1_PROC_CD = ?
		          ,T.K1_KR_NO = ?
		          ,T.K1_LD_NO = ?
		          ,T.K1_IRON_WEIGT = ?
		          ,T.K1_WEIGHT_TIME = ?
        ]]>
    </query>
    <query id="NIG02COMM_KR2_TRACKING" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
         	  UPDATE TBG02_STLMAKE_TRACKING T
		      SET T.K2_PROC_CD = ?
		          ,T.K2_KR_NO = ?
		          ,T.K2_LD_NO = ?
		          ,T.K2_IRON_WEIGT = ?
		          ,T.K2_WEIGHT_TIME = ?
        ]]>
    </query>
    <query id="NIG02COMM_KR3_TRACKING" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
         	UPDATE TBG02_STLMAKE_TRACKING T
		      SET T.K1_PROC_CD = ?
		          ,T.K1_KR_NO = ?
		          ,T.K1_LD_NO = ?
		          ,T.K1_IRON_TEMP = ?
		          ,T.K1_TEMP_TIME = ?
        ]]>
    </query>
    <query id="NIG02COMM_KR4_TRACKING" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
         	UPDATE TBG02_STLMAKE_TRACKING T
		      SET T.K2_PROC_CD = ?
		          ,T.K2_KR_NO = ?
		          ,T.K2_LD_NO = ?
		          ,T.K2_IRON_TEMP = ?
		          ,T.K2_TEMP_TIME = ?
        ]]>
    </query>
    <query id="NIG02COMM_BOF1_TRACKING" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
         	UPDATE TBG02_STLMAKE_TRACKING T 
		      SET T.B1_PROC_CD = ?
		          ,T.B1_CHARGE_NO = ?
		          ,T.B1_LD_NO = ?
		          ,T.B1_STL_GRD =  ?
		          ,T.B1_STL_PROC = ?
		          ,T.B1_IRON_WGT = ?
		          ,T.B1_IRON_TEMP = ?
		          ,T.B1_O2BLOW_DTIME = ?
		          ,T.B1_TAPPING_DTIME = ?
		          ,T.B1_IRON_TEMP2 = ?
		          ,T.B1_TAPPING_HOUR = ?
        ]]>
    </query>
    <query id="NIG02COMM_BOF2_TRACKING" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
         	UPDATE TBG02_STLMAKE_TRACKING T 
		      SET T.B2_PROC_CD = ?
		          ,T.B2_CHARGE_NO = ?
		          ,T.B2_LD_NO = ?
		          ,T.B2_STL_GRD =  ?
		          ,T.B2_STL_PROC = ?
		          ,T.B2_IRON_WGT = ?
		          ,T.B2_IRON_TEMP = ?
		          ,T.B2_O2BLOW_DTIME = ?
		          ,T.B2_TAPPING_DTIME = ?
		          ,T.B2_IRON_TEMP2 = ?
		          ,T.B2_TAPPING_HOUR = ?
        ]]>
    </query>
    <query id="NIG02COMM_BOF3_TRACKING" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
         	UPDATE TBG02_STLMAKE_TRACKING T 
		      SET T.B3_PROC_CD = ?
		          ,T.B3_CHARGE_NO = ?
		          ,T.B3_LD_NO = ?
		          ,T.B3_STL_GRD =  ?
		          ,T.B3_STL_PROC = ?
		          ,T.B3_IRON_WGT = ?
		          ,T.B3_IRON_TEMP = ?
		          ,T.B3_O2BLOW_DTIME = ?
		          ,T.B3_TAPPING_DTIME = ?
		          ,T.B3_IRON_TEMP2 = ?
		          ,T.B3_TAPPING_HOUR = ?
        ]]>
    </query>
    <query id="NIG02COMM_CAS1_TRACKING" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
         	UPDATE TBG02_STLMAKE_TRACKING T 
	          SET T.C1_PROC_CD = ?
	              ,T.C1_CHARGE_NO = ?
	              ,T.C1_LD_NO = ?
	              ,T.C1_STL_GRD =  ?
	              ,T.C1_IRON_WGT = ?
	              ,T.C1_IRON_TEMP = ?
	              ,T.C1_AR_GAS_USE_WGT = ?
	              ,T.C1_CAS_DTIME = ?
	              ,T.C1_TREAT_HOUR = ?
        ]]>
    </query>
    <query id="NIG02COMM_CAS2_TRACKING" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
         	UPDATE TBG02_STLMAKE_TRACKING T 
	          SET T.C2_PROC_CD = ?
	              ,T.C2_CHARGE_NO = ?
	              ,T.C2_LD_NO = ?
	              ,T.C2_STL_GRD =  ?
	              ,T.C2_IRON_WGT = ?
	              ,T.C2_IRON_TEMP = ?
	              ,T.C2_AR_GAS_USE_WGT = ?
	              ,T.C2_CAS_DTIME = ?
	              ,T.C2_TREAT_HOUR = ?
        ]]>
    </query>
    <query id="NIG02COMM_CAS3_TRACKING" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
         	UPDATE TBG02_STLMAKE_TRACKING T 
	          SET T.C3_PROC_CD = ?
	              ,T.C3_CHARGE_NO = ?
	              ,T.C3_LD_NO = ?
	              ,T.C3_STL_GRD =  ?
	              ,T.C3_IRON_WGT = ?
	              ,T.C3_IRON_TEMP = ?
	              ,T.C3_AR_GAS_USE_WGT = ?
	              ,T.C3_CAS_DTIME = ?
	              ,T.C3_TREAT_HOUR = ?
        ]]>
    </query>
    <query id="NIG02COMM_CCM1_TRACKING" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
         	UPDATE TBG02_STLMAKE_TRACKING T 
			SET T.J1_PROC_CD = ?
			    ,T.J1_CHARGE_NO = ?
			    ,T.J1_LD_NO = ?
			    ,T.J1_STL_GRD =  ?
			    ,T.J1_STLMELT_WGT = ?
			    ,T.J1_LD_WGT = ?
			    ,T.J1_LD_TEMP = ?
			    ,T.J1_TD_WGT = ?
			    ,T.J1_TD_TEMP = ?
			    ,T.J1_CC_START_DTIME = ?
			    ,T.J1_CC_HOUR = ?
			    ,T.J1_CC_SPEED1 = ?
			    ,T.J1_CC_SIZE1 = ?
			    ,T.J1_CC_STATE1 = ?
			    ,T.J1_CC_SPEED2 = ?
			    ,T.J1_CC_SIZE2 = ?
			    ,T.J1_CC_STATE2 = ?
        ]]>
    </query>
    <query id="NIG02COMM_CCM2_TRACKING" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
         	UPDATE TBG02_STLMAKE_TRACKING T 
			SET T.J2_PROC_CD = ?
			    ,T.J2_CHARGE_NO = ?
			    ,T.J2_LD_NO = ?
			    ,T.J2_STL_GRD =  ?
			    ,T.J2_STLMELT_WGT = ?
			    ,T.J2_LD_WGT = ?
			    ,T.J2_LD_TEMP = ?
			    ,T.J2_TD_WGT = ?
			    ,T.J2_TD_TEMP = ?
			    ,T.J2_CC_START_DTIME = ?
			    ,T.J2_CC_HOUR = ?
			    ,T.J2_CC_SPEED1 = ?
			    ,T.J2_CC_SIZE1 = ?
			    ,T.J2_CC_STATE1 = ?
			    ,T.J2_CC_SPEED2 = ?
			    ,T.J2_CC_SIZE2 = ?
			    ,T.J2_CC_STATE2 = ?
        ]]>
    </query>
    <query id="NIG02COMM_CCM3_TRACKING" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
         	UPDATE TBG02_STLMAKE_TRACKING T 
			SET T.J3_PROC_CD = ?
			    ,T.J3_CHARGE_NO = ?
			    ,T.J3_LD_NO = ?
			    ,T.J3_STL_GRD =  ?
			    ,T.J3_STLMELT_WGT = ?
			    ,T.J3_LD_WGT = ?
			    ,T.J3_LD_TEMP = ?
			    ,T.J3_TD_WGT = ?
			    ,T.J3_TD_TEMP = ?
			    ,T.J3_CC_START_DTIME = ?
			    ,T.J3_CC_HOUR = ?
			    ,T.J3_CC_SPEED1 = ?
			    ,T.J3_CC_SIZE1 = ?
			    ,T.J3_CC_STATE1 = ?
			    ,T.J3_CC_SPEED2 = ?
			    ,T.J3_CC_SIZE2 = ?
			    ,T.J3_CC_STATE2 = ?
        ]]>
    </query>
</queryMap>