public async Task <IActionResult> Index(SearchConditionParams query)
{
try
{
ViewBag.keywords = query.KeyWords?.Trim();
ViewBag.IsNull = query.ExistNull;
int counts = await _docService.GetRecordCounts(query);
var tables = await _docService.GetTables(query);
foreach (var tb in tables)
{
tb.FieldInfos = await _docService.GetFields(tb.Id);
}
PagerOption pageOptions = new PagerOption()
{
ItemCount = counts,
PageSize = query.PageSize, //5
PageIndex = query.PageIndex,
CountNum = 5,
Url = Request.Path.Value,
Query = Request.Query,
};
ViewBag.Option = pageOptions;
ViewBag.TotalCount = counts;
return(View(tables));
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.ToString());
}
return(View());
}
public async Task <IActionResult> Pictures([FromQuery] int index)
{
var options = new PagerOption
{
PageIndex = index,
PageSize = 6,
};
var result = await _pictureService.GetPagerAsync(options.PageIndex, options.PageSize);
options.Total = result.total;
ViewBag.Options = options;
return(View(result.rows));
}
public async Task <IActionResult> Index(int pageIndex = 1)
{
var posts = await _repository.FindAsync <Post, DateTime>(t => t.IsPublished, t => t.PubDate, int.Parse(_config["blog:pageSize"]), pageIndex, out int count);
var pageOption = new PagerOption
{
PageIndex = pageIndex,
PageSize = int.Parse(_config["blog:pageSize"]),
TotalCount = count,
RouteUrl = "/"
};
ViewBag.PagerOption = pageOption;
return(View(posts));
}
public async Task <IActionResult> GalleryManage(int pageIndex = 1)
{
var galleries = await _repository.FindAsync <Gallery, DateTime>(t => true, t => t.PubDate, int.Parse(_config["blog:pageSize"]), pageIndex, out int count);
var pageOption = new PagerOption
{
PageIndex = pageIndex,
PageSize = int.Parse(_config["blog:pageSize"]),
TotalCount = count,
RouteUrl = "/Admin/GalleryManage"
};
ViewBag.PagerOption = pageOption;
return(View(galleries));
}
public async Task <IActionResult> Archives(int pageIndex = 1)
{
int pageSize = 20;
var posts = await _repository.FindAsync <Post, DateTime>(t => t.IsPublished, t => t.PubDate, pageSize, pageIndex, out int count);
var pageOption = new PagerOption
{
PageIndex = pageIndex,
PageSize = pageSize,
TotalCount = count,
RouteUrl = "/archives"
};
ViewBag.PagerOption = pageOption;
return(View(posts));
}
public async Task <IActionResult> CommentManage(int pageIndex = 1)
{
int pageSize = 10;
var comments = await _repository.FindAsync <Comment, DateTime>(t => true, t => t.PubDate, pageSize, pageIndex, out int count);
var pageOption = new PagerOption
{
PageIndex = pageIndex,
PageSize = pageSize,
TotalCount = count,
RouteUrl = "/Admin/CommentManage"
};
ViewBag.PagerOption = pageOption;
return(View(comments));
}
public IActionResult Index(SearchConditionParams query)
{
ViewBag.keywords = query.KeyWords?.Trim();
ViewBag.IsNull = query.ExistNull;
int counts = 0;
var tables = GetTables(out counts, query.PageIndex, query.PageSize, query.KeyWords, query.ExistNull);
PagerOption pageOptions = new PagerOption()
{
ItemCount = counts,
PageSize = query.PageSize, //5
PageIndex = query.PageIndex,
CountNum = 5,
Url = Request.Path.Value,
Query = Request.Query,
};
ViewBag.Option = pageOptions;
ViewBag.TotalCount = counts;
return(View(tables));
}
public async Task <IActionResult> Search2(string category, int pageIndex = 1)
{
var query = from galleries in _repository.All <Gallery>()
join categories in _repository.All <Category>()
on galleries.ID equals categories.SourceID
where categories.Text == category && galleries.IsPublished
select galleries;
var count = await query.GroupBy(t => t.ID).CountAsync();
var data = await query.Distinct().OrderByDescending(t => t.PubDate).Skip((pageIndex - 1) * int.Parse(_config["blog:pageSize"])).Take(int.Parse(_config["blog:pageSize"])).ToListAsync();
var pageOption = new PagerOption
{
PageIndex = pageIndex,
PageSize = int.Parse(_config["blog:pageSize"]),
TotalCount = count,
RouteUrl = $"/search/{category}"
};
ViewBag.PagerOption = pageOption;
return(View("Photos", data));
}
