asp.net Linq TO Sql 分页方法

<br>/// <summary> <br>/// <br>/// </summary> <br>/// <typeparam name="T"></typeparam> <br>/// <param name="replist">控件ID</param> <br>/// <param name="DataSource">数据源</param> <br>/// <param name="IndexPage">当前页</param> <br>/// <param name="PageSize">每页数据条数</param> <br>/// <param name="PageParemart">页面搜索参数 like &a=a&b=b </param> <br>/// <returns></returns> <br>public static string ShowPage<T>(System.Web.UI.WebControls.Repeater replist, IQueryable<T> DataSource, int IndexPage, int PageSize, string PageParemart) <br>{ <br>string rtnStr = ""; <br>int sourceCount = DataSource.Count(); <br>if (sourceCount == 0)//数据源无数据 <br>{ <br>rtnStr = string.Empty; <br>} <br>else <br>{ <br>int yutemp = sourceCount % PageSize; <br>int pagecounts = (yutemp == 0) ? (sourceCount / PageSize) : (sourceCount / PageSize + 1);//总页数 <br>rtnStr = " <div style='width:100%;'><div style=' float:left;'>页次：" + IndexPage + "页/" + pagecounts + "页，共" + sourceCount + "条记录</div> "; <br>if (pagecounts == 1) //总共一页数据 <br>{ <br>replist.DataSource = DataSource; <br>rtnStr += "[首页] [上一页] [下一页] [尾页] "; <br>} <br>else <br>{ <br>rtnStr += "<div style=' float:right;'>"; <br>if (IndexPage == 1)//首页 <br>{ <br>replist.DataSource = DataSource.Take(PageSize); <br>rtnStr += "[首页] [上一页] <a href='?page=" + (IndexPage + 1) + PageParemart + "'>[下一页]</a> <a href='?page=" + (pagecounts) + PageParemart + "'>[尾页]</a> "; <br>} <br>else <br>{ <br>replist.DataSource = DataSource.Skip((IndexPage - 1) * PageSize).Take(PageSize); <br>if (IndexPage == pagecounts)//末页 <br>{ <br>rtnStr += "<a href='?page=1" + PageParemart + "'>[首页]</a> <a href='?page=" + (IndexPage - 1) + PageParemart + "'>[上一页]</a> [下一页] [尾页] "; <br>} <br>else <br>{ <br>rtnStr += "<a href='?page=1" + PageParemart + "'>[首页]</a> <a href='?page=" + (IndexPage - 1) + PageParemart + "'>[上一页]</a> <a href='?page=" + (IndexPage + 1) + PageParemart + "'>[下一页]</a> <a href='?page=" + (pagecounts) + PageParemart + "'>[尾页]</a> "; <br>} <br>} <br>rtnStr += "</div></div>"; <br>} <br>replist.DataBind(); <br>} <br>return rtnStr; <br>} <br> <br>页面调用 <br><span><u></u></span> 代码如下:<pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li><br>private int PageSize = 10; <br>private int IndexPage = 1; <br>private string PageParemart = ""; <br>private void Bind() <br>{ <br>strwhere = "1=1 " + strwhere; <br>str2 = "1=1 " + str2; <br>var a = from b in datas.fav_Awards_User select b; <br>Label2.Text = common.PageFen.ShowPage(replist, a, this.IndexPage, this.PageSize, this.PageParemart); <br>if (Label2.Text == "") <br>{ <br>Label1.Visible = true; <br>} <br>} <br></li><li>            </li><li>                                </li></ol></pre>