End
elseif(@CurrentPage=@TotalPage)
begin
set@afterRows=@RowsCount-(@CurrentPage-1)*@PageSize
setRowCount@afterRows
if(@OrderType=1)
begin
set@OrderField=REPLACE(@OrderField,asc,lai512343975)//这里用变量将asc和desc交换,哈哈,太神了
set@OrderField=REPLACE(@OrderField,desc,asc)
set@OrderField=REPLACE(@OrderField,lai512343975,desc)
set@Sql=select+@SelectFields+from+@TableName+where+@strWhere+orderby+@OrderField+desc+,+@IdField+asc
end
else
begin
set@OrderField=REPLACE(@OrderField,desc,lai512343975)
set@OrderField=REPLACE(@OrderField,asc,desc)
set@OrderField=REPLACE(@OrderField,lai512343975,asc)
set@Sql=select+@SelectFields+from+@TableName+where+@strWhere+orderby+@OrderField+asc+,+@IdField+asc
print(@Sql)
end
--print(@Sql)
execsp_executeSql@Sql
end
else
Begin
set@nRd=@PageSize*(@CurrentPage-1)
print(@nRd)
setRowCount@PageSize
set@Sql=select+@SelectFields+from+@TableName+where+@strWhere+and+@IdField+notin(selecttop+cast(@nRdasnvarchar(10))++@IdField+from+@TableName+where+@strWhere+orderby+@OrderField++@OrderSql+,+@IdField+asc)+orderby+@OrderField++@OrderSql+,+@IdField+asc
execsp_executeSql@Sql
--Print(@sql)
End
end
GO