分页查询前台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");
        
    }
原文地址:https://www.cnblogs.com/jrmy/p/14316363.html