AspNetPage分页控件-优快云博客

【1】

AspNetPage分页控件的存储过程。

set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go /**** 名称：分页存储过程作者：shuiyao 描述：传入表名,主键,与搜索条件 ***/ --EXEC public_page '15', '1', 'where 1=1', 'ID', 'shop_020' ALTER procedure [dbo].[PR_public_page] @PageSize int,--页大小 @CurrPage int,--当前页 @SearchSql NVarChar(4000),--搜索条件where @strview nvarchar(40),--表名或视图名 @strcode nvarchar(40)--主键id AS declare @queryStr nvarchar(1000)--查询语句 declare @keyField nvarchar (200) --主键id declare @pageNumber int set @queryStr ='* from '+@strview+' '+@SearchSql set @keyField=@strcode set @pageNumber=@CurrPage-1 set nocount on BEGIN DECLARE @sqlText AS nvarchar(4000) DECLARE @sqlTable AS nvarchar(4000) SET @sqlTable = 'SELECT TOP ' + CAST((@pageNumber + 1) * @pageSize AS varchar(30)) + ' ' + @queryStr SET @sqlText = 'SELECT TOP ' + CAST(@pageSize AS varchar(30)) + ' * ' + 'FROM (' + @sqlTable + ') AS tableA ' + 'WHERE ' + @keyField + ' NOT IN(SELECT TOP ' + CAST(@pageNumber * @pageSize AS varchar(30)) + ' ' + @keyField + ' FROM (' + @sqlTable + ') AS tableB)' EXEC (@sqlText) END set nocount off