XinYu_RZMES/.svn/pristine/39/39a9b60155b6516de78a495e0b0f2d8431a20626.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH050300_01.select" desc=" 这里装车待机的状态是CUR_PROG_CD进度为SFB,排车顺序最后以钢卷公共表中的TRAIN_STEP_NO为准,并且在公共表中的SHIP_PROG_CD状态为05执行完后为06 ">
        <![CDATA[
            SELECT '' CHK,
       A.SHIP_DIRNO,
       A.SHIP_DIR_DTIME,
	   A.OLD_SAMPL_NO,
       A.COIL_NO,
       A.CUR_LOAD_LOC,
       A.ACT_WGT,
       A.COIL_OUTDIA,
       A.TRANS_CAR_NO,
       A.TRAIN_STEP_NO,
       DECODE(B.DLIV_TP,'T','铁路运输','C','公路运输') TRANS_CLF,
       A.DLIV_DIRNO,
       'T'||B.LANE_TP||TO_CHAR(B.ENTERANCE_SEQ,'FM00')||TO_CHAR(A.TRAIN_STEP_NO,'FM00') AS TRAIN_ADDR
            FROM tbh02_coil_comm A, TBJ01_DLIV_DIR B
            WHERE 
             (SUBSTR(A.CUR_LOAD_LOC,1,1) != 'B' AND SUBSTR(A.CUR_LOAD_LOC,1,2) != 'C0' AND SUBSTR(A.CUR_LOAD_LOC,1,1) != 'T')
             AND A.dliv_dirno = B.DLIV_DIRNO
			 AND A.CUR_LOAD_LOC IS NOT NULL  
			 AND A.TRANS_CAR_NO IS NOT NULL 
             AND  A.SHIP_DIR_DTIME like ?||'%' 
             AND  A.CUR_PROG_CD LIKE ?||'%'                                                          
        ]]>
    </query>
	<query id="UIH050300_02.select" desc="">
        <![CDATA[
			/* 查询钢卷库没执行的行车命令 */
			SELECT '' CHK,ORD_SEQ,FROM_ADDR,TO_ADDR,CR_NO,COIL_NO OLD_SAMPL_NO FROM TBH05_COIL_CRANE_ORDER WHERE ORD_STAT = '1' ORDER BY ORD_SEQ															
        ]]>
    </query>
	<query id="UIH050300_01.insert" desc="">
        <![CDATA[
			/* 这里用于新增行车命令记录 */
			INSERT INTO TBH05_COIL_CRANE_ORDER (
			ORD_SEQ
			,AREA_CD
			,CR_NO
			,FROM_ADDR
			,COIL_NO
			,TO_ADDR
			,REG_ID
			,CMD_CLF
			,ORD_STAT
			,REG_DTIME)
			VALUES( COIL_CRANE_ORDER_SEQ.NEXTVAL
					,?
					,?
					,?
					,?
					,?
			        ,?
					,'T'
					,'1'
					,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
			)
        ]]>
    </query>
	<query id="UIH050300_01.update" desc="更新行车命令锁定状态" fetchSize="10">
		<![CDATA[
			update tbh05_coil_crane_order set 
				ORD_STAT = '3'  
					
			where  ORD_SEQ = ? 
		]]>
	</query>
	<query id="UIH050300_02.update" desc="更新钢卷库库位锁定状态" fetchSize="10">
		<![CDATA[
			update TBH05_COIL_YARD set 
				RESERV_FL = '1'   
					
			where  YARD_CLF||STEP_CLF||STORELAY||STORE_SEQ = ? 
		]]>
	</query>
	<query id="UIH050300_03.update" desc="更新钢卷库库位锁定状态" fetchSize="10">
		<![CDATA[
			update TBH05_COIL_YARD set 
				RESERV_FL = ''   
					
			where  YARD_CLF||STEP_CLF||STORELAY||STORE_SEQ = ? 
		]]>
	</query>
</queryMap>