/// <summary> /// 获取积分列表 /// </summary> /// <param name="searchView"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public MemScoreSearchView GetList(MemScoreSearchView searchView, int pageIndex, int pageSize) { var expression = base.GetFilterEnabled(); if (searchView.SearchType.HasValue) { expression = expression.And(t => t.OperatType == searchView.SearchType.Value); } if (!searchView.ScoreType.IsEmpty()) { expression = expression.And(t => t.ScoreType == searchView.ScoreType); } if (searchView.StartDate.HasValue) { expression = expression.And(t => t.CreatorTime >= searchView.StartDate); } if (searchView.EndDate.HasValue) { expression = expression.And(t => t.CreatorTime <= searchView.EndDate); } //会员信息 if (!searchView.MemberId.IsEmpty()) { expression = expression.And(t => t.MemberId == searchView.MemberId); } searchView.MemScore = _MemRespository.GetMemScore(searchView.MemberId); searchView.TotalScore = _Respository.Get(expression).Sum(w => w.Score); searchView.ScoreList = _Respository.GetPagedList(u => new MemScoreDetailView { Id = u.Id, Score = u.Score, MemberId = u.MemberId, ScoreType = u.ScoreType, CreatorTime = u.CreatorTime, Description = u.Description, OperatType = u.OperatType }, expression, pageIndex, pageSize, o => o.OrderBy(b => b.SortCode)); return(searchView); }
/// <summary> /// 我的积分 /// </summary> /// <returns></returns> public IActionResult UserScore([FromServices] IMemberScoreService memberScoreService, MemScoreSearchView searchView, int p = 1) { AddPageCrumbs("我的积分"); searchView.MemberId = CoreContextProvider.CurrentMember.UserId; return(View(memberScoreService.GetList(searchView, p, PageSize))); }
public ActionResult GetGridJson([FromServices] ISysItemsDetailService sysItemsDetailService, MemScoreSearchView search, int page = 1) { var data = _MemberScoreService.GetList(search, page, PageSize); if (data.ScoreList != null && data.ScoreList.Any()) { var scoreTypes = data.ScoreList.Select(w => w.ScoreType + "").Distinct().ToArray(); var itemDatas = sysItemsDetailService.GetListItem("ScoreType", scoreTypes).ToDictionary(k => k.Code, v => v.Text); data.ScoreList.ForEach(score => { score.ScoreTypeName = itemDatas.TryGetValue(score.ScoreType + "");//ExtList.TryGetValue(); }); } return(Content(new { rows = data.ScoreList, total = data.ScoreList.PageCount, page = data.ScoreList.PageIndex, records = data.ScoreList.TotalCount }.ToJson())); }