PrecompiledWeb/WebUI/AjaxTable1.ashx

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

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

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

using System;
using System.Web;
using System.Data;
using System.Text;
using DAL;
using System.Data .SqlClient ;
public class AjaxTable1 : 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"];
        int TableKeyVal = int.Parse(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>
    /// 发送当前表里所有信息(不分页)