aspnetpage分页存储过程

在ASPNETPAGE官方网站上自动生成的分页存储过程是不能加WHERE参数的，因为那个不能构建SQL语句，自己做了一个，用临时表的。

CREATE procedure sp_sys_OrgInfo_GetList
(@pagesize int,
@pageindex int,
@str_Where char(100))
as
set nocount on
begin
create table #t(id int identity(1,1),nid int)
declare @PageLowerBound int
declare @PageUpperBound int
declare @SQL varchar(400)
set @PageLowerBound=(@pageindex-1)*@pagesize
set @PageUpperBound=@PageLowerBound+@pagesize
set rowcount @PageUpperBound
set @SQL=\’insert into #t(nid) select orgid from sys_orginfo\’+@str_Where+\’ order by orgid desc\’
exec(@SQL)
select * from sys_orginfo b,#t t where b.orgid=t.nid
and t.id between @PageLowerBound+1 and @PageUpperBound order by t.id
end
set nocount off