HEGII.ss.mes.web/wwwroot/api/PorcelainWeight2.ashx

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

using System;
using System.Web;
using System.Data;
using Curtain.DataAccess;
using DK.XuWei.WebMes;

/// <summary>
/// 当日经过3#卸窑的光瓷重量
/// xuwei 2020-08-20
/// </summary>
public class mesPackingIndex : IHttpHandler
{
    public string procedureid = "";
    public string StartTime = "";
    public string EndTime = "";
    public void ProcessRequest(HttpContext context)
    {
        context.Response.ContentType = "text/plain";
        procedureid = context.Request["PROCEDUREID"] is object ? context.Request["PROCEDUREID"] : "";
        StartTime = context.Request["StartTime"] is object ? context.Request["StartTime"] : "";
        EndTime = context.Request["EndTime"] is object ? context.Request["EndTime"] : "";
        DataTable dt = new DataTable();
        using (IDataAccess conn = DataAccess.Create())
        {
            if (procedureid != "" && StartTime == "" && EndTime == "")
            {
               
                dt = conn.ExecuteDatatable(@"
               SELECT
	                SUM( T.LUSTERWAREWEIGHT * T.count ) LUSTERWAREWEIGHT
                FROM
	                (
	                SELECT
		                TPPD.GOODSCODE,
		                TMG.LUSTERWAREWEIGHT,
		                COUNT( * ) count 
	                FROM
		                TP_PM_PRODUCTIONDATA TPPD
		                LEFT JOIN TP_MST_GOODS TMG ON TPPD.GOODSID = TMG.GOODSID 
	                WHERE
		                TPPD.PROCEDUREID = @PROCEDUREID@ 
		                AND TPPD.CREATETIME >= trunc( SYSDATE )
	                GROUP BY
		                TPPD.GOODSCODE,
	                TMG.LUSTERWAREWEIGHT
	                ) T
				",
                    new CDAParameter("PROCEDUREID", procedureid)
            );
                var LUSTERWAREWEIGHT = dt.Rows[0]["LUSTERWAREWEIGHT"].ToString();
                context.Response.Write(new JsonResult(LUSTERWAREWEIGHT).ToJson());
            }
            else if (procedureid != "" && StartTime != "" && EndTime != "")
                {
                    dt = conn.ExecuteDatatable(@"
               SELECT
	                SUM( T.LUSTERWAREWEIGHT * T.count ) LUSTERWAREWEIGHT
                FROM
	                (
	                SELECT
		                TPPD.GOODSCODE,
		                TMG.LUSTERWAREWEIGHT,
		                COUNT( * ) count 
	                FROM
		                TP_PM_PRODUCTIONDATA TPPD
		                LEFT JOIN TP_MST_GOODS TMG ON TPPD.GOODSID = TMG.GOODSID 
	                WHERE
		                TPPD.PROCEDUREID = @PROCEDUREID@
		                AND TPPD.CREATETIME >= TO_date(@StartTime@,'yy-mm-dd hh24:mi:ss')
						AND TPPD.CREATETIME <= TO_date(@EndTime@,'yy-mm-dd hh24:mi:ss')
	                GROUP BY
		                TPPD.GOODSCODE,
	                TMG.LUSTERWAREWEIGHT
									) T
				",
                    new CDAParameter("PROCEDUREID", procedureid),
                    new CDAParameter("StartTime", StartTime+"00:00:00"),
                    new CDAParameter("EndTime", EndTime+"23:59:59")
            );
                var LUSTERWAREWEIGHT = dt.Rows[0]["LUSTERWAREWEIGHT"].ToString();
                context.Response.Write(new JsonResult(LUSTERWAREWEIGHT).ToJson());
                }
            else {
                    string meagss = "传入的参数不正确";
                context.Response.Write(new JsonResult(meagss).ToJson());
            }
        }
    }


    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}