HEGII.gt.mes.check/wwwroot/main/PreProductCheck/api/GetUserCodeCheckNum.ashx

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

using System.Web;
using System.Web.SessionState;
using System.Web.Configuration;
using Newtonsoft.Json.Linq;
using Curtain.DataAccess;
using Curtain.Log;
using DK.XuWei.WebMes;
using System.Data;

public class GetUserCodeCheckNum : IHttpHandler
{

    public void ProcessRequest(HttpContext context)
    {
        context.Response.ContentType = "text/plain";

        using (IDataAccess conn = DataAccess.Create())
        {
            DataTable dt = conn.ExecuteDatatable(@"
                SELECT P.USERCODE AS 工号, COUNT(DISTINCT P.BARCODE) AS 产量
                FROM   TP_PM_PRODUCTIONDATA P
                WHERE  P.PROCEDUREID IN (10, 16)
                      --AND P.VALUEFLAG = 1
                       AND P.CREATETIME > TRUNC(SYSDATE)
                       AND INSTR(P.USERCODE,'Z') = 1
                GROUP  BY USERCODE
                ORDER  BY P.USERCODE
            ");
            context.Response.Write(new JsonResult(dt).ToJson());
        }

    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}