asp.net 無(wú)刷新分頁(yè)實(shí)例代碼

更新時(shí)間：2013年03月19日 09:30:43 作者：

asp.net 無(wú)刷新分頁(yè)實(shí)例代碼，需要的朋友可以參考一下

數(shù)據(jù)類(lèi)代碼：

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
    {
        /// <summary>
        /// 取得總頁(yè)數(shù)
        /// </summary>
        /// <returns>總頁(yè)數(shù)</returns>
        public int GetPageCount()
        {
            int counts;
            string SqlStr = "select count(0) from [User]";
            counts = new SQLHelper().Content(SqlStr, CommandType.Text);
            return counts;
        }
        /// <summary>
        /// 取出每一頁(yè)的內(nèi)容
        /// </summary>
        /// <param name="SatrPage">開(kāi)始頁(yè)數(shù)</param>
        /// <param name="EndPage">結(jié)束頁(yè)數(shù)</param>
        /// <returns>每一頁(yè)的內(nèi)容</returns>
        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;
        }

        /// <summary>
        /// 將一個(gè)DataTable轉(zhuǎn)換成列表
        /// </summary>
        /// <typeparam name="T">實(shí)體對(duì)象的類(lèi)型</typeparam>
        /// <param name="dt">要轉(zhuǎn)換的DataTable</param>
        /// <returns></returns>
        public List<T> DataTableToEntityList<T>(DataTable dt)
        {
            List<T> entiyList = new List<T>();

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

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

                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一般處理程序代碼：

復(fù)制代碼代碼如下:

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
{
    /// <summary>
    /// $codebehindclassname$ 的摘要說(shuō)明
    /// </summary>
    [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<RegisterModel> data = ModelConvertHelper<RegisterModel>.ConvertToModel(dt);
               // IList<RegisterModel> data = new UserManageClass().DataTableToEntityList<RegisterModel>(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<RegisterModel>();
//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頁(yè)面代碼：

復(fù)制代碼代碼如下:

ModelConvertHelper.cs（將datatable轉(zhuǎn)換為list通用類(lèi)）代碼：

復(fù)制代碼代碼如下:

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<T> where T : new ()
    {
        public static IList<T> ConvertToModel(DataTable dt)
        {
         IList<T> ts = new List<T>();
        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;
        }


    }
}