XinYu_RZMES/.svn/pristine/99/990c6c2ee4360af276a98cd3377101b8045ab2e4.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH020220_01.select" desc="  ">
        <![CDATA[
            SELECT B.ROLL_MANA_NO,
       B.ROLL_SLAB_SEQ,
       A.SPM_YN,
       A.SPEC_STL_GRD,
       A.COIL_THK||'*'||A.COIL_WTH T_W,
       A.INSTR_COIL_THK||'*'||A.INSTR_COIL_WTH IT_IW,
       CASE  WHEN (B.STATUS_CD = 'A' AND A.COIL_STAT IS NULL )    THEN '轧制作业待机'
               WHEN (B.STATUS_CD = 'A' AND A.COIL_STAT = '0')       THEN '上料进行'
               WHEN (B.STATUS_CD = 'D'                           )  THEN '轧制吊销'
               WHEN (B.STATUS_CD = 'B' )                            THEN '轧制进行'
               WHEN (B.STATUS_CD = 'C' AND A.MISSNO_CLF_CD IS NULL) THEN '轧制完成'
               WHEN (B.STATUS_CD = 'C' AND A.MISSNO_CLF_CD =  'C')  THEN '轧废或中板'
               ELSE '轧制完成'                                      END    STATUS_CD,
       A.ACT_WGT,
       A.ORD_NO,
       A.ORD_SEQ 
FROM TBH02_COIL_COMM A,TBF02_SPEC_MILL B
WHERE  A.SLAB_NO = B.SLAB_NO
AND    A.COIL_NO = B.COIL_NO
AND A.OLD_SAMPL_NO = ? 
		]]>
    </query>
	<query id="UIH020220_02.select" desc=" 查询钢卷状态 ">
        <![CDATA[
              SELECT A.CUR_PROG_CD,A.SLAB_NO,A.COIL_NO,A.COIL_STAT,A.MISSNO_CLF_CD FROM TBH02_COIL_COMM A WHERE A.OLD_SAMPL_NO = ?
		]]>
    </query>
	<query id="UIH020220_03.select" desc=" 查询吊销表的状态 ">
        <![CDATA[
              SELECT A.MISSNO_CLF FROM TBH02_RHF_MISSNO A WHERE A.SLAB_NO = ? AND A.COIL_NO = ? 
		]]>
    </query>
	<query id="UIH020220_01.delete" desc="这里必须清空，否则吊销的时候不能再次调用品质和进程 ">
        <![CDATA[
              delete   TBH02_RHF_MISSNO A
             WHERE A.SLAB_NO = ?
              AND A.COIL_NO = ?
		]]>
    </query>
	<query id="UIH020220_01.update" desc=" 更新加热炉入炉出炉表 ">
        <![CDATA[
              UPDATE TBH02_REHEATFUR T SET 
				     T.RHF_STAT = ?  
			   WHERE T.SLAB_NO = ? AND T.COIL_NO = ?  
		]]>
    </query>
	<query id="UIH020220_02.update" desc=" 更新钢卷公共表 ">
        <![CDATA[
              update TBH02_COIL_COMM set
                             ROLL_UNIT = ''  
                                ,MISSNO_CLF_CD = ''
                                ,MISSNO_CAUSE_CD = ''
                                ,MISSNO_DTIME = ''  
                                ,COIL_STAT    = ?  
                                ,COIL_RETURN_REG = ?
                                ,COIL_RETURN_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MIDD')                                                        
						  where   SLAB_NO = ?  
						      and COIL_NO = ?     
		]]>
    </query>
	<query id="UIH020220_03.update" desc=" 更新钢卷公共表，轧废的回退需要单独处理 ">
        <![CDATA[
             UPDATE TBH02_MILL_RESULT A SET 
       A.MISSNO_BAR_THK = '',
       A.MISSNO_CLF_CD = '',
       A.MISSNO_CAUSE_CD = '',
       A.MISSNO_DTIME = '',
       A.MISSNO_BAR_WTH = '',
       A.MISSNO_BAR_WGT = ''
       
       WHERE A.SLAB_NO = ?  AND A.COIL_NO = ?  
		]]>
    </query>
	<query id="UIH020220_NIB02701X" desc="调用品质存储过程" fetchSize="1">
        <![CDATA[			
           {call ZL_HOST_DCS02.RUIN_COIL_QLTY(?,?,?,?)}
        ]]>
    </query>
</queryMap>