XinYu_RZMES/.svn/pristine/6e/6e405c707fc8613ea4ebd331ed7f125366a4f3a7.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
     
    <query id="NIH020040_COIL_COMM.select" desc="init " fetchSize="10">
        <![CDATA[
            SELECT COIL_NO
              FROM TBH02_COIL_COMM
             WHERE SLAB_NO = ?       
        ]]>
    </query> 
	 <query id="NIH020040_SPEC_MILL.select" desc="init " fetchSize="10">
        <![CDATA[
            SELECT COIL_NO,SLAB_EDT_SEQ
              FROM TBF02_SPEC_MILL
             WHERE  STATUS_CD IN('A','B')
              AND   SLAB_NO = ?       
        ]]>
    </query> 
     
    <query id="NIH020040_COIL.update" desc="init " fetchSize="10">
        <![CDATA[
            UPDATE TBH02_COIL_COMM SET
                   COIL_STAT = ?  
                  ,MATRL_END_CAUSE_CD  = ?
                  ,MATRL_END_DTIME     = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
                  ,MISSNO_CAUSE_CD     = ?   
			      ,MISSNO_DTIME        = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
			      ,MISSNO_CLF_CD       = 'C'                                          
             WHERE SLAB_NO = ?     
        ]]>
    </query>
     
    <query id="NIH020040_COIL.insert" desc="init " fetchSize="10">
        <![CDATA[
        INSERT  INTO TBH02_COIL_COMM   
             (   SLAB_NO
                ,COIL_NO 
                ,COIL_STAT
                ,MATRL_END_CAUSE_CD
                ,MATRL_END_DTIME
                ,MISSNO_CAUSE_CD
                ,MISSNO_DTIME 
			    ,MISSNO_CLF_CD
             ) 
             VALUES
             (
                ?
			   ,?
			   ,?
			   ,?
			   ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
			   ,?
			   ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
			   ,'C'
             )
             
        ]]>
    </query>
       <query id="NIH020040_REJ.insert" desc="这里位了获取轧回的班组信息，特别添加" 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_WKGROUP
                ,MISSNO_WK_EMP_NO
			    ,REG_ID
			    ,REG_DTIME
             ) 
             VALUES
             (
                ?,?,?,?,?,?,?,?,?,'NIH020030',TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
             )
        ]]>
    </query>   
</queryMap>