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 DataPaging <Category> GetPageList(Category parameters, int currentPage, int pageSize)
{
var exp = new PredicatePack <Category>();
var source = _category.Entities.Where(exp);
var list = source.OrderBy(x => true).Skip((currentPage - 1) * pageSize).Take(pageSize).ToList();
var totalRecord = source.Count();
return(new DataPaging <Category>
{
SearchParams = parameters,
List = list,
Pager = totalRecord < 1 ? string.Empty : new HtmlPager <Category>(HttpContext.Current.Request.Path.ToLower(), parameters)
.GenerateCode(totalRecord / pageSize, currentPage)
});
}
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)
});
}
