HEGII.ss.mes.check/wwwroot/main/PreProductCheck/api/GetWorkStationInfo.ashx

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

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>
/// 获取 工位相关信息
/// </summary>
public class GetWorkStationInfo : IHttpHandler, IReadOnlySessionState
{
    public void ProcessRequest(HttpContext context)
    {
        using (IDataAccess conn = DataAccess.Create())
        {
            DataTable dt = conn.ExecuteDatatable(@"
            SELECT W.WORKSTATIONNAME || '【' ||
                   (SELECT LISTAGG(TO_CHAR(S.STAFFNAME), '，') WITHIN GROUP(ORDER BY S.STAFFNAME)
                      FROM TP_PC_CLASSESDETAIL T
                      LEFT JOIN TP_HR_STAFF S
                        ON S.STAFFID = T.STAFFID
                     WHERE T.CLASSESSETTINGID = (SELECT MAX(CD.CLASSESSETTINGID)
                                                   FROM TP_PC_CLASSESDETAIL CD
                                                  WHERE CD.USERID = @USERID@)) || '】' AS WORKSTATIONINFO
              FROM TP_MST_WORKSTATION W
             WHERE W.USERCODE = @USERCODE@
            ",
                new CDAParameter("USERID", context.Session["UserID"].ToString()),
                new CDAParameter("USERCODE", context.Session["userCode"].ToString())
            );
            context.Response.Write(new JsonResult(dt).ToJson());
        }
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}