/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); DevExpress.DashboardCommon.Measure measure1 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.GridMeasureColumn gridMeasureColumn1 = new DevExpress.DashboardCommon.GridMeasureColumn(); DevExpress.DashboardCommon.Dimension dimension1 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn1 = new DevExpress.DashboardCommon.GridDimensionColumn(); 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.DashboardParameter dashboardParameter2 = new DevExpress.DashboardCommon.DashboardParameter(); this.gridDashboardItem1 = new DevExpress.DashboardCommon.GridDashboardItem(); this.bindingSource1 = new System.Windows.Forms.BindingSource(this.components); this.dashboardObjectDataSource1 = new DevExpress.DashboardCommon.DashboardObjectDataSource(); ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.bindingSource1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dashboardObjectDataSource1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // gridDashboardItem1 // measure1.DataMember = "ID"; gridMeasureColumn1.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight; gridMeasureColumn1.AddDataItem("Measure", measure1); dimension1.DataMember = "Name"; gridDimensionColumn1.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight; gridDimensionColumn1.AddDataItem("Dimension", dimension1); this.gridDashboardItem1.Columns.AddRange(new DevExpress.DashboardCommon.GridColumnBase[] { gridMeasureColumn1, gridDimensionColumn1 }); this.gridDashboardItem1.ComponentName = "gridDashboardItem1"; this.gridDashboardItem1.DataItemRepository.Clear(); this.gridDashboardItem1.DataItemRepository.Add(measure1, "DataItem0"); this.gridDashboardItem1.DataItemRepository.Add(dimension1, "DataItem1"); this.gridDashboardItem1.DataSource = this.dashboardObjectDataSource1; this.gridDashboardItem1.FilterString = ""; this.gridDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false; this.gridDashboardItem1.Name = "Grid 1"; this.gridDashboardItem1.ShowCaption = true; // // bindingSource1 // this.bindingSource1.DataSource = typeof(WinProject.MyClass); // // dashboardObjectDataSource1 // this.dashboardObjectDataSource1.ComponentName = "dashboardObjectDataSource1"; this.dashboardObjectDataSource1.DataSource = typeof(WinProject.MyClass); this.dashboardObjectDataSource1.Name = "Object Data Source 1"; // // Dashboard1 // this.DataSources.AddRange(new DevExpress.DashboardCommon.IDashboardDataSource[] { this.dashboardObjectDataSource1 }); this.Items.AddRange(new DevExpress.DashboardCommon.DashboardItem[] { this.gridDashboardItem1 }); dashboardLayoutItem1.DashboardItem = this.gridDashboardItem1; dashboardLayoutItem1.Weight = 44.110275689223059D; dashboardLayoutGroup1.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] { dashboardLayoutItem1 }); dashboardLayoutGroup1.DashboardItem = null; this.LayoutRoot = dashboardLayoutGroup1; dashboardParameter1.Name = "Parameter1"; dashboardParameter1.Type = typeof(int); dashboardParameter1.Value = 0; dashboardParameter2.Name = "Parameter2"; dashboardParameter2.Type = typeof(string); dashboardParameter2.Value = "Name1"; this.Parameters.AddRange(new DevExpress.DashboardCommon.DashboardParameter[] { dashboardParameter1, dashboardParameter2 }); this.Title.Text = "Dashboard"; ((System.ComponentModel.ISupportInitialize)(measure1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.bindingSource1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dashboardObjectDataSource1)).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.Measure measure2 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.Card card1 = new DevExpress.DashboardCommon.Card(); DevExpress.DashboardCommon.CardStretchedLayoutTemplate cardStretchedLayoutTemplate1 = new DevExpress.DashboardCommon.CardStretchedLayoutTemplate(); DevExpress.DashboardCommon.Dimension dimension1 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Dimension dimension2 = new DevExpress.DashboardCommon.Dimension(); 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.ChartPane chartPane1 = new DevExpress.DashboardCommon.ChartPane(); DevExpress.DashboardCommon.SimpleSeries simpleSeries1 = 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.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.CustomExpression customExpression1 = new DevExpress.DataAccess.Sql.CustomExpression(); DevExpress.DataAccess.Sql.Column column11 = new DevExpress.DataAccess.Sql.Column(); DevExpress.DataAccess.Sql.ColumnExpression columnExpression10 = new DevExpress.DataAccess.Sql.ColumnExpression(); DevExpress.DataAccess.Sql.QueryParameter queryParameter1 = new DevExpress.DataAccess.Sql.QueryParameter(); 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(ApartmentDashboard)); DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup1 = new DevExpress.DashboardCommon.DashboardLayoutGroup(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem1 = new DevExpress.DashboardCommon.DashboardLayoutItem(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem2 = new DevExpress.DashboardCommon.DashboardLayoutItem(); DevExpress.DashboardCommon.DashboardParameter dashboardParameter1 = new DevExpress.DashboardCommon.DashboardParameter(); this.cardDashboardItem1 = new DevExpress.DashboardCommon.CardDashboardItem(); this.chartDashboardItem1 = new DevExpress.DashboardCommon.ChartDashboardItem(); this.dashboardSqlDataSource1 = new DevExpress.DashboardCommon.DashboardSqlDataSource(); ((System.ComponentModel.ISupportInitialize)(this.cardDashboardItem1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension4)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // cardDashboardItem1 // measure1.DataMember = "CostOfKv"; measure2.DataMember = "Cost"; 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", measure1); card1.AddDataItem("TargetValue", measure2); this.cardDashboardItem1.Cards.AddRange(new DevExpress.DashboardCommon.Card[] { card1 }); this.cardDashboardItem1.ComponentName = "cardDashboardItem1"; dimension1.DataMember = "Information"; dimension2.DataMember = "Url"; dimension3.DataMember = "CostOfKv"; this.cardDashboardItem1.DataItemRepository.Clear(); this.cardDashboardItem1.DataItemRepository.Add(dimension1, "DataItem2"); this.cardDashboardItem1.DataItemRepository.Add(dimension2, "DataItem3"); this.cardDashboardItem1.DataItemRepository.Add(dimension3, "DataItem5"); this.cardDashboardItem1.DataItemRepository.Add(measure1, "DataItem1"); this.cardDashboardItem1.DataItemRepository.Add(measure2, "DataItem0"); this.cardDashboardItem1.DataMember = "Realties"; this.cardDashboardItem1.DataSource = this.dashboardSqlDataSource1; this.cardDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false; this.cardDashboardItem1.Name = "Cards 1"; this.cardDashboardItem1.SeriesDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension2, dimension1 }); this.cardDashboardItem1.ShowCaption = true; this.cardDashboardItem1.SparklineArgument = dimension3; // // chartDashboardItem1 // dimension4.DataMember = "Url"; this.chartDashboardItem1.Arguments.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension4 }); this.chartDashboardItem1.AxisX.TitleVisible = false; this.chartDashboardItem1.ComponentName = "chartDashboardItem1"; measure3.DataMember = "CostOfKv"; this.chartDashboardItem1.DataItemRepository.Clear(); this.chartDashboardItem1.DataItemRepository.Add(measure3, "DataItem0"); this.chartDashboardItem1.DataItemRepository.Add(dimension4, "DataItem1"); this.chartDashboardItem1.DataMember = "Realties"; 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.AddDataItem("Value", measure3); chartPane1.Series.AddRange(new DevExpress.DashboardCommon.ChartSeries[] { simpleSeries1 }); this.chartDashboardItem1.Panes.AddRange(new DevExpress.DashboardCommon.ChartPane[] { chartPane1 }); this.chartDashboardItem1.ShowCaption = true; // // dashboardSqlDataSource1 // calculatedField1.DataMember = "Realties"; calculatedField1.Expression = "Avg([CostOfKv])"; calculatedField1.Name = "Avg"; this.dashboardSqlDataSource1.CalculatedFields.AddRange(new DevExpress.DashboardCommon.CalculatedField[] { calculatedField1 }); this.dashboardSqlDataSource1.ComponentName = "dashboardSqlDataSource1"; this.dashboardSqlDataSource1.ConnectionName = "localhost_Apartment_Connection"; msSqlConnectionParameters1.AuthorizationType = DevExpress.DataAccess.ConnectionParameters.MsSqlAuthorizationType.Windows; msSqlConnectionParameters1.DatabaseName = "Apartment"; msSqlConnectionParameters1.ServerName = "localhost"; this.dashboardSqlDataSource1.ConnectionParameters = msSqlConnectionParameters1; this.dashboardSqlDataSource1.Name = "SQL Data Source 1"; columnExpression1.ColumnName = "Name"; table1.MetaSerializable = "<Meta X=\"220\" Y=\"40\" Width=\"125\" Height=\"115\" />"; table1.Name = "Areas"; columnExpression1.Table = table1; column1.Expression = columnExpression1; columnExpression2.ColumnName = "Information"; table2.MetaSerializable = "<Meta X=\"30\" Y=\"30\" Width=\"125\" Height=\"305\" />"; table2.Name = "Realties"; columnExpression2.Table = table2; column2.Expression = columnExpression2; columnExpression3.ColumnName = "Cost"; columnExpression3.Table = table2; column3.Expression = columnExpression3; columnExpression4.ColumnName = "RoomCount"; columnExpression4.Table = table2; column4.Expression = columnExpression4; columnExpression5.ColumnName = "Url"; columnExpression5.Table = table2; column5.Expression = columnExpression5; columnExpression6.ColumnName = "Comment"; columnExpression6.Table = table2; column6.Expression = columnExpression6; columnExpression7.ColumnName = "Series"; columnExpression7.Table = table2; column7.Expression = columnExpression7; columnExpression8.ColumnName = "DateRegistration"; columnExpression8.Table = table2; column8.Expression = columnExpression8; columnExpression9.ColumnName = "Area"; columnExpression9.Table = table2; column9.Expression = columnExpression9; column10.Alias = "CostOfKv"; customExpression1.Expression = "[Realties.Cost]/[Realties.Area]"; column10.Expression = customExpression1; columnExpression10.ColumnName = "Id"; columnExpression10.Table = table1; column11.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.Columns.Add(column11); selectQuery1.FilterString = "[Realties.Cost] Is Not Null And [Realties.Area] Is Not Null And [Realties.Area] <" + "> 0s And [Areas.Id] = ?IdArea"; selectQuery1.GroupFilterString = ""; selectQuery1.Name = "Realties"; queryParameter1.Name = "IdArea"; queryParameter1.Type = typeof(DevExpress.DataAccess.Expression); queryParameter1.Value = new DevExpress.DataAccess.Expression("?IdArea", typeof(int)); selectQuery1.Parameters.Add(queryParameter1); relationColumnInfo1.NestedKeyColumn = "Id"; relationColumnInfo1.ParentKeyColumn = "IdArea"; join1.KeyColumns.Add(relationColumnInfo1); join1.Nested = table1; join1.Parent = table2; selectQuery1.Relations.Add(join1); selectQuery1.Tables.Add(table2); selectQuery1.Tables.Add(table1); this.dashboardSqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { selectQuery1 }); this.dashboardSqlDataSource1.ResultSchemaSerializable = resources.GetString("dashboardSqlDataSource1.ResultSchemaSerializable"); // // ApartmentDashboard // this.DataSources.AddRange(new DevExpress.DashboardCommon.IDashboardDataSource[] { this.dashboardSqlDataSource1 }); this.Items.AddRange(new DevExpress.DashboardCommon.DashboardItem[] { this.cardDashboardItem1, this.chartDashboardItem1 }); dashboardLayoutItem1.DashboardItem = this.cardDashboardItem1; dashboardLayoutItem1.Weight = 0.25D; dashboardLayoutItem2.DashboardItem = this.chartDashboardItem1; dashboardLayoutItem2.Weight = 0.25D; dashboardLayoutGroup1.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] { dashboardLayoutItem1, dashboardLayoutItem2 }); dashboardLayoutGroup1.DashboardItem = null; dashboardLayoutGroup1.Weight = 100D; this.LayoutRoot = dashboardLayoutGroup1; dashboardParameter1.Name = "IdArea"; dashboardParameter1.Type = typeof(int); dashboardParameter1.Value = 7; this.Parameters.AddRange(new DevExpress.DashboardCommon.DashboardParameter[] { dashboardParameter1 }); this.Title.Text = "Dashboard"; ((System.ComponentModel.ISupportInitialize)(measure1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.cardDashboardItem1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension4)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).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.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() { DevExpress.DashboardCommon.Measure measure1 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.Measure measure2 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.Card card1 = new DevExpress.DashboardCommon.Card(); DevExpress.DashboardCommon.CardStretchedLayoutTemplate cardStretchedLayoutTemplate1 = new DevExpress.DashboardCommon.CardStretchedLayoutTemplate(); DevExpress.DashboardCommon.Dimension dimension1 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Dimension dimension2 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Measure measure3 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.Measure measure4 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.Dimension dimension3 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.ChartPane chartPane1 = new DevExpress.DashboardCommon.ChartPane(); DevExpress.DashboardCommon.SimpleSeries simpleSeries1 = new DevExpress.DashboardCommon.SimpleSeries(); DevExpress.DashboardCommon.SimpleSeries simpleSeries2 = new DevExpress.DashboardCommon.SimpleSeries(); DevExpress.DashboardCommon.ChartPane chartPane2 = new DevExpress.DashboardCommon.ChartPane(); DevExpress.DashboardCommon.Dimension dimension4 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Measure measure5 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.Measure measure6 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.Gauge gauge1 = new DevExpress.DashboardCommon.Gauge(); DevExpress.DashboardCommon.Measure measure7 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.Measure measure8 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.Gauge gauge2 = new DevExpress.DashboardCommon.Gauge(); DevExpress.DashboardCommon.Measure measure9 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.Gauge gauge3 = new DevExpress.DashboardCommon.Gauge(); DevExpress.DashboardCommon.CalculatedField calculatedField1 = new DevExpress.DashboardCommon.CalculatedField(); DevExpress.DataAccess.ConnectionParameters.MsSqlConnectionParameters msSqlConnectionParameters1 = new DevExpress.DataAccess.ConnectionParameters.MsSqlConnectionParameters(); DevExpress.DataAccess.Sql.StoredProcQuery storedProcQuery1 = new DevExpress.DataAccess.Sql.StoredProcQuery(); DevExpress.DataAccess.Sql.QueryParameter queryParameter1 = new DevExpress.DataAccess.Sql.QueryParameter(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Dashboard_principal)); 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.DashboardLayoutGroup dashboardLayoutGroup3 = new DevExpress.DashboardCommon.DashboardLayoutGroup(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem2 = new DevExpress.DashboardCommon.DashboardLayoutItem(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem3 = new DevExpress.DashboardCommon.DashboardLayoutItem(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem4 = new DevExpress.DashboardCommon.DashboardLayoutItem(); DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup4 = new DevExpress.DashboardCommon.DashboardLayoutGroup(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem5 = new DevExpress.DashboardCommon.DashboardLayoutItem(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem6 = new DevExpress.DashboardCommon.DashboardLayoutItem(); DevExpress.DashboardCommon.DashboardParameter dashboardParameter1 = new DevExpress.DashboardCommon.DashboardParameter(); this.cardDashboardItem1 = new DevExpress.DashboardCommon.CardDashboardItem(); this.chartDashboardItem1 = new DevExpress.DashboardCommon.ChartDashboardItem(); this.listBoxDashboardItem1 = new DevExpress.DashboardCommon.ListBoxDashboardItem(); this.gaugeDashboardItem2 = new DevExpress.DashboardCommon.GaugeDashboardItem(); this.gaugeDashboardItem1 = new DevExpress.DashboardCommon.GaugeDashboardItem(); this.gaugeDashboardItem3 = new DevExpress.DashboardCommon.GaugeDashboardItem(); this.dashboardSqlDataSource1 = new DevExpress.DashboardCommon.DashboardSqlDataSource(); ((System.ComponentModel.ISupportInitialize)(this.cardDashboardItem1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure4)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.listBoxDashboardItem1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension4)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.gaugeDashboardItem2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure5)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure6)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.gaugeDashboardItem1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure7)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure8)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.gaugeDashboardItem3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure9)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // cardDashboardItem1 // measure1.DataMember = "VALORPRESUPUESTADO"; measure1.NumericFormat.FormatType = DevExpress.DashboardCommon.DataItemNumericFormatType.Number; measure1.NumericFormat.IncludeGroupSeparator = true; measure1.NumericFormat.Unit = DevExpress.DashboardCommon.DataItemNumericUnit.Ones; measure2.DataMember = "VALOREJECUTADO"; measure2.NumericFormat.FormatType = DevExpress.DashboardCommon.DataItemNumericFormatType.Number; measure2.NumericFormat.IncludeGroupSeparator = true; measure2.NumericFormat.Unit = DevExpress.DashboardCommon.DataItemNumericUnit.Ones; card1.AbsoluteVariationNumericFormat.IncludeGroupSeparator = true; card1.AbsoluteVariationNumericFormat.Unit = DevExpress.DashboardCommon.DataItemNumericUnit.Ones; 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.SparklineOptions.ViewType = DevExpress.DashboardCommon.SparklineViewType.Area; card1.AddDataItem("ActualValue", measure1); card1.AddDataItem("TargetValue", measure2); this.cardDashboardItem1.Cards.AddRange(new DevExpress.DashboardCommon.Card[] { card1 }); this.cardDashboardItem1.ComponentName = "cardDashboardItem1"; dimension1.DataMember = "DESCRIPCION"; this.cardDashboardItem1.DataItemRepository.Clear(); this.cardDashboardItem1.DataItemRepository.Add(measure1, "DataItem2"); this.cardDashboardItem1.DataItemRepository.Add(measure2, "DataItem1"); this.cardDashboardItem1.DataItemRepository.Add(dimension1, "DataItem0"); this.cardDashboardItem1.DataMember = "SP_KPI_PRINCIPAL"; this.cardDashboardItem1.DataSource = this.dashboardSqlDataSource1; this.cardDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false; this.cardDashboardItem1.Name = "Desviación Acumulada por Item de Costo"; this.cardDashboardItem1.SeriesDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension1 }); this.cardDashboardItem1.ShowCaption = true; // // chartDashboardItem1 // dimension2.DataMember = "PERIODO"; this.chartDashboardItem1.Arguments.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension2 }); this.chartDashboardItem1.AxisX.EnableZooming = true; this.chartDashboardItem1.AxisX.TitleVisible = true; this.chartDashboardItem1.ComponentName = "chartDashboardItem1"; measure3.DataMember = "VALOREJECUTADO"; measure3.Name = "Ejecutado"; measure3.NumericFormat.FormatType = DevExpress.DashboardCommon.DataItemNumericFormatType.Number; measure3.NumericFormat.IncludeGroupSeparator = true; measure3.NumericFormat.Unit = DevExpress.DashboardCommon.DataItemNumericUnit.Ones; measure4.DataMember = "VALORPRESUPUESTADO"; measure4.Name = "Presupuestado"; measure4.NumericFormat.FormatType = DevExpress.DashboardCommon.DataItemNumericFormatType.Number; measure4.NumericFormat.IncludeGroupSeparator = true; measure4.NumericFormat.Unit = DevExpress.DashboardCommon.DataItemNumericUnit.Ones; dimension3.DataMember = "DESCRIPCION"; dimension3.Name = "Item de Costo"; this.chartDashboardItem1.DataItemRepository.Clear(); this.chartDashboardItem1.DataItemRepository.Add(measure3, "DataItem1"); this.chartDashboardItem1.DataItemRepository.Add(measure4, "DataItem2"); this.chartDashboardItem1.DataItemRepository.Add(dimension2, "DataItem0"); this.chartDashboardItem1.DataItemRepository.Add(dimension3, "DataItem3"); this.chartDashboardItem1.DataMember = "SP_KPI_PRINCIPAL"; this.chartDashboardItem1.DataSource = this.dashboardSqlDataSource1; this.chartDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false; this.chartDashboardItem1.Legend.InsidePosition = DevExpress.DashboardCommon.ChartLegendInsidePosition.BottomRightVertical; this.chartDashboardItem1.Legend.OutsidePosition = DevExpress.DashboardCommon.ChartLegendOutsidePosition.TopLeftHorizontal; this.chartDashboardItem1.Name = "Resumen Desviación Mensual"; chartPane1.Name = "Panel 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", measure3); simpleSeries2.SeriesType = DevExpress.DashboardCommon.SimpleSeriesType.Line; simpleSeries2.AddDataItem("Value", measure4); chartPane1.Series.AddRange(new DevExpress.DashboardCommon.ChartSeries[] { simpleSeries1, simpleSeries2 }); chartPane2.Name = "Panel 2"; chartPane2.PrimaryAxisY.AlwaysShowZeroLevel = true; chartPane2.PrimaryAxisY.ShowGridLines = true; chartPane2.PrimaryAxisY.TitleVisible = true; chartPane2.SecondaryAxisY.AlwaysShowZeroLevel = true; chartPane2.SecondaryAxisY.ShowGridLines = false; chartPane2.SecondaryAxisY.TitleVisible = true; this.chartDashboardItem1.Panes.AddRange(new DevExpress.DashboardCommon.ChartPane[] { chartPane1, chartPane2 }); this.chartDashboardItem1.SeriesDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension3 }); this.chartDashboardItem1.ShowCaption = true; // // listBoxDashboardItem1 // this.listBoxDashboardItem1.ComponentName = "listBoxDashboardItem1"; dimension4.DataMember = "DESCRIPCION"; this.listBoxDashboardItem1.DataItemRepository.Clear(); this.listBoxDashboardItem1.DataItemRepository.Add(dimension4, "DataItem0"); this.listBoxDashboardItem1.DataMember = "SP_KPI_PRINCIPAL"; this.listBoxDashboardItem1.DataSource = this.dashboardSqlDataSource1; this.listBoxDashboardItem1.FilterDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension4 }); this.listBoxDashboardItem1.InteractivityOptions.IgnoreMasterFilters = true; this.listBoxDashboardItem1.Name = "Item de Costo"; this.listBoxDashboardItem1.ShowCaption = true; // // gaugeDashboardItem2 // this.gaugeDashboardItem2.ComponentName = "gaugeDashboardItem2"; measure5.DataMember = "PRESUPUESTOTOTAL"; measure5.SummaryType = DevExpress.DashboardCommon.SummaryType.Average; measure6.DataMember = "VALOREJECUTADO"; this.gaugeDashboardItem2.DataItemRepository.Clear(); this.gaugeDashboardItem2.DataItemRepository.Add(measure5, "DataItem0"); this.gaugeDashboardItem2.DataItemRepository.Add(measure6, "DataItem1"); this.gaugeDashboardItem2.DataMember = "SP_KPI_PRINCIPAL"; this.gaugeDashboardItem2.DataSource = this.dashboardSqlDataSource1; gauge1.DeltaOptions.ResultIndicationThresholdType = DevExpress.DashboardCommon.DeltaIndicationThresholdType.Absolute; gauge1.Name = " Saldo"; gauge1.AddDataItem("ActualValue", measure5); gauge1.AddDataItem("TargetValue", measure6); this.gaugeDashboardItem2.Gauges.AddRange(new DevExpress.DashboardCommon.Gauge[] { gauge1 }); this.gaugeDashboardItem2.InteractivityOptions.IgnoreMasterFilters = false; this.gaugeDashboardItem2.Name = "Presupuesto Restante"; this.gaugeDashboardItem2.ShowCaption = true; this.gaugeDashboardItem2.ViewType = DevExpress.DashboardCommon.GaugeViewType.CircularHalf; // // gaugeDashboardItem1 // this.gaugeDashboardItem1.ComponentName = "gaugeDashboardItem1"; measure7.DataMember = "VALOREJECUTADO"; measure7.NumericFormat.FormatType = DevExpress.DashboardCommon.DataItemNumericFormatType.Number; measure7.NumericFormat.IncludeGroupSeparator = true; measure7.NumericFormat.Unit = DevExpress.DashboardCommon.DataItemNumericUnit.Ones; measure8.DataMember = "PRESUPUESTOTOTAL"; measure8.SummaryType = DevExpress.DashboardCommon.SummaryType.Average; this.gaugeDashboardItem1.DataItemRepository.Clear(); this.gaugeDashboardItem1.DataItemRepository.Add(measure7, "DataItem1"); this.gaugeDashboardItem1.DataItemRepository.Add(measure8, "DataItem0"); this.gaugeDashboardItem1.DataMember = "SP_KPI_PRINCIPAL"; this.gaugeDashboardItem1.DataSource = this.dashboardSqlDataSource1; gauge2.DeltaOptions.ValueType = DevExpress.DashboardCommon.DeltaValueType.ActualValue; gauge2.Name = "Ejecutado"; gauge2.AddDataItem("ActualValue", measure7); gauge2.AddDataItem("TargetValue", measure8); this.gaugeDashboardItem1.Gauges.AddRange(new DevExpress.DashboardCommon.Gauge[] { gauge2 }); this.gaugeDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false; this.gaugeDashboardItem1.Name = "Presupuesto ejecutado"; this.gaugeDashboardItem1.ShowCaption = true; this.gaugeDashboardItem1.ViewType = DevExpress.DashboardCommon.GaugeViewType.CircularHalf; // // gaugeDashboardItem3 // this.gaugeDashboardItem3.ComponentName = "gaugeDashboardItem3"; measure9.DataMember = "porcentajedeejecucion"; measure9.Name = "Porcentaje de Ejecución"; measure9.NumericFormat.FormatType = DevExpress.DashboardCommon.DataItemNumericFormatType.Percent; measure9.NumericFormat.IncludeGroupSeparator = true; measure9.NumericFormat.Unit = DevExpress.DashboardCommon.DataItemNumericUnit.Ones; this.gaugeDashboardItem3.DataItemRepository.Clear(); this.gaugeDashboardItem3.DataItemRepository.Add(measure9, "DataItem0"); this.gaugeDashboardItem3.DataMember = "SP_KPI_PRINCIPAL"; this.gaugeDashboardItem3.DataSource = this.dashboardSqlDataSource1; gauge3.Maximum = 100D; gauge3.Minimum = 0D; gauge3.Name = " "; gauge3.AddDataItem("TargetValue", measure9); this.gaugeDashboardItem3.Gauges.AddRange(new DevExpress.DashboardCommon.Gauge[] { gauge3 }); this.gaugeDashboardItem3.InteractivityOptions.IgnoreMasterFilters = false; this.gaugeDashboardItem3.Name = "Porcentaje de Ejecución de Presupuesto"; this.gaugeDashboardItem3.ShowCaption = true; this.gaugeDashboardItem3.ViewType = DevExpress.DashboardCommon.GaugeViewType.CircularHalf; // // dashboardSqlDataSource1 // calculatedField1.DataMember = "SP_KPI_PRINCIPAL"; calculatedField1.Expression = "Sum([VALOREJECUTADO]) / (Avg([PRESUPUESTOTOTAL]) - Sum([VALOREJECUTADO]))"; calculatedField1.Name = "porcentajedeejecucion"; this.dashboardSqlDataSource1.CalculatedFields.AddRange(new DevExpress.DashboardCommon.CalculatedField[] { calculatedField1 }); this.dashboardSqlDataSource1.ComponentName = "dashboardSqlDataSource1"; this.dashboardSqlDataSource1.ConnectionName = "localhost_PRESUPUESTO_Connection"; msSqlConnectionParameters1.AuthorizationType = DevExpress.DataAccess.ConnectionParameters.MsSqlAuthorizationType.SqlServer; msSqlConnectionParameters1.DatabaseName = "PRESUPUESTO"; msSqlConnectionParameters1.ServerName = "181.176.187.68\\BDNISIRA"; this.dashboardSqlDataSource1.ConnectionParameters = msSqlConnectionParameters1; this.dashboardSqlDataSource1.Name = "Origen de datos SQL 1"; storedProcQuery1.Name = "SP_KPI_PRINCIPAL"; queryParameter1.Name = "@IDMONEDA"; queryParameter1.Type = typeof(string); queryParameter1.ValueInfo = "02"; storedProcQuery1.Parameters.Add(queryParameter1); storedProcQuery1.StoredProcName = "SP_KPI_PRINCIPAL"; this.dashboardSqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { storedProcQuery1 }); this.dashboardSqlDataSource1.ResultSchemaSerializable = resources.GetString("dashboardSqlDataSource1.ResultSchemaSerializable"); // // Dashboard2 // this.DataSources.AddRange(new DevExpress.DashboardCommon.IDashboardDataSource[] { this.dashboardSqlDataSource1 }); this.Items.AddRange(new DevExpress.DashboardCommon.DashboardItem[] { this.cardDashboardItem1, this.chartDashboardItem1, this.listBoxDashboardItem1, this.gaugeDashboardItem2, this.gaugeDashboardItem1, this.gaugeDashboardItem3 }); dashboardLayoutItem1.DashboardItem = this.chartDashboardItem1; dashboardLayoutItem1.Weight = 77.162629757785467D; dashboardLayoutItem2.DashboardItem = this.gaugeDashboardItem3; dashboardLayoutItem2.Weight = 35.379061371841154D; dashboardLayoutItem3.DashboardItem = this.gaugeDashboardItem2; dashboardLayoutItem3.Weight = 31.588447653429604D; dashboardLayoutItem4.DashboardItem = this.gaugeDashboardItem1; dashboardLayoutItem4.Weight = 33.032490974729242D; dashboardLayoutGroup3.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] { dashboardLayoutItem2, dashboardLayoutItem3, dashboardLayoutItem4 }); dashboardLayoutGroup3.DashboardItem = null; dashboardLayoutGroup3.Orientation = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical; dashboardLayoutGroup3.Weight = 22.837370242214533D; dashboardLayoutGroup2.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] { dashboardLayoutItem1, dashboardLayoutGroup3 }); dashboardLayoutGroup2.DashboardItem = null; dashboardLayoutGroup2.Weight = 61.830357142857146D; dashboardLayoutItem5.DashboardItem = this.cardDashboardItem1; dashboardLayoutItem5.Weight = 77.162629757785467D; dashboardLayoutItem6.DashboardItem = this.listBoxDashboardItem1; dashboardLayoutItem6.Weight = 22.837370242214533D; dashboardLayoutGroup4.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] { dashboardLayoutItem5, dashboardLayoutItem6 }); dashboardLayoutGroup4.DashboardItem = null; dashboardLayoutGroup4.Weight = 38.169642857142854D; dashboardLayoutGroup1.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] { dashboardLayoutGroup2, dashboardLayoutGroup4 }); dashboardLayoutGroup1.DashboardItem = null; dashboardLayoutGroup1.Orientation = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical; this.LayoutRoot = dashboardLayoutGroup1; dashboardParameter1.Name = "MONEDA"; dashboardParameter1.Type = typeof(string); dashboardParameter1.Value = ""; this.Parameters.AddRange(new DevExpress.DashboardCommon.DashboardParameter[] { dashboardParameter1 }); this.Title.Text = "Tablero de control"; ((System.ComponentModel.ISupportInitialize)(measure1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.cardDashboardItem1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure4)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension4)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.listBoxDashboardItem1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure5)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure6)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.gaugeDashboardItem2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure7)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure8)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.gaugeDashboardItem1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure9)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.gaugeDashboardItem3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).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.Dimension dimension2 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Dimension dimension3 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Dimension dimension4 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Measure measure1 = new DevExpress.DashboardCommon.Measure(); 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.SimpleSeries simpleSeries2 = new DevExpress.DashboardCommon.SimpleSeries(); DevExpress.DashboardCommon.CalculatedField calculatedField1 = new DevExpress.DashboardCommon.CalculatedField(); 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(dash_pro_profile)); DevExpress.DashboardCommon.Dimension dimension5 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Dimension dimension6 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Measure measure3 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.Measure measure4 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.Dimension dimension7 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Dimension dimension8 = new DevExpress.DashboardCommon.Dimension(); 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.Dimension dimension12 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Dimension dimension13 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Measure measure5 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.Dimension dimension14 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Dimension dimension15 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Measure measure6 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.Dimension dimension16 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Dimension dimension17 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Dimension dimension18 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Measure measure7 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.Measure measure8 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.Dimension dimension19 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Dimension dimension20 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Dimension dimension21 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Measure measure9 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.PivotWindowDefinition pivotWindowDefinition1 = new DevExpress.DashboardCommon.PivotWindowDefinition(); DevExpress.DashboardCommon.PivotItemFormatRule pivotItemFormatRule1 = new DevExpress.DashboardCommon.PivotItemFormatRule(); DevExpress.DashboardCommon.FormatConditionValue formatConditionValue1 = new DevExpress.DashboardCommon.FormatConditionValue(); DevExpress.DashboardCommon.AppearanceSettings appearanceSettings1 = new DevExpress.DashboardCommon.AppearanceSettings(); DevExpress.DashboardCommon.PivotItemFormatRule pivotItemFormatRule2 = new DevExpress.DashboardCommon.PivotItemFormatRule(); DevExpress.DashboardCommon.FormatConditionValue formatConditionValue2 = new DevExpress.DashboardCommon.FormatConditionValue(); DevExpress.DashboardCommon.AppearanceSettings appearanceSettings2 = new DevExpress.DashboardCommon.AppearanceSettings(); DevExpress.DashboardCommon.PivotItemFormatRule pivotItemFormatRule3 = new DevExpress.DashboardCommon.PivotItemFormatRule(); DevExpress.DashboardCommon.FormatConditionValue formatConditionValue3 = new DevExpress.DashboardCommon.FormatConditionValue(); DevExpress.DashboardCommon.AppearanceSettings appearanceSettings3 = new DevExpress.DashboardCommon.AppearanceSettings(); DevExpress.DashboardCommon.PivotItemFormatRule pivotItemFormatRule4 = new DevExpress.DashboardCommon.PivotItemFormatRule(); DevExpress.DashboardCommon.FormatConditionValue formatConditionValue4 = new DevExpress.DashboardCommon.FormatConditionValue(); DevExpress.DashboardCommon.IconSettings iconSettings1 = new DevExpress.DashboardCommon.IconSettings(); DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup1 = new DevExpress.DashboardCommon.DashboardLayoutGroup(); DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup2 = new DevExpress.DashboardCommon.DashboardLayoutGroup(); DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup3 = new DevExpress.DashboardCommon.DashboardLayoutGroup(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem1 = new DevExpress.DashboardCommon.DashboardLayoutItem(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem2 = new DevExpress.DashboardCommon.DashboardLayoutItem(); DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup4 = new DevExpress.DashboardCommon.DashboardLayoutGroup(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem3 = new DevExpress.DashboardCommon.DashboardLayoutItem(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem4 = new DevExpress.DashboardCommon.DashboardLayoutItem(); DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem5 = new DevExpress.DashboardCommon.DashboardLayoutItem(); DevExpress.DashboardCommon.DashboardParameter dashboardParameter1 = new DevExpress.DashboardCommon.DashboardParameter(); this.chartDashboardItem1 = new DevExpress.DashboardCommon.ChartDashboardItem(); this.dashboardSqlDataSource1 = new DevExpress.DashboardCommon.DashboardSqlDataSource(); this.treeViewDashboardItem1 = new DevExpress.DashboardCommon.TreeViewDashboardItem(); this.pieDashboardItem1 = new DevExpress.DashboardCommon.PieDashboardItem(); this.pieDashboardItem2 = new DevExpress.DashboardCommon.PieDashboardItem(); this.pivotDashboardItem1 = new DevExpress.DashboardCommon.PivotDashboardItem(); ((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension4)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.treeViewDashboardItem1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension5)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension6)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure4)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension7)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension8)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension9)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension10)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.pieDashboardItem1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension11)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension12)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension13)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure5)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.pieDashboardItem2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension14)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension15)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure6)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension16)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.pivotDashboardItem1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension17)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension18)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure7)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure8)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension19)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension20)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension21)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure9)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // chartDashboardItem1 // dimension1.DataMember = "area_identifier"; dimension2.DataMember = "bp_name"; dimension3.DataMember = "stan_standard"; dimension3.SortOrder = DevExpress.DashboardCommon.DimensionSortOrder.Descending; this.chartDashboardItem1.Arguments.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension1, dimension2, dimension3 }); this.chartDashboardItem1.AxisX.EnableZooming = true; this.chartDashboardItem1.AxisX.TitleVisible = false; this.chartDashboardItem1.ComponentName = "chartDashboardItem1"; dimension4.DataMember = "area_name"; measure1.DataMember = "score_col1"; measure1.Name = "As-Is"; measure1.SummaryType = DevExpress.DashboardCommon.SummaryType.Min; measure2.DataMember = "score_col2"; measure2.Name = "To-Be"; measure2.SummaryType = DevExpress.DashboardCommon.SummaryType.Min; this.chartDashboardItem1.DataItemRepository.Clear(); this.chartDashboardItem1.DataItemRepository.Add(dimension4, "DataItem0"); this.chartDashboardItem1.DataItemRepository.Add(dimension2, "DataItem1"); this.chartDashboardItem1.DataItemRepository.Add(dimension3, "DataItem2"); this.chartDashboardItem1.DataItemRepository.Add(measure1, "DataItem3"); this.chartDashboardItem1.DataItemRepository.Add(dimension1, "DataItem5"); this.chartDashboardItem1.DataItemRepository.Add(measure2, "DataItem4"); this.chartDashboardItem1.DataMember = "modified_felipe"; this.chartDashboardItem1.DataSource = this.dashboardSqlDataSource1; this.chartDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false; this.chartDashboardItem1.InteractivityOptions.IsDrillDownEnabled = true; this.chartDashboardItem1.Name = "Capability Scores"; 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.PointLabelOptions.ContentType = DevExpress.DashboardCommon.PointLabelContentTypeEx.Value; simpleSeries1.PointLabelOptions.Position = DevExpress.DashboardCommon.PointLabelPosition.Inside; simpleSeries1.PointLabelOptions.ShowForZeroValues = true; simpleSeries1.AddDataItem("Value", measure1); simpleSeries2.PointLabelOptions.ContentType = DevExpress.DashboardCommon.PointLabelContentTypeEx.Value; simpleSeries2.PointLabelOptions.Position = DevExpress.DashboardCommon.PointLabelPosition.Inside; simpleSeries2.PointLabelOptions.ShowForZeroValues = true; simpleSeries2.AddDataItem("Value", measure2); chartPane1.Series.AddRange(new DevExpress.DashboardCommon.ChartSeries[] { simpleSeries1, simpleSeries2 }); this.chartDashboardItem1.Panes.AddRange(new DevExpress.DashboardCommon.ChartPane[] { chartPane1 }); this.chartDashboardItem1.Rotated = true; this.chartDashboardItem1.SeriesDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension4 }); this.chartDashboardItem1.ShowCaption = true; // // dashboardSqlDataSource1 // calculatedField1.DataMember = "modified_felipe"; calculatedField1.Expression = "[score_col2] - [score_col1]"; calculatedField1.Name = "Calculated Field 1"; this.dashboardSqlDataSource1.CalculatedFields.AddRange(new DevExpress.DashboardCommon.CalculatedField[] { calculatedField1 }); this.dashboardSqlDataSource1.ComponentName = "dashboardSqlDataSource1"; this.dashboardSqlDataSource1.ConnectionName = "OhioDB"; this.dashboardSqlDataSource1.Name = "SQL Data Source 1"; customSqlQuery1.Name = "modified_felipe"; queryParameter1.Name = "projectID"; queryParameter1.Type = typeof(DevExpress.DataAccess.Expression); queryParameter1.Value = new DevExpress.DataAccess.Expression("[Parameters.projectID]", typeof(System.Guid)); 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"); // // treeViewDashboardItem1 // this.treeViewDashboardItem1.ComponentName = "treeViewDashboardItem1"; dimension5.DataMember = "value_scoretext"; dimension6.DataMember = "stan_standard"; measure3.DataMember = "score_col1"; measure3.SummaryType = DevExpress.DashboardCommon.SummaryType.Min; measure4.DataMember = "score_col2"; measure4.SummaryType = DevExpress.DashboardCommon.SummaryType.Min; dimension7.DataMember = "card_name"; dimension8.DataMember = "area_name"; dimension9.DataMember = "bp_name"; dimension10.DataMember = "value_score"; this.treeViewDashboardItem1.DataItemRepository.Clear(); this.treeViewDashboardItem1.DataItemRepository.Add(dimension5, "DataItem0"); this.treeViewDashboardItem1.DataItemRepository.Add(dimension6, "DataItem1"); this.treeViewDashboardItem1.DataItemRepository.Add(measure3, "DataItem2"); this.treeViewDashboardItem1.DataItemRepository.Add(measure4, "DataItem3"); this.treeViewDashboardItem1.DataItemRepository.Add(dimension7, "DataItem5"); this.treeViewDashboardItem1.DataItemRepository.Add(dimension8, "DataItem6"); this.treeViewDashboardItem1.DataItemRepository.Add(dimension9, "DataItem4"); this.treeViewDashboardItem1.DataItemRepository.Add(dimension10, "DataItem7"); this.treeViewDashboardItem1.DataMember = "modified_felipe"; this.treeViewDashboardItem1.DataSource = this.dashboardSqlDataSource1; this.treeViewDashboardItem1.EnableSearch = true; this.treeViewDashboardItem1.FilterDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension8, dimension9, dimension7, dimension6, dimension10, dimension5 }); this.treeViewDashboardItem1.HiddenMeasures.AddRange(new DevExpress.DashboardCommon.Measure[] { measure3, measure4 }); this.treeViewDashboardItem1.InteractivityOptions.IgnoreMasterFilters = true; this.treeViewDashboardItem1.Name = "Select Data to Visualize"; this.treeViewDashboardItem1.ShowCaption = true; // // pieDashboardItem1 // dimension11.DataMember = "bp_name"; dimension12.DataMember = "stan_standard"; this.pieDashboardItem1.Arguments.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension11, dimension12 }); this.pieDashboardItem1.ComponentName = "pieDashboardItem1"; dimension13.DataMember = "area_name"; dimension13.SortOrder = DevExpress.DashboardCommon.DimensionSortOrder.Descending; measure5.DataMember = "score_col1"; measure5.Name = "As-Is"; measure5.NumericFormat.FormatType = DevExpress.DashboardCommon.DataItemNumericFormatType.General; measure5.SummaryType = DevExpress.DashboardCommon.SummaryType.Min; this.pieDashboardItem1.DataItemRepository.Clear(); this.pieDashboardItem1.DataItemRepository.Add(dimension13, "DataItem2"); this.pieDashboardItem1.DataItemRepository.Add(measure5, "DataItem0"); this.pieDashboardItem1.DataItemRepository.Add(dimension11, "DataItem3"); this.pieDashboardItem1.DataItemRepository.Add(dimension12, "DataItem1"); this.pieDashboardItem1.DataMember = "modified_felipe"; this.pieDashboardItem1.DataSource = this.dashboardSqlDataSource1; this.pieDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false; this.pieDashboardItem1.InteractivityOptions.IsDrillDownEnabled = true; this.pieDashboardItem1.LabelContentType = ((DevExpress.DashboardCommon.PieValueType)((DevExpress.DashboardCommon.PieValueType.Argument | DevExpress.DashboardCommon.PieValueType.Value))); this.pieDashboardItem1.Name = "As-Is"; this.pieDashboardItem1.SeriesDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension13 }); this.pieDashboardItem1.ShowCaption = true; this.pieDashboardItem1.TooltipContentType = ((DevExpress.DashboardCommon.PieValueType)((DevExpress.DashboardCommon.PieValueType.Argument | DevExpress.DashboardCommon.PieValueType.Value))); this.pieDashboardItem1.Values.AddRange(new DevExpress.DashboardCommon.Measure[] { measure5 }); // // pieDashboardItem2 // dimension14.DataMember = "bp_name"; dimension15.DataMember = "stan_standard"; this.pieDashboardItem2.Arguments.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension14, dimension15 }); this.pieDashboardItem2.ComponentName = "pieDashboardItem2"; measure6.DataMember = "score_col2"; measure6.Name = "To-Be"; measure6.SummaryType = DevExpress.DashboardCommon.SummaryType.Min; dimension16.DataMember = "area_name"; this.pieDashboardItem2.DataItemRepository.Clear(); this.pieDashboardItem2.DataItemRepository.Add(measure6, "DataItem0"); this.pieDashboardItem2.DataItemRepository.Add(dimension16, "DataItem1"); this.pieDashboardItem2.DataItemRepository.Add(dimension14, "DataItem2"); this.pieDashboardItem2.DataItemRepository.Add(dimension15, "DataItem3"); this.pieDashboardItem2.DataMember = "modified_felipe"; this.pieDashboardItem2.DataSource = this.dashboardSqlDataSource1; this.pieDashboardItem2.InteractivityOptions.IgnoreMasterFilters = false; this.pieDashboardItem2.InteractivityOptions.IsDrillDownEnabled = true; this.pieDashboardItem2.LabelContentType = ((DevExpress.DashboardCommon.PieValueType)((DevExpress.DashboardCommon.PieValueType.Argument | DevExpress.DashboardCommon.PieValueType.Value))); this.pieDashboardItem2.Name = "To-Be"; this.pieDashboardItem2.SeriesDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension16 }); this.pieDashboardItem2.ShowCaption = true; this.pieDashboardItem2.Values.AddRange(new DevExpress.DashboardCommon.Measure[] { measure6 }); // // pivotDashboardItem1 // dimension17.DataMember = "card_col1"; dimension18.DataMember = "card_col2"; this.pivotDashboardItem1.Columns.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension17, dimension18 }); this.pivotDashboardItem1.ComponentName = "pivotDashboardItem1"; measure7.DataMember = "score_col1"; measure7.Name = "As-Is"; measure7.SummaryType = DevExpress.DashboardCommon.SummaryType.Min; measure8.DataMember = "score_col2"; measure8.Name = "To-Be"; measure8.SummaryType = DevExpress.DashboardCommon.SummaryType.Min; dimension19.DataMember = "card_name"; dimension20.DataMember = "stan_standard"; dimension21.DataMember = "area_name"; measure9.DataMember = "Calculated Field 1"; measure9.Expression = "Max([score_col2]) - Max([score_col1])"; measure9.Name = "Advancement Opportunity"; measure9.SummaryType = DevExpress.DashboardCommon.SummaryType.Max; pivotWindowDefinition1.DefinitionMode = DevExpress.DashboardCommon.PivotWindowDefinitionMode.Rows; measure9.WindowDefinition = pivotWindowDefinition1; this.pivotDashboardItem1.DataItemRepository.Clear(); this.pivotDashboardItem1.DataItemRepository.Add(measure7, "DataItem0"); this.pivotDashboardItem1.DataItemRepository.Add(measure8, "DataItem1"); this.pivotDashboardItem1.DataItemRepository.Add(dimension19, "DataItem6"); this.pivotDashboardItem1.DataItemRepository.Add(dimension17, "DataItem2"); this.pivotDashboardItem1.DataItemRepository.Add(dimension18, "DataItem4"); this.pivotDashboardItem1.DataItemRepository.Add(dimension20, "DataItem7"); this.pivotDashboardItem1.DataItemRepository.Add(dimension21, "DataItem3"); this.pivotDashboardItem1.DataItemRepository.Add(measure9, "DataItem8"); this.pivotDashboardItem1.DataMember = "modified_felipe"; this.pivotDashboardItem1.DataSource = this.dashboardSqlDataSource1; pivotItemFormatRule1.ApplyToRow = true; appearanceSettings1.AppearanceType = DevExpress.DashboardCommon.FormatConditionAppearanceType.Red; formatConditionValue1.StyleSettings = appearanceSettings1; formatConditionValue1.Value1 = 1; pivotItemFormatRule1.Condition = formatConditionValue1; pivotItemFormatRule1.DataItem = measure8; pivotItemFormatRule1.Name = "FormatRule 1"; pivotItemFormatRule2.ApplyToColumn = true; pivotItemFormatRule2.ApplyToRow = true; appearanceSettings2.AppearanceType = DevExpress.DashboardCommon.FormatConditionAppearanceType.Green; formatConditionValue2.StyleSettings = appearanceSettings2; formatConditionValue2.Value1 = 5; pivotItemFormatRule2.Condition = formatConditionValue2; pivotItemFormatRule2.DataItem = measure7; pivotItemFormatRule2.Name = "FormatRule 2"; pivotItemFormatRule3.ApplyToColumn = true; pivotItemFormatRule3.ApplyToRow = true; appearanceSettings3.AppearanceType = DevExpress.DashboardCommon.FormatConditionAppearanceType.Green; formatConditionValue3.StyleSettings = appearanceSettings3; formatConditionValue3.Value1 = 5; pivotItemFormatRule3.Condition = formatConditionValue3; pivotItemFormatRule3.DataItem = measure8; pivotItemFormatRule3.Name = "FormatRule 3"; formatConditionValue4.Condition = DevExpress.DashboardCommon.DashboardFormatCondition.Greater; iconSettings1.IconType = DevExpress.DashboardCommon.FormatConditionIconType.IndicatorGreenFlag; formatConditionValue4.StyleSettings = iconSettings1; formatConditionValue4.Value1 = 0; pivotItemFormatRule4.Condition = formatConditionValue4; pivotItemFormatRule4.DataItem = measure9; pivotItemFormatRule4.IntersectionLevelMode = DevExpress.DashboardCommon.FormatConditionIntersectionLevelMode.AllLevels; pivotItemFormatRule4.Name = "FormatRule 4"; this.pivotDashboardItem1.FormatRules.AddRange(new DevExpress.DashboardCommon.PivotItemFormatRule[] { pivotItemFormatRule1, pivotItemFormatRule2, pivotItemFormatRule3, pivotItemFormatRule4 }); this.pivotDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false; this.pivotDashboardItem1.LayoutType = DevExpress.DashboardCommon.PivotLayoutType.Compact; this.pivotDashboardItem1.Name = "Pivot 1"; this.pivotDashboardItem1.Rows.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension21, dimension19, dimension20 }); this.pivotDashboardItem1.ShowCaption = false; this.pivotDashboardItem1.ShowColumnGrandTotals = false; this.pivotDashboardItem1.ShowColumnTotals = false; this.pivotDashboardItem1.ShowRowGrandTotals = false; this.pivotDashboardItem1.ShowRowTotals = false; this.pivotDashboardItem1.Values.AddRange(new DevExpress.DashboardCommon.Measure[] { measure7, measure8, measure9 }); // // dash_pro_profile // this.DataSources.AddRange(new DevExpress.DashboardCommon.IDashboardDataSource[] { this.dashboardSqlDataSource1 }); this.Items.AddRange(new DevExpress.DashboardCommon.DashboardItem[] { this.treeViewDashboardItem1, this.pivotDashboardItem1, this.pieDashboardItem1, this.pieDashboardItem2, this.chartDashboardItem1 }); dashboardLayoutItem1.DashboardItem = this.treeViewDashboardItem1; dashboardLayoutItem1.Weight = 22.46153846153846D; dashboardLayoutItem2.DashboardItem = this.chartDashboardItem1; dashboardLayoutItem2.Weight = 77.538461538461533D; dashboardLayoutGroup3.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] { dashboardLayoutItem1, dashboardLayoutItem2 }); dashboardLayoutGroup3.DashboardItem = null; dashboardLayoutGroup3.Orientation = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical; dashboardLayoutGroup3.Weight = 42.476697736351532D; dashboardLayoutItem3.DashboardItem = this.pieDashboardItem1; dashboardLayoutItem3.Weight = 52.769230769230766D; dashboardLayoutItem4.DashboardItem = this.pieDashboardItem2; dashboardLayoutItem4.Weight = 47.230769230769234D; dashboardLayoutGroup4.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] { dashboardLayoutItem3, dashboardLayoutItem4 }); dashboardLayoutGroup4.DashboardItem = null; dashboardLayoutGroup4.Orientation = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical; dashboardLayoutGroup4.Weight = 57.523302263648468D; dashboardLayoutGroup2.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] { dashboardLayoutGroup3, dashboardLayoutGroup4 }); dashboardLayoutGroup2.DashboardItem = null; dashboardLayoutGroup2.Weight = 63.4765625D; dashboardLayoutItem5.DashboardItem = this.pivotDashboardItem1; dashboardLayoutItem5.Weight = 36.5234375D; dashboardLayoutGroup1.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] { dashboardLayoutGroup2, dashboardLayoutItem5 }); dashboardLayoutGroup1.DashboardItem = null; dashboardLayoutGroup1.Orientation = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical; this.LayoutRoot = dashboardLayoutGroup1; dashboardParameter1.Description = "Project"; dashboardParameter1.Name = "projectID"; dashboardParameter1.Type = typeof(System.Guid); dashboardParameter1.Value = new System.Guid("00000000-0000-0000-0000-000000000000"); dashboardParameter1.Visible = false; this.Parameters.AddRange(new DevExpress.DashboardCommon.DashboardParameter[] { dashboardParameter1 }); this.Title.ImageUrl = "https://rcxbox.readycert.net/Content/Images/logo.png"; this.Title.Text = "Business Process Profile"; ((System.ComponentModel.ISupportInitialize)(dimension1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension4)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension5)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension6)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure4)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension7)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension8)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension9)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension10)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.treeViewDashboardItem1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension11)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension12)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension13)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure5)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.pieDashboardItem1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension14)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension15)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure6)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension16)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.pieDashboardItem2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension17)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension18)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure7)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure8)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension19)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension20)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension21)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure9)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.pivotDashboardItem1)).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(); }
/// <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.Dimension dimension2 = 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.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(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(dash_workflow)); DevExpress.DashboardCommon.Measure measure2 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.Dimension dimension3 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Gauge gauge1 = new DevExpress.DashboardCommon.Gauge(); DevExpress.DashboardCommon.Dimension dimension4 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Dimension dimension5 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Dimension dimension6 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Measure measure3 = new DevExpress.DashboardCommon.Measure(); DevExpress.DashboardCommon.Dimension dimension7 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.Dimension dimension8 = new DevExpress.DashboardCommon.Dimension(); DevExpress.DashboardCommon.PivotItemFormatRule pivotItemFormatRule1 = new DevExpress.DashboardCommon.PivotItemFormatRule(); DevExpress.DashboardCommon.FormatConditionDateOccuring formatConditionDateOccuring1 = new DevExpress.DashboardCommon.FormatConditionDateOccuring(); DevExpress.DashboardCommon.IconSettings iconSettings1 = new DevExpress.DashboardCommon.IconSettings(); 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(); this.pieDashboardItem1 = new DevExpress.DashboardCommon.PieDashboardItem(); this.data_workflow = new DevExpress.DashboardCommon.DashboardSqlDataSource(); this.gaugeDashboardItem1 = new DevExpress.DashboardCommon.GaugeDashboardItem(); this.pivotDashboardItem1 = new DevExpress.DashboardCommon.PivotDashboardItem(); ((System.ComponentModel.ISupportInitialize)(this.pieDashboardItem1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.data_workflow)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.gaugeDashboardItem1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.pivotDashboardItem1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension4)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension5)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension6)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(measure3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension7)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(dimension8)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // pieDashboardItem1 // dimension1.DataMember = "Status"; this.pieDashboardItem1.Arguments.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension1 }); this.pieDashboardItem1.ComponentName = "pieDashboardItem1"; measure1.DataMember = "AssignedTo"; measure1.SummaryType = DevExpress.DashboardCommon.SummaryType.CountDistinct; dimension2.DataMember = "AssignedTo"; this.pieDashboardItem1.DataItemRepository.Clear(); this.pieDashboardItem1.DataItemRepository.Add(measure1, "DataItem0"); this.pieDashboardItem1.DataItemRepository.Add(dimension2, "DataItem2"); this.pieDashboardItem1.DataItemRepository.Add(dimension1, "DataItem1"); this.pieDashboardItem1.DataMember = "view_workflow_laststatus"; this.pieDashboardItem1.DataSource = this.data_workflow; this.pieDashboardItem1.FilterString = "[DataItem1] <> \'Unassugned\'"; this.pieDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false; this.pieDashboardItem1.LabelContentType = ((DevExpress.DashboardCommon.PieValueType)(((DevExpress.DashboardCommon.PieValueType.Argument | DevExpress.DashboardCommon.PieValueType.Percent) | DevExpress.DashboardCommon.PieValueType.Value))); this.pieDashboardItem1.Name = "Workflow Activities by Worker"; this.pieDashboardItem1.PieType = DevExpress.DashboardCommon.PieType.Donut; this.pieDashboardItem1.SeriesDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension2 }); this.pieDashboardItem1.ShowCaption = true; this.pieDashboardItem1.Values.AddRange(new DevExpress.DashboardCommon.Measure[] { measure1 }); // // data_workflow // this.data_workflow.ComponentName = "data_workflow"; this.data_workflow.ConnectionName = "DevDB"; this.data_workflow.Name = "CurrentWorkflow"; 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.FilterString = "Contains([view_workflow.AssignedTo], ?UserEmail)"; selectQuery1.GroupFilterString = ""; selectQuery1.Name = "view_workflow_laststatus"; queryParameter1.Name = "UserEmail"; queryParameter1.Type = typeof(DevExpress.DataAccess.Expression); queryParameter1.Value = new DevExpress.DataAccess.Expression("[Parameters.UserEmail]", typeof(string)); selectQuery1.Parameters.Add(queryParameter1); selectQuery1.Tables.Add(table1); this.data_workflow.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { selectQuery1 }); this.data_workflow.ResultSchemaSerializable = resources.GetString("data_workflow.ResultSchemaSerializable"); // // gaugeDashboardItem1 // this.gaugeDashboardItem1.ComponentName = "gaugeDashboardItem1"; measure2.DataMember = "Status"; measure2.Name = "Count of Workflow Items"; measure2.SummaryType = DevExpress.DashboardCommon.SummaryType.Count; dimension3.DataMember = "DueDate"; dimension3.DateTimeGroupInterval = DevExpress.DashboardCommon.DateTimeGroupInterval.QuarterYear; this.gaugeDashboardItem1.DataItemRepository.Clear(); this.gaugeDashboardItem1.DataItemRepository.Add(measure2, "DataItem0"); this.gaugeDashboardItem1.DataItemRepository.Add(dimension3, "DataItem1"); this.gaugeDashboardItem1.DataMember = "view_workflow_laststatus"; this.gaugeDashboardItem1.DataSource = this.data_workflow; gauge1.AddDataItem("ActualValue", measure2); this.gaugeDashboardItem1.Gauges.AddRange(new DevExpress.DashboardCommon.Gauge[] { gauge1 }); this.gaugeDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false; this.gaugeDashboardItem1.Name = "Count of Workflow Items per Quarter"; this.gaugeDashboardItem1.SeriesDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension3 }); this.gaugeDashboardItem1.ShowCaption = true; // // pivotDashboardItem1 // dimension4.DataMember = "Project"; dimension5.DataMember = "Status"; this.pivotDashboardItem1.Columns.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension4, dimension5 }); this.pivotDashboardItem1.ComponentName = "pivotDashboardItem1"; dimension6.DataMember = "AssignedTo"; measure3.DataMember = "AssignedTo"; measure3.SummaryType = DevExpress.DashboardCommon.SummaryType.Count; dimension7.DataMember = "RC_ID"; dimension8.DataMember = "RC_NAME"; this.pivotDashboardItem1.DataItemRepository.Clear(); this.pivotDashboardItem1.DataItemRepository.Add(dimension6, "DataItem0"); this.pivotDashboardItem1.DataItemRepository.Add(measure3, "DataItem2"); this.pivotDashboardItem1.DataItemRepository.Add(dimension4, "DataItem1"); this.pivotDashboardItem1.DataItemRepository.Add(dimension7, "DataItem4"); this.pivotDashboardItem1.DataItemRepository.Add(dimension8, "DataItem3"); this.pivotDashboardItem1.DataItemRepository.Add(dimension5, "DataItem5"); this.pivotDashboardItem1.DataMember = "view_workflow_laststatus"; this.pivotDashboardItem1.DataSource = this.data_workflow; this.pivotDashboardItem1.FilterString = "Not [DataItem5] In (\'Unassugned\')"; formatConditionDateOccuring1.DateType = ((DevExpress.XtraEditors.FilterDateType)(((((((DevExpress.XtraEditors.FilterDateType.Yesterday | DevExpress.XtraEditors.FilterDateType.EarlierThisWeek) | DevExpress.XtraEditors.FilterDateType.LastWeek) | DevExpress.XtraEditors.FilterDateType.EarlierThisMonth) | DevExpress.XtraEditors.FilterDateType.EarlierThisYear) | DevExpress.XtraEditors.FilterDateType.PriorThisYear) | DevExpress.XtraEditors.FilterDateType.Beyond))); iconSettings1.IconType = DevExpress.DashboardCommon.FormatConditionIconType.IndicatorRedFlag; formatConditionDateOccuring1.StyleSettings = iconSettings1; pivotItemFormatRule1.Condition = formatConditionDateOccuring1; pivotItemFormatRule1.Enabled = false; pivotItemFormatRule1.Name = "FormatRule 1"; this.pivotDashboardItem1.FormatRules.AddRange(new DevExpress.DashboardCommon.PivotItemFormatRule[] { pivotItemFormatRule1 }); this.pivotDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false; this.pivotDashboardItem1.LayoutType = DevExpress.DashboardCommon.PivotLayoutType.Compact; this.pivotDashboardItem1.Name = "Items assigned to you"; this.pivotDashboardItem1.Rows.AddRange(new DevExpress.DashboardCommon.Dimension[] { dimension6, dimension7, dimension8 }); this.pivotDashboardItem1.ShowCaption = true; this.pivotDashboardItem1.Values.AddRange(new DevExpress.DashboardCommon.Measure[] { measure3 }); // // dash_workflow // this.DataSources.AddRange(new DevExpress.DashboardCommon.IDashboardDataSource[] { this.data_workflow }); this.Items.AddRange(new DevExpress.DashboardCommon.DashboardItem[] { this.pieDashboardItem1, this.pivotDashboardItem1, this.gaugeDashboardItem1 }); dashboardLayoutItem1.DashboardItem = this.pieDashboardItem1; dashboardLayoutItem1.Weight = 49.957155098543275D; dashboardLayoutItem2.DashboardItem = this.gaugeDashboardItem1; dashboardLayoutItem2.Weight = 50.042844901456725D; dashboardLayoutGroup2.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] { dashboardLayoutItem1, dashboardLayoutItem2 }); dashboardLayoutGroup2.DashboardItem = null; dashboardLayoutGroup2.Weight = 49.92272024729521D; dashboardLayoutItem3.DashboardItem = this.pivotDashboardItem1; dashboardLayoutItem3.Weight = 50.07727975270479D; dashboardLayoutGroup1.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] { dashboardLayoutGroup2, dashboardLayoutItem3 }); dashboardLayoutGroup1.DashboardItem = null; dashboardLayoutGroup1.Orientation = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical; this.LayoutRoot = dashboardLayoutGroup1; dashboardParameter1.Name = "UserEmail"; dashboardParameter1.Type = typeof(string); dashboardParameter1.Value = ""; this.Parameters.AddRange(new DevExpress.DashboardCommon.DashboardParameter[] { dashboardParameter1 }); this.Title.Text = "Dashboard"; this.Title.Visible = false; ((System.ComponentModel.ISupportInitialize)(dimension1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.pieDashboardItem1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.data_workflow)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.gaugeDashboardItem1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension4)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension5)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension6)).EndInit(); ((System.ComponentModel.ISupportInitialize)(measure3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension7)).EndInit(); ((System.ComponentModel.ISupportInitialize)(dimension8)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.pivotDashboardItem1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }