LS的分页（2005-5-25）

A,gammadoctor
    计划将子站点的页面连上后台
B，LS
    分页功能完善

   string sql="select top "+PageSize+" * "
    +"from tomain "
    +"where (tomainid > "
    +"(select isnull(max(tomainid), 0) "
    +"from (select top "+PageSize*(Pages-1)+" tomainid "
    +"from tomain where RoNumber like '%'+@RoNumber+'%' and LicenseNo like '%'+@licenseno+'%' and CustomName like '%'+@CustomName+'%' "
    +"order by tomainid) a)) and  RoNumber like '%'+@RoNumber+'%' and LicenseNo like '%'+@licenseno+'%' and CustomName like '%'+@CustomName+'%' "
    +"order by tomainid ";

很奇怪的是PageSize无法使用参数，