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>         /// 取得总页数         /// </summary>         /// <returns>总页数</returns>         public int GetPageCount()         {             int counts;             string SqlStr = "select count(0) from [User]";             counts = new SQLHelper().Content(SqlStr, CommandType.Text);             return counts;         }         /// <summary>         /// 取出每一页的内容         /// </summary>         /// <param name="SatrPage">开始页数</param>         /// <param name="EndPage">结束页数</param>         /// <returns>每一页的内容</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>         /// 将一个DataTable转换成列表         /// </summary>         /// <typeparam name="T">实体对象的类型</typeparam>         /// <param name="dt">要转换的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;         } 。

    } } 。

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$ 的摘要说明     /// </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;             }         }     } } 。

<head runat="server">     <title>无标题页</title> 。

  。

    <script src="JS/jquery-latest.js" type="text/javascript"></script>     <script type="text/javascript">  $(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;i<comments.length;i++){  var row=comments[i];  var li= $("<li>"+row.Name+" : "+row.Phone+"</li>");  $("#Comment").append(li); //每取出一条数据就创建一个li并append到Comment/ul内。  }  }  });  }  //-------------------------------------------------------------------  getPageData(1); //首次进入页面，看到的是第一页的数据  //----------------------------------------------------------------/  //取得所有的页数并且初始化分页按钮  $.post("PageService.ashx",{"action":"GetPageCount"},function(data,status){  if(status=="success"){  var tr1=$("<tr></tr>");  var pageNo=parseInt(data);  for(var i=1;i<=pageNo;i++){  var td=$("<td><a href=''>"+i+"</a></td>");  tr1.append(td);  }  $("#pageNo").append(tr1);  $("#pageNo a").click(function(e){ //页码创建后，就为每一个页码监听一个click事件。  e.preventDefault(); //取消a的默认跳转行为  getPageData($(this).html()); //点击后就去执行取页数据的操作。  });  }  });  //----------------------------------------------------------------------------  });  </script>  </head> <body> <table>     <tr>         <td>         <ul id="Comment"></ul>         </td>     </tr> </table>     <br />     页数：     <table id="pageNo"></table> </body> </html> 。

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;         }          } } 。