public async Task <IActionResult> GetPayments([FromQuery] string name, [FromBody] TablePagination model)
{
if (string.IsNullOrWhiteSpace(name))
{
name = null;
}
var query = this.context.Payments.Where(x => name == null || x.Charity.Name.Contains(name)).Select(x => new
{
x.Id,
x.Amount,
x.Desceiption,
x.PaymentDateTime,
x.CharityId,
CharityName = x.Charity.Name,
x.UserId,
x.User.UserName,
UserFullName = x.User.Name + " " + x.User.Surname
});
var count = await query.CountAsync();
var totalAmount = await query.SumAsync(x => x.Amount);
var dataQuery = query.Skip(model.ItemsPerPage * (model.Page - 1)).Take(model.ItemsPerPage);
return(this.Json(new { TotalCount = count, Data = await dataQuery.ToArrayAsync(), TotalAmount = totalAmount }));
}
/// <summary>
/// 垃圾箱 0收件箱， 1发件箱， 2草稿箱， 3回收站
/// </summary>
/// <returns></returns>
public IActionResult Trash(int pageIndex = 1, int pageSize = 10, string strKey = "")
{
List <Message> trashList = messageAppService.GetPagingMessage(3, pageIndex, pageSize, strKey, out int pageCount, out int itemCount);
ViewBag.Page = TablePagination.PagingHtml(pageIndex, pageSize, pageCount, itemCount, strKey);
ViewBag.PageIndex = pageIndex;
ViewBag.PageSize = pageSize;
ViewBag.Key = strKey;
return(View(trashList));
}
public IActionResult Index(int pageIndex = 1, int pageSize = 10, string strKey = "")
{
List <Document> docList = documentAppService.GetPagingDocuments(pageIndex, pageSize, out int pageCount, out int itemCount);
ViewBag.Page = TablePagination.PagingHtml(pageIndex, pageSize, pageCount, itemCount, strKey);
ViewBag.PageIndex = pageIndex;
ViewBag.PageSize = pageSize;
ViewBag.Key = strKey;
return(View(docList));
}
public IActionResult Index(int pageIndex = 1, int pageSize = 10, string strKey = "")
{
List <User> userList = userAppService.GetPagingUsers(pageIndex, pageSize, strKey, out int pageCount, out int itemCount);
ViewBag.Page = TablePagination.PagingHtml(pageIndex, pageSize, pageCount, itemCount, strKey);
ViewBag.PageIndex = pageIndex;
ViewBag.PageSize = pageSize;
ViewBag.Key = strKey;
return(View(userList));
}
//
// TODO
//
/// <summary>
/// 分页获取Roles数据
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="strRoleKey"></param>
/// <param name="strUserKey"></param>
/// <returns></returns>
public async Task <IActionResult> Index(int pageIndex = 1, int pageSize = 10, string strRoleKey = "", string strUserKey = "")
{
List <Role> roleList = await roleService.GetRoles();
//分页获取Roles
if (!string.IsNullOrEmpty(strRoleKey))
{
roleList = roleList.Where(q => q.Name.Contains(strRoleKey)).ToList();
}
List <User> userList = userService.GetPagingUsers(pageIndex, pageSize, strUserKey, out int pageCount, out int itemCount);
ViewBag.Page = TablePagination.PagingHtml(pageIndex, pageSize, pageCount, itemCount, strUserKey);
ViewBag.PageIndex = pageIndex;
ViewBag.PageSize = pageSize;
ViewBag.RoleKey = strRoleKey;
ViewData["RoleList"] = roleList;
return(View());
}
