CREATE PROCEDURE [dbo].[USP_GetList]

　　(

　　@pageIndex int = 1 -- 当前页码0 表示返回所有符合内容

　　,@pageSize int = 10 -- 页尺寸

　　,@SID nvarchar(30) = '' -- 主键字段

　　,@strGetField nvarchar(1000) = '*' -- 需要返回的列

　　,@strTableName nvarchar(30) = '' --表名

　　,@strWhere nvarchar(2000) = '' -- 查询条件(注意: 条件中要带where)

　　,@strOrderBy nvarchar(300) = '' -- 排序

　　--,@MemberID int=0 --会员ID

　　)

　　AS

　　SET NOCOUNT ON

　　DECLARE @strSQL nvarchar(4000)

　　DECLARE @startPos int

　　DECLARE @endPos int

　　DECLARE @num int

　　SET @startPos=@pageSize*(@pageIndex-1)+1

　　SET @endPos=@startPos+@pageSize-1

　　--页大小*(页数-1)

　　SET @num = @pageSize * (@PageIndex - 1)

　　IF @PageIndex!=0

　　BEGIN

　　IF @strWhere != ''

　　SET @strSQL = 'SELECT TOP '+ cast(@pageSize as nvarchar(10)) +' '+ @strGetField +' FROM '+ @strTableName +' WHERE ('+ cast(@SID as nvarchar(30)) +' NOT IN (SELECT TOP '+ cast(@num as nvarchar(20)) +' '+ cast(@SID as nvarchar(30)) +' FROM '+ @strTableName +' where '+@strWhere+' ORDER BY '+ cast(@strOrderBy as nvarchar(255)) +' )) and '+@strwhere+' ORDER BY '+cast(@strOrderBy as varchar(255)) + ''

　　else

　　SET @strSQL = 'SELECT TOP '+ cast(@pageSize as nvarchar(10)) +' '+ @strGetField +' FROM '+ @strTableName +' WHERE ('+ cast(@SID as nvarchar(30)) +' NOT IN (SELECT TOP '+ cast(@num as nvarchar(20)) +' '+ cast(@SID as nvarchar(30)) +' FROM '+ @strTableName +' ORDER BY '+ cast(@strOrderBy as nvarchar(255)) +' )) ORDER BY '+ cast(@strOrderBy as varchar(255)) + ''