XinYu_RZMES/.svn/pristine/fb/fb1d58a4bbf15b2c3043cce643bc026e488ab316.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
     
    <query id="NIH020030_01.select" desc="init " fetchSize="10">
		<![CDATA[
			SELECT SLAB_NO
			  FROM TBH02_RHF_MISSNO
			 WHERE SLAB_NO = ? AND COIL_NO = ?       
		]]>
	</query> 
     
	<query id="NIH020030_COIL.update" desc="吊销的情况，钢卷状态为3 " fetchSize="10">
		<![CDATA[
			update TBH02_COIL_COMM set
                             ROLL_UNIT = ?  
                                ,MISSNO_CLF_CD = ?
                                ,MISSNO_CAUSE_CD = ?
                                ,MISSNO_DTIME = ?  
                                ,COIL_STAT    = '3'                                                        
      where                  COIL_NO = ?   
		]]>
	</query>
	
	<query id="NIH020030_RealCOIL.update" desc="吊销的情况，钢卷状态为3 " fetchSize="10">
		<![CDATA[
			update TBH02_COIL_COMM set
                             ROLL_UNIT = ?  
                                ,MISSNO_CLF_CD = ?
                                ,MISSNO_CAUSE_CD = ?
                                ,MISSNO_DTIME = ?  
                                ,COIL_STAT    = '3'                                                        
      where                  old_sampl_no = ?   
		]]>
	</query>
	<query id="NIH020030_SLAB.update" desc="init " fetchSize="10">
		<![CDATA[
			update tbg02_slab_comm set
                     			 MISSNO_CLF = ?
								 ,MISSNO_CAUSE_CD = ?
								 ,MISSNO_OCR_DTIME = ?  
								 ,MISSNO_EMP_ID = ?  
			where                SLAB_NO = ? 
		]]>
	</query>
	<query id="NIH020030_REJ.update" desc="init " fetchSize="10">
		<![CDATA[
			UPDATE TBH02_RHF_MISSNO SET
                 ROLL_UNIT_NO    = ?
			    ,MISSNO_CLF      = ?
			    ,MISSNO_CAUSE_CD = ?  
			    ,MISSNO_DTIME    = ?  
			    ,MOD_ID   = 'NIH020030'
			    ,MOD_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
			WHERE   SLAB_NO = ? 
		]]>
	</query>
	<query id="NIH020030_REJ.insert" desc="init " fetchSize="10">
		<![CDATA[
		INSERT  INTO TBH02_RHF_MISSNO   
             (   SLAB_NO
                ,COIL_NO 
                ,ROLL_UNIT_NO
                ,MISSNO_CLF
                ,MISSNO_CAUSE_CD
                ,MISSNO_DTIME
                ,MISSNO_WKSHIFT
                ,MISSNO_WK_EMP_NO
			    ,REG_ID
			    ,REG_DTIME
             ) 
             VALUES
             (
                ?,?,?,?,?,?,?,?,'NIH020030',TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
             )
			 
		]]>
	</query>
	  <query id="NIH020030_SLAB.select" desc="init " fetchSize="10">
        <![CDATA[
            SELECT CUR_PROG_CD,BEF_PROG_CD,ORD_NO,ORD_SEQ,SLAB_WGT
              FROM TBG02_SLAB_COMM
             WHERE SLAB_NO = ?       
        ]]>
    </query> 
	<query id="NIH020030_SLAB_END.update" desc="init " fetchSize="10">
        <![CDATA[
            update tbg02_slab_comm set
                   SLAB_STAT = ?  
            where  SLAB_NO = ? 
        ]]>
    </query>
</queryMap>