ASP.NET MVC5网站开发显示文章列表(九)_实用技巧_

/// 
 /// 排序 /// 
 /// 数据实体集 /// 排序代码[默认：ID降序] ///  IQueryable Order(IQueryable entitys, int roderCode); 查询数据方法 /// 
 /// 查询分页数据列表 /// 
 /// 总记录数 /// 模型【All全部】 /// 页码 /// 每页记录数 /// 标题【不使用设置空字符串】 /// 栏目ID【不使用设0】 /// 用户名【不使用设置空字符串】 /// 起始日期【可为null】 /// 截止日期【可为null】 /// 排序码 /// 分页数据列表 IQueryable FindPageList(out int totalRecord, int pageIndex, int pageSize, string model, string title, int categoryID, string inputer, Nullable fromDate, Nullable toDate, int orderCode);

public IQueryable FindPageList(out int totalRecord, int pageIndex, int pageSize, string model, string title, int categoryID, string inputer, Nullable fromDate, Nullable toDate, int orderCode) { //获取实体列表 IQueryable _commonModels = CurrentRepository.Entities; if (model == null || model != "All") _commonModels = _commonModels.Where(cm => cm.Model == model); if (!string.IsNullOrEmpty(title)) _commonModels = _commonModels.Where(cm => cm.Title.Contains(title)); if (categoryID > 0) _commonModels = _commonModels.Where(cm => cm.CategoryID == categoryID); if (!string.IsNullOrEmpty(inputer)) _commonModels = _commonModels.Where(cm => cm.Inputer == inputer); if (fromDate != null) _commonModels = _commonModels.Where(cm => cm.ReleaseDate >= fromDate); if (toDate != null) _commonModels = _commonModels.Where(cm => cm.ReleaseDate <= toDate); _commonModels = Order(_commonModels, orderCode); totalRecord = _commonModels.Count(); return PageList(_commonModels, pageIndex, pageSize).AsQueryable(); } public IQueryable Order(IQueryable entitys, int orderCode) { switch(orderCode) { //默认排序 default: entitys = entitys.OrderByDescending(cm => cm.ReleaseDate); break; } return entitys; }

using System; namespace Ninesky.Web.Models { /// 
 /// CommonModel视图模型 ///  /// 创建：2014.03.10 ///  /// 
 public class CommonModelViewModel { public int ModelID { get; set; } /// 
 /// 栏目ID /// 
 public int CategoryID { get; set; } /// 
 /// 栏目名称 /// 
 public string CategoryName { get; set; } /// 
 /// 模型名称 /// 
 public string Model { get; set; } /// 
 /// 标题 /// 
 public string Title { get; set; } /// 
 /// 录入者 /// 
 public string Inputer { get; set; } /// 
 /// 点击 /// 
 public int Hits { get; set; } /// 
 /// 发布日期 /// 
 public DateTime ReleaseDate { get; set; } /// 
 /// 状态 /// 
 public int Status { get; set; } /// 
 /// 状态文字 /// 
 public string StatusString { get { return Ninesky.Models.CommonModel.StatusList[Status]; } } /// 
 /// 首页图片 /// 
 public string DefaultPicUrl { get; set; } } }

/// 
 /// 文章列表Json【注意权限问题，普通人员是否可以访问？】 /// 
 /// 标题 /// 录入 /// 栏目 /// 日期起 /// 日期止 /// 页码 /// 每页记录 ///  public ActionResult JsonList(string title, string input, Nullable category, Nullable fromDate, Nullable toDate, int pageIndex = 1, int pageSize = 20) { if (category == null) category = 0; int _total; var _rows = commonModelService.FindPageList(out _total, pageIndex, pageSize, "Article", title, (int)category, input, fromDate, toDate, 0).Select( cm => new Ninesky.Web.Models.CommonModelViewModel() { CategoryID = cm.CategoryID, CategoryName = cm.Category.Name, DefaultPicUrl = cm.DefaultPicUrl, Hits = cm.Hits, Inputer = cm.Inputer, Model = cm.Model, ModelID = cm.ModelID, ReleaseDate = cm.ReleaseDate, Status = cm.Status, Title = cm.Title }); return Json(new { total = _total, rows = _rows.ToList() }); } 

/// 
 /// 全部文章 /// 
 ///  public ActionResult List() { return View(); }

修改删除刷新
栏目标题录入人添加日期 - 查询