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

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

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 GetWorkStation : IHttpHandler, IReadOnlySessionState
{
    public void ProcessRequest(HttpContext context)
    {
        using (IDataAccess conn = DataAccess.Create())
        {
            DataTable dt = new DataTable();
            if (context.Request["PROCEDUREID"] == "9999")
            {
                dt = conn.ExecuteDatatable(@"
                    SELECT T.WORKSTATIONTYPEID AS TYPEID,
                           REPLACE(REPLACE(T.WORKSTATIONTYPEURL, '@procedureid', W.PROCEDUREID)
                                  ,'@modeltype'
                                  ,P.MODELTYPE) AS TYPEURL,
                           W.PROCEDUREID,
                           W.WORKSTATIONID AS ID,
                           W.WORKSTATIONNAME AS NAME,
                           W.PCCODE
                      FROM TP_MST_WORKSTATION W
                      LEFT JOIN TP_SYS_WORKSTATIONTYPE T
                        ON T.WORKSTATIONTYPEID = W.WORKSTATIONTYPEID
                      LEFT JOIN TP_MST_WORKSTATIONUSER WU
                        ON WU.WORKSTATIONID = W.WORKSTATIONID
                      LEFT JOIN TP_MST_USER U
                        ON U.USERID = WU.USERID
                      LEFT JOIN TP_PC_PROCEDURE P
                        ON P.PROCEDUREID = W.PROCEDUREID
                     WHERE W.VALUEFLAG = '1'
                       AND U.USERCODE = @USERCODE@
                       AND W.PROCEDUREID IS NULL
                     ORDER BY W.WORKSTATIONNAME ",
                new CDAParameter("USERCODE",context.Request["UserCode"]),
                new CDAParameter("PROCEDUREID",context.Request["PROCEDUREID"])
                );
            }
            else
            {
                dt = conn.ExecuteDatatable(@"
                    SELECT T.WORKSTATIONTYPEID AS TYPEID,
                           REPLACE(REPLACE(T.WORKSTATIONTYPEURL, '@procedureid', W.PROCEDUREID)
                                  ,'@modeltype'
                                  ,P.MODELTYPE) AS TYPEURL,
                           W.PROCEDUREID,
                           W.WORKSTATIONID AS ID,
                           W.WORKSTATIONNAME AS NAME,
                           W.PCCODE
                      FROM TP_MST_WORKSTATION W
                      LEFT JOIN TP_SYS_WORKSTATIONTYPE T
                        ON T.WORKSTATIONTYPEID = W.WORKSTATIONTYPEID
                      LEFT JOIN TP_MST_WORKSTATIONUSER WU
                        ON WU.WORKSTATIONID = W.WORKSTATIONID
                      LEFT JOIN TP_MST_USER U
                        ON U.USERID = WU.USERID
                      LEFT JOIN TP_PC_PROCEDURE P
                        ON P.PROCEDUREID = W.PROCEDUREID
                     WHERE W.VALUEFLAG = '1'
                       AND U.USERCODE = @USERCODE@
                       AND (@PROCEDUREID@ = '0' OR  W.PROCEDUREID = @PROCEDUREID@)
                     ORDER BY W.WORKSTATIONNAME ",
                new CDAParameter("USERCODE",context.Request["UserCode"]),
                new CDAParameter("PROCEDUREID",context.Request["PROCEDUREID"])
                );
            }
            
            context.Response.Write(new JsonResult(dt).ToJson());
        }
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}