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