<%@ WebHandler Language="C#" Class="getProcedure" %> using System; using System.Web; using System.Web.SessionState; using System.Data; using System.Text; using System.Collections; using System.Collections.Generic; using Newtonsoft.Json; using Newtonsoft.Json.Linq; using Curtain.DataAccess; using DK.XuWei.WebMes; public class getProcedure : IHttpHandler, IReadOnlySessionState { public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; using(IDataAccess conn = DataAccess.Create()) { DataTable dt = conn.ExecuteDatatable(@" SELECT PROCEDUREID AS ID, PROCEDURECODE AS CODE, PROCEDURENAME AS NAME FROM TP_PC_PROCEDURE WHERE VALUEFLAG = '1' AND PROCEDURENAME LIKE '1#%' ORDER BY NODENO "); context.Response.Write(dt.ToJson()); } } public bool IsReusable { get { return false; } } }