重写Repeater控件，并分页管理

1、重写Repeater（修改过的，当只有一页的情况时，只显示Total页数及共有多少条目，不会显示上一页，下一页等）:

using System.ComponentModel;
using System.Web.UI;
[assembly: TagPrefix("MyRepeater.Control", "MyRepeater")]
namespace MyRepeater
{
    /// <summary>
    /// JRepeater控件
    /// </summary>

    [DefaultProperty("Text"), ToolboxData("<!--Repeater Begin --><div class=\"BigDiv_rep\"> <{0}:Repeater ID=\"Rep_List\" runat=server EnableViewState=\"false\" OnPreRender=\"Rep_List_PreRender\"> <HeaderTemplate><div class=\"BigDiv_Title_rep\"> <ul> <li style=\"line-height:22px;\"> <asp:CheckBox ID=\"TopCheckBox\" runat=\"server\" Text=\"ID\" EnableViewState=\"false\"/> </li><li style=\"width:10%;\"> </li>  </ul> </div> </HeaderTemplate><ItemTemplate><div class=\"BigDiv_line_rep\"  onmouseover=\"javascript:this.style.backgroundColor='#EEF8F9'\" onmouseout=\"javascript:this.style.backgroundColor='#FFFFFF'\"><ul ><li style=\"line-height:22px;\"><asp:CheckBox ID=\"ItemCheckBox\" runat=\"server\" Text='<%# Eval(\"ID\") %>'  EnableViewState=\"false\"/></li><li style=\"width:10%;\"></li></ul></div></ItemTemplate>   <FooterTemplate><div class=\"DelAllButton\"><asp:Button ID=\"btn_DelAll\" runat=\"server\" onclick=\"btn_DelAll_Click\"  CssClass=\"btn_DelAllCss\"  Text=\"删除\"  EnableViewState=\"false\"/></div></FooterTemplate></{0}:Repeater></div><!--Repeater End -->")]
    public class Repeater : System.Web.UI.WebControls.Repeater
    {
        public bool ShowPagingWhenItemLessThanPageSize { get; set; }

        private int _recordcount = 0;
        private int _pagesize = 0;
        private string _pagelink = "";
        private int _currentpage = 1;
        private string _urlSearchPrex = null;
        /// <summary>
        /// constructure
        /// </summary>
        public Repeater()
        {
            this.ShowPagingWhenItemLessThanPageSize = true;
        }

        #region _

        [Bindable(true), Category("Data"), DefaultValue("1"), Description("totalCount")]
        public int RecordCount
        {
            get
            {
                return _recordcount;
            }

            set
            {
                _recordcount = value;
            }
        }

        [Bindable(true), Category("Data"), DefaultValue("1"), Description("pagesize")]
        public int PageSize
        {
            get
            {
                return _pagesize;
            }

            set
            {
                _pagesize = value;
            }
        }

        [Bindable(true), Category("Data"), DefaultValue(""), Description("currentLink")]
        public string PageLink
        {
            get
            {
                return _pagelink;
            }

            set
            {
                _pagelink = value;
            }
        }

        [Bindable(true), Category("Data"), DefaultValue("1"), Description("currentPageIndex")]
        public int CurrentPage
        {
            get
            {
                return _currentpage;
            }

            set
            {
                _currentpage = value;
            }
        }

        public string UrlSearchPrex
        {
            get { return _urlSearchPrex; }
            set { _urlSearchPrex = value; }
        }
        #endregion



        /// <summary> 
        /// output control to page
        /// </summary>
        /// <param name="output">  </param>
        protected override void Render(HtmlTextWriter output)
        {
            base.Render(output);

            if (this._recordcount <= this._pagesize)
            {
                output.WriteLine("<div class=\"PageLink\"><font color=\"#666666\">Total:1 page(s)&nbsp;&nbsp;&nbsp;" + this._recordcount + "&nbsp;record(s)</div>");
                return;
            }
            if (!(this._recordcount <= this._pagesize && !this.ShowPagingWhenItemLessThanPageSize))
            {
                output.WriteLine("<div class=\"PageLink\">" + Pagination(_recordcount, _pagesize, _currentpage, _pagelink, _urlSearchPrex) + "</div>");
            }
        }


        /// <summary>
        /// paging function
        /// </summary>
        /// <param name="recordcount">total count</param>
        /// <param name="pagesize"></param>
        /// <param name="currentpage"></param>
        /// <param name="url"></param>
        /// <returns></returns>
        public string Pagination(int recordcount, int pagesize, int currentpage, string url, string urlSearchPrex)
        {
            int allcurrentpage = 0;
            int next = 0;
            int pre = 0;
            int startcount = 0;
            int endcount = 0;
            string currentpagestr = "";

            if (currentpage < 1) { currentpage = 1; }
            //total page count
            if (pagesize != 0)
            {
                allcurrentpage = (recordcount / pagesize);
                allcurrentpage = ((recordcount % pagesize) != 0 ? allcurrentpage + 1 : allcurrentpage);
                allcurrentpage = (allcurrentpage == 0 ? 1 : allcurrentpage);
            }
            next = currentpage + 1;
            pre = currentpage - 1;
            startcount = (currentpage + 5) > allcurrentpage ? allcurrentpage - 9 : currentpage - 4;

            endcount = currentpage < 5 ? 10 : currentpage + 5;
            if (startcount < 1) { startcount = 1; }
            if (allcurrentpage < endcount) { endcount = allcurrentpage; }
            currentpagestr = "<font color=\"#666666\">Total:&nbsp;" + allcurrentpage + "&nbsp; page(s) &nbsp;&nbsp; " + recordcount + "&nbsp;record(s) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";

            string checkaccountName = Page.Request.QueryString["checkaccount"];
            string checkprojectName = Page.Request.QueryString["checkproject"];
            urlSearchPrex += "&checkaccount=" + checkaccountName + "&checkproject=" + checkprojectName;

            string urlPrex = url + urlSearchPrex == null ? "?page=" : "?" + urlSearchPrex + "&page=";
            currentpagestr += currentpage > 1 ?
                "</font><a href=\"" + urlPrex + "1\"><span class=\"disabled\"> First </span></a>&nbsp;&nbsp;&nbsp;<a href=\"" + urlPrex + pre + "\">&nbsp;<span class=\"disabled\"> < Prev </span></a>" : "&nbsp;<span class=\"disabled\"> First </span>";

            for (int i = startcount; i <= endcount; i++)
            {
                currentpagestr += currentpage == i ? "&nbsp;<font color=\"#666666\"><span class=\"disabled\">" + "[&nbsp;" + i + "&nbsp;]" + "</span></font>" : "&nbsp;<a href=\"" + urlPrex + i + "\"><span class=\"ssss\">" + "[&nbsp;" + i + "&nbsp;]" + "</span></a>&nbsp;";
            }
            currentpagestr += currentpage != allcurrentpage ? "&nbsp;&nbsp;<a href=\"" + urlPrex + next + "\"><span class=\"disabled\"> Next ></span></a>&nbsp;&nbsp;<a href=\"" + urlPrex + allcurrentpage + "\">&nbsp;&nbsp;<span class=\"disabled\">   Last </span></a>" : " &nbsp;&nbsp;<font color=\"#666666\"><span class=\"disabled\">  Last </span></font>";
            //currentpagestr += "&nbsp;&nbsp; <input id=\"Text1\" type=\"text\" />";

            //currentpagestr += "&nbsp;&nbsp; <a href=\"javascript:CheckStatus();\">GO</a>";
            return currentpagestr;
        }

    }
}

2、页面调用方法：

<MyRepeater:Repeater ID="Rep_List" runat="server" EnableViewState="false" ShowPagingWhenItemLessThanPageSize="True"
                OnItemDataBound="Rep_List_ItemDataBound">
                <HeaderTemplate>
                    <table id="tbMain" width="100%" border="0" cellpadding="0" cellspacing="0" class="content_tb">
                        <thead>
                            <tr>
                                <th align="left" style="text-align: left">
                                    <input type="checkbox" id="ckboxAll" />
                                </th>
                                <th>
                                    <a href="#" id="aSortEmpNo" sort="EmpNo-ASC">Emp No.</a>
                                </th>
                                <th>
                                    <a href="#" id="aSortEmailID" sort="EmailID-ASC">Email ID</a>
                                </th>
                                <th>
                                    <a href="#" id="aSortRole" sort="Role-ASC">Role</a>
                                </th>
                             </tr>
                        </thead>
                        <tbody>
                </HeaderTemplate>
                <ItemTemplate>
                    <tr class="search_tr" id="ResourceList" runat="server">
                        <td width="3%" style="white-space: nowrap;">
                            <input type="checkbox" value="<%# Eval("ID") %>" name="ckboxChild" style="display: inline" />
                        </td>
                        <td width="10%" style="text-align: right;">
                            <%# Eval("EmpNo") %>
                            <input type="hidden" value='' />
                        </td>
                        <td width="10%" style="text-align: right;">
                            <%# Eval("EmailID") %>
                            <input type="hidden" value='' />
                        </td>
                          <td width="5%" class="ResourceStyle">
                            <%# Eval("Role") %>
                        </td>
                    </tr>
                </ItemTemplate>
                <FooterTemplate>
                    </tbody> </table>
                </FooterTemplate>
            </MyRepeater:Repeater>

后台只需要把数据绑定；

3、常用高效数据库分页存储过程（借用的）：

--高效分页存储过程    
  
CREATE PROCEDURE [dbo].[GetListByPage](   
@Table nvarchar(500),          --表名   
@Field nvarchar(500) = '*',        --读取字段   
@Where  nvarchar(max) = NULL,       --Where条件   
@GroupBy nvarchar(500) = NULL,      --分组   
@OrderBy nvarchar(500)= NULL,       --排序字段   
@PrimaryKeyField nvarchar(50),      --主键必需    
@PageIndex int = 1,            --开始页码   
@PageSize int = 10,             --页大小   
@IsCount bit = 0          --返回记录总数   
  
------------------------------------------------------------------------------------------------   
--当@IsCount为1时,将同时返回2张表，表0为记录总数，表1为查询结果  
------------------------------------------------------------------------------------------------   
  
)   
AS   
BEGIN   
    ------------------------------------------------------------------------------------------------   
    DECLARE @strWhere nvarchar(500)                     --Where 条件   
    IF @Where IS NOT NULL AND @Where != ''              --Where 条件   
    BEGIN   
        SET @strWhere = ' WHERE ' + @Where + ' '   
    END   
    ELSE   
    BEGIN   
        SET @strWhere = ''   
    END   
    ----------------------------------------------------------------------------------------------------   
    DECLARE @strGroupBy nvarchar(500)                   --GroupBy 条件   
    IF @GroupBy IS NOT NULL AND @GroupBy != ''          --GroupBy 条件   
    BEGIN   
        SET @strGroupBy = ' GROUP BY ' + @GroupBy + ' '   
    END   
    ELSE   
    BEGIN   
        SET @strGroupBy = ''   
    END   
    ----------------------------------------------------------------------------------------------------   
    DECLARE @strOrderBy nvarchar(500)                   --OrderBy 条件   
    IF @OrderBy IS NULL OR @OrderBy = ''                --OrderBy 条件   
    BEGIN   
        SET @strOrderBy = ' ORDER BY ' + @PrimaryKeyField + ' DESC'   
    END   
    ELSE   
    BEGIN   
        SET @strOrderBy = ' ORDER BY ' + @OrderBy   
    END   
    ----------------------------------------------------------------------------------------------------   
    DECLARE @strSql nvarchar(max)   --Sql 语句   
    --计算总行数   
    IF @IsCount = 1   
    BEGIN   
        SET @strSql= 'SELECT  Count (*) AS RecordCount FROM ' + @Table + @strWhere + @strGroupBy   
        print @strSql  
        EXEC sp_executesql @strSql   
        --RETURN    
    END    
          
    ----------------------------------------------------------------------------------------------------   
    IF @PageIndex < 1                                  --第一页提高性能   
    BEGIN      
        SET @PageIndex = 1   
    END   
  
    IF @PageIndex = 1                             
    BEGIN   
        SET @strSql = 'SELECT TOP ' + str(@PageSize) +  ' ' + @Field + ' FROM ' + @Table +    
                       @strWhere + @strGroupBy + @strOrderBy   
        print @strSql  
        EXEC sp_executesql @strSql   
        RETURN   
    END   
    ----------------------------------------------------------------------------------------------------     
    DECLARE @STARTID nvarchar(50)   
    DECLARE @ENDID nvarchar(50)   
    SET @STARTID = convert(nvarchar(50),(@PageIndex - 1) * @PageSize + 1)   
    SET @ENDID = convert(nvarchar(50),@PageIndex * @PageSize)   
    SET @strSql = 'WITH MYTABLE AS (SELECT ROW_NUMBER() OVER (' + @strOrderBy + ')   
                   AS RowNumber,' + @Field + ' FROM '+ @Table +  @strWhere + @strGroupBy + ')    
                   SELECT * FROM MYTABLE    
                   WHERE RowNumber BETWEEN ' + @STARTID + ' AND ' + @ENDID   
    print @strSql  
    EXEC sp_executesql @strSql   
    --------------------------------------------------------------------------------------------------   
END  

4、有上面的存储过程的使用，同样可以在后台实现真分页