public JsonResult GetMemberIntegralDetail(int page, int?userId, Himall.Entities.MemberIntegralInfo.IntegralType?type, DateTime?startDate, DateTime?endDate, int rows) { var query = new IntegralRecordQuery() { StartDate = startDate, EndDate = endDate, IntegralType = type, UserId = userId, PageNo = page, PageSize = rows }; var result = _iMemberIntegralService.GetIntegralRecordList(query); var list = result.Models.Select(item => { var actions = _iMemberIntegralService.GetIntegralRecordAction(item.Id); return(new { Id = item.Id, UserName = item.UserName, RecordDate = item.RecordDate.ToString("yyyy-MM-dd HH:mm:ss"), Integral = item.Integral, Type = item.TypeId.ToDescription(), Remark = GetRemarkFromIntegralType(item.TypeId, actions, item.ReMark) }); }); var model = new { rows = list, total = result.Total }; return(Json(model)); }
/// <summary> /// 获取用户积分明细 /// </summary> /// <param name="id">用户编号</param> /// <param name="type"></param> /// <param name="pageSize"></param> /// <param name="pageNo"></param> /// <returns></returns> public QueryPageModel <UserCenterGetIntegralRecordModel> GetIntegralRecord(MemberIntegral.IntegralType?type = null, int page = 1, int pagesize = 10) { CheckUserLogin(); var id = CurrentUser.Id; //处理当前用户与id的判断 var _iMemberIntegralService = ServiceHelper.Create <IMemberIntegralService>(); Himall.Model.MemberIntegral.IntegralType?integralType = type; var query = new IntegralRecordQuery() { IntegralType = integralType, UserId = id, PageNo = page, PageSize = pagesize }; var result = _iMemberIntegralService.GetIntegralRecordListForWeb(query); var list = result.Models.ToList().Select(item => new UserCenterGetIntegralRecordModel { Id = item.Id, RecordDate = item.RecordDate, Integral = item.Integral, TypeId = item.TypeId, ShowType = item.TypeId.ToDescription(), ReMark = GetRemarkFromIntegralType(item.TypeId, item.Himall_MemberIntegralRecordAction, item.ReMark) }); QueryPageModel <UserCenterGetIntegralRecordModel> pageresult = new QueryPageModel <UserCenterGetIntegralRecordModel>(); pageresult.Total = result.Total; pageresult.Models = list.ToList(); return(pageresult); }
public JsonResult <Result <dynamic> > GetIntegralRecordList(string openId, int pageNo = 1, int pageSize = 10) { CheckUserLogin(); IntegralRecordQuery query = new IntegralRecordQuery { UserId = CurrentUserId, PageNo = pageNo, PageSize = pageSize }; var list = MemberIntegralApplication.GetIntegralRecordList(query); if (list.Models != null) { var recordlist = list.Models.Select(a => { var actions = ServiceProvider.Instance <IMemberIntegralService> .Create.GetIntegralRecordAction(a.Id); return(new { Id = a.Id, MemberId = a.MemberId, UserName = a.UserName, TypeName = (a.TypeId == MemberIntegralInfo.IntegralType.WeiActivity) ? a.ReMark : a.TypeId.ToDescription(), Integral = a.Integral, RecordDate = ((DateTime)a.RecordDate).ToString("yyyy-MM-dd HH:mm:ss"), ReMark = GetRemarkFromIntegralType(a.TypeId, actions, a.ReMark) }); }); return(JsonResult <dynamic>(recordlist)); } return(JsonResult <dynamic>(new int[0])); }
public JsonResult GetMemberIntegralDetail(int page, int?userId, MemberIntegral.IntegralType?type, DateTime?startDate, DateTime?endDate, int rows) { long?nullable; IntegralRecordQuery integralRecordQuery = new IntegralRecordQuery() { StartDate = startDate, EndDate = endDate, IntegralType = type }; IntegralRecordQuery integralRecordQuery1 = integralRecordQuery; int?nullable1 = userId; if (nullable1.HasValue) { nullable = new long?(nullable1.GetValueOrDefault()); } else { nullable = null; } integralRecordQuery1.UserId = nullable; integralRecordQuery.PageNo = page; integralRecordQuery.PageSize = rows; PageModel <MemberIntegralRecord> integralRecordList = ServiceHelper.Create <IMemberIntegralService>().GetIntegralRecordList(integralRecordQuery); var list = from item in integralRecordList.Models.ToList() select new { Id = item.Id, UserName = item.UserName, RecordDate = item.RecordDate.Value.ToString("yyyy-MM-dd HH:mm:ss"), Integral = item.Integral, Type = item.TypeId.ToDescription(), Remark = GetRemarkFromIntegralType(item.TypeId, item.Himall_MemberIntegralRecordAction, item.ReMark) }; return(Json(new { rows = list, total = integralRecordList.Total })); }
/// <summary> /// 获取用户积分明细 /// </summary> /// <param name="id">用户编号</param> /// <param name="type"></param> /// <param name="pageSize"></param> /// <param name="pageNo"></param> /// <returns></returns> public object GetIntegralRecord(Himall.Entities.MemberIntegralInfo.IntegralType?type = null, int page = 1, int pagesize = 10) { CheckUserLogin(); //处理当前用户与id的判断 var _iMemberIntegralService = ServiceApplication.Create <IMemberIntegralService>(); var query = new IntegralRecordQuery() { IntegralType = type, UserId = CurrentUser.Id, PageNo = page, PageSize = pagesize }; var result = _iMemberIntegralService.GetIntegralRecordListForWeb(query); var list = result.Models.Select(item => { var actions = _iMemberIntegralService.GetIntegralRecordAction(item.Id); return(new UserCenterGetIntegralRecordModel { Id = item.Id, RecordDate = item.RecordDate, Integral = item.Integral, TypeId = item.TypeId, ShowType = (item.TypeId == MemberIntegralInfo.IntegralType.WeiActivity) ? item.ReMark : item.TypeId.ToDescription(), ReMark = GetRemarkFromIntegralType(item.TypeId, actions, item.ReMark) }); }); dynamic pageresult = SuccessResult(); pageresult.total = result.Total; pageresult.data = list.ToList(); return(pageresult); }
public QueryPageModel <MemberIntegralRecordInfo> GetIntegralRecordList(IntegralRecordQuery query) { //int total = 0; //IQueryable<MemberIntegralRecord> list = Context.MemberIntegralRecord.AsQueryable(); var list = DbFactory.Default.Get <MemberIntegralRecordInfo>(); if (query.UserId.HasValue) { list.Where(item => item.MemberId == query.UserId.Value); } if (query.StartDate.HasValue) { list.Where(item => query.StartDate <= item.RecordDate); } if (query.IntegralType.HasValue) { list.Where(item => item.TypeId == query.IntegralType.Value); } if (query.EndDate.HasValue) { list.Where(item => query.EndDate >= item.RecordDate); } //list = list.GetPage(d => d.OrderByDescending(o => o.Id), out total, query.PageNo, query.PageSize); var model = list.OrderByDescending(o => o.Id).ToPagedList(query.PageNo, query.PageSize); QueryPageModel <MemberIntegralRecordInfo> pageModel = new QueryPageModel <MemberIntegralRecordInfo>() { Models = model, Total = model.TotalRecordCount }; return(pageModel); }
public ActionResult Index(int?type, int pageSize = 10, int pageNo = 1) { int num; int num1; MemberIntegralExchangeRules integralChangeRule = ServiceHelper.Create <IMemberIntegralService>().GetIntegralChangeRule(); dynamic viewBag = base.ViewBag; num = (integralChangeRule == null ? 0 : integralChangeRule.IntegralPerMoney); viewBag.IntegralPerMoney = num; MemberIntegral memberIntegral = ServiceHelper.Create <IMemberIntegralService>().GetMemberIntegral(base.CurrentUser.Id); dynamic obj = base.ViewBag; num1 = (memberIntegral == null ? 0 : memberIntegral.AvailableIntegrals); obj.Integral = num1; MemberIntegral.IntegralType?nullable = null; if (type.HasValue) { nullable = new MemberIntegral.IntegralType?((MemberIntegral.IntegralType)type.Value); } IntegralRecordQuery integralRecordQuery = new IntegralRecordQuery() { IntegralType = nullable, UserId = new long?(base.CurrentUser.Id), PageNo = pageNo, PageSize = pageSize }; PageModel <MemberIntegralRecord> integralRecordList = ServiceHelper.Create <IMemberIntegralService>().GetIntegralRecordList(integralRecordQuery); IEnumerable <MemberIntegralRecord> list = from item in integralRecordList.Models.ToList() select new MemberIntegralRecord() { Id = item.Id, UserName = item.UserName, RecordDate = item.RecordDate, Integral = item.Integral, TypeId = item.TypeId, ReMark = GetRemarkFromIntegralType(item.TypeId, item.Himall_MemberIntegralRecordAction, item.ReMark) }; PagingInfo pagingInfo = new PagingInfo() { CurrentPage = pageNo, ItemsPerPage = pageSize, TotalItems = integralRecordList.Total }; ViewBag.pageInfo = pagingInfo; return(View(list)); }
// GET: Web/UserIntegral public ActionResult Index(int?type, int pageSize = 10, int pageNo = 1) { var model = _iMemberIntegralService.GetIntegralChangeRule(); ViewBag.IntegralPerMoney = model == null ? 0 : model.IntegralPerMoney; ViewBag.Integral = MemberIntegralApplication.GetAvailableIntegral(CurrentUser.Id); Mall.Entities.MemberIntegralInfo.IntegralType?integralType = null; if (type.HasValue) { integralType = (Mall.Entities.MemberIntegralInfo.IntegralType)type.Value; } var query = new IntegralRecordQuery() { IntegralType = integralType, UserId = CurrentUser.Id, PageNo = pageNo, PageSize = pageSize }; var result = _iMemberIntegralService.GetIntegralRecordListForWeb(query); var list = result.Models.Select(item => { var actions = _iMemberIntegralService.GetIntegralRecordAction(item.Id); return(new MemberIntegralRecordInfo { Id = item.Id, UserName = item.UserName, RecordDate = item.RecordDate, Integral = item.Integral, TypeId = item.TypeId, ReMark = GetRemarkFromIntegralType(item.TypeId, actions, item.ReMark) }); }); PagingInfo info = new PagingInfo { CurrentPage = pageNo, ItemsPerPage = pageSize, TotalItems = result.Total }; ViewBag.pageInfo = info; ViewBag.Keyword = string.IsNullOrWhiteSpace(SiteSettings.SearchKeyword) ? SiteSettings.Keyword : SiteSettings.SearchKeyword; ViewBag.Keywords = SiteSettings.HotKeyWords; return(View(list)); }
public PageModel <MemberIntegralRecord> GetIntegralRecordList(IntegralRecordQuery query) { int num = 0; IQueryable <MemberIntegralRecord> memberId = context.MemberIntegralRecord.AsQueryable <MemberIntegralRecord>(); if (query.UserId.HasValue) { memberId = from item in memberId where item.MemberId == query.UserId.Value select item; } if (query.StartDate.HasValue) { memberId = from item in memberId where query.StartDate <= item.RecordDate select item; } if (query.IntegralType.HasValue) { memberId = from item in memberId where (int)item.TypeId == (int)query.IntegralType.Value select item; } if (query.EndDate.HasValue) { memberId = from item in memberId where query.EndDate >= item.RecordDate select item; } memberId = memberId.GetPage(out num, query.PageNo, query.PageSize, null); return(new PageModel <MemberIntegralRecord>() { Models = memberId, Total = num }); }
// GET: Web/UserIntegral public ActionResult Index(int?type, int pageSize = 10, int pageNo = 1) { var model = _iMemberIntegralService.GetIntegralChangeRule(); ViewBag.IntegralPerMoney = model == null ? 0 : model.IntegralPerMoney; var memberIntegral = _iMemberIntegralService.GetMemberIntegral(CurrentUser.Id); ViewBag.Integral = memberIntegral == null ? 0 : memberIntegral.AvailableIntegrals; Himall.Model.MemberIntegral.IntegralType?integralType = null; if (type.HasValue) { integralType = (Himall.Model.MemberIntegral.IntegralType)type.Value; } var query = new IntegralRecordQuery() { IntegralType = integralType, UserId = CurrentUser.Id, PageNo = pageNo, PageSize = pageSize }; var result = _iMemberIntegralService.GetIntegralRecordListForWeb(query); var list = result.Models.ToList().Select(item => new MemberIntegralRecord { Id = item.Id, UserName = item.UserName, RecordDate = item.RecordDate, Integral = item.Integral, TypeId = item.TypeId, ReMark = GetRemarkFromIntegralType(item.TypeId, item.Himall_MemberIntegralRecordAction, item.ReMark) }); PagingInfo info = new PagingInfo { CurrentPage = pageNo, ItemsPerPage = pageSize, TotalItems = result.Total }; ViewBag.pageInfo = info; return(View(list)); }
/// <summary> /// 获取单个用户的积分记录 /// </summary> /// <param name="query"></param> /// <returns></returns> public static QueryPageModel <MemberIntegralRecordInfo> GetIntegralRecordList(IntegralRecordQuery query) { return(_iMemberIntegralService.GetIntegralRecordList(query)); }
/// <summary> /// 获取单个用户的积分记录,前台使用 /// </summary> /// <param name="query"></param> /// <returns></returns> public static ObsoletePageModel <MemberIntegralRecord> GetIntegralRecordListForWeb(IntegralRecordQuery query) { return(_iMemberIntegralService.GetIntegralRecordListForWeb(query)); }