asp.net学习_分页的设计(18)

  42:         
  43:           else
  44:               begin
  45:                   set @strTmp = '>(select max'
  46:                   set @strOrder = ' order by [' + @fldName +'] asc'
  47:               end
  48:               if @PageIndex = 1
  49:                   begin
  50:                       if @strWhere != ''
  51:                           set @strSQL = 'select top ' + str(@PageSize) +' '+@strGetFields+ ' from [' + @tblName + '] '+@innerJohn +' where ' + @strWhere + ' ' + @strOrder
  52:                       else
  53:                           set @strSQL = 'select top ' + str(@PageSize) +' '+@strGetFields+ ' from ['+ @tblName + '] '+@innerJohn + @strOrder
  54:                           --如果是第一页就执行以上代码，这样会加快执行速度
  55:                   end
  56:               else
  57:                   begin
  58:                       --以下代码赋予了@strSQL以真正执行的SQL代码
  59:                       set @strSQL = 'select top ' + str(@PageSize) +' '+@strGetFields+ ' from '
  60:                           + @tblName + ' '+@innerJohn+ ' where [' + @fldName + ']' + @strTmp + '(['+ @fldName + ']) from (select top ' + str((@PageIndex-1)*@PageSize) + ' ['+ @fldName + '] from [' + @tblName + '] '+@innerJohn +' ' + @strOrder + ') as tblTmp)'+ @strOrder