逻辑清晰学会为页面添加分页

最新推荐文章于 2025-08-21 09:06:52 发布

原创最新推荐文章于 2025-08-21 09:06:52 发布 · 141 阅读

CC 4.0 BY-SA版权

分页

DAL页面

 public static List<Truck> GetTruckPage(string number, string types, int Page, int Pagesize, out int Totalcount, CommandType type = CommandType.Text)
        {

            SqlParameter[] paras = new SqlParameter[5];
            paras[0] = new SqlParameter("@Number", number);
            paras[1] = new SqlParameter("@Type", types);
            paras[2] = new SqlParameter("@PageIndex", Page);
            paras[3] = new SqlParameter("@PageSize", Pagesize);
            paras[4] = new SqlParameter("@TotalCount", SqlDbType.Int)
            {
                Direction = ParameterDirection.Output
            };
            SqlDataReader reader = DBHelpe.ExecuteReader("[dbo].[Proc_GetPagedTruckList1]", paras, CommandType.StoredProcedure);
            List<Truck> list = GetTrcuk(reader);
            Totalcount = Convert.ToInt32(paras[4].Value);
            reader.Close();
            return list;
        }

BLL页面

 public static List<Truck> GetTruckPage(string number, string types, int Page, int Pagesize, out int Totalcount)
        {
            return TruckListDal.GetTruckPage(number,types, Page, Pagesize, out Totalcount);
        }

aspx后台

 public int PageLenth { get; set; }
        public int CurrentPage { get; set; }
        public int Pagesize { get; set; }
        public string PageLink { get; set; }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                Pagesize = 3;
                int page = Convert.ToInt32(Request.QueryString["page"]);

                Repeater1.DataSource = TruckListBll.GetTruckPage("", "", page, Pagesize, out int Totalcount);
                PageLenth = (int)Math.Ceiling((float)Totalcount / Pagesize);
                PageLink = MyAspNetPager.ShowPage(Pagesize, PageLenth, Totalcount);
                Repeater1.DataBind();
            }
        }

前台

<ul class="pagination">
            <% for (int i = 1; i <= PageLenth; i++)
                {
            %>
            <li class="page-item <%=CurrentPage==i?"active":"" %>"><a class="page-link" href="TruckList.aspx?page=<%=i %>"><%=i %></a>
                <% }
                %>
        </ul>