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

/// 从WCF接口获取 产品信息 /// xuwei 2019-10-26 ///

public class GetCompleteProcedureIDPDANew_WCF : IHttpHandler, IRequiresSessionState { public void ProcessRequest(HttpContext context) { using (IDataAccess conn = DataAccess.Create()) { DataTable dt = conn.ExecuteDatatable(@" SELECT pd.productiondataid ,pmax.productiondataid pmaxproductiondataid ,pmax.procedureid COMPLETEPROCEDUREID ,pmax.ProcedureID ,pmax.ProductionLineID ,pmax.ProductionlineCode ,pmax.ProductionlineName ,pmax.ProcedureCode ,pmax.ProcedureName ,pmax.ProcedureModel ,pmax.ModelType ,pmax.OrganizationID ,pmax.GOODSID ,pmax.GOODSCODE ,pmax.GOODSNAME FROM tp_pm_productiondata pd LEFT JOIN tp_pm_productiondata pmax ON pmax.groutingdailydetailid = pd.groutingdailydetailid AND pmax.productiondataid < pd.productiondataid AND pmax.valueflag = '1' AND pmax.procedureid IN (13, 35) WHERE pd.barcode = @BARCODE@ AND pd.valueflag = 1 AND pd.procedureid = 15 order by pmax.productiondataid desc /* GROUP BY pd.productiondataid ,pmax.procedureid ,pmax.ProductionLineID ,pmax.ProductionlineCode ,pmax.ProductionlineName ,pmax.ProcedureCode ,pmax.ProcedureName ,pmax.ProcedureModel ,pmax.ModelType ,pmax.OrganizationID ,pmax.GOODSID ,pmax.GOODSCODE ,pmax.GOODSNAME*/ ", new CDAParameter("BARCODE", context.Request["barcode"]) ); context.Response.Write(new JsonResult(dt).ToJson()); } } public bool IsReusable { get { return false; } } }