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

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


using System;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.SessionState;
using System.Web.Configuration;
using System.Collections;
using System.Collections.Generic;
using System.Collections.Specialized;
using System.Configuration;

using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using Curtain.DataAccess;
using Curtain.Log;
using DK.XuWei.WebMes;


/// <summary>
/// 获取 当前产品的可变商标(附件绑定)
/// qq 2024-10-17
/// </summary>
public class GetLogoDataByFJBD : IHttpHandler, IReadOnlySessionState
{
    public void ProcessRequest(HttpContext context)
    {
        using (IDataAccess conn = DataAccess.Create())
        { 
            DataTable dtLogo = conn.ExecuteDatatable(@"
                SELECT L.LOGOID AS ID,
                        L.LOGONAME || '[' || case when instr( T2.materialremark ,'智能一体机陶瓷体')= 1 then substr(T2.materialremark,9,length(T2.materialremark))
                          when instr( T2.materialremark ,'落地式坐便器')= 1 then substr(T2.materialremark,7,length(T2.materialremark))
                            when instr( T2.materialremark ,'智能一体机')= 1 then substr(T2.materialremark,6,length(T2.materialremark))
                              when instr( T2.materialremark ,'电控一体机')= 1 then substr(T2.materialremark,6,length(T2.materialremark))
                            else T2.materialremark   end || ']' AS NAME,
                        T2.MATERIALCODE,
                        NVL(GDD.VALUEFLAG, '0') AS ISCURRENTLOGO
                        ,0 AS ISCONTROL
                    FROM TP_MST_LOGO L
                    INNER JOIN (SELECT DISTINCT T.GOODSID,
                                                T.LOGOID,
                                                T.MATERIALCODE,
                                                T.materialremark
                                FROM (SELECT G.GOODSID,
                                            G.LOGOID,
                                            G.MATERIALCODE,
                                            G.materialremark
                                        FROM TP_MST_GOODS G
                                        UNION ALL
                                        SELECT S.GOODSID,
                                            S.LOGOID,
                                            S.MATERIALCODE,
                                            S.materialremark
                                        FROM TP_MST_GOODSLOGOSAP S) T
                                WHERE EXISTS (SELECT 1
                                        FROM TP_PM_GROUTINGDAILYDETAIL G
                                        WHERE G.GOODSID = T.GOODSID
                                        AND G.BARCODE = @BARCODE@)) T2
                    ON T2.LOGOID = L.LOGOID
                    LEFT JOIN TP_PM_GROUTINGDAILYDETAIL GDD
                    ON GDD.LOGOID = L.LOGOID
                    AND GDD.BARCODE = @BARCODE@
                    WHERE L.VALUEFLAG = '1'
                    AND L.ACCOUNTID = @ACCOUNTID@
                    ORDER BY L.DISPLAYNO ",
                new CDAParameter("BARCODE", context.Request["barCode"]),
                new CDAParameter("ACCOUNTID", HttpContext.Current.Session["accountId"])
            );
            context.Response.Write(new JsonResult() { success = true, message = "操作成功！", rows = dtLogo }.ToJson());
             
        }
    }


    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}