Ejemplo n.º 1
0
 /// <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.Measure                   measure1           = 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.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.Table                      table2             = new DevExpress.DataAccess.Sql.Table();
     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.Table                      table3             = 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();
     DevExpress.DataAccess.Sql.Column                     column8            = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression           columnExpression8  = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Table                      table4             = new DevExpress.DataAccess.Sql.Table();
     DevExpress.DataAccess.Sql.Column                     column9            = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression           columnExpression9  = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Table                      table5             = new DevExpress.DataAccess.Sql.Table();
     DevExpress.DataAccess.Sql.Column                     column10           = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression           columnExpression10 = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Table                      table6             = new DevExpress.DataAccess.Sql.Table();
     DevExpress.DataAccess.Sql.Column                     column11           = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression           columnExpression11 = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Table                      table7             = new DevExpress.DataAccess.Sql.Table();
     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();
     DevExpress.DataAccess.Sql.Join                       join2 = new DevExpress.DataAccess.Sql.Join();
     DevExpress.DataAccess.Sql.RelationColumnInfo         relationColumnInfo2 = new DevExpress.DataAccess.Sql.RelationColumnInfo();
     DevExpress.DataAccess.Sql.Join                       join3 = new DevExpress.DataAccess.Sql.Join();
     DevExpress.DataAccess.Sql.RelationColumnInfo         relationColumnInfo3 = new DevExpress.DataAccess.Sql.RelationColumnInfo();
     DevExpress.DataAccess.Sql.Table                      table8 = new DevExpress.DataAccess.Sql.Table();
     DevExpress.DataAccess.Sql.Join                       join4  = new DevExpress.DataAccess.Sql.Join();
     DevExpress.DataAccess.Sql.RelationColumnInfo         relationColumnInfo4 = new DevExpress.DataAccess.Sql.RelationColumnInfo();
     DevExpress.DataAccess.Sql.Join                       join5 = new DevExpress.DataAccess.Sql.Join();
     DevExpress.DataAccess.Sql.RelationColumnInfo         relationColumnInfo5 = new DevExpress.DataAccess.Sql.RelationColumnInfo();
     DevExpress.DataAccess.Sql.Join                       join6 = new DevExpress.DataAccess.Sql.Join();
     DevExpress.DataAccess.Sql.RelationColumnInfo         relationColumnInfo6 = new DevExpress.DataAccess.Sql.RelationColumnInfo();
     DevExpress.DataAccess.Sql.Join                       join7 = new DevExpress.DataAccess.Sql.Join();
     DevExpress.DataAccess.Sql.RelationColumnInfo         relationColumnInfo7        = new DevExpress.DataAccess.Sql.RelationColumnInfo();
     System.ComponentModel.ComponentResourceManager       resources                  = new System.ComponentModel.ComponentResourceManager(typeof(dash_pro_pm));
     DevExpress.DashboardCommon.Dimension                 dimension3                 = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.Measure                   measure2                   = new DevExpress.DashboardCommon.Measure();
     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.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.Measure                   measure3                   = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.PercentOfTotalCalculation percentOfTotalCalculation1 = new DevExpress.DashboardCommon.PercentOfTotalCalculation();
     DevExpress.DashboardCommon.PieWindowDefinition       pieWindowDefinition1       = new DevExpress.DashboardCommon.PieWindowDefinition();
     DevExpress.DashboardCommon.Dimension                 dimension12                = new DevExpress.DashboardCommon.Dimension();
     DevExpress.DashboardCommon.Dimension                 dimension13                = 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();
     this.chartDashboardItem1     = new DevExpress.DashboardCommon.ChartDashboardItem();
     this.dashboardSqlDataSource1 = new DevExpress.DashboardCommon.DashboardSqlDataSource();
     this.treeViewDashboardItem1  = new DevExpress.DashboardCommon.TreeViewDashboardItem();
     this.pieDashboardItem1       = new DevExpress.DashboardCommon.PieDashboardItem();
     ((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.treeViewDashboardItem1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension3)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension4)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension5)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension6)).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)(measure3)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension12)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension13)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
     //
     // chartDashboardItem1
     //
     dimension1.DataMember = "area_name";
     this.chartDashboardItem1.Arguments.AddRange(new DevExpress.DashboardCommon.Dimension[] {
         dimension1
     });
     this.chartDashboardItem1.AxisX.TitleVisible = false;
     this.chartDashboardItem1.ComponentName      = "chartDashboardItem1";
     dimension2.DataMember = "pro_name";
     measure1.DataMember   = "wf_status";
     measure1.Name         = "Workflwo Status";
     measure1.SummaryType  = DevExpress.DashboardCommon.SummaryType.CountDistinct;
     this.chartDashboardItem1.DataItemRepository.Clear();
     this.chartDashboardItem1.DataItemRepository.Add(dimension2, "DataItem1");
     this.chartDashboardItem1.DataItemRepository.Add(dimension1, "DataItem2");
     this.chartDashboardItem1.DataItemRepository.Add(measure1, "DataItem0");
     this.chartDashboardItem1.DataMember   = "WORKFLOW";
     this.chartDashboardItem1.DataSource   = this.dashboardSqlDataSource1;
     this.chartDashboardItem1.FilterString = "";
     this.chartDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
     this.chartDashboardItem1.Name = "Workflow Counts by Business Area and Project";
     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.AddDataItem("Value", measure1);
     chartPane1.Series.AddRange(new DevExpress.DashboardCommon.ChartSeries[] {
         simpleSeries1
     });
     this.chartDashboardItem1.Panes.AddRange(new DevExpress.DashboardCommon.ChartPane[] {
         chartPane1
     });
     this.chartDashboardItem1.SeriesDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] {
         dimension2
     });
     this.chartDashboardItem1.ShowCaption = true;
     //
     // dashboardSqlDataSource1
     //
     calculatedField1.DataMember = "WORKFLOW";
     calculatedField1.Expression = "CountDistinct([wf_status])";
     calculatedField1.Name       = "Calculated Field 1";
     this.dashboardSqlDataSource1.CalculatedFields.AddRange(new DevExpress.DashboardCommon.CalculatedField[] {
         calculatedField1
     });
     this.dashboardSqlDataSource1.ComponentName  = "dashboardSqlDataSource1";
     this.dashboardSqlDataSource1.ConnectionName = "DevDB";
     this.dashboardSqlDataSource1.Name           = "SQL Data Source 1";
     columnExpression1.ColumnName = "wf_status";
     table1.Alias                  = "WORKFLOW";
     table1.MetaSerializable       = "<Meta X=\"200\" Y=\"240\" Width=\"125\" Height=\"248\" />";
     table1.Name                   = "rc_workflow";
     columnExpression1.Table       = table1;
     column1.Expression            = columnExpression1;
     columnExpression2.ColumnName  = "wf_status_value";
     columnExpression2.Table       = table1;
     column2.Expression            = columnExpression2;
     columnExpression3.ColumnName  = "wf_statusdate";
     columnExpression3.Table       = table1;
     column3.Expression            = columnExpression3;
     columnExpression4.ColumnName  = "pro_name";
     table2.Alias                  = "PROJECTS";
     table2.MetaSerializable       = "<Meta X=\"400\" Y=\"300\" Width=\"125\" Height=\"153\" />";
     table2.Name                   = "rc_projects";
     columnExpression4.Table       = table2;
     column4.Expression            = columnExpression4;
     columnExpression5.ColumnName  = "wf_duedate";
     columnExpression5.Table       = table1;
     column5.Expression            = columnExpression5;
     columnExpression6.ColumnName  = "bp_name";
     table3.Alias                  = "processes";
     table3.MetaSerializable       = "<Meta X=\"810\" Y=\"430\" Width=\"125\" Height=\"210\" />";
     table3.Name                   = "rc_assessment_processes";
     columnExpression6.Table       = table3;
     column6.Expression            = columnExpression6;
     columnExpression7.ColumnName  = "bp_identifier";
     columnExpression7.Table       = table3;
     column7.Expression            = columnExpression7;
     columnExpression8.ColumnName  = "UserName";
     table4.Alias                  = "from";
     table4.MetaSerializable       = "<Meta X=\"190\" Y=\"520\" Width=\"125\" Height=\"343\" />";
     table4.Name                   = "AspNetUsers";
     columnExpression8.Table       = table4;
     column8.Expression            = columnExpression8;
     column9.Alias                 = "AspNetUsers_1_UserName";
     columnExpression9.ColumnName  = "UserName";
     table5.Alias                  = "to";
     table5.MetaSerializable       = "<Meta X=\"30\" Y=\"330\" Width=\"125\" Height=\"343\" />";
     table5.Name                   = "AspNetUsers";
     columnExpression9.Table       = table5;
     column9.Expression            = columnExpression9;
     columnExpression10.ColumnName = "cat_name";
     table6.Alias                  = "categories";
     table6.MetaSerializable       = "<Meta X=\"1000\" Y=\"440\" Width=\"125\" Height=\"210\" />";
     table6.Name                   = "rc_assessment_categories";
     columnExpression10.Table      = table6;
     column10.Expression           = columnExpression10;
     columnExpression11.ColumnName = "area_name";
     table7.Alias                  = "areas";
     table7.MetaSerializable       = "<Meta X=\"1160\" Y=\"440\" Width=\"125\" Height=\"191\" />";
     table7.Name                   = "rc_assessment_areas";
     columnExpression11.Table      = table7;
     column11.Expression           = columnExpression11;
     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      = "[WORKFLOW.wf_statusdate] < LocalDateTimeTomorrow()";
     selectQuery1.GroupFilterString = "";
     selectQuery1.Name     = "WORKFLOW";
     queryParameter1.Name  = "Project";
     queryParameter1.Type  = typeof(DevExpress.DataAccess.Expression);
     queryParameter1.Value = new DevExpress.DataAccess.Expression("[Parameters.Project]", typeof(string));
     selectQuery1.Parameters.Add(queryParameter1);
     relationColumnInfo1.NestedKeyColumn = "pro_ID";
     relationColumnInfo1.ParentKeyColumn = "wf_projectid";
     join1.KeyColumns.Add(relationColumnInfo1);
     join1.Nested = table2;
     join1.Parent = table1;
     relationColumnInfo2.NestedKeyColumn = "Id";
     relationColumnInfo2.ParentKeyColumn = "wf_from";
     join2.KeyColumns.Add(relationColumnInfo2);
     join2.Nested = table4;
     join2.Parent = table1;
     relationColumnInfo3.NestedKeyColumn = "act_projectID";
     relationColumnInfo3.ParentKeyColumn = "pro_ID";
     join3.KeyColumns.Add(relationColumnInfo3);
     table8.Alias                        = "isactive";
     table8.MetaSerializable             = "<Meta X=\"580\" Y=\"450\" Width=\"125\" Height=\"134\" />";
     table8.Name                         = "rc_assessment_active";
     join3.Nested                        = table8;
     join3.Parent                        = table2;
     relationColumnInfo4.NestedKeyColumn = "bp_id";
     relationColumnInfo4.ParentKeyColumn = "act_bpID";
     join4.KeyColumns.Add(relationColumnInfo4);
     join4.Nested = table3;
     join4.Parent = table8;
     relationColumnInfo5.NestedKeyColumn = "Id";
     relationColumnInfo5.ParentKeyColumn = "wf_to";
     join5.KeyColumns.Add(relationColumnInfo5);
     join5.Nested = table5;
     join5.Parent = table1;
     relationColumnInfo6.NestedKeyColumn = "cat_id";
     relationColumnInfo6.ParentKeyColumn = "bp_bcID";
     join6.KeyColumns.Add(relationColumnInfo6);
     join6.Nested = table6;
     join6.Parent = table3;
     relationColumnInfo7.NestedKeyColumn = "area_id";
     relationColumnInfo7.ParentKeyColumn = "cat_baID";
     join7.KeyColumns.Add(relationColumnInfo7);
     join7.Nested = table7;
     join7.Parent = table6;
     selectQuery1.Relations.Add(join1);
     selectQuery1.Relations.Add(join2);
     selectQuery1.Relations.Add(join3);
     selectQuery1.Relations.Add(join4);
     selectQuery1.Relations.Add(join5);
     selectQuery1.Relations.Add(join6);
     selectQuery1.Relations.Add(join7);
     selectQuery1.Tables.Add(table1);
     selectQuery1.Tables.Add(table2);
     selectQuery1.Tables.Add(table4);
     selectQuery1.Tables.Add(table8);
     selectQuery1.Tables.Add(table3);
     selectQuery1.Tables.Add(table5);
     selectQuery1.Tables.Add(table6);
     selectQuery1.Tables.Add(table7);
     this.dashboardSqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
         selectQuery1
     });
     this.dashboardSqlDataSource1.ResultSchemaSerializable = resources.GetString("dashboardSqlDataSource1.ResultSchemaSerializable");
     //
     // treeViewDashboardItem1
     //
     this.treeViewDashboardItem1.ComponentName = "treeViewDashboardItem1";
     dimension3.DataMember  = "wf_status_value";
     measure2.DataMember    = "wf_statusdate";
     measure2.SummaryType   = DevExpress.DashboardCommon.SummaryType.Count;
     dimension4.DataMember  = "pro_name";
     dimension5.DataMember  = "area_name";
     dimension6.DataMember  = "cat_name";
     dimension7.DataMember  = "bp_identifier";
     dimension8.DataMember  = "bp_name";
     dimension9.DataMember  = "wf_status";
     dimension9.SortOrder   = DevExpress.DashboardCommon.DimensionSortOrder.Descending;
     dimension10.DataMember = "AspNetUsers_1_UserName";
     this.treeViewDashboardItem1.DataItemRepository.Clear();
     this.treeViewDashboardItem1.DataItemRepository.Add(dimension3, "DataItem6");
     this.treeViewDashboardItem1.DataItemRepository.Add(measure2, "DataItem8");
     this.treeViewDashboardItem1.DataItemRepository.Add(dimension4, "DataItem0");
     this.treeViewDashboardItem1.DataItemRepository.Add(dimension5, "DataItem1");
     this.treeViewDashboardItem1.DataItemRepository.Add(dimension6, "DataItem2");
     this.treeViewDashboardItem1.DataItemRepository.Add(dimension7, "DataItem3");
     this.treeViewDashboardItem1.DataItemRepository.Add(dimension8, "DataItem4");
     this.treeViewDashboardItem1.DataItemRepository.Add(dimension9, "DataItem5");
     this.treeViewDashboardItem1.DataItemRepository.Add(dimension10, "DataItem7");
     this.treeViewDashboardItem1.DataMember = "WORKFLOW";
     this.treeViewDashboardItem1.DataSource = this.dashboardSqlDataSource1;
     this.treeViewDashboardItem1.FilterDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] {
         dimension4,
         dimension5,
         dimension6,
         dimension7,
         dimension8,
         dimension9,
         dimension10
     });
     this.treeViewDashboardItem1.HiddenDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] {
         dimension3
     });
     this.treeViewDashboardItem1.HiddenMeasures.AddRange(new DevExpress.DashboardCommon.Measure[] {
         measure2
     });
     this.treeViewDashboardItem1.InteractivityOptions.IgnoreMasterFilters = true;
     this.treeViewDashboardItem1.Name        = "Assessments Data - Tree View";
     this.treeViewDashboardItem1.ShowCaption = true;
     //
     // pieDashboardItem1
     //
     dimension11.DataMember = "area_name";
     this.pieDashboardItem1.Arguments.AddRange(new DevExpress.DashboardCommon.Dimension[] {
         dimension11
     });
     this.pieDashboardItem1.ComponentName = "pieDashboardItem1";
     measure3.Calculation = percentOfTotalCalculation1;
     measure3.DataMember  = "wf_status";
     measure3.Name        = "Workflow items by User";
     measure3.SummaryType = DevExpress.DashboardCommon.SummaryType.CountDistinct;
     pieWindowDefinition1.DefinitionMode = DevExpress.DashboardCommon.PieWindowDefinitionMode.Arguments;
     measure3.WindowDefinition           = pieWindowDefinition1;
     dimension12.DataMember        = "UserName";
     dimension13.DataMember        = "AspNetUsers_1_UserName";
     dimension13.TextGroupInterval = DevExpress.DashboardCommon.TextGroupInterval.Alphabetical;
     this.pieDashboardItem1.DataItemRepository.Clear();
     this.pieDashboardItem1.DataItemRepository.Add(measure3, "DataItem1");
     this.pieDashboardItem1.DataItemRepository.Add(dimension12, "DataItem2");
     this.pieDashboardItem1.DataItemRepository.Add(dimension11, "DataItem0");
     this.pieDashboardItem1.DataItemRepository.Add(dimension13, "DataItem3");
     this.pieDashboardItem1.DataMember = "WORKFLOW";
     this.pieDashboardItem1.DataSource = this.dashboardSqlDataSource1;
     this.pieDashboardItem1.HiddenDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] {
         dimension13
     });
     this.pieDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
     this.pieDashboardItem1.Name = "Workflow items by User";
     this.pieDashboardItem1.SeriesDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] {
         dimension12
     });
     this.pieDashboardItem1.ShowCaption = true;
     this.pieDashboardItem1.Values.AddRange(new DevExpress.DashboardCommon.Measure[] {
         measure3
     });
     //
     // dash_pro_pm
     //
     this.DataSources.AddRange(new DevExpress.DashboardCommon.IDashboardDataSource[] {
         this.dashboardSqlDataSource1
     });
     this.Items.AddRange(new DevExpress.DashboardCommon.DashboardItem[] {
         this.pieDashboardItem1,
         this.chartDashboardItem1,
         this.treeViewDashboardItem1
     });
     dashboardLayoutItem1.DashboardItem = this.chartDashboardItem1;
     dashboardLayoutItem1.Weight        = 49.141630901287556D;
     dashboardLayoutItem2.DashboardItem = this.treeViewDashboardItem1;
     dashboardLayoutItem2.Weight        = 50.858369098712444D;
     dashboardLayoutGroup2.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
         dashboardLayoutItem1,
         dashboardLayoutItem2
     });
     dashboardLayoutGroup2.DashboardItem = null;
     dashboardLayoutGroup2.Weight        = 35.876623376623378D;
     dashboardLayoutItem3.DashboardItem  = this.pieDashboardItem1;
     dashboardLayoutItem3.Weight         = 64.123376623376629D;
     dashboardLayoutGroup1.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
         dashboardLayoutGroup2,
         dashboardLayoutItem3
     });
     dashboardLayoutGroup1.DashboardItem = null;
     dashboardLayoutGroup1.Orientation   = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical;
     this.LayoutRoot     = dashboardLayoutGroup1;
     this.Title.ImageUrl = "https://rcxbox.readycert.net/Content/Images/logo.png";
     this.Title.Text     = "Project User Dashboard";
     ((System.ComponentModel.ISupportInitialize)(dimension1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension3)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension4)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension5)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension6)).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)(measure3)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension12)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension13)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.pieDashboardItem1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this)).EndInit();
 }
Ejemplo n.º 2
0
 /// <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.Measure   measure1   = new DevExpress.DashboardCommon.Measure();
     DevExpress.DashboardCommon.PercentOfTotalCalculation percentOfTotalCalculation1 = new DevExpress.DashboardCommon.PercentOfTotalCalculation();
     DevExpress.DashboardCommon.PieWindowDefinition       pieWindowDefinition1       = new DevExpress.DashboardCommon.PieWindowDefinition();
     DevExpress.DataAccess.Sql.CustomSqlQuery             customSqlQuery1            = new DevExpress.DataAccess.Sql.CustomSqlQuery();
     System.ComponentModel.ComponentResourceManager       resources             = new System.ComponentModel.ComponentResourceManager(typeof(Pro_Db_OFThisWeek_Pie));
     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();
     this.pieDashboardItem1       = new DevExpress.DashboardCommon.PieDashboardItem();
     this.dashboardSqlDataSource1 = new DevExpress.DashboardCommon.DashboardSqlDataSource();
     this.dashboardSqlDataSource2 = new DevExpress.DashboardCommon.DashboardSqlDataSource();
     ((System.ComponentModel.ISupportInitialize)(this.pieDashboardItem1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(dimension2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(measure1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
     //
     // pieDashboardItem1
     //
     dimension1.DataMember = "CD_MAT";
     dimension2.DataMember = "LB_MAT";
     this.pieDashboardItem1.Arguments.AddRange(new DevExpress.DashboardCommon.Dimension[] {
         dimension1,
         dimension2
     });
     this.pieDashboardItem1.ComponentName = "pieDashboardItem1";
     measure1.Calculation = percentOfTotalCalculation1;
     measure1.DataMember  = "QT_MVMT";
     measure1.Name        = "Manf. QTY.";
     measure1.NumericFormat.FormatType            = DevExpress.DashboardCommon.DataItemNumericFormatType.Percent;
     measure1.NumericFormat.IncludeGroupSeparator = true;
     measure1.NumericFormat.Unit         = DevExpress.DashboardCommon.DataItemNumericUnit.Ones;
     pieWindowDefinition1.DefinitionMode = DevExpress.DashboardCommon.PieWindowDefinitionMode.Arguments;
     measure1.WindowDefinition           = pieWindowDefinition1;
     this.pieDashboardItem1.DataItemRepository.Clear();
     this.pieDashboardItem1.DataItemRepository.Add(measure1, "DataItem0");
     this.pieDashboardItem1.DataItemRepository.Add(dimension1, "DataItem1");
     this.pieDashboardItem1.DataItemRepository.Add(dimension2, "DataItem2");
     this.pieDashboardItem1.DataMember = "Query";
     this.pieDashboardItem1.DataSource = this.dashboardSqlDataSource1;
     this.pieDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
     this.pieDashboardItem1.LabelContentType = ((DevExpress.DashboardCommon.PieValueType)((DevExpress.DashboardCommon.PieValueType.Argument | DevExpress.DashboardCommon.PieValueType.Value)));
     this.pieDashboardItem1.Name             = "Pies 1";
     this.pieDashboardItem1.ShowCaption      = false;
     this.pieDashboardItem1.ShowPieCaptions  = false;
     this.pieDashboardItem1.Values.AddRange(new DevExpress.DashboardCommon.Measure[] {
         measure1
     });
     //
     // dashboardSqlDataSource1
     //
     this.dashboardSqlDataSource1.ComponentName  = "dashboardSqlDataSource1";
     this.dashboardSqlDataSource1.ConnectionName = "Production.Properties.Settings.SYNC_NUTRICIELConnectionString";
     this.dashboardSqlDataSource1.Name           = "OF This Week Pie";
     customSqlQuery1.Name = "Query";
     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           = "OF This Month Pie";
     customSqlQuery2.Name = "Query";
     customSqlQuery2.Sql  = resources.GetString("customSqlQuery2.Sql");
     this.dashboardSqlDataSource2.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
         customSqlQuery2
     });
     this.dashboardSqlDataSource2.ResultSchemaSerializable = resources.GetString("dashboardSqlDataSource2.ResultSchemaSerializable");
     //
     // Pro_Db_OFThisWeek_Pie
     //
     this.DataSources.AddRange(new DevExpress.DashboardCommon.IDashboardDataSource[] {
         this.dashboardSqlDataSource1,
         this.dashboardSqlDataSource2
     });
     this.Items.AddRange(new DevExpress.DashboardCommon.DashboardItem[] {
         this.pieDashboardItem1
     });
     dashboardLayoutItem1.DashboardItem = this.pieDashboardItem1;
     dashboardLayoutItem1.Weight        = 50.133333333333333D;
     dashboardLayoutGroup1.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
         dashboardLayoutItem1
     });
     dashboardLayoutGroup1.DashboardItem = null;
     dashboardLayoutGroup1.Orientation   = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical;
     this.LayoutRoot = dashboardLayoutGroup1;
     this.Title.Text = "Percentage of FG this week";
     ((System.ComponentModel.ISupportInitialize)(dimension1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(dimension2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(measure1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.pieDashboardItem1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this)).EndInit();
 }