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()); }