XinYu_RZMES/.svn/pristine/7c/7c726deeda3fe2c19ca2926334f173c5bb7c5814.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH090020_01.select" desc=" 加热炉入炉报表 " fetchSize="10">
		<![CDATA[
			select ROWNUM seq,
       decode(c.buy_charge_no,null,nvl(c.buy_charge_no,'热轧材'),'外购坯') buy_charge_no,
       a.slab_no,
       c.stl_grd,
       c.slab_thk||'*'||c.slab_wth||'*'||c.slab_len t_w_l,
       c.slab_wgt,
       a.devno,
       DECODE(a.ROW_NUM,'1','一列','2','二列','0','长坯')  ROW_NUM, 
       a.charing_dtime,
       b.roll_mana_no,
       substr(a.coil_no,0,10) coil_no,
       a.CHRGING_WK_EMP_NO,
     '' memo
         from 
         tbh02_reheatfur a,tbf02_spec_mill b,tbg02_slab_comm c
         where a.slab_no = b.slab_no
         and   a.slab_no = c.slab_no
         and   substr(a.charing_dtime,1,12) >= ?
         and   substr(a.charing_dtime,1,12) <= ?
         and   a.CHRGING_WKGROUP||'&' like ?||'%'
         and   a.CHRGING_WKSHIFT||'&' like ?||'%'
		 
		order by a.CHARING_DTIME
         
		]]>
	</query>
	<query id="UIH090020_02.select" desc=" 加热炉入炉报表,统计块数和重量 " fetchSize="10">
		<![CDATA[
			select count(c.SLAB_NO) COIL_CNT,
            nvl(sum(c.SLAB_WGT)/1000,0) COIL_WGT 
         from 
         tbh02_reheatfur a,tbf02_spec_mill b,tbg02_slab_comm c
         where a.slab_no = b.slab_no
         and   a.slab_no = c.slab_no
         and   substr(a.charing_dtime,1,12) >= ?
         and   substr(a.charing_dtime,1,12) <= ?
         and   a.CHRGING_WKGROUP||'&' like ?||'%'
         and   a.CHRGING_WKSHIFT||'&' like ?||'%' 
         
		]]>
	</query>
</queryMap>