XinYu_RZMES/.svn/pristine/c2/c2033ab4f46ecb2bcbeb37972cdae7f65807f0cc.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING PROGRESS MONITORING  ">
  <query id="UIG030030_01.select" desc="获得中间包等待信息">
	   <![CDATA[
	  SELECT '' CHK,TD_NO,TD_CYCLIC_CNT ,TD_CYCLIC_CNT_LIMIT
      FROM TBG03_TD_PROG
     WHERE TD_STATUS = '1'
        ]]> 
  </query>
  <query id="UIG030030_02.select" desc="获得待机结晶器信息">
      <![CDATA[
	  SELECT '' CHK,MD_NO,MD_CYCLIC_CNT,MD_CYCLIC_CNT_LIMIT 
      FROM TBG03_MD_PROG
     WHERE MD_STATUS = '1'
        ]]>  
  </query>
	<query id="UIG030030_01.update" desc="更新从相应的连铸机1上拿下来的中间包的信息,这里写死连铸机号与前台页面对应" fetchSize="10">
		<![CDATA[	
			update TBG03_TD_PROG set 
				USE_CAST_NO =null,
				USE_MC_NO =null,
				TD_STATUS = '1'
					
			where USE_MC_NO='1' 
			and TD_STATUS = '2'	
		]]>
	</query> 
	<query id="UIG030030_02.update" desc="更新放入连铸机1的中间包的信息" fetchSize="10">
		<![CDATA[	
			update TBG03_TD_PROG set 
				USE_MC_NO = '1',
				TD_CYCLIC_CNT = ?,
				TD_STATUS = '2'
					
			where TD_NO=?  
			and TD_STATUS = '1'	
		]]>
	</query>
	<query id="UIG030030_03.update" desc="更新从连铸机1上拿下来的结晶器的信息" fetchSize="10">
		<![CDATA[	
			update TBG03_MD_PROG set 
				USE_MC_NO =null,
				MD_STATUS = '1'
					
			where USE_MC_NO='1' 
			and MD_STATUS = '2'	
		]]>
	</query> 
	<query id="UIG030030_04.update" desc="更新放入结晶器1的信息到相应的表中" fetchSize="10">
		<![CDATA[	
			update TBG03_MD_PROG set 
				USE_MC_NO = '1',
				MD_CYCLIC_CNT = ?,
				MD_STATUS = '2',
			    MD_UP_SIDE ='R'	
					
			where MD_NO=?  
			and MD_STATUS = '1'	
		]]>
	</query>
	<query id="UIG030030_05.update" desc="更新放入结晶器2的信息到相应的表中" fetchSize="10">
		<![CDATA[	
			update TBG03_MD_PROG set 
				USE_MC_NO = '1',
				MD_CYCLIC_CNT = ?,
				MD_STATUS = '2',
				MD_UP_SIDE ='L'
					
			where MD_NO=?  
			and MD_STATUS = '1'	
		]]>
	</query> 
	<query id="UIG030030_06.update" desc="更新从相应的连铸机2上拿下来的中间包的信息,这里写死连铸机号与前台页面对应" fetchSize="10">
		<![CDATA[	
			update TBG03_TD_PROG set 
				USE_CAST_NO =null,
				USE_MC_NO =null,
				TD_STATUS = '1'
					
			where USE_MC_NO='2' 
			and TD_STATUS = '2'	
		]]>
	</query> 
	<query id="UIG030030_07.update" desc="更新放入连铸机2的中间包的信息" fetchSize="10">
		<![CDATA[	
			update TBG03_TD_PROG set 
				USE_MC_NO = '2',
				TD_CYCLIC_CNT = ?,
				TD_STATUS = '2'
					
			where TD_NO=?  
			and TD_STATUS = '1'	
		]]>
	</query>
	<query id="UIG030030_08.update" desc="更新从连铸机1上拿下来的结晶器的信息" fetchSize="10">
		<![CDATA[	
			update TBG03_MD_PROG set 
				USE_MC_NO =null,
				MD_STATUS = '1'
					
			where USE_MC_NO='2' 
			and MD_STATUS = '2'	
		]]>
	</query> 
	<query id="UIG030030_09.update" desc="更新放入结晶器1的信息到相应的表中" fetchSize="10">
		<![CDATA[	
			update TBG03_MD_PROG set 
				USE_MC_NO = '2',
				MD_CYCLIC_CNT = ?,
				MD_STATUS = '2',
				MD_UP_SIDE ='R'
					
			where MD_NO=?  
			and MD_STATUS = '1'	
		]]>
	</query>
	<query id="UIG030030_10.update" desc="更新放入结晶器2的信息到相应的表中" fetchSize="10">
		<![CDATA[	
			update TBG03_MD_PROG set 
				USE_MC_NO = '2',
				MD_CYCLIC_CNT = ?,
				MD_STATUS = '2',
				MD_UP_SIDE ='L'
					
			where MD_NO=?  
			and MD_STATUS = '1'	
		]]>
	</query>
	<query id="UIG030030_12.update" desc="更新从连铸机1上拿下来的结晶器的信息" fetchSize="10">
		<![CDATA[	
			update TBG03_MD_PROG set 
				USE_MC_NO =null,
				MD_STATUS = '1'
					
			where USE_MC_NO='1' 
			and MD_STATUS = '2'	
			and MD_UP_SIDE = 'R'
		]]>
	</query> 
	<query id="UIG030030_13.update" desc="更新从连铸机1上拿下来的结晶器的信息" fetchSize="10">
		<![CDATA[	
			update TBG03_MD_PROG set 
				USE_MC_NO =null,
				MD_STATUS = '1'
					
			where USE_MC_NO='1' 
			and MD_STATUS = '2'	
			and MD_UP_SIDE = 'L'
		]]>
	</query> 
	<query id="UIG030030_11.update" desc="更新从连铸机2上拿下来的结晶器的信息" fetchSize="10">
		<![CDATA[	
			update TBG03_MD_PROG set 
				USE_MC_NO =null,
				MD_STATUS = '1'
					
			where USE_MC_NO='2' 
			and MD_STATUS = '2'	
			and MD_UP_SIDE = 'R'
		]]>
	</query> 
	<query id="UIG030030_14.update" desc="更新从连铸机2上拿下来的结晶器的信息" fetchSize="10">
		<![CDATA[	
			update TBG03_MD_PROG set 
				USE_MC_NO =null,
				MD_STATUS = '1'
					
			where USE_MC_NO='2' 
			and MD_STATUS = '2'	
			and MD_UP_SIDE = 'L'
		]]>
	</query> 
	<query id="UIG030030_L2_SEND.insert" desc="CCM LEVEL2 SEND INSERT " fetchSize="10">
        <![CDATA[   
             INSERT INTO  TBG06_L2_SEND_TDMD
              (
                SEQ_NO
               ,MSG_FLAG
               ,TC_ID 
               ,SND_DTIME
               ,SND_SEQNO
               ,SND_RESERV
               ,CAST_NO
               ,TD_NO
               ,TD_USE_CNT
               ,MD_NO1
               ,MD_NO1_USE_CNT
               ,MD_NO2
               ,MD_NO2_USE_CNT
               ,TRANS_DTIME
              )
              VALUES
              (
                L2_SEND_TDMD_SEQ.NEXTVAL
               ,'N'
               ,'UIG030030' 
               , TO_DATE(SYSDATE,'YYYYMMDDHH24MISS')
               , L2_SEND_TDMD_SEQ.NEXTVAL
               ,  ''
               , ?
               , ?
               , ?
               , ?
               , ?
               , ?
               , ?
               , TO_DATE(SYSDATE,'YYYYMMDDHH24MISS')
             )
        ]]>
    </query> 
</queryMap>