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

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

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

/// <summary>
/// 从WCF接口获取 产品质量登记工序 modeltype = -1
/// xuwei 2019-10-26
/// </summary>
public class GetProductCheckProcedure : IHttpHandler, IReadOnlySessionState
{
    public void ProcessRequest(HttpContext context)
    {
        //读取成检工序
        using (IDataAccess conn = DataAccess.Create())
        {
            string sqlStr = @"
                SELECT
                    NODENO, --序号
	                PROCEDUREID, --流程编号
	                PROCEDURENAME --流程名称
                FROM
	                TP_PC_PROCEDURE 
                WHERE
	                VALUEFLAG = 1 --有效标识
	                AND MODELTYPE = - 1 --工序模型
                ORDER BY
	                NODENO
                ";

            context.Response.Write(new JsonResult( conn.ExecuteDatatable(sqlStr)).ToJson());
        }
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}