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

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

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 GetProductCheckDefect : IHttpHandler, IReadOnlySessionState
{
    public void ProcessRequest(HttpContext context)
    {
        using (IDataAccess conn = DataAccess.Create())
        {
            string sqlStr = @"
                SELECT
	                DEFECTTYPEID, --缺陷类别编号
	                DEFECTID, --缺陷编号
	                DEFECTCODE, --缺陷编码
	                DEFECTNAME --缺陷名称
                FROM
	                TP_MST_DEFECT 
                WHERE
	                VALUEFLAG = '1' --有效标识
                    AND DEFECTTYPEID > 0
                ORDER BY
	                DEFECTTYPEID, --缺陷类别编号
	                DISPLAYNO --显示顺序
                ";
            context.Response.Write(new JsonResult(conn.ExecuteDatatable(sqlStr)).ToJson());
        }
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}