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