HEGII.ss.mes.check/wwwroot/main/ProductCheckPlus/api/GetProductCheckDefectPosition.ashx

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

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;

/// <summary>
/// 从WCF接口获取 产品缺陷类别
/// xuwei 2019-10-26
/// </summary>
public class GetProductCheckDefectPosition : IHttpHandler, IReadOnlySessionState
{
    public void ProcessRequest(HttpContext context)
    {
        using (IDataAccess conn = DataAccess.Create())
        {
            string sqlStr = @"
                SELECT
	                DEFECTPOSITIONID, --位置编号
	                DEFECTPOSITIONCODE, --位置编码
	                DEFECTPOSITIONNAME --位置名称
                FROM
	                TP_MST_DEFECTPOSITION 
                WHERE
	                VALUEFLAG = '1' --有效标识
                ORDER BY
	                DISPLAYNO --显示顺序
                ";
            context.Response.Write(new JsonResult(conn.ExecuteDatatable(sqlStr)).ToJson());
        }
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}