XinYu_RZMES/.svn/pristine/f2/f27bfbfd19c60434feaf7f15c32a9a0b47d067d5.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="出钢参数接收现况分析(中厚板)">
	<query id="UIF012010.findByK" desc="求各炉次所接受的中厚板板坯参数" fetchSize="10">
        <![CDATA[
/*******************************根据块数求各炉次所接受的中厚板板坯参数***********************************/

   SELECT   CASE WHEN SLAB_THK IS NULL     THEN '合计'   
                 WHEN SLAB_THK IS NOT NULL THEN TO_CHAR(SLAB_THK)                        END  SLAB_THK            
        ,SUM(NVL(SLAB_CNT1450,''))                                                            SLAB_CNT1450
        ,SUM(NVL(SLAB_CNT1500,''))                                                            SLAB_CNT1500
        ,SUM(NVL(SLAB_CNT1550,''))                                                            SLAB_CNT1550
        ,SUM(NVL(SLAB_CNT1600,''))                                                            SLAB_CNT1600
        ,SUM(NVL(SLAB_CNT1650,''))                                                            SLAB_CNT1650
		,SUM(NVL(SLAB_CNT2400,''))                                                            SLAB_CNT2400
        ,( SUM(NVL(SLAB_CNT1450,0)) +
           SUM(NVL(SLAB_CNT1500,0)) + 
           SUM(NVL(SLAB_CNT1550,0)) + 
           SUM(NVL(SLAB_CNT1600,0)) + 
           SUM(NVL(SLAB_CNT1650,0)) + 
           SUM(NVL(SLAB_CNT2400,0)) )                                                          SUM_CNT
         
   FROM (SELECT  T1.SLAB_THK
                ,CASE WHEN 0   <=  T1.SLAB_WTH AND T1.SLAB_WTH <= 1450 THEN 1              END   SLAB_CNT1450
                ,CASE WHEN 1450 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1500 THEN 1              END   SLAB_CNT1500
                ,CASE WHEN 1500 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1550 THEN 1              END   SLAB_CNT1550
                ,CASE WHEN 1550 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1600 THEN 1              END   SLAB_CNT1600
                ,CASE WHEN 1600 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1650 THEN 1              END   SLAB_CNT1650 
			    ,CASE WHEN 1650 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 2400 THEN 1              END   SLAB_CNT2400    
          FROM   TBF01_SPEC_SLAB T1, TBF01_SPEC_CHARGE T2 
          WHERE  T1.CHARGE_EDT_SEQ   =      T2.CHARGE_EDT_SEQ    
            AND  T1.SLAB_RT          IN     ('P','Z')
            AND  T2.STATUS_CD        =      'A' 
            AND  T2.PROG_CD          IN     ('JBA','JBB')
            AND  T2.STL_GRD          LIKE   ? || '%' 
            AND  T2.PROG_CD          LIKE   ? || '%'
            AND  T1.SLAB_RT          LIKE   ? || '%'
  )          
  GROUP  BY  ROLLUP(SLAB_THK) 
			
			
/*******************************根据块数求各炉次所接受的中厚板板坯参数***********************************/
        ]]>
    </query> 
	
	<query id="UIF012010.findSlabinfo" desc="求各炉次所接受的中厚板板坯参数" fetchSize="10">
        <![CDATA[
/*******************************根据块数求各炉次所接受的中厚板板坯参数***********************************/

SELECT  C.SLAB_MANA_NO,
        C.STL_GRD,
        C.SLAB_THK,
        D.SLAB_WTH,
        C.SLAB_LEN,
        C.SLAB_WGT,
        T1.SM_CFNM PROG_CD,
        T2.SM_CFNM SLAB_RT,
        C.DSN_SLAB_NO,
        B.L2_SEND
  FROM  TBF01_SPEC_CHARGE A,
        TBF01_CHARGE_IDX  B,
        TBF01_SPEC_SLAB   C,
        (SELECT   SLAB_EDT_SEQ,
              CASE WHEN 0    <= SLAB_WTH AND SLAB_WTH <= 1450 THEN   '1450'
                   WHEN 1450 <  SLAB_WTH AND SLAB_WTH <= 1500 THEN   '1500'
                   WHEN 1500 <  SLAB_WTH AND SLAB_WTH <= 1550 THEN   '1550'
                   WHEN 1550 <  SLAB_WTH AND SLAB_WTH <= 1600 THEN   '1600'
                   WHEN 1600 <  SLAB_WTH AND SLAB_WTH <= 1650 THEN   '1650'
			       WHEN 1650 <  SLAB_WTH AND SLAB_WTH <= 2400 THEN   '2400'
                   WHEN 0 <  SLAB_WTH AND SLAB_WTH <= 2400 THEN      ''
                   WHEN SLAB_WTH IS NOT NULL THEN TO_CHAR(SLAB_WTH)       END    SLAB_WTH 
        FROM TBF01_SPEC_SLAB ) D,
        (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T  WHERE T.LG_CD =  'E01002') T1,
		(SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T  WHERE T.LG_CD =  'B01004') T2
 WHERE  A.CHARGE_EDT_SEQ  =     B.CHARGE_EDT_SEQ
   AND  A.CHARGE_EDT_SEQ  =     C.CHARGE_EDT_SEQ
   AND  C.SLAB_EDT_SEQ    =     D.SLAB_EDT_SEQ
   AND  T1.SM_CD          =     A.PROG_CD
   AND  T2.SM_CD          =     C.SLAB_RT
   AND  C.SLAB_WTH        BETWEEN 0 AND 2400
   AND  C.SLAB_RT         IN    ('Z','P')
   AND  A.STATUS_CD       =     'A'
   AND  A.PROG_CD          IN     ('JBA','JBB')
   AND  A.STL_GRD          LIKE   ? || '%' 
   AND  A.PROG_CD          LIKE   ? || '%'
   AND  C.SLAB_RT          LIKE   ? || '%'
   AND  D.SLAB_WTH        LIKE     ? || '%'
   AND  C.SLAB_THK        LIKE     ? || '%'
ORDER BY C.SLAB_MANA_NO
			
			
/*******************************根据块数求各炉次所接受的中厚板板坯参数***********************************/
        ]]>
    </query> 	
	
   <query id="UIF012010.findByW" desc="根据重量求各炉次所接受的中厚板板坯参数" fetchSize="10">
        <![CDATA[
/*******************************根据重量求各炉次所接受的中厚板板坯参数***********************************/

SELECT   CASE WHEN SLAB_THK IS NULL     THEN '合计'   
              WHEN SLAB_THK IS NOT NULL THEN TO_CHAR(SLAB_THK)                        END    SLAB_THK            
        ,SUM(NVL(SLAB_CNT1450,''))                                                            SLAB_CNT1450
        ,SUM(NVL(SLAB_CNT1500,''))                                                            SLAB_CNT1500
        ,SUM(NVL(SLAB_CNT1550,''))                                                            SLAB_CNT1550
        ,SUM(NVL(SLAB_CNT1600,''))                                                            SLAB_CNT1600
        ,SUM(NVL(SLAB_CNT1650,''))                                                            SLAB_CNT1650
		,SUM(NVL(SLAB_CNT2400,''))                                                            SLAB_CNT2400
        ,( SUM(NVL(SLAB_CNT1450,0)) +
           SUM(NVL(SLAB_CNT1500,0)) + 
           SUM(NVL(SLAB_CNT1550,0)) + 
           SUM(NVL(SLAB_CNT1600,0)) + 
           SUM(NVL(SLAB_CNT1650,0)) + 
           SUM(NVL(SLAB_CNT2400,0)) )                                                          SUM_CNT
         
   FROM (SELECT  T1.SLAB_THK
                ,CASE WHEN 0    <=  T1.SLAB_WTH AND T1.SLAB_WTH  <= 1450  THEN T1.SLAB_WGT            END   SLAB_CNT1450
                ,CASE WHEN 1450 <   T1.SLAB_WTH AND T1.SLAB_WTH  <= 1500  THEN T1.SLAB_WGT            END   SLAB_CNT1500
                ,CASE WHEN 1500 <   T1.SLAB_WTH AND T1.SLAB_WTH  <= 1550  THEN T1.SLAB_WGT            END   SLAB_CNT1550
                ,CASE WHEN 1550 <   T1.SLAB_WTH AND T1.SLAB_WTH  <= 1600  THEN T1.SLAB_WGT            END   SLAB_CNT1600
                ,CASE WHEN 1600 <   T1.SLAB_WTH AND T1.SLAB_WTH  <= 1650  THEN T1.SLAB_WGT            END   SLAB_CNT1650  
			    ,CASE WHEN 1650 <   T1.SLAB_WTH AND T1.SLAB_WTH  <= 2400  THEN T1.SLAB_WGT            END   SLAB_CNT2400                
           FROM  TBF01_SPEC_SLAB T1, TBF01_SPEC_CHARGE T2 
          WHERE  T1.CHARGE_EDT_SEQ   =      T2.CHARGE_EDT_SEQ    
            AND  T1.SLAB_RT          IN     ('P','Z')
            AND  T2.STATUS_CD        =      'A' 
            AND  T2.PROG_CD          IN     ('JBA','JBB')
            AND  T2.STL_GRD          LIKE   ? || '%' 
            AND  T2.PROG_CD          LIKE   ? || '%'
            AND  T1.SLAB_RT          LIKE   ? || '%'
  )          
  GROUP  BY  ROLLUP(SLAB_THK) 
			
			
/*******************************根据重量求各炉次所接受的中厚板板坯参数***********************************/
        ]]>
    </query> 
</queryMap>