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

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 GetClassesUser : IHttpHandler, IReadOnlySessionState
{
    public void ProcessRequest(HttpContext context)
    {
        using (IDataAccess conn = DataAccess.Create())
        {
            DataTable dt = conn.ExecuteDatatable(@"
                SELECT
	                D.USERID,
	                D.USERCODE,
	                WMSYS.WM_CONCAT ( D.STAFFID ) AS STAFFID, 
	                WMSYS.WM_CONCAT ( D.UJOBSID ) AS UJOBSID 
                FROM
	                TP_PC_CLASSESDETAIL D 
                WHERE
	                --CLASSESSETTINGID = ( SELECT MAX( CLASSESSETTINGID ) FROM TP_PC_CLASSESSETTING WHERE ACCOUNTDATE = TRUNC( SYSDATE ) AND USERCODE = @USERCODE@ ) 
	                CLASSESSETTINGID = ( SELECT MAX( CLASSESSETTINGID ) FROM TP_PC_CLASSESSETTING WHERE USERCODE = @USERCODE@ ) 
                GROUP BY
	                D.USERID,
	                D.USERCODE
                ",
                    new CDAParameter("USERCODE", context.Request["UserCode"])
                );
            context.Response.Write(new JsonResult(dt).ToJson());
        }
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}