XinYu_RZMES/.svn/pristine/32/32c51b58cdb3af37032375bc2b47dcc21c5dfc2b.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH020060_01.select" desc="" fetchSize="10">
		<![CDATA[
			select COIL_NO,COIL_OUTDIA,COIL_INDIA,ACT_WGT,ORD_NO,SCRAP_CAUSE_CD,SCRAP_TREATE_DTIME,SCRAP_WGT
            from TBH02_COIL_COMM where SCRAP_TREATE_DTIME like to_number(to_char(sysdate,'yyyy'))||'%' order by SCRAP_TREATE_DTIME
		]]>
	</query>
	<query id="UIH020060_02.select" desc="COIL废弃处理原因查询" fetchSize="10">
		<![CDATA[
			select SM_CD||' '||SM_CFNM LABEL,SM_CFNM VALUE from TBZ00_COMMCD where lg_cd = 'H02002'
		]]>
	</query>
	<query id="UIH020060_03.select" desc="" fetchSize="10">
		<![CDATA[
			select count(coil_no) sumCoilNo,sum(SCRAP_WGT) sumScrapWgt from tbh02_coil_comm 
		]]>
	</query>
	<query id="UIH020060_04.select" desc="通过批次号统计所有废钢块数和废钢量" fetchSize="10">
		<![CDATA[
			select count(OLD_SAMPL_NO) sumCoilNo,sum(SCRAP_WGT) sumScrapWgt from tbh02_coil_comm where SCRAP_TREATE_DTIME like to_number(to_char(sysdate,'yyyy'))||'%'  
		]]>
	</query>
	<query id="UIH020060_05.select" desc="查询批次号 (限制在本年度内的)" fetchSize="10">
		<![CDATA[
			select COIL_NO COIL_NO_L,OLD_SAMPL_NO COIL_NO,COIL_OUTDIA,COIL_INDIA,ACT_WGT,ORD_NO,SCRAP_CAUSE_CD,SCRAP_TREATE_DTIME,SCRAP_WGT
            from TBH02_COIL_COMM where SCRAP_TREATE_DTIME like to_number(to_char(sysdate,'yyyy'))||'%' order by SCRAP_TREATE_DTIME 
		]]>
	</query>
    <query id="UIH020060_01.update" desc="更新" fetchSize="10">
		<![CDATA[
		    update TBH02_COIL_COMM
			set
			SCRAP_WGT =?,
			SCRAP_CAUSE_CD =?,
			SCRAP_TREATE_DTIME =?,
			SCRAP_WKSHIFT =?,
			SCRAP_WKGROUP =?,
			SCRAP_EMP_NO =?,
			COIL_STAT = '3'
			where OLD_SAMPL_NO =?
		]]>
	</query>	
</queryMap>