HEGII.ss.mes.check/wwwroot/main/Login/api/GetWorkStationUser.ashx

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

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 GetWorkStationUser : IHttpHandler, IReadOnlySessionState
{
    public void ProcessRequest(HttpContext context)
    {
        using (IDataAccess conn = DataAccess.Create())
        {
            DataTable dt = conn.ExecuteDatatable(@"
                SELECT
                    d.USERID,
                    d.USERCODE,
	                s.STAFFID,
                    s.STAFFCODE,
	                s.STAFFNAME,
                    j.JOBSID,
                    j.JOBSNAME
                FROM
	                TP_MST_WORKSTATIONUSERDETAIL d
                    LEFT JOIN TP_MST_WORKSTATIONUSER u ON u.USERCODE = d.USERCODE
					LEFT JOIN TP_MST_WORKSTATION w ON w.WORKSTATIONID = u.WORKSTATIONID
					LEFT JOIN TP_HR_STAFF s ON s.STAFFID = d.STAFFID 
                    LEFT JOIN TP_MST_JOBS j ON j.JOBSID = d.UJOBSID
                WHERE
	                d.VALUEFLAG = '1'
                    AND d.USERCODE = @USERCODE@
                    AND w.WORKSTATIONID = @WORKSTATIONID@
                    AND s.STAFFSTATUS <> 3
                ORDER BY
	                s.STAFFCODE
                ",
                    new CDAParameter("USERCODE", context.Request["UserCode"]),
                    new CDAParameter("WORKSTATIONID", context.Request["WorkstationId"])
                );
            context.Response.Write(new JsonResult(dt).ToJson());
        }
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}