代码改变世界

AspNetPager 真分页

2020-07-25 16:48  idea555  阅读(81)  评论(0)    收藏  举报

前台：

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Test1.aspx.cs" Inherits="WebFrom.Test1" %>
<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>
<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title></title>

</head>
<body>
<form runat="server">
<asp:Repeater ID="List_repeatrer" runat="server">
<ItemTemplate>
<tr class="comx_tc" onmouseover="RptOver(this);" onmouseout="RptOut(this);" >
<td class="ckb"><input type="checkbox" id='<%#Eval("id") %>'></td>
<td><%#Eval("Id") %></td>
<td><%#Eval("Name")%></td>
<td><%#Eval("Name1")%></td>
<td><%#Eval("AddTime")%></td>
</tr>
</ItemTemplate>
</asp:Repeater>

<webdiyer:AspNetPager ID="AspNetPager1" runat="server" FirstPageText="" LastPageText=""
            NextPageText="下一页" OnPageChanging="AspNetPager1_PageChanging" CssClass="pages" CurrentPageButtonClass="cpb" PrevPageText="上一页" PageSize="3">
        </webdiyer:AspNetPager>
</form>
</body>
</html>

 后台：

using My.Framework.Page;
using My.Framework.TrSqlHelper;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Wuqi.Webdiyer;

namespace WebFrom
{
public partial class Test1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DisplayData(1, AspNetPager1.PageSize);
}

}

private void DisplayData(int pageIndex, int pageSize)
{
string sqlText = "select * from Company";
string orderByText = "Order by Id DESC ";
sqlText = PageHelper.GetPageSql(sqlText, orderByText, pageIndex, pageSize);
DataTable tempTable = TrSqlHelper.FillDataTable(CommandType.Text, sqlText,null);
AspNetPager1.RecordCount = tempTable.AsEnumerable().Select(t => t.Field<int>("recordcount")).FirstOrDefault();


List_repeatrer.DataSource = tempTable;
List_repeatrer.DataBind();
}

protected void AspNetPager1_PageChanging(object src, PageChangingEventArgs e)
{
DisplayData(e.NewPageIndex, AspNetPager1.PageSize);
}
}
}