XinYu_RZMES/.svn/pristine/2f/2f3073020a1e3ec005291743a0cc7c661d63ea19.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">	
    <query id="UIG020060_101.insert" desc="写入发送信息">
        <![CDATA[
		   insert into tb_slab_wgt_send
  (CHARGE_NO,
   SLAB_NO,
   CC_DEVNO,
   STL_GRD,
   state,
   flag,
   ply,
   width,
   len,
   quantity,
   theor_wgt,
   wgt_seq,
   real_wgt,
   sedn_time,
   revert_time,
   last_updatetime,
   cuttime,
   heatoverflag)
values
  (?,
   ?,
   ?,
   ?,
   ?,
   ?,
   ?,
   ?,
   ?,
   ?,
   ?,
   null,
   null,
   to_char(sysdate, 'yyyymmddhh24miss'),
   null,
   to_char(sysdate, 'yyyymmddhh24miss'),
   ?,
   ?);
        ]]>
    </query>
	<query id="UIG020062_102.select" desc="发送表数据查询">
        <![CDATA[
		   
			select 
			'N' chk,
			CHARGE_NO,
   SLAB_NO,
   CC_DEVNO,
   STL_GRD,
   decode(state,'1','未接收','2','已接收') state,
   flag,
   ply,
   width,
   len,
   quantity,
   theor_wgt,
   wgt_seq,
   real_wgt,
   sedn_time,
   revert_time,
   last_updatetime,
   cuttime,
   heatoverflag
  from tb_slab_wgt_send t
 where t.CHARGE_NO LIKE ?||'%' 
 AND TO_CHAR(T.CUTTIME) BETWEEN ? AND ?
        ]]>
    </query>
    
    <query id="UIG020060_103.update" desc="更新发送表">
        <![CDATA[
		  update tb_slab_wgt_send
   set ccmid           = ?,
       steelcode       = ?,
       state           = ?,
       flag            = ?,
       ply             = ?,
       width           = ?,
       len             = ?,
       quantity        = ?,
       theor_wgt       = ?,
       sedn_time       = to_char(sysdate, 'yyyymmddhh24miss'),
       heatoverflag    = ?,
       last_updatetime = to_char(sysdate, 'yyyymmddhh24miss')
 where heatno = ?
   and billetno = ?
		   
        ]]>
    </query>
    
    <query id="UIG020060_104.update" desc="接受二级回填重量">
        <![CDATA[
		   
    update tb_slab_wgt_send a
   set a.state           = '2',
       a.real_wgt        = ?,
       a.wgt_seq         = ?,
       a.revert_time     = ?,
       a.last_updatetime = to_char(sysdate, 'yyyymmddhh24miss')
 where CHARGE_NO = ?
   		and SLAB_NO = ?		
    
        ]]>
    </query>
    
    <query id="UIG020060_105.update" desc="更新接收表的状态为已处理">
        <![CDATA[
		  
           update tb_slab_wgt_rec set flag = '1'  where CHARGE_NO = ?  and SLAB_NO = ? and flag = '0' 
					   
        ]]>
    </query>
</queryMap>