/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
DevExpress.DashboardCommon.Dimension dimension1 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Measure measure1 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.DateTimePeriod dateTimePeriod1 = new DevExpress.DashboardCommon.DateTimePeriod();
DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit1 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit2 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
DevExpress.DashboardCommon.DateTimePeriod dateTimePeriod2 = new DevExpress.DashboardCommon.DateTimePeriod();
DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit3 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit4 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
DevExpress.DashboardCommon.DateTimePeriod dateTimePeriod3 = new DevExpress.DashboardCommon.DateTimePeriod();
DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit5 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit6 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
DevExpress.DashboardCommon.DateTimePeriod dateTimePeriod4 = new DevExpress.DashboardCommon.DateTimePeriod();
DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit7 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit8 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
DevExpress.DashboardCommon.DateTimePeriod dateTimePeriod5 = new DevExpress.DashboardCommon.DateTimePeriod();
DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit9 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit10 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
DevExpress.DashboardCommon.DateTimePeriod dateTimePeriod6 = new DevExpress.DashboardCommon.DateTimePeriod();
DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit11 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit12 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
DevExpress.DashboardCommon.DateTimePeriod dateTimePeriod7 = new DevExpress.DashboardCommon.DateTimePeriod();
DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit13 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
DevExpress.DashboardCommon.FlowDateTimePeriodLimit flowDateTimePeriodLimit14 = new DevExpress.DashboardCommon.FlowDateTimePeriodLimit();
DevExpress.DashboardCommon.SimpleSeries simpleSeries1 = new DevExpress.DashboardCommon.SimpleSeries();
DevExpress.DataAccess.ConnectionParameters.MsSqlConnectionParameters msSqlConnectionParameters1 = new DevExpress.DataAccess.ConnectionParameters.MsSqlConnectionParameters();
DevExpress.DataAccess.Sql.SelectQuery selectQuery1 = new DevExpress.DataAccess.Sql.SelectQuery();
DevExpress.DataAccess.Sql.Column column1 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression1 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Table table1 = new DevExpress.DataAccess.Sql.Table();
DevExpress.DataAccess.Sql.Column column2 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression2 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Table table2 = new DevExpress.DataAccess.Sql.Table();
DevExpress.DataAccess.Sql.Column column3 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression3 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column4 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression4 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column5 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression5 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column6 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression6 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column7 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression7 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column8 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression8 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Table table3 = new DevExpress.DataAccess.Sql.Table();
DevExpress.DataAccess.Sql.Column column9 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression9 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column10 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression10 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Join join1 = new DevExpress.DataAccess.Sql.Join();
DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo1 = new DevExpress.DataAccess.Sql.RelationColumnInfo();
DevExpress.DataAccess.Sql.Join join2 = new DevExpress.DataAccess.Sql.Join();
DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo2 = new DevExpress.DataAccess.Sql.RelationColumnInfo();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Report_TienConLaiCC));
DevExpress.DashboardCommon.Dimension dimension2 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn1 = new DevExpress.DashboardCommon.GridDimensionColumn();
DevExpress.DashboardCommon.GridColumnTotal gridColumnTotal1 = new DevExpress.DashboardCommon.GridColumnTotal();
DevExpress.DashboardCommon.Dimension dimension3 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn2 = new DevExpress.DashboardCommon.GridDimensionColumn();
DevExpress.DashboardCommon.Measure measure2 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.GridMeasureColumn gridMeasureColumn1 = new DevExpress.DashboardCommon.GridMeasureColumn();
DevExpress.DashboardCommon.GridItemFormatRule gridItemFormatRule1 = new DevExpress.DashboardCommon.GridItemFormatRule();
DevExpress.DashboardCommon.FormatConditionRangeSet formatConditionRangeSet1 = new DevExpress.DashboardCommon.FormatConditionRangeSet();
DevExpress.DashboardCommon.RangeInfo rangeInfo1 = new DevExpress.DashboardCommon.RangeInfo();
DevExpress.DashboardCommon.IconSettings iconSettings1 = new DevExpress.DashboardCommon.IconSettings();
DevExpress.DashboardCommon.RangeInfo rangeInfo2 = new DevExpress.DashboardCommon.RangeInfo();
DevExpress.DashboardCommon.IconSettings iconSettings2 = new DevExpress.DashboardCommon.IconSettings();
DevExpress.DashboardCommon.RangeInfo rangeInfo3 = new DevExpress.DashboardCommon.RangeInfo();
DevExpress.DashboardCommon.IconSettings iconSettings3 = new DevExpress.DashboardCommon.IconSettings();
DevExpress.DashboardCommon.RangeInfo rangeInfo4 = new DevExpress.DashboardCommon.RangeInfo();
DevExpress.DashboardCommon.IconSettings iconSettings4 = new DevExpress.DashboardCommon.IconSettings();
DevExpress.DashboardCommon.Dimension dimension4 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn3 = new DevExpress.DashboardCommon.GridDimensionColumn();
DevExpress.DashboardCommon.GridColumnTotal gridColumnTotal2 = new DevExpress.DashboardCommon.GridColumnTotal();
DevExpress.DashboardCommon.Dimension dimension5 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn4 = new DevExpress.DashboardCommon.GridDimensionColumn();
DevExpress.DashboardCommon.Measure measure3 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.GridMeasureColumn gridMeasureColumn2 = new DevExpress.DashboardCommon.GridMeasureColumn();
DevExpress.DashboardCommon.GridItemFormatRule gridItemFormatRule2 = new DevExpress.DashboardCommon.GridItemFormatRule();
DevExpress.DashboardCommon.FormatConditionRangeSet formatConditionRangeSet2 = new DevExpress.DashboardCommon.FormatConditionRangeSet();
DevExpress.DashboardCommon.RangeInfo rangeInfo5 = new DevExpress.DashboardCommon.RangeInfo();
DevExpress.DashboardCommon.IconSettings iconSettings5 = new DevExpress.DashboardCommon.IconSettings();
DevExpress.DashboardCommon.RangeInfo rangeInfo6 = new DevExpress.DashboardCommon.RangeInfo();
DevExpress.DashboardCommon.IconSettings iconSettings6 = new DevExpress.DashboardCommon.IconSettings();
DevExpress.DashboardCommon.RangeInfo rangeInfo7 = new DevExpress.DashboardCommon.RangeInfo();
DevExpress.DashboardCommon.IconSettings iconSettings7 = new DevExpress.DashboardCommon.IconSettings();
DevExpress.DashboardCommon.Dimension dimension6 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn5 = new DevExpress.DashboardCommon.GridDimensionColumn();
DevExpress.DashboardCommon.Measure measure4 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.GridMeasureColumn gridMeasureColumn3 = new DevExpress.DashboardCommon.GridMeasureColumn();
DevExpress.DashboardCommon.GridItemFormatRule gridItemFormatRule3 = new DevExpress.DashboardCommon.GridItemFormatRule();
DevExpress.DashboardCommon.FormatConditionRangeSet formatConditionRangeSet3 = new DevExpress.DashboardCommon.FormatConditionRangeSet();
DevExpress.DashboardCommon.RangeInfo rangeInfo8 = new DevExpress.DashboardCommon.RangeInfo();
DevExpress.DashboardCommon.IconSettings iconSettings8 = new DevExpress.DashboardCommon.IconSettings();
DevExpress.DashboardCommon.RangeInfo rangeInfo9 = new DevExpress.DashboardCommon.RangeInfo();
DevExpress.DashboardCommon.IconSettings iconSettings9 = new DevExpress.DashboardCommon.IconSettings();
DevExpress.DashboardCommon.RangeInfo rangeInfo10 = new DevExpress.DashboardCommon.RangeInfo();
DevExpress.DashboardCommon.IconSettings iconSettings10 = new DevExpress.DashboardCommon.IconSettings();
DevExpress.DashboardCommon.RangeInfo rangeInfo11 = new DevExpress.DashboardCommon.RangeInfo();
DevExpress.DashboardCommon.IconSettings iconSettings11 = new DevExpress.DashboardCommon.IconSettings();
DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup1 = new DevExpress.DashboardCommon.DashboardLayoutGroup();
DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem1 = new DevExpress.DashboardCommon.DashboardLayoutItem();
DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup2 = new DevExpress.DashboardCommon.DashboardLayoutGroup();
DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem2 = new DevExpress.DashboardCommon.DashboardLayoutItem();
DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup3 = new DevExpress.DashboardCommon.DashboardLayoutGroup();
DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem3 = new DevExpress.DashboardCommon.DashboardLayoutItem();
DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem4 = new DevExpress.DashboardCommon.DashboardLayoutItem();
this.rangeFilterDashboardItem1 = new DevExpress.DashboardCommon.RangeFilterDashboardItem();
this.dashboardSqlDataSource1 = new DevExpress.DashboardCommon.DashboardSqlDataSource();
this.gridDashboardItem1 = new DevExpress.DashboardCommon.GridDashboardItem();
this.gridDashboardItem2 = new DevExpress.DashboardCommon.GridDashboardItem();
this.gridDashboardItem3 = new DevExpress.DashboardCommon.GridDashboardItem();
((System.ComponentModel.ISupportInitialize)(this.rangeFilterDashboardItem1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension3)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension4)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension5)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure3)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem3)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension6)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure4)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// rangeFilterDashboardItem1
//
dimension1.DataMember = "ngaytaodt";
dimension1.DateTimeFormat.ExactDateFormat = DevExpress.DashboardCommon.ExactDateFormat.Month;
dimension1.DateTimeGroupInterval = DevExpress.DashboardCommon.DateTimeGroupInterval.DayMonthYear;
measure1.DataMember = "tienconlaitheoca";
dimension1.TopNOptions.Measure = measure1;
this.rangeFilterDashboardItem1.Argument = dimension1;
this.rangeFilterDashboardItem1.ComponentName = "rangeFilterDashboardItem1";
this.rangeFilterDashboardItem1.DataItemRepository.Clear();
this.rangeFilterDashboardItem1.DataItemRepository.Add(dimension1, "DataItem2");
this.rangeFilterDashboardItem1.DataItemRepository.Add(measure1, "DataItem0");
this.rangeFilterDashboardItem1.DataMember = "DoanhThu";
this.rangeFilterDashboardItem1.DataSource = this.dashboardSqlDataSource1;
flowDateTimePeriodLimit1.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month;
flowDateTimePeriodLimit1.Offset = 1;
dateTimePeriod1.End = flowDateTimePeriodLimit1;
dateTimePeriod1.Name = "This Month";
flowDateTimePeriodLimit2.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month;
dateTimePeriod1.Start = flowDateTimePeriodLimit2;
flowDateTimePeriodLimit3.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month;
dateTimePeriod2.End = flowDateTimePeriodLimit3;
dateTimePeriod2.Name = "Last Month";
flowDateTimePeriodLimit4.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month;
flowDateTimePeriodLimit4.Offset = -1;
dateTimePeriod2.Start = flowDateTimePeriodLimit4;
flowDateTimePeriodLimit5.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month;
dateTimePeriod3.End = flowDateTimePeriodLimit5;
dateTimePeriod3.Name = "Last 3 Months";
flowDateTimePeriodLimit6.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month;
flowDateTimePeriodLimit6.Offset = -3;
dateTimePeriod3.Start = flowDateTimePeriodLimit6;
flowDateTimePeriodLimit7.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month;
dateTimePeriod4.End = flowDateTimePeriodLimit7;
dateTimePeriod4.Name = "Last 6 Months";
flowDateTimePeriodLimit8.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month;
flowDateTimePeriodLimit8.Offset = -6;
dateTimePeriod4.Start = flowDateTimePeriodLimit8;
flowDateTimePeriodLimit9.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month;
dateTimePeriod5.End = flowDateTimePeriodLimit9;
dateTimePeriod5.Name = "Last 12 Months";
flowDateTimePeriodLimit10.Interval = DevExpress.DashboardCommon.DateTimeInterval.Month;
flowDateTimePeriodLimit10.Offset = -12;
dateTimePeriod5.Start = flowDateTimePeriodLimit10;
dateTimePeriod6.End = flowDateTimePeriodLimit11;
dateTimePeriod6.Name = "Last Year";
flowDateTimePeriodLimit12.Offset = -1;
dateTimePeriod6.Start = flowDateTimePeriodLimit12;
dateTimePeriod7.End = flowDateTimePeriodLimit13;
dateTimePeriod7.Name = "Last 2 Years";
flowDateTimePeriodLimit14.Offset = -2;
dateTimePeriod7.Start = flowDateTimePeriodLimit14;
this.rangeFilterDashboardItem1.DateTimePeriods.AddRange(new DevExpress.DashboardCommon.DateTimePeriod[] {
dateTimePeriod1,
dateTimePeriod2,
dateTimePeriod3,
dateTimePeriod4,
dateTimePeriod5,
dateTimePeriod6,
dateTimePeriod7
});
this.rangeFilterDashboardItem1.DefaultDateTimePeriodName = "This Month";
this.rangeFilterDashboardItem1.InteractivityOptions.IgnoreMasterFilters = true;
this.rangeFilterDashboardItem1.Name = "Filter theo tháng năm";
simpleSeries1.SeriesType = DevExpress.DashboardCommon.SimpleSeriesType.StackedBar;
simpleSeries1.AddDataItem("Value", measure1);
this.rangeFilterDashboardItem1.Series.AddRange(new DevExpress.DashboardCommon.SimpleSeries[] {
simpleSeries1
});
this.rangeFilterDashboardItem1.ShowCaption = true;
//
// dashboardSqlDataSource1
//
this.dashboardSqlDataSource1.ComponentName = "dashboardSqlDataSource1";
this.dashboardSqlDataSource1.ConnectionName = "localhost_BaoCaoThuChi_Connection";
msSqlConnectionParameters1.AuthorizationType = DevExpress.DataAccess.ConnectionParameters.MsSqlAuthorizationType.Windows;
msSqlConnectionParameters1.DatabaseName = "BaoCaoThuChi";
msSqlConnectionParameters1.ServerName = ".";
this.dashboardSqlDataSource1.ConnectionParameters = msSqlConnectionParameters1;
this.dashboardSqlDataSource1.Name = "SQL Data Source 1";
columnExpression1.ColumnName = "ngaytaodt";
table1.MetaSerializable = "<Meta X=\"30\" Y=\"30\" Width=\"125\" Height=\"110\" />";
table1.Name = "DoanhThu";
columnExpression1.Table = table1;
column1.Expression = columnExpression1;
columnExpression2.ColumnName = "caID";
table2.MetaSerializable = "<Meta X=\"185\" Y=\"30\" Width=\"125\" Height=\"194\" />";
table2.Name = "DoanhThuTheoCa";
columnExpression2.Table = table2;
column2.Expression = columnExpression2;
columnExpression3.ColumnName = "tenCa";
columnExpression3.Table = table2;
column3.Expression = columnExpression3;
columnExpression4.ColumnName = "tiendelai";
columnExpression4.Table = table2;
column4.Expression = columnExpression4;
columnExpression5.ColumnName = "doanhthutheoca";
columnExpression5.Table = table2;
column5.Expression = columnExpression5;
columnExpression6.ColumnName = "doanhthukhac";
columnExpression6.Table = table2;
column6.Expression = columnExpression6;
columnExpression7.ColumnName = "doanhthuID";
columnExpression7.Table = table1;
column7.Expression = columnExpression7;
columnExpression8.ColumnName = "tienconlaitheoca";
table3.MetaSerializable = "<Meta X=\"340\" Y=\"30\" Width=\"125\" Height=\"131\" />";
table3.Name = "TienConLaiTheoCa";
columnExpression8.Table = table3;
column8.Expression = columnExpression8;
column9.Alias = "TienConLaiTheoCa_caID";
columnExpression9.ColumnName = "caID";
columnExpression9.Table = table3;
column9.Expression = columnExpression9;
columnExpression10.ColumnName = "tlID";
columnExpression10.Table = table3;
column10.Expression = columnExpression10;
selectQuery1.Columns.Add(column1);
selectQuery1.Columns.Add(column2);
selectQuery1.Columns.Add(column3);
selectQuery1.Columns.Add(column4);
selectQuery1.Columns.Add(column5);
selectQuery1.Columns.Add(column6);
selectQuery1.Columns.Add(column7);
selectQuery1.Columns.Add(column8);
selectQuery1.Columns.Add(column9);
selectQuery1.Columns.Add(column10);
selectQuery1.Name = "DoanhThu";
relationColumnInfo1.NestedKeyColumn = "doanhthuID";
relationColumnInfo1.ParentKeyColumn = "doanhthuID";
join1.KeyColumns.Add(relationColumnInfo1);
join1.Nested = table2;
join1.Parent = table1;
relationColumnInfo2.NestedKeyColumn = "caID";
relationColumnInfo2.ParentKeyColumn = "caID";
join2.KeyColumns.Add(relationColumnInfo2);
join2.Nested = table3;
join2.Parent = table2;
selectQuery1.Relations.Add(join1);
selectQuery1.Relations.Add(join2);
selectQuery1.Tables.Add(table1);
selectQuery1.Tables.Add(table2);
selectQuery1.Tables.Add(table3);
this.dashboardSqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
selectQuery1
});
this.dashboardSqlDataSource1.ResultSchemaSerializable = resources.GetString("dashboardSqlDataSource1.ResultSchemaSerializable");
//
// gridDashboardItem1
//
dimension2.DataMember = "ngaytaodt";
dimension2.DateTimeGroupInterval = DevExpress.DashboardCommon.DateTimeGroupInterval.DayMonthYear;
dimension2.SortOrder = DevExpress.DashboardCommon.DimensionSortOrder.Descending;
gridDimensionColumn1.Name = "Ngày";
gridDimensionColumn1.Totals.AddRange(new DevExpress.DashboardCommon.GridColumnTotal[] {
gridColumnTotal1
});
gridDimensionColumn1.Weight = 51.772793053545584D;
gridDimensionColumn1.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
gridDimensionColumn1.AddDataItem("Dimension", dimension2);
dimension3.DataMember = "tenCa";
gridDimensionColumn2.Name = "Tên Ca";
gridDimensionColumn2.Weight = 59.261939218523878D;
gridDimensionColumn2.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
gridDimensionColumn2.AddDataItem("Dimension", dimension3);
measure2.DataMember = "tienconlaitheoca";
measure2.NumericFormat.CurrencyCultureName = "vi-VN";
measure2.NumericFormat.FormatType = DevExpress.DashboardCommon.DataItemNumericFormatType.Currency;
gridMeasureColumn1.Name = "Số Tiền Cuối Ca";
gridMeasureColumn1.Weight = 113.96526772793054D;
gridMeasureColumn1.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
gridMeasureColumn1.AddDataItem("Measure", measure2);
this.gridDashboardItem1.Columns.AddRange(new DevExpress.DashboardCommon.GridColumnBase[] {
gridDimensionColumn1,
gridDimensionColumn2,
gridMeasureColumn1
});
this.gridDashboardItem1.ComponentName = "gridDashboardItem1";
this.gridDashboardItem1.DataItemRepository.Clear();
this.gridDashboardItem1.DataItemRepository.Add(dimension3, "DataItem1");
this.gridDashboardItem1.DataItemRepository.Add(measure2, "DataItem2");
this.gridDashboardItem1.DataItemRepository.Add(dimension2, "DataItem0");
this.gridDashboardItem1.DataMember = "DoanhThu";
this.gridDashboardItem1.DataSource = this.dashboardSqlDataSource1;
iconSettings1.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalRedDownArrow;
rangeInfo1.StyleSettings = iconSettings1;
rangeInfo1.Value = 0D;
iconSettings2.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalYellowDownInclineArrow;
rangeInfo2.StyleSettings = iconSettings2;
rangeInfo2.Value = 25D;
iconSettings3.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalYellowUpInclineArrow;
rangeInfo3.StyleSettings = iconSettings3;
rangeInfo3.Value = 50D;
iconSettings4.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalGreenArrowUp;
rangeInfo4.StyleSettings = iconSettings4;
rangeInfo4.Value = 75D;
formatConditionRangeSet1.RangeSet.AddRange(new DevExpress.DashboardCommon.RangeInfo[] {
rangeInfo1,
rangeInfo2,
rangeInfo3,
rangeInfo4
});
formatConditionRangeSet1.ValueType = DevExpress.DashboardCommon.DashboardFormatConditionValueType.Percent;
gridItemFormatRule1.Condition = formatConditionRangeSet1;
gridItemFormatRule1.DataItem = measure2;
gridItemFormatRule1.Name = "FormatRule 1";
this.gridDashboardItem1.FormatRules.AddRange(new DevExpress.DashboardCommon.GridItemFormatRule[] {
gridItemFormatRule1
});
this.gridDashboardItem1.GridOptions.ColumnWidthMode = DevExpress.DashboardCommon.GridColumnWidthMode.Manual;
this.gridDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
this.gridDashboardItem1.Name = "Chi tiết theo ngày";
this.gridDashboardItem1.ShowCaption = true;
//
// gridDashboardItem2
//
dimension4.DataMember = "ngaytaodt";
dimension4.DateTimeGroupInterval = DevExpress.DashboardCommon.DateTimeGroupInterval.MonthYear;
gridDimensionColumn3.Name = "Tháng Năm";
gridDimensionColumn3.Totals.AddRange(new DevExpress.DashboardCommon.GridColumnTotal[] {
gridColumnTotal2
});
gridDimensionColumn3.Weight = 60.910404624277454D;
gridDimensionColumn3.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
gridDimensionColumn3.AddDataItem("Dimension", dimension4);
dimension5.DataMember = "tenCa";
gridDimensionColumn4.Name = "Tên Ca";
gridDimensionColumn4.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
gridDimensionColumn4.AddDataItem("Dimension", dimension5);
measure3.DataMember = "tienconlaitheoca";
measure3.NumericFormat.CurrencyCultureName = "vi-VN";
measure3.NumericFormat.FormatType = DevExpress.DashboardCommon.DataItemNumericFormatType.Currency;
gridMeasureColumn2.Name = "Tổng";
gridMeasureColumn2.Weight = 89.089595375722539D;
gridMeasureColumn2.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
gridMeasureColumn2.AddDataItem("Measure", measure3);
this.gridDashboardItem2.Columns.AddRange(new DevExpress.DashboardCommon.GridColumnBase[] {
gridDimensionColumn3,
gridDimensionColumn4,
gridMeasureColumn2
});
this.gridDashboardItem2.ComponentName = "gridDashboardItem2";
this.gridDashboardItem2.DataItemRepository.Clear();
this.gridDashboardItem2.DataItemRepository.Add(dimension4, "DataItem0");
this.gridDashboardItem2.DataItemRepository.Add(measure3, "DataItem1");
this.gridDashboardItem2.DataItemRepository.Add(dimension5, "DataItem2");
this.gridDashboardItem2.DataMember = "DoanhThu";
this.gridDashboardItem2.DataSource = this.dashboardSqlDataSource1;
iconSettings5.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalRedDownArrow;
rangeInfo5.StyleSettings = iconSettings5;
rangeInfo5.Value = 0D;
iconSettings6.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalYellowSideArrow;
rangeInfo6.StyleSettings = iconSettings6;
rangeInfo6.Value = 33D;
iconSettings7.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalGreenArrowUp;
rangeInfo7.StyleSettings = iconSettings7;
rangeInfo7.Value = 67D;
formatConditionRangeSet2.RangeSet.AddRange(new DevExpress.DashboardCommon.RangeInfo[] {
rangeInfo5,
rangeInfo6,
rangeInfo7
});
formatConditionRangeSet2.ValueType = DevExpress.DashboardCommon.DashboardFormatConditionValueType.Percent;
gridItemFormatRule2.Condition = formatConditionRangeSet2;
gridItemFormatRule2.DataItem = measure3;
gridItemFormatRule2.Name = "FormatRule 1";
this.gridDashboardItem2.FormatRules.AddRange(new DevExpress.DashboardCommon.GridItemFormatRule[] {
gridItemFormatRule2
});
this.gridDashboardItem2.GridOptions.ColumnWidthMode = DevExpress.DashboardCommon.GridColumnWidthMode.Manual;
this.gridDashboardItem2.InteractivityOptions.IgnoreMasterFilters = false;
this.gridDashboardItem2.Name = "Tổng theo tháng";
this.gridDashboardItem2.ShowCaption = true;
//
// gridDashboardItem3
//
dimension6.DataMember = "ngaytaodt";
gridDimensionColumn5.Name = "Năm";
gridDimensionColumn5.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
gridDimensionColumn5.AddDataItem("Dimension", dimension6);
measure4.DataMember = "tienconlaitheoca";
measure4.NumericFormat.CurrencyCultureName = "vi-VN";
measure4.NumericFormat.FormatType = DevExpress.DashboardCommon.DataItemNumericFormatType.Currency;
gridMeasureColumn3.Name = "Tổng";
gridMeasureColumn3.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
gridMeasureColumn3.AddDataItem("Measure", measure4);
this.gridDashboardItem3.Columns.AddRange(new DevExpress.DashboardCommon.GridColumnBase[] {
gridDimensionColumn5,
gridMeasureColumn3
});
this.gridDashboardItem3.ComponentName = "gridDashboardItem3";
this.gridDashboardItem3.DataItemRepository.Clear();
this.gridDashboardItem3.DataItemRepository.Add(dimension6, "DataItem0");
this.gridDashboardItem3.DataItemRepository.Add(measure4, "DataItem1");
this.gridDashboardItem3.DataMember = "DoanhThu";
this.gridDashboardItem3.DataSource = this.dashboardSqlDataSource1;
iconSettings8.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalRedDownArrow;
rangeInfo8.StyleSettings = iconSettings8;
rangeInfo8.Value = 0D;
iconSettings9.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalYellowDownInclineArrow;
rangeInfo9.StyleSettings = iconSettings9;
rangeInfo9.Value = 25D;
iconSettings10.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalYellowUpInclineArrow;
rangeInfo10.StyleSettings = iconSettings10;
rangeInfo10.Value = 50D;
iconSettings11.IconType = DevExpress.DashboardCommon.FormatConditionIconType.DirectionalGreenArrowUp;
rangeInfo11.StyleSettings = iconSettings11;
rangeInfo11.Value = 75D;
formatConditionRangeSet3.RangeSet.AddRange(new DevExpress.DashboardCommon.RangeInfo[] {
rangeInfo8,
rangeInfo9,
rangeInfo10,
rangeInfo11
});
formatConditionRangeSet3.ValueType = DevExpress.DashboardCommon.DashboardFormatConditionValueType.Percent;
gridItemFormatRule3.Condition = formatConditionRangeSet3;
gridItemFormatRule3.DataItem = measure4;
gridItemFormatRule3.Name = "FormatRule 1";
this.gridDashboardItem3.FormatRules.AddRange(new DevExpress.DashboardCommon.GridItemFormatRule[] {
gridItemFormatRule3
});
this.gridDashboardItem3.InteractivityOptions.IgnoreMasterFilters = false;
this.gridDashboardItem3.Name = "Tổng theo Năm";
this.gridDashboardItem3.ShowCaption = true;
//
// Report_TienConLaiCC
//
this.DataSources.AddRange(new DevExpress.DashboardCommon.IDashboardDataSource[] {
this.dashboardSqlDataSource1
});
this.Items.AddRange(new DevExpress.DashboardCommon.DashboardItem[] {
this.gridDashboardItem1,
this.rangeFilterDashboardItem1,
this.gridDashboardItem2,
this.gridDashboardItem3
});
dashboardLayoutItem1.DashboardItem = this.rangeFilterDashboardItem1;
dashboardLayoutItem1.Weight = 29.154929577464788D;
dashboardLayoutItem2.DashboardItem = this.gridDashboardItem1;
dashboardLayoutItem2.Weight = 59.3727726300784D;
dashboardLayoutItem3.DashboardItem = this.gridDashboardItem2;
dashboardLayoutItem3.Weight = 50.099403578528829D;
dashboardLayoutItem4.DashboardItem = this.gridDashboardItem3;
dashboardLayoutItem4.Weight = 49.900596421471171D;
dashboardLayoutGroup3.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
dashboardLayoutItem3,
dashboardLayoutItem4
});
dashboardLayoutGroup3.DashboardItem = null;
dashboardLayoutGroup3.Orientation = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical;
dashboardLayoutGroup3.Weight = 40.6272273699216D;
dashboardLayoutGroup2.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
dashboardLayoutItem2,
dashboardLayoutGroup3
});
dashboardLayoutGroup2.DashboardItem = null;
dashboardLayoutGroup2.Weight = 70.845070422535215D;
dashboardLayoutGroup1.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
dashboardLayoutItem1,
dashboardLayoutGroup2
});
dashboardLayoutGroup1.DashboardItem = null;
dashboardLayoutGroup1.Orientation = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical;
dashboardLayoutGroup1.Weight = 100D;
this.LayoutRoot = dashboardLayoutGroup1;
this.Title.Text = "Báo Cáo Tiền Còn Lại Cuối Ca";
((System.ComponentModel.ISupportInitialize)(measure1)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.rangeFilterDashboardItem1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension2)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension3)).EndInit();
((System.ComponentModel.ISupportInitialize)(measure2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem1)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension4)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension5)).EndInit();
((System.ComponentModel.ISupportInitialize)(measure3)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem2)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension6)).EndInit();
((System.ComponentModel.ISupportInitialize)(measure4)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem3)).EndInit();
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
}