HEGII.ss.mes.dashboard/wwwroot/main/Split/Screen06/rpt.ashx

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

using System;
using System.Web;
using System.Web.SessionState;
using System.Data;
using System.Text;
using System.Collections;
using System.Collections.Generic;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
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() == "1")
            {
                    //读取报表数据
                    string sqlStr = @"
					WITH hour AS (
						SELECT
							00 AS h 
						FROM
							dual UNION
						SELECT
							01 AS h 
						FROM
							dual UNION
						SELECT
							02 AS h 
						FROM
							dual UNION
						SELECT
							03 AS h 
						FROM
							dual UNION
						SELECT
							04 AS h 
						FROM
							dual UNION
						SELECT
							05 AS h 
						FROM
							dual UNION
						SELECT
							06 AS h 
						FROM
							dual UNION
						SELECT
							07 AS h 
						FROM
							dual UNION
						SELECT
							08 AS h 
						FROM
							dual UNION
						SELECT
							09 AS h 
						FROM
							dual UNION
						SELECT
							10 AS h 
						FROM
							dual UNION
						SELECT
							11 AS h 
						FROM
							dual UNION
						SELECT
							12 AS h 
						FROM
							dual UNION
						SELECT
							13 AS h 
						FROM
							dual UNION
						SELECT
							14 AS h 
						FROM
							dual UNION
						SELECT
							15 AS h 
						FROM
							dual UNION
						SELECT
							16 AS h 
						FROM
							dual UNION
						SELECT
							17 AS h 
						FROM
							dual UNION
						SELECT
							18 AS h 
						FROM
							dual UNION
						SELECT
							19 AS h 
						FROM
							dual UNION
						SELECT
							20 AS h 
						FROM
							dual UNION
						SELECT
							21 AS h 
						FROM
							dual UNION
						SELECT
							22 AS h 
						FROM
							dual UNION
						SELECT
							23 AS h 
						FROM
							dual 
						) 

						SELECT
							'1#' AS 施釉房号,
							h.h AS 时间,
							流量
						FROM
						(
						SELECT
							TO_CHAR( P.CREATETIME, 'HH24' ) AS 时间,
							ROUND( avg( nvl(G.G_FLOW,0) ), 2 ) AS 流量 
						FROM
							TP_PM_PRODUCTIONDATA P
							LEFT JOIN TP_PM_GROUTINGDAILYDETAIL GD ON GD.GROUTINGDAILYDETAILID = P.GROUTINGDAILYDETAILID
							LEFT JOIN TP_PM_GOODSGLAZING G ON P.GROUTINGDAILYDETAILID = G.GROUTINGDAILYDETAILID 
						WHERE
							P.PROCEDUREID = 98 
							AND P.CREATETIME >= TRUNC(SYSDATE)
							AND P.CREATETIME < TRUNC(SYSDATE) + 1
							AND GD.GLAZINGROOM = '1#' 
						GROUP BY
							TO_CHAR( P.CREATETIME, 'HH24' ) 
						)t
						RIGHT JOIN ( SELECT * FROM hour ) h ON t.时间 = h.h 
						ORDER BY
							h.h
			
                    ";
                    //直接获取不分页数据
                    DataTable dt = conn.ExecuteDatatable(sqlStr);
                    string jsonStr = new JsonResult(dt).ToJson();
                    context.Response.Write(jsonStr);
            }else if (context.Request["m"].ToString() == "2")
            {
                    //读取报表数据
                    string sqlStr = @"
					WITH hour AS (
						SELECT
							00 AS h 
						FROM
							dual UNION
						SELECT
							01 AS h 
						FROM
							dual UNION
						SELECT
							02 AS h 
						FROM
							dual UNION
						SELECT
							03 AS h 
						FROM
							dual UNION
						SELECT
							04 AS h 
						FROM
							dual UNION
						SELECT
							05 AS h 
						FROM
							dual UNION
						SELECT
							06 AS h 
						FROM
							dual UNION
						SELECT
							07 AS h 
						FROM
							dual UNION
						SELECT
							08 AS h 
						FROM
							dual UNION
						SELECT
							09 AS h 
						FROM
							dual UNION
						SELECT
							10 AS h 
						FROM
							dual UNION
						SELECT
							11 AS h 
						FROM
							dual UNION
						SELECT
							12 AS h 
						FROM
							dual UNION
						SELECT
							13 AS h 
						FROM
							dual UNION
						SELECT
							14 AS h 
						FROM
							dual UNION
						SELECT
							15 AS h 
						FROM
							dual UNION
						SELECT
							16 AS h 
						FROM
							dual UNION
						SELECT
							17 AS h 
						FROM
							dual UNION
						SELECT
							18 AS h 
						FROM
							dual UNION
						SELECT
							19 AS h 
						FROM
							dual UNION
						SELECT
							20 AS h 
						FROM
							dual UNION
						SELECT
							21 AS h 
						FROM
							dual UNION
						SELECT
							22 AS h 
						FROM
							dual UNION
						SELECT
							23 AS h 
						FROM
							dual 
						) 

						SELECT
							'2#' AS 施釉房号,
							h.h AS 时间,
							流量
						FROM
						(
						SELECT
							TO_CHAR( P.CREATETIME, 'HH24' ) AS 时间,
							ROUND( avg( nvl(G.G_FLOW,0) ), 2 ) AS 流量 
						FROM
							TP_PM_PRODUCTIONDATA P
							LEFT JOIN TP_PM_GROUTINGDAILYDETAIL GD ON GD.GROUTINGDAILYDETAILID = P.GROUTINGDAILYDETAILID
							LEFT JOIN TP_PM_GOODSGLAZING G ON P.GROUTINGDAILYDETAILID = G.GROUTINGDAILYDETAILID 
						WHERE
							P.PROCEDUREID = 98 
							AND P.CREATETIME >= TRUNC(SYSDATE)
							AND P.CREATETIME < TRUNC(SYSDATE) + 1
							AND GD.GLAZINGROOM = '2#' 
						GROUP BY
							TO_CHAR( P.CREATETIME, 'HH24' ) 
						)t
						RIGHT JOIN ( SELECT * FROM hour ) h ON t.时间 = h.h 
						ORDER BY
							h.h
                    ";
                    //直接获取不分页数据
                    DataTable dt = conn.ExecuteDatatable(sqlStr);
                    string jsonStr = new JsonResult(dt).ToJson();
                    context.Response.Write(jsonStr);
            }else if (context.Request["m"].ToString() == "table1")
            {
                    //读取报表数据
                    string sqlStr = @"
					SELECT
						ROUND( AVG( NVL(G.G_FLOW, 0) ), 2 )  AS 平均流量, 
						ROUND( SUM( NVL(G.G_FLOW, 0) ), 2 ) AS 累计流量 
					FROM
						TP_PM_PRODUCTIONDATA P
						LEFT JOIN TP_PM_GROUTINGDAILYDETAIL GD ON GD.GROUTINGDAILYDETAILID = P.GROUTINGDAILYDETAILID
						LEFT JOIN TP_PM_GOODSGLAZING G ON P.GROUTINGDAILYDETAILID = G.GROUTINGDAILYDETAILID 
					WHERE
						P.PROCEDUREID = 98 
						AND P.CREATETIME >= TRUNC( SYSDATE )
						AND P.CREATETIME < TRUNC( SYSDATE ) + 1 
						AND GD.GLAZINGROOM = '1#' 
                    ";
                    //直接获取不分页数据
                    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
						ROUND( AVG( NVL(G.G_FLOW, 0) ), 2 )  AS 平均流量, 
						ROUND( SUM( NVL(G.G_FLOW, 0) ), 2 ) AS 累计流量 
					FROM
						TP_PM_PRODUCTIONDATA P
						LEFT JOIN TP_PM_GROUTINGDAILYDETAIL GD ON GD.GROUTINGDAILYDETAILID = P.GROUTINGDAILYDETAILID
						LEFT JOIN TP_PM_GOODSGLAZING G ON P.GROUTINGDAILYDETAILID = G.GROUTINGDAILYDETAILID 
					WHERE
						P.PROCEDUREID = 98 
						AND P.CREATETIME >= TRUNC( SYSDATE )
						AND P.CREATETIME < TRUNC( SYSDATE ) + 1 
						AND GD.GLAZINGROOM = '2#' 
                    ";
                    //直接获取不分页数据
                    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;
        }
    }

}