C#中GridView中的分页算法重写

USE [PortalTemplate3]
GO
/****** Object:  StoredProcedure [dbo].[P_PORTAL_GENERALPAGING]    Script Date: 08/26/2014 15:56:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER PROCEDURE [dbo].[P_PORTAL_GENERALPAGING]
 @p_table  varchar(8000),
@p_sqlwhere varchar(8000),
@p_columns  varchar(8000),
@p_ordercolumn  varchar(8000),
@p_rowstart int,
@p_rowend int,
@p_groupby varchar(8000)
AS
BEGIN
SET NOCOUNT ON;
 
   DECLARE @PagingSQL NVARCHAR(max)
   DECLARE @CountSQL NVARCHAR(max)
   DECLARE @ParmDefinition nvarchar(500)


set  @PagingSQL = N'With TempPageTable As'
+'(SELECT '+@p_columns+',ROW_NUMBER() OVER (Order By '+@p_ordercolumn+') as RowNumber FROM '+@p_table+' '+@p_sqlwhere+' '+@p_groupby+')'
+' Select * From TempPageTable Where RowNumber between @rowStart and @rowEnd;'
--+' Select Count(*) From '+ @tableParm+' '+ @sqlWhereParm
    
    
    set @CountSQL = N'Select Count(*) From '+ @p_table+' '+ @p_sqlwhere +' '+@p_groupby
    
set @ParmDefinition = N'@rowStart int,@rowEnd int';


EXECUTE sp_executesql @PagingSQL,@ParmDefinition,@rowStart=@p_rowstart,@rowEnd=@p_rowend;
     EXECUTE sp_executesql @CountSQL
END