/// <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.DataAccess.Sql.CustomSqlQuery customSqlQuery1 = new DevExpress.DataAccess.Sql.CustomSqlQuery(); DevExpress.DataAccess.Sql.QueryParameter queryParameter1 = new DevExpress.DataAccess.Sql.QueryParameter(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Pro_Db_RMNUT_OnHand_Chart)); DevExpress.DataAccess.Sql.CustomSqlQuery customSqlQuery2 = new DevExpress.DataAccess.Sql.CustomSqlQuery(); DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup1 = new DevExpress.DashboardCommon.DashboardLayoutGroup(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem1 = new DevExpress.DashboardCommon.DashboardLayoutItem(); DevExpress.DashboardCommon.DashboardParameter dashboardParameter1 = new DevExpress.DashboardCommon.DashboardParameter(); DevExpress.DashboardCommon.DynamicListLookUpSettings dynamicListLookUpSettings1 = new DevExpress.DashboardCommon.DynamicListLookUpSettings(); this.chartDashboardItem1 = new DevExpress.DashboardCommon.ChartDashboardItem(); this.dashboardSqlDataSource1 = new DevExpress.DashboardCommon.DashboardSqlDataSource(); this.dashboardSqlDataSource2 = new DevExpress.DashboardCommon.DashboardSqlDataSource(); ((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // chartDashboardItem1 // dimension1.DataMember = "DT_FIN"; dimension1.DateTimeGroupInterval = DevExpress.DashboardCommon.DateTimeGroupInterval.MonthYear; this.chartDashboardItem1.Arguments.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension1 }); this.chartDashboardItem1.AxisX.TitleVisible = false; this.chartDashboardItem1.ComponentName = "chartDashboardItem1"; measure1.DataMember = "QT_MVMT"; measure1.Name = "Manf. QTY."; measure1.NumericFormat.FormatType = DevExpress.DashboardCommon.DataItemNumericFormatType.Number; measure1.NumericFormat.IncludeGroupSeparator = true; measure1.NumericFormat.Unit = DevExpress.DashboardCommon.DataItemNumericUnit.Ones; this.chartDashboardItem1.DataItemRepository.Clear(); this.chartDashboardItem1.DataItemRepository.Add(dimension1, "DataItem0"); this.chartDashboardItem1.DataItemRepository.Add(measure1, "DataItem1"); this.chartDashboardItem1.DataMember = "Query"; this.chartDashboardItem1.DataSource = this.dashboardSqlDataSource1; this.chartDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false; this.chartDashboardItem1.Legend.InsidePosition = DevExpress.DashboardCommon.ChartLegendInsidePosition.TopRightVertical; this.chartDashboardItem1.Legend.IsInsideDiagram = true; this.chartDashboardItem1.Legend.OutsidePosition = DevExpress.DashboardCommon.ChartLegendOutsidePosition.BottomCenterHorizontal; this.chartDashboardItem1.Name = "Chart 1"; chartPane1.Name = "Pane 1"; chartPane1.PrimaryAxisY.AlwaysShowZeroLevel = true; chartPane1.PrimaryAxisY.ShowGridLines = true; chartPane1.PrimaryAxisY.TitleVisible = true; chartPane1.SecondaryAxisY.AlwaysShowZeroLevel = true; chartPane1.SecondaryAxisY.Logarithmic = true; chartPane1.SecondaryAxisY.ShowGridLines = false; chartPane1.SecondaryAxisY.TitleVisible = true; simpleSeries1.PointLabelOptions.Content = DevExpress.DashboardCommon.PointLabelContentType.ArgumentAndValue; simpleSeries1.PointLabelOptions.ShowForZeroValues = true; simpleSeries1.PointLabelOptions.ShowPointLabels = true; simpleSeries1.AddDataItem("Value", measure1); chartPane1.Series.AddRange(new DevExpress.DashboardCommon.ChartSeries[] { simpleSeries1 }); this.chartDashboardItem1.Panes.AddRange(new DevExpress.DashboardCommon.ChartPane[] { chartPane1 }); this.chartDashboardItem1.ShowCaption = false; // // dashboardSqlDataSource1 // this.dashboardSqlDataSource1.ComponentName = "dashboardSqlDataSource1"; this.dashboardSqlDataSource1.ConnectionName = "Production.Properties.Settings.SYNC_NUTRICIELConnectionString"; this.dashboardSqlDataSource1.Name = "FG This Month Chart"; customSqlQuery1.Name = "Query"; queryParameter1.Name = "Parm_CD_MAT"; queryParameter1.Type = typeof(DevExpress.DataAccess.Expression); queryParameter1.Value = new DevExpress.DataAccess.Expression("[Parameters.FGName]", typeof(string)); customSqlQuery1.Parameters.Add(queryParameter1); customSqlQuery1.Sql = resources.GetString("customSqlQuery1.Sql"); this.dashboardSqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { customSqlQuery1 }); this.dashboardSqlDataSource1.ResultSchemaSerializable = resources.GetString("dashboardSqlDataSource1.ResultSchemaSerializable"); // // dashboardSqlDataSource2 // this.dashboardSqlDataSource2.ComponentName = "dashboardSqlDataSource2"; this.dashboardSqlDataSource2.ConnectionName = "Production.Properties.Settings.SYNC_NUTRICIELConnectionString"; this.dashboardSqlDataSource2.Name = "List_Parm_CD_MAT"; customSqlQuery2.Name = "Query"; customSqlQuery2.Sql = resources.GetString("customSqlQuery2.Sql"); this.dashboardSqlDataSource2.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { customSqlQuery2 }); this.dashboardSqlDataSource2.ResultSchemaSerializable = "PERhdGFTZXQgTmFtZT0iTGlzdF9QYXJtX0NEX01BVCI+PFZpZXcgTmFtZT0iUXVlcnkiPjxGaWVsZCBOY" + "W1lPSJDRF9NQVQiIFR5cGU9IlN0cmluZyIgLz48RmllbGQgTmFtZT0iTEJfTUFUIiBUeXBlPSJTdHJpb" + "mciIC8+PC9WaWV3PjwvRGF0YVNldD4="; // // Pro_Db_RMNUT_OnHand_Chart // this.DataSources.AddRange(new DevExpress.DashboardCommon.IDashboardDataSource[] { this.dashboardSqlDataSource1, this.dashboardSqlDataSource2 }); this.Items.AddRange(new DevExpress.DashboardCommon.DashboardItem[] { this.chartDashboardItem1 }); dashboardLayoutItem1.DashboardItem = this.chartDashboardItem1; dashboardLayoutItem1.Weight = 100D; dashboardLayoutGroup1.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] { dashboardLayoutItem1 }); dashboardLayoutGroup1.DashboardItem = null; dashboardLayoutGroup1.Orientation = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical; this.LayoutRoot = dashboardLayoutGroup1; dynamicListLookUpSettings1.DataMember = "Query"; dynamicListLookUpSettings1.DataSourceName = "dashboardSqlDataSource2"; dynamicListLookUpSettings1.DisplayMember = "LB_MAT"; dynamicListLookUpSettings1.SortByMember = "LB_MAT"; dynamicListLookUpSettings1.ValueMember = "CD_MAT"; dashboardParameter1.LookUpSettings = dynamicListLookUpSettings1; dashboardParameter1.Name = "FGName"; dashboardParameter1.Type = typeof(string); dashboardParameter1.Value = ""; this.Parameters.AddRange(new DevExpress.DashboardCommon.DashboardParameter[] { dashboardParameter1 }); this.Title.Text = "Total FG quantity per month"; ((System.ComponentModel.ISupportInitialize)(dimension1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource2)).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() { System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(dash_pro_user_home)); DevExpress.DashboardCommon.CalculatedField calculatedField1 = new DevExpress.DashboardCommon.CalculatedField(); DevExpress.DashboardCommon.CalculatedField calculatedField2 = new DevExpress.DashboardCommon.CalculatedField(); 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.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.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.Column column11 = new DevExpress.DataAccess.Sql.Column(); DevExpress.DataAccess.Sql.ColumnExpression columnExpression11 = new DevExpress.DataAccess.Sql.ColumnExpression(); DevExpress.DataAccess.Sql.Column column12 = new DevExpress.DataAccess.Sql.Column(); DevExpress.DataAccess.Sql.ColumnExpression columnExpression12 = new DevExpress.DataAccess.Sql.ColumnExpression(); DevExpress.DataAccess.Sql.Column column13 = new DevExpress.DataAccess.Sql.Column(); DevExpress.DataAccess.Sql.ColumnExpression columnExpression13 = new DevExpress.DataAccess.Sql.ColumnExpression(); DevExpress.DataAccess.Sql.QueryParameter queryParameter1 = new DevExpress.DataAccess.Sql.QueryParameter(); DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup1 = new DevExpress.DashboardCommon.DashboardLayoutGroup(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem1 = new DevExpress.DashboardCommon.DashboardLayoutItem(); DevExpress.DashboardCommon.DashboardParameter dashboardParameter1 = new DevExpress.DashboardCommon.DashboardParameter(); DevExpress.DashboardCommon.DynamicListLookUpSettings dynamicListLookUpSettings1 = new DevExpress.DashboardCommon.DynamicListLookUpSettings(); this.textBoxDashboardItem1 = new DevExpress.DashboardCommon.TextBoxDashboardItem(); this.dashboardSqlDataSource2 = new DevExpress.DashboardCommon.DashboardSqlDataSource(); ((System.ComponentModel.ISupportInitialize)(this.textBoxDashboardItem1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // textBoxDashboardItem1 // this.textBoxDashboardItem1.ComponentName = "textBoxDashboardItem1"; this.textBoxDashboardItem1.DataItemRepository.Clear(); this.textBoxDashboardItem1.InnerRtf = resources.GetString("textBoxDashboardItem1.InnerRtf"); this.textBoxDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false; this.textBoxDashboardItem1.Name = "Text Box 1"; this.textBoxDashboardItem1.ShowCaption = true; // // dashboardSqlDataSource2 // calculatedField1.DataMember = "view_workflow_laststatus"; calculatedField1.Expression = "CountDistinct([Status])"; calculatedField1.Name = "CD_status"; calculatedField2.DataMember = "view_workflow_laststatus"; calculatedField2.Expression = "ToStr([Worker])"; calculatedField2.Name = "STR_Worker"; this.dashboardSqlDataSource2.CalculatedFields.AddRange(new DevExpress.DashboardCommon.CalculatedField[] { calculatedField1, calculatedField2 }); this.dashboardSqlDataSource2.ComponentName = "dashboardSqlDataSource2"; this.dashboardSqlDataSource2.ConnectionName = "DevDB"; this.dashboardSqlDataSource2.Name = "SQL Data Source 1"; columnExpression1.ColumnName = "AssignedTo"; table1.MetaSerializable = "<Meta X=\"30\" Y=\"30\" Width=\"125\" Height=\"305\" />"; table1.Name = "view_workflow"; columnExpression1.Table = table1; column1.Expression = columnExpression1; columnExpression2.ColumnName = "AssignedBy"; columnExpression2.Table = table1; column2.Expression = columnExpression2; columnExpression3.ColumnName = "Project"; columnExpression3.Table = table1; column3.Expression = columnExpression3; columnExpression4.ColumnName = "ProjectColor"; columnExpression4.Table = table1; column4.Expression = columnExpression4; columnExpression5.ColumnName = "Status"; columnExpression5.Table = table1; column5.Expression = columnExpression5; columnExpression6.ColumnName = "StatusOrder"; columnExpression6.Table = table1; column6.Expression = columnExpression6; columnExpression7.ColumnName = "Comments"; columnExpression7.Table = table1; column7.Expression = columnExpression7; columnExpression8.ColumnName = "Manager"; columnExpression8.Table = table1; column8.Expression = columnExpression8; columnExpression9.ColumnName = "Worker"; columnExpression9.Table = table1; column9.Expression = columnExpression9; columnExpression10.ColumnName = "Date"; columnExpression10.Table = table1; column10.Expression = columnExpression10; columnExpression11.ColumnName = "DueDate"; columnExpression11.Table = table1; column11.Expression = columnExpression11; columnExpression12.ColumnName = "RC_ID"; columnExpression12.Table = table1; column12.Expression = columnExpression12; columnExpression13.ColumnName = "RC_NAME"; columnExpression13.Table = table1; column13.Expression = columnExpression13; 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.Columns.Add(column11); selectQuery1.Columns.Add(column12); selectQuery1.Columns.Add(column13); selectQuery1.Distinct = true; selectQuery1.FilterString = ""; selectQuery1.GroupFilterString = ""; selectQuery1.Name = "view_workflow_laststatus"; queryParameter1.Name = "User"; queryParameter1.Type = typeof(DevExpress.DataAccess.Expression); queryParameter1.Value = new DevExpress.DataAccess.Expression("[Parameters.Parameter1]", typeof(string)); selectQuery1.Parameters.Add(queryParameter1); selectQuery1.Tables.Add(table1); this.dashboardSqlDataSource2.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { selectQuery1 }); this.dashboardSqlDataSource2.ResultSchemaSerializable = resources.GetString("dashboardSqlDataSource2.ResultSchemaSerializable"); // // dash_pro_user_home // this.DataSources.AddRange(new DevExpress.DashboardCommon.IDashboardDataSource[] { this.dashboardSqlDataSource2 }); this.Items.AddRange(new DevExpress.DashboardCommon.DashboardItem[] { this.textBoxDashboardItem1 }); dashboardLayoutItem1.DashboardItem = this.textBoxDashboardItem1; dashboardLayoutItem1.Weight = 100D; dashboardLayoutGroup1.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] { dashboardLayoutItem1 }); dashboardLayoutGroup1.DashboardItem = null; dashboardLayoutGroup1.Orientation = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical; this.LayoutRoot = dashboardLayoutGroup1; dashboardParameter1.Description = "Select a User"; dynamicListLookUpSettings1.DataMember = "view_workflow_laststatus"; dynamicListLookUpSettings1.DataSourceName = "dashboardSqlDataSource2"; dynamicListLookUpSettings1.ValueMember = "Worker"; dashboardParameter1.LookUpSettings = dynamicListLookUpSettings1; dashboardParameter1.Name = "Parameter1"; dashboardParameter1.Type = typeof(string); dashboardParameter1.Value = "4ce0cdc9-ec9c-41a6-ac53-7205023c0312"; this.Parameters.AddRange(new DevExpress.DashboardCommon.DashboardParameter[] { dashboardParameter1 }); this.Title.Text = "Dashboard"; ((System.ComponentModel.ISupportInitialize)(this.textBoxDashboardItem1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource2)).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.Measure measure1 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.Card card1 = new DevExpress.DashboardCommon.Card(); DevExpress.DashboardCommon.Dimension dimension1 = new DevExpress.DashboardCommon.Dimension(); 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.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.QueryParameter queryParameter1 = new DevExpress.DataAccess.Sql.QueryParameter(); DevExpress.DataAccess.Sql.SelectQuery selectQuery2 = new DevExpress.DataAccess.Sql.SelectQuery(); DevExpress.DataAccess.Sql.Column column6 = new DevExpress.DataAccess.Sql.Column(); DevExpress.DataAccess.Sql.ColumnExpression columnExpression6 = new DevExpress.DataAccess.Sql.ColumnExpression(); DevExpress.DataAccess.Sql.Table table2 = new DevExpress.DataAccess.Sql.Table(); DevExpress.DataAccess.Sql.Column column7 = new DevExpress.DataAccess.Sql.Column(); DevExpress.DataAccess.Sql.ColumnExpression columnExpression7 = new DevExpress.DataAccess.Sql.ColumnExpression(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Dashboard1)); DevExpress.DashboardCommon.Dimension dimension2 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Measure measure2 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.ChartPane chartPane1 = new DevExpress.DashboardCommon.ChartPane(); DevExpress.DashboardCommon.SimpleSeries simpleSeries1 = new DevExpress.DashboardCommon.SimpleSeries(); DevExpress.DashboardCommon.Dimension dimension3 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Measure measure3 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.Dimension dimension4 = new DevExpress.DashboardCommon.Dimension(); 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.DashboardParameter dashboardParameter1 = new DevExpress.DashboardCommon.DashboardParameter(); DevExpress.DashboardCommon.DynamicListLookUpSettings dynamicListLookUpSettings1 = new DevExpress.DashboardCommon.DynamicListLookUpSettings(); this.cardDashboardItem1 = new DevExpress.DashboardCommon.CardDashboardItem(); this.dashboardSqlDataSource1 = new DevExpress.DashboardCommon.DashboardSqlDataSource(); this.chartDashboardItem1 = new DevExpress.DashboardCommon.ChartDashboardItem(); this.pivotDashboardItem1 = new DevExpress.DashboardCommon.PivotDashboardItem(); ((System.ComponentModel.ISupportInitialize)(this.cardDashboardItem1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem1)).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)(measure3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension4)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // cardDashboardItem1 // measure1.DataMember = "ExtendedPrice"; card1.AddDataItem("ActualValue", measure1); this.cardDashboardItem1.Cards.AddRange(new DevExpress.DashboardCommon.Card[] { card1 }); this.cardDashboardItem1.ComponentName = "cardDashboardItem1"; dimension1.DataMember = "Customers.CompanyName"; this.cardDashboardItem1.DataItemRepository.Clear(); this.cardDashboardItem1.DataItemRepository.Add(dimension1, "DataItem0"); this.cardDashboardItem1.DataItemRepository.Add(measure1, "DataItem1"); this.cardDashboardItem1.DataMember = "Invoices"; this.cardDashboardItem1.DataSource = this.dashboardSqlDataSource1; this.cardDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false; this.cardDashboardItem1.Name = "Cards 1"; this.cardDashboardItem1.SeriesDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension1 }); this.cardDashboardItem1.ShowCaption = false; // // dashboardSqlDataSource1 // this.dashboardSqlDataSource1.ComponentName = "dashboardSqlDataSource1"; this.dashboardSqlDataSource1.ConnectionName = "nwindConnection"; this.dashboardSqlDataSource1.Name = "SQL Data Source 1"; columnExpression1.ColumnName = "CustomerID"; table1.MetaSerializable = "30|30|200|550"; table1.Name = "Invoices"; columnExpression1.Table = table1; column1.Expression = columnExpression1; columnExpression2.ColumnName = "Customers.CompanyName"; columnExpression2.Table = table1; column2.Expression = columnExpression2; columnExpression3.ColumnName = "OrderDate"; columnExpression3.Table = table1; column3.Expression = columnExpression3; columnExpression4.ColumnName = "ProductName"; columnExpression4.Table = table1; column4.Expression = columnExpression4; columnExpression5.ColumnName = "ExtendedPrice"; columnExpression5.Table = table1; column5.Expression = columnExpression5; selectQuery1.Columns.Add(column1); selectQuery1.Columns.Add(column2); selectQuery1.Columns.Add(column3); selectQuery1.Columns.Add(column4); selectQuery1.Columns.Add(column5); selectQuery1.FilterString = "[Invoices.CustomerID] In (?customerIdParameter)"; selectQuery1.GroupFilterString = ""; selectQuery1.MetaSerializable = "20|20|100|103"; selectQuery1.Name = "Invoices"; queryParameter1.Name = "customerIdParameter"; queryParameter1.Type = typeof(DevExpress.DataAccess.Expression); queryParameter1.Value = new DevExpress.DataAccess.Expression("[Parameters.customerIdParameter]", typeof(string)); selectQuery1.Parameters.Add(queryParameter1); selectQuery1.Tables.Add(table1); columnExpression6.ColumnName = "CustomerID"; table2.MetaSerializable = "30|30|125|550"; table2.Name = "Invoices"; columnExpression6.Table = table2; column6.Expression = columnExpression6; columnExpression7.ColumnName = "Customers.CompanyName"; columnExpression7.Table = table2; column7.Expression = columnExpression7; selectQuery2.Columns.Add(column6); selectQuery2.Columns.Add(column7); selectQuery2.Name = "Invoices_DashboardParameterSource"; selectQuery2.Tables.Add(table2); this.dashboardSqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { selectQuery1, selectQuery2 }); this.dashboardSqlDataSource1.ResultSchemaSerializable = resources.GetString("dashboardSqlDataSource1.ResultSchemaSerializable"); // // chartDashboardItem1 // dimension2.DataMember = "OrderDate"; dimension2.DateTimeGroupInterval = DevExpress.DashboardCommon.DateTimeGroupInterval.MonthYear; this.chartDashboardItem1.Arguments.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension2 }); this.chartDashboardItem1.AxisX.TitleVisible = false; this.chartDashboardItem1.ComponentName = "chartDashboardItem1"; measure2.DataMember = "ExtendedPrice"; this.chartDashboardItem1.DataItemRepository.Clear(); this.chartDashboardItem1.DataItemRepository.Add(dimension2, "DataItem1"); this.chartDashboardItem1.DataItemRepository.Add(measure2, "DataItem0"); this.chartDashboardItem1.DataMember = "Invoices"; this.chartDashboardItem1.DataSource = this.dashboardSqlDataSource1; this.chartDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false; this.chartDashboardItem1.Name = "Chart 1"; 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.SplineArea; simpleSeries1.AddDataItem("Value", measure2); chartPane1.Series.AddRange(new DevExpress.DashboardCommon.ChartSeries[] { simpleSeries1 }); this.chartDashboardItem1.Panes.AddRange(new DevExpress.DashboardCommon.ChartPane[] { chartPane1 }); this.chartDashboardItem1.ShowCaption = false; // // pivotDashboardItem1 // dimension3.DataMember = "OrderDate"; this.pivotDashboardItem1.Columns.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension3 }); this.pivotDashboardItem1.ComponentName = "pivotDashboardItem1"; measure3.DataMember = "ExtendedPrice"; dimension4.DataMember = "ProductName"; this.pivotDashboardItem1.DataItemRepository.Clear(); this.pivotDashboardItem1.DataItemRepository.Add(measure3, "DataItem0"); this.pivotDashboardItem1.DataItemRepository.Add(dimension4, "DataItem1"); this.pivotDashboardItem1.DataItemRepository.Add(dimension3, "DataItem2"); this.pivotDashboardItem1.DataMember = "Invoices"; this.pivotDashboardItem1.DataSource = this.dashboardSqlDataSource1; this.pivotDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false; this.pivotDashboardItem1.Name = "Pivot 1"; this.pivotDashboardItem1.Rows.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension4 }); this.pivotDashboardItem1.ShowCaption = false; this.pivotDashboardItem1.Values.AddRange(new DevExpress.DashboardCommon.Measure[] { measure3 }); // // Dashboard1 // this.DataSources.AddRange(new DevExpress.DashboardCommon.IDashboardDataSource[] { this.dashboardSqlDataSource1 }); this.Items.AddRange(new DevExpress.DashboardCommon.DashboardItem[] { this.cardDashboardItem1, this.chartDashboardItem1, this.pivotDashboardItem1 }); dashboardLayoutItem1.DashboardItem = this.cardDashboardItem1; dashboardLayoutItem1.Weight = 24.041811846689896D; dashboardLayoutItem2.DashboardItem = this.chartDashboardItem1; dashboardLayoutItem2.Weight = 75.9581881533101D; dashboardLayoutGroup2.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] { dashboardLayoutItem1, dashboardLayoutItem2 }); dashboardLayoutGroup2.DashboardItem = null; dashboardLayoutGroup2.Weight = 56.71641791044776D; dashboardLayoutItem3.DashboardItem = this.pivotDashboardItem1; dashboardLayoutItem3.Weight = 43.28358208955224D; dashboardLayoutGroup1.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] { dashboardLayoutGroup2, dashboardLayoutItem3 }); dashboardLayoutGroup1.DashboardItem = null; dashboardLayoutGroup1.Orientation = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical; this.LayoutRoot = dashboardLayoutGroup1; dashboardParameter1.AllowMultiselect = true; dashboardParameter1.Description = "Select companies:"; dynamicListLookUpSettings1.DataMember = "Invoices_DashboardParameterSource"; dynamicListLookUpSettings1.DataSourceName = "dashboardSqlDataSource1"; dynamicListLookUpSettings1.DisplayMember = "Customers.CompanyName"; dynamicListLookUpSettings1.ValueMember = "CustomerID"; dashboardParameter1.LookUpSettings = dynamicListLookUpSettings1; dashboardParameter1.Name = "customerIdParameter"; dashboardParameter1.Type = typeof(string); dashboardParameter1.Value = new object[] { ((object)("ALFKI")) }; this.Parameters.AddRange(new DevExpress.DashboardCommon.DashboardParameter[] { dashboardParameter1 }); this.Title.Text = "Dashboard"; ((System.ComponentModel.ISupportInitialize)(measure1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.cardDashboardItem1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension4)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.pivotDashboardItem1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }