IMEX.mes.web/wwwroot/mes/pm/celsiusrecord/getCelsiusrecord.ashx

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

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 getCelsiusrecord : IHttpHandler, IReadOnlySessionState
{
    public void ProcessRequest(HttpContext context)
    {
        context.Response.ContentType = "text/plain";
        using(IDataAccess conn = DataAccess.Create())
        {
            DataTable dt = conn.ExecuteDatatable(@"
                SELECT
	                TO_CHAR( RECORDDATE, 'YYYY-MM-DD' ) AS 日期,
	                COUNT(*) 数量,
	                WM_CONCAT ( '''' || TO_CHAR( RECORDDATE, 'HH24:MM' ) || '''' ) AS 时间,
	                WM_CONCAT ( TO_CHAR( CELSIUS ) ) AS 温度,
	                WM_CONCAT ( TO_CHAR( HUMIDITY ) ) AS 湿度 
                FROM
	                TP_PM_CELSIUSRECORD 
                WHERE
	                VALUEFLAG = '1' 
	                AND THERMOMETERID = @THERMOMETERID@ 
	                AND RECORDDATE >= @DATEBEGIN@ 
	                AND RECORDDATE <= @DATEEND@ 
                GROUP BY
	                TO_CHAR( RECORDDATE, 'YYYY-MM-DD' )
            ".Replace("''''","'\"'"),
               new CDAParameter("DATEBEGIN", Convert.ToDateTime(context.Request["DATEBEGIN"])),
               new CDAParameter("DATEEND", Convert.ToDateTime(context.Request["DATEEND"])),
               new CDAParameter("THERMOMETERID", context.Request["THERMOMETERID"])
            );
            context.Response.Write(new JsonResult(dt).ToJson());
        }

    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}