<%@ WebHandler Language="C#" Class="mesPackingIndex" %> using System; using System.Web; using System.Data; using Curtain.DataAccess; using DK.XuWei.WebMes; ///

/// 当日经过3#卸窑的光瓷重量 /// xuwei 2020-08-20 ///

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; } } }