<%@ 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 void ProcessRequest(HttpContext context)
    {
        context.Response.ContentType = "text/plain";

        using (IDataAccess conn = DataAccess.Create())
        {
            DataTable dt = new DataTable();
                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 IN ( 103 )
		                AND TPPD.CREATETIME >= trunc( SYSDATE )
	                GROUP BY
		                TPPD.GOODSCODE,
	                TMG.LUSTERWAREWEIGHT
	                ) T
				"
            );
            var LUSTERWAREWEIGHT =  dt.Rows[0]["LUSTERWAREWEIGHT"].ToString();
            context.Response.Write(new JsonResult(LUSTERWAREWEIGHT).ToJson());
        }
    }


    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}