public IQueryable <Articel> GetArticelList(ArticleInfoSearch articleInfoSearch)
{
IQueryable <Articel> ArticleInfoList = this.DbSession.ArticelDAL.LoadEntity(a => a.DelFlag == 0);
if (!string.IsNullOrEmpty(articleInfoSearch.ArticelClassID))
{
int articleClassId = Convert.ToInt32(articleInfoSearch.ArticelClassID);
ArticleInfoList = from a in ArticleInfoList
from b in a.ArticelClass
where b.ID == articleClassId
select a;
}
if (!string.IsNullOrEmpty(articleInfoSearch.ArticeTitle))
{
ArticleInfoList = ArticleInfoList.Where(a => a.Title.Contains(articleInfoSearch.ArticeTitle));
}
if (!string.IsNullOrEmpty(articleInfoSearch.ArticelAuthor))
{
ArticleInfoList = ArticleInfoList.Where(a => a.Author.Contains(articleInfoSearch.ArticelAuthor));
}
if (!string.IsNullOrEmpty(articleInfoSearch.ToDatepicker) && !string.IsNullOrEmpty(articleInfoSearch.FormDatepicker))
{
DateTime fromDate = Convert.ToDateTime(articleInfoSearch.FormDatepicker);
DateTime toDate = Convert.ToDateTime(articleInfoSearch.ToDatepicker);
ArticleInfoList = ArticleInfoList.Where(a => a.AddDate >= fromDate && a.AddDate <= toDate);
}
articleInfoSearch.TotalCount = ArticleInfoList.Count();
IQueryable <Articel> temp = ArticleInfoList.OrderBy <Articel, int>(a => a.ID).Skip <Articel>((articleInfoSearch.PageIndex - 1) * articleInfoSearch.PageSize).Take <Articel>(articleInfoSearch.PageSize);
return(temp);
}
/// <summary>
/// 获取列表信息
/// </summary>
/// <returns></returns>
public ActionResult GetArticelInfo()
{
int pageIndex = Request["page"] == null ? 1 : Convert.ToInt32(Request["page"]);
int pageSize = Request["rows"] == null ? 5 : Convert.ToInt32(Request["rows"]);
int totalCount = 0;
ArticleInfoSearch articleInfoSearch = new ArticleInfoSearch()
{
ArticelAuthor = Request["txtArticelAuthor"],
ArticelClassID = Request["articelClassId"],
ArticeTitle = Request["txtArticeTitle"],
FormDatepicker = Request["formDatepicker"],
ToDatepicker = Request["toDatepicker"],
PageIndex = pageIndex,
PageSize = pageSize,
TotalCount = totalCount
};
IQueryable <Articel> list = ArticelBLL.GetArticelList(articleInfoSearch);
var temp = from a in list
select new { ID = a.ID, Title = a.Title, Author = a.Author, Origin = a.Origin, AddDate = a.AddDate, ClassName = from b in a.ArticelClass select b.ClassName };
return(Json(new { total = articleInfoSearch.TotalCount, rows = temp }, JsonRequestBehavior.AllowGet));
}