HEGII.ss.mes.dashboard/wwwroot/main/Procedure/synthesis2/rpt.ashx

<%@ WebHandler Language="C#" Class="rpt" %>

using System;
using System.Web;
using System.Web.SessionState;
using System.Data;

using Curtain.DataAccess;
using DK.XuWei.WebMes;

public class rpt : IHttpHandler, IReadOnlySessionState
{
    public void ProcessRequest(HttpContext context)
    {
        context.Response.ContentType = "text/plain";
        using (IDataAccess conn = DataAccess.Create())
        {
            if (context.Request["m"].ToString() == "table1")
            {
                string sqlStr = @"
				SELECT
TT.GOODSCODE,
TT.NUM1,
TT.NUM2,
TT.REACH
FROM(
SELECT
					GOODSCODE,
					NUM1,
					NUM2,
					RATE || '%' AS REACH 
				FROM
					(
SELECT
							PD.GOODSCODE,
							COUNT( PD.BARCODE ) AS NUM1,
							COUNT(T2.BARCODE) AS NUM2,
							100 * ROUND( ( COUNT( PD.BARCODE ) - NVL( COUNT(T2.BARCODE), 0 ) ) / COUNT( PD.BARCODE ), 3 ) AS RATE 
						FROM
							TP_PM_PRODUCTIONDATA PD
							INNER JOIN TP_MST_GOODS G ON PD.GOODSID = G.GOODSID
							INNER JOIN TP_MST_GOODSTYPE GT ON G.GOODSTYPEID = GT.GOODSTYPEID 
							LEFT JOIN (
						SELECT
							D.GOODSCODE,
							PD.BARCODE
						FROM
							TP_PM_DEFECT D	
							INNER JOIN TP_MST_GOODS G ON D.GOODSID = G.GOODSID
							INNER JOIN TP_MST_GOODSTYPE GT ON G.GOODSTYPEID = GT.GOODSTYPEID
							INNER JOIN TP_PM_PRODUCTIONDATA PD ON D.PRODUCTIONDATAID = PD.PRODUCTIONDATAID
							LEFT JOIN TP_MST_DEFECT MSTD ON D.DEFECTID = MSTD.DEFECTID
							LEFT JOIN TP_MST_DEFECTTYPE DT ON MSTD.DEFECTTYPEID = DT.DEFECTTYPEID 
						WHERE
							D.VALUEFLAG = 1 
							AND INSTR( GT.GOODSTYPECODE, '001001' ) = 1 
							AND D.CREATETIME >= trunc(sysdate, 'mm')
							AND D.CREATETIME <= trunc(sysdate)
							AND PD.ISREFIRE = 0
							AND PD.GOODSLEVELTYPEID IN ( 6, 7 ) 
							AND DT.DEFECTTYPENAME LIKE '成型%' 
							AND PD.CHECKBATCHNO = 1
							AND D.DEFECTDEDUCTIONNUM IN ( 1, 2, 5 )  
						) T2 ON PD.BARCODE = T2.BARCODE 
						WHERE
							PD.PROCEDUREID = 104 AND PD.ISREFIRE = 0 AND PD.CHECKFLAG = 1
							AND PD.CREATETIME >= trunc(sysdate, 'mm')
							--AND PD.CREATETIME <= sysdate
							AND INSTR( GT.GOODSTYPECODE, '001001' ) = 1 
						GROUP BY
							PD.GOODSCODE
							)
											ORDER BY
					TO_NUMBER( RATE ) DESC )TT WHERE ROWNUM < 11 ORDER BY TT.REACH DESC";
                //直接获取不分页数据
                DataTable dt = conn.ExecuteDatatable(sqlStr);
                string jsonStr = new JsonResult(dt).ToJson();
                context.Response.Write(jsonStr);
            }
            else if (context.Request["m"].ToString() == "table2")
            {
                string sqlStr = @"
				SELECT
	TT.GOODSCODE,
	TT.NUM1,
	TT.NUM2,
	TT.REACH 
FROM
	(
	SELECT
		GOODSCODE,
		NUM1,
		NUM2,
		RATE || '%' AS REACH 
	FROM
		(
		SELECT
			PD.GOODSCODE,
			COUNT( PD.BARCODE ) AS NUM1,
			COUNT( T2.BARCODE ) AS NUM2,
			100 * ROUND(
				( COUNT( PD.BARCODE ) - NVL( COUNT( T2.BARCODE ), 0 ) ) / COUNT( PD.BARCODE ),
				3 
			) AS RATE 
		FROM
			TP_PM_PRODUCTIONDATA PD
			INNER JOIN TP_MST_GOODS G ON PD.GOODSID = G.GOODSID
			INNER JOIN TP_MST_GOODSTYPE GT ON G.GOODSTYPEID = GT.GOODSTYPEID
			LEFT JOIN (
			SELECT
				D.GOODSCODE,
				PD.BARCODE 
			FROM
				TP_PM_DEFECT D
				INNER JOIN TP_MST_GOODS G ON D.GOODSID = G.GOODSID
				INNER JOIN TP_MST_GOODSTYPE GT ON G.GOODSTYPEID = GT.GOODSTYPEID
				INNER JOIN TP_PM_PRODUCTIONDATA PD ON D.PRODUCTIONDATAID = PD.PRODUCTIONDATAID
				LEFT JOIN TP_MST_DEFECT MSTD ON D.DEFECTID = MSTD.DEFECTID
				LEFT JOIN TP_MST_DEFECTTYPE DT ON MSTD.DEFECTTYPEID = DT.DEFECTTYPEID 
			WHERE
				D.VALUEFLAG = 1 
				AND INSTR( GT.GOODSTYPECODE, '001001' ) = 1 
				AND D.CREATETIME >= trunc( SYSDATE, 'mm' ) 
				AND D.CREATETIME <=  SYSDATE 
				AND PD.ISREFIRE = 0 
				AND PD.GOODSLEVELTYPEID IN ( 6, 7 ) 
				AND DT.DEFECTTYPENAME LIKE '%改洗%' 
				AND PD.CHECKBATCHNO = 1 
				AND D.DEFECTDEDUCTIONNUM IN ( 1, 2, 5 ) 
			) T2 ON PD.BARCODE = T2.BARCODE 
		WHERE
			(
				PD.PROCEDUREID = 104 
				AND PD.ISREFIRE = 0 
				AND PD.CHECKFLAG = 1 
			) 
			AND PD.CREATETIME >= trunc( SYSDATE, 'mm' ) 
			AND PD.CREATETIME <= SYSDATE 
			AND INSTR( GT.GOODSTYPECODE, '001001' ) = 1 
		GROUP BY
			PD.GOODSCODE 
		) 
	ORDER BY
		TO_NUMBER( RATE ) ASC 
	) TT 
WHERE
	ROWNUM < 11 ORDER BY TT.REACH DESC";
                //直接获取不分页数据
                DataTable dt = conn.ExecuteDatatable(sqlStr);
                string jsonStr = new JsonResult(dt).ToJson();
                context.Response.Write(jsonStr);
            }
            else if (context.Request["m"].ToString() == "table3")
            {
                string sqlStr = @"
				SELECT
					TT.GOODSCODE,
					TT.NUM1,
					TT.NUM2,
					TT.REACH 
				FROM
					(
					SELECT
						GOODSCODE,
						NUM1,
						NUM2,
						RATE || '%' AS REACH 
					FROM
						(
						SELECT
							PD.GOODSCODE,
							COUNT( PD.BARCODE ) AS NUM1,
							COUNT( T2.BARCODE ) AS NUM2,
							100 * ROUND(
								( COUNT( PD.BARCODE ) - NVL( COUNT( T2.BARCODE ), 0 ) ) / COUNT( PD.BARCODE ),
								3 
							) AS RATE 
						FROM
							TP_PM_PRODUCTIONDATA PD
							INNER JOIN TP_MST_GOODS G ON PD.GOODSID = G.GOODSID
							INNER JOIN TP_MST_GOODSTYPE GT ON G.GOODSTYPEID = GT.GOODSTYPEID
							LEFT JOIN (
							SELECT
								D.GOODSCODE,
								PD.BARCODE 
							FROM
								TP_PM_DEFECT D
								INNER JOIN TP_MST_GOODS G ON D.GOODSID = G.GOODSID
								INNER JOIN TP_MST_GOODSTYPE GT ON G.GOODSTYPEID = GT.GOODSTYPEID
								INNER JOIN TP_PM_PRODUCTIONDATA PD ON D.PRODUCTIONDATAID = PD.PRODUCTIONDATAID
								LEFT JOIN TP_MST_DEFECT MSTD ON D.DEFECTID = MSTD.DEFECTID
								LEFT JOIN TP_MST_DEFECTTYPE DT ON MSTD.DEFECTTYPEID = DT.DEFECTTYPEID 
							WHERE
								D.VALUEFLAG = 1 
								AND INSTR( GT.GOODSTYPECODE, '001001' ) = 1 
								AND D.CREATETIME >= trunc( SYSDATE, 'mm' ) 
								AND D.CREATETIME <=  SYSDATE  
								AND PD.ISREFIRE = 0 
								AND PD.GOODSLEVELTYPEID IN ( 6, 7 ) 
								AND DT.DEFECTTYPENAME LIKE '%成型/检验%'
								AND PD.CHECKBATCHNO = 1 
								AND D.DEFECTDEDUCTIONNUM IN ( 1, 2, 5 ) 
							) T2 ON PD.BARCODE = T2.BARCODE 
						WHERE
							(
								PD.PROCEDUREID = 104 
								AND PD.ISREFIRE = 0 
								AND PD.CHECKFLAG = 1 
							) 
							AND PD.CREATETIME >= trunc( SYSDATE, 'mm' ) 
							AND PD.CREATETIME <= SYSDATE 
							AND INSTR( GT.GOODSTYPECODE, '001001' ) = 1 
						GROUP BY
							PD.GOODSCODE 
						) 
					ORDER BY
						TO_NUMBER( RATE ) ASC 
					) TT 
				WHERE
					ROWNUM < 11 ORDER BY TT.REACH DESC";
                //直接获取不分页数据
                DataTable dt = conn.ExecuteDatatable(sqlStr);
                string jsonStr = new JsonResult(dt).ToJson();
                context.Response.Write(jsonStr);
            }
            else if (context.Request["m"].ToString() == "table4")
            {
                string sqlStr = @"
				SELECT
	TT.GOODSCODE,
	TT.NUM1,
	TT.NUM2,
	TT.REACH 
FROM
	(
	SELECT
		GOODSCODE,
		NUM1,
		NUM2,
		RATE || '%' AS REACH 
	FROM
		(
		SELECT
			PD.GOODSCODE,
			COUNT( PD.BARCODE ) AS NUM1,
			COUNT( T2.BARCODE ) AS NUM2,
			100 * ROUND(
				( COUNT( PD.BARCODE ) - NVL( COUNT( T2.BARCODE ), 0 ) ) / COUNT( PD.BARCODE ),
				3 
			) AS RATE 
		FROM
			TP_PM_PRODUCTIONDATA PD
			INNER JOIN TP_MST_GOODS G ON PD.GOODSID = G.GOODSID
			INNER JOIN TP_MST_GOODSTYPE GT ON G.GOODSTYPEID = GT.GOODSTYPEID
			LEFT JOIN (
			SELECT
				D.GOODSCODE,
				PD.BARCODE 
			FROM
				TP_PM_DEFECT D
				INNER JOIN TP_MST_GOODS G ON D.GOODSID = G.GOODSID
				INNER JOIN TP_MST_GOODSTYPE GT ON G.GOODSTYPEID = GT.GOODSTYPEID
				INNER JOIN TP_PM_PRODUCTIONDATA PD ON D.PRODUCTIONDATAID = PD.PRODUCTIONDATAID
				LEFT JOIN TP_MST_DEFECT MSTD ON D.DEFECTID = MSTD.DEFECTID
				LEFT JOIN TP_MST_DEFECTTYPE DT ON MSTD.DEFECTTYPEID = DT.DEFECTTYPEID 
			WHERE
				D.VALUEFLAG = 1 
				AND INSTR( GT.GOODSTYPECODE, '001001' ) = 1 
				AND D.CREATETIME >= trunc( SYSDATE, 'mm' ) 
				AND D.CREATETIME <= SYSDATE  
				AND PD.ISREFIRE = 0 
				AND PD.GOODSLEVELTYPEID IN ( 6, 7 ) 
				AND DT.DEFECTTYPENAME LIKE '%施釉%' 
				AND PD.CHECKBATCHNO = 1 
				AND D.DEFECTDEDUCTIONNUM IN ( 1, 2, 5 ) 
			) T2 ON PD.BARCODE = T2.BARCODE 
		WHERE
			(
				PD.PROCEDUREID = 104 
				AND PD.ISREFIRE = 0 
				AND PD.CHECKFLAG = 1 
			) 
			AND PD.CREATETIME >= trunc( SYSDATE, 'mm' ) 
			AND PD.CREATETIME <=  SYSDATE 
			AND INSTR( GT.GOODSTYPECODE, '001001' ) = 1 
		GROUP BY
			PD.GOODSCODE 
		) 
	ORDER BY
		TO_NUMBER( RATE ) ASC 
	) TT 
WHERE
	ROWNUM < 11 ORDER BY TT.REACH DESC";
                //直接获取不分页数据
                DataTable dt = conn.ExecuteDatatable(sqlStr);
                string jsonStr = new JsonResult(dt).ToJson();
                context.Response.Write(jsonStr);
            }
            else if (context.Request["m"].ToString() == "table5")
            {
                string sqlStr = @"
				SELECT
					TT.GOODSCODE,
					TT.NUM1,
					TT.NUM2,
					TT.REACH 
				FROM
					(
					SELECT
						GOODSCODE,
						NUM1,
						NUM2,
						RATE || '%' AS REACH 
					FROM
						(
						SELECT
							PD.GOODSCODE,
							COUNT( PD.BARCODE ) AS NUM1,
							COUNT( T2.BARCODE ) AS NUM2,
							100 * ROUND(
								( COUNT( PD.BARCODE ) - NVL( COUNT( T2.BARCODE ), 0 ) ) / COUNT( PD.BARCODE ),
								3 
							) AS RATE 
						FROM
							TP_PM_PRODUCTIONDATA PD
							INNER JOIN TP_MST_GOODS G ON PD.GOODSID = G.GOODSID
							INNER JOIN TP_MST_GOODSTYPE GT ON G.GOODSTYPEID = GT.GOODSTYPEID
							LEFT JOIN (
							SELECT
								D.GOODSCODE,
								PD.BARCODE 
							FROM
								TP_PM_DEFECT D
								INNER JOIN TP_MST_GOODS G ON D.GOODSID = G.GOODSID
								INNER JOIN TP_MST_GOODSTYPE GT ON G.GOODSTYPEID = GT.GOODSTYPEID
								INNER JOIN TP_PM_PRODUCTIONDATA PD ON D.PRODUCTIONDATAID = PD.PRODUCTIONDATAID
								LEFT JOIN TP_MST_DEFECT MSTD ON D.DEFECTID = MSTD.DEFECTID
								LEFT JOIN TP_MST_DEFECTTYPE DT ON MSTD.DEFECTTYPEID = DT.DEFECTTYPEID 
							WHERE
								D.VALUEFLAG = 1 
								AND INSTR( GT.GOODSTYPECODE, '001001' ) = 1 
								AND D.CREATETIME >= trunc( SYSDATE, 'mm' ) 
								AND D.CREATETIME <=  SYSDATE 
								AND PD.ISREFIRE = 0 
								AND PD.GOODSLEVELTYPEID IN ( 6, 7 ) 
								AND DT.DEFECTTYPENAME  IN ('刮边','登窑')
								AND PD.CHECKBATCHNO = 1 
								AND D.DEFECTDEDUCTIONNUM IN ( 1, 2, 5 ) 
							) T2 ON PD.BARCODE = T2.BARCODE 
						WHERE
							(
								PD.PROCEDUREID = 104 
								AND PD.ISREFIRE = 0 
								AND PD.CHECKFLAG = 1 
							) 
							AND PD.CREATETIME >= trunc( SYSDATE, 'mm' ) 
							AND PD.CREATETIME <= SYSDATE  
							AND INSTR( GT.GOODSTYPECODE, '001001' ) = 1 
						GROUP BY
							PD.GOODSCODE 
						) 
					ORDER BY
						TO_NUMBER( RATE ) ASC 
					) TT 
				WHERE
					ROWNUM < 11 ORDER BY TT.REACH DESC" ;
                //直接获取不分页数据
                DataTable dt = conn.ExecuteDatatable(sqlStr);
                string jsonStr = new JsonResult(dt).ToJson();
                context.Response.Write(jsonStr);
            }
            else if (context.Request["m"].ToString() == "table6")
            {
                string sqlStr = @"
				SELECT
					TT.GOODSCODE,
					TT.NUM1,
					TT.NUM2,
					TT.REACH 
				FROM
					(
					SELECT
						GOODSCODE,
						NUM1,
						NUM2,
						RATE || '%' AS REACH 
					FROM
						(
						SELECT
							PD.GOODSCODE,
							COUNT( PD.BARCODE ) AS NUM1,
							COUNT( T2.BARCODE ) AS NUM2,
							100 * ROUND(
								( COUNT( PD.BARCODE ) - NVL( COUNT( T2.BARCODE ), 0 ) ) / COUNT( PD.BARCODE ),
								3 
							) AS RATE 
						FROM
							TP_PM_PRODUCTIONDATA PD
							INNER JOIN TP_MST_GOODS G ON PD.GOODSID = G.GOODSID
							INNER JOIN TP_MST_GOODSTYPE GT ON G.GOODSTYPEID = GT.GOODSTYPEID
							LEFT JOIN (
							SELECT
								D.GOODSCODE,
								PD.BARCODE 
							FROM
								TP_PM_DEFECT D
								INNER JOIN TP_MST_GOODS G ON D.GOODSID = G.GOODSID
								INNER JOIN TP_MST_GOODSTYPE GT ON G.GOODSTYPEID = GT.GOODSTYPEID
								INNER JOIN TP_PM_PRODUCTIONDATA PD ON D.PRODUCTIONDATAID = PD.PRODUCTIONDATAID
								LEFT JOIN TP_MST_DEFECT MSTD ON D.DEFECTID = MSTD.DEFECTID
								LEFT JOIN TP_MST_DEFECTTYPE DT ON MSTD.DEFECTTYPEID = DT.DEFECTTYPEID 
							WHERE
								D.VALUEFLAG = 1 
								AND INSTR( GT.GOODSTYPECODE, '001001' ) = 1 
								AND D.CREATETIME >= trunc( SYSDATE, 'mm' ) 
								AND D.CREATETIME <= SYSDATE 
								AND PD.ISREFIRE = 0 
								AND PD.GOODSLEVELTYPEID IN ( 6, 7 ) 
								AND DT.DEFECTTYPENAME LIKE '%烧成%'
								AND PD.CHECKBATCHNO = 1 
								AND D.DEFECTDEDUCTIONNUM IN ( 1, 2, 5 ) 
							) T2 ON PD.BARCODE = T2.BARCODE 
						WHERE
							(
								PD.PROCEDUREID = 104 
								AND PD.ISREFIRE = 0 
								AND PD.CHECKFLAG = 1 
							) 
							AND PD.CREATETIME >= trunc( SYSDATE, 'mm' ) 
							AND PD.CREATETIME <=  SYSDATE 
							AND INSTR( GT.GOODSTYPECODE, '001001' ) = 1 
						GROUP BY
							PD.GOODSCODE 
						) 
					ORDER BY
						TO_NUMBER( RATE ) ASC 
					) TT 
				WHERE
					ROWNUM < 11  					ORDER BY TT.REACH DESC";
                //直接获取不分页数据
                DataTable dt = conn.ExecuteDatatable(sqlStr);
                string jsonStr = new JsonResult(dt).ToJson();
                context.Response.Write(jsonStr);
            }
            else if (context.Request["m"].ToString() == "procedureday")
            {
                string sqlStr = @"WITH PD AS (
					SELECT
						1 AS FK,
						COUNT( DISTINCT CASE WHEN  DT.DEFECTTYPENAME LIKE '成型%' THEN TO_CHAR(D.BARCODE) ELSE NULL END ) AS 成型一检,
						COUNT( DISTINCT CASE WHEN DT.DEFECTTYPENAME LIKE '%改洗%' THEN TO_CHAR(D.BARCODE) ELSE NULL END ) AS 改洗,
						COUNT( DISTINCT CASE WHEN DT.DEFECTTYPENAME LIKE '%检验%' THEN TO_CHAR(D.BARCODE) ELSE NULL END ) AS 二检,
						COUNT( DISTINCT CASE WHEN DT.DEFECTTYPENAME LIKE '%施釉%' THEN TO_CHAR(D.BARCODE) ELSE NULL END ) AS 施釉,
						COUNT( DISTINCT CASE WHEN DT.DEFECTTYPENAME IN ( '刮边', '登窑' ) THEN TO_CHAR(D.BARCODE) ELSE NULL END ) AS 刮登,
						COUNT( DISTINCT CASE WHEN DT.DEFECTTYPENAME LIKE '%烧成%' THEN TO_CHAR(D.BARCODE) ELSE NULL END ) AS 烧成 
										FROM
											TP_PM_DEFECT D
											INNER JOIN TP_MST_GOODS G ON D.GOODSID = G.GOODSID
											INNER JOIN TP_MST_GOODSTYPE GT ON G.GOODSTYPEID = GT.GOODSTYPEID
											INNER JOIN TP_PM_PRODUCTIONDATA PD ON D.PRODUCTIONDATAID = PD.PRODUCTIONDATAID
											LEFT JOIN TP_MST_DEFECT MSTD ON D.DEFECTID = MSTD.DEFECTID
											LEFT JOIN TP_MST_DEFECTTYPE DT ON MSTD.DEFECTTYPEID = DT.DEFECTTYPEID 
										WHERE
											D.VALUEFLAG = 1 
											AND INSTR( GT.GOODSTYPECODE, '001001' ) = 1 
											AND D.CREATETIME >= TRUNC( SYSDATE ) 
											AND PD.GOODSLEVELTYPEID IN ( 6, 7 ) 
											AND PD.CHECKBATCHNO = 1 
											AND PD.ISREFIRE = 0 
											AND D.DEFECTDEDUCTIONNUM IN ( 1, 2, 5 ) 
										),
										OUTPUT AS (
										SELECT
											1 AS FK,
											COUNT( * ) AS 出窑数 
										FROM
											TP_PM_PRODUCTIONDATA PD
											INNER JOIN TP_MST_GOODS G ON PD.GOODSID = G.GOODSID
											INNER JOIN TP_MST_GOODSTYPE GT ON G.GOODSTYPEID = GT.GOODSTYPEID 
										WHERE
											(
												 PD.PROCEDUREID = 104 
												AND PD.ISREFIRE = 0 
												AND PD.CHECKFLAG = 1 
											) 
											AND PD.CREATETIME >= TRUNC( SYSDATE ) 
											AND PD.CREATETIME < TRUNC( SYSDATE ) + 1 
											AND INSTR( GT.GOODSTYPECODE, '001001' ) = 1 
										) 
									SELECT
										TO_NUMBER(DECODE( OUTPUT.出窑数, 0, '0', ROUND( ( OUTPUT.出窑数 - PD.成型一检 ) / OUTPUT.出窑数, 3 ) * 100 )) AS 成型一检,
										TO_NUMBER(DECODE( OUTPUT.出窑数, 0, '0', ROUND( ( OUTPUT.出窑数 - PD.改洗 ) / OUTPUT.出窑数, 3 ) * 100 )) AS 改洗,
										TO_NUMBER(DECODE( OUTPUT.出窑数, 0, '0', ROUND( ( OUTPUT.出窑数 - PD.二检 ) / OUTPUT.出窑数, 3 ) * 100 )) AS 二检,
										TO_NUMBER(DECODE( OUTPUT.出窑数, 0, '0', ROUND( ( OUTPUT.出窑数 - PD.施釉 ) / OUTPUT.出窑数, 3 ) * 100 )) AS 施釉,
										TO_NUMBER(DECODE( OUTPUT.出窑数, 0, '0', ROUND( ( OUTPUT.出窑数 - PD.刮登 ) / OUTPUT.出窑数, 3 ) * 100 )) AS 刮登,
										TO_NUMBER(DECODE( OUTPUT.出窑数, 0, '0', ROUND( ( OUTPUT.出窑数 - PD.烧成 ) / OUTPUT.出窑数, 3 ) * 100 )) AS 烧成 
									FROM
									OUTPUT INNER JOIN PD ON OUTPUT.FK = PD.FK";
                //直接获取不分页数据
                DataTable dt = conn.ExecuteDatatable(sqlStr);
                string jsonStr = new JsonResult(dt).ToJson();
                context.Response.Write(jsonStr);
            }
            else if (context.Request["m"].ToString() == "proceduremonth")
            {
                string sqlStr = @"
				WITH PD AS (
					SELECT
						1 AS FK,
						COUNT( DISTINCT CASE WHEN  DT.DEFECTTYPENAME LIKE '成型%' THEN TO_CHAR(D.BARCODE) ELSE NULL END ) AS 成型一检,
						COUNT( DISTINCT CASE WHEN DT.DEFECTTYPENAME LIKE '%改洗%' THEN TO_CHAR(D.BARCODE) ELSE NULL END ) AS 改洗,
						COUNT( DISTINCT CASE WHEN DT.DEFECTTYPENAME LIKE '%检验%' THEN TO_CHAR(D.BARCODE) ELSE NULL END ) AS 二检,
						COUNT( DISTINCT CASE WHEN DT.DEFECTTYPENAME LIKE '%施釉%' THEN TO_CHAR(D.BARCODE) ELSE NULL END ) AS 施釉,
						COUNT( DISTINCT CASE WHEN DT.DEFECTTYPENAME IN ( '刮边', '登窑' ) THEN TO_CHAR(D.BARCODE) ELSE NULL END ) AS 刮登,
						COUNT( DISTINCT CASE WHEN DT.DEFECTTYPENAME LIKE '%烧成%' THEN TO_CHAR(D.BARCODE) ELSE NULL END ) AS 烧成 
										FROM
											TP_PM_DEFECT D
											INNER JOIN TP_MST_GOODS G ON D.GOODSID = G.GOODSID
											INNER JOIN TP_MST_GOODSTYPE GT ON G.GOODSTYPEID = GT.GOODSTYPEID
											INNER JOIN TP_PM_PRODUCTIONDATA PD ON D.PRODUCTIONDATAID = PD.PRODUCTIONDATAID
											LEFT JOIN TP_MST_DEFECT MSTD ON D.DEFECTID = MSTD.DEFECTID
											LEFT JOIN TP_MST_DEFECTTYPE DT ON MSTD.DEFECTTYPEID = DT.DEFECTTYPEID 
										WHERE
											D.VALUEFLAG = 1 
											AND INSTR( GT.GOODSTYPECODE, '001001' ) = 1 
											AND D.CREATETIME >= TRUNC(SYSDATE, 'MM') 
											AND PD.GOODSLEVELTYPEID IN ( 6, 7 ) 
											AND PD.CHECKBATCHNO = 1 
											AND PD.ISREFIRE = 0 
											AND D.DEFECTDEDUCTIONNUM IN ( 1, 2, 5 ) 
										),
										OUTPUT AS (
										SELECT
											1 AS FK,
											COUNT( * ) AS 出窑数 
										FROM
											TP_PM_PRODUCTIONDATA PD
											INNER JOIN TP_MST_GOODS G ON PD.GOODSID = G.GOODSID
											INNER JOIN TP_MST_GOODSTYPE GT ON G.GOODSTYPEID = GT.GOODSTYPEID 
										WHERE
											(
												PD.PROCEDUREID = 104 
												AND PD.ISREFIRE = 0 
												AND PD.CHECKFLAG = 1 
											) 
											AND PD.CREATETIME >= TRUNC(SYSDATE, 'MM') 
											AND PD.CREATETIME < TRUNC( SYSDATE ) + 1 
											AND INSTR( GT.GOODSTYPECODE, '001001' ) = 1 
										) 
									SELECT
										TO_NUMBER(DECODE( OUTPUT.出窑数, 0, '0', ROUND( ( OUTPUT.出窑数 - PD.成型一检 ) / OUTPUT.出窑数, 3 ) * 100 )) AS 成型一检,
										TO_NUMBER(DECODE( OUTPUT.出窑数, 0, '0', ROUND( ( OUTPUT.出窑数 - PD.改洗 ) / OUTPUT.出窑数, 3 ) * 100 )) AS 改洗,
										TO_NUMBER(DECODE( OUTPUT.出窑数, 0, '0', ROUND( ( OUTPUT.出窑数 - PD.二检 ) / OUTPUT.出窑数, 3 ) * 100 )) AS 二检,
										TO_NUMBER(DECODE( OUTPUT.出窑数, 0, '0', ROUND( ( OUTPUT.出窑数 - PD.施釉 ) / OUTPUT.出窑数, 3 ) * 100 )) AS 施釉,
										TO_NUMBER(DECODE( OUTPUT.出窑数, 0, '0', ROUND( ( OUTPUT.出窑数 - PD.刮登 ) / OUTPUT.出窑数, 3 ) * 100 )) AS 刮登,
										TO_NUMBER(DECODE( OUTPUT.出窑数, 0, '0', ROUND( ( OUTPUT.出窑数 - PD.烧成 ) / OUTPUT.出窑数, 3 ) * 100 )) AS 烧成 
									FROM
									OUTPUT INNER JOIN PD ON OUTPUT.FK = PD.FK";
                //直接获取不分页数据
                DataTable dt = conn.ExecuteDatatable(sqlStr);
                string jsonStr = new JsonResult(dt).ToJson();
                context.Response.Write(jsonStr);
            }
        }
    }

    public decimal toNumber(object o)
    {
        if (o != DBNull.Value)
            return Convert.ToDecimal(o);
        else
            return 0;
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}