asp.net中一個(gè)linq分頁(yè)實(shí)現(xiàn)代碼

更新時(shí)間：2011年12月20日 11:57:50 作者：

asp.net中一個(gè)linq分頁(yè)實(shí)現(xiàn)代碼，需要的朋友可以參考下。

LInq分頁(yè)

 
testDataContext dc = new testDataContext(); 
public string GetPageNum(GridView GridViewName, int pagesize, IQueryable<test> sql) 
{ 
int page; 
if (HttpContext.Current.Request.QueryString["page"] != null) 
page = Convert.ToInt32(HttpContext.Current.Request.QueryString["page"]); 
else 
page = 1; 
//var sql = from o in dc.test select o; 
int total = sql.Count();//總數(shù)據(jù)量 
var sqls = sql.Skip((page - 1) * pagesize).Take(pagesize); 
GridViewName.DataSource = sqls; 
GridViewName.DataBind(); 
int allpage = 0; 
int next = 0; 
int pre = 0; 
int startcount = 0; 
int endcount = 0; 
string pagestr = ""; 
if (page < 1) { page = 1; } 
//計(jì)算總頁(yè)數(shù) 
if (pagesize != 0) 
{ 
allpage = (total / pagesize); 
allpage = ((total % pagesize) != 0 ? allpage + 1 : allpage); 
allpage = (allpage == 0 ? 1 : allpage); 
} 
next = page + 1; 
pre = page - 1; 
startcount = (page + 5) > allpage ? allpage - 9 : page - 4;//中間頁(yè)起始序號(hào) 
//中間頁(yè)終止序號(hào) 
endcount = page < 5 ? 10 : page + 5; 
if (startcount < 1) { startcount = 1; } //為了避免輸出的時(shí)候產(chǎn)生負(fù)數(shù)，設(shè)置如果小于1就從序號(hào)1開(kāi)始 
if (allpage < endcount) { endcount = allpage; } //頁(yè)碼+5的可能性就會(huì)產(chǎn)生最終輸出序號(hào)大于總頁(yè)碼，那么就要將其控制在頁(yè)碼數(shù)之內(nèi) 
pagestr = "共" + allpage + "頁(yè)&nbsp;&nbsp;&nbsp;&nbsp"; 
pagestr += page > 1 ? "<a href=\"" + HttpContext.Current.Request.CurrentExecutionFilePath + "?page=1\">首頁(yè)</a>&nbsp;&nbsp;<a href=\"" + HttpContext.Current.Request.CurrentExecutionFilePath + "?page=" + pre + "\">上一頁(yè)</a>" : "首頁(yè) 上一頁(yè)"; 
//中間頁(yè)處理，這個(gè)增加時(shí)間復(fù)雜度，減小空間復(fù)雜度 
for (int i = startcount; i <= endcount; i++) 
{ 
pagestr += page == i ? "&nbsp;&nbsp;<font color=\"#ff0000\">" + i + "</font>" : "&nbsp;&nbsp;<a href=\"" + HttpContext.Current.Request.CurrentExecutionFilePath + "?page=" + i + "\">" + i + "</a>"; 
} 
pagestr += page != allpage ? "&nbsp;&nbsp;<a href=\"" + HttpContext.Current.Request.CurrentExecutionFilePath + "?page=" + next + "\">下一頁(yè)</a>&nbsp;&nbsp;<a href=\"" + HttpContext.Current.Request.CurrentExecutionFilePath + "?page=" + allpage + "\">末頁(yè)</a>" : " 下一頁(yè) 末頁(yè)"; 
return pagestr; 
} 

調(diào)用 label1.Test=GetPageNum(控件名稱，每頁(yè)顯示條數(shù)，linq查詢語(yǔ)句)
普通分頁(yè)

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

 
public static string GetPageNum(DataTable ds, DataList datalistname, int pagesize) 
{ 
PagedDataSource objPds = new PagedDataSource(); 
objPds.DataSource = ds.DefaultView; 
objPds.AllowPaging = true; 
int total = ds.Rows.Count; 
objPds.PageSize = pagesize; 
int page; 
if (HttpContext.Current.Request.QueryString["page"] != null) 
page = Convert.ToInt32(HttpContext.Current.Request.QueryString["page"]); 
else 
page = 1; 
objPds.CurrentPageIndex = page - 1; 
datalistname.DataSource = objPds; 
datalistname.DataBind(); 
int allpage = 0; 
int next = 0; 
int pre = 0; 
int startcount = 0; 
int endcount = 0; 
string pagestr = ""; 
if (page < 1) { page = 1; } 
//計(jì)算總頁(yè)數(shù) 
if (pagesize != 0) 
{ 
allpage = (total / pagesize); 
allpage = ((total % pagesize) != 0 ? allpage + 1 : allpage); 
allpage = (allpage == 0 ? 1 : allpage); 
} 
next = page + 1; 
pre = page - 1; 
startcount = (page + 5) > allpage ? allpage - 9 : page - 4;//中間頁(yè)起始序號(hào) 
//中間頁(yè)終止序號(hào) 
endcount = page < 5 ? 10 : page + 5; 
if (startcount < 1) { startcount = 1; } //為了避免輸出的時(shí)候產(chǎn)生負(fù)數(shù)，設(shè)置如果小于1就從序號(hào)1開(kāi)始 
if (allpage < endcount) { endcount = allpage; } //頁(yè)碼+5的可能性就會(huì)產(chǎn)生最終輸出序號(hào)大于總頁(yè)碼，那么就要將其控制在頁(yè)碼數(shù)之內(nèi) 
pagestr = "共" + allpage + "頁(yè)&nbsp;&nbsp;&nbsp;&nbsp"; 
pagestr += page > 1 ? "<a href=\"" + HttpContext.Current.Request.CurrentExecutionFilePath + "?page=1\">首頁(yè)</a>&nbsp;&nbsp;<a href=\"" + HttpContext.Current.Request.CurrentExecutionFilePath + "?page=" + pre + "\">上一頁(yè)</a>" : "首頁(yè) 上一頁(yè)"; 
//中間頁(yè)處理，這個(gè)增加時(shí)間復(fù)雜度，減小空間復(fù)雜度 
for (int i = startcount; i <= endcount; i++) 
{ 
pagestr += page == i ? "&nbsp;&nbsp;<font color=\"#ff0000\">" + i + "</font>" : "&nbsp;&nbsp;<a href=\"" + HttpContext.Current.Request.CurrentExecutionFilePath + "?page=" + i + "\">" + i + "</a>"; 
} 
pagestr += page != allpage ? "&nbsp;&nbsp;<a href=\"" + HttpContext.Current.Request.CurrentExecutionFilePath + "?page=" + next + "\">下一頁(yè)</a>&nbsp;&nbsp;<a href=\"" + HttpContext.Current.Request.CurrentExecutionFilePath + "?page=" + allpage + "\">末頁(yè)</a>" : " 下一頁(yè) 末頁(yè)"; 
return pagestr; 
} 