XinYu_RZMES/.svn/pristine/73/738dfc5ba5f0ed1e29220992374c6e97d7fddd23.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING PROGRESS    ">
              
   <query id="NIG040200_SLAB_YARD.select" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
         SELECT YARD_ADDR,STORELAY,SLAB_NO,BEF_STORE_LOC,CR_NO,REG_ID,REG_DTIME,ORD_FLAG 
         FROM TBG04_SLAB_YARD T 
         WHERE '1' = '1'
         AND   SLAB_NO IS NOT NULL
         AND   YARD_ADDR = ?
         ORDER BY STORELAY ASC
        ]]>
    </query>
	<query id="NIG040200_SLAB_YARD.update" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
			UPDATE TBG04_SLAB_YARD
			SET SLAB_NO = ?
				,BEF_STORE_LOC = ?
				,CR_NO = ?
				,REG_ID = ?
				,REG_DTIME = ?
				,ORD_FLAG = ?
			WHERE YARD_ADDR = ?   
			AND   STORELAY = ?
        ]]>
    </query>
	<query id="NIG040200_SLAB_COMM.update" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
			UPDATE TBG02_SLAB_COMM 
			SET CUR_LOAD_LOC = ?
			WHERE SLAB_NO = ?
        ]]>
    </query>
	<query id="NIG040200_SLAB_YARD_CLEAR.update" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
			UPDATE TBG04_SLAB_YARD
			SET SLAB_NO = ''
				,BEF_STORE_LOC = ''
				,CR_NO = ''
				,REG_ID = ''
				,REG_DTIME = ''
				,ORD_FLAG = ''
			WHERE YARD_ADDR = ?   
			AND   STORELAY = ?
        ]]>
    </query>
</queryMap>