MySQL linq 分页_asp.net Linq TO Sql 分页方法

分页方法

///

///

///

///

/// 控件ID

/// 数据源

/// 当前页

/// 每页数据条数

/// 页面搜索参数 like &a=a&b=b

///

public static string ShowPage(System.Web.UI.WebControls.Repeater replist, IQueryable DataSource, int IndexPage, int PageSize, string PageParemart)

{

string rtnStr = "";

int sourceCount = DataSource.Count();

if (sourceCount == 0)//数据源无数据

{

rtnStr = string.Empty;

}

else

{

int yutemp = sourceCount % PageSize;

int pagecounts = (yutemp == 0) ? (sourceCount / PageSize) : (sourceCount / PageSize + 1);//总页数

rtnStr = "

页次：" + IndexPage + "页/" + pagecounts + "页，共" + sourceCount + "条记录

";

if (pagecounts == 1) //总共一页数据

{

replist.DataSource = DataSource;

rtnStr += "[首页] [上一页] [下一页] [尾页] ";

}

else

{

rtnStr += "

";

if (IndexPage == 1)//首页

{

replist.DataSource = DataSource.Take(PageSize);

rtnStr += "[首页] [上一页] [下一页] [尾页] ";

}

else

{

replist.DataSource = DataSource.Skip((IndexPage - 1) * PageSize).Take(PageSize);

if (IndexPage == pagecounts)//末页

{

rtnStr += "[首页] [上一页] [下一页] [尾页] ";

}

else

{

rtnStr += "[首页] [上一页] [下一页] [尾页] ";

}

}

rtnStr += "

";

}

replist.DataBind();

}

return rtnStr;

}

页面调用

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;

}

}