/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { DevExpress.DataAccess.EntityFramework.EFConnectionParameters efConnectionParameters1 = new DevExpress.DataAccess.EntityFramework.EFConnectionParameters(); DevExpress.DashboardCommon.Dimension dimension1 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Measure measure1 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.Dimension dimension2 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Measure measure2 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.Dimension dimension3 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Dimension dimension4 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Measure measure3 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.Dimension dimension5 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Dimension dimension6 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Dimension dimension7 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.DateTimePeriod dateTimePeriod1 = new DevExpress.DashboardCommon.DateTimePeriod(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit1 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit2 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.DateTimePeriod dateTimePeriod2 = new DevExpress.DashboardCommon.DateTimePeriod(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit3 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit4 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.DateTimePeriod dateTimePeriod3 = new DevExpress.DashboardCommon.DateTimePeriod(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit5 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit6 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.DateTimePeriod dateTimePeriod4 = new DevExpress.DashboardCommon.DateTimePeriod(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit7 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit8 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.Dimension dimension8 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Measure measure4 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.Measure measure5 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.Measure measure6 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.Measure measure7 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.Card card1 = new DevExpress.DashboardCommon.Card(); DevExpress.DashboardCommon.CardStretchedLayoutTemplate cardStretchedLayoutTemplate1 = new DevExpress.DashboardCommon.CardStretchedLayoutTemplate(); DevExpress.DashboardCommon.Dimension dimension9 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Dimension dimension10 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Dimension dimension11 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Measure measure8 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.ChartPane chartPane1 = new DevExpress.DashboardCommon.ChartPane(); DevExpress.DashboardCommon.SimpleSeries simpleSeries1 = new DevExpress.DashboardCommon.SimpleSeries(); DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup1 = new DevExpress.DashboardCommon.DashboardLayoutGroup(); DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup2 = new DevExpress.DashboardCommon.DashboardLayoutGroup(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem1 = new DevExpress.DashboardCommon.DashboardLayoutItem(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem2 = new DevExpress.DashboardCommon.DashboardLayoutItem(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem3 = new DevExpress.DashboardCommon.DashboardLayoutItem(); DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup3 = new DevExpress.DashboardCommon.DashboardLayoutGroup(); DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup4 = new DevExpress.DashboardCommon.DashboardLayoutGroup(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem4 = new DevExpress.DashboardCommon.DashboardLayoutItem(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem5 = new DevExpress.DashboardCommon.DashboardLayoutItem(); DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup5 = new DevExpress.DashboardCommon.DashboardLayoutGroup(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem6 = new DevExpress.DashboardCommon.DashboardLayoutItem(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem7 = new DevExpress.DashboardCommon.DashboardLayoutItem(); this.dashboardEFDataSource1 = new DevExpress.DashboardCommon.DashboardEFDataSource(); this.pieDashboardItem2 = new DevExpress.DashboardCommon.PieDashboardItem(); this.pieDashboardItem3 = new DevExpress.DashboardCommon.PieDashboardItem(); this.pivotDashboardItem1 = new DevExpress.DashboardCommon.PivotDashboardItem(); this.dateFilterDashboardItem1 = new DevExpress.DashboardCommon.DateFilterDashboardItem(); this.scatterChartDashboardItem1 = new DevExpress.DashboardCommon.ScatterChartDashboardItem(); this.cardDashboardItem1 = new DevExpress.DashboardCommon.CardDashboardItem(); this.chartDashboardItem1 = new DevExpress.DashboardCommon.ChartDashboardItem(); ((System.ComponentModel.ISupportInitialize)(this.dashboardEFDataSource1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.pieDashboardItem2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.pieDashboardItem3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.pivotDashboardItem1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension4)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension5)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension6)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dateFilterDashboardItem1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension7)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.scatterChartDashboardItem1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension8)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure4)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure5)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure6)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.cardDashboardItem1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure7)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension9)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension10)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension11)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure8)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // dashboardEFDataSource1 // this.dashboardEFDataSource1.ComponentName = "dashboardEFDataSource1"; efConnectionParameters1.ConnectionString = ""; efConnectionParameters1.ConnectionStringName = "EntitiesDataModel"; efConnectionParameters1.Source = typeof(TypicalSouthernFoods.Web.Persistence.EntitiesDataModel); this.dashboardEFDataSource1.ConnectionParameters = efConnectionParameters1; this.dashboardEFDataSource1.Name = "EF Data Source 1"; // // pieDashboardItem2 // dimension1.DataMember = "INVOICE.WAITER.NAMES"; this.pieDashboardItem2.Arguments.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension1 }); this.pieDashboardItem2.ComponentName = "pieDashboardItem2"; measure1.DataMember = "INVOICE.ID"; measure1.Name = "Invoices (Count)"; measure1.SummaryType = DevExpress.DashboardCommon.SummaryType.Count; this.pieDashboardItem2.DataItemRepository.Clear(); this.pieDashboardItem2.DataItemRepository.Add(dimension1, "DataItem0"); this.pieDashboardItem2.DataItemRepository.Add(measure1, "DataItem1"); this.pieDashboardItem2.DataMember = "INVOICES_DET"; this.pieDashboardItem2.DataSource = this.dashboardEFDataSource1; this.pieDashboardItem2.InteractivityOptions.IgnoreMasterFilters = false; this.pieDashboardItem2.Name = "% Orders by Waiter"; this.pieDashboardItem2.ShowCaption = true; this.pieDashboardItem2.Values.AddRange(new DevExpress.DashboardCommon.Measure[] { measure1 }); // // pieDashboardItem3 // dimension2.DataMember = "RECIPE_NAME"; this.pieDashboardItem3.Arguments.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension2 }); this.pieDashboardItem3.ComponentName = "pieDashboardItem3"; measure2.DataMember = "ID"; measure2.Name = "Recipes (Count)"; measure2.SummaryType = DevExpress.DashboardCommon.SummaryType.Count; this.pieDashboardItem3.DataItemRepository.Clear(); this.pieDashboardItem3.DataItemRepository.Add(measure2, "DataItem1"); this.pieDashboardItem3.DataItemRepository.Add(dimension2, "DataItem0"); this.pieDashboardItem3.DataMember = "INVOICES_DET"; this.pieDashboardItem3.DataSource = this.dashboardEFDataSource1; this.pieDashboardItem3.InteractivityOptions.IgnoreMasterFilters = false; this.pieDashboardItem3.Name = "% Recipes Served"; this.pieDashboardItem3.ShowCaption = true; this.pieDashboardItem3.Values.AddRange(new DevExpress.DashboardCommon.Measure[] { measure2 }); // // pivotDashboardItem1 // dimension3.DataMember = "INVOICE.INVOICE_DATE"; dimension4.DataMember = "INVOICE.INVOICE_DATE"; dimension4.DateTimeGroupInterval = DevExpress.DashboardCommon.DateTimeGroupInterval.Month; this.pivotDashboardItem1.Columns.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension3, dimension4 }); this.pivotDashboardItem1.ComponentName = "pivotDashboardItem1"; measure3.DataMember = "PRICE"; measure3.Name = "Sales (Sum)"; dimension5.DataMember = "RECIPE_NAME"; dimension6.DataMember = "INVOICE.CLIENT.NAMES"; this.pivotDashboardItem1.DataItemRepository.Clear(); this.pivotDashboardItem1.DataItemRepository.Add(dimension3, "DataItem0"); this.pivotDashboardItem1.DataItemRepository.Add(measure3, "DataItem1"); this.pivotDashboardItem1.DataItemRepository.Add(dimension4, "DataItem2"); this.pivotDashboardItem1.DataItemRepository.Add(dimension5, "DataItem3"); this.pivotDashboardItem1.DataItemRepository.Add(dimension6, "DataItem4"); this.pivotDashboardItem1.DataMember = "INVOICES_DET"; this.pivotDashboardItem1.DataSource = this.dashboardEFDataSource1; this.pivotDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false; this.pivotDashboardItem1.Name = "Pivot Sales and Clients"; this.pivotDashboardItem1.Rows.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension5, dimension6 }); this.pivotDashboardItem1.ShowCaption = true; this.pivotDashboardItem1.Values.AddRange(new DevExpress.DashboardCommon.Measure[] { measure3 }); // // dateFilterDashboardItem1 // this.dateFilterDashboardItem1.ComponentName = "dateFilterDashboardItem1"; dimension7.DataMember = "INVOICE.INVOICE_DATE"; this.dateFilterDashboardItem1.DataItemRepository.Clear(); this.dateFilterDashboardItem1.DataItemRepository.Add(dimension7, "DataItem0"); this.dateFilterDashboardItem1.DataMember = "INVOICES_DET"; this.dateFilterDashboardItem1.DataSource = this.dashboardEFDataSource1; flowDateTimePeriodLimit1.Offset = 1; dateTimePeriod1.End = flowDateTimePeriodLimit1; dateTimePeriod1.Name = "This Year"; dateTimePeriod1.Start = flowDateTimePeriodLimit2; dateTimePeriod2.End = flowDateTimePeriodLimit3; dateTimePeriod2.Name = "Last Year"; flowDateTimePeriodLimit4.Offset = -1; dateTimePeriod2.Start = flowDateTimePeriodLimit4; dateTimePeriod3.End = flowDateTimePeriodLimit5; dateTimePeriod3.Name = "Last 2 Years"; flowDateTimePeriodLimit6.Offset = -2; dateTimePeriod3.Start = flowDateTimePeriodLimit6; dateTimePeriod4.End = flowDateTimePeriodLimit7; dateTimePeriod4.Name = "Last 3 Years"; flowDateTimePeriodLimit8.Offset = -3; dateTimePeriod4.Start = flowDateTimePeriodLimit8; this.dateFilterDashboardItem1.DateTimePeriods.AddRange(new DevExpress.DashboardCommon.DateTimePeriod[] { dateTimePeriod1, dateTimePeriod2, dateTimePeriod3, dateTimePeriod4 }); this.dateFilterDashboardItem1.DefaultDateTimePeriodName = "This Year"; this.dateFilterDashboardItem1.Dimension = dimension7; this.dateFilterDashboardItem1.IsMasterFilterCrossDataSource = true; this.dateFilterDashboardItem1.Name = "Date Filter"; this.dateFilterDashboardItem1.ShowCaption = true; // // scatterChartDashboardItem1 // dimension8.DataMember = "INVOICE.TABLE.NAME"; this.scatterChartDashboardItem1.Arguments.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension8 }); this.scatterChartDashboardItem1.AxisX.AlwaysShowZeroLevel = false; this.scatterChartDashboardItem1.AxisX.ShowGridLines = true; this.scatterChartDashboardItem1.AxisX.TitleVisible = true; measure4.DataMember = "INVOICE.ID_TABLE"; measure4.Name = "TABLE (Count)"; measure4.SummaryType = DevExpress.DashboardCommon.SummaryType.Count; this.scatterChartDashboardItem1.AxisXMeasure = measure4; this.scatterChartDashboardItem1.AxisY.AlwaysShowZeroLevel = false; this.scatterChartDashboardItem1.AxisY.ShowGridLines = true; this.scatterChartDashboardItem1.AxisY.TitleVisible = true; measure5.DataMember = "INVOICE.INVOICE_DATE"; measure5.SummaryType = DevExpress.DashboardCommon.SummaryType.Count; this.scatterChartDashboardItem1.AxisYMeasure = measure5; this.scatterChartDashboardItem1.ComponentName = "scatterChartDashboardItem1"; measure6.DataMember = "PRICE"; this.scatterChartDashboardItem1.DataItemRepository.Clear(); this.scatterChartDashboardItem1.DataItemRepository.Add(dimension8, "DataItem0"); this.scatterChartDashboardItem1.DataItemRepository.Add(measure6, "DataItem1"); this.scatterChartDashboardItem1.DataItemRepository.Add(measure5, "DataItem2"); this.scatterChartDashboardItem1.DataItemRepository.Add(measure4, "DataItem3"); this.scatterChartDashboardItem1.DataMember = "INVOICES_DET"; this.scatterChartDashboardItem1.DataSource = this.dashboardEFDataSource1; this.scatterChartDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false; this.scatterChartDashboardItem1.Name = "Scatter Chart Sales by Table"; this.scatterChartDashboardItem1.ShowCaption = true; this.scatterChartDashboardItem1.Weight = measure6; // // cardDashboardItem1 // measure7.DataMember = "ID"; measure7.Name = "Recipe (Count)"; measure7.SummaryType = DevExpress.DashboardCommon.SummaryType.Count; cardStretchedLayoutTemplate1.BottomValue1.DimensionIndex = 0; cardStretchedLayoutTemplate1.BottomValue1.ValueType = DevExpress.DashboardCommon.CardRowDataElementType.PercentVariation; cardStretchedLayoutTemplate1.BottomValue1.Visible = true; cardStretchedLayoutTemplate1.BottomValue2.DimensionIndex = 0; cardStretchedLayoutTemplate1.BottomValue2.ValueType = DevExpress.DashboardCommon.CardRowDataElementType.AbsoluteVariation; cardStretchedLayoutTemplate1.BottomValue2.Visible = true; cardStretchedLayoutTemplate1.DeltaIndicator.Visible = true; cardStretchedLayoutTemplate1.MainValue.DimensionIndex = 0; cardStretchedLayoutTemplate1.MainValue.ValueType = DevExpress.DashboardCommon.CardRowDataElementType.Title; cardStretchedLayoutTemplate1.MainValue.Visible = true; cardStretchedLayoutTemplate1.Sparkline.Visible = true; cardStretchedLayoutTemplate1.SubValue.DimensionIndex = 0; cardStretchedLayoutTemplate1.SubValue.ValueType = DevExpress.DashboardCommon.CardRowDataElementType.Subtitle; cardStretchedLayoutTemplate1.SubValue.Visible = true; cardStretchedLayoutTemplate1.TopValue.DimensionIndex = 0; cardStretchedLayoutTemplate1.TopValue.ValueType = DevExpress.DashboardCommon.CardRowDataElementType.ActualValue; cardStretchedLayoutTemplate1.TopValue.Visible = true; card1.LayoutTemplate = cardStretchedLayoutTemplate1; card1.AddDataItem("ActualValue", measure7); this.cardDashboardItem1.Cards.AddRange(new DevExpress.DashboardCommon.Card[] { card1 }); this.cardDashboardItem1.ComponentName = "cardDashboardItem1"; dimension9.DataMember = "RECIPE_NAME"; dimension10.DataMember = "INVOICE.WAITER.NAMES"; this.cardDashboardItem1.DataItemRepository.Clear(); this.cardDashboardItem1.DataItemRepository.Add(dimension9, "DataItem0"); this.cardDashboardItem1.DataItemRepository.Add(measure7, "DataItem1"); this.cardDashboardItem1.DataItemRepository.Add(dimension10, "DataItem2"); this.cardDashboardItem1.DataMember = "INVOICES_DET"; this.cardDashboardItem1.DataSource = this.dashboardEFDataSource1; this.cardDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false; this.cardDashboardItem1.Name = "Top Recipes Sold"; this.cardDashboardItem1.SeriesDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension9, dimension10 }); this.cardDashboardItem1.ShowCaption = true; // // chartDashboardItem1 // dimension11.DataMember = "INVOICE.WAITER.NAMES"; this.chartDashboardItem1.Arguments.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension11 }); this.chartDashboardItem1.AxisX.TitleVisible = false; this.chartDashboardItem1.ComponentName = "chartDashboardItem1"; measure8.DataMember = "PRICE"; measure8.Name = "Sales (Sum)"; this.chartDashboardItem1.DataItemRepository.Clear(); this.chartDashboardItem1.DataItemRepository.Add(dimension11, "DataItem0"); this.chartDashboardItem1.DataItemRepository.Add(measure8, "DataItem1"); this.chartDashboardItem1.DataMember = "INVOICES_DET"; this.chartDashboardItem1.DataSource = this.dashboardEFDataSource1; this.chartDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false; this.chartDashboardItem1.Name = "Sales by Waiter "; chartPane1.Name = "Pane 1"; chartPane1.PrimaryAxisY.AlwaysShowZeroLevel = true; chartPane1.PrimaryAxisY.ShowGridLines = true; chartPane1.PrimaryAxisY.TitleVisible = true; chartPane1.SecondaryAxisY.AlwaysShowZeroLevel = true; chartPane1.SecondaryAxisY.ShowGridLines = false; chartPane1.SecondaryAxisY.TitleVisible = true; simpleSeries1.PlotOnSecondaryAxis = true; simpleSeries1.PointLabelOptions.ContentType = DevExpress.DashboardCommon.PointLabelContentTypeEx.Value; simpleSeries1.PointLabelOptions.Orientation = DevExpress.DashboardCommon.PointLabelOrientation.RotateLeft; simpleSeries1.PointLabelOptions.OverlappingMode = DevExpress.DashboardCommon.PointLabelOverlappingMode.Reposition; simpleSeries1.PointLabelOptions.Position = DevExpress.DashboardCommon.PointLabelPosition.Inside; simpleSeries1.PointLabelOptions.ShowForZeroValues = true; simpleSeries1.AddDataItem("Value", measure8); chartPane1.Series.AddRange(new DevExpress.DashboardCommon.ChartSeries[] { simpleSeries1 }); this.chartDashboardItem1.Panes.AddRange(new DevExpress.DashboardCommon.ChartPane[] { chartPane1 }); this.chartDashboardItem1.ShowCaption = true; // // DashboardMain // this.DataSources.AddRange(new DevExpress.DashboardCommon.IDashboardDataSource[] { this.dashboardEFDataSource1 }); this.Items.AddRange(new DevExpress.DashboardCommon.DashboardItem[] { this.dateFilterDashboardItem1, this.pivotDashboardItem1, this.chartDashboardItem1, this.pieDashboardItem2, this.pieDashboardItem3, this.cardDashboardItem1, this.scatterChartDashboardItem1 }); dashboardLayoutItem1.DashboardItem = this.chartDashboardItem1; dashboardLayoutItem1.Weight = 32.604562737642588D; dashboardLayoutItem2.DashboardItem = this.pieDashboardItem2; dashboardLayoutItem2.Weight = 32.224334600760457D; dashboardLayoutItem3.DashboardItem = this.pieDashboardItem3; dashboardLayoutItem3.Weight = 35.171102661596962D; dashboardLayoutGroup2.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] { dashboardLayoutItem1, dashboardLayoutItem2, dashboardLayoutItem3 }); dashboardLayoutGroup2.DashboardItem = null; dashboardLayoutGroup2.Weight = 29.553679131483715D; dashboardLayoutItem4.DashboardItem = this.cardDashboardItem1; dashboardLayoutItem4.Weight = 52.376425855513311D; dashboardLayoutItem5.DashboardItem = this.scatterChartDashboardItem1; dashboardLayoutItem5.Weight = 47.623574144486689D; dashboardLayoutGroup4.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] { dashboardLayoutItem4, dashboardLayoutItem5 }); dashboardLayoutGroup4.DashboardItem = null; dashboardLayoutGroup4.Weight = 39.897260273972606D; dashboardLayoutItem6.DashboardItem = this.pivotDashboardItem1; dashboardLayoutItem6.Weight = 76.638176638176631D; dashboardLayoutItem7.DashboardItem = this.dateFilterDashboardItem1; dashboardLayoutItem7.Weight = 23.361823361823362D; dashboardLayoutGroup5.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] { dashboardLayoutItem6, dashboardLayoutItem7 }); dashboardLayoutGroup5.DashboardItem = null; dashboardLayoutGroup5.Orientation = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical; dashboardLayoutGroup5.Weight = 60.102739726027394D; dashboardLayoutGroup3.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] { dashboardLayoutGroup4, dashboardLayoutGroup5 }); dashboardLayoutGroup3.DashboardItem = null; dashboardLayoutGroup3.Orientation = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical; dashboardLayoutGroup3.Weight = 70.446320868516281D; dashboardLayoutGroup1.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] { dashboardLayoutGroup2, dashboardLayoutGroup3 }); dashboardLayoutGroup1.DashboardItem = null; dashboardLayoutGroup1.Orientation = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical; dashboardLayoutGroup1.Weight = 100D; this.LayoutRoot = dashboardLayoutGroup1; this.Title.Text = "Dashboard"; ((System.ComponentModel.ISupportInitialize)(this.dashboardEFDataSource1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.pieDashboardItem2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.pieDashboardItem3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension4)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension5)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension6)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.pivotDashboardItem1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension7)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dateFilterDashboardItem1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension8)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure4)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure5)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure6)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.scatterChartDashboardItem1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure7)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension9)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension10)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.cardDashboardItem1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension11)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure8)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { DevExpress.DashboardCommon.Dimension dimension1 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Measure measure1 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.DateTimePeriod dateTimePeriod1 = new DevExpress.DashboardCommon.DateTimePeriod(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit1 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit2 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.DateTimePeriod dateTimePeriod2 = new DevExpress.DashboardCommon.DateTimePeriod(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit3 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit4 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.DateTimePeriod dateTimePeriod3 = new DevExpress.DashboardCommon.DateTimePeriod(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit5 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit6 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.DateTimePeriod dateTimePeriod4 = new DevExpress.DashboardCommon.DateTimePeriod(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit7 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit8 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.DateTimePeriod dateTimePeriod5 = new DevExpress.DashboardCommon.DateTimePeriod(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit9 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit10 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.DateTimePeriod dateTimePeriod6 = new DevExpress.DashboardCommon.DateTimePeriod(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit11 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit12 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.DateTimePeriod dateTimePeriod7 = new DevExpress.DashboardCommon.DateTimePeriod(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit13 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit14 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.SimpleSeries simpleSeries1 = new DevExpress.DashboardCommon.SimpleSeries(); DevExpress.DataAccess.ConnectionParameters.MsSqlConnectionParameters msSqlConnectionParameters1 = new DevExpress.DataAccess.ConnectionParameters.MsSqlConnectionParameters(); DevExpress.DataAccess.Sql.SelectQuery selectQuery1 = new DevExpress.DataAccess.Sql.SelectQuery(); DevExpress.DataAccess.Sql.Column column1 = new DevExpress.DataAccess.Sql.Column(); DevExpress.DataAccess.Sql.ColumnExpression columnExpression1 = new DevExpress.DataAccess.Sql.ColumnExpression(); DevExpress.DataAccess.Sql.Table table1 = new DevExpress.DataAccess.Sql.Table(); DevExpress.DataAccess.Sql.Column column2 = new DevExpress.DataAccess.Sql.Column(); DevExpress.DataAccess.Sql.ColumnExpression columnExpression2 = new DevExpress.DataAccess.Sql.ColumnExpression(); DevExpress.DataAccess.Sql.Table table2 = new DevExpress.DataAccess.Sql.Table(); DevExpress.DataAccess.Sql.Column column3 = new DevExpress.DataAccess.Sql.Column(); DevExpress.DataAccess.Sql.ColumnExpression columnExpression3 = new DevExpress.DataAccess.Sql.ColumnExpression(); DevExpress.DataAccess.Sql.Column column4 = new DevExpress.DataAccess.Sql.Column(); DevExpress.DataAccess.Sql.ColumnExpression columnExpression4 = new DevExpress.DataAccess.Sql.ColumnExpression(); DevExpress.DataAccess.Sql.Column column5 = new DevExpress.DataAccess.Sql.Column(); DevExpress.DataAccess.Sql.ColumnExpression columnExpression5 = new DevExpress.DataAccess.Sql.ColumnExpression(); DevExpress.DataAccess.Sql.Column column6 = new DevExpress.DataAccess.Sql.Column(); DevExpress.DataAccess.Sql.ColumnExpression columnExpression6 = new DevExpress.DataAccess.Sql.ColumnExpression(); DevExpress.DataAccess.Sql.Column column7 = new DevExpress.DataAccess.Sql.Column(); DevExpress.DataAccess.Sql.ColumnExpression columnExpression7 = new DevExpress.DataAccess.Sql.ColumnExpression(); DevExpress.DataAccess.Sql.Column column8 = new DevExpress.DataAccess.Sql.Column(); DevExpress.DataAccess.Sql.ColumnExpression columnExpression8 = new DevExpress.DataAccess.Sql.ColumnExpression(); DevExpress.DataAccess.Sql.Table table3 = new DevExpress.DataAccess.Sql.Table(); DevExpress.DataAccess.Sql.Column column9 = new DevExpress.DataAccess.Sql.Column(); DevExpress.DataAccess.Sql.ColumnExpression columnExpression9 = new DevExpress.DataAccess.Sql.ColumnExpression(); DevExpress.DataAccess.Sql.Column column10 = new DevExpress.DataAccess.Sql.Column(); DevExpress.DataAccess.Sql.ColumnExpression columnExpression10 = new DevExpress.DataAccess.Sql.ColumnExpression(); DevExpress.DataAccess.Sql.Join join1 = new DevExpress.DataAccess.Sql.Join(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo1 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.Join join2 = new DevExpress.DataAccess.Sql.Join(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo2 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Report_TienConLaiCC)); DevExpress.DashboardCommon.Dimension dimension2 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn1 = new DevExpress.DashboardCommon.GridDimensionColumn(); DevExpress.DashboardCommon.GridColumnTotal gridColumnTotal1 = new DevExpress.DashboardCommon.GridColumnTotal(); DevExpress.DashboardCommon.Dimension dimension3 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn2 = new DevExpress.DashboardCommon.GridDimensionColumn(); DevExpress.DashboardCommon.Measure measure2 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.GridMeasureColumn gridMeasureColumn1 = new DevExpress.DashboardCommon.GridMeasureColumn(); DevExpress.DashboardCommon.GridItemFormatRule gridItemFormatRule1 = new DevExpress.DashboardCommon.GridItemFormatRule(); DevExpress.DashboardCommon.FormatConditionRangeSet formatConditionRangeSet1 = new DevExpress.DashboardCommon.FormatConditionRangeSet(); DevExpress.DashboardCommon.RangeInfo rangeInfo1 = new DevExpress.DashboardCommon.RangeInfo(); DevExpress.DashboardCommon.IconSettings iconSettings1 = new DevExpress.DashboardCommon.IconSettings(); DevExpress.DashboardCommon.RangeInfo rangeInfo2 = new DevExpress.DashboardCommon.RangeInfo(); DevExpress.DashboardCommon.IconSettings iconSettings2 = new DevExpress.DashboardCommon.IconSettings(); DevExpress.DashboardCommon.RangeInfo rangeInfo3 = new DevExpress.DashboardCommon.RangeInfo(); DevExpress.DashboardCommon.IconSettings iconSettings3 = new DevExpress.DashboardCommon.IconSettings(); DevExpress.DashboardCommon.RangeInfo rangeInfo4 = new DevExpress.DashboardCommon.RangeInfo(); DevExpress.DashboardCommon.IconSettings iconSettings4 = new DevExpress.DashboardCommon.IconSettings(); DevExpress.DashboardCommon.Dimension dimension4 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn3 = new DevExpress.DashboardCommon.GridDimensionColumn(); DevExpress.DashboardCommon.GridColumnTotal gridColumnTotal2 = new DevExpress.DashboardCommon.GridColumnTotal(); DevExpress.DashboardCommon.Dimension dimension5 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn4 = new DevExpress.DashboardCommon.GridDimensionColumn(); DevExpress.DashboardCommon.Measure measure3 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.GridMeasureColumn gridMeasureColumn2 = new DevExpress.DashboardCommon.GridMeasureColumn(); DevExpress.DashboardCommon.GridItemFormatRule gridItemFormatRule2 = new DevExpress.DashboardCommon.GridItemFormatRule(); DevExpress.DashboardCommon.FormatConditionRangeSet formatConditionRangeSet2 = new DevExpress.DashboardCommon.FormatConditionRangeSet(); DevExpress.DashboardCommon.RangeInfo rangeInfo5 = new DevExpress.DashboardCommon.RangeInfo(); DevExpress.DashboardCommon.IconSettings iconSettings5 = new DevExpress.DashboardCommon.IconSettings(); DevExpress.DashboardCommon.RangeInfo rangeInfo6 = new DevExpress.DashboardCommon.RangeInfo(); DevExpress.DashboardCommon.IconSettings iconSettings6 = new DevExpress.DashboardCommon.IconSettings(); DevExpress.DashboardCommon.RangeInfo rangeInfo7 = new DevExpress.DashboardCommon.RangeInfo(); DevExpress.DashboardCommon.IconSettings iconSettings7 = new DevExpress.DashboardCommon.IconSettings(); DevExpress.DashboardCommon.Dimension dimension6 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn5 = new DevExpress.DashboardCommon.GridDimensionColumn(); DevExpress.DashboardCommon.Measure measure4 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.GridMeasureColumn gridMeasureColumn3 = new DevExpress.DashboardCommon.GridMeasureColumn(); DevExpress.DashboardCommon.GridItemFormatRule gridItemFormatRule3 = new DevExpress.DashboardCommon.GridItemFormatRule(); DevExpress.DashboardCommon.FormatConditionRangeSet formatConditionRangeSet3 = new DevExpress.DashboardCommon.FormatConditionRangeSet(); DevExpress.DashboardCommon.RangeInfo rangeInfo8 = new DevExpress.DashboardCommon.RangeInfo(); DevExpress.DashboardCommon.IconSettings iconSettings8 = new DevExpress.DashboardCommon.IconSettings(); DevExpress.DashboardCommon.RangeInfo rangeInfo9 = new DevExpress.DashboardCommon.RangeInfo(); DevExpress.DashboardCommon.IconSettings iconSettings9 = new DevExpress.DashboardCommon.IconSettings(); DevExpress.DashboardCommon.RangeInfo rangeInfo10 = new DevExpress.DashboardCommon.RangeInfo(); DevExpress.DashboardCommon.IconSettings iconSettings10 = new DevExpress.DashboardCommon.IconSettings(); DevExpress.DashboardCommon.RangeInfo rangeInfo11 = new DevExpress.DashboardCommon.RangeInfo(); DevExpress.DashboardCommon.IconSettings iconSettings11 = new DevExpress.DashboardCommon.IconSettings(); DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup1 = new DevExpress.DashboardCommon.DashboardLayoutGroup(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem1 = new DevExpress.DashboardCommon.DashboardLayoutItem(); DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup2 = new DevExpress.DashboardCommon.DashboardLayoutGroup(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem2 = new DevExpress.DashboardCommon.DashboardLayoutItem(); DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup3 = new DevExpress.DashboardCommon.DashboardLayoutGroup(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem3 = new DevExpress.DashboardCommon.DashboardLayoutItem(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem4 = new DevExpress.DashboardCommon.DashboardLayoutItem(); this.rangeFilterDashboardItem1 = new DevExpress.DashboardCommon.RangeFilterDashboardItem(); this.dashboardSqlDataSource1 = new DevExpress.DashboardCommon.DashboardSqlDataSource(); this.gridDashboardItem1 = new DevExpress.DashboardCommon.GridDashboardItem(); this.gridDashboardItem2 = new DevExpress.DashboardCommon.GridDashboardItem(); this.gridDashboardItem3 = new DevExpress.DashboardCommon.GridDashboardItem(); ((System.ComponentModel.ISupportInitialize)(this.rangeFilterDashboardItem1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension4)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension5)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension6)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure4)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // rangeFilterDashboardItem1 // dimension1.DataMember = "ngaytaodt"; dimension1.DateTimeFormat.ExactDateFormat = DevExpress.DashboardCommon.ExactDateFormat.Month; dimension1.DateTimeGroupInterval = DevExpress.DashboardCommon.DateTimeGroupInterval.DayMonthYear; measure1.DataMember = "tienconlaitheoca"; dimension1.TopNOptions.Measure = measure1; this.rangeFilterDashboardItem1.Argument = dimension1; this.rangeFilterDashboardItem1.ComponentName = "rangeFilterDashboardItem1"; this.rangeFilterDashboardItem1.DataItemRepository.Clear(); this.rangeFilterDashboardItem1.DataItemRepository.Add(dimension1, "DataItem2"); this.rangeFilterDashboardItem1.DataItemRepository.Add(measure1, "DataItem0"); this.rangeFilterDashboardItem1.DataMember = "DoanhThu"; this.rangeFilterDashboardItem1.DataSource = this.dashboardSqlDataSource1; flowDateTimePeriodLimit1.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month; flowDateTimePeriodLimit1.Offset = 1; dateTimePeriod1.End = flowDateTimePeriodLimit1; dateTimePeriod1.Name = "This Month"; flowDateTimePeriodLimit2.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month; dateTimePeriod1.Start = flowDateTimePeriodLimit2; flowDateTimePeriodLimit3.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month; dateTimePeriod2.End = flowDateTimePeriodLimit3; dateTimePeriod2.Name = "Last Month"; flowDateTimePeriodLimit4.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month; flowDateTimePeriodLimit4.Offset = -1; dateTimePeriod2.Start = flowDateTimePeriodLimit4; flowDateTimePeriodLimit5.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month; dateTimePeriod3.End = flowDateTimePeriodLimit5; dateTimePeriod3.Name = "Last 3 Months"; flowDateTimePeriodLimit6.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month; flowDateTimePeriodLimit6.Offset = -3; dateTimePeriod3.Start = flowDateTimePeriodLimit6; flowDateTimePeriodLimit7.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month; dateTimePeriod4.End = flowDateTimePeriodLimit7; dateTimePeriod4.Name = "Last 6 Months"; flowDateTimePeriodLimit8.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month; flowDateTimePeriodLimit8.Offset = -6; dateTimePeriod4.Start = flowDateTimePeriodLimit8; flowDateTimePeriodLimit9.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month; dateTimePeriod5.End = flowDateTimePeriodLimit9; dateTimePeriod5.Name = "Last 12 Months"; flowDateTimePeriodLimit10.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month; flowDateTimePeriodLimit10.Offset = -12; dateTimePeriod5.Start = flowDateTimePeriodLimit10; dateTimePeriod6.End = flowDateTimePeriodLimit11; dateTimePeriod6.Name = "Last Year"; flowDateTimePeriodLimit12.Offset = -1; dateTimePeriod6.Start = flowDateTimePeriodLimit12; dateTimePeriod7.End = flowDateTimePeriodLimit13; dateTimePeriod7.Name = "Last 2 Years"; flowDateTimePeriodLimit14.Offset = -2; dateTimePeriod7.Start = flowDateTimePeriodLimit14; this.rangeFilterDashboardItem1.DateTimePeriods.AddRange(new DevExpress.DashboardCommon.DateTimePeriod[] { dateTimePeriod1, dateTimePeriod2, dateTimePeriod3, dateTimePeriod4, dateTimePeriod5, dateTimePeriod6, dateTimePeriod7 }); this.rangeFilterDashboardItem1.DefaultDateTimePeriodName = "This Month"; this.rangeFilterDashboardItem1.InteractivityOptions.IgnoreMasterFilters = true; this.rangeFilterDashboardItem1.Name = "Filter theo tháng năm"; simpleSeries1.SeriesType = DevExpress.DashboardCommon.SimpleSeriesType.StackedBar; simpleSeries1.AddDataItem("Value", measure1); this.rangeFilterDashboardItem1.Series.AddRange(new DevExpress.DashboardCommon.SimpleSeries[] { simpleSeries1 }); this.rangeFilterDashboardItem1.ShowCaption = true; // // dashboardSqlDataSource1 // this.dashboardSqlDataSource1.ComponentName = "dashboardSqlDataSource1"; this.dashboardSqlDataSource1.ConnectionName = "localhost_BaoCaoThuChi_Connection"; msSqlConnectionParameters1.AuthorizationType = DevExpress.DataAccess.ConnectionParameters.MsSqlAuthorizationType.Windows; msSqlConnectionParameters1.DatabaseName = "BaoCaoThuChi"; msSqlConnectionParameters1.ServerName = "."; this.dashboardSqlDataSource1.ConnectionParameters = msSqlConnectionParameters1; this.dashboardSqlDataSource1.Name = "SQL Data Source 1"; columnExpression1.ColumnName = "ngaytaodt"; table1.MetaSerializable = "<Meta X=\"30\" Y=\"30\" Width=\"125\" Height=\"110\" />"; table1.Name = "DoanhThu"; columnExpression1.Table = table1; column1.Expression = columnExpression1; columnExpression2.ColumnName = "caID"; table2.MetaSerializable = "<Meta X=\"185\" Y=\"30\" Width=\"125\" Height=\"194\" />"; table2.Name = "DoanhThuTheoCa"; columnExpression2.Table = table2; column2.Expression = columnExpression2; columnExpression3.ColumnName = "tenCa"; columnExpression3.Table = table2; column3.Expression = columnExpression3; columnExpression4.ColumnName = "tiendelai"; columnExpression4.Table = table2; column4.Expression = columnExpression4; columnExpression5.ColumnName = "doanhthutheoca"; columnExpression5.Table = table2; column5.Expression = columnExpression5; columnExpression6.ColumnName = "doanhthukhac"; columnExpression6.Table = table2; column6.Expression = columnExpression6; columnExpression7.ColumnName = "doanhthuID"; columnExpression7.Table = table1; column7.Expression = columnExpression7; columnExpression8.ColumnName = "tienconlaitheoca"; table3.MetaSerializable = "<Meta X=\"340\" Y=\"30\" Width=\"125\" Height=\"131\" />"; table3.Name = "TienConLaiTheoCa"; columnExpression8.Table = table3; column8.Expression = columnExpression8; column9.Alias = "TienConLaiTheoCa_caID"; columnExpression9.ColumnName = "caID"; columnExpression9.Table = table3; column9.Expression = columnExpression9; columnExpression10.ColumnName = "tlID"; columnExpression10.Table = table3; column10.Expression = columnExpression10; selectQuery1.Columns.Add(column1); selectQuery1.Columns.Add(column2); selectQuery1.Columns.Add(column3); selectQuery1.Columns.Add(column4); selectQuery1.Columns.Add(column5); selectQuery1.Columns.Add(column6); selectQuery1.Columns.Add(column7); selectQuery1.Columns.Add(column8); selectQuery1.Columns.Add(column9); selectQuery1.Columns.Add(column10); selectQuery1.Name = "DoanhThu"; relationColumnInfo1.NestedKeyColumn = "doanhthuID"; relationColumnInfo1.ParentKeyColumn = "doanhthuID"; join1.KeyColumns.Add(relationColumnInfo1); join1.Nested = table2; join1.Parent = table1; relationColumnInfo2.NestedKeyColumn = "caID"; relationColumnInfo2.ParentKeyColumn = "caID"; join2.KeyColumns.Add(relationColumnInfo2); join2.Nested = table3; join2.Parent = table2; selectQuery1.Relations.Add(join1); selectQuery1.Relations.Add(join2); selectQuery1.Tables.Add(table1); selectQuery1.Tables.Add(table2); selectQuery1.Tables.Add(table3); this.dashboardSqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { selectQuery1 }); this.dashboardSqlDataSource1.ResultSchemaSerializable = resources.GetString("dashboardSqlDataSource1.ResultSchemaSerializable"); // // gridDashboardItem1 // dimension2.DataMember = "ngaytaodt"; dimension2.DateTimeGroupInterval = DevExpress.DashboardCommon.DateTimeGroupInterval.DayMonthYear; dimension2.SortOrder = DevExpress.DashboardCommon.DimensionSortOrder.Descending; gridDimensionColumn1.Name = "Ngày"; gridDimensionColumn1.Totals.AddRange(new DevExpress.DashboardCommon.GridColumnTotal[] { gridColumnTotal1 }); gridDimensionColumn1.Weight = 51.772793053545584D; gridDimensionColumn1.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight; gridDimensionColumn1.AddDataItem("Dimension", dimension2); dimension3.DataMember = "tenCa"; gridDimensionColumn2.Name = "Tên Ca"; gridDimensionColumn2.Weight = 59.261939218523878D; gridDimensionColumn2.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight; gridDimensionColumn2.AddDataItem("Dimension", dimension3); measure2.DataMember = "tienconlaitheoca"; measure2.NumericFormat.CurrencyCultureName = "vi-VN"; measure2.NumericFormat.FormatType = DevExpress.DashboardCommon.DataItemNumericFormatType.Currency; gridMeasureColumn1.Name = "Số Tiền Cuối Ca"; gridMeasureColumn1.Weight = 113.96526772793054D; gridMeasureColumn1.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight; gridMeasureColumn1.AddDataItem("Measure", measure2); this.gridDashboardItem1.Columns.AddRange(new DevExpress.DashboardCommon.GridColumnBase[] { gridDimensionColumn1, gridDimensionColumn2, gridMeasureColumn1 }); this.gridDashboardItem1.ComponentName = "gridDashboardItem1"; this.gridDashboardItem1.DataItemRepository.Clear(); this.gridDashboardItem1.DataItemRepository.Add(dimension3, "DataItem1"); this.gridDashboardItem1.DataItemRepository.Add(measure2, "DataItem2"); this.gridDashboardItem1.DataItemRepository.Add(dimension2, "DataItem0"); this.gridDashboardItem1.DataMember = "DoanhThu"; this.gridDashboardItem1.DataSource = this.dashboardSqlDataSource1; iconSettings1.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalRedDownArrow; rangeInfo1.StyleSettings = iconSettings1; rangeInfo1.Value = 0D; iconSettings2.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalYellowDownInclineArrow; rangeInfo2.StyleSettings = iconSettings2; rangeInfo2.Value = 25D; iconSettings3.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalYellowUpInclineArrow; rangeInfo3.StyleSettings = iconSettings3; rangeInfo3.Value = 50D; iconSettings4.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalGreenArrowUp; rangeInfo4.StyleSettings = iconSettings4; rangeInfo4.Value = 75D; formatConditionRangeSet1.RangeSet.AddRange(new DevExpress.DashboardCommon.RangeInfo[] { rangeInfo1, rangeInfo2, rangeInfo3, rangeInfo4 }); formatConditionRangeSet1.ValueType = DevExpress.DashboardCommon.DashboardFormatConditionValueType.Percent; gridItemFormatRule1.Condition = formatConditionRangeSet1; gridItemFormatRule1.DataItem = measure2; gridItemFormatRule1.Name = "FormatRule 1"; this.gridDashboardItem1.FormatRules.AddRange(new DevExpress.DashboardCommon.GridItemFormatRule[] { gridItemFormatRule1 }); this.gridDashboardItem1.GridOptions.ColumnWidthMode = DevExpress.DashboardCommon.GridColumnWidthMode.Manual; this.gridDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false; this.gridDashboardItem1.Name = "Chi tiết theo ngày"; this.gridDashboardItem1.ShowCaption = true; // // gridDashboardItem2 // dimension4.DataMember = "ngaytaodt"; dimension4.DateTimeGroupInterval = DevExpress.DashboardCommon.DateTimeGroupInterval.MonthYear; gridDimensionColumn3.Name = "Tháng Năm"; gridDimensionColumn3.Totals.AddRange(new DevExpress.DashboardCommon.GridColumnTotal[] { gridColumnTotal2 }); gridDimensionColumn3.Weight = 60.910404624277454D; gridDimensionColumn3.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight; gridDimensionColumn3.AddDataItem("Dimension", dimension4); dimension5.DataMember = "tenCa"; gridDimensionColumn4.Name = "Tên Ca"; gridDimensionColumn4.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight; gridDimensionColumn4.AddDataItem("Dimension", dimension5); measure3.DataMember = "tienconlaitheoca"; measure3.NumericFormat.CurrencyCultureName = "vi-VN"; measure3.NumericFormat.FormatType = DevExpress.DashboardCommon.DataItemNumericFormatType.Currency; gridMeasureColumn2.Name = "Tổng"; gridMeasureColumn2.Weight = 89.089595375722539D; gridMeasureColumn2.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight; gridMeasureColumn2.AddDataItem("Measure", measure3); this.gridDashboardItem2.Columns.AddRange(new DevExpress.DashboardCommon.GridColumnBase[] { gridDimensionColumn3, gridDimensionColumn4, gridMeasureColumn2 }); this.gridDashboardItem2.ComponentName = "gridDashboardItem2"; this.gridDashboardItem2.DataItemRepository.Clear(); this.gridDashboardItem2.DataItemRepository.Add(dimension4, "DataItem0"); this.gridDashboardItem2.DataItemRepository.Add(measure3, "DataItem1"); this.gridDashboardItem2.DataItemRepository.Add(dimension5, "DataItem2"); this.gridDashboardItem2.DataMember = "DoanhThu"; this.gridDashboardItem2.DataSource = this.dashboardSqlDataSource1; iconSettings5.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalRedDownArrow; rangeInfo5.StyleSettings = iconSettings5; rangeInfo5.Value = 0D; iconSettings6.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalYellowSideArrow; rangeInfo6.StyleSettings = iconSettings6; rangeInfo6.Value = 33D; iconSettings7.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalGreenArrowUp; rangeInfo7.StyleSettings = iconSettings7; rangeInfo7.Value = 67D; formatConditionRangeSet2.RangeSet.AddRange(new DevExpress.DashboardCommon.RangeInfo[] { rangeInfo5, rangeInfo6, rangeInfo7 }); formatConditionRangeSet2.ValueType = DevExpress.DashboardCommon.DashboardFormatConditionValueType.Percent; gridItemFormatRule2.Condition = formatConditionRangeSet2; gridItemFormatRule2.DataItem = measure3; gridItemFormatRule2.Name = "FormatRule 1"; this.gridDashboardItem2.FormatRules.AddRange(new DevExpress.DashboardCommon.GridItemFormatRule[] { gridItemFormatRule2 }); this.gridDashboardItem2.GridOptions.ColumnWidthMode = DevExpress.DashboardCommon.GridColumnWidthMode.Manual; this.gridDashboardItem2.InteractivityOptions.IgnoreMasterFilters = false; this.gridDashboardItem2.Name = "Tổng theo tháng"; this.gridDashboardItem2.ShowCaption = true; // // gridDashboardItem3 // dimension6.DataMember = "ngaytaodt"; gridDimensionColumn5.Name = "Năm"; gridDimensionColumn5.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight; gridDimensionColumn5.AddDataItem("Dimension", dimension6); measure4.DataMember = "tienconlaitheoca"; measure4.NumericFormat.CurrencyCultureName = "vi-VN"; measure4.NumericFormat.FormatType = DevExpress.DashboardCommon.DataItemNumericFormatType.Currency; gridMeasureColumn3.Name = "Tổng"; gridMeasureColumn3.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight; gridMeasureColumn3.AddDataItem("Measure", measure4); this.gridDashboardItem3.Columns.AddRange(new DevExpress.DashboardCommon.GridColumnBase[] { gridDimensionColumn5, gridMeasureColumn3 }); this.gridDashboardItem3.ComponentName = "gridDashboardItem3"; this.gridDashboardItem3.DataItemRepository.Clear(); this.gridDashboardItem3.DataItemRepository.Add(dimension6, "DataItem0"); this.gridDashboardItem3.DataItemRepository.Add(measure4, "DataItem1"); this.gridDashboardItem3.DataMember = "DoanhThu"; this.gridDashboardItem3.DataSource = this.dashboardSqlDataSource1; iconSettings8.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalRedDownArrow; rangeInfo8.StyleSettings = iconSettings8; rangeInfo8.Value = 0D; iconSettings9.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalYellowDownInclineArrow; rangeInfo9.StyleSettings = iconSettings9; rangeInfo9.Value = 25D; iconSettings10.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalYellowUpInclineArrow; rangeInfo10.StyleSettings = iconSettings10; rangeInfo10.Value = 50D; iconSettings11.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalGreenArrowUp; rangeInfo11.StyleSettings = iconSettings11; rangeInfo11.Value = 75D; formatConditionRangeSet3.RangeSet.AddRange(new DevExpress.DashboardCommon.RangeInfo[] { rangeInfo8, rangeInfo9, rangeInfo10, rangeInfo11 }); formatConditionRangeSet3.ValueType = DevExpress.DashboardCommon.DashboardFormatConditionValueType.Percent; gridItemFormatRule3.Condition = formatConditionRangeSet3; gridItemFormatRule3.DataItem = measure4; gridItemFormatRule3.Name = "FormatRule 1"; this.gridDashboardItem3.FormatRules.AddRange(new DevExpress.DashboardCommon.GridItemFormatRule[] { gridItemFormatRule3 }); this.gridDashboardItem3.InteractivityOptions.IgnoreMasterFilters = false; this.gridDashboardItem3.Name = "Tổng theo Năm"; this.gridDashboardItem3.ShowCaption = true; // // Report_TienConLaiCC // this.DataSources.AddRange(new DevExpress.DashboardCommon.IDashboardDataSource[] { this.dashboardSqlDataSource1 }); this.Items.AddRange(new DevExpress.DashboardCommon.DashboardItem[] { this.gridDashboardItem1, this.rangeFilterDashboardItem1, this.gridDashboardItem2, this.gridDashboardItem3 }); dashboardLayoutItem1.DashboardItem = this.rangeFilterDashboardItem1; dashboardLayoutItem1.Weight = 29.154929577464788D; dashboardLayoutItem2.DashboardItem = this.gridDashboardItem1; dashboardLayoutItem2.Weight = 59.3727726300784D; dashboardLayoutItem3.DashboardItem = this.gridDashboardItem2; dashboardLayoutItem3.Weight = 50.099403578528829D; dashboardLayoutItem4.DashboardItem = this.gridDashboardItem3; dashboardLayoutItem4.Weight = 49.900596421471171D; dashboardLayoutGroup3.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] { dashboardLayoutItem3, dashboardLayoutItem4 }); dashboardLayoutGroup3.DashboardItem = null; dashboardLayoutGroup3.Orientation = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical; dashboardLayoutGroup3.Weight = 40.6272273699216D; dashboardLayoutGroup2.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] { dashboardLayoutItem2, dashboardLayoutGroup3 }); dashboardLayoutGroup2.DashboardItem = null; dashboardLayoutGroup2.Weight = 70.845070422535215D; dashboardLayoutGroup1.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] { dashboardLayoutItem1, dashboardLayoutGroup2 }); dashboardLayoutGroup1.DashboardItem = null; dashboardLayoutGroup1.Orientation = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical; dashboardLayoutGroup1.Weight = 100D; this.LayoutRoot = dashboardLayoutGroup1; this.Title.Text = "Báo Cáo Tiền Còn Lại Cuối Ca"; ((System.ComponentModel.ISupportInitialize)(measure1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.rangeFilterDashboardItem1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension4)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension5)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension6)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure4)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { DevExpress.DashboardCommon.Dimension dimension1 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Measure measure1 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.Measure measure2 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.DateTimePeriod dateTimePeriod1 = new DevExpress.DashboardCommon.DateTimePeriod(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit1 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit2 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.DateTimePeriod dateTimePeriod2 = new DevExpress.DashboardCommon.DateTimePeriod(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit3 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit4 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.DateTimePeriod dateTimePeriod3 = new DevExpress.DashboardCommon.DateTimePeriod(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit5 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit6 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.DateTimePeriod dateTimePeriod4 = new DevExpress.DashboardCommon.DateTimePeriod(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit7 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit8 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.DateTimePeriod dateTimePeriod5 = new DevExpress.DashboardCommon.DateTimePeriod(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit9 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit10 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.DateTimePeriod dateTimePeriod6 = new DevExpress.DashboardCommon.DateTimePeriod(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit11 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit12 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.DateTimePeriod dateTimePeriod7 = new DevExpress.DashboardCommon.DateTimePeriod(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit13 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit14 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.SimpleSeries simpleSeries1 = new DevExpress.DashboardCommon.SimpleSeries(); DevExpress.DashboardCommon.SimpleSeries simpleSeries2 = new DevExpress.DashboardCommon.SimpleSeries(); DevExpress.DashboardCommon.CalculatedField calculatedField1 = new DevExpress.DashboardCommon.CalculatedField(); DevExpress.DataAccess.ConnectionParameters.MsSqlConnectionParameters msSqlConnectionParameters1 = new DevExpress.DataAccess.ConnectionParameters.MsSqlConnectionParameters(); DevExpress.DataAccess.Sql.SelectQuery selectQuery1 = new DevExpress.DataAccess.Sql.SelectQuery(); DevExpress.DataAccess.Sql.Column column1 = new DevExpress.DataAccess.Sql.Column(); DevExpress.DataAccess.Sql.ColumnExpression columnExpression1 = new DevExpress.DataAccess.Sql.ColumnExpression(); DevExpress.DataAccess.Sql.Table table1 = new DevExpress.DataAccess.Sql.Table(); DevExpress.DataAccess.Sql.Column column2 = new DevExpress.DataAccess.Sql.Column(); DevExpress.DataAccess.Sql.ColumnExpression columnExpression2 = new DevExpress.DataAccess.Sql.ColumnExpression(); DevExpress.DataAccess.Sql.Table table2 = new DevExpress.DataAccess.Sql.Table(); DevExpress.DataAccess.Sql.Column column3 = new DevExpress.DataAccess.Sql.Column(); DevExpress.DataAccess.Sql.ColumnExpression columnExpression3 = new DevExpress.DataAccess.Sql.ColumnExpression(); DevExpress.DataAccess.Sql.Column column4 = new DevExpress.DataAccess.Sql.Column(); DevExpress.DataAccess.Sql.ColumnExpression columnExpression4 = new DevExpress.DataAccess.Sql.ColumnExpression(); DevExpress.DataAccess.Sql.Column column5 = new DevExpress.DataAccess.Sql.Column(); DevExpress.DataAccess.Sql.ColumnExpression columnExpression5 = new DevExpress.DataAccess.Sql.ColumnExpression(); DevExpress.DataAccess.Sql.Column column6 = new DevExpress.DataAccess.Sql.Column(); DevExpress.DataAccess.Sql.ColumnExpression columnExpression6 = new DevExpress.DataAccess.Sql.ColumnExpression(); DevExpress.DataAccess.Sql.Column column7 = new DevExpress.DataAccess.Sql.Column(); DevExpress.DataAccess.Sql.ColumnExpression columnExpression7 = new DevExpress.DataAccess.Sql.ColumnExpression(); DevExpress.DataAccess.Sql.Column column8 = new DevExpress.DataAccess.Sql.Column(); DevExpress.DataAccess.Sql.ColumnExpression columnExpression8 = new DevExpress.DataAccess.Sql.ColumnExpression(); DevExpress.DataAccess.Sql.AllColumns allColumns1 = new DevExpress.DataAccess.Sql.AllColumns(); DevExpress.DataAccess.Sql.AllColumns allColumns2 = new DevExpress.DataAccess.Sql.AllColumns(); DevExpress.DataAccess.Sql.Join join1 = new DevExpress.DataAccess.Sql.Join(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo1 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Report_DTBanHang)); DevExpress.DashboardCommon.Dimension dimension2 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn1 = new DevExpress.DashboardCommon.GridDimensionColumn(); DevExpress.DashboardCommon.GridColumnTotal gridColumnTotal1 = new DevExpress.DashboardCommon.GridColumnTotal(); DevExpress.DashboardCommon.Dimension dimension3 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn2 = new DevExpress.DashboardCommon.GridDimensionColumn(); DevExpress.DashboardCommon.Measure measure3 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.GridMeasureColumn gridMeasureColumn1 = new DevExpress.DashboardCommon.GridMeasureColumn(); DevExpress.DashboardCommon.GridColumnTotal gridColumnTotal2 = new DevExpress.DashboardCommon.GridColumnTotal(); DevExpress.DashboardCommon.GridItemFormatRule gridItemFormatRule1 = new DevExpress.DashboardCommon.GridItemFormatRule(); DevExpress.DashboardCommon.FormatConditionRangeSet formatConditionRangeSet1 = new DevExpress.DashboardCommon.FormatConditionRangeSet(); DevExpress.DashboardCommon.RangeInfo rangeInfo1 = new DevExpress.DashboardCommon.RangeInfo(); DevExpress.DashboardCommon.IconSettings iconSettings1 = new DevExpress.DashboardCommon.IconSettings(); DevExpress.DashboardCommon.RangeInfo rangeInfo2 = new DevExpress.DashboardCommon.RangeInfo(); DevExpress.DashboardCommon.IconSettings iconSettings2 = new DevExpress.DashboardCommon.IconSettings(); DevExpress.DashboardCommon.RangeInfo rangeInfo3 = new DevExpress.DashboardCommon.RangeInfo(); DevExpress.DashboardCommon.IconSettings iconSettings3 = new DevExpress.DashboardCommon.IconSettings(); DevExpress.DashboardCommon.RangeInfo rangeInfo4 = new DevExpress.DashboardCommon.RangeInfo(); DevExpress.DashboardCommon.IconSettings iconSettings4 = new DevExpress.DashboardCommon.IconSettings(); DevExpress.DashboardCommon.Dimension dimension4 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn3 = new DevExpress.DashboardCommon.GridDimensionColumn(); DevExpress.DashboardCommon.GridColumnTotal gridColumnTotal3 = new DevExpress.DashboardCommon.GridColumnTotal(); DevExpress.DashboardCommon.Measure measure4 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.GridMeasureColumn gridMeasureColumn2 = new DevExpress.DashboardCommon.GridMeasureColumn(); DevExpress.DashboardCommon.GridItemFormatRule gridItemFormatRule2 = new DevExpress.DashboardCommon.GridItemFormatRule(); DevExpress.DashboardCommon.FormatConditionRangeSet formatConditionRangeSet2 = new DevExpress.DashboardCommon.FormatConditionRangeSet(); DevExpress.DashboardCommon.RangeInfo rangeInfo5 = new DevExpress.DashboardCommon.RangeInfo(); DevExpress.DashboardCommon.IconSettings iconSettings5 = new DevExpress.DashboardCommon.IconSettings(); DevExpress.DashboardCommon.RangeInfo rangeInfo6 = new DevExpress.DashboardCommon.RangeInfo(); DevExpress.DashboardCommon.IconSettings iconSettings6 = new DevExpress.DashboardCommon.IconSettings(); DevExpress.DashboardCommon.RangeInfo rangeInfo7 = new DevExpress.DashboardCommon.RangeInfo(); DevExpress.DashboardCommon.IconSettings iconSettings7 = new DevExpress.DashboardCommon.IconSettings(); DevExpress.DashboardCommon.RangeInfo rangeInfo8 = new DevExpress.DashboardCommon.RangeInfo(); DevExpress.DashboardCommon.IconSettings iconSettings8 = new DevExpress.DashboardCommon.IconSettings(); DevExpress.DashboardCommon.Dimension dimension5 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn4 = new DevExpress.DashboardCommon.GridDimensionColumn(); DevExpress.DashboardCommon.Measure measure5 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.GridMeasureColumn gridMeasureColumn3 = new DevExpress.DashboardCommon.GridMeasureColumn(); DevExpress.DashboardCommon.GridItemFormatRule gridItemFormatRule3 = new DevExpress.DashboardCommon.GridItemFormatRule(); DevExpress.DashboardCommon.FormatConditionRangeSet formatConditionRangeSet3 = new DevExpress.DashboardCommon.FormatConditionRangeSet(); DevExpress.DashboardCommon.RangeInfo rangeInfo9 = new DevExpress.DashboardCommon.RangeInfo(); DevExpress.DashboardCommon.IconSettings iconSettings9 = new DevExpress.DashboardCommon.IconSettings(); DevExpress.DashboardCommon.RangeInfo rangeInfo10 = new DevExpress.DashboardCommon.RangeInfo(); DevExpress.DashboardCommon.IconSettings iconSettings10 = new DevExpress.DashboardCommon.IconSettings(); DevExpress.DashboardCommon.RangeInfo rangeInfo11 = new DevExpress.DashboardCommon.RangeInfo(); DevExpress.DashboardCommon.IconSettings iconSettings11 = new DevExpress.DashboardCommon.IconSettings(); DevExpress.DashboardCommon.RangeInfo rangeInfo12 = new DevExpress.DashboardCommon.RangeInfo(); DevExpress.DashboardCommon.IconSettings iconSettings12 = new DevExpress.DashboardCommon.IconSettings(); DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup1 = new DevExpress.DashboardCommon.DashboardLayoutGroup(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem1 = new DevExpress.DashboardCommon.DashboardLayoutItem(); DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup2 = new DevExpress.DashboardCommon.DashboardLayoutGroup(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem2 = new DevExpress.DashboardCommon.DashboardLayoutItem(); DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup3 = new DevExpress.DashboardCommon.DashboardLayoutGroup(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem3 = new DevExpress.DashboardCommon.DashboardLayoutItem(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem4 = new DevExpress.DashboardCommon.DashboardLayoutItem(); this.rangeFilterDashboardItem1 = new DevExpress.DashboardCommon.RangeFilterDashboardItem(); this.dashboardSqlDataSource1 = new DevExpress.DashboardCommon.DashboardSqlDataSource(); this.gridDashboardItem1 = new DevExpress.DashboardCommon.GridDashboardItem(); this.gridDashboardItem2 = new DevExpress.DashboardCommon.GridDashboardItem(); this.gridDashboardItem3 = new DevExpress.DashboardCommon.GridDashboardItem(); ((System.ComponentModel.ISupportInitialize)(this.rangeFilterDashboardItem1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension4)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure4)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension5)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure5)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // rangeFilterDashboardItem1 // dimension1.DataMember = "DoanhThu_ngaytaodt"; dimension1.DateTimeGroupInterval = DevExpress.DashboardCommon.DateTimeGroupInterval.DayMonthYear; this.rangeFilterDashboardItem1.Argument = dimension1; this.rangeFilterDashboardItem1.ComponentName = "rangeFilterDashboardItem1"; measure1.DataMember = "tong dt"; measure2.DataMember = "DoanhThuTheoCa_tenCa"; measure2.SummaryType = DevExpress.DashboardCommon.SummaryType.Count; this.rangeFilterDashboardItem1.DataItemRepository.Clear(); this.rangeFilterDashboardItem1.DataItemRepository.Add(dimension1, "DataItem2"); this.rangeFilterDashboardItem1.DataItemRepository.Add(measure1, "DataItem1"); this.rangeFilterDashboardItem1.DataItemRepository.Add(measure2, "DataItem0"); this.rangeFilterDashboardItem1.DataMember = "DoanhThu"; this.rangeFilterDashboardItem1.DataSource = this.dashboardSqlDataSource1; flowDateTimePeriodLimit1.Offset = 1; dateTimePeriod1.End = flowDateTimePeriodLimit1; dateTimePeriod1.Name = "Năm Hiện Tại"; dateTimePeriod1.Start = flowDateTimePeriodLimit2; flowDateTimePeriodLimit3.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month; flowDateTimePeriodLimit3.Offset = 1; dateTimePeriod2.End = flowDateTimePeriodLimit3; dateTimePeriod2.Name = "Tháng Hiện Tại"; flowDateTimePeriodLimit4.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month; dateTimePeriod2.Start = flowDateTimePeriodLimit4; dateTimePeriod3.End = flowDateTimePeriodLimit5; dateTimePeriod3.Name = "Năm Trước"; flowDateTimePeriodLimit6.Offset = -1; dateTimePeriod3.Start = flowDateTimePeriodLimit6; flowDateTimePeriodLimit7.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month; dateTimePeriod4.End = flowDateTimePeriodLimit7; dateTimePeriod4.Name = "Tháng trước"; flowDateTimePeriodLimit8.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month; flowDateTimePeriodLimit8.Offset = -1; dateTimePeriod4.Start = flowDateTimePeriodLimit8; flowDateTimePeriodLimit9.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month; dateTimePeriod5.End = flowDateTimePeriodLimit9; dateTimePeriod5.Name = "3 tháng trước"; flowDateTimePeriodLimit10.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month; flowDateTimePeriodLimit10.Offset = -3; dateTimePeriod5.Start = flowDateTimePeriodLimit10; flowDateTimePeriodLimit11.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month; dateTimePeriod6.End = flowDateTimePeriodLimit11; dateTimePeriod6.Name = "6 tháng trước"; flowDateTimePeriodLimit12.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month; flowDateTimePeriodLimit12.Offset = -6; dateTimePeriod6.Start = flowDateTimePeriodLimit12; flowDateTimePeriodLimit13.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month; dateTimePeriod7.End = flowDateTimePeriodLimit13; dateTimePeriod7.Name = "12 tháng trước"; flowDateTimePeriodLimit14.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month; flowDateTimePeriodLimit14.Offset = -12; dateTimePeriod7.Start = flowDateTimePeriodLimit14; this.rangeFilterDashboardItem1.DateTimePeriods.AddRange(new DevExpress.DashboardCommon.DateTimePeriod[] { dateTimePeriod1, dateTimePeriod2, dateTimePeriod3, dateTimePeriod4, dateTimePeriod5, dateTimePeriod6, dateTimePeriod7 }); this.rangeFilterDashboardItem1.DefaultDateTimePeriodName = "Năm Hiện Tại"; this.rangeFilterDashboardItem1.InteractivityOptions.IgnoreMasterFilters = true; this.rangeFilterDashboardItem1.Name = "Bộ Lọc Doanh Thu theo năm tháng"; simpleSeries1.SeriesType = DevExpress.DashboardCommon.SimpleSeriesType.StackedBar; simpleSeries1.AddDataItem("Value", measure2); simpleSeries2.SeriesType = DevExpress.DashboardCommon.SimpleSeriesType.StackedBar; simpleSeries2.AddDataItem("Value", measure1); this.rangeFilterDashboardItem1.Series.AddRange(new DevExpress.DashboardCommon.SimpleSeries[] { simpleSeries1, simpleSeries2 }); this.rangeFilterDashboardItem1.ShowCaption = true; // // dashboardSqlDataSource1 // calculatedField1.DataMember = "DoanhThu"; calculatedField1.Expression = "[DoanhThuTheoCa_tiendelai] + [DoanhThuTheoCa_doanhthutheoca] + [DoanhThuTheoCa_do" + "anhthukhac]"; calculatedField1.Name = "tong dt"; this.dashboardSqlDataSource1.CalculatedFields.AddRange(new DevExpress.DashboardCommon.CalculatedField[] { calculatedField1 }); this.dashboardSqlDataSource1.ComponentName = "dashboardSqlDataSource1"; this.dashboardSqlDataSource1.ConnectionName = "localhost_BaoCaoThuChi_Connection"; msSqlConnectionParameters1.AuthorizationType = DevExpress.DataAccess.ConnectionParameters.MsSqlAuthorizationType.Windows; msSqlConnectionParameters1.DatabaseName = "BaoCaoThuChi"; msSqlConnectionParameters1.ServerName = "localhost"; this.dashboardSqlDataSource1.ConnectionParameters = msSqlConnectionParameters1; this.dashboardSqlDataSource1.Name = "SQL Data Source 1"; columnExpression1.ColumnName = "ngaytaodt"; table1.MetaSerializable = "<Meta X=\"30\" Y=\"30\" Width=\"125\" Height=\"110\" />"; table1.Name = "DoanhThu"; columnExpression1.Table = table1; column1.Expression = columnExpression1; columnExpression2.ColumnName = "tenCa"; table2.MetaSerializable = "<Meta X=\"185\" Y=\"30\" Width=\"125\" Height=\"194\" />"; table2.Name = "DoanhThuTheoCa"; columnExpression2.Table = table2; column2.Expression = columnExpression2; column3.Alias = "DoanhThuTheoCa_doanhthuID"; columnExpression3.ColumnName = "doanhthuID"; columnExpression3.Table = table2; column3.Expression = columnExpression3; columnExpression4.ColumnName = "tiendelai"; columnExpression4.Table = table2; column4.Expression = columnExpression4; columnExpression5.ColumnName = "doanhthutheoca"; columnExpression5.Table = table2; column5.Expression = columnExpression5; columnExpression6.ColumnName = "doanhthukhac"; columnExpression6.Table = table2; column6.Expression = columnExpression6; columnExpression7.ColumnName = "doanhthuID"; columnExpression7.Table = table1; column7.Expression = columnExpression7; columnExpression8.ColumnName = "caID"; columnExpression8.Table = table2; column8.Expression = columnExpression8; allColumns1.Table = table2; allColumns2.Table = table1; selectQuery1.Columns.Add(column1); selectQuery1.Columns.Add(column2); selectQuery1.Columns.Add(column3); selectQuery1.Columns.Add(column4); selectQuery1.Columns.Add(column5); selectQuery1.Columns.Add(column6); selectQuery1.Columns.Add(column7); selectQuery1.Columns.Add(column8); selectQuery1.Columns.Add(allColumns1); selectQuery1.Columns.Add(allColumns2); selectQuery1.Name = "DoanhThu"; relationColumnInfo1.NestedKeyColumn = "doanhthuID"; relationColumnInfo1.ParentKeyColumn = "doanhthuID"; join1.KeyColumns.Add(relationColumnInfo1); join1.Nested = table2; join1.Parent = table1; selectQuery1.Relations.Add(join1); selectQuery1.Tables.Add(table1); selectQuery1.Tables.Add(table2); this.dashboardSqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { selectQuery1 }); this.dashboardSqlDataSource1.ResultSchemaSerializable = resources.GetString("dashboardSqlDataSource1.ResultSchemaSerializable"); // // gridDashboardItem1 // dimension2.DataMember = "DoanhThu_ngaytaodt"; dimension2.DateTimeGroupInterval = DevExpress.DashboardCommon.DateTimeGroupInterval.DayMonthYear; dimension2.Name = "Ngày tạo Doanh Thu"; dimension2.SortOrder = DevExpress.DashboardCommon.DimensionSortOrder.Descending; gridDimensionColumn1.FixedWidth = 57.491674693821388D; gridDimensionColumn1.Totals.AddRange(new DevExpress.DashboardCommon.GridColumnTotal[] { gridColumnTotal1 }); gridDimensionColumn1.Weight = 97.358900144717822D; gridDimensionColumn1.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight; gridDimensionColumn1.AddDataItem("Dimension", dimension2); dimension3.DataMember = "tenCa"; dimension3.Name = "Tên Ca"; gridDimensionColumn2.Weight = 26.049204052098414D; gridDimensionColumn2.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.FitToContent; gridDimensionColumn2.AddDataItem("Dimension", dimension3); measure3.DataMember = "tong dt"; measure3.NumericFormat.CurrencyCultureName = "vi-VN"; measure3.NumericFormat.FormatType = DevExpress.DashboardCommon.DataItemNumericFormatType.Currency; gridMeasureColumn1.Name = "Tổng"; gridColumnTotal2.TotalType = DevExpress.DashboardCommon.GridColumnTotalType.Sum; gridMeasureColumn1.Totals.AddRange(new DevExpress.DashboardCommon.GridColumnTotal[] { gridColumnTotal2 }); gridMeasureColumn1.Weight = 101.59189580318382D; gridMeasureColumn1.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight; gridMeasureColumn1.AddDataItem("Measure", measure3); this.gridDashboardItem1.Columns.AddRange(new DevExpress.DashboardCommon.GridColumnBase[] { gridDimensionColumn1, gridDimensionColumn2, gridMeasureColumn1 }); this.gridDashboardItem1.ComponentName = "gridDashboardItem1"; this.gridDashboardItem1.DataItemRepository.Clear(); this.gridDashboardItem1.DataItemRepository.Add(dimension2, "DataItem0"); this.gridDashboardItem1.DataItemRepository.Add(dimension3, "DataItem1"); this.gridDashboardItem1.DataItemRepository.Add(measure3, "DataItem2"); this.gridDashboardItem1.DataMember = "DoanhThu"; this.gridDashboardItem1.DataSource = this.dashboardSqlDataSource1; iconSettings1.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalRedDownArrow; rangeInfo1.StyleSettings = iconSettings1; rangeInfo1.Value = 0D; iconSettings2.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalYellowDownInclineArrow; rangeInfo2.StyleSettings = iconSettings2; rangeInfo2.Value = 25D; iconSettings3.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalYellowUpInclineArrow; rangeInfo3.StyleSettings = iconSettings3; rangeInfo3.Value = 50D; iconSettings4.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalGreenArrowUp; rangeInfo4.StyleSettings = iconSettings4; rangeInfo4.Value = 75D; formatConditionRangeSet1.RangeSet.AddRange(new DevExpress.DashboardCommon.RangeInfo[] { rangeInfo1, rangeInfo2, rangeInfo3, rangeInfo4 }); formatConditionRangeSet1.ValueType = DevExpress.DashboardCommon.DashboardFormatConditionValueType.Percent; gridItemFormatRule1.Condition = formatConditionRangeSet1; gridItemFormatRule1.DataItem = measure3; gridItemFormatRule1.Name = "FormatRule 1"; this.gridDashboardItem1.FormatRules.AddRange(new DevExpress.DashboardCommon.GridItemFormatRule[] { gridItemFormatRule1 }); this.gridDashboardItem1.GridOptions.ColumnWidthMode = DevExpress.DashboardCommon.GridColumnWidthMode.Manual; this.gridDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false; this.gridDashboardItem1.Name = "Chi tiết theo ngày"; this.gridDashboardItem1.ShowCaption = true; // // gridDashboardItem2 // dimension4.DataMember = "DoanhThu_ngaytaodt"; dimension4.DateTimeGroupInterval = DevExpress.DashboardCommon.DateTimeGroupInterval.MonthYear; dimension4.Name = "Ngày tạo Doanh Thu (Month-Year)"; dimension4.SortOrder = DevExpress.DashboardCommon.DimensionSortOrder.Descending; gridDimensionColumn3.Name = "Tháng Năm"; gridDimensionColumn3.Totals.AddRange(new DevExpress.DashboardCommon.GridColumnTotal[] { gridColumnTotal3 }); gridDimensionColumn3.Weight = 78.468208092485554D; gridDimensionColumn3.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight; gridDimensionColumn3.AddDataItem("Dimension", dimension4); measure4.DataMember = "tong dt"; measure4.Name = "Tổng"; measure4.NumericFormat.CurrencyCultureName = "vi-VN"; measure4.NumericFormat.FormatType = DevExpress.DashboardCommon.DataItemNumericFormatType.Currency; gridMeasureColumn2.Weight = 71.531791907514446D; gridMeasureColumn2.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight; gridMeasureColumn2.AddDataItem("Measure", measure4); this.gridDashboardItem2.Columns.AddRange(new DevExpress.DashboardCommon.GridColumnBase[] { gridDimensionColumn3, gridMeasureColumn2 }); this.gridDashboardItem2.ComponentName = "gridDashboardItem2"; this.gridDashboardItem2.DataItemRepository.Clear(); this.gridDashboardItem2.DataItemRepository.Add(dimension4, "DataItem0"); this.gridDashboardItem2.DataItemRepository.Add(measure4, "DataItem1"); this.gridDashboardItem2.DataMember = "DoanhThu"; this.gridDashboardItem2.DataSource = this.dashboardSqlDataSource1; iconSettings5.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalRedDownArrow; rangeInfo5.StyleSettings = iconSettings5; rangeInfo5.Value = 0D; iconSettings6.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalYellowDownInclineArrow; rangeInfo6.StyleSettings = iconSettings6; rangeInfo6.Value = 25D; iconSettings7.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalYellowUpInclineArrow; rangeInfo7.StyleSettings = iconSettings7; rangeInfo7.Value = 50D; iconSettings8.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalGreenArrowUp; rangeInfo8.StyleSettings = iconSettings8; rangeInfo8.Value = 75D; formatConditionRangeSet2.RangeSet.AddRange(new DevExpress.DashboardCommon.RangeInfo[] { rangeInfo5, rangeInfo6, rangeInfo7, rangeInfo8 }); formatConditionRangeSet2.ValueType = DevExpress.DashboardCommon.DashboardFormatConditionValueType.Percent; gridItemFormatRule2.Condition = formatConditionRangeSet2; gridItemFormatRule2.DataItem = measure4; gridItemFormatRule2.Name = "FormatRule 1"; this.gridDashboardItem2.FormatRules.AddRange(new DevExpress.DashboardCommon.GridItemFormatRule[] { gridItemFormatRule2 }); this.gridDashboardItem2.GridOptions.ColumnWidthMode = DevExpress.DashboardCommon.GridColumnWidthMode.Manual; this.gridDashboardItem2.InteractivityOptions.IgnoreMasterFilters = false; this.gridDashboardItem2.Name = "Tổng theo Tháng"; this.gridDashboardItem2.ShowCaption = true; // // gridDashboardItem3 // dimension5.DataMember = "DoanhThu_ngaytaodt"; gridDimensionColumn4.Name = "Năm"; gridDimensionColumn4.Weight = 95.717344753747327D; gridDimensionColumn4.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight; gridDimensionColumn4.AddDataItem("Dimension", dimension5); measure5.DataMember = "tong dt"; measure5.NumericFormat.CurrencyCultureName = "vi-VN"; measure5.NumericFormat.FormatType = DevExpress.DashboardCommon.DataItemNumericFormatType.Currency; gridMeasureColumn3.Name = "Tổng"; gridMeasureColumn3.Weight = 54.282655246252673D; gridMeasureColumn3.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight; gridMeasureColumn3.AddDataItem("Measure", measure5); this.gridDashboardItem3.Columns.AddRange(new DevExpress.DashboardCommon.GridColumnBase[] { gridDimensionColumn4, gridMeasureColumn3 }); this.gridDashboardItem3.ComponentName = "gridDashboardItem3"; this.gridDashboardItem3.DataItemRepository.Clear(); this.gridDashboardItem3.DataItemRepository.Add(dimension5, "DataItem0"); this.gridDashboardItem3.DataItemRepository.Add(measure5, "DataItem1"); this.gridDashboardItem3.DataMember = "DoanhThu"; this.gridDashboardItem3.DataSource = this.dashboardSqlDataSource1; iconSettings9.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalRedDownArrow; rangeInfo9.StyleSettings = iconSettings9; rangeInfo9.Value = 0D; iconSettings10.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalYellowDownInclineArrow; rangeInfo10.StyleSettings = iconSettings10; rangeInfo10.Value = 25D; iconSettings11.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalYellowUpInclineArrow; rangeInfo11.StyleSettings = iconSettings11; rangeInfo11.Value = 50D; iconSettings12.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalGreenArrowUp; rangeInfo12.StyleSettings = iconSettings12; rangeInfo12.Value = 75D; formatConditionRangeSet3.RangeSet.AddRange(new DevExpress.DashboardCommon.RangeInfo[] { rangeInfo9, rangeInfo10, rangeInfo11, rangeInfo12 }); formatConditionRangeSet3.ValueType = DevExpress.DashboardCommon.DashboardFormatConditionValueType.Percent; gridItemFormatRule3.Condition = formatConditionRangeSet3; gridItemFormatRule3.DataItem = measure5; gridItemFormatRule3.Name = "FormatRule 1"; this.gridDashboardItem3.FormatRules.AddRange(new DevExpress.DashboardCommon.GridItemFormatRule[] { gridItemFormatRule3 }); this.gridDashboardItem3.GridOptions.ColumnWidthMode = DevExpress.DashboardCommon.GridColumnWidthMode.Manual; this.gridDashboardItem3.InteractivityOptions.IgnoreMasterFilters = false; this.gridDashboardItem3.Name = "Tổng theo Năm"; this.gridDashboardItem3.ShowCaption = true; // // Report_DTBanHang // this.DataSources.AddRange(new DevExpress.DashboardCommon.IDashboardDataSource[] { this.dashboardSqlDataSource1 }); this.Items.AddRange(new DevExpress.DashboardCommon.DashboardItem[] { this.gridDashboardItem1, this.rangeFilterDashboardItem1, this.gridDashboardItem2, this.gridDashboardItem3 }); dashboardLayoutItem1.DashboardItem = this.rangeFilterDashboardItem1; dashboardLayoutItem1.Weight = 40.465116279069768D; dashboardLayoutItem2.DashboardItem = this.gridDashboardItem1; dashboardLayoutItem2.Weight = 65.9963436928702D; dashboardLayoutItem3.DashboardItem = this.gridDashboardItem2; dashboardLayoutItem3.Weight = 50.520833333333336D; dashboardLayoutItem4.DashboardItem = this.gridDashboardItem3; dashboardLayoutItem4.Weight = 49.479166666666664D; dashboardLayoutGroup3.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] { dashboardLayoutItem3, dashboardLayoutItem4 }); dashboardLayoutGroup3.DashboardItem = null; dashboardLayoutGroup3.Orientation = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical; dashboardLayoutGroup3.Weight = 34.0036563071298D; dashboardLayoutGroup2.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] { dashboardLayoutItem2, dashboardLayoutGroup3 }); dashboardLayoutGroup2.DashboardItem = null; dashboardLayoutGroup2.Weight = 59.534883720930232D; dashboardLayoutGroup1.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] { dashboardLayoutItem1, dashboardLayoutGroup2 }); dashboardLayoutGroup1.DashboardItem = null; dashboardLayoutGroup1.Orientation = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical; dashboardLayoutGroup1.Weight = 100D; this.LayoutRoot = dashboardLayoutGroup1; this.Title.Text = "Dashboard"; ((System.ComponentModel.ISupportInitialize)(dimension1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.rangeFilterDashboardItem1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension4)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure4)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension5)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure5)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { DevExpress.DashboardCommon.Dimension dimension1 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Measure measure1 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.ChartPane chartPane1 = new DevExpress.DashboardCommon.ChartPane(); DevExpress.DashboardCommon.SimpleSeries simpleSeries1 = new DevExpress.DashboardCommon.SimpleSeries(); DevExpress.DashboardCommon.Dimension dimension2 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.DateTimePeriod dateTimePeriod1 = new DevExpress.DashboardCommon.DateTimePeriod(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit1 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit2 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.DateTimePeriod dateTimePeriod2 = new DevExpress.DashboardCommon.DateTimePeriod(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit3 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit4 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.DateTimePeriod dateTimePeriod3 = new DevExpress.DashboardCommon.DateTimePeriod(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit5 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit6 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit(); DevExpress.DashboardCommon.DateTimePeriod dateTimePeriod4 = new DevExpress.DashboardCommon.DateTimePeriod(); DevExpress.DashboardCommon.FixedDateTimePeriodLimit fixedDateTimePeriodLimit1 = new DevExpress.DashboardCommon.FixedDateTimePeriodLimit(); DevExpress.DashboardCommon.FixedDateTimePeriodLimit fixedDateTimePeriodLimit2 = new DevExpress.DashboardCommon.FixedDateTimePeriodLimit(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Dashboard1)); DevExpress.DataAccess.Excel.ExcelWorksheetSettings excelWorksheetSettings1 = new DevExpress.DataAccess.Excel.ExcelWorksheetSettings(); DevExpress.DataAccess.Excel.ExcelSourceOptions excelSourceOptions1 = new DevExpress.DataAccess.Excel.ExcelSourceOptions(excelWorksheetSettings1); DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup1 = new DevExpress.DashboardCommon.DashboardLayoutGroup(); DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup2 = new DevExpress.DashboardCommon.DashboardLayoutGroup(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem1 = new DevExpress.DashboardCommon.DashboardLayoutItem(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem2 = new DevExpress.DashboardCommon.DashboardLayoutItem(); this.chartDashboardItem1 = new DevExpress.DashboardCommon.ChartDashboardItem(); this.dateFilterDashboardItem1 = new DevExpress.DashboardCommon.DateFilterDashboardItem(); this.dashboardItemGroup1 = new DevExpress.DashboardCommon.DashboardItemGroup(); this.dashboardExcelDataSource1 = new DevExpress.DashboardCommon.DashboardExcelDataSource(); ((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dateFilterDashboardItem1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dashboardItemGroup1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dashboardExcelDataSource1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // chartDashboardItem1 // dimension1.DataMember = "OrderDate"; dimension1.DateTimeGroupInterval = DevExpress.DashboardCommon.DateTimeGroupInterval.DayMonthYear; this.chartDashboardItem1.Arguments.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension1 }); this.chartDashboardItem1.AxisX.TitleVisible = false; this.chartDashboardItem1.ComponentName = "chartDashboardItem1"; measure1.DataMember = "Extended Price"; this.chartDashboardItem1.DataItemRepository.Clear(); this.chartDashboardItem1.DataItemRepository.Add(dimension1, "DataItem0"); this.chartDashboardItem1.DataItemRepository.Add(measure1, "DataItem1"); this.chartDashboardItem1.DataSource = this.dashboardExcelDataSource1; this.chartDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false; this.chartDashboardItem1.Name = ""; chartPane1.Name = "Pane 1"; chartPane1.PrimaryAxisY.AlwaysShowZeroLevel = true; chartPane1.PrimaryAxisY.ShowGridLines = true; chartPane1.PrimaryAxisY.TitleVisible = true; chartPane1.SecondaryAxisY.AlwaysShowZeroLevel = true; chartPane1.SecondaryAxisY.ShowGridLines = false; chartPane1.SecondaryAxisY.TitleVisible = true; simpleSeries1.SeriesType = DevExpress.DashboardCommon.SimpleSeriesType.Line; simpleSeries1.AddDataItem("Value", measure1); chartPane1.Series.AddRange(new DevExpress.DashboardCommon.ChartSeries[] { simpleSeries1 }); this.chartDashboardItem1.Panes.AddRange(new DevExpress.DashboardCommon.ChartPane[] { chartPane1 }); this.chartDashboardItem1.ParentContainer = this.dashboardItemGroup1; this.chartDashboardItem1.ShowCaption = false; // // dateFilterDashboardItem1 // this.dateFilterDashboardItem1.ArrangementMode = DevExpress.DashboardCommon.DateFilterArrangementMode.Vertical; this.dateFilterDashboardItem1.ComponentName = "dateFilterDashboardItem1"; dimension2.DataMember = "OrderDate"; dimension2.DateTimeGroupInterval = DevExpress.DashboardCommon.DateTimeGroupInterval.DayMonthYear; dimension2.UniqueId = "orderDateId"; this.dateFilterDashboardItem1.DataItemRepository.Clear(); this.dateFilterDashboardItem1.DataItemRepository.Add(dimension2, "DataItem0"); this.dateFilterDashboardItem1.DataSource = this.dashboardExcelDataSource1; dateTimePeriod1.End = flowDateTimePeriodLimit1; dateTimePeriod1.Name = "Last Year"; flowDateTimePeriodLimit2.Offset = -1; dateTimePeriod1.Start = flowDateTimePeriodLimit2; flowDateTimePeriodLimit3.Interval = DevExpress.DashboardCommon.DateTimeInterval.Day; flowDateTimePeriodLimit3.Offset = 8; dateTimePeriod2.End = flowDateTimePeriodLimit3; dateTimePeriod2.Name = "Next Seven Days"; flowDateTimePeriodLimit4.Interval = DevExpress.DashboardCommon.DateTimeInterval.Day; flowDateTimePeriodLimit4.Offset = 1; dateTimePeriod2.Start = flowDateTimePeriodLimit4; flowDateTimePeriodLimit5.Interval = DevExpress.DashboardCommon.DateTimeInterval.Day; flowDateTimePeriodLimit5.Offset = 1; dateTimePeriod3.End = flowDateTimePeriodLimit5; dateTimePeriod3.Name = "Month-to-Date"; flowDateTimePeriodLimit6.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month; dateTimePeriod3.Start = flowDateTimePeriodLimit6; fixedDateTimePeriodLimit1.Date = new System.DateTime(2019, 1, 18, 0, 0, 0, 0); dateTimePeriod4.End = fixedDateTimePeriodLimit1; dateTimePeriod4.Name = "Jul 18, 2018 - Jan 18, 2019"; fixedDateTimePeriodLimit2.Date = new System.DateTime(2018, 7, 18, 0, 0, 0, 0); dateTimePeriod4.Start = fixedDateTimePeriodLimit2; this.dateFilterDashboardItem1.DateTimePeriods.AddRange(new DevExpress.DashboardCommon.DateTimePeriod[] { dateTimePeriod1, dateTimePeriod2, dateTimePeriod3, dateTimePeriod4 }); this.dateFilterDashboardItem1.Dimension = dimension2; this.dateFilterDashboardItem1.Name = ""; this.dateFilterDashboardItem1.ParentContainer = this.dashboardItemGroup1; this.dateFilterDashboardItem1.ShowCaption = false; // // dashboardItemGroup1 // this.dashboardItemGroup1.ComponentName = "dashboardItemGroup1"; this.dashboardItemGroup1.InteractivityOptions.IgnoreMasterFilters = true; this.dashboardItemGroup1.InteractivityOptions.IsMasterFilter = false; this.dashboardItemGroup1.Name = "Sales by Date"; this.dashboardItemGroup1.ShowCaption = true; // // dashboardExcelDataSource1 // this.dashboardExcelDataSource1.ComponentName = "dashboardExcelDataSource1"; this.dashboardExcelDataSource1.FileName = "SalesPerson.xlsx"; this.dashboardExcelDataSource1.Name = "Excel Data Source 1"; this.dashboardExcelDataSource1.ResultSchemaSerializable = resources.GetString("dashboardExcelDataSource1.ResultSchemaSerializable"); excelWorksheetSettings1.CellRange = null; excelWorksheetSettings1.WorksheetName = "Data"; excelSourceOptions1.ImportSettings = excelWorksheetSettings1; this.dashboardExcelDataSource1.SourceOptions = excelSourceOptions1; // // Dashboard1 // this.DataSources.AddRange(new DevExpress.DashboardCommon.IDashboardDataSource[] { this.dashboardExcelDataSource1 }); this.Groups.AddRange(new DevExpress.DashboardCommon.DashboardItemGroup[] { this.dashboardItemGroup1 }); this.Items.AddRange(new DevExpress.DashboardCommon.DashboardItem[] { this.chartDashboardItem1, this.dateFilterDashboardItem1 }); dashboardLayoutItem1.DashboardItem = this.dateFilterDashboardItem1; dashboardLayoutItem1.Weight = 30D; dashboardLayoutItem2.DashboardItem = this.chartDashboardItem1; dashboardLayoutItem2.Weight = 70D; dashboardLayoutGroup2.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] { dashboardLayoutItem1, dashboardLayoutItem2 }); dashboardLayoutGroup2.DashboardItem = this.dashboardItemGroup1; dashboardLayoutGroup2.Weight = 100D; dashboardLayoutGroup1.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] { dashboardLayoutGroup2 }); dashboardLayoutGroup1.DashboardItem = null; dashboardLayoutGroup1.Orientation = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical; dashboardLayoutGroup1.Weight = 100D; this.LayoutRoot = dashboardLayoutGroup1; this.Title.Text = "Dashboard"; ((System.ComponentModel.ISupportInitialize)(dimension1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dateFilterDashboardItem1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dashboardItemGroup1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dashboardExcelDataSource1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }