XinYu_RZMES/.svn/pristine/c3/c3aea85f752cb94ad2bca6d40849943e643136a2.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="公司钢材(坯)非计划品率统计报表">

	<query id="UIG100000.SELECT" desc="查询报表" >
        <![CDATA[
	   SELECT      T.*
	   FROM        RPTTMP_FJH3_TURNOFFQUALITY@XGCX     T  
	   WHERE       SUBSTR(T.CREATIME , 1,8)      =   NVL(?,TO_CHAR(SYSDATE , 'YYYYMMDD'))
	   UNION
	   SELECT      S.*   
	   FROM        RPTTMP_FJH3_TMP@XGCX     S 
	   WHERE       SUBSTR(S.CREATIME , 1,8)      =   NVL(?,TO_CHAR(SYSDATE , 'YYYYMMDD'))
	     
         ]]>
    </query>
    
    <query id="UIG100000.DELETE" desc="清空临时表 ">
    <![CDATA[
    	DELETE FROM RPTTMP_FJH3_TMP@XGCX  COMMIT
    ]]>
    </query>
    
    <query id="UIG100000_01.INSERT" desc="插入项目名称的大标题">
    <![CDATA[
    	INSERT INTO RPTTMP_FJH3_TMP@XGCX (XMMC,CREATIME,KHZB,ZX_DR,MX_DR,ZX_ZL,MX_ZL,ZX_YL,MX_YL,ZX_NL,MX_NL)
    	SELECT '1 中板线综合非计划品率' AS XMMC, ? AS CREATIME,6.99 AS KHZB,SUM(ZX_DR),SUM(MX_DR),SUM(ZX_ZL),SUM(MX_ZL),
    	SUM(ZX_YL),SUM(MX_YL),SUM(ZX_NL),SUM(MX_NL)  
    	FROM  RPTTMP_FJH3_TURNOFFQUALITY@XGCX  T  
    	WHERE  SUBSTR(T.CREATIME , 1,8)      =   NVL(?,TO_CHAR(SYSDATE , 'YYYYMMDD'))
    	AND T.XMMC LIKE '1%'
        ]]>
    </query>  
    
    <query id="UIG100000_01.INSERT1" desc="插入项目名称的大标题">
    <![CDATA[
   		INSERT INTO RPTTMP_FJH3_TMP@XGCX (XMMC,CREATIME,KHZB,ZX_DR,MX_DR,ZX_ZL,MX_ZL,ZX_YL,MX_YL,ZX_NL,MX_NL)
    	SELECT '2 厚板线综合非计划品率' AS XMMC, ? AS CREATIME,8.35 AS KHZB,SUM(ZX_DR),SUM(MX_DR),SUM(ZX_ZL),SUM(MX_ZL),
    	SUM(ZX_YL),SUM(MX_YL),SUM(ZX_NL),SUM(MX_NL)  
    	FROM  RPTTMP_FJH3_TURNOFFQUALITY@XGCX  T  
    	WHERE  SUBSTR(T.CREATIME , 1,8)      =   NVL(?,TO_CHAR(SYSDATE , 'YYYYMMDD'))
    	AND T.XMMC LIKE '2%'
    	]]>
    </query>
    
    <query id="UIG100000_01.INSERT2" desc="插入项目名称的大标题">
    <![CDATA[
     	INSERT INTO RPTTMP_FJH3_TMP@XGCX (XMMC,CREATIME,KHZB,ZX_DR,MX_DR,ZX_ZL,MX_ZL,ZX_YL,MX_YL,ZX_NL,MX_NL)
    	SELECT '3 热连轧线综合非计品率（含进酸轧量）' AS XMMC, ? AS CREATIME,4.09 AS KHZB,SUM(ZX_DR),SUM(MX_DR),SUM(ZX_ZL),
    	SUM(MX_ZL),SUM(ZX_YL),SUM(MX_YL),SUM(ZX_NL),SUM(MX_NL)  
    	FROM  RPTTMP_FJH3_TURNOFFQUALITY@XGCX  T  
    	WHERE  SUBSTR(T.CREATIME , 1,8)      =   NVL(?,TO_CHAR(SYSDATE , 'YYYYMMDD'))
    	AND T.XMMC LIKE '3%'
    	]]>
    </query>
    
    <query id="UIG100000_01.INSERT3" desc="插入项目名称的大标题">
    <![CDATA[
     	INSERT INTO RPTTMP_FJH3_TMP@XGCX (XMMC,CREATIME,KHZB,ZX_DR,MX_DR,ZX_ZL,MX_ZL,ZX_YL,MX_YL,ZX_NL,MX_NL)
    	SELECT '4 热轧卷非计品率（不含进酸轧量）' AS XMMC, ? AS CREATIME,'-' AS KHZB,SUM(ZX_DR),SUM(MX_DR),SUM(ZX_ZL),
    	SUM(MX_ZL),SUM(ZX_YL),SUM(MX_YL),SUM(ZX_NL),SUM(MX_NL)  
    	FROM  RPTTMP_FJH3_TURNOFFQUALITY@XGCX  T  
    	WHERE  SUBSTR(T.CREATIME , 1,8)      =   NVL(?,TO_CHAR(SYSDATE , 'YYYYMMDD'))
    	AND T.XMMC LIKE '4%'
    	]]>
    </query>
    
    <query id="UIG100000_01.INSERT4" desc="插入项目名称的大标题">
    <![CDATA[
     	INSERT INTO RPTTMP_FJH3_TMP@XGCX (XMMC,CREATIME,KHZB,ZX_DR,MX_DR,ZX_ZL,MX_ZL,ZX_YL,MX_YL,ZX_NL,MX_NL)
    	SELECT '5 酸轧卷非计划品率（不含进连退量）' AS XMMC, ? AS CREATIME,0.87 AS KHZB,SUM(ZX_DR),SUM(MX_DR),SUM(ZX_ZL),
    	SUM(MX_ZL),SUM(ZX_YL),SUM(MX_YL),SUM(ZX_NL),SUM(MX_NL)  
    	FROM  RPTTMP_FJH3_TURNOFFQUALITY@XGCX  T  
    	WHERE  SUBSTR(T.CREATIME , 1,8)      =   NVL(?,TO_CHAR(SYSDATE , 'YYYYMMDD'))
    	AND T.XMMC LIKE '5%'
    	]]>
    </query>
    
    <query id="UIG100000_01.INSERT5" desc="插入项目名称的大标题">
    <![CDATA[
     	INSERT INTO RPTTMP_FJH3_TMP@XGCX (XMMC,CREATIME,KHZB,ZX_DR,MX_DR,ZX_ZL,MX_ZL,ZX_YL,MX_YL,ZX_NL,MX_NL)
    	SELECT '6 连退卷非计划品率' AS XMMC, ? AS CREATIME,6.84 AS KHZB,SUM(ZX_DR),SUM(MX_DR),SUM(ZX_ZL),
    	SUM(MX_ZL),SUM(ZX_YL),SUM(MX_YL),SUM(ZX_NL),SUM(MX_NL)  
    	FROM  RPTTMP_FJH3_TURNOFFQUALITY@XGCX  T  
    	WHERE  SUBSTR(T.CREATIME , 1,8)      =   NVL(?,TO_CHAR(SYSDATE , 'YYYYMMDD'))
    	AND T.XMMC LIKE '6%'
    	]]>
    </query>
    
    <query id="UIG100000_01.INSERT6" desc="插入项目名称的大标题">
     <![CDATA[
     	INSERT INTO RPTTMP_FJH3_TMP@XGCX (XMMC,CREATIME,KHZB,ZX_DR,MX_DR,ZX_ZL,MX_ZL,ZX_YL,MX_YL,ZX_NL,MX_NL)
    	SELECT '7 一钢炼钢综合非计划品率(不含方坯)' AS XMMC, ? AS CREATIME,3.15 AS KHZB,SUM(ZX_DR),SUM(MX_DR),SUM(ZX_ZL),
    	SUM(MX_ZL),SUM(ZX_YL),SUM(MX_YL),SUM(ZX_NL),SUM(MX_NL)  
    	FROM  RPTTMP_FJH3_TURNOFFQUALITY@XGCX  T  
    	WHERE  SUBSTR(T.CREATIME , 1,8)      =   NVL(?,TO_CHAR(SYSDATE , 'YYYYMMDD'))
    	AND T.XMMC LIKE '7%'
    	]]>
    </query>
    
    <query id="UIG100000_01.INSERT7" desc="插入项目名称的大标题">
     <![CDATA[
     	INSERT INTO RPTTMP_FJH3_TMP@XGCX (XMMC,CREATIME,KHZB,ZX_DR,MX_DR,ZX_ZL,MX_ZL,ZX_YL,MX_YL,ZX_NL,MX_NL)
    	SELECT '8 二钢炼钢综合非计划品率(不含方坯)' AS XMMC, ? AS CREATIME,2.8 AS KHZB,SUM(ZX_DR),SUM(MX_DR),SUM(ZX_ZL),
    	SUM(MX_ZL),SUM(ZX_YL),SUM(MX_YL),SUM(ZX_NL),SUM(MX_NL)  
    	FROM  RPTTMP_FJH3_TURNOFFQUALITY@XGCX  T  
    	WHERE  SUBSTR(T.CREATIME , 1,8)      =   NVL(?,TO_CHAR(SYSDATE , 'YYYYMMDD'))
    	AND T.XMMC LIKE '8%'
    	]]>
    </query>
    
    <query id="UIG100000_02.INSERT" desc="合并两小项">
    <![CDATA[
    	INSERT INTO RPTTMP_FJH3_TMP@XGCX (XMMC,CREATIME,KHZB,ZX_DR,MX_DR,ZX_ZL,MX_ZL,ZX_YL,MX_YL,ZX_NL,MX_NL)
    	SELECT '1.3 中板线钢板非计划品率' AS XMMC, ? AS CREATIME,SUM(KHZB),SUM(ZX_DR),SUM(MX_DR),SUM(ZX_ZL),
    	SUM(MX_ZL),SUM(ZX_YL),SUM(MX_YL),SUM(ZX_NL),SUM(MX_NL)  
    	FROM  RPTTMP_FJH3_TURNOFFQUALITY@XGCX  T  
    	WHERE  SUBSTR(T.CREATIME , 1,8)      =   NVL(?,TO_CHAR(SYSDATE , 'YYYYMMDD'))
    	AND (T.XMMC LIKE '1.3.1%' OR T.XMMC LIKE '1.3.2%') AND T.XMMC NOT LIKE '1.3.1.%' AND T.XMMC NOT LIKE '1.3.2.%'
    ]]>
    </query>
    
     <query id="UIG100000_02.INSERT1" desc="合并两小项">
    <![CDATA[
    	INSERT INTO RPTTMP_FJH3_TMP@XGCX (XMMC,CREATIME,KHZB,ZX_DR,MX_DR,ZX_ZL,MX_ZL,ZX_YL,MX_YL,ZX_NL,MX_NL)
    	SELECT '2.3 厚板线钢板非计划品率' AS XMMC, ? AS CREATIME,SUM(KHZB),SUM(ZX_DR),SUM(MX_DR),SUM(ZX_ZL),
    	SUM(MX_ZL),SUM(ZX_YL),SUM(MX_YL),SUM(ZX_NL),SUM(MX_NL)  
    	FROM  RPTTMP_FJH3_TURNOFFQUALITY@XGCX  T  
    	WHERE  SUBSTR(T.CREATIME , 1,8)      =   NVL(?,TO_CHAR(SYSDATE , 'YYYYMMDD'))
    	AND (T.XMMC LIKE '2.3.1%' OR T.XMMC LIKE '2.3.2%') AND T.XMMC NOT LIKE '2.3.1.%' AND T.XMMC NOT LIKE '2.3.2.%'
    ]]>
    </query>
    
     <query id="UIG100000_02.INSERT2" desc="合并两小项">
    <![CDATA[
        INSERT INTO RPTTMP_FJH3_TMP@XGCX (XMMC,CREATIME,KHZB,ZX_DR,MX_DR,ZX_ZL,MX_ZL,ZX_YL,MX_YL,ZX_NL,MX_NL)
    	SELECT '3.3.1 钢质' AS XMMC, ? AS CREATIME,'-',SUM(ZX_DR),SUM(MX_DR),SUM(ZX_ZL),
    	SUM(MX_ZL),SUM(ZX_YL),SUM(MX_YL),SUM(ZX_NL),SUM(MX_NL)  
    	FROM  RPTTMP_FJH3_TURNOFFQUALITY@XGCX  T  
    	WHERE  SUBSTR(T.CREATIME , 1,8)      =   NVL(?,TO_CHAR(SYSDATE , 'YYYYMMDD'))
    	AND T.XMMC LIKE '3.3.1.%'  
    	]]>
    </query>
    
    <query id="UIG100000_02.INSERT3" desc="合并两小项">
    <![CDATA[
    	INSERT INTO RPTTMP_FJH3_TMP@XGCX (XMMC,CREATIME,KHZB,ZX_DR,MX_DR,ZX_ZL,MX_ZL,ZX_YL,MX_YL,ZX_NL,MX_NL)
    	SELECT '3.3.2 热轧' AS XMMC, ? AS CREATIME,'-',SUM(ZX_DR),SUM(MX_DR),SUM(ZX_ZL),
    	SUM(MX_ZL),SUM(ZX_YL),SUM(MX_YL),SUM(ZX_NL),SUM(MX_NL)  
    	FROM  RPTTMP_FJH3_TURNOFFQUALITY@XGCX  T  
    	WHERE  SUBSTR(T.CREATIME , 1,8)      =   NVL(?,TO_CHAR(SYSDATE , 'YYYYMMDD'))
    	AND T.XMMC LIKE '3.3.2.%'  
    ]]>
    </query>
    
    <query id="UIG100000_02.INSERT4" desc="合并两小项">
    <![CDATA[
    	INSERT INTO RPTTMP_FJH3_TMP@XGCX (XMMC,CREATIME,KHZB,ZX_DR,MX_DR,ZX_ZL,MX_ZL,ZX_YL,MX_YL,ZX_NL,MX_NL)
    	SELECT '7.1 连铸坯超库存定额非计划品率' AS XMMC, ? AS CREATIME,'-',SUM(ZX_DR),SUM(MX_DR),SUM(ZX_ZL),
    	SUM(MX_ZL),SUM(ZX_YL),SUM(MX_YL),SUM(ZX_NL),SUM(MX_NL)  
    	FROM  RPTTMP_FJH3_TURNOFFQUALITY@XGCX  T  
    	WHERE  SUBSTR(T.CREATIME , 1,8)      =   NVL(?,TO_CHAR(SYSDATE , 'YYYYMMDD'))
    	AND T.XMMC LIKE '7.1.%'  
    ]]>
    </query>
    
    <query id="UIG100000_02.INSERT5" desc="合并两小项">
    <![CDATA[
    	INSERT INTO RPTTMP_FJH3_TMP@XGCX (XMMC,CREATIME,KHZB,ZX_DR,MX_DR,ZX_ZL,MX_ZL,ZX_YL,MX_YL,ZX_NL,MX_NL)
    	SELECT '7.2 连铸坯外销、废次非计划品率' AS XMMC, ? AS CREATIME,'-',SUM(ZX_DR),SUM(MX_DR),SUM(ZX_ZL),
    	SUM(MX_ZL),SUM(ZX_YL),SUM(MX_YL),SUM(ZX_NL),SUM(MX_NL)  
    	FROM  RPTTMP_FJH3_TURNOFFQUALITY@XGCX  T  
    	WHERE  SUBSTR(T.CREATIME , 1,8)      =   NVL(?,TO_CHAR(SYSDATE , 'YYYYMMDD'))
    	AND T.XMMC LIKE '7.2.%'  
    ]]>
    </query>
    
    <query id="UIG100000_02.INSERT6" desc="合并两小项">
    <![CDATA[
    	INSERT INTO RPTTMP_FJH3_TMP@XGCX (XMMC,CREATIME,KHZB,ZX_DR,MX_DR,ZX_ZL,MX_ZL,ZX_YL,MX_YL,ZX_NL,MX_NL)
    	SELECT '7.3 炼钢钢材钢质非计划品率' AS XMMC, ? AS CREATIME,'-',SUM(ZX_DR),SUM(MX_DR),SUM(ZX_ZL),
    	SUM(MX_ZL),SUM(ZX_YL),SUM(MX_YL),SUM(ZX_NL),SUM(MX_NL)  
    	FROM  RPTTMP_FJH3_TURNOFFQUALITY@XGCX  T  
    	WHERE  SUBSTR(T.CREATIME , 1,8)      =   NVL(?,TO_CHAR(SYSDATE , 'YYYYMMDD'))
    	AND T.XMMC LIKE '7.3.%'  
    ]]>
    </query>
    
    <query id="UIG100000_02.INSERT7" desc="合并两小项">
    <![CDATA[
    	INSERT INTO RPTTMP_FJH3_TMP@XGCX (XMMC,CREATIME,KHZB,ZX_DR,MX_DR,ZX_ZL,MX_ZL,ZX_YL,MX_YL,ZX_NL,MX_NL)
    	SELECT '8.1 连铸坯超库存定额非计划品率' AS XMMC, ? AS CREATIME,'-',SUM(ZX_DR),SUM(MX_DR),SUM(ZX_ZL),
    	SUM(MX_ZL),SUM(ZX_YL),SUM(MX_YL),SUM(ZX_NL),SUM(MX_NL)  
    	FROM  RPTTMP_FJH3_TURNOFFQUALITY@XGCX  T  
    	WHERE  SUBSTR(T.CREATIME , 1,8)      =   NVL(?,TO_CHAR(SYSDATE , 'YYYYMMDD'))
    	AND T.XMMC LIKE '8.1.%'  
    ]]>
    </query>
    
    <query id="UIG100000_02.INSERT8" desc="合并两小项">
    <![CDATA[
    	INSERT INTO RPTTMP_FJH3_TMP@XGCX (XMMC,CREATIME,KHZB,ZX_DR,MX_DR,ZX_ZL,MX_ZL,ZX_YL,MX_YL,ZX_NL,MX_NL)
    	SELECT '8.2 连铸坯外销、废次非计划品率' AS XMMC, ? AS CREATIME,'-',SUM(ZX_DR),SUM(MX_DR),SUM(ZX_ZL),
    	SUM(MX_ZL),SUM(ZX_YL),SUM(MX_YL),SUM(ZX_NL),SUM(MX_NL)  
    	FROM  RPTTMP_FJH3_TURNOFFQUALITY@XGCX  T  
    	WHERE  SUBSTR(T.CREATIME , 1,8)      =   NVL(?,TO_CHAR(SYSDATE , 'YYYYMMDD'))
    	AND T.XMMC LIKE '8.2.%'  
    ]]>
    </query>
    
     <query id="UIG100000_02.INSERT9" desc="合并两小项">
    <![CDATA[
    	INSERT INTO RPTTMP_FJH3_TMP@XGCX (XMMC,CREATIME,KHZB,ZX_DR,MX_DR,ZX_ZL,MX_ZL,ZX_YL,MX_YL,ZX_NL,MX_NL)
    	SELECT '8.3 炼钢钢材钢质非计划品率' AS XMMC, ? AS CREATIME,SUM(KHZB),SUM(ZX_DR),SUM(MX_DR),SUM(ZX_ZL),
    	SUM(MX_ZL),SUM(ZX_YL),SUM(MX_YL),SUM(ZX_NL),SUM(MX_NL)  
    	FROM  RPTTMP_FJH3_TURNOFFQUALITY@XGCX  T  
    	WHERE  SUBSTR(T.CREATIME , 1,8)      =   NVL(?,TO_CHAR(SYSDATE , 'YYYYMMDD'))
    	AND T.XMMC LIKE '8.3.%'  
    ]]>
    </query>
</queryMap>