private void DrawPie() { string ttt = string.Concat(new object[] { "第", this.WeekOfYear(DateTime.Parse(this.week).AddDays(-7.0)), "周与第", this.WeekOfYear(DateTime.Parse(this.week)), "周的人流统计分析图-周图表" }); ChartServices.SetChartTitle(this.WebChartControl1, true, ttt, StringAlignment.Center, ChartTitleDockStyle.Top, true, new Font("宋体", 12f, FontStyle.Bold), Color.Red, 10); ChartServices.DrawChart(this.WebChartControl1, "人数", this.types, this.loadz(), "类型", "人数"); }
private void DrawPie() { string title = "店铺消费金额统计表"; ChartServices.SetChartTitle(this.WebChartControl1, true, title, StringAlignment.Center, ChartTitleDockStyle.Top, true, new Font("宋体", 12f, FontStyle.Bold), Color.Red, 10); ChartServices.DrawChart(this.WebChartControl1, "消费金额", this.types, this.load(), "sName", "mony"); }
private void DrawPie() { string title = "区域会员统计树形图"; ChartServices.SetChartTitle(this.WebChartControl1, true, title, StringAlignment.Center, ChartTitleDockStyle.Top, true, new Font("宋体", 12f, FontStyle.Bold), Color.Red, 10); ChartServices.DrawChart(this.WebChartControl1, "人数", ViewType.Bar, this.load(), "mTown", "cout"); }
public void GetBarNames_OneDay_MultipleItemsDifferentNames() { // arrange var foodItems = new List <FoodItem> { new FoodItem { Code = "1", Name = "XXX" }, new FoodItem { Code = "2", Name = "YYY" } }; var days = new List <Day> { new Day { Date = new DateTime(2015, 1, 19), Food = foodItems } }; var expected = new List <string> { "XXX", "YYY", "Total" }; // act List <string> actual = new ChartServices().GetBarNames(days); // assert CollectionAssert.AreEqual(expected, actual); }
private void DrawPie() { string title = "年龄段会员统计比例饼状图"; ChartServices.SetChartTitle(this.WebChartControl1, true, title, StringAlignment.Center, ChartTitleDockStyle.Top, true, new Font("宋体", 12f, FontStyle.Bold), Color.Red, 10); ChartServices.DrawChart(this.WebChartControl1, "人数", ViewType.Pie, this.llnian(), "nian", "count"); }
private void DrawPie() { string title = DateTime.Parse(this.day).AddDays(-1.0).ToString("yyyy-MM-dd") + "与" + this.day + "的人流统计分析图-日图表"; ChartServices.SetChartTitle(this.WebChartControl1, true, title, StringAlignment.Center, ChartTitleDockStyle.Top, true, new Font("宋体", 12f, FontStyle.Bold), Color.Red, 10); ChartServices.DrawChart(this.WebChartControl1, "人数", this.types, this.loadz(), "类型", "人数"); }
private void DrawPie() { string title = this.years + "年-每月会员充值金额统计分析图"; ChartServices.SetChartTitle(this.WebChartControl1, true, title, StringAlignment.Center, ChartTitleDockStyle.Top, true, new Font("宋体", 12f, FontStyle.Bold), Color.Red, 10); ChartServices.DrawChart(this.WebChartControl1, "充值金额", this.types, this.load(), "month", "money"); }
public void TestCalculateMicronutrientByDayOneProductOneDay() { // Arrange ChartServices chartServices = new ChartServices(myFoodItemServices.Object, myProductServices.Object); var productServices = new ProductServices(); myProductServices.Setup(m => m.GetProducts(It.IsAny <string>(), It.IsAny <List <Day> >())).Returns(new List <Product> { new Product { Code = "XXX", ProductMicronutrients = productServices.UpdateProductMicronutrients(Micronutrients) } }); myFoodItemServices.Setup(m => m.GetDays(It.IsAny <DateTime>(), It.IsAny <DateTime>(), It.IsAny <string>())).Returns(new List <Day> { new Day { Food = new List <FoodItem> { new FoodItem { Code = "XXX", Quantity = 10 } } } }); var nutrients = new List <string> { "Folate" }; // Act var result = chartServices.CalculateMicronutrientByDay(DateTime.Now, DateTime.Now, nutrients, It.IsAny <string>()); // Assert Assert.AreEqual(5, result[0].Sum()); }
private void DrawLine() { ChartServices.SetChartTitle(this.WebChartControl3, true, "2012年12月第1周收入情况", StringAlignment.Center, ChartTitleDockStyle.Top, true, new Font("宋体", 12f, FontStyle.Bold), Color.Red, 10); ChartServices.DrawChart(this.WebChartControl3, "收益", ViewType.Line, ServiceData.GetWeekMoneyAndCost(), "week", "money"); ChartServices.DrawChart(this.WebChartControl3, "成本", ViewType.Line, ServiceData.GetWeekMoneyAndCost(), "week", "cost"); ChartServices.SetAxisX(this.WebChartControl3, true, StringAlignment.Center, "星期", Color.Red, true, new Font("宋体", 12f, FontStyle.Bold)); ChartServices.SetAxisY(this.WebChartControl3, true, StringAlignment.Center, "金额", Color.Red, true, new Font("宋体", 12f, FontStyle.Bold)); }
private void DrawPie() { string sql = "select DATEADD(wk, DATEDIFF(wk,0,'" + this.month + "'), 0) as one"; DataTable dt = this.bc.ReadTable(sql); string title = DateTime.Parse(dt.Rows[0][0].ToString()).ToString("yyyy-MM-dd") + "至" + DateTime.Parse(dt.Rows[0][0].ToString()).AddDays(6.0).ToString("yyyy-MM-dd") + "会员消费金额统计分析图"; ChartServices.SetChartTitle(this.WebChartControl1, true, title, StringAlignment.Center, ChartTitleDockStyle.Top, true, new Font("宋体", 12f, FontStyle.Bold), Color.Red, 10); ChartServices.DrawChart(this.WebChartControl1, "消费金额", this.types, this.load(), "day", "money"); }
public string GetmonthByChart() { int adminid = Convert.ToInt16(Session["AdminId"]); ChartServices _ser = new ChartServices(); var chart = _ser.GetJobByMonth(adminid); JavaScriptSerializer obj = new JavaScriptSerializer(); return(obj.Serialize(chart)); }
public void TestCalculateMacroNutrientByProductTwoDifferentFoodItems() { // Arrange ChartServices chartServices = new ChartServices(myFoodItemServices.Object, myProductServices.Object); var productServices = new ProductServices(); myProductServices.Setup(m => m.GetProducts(It.IsAny <string>(), It.IsAny <List <Day> >())).Returns(new List <Product> { new Product { Code = "XXX", ProductMicronutrients = productServices.UpdateProductMicronutrients(Micronutrients) }, new Product { Code = "YYY", ProductMicronutrients = productServices.UpdateProductMicronutrients(Micronutrients) } }); myFoodItemServices.Setup(m => m.GetDays(It.IsAny <DateTime>(), It.IsAny <DateTime>(), It.IsAny <string>())).Returns(new List <Day> { new Day { Food = new List <FoodItem> { new FoodItem { Code = "XXX", Quantity = 10 }, new FoodItem { Code = "YYY", Quantity = 20 } } } }); var nutrients = new List <string> { "Folate", "Calcium" }; var expected = new List <List <decimal?> > { new List <decimal?> { 5, 10 }, new List <decimal?> { 5, 10 } }; // Act var actual = chartServices.CalculateMicronutrientByProduct(DateTime.Now, DateTime.Now, nutrients, It.IsAny <string>()); // Assert CollectionAssert.AreEqual(expected[0], actual[0]); CollectionAssert.AreEqual(expected[1], actual[1]); }
public void CalculateTotalEnergyData_MultipleDays_OneItem() { // arrange var foodItems1 = new List <FoodItem> { new FoodItem { Code = "1", Quantity = 1 } }; var foodItems2 = new List <FoodItem> { new FoodItem { Code = "1", Quantity = 1 } }; var days = new List <Day> { new Day { Date = new DateTime(2015, 1, 19), Food = foodItems1 }, new Day { Date = new DateTime(2015, 1, 20), Food = foodItems2 } }; var products = new List <Product> { new Product { Code = "1", Nutrients = new Dictionary <string, double> { { "Protein", 10 }, { "Carbohydrates", 10 }, { "Fat", 10 } }, ServingSize = 100 }, new Product { Code = "2", Nutrients = new Dictionary <string, double> { { "Protein", 10 }, { "Carbohydrates", 10 }, { "Fat", 10 } }, ServingSize = 0 } }; var expected = new List <double> { 23.5, 23.5, 52.9 }; // act List <double> actual = new ChartServices().CalculateTotalEnergyData(days, products); // assert CollectionAssert.AreEqual(expected, actual); }
public void CalculateNutrientByProduct_OneDay_TwoItemsOneMultiple() { // arrange var foodItems = new List <FoodItem> { new FoodItem { Code = "1", Quantity = 3 }, new FoodItem { Code = "2", Quantity = 100 } }; var days = new List <Day> { new Day { Date = new DateTime(2015, 1, 19), Food = foodItems } }; var products = new List <Product> { new Product { Code = "1", Nutrients = new Dictionary <string, double> { { "Protein", 5.6 } }, ServingSize = 100 }, new Product { Code = "2", Nutrients = new Dictionary <string, double> { { "Protein", 1.4 } }, ServingSize = 0 } }; var expected = new List <double> { 16.8, 1.4, 18.2 }; // act List <double> actual = new ChartServices().CalculateNutrientByProduct(days, products, "Protein"); // assert CollectionAssert.AreEqual(expected, actual); }
private void DrawPie() { string ttt = string.Concat(new object[] { "第", this.WeekOfYear(DateTime.Parse(this.week).AddDays(-7.0)), "周与第", this.WeekOfYear(DateTime.Parse(this.week)), "周的会员消费金额统计分析图" }); ChartServices.SetChartTitle(this.WebChartControl1, true, ttt, StringAlignment.Center, ChartTitleDockStyle.Top, true, new Font("宋体", 12f, FontStyle.Bold), Color.Red, 10); if (this.types == ViewType.Bar) { ChartServices.DrawChart(this.WebChartControl1, "会员卡", this.types, this.load(), "类型", "会员卡"); ChartServices.DrawChart(this.WebChartControl1, "临时卡", this.types, this.load(), "类型", "临时卡"); ChartServices.DrawChart(this.WebChartControl1, "散客卡", this.types, this.load(), "类型", "散客卡"); } else { ChartServices.DrawChart(this.WebChartControl1, "上周", this.types, this.loadz(), "CardType", "上周"); ChartServices.DrawChart(this.WebChartControl1, "本周", this.types, this.loadz(), "CardType", "本周"); } }
private void DrawPie() { string title = DateTime.Parse(this.day).AddDays(-1.0).ToString("yyyy-MM-dd") + "与" + this.day + "的会员消费金额统计分析图"; ChartServices.SetChartTitle(this.WebChartControl1, true, title, StringAlignment.Center, ChartTitleDockStyle.Top, true, new Font("宋体", 12f, FontStyle.Bold), Color.Red, 10); if (this.types == ViewType.Bar) { ChartServices.DrawChart(this.WebChartControl1, "会员卡", this.types, this.load(), "类型", "会员卡"); ChartServices.DrawChart(this.WebChartControl1, "临时卡", this.types, this.load(), "类型", "临时卡"); ChartServices.DrawChart(this.WebChartControl1, "散客卡", this.types, this.load(), "类型", "散客卡"); } else { ChartServices.DrawChart(this.WebChartControl1, "昨天", this.types, this.loadz(), "CardType", "昨天"); ChartServices.DrawChart(this.WebChartControl1, "今天", this.types, this.loadz(), "CardType", "今天"); } }
public void CalculateAlcoholByProduct_OneDay_MultipleItems() { // arrange var foodItems = new List <FoodItem> { new FoodItem { Code = "1", Quantity = 568 }, new FoodItem { Code = "2", Quantity = 2 } }; var days = new List <Day> { new Day { Date = new DateTime(2015, 1, 19), Food = foodItems } }; var products = new List <Product> { new Product { Code = "1", Nutrients = new Dictionary <string, double> { { "Alcohol", 4.2 } }, ServingSize = 0 }, new Product { Code = "2", Nutrients = new Dictionary <string, double> { { "Alcohol", 4.2 } }, ServingSize = 568 } }; var expected = new List <double> { 2.4, 4.8, 7.2 }; // act List <double> actual = new ChartServices().CalculateAlcoholByProduct(days, products); // assert CollectionAssert.AreEqual(expected, actual); }
public void GetDates_OneDay() { // arrange var days = new List <Day> { new Day { Date = new DateTime(2015, 1, 19) } }; var expected = new List <string> { "19/01/2015" }; // act List <string> actual = new ChartServices().GetDates(days); // assert CollectionAssert.AreEqual(expected, actual); }
public void CalculateNutrientByDay_MultipleDays_MultipleItems() { // arrange var foodItems1 = new List <FoodItem> { new FoodItem { Code = "1", Quantity = 1 }, new FoodItem { Code = "2", Quantity = 100 } }; var foodItems2 = new List <FoodItem> { new FoodItem { Code = "3", Quantity = 2 }, new FoodItem { Code = "4", Quantity = 10 } }; var foodItems3 = new List <FoodItem> { new FoodItem { Code = "3", Quantity = 1 }, new FoodItem { Code = "4", Quantity = 5 } }; var days = new List <Day> { new Day { Date = new DateTime(2015, 1, 19), Food = foodItems1 }, new Day { Date = new DateTime(2015, 1, 20), Food = foodItems2 }, new Day { Date = new DateTime(2015, 1, 21), Food = foodItems3 } }; var products = new List <Product> { new Product { Code = "1", Nutrients = new Dictionary <string, double> { { "Protein", 5 } }, ServingSize = 100 }, new Product { Code = "2", Nutrients = new Dictionary <string, double> { { "Protein", 30 } }, ServingSize = 0 }, new Product { Code = "3", Nutrients = new Dictionary <string, double> { { "Protein", 10 } }, ServingSize = 100 }, new Product { Code = "4", Nutrients = new Dictionary <string, double> { { "Protein", 50 } }, ServingSize = 0 } }; var expected = new List <double> { 35, 25, 12.5 }; // act List <double> actual = new ChartServices().CalculateNutrientByDay(days, products, "Protein"); // assert CollectionAssert.AreEqual(expected, actual); }
private void DrawPie() { ChartServices.SetChartTitle(this.WebChartControl4, true, "2012年12月第1周收入情况", StringAlignment.Center, ChartTitleDockStyle.Top, true, new Font("宋体", 12f, FontStyle.Bold), Color.Red, 10); ChartServices.DrawChart(this.WebChartControl4, ServiceData.GetWeekMoneyAndCost().Rows[0][0].ToString(), ViewType.Pie, ServiceData.GetWeekMoneyAndCost(), "week", "money"); }
public ChartsController(UserManager <IdentityUser> users, ChartServices services, ApplicationDbContext db) { this.users = users; this.services = services; this.db = db; }