XinYu_RZMES/.svn/pristine/2c/2c5a21c80295f9234b9bb3eb8c9f74f1f59046ce.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIG040045_SLAB_YD.select" desc="  " fetchSize="10">
		<![CDATA[
	     SELECT YARD_ADDR,STORELAY,SLAB_NO 
			FROM TBG04_SLAB_YARD 
			WHERE SLAB_NO IS NOT NULL 
			AND YARD_ADDR = ?
		]]>
	</query> 
	<query id="UIG040045_TRANS_CAR_YD.select" desc="  " fetchSize="10">
		<![CDATA[
	     SELECT STORELAY,SLAB_NO,ORD_FLAG 
			FROM TBG04_SLAB_YARD 
			WHERE SLAB_NO IS NOT NULL 
			AND YARD_ADDR = 'T01'
		]]>
	</query> 
	<query id="UIG040045_SLAB_NO.select" desc="  " fetchSize="10">
		<![CDATA[
			SELECT SLAB_THK||'*'||SLAB_WTH||'*'||SLAB_LEN SLAB_SIZE
				   ,STL_GRD
				   ,SLAB_WGT
				   ,ORD_NO
				   ,ORD_SEQ
				   ,GF_NIB028720(SLAB_NO , ORD_NO , ORD_SEQ)  QLFD_YN
			FROM TBG02_SLAB_COMM  WHERE SLAB_NO = ?
		]]>
	</query>
	<query id="UIG040045_SLBA_CRANE_ORDER.insert" desc="  " fetchSize="10">
		<![CDATA[
	     INSERT INTO TBG04_SLAB_CRANE_ORDER 
    	(SEQ_NO
        ,cr_no 
		,from_addr 
		,to_addr 
		,slab_cnt 
		,ord_dtime
		,ord_stat
		,reg_id
		,reg_dtime 
		,ORD_SLAB_NO1 
		,ORD_SLAB_NO2 
		,ORD_SLAB_NO3 
		)VALUES(SLAB_CRANE_ORDER_SEQ.NEXTVAL,?,'T01',?,?,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'),'1','UIG040045',TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'),?,?,?)
		]]>
	</query> 
	<query id="UIG040045_SLBA_CRANE_ORDER.select" desc="  " fetchSize="10">
		<![CDATA[
	     select from_addr,to_addr,cr_no,ord_slab_no1,ord_slab_no2,ord_slab_no3 
		from tbg04_slab_crane_order 
		where from_addr = 'T01'
	    and ord_stat = '1'
		]]>
	</query> 
	<query id="UIG040045_SLBA_YARD.update" desc="  " fetchSize="10">
		<![CDATA[
	    UPDATE TBG04_SLAB_YARD 
		SET SLAB_NO = ?
			,BEF_STORE_LOC = ?
			,REG_ID = 'UIG040045'
			,REG_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
		WHERE YARD_ADDR = ?
		AND   STORELAY = ?
		]]>
	</query> 
	<query id="UIG040045_SLBA_YARD_STORELAY.select" desc="  " fetchSize="10">
		<![CDATA[
	    select STORELAY from tbg04_slab_yard  WHERE YARD_ADDR = ? AND SLAB_NO IS  NULL AND ROWNUM = 1
		]]>
	</query>
	<query id="UIG040045_SLBA_YARD_FROM.update" desc="  " fetchSize="10">
		<![CDATA[
	    UPDATE TBG04_SLAB_YARD 
		SET SLAB_NO = ''
			,BEF_STORE_LOC = ''
			,REG_ID = ''
			,REG_DTIME = ''
			,CR_NO = ''
			,ORD_FLAG = ''
		WHERE YARD_ADDR = ?
		AND   STORELAY = ?
		]]>
	</query>
	<query id="UIG040045_SLBA_YARD_CLREA.update" desc="  " fetchSize="10">
		<![CDATA[
	    UPDATE TBG04_SLAB_YARD 
		SET SLAB_NO = ''
			,BEF_STORE_LOC = ''
			,REG_ID = ''
			,REG_DTIME = ''
			,CR_NO = ''
			,ORD_FLAG = ''
		WHERE SLAB_NO = ?
		]]>
	</query>
	<query id="UIG040045_SLAB_COMM_TAKEOUT.update" desc="  " fetchSize="10">
		<![CDATA[
	    UPDATE TBG02_SLAB_COMM 
		SET    CUR_LOAD_LOC = ? 
			   ,SMS_YARD_EXT_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
		WHERE  SLAB_NO  = ?
		]]>
	</query>
	<query id="UIG040045_SLAB_COMM_TAKEIN.update" desc="  " fetchSize="10">
		<![CDATA[
	    UPDATE TBG02_SLAB_COMM 
		SET    CUR_LOAD_LOC = ? 
			   ,SLAB_STOCK_ENT_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
		WHERE  SLAB_NO  = ?
		]]>
	</query>
	<query id="UIG040045_SLBA_YARD_ORD_STATUS.update" desc="  " fetchSize="10">
		<![CDATA[
	    UPDATE TBG04_SLAB_YARD 
		SET ORD_FLAG = '1'
			,CR_NO = ?
		WHERE YARD_ADDR = ?
		AND   SLAB_NO = ?
		]]>
	</query> 
</queryMap>