Linq语句与aspnetpager结合分页

public void DataBindList()
        {
            List<EnDeContent> listCon = null;
            int pageSize = 10;
            int pageIndex =0;
            string key = txtKey.Text.Trim();
            AspNetPager.RecordCount = db.EnDeContent.ToList().Count();

            pageIndex = AspNetPager.CurrentPageIndex;

            if (string.IsNullOrEmpty(key))
            {
                listCon = db.EnDeContent.OrderBy(c => c.CodeDate).Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList();

            }
            else
            {
                listCon = db.EnDeContent.Where(c => c.CodeTitle.IndexOf(key) >= 0 || c.CodeContent.IndexOf(key) > 0).OrderBy(c => c.CodeDate).Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList();
            }

            Repeater1.DataSource = listCon;
            Repeater1.DataBind();
        }

      

posted on 2016-12-24 16:24  焦会锋  阅读(105)  评论(0编辑  收藏  举报

导航