XinYu_RZMES/.svn/pristine/5f/5f609c74cfeed845b871d291f3e30f501ebc96cb.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIG040043_01.select" desc=" 行车命令制定时原板坯地址，目的地址详细信息查询 " fetchSize="10">
		<![CDATA[
		SELECT '' CHK,
			   A.YARD_ADDR,
      		   A.STORELAY,
			   A.SLAB_NO,
			   B.SLAB_THK,
			   B.SLAB_WTH,
			   B.SLAB_LEN,
			   B.SLAB_WGT,
			   B.STL_GRD,
			   B.HCR_CLF,
			   A.ORD_FLAG
		FROM TBG02_SLAB_COMM B
		,    TBG04_SLAB_YARD A
		WHERE A.SLAB_NO = B.SLAB_NO(+)
		AND   A.YARD_ADDR = ?
		ORDER BY A.STORELAY DESC
		]]>
	</query> 
	<query id="UIG040043_02.select" desc=" 以制定尚未执行的板坯行车命令查询 " fetchSize="10">
		<![CDATA[
		SELECT '' CHK,
			   SEQ_NO,
			   FROM_ADDR,
       		   TO_ADDR,
			   SLAB_CNT,
			   CR_NO
		FROM TBG04_SLAB_CRANE_ORDER
		WHERE ORD_STAT = '1'
		ORDER BY SEQ_NO 
		]]>
	</query> 
	<query id="UIG040043_01.insert" desc=" 新增一条行车命令 " fetchSize="10">
		<![CDATA[
		INSERT INTO TBG04_SLAB_CRANE_ORDER 
		(   
		   SEQ_NO
		  ,CR_NO
		  ,FROM_ADDR
		  ,TO_ADDR
		  ,SLAB_CNT
		  ,ORD_SLAB_NO1
		  ,ORD_SLAB_NO2
		  ,ORD_SLAB_NO3
		  ,ORD_SLAB_NO4
		  ,ORD_DTIME
		  ,ORD_STAT
		  ,REG_ID
		  ,REG_DTIME
		  ,ORD_TYPE
		)VALUES
		( SLAB_CRANE_ORDER_SEQ.NEXTVAL
		 ,?
		 ,?
		 ,?
		 ,?
		 ,?
		 ,?
		 ,?
		 ,?
		 ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
		 ,'1'
		 ,'UIG040043'
		 ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
		 ,'C'
		 )
		]]>
	</query> 
	<query id="UIG040043_01.delete" desc=" 删除一条行车命令 修改行车状态为 ‘3’ " fetchSize="10">
		<![CDATA[
		UPDATE TBG04_SLAB_CRANE_ORDER SET ORD_STAT = '3'
		WHERE SEQ_NO = ?
		AND   CR_NO = ?
		]]>
	</query> 
	<query id="UIG040043_03.select" desc=" 查询板坯库一个跺位的可以编制的板坯，选择要移动的板坯 " fetchSize="10">
		<![CDATA[
		  SELECT STORELAY , SLAB_NO 
            FROM  TBG04_SLAB_YARD
           WHERE YARD_ADDR = ?
             AND SLAB_NO IS NOT NULL
			 AND ORD_FLAG IS NULL
           ORDER BY STORELAY DESC
		]]>
	</query> 
	<query id="UIG040043_06.select" desc=" 查询板一个命令编制的板坯号 " fetchSize="10">
		<![CDATA[
		  SELECT STORELAY , SLAB_NO 
            FROM  TBG04_SLAB_YARD
           WHERE YARD_ADDR = ?
             AND SLAB_NO IS NOT NULL
			 AND ORD_FLAG = '1'
           ORDER BY STORELAY ASC     
		]]>
	</query> 
	<query id="UIG040043_04.select" desc="  " fetchSize="10">
		<![CDATA[
	     SELECT   SLAB_NO 
           FROM  TBG04_SLAB_YARD
          WHERE ORD_FLAG = '1'
            AND SLAB_NO = ?
            AND YARD_ADDR  = ? 
		]]>
	</query> 
	<query id="UIG040043_05.select" desc="  " fetchSize="10">
		<![CDATA[
	     SELECT   a.YARD_ADDR YARD_LOC,YARD_NAME ,SLAB_CNT
           FROM  TBG04_STD_SLAB_YARD a,
                (SELECT YARD_ADDR,COUNT(SLAB_NO) SLAB_CNT FROM TBG04_SLAB_YARD   
                 WHERE SLAB_NO IS NOT NULL AND YARD_ADDR LIKE ?||'%' GROUP BY YARD_ADDR ) b
          WHERE a.YARD_ADDR = b.YARD_ADDR(+) 
           AND  a.YARD_ADDR  LIKE ?||'%' 
		]]>
	</query> 
	<query id="UIG040043_toAddr_UPDATE.select" desc=" 查询板坯库一个跺位的可以放置板坯的位置，选择要的放置板坯的位置 " fetchSize="10">
		<![CDATA[
		  SELECT STORELAY , SLAB_NO 
            FROM  TBG04_SLAB_YARD
           WHERE YARD_ADDR = ?
             AND SLAB_NO IS  NULL
			 AND ORD_FLAG IS NULL
           ORDER BY STORELAY ASC
		]]>
	</query>
	<query id="UIG040043_toAddr_delete.select" desc=" 查询板坯库一个跺位的可以放置板坯的位置，选择要的放置板坯的位置 " fetchSize="10">
		<![CDATA[
		  SELECT STORELAY , SLAB_NO 
            FROM  TBG04_SLAB_YARD
           WHERE YARD_ADDR = ?
             AND SLAB_NO IS  NULL
			 AND ORD_FLAG = '4'
           ORDER BY STORELAY ASC
		]]>
	</query>
</queryMap>