/// <summary>  
 /// 酒店評(píng)論列表-分頁(yè)  
/// </summary>  
/// <param name="userId"></param>  
/// <param name="pageIndex">當(dāng)前頁(yè)</param>  
/// <param name="pageCount">總頁(yè)數(shù)</param>  
/// <returns></returns>  
 public static List<CommentInfo> GetHotelCommentList(int userId, int pageIndex, out int pageCount)  
 {  
     var list = new List<CommentInfo>();  
     pageCount = 0;  
     try  
     {  
         //查詢酒店ID,名字,圖片,用戶ID,用戶評(píng)論  
         string sql = string.Format( @"select hotels.hid,hotels.hotelName,hotels.images,hotelorder.UserID,user_HotelComment.comment from hotels with(nolock) join hotelorder with(nolock) join user_HotelComment   
telorder.UserID=user_HotelComment.userID on hotels.hid=hotelorder.HotelID where hotelorder.UserID={0}", userId);  
         DataTable dt = SQLHelper.Get_DataTable(sql, SQLHelper.GetCon(), null);  
         if (dt != null && dt.Rows.Count > 0)  
         {  
             list = (from p in dt.AsEnumerable()  //這個(gè)list是查出全部的用戶評(píng)論  
                     select new CommentInfo  
                     {  
                         Id = p.Field<int>("hid"), //p.Filed<int>("Id") 其實(shí)就是獲取DataRow中ID列。即：row["ID"]  
                         HotelImages = p.Field<string>("images"),  
                         HotelName = p.Field<string>("hotelName"),  
                         Comment = p.Field<string>("comment")  
                     }).ToList(); //將這個(gè)集合轉(zhuǎn)換成list  
             int pageSize = 10; //每頁(yè)顯示十條數(shù)據(jù)  
  
             //獲取總頁(yè)數(shù)  
             pageCount = list.Count % pageSize == 0 ? ((list.Count - pageSize >= 0 ? (list.Count / pageSize) : (list.Count == 0 ? 0 : 1))) : list.Count / pageSize + 1;  
  
             //這個(gè)list 就是取到10條數(shù)據(jù)  
             //Skip跳過(guò)序列中指定數(shù)量的元素，然后返回剩余的元素。  
             //Take序列的開(kāi)頭返回指定數(shù)量的連續(xù)元素。  
             list = list.Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList(); //假設(shè)當(dāng)前頁(yè)為第三頁(yè)。這么這里就是跳過(guò) 10*(3-1) 即跳過(guò)20條數(shù)據(jù)，Take(pageSize)的意思是:取10條數(shù)據(jù),既然前面已經(jīng)跳過(guò)前20條數(shù)據(jù)了，那么這里就是從21條開(kāi)始，取10條咯  
         }  
     }  
     catch (Exception ex)  
     {  
         // write log here  
     }  
     return list;  
}

using System;  
using System.Collections.Generic;  
using System.Linq;  
using System.Web;  
  
namespace WebApplication1  
{  
    /// <summary>  
    /// 用戶信息  
    /// </summary>  
    public class User  
    {  
        public int Id { get; set; }  
  
        public string UserName { get; set; }  
  
        public int Age { get; set; }  
  
        public int Gender { get; set; }  
    }  
}

using System;  
using System.Collections.Generic;  
using System.Linq;  
using System.Web;  
using JSON.Controllers;  
using System.Data;  
  
namespace WebApplication1  
{  
    public class Class1  
    {  
        /// <summary>  
        /// 將DataTable轉(zhuǎn)換成一個(gè)list  
        /// </summary>  
        /// <returns>返回一個(gè)List<User>對(duì)象</returns>  
        public List<User> TableToList()  
        {  
            string sql = "select  * from T_User"; //T_User表里總共有 id,UserName,Age,Gender四列  
            DataTable dt= SqlHelper.ExecuteDataTable(sql,null);  
            var list = new List<User>(); //創(chuàng)建一個(gè)List<User>的實(shí)例  
            if (dt != null && dt.Rows.Count > 0)  
            {  
                //AsEnumerable()：返回一個(gè)IEnumerable<T> 對(duì)象，其泛型參數(shù) T 為 System.Data.DataRow。  
                list = (from p in dt.AsEnumerable()  
                        select new User  //new一個(gè)User對(duì)象  
                        {  
                            Id = p.Field<int>("id"),//p.Filed<int>("id") 其實(shí)就是獲取DataRow中ID列。即：row["ID"] 然后將它賦值給User類的Id字段。  
                            UserName = p.Field<string>("UserName"),  
                            Age = p.Field<int>("Age"),  
                            Gender = p.Field<int>("Gender")  
                        }).ToList(); //將這個(gè)User類對(duì)象轉(zhuǎn)換成list  
            }  
            int dataCount = list.Count; // 總的數(shù)據(jù)條數(shù)。  
            int pageSize=10;//每頁(yè)顯示多少條數(shù)據(jù)。              
            int pageCount; //總頁(yè)數(shù)。  
            int currentPage=3;//當(dāng)前頁(yè)。--這里假設(shè)當(dāng)前頁(yè)為第3頁(yè)。  
            pageCount = dataCount % pageSize == 0 ? (dataCount < pageSize ? (dataCount==0?0:1): (dataCount / pageSize)) : (dataCount / pageSize + 1); 

 

     //這個(gè)list 就是取到10條數(shù)據(jù)    
            //Skip跳過(guò)序列中指定數(shù)量的元素，然后返回剩余的元素。    
            //Take序列的開(kāi)頭返回指定數(shù)量的連續(xù)元素。    
            list = list.Skip(pageSize * (currentPage - 1)).Take(pageSize).ToList(); //假設(shè)當(dāng)前頁(yè)為第3頁(yè)。這么這里就是跳過(guò) 10*(3-1) 即跳過(guò)20條數(shù)據(jù)，Take(pageSize)的意思是:取10條數(shù)據(jù),既然前面已經(jīng)跳過(guò)前20條數(shù)據(jù)了，那么這里就是從21條開(kāi)始，取10條咯    
            return list;   
        }          
    }  
}