XinYu_RZMES/.svn/pristine/47/479fe51ec344b852a63a739adbd9a22b3fe470d6.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH040020_01.select" desc="磨削结束现况查询处理,这里轧辊按照规定好的编号规则进行查询" fetchSize="10">
		<![CDATA[
			select '' CHK,ROLL_NO,ROLL_TYPE,CUR_DIA,ROLL_LEN,ROLL_SHAPE_CD,ROLL_MAT_QLTY,GRIND_DTIME from tbh04_roll WHERE ROLL_STAT = 'G' and roll_no like ?||'%'
		]]>
	</query>
	<query id="UIH040020_02.select" desc="等待ROLL 查询处理" fetchSize="10">
		<![CDATA[
		select 
		   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="UIH040020_01.update" desc="根据上部轧辊号更新轧辊信息 ASSEM_CHOCK_LEFT对应的是操作 ASSEM_CHOCK_RIGHT对应的是传动 ASSEM_ROLL是上部轧辊绑定的下部轧辊的编号" fetchSize="10">
		<![CDATA[
			update tbh04_roll set 
				roll_type =?,
				ASSEM_CHOCK_DRIVE =?,
				ASSEM_CHOCK_WORK =?,
				ASSEM_ROLL =?, 
				roll_stat ='W',
				TOP_BOT_CLF =?,
				ASSEM_END_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MIDD')
					
			where ROLL_NO=?
		]]>
	</query>
	<query id="UIH040020_01.insert" desc="废弃" fetchSize="10">
		<![CDATA[
			insert into tbh04_roll 
			(
				ROLL_NO,
				roll_type,
				ASSEM_CHOCK_DRIVE,
				ASSEM_CHOCK_WORK,
				ASSEM_ROLL,
				MILL_MCH_CLF,
				roll_stat,
				TOP_BOT_CLF
			)values(?,?,?,?,?,?,'W',?)
		]]>
	</query>
	<query id="UIH040020_02.update" desc="根据下部轧辊号更新轧辊信息 ASSEM_CHOCK_LEFT对应的是操作 ASSEM_CHOCK_RIGHT对应的是传动 ASSEM_ROLL是上部轧辊绑定的下部轧辊的编号" fetchSize="10">
		<![CDATA[
			update tbh04_roll set 
				roll_type =?,
				ASSEM_CHOCK_DRIVE =?,
				ASSEM_CHOCK_WORK =?,
				ASSEM_ROLL =?, 
				roll_stat ='W',
				TOP_BOT_CLF =?,
				ASSEM_END_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MIDD')
				
			where ROLL_NO=?
		]]>
	</query>
	<query id="UIH040020_02.insert" desc="废弃" fetchSize="10">
		<![CDATA[
			insert into tbh04_roll 
			(
				ROLL_NO,
				roll_type,
				ASSEM_CHOCK_DRIVE,
				ASSEM_CHOCK_WORK,
				ASSEM_ROLL,
				MILL_MCH_CLF,
				roll_stat,
				TOP_BOT_CLF
			)values(?,?,?,?,?,?,'W',?)
		]]>
	</query>	
	<query id="UIH040020_DIS_ASM.update" desc="根据下部轧辊号更新轧辊信息 ASSEM_CHOCK_LEFT对应的是操作 ASSEM_CHOCK_RIGHT对应的是传动 ASSEM_ROLL是上部轧辊绑定的下部轧辊的编号" fetchSize="10">
        <![CDATA[
            UPDATE  TBH04_ROLL  SET    
                roll_stat ='G',
                TOP_BOT_CLF = null,
			    ASSEM_CHOCK_DRIVE = null,
			    ASSEM_CHOCK_WORK  = null, 
			    ASSEM_ROLL   = null,
                ASSEM_END_DTIME = null 
            WHERE  ROLL_NO=?
        ]]>
    </query>	
</queryMap>