set @SQL2 = @SQL2 + ‘ set rowcount ‘ + convert(varchar, @PageSize) –设置返回记录数为页大小
set @Where = @Where + ‘ and ‘ + @PK + @SortDirection + ‘@Sort’
set @SQL2 = @SQL2 + ‘ select ‘ + @Fields + ‘ from ‘ + @Tables + @Where + ‘ order by ‘ + @OrderBy –输出最终显示结果
end
else
begin
–****************************************************************************
–*************需要创建自增长主键******************************************
–****************************************************************************
set @SQL2 = @SQL2 + ‘ declare @EndRow int’
set @SQL2 = @SQL2 + ‘ set @EndRow=@PageIndex*’ + convert(varchar, @PageSize)
set @SQL2 = @SQL2 + ‘ set rowcount @EndRow’
set @SQL2 = @SQL2 + ‘ declare @PKBegin int’ –声明一个变量，开始索引
set @SQL2 = @SQL2 + ‘ declare @PKEnd int’ –声明一个变量，结束索引
set @SQL2 = @SQL2 + ‘ set @PKBegin=@StartRow’
set @SQL2 = @SQL2 + ‘ set @PKEnd=@EndRow’
–****************************************************************************
–************对特殊字段进行转换，以便可以插入到临时表******************
–****************************************************************************
declare @TempFields varchar(500)
set @TempFields=@Fields
set @TempFields = replace(@TempFields, ””’ as CheckBox’, ”)
set @TempFields = replace(@TempFields, ””’ as DetailButton’, ”)
set @TempFields = replace(@TempFields, ””’ as Radio’, ”)
