asp.net 一般处理程序

一般处理程序类似公共模块，所有页面都可以调用。

一般处理程序

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

using System;

using System.Web;

public class SetGrid : IHttpHandler {

    public void ProcessRequest (HttpContext context) {

        string sql = "";

        System.Data.DataTable dtTmp = null;

        string sf = "";

        string result = "";

        try

        {

            switch (context.Request["oper"])

            {

                case "Supplier"://供应商

                    sql = "select ID,abbreviation,name,linkman1,Tel,trmo,currency,cess from provider";

                    if (!string.IsNullOrEmpty(context.Request["q"]))

                    {

                        sf = context.Request["q"].ToString().Trim();

                        sql += " where abbreviation like '%" + sf + "%' or linkman1 like '%" + sf + "%' or name like '%" + sf + "%' or Tel like '%" + sf + "%'";

                    }

                    dtTmp = pubCommon.GetDataTable(sql);

                    result = pubCommon.DataTableToJson(dtTmp);

                    //result = "[{\"si_name\":\"三菱\",\"si_linkman\":\"村上\",\"si_mobile\":\"12-002136\"},{\"si_name\":\"西门西\",\"si_linkman\":\"Jon\",\"si_mobile\":\"0223-26565\"}]";

                    break;

                case "PODetail":

                    sql = "select 1 as gi_id,*,12 as pi_number,12 as qty from materiel where code = '110010030092'";

                    dtTmp = pubCommon.GetDataTable(sql);

                    if (dtTmp != null)

                    {

                        result = pubCommon.DataTableToJson(dtTmp);

                    }

                    break;

                case "Query":

                    sql = "select * from materiel";

                    dtTmp = pubCommon.GetDataTable(sql);

                    if (dtTmp != null)

                    {

                        result = pubCommon.DataTableToJson(dtTmp);

                    }

                    break;

            }

        }

        catch (Exception ex)

        {

        }

        context.Response.Write(result);

        context.Response.End();

    }

    public bool IsReusable {

        get {

            return false;

        }

    }

}

脚本

    //供应商

    $('#gys_key').combogrid({

        panelWidth: 350,

        delay: 500,

        mode: 'remote',

        idField: 'ID',

        textField: 'abbreviation',

        url: '/Project2/Dispose/SetGrid.ashx?oper=Supplier',

        columns: [[

                        { field: 'abbreviation', title: '简称', width: 80 },

                        { field: 'name', title: '供应商名称', width: 120 },

                        { field: 'linkman1', title: '联系人', width: 80 },

                        { field: 'Tel', title: '电话', width: 100 }

                    ]],

        onSelect: function (rowIndex, rowData) {

            $("#txtTax").val(rowData.cess);

            $("#txtpay").val(rowData.trmo);

            $("#txtcurrency").val(rowData.currency);

        }

    });