MarcusV(南墙大佬的搬运工)

南墙大佬的CSDN博客地址

导航

ASP.NET的Web网页如何进行分页操作(Demo举例)

大概说一下思路,可以利用sql的 Offset/Fetch Next分页,点击这里
这里的Demo利用LINQ的写好的方法

//这里是某个表的列表   skip是跳过前面的多少条数据   take这是跳过前面的数据后显示多少条数据
db.Albums.ToList().Skip((pageNumber - 1) * pageSize).Take(pageSize).ToList();

我们是四个按钮一个首页,上一页,下一页,尾页,点击跳转
有不明白的,或者小编描述错误的模糊的欢迎评论私信

这个页面的前台页面

<%@ Page Title="" Language="C#" MasterPageFile="~/Admin/AdminSite.Master" AutoEventWireup="true" CodeBehind="MusicManager.aspx.cs" Inherits="WebApplication1.Admin.MusicManager1" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">

    <link href="../Assets/css/input.css" rel="stylesheet" />
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">

    <div class="pure-form">
        <fieldset>
            <%--genres表--%>
            <legend>后台管理<i class="fa fa-angle-double-right"></i>音乐管理
                <asp:Button ID="Button1" runat="server" CssClass="button-default pure-button-primary tools-button" Text="添加音乐" OnClick="Button1_Click" />
            </legend>
        </fieldset>
    </div>
    <table class="pure-table">
        <thead>
            <tr>
                <th>#</th>
                <th>音乐名称</th>
                <th>歌手名称</th>
                <th>标题</th>
                <th>单价</th>
                <th>图片</th>
                <th>编辑</th>
            </tr>
        </thead>
        <tbody>
            <asp:Repeater ID="Repeater1" runat="server" OnItemCommand="Repeater1_ItemCommand">
                <ItemTemplate>
                    <tr>
                        <td><%# Eval("AlbumId") %></td>
                        <td><%# Eval("Genres.Name") %></td>
                        <td><%# Eval("Artists.Name") %></td>
                        <td><%# Eval("Title") %></td>
                        <td><%# Eval("Price") %></td>
                        <td><%#  Eval("AlbumArtUrl") %><asp:Image ID="Image1" ImageUrl='<%# "~"+Eval("AlbumArtUrl") %>' runat="server" Width="40px" Height="40px" /></td>
                        <td>
                            <asp:LinkButton ID="LinkButton1" CssClass="button-default pure-button-primary" runat="server" CommandArgument='<%#Eval("AlbumId") %>' CommandName="Edit">编辑</asp:LinkButton>
                            <asp:LinkButton ID="LinkButton2" CssClass="button-default  button-error" runat="server" CommandArgument='<%#Eval("AlbumId") %>' CommandName="Delete">删除</asp:LinkButton></td>

                    </tr>
                </ItemTemplate>
            </asp:Repeater>
            <tr>
                <td colspan="6">
                    <asp:Label ID="Label1" runat="server"></asp:Label>
                    <asp:Button ID="btnFirst" runat="server" Text="首页" OnClick="btnFirst_Click" />
                    <asp:Button ID="btnPrev" runat="server" Text="上页" OnClick="btnPrev_Click" />
                    <asp:Button ID="btnNext" runat="server" Text="下页" OnClick="btnNext_Click" />
                    <asp:Button ID="btnLast" runat="server" Text="尾页" OnClick="btnLast_Click" />


                </td>
            </tr>
        </tbody>



    </table>
</asp:Content>

这个页面的后台页面

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using WebApplication1.BLL;
using WebApplication1.DAL;

namespace WebApplication1.Admin
{
    public partial class MusicManager1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
                LoadData();
        }

        protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
        {
            string str = e.CommandName.ToString();
            //这里获取id,我的id是刚才我赋值的时候CommandArgument是赋值的id
            int id = Convert.ToInt32(e.CommandArgument.ToString());
            //using (OLMSDBEntities oLMSDB = new OLMSDBEntities())
            //{


            // var gener = oLMSDB.Genres.FirstOrDefault(t => t.GenreId == id);
            if (str == "Delete")
            {

                //后面是对数据库的操作,可以忽略
                //    oLMSDB.Genres.Remove(gener);
                bool flag_deleteMussicType = BLL.MusicManager.deleteMusicManager(id);


                if (flag_deleteMussicType)
                {
                    string strUrl = "<script>alert('删除成功');window.location.href='MusicManager.aspx'</script>";
                    Response.Write(strUrl);
                }
                else
                {
                    string strUrl = "<script>alert('删除失败');</script>";
                    Response.Write(strUrl);
                }
            }
            else if (str == "Edit")
            {
                Response.Redirect($"Edit_MusicManager.aspx?id={id}");

            }
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            Response.Redirect("Add_MusicManager.aspx");
        }
      


		//分页的具体代码



        //页码
        public int pageNumber
        {
            //取值的话,如果里面没有就说明第一次进入,然后给它赋值,下面在取值
            get
            {
                if (ViewState["page"] == null)
                {
                    return 1;
                }
                else
                {
                    return Convert.ToInt32(ViewState["page"]);
                }
            }
            set
            {
                ViewState["page"] = value;
            }
        }
        //每页的记录数
        public int pageSize
        {
            get
            {
                return 5;
            }
        }
        //总页数
        public int pageCount
        {
            get
            {
                if (ViewState["count"] == null)
                {
                    return 1;
                }
                else
                {
                    return Convert.ToInt32(ViewState["count"]);
                }
            }
            set
            {
                ViewState["count"] = value;
            }
        }


        public void LoadData()
        {
            using (OLMSDBEntities oLMSDB = new OLMSDBEntities())
            {                          //这里是某个表的列表      skip是跳过前面的多少条数据         take这是跳过前面的数据后显示多少条数据
                                       //     //这里是我需要显示第三页的数据,我们要跳过二页的数据,所以是(3-1)*一页的数据量
                Repeater1.DataSource = oLMSDB.Albums.ToList().Skip((pageNumber - 1) * pageSize).Take(pageSize).ToList();
                Repeater1.DataBind();
                pageCount = oLMSDB.Albums.ToList().Count;
                Label1.Text = $"每页{pageSize}条,共{pageCount}条    ";
                //我们最后剩下一行数据也要在加一页,如果有余数就要加一页
                pageCount = pageCount % pageSize == 0 ? pageCount / pageSize : pageCount / pageSize + 1;
            }
            Label1.Text += "当前页数为" + pageNumber + "/" + pageCount;
        }

        //首页
        protected void btnFirst_Click(object sender, EventArgs e)
        {
            pageNumber = 1;
            LoadData();
        }

        //上一页
        protected void btnPrev_Click(object sender, EventArgs e)
        {
            //防止到0页,如果到0页的话,我们就是到1页
            pageNumber = pageNumber - 1 < 1 ? pageNumber = 1 : pageNumber - 1;

            LoadData();
        }

        //下一页
        protected void btnNext_Click(object sender, EventArgs e)
        {
            //防止超出所有的页面总数,超出的话,就赋值页面总数
            pageNumber = pageNumber + 1 > pageCount ? pageNumber = pageCount : pageNumber + 1;
            LoadData();
        }

        //尾页
        protected void btnLast_Click(object sender, EventArgs e)
        {
            pageNumber = pageCount;
            LoadData();
        }
    }
}

效果图

在这里插入图片描述

posted on 2020-05-13 11:42  MarcusV  阅读(118)  评论(0编辑  收藏  举报