C# 一般处理程序

C#一般处理程序

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

using System.Web;
using System.Data;
using System.Text;
using System.Data.SqlClient;

public class GetWaterUser : IHttpHandler
{
    public void ProcessRequest(HttpContext context)
    {
        context.Response.ContentType = "text/plain";
        //指定字符集
        context.Response.ContentEncoding = Encoding.UTF8;
        string Content = context.Request["hhs"];
        using (SqlConnection conn = new SqlConnection("Data Source=10.0.0.205,1433;Initial Catalog=zhpt;UID=sa;PWD=tszls2020!"))
        {
            conn.Open();
            using (SqlCommand cmd = new SqlCommand())
            {
                DataTable dt = new DataTable();
                cmd.Connection = conn;
                cmd.CommandText = "SELECT * FROM ysh_xx where hh in(" + Content + ")";//
                SqlDataAdapter ada = new SqlDataAdapter(cmd);
                ada.Fill(dt);
                string json = DataTableJson(dt);
                context.Response.ContentType = "text/plain";
                context.Response.Write(json);
            }
        }
    }

    public static string DataTableJson(DataTable dt)
    {
        StringBuilder jsonBuilder = new StringBuilder();
        jsonBuilder.Append("[");
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            jsonBuilder.Append("{");
            for (int j = 0; j < dt.Columns.Count; j++)
            {
                jsonBuilder.Append("\"");
                jsonBuilder.Append(dt.Columns[j].ColumnName);
                jsonBuilder.Append("\"");
                jsonBuilder.Append(":");
                jsonBuilder.Append("\"");
                jsonBuilder.Append(dt.Rows[i][j].ToString());
                jsonBuilder.Append("\"");
                jsonBuilder.Append(",");
            }
            jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
            jsonBuilder.Append("},");
        }
        jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
        jsonBuilder.Append("]");
        return jsonBuilder.ToString().Replace("\n", "").Replace(" ", "").Replace("\t", "").Replace("\r", ""); ;
    }
    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}

请求方式：

var waterUrl = http://IP地址/GetWaterUser.ashx";
code :户号 精确查询   可传多个 例如："1001,1002,1300"

$.ajax({
                //请求方式
                type: "post",
                //请求地址
                url: waterUrl,
                //数据，json字符串
                data: { hhs: code },
                //请求成功
                success: function (result) {
                    if (result != "]") {result = JSON.parse(result);}
	}