// GET: Material public ActionResult Index(int page = 1) { MaterialFilter filter = new MaterialFilter(); var pager = PageReq <MaterialFilter> .Create(filter, page); var data = jlService.MaterialPage(pager); return(View(data)); }
public ActionResult Video(int page = 1) { MaterialFilter filter = new MaterialFilter(); filter.MaterialType = (int)MaterialType.Video; PageReq <MaterialFilter> pager = PageReq <MaterialFilter> .Create(filter, page); var data = jlService.MaterialPage(pager); return(View(data)); }
public ActionResult Video(MaterialSearchModel model, int page = 1) { MaterialFilter filter = new MaterialFilter(); filter.AddTimeFrom = model.AddTimeFrom; filter.AddTimeTo = model.AddTimeTo; filter.MaterialType = (int)MaterialType.Video; filter.Title = model.Title; PageReq <MaterialFilter> pager = PageReq <MaterialFilter> .Create(filter, page); var data = jlService.MaterialPage(pager); return(View(data)); }
/// <summary> /// Получим список новостей /// </summary> /// <param name="filtr">Фильтр</param> /// <returns></returns> public override MaterialsList getMaterialsList(MaterialFilter filter) { using (var db = new CMSdb(_context)) { // кол-во эл-тов int itemCount = db.content_materialss.Count(); // список новостей var list = db.content_materialss .OrderByDescending(o => o.d_date) .Skip(filter.Size * (filter.Page - 1)) .Take(filter.Size) .Select(s => new MaterialsModel { Id = s.id, Title = s.c_title, Date = s.d_date, PreviewImage = new Photo { Url = s.c_preview }, Disabled = s.b_disabled, Text = s.c_text }); if (list.Any()) { return(new MaterialsList { Data = list.ToArray(), Pager = new Pager { page = filter.Page, size = filter.Size, items_count = itemCount, page_count = (itemCount % filter.Size > 0) ? (itemCount / filter.Size) + 1 : itemCount / filter.Size } }); } else { return(null); } } }
private string BuildSqlFrom(MaterialFilter filter) { if (filter == null) { return(null); } var sb = new System.Text.StringBuilder(); if (filter.AddTimeFrom.HasValue) { sb.Append(" addtime >= " + filter.AddTimeFrom.Value.ToString("yyyy-MM-dd")); sb.Append(" and "); } if (filter.AddTimeTo.HasValue) { sb.Append(" addtime <= " + filter.AddTimeTo.Value.ToString("yyyy-MM-dd")); sb.Append(" and "); } if (filter.MaterialType > 0) { sb.AppendFormat(" materialtype = '{0}' ", SqlFilter.FilterQueryParameter(filter.MaterialType.Value.ToString())); sb.Append(" and "); } if (!string.IsNullOrEmpty(filter.Title)) { sb.AppendFormat(" title like '{0}' ", SqlFilter.FilterQueryParameter(filter.Title)); sb.Append(" and "); } if (sb.Length > 0) { sb.Remove(sb.Length - 4, 4); } return(sb.ToString()); }
public abstract MaterialsList getMaterialsList(MaterialFilter filtr);