XinYu_RZMES/.svn/pristine/dd/dd9e07c76410bc4cb9cec42c4c7b22ea6194975c.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH040030_02.select" desc="等待ROLL现况查询处理" fetchSize="10">
		<![CDATA[
		  select 
            '' CHK 
		  ,a.ROLL_TYPE
          ,a.ROLL_NO ROLL_NO
          ,b.roll_no BOT_roll_no 
          ,b.ASSEM_CHOCK_WORK BOT_ASSEM_CHOCK_WORK
          ,b.ASSEM_CHOCK_DRIVE BOT_ASSEM_CHOCK_DRIVE
          ,a.ASSEM_CHOCK_WORK 
          ,a.ASSEM_CHOCK_DRIVE
          ,a.ASSEM_END_DTIME
              from  TBH04_ROLL a,TBH04_ROLL b
                     where a.assem_roll = b.roll_no(+)
                     AND a.roll_stat = b.roll_stat(+)
                     AND a.roll_stat = 'W' 
                     AND (a.TOP_BOT_CLF = 'T' OR a.TOP_BOT_CLF = 'A' )
		]]>
	</query>
	<query id="UIH040030_01.select" desc="使用 ROLL 查询处理" fetchSize="10">
		<![CDATA[
		  SELECT  '' CHK
              , a.STAND_NO 
              , a.ROLL_TYPE
              , TOP_ROLL_NO
              , BOT_ROLL_NO
              , TOP_DRIVE_CHOCK   
              , TOP_WORK_CHOCK
              , BOT_DRIVE_CHOCK
              , BOT_WORK_CHOCK
              , EXT_TOP_ROLL_NO
              , EXT_BOT_ROLL_NO
           FROM 
           (
               select a.ROLL_TYPE  
                    , a.ROLL_NO TOP_ROLL_NO
                    , b.ROLL_NO BOT_ROLL_NO
                    , a.ASSEM_CHOCK_DRIVE TOP_DRIVE_CHOCK
                    , a.ASSEM_CHOCK_WORK TOP_WORK_CHOCK
                    , b.ASSEM_CHOCK_DRIVE BOT_DRIVE_CHOCK
                    , b.ASSEM_CHOCK_WORK BOT_WORK_CHOCK
                    , a.STAND_NO      
               from  TBH04_ROLL a ,TBH04_ROLL b
               where a.assem_roll = b.roll_no(+) 
                 AND a.roll_stat = 'U' 
                 AND (a.TOP_BOT_CLF = 'T' OR a.TOP_BOT_CLF = 'A') 
                 order by stand_no
           ) a,
           (
             select   MAX(DECODE(TOP_BOT_CLF,'T',ROLL_NO,'A',ROLL_NO,'')) EXT_TOP_ROLL_NO 
                     ,MAX(DECODE(TOP_BOT_CLF,'B',ROLL_NO,'' )) EXT_BOT_ROLL_NO  
                     ,STAND_NO
               from  TBH04_ROLL  
               where  roll_stat = 'S'
              GROUP BY  STAND_NO
              
          ) b
          WHERE a.STAND_NO = b.STAND_NO   
		]]>
	</query>
	<query id="UIH040030_03.select" desc="" fetchSize="10">
		<![CDATA[
		  select 
            '' CHK 
		  ,a.ROLL_TYPE   	
          ,a.ROLL_NO ROLL_NO
          ,b.roll_no BOT_roll_no 
          ,b.ASSEM_CHOCK_WORK BOT_ASSEM_CHOCK_WORK
          ,b.ASSEM_CHOCK_DRIVE BOT_ASSEM_CHOCK_DRIVE
          ,a.ASSEM_CHOCK_WORK 
          ,a.ASSEM_CHOCK_DRIVE
          ,a.ASSEM_END_DTIME
              from  TBH04_ROLL a,TBH04_ROLL b
                where  
                       a.assem_roll = b.roll_no(+) 
                     AND  a.roll_stat = 'W' 
                     AND (a.TOP_BOT_CLF = 'T' OR a.TOP_BOT_CLF = 'A')
                     and  a.roll_no LIKE ? || '%'  
		]]>
	</query>
	<query id="UIH040030_04.select" desc="使用 ROLL 查询处理" fetchSize="10">
		<![CDATA[
		 SELECT  '' CHK
              , a.STAND_NO 
              , a.ROLL_TYPE
              , TOP_ROLL_NO
              , BOT_ROLL_NO
              , TOP_DRIVE_CHOCK   
              , TOP_WORK_CHOCK
              , BOT_DRIVE_CHOCK
              , BOT_WORK_CHOCK
              , EXT_TOP_ROLL_NO
              , EXT_BOT_ROLL_NO
              , CHANG_DTIME 
           FROM 
           (
               SELECT    ROLL_TYPE
                      ,MAX(DECODE(TOP_BOT_CLF,'T',ROLL_NO,''))  TOP_ROLL_NO
                      ,MAX(DECODE(TOP_BOT_CLF,'B',ROLL_NO,''))  BOT_ROLL_NO 
                      ,MAX(DECODE(TOP_BOT_CLF,'T', ASSEM_CHOCK_DRIVE,''))  TOP_DRIVE_CHOCK 
                      ,MAX(DECODE(TOP_BOT_CLF,'T', ASSEM_CHOCK_WORK,''))  TOP_WORK_CHOCK    
                      ,MAX(DECODE(TOP_BOT_CLF,'B', ASSEM_CHOCK_DRIVE,''))  BOT_DRIVE_CHOCK 
                      ,MAX(DECODE(TOP_BOT_CLF,'B', ASSEM_CHOCK_WORK,''))  BOT_WORK_CHOCK  
                      ,STAND_NO
                      ,MAX(CHANG_DTIME) CHANG_DTIME
               from  TBH04_ROLL 
               where  roll_stat = 'U'   
                 AND ROLL_NO LIKE ?||'%' 
               GROUP BY  STAND_NO ,ROLL_TYPE
           ) a,
           (
              select   MAX(DECODE(TOP_BOT_CLF,'T',ROLL_NO,'A',ROLL_NO,'')) EXT_TOP_ROLL_NO 
                     ,MAX(DECODE(TOP_BOT_CLF,'B',ROLL_NO,'' )) EXT_BOT_ROLL_NO  
                     ,STAND_NO
               from  TBH04_ROLL  
               where  roll_stat = 'S'
              GROUP BY  STAND_NO
 
          ) b
          WHERE a.STAND_NO = b.STAND_NO(+)   
          ORDER BY a.STAND_NO
		]]>
	</query>
	<query id="UIH040030_01.update" desc="更新引出上部轧辊信息" fetchSize="10">
		<![CDATA[
				update tbh04_roll set 
				ROLL_STAT ='S' 
			   ,CHANG_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')  	
			where ROLL_NO=?
		]]>
	</query>
	<query id="UIH040030_02.update" desc="更新引入上部轧辊信息" fetchSize="10">
		<![CDATA[
				update tbh04_roll set 
				 STAND_NO = ? 
			    ,TOP_BOT_CLF = ?
			    ,ROLL_STAT ='U'
			    ,USE_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')	
			    ,CHANG_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')   	
			where ROLL_NO=?
		]]>
	</query>
	<query id="UIH040030_03.update" desc="更新引入下部轧辊信息" fetchSize="10">
		<![CDATA[
				update tbh04_roll set 
				 STAND_NO = ? 
			    ,TOP_BOT_CLF = ? 
			    ,ROLL_STAT ='U'
			    ,USE_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
                ,CHANG_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')  
			where ROLL_NO=?
		]]>
	</query>
	<query id="UIH040030_CANCEL_S.update" desc="更新引出轧辊信息" fetchSize="10">
        <![CDATA[
                update tbh04_roll set 
                ROLL_STAT = ?  
			   ,CHANG_DTIME = null
            where ROLL_NO=?
        ]]>
    </query>
	<query id="UIH040030_CANCEL_A.update" desc="更新引入单轧辊信息" fetchSize="10">
        <![CDATA[
                update tbh04_roll set 
                TOP_BOT_CLF = ?,
				ROLL_STAT = ?,    
				ASSEM_ROLL = ''      
            where ROLL_NO= ?
        ]]>
    </query>
	<query id="UIH040030_CANCEL_B.update" desc="更新引入单辊的另一个轧辊信息" fetchSize="10">
        <![CDATA[
                update tbh04_roll set 
                ROLL_STAT = ?,
			    ASSEM_ROLL = ?   
            where ROLL_NO=?
        ]]>
    </query>
	<query id="UIH040030_CANCEL_U.update" desc="更新引入轧辊信息" fetchSize="10">
        <![CDATA[
                update tbh04_roll set 
                ROLL_STAT = ?  
            where ROLL_NO=?
        ]]>
    </query>
</queryMap>