关于吴旗娃分页控件For mssqlserver版

[yibin2006]

在演示页中看到有结合MS Sqlserver存储过程的分页
但存储过程在哪里？可以提供么？

[潜水员2099]

去
http://www.webdiyer.com
下载!

[jetsteven]

--分页，短消息。
CREATE PROCEDURE [a_mail_page]
(@pagesize int,
@pageindex int,
@docount bit,
@userid int,
@box int)
as
set nocount on
declare @indextable table(id int identity(1,1),nid int)
declare @PageLowerBound int
declare @PageUpperBound int

if(@box=1) --@box 1代表收件箱，@box 2代表发件箱
begin
if(@docount=1)
select count(mailid)
from vd_mailinbox
where touserid = @userid and touse=1 --fromuse=1表示没有删除
else
begin
set @PageLowerBound=(@pageindex-1)*@pagesize
set @PageUpperBound=@PageLowerBound+@pagesize
set rowcount @PageUpperBound
insert into @indextable(nid)
select mailid from vd_mailinbox
where touserid = @userid and touse=1 order by mailid desc
select O.mailid, O.crdate, O.username , O.remind, O.title
from vd_mailinbox O,@indextable t
where O.mailid=t.nid
and t.id>@PageLowerBound and t.id<=@PageUpperBound order by t.id
end
end
else
begin
if(@docount=1)
select count(mailid) from vd_mailOutbox
where fromuserid = @userid and fromuse=1 --fromuse=1表示没有删除
else
begin
set @PageLowerBound=(@pageindex-1)*@pagesize
set @PageUpperBound=@PageLowerBound+@pagesize
set rowcount @PageUpperBound
insert into @indextable(nid) select mailid from vd_mailoutbox where fromuserid=@userid and fromuse=1 order by mailid desc
select O.mailid, O.crdate, O.username , O.remind, O.title from vd_mailOutbox O,@indextable t where O.mailid=t.nid
and t.id>@PageLowerBound and t.id<=@PageUpperBound order by t.id
end
end

set nocount off
GO

[job_2006]

顶一下

[szc21]

同顶