XinYu_RZMES/.svn/pristine/7b/7b6b5048aa42646982c411ebc2c67320dc9398c9.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING PROGRESS MONITORING  ">
	<query id="UIG04COMBOX_STLGRD.select" desc="求所有的牌号" fetchSize="10">
        <![CDATA[
 /************************desc：得到所有的牌号代码和牌号名称的combo组*****************************************/	     			
	
     SELECT '' FAC_STL_GRD ,'' FAC_CODE,  '1' SEQ FROM dual
     UNION ALL 
     SELECT DISTINCT T.FAC_STL_GRD, 
                      T.FAC_STL_GRD AS FAC_CODE ,'2' SEQ
        FROM TBB01_FAC_INGR T
ORDER BY SEQ,FAC_STL_GRD ASC
			
/************************desc：得到所有的牌号代码和牌号名称的combo组*****************************************/	     
        ]]>
    </query> 
    <query id="UIG04COMBOX_CHARGE_NO.select" desc="求所有的牌号" fetchSize="10">
        <![CDATA[
 /************************desc：得到所有炼钢未综合判定的炉次号*****************************************/	     			
		SELECT '--全部--' LABEL , '' VALUE , 0 SEQ  FROM DUAL
	    UNION ALL
	    SELECT LABEL,VALUE,SEQ FROM (
	       SELECT CHARGE_NO LABEL,CHARGE_NO VALUE,ROW_NUMBER() OVER( ORDER BY CHARGE_NO asc)  SEQ
	    FROM 
	    (
	           SELECT DISTINCT SUBSTR(T.SLAB_NO,1,10) CHARGE_NO 
	           FROM TBG02_SLAB_COMM T WHERE T.SLAB_TOT_DEC_GRD IS NULL
	           
	    )
	    ) WHERE SEQ <= 20
			
/************************desc：得到所有炼钢未综合判定的炉次号*****************************************/	     
        ]]>
    </query>
</queryMap>