[关闭]
@Aiti 2018-11-14T01:15:01.000000Z 字数 7765 阅读 222

ASP.NET中控件实现分页功能/Repeater控件分页

未分类

前台代码

  1. //repeate.aspx  
  2. <%@ Page Language="C#" AutoEventWireup="true" CodeFile="repeate.aspx.cs" Inherits="repeate" %>  
  3. <%@ Import Namespace="System.Data" %>  
  5. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">  
  7. <html xmlns="http://www.w3.org/1999/xhtml" >  
  8. <head runat="server">  
  9.     <title>无标题页</title>  
  10. </head>  
  11. <body>  
  12.     <form id="form1" runat="server">  
  13.     <div>  
  14.         <asp:Repeater ID="Repeater1" runat="server" OnItemDataBound="Repeater1_ItemDataBound" >  
  15.         <HeaderTemplate><%-- 我是头模板--%>  
  16.         <table width="500">  
  17.         <tr style="background-color: #ccffcc;">  
  18.         <td>作者</td>  
  19.         <td>书籍</td>  
  20.         </tr>  
  21.         </HeaderTemplate>  
  22.         <ItemTemplate><%--我是项模板--%>  
  23.         <tr>  
  24.         <td><a href='repeate.aspx?id=<%# Eval("au_id")%>'><%# Eval("au_lname") %></a></td>  
  25.         <td><asp:Repeater ID="Repeater2" runat="server" DataSource='<%# Eval("myrela") %>'>  
  26.         <ItemTemplate>  
  27.         <%# Eval("[/"title_id/"]") %>  
  28.         </ItemTemplate>  
  29.         </asp:Repeater>  
  30.         </td>  
  31.         </tr>          
  32.         </ItemTemplate>  
  33.         <SeparatorTemplate><%--这是分隔线模板--%>  
  34.         <tr>  
  35.         <td colspan="2">  
  36.         <hr style="border-top:1pt;"/>  
  37.         </td>  
  38.         </tr>  
  39.         </SeparatorTemplate>  
  40.         <FooterTemplate><%--这是脚模板--%>  
  41.         <tr>  
  42.         <td colspan="2" style="font-size:12pt;color:#0099ff; background-color:#e6feda;">  
  43.         共<asp:Label ID="lblpc" runat="server" Text="Label"></asp:Label>页 当前为第  
  44.         <asp:Label ID="lblp" runat="server" Text="Label"></asp:Label>页  
  45.         <asp:HyperLink ID="hlfir" runat="server" Text="首页"></asp:HyperLink>  
  46.         <asp:HyperLink ID="hlp" runat="server" Text="上一页"></asp:HyperLink>  
  47.         <asp:HyperLink ID="hln" runat="server" Text="下一页"></asp:HyperLink>  
  48.         <asp:HyperLink ID="hlla" runat="server" Text="尾页"></asp:HyperLink>  
  49.          跳至第  
  50.          <asp:DropDownList ID="ddlp" runat="server" AutoPostBack="true" OnSelectedIndexChanged="ddlp_SelectedIndexChanged" >  
  51.          </asp:DropDownList>页  
  52.         </td>  
  53.         </tr>  
  54.         </table>  
  55.         </FooterTemplate>  
  56.         </asp:Repeater>  
  57.          </div>  
  58.     </form>  
  59. </body>  
  60. </html>

后台代码

  2. using System;  
  3. using System.Data;  
  4. using System.Data.SqlClient;  
  5. using System.Configuration;  
  6. using System.Collections;  
  7. using System.Web;  
  8. using System.Web.Security;  
  9. using System.Web.UI;  
  10. using System.Web.UI.WebControls;  
  11. using System.Web.UI.WebControls.WebParts;  
  12. using System.Web.UI.HtmlControls;  
  14. public partial class repeate : System.Web.UI.Page  
  15. {  
  16.     protected void Page_Load(object sender, EventArgs e)  
  17.     {  
  18.         if (!IsPostBack)  
  19.         {  
  20.             Repeater1.DataSource = pds();  
  21.             Repeater1.DataBind();              
  22.         }  
  23.     }  
  24.     private PagedDataSource pds()  
  25.     {  
  26.         PagedDataSource pds = new PagedDataSource();  
  28.         //string connstring = ConfigurationManager.ConnectionStrings["pconn"].ConnectionString;  
  29.        // SqlConnection con = new SqlConnection(connstring);  
  31.        // DataSet ds = new DataSet();  
  32.        //SqlDataAdapter sda = new SqlDataAdapter("select * from authors",con);  
  33.        // sda.Fill(ds,"name");  
  34.        // SqlDataAdapter sda2 = new SqlDataAdapter("select * from titleauthor",con);  
  35.        // sda2.Fill(ds,"title");  
  36.        // ds.Relations.Add("myrela",ds.Tables["name"].Columns["au_id"],ds.Tables["title"].Columns["au_id"]);   
  38.        // pds.DataSource = ds.Tables["name"].DefaultView;  
  39.        //Comments类是Diary类的一对多的关联关系
  40.        Diary Diary = session.FindObject<Diary>(CriteriaOperator.Parse("Oid=?", 1));  
  41.        pds.DataSource = Diary.Comments;
  43.         pds.AllowPaging = true;//允许分页  
  44.         pds.PageSize = 5;//单页显示项数  
  45.         pds.CurrentPageIndex = Convert.ToInt32(Request.QueryString["page"]);  
  46.         return pds;  
  47.     }  
  49.     protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)  
  50.     {  
  51.         if (e.Item.ItemType == ListItemType.Footer)  
  52.         {  
  53.             DropDownList ddlp = (DropDownList)e.Item.FindControl("ddlp");  
  55.             HyperLink lpfirst = (HyperLink)e.Item.FindControl("hlfir");  
  56.             HyperLink lpprev = (HyperLink)e.Item.FindControl("hlp");  
  57.             HyperLink lpnext = (HyperLink)e.Item.FindControl("hln");  
  58.             HyperLink lplast = (HyperLink)e.Item.FindControl("hlla");  
  60.             pds().CurrentPageIndex = ddlp.SelectedIndex;  
  62.             int n = Convert.ToInt32(pds().PageCount);//n为分页数  
  63.             int i = Convert.ToInt32(pds().CurrentPageIndex);//i为当前页  
  65.             Label lblpc = (Label)e.Item.FindControl("lblpc");  
  66.             lblpc.Text = n.ToString();  
  67.             Label lblp = (Label)e.Item.FindControl("lblp");  
  68.             lblp.Text = Convert.ToString(pds().CurrentPageIndex + 1);  
  70.             if (!IsPostBack)  
  71.             {  
  72.                 for (int j = 0; j < n; j++)  
  73.                 {  
  74.                     ddlp.Items.Add(Convert.ToString(j + 1));  
  75.                 }  
  76.             }  
  78.             if (i <= 0)  
  79.             {  
  80.                 lpfirst.Enabled = false;  
  81.                 lpprev.Enabled = false;  
  82.                 lplast.Enabled = true;  
  83.                 lpnext.Enabled = true;  
  84.             }  
  85.             else  
  86.             {  
  87.                 lpprev.NavigateUrl = "?page=" + (i - 1);  
  88.             }  
  89.             if (i >= n - 1)  
  90.             {  
  91.                 lpfirst.Enabled = true;  
  92.                 lplast.Enabled = false;  
  93.                 lpnext.Enabled = false;  
  94.                 lpprev.Enabled = true;  
  95.             }  
  96.             else  
  97.             {  
  98.                 lpnext.NavigateUrl = "?page=" + (i + 1);  
  99.             }  
  101.             lpfirst.NavigateUrl = "?page=0";//向本页传递参数page  
  102.             lplast.NavigateUrl = "?page=" + (n - 1);  
  104.             ddlp.SelectedIndex = Convert.ToInt32(pds().CurrentPageIndex);//更新下拉列表框中的当前选中页序号  
  105.         }  
  107.     }  
  108.     protected void ddlp_SelectedIndexChanged(object sender, EventArgs e)  
  109.     {//脚模板中的下拉列表框更改时激发  
  110.         string pg=Convert.ToString((Convert.ToInt32(((DropDownList)sender).SelectedValue)-1));//获取列表框当前选中项  
  111.         Response.Redirect("repeate.aspx?page="+pg);//页面转向  
  112.     }  
  113. }

其中发现的问题：
因为DataSource的数据类型是List()数据集; 所以

  1. var data = new XPQuery<Diary>(session);
  2. pds.DataSource = data;

会报错：“无法计算未实现 ICollection 的数据源中的计数”；所以有两种改法
1、

  1. var data = new XPQuery<Diary>(session).ToList();
  2. pds.DataSource = data;

2、

  1. var data = new XPCollection<Diary>(session);
  2. pds.DataSource = data;

其中XPQuery也可实现查询前几条数据；如前6条数据：

  1. var data = new XPQuery<Diary>(session).Take(6).ToList();
  2. pds.DataSource = data;

Repeater控件添加删除按钮，并确认提示框

第一种

  1. <style>
  2.     .wrap-dialog {
  3.         position: fixed;
  4.         top: 0;
  5.         left: 0;
  6.         width: 100%;
  7.         height: 100%;
  8.         font-size: 16px;
  9.         text-align: center;
  10.         background-color: rgba(0, 0, 0, .4);
  11.         z-index: 99999;
  12.     }
  13.     .dialog1 {
  14.         position: relative;
  15.         margin: 15% auto;
  16.         width: 300px;
  17.         background-color: #FFFFFF;
  18.     }
  19.     .dialog1 .dialog-header {
  20.         height: 20px;
  21.         padding: 10px;
  22.         background-color: lightskyblue;
  23.     }
  24.     .dialog1 .dialog-body {
  25.         height: 30px;
  26.         padding: 20px;
  27.     }
  28.     .dialog1 .dialog-footer {
  29.         padding: 8px;
  30.         background-color: whitesmoke;
  31.     }
  32.     .btn {
  33.         width: 70px;
  34.         padding: 2px;
  35.     }
  36.     .hide {
  37.         display: none;
  38.     }
  39.     .ml50 {
  40.         margin-left: 50px;
  41.     }
  42. </style>
  43. --------------------
  44. <script>
  45.     function dialogBox(message, yesCallback, noCallback) {
  46.         if (message) {
  47.             $('.dialog-message').html(message);
  48.         }
  49.         // 显示遮罩和对话框
  50.         $('.wrap-dialog').removeClass("hide");
  51.         // 确定按钮
  52.         $('#confirm').click(function () {
  53.             $('.wrap-dialog').addClass("hide");
  54.             yesCallback();
  55.         });
  56.         // 取消按钮
  57.         $('#cancel').click(function () {
  58.             $('.wrap-dialog').addClass("hide");
  59.             noCallback();
  60.         });
  61.     }
  62.     $(function () {
  63.         $(".delbtn").click(function () {
  64.             var that=this;
  65.             dialogBox("你确认删除此条信息？？",
  66.               function () {
  67.                 var h=$(that).parent().find("div").find("a").attr("href");
  68.                 h=h.substring(h.indexOf('rpt'),h.lastIndexOf('e')+1);
  69.                 __doPostBack(h,'');
  70.               },
  71.               function(){
  72.               }
  73.           );
  75.         });
  76.     });
  77. </script>
  79. --------------------
  81. <div class="wrap-dialog hide">
  82.     <div class="dialog1">
  83.         <div class="dialog-header">
  84.             <span class="dialog-title">删除确认</span>
  85.         </div>
  86.         <div class="dialog-body">
  87.             <span class="dialog-message">你确认删除此条信息？</span>
  88.         </div>
  89.         <div class="dialog-footer">
  90.             <input type="button" class="btn" id="confirm" value="确认" />
  91.             <input type="button" class="btn ml50" id="cancel" value="取消" />
  92.         </div>
  93.     </div>
  94. </div>
  96. <asp:Repeater runat="server" ID="rpt" ClientIDMode="Static">
  97. <ItemTemplate>
  98.     <tr>
  99.         <td><a  href='ViewAll.aspx?rid=<%#Eval("Oid") %>'>
  100.                 <%#Eval("RecordName") %> (合计:
  101.                 <%#Eval("Grade") %> )</a> </td>
  102.         <td>
  103.             <a href="javascript:void(0)" class='del delbtn'>删除</a>
  104.             <div style="display:none;">
  105.                 <asp:LinkButton ID="btnDelete" runat="server" cssClass='del' CommandArgument='<%#Eval("Oid") %>'
  106.                     OnClick="Del">删除</asp:LinkButton>
  107.             </div>
  108.         </td>
  109.     </tr>
  110. </ItemTemplate>
  111. </asp:Repeater>
  114. ----------
  115. 后台代码：
  117. public void Del(object sender, EventArgs e)
  118. {
  119.     int id = Convert.ToInt32((sender as LinkButton).CommandArgument);
  120.     var r = new XPCollection<CalculationReport>(session, CriteriaOperator.Parse("Oid=?", id));
  121.     session.Delete(r);
  122.     session.Save(r);
  123.     rpt.DataSource = new XPCollection<CalculationReport>(session, CriteriaOperator.Parse("User.LoginName=?", currentUser.LoginName), new SortProperty("RecordName", DevExpress.Xpo.DB.SortingDirection.Ascending));
  124.     rpt.DataBind();
  125. }

第二种

  2. <asp:Repeater runat="server" ID="rpt" ClientIDMode="Static">
  3. <ItemTemplate>
  4.     <tr>
  5.         <td><i class="fa fa-file" style="color:#d4cbd4;margin-right:10px;"></i></td>
  6.         <td><a style="font-size:14px;color:#2599e3;" href='ViewAll.aspx?rid=<%#Eval("Oid") %>'> <%#Eval("RecordName") %> (合计:<%#Eval("Grade") %> )</a> </td>
  7.         <td> 
  8.             <%--<asp:LinkButton ID="btnDelete" runat="server" cssClass='del' Text="删除" CommandName="delete" CommandArgument='<%#Eval("Oid") %>'>删除</asp:LinkButton>--%>
  9.             <asp:LinkButton ID="btnDelete" runat="server" cssClass='del' CommandArgument='<%#Eval("Oid") %>'  OnClientClick="return confirm('是否删除')"  OnClick="Del" >删除</asp:LinkButton>
  11.         </td>
  12.     </tr>
  13. </ItemTemplate>
  14. </asp:Repeater>
  15. 后台代码与上面一致
添加新批注
在作者公开此批注前，只有你和作者可见。
回复批注