动易标签分页

最新推荐文章于 2021-07-06 04:44:33 发布

生活在他方

最新推荐文章于 2021-07-06 04:44:33 发布

阅读量2.6k

点赞数

分类专栏：网站管理员日记前台开发资料

本文链接：https://blog.csdn.net/wuyt2008/article/details/9188497

版权

前台开发资料同时被 2 个专栏收录

29 篇文章 0 订阅

订阅专栏

网站管理员日记

15 篇文章 0 订阅

订阅专栏

SELECT  top @pagesize .....
WHERE    .... AND (dbo.PE_CommonModel.GeneralID NOT IN (SELECT  top @startrow ....))
ORDER BY ....

SELECT  count(dbo.PE_CommonModel.GeneralID)
....

注意，后面的SQL语句不能有order by

下面是显示文章标题和简介的语句

SELECT     TOP (@pagesize) dbo.PE_CommonModel.GeneralID, dbo.PE_CommonModel.NodeID, dbo.PE_CommonModel.ItemID, dbo.PE_CommonModel.Title, dbo.PE_U_Article.Intro
FROM         dbo.PE_CommonModel INNER JOIN
                      dbo.PE_U_Article ON dbo.PE_CommonModel.ItemID = dbo.PE_U_Article.ID
WHERE     (dbo.PE_CommonModel.ModelID = 1) AND (dbo.PE_CommonModel.Status = 99) AND (dbo.PE_CommonModel.NodeID = @NodeID) AND 
                      (dbo.PE_CommonModel.GeneralID NOT IN
                          (SELECT     TOP (@startrow) PE_CommonModel_1.GeneralID
                            FROM          dbo.PE_CommonModel AS PE_CommonModel_1 INNER JOIN
                                                   dbo.PE_U_Article AS PE_U_Article_1 ON PE_CommonModel_1.ItemID = PE_U_Article_1.ID
                            WHERE      (PE_CommonModel_1.ModelID = 1) AND (PE_CommonModel_1.Status = 99) AND (PE_CommonModel_1.NodeID = @NodeID)
                            ORDER BY PE_CommonModel_1.GeneralID DESC))
ORDER BY dbo.PE_CommonModel.GeneralID DESC

SELECT count(dbo.PE_CommonModel.GeneralID)  FROM PE_CommonModel INNER JOIN PE_U_Article ON PE_CommonModel.ItemID = PE_U_Article.ID  WHERE  (PE_CommonModel.NodeID = @NodeID)   (dbo.PE_CommonModel.ModelID = 1) AND (dbo.PE_CommonModel.Status = 99)

调用方式：

{PE.Label id="mobilelistbypage" nodeID="@RequestInt_Id" pagesize="6" page="true"/}

分页按钮：

   <ul>
      <li><a href="{$prvurl/}" data-transition="none">上一页</a></li>
      <li><a href="{$nexturl/}" data-transition="none">下一页</a></li>
    </ul>