HEGII.ss.mes.check/wwwroot/main/Assemble/api/GetIPData_WCF.ashx

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

using System.Web;
    using System.Data;
using System.Web.SessionState;
using System.Web.Configuration;
using Newtonsoft.Json.Linq;
using Curtain.DataAccess;
using Curtain.Log;
using DK.XuWei.WebMes;

/// <summary>
/// 从WCF接口获取 自动扫描配置信息类型
/// qq 20240520
/// </summary>
public class GetIPData_WCF : IHttpHandler, IReadOnlySessionState
{
    public void ProcessRequest(HttpContext context)
    {
        using (IDataAccess conn = DataAccess.Create())
        {
            DataTable soptypename = conn.ExecuteDatatable(@"
                SELECT  w.workstationid,w.workstationname,wc.barcodeip,wc.idnrkip,wc.scanip,wc.plcip,wc.servicePort
                   FROM tp_mst_workstation  w
                   left join tp_Pc_procedure p on p.procedureid = w.procedureid 
                   left join TP_PM_WORKSTATIONIPCONFIG wc on wc.workstationname = w.workstationname
                   WHERE w.procedureid = @PROCEDUREID@ and w.workstationID = @WORKSTATIONID@  ",
                new CDAParameter("PROCEDUREID", context.Request["id"]),
                new CDAParameter("WORKSTATIONID", context.Request["workstation"])
            );
            context.Response.Write(new JsonResult(soptypename).ToJson());

        }
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}