首页 > 代码库 > asp.net 一般处理程序

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;        }    }}
View Code

 

脚本

    //供应商    $(‘#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);        }    });

 

asp.net 一般处理程序