分页查询--前台HTML+后台asp.net代码
前台代码:
<div class="paging"><span>第<%=pageCurrent %>/<%=pageCount %>页</span>
<a href="?page=1" <%if(pageCurrent==1){ %>disabled<%} %>>首页</a>
<a <%if(groupCurrent<=0){ %>disabled <%} %> href="?group=<%=groupCurrent-1 %>">上组</a>
<a <%if(pageCurrent<=1){ %>disabled <%} %> href="?page=<%=pageCurrent-1 %>"> 上一页</a>
<%for (int i = 1; i <= groupSize &((groupCurrent)*groupSize+i)<=pageCount; i++)
{ %>
<a href="?page=<%=groupCurrent*groupSize+i %>" <%if(pageCurrent==groupCurrent*groupSize+i){ %>disabled<%} %>><%=groupCurrent * groupSize + i%></a>
<%} %>
<a <%if(pageCurrent>=pageCount){ %>disabled<%} %> href="?page=<%=pageCurrent+1 %>">下一页</a>
<a <%if(groupCurrent>=groupCount){ %>disabled<%} %> href="?group=<%=groupCurrent+1 %>">下组</a>
<a href="?page=<%=pageCount %>" <%if(pageCurrent==pageCount){ %>disabled<%} %>>末页</a>
</div>
后台代码:
protected int pageCurrent, pageCount, groupCurrent,groupCount, groupSize;
protected void Reload()
{
groupSize = 3;
int recordCount, pageSize = 1;
if (Request["page"] == null)
{
pageCurrent = 1;
}
else
{
int.TryParse(Request["page"], out pageCurrent);
}
if (pageCurrent < 1)
{
pageCurrent = 1;
}
dtUser = SqlHelper.QueryPagingData("system_userinfo", "sid,username,job_number,privilege_group_sid,status,lastlogin_date,remark", "sid", "1=1", "sid", 2, pageSize, pageCurrent, out pageCount, out recordCount);
if (pageCurrent > pageCount)
{
pageCurrent = pageCount;
}
groupCurrent = (pageCurrent - 1) / groupSize;
groupCount = (pageCount - 1) / groupSize;
if (Request["group"] != null)
{
int.TryParse(Request["group"], out groupCurrent);
if (groupCurrent <= 0)
{
groupCurrent = 0;
}
if (groupCurrent >= groupCount)
{
groupCurrent = groupCount;
}
pageCurrent += groupCurrent * groupSize;
}
dtprivilege_group = SqlHelper.Query("select sid,group_name from system_privilege_group");
}