コード例 #1
0
 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();
     }
 }
コード例 #2
0
        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();
            }
        }