wudonglin
/
XinYu_RZMES


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566
							<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH040060_01.select" desc="查询现有轧辊现况 带两个参数" fetchSize="10">
		<![CDATA[
			select ROLL_NO,
              decode(ROLL_STAT,NVL('I',''),'新辊入库',NVL('G',''),'磨削完成',NVL('S',''),'磨削待机',NVL('W',''),'装配完成',NVL('U',''),'使用中',NVL('D',''),'废弃') ROLL_STAT,
              STAND_NO,
              ROLL_TYPE,
              ROLL_MAT_QLTY,
              ROLL_UCOST,
              ENT_DIA,
              ROLL_SHAPE_CD,
              DISUSE_DIA,
              CUR_DIA,
              ROLL_MAKER,
              ENT_DTIME,
              GRIND_DTIME,
              GRIND_STEPNO,
              decode(TOP_BOT_CLF,NVL('T',''),'上部轧辊',NVL('B',''),'下部轧辊') TOP_BOT_CLF,
              GRIND_USE_DTIME
                from tbh04_roll where ROLL_TYPE = ? and ROLL_STAT = ?
		]]>
	</query>
	<query id="UIH040060_02.select" desc="查询现有轧辊现况 带一个参数" fetchSize="10">
		<![CDATA[
			select ROLL_NO,
			        decode(ROLL_STAT,NVL('I',''),'新辊入库',NVL('G',''),'磨削完成',NVL('S',''),'磨削待机',NVL('W',''),'装配完成',NVL('U',''),'使用中',NVL('D',''),'废弃') ROLL_STAT,
			        STAND_NO,
			        ROLL_TYPE,
			        ROLL_MAT_QLTY,
			        ROLL_UCOST,
			        ENT_DIA,
			        ROLL_SHAPE_CD,
			        DISUSE_DIA,
			        CUR_DIA,
			        ROLL_MAKER,
			        ENT_DTIME,
			        GRIND_DTIME,
			        GRIND_STEPNO,
					decode(TOP_BOT_CLF,NVL('T',''),'上部轧辊',NVL('B',''),'下部轧辊') TOP_BOT_CLF,
					GRIND_USE_DTIME   
			         from tbh04_roll where ROLL_TYPE = ? 
		]]>
	</query>
	<query id="UIH040060_03.select" desc="查询现有轧辊现况 不带参数" fetchSize="10">
		<![CDATA[
			select ROLL_NO,
			        decode(ROLL_STAT,NVL('I',''),'新辊入库',NVL('G',''),'磨削完成',NVL('S',''),'磨削待机',NVL('W',''),'装配完成',NVL('U',''),'使用中',NVL('D',''),'废弃') ROLL_STAT,
			        STAND_NO,
			        ROLL_TYPE,
			        ROLL_MAT_QLTY,
			        ROLL_UCOST,
			        ENT_DIA,
			        ROLL_SHAPE_CD,
			        DISUSE_DIA,
			        CUR_DIA,
			        ROLL_MAKER,
			        ENT_DTIME,
			        GRIND_DTIME,
			        GRIND_STEPNO,
					decode(TOP_BOT_CLF,NVL('T',''),'上部轧辊',NVL('B',''),'下部轧辊') TOP_BOT_CLF,
				    GRIND_USE_DTIME   
			         from tbh04_roll 
		]]>
	</query>
</queryMap>