public ActionResult Index(NewsCondition condition)
{
var news = service.SearchNews(condition);
var models = new PagedList <NewsInfo>(news, news.Paging);
return(View(PluginHelper.GetViewPath(this.GetType(), "Index"), models));
}
public IPagedList <ImportantNewsInfo> SearchNews(NewsCondition condition)
{
var query = repository.Table;
if (!string.IsNullOrEmpty(condition.Title))
{
query = query.Where(t => t.Title.Contains(condition.Title));
}
if (condition.NewsType != null)
{
query = query.Where(t => t.NewsType == condition.NewsType);
}
if (condition.BeginDate != null)
{
query = query.Where(t => t.ReleaseTime > condition.BeginDate);
}
if (condition.EndDate != null)
{
query = query.Where(t => t.ReleaseTime < condition.EndDate);
}
query = query.Where(t => t.IsDelete == false);
query = query.OrderByDescending(t => t.ReleaseTime);
return(new PagedList <ImportantNewsInfo>(query, condition.PageIndex, condition.PageSize));
}
public IList <News_News> SearchNews(NewsCondition condition, ref Paging paging)
{
CupcakeEntities db = new CupcakeEntities();
Expression <Func <News_News, bool> > where = PredicateExtensions.True <News_News>();
if (condition.NewsType != null)
{
where = where.And(n => n.NewsType == condition.NewsType);
}
where = where.And(n => n.IsDelete == false);
paging.Total = db.News_News.Where(n => n.NewsType == condition.NewsType).Count();
return(db.News_News.Where(where).OrderBy(n => n.CreateDate)
.Skip(paging.PageSize * paging.PageIndex)
.Take(paging.PageSize).ToList());
}
public IPagedList <News> SearchNews(NewsCondition condition)
{
var query = repository.Table;
if (!string.IsNullOrEmpty(condition.Title))
{
query = query.Where(t => t.Title.Contains(condition.Title));
}
if (condition.NewsType != null)
{
query = query.Where(t => t.NewsType == condition.NewsType);
}
query = query.Where(t => t.IsDelete == false);
query = query.OrderByDescending(t => t.CreateDate);
return(new PagedList <News>(query, condition.PageIndex, condition.PageSize));
}