XinYu_RZMES/.svn/pristine/17/17ca231d8fd927f419fefb07dac96fd85213b229.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH040050_01.select" desc="获取所有RollNo信息" fetchSize="10">
		<![CDATA[
		   select roll_no label,roll_no value from tbh04_roll where roll_stat <> 'D'
		]]>
	</query>
	<query id="UIH040050_02.select" desc="获取特定的RollNo信息" fetchSize="10">
		<![CDATA[
		   select roll_type,
				   ENT_DIA,
			       DISUSE_DIA,
			       CUR_DIA,
			       decode(ROLL_STAT,NVL('I',''),'新辊入库',NVL('G',''),'磨削完成',NVL('S',''),'磨削待机',NVL('W',''),'装配完成',NVL('U',''),'使用中',NVL('D',''),'废弃') ROLL_STAT,
			       CHANG_DTIME,
			       GRIND_DTIME,
			       GRIND_STEPNO,
			       ENT_DTIME 
			         from tbh04_roll where ROLL_NO = ?
		]]>
	</query>
	<query id="UIH040050_03.select" desc="获取所有废弃的RollNo信息" fetchSize="10">
		<![CDATA[
		   select ROLL_TYPE,
				   ROLL_NO,
			       ENT_DIA,
			       DISUSE_DIA,
			       ROLL_UCOST,
			       ROLL_MAT_QLTY,
			       ROLL_MAKER,
			       ROLL_DISUSE_DTIME,
			       ROLL_DISUSE_CAUSE_CD,
			       ROLL_DISUSE_EMP_ID  
			        from tbh04_roll where roll_stat = 'D' 
			        order by ROLL_DISUSE_DTIME desc
		]]>
	</query>
	<query id="UIH040050_04.select" desc="获取所有的废弃原因" fetchSize="10">
		<![CDATA[
		   select SM_CD||LG_NM LABEL,LG_NM VALUE from tbz00_commcd where lg_cd = 'H04001' 
		]]>
	</query>
	<query id="UIH040050_01.update" desc="更新废弃的轧辊信息" >
		<![CDATA[
			update tbh04_roll set 
				roll_disuse_cause_cd =?,
				roll_disuse_dtime =?,
				roll_disuse_emp_id =?,
				roll_stat ='D'
					
			where roll_no=?
		]]>
	</query>
	<query id="UIH040050_02.update" desc="废弃回退处理，拉到磨削待机" >
		<![CDATA[
			update tbh04_roll set 
				roll_disuse_cause_cd ='',
				roll_disuse_dtime ='',
				roll_disuse_emp_id ='',
				roll_stat ='S'
					
			where roll_no=?
		]]>
	</query>
</queryMap>