XinYu_RZMES/.svn/pristine/9e/9e527ca94bd2400b94b3a8ae895eb45411f3609a.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="Roller Table 状态信息">
 
	<query id="NIH020080_01.update" desc="init " fetchSize="10">
		<![CDATA[
			UPDATE TBG04_SLAB_YARD SET 
               SLAB_NO         = ? 
              ,REG_DTIME       = ?
              ,REG_ID          = ?
			WHERE YARD_ADDR =  ?
			  AND STORELAY = '01' 
		]]>
	</query>
	<query id="NIH020080_SLAB_EXIST.select" desc="init " fetchSize="10">
        <![CDATA[ 
			SELECT YARD_ADDR 
             FROM TBG04_SLAB_YARD 
             WHERE SLAB_NO = ?
              AND (  YARD_ADDR LIKE 'A%'  OR YARD_ADDR LIKE 'C%')
			
        ]]>
    </query>
	<query id="NIH020080_SLAB_EXIST.update" desc="init " fetchSize="10">
        <![CDATA[
            UPDATE TBG04_SLAB_YARD SET 
               SLAB_NO         = null
              ,REG_DTIME       = ''
              ,REG_ID          = ''
            WHERE YARD_ADDR =  ? 
        ]]>
    </query>
	 
</queryMap>