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

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

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 GetWorkStationSetting : IHttpHandler, IReadOnlySessionState
{
    public void ProcessRequest(HttpContext context)
    {
        using (IDataAccess conn = DataAccess.Create())
        {
            //检查工号是否配置了工位
            string isWorkStation = conn.ExecuteScalar(@"
                SELECT 
                    COUNT(*)
                FROM
                    TP_MST_WORKSTATIONUSER u
                    LEFT JOIN TP_MST_WORKSTATION w ON u.WORKSTATIONID = w.WORKSTATIONID
                WHERE 
                    w.VALUEFLAG = '1'
                    AND u.VALUEFLAG = '1'
                    AND u.USERCODE = @USERCODE@
            ",
                new CDAParameter("USERCODE", context.Request["userCode"])
            ).ToString();

            if(isWorkStation != "0")
            {
                //已配置工位
                context.Response.Write(new JsonResult( JsonStatus.success ).ToJson());
            }
            else
            {
                //未配置工位
                context.Response.Write(new JsonResult(JsonStatus.otherError ).ToJson());
            }

        }
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}