Linq 分页

来源：互联网发布：触发器 sql 编辑：程序博客网时间：2024/05/20 03:42

            ERPDBDataContext erpdb = new ERPDBDataContext();

            if (string.IsNullOrEmpty(StartDate))                StartDate = new DateTime(1900, 1, 1).ToShortDateString();            if (string.IsNullOrEmpty(EndDate))                EndDate = new DateTime(2999, 1, 1).ToShortDateString();            var List = erpdb.Demand_List.ToList().Where(x => x.CreatedTime >= DateTime.Parse(StartDate) && x.CreatedTime <= DateTime.Parse(EndDate).AddDays(1)).ToList();            if (!string.IsNullOrEmpty(Keys))// extensions.Where(x=>x.keys.Contains(Keys) || x.names.Contains(Keys) || x.remarks.Contains(Keys));                List = erpdb.Demand_List.Where(x => x.Title.Contains(Keys) || x.Context.Contains(Keys)).ToList();            var query = List.OrderByDescending(c => c.Id).OrderByDescending(c => c.Id).ToList();//排序            var list = (from p in query                        select p).Skip(10 * (pageNo - 1)).Take(10).ToList();

0 0