HEGII.gt.mes.check/wwwroot/main/PreProductCheck/api/GetWaterLabelCode.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
                     NVL(GLS.waterlabelcode, G.WaterLabelCode) WaterLabelCode 
                    FROM
                      TP_PM_GROUTINGDAILYDETAIL TPGL
                       INNER JOIN TP_MST_GOODS G
                                   ON G.GOODSID = TPGL.GOODSID
                                   LEFT JOIN TP_MST_GOODSLOGOSAP GLS
                                   ON G.GOODSID = GLS.GOODSID
                                  AND GLS.LOGOID = TPGL.LOGOID
                    WHERE
	                    TPGL.BARCODE = @BARCODE@
                ",
                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;
        }
    }

}