asp.net 无刷新分页实例代码

517人浏览 / 0人评论

数据类代码：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using System.Reflection;

namespace DAL
{
    public class UserManageClass
    {
        ///
        /// 取得总页数
        ///
        /// 总页数
        public int GetPageCount()
        {
            int counts;
            string SqlStr = "select count(0) from [User]";
            counts = new SQLHelper().Content(SqlStr, CommandType.Text);
            return counts;
        }
        ///
        /// 取出每一页的内容
        ///
        /// 开始页数
        /// 结束页数
        /// 每一页的内容
        public DataTable GetPageDate(string SatrPage, string EndPage)
        {
            DataTable dt;
            string SqlStr = @"select * from
            (select *, ROW_NUMBER() over(order by id)as no_ from [User])aa
            where aa.no_ between '"+SatrPage+"' and '"+EndPage+"'";
            dt = new SQLHelper().ExecuteQuery(SqlStr, CommandType.Text);
            return dt;
        }

        ///
        /// 将一个DataTable转换成列表
        ///
        /// 实体对象的类型
        /// 要转换的DataTable
        ///
        public List DataTableToEntityList(DataTable dt)
        {
            List entiyList = new List();

Type entityType = typeof(T);
PropertyInfo[] entityProperties = entityType.GetProperties();

            foreach (DataRow row in dt.Rows)
            {
                T entity = Activator.CreateInstance();

                foreach (PropertyInfo propInfo in entityProperties)
                {
                    if (dt.Columns.Contains(propInfo.Name))
                    {
                        if (!row.IsNull(propInfo.Name))
                        {
                            propInfo.SetValue(entity, row[propInfo.Name], null);
                        }
                    }
                }

entiyList.Add(entity);
}

return entiyList;
}

}
}

PageService.ashx.cs一般处理程序代码：

复制代码代码如下:

using System;
using System.Collections;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Xml.Linq;
using System.Data.SqlClient;
using DAL;
using System.Web.Extensions;
using System.Web.Script.Serialization;
using Model;
using System.Web.UI.MobileControls;
using System.Collections.Generic;

namespace LandingSystem
{
    ///
    /// $codebehindclassname$ 的摘要说明
    ///
    [WebService(Namespace = "http://tempuri.org/")]
    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
    public class PageService : IHttpHandler
    {

        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType = "text/plain";
            string action = context.Request["action"];
            if (action == "GetPageCount")
            {
                int counts = new UserManageClass().GetPageCount();
                int page = counts / 3;
                if (counts % 3 != 0)
                {
                    page++;
                }
                context.Response.Write(page);
            }
            else if (action == "GetPageData")
            {
                int pageNo = Convert.ToInt32(context.Request["PageNo"]);
                string SatrPage = ((pageNo - 1) * 3 + 1).ToString();
                string EndPage = (pageNo * 3).ToString();
                DataTable dt= new UserManageClass().GetPageDate(SatrPage, EndPage);
                IList data = ModelConvertHelper.ConvertToModel(dt);
               // IList data = new UserManageClass().DataTableToEntityList(dt);
                var p1 = data.Select(c => new { c.Name,c.Phone});
                #region 废物代码
                // var p1 = data.Select( c => new { c.Name,c.Phone});
                //var p1=data.Select(dr=>new {dr["Name"].ToString(),dr["Phone"].ToString()});

//var T_model = new List();
//var p3 = T_model.Select(c => new { c.Name, c.Phone });

                //var p2=data.Select(c=>new {})
                #endregion
                JavaScriptSerializer jss = new JavaScriptSerializer();
                context.Response.Write(jss.Serialize(p1));
            }
        }

        public bool IsReusable
        {
            get
            {
                return false;
            }
        }
    }
}

aspx页面代码：

复制代码代码如下:

无标题页

$(function(){
//-----------------------------------------------------------
function getPageData(pageNo){ //取得某页数据的方法
$.post("PageService.ashx",{"action":"GetPageData","PageNo":pageNo},function(data,status){
if(status=="success"){
$("#Comment").empty();
var comments=$.parseJSON(data); //反序列化json数据。
for(var i=0;ivar row=comments[i];
var li= $("

"+row.Name+" : "+row.Phone+"

");
$("#Comment").append(li); //每取出一条数据就创建一个li并append到Comment/ul内。
}
}
});
}
//-------------------------------------------------------------------
getPageData(1); //首次进入页面，看到的是第一页的数据
//----------------------------------------------------------------/
//取得所有的页数并且初始化分页按钮
$.post("PageService.ashx",{"action":"GetPageCount"},function(data,status){
if(status=="success"){
var tr1=$("");
var pageNo=parseInt(data);
for(var i=1;i<=pageNo;i++){
var td=$(""+i+"");
tr1.append(td);
}
$("#pageNo").append(tr1);
$("#pageNo a").click(function(e){ //页码创建后，就为每一个页码监听一个click事件。
e.preventDefault(); //取消a的默认跳转行为
getPageData($(this).html()); //点击后就去执行取页数据的操作。
});
}
});
//----------------------------------------------------------------------------
});

    页数：

ModelConvertHelper.cs（将datatable转换为list通用类）代码：

复制代码代码如下:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Collections;
using System.Data;
using System.Reflection;

namespace DAL
{
    public class ModelConvertHelper where T : new ()
    {
        public static IList ConvertToModel(DataTable dt)
        {
         IList ts = new List();
        Type type=typeof(T);
        string tempName = "";
        foreach (DataRow dr in dt.Rows)
        {
            T t = new T();
            // 获得此模型的公共属性
            PropertyInfo[] propertys = t.GetType().GetProperties();
            foreach (PropertyInfo pi in propertys)
            {
                tempName = pi.Name;
                // 检查DataTable是否包含此列
                if (dt.Columns.Contains(tempName))
                {
                    // 判断此属性是否有Setter
                    if (!pi.CanRead) continue;
                    object value = dr[tempName];
                    if (value != DBNull.Value)
                        if (pi.PropertyType == typeof(int))
                        {
                            pi.SetValue(t, Convert.ToInt32(value), null);
                        }
                        else if (pi.PropertyType == typeof(string))
                        {
                            pi.SetValue(t, value.ToString(), null);
                        }
                        //pi.SetValue(t, value, null);
                }
            }
            ts.Add(t);
        }
        return ts;
        }


    }
}