XinYu_RZMES/.svn/pristine/10/10ee723700d6058055c79a53a2184de58c485315.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="Prograss Planning Project D">

	<query id="DCommCode.Normal.Select" desc="工程.公用代码.Normal-查询" fetchSize="10">
        <![CDATA[
			SELECT '%'         AS SM_CD
			     , '-- ALL --' AS SM_CFNM
			     , 0           AS CD_SEQ
			FROM DUAL
			WHERE 'A' = :1
			UNION ALL
			SELECT FAC_STL_GRP, FAC_STL_GRPNM
			     , ROW_NUMBER() OVER (ORDER BY FAC_STL_GRP)
			FROM TBD00_STLGRD_GRP
			WHERE --FAC_STL_GRP = :2
			USE_YN = 'Y'
			
        ]]>
    </query>
                                                
    <query id="DCommCode.FacStlGrd.Select_unused" desc="工程.厂内牌号.FacStlGrd-查询" fetchSize="10">
        <![CDATA[
            SELECT '%'         AS FAC_STL_GRD
                 , '-- ALL --' AS FAC_STL_GRD_NM
                 , 0           AS CD_SEQ
            FROM DUAL
            WHERE 'A' = :1
            UNION ALL
            SELECT FAC_STL_GRD AS FAC_STL_GRD
                 , FAC_STL_GRD AS FAC_STL_GRD_NM
                 , ROW_NUMBER() OVER (ORDER BY FAC_STL_GRD) AS CD_SEQ
            FROM TBD00_STLGRD
            WHERE FAC_STL_GRD LIKE :2||'%'  
        ]]>
    </query>
	
	 <query id="DCommCode.FacStlGrd.Select" desc="工程.厂内牌号.FacStlGrd-查询" fetchSize="10">
        <![CDATA[
			SELECT '%'         AS FAC_STL_GRD
                 , '-- ALL --' AS FAC_STL_GRD_NM
                 --, 0           AS CD_SEQ
            FROM DUAL
            WHERE 'A' = :1
            UNION ALL
            SELECT DISTINCT D.FAC_STL_GRD AS FAC_STL_GRD
                 , D.FAC_STL_GRD AS FAC_STL_GRD_NM
                 --, ROW_NUMBER() OVER (ORDER BY D.FAC_STL_GRD) AS CD_SEQ
            FROM TBD00_STLGRD D,TBD01_SLABDN_RST R
            WHERE D.FAC_STL_GRD = R.FAC_STL_GRD
			
           --6月10修改注释			
	       --SELECT '%'         AS FAC_STL_GRD
           --      , '-- ALL --' AS FAC_STL_GRD_NM
           -- FROM DUAL
           -- WHERE 'A' = :1
           -- UNION ALL
           -- SELECT DISTINCT D.FAC_STL_GRD AS FAC_STL_GRD
           --      , D.FAC_STL_GRD AS FAC_STL_GRD_NM
           -- FROM TBD00_STLGRD D
        ]]>
    </query>
	
	 <query id="DCommCode.FacStlGrd.Select.jinji" desc="工程.厂内牌号.FacStlGrd-查询_紧急才专用" fetchSize="10">
        <![CDATA[
SELECT  *  FROM 
			(
			SELECT '%'         AS FAC_STL_GRD
                 , '-- ALL --' AS FAC_STL_GRD_NM
                 --, 0           AS CD_SEQ
            FROM DUAL
            WHERE 'A' = :1
            UNION ALL
            SELECT DISTINCT D.FAC_STL_GRD AS FAC_STL_GRD
                 , D.FAC_STL_GRD AS FAC_STL_GRD_NM
                 --, ROW_NUMBER() OVER (ORDER BY D.FAC_STL_GRD) AS CD_SEQ
            FROM TBD00_STLGRD D,TBD01_SLABDN_RST R
            WHERE D.FAC_STL_GRD = R.FAC_STL_GRD(+)
			
           --6月10修改注释			
	       --SELECT '%'         AS FAC_STL_GRD
           --      , '-- ALL --' AS FAC_STL_GRD_NM
           -- FROM DUAL
           -- WHERE 'A' = :1
           -- UNION ALL
           -- SELECT DISTINCT D.FAC_STL_GRD AS FAC_STL_GRD
           --      , D.FAC_STL_GRD AS FAC_STL_GRD_NM
           -- FROM TBD00_STLGRD D
)  ORDER  BY      FAC_STL_GRD      
        ]]>
    </query>
	
	<query id="DCommCode.FacStlGrd.Select2" desc="工程.厂内牌号.FacStlGrd-查询" fetchSize="10">
        <![CDATA[
	       SELECT '%'         AS FAC_STL_GRD
                 , '-- ALL --' AS FAC_STL_GRD_NM
                 --, 0           AS CD_SEQ
            FROM DUAL
            WHERE 'A' = :1
            UNION ALL
            SELECT DISTINCT D.FAC_STL_GRD AS FAC_STL_GRD
                 , D.FAC_STL_GRD AS FAC_STL_GRD_NM
                 --, ROW_NUMBER() OVER (ORDER BY D.FAC_STL_GRD) AS CD_SEQ
            FROM TBD00_STLGRD D,TBD01_SLABDN_RST2 R
            WHERE D.FAC_STL_GRD LIKE :2||'%'
            AND D.FAC_STL_GRD = R.FAC_STL_GRD
        ]]>
    </query>
                                                
    <query id="DCommCode.FacStlGrp.Select" desc="工程.厂内牌号.FacStlGrp-查询" fetchSize="10">
        <![CDATA[
            SELECT '%'         AS FAC_STL_GRP
                 , '-- ALL --' AS FAC_STL_GRP_NM
                 , 0           AS CD_SEQ
            FROM DUAL
            WHERE 'A' = :1
            UNION ALL
            SELECT FAC_STL_GRP
                 , FAC_STL_GRPNM
                 , ROW_NUMBER() OVER (ORDER BY FAC_STL_GRP) AS CD_SEQ
            FROM TBD00_STLGRD_GRP
            --WHERE FAC_STL_GRP LIKE :2||'%'  
        ]]>
    </query>

	<query id="DCommCode.SlabDnWidth.Select" desc="板坯宽度" fetchSize="10">
        <![CDATA[
            SELECT 1         AS SLAB_WTH
                 , '-- ALL --' AS SLAB_WTH_NM
                 , 0           AS CD_SEQ
            FROM DUAL
            WHERE 'A' = :1
            UNION ALL
			SELECT X.SLAB_WTH
				 , LPAD(TO_CHAR(X.SLAB_WTH,'FM99,990'),6,' ')||' ('||LPAD(TO_CHAR(X.WGT,'FM99,999,990'),10,' ')||'t)'
				 , X.RN
			FROM (SELECT SLAB_WTH
					   , COUNT(*) AS CNT
					   , SUM(SLAB_WGT) AS WGT
					   , ROW_NUMBER() OVER (ORDER BY SLAB_WTH) AS RN
				  FROM TBD01_SLABDN_RST
				  GROUP BY SLAB_WTH) X
        ]]>
    </query>
	
	<query id="DCommCode.SlabDnWidth2.Select" desc="板坯宽度" fetchSize="10">
        <![CDATA[
            SELECT 1         AS SLAB_WTH
                 , '-- ALL --' AS SLAB_WTH_NM
                 , 0           AS CD_SEQ
            FROM DUAL
            WHERE 'A' = :1
            UNION ALL
			SELECT X.SLAB_WTH
				 , LPAD(TO_CHAR(X.SLAB_WTH,'FM99,990'),6,' ')||' ('||LPAD(TO_CHAR(X.WGT,'FM99,999,990'),10,' ')||'t)'
				 , X.RN
			FROM (SELECT SLAB_WTH
					   , COUNT(*) AS CNT
					   , SUM(SLAB_WGT) AS WGT
					   , ROW_NUMBER() OVER (ORDER BY SLAB_WTH) AS RN
				  FROM TBD01_SLABDN_RST2
				  GROUP BY SLAB_WTH) X
        ]]>
    </query>
	
	<query id="DCommCode.NumMinMaxByBizTp.Select" desc="钢卷厚度" fetchSize="10">
        <![CDATA[
            SELECT 'ALL'       AS MATDN_STD_NM
                 , '-- ALL --' AS MATDN_STD_RANGE
                 , 0           AS NUM_MIN
			     , 99          AS NUM_MAX
			     , 0           AS CD_SEQ
            FROM DUAL
            WHERE 'A' = :1
			UNION ALL
            SELECT MATDN_STD_NM
                 , LPAD(TO_CHAR(NUM_MIN,'FM990.0'),4,' ')||' - '||LPAD(TO_CHAR(NUM_MAX,'FM990.0'),4,' ')
                 , NUM_MIN
			     , NUM_MAX
			     , CD_SEQ
            FROM TBD00_MATDN_STD
			WHERE BIZ_TP = :2     -- 'CoilThickGroup'
			AND USE_YN = 'Y'
			ORDER BY CD_SEQ
        ]]>
    </query>
</queryMap>