HEGII.ss.mes.dashboard/wwwroot/main/Procedure/test14/demo.ashx

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

using Curtain.DataAccess;
using DK.XuWei.WebMes;
using Newtonsoft.Json.Linq;
using System;
using System.Collections.Generic;
using System.Data;
using System.Web;
using System.Web.SessionState;
using System.Linq;
public class demo : IHttpHandler
{

    public void ProcessRequest(HttpContext context)
    {
        context.Response.ContentType = "text/plain";
        context.Response.ContentType = "text/plain";
        using (IDataAccess conn = DataAccess.Create())
        {
            //毛坯库库存
            if (context.Request["m"].ToString() == "kc")
            {
                string sqlStr = @"SELECT
									CASE WHEN T.GOODSTYPEID = 3 THEN '连体'
									 WHEN T.GOODSTYPEID = 18 THEN '智能'
										ELSE '其他' END AS 产品类别,
									T.count 数量
									FROM (
									SELECT
										GOODSTYPEID,
										COUNT( * ) count
									FROM
										TP_PM_INPRODUCTION TPI
										LEFT JOIN TP_MST_GOODS TMG ON TPI.GOODSCODE = TMG.GOODSCODE
									WHERE
										TPI.PROCEDUREID = 97
									GROUP BY
										TMG.GOODSTYPEID) T";
                //直接获取不分页数据
                DataTable dt = conn.ExecuteDatatable(sqlStr);
                string jsonStr = new JsonResult(dt).ToJson();
                context.Response.Write(jsonStr);
            }
        }
        using (IDataAccess conn = DataAccess.Create())
        {
            //吹尘工号产量柱状图
            if (context.Request["m"].ToString() == "cc")
            {
                string sqlStr = @"	SELECT
										SUBSTR( T.日期, 6, 2 ) || '-' || SUBSTR( T.日期, 9, 2 ) 日期,
										T.产量 
									FROM
										(
										SELECT
											SUBSTR( TO_CHAR( TPP.CREATETIME, 'yyyy-mm-dd hh24:mi:ss' ), 0, 10 ) 日期,
											COUNT( * ) 产量 
										FROM
											TP_PM_PRODUCTIONDATA TPP
											LEFT JOIN TP_MST_WORKSTATIONUSER TMWU ON TPP.USERCODE = TMWU.USERCODE
											LEFT JOIN TP_PM_GROUTINGDAILYDETAIL PGD ON PGD.BARCODE = TPP.BARCODE
											LEFT JOIN TP_PC_GROUTINGLINE TPGL ON TPGL.GROUTINGLINEID = PGD.GROUTINGLINEID 
										WHERE
											TPP.PROCEDUREID IN ( 98 ) 
											AND TPP.VALUEFLAG = 1 
											AND TPGL.TESTFLAG = 0 
											AND TPP.CREATETIME >= trunc( SYSDATE - 7 ) 
										GROUP BY
											SUBSTR( TO_CHAR( TPP.CREATETIME, 'yyyy-mm-dd hh24:mi:ss' ), 0, 10 ) 
										ORDER BY
										SUBSTR( TO_CHAR( TPP.CREATETIME, 'yyyy-mm-dd hh24:mi:ss' ), 0, 10 ) ASC 
										) T";
                //直接获取不分页数据
                DataTable dt = conn.ExecuteDatatable(sqlStr);
                string jsonStr = new JsonResult(dt).ToJson();
                context.Response.Write(jsonStr);
            }
        }
        using (IDataAccess conn = DataAccess.Create())
        {
            //施釉工号产量柱状图
            if (context.Request["m"].ToString() == "cl")
            {
                string sqlStr = @"			SELECT
												TPP.USERCODE 工号,
												COUNT(*) 产量
											FROM
												TP_PM_PRODUCTIONDATA TPP
												LEFT JOIN TP_MST_WORKSTATIONUSER TMWU ON TPP.USERCODE = TMWU.USERCODE
												LEFT JOIN TP_PM_GROUTINGDAILYDETAIL PGD ON PGD.BARCODE = TPP.BARCODE
												LEFT JOIN TP_PC_GROUTINGLINE TPGL ON TPGL.GROUTINGLINEID = PGD.GROUTINGLINEID 
											WHERE
												TPP.PROCEDUREID IN ( 98 ) 
												AND TPP.VALUEFLAG = 1 
												AND TPGL.TESTFLAG = 0 
												AND TPP.CREATETIME >= trunc( SYSDATE ) 
												GROUP BY TPP.USERCODE";
                //直接获取不分页数据
                DataTable dt = conn.ExecuteDatatable(sqlStr);
                string jsonStr = new JsonResult(dt).ToJson();
                context.Response.Write(jsonStr);
            }
        }

        using (IDataAccess conn = DataAccess.Create())
        {
            //归属施釉缺陷（今日TOP3） 
            if (context.Request["m"].ToString() == "defect")
            {
                string sqlStr = @"SELECT
										T.S_NAME AS 缺陷名称,
										T.数量 ,
										 T.缺陷工序编码
									FROM
										(
										SELECT
											TMD.S_NAME,
											count( DISTINCT TPD.BARCODE ) AS 数量 ,
											TPD.DEFECTUSERCODE AS 缺陷工序编码
										FROM
											TP_PM_DEFECT TPD
											LEFT JOIN TP_MST_DEFECT TMD ON TPD.DEFECTID = TMD.DEFECTID
											LEFT JOIN TP_PM_PRODUCTIONDATA TPPD ON TPD.BARCODE = TPPD.BARCODE
											LEFT JOIN TP_PM_GROUTINGDAILYDETAIL PGD ON PGD.BARCODE = TPD.BARCODE
											LEFT JOIN TP_PC_GROUTINGLINE TPGL ON TPGL.GROUTINGLINEID = PGD.GROUTINGLINEID 
										WHERE
											TPD.CREATETIME >= TRUNC( SYSDATE )
											AND TMD.DEFECTTYPEID IN ( 17, 5 )
											AND TPGL.TESTFLAG = 0 
											AND TPD.DEFECTDEDUCTIONNUM >=1
											AND ( SUBSTR( TPGL.GROUTINGLINENAME, 1, 3 ) = 'C05' OR SUBSTR( TPGL.GROUTINGLINECODE, 1, 3 ) = 'C06' ) 
											AND TPPD.CHECKBATCHNO = 1 
											AND TPD.VALUEFLAG = 1
											AND TPD.DEFECTUSERCODE NOT IN('YL1')
										GROUP BY
											TMD.S_NAME ,TPD.DEFECTUSERCODE
										ORDER BY
											COUNT( * ) DESC 
										) T ";
                //直接获取不分页数据
                DataTable dt = conn.ExecuteDatatable(sqlStr);
                //创建返回值
                DataTable dt归属施釉缺陷 = new DataTable();
                DataTable dt月成品缺陷0105 = new DataTable();
                DataTable dt月成品缺陷0204 = new DataTable();
                //所需缺陷代码
                List<String> S0105 = new List<string>() { "SSY001", "SSY005" };
                List<String> S0204 = new List<string>() { "SSY002", "SSY004" };
                //添加表头
                for (int i = 0; i < 2; i++)
                {
                    dt归属施釉缺陷.Columns.Add(dt.Columns[i].ColumnName);
                    dt月成品缺陷0105.Columns.Add(dt.Columns[i].ColumnName);
                    dt月成品缺陷0204.Columns.Add(dt.Columns[i].ColumnName);
                }
                //创建归属施釉缺陷所需数据
                var aaa = dt.AsEnumerable().GroupBy(row => row.Field<string>("缺陷名称")).Select(group =>
                new { 缺陷名称 = group.Key, 数量 = group.Sum(row => row.Field<decimal>("数量")) }).
                OrderByDescending(ex => ex.数量).Take(3);
                //添加表体
                foreach (var item in aaa)
                {
                    var dr归属施釉缺陷 = dt归属施釉缺陷.NewRow();
                    dr归属施釉缺陷["缺陷名称"] = item.缺陷名称;
                    dr归属施釉缺陷["数量"] = item.数量;
                    dt归属施釉缺陷.Rows.Add(dr归属施釉缺陷);
                }
                //创建月成品缺陷0105所需数据
                var bbb = dt.AsEnumerable().Where(ex => S0105.Contains(ex.Field<string>("缺陷工序编码")))
                           .GroupBy(row => row.Field<string>("缺陷名称")).Select(group =>
                     new { 缺陷名称 = group.Key, 数量 = group.Sum(row => row.Field<decimal>("数量")) }).
                     OrderByDescending(ex => ex.数量).Take(5);

                //添加表体
                foreach (var item in bbb)
                {
                    var dr月成品缺陷0105 = dt月成品缺陷0105.NewRow();
                    dr月成品缺陷0105["缺陷名称"] = item.缺陷名称;
                    dr月成品缺陷0105["数量"] = item.数量;
                    dt月成品缺陷0105.Rows.Add(dr月成品缺陷0105);
                }
                //创建月成品缺陷0204所需数据
                var ccc = dt.AsEnumerable().Where(ex => S0204.Contains(ex.Field<string>("缺陷工序编码")))
                .GroupBy(row => row.Field<string>("缺陷名称")).Select(group =>
                 new { 缺陷名称 = group.Key, 数量 = group.Sum(row => row.Field<decimal>("数量")) }).
                OrderByDescending(ex => ex.数量).Take(5);
                //添加表体
                foreach (var item in ccc)
                {
                    var dr月成品缺陷0204 = dt月成品缺陷0204.NewRow();
                    dr月成品缺陷0204["缺陷名称"] = item.缺陷名称;
                    dr月成品缺陷0204["数量"] = item.数量;
                    dt月成品缺陷0204.Rows.Add(dr月成品缺陷0204);
                }
                //返回值对象
                DataSet result = new DataSet();
                result.Tables.Add(dt归属施釉缺陷);
                result.Tables.Add(dt月成品缺陷0105);
                result.Tables.Add(dt月成品缺陷0204);
                string jsonStr = new JsonResult(result).ToJson();
                context.Response.Write(jsonStr);
            }
        }
        using (IDataAccess conn = DataAccess.Create())
        {
            //月成品缺陷(每月TOP5)
            //SSY001 SSY002 SSY004 SSY005
            if (context.Request["m"].ToString() == "defectMonth")
            {
                string sqlStr = @"SELECT
										T.S_NAME AS 缺陷名称,
										T.数量 ,
										 T.缺陷工序编码
									FROM
										(
										SELECT
											TMD.S_NAME,
											count( DISTINCT TPD.BARCODE ) AS 数量 ,
											TPD.DEFECTUSERCODE AS 缺陷工序编码
										FROM
											TP_PM_DEFECT TPD
											LEFT JOIN TP_MST_DEFECT TMD ON TPD.DEFECTID = TMD.DEFECTID
											LEFT JOIN TP_PM_PRODUCTIONDATA TPPD ON TPD.BARCODE = TPPD.BARCODE
											LEFT JOIN TP_PM_GROUTINGDAILYDETAIL PGD ON PGD.BARCODE = TPD.BARCODE
											LEFT JOIN TP_PC_GROUTINGLINE TPGL ON TPGL.GROUTINGLINEID = PGD.GROUTINGLINEID 
										WHERE
											TPD.CREATETIME >= TRUNC(SYSDATE, 'MM') 
											AND TMD.DEFECTTYPEID IN ( 17, 5 )
											AND TPGL.TESTFLAG = 0 
											AND TPD.DEFECTDEDUCTIONNUM >=1
											AND ( SUBSTR( TPGL.GROUTINGLINENAME, 1, 3 ) = 'C05' OR SUBSTR( TPGL.GROUTINGLINECODE, 1, 3 ) = 'C06' ) 
											AND TPPD.CHECKBATCHNO = 1 
											AND TPD.VALUEFLAG = 1
											AND TPD.DEFECTUSERCODE NOT IN('YL1')
										GROUP BY
											TMD.S_NAME ,TPD.DEFECTUSERCODE
										ORDER BY
											COUNT( * ) DESC 
										) T ";
                //直接获取不分页数据
                DataTable dt = conn.ExecuteDatatable(sqlStr);
                //创建返回值 
                DataTable dt月成品缺陷0105 = new DataTable();
                DataTable dt月成品缺陷0204 = new DataTable();
                //所需缺陷代码
                List<String> S0105 = new List<string>() { "SSY001", "SSY005" };
                List<String> S0204 = new List<string>() { "SSY002", "SSY004" };
                //添加表头
                for (int i = 0; i < 2; i++)
                {
                    dt月成品缺陷0105.Columns.Add(dt.Columns[i].ColumnName);
                    dt月成品缺陷0204.Columns.Add(dt.Columns[i].ColumnName);
                }
                //创建月成品缺陷0105所需数据
                var bbb = dt.AsEnumerable().Where(ex => S0105.Contains(ex.Field<string>("缺陷工序编码")))
                           .GroupBy(row => row.Field<string>("缺陷名称")).Select(group =>
                     new { 缺陷名称 = group.Key, 数量 = group.Sum(row => row.Field<decimal>("数量")) }).
                     OrderByDescending(ex => ex.数量).Take(5);

                //添加表体
                foreach (var item in bbb)
                {
                    var dr月成品缺陷0105 = dt月成品缺陷0105.NewRow();
                    dr月成品缺陷0105["缺陷名称"] = item.缺陷名称;
                    dr月成品缺陷0105["数量"] = item.数量;
                    dt月成品缺陷0105.Rows.Add(dr月成品缺陷0105);
                }
                //创建月成品缺陷0204所需数据
                var ccc = dt.AsEnumerable().Where(ex => S0204.Contains(ex.Field<string>("缺陷工序编码")))
                .GroupBy(row => row.Field<string>("缺陷名称")).Select(group =>
                 new { 缺陷名称 = group.Key, 数量 = group.Sum(row => row.Field<decimal>("数量")) }).
                OrderByDescending(ex => ex.数量).Take(5);
                //添加表体
                foreach (var item in ccc)
                {
                    var dr月成品缺陷0204 = dt月成品缺陷0204.NewRow();
                    dr月成品缺陷0204["缺陷名称"] = item.缺陷名称;
                    dr月成品缺陷0204["数量"] = item.数量;
                    dt月成品缺陷0204.Rows.Add(dr月成品缺陷0204);
                }
                //返回值对象
                DataSet result = new DataSet();
                result.Tables.Add(dt月成品缺陷0105);
                result.Tables.Add(dt月成品缺陷0204);
                string jsonStr = new JsonResult(result).ToJson();
                context.Response.Write(jsonStr);
            }
        }

        using (IDataAccess conn = DataAccess.Create())
        {
            //半检缺陷扇形图
            if (context.Request["m"].ToString() == "defectb")
            {
                string sqlStr = @"SELECT
									CASE WHEN T.GOODSTYPEID = 3 THEN '连体'
									 WHEN T.GOODSTYPEID = 18 THEN '智能'
										ELSE '其他' END AS 产品类别,
									T.count 数量
									FROM (
									SELECT
										GOODSTYPEID,
										COUNT( * ) count
									FROM
										TP_PM_INPRODUCTION TPI
										LEFT JOIN TP_MST_GOODS TMG ON TPI.GOODSCODE = TMG.GOODSCODE 
									WHERE
										TPI.PROCEDUREID = 99 
									GROUP BY
										TMG.GOODSTYPEID) T";
                //直接获取不分页数据
                DataTable dt = conn.ExecuteDatatable(sqlStr);
                string jsonStr = new JsonResult(dt).ToJson();
                context.Response.Write(jsonStr);
            }
        }

        using (IDataAccess conn = DataAccess.Create())
        {
            //每小时产量折线图
            if (context.Request["m"].ToString() == "h")
            {
                string sqlStr = @"SELECT
		T.CREATETIME AS 日期,
	CASE
			
			WHEN TT.施釉数量 IS NULL THEN
			0 ELSE TT.施釉数量 
		END AS 二线施釉数量,
	CASE
			
			WHEN TT1.施釉数量 IS NULL THEN
			0 ELSE TT1.施釉数量 
		END AS 一线施釉数量 
	FROM
		(
		SELECT
			0 施釉数量,
			'00' AS CREATETIME 
		FROM
			DUAL UNION ALL
		SELECT
			0 施釉数量,
			'01' AS CREATETIME 
		FROM
			DUAL UNION ALL
		SELECT
			0 施釉数量,
			'02' AS CREATETIME 
		FROM
			DUAL UNION ALL
		SELECT
			0 施釉数量,
			'03' AS CREATETIME 
		FROM
			DUAL UNION ALL
		SELECT
			0 施釉数量,
			'04' AS CREATETIME 
		FROM
			DUAL UNION ALL
		SELECT
			0 施釉数量,
			'05' AS CREATETIME 
		FROM
			DUAL UNION ALL
		SELECT
			0 施釉数量,
			'06' AS CREATETIME 
		FROM
			DUAL UNION ALL
		SELECT
			0 施釉数量,
			'07' AS CREATETIME 
		FROM
			DUAL UNION ALL
		SELECT
			0 施釉数量,
			'08' AS CREATETIME 
		FROM
			DUAL UNION ALL
		SELECT
			0 施釉数量,
			'09' AS CREATETIME 
		FROM
			DUAL UNION ALL
		SELECT
			0 施釉数量,
			'10' AS CREATETIME 
		FROM
			DUAL UNION ALL
		SELECT
			0 施釉数量,
			'11' AS CREATETIME 
		FROM
			DUAL UNION ALL
		SELECT
			0 施釉数量,
			'12' AS CREATETIME 
		FROM
			DUAL UNION ALL
		SELECT
			0 施釉数量,
			'13' AS CREATETIME 
		FROM
			DUAL UNION ALL
		SELECT
			0 施釉数量,
			'14' AS CREATETIME 
		FROM
			DUAL UNION ALL
		SELECT
			0 施釉数量,
			'15' AS CREATETIME 
		FROM
			DUAL UNION ALL
		SELECT
			0 施釉数量,
			'16' AS CREATETIME 
		FROM
			DUAL UNION ALL
		SELECT
			0 施釉数量,
			'17' AS CREATETIME 
		FROM
			DUAL UNION ALL
		SELECT
			0 施釉数量,
			'18' AS CREATETIME 
		FROM
			DUAL UNION ALL
		SELECT
			0 施釉数量,
			'19' AS CREATETIME 
		FROM
			DUAL UNION ALL
		SELECT
			0 施釉数量,
			'20' AS CREATETIME 
		FROM
			DUAL UNION ALL
		SELECT
			0 施釉数量,
			'21' AS CREATETIME 
		FROM
			DUAL UNION ALL
		SELECT
			0 施釉数量,
			'22' AS CREATETIME 
		FROM
			DUAL UNION ALL
		SELECT
			0 施釉数量,
			'23' AS CREATETIME 
		FROM
			DUAL 
		) T
		FULL JOIN (
		SELECT
			T2.CREATETIME,
			COUNT( * ) 施釉数量 
		FROM
			(
			SELECT
				SUBSTR( TO_CHAR( TPP.CREATETIME, 'yyyy-mm-dd hh24:mi:ss' ), 12, 2 ) AS CREATETIME 
			FROM
				TP_PM_PRODUCTIONDATA TPP
				LEFT JOIN TP_MST_WORKSTATIONUSER TMWU ON TPP.USERCODE = TMWU.USERCODE
				LEFT JOIN TP_PM_GROUTINGDAILYDETAIL PGD ON PGD.BARCODE = TPP.BARCODE
				LEFT JOIN TP_PC_GROUTINGLINE TPGL ON TPGL.GROUTINGLINEID = PGD.GROUTINGLINEID 
			WHERE
				TPP.PROCEDUREID IN ( 98 ) 
				AND TPP.VALUEFLAG = 1 
				AND TPGL.TESTFLAG = 0 
				AND TMWU.WORKSTATIONID IN ( 37 ) 
				AND TPP.CREATETIME >= trunc( SYSDATE ) 
			) T2 
		GROUP BY
			T2.CREATETIME 
		ORDER BY
			T2.CREATETIME 
		) TT ON T.CREATETIME = TT.CREATETIME
		FULL JOIN (
		SELECT
			T2.CREATETIME,
			COUNT( * ) 施釉数量 
		FROM
			(
			SELECT
				SUBSTR( TO_CHAR( TPP.CREATETIME, 'yyyy-mm-dd hh24:mi:ss' ), 12, 2 ) AS CREATETIME 
			FROM
				TP_PM_PRODUCTIONDATA TPP
				LEFT JOIN TP_MST_WORKSTATIONUSER TMWU ON TPP.USERCODE = TMWU.USERCODE
				LEFT JOIN TP_PM_GROUTINGDAILYDETAIL PGD ON PGD.BARCODE = TPP.BARCODE
				LEFT JOIN TP_PC_GROUTINGLINE TPGL ON TPGL.GROUTINGLINEID = PGD.GROUTINGLINEID 
			WHERE
				TPP.PROCEDUREID IN ( 98 ) 
				AND TPP.VALUEFLAG = 1 
				AND TPGL.TESTFLAG = 0 
				AND TMWU.WORKSTATIONID IN ( 38 ) 
				AND TPP.CREATETIME >= trunc( SYSDATE ) 
			) T2 
		GROUP BY
			T2.CREATETIME 
		ORDER BY
		T2.CREATETIME 
	) TT1 ON T.CREATETIME = TT1.CREATETIME";
                //直接获取不分页数据
                DataTable dt = conn.ExecuteDatatable(sqlStr);
                string jsonStr = new JsonResult(dt).ToJson();
                context.Response.Write(jsonStr);
            }
        }

        using (IDataAccess conn = DataAccess.Create())
        {
            //施釉折线图
            if (context.Request["m"].ToString() == "zx")
            {
                string sqlStr = @"SELECT
									CASE
		
										WHEN
											T4.出窑数 = 0 THEN
												'100%' ELSE TO_CHAR( TRUNC( T4.成检合格 / T4.出窑数, 4 ) * 100, '990.00' ) || '%' 
												END AS 施釉合格率,
											T4.出窑数,
											SUBSTR( T4.CREATETIME, 5, 2 )||'.'||SUBSTR( T4.CREATETIME, 7, 2 ) AS 日期 
										FROM
											(
											SELECT
												T.出窑数,
												T.出窑数 - ( CASE WHEN T2.成检不合格数 IS NULL THEN 0 ELSE T2.成检不合格数 END ) AS 成检合格,
												T.CREATETIME 
											FROM
												(--出窑数
												SELECT
												CASE
													WHEN
														T2.出窑数 IS NULL THEN
															0 ELSE T2.出窑数 
														END 出窑数,
										T1.CREATETIME CREATETIME 
									FROM
										(
										SELECT
											0 出窑数,
											to_char( ( TRUNC( SYSDATE - 6 ) + ROWNUM - 1 ), 'yyyymmdd' ) AS CREATETIME 
										FROM
											DUAL CONNECT BY ROWNUM <= 7 
										ORDER BY
											to_char( ( TRUNC( SYSDATE - 6 ) + ROWNUM - 1 ), 'yyyymmdd' ) DESC 
										) T1
										LEFT JOIN (
										SELECT
											出窑数,
											CREATETIME 
										FROM
											(
											SELECT DISTINCT
											CASE
												WHEN
													COUNT( TPPD.BARCODE ) IS NULL THEN
														0 ELSE COUNT( TPPD.BARCODE ) 
													END 出窑数,
										to_char( TPPD.CREATETIME, 'yyyymmdd' ) AS CREATETIME 
									FROM
										TP_PM_PRODUCTIONDATA TPPD
										LEFT JOIN (
												SELECT
													TPPD.BARCODE,TPPD.CREATETIME
												FROM
													TP_PM_PRODUCTIONDATA TPPD
													LEFT JOIN TP_PM_GROUTINGDAILYDETAIL PGD ON PGD.BARCODE = TPPD.BARCODE
													LEFT JOIN TP_PC_GROUTINGLINE TPGL ON TPGL.GROUTINGLINEID = PGD.GROUTINGLINEID 
												WHERE
													TPPD.PROCEDUREID IN (98) 
													--AND TPPD.CREATETIME >= trunc( SYSDATE - 6 ) 
													AND TPPD.VALUEFLAG = 1
													AND ( SUBSTR( TPGL.GROUTINGLINENAME, 1, 3 ) = 'C05' OR SUBSTR( TPGL.GROUTINGLINECODE, 1, 3 ) = 'C06' ) 
													AND TPGL.TESTFLAG = 0 
													AND TPPD.ISREFIRE = 0
												) TPPB
												ON TPPB.BARCODE = TPPD.BARCODE
										LEFT JOIN TP_PM_GROUTINGDAILYDETAIL PGD ON PGD.BARCODE = TPPD.BARCODE
										LEFT JOIN TP_PC_GROUTINGLINE TPGL ON TPGL.GROUTINGLINEID = PGD.GROUTINGLINEID 
									WHERE
										TPPD.PROCEDUREID IN ( 104 ) 
										AND PGD.TESTFLAG = 0 
										AND TPPD.ISREFIRE = 0
										AND ( SUBSTR( TPGL.GROUTINGLINENAME, 1, 3 ) = 'C05' OR SUBSTR( TPGL.GROUTINGLINECODE, 1, 3 ) = 'C06' ) 
										AND TPPD.CREATETIME >= trunc( SYSDATE - 6 ) 
										AND TPPD.VALUEFLAG = 1 
									GROUP BY
										to_char( TPPD.CREATETIME, 'yyyymmdd' ) 
									ORDER BY
										to_char( TPPD.CREATETIME, 'yyyymmdd' ) DESC 
										) 
										) T2 ON T1.CREATETIME = T2.CREATETIME 
									ORDER BY
										T1.CREATETIME DESC 
										) T
										LEFT JOIN (
										SELECT
										CASE
											WHEN
												T2.成检不合格数 IS NULL THEN
													0 ELSE T2.成检不合格数 
												END 成检不合格数,
										T1.CREATETIME CREATETIME 
									FROM
										(
										SELECT
											0 成检不合格数,
											to_char( ( TRUNC( SYSDATE - 6 ) + ROWNUM - 1 ), 'yyyymmdd' ) AS CREATETIME 
										FROM
											DUAL CONNECT BY ROWNUM <= 7 
										ORDER BY
											to_char( ( TRUNC( SYSDATE - 6 ) + ROWNUM - 1 ), 'yyyymmdd' ) DESC 
										) T1
										LEFT JOIN (
										SELECT
											成检不合格数,
											CREATETIME 
										FROM
											(
											SELECT DISTINCT
												NVL( COUNT( DISTINCT TPPD.BARCODE ), 0 ) 成检不合格数,--成检本烧最后一次检验判断为次品和重烧数
												to_char( TPPD.CREATETIME, 'yyyymmdd' ) AS CREATETIME 
											FROM
												TP_PM_PRODUCTIONDATA TPPD
												LEFT JOIN TP_PM_DEFECT TPD ON TPPD.BARCODE = TPD.BARCODE
													LEFT JOIN TP_PM_GROUTINGDAILYDETAIL PGD ON PGD.BARCODE = TPPD.BARCODE
													LEFT JOIN TP_PC_GROUTINGLINE TPGL ON TPGL.GROUTINGLINEID = PGD.GROUTINGLINEID 
												WHERE
													TPD.DEFECTPROCEDUREID = 98 
													AND TPPD.CHECKBATCHNO = 1
													AND TPPD.ISREFIRE IN (0)
													AND TPPD.GOODSLEVELID IN (6,7)
													AND TPD.DEFECTDEDUCTIONNUM >=1
													AND TPD.DEFECTNAME IS NOT NULL
													AND TPPD.CREATETIME >= trunc( SYSDATE - 6 )
													AND TPPD.VALUEFLAG = 1
													AND TPGL.TESTFLAG = 0 
													AND ( SUBSTR( TPGL.GROUTINGLINENAME, 1, 3 ) = 'C05' OR SUBSTR( TPGL.GROUTINGLINECODE, 1, 3 ) = 'C06' ) 
													GROUP BY
												to_char( TPPD.CREATETIME, 'yyyymmdd' ) 
											ORDER BY
												to_char( TPPD.CREATETIME, 'yyyymmdd' ) DESC 
											) 
										) T2 ON T1.CREATETIME = T2.CREATETIME 
									ORDER BY
										T1.CREATETIME DESC 
										) T2 ON T2.CREATETIME = T.CREATETIME
									ORDER BY
										T2.CREATETIME DESC
										) T4
									ORDER BY
										CREATETIME";
                //直接获取不分页数据
                DataTable dt = conn.ExecuteDatatable(sqlStr);
                string jsonStr = new JsonResult(dt).ToJson();
                context.Response.Write(jsonStr);
            }
        }

        using (IDataAccess conn = DataAccess.Create())
        {
            //施釉每日成品合格率(前7日)&&施釉每月成品合格率(前7月)&&施釉每日成品冷补缺陷率(前7日)
            if (context.Request["m"].ToString() == "Dailypassrate")
            {
                string type = context.Request["type"].ToString() == "day" ? "yyyymmdd" : "yyyymm";
                //判断是否开启施釉每日成品冷补缺陷率(前7日)
                string repair = context.Request["repair"].ToString();
                //出窑数 
                string sqlStr1 = "SELECT " +
                    "DISTINCT CASE WHEN  COUNT( TPPD.BARCODE ) IS NULL THEN 0 ELSE COUNT( TPPD.BARCODE ) END 出窑数," +
                    "to_char( temp.CREATETIME, '"+type+"' ) AS CREATETIME " +
                    "FROM " +
                    "TP_PM_ProductionData TPPD " +
                    "INNER JOIN tp_mst_goods ON tp_mst_goods.goodsid = TPPD.Goodsid " +
                    "INNER JOIN tp_mst_goodstype ON tp_mst_goodstype.goodstypeid = tp_mst_goods.goodstypeid " +
                    "INNER JOIN TP_MST_RptTProcedure ON TP_MST_RptTProcedure.Procedureid = TPPD.Procedureid " +
                    "INNER JOIN tp_pc_procedure pcp ON pcp.procedureid = TPPD.Procedureid " +
                    "INNER JOIN ( " +
                                  "SELECT pd.Barcode, pd.Createtime " +
                                  "FROM TP_PM_ProductionData pd " +
                                  "INNER JOIN tp_pm_groutingdailydetail gdd ON gdd.groutingdailydetailid = pd.groutingdailydetailid " +
                                  "WHERE pd.Accountid = 1 " +
                                  "AND pd.isrefire = '0' " +
                                  "AND pd.islengbu = '0' " +
                                  "AND ( " +
                                  "( pd.procedureid = 11 AND pd.valueflag = '1' AND ( pd.checkflag = '1' OR pd.checkflag IS NULL ) ) " +
                                  "OR ( pd.procedureid = 104 AND pd.checkflag = '1' ) " +
                                  ") " +
                                  "AND PD.KILNID IN ( 1, 2, 5 )  " +
                                  "AND PD.CREATETIME >=  CASE WHEN '"+type+"' = 'yyyymm' THEN TRUNC(ADD_MONTHS(SYSDATE, -6), 'MM')" +
                                  "ELSE TRUNC(SYSDATE - 6) END  "+
                                  ") temp ON TPPD.Barcode = temp.barcode " +
                    "AND TPPD.createtime <= temp.createtime " +
                    "WHERE TPPD.Valueflag = '1' " +
                    "AND TP_MST_RptTProcedure.Rptprocedureid = 1 " +
                    "AND instr( ',' || '98' || ',', ',' || TP_MST_RptTProcedure.ProcedureId || ',' ) > 0 " +
                    "AND TPPD.usercode IN ( 'SSY001', 'SSY002', 'SSY004', 'SSY005' ) "+
                    "GROUP BY to_char( temp.CREATETIME, '"+type+"') " +
                    "ORDER BY to_char( temp.CREATETIME, '"+type+"' ) DESC ";

                //直接获取不分页数据
                DataTable dt1 = conn.ExecuteDatatable(sqlStr1);
                //成检不合格数 
                string sqlStr2 = "SELECT DISTINCT " +
                    "NVL( COUNT( DISTINCT pmd.BARCODE ), 0 ) 成检不合格数, " +
                    "to_char( pmd.CREATETIME, '"+type+"' ) AS CREATETIME " +
                    "FROM " +
                    "tp_pm_defect pmd " +
                    "INNER JOIN TP_PM_PRODUCTIONDATA PD ON PMD.PRODUCTIONDATAID = PD.PRODUCTIONDATAID " +
                    "AND PD.MODELTYPE IN ( - 1, - 4, - 5 ) " +
                    "AND PD.VALUEFLAG = '1' " +
                    "AND PD.CHECKBATCHNO = 1 " +
                    "AND PD.ISREFIRE = '0' " +
                    "LEFT JOIN TP_MST_Defect mstd ON pmd.DefectID = mstd.DefectID " +
                    "LEFT JOIN TP_MST_DefectType dt ON mstd.DefectTypeID = dt.DefectTypeID " +
                    "LEFT JOIN TP_PM_GroutingDailyDetail gdd ON gdd.Groutingdailydetailid = pd.Groutingdailydetailid " +
                    "INNER JOIN tp_pm_productiondata hopd ON hopd.kilncarbatchno = pd.kilncarbatchno " +
                    "AND hopd.barcode = pd.barcode " +
                    "AND ( ( hopd.procedureid = 11 AND hopd.valueflag = '1' ) " +
                          "OR ( hopd.procedureid = 104 AND hopd.isrefire = '0' AND hopd.checkflag = '1' ))  " +
                    "WHERE pmd.valueflag = '1' " +
                    "AND instr( pd.KilnCode, '3' ) > 0 " +
                    "AND dt.DefectTypeID IN(5) " +
                    "AND gdd.RECYCLINGFLAG = '0' " +
                    "AND pmd.CREATETIME >= CASE WHEN '"+type+"' = 'yyyymm' THEN TRUNC( ADD_MONTHS( SYSDATE, - 6 ), 'MM' ) " +
                         "ELSE TRUNC( SYSDATE - 6 )  END " +
                    "AND (  ( '"+repair+"' = 'true' AND pd.GOODSLEVELID = 16 ) " +
                         "OR ( '"+repair+"' <> 'true' AND pd.GOODSLEVELID IN ( 6, 7 ) AND pmd.DefectDeductionNum = 1" +
                              "AND pmd.DEFECTUSERCODE IN ( 'SSY001', 'SSY002', 'SSY004', 'SSY005' ) ) )  " +
                    "GROUP BY to_char( pmd.CREATETIME, '"+type+"' ) " +
                    "ORDER BY to_char( pmd.CREATETIME, '"+type+"' ) DESC";
                //直接获取不分页数据
                DataTable dt2 = conn.ExecuteDatatable(sqlStr2);
                DataTable restultDay = new DataTable();
                restultDay.Columns.Add("出窑数");
                restultDay.Columns.Add("施釉合格率");
                restultDay.Columns.Add("日期");
                DateTime dateTime = DateTime.Now;
                //创建施釉缺陷所需数据
                for (int i = 6; i >= 0; i--)
                { 
					string day=dateTime.AddDays(-i).ToString("yyyyMMdd");
                    string month = dateTime.AddMonths(-i).ToString("yyyyMM");

                    //出窑数
                    var kilnexits = dt1.AsEnumerable().
                            Where(ex => ex.Field<string>("CREATETIME") == (type == "yyyymmdd" ? day : month)).
                            Select(ex => ex.Field<decimal>("出窑数")).FirstOrDefault();
                    //成检不合格数
                    var unqualified = dt2.AsEnumerable().
                            Where(ex => ex.Field<string>("CREATETIME") == (type == "yyyymmdd" ? day : month)).
                            Select(ex => ex.Field<decimal>("成检不合格数")).FirstOrDefault();
                    DataRow dr = restultDay.NewRow();
                    dr["出窑数"] = kilnexits;
                    dr["施釉合格率"] = ((kilnexits - unqualified) / kilnexits).ToString("p2");
                    dr["日期"] = type == "yyyymmdd" ? dateTime.ToString("MM") + "." + dateTime.AddDays(-i).ToString("dd") :
                            dateTime.ToString("yy") + "." + dateTime.AddMonths(-i).ToString("MM");
                    restultDay.Rows.Add(dr);
                }
                string jsonStr = new JsonResult(restultDay).ToJson();
                context.Response.Write(jsonStr);
            }
        }
        using (IDataAccess conn = DataAccess.Create())
        {
            /**摘取自zx方法**/
            //施釉每日半成品损坯率
            if (context.Request["m"].ToString() == "DailypassrateSemifinished")
            {
                //出窑数 
                string sqlStr1 = @" SELECT DISTINCT
											CASE
												WHEN
													COUNT( TPPD.BARCODE ) IS NULL THEN
														0 ELSE COUNT( TPPD.BARCODE ) 
													END 出窑数,
										to_char( TPPD.CREATETIME, 'yyyymmdd' ) AS CREATETIME 
												FROM
													TP_PM_PRODUCTIONDATA TPPD
													LEFT JOIN TP_PM_GROUTINGDAILYDETAIL PGD ON PGD.BARCODE = TPPD.BARCODE
													LEFT JOIN TP_PC_GROUTINGLINE TPGL ON TPGL.GROUTINGLINEID = PGD.GROUTINGLINEID 
												WHERE
													TPPD.PROCEDUREID IN (98) 
													AND TPPD.CREATETIME >= trunc( SYSDATE - 6 ) 
													AND TPPD.VALUEFLAG = 1
													AND ( SUBSTR( TPGL.GROUTINGLINENAME, 1, 3 ) = 'C05' OR SUBSTR( TPGL.GROUTINGLINECODE, 1, 3 ) = 'C06' ) 
													AND TPGL.TESTFLAG = 0 
													AND TPPD.ISREFIRE = 0
														GROUP BY
										to_char( TPPD.CREATETIME, 'yyyymmdd' ) 
									ORDER BY
										to_char( TPPD.CREATETIME, 'yyyymmdd' ) DESC ";

                //直接获取不分页数据
                DataTable dt1 = conn.ExecuteDatatable(sqlStr1);
                //损坏数当日损毁且走过3#施釉并且损毁工序为30014,30020,30021(119, 115, 98)
                string sqlStr2 = @"SELECT DISTINCT
								   COUNT(a.BARCODE)AS 损坯数 ,
								  a.CREATETIME 	 
                                   FROM
                	              (
                	             SELECT DISTINCT sp.BARCODE , to_char( 	sp.CREATETIME , 'yyyymmdd' ) AS CREATETIME  
								 FROM
                		         tp_pm_scrapproduct sp
                		         LEFT JOIN TP_PM_ResponProcedure rp ON rp.scrapproductid = sp.scrapproductid
                		         LEFT JOIN tp_pc_procedure p ON p.procedureid = sp.procedureid 
                	             WHERE
                		         sp.valueflag = '1' 
                		         AND sp.AuditStatus = '1' 
                		         AND sp.accountid = 1 
                		         AND sp.GoodsLevelTypeID IN ( 8, 9 ) -- 8损坯、9干补
                		         AND sp.CREATETIME>= trunc( SYSDATE - 6 )
                		         AND sp.IsReFire <> '6' 
                		         AND sp.ScrapType = '0' 
                		         AND rp.ProcedureID IN ( 119, 115, 98 )
								 ) a
                	            INNER JOIN  TP_PM_PRODUCTIONDATA TPPD ON TPPD.BARCODE = a.BARCODE 
                	            WHERE 	TPPD.PROCEDUREID = 98 
                		        GROUP BY a.CREATETIME
                		        ORDER BY a.CREATETIME DESC";
                DataTable dt2 = conn.ExecuteDatatable(sqlStr2);
                DataTable restultDay = new DataTable();
                restultDay.Columns.Add("出窑数");
                restultDay.Columns.Add("损坯率");
                restultDay.Columns.Add("日期");
                DateTime dateTime = DateTime.Now;
                //创建施釉半成品损坯所需数据
                for (int i = 6; i >= 0; i--)
                {
                    string day = dateTime.AddDays(-i).ToString("yyyyMMdd");

                    //出窑数
                    var kilnexits = dt1.AsEnumerable().
                            Where(ex => ex.Field<string>("CREATETIME") == day).
                            Select(ex => ex.Field<decimal>("出窑数")).FirstOrDefault();
                    //损坯数
                    var unqualified = dt2.AsEnumerable().
                            Where(ex => ex.Field<string>("CREATETIME") == day).
                            Select(ex => ex.Field<decimal>("损坯数")).FirstOrDefault();
                    DataRow dr = restultDay.NewRow();
                    dr["出窑数"] = kilnexits;
                    dr["损坯率"] = ((kilnexits - unqualified) / kilnexits).ToString("p2");
                    dr["日期"] = dateTime.ToString("MM") + "." + dateTime.AddDays(-i).ToString("dd");

                    restultDay.Rows.Add(dr);
                }
                string jsonStr = new JsonResult(restultDay).ToJson();
                context.Response.Write(jsonStr);
            }
        }
        using (IDataAccess conn = DataAccess.Create())
        {
            //产线信息

            if (context.Request["m"].ToString() == "MonthTable")
            {
                string sqlStr = @"SELECT
									TPPD.BARCODE 产品条码,
									TPGL.GOODSCODE 产品型号,
									SUBSTR(TMW.WORKSTATIONNAME,0,4) 施釉产线,
									TPGL.GLAZE1_WEIGHT 施釉前重,
									TPGL.GLAZE2_WEIGHT 施釉后重,
									TPGL.GLAZINGROOM 施釉房号,
									TPGZ.G_FLOW 施釉流量,
									TPGZ.G_SPRAY 施釉喷幅,
									TO_CHAR(TPGZ.G_TEMP, '990.00' ) 釉浆温度,
									TPGZ.G_PRESSURE 施釉压力
								FROM
								TP_PM_PRODUCTIONDATA TPPD 
								LEFT JOIN	TP_PM_GROUTINGDAILYDETAIL TPGL ON TPPD.BARCODE = TPGL.BARCODE
								LEFT JOIN TP_PM_GOODSGLAZING TPGZ ON TPPD.BARCODE =  TPGZ.BARCODE
								LEFT JOIN TP_MST_WORKSTATIONUSER TMWU ON TPPD.USERCODE = TMWU.USERCODE
								LEFT JOIN TP_MST_WORKSTATION TMW ON TMWU.WORKSTATIONID = TMW.WORKSTATIONID
								WHERE
									TPPD.CREATETIME >= TRUNC( SYSDATE )
									AND TPPD.PROCEDUREID = 98
											 ";
                //直接获取不分页数据
                DataTable dt = conn.ExecuteDatatable(sqlStr);
                int a = 1;
                string jsonStr = new JsonResult(dt).ToJson();
                context.Response.Write(jsonStr);
            }
        }

        using (IDataAccess conn = DataAccess.Create())
        {
            //二检产线信息
            if (context.Request["m"].ToString() == "MonthTabletwo")
            {
                string sqlStr = @"				SELECT
															B.产品型号 AS 产品型号,
															B.成型产线 AS 成型产线,
															B.检验数量 AS 检验数量,
															B.合格品数 AS 合格品数,
															B.返工品数 AS 返工品数,
															B.返工合格数 AS 返工合格数,
															B.综合合格数 AS 综合合格数,
															TO_CHAR((B.合格品数/B.检验数量)* 100,'9,990.00') || '%' AS 一次合格率,
															CASE WHEN B.返工合格数 = 0 AND B.返工品数 > 0 THEN '0%'
																	 WHEN B.返工合格数 > 0 AND B.返工品数 = 0 THEN '100%' 
																	 WHEN B.返工合格数 > 0 AND B.返工品数 > 0 THEN  TO_CHAR((B.返工合格数/B.返工品数)* 100,'9,990.00') || '%' ELSE '0%'  END AS 返工合格率,
															TO_CHAR((B.综合合格数/B.检验数量)* 100,'9,990.00') || '%' AS 综合合格率
															FROM(
												SELECT
													--decode( H.gid, 7, '总计', 3, '合计【' || H.产品型号 || '】', 0, H.产品型号, '--' ) 产品型号,
													decode( H.gid, 1, '小计', 0, H.产品型号, '总计' ) 产品型号,
													decode( H.gid, 1, '--', 0, H.成型产线, '--' ) 成型产线,
													decode( H.gid, 1, H.检验数量, 0, H.检验数量, H.检验数量 ) 检验数量,
													decode( H.gid, 1, H.合格品数, 0, H.合格品数, H.合格品数 ) 合格品数,
													decode( H.gid, 1, H.返工品数, 0, H.返工品数, H.返工品数 ) 返工品数,
													decode( H.gid, 1, H.返工合格数, 0, H.返工合格数, H.返工合格数 ) 返工合格数,
													decode( H.gid, 1, H.综合合格数, 0, H.综合合格数, H.综合合格数 ) 综合合格数
												FROM
													(
												SELECT
													grouping_id(Z.产品型号, Z.成型产线) gid,
													Z.产品型号,
													Z.成型产线,
													SUM(Z.检验数量) 检验数量,
													SUM(Z.合格品数) 合格品数,
													SUM(Z.返工品数) 返工品数,
													SUM(Z.返工合格数) 返工合格数,
													SUM(Z.综合合格数) 综合合格数
												FROM
													(
													SELECT
														B.GOODSCODE AS 产品型号,
														B.GROUTINGLINECODE AS 成型产线,
														B.检验 AS 检验数量,
														B.检验 - B.返工 - B.一次不合格 AS 合格品数,
														B.返工 AS 返工品数,
														B.返工 - B.二次不合格 AS 返工合格数,
														B.检验 - B.一次不合格 - B.二次不合格 AS 综合合格数 
													FROM
														(
														SELECT
															TPPD.GOODSCODE,
															TPGL.GROUTINGLINECODE,
															COUNT( TPPD.BARCODE ) 检验,
														CASE
				
																WHEN BJFG.count IS NULL THEN
																0 ELSE BJFG.count 
															END 返工,
												CASE
	
													WHEN BJFP.count IS NULL THEN
													0 ELSE BJFP.count 
													END 一次不合格,
												CASE
	
													WHEN BJFGH.count IS NULL THEN
													0 ELSE BJFGH.count 
													END 返工合格,
												CASE
	
													WHEN BJFFP.count IS NULL THEN
													0 ELSE BJFFP.count 
													END 二次不合格 
												FROM
													TP_PM_PRODUCTIONDATA TPPD
													LEFT JOIN TP_PC_GROUTINGLINE TPGL ON TPPD.GROUTINGLINEID = TPGL.GROUTINGLINEID
													LEFT JOIN (--半检一检返工数
													SELECT
														T.GOODSCODE,
														T.GROUTINGLINECODE,
														COUNT( T.BARCODE ) count 
													FROM
														(
														SELECT DISTINCT
															TPPD.GOODSCODE,
															TPGL.GROUTINGLINECODE,
															TPS.BARCODE 
														FROM
															TP_PM_SEMICHECK TPS
															LEFT JOIN TP_PM_PRODUCTIONDATA TPPD ON TPS.BARCODE = TPPD.BARCODE
															LEFT JOIN TP_PC_GROUTINGLINE TPGL ON TPPD.GROUTINGLINEID = TPGL.GROUTINGLINEID 
														WHERE
															TPS.SEMICHECKTYPE = 1 
															AND TPS.PROCEDUREID IN ( 117 ) 
															AND TPS.CREATETIME >= TRUNC( SYSDATE ) 
															AND TPGL.TESTFLAG = 0 
															AND ( SUBSTR( TPGL.GROUTINGLINENAME, 1, 3 ) = 'C05' OR SUBSTR( TPGL.GROUTINGLINECODE, 1, 3 ) = 'C06' ) 
															AND TPS.VALUEFLAG = 1 
														) T 
													GROUP BY
														T.GOODSCODE,
														T.GROUTINGLINECODE 
													) BJFG ON BJFG.GOODSCODE = TPPD.GOODSCODE 
													AND BJFG.GROUTINGLINECODE = TPGL.GROUTINGLINECODE
													LEFT JOIN (--半检二检返工合格数
													SELECT
														T.GOODSCODE,
														T.GROUTINGLINECODE,
														COUNT( T.BARCODE ) count 
													FROM
														(
														SELECT DISTINCT
															TPPD.GOODSCODE,
															TPGL.GROUTINGLINECODE,
															TPS.BARCODE 
														FROM
															TP_PM_SEMICHECK TPS
															LEFT JOIN TP_PM_PRODUCTIONDATA TPPD ON TPS.BARCODE = TPPD.BARCODE
															LEFT JOIN TP_PC_GROUTINGLINE TPGL ON TPPD.GROUTINGLINEID = TPGL.GROUTINGLINEID 
														WHERE
															TPS.RESEMICHECKTYPE = 1 
															AND TPS.PROCEDUREID IN ( 117 ) 
															AND TPS.CREATETIME >= TRUNC( SYSDATE ) 
															AND TPGL.TESTFLAG = 0 
															AND ( SUBSTR( TPGL.GROUTINGLINENAME, 1, 3 ) = 'C05' OR SUBSTR( TPGL.GROUTINGLINECODE, 1, 3 ) = 'C06' ) 
														) T 
													GROUP BY
														T.GOODSCODE,
														T.GROUTINGLINECODE 
													ORDER BY
														T.GOODSCODE 
													) BJFGH ON BJFGH.GOODSCODE = TPPD.GOODSCODE 
													AND BJFGH.GROUTINGLINECODE = TPGL.GROUTINGLINECODE
													LEFT JOIN (--半检一次不合格
													SELECT
														T.GOODSCODE,
														T.GROUTINGLINECODE,
														COUNT( T.BARCODE ) count 
													FROM
														(
														SELECT DISTINCT
															TPPD.GOODSCODE,
															TPGL.GROUTINGLINECODE,
															TPS.BARCODE 
														FROM
															TP_PM_SEMICHECK TPS
															FULL JOIN TP_PM_PRODUCTIONDATA TPPD ON TPS.BARCODE = TPPD.BARCODE
															LEFT JOIN TP_PC_GROUTINGLINE TPGL ON TPPD.GROUTINGLINEID = TPGL.GROUTINGLINEID 
														WHERE
															TPS.SEMICHECKTYPE =2
															AND TPS.PROCEDUREID IN ( 117 ) 
															AND TPS.CREATETIME >= TRUNC( SYSDATE ) 
															AND TPGL.TESTFLAG = 0 
															AND ( SUBSTR( TPGL.GROUTINGLINENAME, 1, 3 ) = 'C05' OR SUBSTR( TPGL.GROUTINGLINECODE, 1, 3 ) = 'C06' ) 
															AND TPS.VALUEFLAG = 1 
														) T 
													GROUP BY
														T.GOODSCODE,
														T.GROUTINGLINECODE 
													) BJFP ON BJFP.GOODSCODE = TPPD.GOODSCODE 
													AND BJFP.GROUTINGLINECODE = TPGL.GROUTINGLINECODE
													LEFT JOIN (--半检二次不合格
													SELECT
														T.GOODSCODE,
														T.GROUTINGLINECODE,
														COUNT( T.BARCODE ) count 
													FROM
														(
														SELECT DISTINCT
															TPPD.GOODSCODE,
															TPGL.GROUTINGLINECODE,
															TPS.BARCODE 
														FROM
															TP_PM_SEMICHECK TPS
															FULL JOIN TP_PM_PRODUCTIONDATA TPPD ON TPS.BARCODE = TPPD.BARCODE
															LEFT JOIN TP_PC_GROUTINGLINE TPGL ON TPPD.GROUTINGLINEID = TPGL.GROUTINGLINEID 
															WHERE--TPS.GOODSLEVELID IN (13)
															TPS.RESEMICHECKTYPE = 2 
															AND TPS.PROCEDUREID IN ( 117 ) 
															AND TPS.CREATETIME >= TRUNC( SYSDATE ) 
															AND TPGL.TESTFLAG = 0 
															AND ( SUBSTR( TPGL.GROUTINGLINENAME, 1, 3 ) = 'C05' OR SUBSTR( TPGL.GROUTINGLINECODE, 1, 3 ) = 'C06' ) 
															AND TPS.VALUEFLAG = 1 
														) T 
													GROUP BY
														T.GOODSCODE,
														T.GROUTINGLINECODE 
													) BJFFP ON BJFP.GOODSCODE = TPPD.GOODSCODE 
													AND BJFFP.GROUTINGLINECODE = TPGL.GROUTINGLINECODE 
													WHERE
													TPPD.CREATETIME >= TRUNC( SYSDATE ) 
																									AND TPPD.PROCEDUREID IN ( 117 ) 
																									AND TPGL.TESTFLAG = 0 
																									AND TPPD.VALUEFLAG = 1 
																									AND ( SUBSTR( TPGL.GROUTINGLINECODE, 1, 3 ) = 'C05' OR SUBSTR( TPGL.GROUTINGLINECODE, 1, 3 ) = 'C06' ) 
												GROUP BY
													TPPD.GOODSCODE,
													TPGL.GROUTINGLINECODE,
													BJFG.count,
													BJFP.count,
													BJFGH.count,
													BJFFP.count 
												ORDER BY
													TPPD.GOODSCODE 
													) B 
													) Z
													GROUP BY GROUPING SETS((Z.产品型号),(Z.产品型号,Z.成型产线, Z.检验数量,Z.合格品数, Z.返工品数, Z.返工合格数,Z.综合合格数),())
													)H) B
											 ";
                //直接获取不分页数据
                DataTable dt = conn.ExecuteDatatable(sqlStr);
                string jsonStr = new JsonResult(dt).ToJson();
                context.Response.Write(jsonStr);
            }
        }
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}