XinYu_RZMES/.svn/pristine/23/2385a2cedfc395ebe2c3fb4d4ab63072ca736cf2.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIG050022_01.select" desc="     " fetchSize="10">
        <![CDATA[
	          select '' chk,
	          		t.seq_no,
       				 t.wight,
       				t.billetno,
       				t.length,
       				t.width,
       				t.thickness,
       				t.theory_weight
  			from tb_l2_mes_exception@link_jk111 t
  			where t.billetno like :1||'%'
  			and t.msg_flag='0'
        ]]>
    </query> 
    <query id="UIG050022_01.update" desc="     " fetchSize="10">
        <![CDATA[
	            update tbg02_slab_comm t
   				set t.WEIGHT_WGT = ?, t.SAMPLINGID = ?
 				where t.SLAB_NO = ?
        ]]>
    </query> 
    <query id="UIG050022_02.update" desc="     " fetchSize="10">
        <![CDATA[
	            update tb_l2_mes_exception@link_jk111 t
   				set t.msg_flag='1'
 				where t.seq_no = ?
        ]]>
    </query>    
</queryMap>