/// <summary> /// 开始构造分页对象 /// </summary> /// <param name="ViewBag">向视图传入的解析后的分页数据</param> /// <param name="TotalForumCount">数据总记录</param> public void GetPaging(dynamic ViewBag, int TotalForumCount) { //构造分页对象 APaging ap = new Paging(); //DefaultPaging为默认的标签设置及样式 IBinding Binding = ap.Set(new DefaultPaging(), CurrentPageindex, TotalForumCount, this.PageSize, this.PageCount); //一下调用顺序将影响分页按钮显示顺序 Binding.GetShowChar(); Binding.GetFrst(); Binding.GetFront(); Binding.GetPageNumber(); Binding.GetAfter(); Binding.GetLast(); Binding.GetInputPageNumber(); Binding.GetGotoPageIndex(); ViewBag.Paging = ap.Bind(); }
//获取并绑定中奖名单 protected void GetData() { //实例化数据库上下文类 using (activityDataContext DataContext = new activityDataContext()) { //计算分页数据 int Skin = (PageIndex - 1) * PageSize; //获取数据总数 TotalCount = DataContext.activity_record.Where(W => W.username != "").Count(); //获取中奖名单 prizeList = DataContext.activity_record .Where(W => W.username != "") .Select(S => new PrizeList { id = S.id, username = S.username, prize_name = S.prize_name, phone = S.phone, add_date = S.add_date ?? DateTime.Now.Date }).OrderByDescending(O => O.id) .Skip(Skin).Take(PageSize).ToList(); //绑定分页控件 paging.Bind(PageIndex, TotalCount); } }