/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
DevExpress.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.Table table2 = new DevExpress.DataAccess.Sql.Table();
DevExpress.DataAccess.Sql.Column column7 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.CustomExpression customExpression1 = new DevExpress.DataAccess.Sql.CustomExpression();
DevExpress.DataAccess.Sql.Join join1 = new DevExpress.DataAccess.Sql.Join();
DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo1 = new DevExpress.DataAccess.Sql.RelationColumnInfo();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Report1));
this.Detail = new DevExpress.XtraReports.UI.DetailBand();
this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand();
this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand();
this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components);
this.pageHeaderBand1 = new DevExpress.XtraReports.UI.PageHeaderBand();
this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel3 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel4 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel5 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel6 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel7 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLine1 = new DevExpress.XtraReports.UI.XRLine();
this.xrLine2 = new DevExpress.XtraReports.UI.XRLine();
this.groupHeaderBand1 = new DevExpress.XtraReports.UI.GroupHeaderBand();
this.xrLabel8 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel9 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel10 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel11 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel12 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel13 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel14 = new DevExpress.XtraReports.UI.XRLabel();
this.pageFooterBand1 = new DevExpress.XtraReports.UI.PageFooterBand();
this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo();
this.xrPageInfo2 = new DevExpress.XtraReports.UI.XRPageInfo();
this.reportHeaderBand1 = new DevExpress.XtraReports.UI.ReportHeaderBand();
this.xrRichText1 = new DevExpress.XtraReports.UI.XRRichText();
this.xrLabel15 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLine3 = new DevExpress.XtraReports.UI.XRLine();
this.Title = new DevExpress.XtraReports.UI.XRControlStyle();
this.FieldCaption = new DevExpress.XtraReports.UI.XRControlStyle();
this.PageInfo = new DevExpress.XtraReports.UI.XRControlStyle();
this.DataField = new DevExpress.XtraReports.UI.XRControlStyle();
((System.ComponentModel.ISupportInitialize)(this.xrRichText1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// Detail
//
this.Detail.Dpi = 100F;
this.Detail.HeightF = 23F;
this.Detail.Name = "Detail";
this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F);
this.Detail.StyleName = "DataField";
this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
//
// TopMargin
//
this.TopMargin.Dpi = 100F;
this.TopMargin.HeightF = 100F;
this.TopMargin.Name = "TopMargin";
this.TopMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F);
this.TopMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
//
// BottomMargin
//
this.BottomMargin.Dpi = 100F;
this.BottomMargin.HeightF = 100F;
this.BottomMargin.Name = "BottomMargin";
this.BottomMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F);
this.BottomMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
//
// sqlDataSource1
//
this.sqlDataSource1.ConnectionName = "localhost_QuanLyVPP_Connection";
this.sqlDataSource1.Name = "sqlDataSource1";
columnExpression1.ColumnName = "MaHH";
table1.MetaSerializable = "30|30|125|191";
table1.Name = "HangHoa";
columnExpression1.Table = table1;
column1.Expression = columnExpression1;
columnExpression2.ColumnName = "TenHH";
columnExpression2.Table = table1;
column2.Expression = columnExpression2;
columnExpression3.ColumnName = "DVTinh";
columnExpression3.Table = table1;
column3.Expression = columnExpression3;
columnExpression4.ColumnName = "GiaMua";
columnExpression4.Table = table1;
column4.Expression = columnExpression4;
columnExpression5.ColumnName = "DonGia";
columnExpression5.Table = table1;
column5.Expression = columnExpression5;
columnExpression6.ColumnName = "SoLuongHH";
table2.MetaSerializable = "185|30|125|96";
table2.Name = "KhoHH";
columnExpression6.Table = table2;
column6.Expression = columnExpression6;
column7.Alias = "Lợi Nhuận";
customExpression1.Expression = "HangHoa.DonGia - HangHoa.GiaMua";
column7.Expression = customExpression1;
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.Name = "HangHoa_1";
relationColumnInfo1.NestedKeyColumn = "MaHK";
relationColumnInfo1.ParentKeyColumn = "MaHK";
join1.KeyColumns.Add(relationColumnInfo1);
join1.Nested = table2;
join1.Parent = table1;
selectQuery1.Relations.Add(join1);
selectQuery1.Tables.Add(table1);
selectQuery1.Tables.Add(table2);
this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
selectQuery1
});
this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable");
//
// pageHeaderBand1
//
this.pageHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrLabel1,
this.xrLabel2,
this.xrLabel3,
this.xrLabel4,
this.xrLabel5,
this.xrLabel6,
this.xrLabel7,
this.xrLine1,
this.xrLine2
});
this.pageHeaderBand1.Dpi = 100F;
this.pageHeaderBand1.HeightF = 45F;
this.pageHeaderBand1.Name = "pageHeaderBand1";
this.pageHeaderBand1.StylePriority.UseTextAlignment = false;
this.pageHeaderBand1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
//
// xrLabel1
//
this.xrLabel1.Dpi = 100F;
this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 7F);
this.xrLabel1.Name = "xrLabel1";
this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel1.SizeF = new System.Drawing.SizeF(75.59241F, 36F);
this.xrLabel1.StyleName = "FieldCaption";
this.xrLabel1.Text = "Mã HH";
//
// xrLabel2
//
this.xrLabel2.Dpi = 100F;
this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(81.59241F, 7.000001F);
this.xrLabel2.Name = "xrLabel2";
this.xrLabel2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel2.SizeF = new System.Drawing.SizeF(135.3363F, 36F);
this.xrLabel2.StyleName = "FieldCaption";
this.xrLabel2.Text = "Tên HH";
//
// xrLabel3
//
this.xrLabel3.Dpi = 100F;
this.xrLabel3.LocationFloat = new DevExpress.Utils.PointFloat(216.9287F, 7.000001F);
this.xrLabel3.Name = "xrLabel3";
this.xrLabel3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel3.SizeF = new System.Drawing.SizeF(80.12796F, 36F);
this.xrLabel3.StyleName = "FieldCaption";
this.xrLabel3.Text = "ĐV Tính";
//
// xrLabel4
//
this.xrLabel4.Dpi = 100F;
this.xrLabel4.LocationFloat = new DevExpress.Utils.PointFloat(297.0567F, 7.000001F);
this.xrLabel4.Name = "xrLabel4";
this.xrLabel4.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel4.SizeF = new System.Drawing.SizeF(86.17535F, 36F);
this.xrLabel4.StyleName = "FieldCaption";
this.xrLabel4.Text = "Giá Mua";
//
// xrLabel5
//
this.xrLabel5.Dpi = 100F;
this.xrLabel5.LocationFloat = new DevExpress.Utils.PointFloat(383.2321F, 7.000001F);
this.xrLabel5.Name = "xrLabel5";
this.xrLabel5.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel5.SizeF = new System.Drawing.SizeF(81.63981F, 36F);
this.xrLabel5.StyleName = "FieldCaption";
this.xrLabel5.Text = "Đơn Giá";
//
// xrLabel6
//
this.xrLabel6.Dpi = 100F;
this.xrLabel6.LocationFloat = new DevExpress.Utils.PointFloat(464.8719F, 7.000001F);
this.xrLabel6.Name = "xrLabel6";
this.xrLabel6.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel6.SizeF = new System.Drawing.SizeF(74.81064F, 36F);
this.xrLabel6.StyleName = "FieldCaption";
this.xrLabel6.Text = "Tồn Kho";
//
// xrLabel7
//
this.xrLabel7.Dpi = 100F;
this.xrLabel7.LocationFloat = new DevExpress.Utils.PointFloat(539.6824F, 7F);
this.xrLabel7.Name = "xrLabel7";
this.xrLabel7.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel7.SizeF = new System.Drawing.SizeF(104.3176F, 36F);
this.xrLabel7.StyleName = "FieldCaption";
this.xrLabel7.Text = "Lợi Nhuận";
//
// xrLine1
//
this.xrLine1.Dpi = 100F;
this.xrLine1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 5F);
this.xrLine1.Name = "xrLine1";
this.xrLine1.SizeF = new System.Drawing.SizeF(638F, 2F);
//
// xrLine2
//
this.xrLine2.Dpi = 100F;
this.xrLine2.LocationFloat = new DevExpress.Utils.PointFloat(6F, 43F);
this.xrLine2.Name = "xrLine2";
this.xrLine2.SizeF = new System.Drawing.SizeF(638F, 2F);
//
// groupHeaderBand1
//
this.groupHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrLabel8,
this.xrLabel9,
this.xrLabel10,
this.xrLabel11,
this.xrLabel12,
this.xrLabel13,
this.xrLabel14
});
this.groupHeaderBand1.Dpi = 100F;
this.groupHeaderBand1.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] {
new DevExpress.XtraReports.UI.GroupField("MaHH", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending),
new DevExpress.XtraReports.UI.GroupField("TenHH", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending),
new DevExpress.XtraReports.UI.GroupField("DVTinh", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending),
new DevExpress.XtraReports.UI.GroupField("GiaMua", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending),
new DevExpress.XtraReports.UI.GroupField("DonGia", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending),
new DevExpress.XtraReports.UI.GroupField("SoLuongHH", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending),
new DevExpress.XtraReports.UI.GroupField("Lợi Nhuận", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending)
});
this.groupHeaderBand1.HeightF = 23F;
this.groupHeaderBand1.Name = "groupHeaderBand1";
this.groupHeaderBand1.StyleName = "DataField";
this.groupHeaderBand1.StylePriority.UseTextAlignment = false;
this.groupHeaderBand1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
//
// xrLabel8
//
this.xrLabel8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "HangHoa_1.MaHH")
});
this.xrLabel8.Dpi = 100F;
this.xrLabel8.LocationFloat = new DevExpress.Utils.PointFloat(6F, 0F);
this.xrLabel8.Name = "xrLabel8";
this.xrLabel8.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel8.SizeF = new System.Drawing.SizeF(75.59241F, 23F);
this.xrLabel8.Text = "xrLabel8";
//
// xrLabel9
//
this.xrLabel9.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "HangHoa_1.TenHH")
});
this.xrLabel9.Dpi = 100F;
this.xrLabel9.LocationFloat = new DevExpress.Utils.PointFloat(81.59241F, 0F);
this.xrLabel9.Name = "xrLabel9";
this.xrLabel9.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel9.SizeF = new System.Drawing.SizeF(135.3363F, 23F);
this.xrLabel9.StylePriority.UseTextAlignment = false;
this.xrLabel9.Text = "xrLabel9";
this.xrLabel9.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
//
// xrLabel10
//
this.xrLabel10.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "HangHoa_1.DVTinh")
});
this.xrLabel10.Dpi = 100F;
this.xrLabel10.LocationFloat = new DevExpress.Utils.PointFloat(216.9287F, 0F);
this.xrLabel10.Name = "xrLabel10";
this.xrLabel10.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel10.SizeF = new System.Drawing.SizeF(80.1279F, 23F);
this.xrLabel10.Text = "xrLabel10";
//
// xrLabel11
//
this.xrLabel11.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "HangHoa_1.GiaMua")
});
this.xrLabel11.Dpi = 100F;
this.xrLabel11.LocationFloat = new DevExpress.Utils.PointFloat(297.0567F, 0F);
this.xrLabel11.Name = "xrLabel11";
this.xrLabel11.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel11.SizeF = new System.Drawing.SizeF(86.17538F, 23F);
this.xrLabel11.Text = "xrLabel11";
//
// xrLabel12
//
this.xrLabel12.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "HangHoa_1.DonGia")
});
this.xrLabel12.Dpi = 100F;
this.xrLabel12.LocationFloat = new DevExpress.Utils.PointFloat(383.2321F, 0F);
this.xrLabel12.Name = "xrLabel12";
this.xrLabel12.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel12.SizeF = new System.Drawing.SizeF(81.6398F, 23F);
this.xrLabel12.Text = "xrLabel12";
//
// xrLabel13
//
this.xrLabel13.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "HangHoa_1.SoLuongHH")
});
this.xrLabel13.Dpi = 100F;
this.xrLabel13.LocationFloat = new DevExpress.Utils.PointFloat(464.8719F, 0F);
this.xrLabel13.Name = "xrLabel13";
this.xrLabel13.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel13.SizeF = new System.Drawing.SizeF(74.81064F, 23F);
this.xrLabel13.Text = "xrLabel13";
//
// xrLabel14
//
this.xrLabel14.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "HangHoa_1.Lợi Nhuận")
});
this.xrLabel14.Dpi = 100F;
this.xrLabel14.LocationFloat = new DevExpress.Utils.PointFloat(539.6824F, 0F);
this.xrLabel14.Name = "xrLabel14";
this.xrLabel14.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel14.SizeF = new System.Drawing.SizeF(104.3176F, 23F);
this.xrLabel14.Text = "xrLabel14";
//
// pageFooterBand1
//
this.pageFooterBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrPageInfo1,
this.xrPageInfo2
});
this.pageFooterBand1.Dpi = 100F;
this.pageFooterBand1.HeightF = 29F;
this.pageFooterBand1.Name = "pageFooterBand1";
//
// xrPageInfo1
//
this.xrPageInfo1.Dpi = 100F;
this.xrPageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 6F);
this.xrPageInfo1.Name = "xrPageInfo1";
this.xrPageInfo1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrPageInfo1.PageInfo = DevExpress.XtraPrinting.PageInfo.DateTime;
this.xrPageInfo1.SizeF = new System.Drawing.SizeF(313F, 23F);
this.xrPageInfo1.StyleName = "PageInfo";
//
// xrPageInfo2
//
this.xrPageInfo2.Dpi = 100F;
this.xrPageInfo2.Format = "Page {0} of {1}";
this.xrPageInfo2.LocationFloat = new DevExpress.Utils.PointFloat(331F, 6F);
this.xrPageInfo2.Name = "xrPageInfo2";
this.xrPageInfo2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrPageInfo2.SizeF = new System.Drawing.SizeF(313F, 23F);
this.xrPageInfo2.StyleName = "PageInfo";
this.xrPageInfo2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight;
//
// reportHeaderBand1
//
this.reportHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrRichText1,
this.xrLabel15,
this.xrLine3
});
this.reportHeaderBand1.Dpi = 100F;
this.reportHeaderBand1.HeightF = 66.12499F;
this.reportHeaderBand1.Name = "reportHeaderBand1";
this.reportHeaderBand1.StylePriority.UseTextAlignment = false;
this.reportHeaderBand1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
//
// xrRichText1
//
this.xrRichText1.Dpi = 100F;
this.xrRichText1.Font = new System.Drawing.Font("Times New Roman", 9.75F);
this.xrRichText1.LocationFloat = new DevExpress.Utils.PointFloat(539.6824F, 43.12499F);
this.xrRichText1.Name = "xrRichText1";
this.xrRichText1.SerializableRtfString = resources.GetString("xrRichText1.SerializableRtfString");
this.xrRichText1.SizeF = new System.Drawing.SizeF(100F, 23F);
//
// xrLabel15
//
this.xrLabel15.Dpi = 100F;
this.xrLabel15.LocationFloat = new DevExpress.Utils.PointFloat(6F, 2F);
this.xrLabel15.Name = "xrLabel15";
this.xrLabel15.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel15.SizeF = new System.Drawing.SizeF(638F, 39F);
this.xrLabel15.StyleName = "Title";
this.xrLabel15.Text = "THỐNG KÊ HÀNG HÓA";
//
// xrLine3
//
this.xrLine3.Dpi = 100F;
this.xrLine3.LocationFloat = new DevExpress.Utils.PointFloat(6F, 0F);
this.xrLine3.Name = "xrLine3";
this.xrLine3.SizeF = new System.Drawing.SizeF(638F, 2F);
//
// Title
//
this.Title.BackColor = System.Drawing.Color.Transparent;
this.Title.BorderColor = System.Drawing.Color.Black;
this.Title.Borders = DevExpress.XtraPrinting.BorderSide.None;
this.Title.BorderWidth = 1F;
this.Title.Font = new System.Drawing.Font("Times New Roman", 24F);
this.Title.ForeColor = System.Drawing.Color.Black;
this.Title.Name = "Title";
//
// FieldCaption
//
this.FieldCaption.BackColor = System.Drawing.Color.Transparent;
this.FieldCaption.BorderColor = System.Drawing.Color.Black;
this.FieldCaption.Borders = DevExpress.XtraPrinting.BorderSide.None;
this.FieldCaption.BorderWidth = 1F;
this.FieldCaption.Font = new System.Drawing.Font("Times New Roman", 10F, System.Drawing.FontStyle.Bold);
this.FieldCaption.ForeColor = System.Drawing.Color.Black;
this.FieldCaption.Name = "FieldCaption";
//
// PageInfo
//
this.PageInfo.BackColor = System.Drawing.Color.Transparent;
this.PageInfo.BorderColor = System.Drawing.Color.Black;
this.PageInfo.Borders = DevExpress.XtraPrinting.BorderSide.None;
this.PageInfo.BorderWidth = 1F;
this.PageInfo.Font = new System.Drawing.Font("Times New Roman", 8F);
this.PageInfo.ForeColor = System.Drawing.Color.Black;
this.PageInfo.Name = "PageInfo";
//
// DataField
//
this.DataField.BackColor = System.Drawing.Color.Transparent;
this.DataField.BorderColor = System.Drawing.Color.Black;
this.DataField.Borders = DevExpress.XtraPrinting.BorderSide.None;
this.DataField.BorderWidth = 1F;
this.DataField.Font = new System.Drawing.Font("Times New Roman", 8F);
this.DataField.ForeColor = System.Drawing.Color.Black;
this.DataField.Name = "DataField";
this.DataField.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
//
// Report1
//
this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
this.Detail,
this.TopMargin,
this.BottomMargin,
this.pageHeaderBand1,
this.groupHeaderBand1,
this.pageFooterBand1,
this.reportHeaderBand1
});
this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] {
this.sqlDataSource1
});
this.DataMember = "HangHoa_1";
this.DataSource = this.sqlDataSource1;
this.StyleSheet.AddRange(new DevExpress.XtraReports.UI.XRControlStyle[] {
this.Title,
this.FieldCaption,
this.PageInfo,
this.DataField
});
this.Version = "16.2";
((System.ComponentModel.ISupportInitialize)(this.xrRichText1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
DevExpress.DashboardCommon.Measure measure1 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.Measure measure2 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.Card card1 = new DevExpress.DashboardCommon.Card();
DevExpress.DashboardCommon.CardStretchedLayoutTemplate cardStretchedLayoutTemplate1 = new DevExpress.DashboardCommon.CardStretchedLayoutTemplate();
DevExpress.DashboardCommon.Dimension dimension1 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Dimension dimension2 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Dimension dimension3 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Dimension dimension4 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Measure measure3 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.ChartPane chartPane1 = new DevExpress.DashboardCommon.ChartPane();
DevExpress.DashboardCommon.SimpleSeries simpleSeries1 = new DevExpress.DashboardCommon.SimpleSeries();
DevExpress.DashboardCommon.CalculatedField calculatedField1 = new DevExpress.DashboardCommon.CalculatedField();
DevExpress.DataAccess.ConnectionParameters.MsSqlConnectionParameters msSqlConnectionParameters1 = new DevExpress.DataAccess.ConnectionParameters.MsSqlConnectionParameters();
DevExpress.DataAccess.Sql.SelectQuery selectQuery1 = new DevExpress.DataAccess.Sql.SelectQuery();
DevExpress.DataAccess.Sql.Column column1 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression1 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Table table1 = new DevExpress.DataAccess.Sql.Table();
DevExpress.DataAccess.Sql.Column column2 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression2 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Table table2 = new DevExpress.DataAccess.Sql.Table();
DevExpress.DataAccess.Sql.Column column3 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression3 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column4 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression4 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column5 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression5 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column6 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression6 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column7 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression7 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column8 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression8 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column9 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression9 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column10 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.CustomExpression customExpression1 = new DevExpress.DataAccess.Sql.CustomExpression();
DevExpress.DataAccess.Sql.Column column11 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression10 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.QueryParameter queryParameter1 = new DevExpress.DataAccess.Sql.QueryParameter();
DevExpress.DataAccess.Sql.Join join1 = new DevExpress.DataAccess.Sql.Join();
DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo1 = new DevExpress.DataAccess.Sql.RelationColumnInfo();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ApartmentDashboard));
DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup1 = new DevExpress.DashboardCommon.DashboardLayoutGroup();
DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem1 = new DevExpress.DashboardCommon.DashboardLayoutItem();
DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem2 = new DevExpress.DashboardCommon.DashboardLayoutItem();
DevExpress.DashboardCommon.DashboardParameter dashboardParameter1 = new DevExpress.DashboardCommon.DashboardParameter();
this.cardDashboardItem1 = new DevExpress.DashboardCommon.CardDashboardItem();
this.chartDashboardItem1 = new DevExpress.DashboardCommon.ChartDashboardItem();
this.dashboardSqlDataSource1 = new DevExpress.DashboardCommon.DashboardSqlDataSource();
((System.ComponentModel.ISupportInitialize)(this.cardDashboardItem1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension3)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension4)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure3)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// cardDashboardItem1
//
measure1.DataMember = "CostOfKv";
measure2.DataMember = "Cost";
cardStretchedLayoutTemplate1.BottomValue1.DimensionIndex = 0;
cardStretchedLayoutTemplate1.BottomValue1.ValueType = DevExpress.DashboardCommon.CardRowDataElementType.PercentVariation;
cardStretchedLayoutTemplate1.BottomValue1.Visible = true;
cardStretchedLayoutTemplate1.BottomValue2.DimensionIndex = 0;
cardStretchedLayoutTemplate1.BottomValue2.ValueType = DevExpress.DashboardCommon.CardRowDataElementType.AbsoluteVariation;
cardStretchedLayoutTemplate1.BottomValue2.Visible = true;
cardStretchedLayoutTemplate1.DeltaIndicator.Visible = true;
cardStretchedLayoutTemplate1.MainValue.DimensionIndex = 0;
cardStretchedLayoutTemplate1.MainValue.ValueType = DevExpress.DashboardCommon.CardRowDataElementType.Title;
cardStretchedLayoutTemplate1.MainValue.Visible = true;
cardStretchedLayoutTemplate1.Sparkline.Visible = true;
cardStretchedLayoutTemplate1.SubValue.DimensionIndex = 0;
cardStretchedLayoutTemplate1.SubValue.ValueType = DevExpress.DashboardCommon.CardRowDataElementType.Subtitle;
cardStretchedLayoutTemplate1.SubValue.Visible = true;
cardStretchedLayoutTemplate1.TopValue.DimensionIndex = 0;
cardStretchedLayoutTemplate1.TopValue.ValueType = DevExpress.DashboardCommon.CardRowDataElementType.ActualValue;
cardStretchedLayoutTemplate1.TopValue.Visible = true;
card1.LayoutTemplate = cardStretchedLayoutTemplate1;
card1.AddDataItem("ActualValue", measure1);
card1.AddDataItem("TargetValue", measure2);
this.cardDashboardItem1.Cards.AddRange(new DevExpress.DashboardCommon.Card[] {
card1
});
this.cardDashboardItem1.ComponentName = "cardDashboardItem1";
dimension1.DataMember = "Information";
dimension2.DataMember = "Url";
dimension3.DataMember = "CostOfKv";
this.cardDashboardItem1.DataItemRepository.Clear();
this.cardDashboardItem1.DataItemRepository.Add(dimension1, "DataItem2");
this.cardDashboardItem1.DataItemRepository.Add(dimension2, "DataItem3");
this.cardDashboardItem1.DataItemRepository.Add(dimension3, "DataItem5");
this.cardDashboardItem1.DataItemRepository.Add(measure1, "DataItem1");
this.cardDashboardItem1.DataItemRepository.Add(measure2, "DataItem0");
this.cardDashboardItem1.DataMember = "Realties";
this.cardDashboardItem1.DataSource = this.dashboardSqlDataSource1;
this.cardDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
this.cardDashboardItem1.Name = "Cards 1";
this.cardDashboardItem1.SeriesDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] {
dimension2,
dimension1
});
this.cardDashboardItem1.ShowCaption = true;
this.cardDashboardItem1.SparklineArgument = dimension3;
//
// chartDashboardItem1
//
dimension4.DataMember = "Url";
this.chartDashboardItem1.Arguments.AddRange(new DevExpress.DashboardCommon.Dimension[] {
dimension4
});
this.chartDashboardItem1.AxisX.TitleVisible = false;
this.chartDashboardItem1.ComponentName = "chartDashboardItem1";
measure3.DataMember = "CostOfKv";
this.chartDashboardItem1.DataItemRepository.Clear();
this.chartDashboardItem1.DataItemRepository.Add(measure3, "DataItem0");
this.chartDashboardItem1.DataItemRepository.Add(dimension4, "DataItem1");
this.chartDashboardItem1.DataMember = "Realties";
this.chartDashboardItem1.DataSource = this.dashboardSqlDataSource1;
this.chartDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
this.chartDashboardItem1.Name = "Chart 1";
chartPane1.Name = "Pane 1";
chartPane1.PrimaryAxisY.AlwaysShowZeroLevel = true;
chartPane1.PrimaryAxisY.ShowGridLines = true;
chartPane1.PrimaryAxisY.TitleVisible = true;
chartPane1.SecondaryAxisY.AlwaysShowZeroLevel = true;
chartPane1.SecondaryAxisY.ShowGridLines = false;
chartPane1.SecondaryAxisY.TitleVisible = true;
simpleSeries1.AddDataItem("Value", measure3);
chartPane1.Series.AddRange(new DevExpress.DashboardCommon.ChartSeries[] {
simpleSeries1
});
this.chartDashboardItem1.Panes.AddRange(new DevExpress.DashboardCommon.ChartPane[] {
chartPane1
});
this.chartDashboardItem1.ShowCaption = true;
//
// dashboardSqlDataSource1
//
calculatedField1.DataMember = "Realties";
calculatedField1.Expression = "Avg([CostOfKv])";
calculatedField1.Name = "Avg";
this.dashboardSqlDataSource1.CalculatedFields.AddRange(new DevExpress.DashboardCommon.CalculatedField[] {
calculatedField1
});
this.dashboardSqlDataSource1.ComponentName = "dashboardSqlDataSource1";
this.dashboardSqlDataSource1.ConnectionName = "localhost_Apartment_Connection";
msSqlConnectionParameters1.AuthorizationType = DevExpress.DataAccess.ConnectionParameters.MsSqlAuthorizationType.Windows;
msSqlConnectionParameters1.DatabaseName = "Apartment";
msSqlConnectionParameters1.ServerName = "localhost";
this.dashboardSqlDataSource1.ConnectionParameters = msSqlConnectionParameters1;
this.dashboardSqlDataSource1.Name = "SQL Data Source 1";
columnExpression1.ColumnName = "Name";
table1.MetaSerializable = "<Meta X=\"220\" Y=\"40\" Width=\"125\" Height=\"115\" />";
table1.Name = "Areas";
columnExpression1.Table = table1;
column1.Expression = columnExpression1;
columnExpression2.ColumnName = "Information";
table2.MetaSerializable = "<Meta X=\"30\" Y=\"30\" Width=\"125\" Height=\"305\" />";
table2.Name = "Realties";
columnExpression2.Table = table2;
column2.Expression = columnExpression2;
columnExpression3.ColumnName = "Cost";
columnExpression3.Table = table2;
column3.Expression = columnExpression3;
columnExpression4.ColumnName = "RoomCount";
columnExpression4.Table = table2;
column4.Expression = columnExpression4;
columnExpression5.ColumnName = "Url";
columnExpression5.Table = table2;
column5.Expression = columnExpression5;
columnExpression6.ColumnName = "Comment";
columnExpression6.Table = table2;
column6.Expression = columnExpression6;
columnExpression7.ColumnName = "Series";
columnExpression7.Table = table2;
column7.Expression = columnExpression7;
columnExpression8.ColumnName = "DateRegistration";
columnExpression8.Table = table2;
column8.Expression = columnExpression8;
columnExpression9.ColumnName = "Area";
columnExpression9.Table = table2;
column9.Expression = columnExpression9;
column10.Alias = "CostOfKv";
customExpression1.Expression = "[Realties.Cost]/[Realties.Area]";
column10.Expression = customExpression1;
columnExpression10.ColumnName = "Id";
columnExpression10.Table = table1;
column11.Expression = columnExpression10;
selectQuery1.Columns.Add(column1);
selectQuery1.Columns.Add(column2);
selectQuery1.Columns.Add(column3);
selectQuery1.Columns.Add(column4);
selectQuery1.Columns.Add(column5);
selectQuery1.Columns.Add(column6);
selectQuery1.Columns.Add(column7);
selectQuery1.Columns.Add(column8);
selectQuery1.Columns.Add(column9);
selectQuery1.Columns.Add(column10);
selectQuery1.Columns.Add(column11);
selectQuery1.FilterString = "[Realties.Cost] Is Not Null And [Realties.Area] Is Not Null And [Realties.Area] <" +
"> 0s And [Areas.Id] = ?IdArea";
selectQuery1.GroupFilterString = "";
selectQuery1.Name = "Realties";
queryParameter1.Name = "IdArea";
queryParameter1.Type = typeof(DevExpress.DataAccess.Expression);
queryParameter1.Value = new DevExpress.DataAccess.Expression("?IdArea", typeof(int));
selectQuery1.Parameters.Add(queryParameter1);
relationColumnInfo1.NestedKeyColumn = "Id";
relationColumnInfo1.ParentKeyColumn = "IdArea";
join1.KeyColumns.Add(relationColumnInfo1);
join1.Nested = table1;
join1.Parent = table2;
selectQuery1.Relations.Add(join1);
selectQuery1.Tables.Add(table2);
selectQuery1.Tables.Add(table1);
this.dashboardSqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
selectQuery1
});
this.dashboardSqlDataSource1.ResultSchemaSerializable = resources.GetString("dashboardSqlDataSource1.ResultSchemaSerializable");
//
// ApartmentDashboard
//
this.DataSources.AddRange(new DevExpress.DashboardCommon.IDashboardDataSource[] {
this.dashboardSqlDataSource1
});
this.Items.AddRange(new DevExpress.DashboardCommon.DashboardItem[] {
this.cardDashboardItem1,
this.chartDashboardItem1
});
dashboardLayoutItem1.DashboardItem = this.cardDashboardItem1;
dashboardLayoutItem1.Weight = 0.25D;
dashboardLayoutItem2.DashboardItem = this.chartDashboardItem1;
dashboardLayoutItem2.Weight = 0.25D;
dashboardLayoutGroup1.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
dashboardLayoutItem1,
dashboardLayoutItem2
});
dashboardLayoutGroup1.DashboardItem = null;
dashboardLayoutGroup1.Weight = 100D;
this.LayoutRoot = dashboardLayoutGroup1;
dashboardParameter1.Name = "IdArea";
dashboardParameter1.Type = typeof(int);
dashboardParameter1.Value = 7;
this.Parameters.AddRange(new DevExpress.DashboardCommon.DashboardParameter[] {
dashboardParameter1
});
this.Title.Text = "Dashboard";
((System.ComponentModel.ISupportInitialize)(measure1)).EndInit();
((System.ComponentModel.ISupportInitialize)(measure2)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension1)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension2)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension3)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.cardDashboardItem1)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension4)).EndInit();
((System.ComponentModel.ISupportInitialize)(measure3)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
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.CustomExpression customExpression1 = new DevExpress.DataAccess.Sql.CustomExpression();
DevExpress.DataAccess.Sql.Column column4 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression3 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column5 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression4 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group1 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression5 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group2 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression6 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group3 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression7 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group4 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression8 = 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.Table table3 = new DevExpress.DataAccess.Sql.Table();
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(XtraReport1));
DevExpress.XtraCharts.XYDiagram xyDiagram1 = new DevExpress.XtraCharts.XYDiagram();
DevExpress.XtraCharts.Legend legend1 = new DevExpress.XtraCharts.Legend();
DevExpress.XtraCharts.Series series1 = new DevExpress.XtraCharts.Series();
DevExpress.XtraCharts.StackedBarSeriesView stackedBarSeriesView1 = new DevExpress.XtraCharts.StackedBarSeriesView();
DevExpress.XtraReports.Parameters.DynamicListLookUpSettings dynamicListLookUpSettings1 = new DevExpress.XtraReports.Parameters.DynamicListLookUpSettings();
DevExpress.XtraReports.Parameters.DynamicListLookUpSettings dynamicListLookUpSettings2 = new DevExpress.XtraReports.Parameters.DynamicListLookUpSettings();
this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components);
this.Detail = new DevExpress.XtraReports.UI.DetailBand();
this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand();
this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand();
this.xrChart1 = new DevExpress.XtraReports.UI.XRChart();
this.Moneda = new DevExpress.XtraReports.Parameters.Parameter();
this.UnidadArtistica = new DevExpress.XtraReports.Parameters.Parameter();
this.Desde = new DevExpress.XtraReports.Parameters.Parameter();
this.Hasta = new DevExpress.XtraReports.Parameters.Parameter();
this.ReportHeader = new DevExpress.XtraReports.UI.ReportHeaderBand();
((System.ComponentModel.ISupportInitialize)(this.xrChart1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(xyDiagram1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(series1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(stackedBarSeriesView1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// sqlDataSource1
//
this.sqlDataSource1.ConnectionName = "DXApplication9.Properties.Settings.artistasConnectionString";
this.sqlDataSource1.Name = "sqlDataSource1";
columnExpression1.ColumnName = "Nombre";
table1.Name = "Agrupacion";
columnExpression1.Table = table1;
column1.Expression = columnExpression1;
columnExpression2.ColumnName = "Abreviatura";
table2.Name = "TipoMoneda";
columnExpression2.Table = table2;
column2.Expression = columnExpression2;
column3.Alias = "Expr";
customExpression1.Aggregate = DevExpress.DataAccess.Sql.AggregationType.Sum;
customExpression1.Expression = "[OrdenDeTrabajo.ImporteFinal] * (100-[OrdenDeTrabajo.PorcientoCliente])/100";
column3.Expression = customExpression1;
columnExpression3.ColumnName = "AgrupacionID";
columnExpression3.Table = table1;
column4.Expression = columnExpression3;
columnExpression4.ColumnName = "TipoMonedaID";
columnExpression4.Table = table2;
column5.Expression = columnExpression4;
selectQuery1.Columns.Add(column1);
selectQuery1.Columns.Add(column2);
selectQuery1.Columns.Add(column3);
selectQuery1.Columns.Add(column4);
selectQuery1.Columns.Add(column5);
selectQuery1.FilterString = "[OrdenDeTrabajo.Estado] <> 1s And [OrdenDeTrabajo.Estado] <> 3s";
selectQuery1.GroupFilterString = "";
columnExpression5.ColumnName = "TipoMonedaID";
columnExpression5.Table = table2;
group1.Expression = columnExpression5;
columnExpression6.ColumnName = "AgrupacionID";
columnExpression6.Table = table1;
group2.Expression = columnExpression6;
columnExpression7.ColumnName = "Nombre";
columnExpression7.Table = table1;
group3.Expression = columnExpression7;
columnExpression8.ColumnName = "Abreviatura";
columnExpression8.Table = table2;
group4.Expression = columnExpression8;
selectQuery1.Groups.Add(group1);
selectQuery1.Groups.Add(group2);
selectQuery1.Groups.Add(group3);
selectQuery1.Groups.Add(group4);
selectQuery1.Name = "Agrupacion_1";
relationColumnInfo1.NestedKeyColumn = "AgrupacionId";
relationColumnInfo1.ParentKeyColumn = "AgrupacionID";
join1.KeyColumns.Add(relationColumnInfo1);
table3.Name = "OrdenDeTrabajo";
join1.Nested = table3;
join1.Parent = table1;
relationColumnInfo2.NestedKeyColumn = "TipoMonedaID";
relationColumnInfo2.ParentKeyColumn = "TipoMonedaId";
join2.KeyColumns.Add(relationColumnInfo2);
join2.Nested = table2;
join2.Parent = table3;
selectQuery1.Relations.Add(join1);
selectQuery1.Relations.Add(join2);
selectQuery1.Tables.Add(table1);
selectQuery1.Tables.Add(table3);
selectQuery1.Tables.Add(table2);
this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
selectQuery1
});
this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable");
//
// Detail
//
this.Detail.Dpi = 254F;
this.Detail.HeightF = 0F;
this.Detail.KeepTogether = true;
this.Detail.Name = "Detail";
this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 254F);
this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
//
// TopMargin
//
this.TopMargin.Dpi = 254F;
this.TopMargin.HeightF = 132F;
this.TopMargin.Name = "TopMargin";
this.TopMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 254F);
this.TopMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
//
// BottomMargin
//
this.BottomMargin.Dpi = 254F;
this.BottomMargin.HeightF = 132F;
this.BottomMargin.Name = "BottomMargin";
this.BottomMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 254F);
this.BottomMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
//
// xrChart1
//
this.xrChart1.BorderColor = System.Drawing.Color.Black;
this.xrChart1.Borders = DevExpress.XtraPrinting.BorderSide.None;
this.xrChart1.DataMember = "Agrupacion_1";
this.xrChart1.DataSource = this.sqlDataSource1;
xyDiagram1.AxisX.VisibleInPanesSerializable = "-1";
xyDiagram1.AxisY.VisibleInPanesSerializable = "-1";
xyDiagram1.DefaultPane.EnableAxisXScrolling = DevExpress.Utils.DefaultBoolean.False;
xyDiagram1.DefaultPane.EnableAxisXZooming = DevExpress.Utils.DefaultBoolean.False;
xyDiagram1.DefaultPane.EnableAxisYScrolling = DevExpress.Utils.DefaultBoolean.False;
xyDiagram1.DefaultPane.EnableAxisYZooming = DevExpress.Utils.DefaultBoolean.False;
this.xrChart1.Diagram = xyDiagram1;
this.xrChart1.Dpi = 254F;
this.xrChart1.Legend.Name = "Default Legend";
legend1.Name = "Legend1";
this.xrChart1.Legends.AddRange(new DevExpress.XtraCharts.Legend[] {
legend1
});
this.xrChart1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 24.99998F);
this.xrChart1.Name = "xrChart1";
this.xrChart1.SeriesDataMember = "TipoMonedaID";
series1.ArgumentDataMember = "Nombre";
series1.Name = "Series 4";
series1.SummaryFunction = "SUM([Expr])";
this.xrChart1.SeriesSerializable = new DevExpress.XtraCharts.Series[] {
series1
};
this.xrChart1.SeriesTemplate.ArgumentDataMember = "Expr";
this.xrChart1.SeriesTemplate.View = stackedBarSeriesView1;
this.xrChart1.SizeF = new System.Drawing.SizeF(2440.94F, 2809.044F);
//
// Moneda
//
this.Moneda.Description = "Moneda";
dynamicListLookUpSettings1.DataAdapter = null;
dynamicListLookUpSettings1.DataMember = "Agrupacion_1";
dynamicListLookUpSettings1.DataSource = this.sqlDataSource1;
dynamicListLookUpSettings1.DisplayMember = "Abreviatura";
dynamicListLookUpSettings1.ValueMember = "TipoMonedaID";
this.Moneda.LookUpSettings = dynamicListLookUpSettings1;
this.Moneda.Name = "Moneda";
this.Moneda.Type = typeof(int);
this.Moneda.ValueInfo = "0";
//
// UnidadArtistica
//
this.UnidadArtistica.Description = "Unidad Artística:";
dynamicListLookUpSettings2.DataAdapter = null;
dynamicListLookUpSettings2.DataMember = "Agrupacion_1";
dynamicListLookUpSettings2.DataSource = this.sqlDataSource1;
dynamicListLookUpSettings2.DisplayMember = "Nombre";
dynamicListLookUpSettings2.ValueMember = "AgrupacionID";
this.UnidadArtistica.LookUpSettings = dynamicListLookUpSettings2;
this.UnidadArtistica.MultiValue = true;
this.UnidadArtistica.Name = "UnidadArtistica";
this.UnidadArtistica.Type = typeof(int);
this.UnidadArtistica.ValueInfo = "0";
//
// Desde
//
this.Desde.Description = "Desde:";
this.Desde.Name = "Desde";
this.Desde.Type = typeof(System.DateTime);
//
// Hasta
//
this.Hasta.Description = "Hasta:";
this.Hasta.Name = "Hasta";
this.Hasta.Type = typeof(System.DateTime);
this.Hasta.ValueInfo = "2050-01-01";
//
// ReportHeader
//
this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrChart1
});
this.ReportHeader.Dpi = 254F;
this.ReportHeader.HeightF = 2834.044F;
this.ReportHeader.Name = "ReportHeader";
//
// XtraReport1
//
this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
this.Detail,
this.TopMargin,
this.BottomMargin,
this.ReportHeader
});
this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] {
this.sqlDataSource1
});
this.DataMember = "Agrupacion_1";
this.DataSource = this.sqlDataSource1;
this.Dpi = 254F;
this.FilterString = "[AgrupacionID] In (?UnidadArtistica) And [TipoMonedaID] = ?Moneda And [FechaLiqui" +
"dacion] >= ?Desde And [FechaLiquidacion] <= ?Hasta";
this.Landscape = true;
this.Margins = new System.Drawing.Printing.Margins(178, 150, 132, 132);
this.PageHeight = 2159;
this.PageWidth = 2794;
this.PaperKind = System.Drawing.Printing.PaperKind.Custom;
this.Parameters.AddRange(new DevExpress.XtraReports.Parameters.Parameter[] {
this.Moneda,
this.UnidadArtistica,
this.Desde,
this.Hasta
});
this.ReportUnit = DevExpress.XtraReports.UI.ReportUnit.TenthsOfAMillimeter;
this.RollPaper = true;
this.SnapGridSize = 25F;
this.Version = "17.1";
((System.ComponentModel.ISupportInitialize)(xyDiagram1)).EndInit();
((System.ComponentModel.ISupportInitialize)(series1)).EndInit();
((System.ComponentModel.ISupportInitialize)(stackedBarSeriesView1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.xrChart1)).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()
{
this.components = new System.ComponentModel.Container();
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.CustomExpression customExpression1 = new DevExpress.DataAccess.Sql.CustomExpression();
DevExpress.DataAccess.Sql.Column column4 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression3 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Table table2 = new DevExpress.DataAccess.Sql.Table();
DevExpress.DataAccess.Sql.Group group1 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression4 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group2 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression5 = 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.Sorting sorting1 = new DevExpress.DataAccess.Sql.Sorting();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression6 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Sorting sorting2 = new DevExpress.DataAccess.Sql.Sorting();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression7 = new DevExpress.DataAccess.Sql.ColumnExpression();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(XtraReport1));
this.Detail = new DevExpress.XtraReports.UI.DetailBand();
this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel();
this.xrTable1 = new DevExpress.XtraReports.UI.XRTable();
this.xrTableRow2 = new DevExpress.XtraReports.UI.XRTableRow();
this.xrTableCell4 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell5 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell6 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableRow1 = new DevExpress.XtraReports.UI.XRTableRow();
this.xrTableCell1 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell2 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell3 = new DevExpress.XtraReports.UI.XRTableCell();
this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand();
this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand();
this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components);
this.calculatedField1 = new DevExpress.XtraReports.UI.CalculatedField();
((System.ComponentModel.ISupportInitialize)(this.xrTable1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// Detail
//
this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrLabel2,
this.xrLabel1,
this.xrTable1
});
this.Detail.HeightF = 107.0659F;
this.Detail.Name = "Detail";
this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F);
this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
//
// xrLabel2
//
this.xrLabel2.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "Products.CategoryName")
});
this.xrLabel2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(440.5816F, 0F);
this.xrLabel2.Name = "xrLabel2";
this.xrLabel2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel2.SizeF = new System.Drawing.SizeF(209.4184F, 23.95833F);
this.xrLabel2.StylePriority.UseFont = false;
this.xrLabel2.StylePriority.UseTextAlignment = false;
this.xrLabel2.Text = "xrLabel2";
this.xrLabel2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight;
//
// xrLabel1
//
this.xrLabel1.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "Products.CategoryID", "Category: {0}")
});
this.xrLabel1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F);
this.xrLabel1.Name = "xrLabel1";
this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel1.SizeF = new System.Drawing.SizeF(177.5897F, 24.9566F);
this.xrLabel1.StylePriority.UseFont = false;
//
// xrTable1
//
this.xrTable1.BorderColor = System.Drawing.Color.Gainsboro;
this.xrTable1.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top)
| DevExpress.XtraPrinting.BorderSide.Right)
| DevExpress.XtraPrinting.BorderSide.Bottom)));
this.xrTable1.Font = new System.Drawing.Font("Tahoma", 9.75F);
this.xrTable1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 26.45833F);
this.xrTable1.Name = "xrTable1";
this.xrTable1.Padding = new DevExpress.XtraPrinting.PaddingInfo(4, 4, 4, 4, 100F);
this.xrTable1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
this.xrTableRow2,
this.xrTableRow1
});
this.xrTable1.SizeF = new System.Drawing.SizeF(650F, 50F);
this.xrTable1.StylePriority.UseBorderColor = false;
this.xrTable1.StylePriority.UseBorders = false;
this.xrTable1.StylePriority.UseFont = false;
this.xrTable1.StylePriority.UsePadding = false;
this.xrTable1.StylePriority.UseTextAlignment = false;
this.xrTable1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
//
// xrTableRow2
//
this.xrTableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
this.xrTableCell4,
this.xrTableCell5,
this.xrTableCell6
});
this.xrTableRow2.Name = "xrTableRow2";
this.xrTableRow2.Weight = 11.5D;
//
// xrTableCell4
//
this.xrTableCell4.Name = "xrTableCell4";
this.xrTableCell4.Text = "Sum (Unit Price * Units In Stock)";
this.xrTableCell4.Weight = 0.2857142857142857D;
//
// xrTableCell5
//
this.xrTableCell5.Name = "xrTableCell5";
this.xrTableCell5.Text = "Sum (Units In Stock)";
this.xrTableCell5.Weight = 0.19159405048076922D;
//
// xrTableCell6
//
this.xrTableCell6.Name = "xrTableCell6";
this.xrTableCell6.Text = "Price average (weighted over units in stock)";
this.xrTableCell6.Weight = 0.37983452094780218D;
//
// xrTableRow1
//
this.xrTableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
this.xrTableCell1,
this.xrTableCell2,
this.xrTableCell3
});
this.xrTableRow1.Name = "xrTableRow1";
this.xrTableRow1.Weight = 11.5D;
//
// xrTableCell1
//
this.xrTableCell1.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "Products.Sum_PriceInStock")
});
this.xrTableCell1.Name = "xrTableCell1";
this.xrTableCell1.StylePriority.UseTextAlignment = false;
this.xrTableCell1.Text = "xrTableCell1";
this.xrTableCell1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrTableCell1.Weight = 0.2857142857142857D;
//
// xrTableCell2
//
this.xrTableCell2.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "Products.Sum_UnitsInStock")
});
this.xrTableCell2.Name = "xrTableCell2";
this.xrTableCell2.StylePriority.UseTextAlignment = false;
this.xrTableCell2.Text = "xrTableCell2";
this.xrTableCell2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrTableCell2.Weight = 0.19159405048076922D;
//
// xrTableCell3
//
this.xrTableCell3.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "Products.calculatedField1", "{0:#.0000}")
});
this.xrTableCell3.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
this.xrTableCell3.Name = "xrTableCell3";
this.xrTableCell3.StylePriority.UseFont = false;
this.xrTableCell3.StylePriority.UseTextAlignment = false;
this.xrTableCell3.Text = "xrTableCell3";
this.xrTableCell3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrTableCell3.Weight = 0.37983452094780218D;
//
// TopMargin
//
this.TopMargin.HeightF = 100F;
this.TopMargin.Name = "TopMargin";
this.TopMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F);
this.TopMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
//
// BottomMargin
//
this.BottomMargin.HeightF = 100F;
this.BottomMargin.Name = "BottomMargin";
this.BottomMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F);
this.BottomMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
//
// sqlDataSource1
//
this.sqlDataSource1.ConnectionName = "nwind";
this.sqlDataSource1.Name = "sqlDataSource1";
column1.Alias = "Sum_UnitsInStock";
columnExpression1.Aggregate = DevExpress.DataAccess.Sql.AggregationType.Sum;
columnExpression1.ColumnName = "UnitsInStock";
table1.Name = "Products";
columnExpression1.Table = table1;
column1.Expression = columnExpression1;
columnExpression2.ColumnName = "CategoryID";
columnExpression2.Table = table1;
column2.Expression = columnExpression2;
column3.Alias = "Sum_PriceInStock";
customExpression1.Aggregate = DevExpress.DataAccess.Sql.AggregationType.Sum;
customExpression1.Expression = "[Products].[UnitPrice] * [Products].[UnitsInStock]";
column3.Expression = customExpression1;
columnExpression3.ColumnName = "CategoryName";
table2.Name = "Categories";
columnExpression3.Table = table2;
column4.Expression = columnExpression3;
selectQuery1.Columns.Add(column1);
selectQuery1.Columns.Add(column2);
selectQuery1.Columns.Add(column3);
selectQuery1.Columns.Add(column4);
columnExpression4.ColumnName = "CategoryID";
columnExpression4.Table = table1;
group1.Expression = columnExpression4;
columnExpression5.ColumnName = "CategoryName";
columnExpression5.Table = table2;
group2.Expression = columnExpression5;
selectQuery1.Groups.Add(group1);
selectQuery1.Groups.Add(group2);
selectQuery1.Name = "Products";
relationColumnInfo1.NestedKeyColumn = "CategoryID";
relationColumnInfo1.ParentKeyColumn = "CategoryID";
join1.KeyColumns.Add(relationColumnInfo1);
join1.Nested = table2;
join1.Parent = table1;
selectQuery1.Relations.Add(join1);
columnExpression6.ColumnName = "CategoryID";
columnExpression6.Table = table1;
sorting1.Expression = columnExpression6;
columnExpression7.ColumnName = "CategoryName";
columnExpression7.Table = table2;
sorting2.Expression = columnExpression7;
selectQuery1.Sorting.Add(sorting1);
selectQuery1.Sorting.Add(sorting2);
selectQuery1.Tables.Add(table1);
selectQuery1.Tables.Add(table2);
this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
selectQuery1
});
this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable");
//
// calculatedField1
//
this.calculatedField1.DataMember = "Products";
this.calculatedField1.Expression = "[Sum_PriceInStock] / [Sum_UnitsInStock]";
this.calculatedField1.Name = "calculatedField1";
//
// XtraReport1
//
this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
this.Detail,
this.TopMargin,
this.BottomMargin
});
this.CalculatedFields.AddRange(new DevExpress.XtraReports.UI.CalculatedField[] {
this.calculatedField1
});
this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] {
this.sqlDataSource1
});
this.DataMember = "Products";
this.DataSource = this.sqlDataSource1;
this.Version = "16.1";
((System.ComponentModel.ISupportInitialize)(this.xrTable1)).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()
{
this.components = new System.ComponentModel.Container();
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.CustomExpression customExpression1 = new DevExpress.DataAccess.Sql.CustomExpression();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(PeriodicBalance));
DevExpress.XtraReports.Parameters.DynamicListLookUpSettings dynamicListLookUpSettings1 = new DevExpress.XtraReports.Parameters.DynamicListLookUpSettings();
DevExpress.XtraReports.Parameters.DynamicListLookUpSettings dynamicListLookUpSettings2 = new DevExpress.XtraReports.Parameters.DynamicListLookUpSettings();
DevExpress.XtraReports.Parameters.DynamicListLookUpSettings dynamicListLookUpSettings3 = new DevExpress.XtraReports.Parameters.DynamicListLookUpSettings();
this.sqlDataSource2 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components);
this.topMarginBand1 = new DevExpress.XtraReports.UI.TopMarginBand();
this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel();
this.Credit = new DevExpress.XtraReports.UI.XRLabel();
this.Debit = new DevExpress.XtraReports.UI.XRLabel();
this.Periode = new DevExpress.XtraReports.UI.XRLabel();
this.AccountName = new DevExpress.XtraReports.UI.XRLabel();
this.AccountID = new DevExpress.XtraReports.UI.XRLabel();
this.detailBand1 = new DevExpress.XtraReports.UI.DetailBand();
this.xrTable3 = new DevExpress.XtraReports.UI.XRTable();
this.xrTableRow3 = new DevExpress.XtraReports.UI.XRTableRow();
this.xrTableCell13 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell14 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell15 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell16 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell17 = new DevExpress.XtraReports.UI.XRTableCell();
this.bottomMarginBand1 = new DevExpress.XtraReports.UI.BottomMarginBand();
this.PageHeader = new DevExpress.XtraReports.UI.PageHeaderBand();
this.parameterAccount = new DevExpress.XtraReports.Parameters.Parameter();
this.paramPeriodFrom = new DevExpress.XtraReports.Parameters.Parameter();
this.paramPeriodTo = new DevExpress.XtraReports.Parameters.Parameter();
this.xrControlStyle1 = new DevExpress.XtraReports.UI.XRControlStyle();
((System.ComponentModel.ISupportInitialize)(this.xrTable3)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// sqlDataSource2
//
this.sqlDataSource2.ConnectionName = "IWSConnectionString";
this.sqlDataSource2.Name = "sqlDataSource2";
columnExpression1.ColumnName = "AccountId";
table1.MetaSerializable = "30|30|125|200";
table1.Name = "PeriodicAccountBalance";
columnExpression1.Table = table1;
column1.Expression = columnExpression1;
columnExpression2.ColumnName = "Name";
columnExpression2.Table = table1;
column2.Expression = columnExpression2;
columnExpression3.ColumnName = "Periode";
columnExpression3.Table = table1;
column3.Expression = columnExpression3;
columnExpression4.ColumnName = "Debit";
columnExpression4.Table = table1;
column4.Expression = columnExpression4;
columnExpression5.ColumnName = "Credit";
columnExpression5.Table = table1;
column5.Expression = columnExpression5;
column6.Alias = "Account";
customExpression1.Expression = "AccountId + \'-\' + Name";
column6.Expression = customExpression1;
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.Name = "PeriodicAccountBalance";
selectQuery1.Tables.Add(table1);
this.sqlDataSource2.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
selectQuery1
});
this.sqlDataSource2.ResultSchemaSerializable = resources.GetString("sqlDataSource2.ResultSchemaSerializable");
//
// topMarginBand1
//
this.topMarginBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrLabel1
});
this.topMarginBand1.Dpi = 100F;
this.topMarginBand1.HeightF = 75F;
this.topMarginBand1.Name = "topMarginBand1";
//
// xrLabel1
//
this.xrLabel1.Dpi = 100F;
this.xrLabel1.Font = new System.Drawing.Font("Times New Roman", 12F, System.Drawing.FontStyle.Bold);
this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(74.16666F, 18.33333F);
this.xrLabel1.Name = "xrLabel1";
this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel1.SizeF = new System.Drawing.SizeF(473.3333F, 33.33334F);
this.xrLabel1.StylePriority.UseFont = false;
this.xrLabel1.Text = global::IWSProject.Content.IWSLocalResource.PeriodicAccountBalance;
//
// Credit
//
this.Credit.BackColor = System.Drawing.Color.Gainsboro;
this.Credit.Dpi = 100F;
this.Credit.Font = new System.Drawing.Font("Times New Roman", 10.2F, System.Drawing.FontStyle.Bold);
this.Credit.LocationFloat = new DevExpress.Utils.PointFloat(532.5F, 10F);
this.Credit.Name = "Credit";
this.Credit.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight;
this.Credit.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.Credit.SizeF = new System.Drawing.SizeF(117.5F, 23F);
this.Credit.StylePriority.UseBackColor = false;
this.Credit.StylePriority.UseFont = false;
this.Credit.Text = global::IWSProject.Content.IWSLocalResource.credit;
//
// Debit
//
this.Debit.BackColor = System.Drawing.Color.Gainsboro;
this.Debit.Dpi = 100F;
this.Debit.Font = new System.Drawing.Font("Times New Roman", 10.2F, System.Drawing.FontStyle.Bold);
this.Debit.LocationFloat = new DevExpress.Utils.PointFloat(402.5F, 10F);
this.Debit.Name = "Debit";
this.Debit.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight;
this.Debit.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.Debit.SizeF = new System.Drawing.SizeF(130F, 23F);
this.Debit.StylePriority.UseBackColor = false;
this.Debit.StylePriority.UseFont = false;
this.Debit.Text = global::IWSProject.Content.IWSLocalResource.debit;
//
// Periode
//
this.Periode.BackColor = System.Drawing.Color.Gainsboro;
this.Periode.Dpi = 100F;
this.Periode.Font = new System.Drawing.Font("Times New Roman", 10.2F, System.Drawing.FontStyle.Bold);
this.Periode.LocationFloat = new DevExpress.Utils.PointFloat(314.1667F, 10F);
this.Periode.Name = "Periode";
this.Periode.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight;
this.Periode.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.Periode.SizeF = new System.Drawing.SizeF(88.33334F, 23F);
this.Periode.StylePriority.UseBackColor = false;
this.Periode.StylePriority.UseFont = false;
this.Periode.Text = global::IWSProject.Content.IWSLocalResource.periode;
//
// AccountName
//
this.AccountName.BackColor = System.Drawing.Color.Gainsboro;
this.AccountName.Dpi = 100F;
this.AccountName.Font = new System.Drawing.Font("Times New Roman", 10.2F, System.Drawing.FontStyle.Bold);
this.AccountName.LocationFloat = new DevExpress.Utils.PointFloat(74.16666F, 10F);
this.AccountName.Name = "AccountName";
this.AccountName.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.AccountName.SizeF = new System.Drawing.SizeF(240F, 23F);
this.AccountName.StylePriority.UseBackColor = false;
this.AccountName.StylePriority.UseFont = false;
this.AccountName.Text = global::IWSProject.Content.IWSLocalResource.name;
//
// AccountID
//
this.AccountID.BackColor = System.Drawing.Color.Gainsboro;
this.AccountID.Dpi = 100F;
this.AccountID.Font = new System.Drawing.Font("Times New Roman", 10.2F, System.Drawing.FontStyle.Bold);
this.AccountID.LocationFloat = new DevExpress.Utils.PointFloat(0F, 10F);
this.AccountID.Name = "AccountID";
this.AccountID.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.AccountID.SizeF = new System.Drawing.SizeF(74.16667F, 23F);
this.AccountID.StylePriority.UseBackColor = false;
this.AccountID.StylePriority.UseFont = false;
this.AccountID.Text = global::IWSProject.Content.IWSLocalResource.accountid;
//
// detailBand1
//
this.detailBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrTable3
});
this.detailBand1.Dpi = 100F;
this.detailBand1.HeightF = 27.5F;
this.detailBand1.Name = "detailBand1";
//
// xrTable3
//
this.xrTable3.Dpi = 100F;
this.xrTable3.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F);
this.xrTable3.Name = "xrTable3";
this.xrTable3.OddStyleName = "xrControlStyle1";
this.xrTable3.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
this.xrTableRow3
});
this.xrTable3.SizeF = new System.Drawing.SizeF(650F, 25F);
//
// xrTableRow3
//
this.xrTableRow3.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
this.xrTableCell13,
this.xrTableCell14,
this.xrTableCell15,
this.xrTableCell16,
this.xrTableCell17
});
this.xrTableRow3.Dpi = 100F;
this.xrTableRow3.Name = "xrTableRow3";
this.xrTableRow3.Weight = 11.5D;
//
// xrTableCell13
//
this.xrTableCell13.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "PeriodicAccountBalance.AccountId")
});
this.xrTableCell13.Dpi = 100F;
this.xrTableCell13.Name = "xrTableCell13";
this.xrTableCell13.Text = "xrTableCell13";
this.xrTableCell13.Weight = 0.38D;
this.xrTableCell13.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
//
// xrTableCell14
//
this.xrTableCell14.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "PeriodicAccountBalance.Name")
});
this.xrTableCell14.Dpi = 100F;
this.xrTableCell14.Name = "xrTableCell14";
this.xrTableCell14.Weight = 1.23D;
this.xrTableCell14.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
//
// xrTableCell15
//
this.xrTableCell15.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "PeriodicAccountBalance.Periode")
});
this.xrTableCell15.Dpi = 100F;
this.xrTableCell15.Name = "xrTableCell15";
this.xrTableCell15.Weight = 0.45D;
this.xrTableCell15.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight;
//
// xrTableCell16
//
this.xrTableCell16.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "PeriodicAccountBalance.Debit", "{0:0.00€}")
});
this.xrTableCell16.Dpi = 100F;
this.xrTableCell16.Name = "xrTableCell16";
this.xrTableCell16.Weight = 0.67D;
this.xrTableCell16.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight;
//
// xrTableCell17
//
this.xrTableCell17.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "PeriodicAccountBalance.Credit", "{0:0.00€}")
});
this.xrTableCell17.Dpi = 100F;
this.xrTableCell17.Name = "xrTableCell17";
this.xrTableCell17.Weight = 0.60D;
this.xrTableCell17.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight;
//
// bottomMarginBand1
//
this.bottomMarginBand1.Dpi = 100F;
this.bottomMarginBand1.HeightF = 100F;
this.bottomMarginBand1.Name = "bottomMarginBand1";
//
// PageHeader
//
this.PageHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.AccountName,
this.AccountID,
this.Periode,
this.Debit,
this.Credit
});
this.PageHeader.Dpi = 100F;
this.PageHeader.HeightF = 45F;
this.PageHeader.Name = "PageHeader";
//
// parameterAccount
//
this.parameterAccount.Description = global::IWSProject.Content.IWSLocalResource.account;
dynamicListLookUpSettings1.DataAdapter = null;
dynamicListLookUpSettings1.DataMember = "PeriodicAccountBalance";
dynamicListLookUpSettings1.DataSource = this.sqlDataSource2;
dynamicListLookUpSettings1.DisplayMember = "Account";
dynamicListLookUpSettings1.ValueMember = "Account";
this.parameterAccount.LookUpSettings = dynamicListLookUpSettings1;
this.parameterAccount.MultiValue = true;
this.parameterAccount.Name = "parameterAccount";
//
// paramPeriodFrom
//
this.paramPeriodFrom.Description = global::IWSProject.Content.IWSLocalResource.PeriodFrom;
dynamicListLookUpSettings2.DataAdapter = null;
dynamicListLookUpSettings2.DataMember = "PeriodicAccountBalance";
dynamicListLookUpSettings2.DataSource = this.sqlDataSource2;
dynamicListLookUpSettings2.DisplayMember = "Periode";
dynamicListLookUpSettings2.FilterString = null;
dynamicListLookUpSettings2.ValueMember = "Periode";
this.paramPeriodFrom.LookUpSettings = dynamicListLookUpSettings2;
this.paramPeriodFrom.Name = "paramPeriodFrom";
//paramPeriodFrom.ValueInfo = IWSLookUp.GetPeriodMin();
//
// paramPeriodTo
//
this.paramPeriodTo.Description = global::IWSProject.Content.IWSLocalResource.PeriodTo;
dynamicListLookUpSettings3.DataAdapter = null;
dynamicListLookUpSettings3.DataMember = "PeriodicAccountBalance";
dynamicListLookUpSettings3.DataSource = this.sqlDataSource2;
dynamicListLookUpSettings3.DisplayMember = "Periode";
dynamicListLookUpSettings3.FilterString = null;
dynamicListLookUpSettings3.ValueMember = "Periode";
this.paramPeriodTo.LookUpSettings = dynamicListLookUpSettings3;
this.paramPeriodTo.Name = "paramPeriodTo";
//paramPeriodTo.ValueInfo = IWSLookUp.GetPeriodMax();
// xrControlStyle1
//
this.xrControlStyle1.BackColor = System.Drawing.Color.WhiteSmoke;
this.xrControlStyle1.Name = "xrControlStyle1";
//
// PeriodicBalance
//
this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
this.topMarginBand1,
this.detailBand1,
this.bottomMarginBand1,
this.PageHeader
});
this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] {
this.sqlDataSource2
});
this.DataMember = "PeriodicAccountBalance";
this.DataSource = this.sqlDataSource2;
this.FilterString = "[Account] In (?parameterAccount) And [Periode] Between(?paramPeriodFrom, ?paramPe" +
"riodTo)";
this.Margins = new System.Drawing.Printing.Margins(100, 100, 75, 100);
this.Parameters.AddRange(new DevExpress.XtraReports.Parameters.Parameter[] {
this.parameterAccount,
this.paramPeriodFrom,
this.paramPeriodTo
});
this.StyleSheet.AddRange(new DevExpress.XtraReports.UI.XRControlStyle[] {
this.xrControlStyle1
});
this.Version = "16.1";
((System.ComponentModel.ISupportInitialize)(this.xrTable3)).EndInit();
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
}
