XinYu_RZMES/.svn/pristine/b4/b44f8c17c5b5ddc317fea1c75c6b85cfce19771c.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH090040_01.select" desc=" 成品库库存报表 " fetchSize="10">
		<![CDATA[
select '' CHK,
       a.old_sampl_no,
       a.spec_stl_grd,
       A.INSTR_COIL_THK,
       A.INSTR_COIL_WTH,
       a.COIL_THK,
       a.COIL_WTH,
       a.ORD_NO,
       a.ORD_SEQ,
       a.act_wgt,
       a.cur_load_loc,
       c.CUST_NM,
       decode(a.tot_dec_grd,'1','合格','2','不合格','3','外观原因','4','废品') tot_dec_grd,
       decode(a.prodnm_cd,'AR','热轧卷','CR','控轧','TMCP','TMCP','NT','NT') prodnm_cd,
       a.rem,
       B.REG_DTIME  
       from tbh02_coil_comm a,tbh05_coil_yard b,tbz00_customer c   
       where a.old_sampl_no = b.coil_no 
       and a.ORDCUST_CD = c.CUST_CD
	   and a.COIL_STAT = '2' 
       and b.reg_dtime like :1||'%'
       and a.OLD_SAMPL_NO like :2||'%'
       and a.SPEC_STL_GRD like :3||'%'
       and a.COIL_WTH like :4||'%'
       and a.COIL_THK like :5||'%'
       and a.CUR_LOAD_LOC like :6||'%'
     order by b.coil_no  desc  
		]]>
	</query>
	<query id="UIH090040_02.select" desc=" 判断是否判定完成，判定完成的不允许改变钢卷重量 " fetchSize="10">
		<![CDATA[
			SELECT A.CUR_PROG_CD,A.COIL_STAT,A.CUR_LOAD_LOC FROM TBH02_COIL_COMM A  
				WHERE A.OLD_SAMPL_NO = ? 
		]]>
	</query>
	<query id="UIH090040_03.select" desc=" 统计查询出来的钢卷个数和重量 " fetchSize="10">
		<![CDATA[
			select count(*) COIL_CNT,
				   nvl(sum(a.act_wgt)/1000,0) COIL_WGT 
				   from tbh02_coil_comm a,tbh05_coil_yard b
				   where a.old_sampl_no = b.coil_no 
			       and a.COIL_STAT = '2' 
				   and b.reg_dtime like :1||'%'
				   and a.OLD_SAMPL_NO like :2||'%'
				   and a.SPEC_STL_GRD like :3||'%'
				   and a.COIL_WTH like :4||'%'
				   and a.COIL_THK like :5||'%'
				   and a.CUR_LOAD_LOC like :6||'%'
		]]>
	</query>
	<query id="UIH090040_01.update" desc="入库钢卷更新卷重">
        <![CDATA[
			        update tbh02_coil_comm set
			  ACT_WGT = ?,
              REG_ID  = ?,
              REG_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
                    where OLD_SAMPL_NO = ? 
		]]>
    </query>
</queryMap>