PumpkinHouseWeb/Admin/ShopStat.aspx.cs

   1 using System;
   2 using System.Collections.Generic;
   3 using System.Linq;
   4 using System.Web;
   5 using System.Web.UI;
   6 using System.Web.UI.WebControls;
   7 using PumpkinHouseDatabase;
   8 using PumpkinHouse.Utils;
   9
  10 namespace PumpkinHouse.Admin
  11 {
  12     public class ShopPriceStat
  13     {
  14         public string Code { get; set; }
  15         public string Name { get; set; }
  16         public int Lt50 { get; set; }
  17         public int Btw50N100 { get; set; }
  18         public int Btw100N200 { get; set; }
  19         public int Btw200N300 { get; set; }
  20         public int Btw300N500 { get; set; }
  21         public int Gt500 { get; set; }
  22         public int NoPrice { get;set;}
  23         public int Total { get { return Lt50 + Btw50N100 + Btw100N200 + Btw200N300 + Btw300N500 + Gt500 + NoPrice; } }
  24     }
  25
  26     public partial class ShopStat : System.Web.UI.Page
  27     {
  28         protected void Page_Load(object sender, EventArgs e)
  29         {
  30
  31         }
  32
  33         private string[] names = new string[] { "", "淘宝", "京东", "（天猫）淘宝商城", "宜家", "凡客", "阿里巴巴", "当当", "亚马逊中国", "拍拍", "优雅", "趣玩", "51悠品", "易趣网", "一号店", "苏宁", "国美" };
  34
  35         protected void StartCalc(object sender, EventArgs e)
  36         {
  37             Dictionary<Shop, ShopPriceStat> dict = new Dictionary<Shop, ShopPriceStat>();
  38
  39             foreach (var s in (Shop[])Enum.GetValues(typeof(Shop)))
  40             {
  41                 if (s == Shop.NotShop) continue;
  42                 dict.Add(s, new ShopPriceStat { Code = Enum.GetName(typeof(Shop), s), Name = names[(byte)s] });
  43             }
  44
  45             using (DataUtils utils = new DataUtils())
  46             {
  47                 IList<DB_Picture> pictures = utils.FindAllPictures(null, true).ToList();
  48                 foreach (var pic in pictures)
  49                 {
  50                     Shop shop = (Shop)pic.Shop;
  51                     ShopPriceStat stat = dict[shop];
  52                     if (pic.Price == 0)
  53                     {
  54                         stat.NoPrice++;
  55                     }
  56                     else if (pic.Price <= 50)
  57                     {
  58                         stat.Lt50++;
  59                     }
  60                     else if (pic.Price <= 100)
  61                     {
  62                         stat.Btw50N100++;
  63                     }
  64                     else if (pic.Price <= 200)
  65                     {
  66                         stat.Btw100N200++;
  67                     }
  68                     else if (pic.Price <= 300)
  69                     {
  70                         stat.Btw200N300++;
  71                     }
  72                     else if (pic.Price <= 500)
  73                     {
  74                         stat.Btw300N500++;
  75                     }
  76                     else
  77                     {
  78                         stat.Gt500++;
  79                     }
  80                 }
  81             }
  82
  83             ShopGridView.DataSource = dict.Values.OrderByDescending(i => i.Total);
  84             ShopGridView.DataBind();
  85         }
  86     }
  87 }