public override void OnLoad(HttpContext context) { base.OnLoad(context); if (context.Request["flag"] == "GetStoreUsersStatistics") { Pagination pagination = new Pagination(); int shoppingGuiderId = 0; int num = context.Request["PageIndex"].ToInt(0); if (num < 1) { num = 1; } int num2 = context.Request["PageSize"].ToInt(0); if (num2 < 1) { num2 = 10; } int num3 = context.Request["GroupId"].ToInt(0); if (num3 != 1 && num3 != 2 && num3 != 3 && num3 != 0) { num3 = 0; } int num4 = context.Request["TimeScope"].ToInt(0); if (num4 != 1 && num4 != 3 && num4 != 6 && num4 != 9 && num4 != 12) { num4 = 1; } if (num3 == 2 && num4 != 1 && num4 != 3 && num4 != 6) { num4 = 1; } pagination.PageIndex = num; pagination.PageSize = num2; pagination.SortBy = "PayDate"; pagination.SortOrder = SortAction.Desc; int storeId = base.CurrentManager.StoreId; string keyword = Globals.StripAllTags(context.Request["Keyword"].ToNullString()); StoreMemberStatisticsQuery storeMemberStatisticsQuery = new StoreMemberStatisticsQuery(); storeMemberStatisticsQuery.Keyword = keyword; storeMemberStatisticsQuery.GroupId = num3; storeMemberStatisticsQuery.PageIndex = num; storeMemberStatisticsQuery.PageSize = num2; storeMemberStatisticsQuery.ShoppingGuiderId = shoppingGuiderId; storeMemberStatisticsQuery.StoreId = storeId; storeMemberStatisticsQuery.TimeScope = num4; storeMemberStatisticsQuery.SortBy = "UserId"; storeMemberStatisticsQuery.SortOrder = SortAction.Desc; SiteSettings siteSettings = HiContext.Current.SiteSettings; PageModel <StoreMemberStatisticsModel> storeMemberStatisticsList = MemberProcessor.GetStoreMemberStatisticsList(storeMemberStatisticsQuery, siteSettings.ConsumeTimesInOneMonth, siteSettings.ConsumeTimesInThreeMonth, siteSettings.ConsumeTimesInSixMonth); string s = JsonConvert.SerializeObject(new { Result = new { RecordCount = storeMemberStatisticsList.Total, List = from u in storeMemberStatisticsList.Models select new { UserId = u.UserId, NickName = (string.IsNullOrEmpty(u.NickName) ? (string.IsNullOrEmpty(u.RealName) ? u.UserName : u.RealName) : u.NickName), UserName = u.UserName, LastConsumeDate = (u.LastConsumeDate.HasValue ? u.LastConsumeDate.Value.ToString("yyyy-MM-dd HH:mm:ss") : ""), ConsumeTimes = u.ConsumeTimes, ConsumeTotal = u.ConsumeTotal.F2ToString("f2").ToDecimal(0), HeadImage = (string.IsNullOrEmpty(u.HeadImage.ToNullString()) ? Globals.FullPath("/templates/common/images/headerimg.png") : Globals.FullPath(u.HeadImage.ToNullString())) } } }); context.Response.Write(s); context.Response.End(); } }
public override void OnLoad(HttpContext context) { base.OnLoad(context); if (context.Request["flag"] == "GetStoreUsersStatistics") { Pagination page = new Pagination(); int shoppingGuiderId = 0; int pageIndex = context.Request["PageIndex"].ToInt(); if (pageIndex < 1) { pageIndex = 1; } int pageSize = context.Request["PageSize"].ToInt(); if (pageSize < 1) { pageSize = 10; } int GroupId = context.Request["GroupId"].ToInt(); if (GroupId != 1 && GroupId != 2 && GroupId != 3 && GroupId != 0) { GroupId = 0; } int TimeScope = context.Request["TimeScope"].ToInt(); if (TimeScope != 1 && TimeScope != 3 && TimeScope != 6 && TimeScope != 9 && TimeScope != 12) { TimeScope = 1; } if (GroupId == 2 && TimeScope != 1 && TimeScope != 3 && TimeScope != 6) { TimeScope = 1; } page.PageIndex = pageIndex; page.PageSize = pageSize; page.SortBy = "PayDate"; page.SortOrder = SortAction.Desc; Int32 storeId = CurrentManager.StoreId; string keyword = Globals.StripAllTags(context.Request["Keyword"].ToNullString()); StoreMemberStatisticsQuery query = new StoreMemberStatisticsQuery(); query.Keyword = keyword; query.GroupId = GroupId; query.PageIndex = pageIndex; query.PageSize = pageSize; query.ShoppingGuiderId = shoppingGuiderId; query.StoreId = storeId; query.TimeScope = TimeScope; query.SortBy = "UserId"; query.SortOrder = SortAction.Desc; SiteSettings setting = HiContext.Current.SiteSettings; PageModel <StoreMemberStatisticsModel> data = MemberProcessor.GetStoreMemberStatisticsList(query, setting.ConsumeTimesInOneMonth, setting.ConsumeTimesInThreeMonth, setting.ConsumeTimesInSixMonth); var json = JsonConvert.SerializeObject(new { Result = new { RecordCount = data.Total, List = data.Models.Select(u => new { u.UserId, NickName = string.IsNullOrEmpty(u.NickName) ? (string.IsNullOrEmpty(u.RealName) ? u.UserName : u.RealName) : u.NickName, u.UserName, LastConsumeDate = u.LastConsumeDate.HasValue ? u.LastConsumeDate.Value.ToString("yyyy-MM-dd HH:mm:ss") : "", u.ConsumeTimes, ConsumeTotal = u.ConsumeTotal.F2ToString("f2").ToDecimal(), HeadImage = string.IsNullOrEmpty(u.HeadImage.ToNullString()) ? Globals.FullPath("/templates/common/images/headerimg.png") : Globals.FullPath(u.HeadImage.ToNullString()), }) } }); context.Response.Write(json); context.Response.End(); } }