加入收藏 | 设为首页 | 会员中心 | 我要投稿 济南站长网 (https://www.0531zz.com/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 站长学院 > PHP教程 > 正文

ASP无组件分页实现思路及代码

发布时间:2016-12-07 23:04:24 所属栏目:PHP教程 来源:站长网
导读:MVC下: 后台代码: 复制代码 代码如下: public ActionResult sys(string page) { if (page == null) { string sql = "select top 15 * from dingdinfo ORDER BY dingdh desc"; ViewData["ds"] = dr.resultSet(sql, "dingdinfo"); } if (page != null) { in
MVC下:
后台代码:
复制代码 代码如下:
public ActionResult sys(string page)
{
if (page == null)
{
string sql = "select top 15 * from dingdinfo ORDER BY dingdh desc";
ViewData["ds"] = dr.resultSet(sql, "dingdinfo");
}
if (page != null)
{
int pageSL = Convert.ToInt32(page);
string sql = "select top 15 * from dingdinfo where id not in (select top " + (pageSL - 1) * 15 + " id from dingdinfo order by dingdh desc )ORDER BY dingdh desc";
ViewData["ds"] = dr.resultSet(sql, "dingdinfo");
}
//计算pageCount
string sql1 = "select * from dingdinfo";
int pageCount = dr.resultCount(sql1,"dingdinfo");
int Chu = Convert.ToInt32(pageCount / 15);
int yuS = Convert.ToInt32(pageCount % 15);
if (pageCount gt; 15)
{
int pageJG = Chu;
if (yuS != 0)
{
pageJG = Chu + 1;
ViewData["jg"] = pageJG;
}
else
{
ViewData["jg"] = pageJG;
}
}
return View();
}

页面显示:
JS代码:
复制代码 代码如下:
lt;script type="text/javascript"gt;
//分页
function Page(id) {
window.location = "/bookIndex/sys/?page=" + id;
}
lt;/scriptgt;

HTML代码:
复制代码 代码如下:
lt;tdgt;
lt;% int count =Convert.ToInt32(ViewData["jg"]);
if (count != 0)
{
for (int i = 1; i lt;=count; i++)
{ %gt;
lt;a href = "#" onclick="Page(lt;%:i%gt;)"gt;lt;%:i%gt;lt;/agt;
lt;% }
}%gt;
lt;/tdgt;

页面最终效果:

(编辑:济南站长网)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    热点阅读