使用AspNetPager分页控件、分页存储过程及用户控件基类实现的完美分页功能
分页原来可以如此简单：
一、分页存储过程
二、需要分页的用户控件基类（里面还有一些信息提示的功能）：
三、需要分页的用户控件前台代码：
四、需要分页的用户控件后台代码：
好，大功告成了。这个用户控件，在Aspx里调用的时候，还可以加参数，比如页大小，条件，排序等。
<uc:ItemPageList ID="list" runat="server" PageSize="20" OrderBy="Id Desc" Where="Id < 200 and AddTime < getdate()" />
一、分页存储过程
1
/*
2
declare @P1 int,@p2 int
3set @P1=NULL
4exec sp_PageView @tbname = N'sim_NoteBook', @FieldKey = N'Id', @PageCurrent = 3, @PageSize = 10, @FieldShow = N'', @FieldOrder = N'Id', @Where = N'', @ItemCount=@p2 output,@PageCount = @P1 output
5select @P1
6select @p2
7
8exec sp_PageView 'sim_NoteBook', 'Id',@ItemCount=NULL,@PageCount=NULL
9
10
11exec sp_PageView @tbname = N'sim_NoteBook', @FieldKey = N'Id', @PageCurrent = 1, @PageSize = 10, @FieldShow = N'', @FieldOrder = N'Id Desc', @Where = N'', @ItemCount = 0, @PageCount = 0
12
*/
13CREATE PROC sp_PageView
14@tbname sysname, --要分页显示的表名
15@FieldKey nvarchar(1000), --用于定位记录的主键(惟一键)字段,可以是逗号分隔的多个字段
16@PageCurrent int=1, --要显示的页码
17@PageSize int=10, --每页的大小(记录数)
18@FieldShow nvarchar(1000)='', --以逗号分隔的要显示的字段列表,如果不指定,则显示所有字段
19@FieldOrder nvarchar(1000)='', --以逗号分隔的排序字段列表,可以指定在字段后面指定DESC/ASC,用于指定排序顺序
20@Where nvarchar(1000)='', --查询条件
21@ItemCount int OUTPUT,
22@PageCount int OUTPUT --总页数
23AS
24SET NOCOUNT ON
25--检查对象是否有效
26IF OBJECT_ID(@tbname) IS NULL
27BEGIN
28 RAISERROR(N'对象"%s"不存在',1,16,@tbname)
29 RETURN
30END
31IF OBJECTPROPERTY(OBJECT_ID(@tbname),N'IsTable')=0
32 AND OBJECTPROPERTY(OBJECT_ID(@tbname),N'IsView')=0
33 AND OBJECTPROPERTY(OBJECT_ID(@tbname),N'IsTableFunction')=0
34BEGIN
35 RAISERROR(N'"%s"不是表、视图或者表值函数',1,16,@tbname)
36 RETURN
37END
38--分页字段检查
39IF ISNULL(@FieldKey,N'')=''
40BEGIN
41 RAISERROR(N'分页处理需要主键（或者惟一键）',1,16)
42 RETURN
43END
44--其他参数检查及规范
45IF ISNULL(@PageCurrent,0)<1 SET @PageCurrent=1
46IF ISNULL(@PageSize,0)<1 SET @PageSize=10
47IF ISNULL(@FieldShow,N'')=N'' SET @FieldShow=N'*'
48IF ISNULL(@FieldOrder,N'')=N''
49 SET @FieldOrder=N''
50ELSE
51 SET @FieldOrder=N'ORDER BY '+LTRIM(@FieldOrder)
52IF ISNULL(@Where,N'')=N''
53 SET @Where=N''
54ELSE
55 SET @Where=N'WHERE ('+@Where+N')'
56--如果@PageCount为NULL值,则计算总页数(这样设计可以只在第一次计算总页数,以后调用时,把总页数传回给存储过程,避免再次计算总页数,对于不想计算总页数的处理而言,可以给@PageCount赋值)
57
58 DECLARE @sql nvarchar(4000)
59 SET @sql=N'SELECT @ItemCount=COUNT(*)'
60 +N' FROM '+@tbname
61 +N' '+@Where
62 EXEC sp_executesql @sql,N'@ItemCount int OUTPUT',@ItemCount OUTPUT
63 SET @PageCount=(@ItemCount+@PageSize-1)/@PageSize
64
65print @PageCount
66print @ItemCount
67--计算分页显示的TOPN值
68DECLARE @TopN varchar(20),@TopN1 varchar(20)
69SELECT @TopN=@PageSize,
70 @TopN1=(@PageCurrent-1)*@PageSize
71--第一页直接显示
72IF @PageCurrent=1
73 EXEC(N'SELECT TOP '+@TopN
74 +N' '+@FieldShow
75 +N' FROM '+@tbname
76 +N' '+@Where
77 +N' '+@FieldOrder)
78ELSE
79BEGIN
80 --处理别名
81 IF @FieldShow=N'*'
82 SET @FieldShow=N'a.*'
83 --生成主键(惟一键)处理条件
84 DECLARE @Where1 nvarchar(4000),@Where2 nvarchar(4000),
85 @s nvarchar(1000),@Field sysname
86 SELECT @Where1=N'',@Where2=N'',@s=@FieldKey
87 WHILE CHARINDEX(N',',@s)>0
88 SELECT @Field=LEFT(@s,CHARINDEX(N',',@s)-1),
89 @s=STUFF(@s,1,CHARINDEX(N',',@s),N''),
90 @Where1=@Where1+N' AND a.'+@Field+N'=b.'+@Field,
91 @Where2=@Where2+N' AND b.'+@Field+N' IS NULL',
92 --@Where=REPLACE(@Where,@Field,N'a.'+@Field),
93 @FieldOrder=REPLACE(@FieldOrder,@Field,N'a.'+@Field),
94 @FieldShow=REPLACE(@FieldShow,@Field,N'a.'+@Field)
95 SELECT --@Where=REPLACE(@Where,@s,N'a.'+@s),
96 @FieldOrder=REPLACE(@FieldOrder,@s,N'a.'+@s),
97 @FieldShow=REPLACE(@FieldShow,@s,N'a.'+@s),
98 @Where1=STUFF(@Where1+N' AND a.'+@s+N'=b.'+@s,1,5,N''),
99 @Where2=CASE
100 WHEN @Where='' THEN N'WHERE ('
101 ELSE @Where+N' AND ('
102 END+N'b.'+@s+N' IS NULL'+@Where2+N')'
103 DECLARE @QUERYSTRING varchar(2000)
104 SET @QUERYSTRING = N'SELECT TOP '+@TopN
105 +N' '+@FieldShow
106 +N' FROM '+@tbname
107 +N' a LEFT JOIN(SELECT TOP '+@TopN1
108 +N' '+@FieldKey
109 +N' FROM '+@tbname
110 +N' a '+@Where
111 +N' '+@FieldOrder
112 +N')b ON '+@Where1
113 +N' '+@Where2
114 +N' '+@FieldOrder
115 PRINT @QUERYSTRING
116 --执行查询
117 EXEC(@QUERYSTRING)
118
119
120END
121GO
122
/*
2
declare @P1 int,@p2 int3
set @P1=NULL4
exec sp_PageView @tbname = N'sim_NoteBook', @FieldKey = N'Id', @PageCurrent = 3, @PageSize = 10, @FieldShow = N'', @FieldOrder = N'Id', @Where = N'', @ItemCount=@p2 output,@PageCount = @P1 output5
select @P16
select @p27
8
exec sp_PageView 'sim_NoteBook', 'Id',@ItemCount=NULL,@PageCount=NULL9
10
11
exec sp_PageView @tbname = N'sim_NoteBook', @FieldKey = N'Id', @PageCurrent = 1, @PageSize = 10, @FieldShow = N'', @FieldOrder = N'Id Desc', @Where = N'', @ItemCount = 0, @PageCount = 012
*/13
CREATE PROC sp_PageView14
@tbname sysname, --要分页显示的表名15
@FieldKey nvarchar(1000), --用于定位记录的主键(惟一键)字段,可以是逗号分隔的多个字段16
@PageCurrent int=1, --要显示的页码17
@PageSize int=10, --每页的大小(记录数)18
@FieldShow nvarchar(1000)='', --以逗号分隔的要显示的字段列表,如果不指定,则显示所有字段19
@FieldOrder nvarchar(1000)='', --以逗号分隔的排序字段列表,可以指定在字段后面指定DESC/ASC,用于指定排序顺序20
@Where nvarchar(1000)='', --查询条件21
@ItemCount int OUTPUT,22
@PageCount int OUTPUT --总页数23
AS24
SET NOCOUNT ON25
--检查对象是否有效26
IF OBJECT_ID(@tbname) IS NULL27
BEGIN28
RAISERROR(N'对象"%s"不存在',1,16,@tbname)29
RETURN30
END31
IF OBJECTPROPERTY(OBJECT_ID(@tbname),N'IsTable')=032
AND OBJECTPROPERTY(OBJECT_ID(@tbname),N'IsView')=033
AND OBJECTPROPERTY(OBJECT_ID(@tbname),N'IsTableFunction')=034
BEGIN35
RAISERROR(N'"%s"不是表、视图或者表值函数',1,16,@tbname)36
RETURN37
END38
--分页字段检查39
IF ISNULL(@FieldKey,N'')=''40
BEGIN41
RAISERROR(N'分页处理需要主键（或者惟一键）',1,16)42
RETURN43
END44
--其他参数检查及规范45
IF ISNULL(@PageCurrent,0)<1 SET @PageCurrent=146
IF ISNULL(@PageSize,0)<1 SET @PageSize=1047
IF ISNULL(@FieldShow,N'')=N'' SET @FieldShow=N'*'48
IF ISNULL(@FieldOrder,N'')=N''49
SET @FieldOrder=N''50
ELSE51
SET @FieldOrder=N'ORDER BY '+LTRIM(@FieldOrder)52
IF ISNULL(@Where,N'')=N''53
SET @Where=N''54
ELSE55
SET @Where=N'WHERE ('+@Where+N')'56
--如果@PageCount为NULL值,则计算总页数(这样设计可以只在第一次计算总页数,以后调用时,把总页数传回给存储过程,避免再次计算总页数,对于不想计算总页数的处理而言,可以给@PageCount赋值)57
58
DECLARE @sql nvarchar(4000)59
SET @sql=N'SELECT @ItemCount=COUNT(*)'60
+N' FROM '+@tbname61
+N' '+@Where62
EXEC sp_executesql @sql,N'@ItemCount int OUTPUT',@ItemCount OUTPUT63
SET @PageCount=(@ItemCount+@PageSize-1)/@PageSize64
65
print @PageCount66
print @ItemCount67
--计算分页显示的TOPN值68
DECLARE @TopN varchar(20),@TopN1 varchar(20)69
SELECT @TopN=@PageSize,70
@TopN1=(@PageCurrent-1)*@PageSize71
--第一页直接显示72
IF @PageCurrent=173
EXEC(N'SELECT TOP '+@TopN74
+N' '+@FieldShow75
+N' FROM '+@tbname76
+N' '+@Where77
+N' '+@FieldOrder)78
ELSE79
BEGIN80
--处理别名81
IF @FieldShow=N'*'82
SET @FieldShow=N'a.*'83
--生成主键(惟一键)处理条件84
DECLARE @Where1 nvarchar(4000),@Where2 nvarchar(4000),85
@s nvarchar(1000),@Field sysname86
SELECT @Where1=N'',@Where2=N'',@s=@FieldKey87
WHILE CHARINDEX(N',',@s)>088
SELECT @Field=LEFT(@s,CHARINDEX(N',',@s)-1),89
@s=STUFF(@s,1,CHARINDEX(N',',@s),N''),90
@Where1=@Where1+N' AND a.'+@Field+N'=b.'+@Field,91
@Where2=@Where2+N' AND b.'+@Field+N' IS NULL',92
--@Where=REPLACE(@Where,@Field,N'a.'+@Field),93
@FieldOrder=REPLACE(@FieldOrder,@Field,N'a.'+@Field),94
@FieldShow=REPLACE(@FieldShow,@Field,N'a.'+@Field)95
SELECT --@Where=REPLACE(@Where,@s,N'a.'+@s),96
@FieldOrder=REPLACE(@FieldOrder,@s,N'a.'+@s),97
@FieldShow=REPLACE(@FieldShow,@s,N'a.'+@s),98
@Where1=STUFF(@Where1+N' AND a.'+@s+N'=b.'+@s,1,5,N''), 99
@Where2=CASE100
WHEN @Where='' THEN N'WHERE ('101
ELSE @Where+N' AND ('102
END+N'b.'+@s+N' IS NULL'+@Where2+N')'103
DECLARE @QUERYSTRING varchar(2000)104
SET @QUERYSTRING = N'SELECT TOP '+@TopN105
+N' '+@FieldShow106
+N' FROM '+@tbname107
+N' a LEFT JOIN(SELECT TOP '+@TopN1108
+N' '+@FieldKey109
+N' FROM '+@tbname110
+N' a '+@Where111
+N' '+@FieldOrder112
+N')b ON '+@Where1113
+N' '+@Where2114
+N' '+@FieldOrder115
PRINT @QUERYSTRING 116
--执行查询117
EXEC(@QUERYSTRING)118
119
120
END121
GO122
二、需要分页的用户控件基类（里面还有一些信息提示的功能）：
1using System;
2using System.Collections.Generic;
3using System.Text;
4using System.Web.UI;
5using System.Web.UI.WebControls;
6using Wuqi.Webdiyer;
7
8namespace Foundway.Project.Web
9{
10 public class UserControlBase : UserControl
11
{
12 protected override void OnLoad(EventArgs e)
13 {
14 base.OnLoad(e);
15
16 Label labelMsg = this.FindControl("labelMsg") as Label;
17 if (labelMsg != null)
18 {
19 labelMsg.Visible = false;
20
}
21 }
22
23 protected void ShowMessage(string message)
24 {
25 Label labelMsg = this.FindControl("labelMsg") as Label;
26 if (labelMsg != null)
27 {
28 labelMsg.Visible = true;
29 labelMsg.Text = message;
30 }
31 }
32
33 protected void ShowMessage(string message, Exception exp)
34 {
35 Label labelMsg = this.FindControl("labelMsg") as Label;
36 if (labelMsg != null)
37 {
38 labelMsg.Visible = true;
39 labelMsg.Text = message + "。详情为：" + exp.Message;
40 }
41 }
42
43 protected void AlertMessage(string message)
44 {
45 Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", String.Format(@"alert(""{0}"");", message), true);
46 }
47
48 protected void AlertMessage(string message, string redirecturl)
49 {
50 AlertMessage(message, redirecturl, false);
51 }
52
53 protected void AlertMessage(string message, string redirecturl, bool canBack)
54 {
55 Response.Clear();
56
57 if (canBack)
58 Response.Write(String.Format(@"<script>alert(""{0}"");location.href='{1}';</script>", message, redirecturl));
59 else
60 Response.Write(String.Format(@"<script>alert(""{0}"");location.replace('{1}');</script>", message, redirecturl));
61
62 Response.End();
63 }
64 }
65
66 public class ListUserControlBase : UserControlBase
67 {
68 // Fields
69 protected int ItemCount;
70
71 // Properties
72 public string OrderBy
73 {
74 get
75 {
76 if (this.ViewState["__OrderBy"] == null)
77 {
78 this.ViewState["__OrderBy"] = "";
79 }
80 return this.ViewState["__OrderBy"].ToString();
81 }
82 set
83 {
84 this.ViewState["__OrderBy"] = value;
85 }
86 }
87
88 public string Where
89 {
90 get
91 {
92 if (this.ViewState["__Where"] == null)
93 {
94 this.ViewState["__Where"] = "1=1";
95 }
96 return this.ViewState["__Where"].ToString();
97 }
98 set
99 {
100 this.ViewState["__Where"] = value;
101 }
102 }
103 }
104
105 public class PageUserControlBase : ListUserControlBase
106 {
107 // Fields
108 protected int PageCount;
109 protected AspNetPager pagerBottom;
110 protected AspNetPager pagerTop;
111
112 // Methods
113 protected virtual void BindData(int pageIndex)
114 {
115 this.PageIndex = pageIndex;
116 if (this.pagerTop != null)
117 {
118 this.pagerTop.PageSize = this.PageSize;
119 this.pagerTop.RecordCount = base.ItemCount;
120 this.pagerTop.CurrentPageIndex = pageIndex;
121 }
122 if (this.pagerBottom != null)
123 {
124 this.pagerBottom.PageSize = this.PageSize;
125 this.pagerBottom.RecordCount = base.ItemCount;
126 this.pagerBottom.CurrentPageIndex = pageIndex;
127 }
128 }
129
130 protected virtual void OnPageChanged(object sender, EventArgs e)
131 {
132 AspNetPager pager = (AspNetPager)sender;
133 this.BindData(pager.CurrentPageIndex);
134 }
135
136 // Properties
137 public int PageIndex
138 {
139 get
140 {
141 if (this.ViewState["__PageIndex"] == null)
142 {
143 this.ViewState["__PageIndex"] = 1;
144 }
145 return Convert.ToInt32(this.ViewState["__PageIndex"]);
146 }
147 set
148 {
149 this.ViewState["__PageIndex"] = value;
150 }
151 }
152
153 public int PageSize
154 {
155 get
156 {
157 if (this.ViewState["__PageSize"] == null)
158 {
159 this.ViewState["__PageSize"] = 10;
160 }
161 return Convert.ToInt32(this.ViewState["__PageSize"]);
162 }
163 set
164 {
165 this.ViewState["__PageSize"] = value;
166 }
167 }
168 }
169
170}
171
using System;2
using System.Collections.Generic;3
using System.Text;4
using System.Web.UI;5
using System.Web.UI.WebControls;6
using Wuqi.Webdiyer;7
8
namespace Foundway.Project.Web9
{
10
public class UserControlBase : UserControl11
{
12
protected override void OnLoad(EventArgs e)13
{14
base.OnLoad(e);15
16
Label labelMsg = this.FindControl("labelMsg") as Label;17
if (labelMsg != null)18
{19
labelMsg.Visible = false;20
}21
}22
23
protected void ShowMessage(string message)24
{25
Label labelMsg = this.FindControl("labelMsg") as Label;26
if (labelMsg != null)27
{28
labelMsg.Visible = true;29
labelMsg.Text = message;30
}31
}32
33
protected void ShowMessage(string message, Exception exp)34
{35
Label labelMsg = this.FindControl("labelMsg") as Label;36
if (labelMsg != null)37
{38
labelMsg.Visible = true;39
labelMsg.Text = message + "。详情为：" + exp.Message;40
}41
}42
43
protected void AlertMessage(string message)44
{45
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", String.Format(@"alert(""{0}"");", message), true);46
}47
48
protected void AlertMessage(string message, string redirecturl)49
{50
AlertMessage(message, redirecturl, false);51
}52
53
protected void AlertMessage(string message, string redirecturl, bool canBack)54
{55
Response.Clear();56
57
if (canBack)58
Response.Write(String.Format(@"<script>alert(""{0}"");location.href='{1}';</script>", message, redirecturl));59
else60
Response.Write(String.Format(@"<script>alert(""{0}"");location.replace('{1}');</script>", message, redirecturl));61
62
Response.End();63
}64
}65
66
public class ListUserControlBase : UserControlBase67
{68
// Fields69
protected int ItemCount;70
71
// Properties72
public string OrderBy73
{74
get75
{76
if (this.ViewState["__OrderBy"] == null)77
{78
this.ViewState["__OrderBy"] = "";79
}80
return this.ViewState["__OrderBy"].ToString();81
}82
set83
{84
this.ViewState["__OrderBy"] = value;85
}86
}87
88
public string Where89
{90
get91
{92
if (this.ViewState["__Where"] == null)93
{94
this.ViewState["__Where"] = "1=1";95
}96
return this.ViewState["__Where"].ToString();97
}98
set99
{100
this.ViewState["__Where"] = value;101
}102
}103
}104
105
public class PageUserControlBase : ListUserControlBase106
{107
// Fields108
protected int PageCount;109
protected AspNetPager pagerBottom;110
protected AspNetPager pagerTop;111
112
// Methods113
protected virtual void BindData(int pageIndex)114
{115
this.PageIndex = pageIndex;116
if (this.pagerTop != null)117
{118
this.pagerTop.PageSize = this.PageSize;119
this.pagerTop.RecordCount = base.ItemCount;120
this.pagerTop.CurrentPageIndex = pageIndex;121
}122
if (this.pagerBottom != null)123
{124
this.pagerBottom.PageSize = this.PageSize;125
this.pagerBottom.RecordCount = base.ItemCount;126
this.pagerBottom.CurrentPageIndex = pageIndex;127
}128
}129
130
protected virtual void OnPageChanged(object sender, EventArgs e)131
{132
AspNetPager pager = (AspNetPager)sender;133
this.BindData(pager.CurrentPageIndex);134
}135
136
// Properties137
public int PageIndex138
{139
get140
{141
if (this.ViewState["__PageIndex"] == null)142
{143
this.ViewState["__PageIndex"] = 1;144
}145
return Convert.ToInt32(this.ViewState["__PageIndex"]);146
}147
set148
{149
this.ViewState["__PageIndex"] = value;150
}151
}152
153
public int PageSize154
{155
get156
{157
if (this.ViewState["__PageSize"] == null)158
{159
this.ViewState["__PageSize"] = 10;160
}161
return Convert.ToInt32(this.ViewState["__PageSize"]);162
}163
set164
{165
this.ViewState["__PageSize"] = value;166
}167
}168
}169
170
}171
三、需要分页的用户控件前台代码：
1<%@ Control Language="C#" Inherits="GotAspx.Sample.Facade.Controls.ItemPageList" %>
2
3记录列表
4<asp:DivLabel ID="labelMsg" runat="server"></asp:DivLabel>
5<asp:Repeater id="repeaterItem" runat="server">
6 <HeaderTemplate><table>
7 <tr>
8 <th>序号</th>
9 <th>名称</th>
10 </tr>
11 </HeaderTemplate>
12 <FooterTemplate></table></FooterTemplate>
13 <ItemTemplate>
14 <tr>
15 <td><%# Container.ItemIndex + 1 %></td>
16 <td><%# Eval("Name") %></td>
17 </tr>
18 </ItemTemplate>
19</asp:Repeater>
20<asp:AspNetPager ID="pagerBottom" runat="server" OnPageChanged="OnPageChanged" />
<%@ Control Language="C#" Inherits="GotAspx.Sample.Facade.Controls.ItemPageList" %>2
3
记录列表4
<asp:DivLabel ID="labelMsg" runat="server"></asp:DivLabel>5
<asp:Repeater id="repeaterItem" runat="server">6
<HeaderTemplate><table>7
<tr>8
<th>序号</th>9
<th>名称</th>10
</tr>11
</HeaderTemplate>12
<FooterTemplate></table></FooterTemplate>13
<ItemTemplate>14
<tr>15
<td><%# Container.ItemIndex + 1 %></td>16
<td><%# Eval("Name") %></td>17
</tr>18
</ItemTemplate>19
</asp:Repeater>20
<asp:AspNetPager ID="pagerBottom" runat="server" OnPageChanged="OnPageChanged" />四、需要分页的用户控件后台代码：
1using System;
2using System.Collections.Generic;
3using System.Text;
4using System.Web.UI.WebControls;
5using System.Data;
6using Foundway.Project.Data.Sql;
7
8namespace GotAspx.Sample.Facade.Controls
9{
10 public class ItemPageList : PageUserControlBase
11 {
12 protected Repeater repeaterItem;
13
14 protected override void OnLoad(EventArgs e)
15 {
16 base.OnLoad(e);
17
18 if (!Page.IsPostBack)
19 {
20 BindData(1);
21 }
22 }
23
24 protected override void BindData(int pageIndex)
25 {
26 //此处为调用分页存储过程
27 DataSet ds = DbUtility.QueryPagerData("jc_Province", "Id", pageIndex, PageSize, "", OrderBy, Where, out ItemCount, out PageCount);
28 if (ItemCount > 0)
29 {
30 repeaterItem.Visible = true;
31 repeaterItem.DataSource = ds;
32 repeaterItem.DataBind();
33 }
34 else
35 {
36 repeaterItem.Visible = false;
37 ShowMessage("还没有添加记录");
38 }
39
40 base.BindData(pageIndex);
41 }
42 }
43}
44
using System;2
using System.Collections.Generic;3
using System.Text;4
using System.Web.UI.WebControls;5
using System.Data;6
using Foundway.Project.Data.Sql;7
8
namespace GotAspx.Sample.Facade.Controls9
{10
public class ItemPageList : PageUserControlBase11
{12
protected Repeater repeaterItem;13
14
protected override void OnLoad(EventArgs e)15
{16
base.OnLoad(e);17
18
if (!Page.IsPostBack)19
{20
BindData(1);21
}22
}23
24
protected override void BindData(int pageIndex)25
{26
//此处为调用分页存储过程27
DataSet ds = DbUtility.QueryPagerData("jc_Province", "Id", pageIndex, PageSize, "", OrderBy, Where, out ItemCount, out PageCount);28
if (ItemCount > 0)29
{30
repeaterItem.Visible = true;31
repeaterItem.DataSource = ds;32
repeaterItem.DataBind();33
}34
else35
{36
repeaterItem.Visible = false;37
ShowMessage("还没有添加记录");38
}39
40
base.BindData(pageIndex);41
}42
}43
}44
好，大功告成了。这个用户控件，在Aspx里调用的时候，还可以加参数，比如页大小，条件，排序等。
<uc:ItemPageList ID="list" runat="server" PageSize="20" OrderBy="Id Desc" Where="Id < 200 and AddTime < getdate()" />
