asp.net Linq TO Sql paging method

  • 2020-05-07 19:30:22
  • OfStack

Paging method
 
/// <summary> 
/// 
/// </summary> 
/// <typeparam name="T"></typeparam> 
/// <param name="replist"> controls ID</param> 
/// <param name="DataSource"> The data source </param> 
/// <param name="IndexPage"> The current page </param> 
/// <param name="PageSize"> Number of data bars per page </param> 
/// <param name="PageParemart"> Page search parameters  like &a=a&b=b </param> 
/// <returns></returns> 
public static string ShowPage<T>(System.Web.UI.WebControls.Repeater replist, IQueryable<T> DataSource, int IndexPage, int PageSize, string PageParemart) 
{ 
string rtnStr = ""; 
int sourceCount = DataSource.Count(); 
if (sourceCount == 0)// Data source no data  
{ 
rtnStr = string.Empty; 
} 
else 
{ 
int yutemp = sourceCount % PageSize; 
int pagecounts = (yutemp == 0) ? (sourceCount / PageSize) : (sourceCount / PageSize + 1);// Total number of pages  
rtnStr = " <div style='width:100%;'><div style=' float:left;'> Page one: " + IndexPage + " page /" + pagecounts + " Page, " + sourceCount + " records </div> "; 
if (pagecounts == 1) // In total, 1 Page data  
{ 
replist.DataSource = DataSource; 
rtnStr += "[ Home page ] [ on 1 page ] [ Under the 1 page ] [ back ] "; 
} 
else 
{ 
rtnStr += "<div style=' float:right;'>"; 
if (IndexPage == 1)// Home page  
{ 
replist.DataSource = DataSource.Take(PageSize); 
rtnStr += "[ Home page ] [ on 1 page ] <a href='?page=" + (IndexPage + 1) + PageParemart + "'>[ Under the 1 page ]</a> <a href='?page=" + (pagecounts) + PageParemart + "'>[ back ]</a> "; 
} 
else 
{ 
replist.DataSource = DataSource.Skip((IndexPage - 1) * PageSize).Take(PageSize); 
if (IndexPage == pagecounts)// At the end of the page  
{ 
rtnStr += "<a href='?page=1" + PageParemart + "'>[ Home page ]</a> <a href='?page=" + (IndexPage - 1) + PageParemart + "'>[ on 1 page ]</a> [ Under the 1 page ] [ back ] "; 
} 
else 
{ 
rtnStr += "<a href='?page=1" + PageParemart + "'>[ Home page ]</a> <a href='?page=" + (IndexPage - 1) + PageParemart + "'>[ on 1 page ]</a> <a href='?page=" + (IndexPage + 1) + PageParemart + "'>[ Under the 1 page ]</a> <a href='?page=" + (pagecounts) + PageParemart + "'>[ back ]</a> "; 
} 
} 
rtnStr += "</div></div>"; 
} 
replist.DataBind(); 
} 
return rtnStr; 
} 

Page calls
 
private int PageSize = 10; 
private int IndexPage = 1; 
private string PageParemart = ""; 
private void Bind() 
{ 
strwhere = "1=1 " + strwhere; 
str2 = "1=1 " + str2; 
var a = from b in datas.fav_Awards_User select b; 
Label2.Text = common.PageFen.ShowPage(replist, a, this.IndexPage, this.PageSize, this.PageParemart); 
if (Label2.Text == "") 
{ 
Label1.Visible = true; 
} 
} 

Related articles: