XinYu_RZMES/.svn/pristine/09/09a5aa58cd961363ca487a4753d81d3936034f62.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">

	<query id="RecvDataL2_G_RECV_DATA.Select" desc="" fetchSize="10">
		<![CDATA[
			SELECT SEQ_NO, MSG_ID, TRAN_DTIME, MSG_DATA
			FROM TBG06_L2_RECV_DATA
			WHERE MSG_ID IN ('NIG020100', 'NIG020110', 'NIG020120',				-- KR
							'NIG020200', 'NIG020210', 'NIG020220', 'NIG020230',	-- BOF
							'NIG020310', 'NIG020320', 'NIG020330',				-- RH
							'NIG020510', 'NIG020520',							-- LF
							'NIG020410', 'NIG020420', 'NIG020430',				-- CAS
							'NIG020610', 'NIG020620', 'NIG020630', 'NIG020640')	-- CCM
			  AND MSG_FLAG = 'N'
			  AND ROWNUM < 21
			ORDER BY TRAN_DTIME
		]]>
	</query>
	<!-- 未知接口数据，即业务不处理的记录：现不用了 -->
	<query id="RecvDataL2_UG_RECV_DATA.Select" desc="" fetchSize="10">
		<![CDATA[
			SELECT SEQ_NO, TRAN_DTIME
			FROM TBG06_L2_RECV_DATA
			WHERE MSG_ID NOT IN ('NIG020100', 'NIG020110', 'NIG020120',			-- KR
							'NIG020200', 'NIG020210', 'NIG020220', 'NIG020230',	-- BOF
							'NIG020310', 'NIG020320', 'NIG020330',				-- RH
							'NIG020510', 'NIG020520',							-- LF
							'NIG020410', 'NIG020420', 'NIG020430',				-- CAS
							'NIG020610', 'NIG020620', 'NIG020630', 'NIG020640')	-- CCM
			  AND MSG_FLAG = 'N'
			  AND ROWNUM < 21
			ORDER BY TRAN_DTIME
		]]>
	</query> 
	<query id="RecvDataL2_G_RECV_DATA.Update" desc="" fetchSize="10">
        <![CDATA[
			UPDATE TBG06_L2_RECV_DATA SET
				MSG_FLAG = ?,
				UP_DTIME = TO_CHAR(SYSTIMESTAMP, 'YYYYMMDDHH24MISS')
			WHERE SEQ_NO = ?
			  AND TRAN_DTIME = ?
		]]>
	</query> 
	<query id="RecvDataL2_UG_RECV_DATA.Update" desc="" fetchSize="10">
		<![CDATA[
			UPDATE TBG06_L2_RECV_DATA SET
				MSG_FLAG = 'U',
				UP_DTIME = TO_CHAR(SYSTIMESTAMP, 'YYYYMMDDHH24MISS')
			WHERE MSG_ID NOT IN ('NIG020100', 'NIG020110', 'NIG020120',			-- KR
							'NIG020200', 'NIG020210', 'NIG020220', 'NIG020230',	-- BOF
							'NIG020310', 'NIG020320', 'NIG020330',				-- RH
							'NIG020510', 'NIG020520',							-- LF
							'NIG020410', 'NIG020420', 'NIG020430',				-- CAS
							'NIG020610', 'NIG020620', 'NIG020630', 'NIG020640')	-- CCM
			  AND MSG_FLAG = 'N'
		]]>
	</query> 

	<query id="RecvDataL2_C_RECV_DATA.Select" desc=" " fetchSize="10">
		<![CDATA[   
			SELECT SEQ_NO, PLAN_CHARGE_NO, RT_CD||'  ' RT_CD, TRAN_DTIME, EXAMINE_SEQ                  
				,ELE_CD_1, TO_CHAR(NVL(ELE_1, 0))  ELE_1             
				,ELE_CD_2, TO_CHAR(NVL(ELE_2, 0))  ELE_2             
				,ELE_CD_3, TO_CHAR(NVL(ELE_3, 0))  ELE_3             
				,ELE_CD_4, TO_CHAR(NVL(ELE_4, 0))  ELE_4             
				,ELE_CD_5, TO_CHAR(NVL(ELE_5, 0))  ELE_5             
				,ELE_CD_6, TO_CHAR(NVL(ELE_6, 0))  ELE_6             
				,ELE_CD_7, TO_CHAR(NVL(ELE_7, 0))  ELE_7             
				,ELE_CD_8, TO_CHAR(NVL(ELE_8, 0))  ELE_8             
				,ELE_CD_9, TO_CHAR(NVL(ELE_9, 0))  ELE_9             
				,ELE_CD_10, TO_CHAR(NVL(ELE_10,0)) ELE_10            
				,ELE_CD_11, TO_CHAR(NVL(ELE_11,0)) ELE_11            
				,ELE_CD_12, TO_CHAR(NVL(ELE_12,0)) ELE_12            
				,ELE_CD_13, TO_CHAR(NVL(ELE_13,0)) ELE_13            
				,ELE_CD_14, TO_CHAR(NVL(ELE_14,0)) ELE_14            
				,ELE_CD_15, TO_CHAR(NVL(ELE_15,0)) ELE_15            
				,ELE_CD_16, TO_CHAR(NVL(ELE_16,0)) ELE_16            
				,ELE_CD_17, TO_CHAR(NVL(ELE_17,0)) ELE_17            
				,ELE_CD_18, TO_CHAR(NVL(ELE_18,0)) ELE_18            
				,ELE_CD_19, TO_CHAR(NVL(ELE_19,0)) ELE_19            
				,ELE_CD_20, TO_CHAR(NVL(ELE_20,0)) ELE_20            
				,ELE_CD_21, TO_CHAR(NVL(ELE_21,0)) ELE_21            
				,ELE_CD_22, TO_CHAR(NVL(ELE_22,0)) ELE_22            
				,ELE_CD_23, TO_CHAR(NVL(ELE_23,0)) ELE_23            
				,ELE_CD_24, TO_CHAR(NVL(ELE_24,0)) ELE_24            
				,ELE_CD_25, TO_CHAR(NVL(ELE_25,0)) ELE_25            
				,ELE_CD_26, TO_CHAR(NVL(ELE_26,0)) ELE_26            
				,ELE_CD_27, TO_CHAR(NVL(ELE_27,0)) ELE_27            
				,ELE_CD_28, TO_CHAR(NVL(ELE_28,0)) ELE_28            
				,ELE_CD_29, TO_CHAR(NVL(ELE_29,0)) ELE_29            
				,ELE_CD_30, TO_CHAR(NVL(ELE_30,0)) ELE_30            
				,ELE_CD_31, TO_CHAR(NVL(ELE_31,0)) ELE_31            
				,ELE_CD_32, TO_CHAR(NVL(ELE_32,0)) ELE_32            
				,ELE_CD_33, TO_CHAR(NVL(ELE_33,0)) ELE_33            
				,ELE_CD_34, TO_CHAR(NVL(ELE_34,0)) ELE_34            
				,ELE_CD_35, TO_CHAR(NVL(ELE_35,0)) ELE_35            
			FROM TBG06_L2_CHEM_RESULT                                
			WHERE MSG_FLAG = 'N'
			  AND ROWNUM < 21
			ORDER BY TRAN_DTIME
		]]>
	</query> 
	<query id="RecvDataL2_C_RECV_DATA.Update" desc="" fetchSize="10">
        <![CDATA[
			UPDATE TBG06_L2_CHEM_RESULT SET
				MSG_FLAG = ?,
				UP_DTIME = TO_CHAR(SYSTIMESTAMP, 'YYYYMMDDHH24MISS')
			WHERE SEQ_NO = ?
			  AND TRAN_DTIME = ?
		]]>
	</query> 

	<query id="RecvDataL2_H_RECV_DATA.Select" desc="" fetchSize="10">
		<![CDATA[
			SELECT A.SEQ_NO, B.TC_ID, A.TRANS_DTIME, SUBSTR(A.TC_MSG, 41) TC_MSG
			FROM TBH06_L2_RECV_DATA A, (
				SELECT TC_ID, L2_RECV_TC_ID
				FROM TBZ01_TCID_LEN
				WHERE PROC_CD = 'H'
				  AND TC_SEND_RECV = 'R') B
			WHERE A.MSG_FLAG = 'N'
			  AND TRIM(SUBSTR(A.TC_MSG, 5, 6)) = B.L2_RECV_TC_ID
			  AND ROWNUM < 21
			ORDER BY TRANS_DTIME
		]]>
	</query> 
	<!-- 未知接口数据，即业务不处理的记录：现不用了 -->
	<query id="RecvDataL2_UH_RECV_DATA.Select" desc="" fetchSize="10">
		<![CDATA[
			SELECT A.SEQ_NO, A.TRANS_DTIME
			FROM TBH06_L2_RECV_DATA A
			WHERE A.MSG_FLAG = 'N'
			  AND TRIM(SUBSTR(A.TC_MSG, 5, 6)) NOT IN (
					SELECT L2_RECV_TC_ID
					FROM TBZ01_TCID_LEN
					WHERE PROC_CD = 'H'
					  AND TC_SEND_RECV = 'R')
			  AND ROWNUM < 21
			ORDER BY TRANS_DTIME
		]]>
	</query> 
	<query id="RecvDataL2_H_RECV_DATA.Update" desc="" fetchSize="10">
        <![CDATA[
			UPDATE TBH06_L2_RECV_DATA SET
				MSG_FLAG = ?,
				UP_DTIME = TO_CHAR(SYSTIMESTAMP, 'YYYYMMDDHH24MISS')
			WHERE SEQ_NO = ?
			  AND TRANS_DTIME = ?
		]]>
	</query> 
	<query id="RecvDataL2_UH_RECV_DATA.Update" desc="" fetchSize="10">
		<![CDATA[
			UPDATE TBH06_L2_RECV_DATA SET
				MSG_FLAG = 'U',
				UP_DTIME = TO_CHAR(SYSTIMESTAMP, 'YYYYMMDDHH24MISS')
			WHERE MSG_FLAG = 'N'
			  AND TRIM(SUBSTR(TC_MSG, 5, 6)) NOT IN (
					SELECT L2_RECV_TC_ID
					FROM TBZ01_TCID_LEN
					WHERE PROC_CD = 'H'
					  AND TC_SEND_RECV = 'R')
		]]>
	</query> 

	<!-- 生产实时数据处理，现在不同了 -->
	<query id="RecvDataL2_RT_RECV_DATA.Select" desc="" fetchSize="10">
		<![CDATA[
			SELECT SEQ_NO, MSG_ID, TRAN_DTIME, MSG_DATA
			FROM TBG06_L2_RECV_DATA
			WHERE MSG_ID IN ('NIG020130',	-- KR
							'NIG020250',	-- BOF
							'NIG020330',	-- RH
							'NIG020530',	-- LF
							'NIG020430',	-- CAS
							'NIG020650')	-- CCM
			  AND MSG_FLAG = 'N'
			  AND ROWNUM < 101
			ORDER BY TRAN_DTIME
		]]>
	</query> 

	<query id="Delete.RecvData.DB" desc="数据库接收">
		<![CDATA[
			DELETE TBG06_L2_RECV_DATA
			WHERE (TO_CHAR(SYSDATE - 7, 'YYYYMMDD') > SUBSTR(TRAN_DTIME, 1, 8))
					OR (MSG_FLAG = 'C' AND MSG_ID IN ('NIG020331','NIG020332','NIG020530','NIG020650'))
		]]>
	</query>
	<query id="Delete.Chem.DB" desc="成分接收">
		<![CDATA[
			DELETE TBG06_L2_CHEM_RESULT
			WHERE TO_CHAR(SYSDATE - 7, 'YYYYMMDD') > SUBSTR(TRAN_DTIME, 1, 8)
		]]>
	</query>
	<query id="Delete.RecvData" desc="报文接收">
		<![CDATA[
			DELETE TBH06_L2_RECV_DATA
			WHERE TO_CHAR(SYSDATE - 7, 'YYYYMMDD') > SUBSTR(TRANS_DTIME, 1, 8)
		]]>
	</query>

	<query id="Delete.MILL_INS" desc="轧制指示">
		<![CDATA[
			DELETE FROM TBH06_L2_MILL_INS T
			WHERE SYSDATE - TO_DATE(T.TRANS_DTIME, 'yyyymmddhh24miss') > 3
		]]>
	</query>
	<query id="Delete.COIL_NO_INS" desc="顺序指示：未使用">
		<![CDATA[
			DELETE FROM TBH06_L2_COIL_NO_INS T
			WHERE SYSDATE - TO_DATE(T.TRANS_DTIME, 'yyyymmddhh24miss') > 1
		]]>
	</query>
	<query id="Delete.RHT_INS" desc="加热炉指示">
		<![CDATA[
			DELETE FROM TBH06_L2_RHT_INS T
			WHERE SYSDATE - TO_DATE(T.TRANS_DTIME, 'yyyymmddhh24miss') > 3
		]]>
	</query>
		<query id="TESTweb" desc="weblogic测试">
		<![CDATA[
			insert into test_date_t_table(date_t) values (sysdate)
		]]>
	</query>
</queryMap>