IMEX.mes.check/wwwroot/main/ProductCheck/api/GetCompleteProcedureIDPDANew_WCF.ashx

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

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

/// <summary>
/// 从WCF接口获取 产品信息
/// xuwei 2019-10-26
/// </summary>
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;
        }
    }

}