WebUI/AjaxTable.ashx

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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

using System;
using System.Web;
using System.Data;
using System.Text;
using DAL;
using System.Data.SqlClient;
public class AjaxTable : IHttpHandler {
    
    public void ProcessRequest (HttpContext context) {
        context.Response.ContentType = "text/plain";
        if (context.Request.Form["_type"] != null)
        {
            switch (context.Request.Form["_type"])
            {
                case "_DownPageAllPageNum": SendAllPageNum(context); break;
                case "_DownDQPageInfoArray": SendPageInfoArray(context); break;
                case "_DownDQPageInfoArray_all": SendAllPageInfoArray(context); break;
                case "_DataRowDel": SendDelIsTrue(context); break;
                case "_DownPageAllCount": SendAllCount(context); break;
                default: break;
            } 
        }
    }
    SQLHelper sqh = new SQLHelper();
    /// <summary>
    /// 删除一条数据
    /// </summary>
    /// <param name="context"></param>
    private void SendDelIsTrue(HttpContext context)
    {
        string TableName = context.Request.Form["_TableName"];
        string TableKey = context.Request.Form["_TableKey"];
        string  TableKeyVal =context.Request.Form["_TableKeyVal"].ToString ();
        string SelectWhere = context.Request.Form["_SelectWhere"];
        string SqlStr = "";
        if (SelectWhere.Length != 0)
        {
            SqlStr = "delete from " + TableName + " where " + TableKey + "='" + TableKeyVal + "' and " + SelectWhere;
        }
        else
        {
            SqlStr = "delete from " + TableName + " where " + TableKey + "='" + TableKeyVal + "'";
        }
        int i = sqh.ExecuteNonQuery(SqlStr);
        if (i>0)
        {
            context.Response.Write("true");
        }
        else
        {
            context.Response.Write("false"); 
        }
    }
    
    /// <summary>
    /// 发送当前表里所有信息(不分页)
    /// </summary>
    /// <param name="context"></param>