public ActionResult BonusList(string usercode, string truename, DateTime?start, DateTime?end, int type = 0, int pageIndex = 1) { BonusListModel model = new BonusListModel(); //查询数据 BonusPageResult bonusModel = new BonusPageResult(); bonusModel = bonusService.GetPageList(0, usercode, truename, type, start, end, pageIndex, PageSize); model.bonusList = bonusModel.BonusS; //分页 Pagination pager = new Pagination(); pager.PageIndex = pageIndex; pager.PageSize = PageSize; pager.TotalCount = bonusModel.TotalCount; if (bonusModel.TotalCount <= PageSize) { model.Page = ""; } else { model.Page = pager.GetPagerHtml(); } return(Json(new AjaxResult { Status = "1", Data = model })); }
/// <summary> /// 奖金明细列表 /// </summary> /// <returns></returns> public ActionResult BonusList() { BonusListModel model = new BonusListModel(); //查询数据 BonusPageResult bonusModel = new BonusPageResult(); bonusModel = bonusService.GetPageList(0, "", "", 0, null, null, 1, PageSize); model.bonusList = bonusModel.BonusS; //分页 Pagination pager = new Pagination(); pager.PageIndex = 1; pager.PageSize = PageSize; pager.TotalCount = bonusModel.TotalCount; if (bonusModel.TotalCount <= PageSize) { model.Page = ""; } else { model.Page = pager.GetPagerHtml(); } //币种 model.bonusTypeList = bonustypeService.GetList(); var selectItemList = new List <SelectListItem>() { new SelectListItem() { Value = "0", Text = "请选择", Selected = true } }; var selectList = new SelectList(model.bonusTypeList, "ID", "TypeName"); selectItemList.AddRange(selectList); ViewBag.bonustype = selectItemList; return(View(model)); }
public BonusPageResult GetPageList(long UserID, string UserCode, string TrueName, int TypeID, DateTime?StartTime, DateTime?EndTime, int PageIndex, int PageSize) { using (MyDbContext dbcontext = new MyDbContext()) { CommonService <BonusEntity> csr = new CommonService <BonusEntity>(dbcontext); BonusPageResult PageResult = new BonusPageResult(); var JournalQuery = csr.GetAll(); if (UserID > 0) { JournalQuery = JournalQuery.Where(p => p.UserID == UserID); } if (!string.IsNullOrEmpty(UserCode)) { JournalQuery = JournalQuery.Where(p => p.Users.UserCode.Contains(UserCode)); } if (!string.IsNullOrEmpty(TrueName)) { JournalQuery = JournalQuery.Where(p => p.Users.TrueName.Contains(TrueName)); } if (TypeID > 0) { JournalQuery = JournalQuery.Where(p => p.TypeID == TypeID); } if (StartTime != null) { JournalQuery = JournalQuery.Where(p => p.CreateTime >= StartTime); } if (EndTime != null) { JournalQuery = JournalQuery.Where(p => p.CreateTime <= EndTime); } PageResult.BonusS = JournalQuery.OrderByDescending(p => p.CreateTime).Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList().Select(p => ToDTO(p)).ToArray(); PageResult.TotalCount = JournalQuery.LongCount(); return(PageResult); } }