HEGII.gt.mes.check/wwwroot/main/PreProductCheck/api/GetLogo.ashx

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

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>
/// 获取 商标信息
/// xuwei 2022-04-18
/// </summary>
public class GetGoodsRepair : IHttpHandler, IRequiresSessionState
{
    public void ProcessRequest(HttpContext context)
    {
        using (IDataAccess conn = DataAccess.Create())
        {
            DataTable dt = conn.ExecuteDatatable(@"
                   SELECT
                    ROWNUM,
                    T.LOGOID,
                    T.LOGONAME
                    FROM(
                    SELECT
	                    TML.LOGOID,
	                    TML.LOGONAME
                    FROM
	                    TP_PM_GROUTINGDAILYDETAIL TPGD
	                    LEFT JOIN TP_MST_LOGO TML ON TPGD.LOGOID = TML.LOGOID 
                    WHERE
	                    BARCODE = @BARCODE@
	                    UNION ALL
                    SELECT
	                    LOGOID,
	                    LOGONAME
                    FROM
	                    TP_MST_LOGO 
                    WHERE
	                    VALUEFLAG = 1 
	                    AND LOGOID NOT IN ( SELECT TML.LOGOID FROM TP_PM_GROUTINGDAILYDETAIL TPGD LEFT JOIN TP_MST_LOGO TML ON TPGD.LOGOID = TML.LOGOID WHERE BARCODE = @BARCODE@ )
	                    )T ORDER BY ROWNUM ASC
                ",
                new CDAParameter("BARCODE", context.Request["barcode"] is object ? context.Request["barcode"].ToString() : "0")
                );
            context.Response.Write(new JsonResult(dt).ToJson());
        }
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}