MVC+EasyUI+三层新闻网站建立 分页查询数据功能（七）_实用技巧_

 /// 
 /// 分页查询 /// 
 /// 分页开始条数 /// 分页结束条数 /// 返回查询到的list集合 public List GetPageEntityList(int start,int end) { string sql = "select * from(select row_number()over(order by id)as num,*from T_News)as t where t.num>=@start and t.num<=@end"; SqlParameter[] pms = { new SqlParameter("@start",SqlDbType.Int), new SqlParameter("@end",SqlDbType.Int), }; pms[0].Value = start; pms[1].Value = end; DataTable dt = SqlHelper.ExcuteDataTable(sql,CommandType.Text,pms); List newList = null; if (dt.Rows.Count>0) { newList = new List(); NewInfo newinfo = null; foreach (DataRow item in dt.Rows) { newinfo = new NewInfo(); LoadEntity(item,newinfo); newList.Add(newinfo); } } return newList; } /// 
 /// 查询出页面条数 /// 
 ///  public int GetRecordCount() { string sql = "select count(*) from T_News"; int count = Convert.ToInt32(SqlHelper.ExecuteScalar(sql,CommandType.Text)); return count; } 

 DAL.NewInfoDal NewInfoDal = new DAL.NewInfoDal(); /// 
 /// 分页查询数据 /// 
 /// 当前页码值 /// 一个多少条数据 ///  public List GetPageEntityList(int pageIndex, int pageSize) { int start = (pageIndex - 1) * pageSize + 1; int end = pageSize * pageIndex; return NewInfoDal.GetPageEntityList(start,end); } /// 
 /// 查询出页面的记录数 /// 
 ///  public int GetRecordCount() { return NewInfoDal.GetRecordCount(); }