public DataPaging <Article> GetPageList(string categoryId, int currentPage, bool isIndex) { try { var exp = new PredicatePack <Article>(); if (!isIndex) { exp.PushAnd(x => x.CategoryId == categoryId); } var list = _article.Entities.Where(exp).ToList(); return(new DataPaging <Article>() { CurrentPage = currentPage, Data = list, TotalRecord = list.Count }); } catch { throw new Exception("读取文章目录出错"); } }
public string GetMenuCategoryId(string id) { var result = string.Empty; if (string.IsNullOrWhiteSpace(id)) { return(result); } var exp = new PredicatePack <Menu>(); exp.PushAnd(x => x.MenuId == id); exp.PushAnd(x => x.CategoryId != null); var exist = _menu.Find(exp); return(exist != null ? exist.CategoryId : result); }
public DataPaging <ArticleListView> GetPageList(ArticleListView parameters, int currentPage, int pageSize, bool isIndex = true) { var _articleView = new EFRepositoryBase <ArticleListView, object>(); var exp = new PredicatePack <ArticleListView>(); if (!isIndex) { exp.PushAnd(x => x.CategoryId == parameters.CategoryId); } exp.PushAnd(x => x.Status == 101); var source = _articleView.Entities.Where(exp); var list = source.OrderByDescending(x => x.CreateTime).Skip((currentPage - 1) * pageSize).Take(pageSize).ToList(); var totalRecord = source.Count(); return(new DataPaging <ArticleListView> { SearchParams = parameters, List = list, Pager = totalRecord < 1 ? string.Empty : new HtmlPager <ArticleListView>(HttpContext.Current.Request.Path.ToLower(), parameters) .GenerateCode(totalRecord / pageSize, currentPage) }); }
public DataPaging <User> GetPageList(User parameters, int currentPage, int pageSize) { var exp = new PredicatePack <User>(); if (!string.IsNullOrEmpty(parameters.UserName)) { exp.PushAnd(x => x.UserName.Contains(parameters.UserName)); } if (!string.IsNullOrEmpty(parameters.DisplayName)) { exp.PushAnd(x => x.DisplayName.Contains(parameters.DisplayName)); } var source = _user.Entities.Where(exp); var list = source.OrderBy(x => true).Skip((currentPage - 1) * pageSize).Take(pageSize).ToList(); var totalRecord = source.Count(); return(new DataPaging <User> { SearchParams = parameters, List = list, Pager = totalRecord < 1 ? string.Empty : new HtmlPager <User>(HttpContext.Current.Request.Path.ToLower(), parameters) .GenerateCode(totalRecord / pageSize, currentPage) }); }