HEGII.gt.mes.web/wwwroot/mes/dashboard.ashx

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

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 dashboard : IHttpHandler, IReadOnlySessionState
{

    public void ProcessRequest(HttpContext context)
    {
        context.Response.ContentType = "text/plain";
        using(IDataAccess conn = DataAccess.Create())
        {
            //注浆
            if(context.Request["m"] == "groutingDay")
            {
                string sqlStr = @"
                    SELECT
	                    COUNT( * ) AS 注浆数量
                    FROM
	                    TP_PM_GROUTINGDAILYDETAIL GDD
	                    LEFT JOIN TP_MST_GOODS G ON GDD.GOODSID = G.GOODSID 
                    WHERE
	                    GDD.GROUTINGDATE >= TRUNC(SYSDATE)
	                    AND GDD.GROUTINGFLAG = '1' 
                ";

                List<CDAParameter> sqlPara = new List<CDAParameter>();
                //sqlPara.Add(new CDAParameter("DATEBEGIN", Convert.ToDateTime(context.Request["datebeginMaster"]), DataType.DateTime));

                DataTable dt = conn.ExecuteDatatable(sqlStr, sqlPara.ToArray());
                string jsonStr = new JsonResult(dt) { total = dt.Rows.Count }.ToJson();

                context.Response.Write(jsonStr);
            }

            //工序产量
            if(context.Request["m"] == "procedureDay")
            {
                string sqlStr = @"
                    SELECT
	                    PC.PROCEDUREID AS 工序编号,
	                    PC.PROCEDURENAME AS 工序名称,
	                    COUNT( PD.PRODUCTIONDATAID ) AS 工序产量 
                    FROM
	                    TP_PC_PROCEDURE PC
	                    LEFT JOIN TP_PM_PRODUCTIONDATA PD ON PD.PROCEDUREID = PC.PROCEDUREID 
                    WHERE
                        (PD.VALUEFLAG = 1 OR PD.VALUEFLAG IS NULL)
                        AND PC.VALUEFLAG = 1 
	                    AND (PD.CREATETIME > TRUNC( SYSDATE ) OR PD.CREATETIME IS NULL)
	                    AND INSTR( PC.PROCEDURENAME, '1#' ) = 1 
                    GROUP BY
	                    PC.PROCEDUREID,
	                    PC.PROCEDURENAME,
	                    PC.NODENO
                    ORDER BY 
	                    PC.NODENO
                ";

                List<CDAParameter> sqlPara = new List<CDAParameter>();
                //sqlPara.Add(new CDAParameter("DATEBEGIN", Convert.ToDateTime(context.Request["datebeginMaster"]), DataType.DateTime));

                DataTable dt = conn.ExecuteDatatable(sqlStr, sqlPara.ToArray());
                string jsonStr = new JsonResult(dt) { total = dt.Rows.Count }.ToJson();

                context.Response.Write(jsonStr);
            }

        }
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}