// 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);
