//处理字段结合绑定的情况 private void processUnitField(ColPivotList xmlCfgLst, DevExpress.XtraPivotGrid.PivotGridControl gridCtl) { if (xmlCfgLst == null || xmlCfgLst.FieldGroups == null || xmlCfgLst.FieldGroups.Length == 0) { return; } string[] groups = xmlCfgLst.FieldGroups.Split(';'); foreach (string group in groups) { string[] fields = group.Split(','); DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup = new DevExpress.XtraPivotGrid.PivotGridGroup(); gridCtl.Groups.Add(pivotGridGroup); foreach (string field in fields) { DevExpress.XtraPivotGrid.PivotGridField pivField = gridCtl.Fields[field]; if (pivField == null) { continue; } pivotGridGroup.Add(pivField); } } }
/// <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.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup(); DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup2 = new DevExpress.XtraPivotGrid.PivotGridGroup(); DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup3 = new DevExpress.XtraPivotGrid.PivotGridGroup(); DevExpress.XtraCharts.XYDiagram xyDiagram1 = new DevExpress.XtraCharts.XYDiagram(); DevExpress.XtraCharts.StackedBarSeriesLabel stackedBarSeriesLabel1 = new DevExpress.XtraCharts.StackedBarSeriesLabel(); DevExpress.XtraCharts.StackedBarSeriesView stackedBarSeriesView1 = new DevExpress.XtraCharts.StackedBarSeriesView(); this.fieldOrderDate = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldOrderDate1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldOrderDate2 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldOrderDate3 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldShipCountry1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldShipCity1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCategoryName1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldProductName1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.xtraPivotGridTutorialBindingSource = new System.Windows.Forms.BindingSource(this.components); this.nwindDataSet = new NwindDataSet.nwindDataSet(); this.xtraPivotGridTutorialViewTableAdapter = new NwindDataSet.nwindDataSetTableAdapters.XtraPivotGridTutorialViewTableAdapter(); this.splitContainerControl1 = new DevExpress.XtraEditors.SplitContainerControl(); this.splitContainerControl2 = new DevExpress.XtraEditors.SplitContainerControl(); this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl(); this.fieldUnitPrice1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldQuantity1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldPrice1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldExtendedPrice1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldFreight1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldSalesPerson1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldShipperCompany1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldOrderDate4 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldDiscount = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldFreightPercentage = new DevExpress.XtraPivotGrid.PivotGridField(); this.chartControl1 = new DevExpress.XtraCharts.ChartControl(); ((System.ComponentModel.ISupportInitialize)(this.xtraPivotGridTutorialBindingSource)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.nwindDataSet)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.splitContainerControl1)).BeginInit(); this.splitContainerControl1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.splitContainerControl2)).BeginInit(); this.splitContainerControl2.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.chartControl1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(xyDiagram1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(stackedBarSeriesLabel1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(stackedBarSeriesView1)).BeginInit(); this.SuspendLayout(); // // fieldOrderDate // this.fieldOrderDate.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldOrderDate.AreaIndex = 0; this.fieldOrderDate.Caption = "Year"; this.fieldOrderDate.DisplayFolder = "Dimensions\\Dates"; this.fieldOrderDate.FieldName = "OrderDate"; this.fieldOrderDate.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateYear; this.fieldOrderDate.Name = "fieldOrderDate"; this.fieldOrderDate.UnboundFieldName = "fieldOrderDate"; // // fieldOrderDate1 // this.fieldOrderDate1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldOrderDate1.AreaIndex = 1; this.fieldOrderDate1.Caption = "Quarter"; this.fieldOrderDate1.DisplayFolder = "Dimensions\\Dates"; this.fieldOrderDate1.ExpandedInFieldsGroup = false; this.fieldOrderDate1.FieldName = "OrderDate"; this.fieldOrderDate1.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateQuarter; this.fieldOrderDate1.Name = "fieldOrderDate1"; this.fieldOrderDate1.UnboundFieldName = "fieldOrderDate1"; this.fieldOrderDate1.ValueFormat.FormatString = "Quarter {0}"; this.fieldOrderDate1.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric; // // fieldOrderDate2 // this.fieldOrderDate2.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldOrderDate2.AreaIndex = 2; this.fieldOrderDate2.Caption = "Month"; this.fieldOrderDate2.DisplayFolder = "Dimensions\\Dates"; this.fieldOrderDate2.ExpandedInFieldsGroup = false; this.fieldOrderDate2.FieldName = "OrderDate"; this.fieldOrderDate2.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateMonth; this.fieldOrderDate2.Name = "fieldOrderDate2"; this.fieldOrderDate2.UnboundFieldName = "fieldOrderDate2"; this.fieldOrderDate2.Visible = false; // // fieldOrderDate3 // this.fieldOrderDate3.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldOrderDate3.AreaIndex = 3; this.fieldOrderDate3.Caption = "Day"; this.fieldOrderDate3.DisplayFolder = "Dimensions\\Dates"; this.fieldOrderDate3.FieldName = "OrderDate"; this.fieldOrderDate3.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateDay; this.fieldOrderDate3.Name = "fieldOrderDate3"; this.fieldOrderDate3.UnboundFieldName = "fieldOrderDate3"; this.fieldOrderDate3.Visible = false; // // fieldShipCountry1 // this.fieldShipCountry1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldShipCountry1.AreaIndex = 0; this.fieldShipCountry1.Caption = "Ship Country"; this.fieldShipCountry1.DisplayFolder = "Dimensions\\Geography"; this.fieldShipCountry1.FieldName = "ShipCountry"; this.fieldShipCountry1.Name = "fieldShipCountry1"; this.fieldShipCountry1.Visible = false; // // fieldShipCity1 // this.fieldShipCity1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldShipCity1.AreaIndex = 1; this.fieldShipCity1.Caption = "Ship City"; this.fieldShipCity1.DisplayFolder = "Dimensions\\Geography"; this.fieldShipCity1.FieldName = "ShipCity"; this.fieldShipCity1.Name = "fieldShipCity1"; this.fieldShipCity1.Visible = false; // // fieldCategoryName1 // this.fieldCategoryName1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldCategoryName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldCategoryName1.AreaIndex = 0; this.fieldCategoryName1.Caption = "Category"; this.fieldCategoryName1.DisplayFolder = "Dimensions\\Products"; this.fieldCategoryName1.FieldName = "CategoryName"; this.fieldCategoryName1.Name = "fieldCategoryName1"; // // fieldProductName1 // this.fieldProductName1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldProductName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldProductName1.AreaIndex = 1; this.fieldProductName1.Caption = "Product"; this.fieldProductName1.DisplayFolder = "Dimensions\\Products"; this.fieldProductName1.FieldName = "ProductName"; this.fieldProductName1.Name = "fieldProductName1"; // // xtraPivotGridTutorialBindingSource // this.xtraPivotGridTutorialBindingSource.DataMember = "XtraPivotGridTutorialView"; this.xtraPivotGridTutorialBindingSource.DataSource = this.nwindDataSet; // // nwindDataSet // this.nwindDataSet.DataSetName = "nwindDataSet"; this.nwindDataSet.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // xtraPivotGridTutorialViewTableAdapter // this.xtraPivotGridTutorialViewTableAdapter.ClearBeforeFill = true; // // splitContainerControl1 // this.splitContainerControl1.Collapsed = true; this.splitContainerControl1.Dock = System.Windows.Forms.DockStyle.Fill; this.splitContainerControl1.Location = new System.Drawing.Point(0, 0); this.splitContainerControl1.Name = "splitContainerControl1"; this.splitContainerControl1.Panel1.Text = "Panel1"; this.splitContainerControl1.Panel2.Controls.Add(this.splitContainerControl2); this.splitContainerControl1.Panel2.Text = "Panel2"; this.splitContainerControl1.Size = new System.Drawing.Size(732, 541); this.splitContainerControl1.SplitterPosition = 312; this.splitContainerControl1.TabIndex = 1; this.splitContainerControl1.Text = "splitContainerControl1"; // // splitContainerControl2 // this.splitContainerControl2.Dock = System.Windows.Forms.DockStyle.Fill; this.splitContainerControl2.Horizontal = false; this.splitContainerControl2.Location = new System.Drawing.Point(0, 0); this.splitContainerControl2.Name = "splitContainerControl2"; this.splitContainerControl2.Panel1.Controls.Add(this.pivotGridControl1); this.splitContainerControl2.Panel1.Text = "Panel1"; this.splitContainerControl2.Panel2.Controls.Add(this.chartControl1); this.splitContainerControl2.Panel2.Text = "Panel2"; this.splitContainerControl2.Size = new System.Drawing.Size(415, 541); this.splitContainerControl2.SplitterPosition = 326; this.splitContainerControl2.TabIndex = 0; this.splitContainerControl2.Text = "splitContainerControl2"; // // pivotGridControl1 // this.pivotGridControl1.DataSource = this.xtraPivotGridTutorialBindingSource; this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill; this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] { this.fieldCategoryName1, this.fieldProductName1, this.fieldUnitPrice1, this.fieldQuantity1, this.fieldPrice1, this.fieldExtendedPrice1, this.fieldFreight1, this.fieldSalesPerson1, this.fieldShipCountry1, this.fieldShipCity1, this.fieldShipperCompany1, this.fieldOrderDate, this.fieldOrderDate1, this.fieldOrderDate2, this.fieldOrderDate3, this.fieldOrderDate4, this.fieldDiscount, this.fieldFreightPercentage }); pivotGridGroup1.Caption = "Calendar"; pivotGridGroup1.Fields.Add(this.fieldOrderDate); pivotGridGroup1.Fields.Add(this.fieldOrderDate1); pivotGridGroup1.Fields.Add(this.fieldOrderDate2); pivotGridGroup1.Fields.Add(this.fieldOrderDate3); pivotGridGroup1.Hierarchy = null; pivotGridGroup1.ShowNewValues = true; pivotGridGroup2.Caption = "Ship Info"; pivotGridGroup2.Fields.Add(this.fieldShipCountry1); pivotGridGroup2.Fields.Add(this.fieldShipCity1); pivotGridGroup2.Hierarchy = null; pivotGridGroup2.ShowNewValues = true; pivotGridGroup3.Caption = "Product Info"; pivotGridGroup3.Fields.Add(this.fieldCategoryName1); pivotGridGroup3.Fields.Add(this.fieldProductName1); pivotGridGroup3.Hierarchy = null; pivotGridGroup3.ShowNewValues = true; this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] { pivotGridGroup1, pivotGridGroup2, pivotGridGroup3 }); this.pivotGridControl1.Location = new System.Drawing.Point(0, 0); this.pivotGridControl1.Name = "pivotGridControl1"; this.pivotGridControl1.OptionsChartDataSource.SelectionOnly = false; this.pivotGridControl1.OptionsCustomization.AllowFilterInCustomizationForm = true; this.pivotGridControl1.OptionsCustomization.AllowSortInCustomizationForm = true; this.pivotGridControl1.OptionsCustomization.CustomizationFormStyle = DevExpress.XtraPivotGrid.Customization.CustomizationFormStyle.Excel2007; this.pivotGridControl1.OptionsData.AutoExpandGroups = DevExpress.Utils.DefaultBoolean.False; this.pivotGridControl1.OptionsData.DataFieldUnboundExpressionMode = DevExpress.XtraPivotGrid.DataFieldUnboundExpressionMode.UseSummaryValues; this.pivotGridControl1.OptionsDataField.Area = DevExpress.XtraPivotGrid.PivotDataArea.ColumnArea; this.pivotGridControl1.OptionsDataField.AreaIndex = 0; this.pivotGridControl1.OptionsView.RowTotalsLocation = DevExpress.XtraPivotGrid.PivotRowTotalsLocation.Tree; this.pivotGridControl1.OptionsView.ShowColumnGrandTotalHeader = false; this.pivotGridControl1.OptionsView.ShowColumnHeaders = false; this.pivotGridControl1.OptionsView.ShowDataHeaders = false; this.pivotGridControl1.OptionsView.ShowFilterHeaders = false; this.pivotGridControl1.OptionsView.ShowRowHeaders = false; this.pivotGridControl1.Size = new System.Drawing.Size(415, 326); this.pivotGridControl1.TabIndex = 2; // // fieldUnitPrice1 // this.fieldUnitPrice1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldUnitPrice1.AreaIndex = 0; this.fieldUnitPrice1.Caption = "Unit Price"; this.fieldUnitPrice1.DisplayFolder = "Dimensions\\Products"; this.fieldUnitPrice1.FieldName = "UnitPrice"; this.fieldUnitPrice1.Name = "fieldUnitPrice1"; this.fieldUnitPrice1.Visible = false; // // fieldQuantity1 // this.fieldQuantity1.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea; this.fieldQuantity1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldQuantity1.AreaIndex = 1; this.fieldQuantity1.Caption = "Quantity"; this.fieldQuantity1.DisplayFolder = "Measures"; this.fieldQuantity1.FieldName = "Quantity"; this.fieldQuantity1.Name = "fieldQuantity1"; this.fieldQuantity1.Visible = false; // // fieldPrice1 // this.fieldPrice1.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea; this.fieldPrice1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldPrice1.AreaIndex = 0; this.fieldPrice1.Caption = "Amount"; this.fieldPrice1.CellFormat.FormatString = "C0"; this.fieldPrice1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldPrice1.DisplayFolder = "Measures"; this.fieldPrice1.FieldName = "Price"; this.fieldPrice1.Name = "fieldPrice1"; // // fieldExtendedPrice1 // this.fieldExtendedPrice1.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea; this.fieldExtendedPrice1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldExtendedPrice1.Caption = "Extended Amount"; this.fieldExtendedPrice1.CellFormat.FormatString = "C0"; this.fieldExtendedPrice1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldExtendedPrice1.DisplayFolder = "Measures"; this.fieldExtendedPrice1.FieldName = "ExtendedPrice"; this.fieldExtendedPrice1.Name = "fieldExtendedPrice1"; this.fieldExtendedPrice1.Visible = false; // // fieldFreight1 // this.fieldFreight1.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea; this.fieldFreight1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldFreight1.AreaIndex = 2; this.fieldFreight1.Caption = "Freight"; this.fieldFreight1.CellFormat.FormatString = "C0"; this.fieldFreight1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldFreight1.DisplayFolder = "Measures"; this.fieldFreight1.FieldName = "Freight"; this.fieldFreight1.Name = "fieldFreight1"; // // fieldSalesPerson1 // this.fieldSalesPerson1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldSalesPerson1.AreaIndex = 0; this.fieldSalesPerson1.Caption = "Sales Person"; this.fieldSalesPerson1.DisplayFolder = "Dimensions"; this.fieldSalesPerson1.FieldName = "SalesPerson"; this.fieldSalesPerson1.Name = "fieldSalesPerson1"; this.fieldSalesPerson1.Visible = false; // // fieldShipperCompany1 // this.fieldShipperCompany1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldShipperCompany1.AreaIndex = 0; this.fieldShipperCompany1.Caption = "Shipper Company"; this.fieldShipperCompany1.DisplayFolder = "Dimensions"; this.fieldShipperCompany1.FieldName = "ShipperCompany"; this.fieldShipperCompany1.Name = "fieldShipperCompany1"; this.fieldShipperCompany1.Visible = false; // // fieldOrderDate4 // this.fieldOrderDate4.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldOrderDate4.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldOrderDate4.AreaIndex = 4; this.fieldOrderDate4.Caption = "Date"; this.fieldOrderDate4.DisplayFolder = "Dimensions\\Dates"; this.fieldOrderDate4.FieldName = "OrderDate"; this.fieldOrderDate4.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.Date; this.fieldOrderDate4.Name = "fieldOrderDate4"; this.fieldOrderDate4.UnboundFieldName = "fieldOrderDate4"; this.fieldOrderDate4.Visible = false; // // fieldDiscount // this.fieldDiscount.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea; this.fieldDiscount.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldDiscount.AreaIndex = 1; this.fieldDiscount.Caption = "Discount"; this.fieldDiscount.CellFormat.FormatString = "C0"; this.fieldDiscount.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldDiscount.DisplayFolder = "Measures"; this.fieldDiscount.FieldName = "DiscountAmount"; this.fieldDiscount.Name = "fieldDiscount"; this.fieldDiscount.UnboundExpression = "Abs([fieldExtendedPrice1] - [fieldPrice1])"; this.fieldDiscount.UnboundFieldName = "fieldDiscountAmount"; this.fieldDiscount.UnboundType = DevExpress.Data.UnboundColumnType.Decimal; // // fieldFreightPercentage // this.fieldFreightPercentage.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea; this.fieldFreightPercentage.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldFreightPercentage.AreaIndex = 2; this.fieldFreightPercentage.Caption = "Freight %"; this.fieldFreightPercentage.CellFormat.FormatString = "P"; this.fieldFreightPercentage.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldFreightPercentage.DisplayFolder = "Measures"; this.fieldFreightPercentage.FieldName = "FreightPercentage"; this.fieldFreightPercentage.Name = "fieldFreightPercentage"; this.fieldFreightPercentage.UnboundExpression = "[fieldFreight1] / ([fieldFreight1] + [fieldExtendedPrice1])"; this.fieldFreightPercentage.UnboundFieldName = "fFreightPercentage"; this.fieldFreightPercentage.UnboundType = DevExpress.Data.UnboundColumnType.Decimal; this.fieldFreightPercentage.Visible = false; // // chartControl1 // this.chartControl1.DataSource = this.pivotGridControl1; xyDiagram1.AxisX.Range.ScrollingRange.SideMarginsEnabled = true; xyDiagram1.AxisX.Range.SideMarginsEnabled = true; xyDiagram1.AxisX.Title.Text = "Category Product"; xyDiagram1.AxisX.VisibleInPanesSerializable = "-1"; xyDiagram1.AxisY.NumericOptions.Format = DevExpress.XtraCharts.NumericFormat.Currency; xyDiagram1.AxisY.Range.ScrollingRange.SideMarginsEnabled = true; xyDiagram1.AxisY.Range.SideMarginsEnabled = true; xyDiagram1.AxisY.Title.Text = "Amount Discount Freight"; xyDiagram1.AxisY.VisibleInPanesSerializable = "-1"; this.chartControl1.Diagram = xyDiagram1; this.chartControl1.Dock = System.Windows.Forms.DockStyle.Fill; this.chartControl1.Legend.AlignmentHorizontal = DevExpress.XtraCharts.LegendAlignmentHorizontal.Center; this.chartControl1.Legend.AlignmentVertical = DevExpress.XtraCharts.LegendAlignmentVertical.TopOutside; this.chartControl1.Legend.Direction = DevExpress.XtraCharts.LegendDirection.LeftToRight; this.chartControl1.Legend.MaxVerticalPercentage = 30; this.chartControl1.Location = new System.Drawing.Point(0, 0); this.chartControl1.Name = "chartControl1"; this.chartControl1.SeriesDataMember = "Series"; this.chartControl1.SeriesSerializable = new DevExpress.XtraCharts.Series[0]; this.chartControl1.SeriesTemplate.ArgumentDataMember = "Arguments"; this.chartControl1.SeriesTemplate.ArgumentScaleType = DevExpress.XtraCharts.ScaleType.Qualitative; this.chartControl1.SeriesTemplate.CrosshairLabelPattern = "{S} : {V:C2}"; this.chartControl1.SeriesTemplate.Label = stackedBarSeriesLabel1; this.chartControl1.SeriesTemplate.ValueDataMembersSerializable = "Values"; this.chartControl1.SeriesTemplate.View = stackedBarSeriesView1; this.chartControl1.Size = new System.Drawing.Size(415, 210); this.chartControl1.TabIndex = 0; // // Form1 // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(732, 541); this.Controls.Add(this.splitContainerControl1); this.Name = "Form1"; this.Text = "XtraPivotGridTutorial.Step5"; this.Load += new System.EventHandler(this.Form1_Load); ((System.ComponentModel.ISupportInitialize)(this.xtraPivotGridTutorialBindingSource)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.nwindDataSet)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.splitContainerControl1)).EndInit(); this.splitContainerControl1.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.splitContainerControl2)).EndInit(); this.splitContainerControl2.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(xyDiagram1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(stackedBarSeriesLabel1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(stackedBarSeriesView1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.chartControl1)).EndInit(); this.ResumeLayout(false); }
/// <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.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup(); DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup2 = new DevExpress.XtraPivotGrid.PivotGridGroup(); DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup3 = new DevExpress.XtraPivotGrid.PivotGridGroup(); this.fieldOrderDate = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldOrderDate1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldOrderDate2 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldOrderDate3 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldShipCountry1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldShipCity1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCategoryName1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldProductName1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.xtraPivotGridTutorialBindingSource = new System.Windows.Forms.BindingSource(this.components); this.nwindDataSet = new NwindDataSet.nwindDataSet(); this.xtraPivotGridTutorialViewTableAdapter = new NwindDataSet.nwindDataSetTableAdapters.XtraPivotGridTutorialViewTableAdapter(); this.splitContainerControl1 = new DevExpress.XtraEditors.SplitContainerControl(); this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl(); this.fieldUnitPrice1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldQuantity1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldPrice1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldExtendedPrice1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldFreight1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldSalesPerson1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldShipperCompany1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldOrderDate4 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldDiscount = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldFreightPercentage = new DevExpress.XtraPivotGrid.PivotGridField(); ((System.ComponentModel.ISupportInitialize)(this.xtraPivotGridTutorialBindingSource)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.nwindDataSet)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.splitContainerControl1)).BeginInit(); this.splitContainerControl1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit(); this.SuspendLayout(); // // fieldOrderDate // this.fieldOrderDate.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldOrderDate.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldOrderDate.AreaIndex = 0; this.fieldOrderDate.Caption = "Year"; this.fieldOrderDate.DisplayFolder = "Dimensions\\Dates"; this.fieldOrderDate.FieldName = "OrderDate"; this.fieldOrderDate.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateYear; this.fieldOrderDate.Name = "fieldOrderDate"; this.fieldOrderDate.UnboundFieldName = "fieldOrderDate"; // // fieldOrderDate1 // this.fieldOrderDate1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldOrderDate1.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldOrderDate1.AreaIndex = 1; this.fieldOrderDate1.Caption = "Quarter"; this.fieldOrderDate1.DisplayFolder = "Dimensions\\Dates"; this.fieldOrderDate1.ExpandedInFieldsGroup = false; this.fieldOrderDate1.FieldName = "OrderDate"; this.fieldOrderDate1.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateQuarter; this.fieldOrderDate1.Name = "fieldOrderDate1"; this.fieldOrderDate1.UnboundFieldName = "fieldOrderDate1"; this.fieldOrderDate1.ValueFormat.FormatString = "Quarter {0}"; this.fieldOrderDate1.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric; // // fieldOrderDate2 // this.fieldOrderDate2.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldOrderDate2.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldOrderDate2.AreaIndex = 2; this.fieldOrderDate2.Caption = "Month"; this.fieldOrderDate2.DisplayFolder = "Dimensions\\Dates"; this.fieldOrderDate2.ExpandedInFieldsGroup = false; this.fieldOrderDate2.FieldName = "OrderDate"; this.fieldOrderDate2.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateMonth; this.fieldOrderDate2.Name = "fieldOrderDate2"; this.fieldOrderDate2.UnboundFieldName = "fieldOrderDate2"; this.fieldOrderDate2.Visible = false; // // fieldOrderDate3 // this.fieldOrderDate3.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldOrderDate3.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldOrderDate3.AreaIndex = 3; this.fieldOrderDate3.Caption = "Day"; this.fieldOrderDate3.DisplayFolder = "Dimensions\\Dates"; this.fieldOrderDate3.FieldName = "OrderDate"; this.fieldOrderDate3.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateDay; this.fieldOrderDate3.Name = "fieldOrderDate3"; this.fieldOrderDate3.UnboundFieldName = "fieldOrderDate3"; this.fieldOrderDate3.Visible = false; // // fieldShipCountry1 // this.fieldShipCountry1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldShipCountry1.AreaIndex = 0; this.fieldShipCountry1.Caption = "Ship Country"; this.fieldShipCountry1.DisplayFolder = "Dimensions\\Geography"; this.fieldShipCountry1.FieldName = "ShipCountry"; this.fieldShipCountry1.Name = "fieldShipCountry1"; this.fieldShipCountry1.Visible = false; // // fieldShipCity1 // this.fieldShipCity1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldShipCity1.AreaIndex = 1; this.fieldShipCity1.Caption = "Ship City"; this.fieldShipCity1.DisplayFolder = "Dimensions\\Geography"; this.fieldShipCity1.FieldName = "ShipCity"; this.fieldShipCity1.Name = "fieldShipCity1"; this.fieldShipCity1.Visible = false; // // fieldCategoryName1 // this.fieldCategoryName1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldCategoryName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldCategoryName1.AreaIndex = 0; this.fieldCategoryName1.Caption = "Category"; this.fieldCategoryName1.DisplayFolder = "Dimensions\\Products"; this.fieldCategoryName1.FieldName = "CategoryName"; this.fieldCategoryName1.Name = "fieldCategoryName1"; // // fieldProductName1 // this.fieldProductName1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldProductName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldProductName1.AreaIndex = 1; this.fieldProductName1.Caption = "Product"; this.fieldProductName1.DisplayFolder = "Dimensions\\Products"; this.fieldProductName1.FieldName = "ProductName"; this.fieldProductName1.Name = "fieldProductName1"; // // xtraPivotGridTutorialBindingSource // this.xtraPivotGridTutorialBindingSource.DataMember = "XtraPivotGridTutorialView"; this.xtraPivotGridTutorialBindingSource.DataSource = this.nwindDataSet; // // nwindDataSet // this.nwindDataSet.DataSetName = "nwindDataSet"; this.nwindDataSet.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // xtraPivotGridTutorialViewTableAdapter // this.xtraPivotGridTutorialViewTableAdapter.ClearBeforeFill = true; // // splitContainerControl1 // this.splitContainerControl1.CollapsePanel = DevExpress.XtraEditors.SplitCollapsePanel.Panel1; this.splitContainerControl1.Dock = System.Windows.Forms.DockStyle.Fill; this.splitContainerControl1.Location = new System.Drawing.Point(0, 0); this.splitContainerControl1.Name = "splitContainerControl1"; this.splitContainerControl1.Panel1.Text = "Panel1"; this.splitContainerControl1.Panel2.Controls.Add(this.pivotGridControl1); this.splitContainerControl1.Panel2.Text = "Panel2"; this.splitContainerControl1.Size = new System.Drawing.Size(1012, 541); this.splitContainerControl1.SplitterPosition = 312; this.splitContainerControl1.TabIndex = 1; this.splitContainerControl1.Text = "splitContainerControl1"; // // pivotGridControl1 // this.pivotGridControl1.DataSource = this.xtraPivotGridTutorialBindingSource; this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill; this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] { this.fieldCategoryName1, this.fieldProductName1, this.fieldUnitPrice1, this.fieldQuantity1, this.fieldPrice1, this.fieldExtendedPrice1, this.fieldFreight1, this.fieldSalesPerson1, this.fieldShipCountry1, this.fieldShipCity1, this.fieldShipperCompany1, this.fieldOrderDate, this.fieldOrderDate1, this.fieldOrderDate2, this.fieldOrderDate3, this.fieldOrderDate4, this.fieldDiscount, this.fieldFreightPercentage }); pivotGridGroup1.Caption = "Calendar"; pivotGridGroup1.Fields.Add(this.fieldOrderDate); pivotGridGroup1.Fields.Add(this.fieldOrderDate1); pivotGridGroup1.Fields.Add(this.fieldOrderDate2); pivotGridGroup1.Fields.Add(this.fieldOrderDate3); pivotGridGroup1.Hierarchy = null; pivotGridGroup1.ShowNewValues = true; pivotGridGroup2.Caption = "Ship Info"; pivotGridGroup2.Fields.Add(this.fieldShipCountry1); pivotGridGroup2.Fields.Add(this.fieldShipCity1); pivotGridGroup2.Hierarchy = null; pivotGridGroup2.ShowNewValues = true; pivotGridGroup3.Caption = "Product Info"; pivotGridGroup3.Fields.Add(this.fieldCategoryName1); pivotGridGroup3.Fields.Add(this.fieldProductName1); pivotGridGroup3.Hierarchy = null; pivotGridGroup3.ShowNewValues = true; this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] { pivotGridGroup1, pivotGridGroup2, pivotGridGroup3 }); this.pivotGridControl1.Location = new System.Drawing.Point(0, 0); this.pivotGridControl1.Name = "pivotGridControl1"; this.pivotGridControl1.OptionsCustomization.AllowFilterInCustomizationForm = true; this.pivotGridControl1.OptionsCustomization.AllowSortInCustomizationForm = true; this.pivotGridControl1.OptionsCustomization.CustomizationFormStyle = DevExpress.XtraPivotGrid.Customization.CustomizationFormStyle.Excel2007; this.pivotGridControl1.OptionsData.AutoExpandGroups = DevExpress.Utils.DefaultBoolean.False; this.pivotGridControl1.OptionsData.DataFieldUnboundExpressionMode = DevExpress.XtraPivotGrid.DataFieldUnboundExpressionMode.UseSummaryValues; this.pivotGridControl1.OptionsDataField.Area = DevExpress.XtraPivotGrid.PivotDataArea.RowArea; this.pivotGridControl1.OptionsDataField.AreaIndex = 2; this.pivotGridControl1.OptionsView.RowTotalsLocation = DevExpress.XtraPivotGrid.PivotRowTotalsLocation.Tree; this.pivotGridControl1.OptionsView.ShowColumnHeaders = false; this.pivotGridControl1.OptionsView.ShowDataHeaders = false; this.pivotGridControl1.OptionsView.ShowFilterHeaders = false; this.pivotGridControl1.OptionsView.ShowRowHeaders = false; this.pivotGridControl1.Size = new System.Drawing.Size(1007, 541); this.pivotGridControl1.TabIndex = 1; this.pivotGridControl1.ShowingCustomizationForm += new DevExpress.XtraPivotGrid.CustomizationFormShowingEventHandler(this.pivotGridControl1_ShowingCustomizationForm); // // fieldUnitPrice1 // this.fieldUnitPrice1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldUnitPrice1.AreaIndex = 0; this.fieldUnitPrice1.Caption = "Unit Price"; this.fieldUnitPrice1.DisplayFolder = "Dimensions\\Products"; this.fieldUnitPrice1.FieldName = "UnitPrice"; this.fieldUnitPrice1.Name = "fieldUnitPrice1"; this.fieldUnitPrice1.Visible = false; // // fieldQuantity1 // this.fieldQuantity1.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea; this.fieldQuantity1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldQuantity1.AreaIndex = 1; this.fieldQuantity1.Caption = "Quantity"; this.fieldQuantity1.DisplayFolder = "Measures"; this.fieldQuantity1.FieldName = "Quantity"; this.fieldQuantity1.Name = "fieldQuantity1"; this.fieldQuantity1.Visible = false; // // fieldPrice1 // this.fieldPrice1.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea; this.fieldPrice1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldPrice1.AreaIndex = 0; this.fieldPrice1.Caption = "Amount"; this.fieldPrice1.CellFormat.FormatString = "C0"; this.fieldPrice1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldPrice1.DisplayFolder = "Measures"; this.fieldPrice1.FieldName = "Price"; this.fieldPrice1.Name = "fieldPrice1"; // // fieldExtendedPrice1 // this.fieldExtendedPrice1.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea; this.fieldExtendedPrice1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldExtendedPrice1.Caption = "Extended Amount"; this.fieldExtendedPrice1.CellFormat.FormatString = "C0"; this.fieldExtendedPrice1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldExtendedPrice1.DisplayFolder = "Measures"; this.fieldExtendedPrice1.FieldName = "ExtendedPrice"; this.fieldExtendedPrice1.Name = "fieldExtendedPrice1"; this.fieldExtendedPrice1.Visible = false; // // fieldFreight1 // this.fieldFreight1.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea; this.fieldFreight1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldFreight1.Caption = "Freight"; this.fieldFreight1.CellFormat.FormatString = "C0"; this.fieldFreight1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldFreight1.DisplayFolder = "Measures"; this.fieldFreight1.FieldName = "Freight"; this.fieldFreight1.Name = "fieldFreight1"; this.fieldFreight1.Visible = false; // // fieldSalesPerson1 // this.fieldSalesPerson1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldSalesPerson1.AreaIndex = 0; this.fieldSalesPerson1.Caption = "Sales Person"; this.fieldSalesPerson1.DisplayFolder = "Dimensions"; this.fieldSalesPerson1.FieldName = "SalesPerson"; this.fieldSalesPerson1.Name = "fieldSalesPerson1"; this.fieldSalesPerson1.Visible = false; // // fieldShipperCompany1 // this.fieldShipperCompany1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldShipperCompany1.AreaIndex = 0; this.fieldShipperCompany1.Caption = "Shipper Company"; this.fieldShipperCompany1.DisplayFolder = "Dimensions"; this.fieldShipperCompany1.FieldName = "ShipperCompany"; this.fieldShipperCompany1.Name = "fieldShipperCompany1"; this.fieldShipperCompany1.Visible = false; // // fieldOrderDate4 // this.fieldOrderDate4.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldOrderDate4.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldOrderDate4.AreaIndex = 4; this.fieldOrderDate4.Caption = "Date"; this.fieldOrderDate4.DisplayFolder = "Dimensions\\Dates"; this.fieldOrderDate4.FieldName = "OrderDate"; this.fieldOrderDate4.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.Date; this.fieldOrderDate4.Name = "fieldOrderDate4"; this.fieldOrderDate4.UnboundFieldName = "fieldOrderDate4"; this.fieldOrderDate4.Visible = false; // // fieldDiscount // this.fieldDiscount.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea; this.fieldDiscount.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldDiscount.AreaIndex = 1; this.fieldDiscount.Caption = "Discount"; this.fieldDiscount.CellFormat.FormatString = "C0"; this.fieldDiscount.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldDiscount.DisplayFolder = "Measures"; this.fieldDiscount.FieldName = "DiscountAmount"; this.fieldDiscount.Name = "fieldDiscount"; this.fieldDiscount.UnboundExpression = "Abs([fieldExtendedPrice1] - [fieldPrice1])"; this.fieldDiscount.UnboundFieldName = "fieldDiscountAmount"; this.fieldDiscount.UnboundType = DevExpress.Data.UnboundColumnType.Decimal; // // fieldFreightPercentage // this.fieldFreightPercentage.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea; this.fieldFreightPercentage.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldFreightPercentage.AreaIndex = 2; this.fieldFreightPercentage.Caption = "Freight %"; this.fieldFreightPercentage.CellFormat.FormatString = "P"; this.fieldFreightPercentage.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldFreightPercentage.DisplayFolder = "Measures"; this.fieldFreightPercentage.FieldName = "FreightPercentage"; this.fieldFreightPercentage.Name = "fieldFreightPercentage"; this.fieldFreightPercentage.UnboundExpression = "[fieldFreight1] / ([fieldFreight1] + [fieldExtendedPrice1])"; this.fieldFreightPercentage.UnboundFieldName = "fFreightPercentage"; this.fieldFreightPercentage.UnboundType = DevExpress.Data.UnboundColumnType.Decimal; // // Form1 // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(1012, 541); this.Controls.Add(this.splitContainerControl1); this.Name = "Form1"; this.Text = "XtraPivotGridTutorial.Step4"; this.Load += new System.EventHandler(this.Form1_Load); ((System.ComponentModel.ISupportInitialize)(this.xtraPivotGridTutorialBindingSource)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.nwindDataSet)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.splitContainerControl1)).EndInit(); this.splitContainerControl1.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit(); this.ResumeLayout(false); }
/// <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.XtraPivotGrid.PivotGridGroup pivotGridGroup3 = new DevExpress.XtraPivotGrid.PivotGridGroup(); DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup4 = new DevExpress.XtraPivotGrid.PivotGridGroup(); this.fielddivision = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCourseName = new DevExpress.XtraPivotGrid.PivotGridField(); this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl(); this.studentenrollmentviewBindingSource = new System.Windows.Forms.BindingSource(this.components); this.fieldlearnerNumber = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldName = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldSurname = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldMAXeregdate = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldnumRegistrations = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldlearnerStatus = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldcompleted = new DevExpress.XtraPivotGrid.PivotGridField(); this.studentEnrollments = new LAD_2009.DataSets.StudentEnrollments(); this.studentenrollmentviewTableAdapter = new LAD_2009.DataSets.StudentEnrollmentsTableAdapters.studentenrollmentviewTableAdapter(); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.studentenrollmentviewBindingSource)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.studentEnrollments)).BeginInit(); this.SuspendLayout(); // // fielddivision // this.fielddivision.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fielddivision.AreaIndex = 0; this.fielddivision.Caption = "division"; this.fielddivision.FieldName = "division"; this.fielddivision.Name = "fielddivision"; this.fielddivision.SortOrder = DevExpress.XtraPivotGrid.PivotSortOrder.Descending; // // fieldCourseName // this.fieldCourseName.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldCourseName.AreaIndex = 0; this.fieldCourseName.Caption = "Course Name"; this.fieldCourseName.FieldName = "CourseName"; this.fieldCourseName.Name = "fieldCourseName"; // // pivotGridControl1 // this.pivotGridControl1.Cursor = System.Windows.Forms.Cursors.Default; this.pivotGridControl1.DataSource = this.studentenrollmentviewBindingSource; this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill; this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] { this.fielddivision, this.fieldlearnerNumber, this.fieldName, this.fieldSurname, this.fieldMAXeregdate, this.fieldnumRegistrations, this.fieldCourseName, this.fieldlearnerStatus, this.fieldcompleted}); pivotGridGroup3.Fields.Add(this.fielddivision); pivotGridGroup3.Hierarchy = null; pivotGridGroup4.Fields.Add(this.fieldCourseName); pivotGridGroup4.Hierarchy = null; this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] { pivotGridGroup3, pivotGridGroup4}); this.pivotGridControl1.Location = new System.Drawing.Point(0, 0); this.pivotGridControl1.Name = "pivotGridControl1"; this.pivotGridControl1.OptionsCustomization.AllowFilter = false; this.pivotGridControl1.Size = new System.Drawing.Size(971, 590); this.pivotGridControl1.TabIndex = 0; // // studentenrollmentviewBindingSource // this.studentenrollmentviewBindingSource.DataMember = "studentenrollmentview"; this.studentenrollmentviewBindingSource.DataSource = this.studentEnrollments; this.studentenrollmentviewBindingSource.CurrentChanged += new System.EventHandler(this.studentenrollmentviewBindingSource_CurrentChanged); // // fieldlearnerNumber // this.fieldlearnerNumber.AreaIndex = 0; this.fieldlearnerNumber.Caption = "learner Number"; this.fieldlearnerNumber.FieldName = "learnerNumber"; this.fieldlearnerNumber.Name = "fieldlearnerNumber"; // // fieldName // this.fieldName.AreaIndex = 1; this.fieldName.Caption = "Name"; this.fieldName.FieldName = "Name"; this.fieldName.Name = "fieldName"; // // fieldSurname // this.fieldSurname.AreaIndex = 2; this.fieldSurname.Caption = "Surname"; this.fieldSurname.FieldName = "Surname"; this.fieldSurname.Name = "fieldSurname"; // // fieldMAXeregdate // this.fieldMAXeregdate.AreaIndex = 3; this.fieldMAXeregdate.Caption = "MAX(e_regdate)"; this.fieldMAXeregdate.FieldName = "MAX(e_regdate)"; this.fieldMAXeregdate.Name = "fieldMAXeregdate"; // // fieldnumRegistrations // this.fieldnumRegistrations.AreaIndex = 4; this.fieldnumRegistrations.Caption = "num Registrations"; this.fieldnumRegistrations.FieldName = "numRegistrations"; this.fieldnumRegistrations.Name = "fieldnumRegistrations"; // // fieldlearnerStatus // this.fieldlearnerStatus.AreaIndex = 5; this.fieldlearnerStatus.Caption = "learner Status"; this.fieldlearnerStatus.FieldName = "learnerStatus"; this.fieldlearnerStatus.Name = "fieldlearnerStatus"; // // fieldcompleted // this.fieldcompleted.AreaIndex = 6; this.fieldcompleted.Caption = "completed"; this.fieldcompleted.FieldName = "completed"; this.fieldcompleted.Name = "fieldcompleted"; // // studentEnrollments // this.studentEnrollments.DataSetName = "StudentEnrollments"; this.studentEnrollments.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // studentenrollmentviewTableAdapter // this.studentenrollmentviewTableAdapter.ClearBeforeFill = true; // // frmStatisticsPivot // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(971, 590); this.Controls.Add(this.pivotGridControl1); this.Name = "frmStatisticsPivot"; this.Text = "Statistics Live"; this.Load += new System.EventHandler(this.frmStatisticsPivot_Load); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.studentenrollmentviewBindingSource)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.studentEnrollments)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(FormReporteTiempo)); this.pivotGridField2 = new DevExpress.XtraPivotGrid.PivotGridField(); this.panel1 = new System.Windows.Forms.Panel(); this.gcDxTiempo = new DevExpress.XtraPivotGrid.PivotGridControl(); this.pivotGridField1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.pivotGridField3 = new DevExpress.XtraPivotGrid.PivotGridField(); this.pivotGridField5 = new DevExpress.XtraPivotGrid.PivotGridField(); this.pivotGridField6 = new DevExpress.XtraPivotGrid.PivotGridField(); this.pivotGridField4 = new DevExpress.XtraPivotGrid.PivotGridField(); this.pivotGridField12 = new DevExpress.XtraPivotGrid.PivotGridField(); this.repositoryItemDateEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit(); this.ribbonControl1 = new DevExpress.XtraBars.Ribbon.RibbonControl(); this.barButtonItem1 = new DevExpress.XtraBars.BarButtonItem(); this.barButtonItem2 = new DevExpress.XtraBars.BarButtonItem(); this.bbiDxIniciarCarrera = new DevExpress.XtraBars.BarButtonItem(); this.barButtonItem3 = new DevExpress.XtraBars.BarButtonItem(); this.barButtonItem4 = new DevExpress.XtraBars.BarButtonItem(); this.barButtonItem5 = new DevExpress.XtraBars.BarButtonItem(); this.barButtonItem6 = new DevExpress.XtraBars.BarButtonItem(); this.barButtonItem7 = new DevExpress.XtraBars.BarButtonItem(); this.ribbonPage1 = new DevExpress.XtraBars.Ribbon.RibbonPage(); this.ribbonPageGroup1 = new DevExpress.XtraBars.Ribbon.RibbonPageGroup(); this.pivotGridField7 = new DevExpress.XtraPivotGrid.PivotGridField(); this.pivotGridField8 = new DevExpress.XtraPivotGrid.PivotGridField(); this.pivotGridField9 = new DevExpress.XtraPivotGrid.PivotGridField(); this.pivotGridField10 = new DevExpress.XtraPivotGrid.PivotGridField(); this.pivotGridField11 = new DevExpress.XtraPivotGrid.PivotGridField(); this.panel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.gcDxTiempo)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1.CalendarTimeProperties)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.ribbonControl1)).BeginInit(); this.SuspendLayout(); // // pivotGridField2 // this.pivotGridField2.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.pivotGridField2.AreaIndex = 0; this.pivotGridField2.FieldName = "Vuelta"; this.pivotGridField2.Name = "pivotGridField2"; this.pivotGridField2.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Custom; // // panel1 // this.panel1.Controls.Add(this.gcDxTiempo); this.panel1.Dock = System.Windows.Forms.DockStyle.Fill; this.panel1.Location = new System.Drawing.Point(0, 142); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(885, 312); this.panel1.TabIndex = 2; // // gcDxTiempo // this.gcDxTiempo.Appearance.FieldValue.Options.UseTextOptions = true; this.gcDxTiempo.Dock = System.Windows.Forms.DockStyle.Fill; this.gcDxTiempo.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] { this.pivotGridField1, this.pivotGridField2, this.pivotGridField3, this.pivotGridField5, this.pivotGridField6, this.pivotGridField4, this.pivotGridField12 }); pivotGridGroup1.Fields.Add(this.pivotGridField2); pivotGridGroup1.Hierarchy = null; pivotGridGroup1.ShowNewValues = true; this.gcDxTiempo.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] { pivotGridGroup1 }); this.gcDxTiempo.Location = new System.Drawing.Point(0, 0); this.gcDxTiempo.Name = "gcDxTiempo"; this.gcDxTiempo.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] { this.repositoryItemDateEdit1 }); this.gcDxTiempo.Size = new System.Drawing.Size(885, 312); this.gcDxTiempo.TabIndex = 0; this.gcDxTiempo.CustomSummary += new DevExpress.XtraPivotGrid.PivotGridCustomSummaryEventHandler(this.gcDxTiempo_CustomSummary); this.gcDxTiempo.CustomCellValue += new System.EventHandler <DevExpress.XtraPivotGrid.PivotCellValueEventArgs>(this.gcDxTiempo_CustomCellValue); // // pivotGridField1 // this.pivotGridField1.AreaIndex = 0; this.pivotGridField1.FieldName = "TiempoId"; this.pivotGridField1.Name = "pivotGridField1"; this.pivotGridField1.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Custom; // // pivotGridField3 // this.pivotGridField3.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.pivotGridField3.AreaIndex = 1; this.pivotGridField3.FieldName = "Nombre"; this.pivotGridField3.Name = "pivotGridField3"; this.pivotGridField3.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Min; // // pivotGridField5 // this.pivotGridField5.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.pivotGridField5.AreaIndex = 2; this.pivotGridField5.CellFormat.FormatString = "d"; this.pivotGridField5.CellFormat.FormatType = DevExpress.Utils.FormatType.DateTime; this.pivotGridField5.FieldName = "TiempoRegistrado"; this.pivotGridField5.Name = "pivotGridField5"; this.pivotGridField5.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Max; this.pivotGridField5.UnboundFieldName = "pivotGridField5"; this.pivotGridField5.UnboundType = DevExpress.Data.UnboundColumnType.DateTime; this.pivotGridField5.ValueFormat.FormatString = "d"; this.pivotGridField5.ValueFormat.FormatType = DevExpress.Utils.FormatType.DateTime; // // pivotGridField6 // this.pivotGridField6.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.pivotGridField6.AreaIndex = 0; this.pivotGridField6.FieldName = "Categoria"; this.pivotGridField6.Name = "pivotGridField6"; this.pivotGridField6.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Custom; // // pivotGridField4 // this.pivotGridField4.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.pivotGridField4.AreaIndex = 1; this.pivotGridField4.FieldName = "Tiempo"; this.pivotGridField4.Name = "pivotGridField4"; this.pivotGridField4.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Min; // // pivotGridField12 // this.pivotGridField12.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.pivotGridField12.AreaIndex = 0; this.pivotGridField12.FieldName = "Numero"; this.pivotGridField12.Name = "pivotGridField12"; // // repositoryItemDateEdit1 // this.repositoryItemDateEdit1.AutoHeight = false; this.repositoryItemDateEdit1.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] { new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo) }); this.repositoryItemDateEdit1.CalendarTimeProperties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] { new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo) }); this.repositoryItemDateEdit1.Name = "repositoryItemDateEdit1"; // // ribbonControl1 // this.ribbonControl1.ExpandCollapseItem.Id = 0; this.ribbonControl1.Items.AddRange(new DevExpress.XtraBars.BarItem[] { this.ribbonControl1.ExpandCollapseItem, this.barButtonItem1, this.barButtonItem2, this.bbiDxIniciarCarrera, this.barButtonItem3, this.barButtonItem4, this.barButtonItem5, this.barButtonItem6, this.barButtonItem7 }); this.ribbonControl1.Location = new System.Drawing.Point(0, 0); this.ribbonControl1.MaxItemId = 9; this.ribbonControl1.Name = "ribbonControl1"; this.ribbonControl1.Pages.AddRange(new DevExpress.XtraBars.Ribbon.RibbonPage[] { this.ribbonPage1 }); this.ribbonControl1.ShowToolbarCustomizeItem = false; this.ribbonControl1.Size = new System.Drawing.Size(885, 142); this.ribbonControl1.Toolbar.ShowCustomizeItem = false; // // barButtonItem1 // this.barButtonItem1.Caption = "F1 - Actualizar"; this.barButtonItem1.Glyph = ((System.Drawing.Image)(resources.GetObject("barButtonItem1.Glyph"))); this.barButtonItem1.Id = 1; this.barButtonItem1.ItemShortcut = new DevExpress.XtraBars.BarShortcut(System.Windows.Forms.Keys.F1); this.barButtonItem1.LargeGlyph = ((System.Drawing.Image)(resources.GetObject("barButtonItem1.LargeGlyph"))); this.barButtonItem1.Name = "barButtonItem1"; this.barButtonItem1.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.barButtonItem1_ItemClick); // // barButtonItem2 // this.barButtonItem2.Caption = "F2- Crear Corredor"; this.barButtonItem2.Glyph = ((System.Drawing.Image)(resources.GetObject("barButtonItem2.Glyph"))); this.barButtonItem2.Id = 2; this.barButtonItem2.ItemShortcut = new DevExpress.XtraBars.BarShortcut(System.Windows.Forms.Keys.F2); this.barButtonItem2.LargeGlyph = ((System.Drawing.Image)(resources.GetObject("barButtonItem2.LargeGlyph"))); this.barButtonItem2.Name = "barButtonItem2"; // // bbiDxIniciarCarrera // this.bbiDxIniciarCarrera.Caption = "F3 - Iniciar carrera"; this.bbiDxIniciarCarrera.Glyph = ((System.Drawing.Image)(resources.GetObject("bbiDxIniciarCarrera.Glyph"))); this.bbiDxIniciarCarrera.Id = 3; this.bbiDxIniciarCarrera.ItemShortcut = new DevExpress.XtraBars.BarShortcut(System.Windows.Forms.Keys.F3); this.bbiDxIniciarCarrera.LargeGlyph = ((System.Drawing.Image)(resources.GetObject("bbiDxIniciarCarrera.LargeGlyph"))); this.bbiDxIniciarCarrera.Name = "bbiDxIniciarCarrera"; // // barButtonItem3 // this.barButtonItem3.Caption = "F5 - Actualizar Datos"; this.barButtonItem3.Glyph = ((System.Drawing.Image)(resources.GetObject("barButtonItem3.Glyph"))); this.barButtonItem3.Id = 4; this.barButtonItem3.ItemShortcut = new DevExpress.XtraBars.BarShortcut(System.Windows.Forms.Keys.F5); this.barButtonItem3.LargeGlyph = ((System.Drawing.Image)(resources.GetObject("barButtonItem3.LargeGlyph"))); this.barButtonItem3.Name = "barButtonItem3"; // // barButtonItem4 // this.barButtonItem4.Caption = "F6 - Borrar Tiempo"; this.barButtonItem4.Glyph = ((System.Drawing.Image)(resources.GetObject("barButtonItem4.Glyph"))); this.barButtonItem4.Id = 5; this.barButtonItem4.ItemShortcut = new DevExpress.XtraBars.BarShortcut(System.Windows.Forms.Keys.F6); this.barButtonItem4.LargeGlyph = ((System.Drawing.Image)(resources.GetObject("barButtonItem4.LargeGlyph"))); this.barButtonItem4.Name = "barButtonItem4"; // // barButtonItem5 // this.barButtonItem5.Caption = "F7 - Borrar Inicio de carrera"; this.barButtonItem5.Glyph = ((System.Drawing.Image)(resources.GetObject("barButtonItem5.Glyph"))); this.barButtonItem5.Id = 6; this.barButtonItem5.ItemShortcut = new DevExpress.XtraBars.BarShortcut(System.Windows.Forms.Keys.F7); this.barButtonItem5.LargeGlyph = ((System.Drawing.Image)(resources.GetObject("barButtonItem5.LargeGlyph"))); this.barButtonItem5.Name = "barButtonItem5"; // // barButtonItem6 // this.barButtonItem6.Caption = "Exportar XLS"; this.barButtonItem6.Glyph = ((System.Drawing.Image)(resources.GetObject("barButtonItem6.Glyph"))); this.barButtonItem6.Id = 7; this.barButtonItem6.LargeGlyph = ((System.Drawing.Image)(resources.GetObject("barButtonItem6.LargeGlyph"))); this.barButtonItem6.Name = "barButtonItem6"; this.barButtonItem6.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.barButtonItem6_ItemClick); // // barButtonItem7 // this.barButtonItem7.Caption = "Exportar PDF"; this.barButtonItem7.Glyph = ((System.Drawing.Image)(resources.GetObject("barButtonItem7.Glyph"))); this.barButtonItem7.Id = 8; this.barButtonItem7.LargeGlyph = ((System.Drawing.Image)(resources.GetObject("barButtonItem7.LargeGlyph"))); this.barButtonItem7.Name = "barButtonItem7"; this.barButtonItem7.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.barButtonItem7_ItemClick); // // ribbonPage1 // this.ribbonPage1.Groups.AddRange(new DevExpress.XtraBars.Ribbon.RibbonPageGroup[] { this.ribbonPageGroup1 }); this.ribbonPage1.Name = "ribbonPage1"; this.ribbonPage1.Text = "Opciones"; // // ribbonPageGroup1 // this.ribbonPageGroup1.Glyph = ((System.Drawing.Image)(resources.GetObject("ribbonPageGroup1.Glyph"))); this.ribbonPageGroup1.ItemLinks.Add(this.barButtonItem1); this.ribbonPageGroup1.ItemLinks.Add(this.barButtonItem6); this.ribbonPageGroup1.ItemLinks.Add(this.barButtonItem7); this.ribbonPageGroup1.Name = "ribbonPageGroup1"; this.ribbonPageGroup1.Text = "Tiempo"; // // pivotGridField7 // this.pivotGridField7.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.pivotGridField7.AreaIndex = 0; this.pivotGridField7.CellFormat.FormatString = "d"; this.pivotGridField7.CellFormat.FormatType = DevExpress.Utils.FormatType.DateTime; this.pivotGridField7.FieldName = "TiempoRegistrado"; this.pivotGridField7.Name = "pivotGridField7"; this.pivotGridField7.SummaryDisplayType = DevExpress.Data.PivotGrid.PivotSummaryDisplayType.RankInColumnLargestToSmallest; this.pivotGridField7.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Custom; this.pivotGridField7.UnboundType = DevExpress.Data.UnboundColumnType.DateTime; this.pivotGridField7.ValueFormat.FormatString = "d"; this.pivotGridField7.ValueFormat.FormatType = DevExpress.Utils.FormatType.DateTime; // // pivotGridField8 // this.pivotGridField8.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.pivotGridField8.AreaIndex = 0; this.pivotGridField8.CellFormat.FormatString = "d"; this.pivotGridField8.CellFormat.FormatType = DevExpress.Utils.FormatType.DateTime; this.pivotGridField8.FieldName = "TiempoRegistrado"; this.pivotGridField8.Name = "pivotGridField8"; this.pivotGridField8.SummaryDisplayType = DevExpress.Data.PivotGrid.PivotSummaryDisplayType.RankInColumnLargestToSmallest; this.pivotGridField8.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Custom; this.pivotGridField8.UnboundType = DevExpress.Data.UnboundColumnType.DateTime; this.pivotGridField8.ValueFormat.FormatString = "d"; this.pivotGridField8.ValueFormat.FormatType = DevExpress.Utils.FormatType.DateTime; // // pivotGridField9 // this.pivotGridField9.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.pivotGridField9.AreaIndex = 0; this.pivotGridField9.CellFormat.FormatString = "d"; this.pivotGridField9.CellFormat.FormatType = DevExpress.Utils.FormatType.DateTime; this.pivotGridField9.FieldName = "TiempoRegistrado"; this.pivotGridField9.Name = "pivotGridField9"; this.pivotGridField9.SummaryDisplayType = DevExpress.Data.PivotGrid.PivotSummaryDisplayType.RankInColumnLargestToSmallest; this.pivotGridField9.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Custom; this.pivotGridField9.UnboundType = DevExpress.Data.UnboundColumnType.DateTime; this.pivotGridField9.ValueFormat.FormatString = "d"; this.pivotGridField9.ValueFormat.FormatType = DevExpress.Utils.FormatType.DateTime; // // pivotGridField10 // this.pivotGridField10.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.pivotGridField10.AreaIndex = 0; this.pivotGridField10.CellFormat.FormatString = "d"; this.pivotGridField10.CellFormat.FormatType = DevExpress.Utils.FormatType.DateTime; this.pivotGridField10.FieldName = "TiempoRegistrado"; this.pivotGridField10.Name = "pivotGridField10"; this.pivotGridField10.SummaryDisplayType = DevExpress.Data.PivotGrid.PivotSummaryDisplayType.RankInColumnLargestToSmallest; this.pivotGridField10.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Custom; this.pivotGridField10.UnboundType = DevExpress.Data.UnboundColumnType.DateTime; this.pivotGridField10.ValueFormat.FormatString = "d"; this.pivotGridField10.ValueFormat.FormatType = DevExpress.Utils.FormatType.DateTime; // // pivotGridField11 // this.pivotGridField11.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.pivotGridField11.AreaIndex = 0; this.pivotGridField11.CellFormat.FormatString = "d"; this.pivotGridField11.CellFormat.FormatType = DevExpress.Utils.FormatType.DateTime; this.pivotGridField11.FieldName = "TiempoRegistrado"; this.pivotGridField11.Name = "pivotGridField11"; this.pivotGridField11.SummaryDisplayType = DevExpress.Data.PivotGrid.PivotSummaryDisplayType.RankInColumnLargestToSmallest; this.pivotGridField11.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Custom; this.pivotGridField11.UnboundType = DevExpress.Data.UnboundColumnType.DateTime; this.pivotGridField11.ValueFormat.FormatString = "d"; this.pivotGridField11.ValueFormat.FormatType = DevExpress.Utils.FormatType.DateTime; // // FormReporteTiempo // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(885, 454); this.Controls.Add(this.panel1); this.Controls.Add(this.ribbonControl1); this.Name = "FormReporteTiempo"; this.Text = "FormReporteTiempo"; this.panel1.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.gcDxTiempo)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1.CalendarTimeProperties)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.ribbonControl1)).EndInit(); this.ResumeLayout(false); this.PerformLayout(); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup(); this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl(); this.Col_pe_cedulaRuc = new DevExpress.XtraPivotGrid.PivotGridField(); this.Col_pe_nombre = new DevExpress.XtraPivotGrid.PivotGridField(); this.Col_es_fecha_registro = new DevExpress.XtraPivotGrid.PivotGridField(); this.Col_Cargo = new DevExpress.XtraPivotGrid.PivotGridField(); this.Col_de_descripcion = new DevExpress.XtraPivotGrid.PivotGridField(); this.Col_zo_descripcion = new DevExpress.XtraPivotGrid.PivotGridField(); this.ColDisco = new DevExpress.XtraPivotGrid.PivotGridField(); this.Col_ru_descripcion = new DevExpress.XtraPivotGrid.PivotGridField(); this.Col_em_status = new DevExpress.XtraPivotGrid.PivotGridField(); this.Col_Placa = new DevExpress.XtraPivotGrid.PivotGridField(); this.Col_fu_descripcion = new DevExpress.XtraPivotGrid.PivotGridField(); this.Col_Orden = new DevExpress.XtraPivotGrid.PivotGridField(); this.Col_Valor = new DevExpress.XtraPivotGrid.PivotGridField(); this.Col_rubro = new DevExpress.XtraPivotGrid.PivotGridField(); this.Col_pe_FechaIni = new DevExpress.XtraPivotGrid.PivotGridField(); this.Col_Grupo = new DevExpress.XtraPivotGrid.PivotGridField(); this.ucRo_Menu = new Core.Erp.Reportes.Controles.UCRo_Menu_Reportes(); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit(); this.SuspendLayout(); // // pivotGridControl1 // this.pivotGridControl1.Appearance.FieldHeader.BackColor = System.Drawing.Color.White; this.pivotGridControl1.Appearance.FieldHeader.BackColor2 = System.Drawing.Color.White; this.pivotGridControl1.Appearance.FieldHeader.ForeColor = System.Drawing.Color.Red; this.pivotGridControl1.Appearance.FieldHeader.Options.UseBackColor = true; this.pivotGridControl1.Appearance.FieldHeader.Options.UseForeColor = true; this.pivotGridControl1.Appearance.FieldValue.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(128)))), ((int)(((byte)(0))))); this.pivotGridControl1.Appearance.FieldValue.Options.UseForeColor = true; this.pivotGridControl1.Appearance.FieldValueTotal.ForeColor = System.Drawing.Color.Black; this.pivotGridControl1.Appearance.FieldValueTotal.Options.UseForeColor = true; this.pivotGridControl1.AppearancePrint.FieldHeader.BackColor = System.Drawing.Color.Black; this.pivotGridControl1.AppearancePrint.FieldHeader.BackColor2 = System.Drawing.Color.White; this.pivotGridControl1.AppearancePrint.FieldHeader.ForeColor = System.Drawing.Color.Red; this.pivotGridControl1.AppearancePrint.FieldHeader.Options.UseBackColor = true; this.pivotGridControl1.AppearancePrint.FieldHeader.Options.UseBorderColor = true; this.pivotGridControl1.AppearancePrint.FieldHeader.Options.UseFont = true; this.pivotGridControl1.AppearancePrint.FieldHeader.Options.UseForeColor = true; this.pivotGridControl1.AppearancePrint.FieldValue.BackColor = System.Drawing.Color.Transparent; this.pivotGridControl1.AppearancePrint.FieldValue.BackColor2 = System.Drawing.Color.Transparent; this.pivotGridControl1.AppearancePrint.FieldValue.ForeColor = System.Drawing.Color.Black; this.pivotGridControl1.AppearancePrint.FieldValue.Options.UseBackColor = true; this.pivotGridControl1.AppearancePrint.FieldValue.Options.UseForeColor = true; this.pivotGridControl1.AppearancePrint.FieldValueTotal.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(128)))), ((int)(((byte)(128)))), ((int)(((byte)(255))))); this.pivotGridControl1.AppearancePrint.FieldValueTotal.Options.UseForeColor = true; this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill; this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] { this.Col_pe_cedulaRuc, this.Col_pe_nombre, this.Col_es_fecha_registro, this.Col_Cargo, this.Col_de_descripcion, this.Col_zo_descripcion, this.ColDisco, this.Col_ru_descripcion, this.Col_em_status, this.Col_Placa, this.Col_fu_descripcion, this.Col_Orden, this.Col_Valor, this.Col_rubro, this.Col_pe_FechaIni, this.Col_Grupo }); pivotGridGroup1.Caption = "Grupos"; pivotGridGroup1.Fields.Add(this.Col_Grupo); pivotGridGroup1.Hierarchy = null; pivotGridGroup1.ShowNewValues = true; this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] { pivotGridGroup1 }); this.pivotGridControl1.Location = new System.Drawing.Point(0, 77); this.pivotGridControl1.Name = "pivotGridControl1"; this.pivotGridControl1.OptionsPrint.MergeRowFieldValues = false; this.pivotGridControl1.OptionsPrint.PrintHeadersOnEveryPage = true; this.pivotGridControl1.OptionsPrint.PrintUnusedFilterFields = false; this.pivotGridControl1.OptionsPrint.UsePrintAppearance = true; this.pivotGridControl1.OptionsView.ShowColumnGrandTotalHeader = false; this.pivotGridControl1.OptionsView.ShowColumnGrandTotals = false; this.pivotGridControl1.OptionsView.ShowColumnTotals = false; this.pivotGridControl1.OptionsView.ShowRowGrandTotalHeader = false; this.pivotGridControl1.OptionsView.ShowRowGrandTotals = false; this.pivotGridControl1.OptionsView.ShowRowTotals = false; this.pivotGridControl1.Size = new System.Drawing.Size(1090, 441); this.pivotGridControl1.TabIndex = 151; // // Col_pe_cedulaRuc // this.Col_pe_cedulaRuc.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.Col_pe_cedulaRuc.AreaIndex = 0; this.Col_pe_cedulaRuc.Caption = "Cedula"; this.Col_pe_cedulaRuc.FieldName = "pe_cedulaRuc"; this.Col_pe_cedulaRuc.Name = "Col_pe_cedulaRuc"; this.Col_pe_cedulaRuc.Options.ReadOnly = true; this.Col_pe_cedulaRuc.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Min; // // Col_pe_nombre // this.Col_pe_nombre.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.Col_pe_nombre.AreaIndex = 1; this.Col_pe_nombre.Caption = "Empleado"; this.Col_pe_nombre.FieldName = "pe_nombreCompleto"; this.Col_pe_nombre.Name = "Col_pe_nombre"; this.Col_pe_nombre.Options.ReadOnly = true; // // Col_es_fecha_registro // this.Col_es_fecha_registro.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.Col_es_fecha_registro.AreaIndex = 2; this.Col_es_fecha_registro.Caption = "Fecha"; this.Col_es_fecha_registro.CellFormat.FormatString = "{0:d}"; this.Col_es_fecha_registro.CellFormat.FormatType = DevExpress.Utils.FormatType.DateTime; this.Col_es_fecha_registro.FieldName = "em_fechaIngaRol"; this.Col_es_fecha_registro.Name = "Col_es_fecha_registro"; this.Col_es_fecha_registro.Options.ReadOnly = true; // // Col_Cargo // this.Col_Cargo.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.Col_Cargo.AreaIndex = 3; this.Col_Cargo.Caption = "Cargo"; this.Col_Cargo.FieldName = "ca_descripcion"; this.Col_Cargo.Name = "Col_Cargo"; this.Col_Cargo.Options.ReadOnly = true; // // Col_de_descripcion // this.Col_de_descripcion.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.Col_de_descripcion.AreaIndex = 4; this.Col_de_descripcion.Caption = "Departamento"; this.Col_de_descripcion.FieldName = "de_descripcion"; this.Col_de_descripcion.Name = "Col_de_descripcion"; this.Col_de_descripcion.Options.ReadOnly = true; // // Col_zo_descripcion // this.Col_zo_descripcion.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.Col_zo_descripcion.AreaIndex = 5; this.Col_zo_descripcion.Caption = "Zona"; this.Col_zo_descripcion.FieldName = "zo_descripcion"; this.Col_zo_descripcion.Name = "Col_zo_descripcion"; // // ColDisco // this.ColDisco.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.ColDisco.AreaIndex = 6; this.ColDisco.Caption = "Disco"; this.ColDisco.FieldName = "Disco"; this.ColDisco.Name = "ColDisco"; // // Col_ru_descripcion // this.Col_ru_descripcion.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.Col_ru_descripcion.AreaIndex = 7; this.Col_ru_descripcion.Caption = "Ruta"; this.Col_ru_descripcion.FieldName = "ru_descripcion"; this.Col_ru_descripcion.Name = "Col_ru_descripcion"; // // Col_em_status // this.Col_em_status.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.Col_em_status.AreaIndex = 8; this.Col_em_status.Caption = "Estado"; this.Col_em_status.FieldName = "em_status"; this.Col_em_status.Name = "Col_em_status"; // // Col_Placa // this.Col_Placa.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.Col_Placa.AreaIndex = 9; this.Col_Placa.Caption = "Placa"; this.Col_Placa.FieldName = "Placa"; this.Col_Placa.Name = "Col_Placa"; // // Col_fu_descripcion // this.Col_fu_descripcion.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.Col_fu_descripcion.AreaIndex = 10; this.Col_fu_descripcion.Caption = "Fuerza"; this.Col_fu_descripcion.FieldName = "fu_descripcion"; this.Col_fu_descripcion.Name = "Col_fu_descripcion"; // // Col_Orden // this.Col_Orden.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.Col_Orden.AreaIndex = 1; this.Col_Orden.Caption = "Orden"; this.Col_Orden.FieldName = "Orden"; this.Col_Orden.Name = "Col_Orden"; // // Col_Valor // this.Col_Valor.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.Col_Valor.AreaIndex = 0; this.Col_Valor.Caption = "Valor"; this.Col_Valor.FieldName = "Valor"; this.Col_Valor.Name = "Col_Valor"; // // Col_rubro // this.Col_rubro.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.Col_rubro.AreaIndex = 2; this.Col_rubro.Caption = "Rubro"; this.Col_rubro.FieldName = "Descripcion"; this.Col_rubro.Name = "Col_rubro"; // // Col_pe_FechaIni // this.Col_pe_FechaIni.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.Col_pe_FechaIni.AreaIndex = 11; this.Col_pe_FechaIni.Caption = "Fecha Mes"; this.Col_pe_FechaIni.CellFormat.FormatString = "{0:d}"; this.Col_pe_FechaIni.CellFormat.FormatType = DevExpress.Utils.FormatType.DateTime; this.Col_pe_FechaIni.FieldName = "pe_FechaIni"; this.Col_pe_FechaIni.Name = "Col_pe_FechaIni"; // // Col_Grupo // this.Col_Grupo.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.Col_Grupo.AreaIndex = 0; this.Col_Grupo.Caption = "Grupo"; this.Col_Grupo.FieldName = "Grupo"; this.Col_Grupo.Name = "Col_Grupo"; // // ucRo_Menu // this.ucRo_Menu.Dock = System.Windows.Forms.DockStyle.Top; this.ucRo_Menu.EnableBotonImprimir = true; this.ucRo_Menu.Location = new System.Drawing.Point(0, 0); this.ucRo_Menu.Name = "ucRo_Menu"; this.ucRo_Menu.Size = new System.Drawing.Size(1090, 77); this.ucRo_Menu.TabIndex = 150; this.ucRo_Menu.VisibleCmbCentroCosto = DevExpress.XtraBars.BarItemVisibility.Never; this.ucRo_Menu.VisibleCmbDivision = DevExpress.XtraBars.BarItemVisibility.Never; this.ucRo_Menu.VisibleCmbEmpleado = DevExpress.XtraBars.BarItemVisibility.Never; this.ucRo_Menu.VisibleCmbNominaTipo = DevExpress.XtraBars.BarItemVisibility.Always; this.ucRo_Menu.VisibleCmbNominaTipoLiqui = DevExpress.XtraBars.BarItemVisibility.Always; this.ucRo_Menu.VisibleCmbPeriodo = DevExpress.XtraBars.BarItemVisibility.Always; this.ucRo_Menu.VisibleCmbRubro = DevExpress.XtraBars.BarItemVisibility.Never; this.ucRo_Menu.VisibleGrupoFecha = false; this.ucRo_Menu.VisibleGrupoFiltro1 = true; this.ucRo_Menu.VisibleGrupoFiltro2 = false; // // XFACT_FJ_Rpt008_frm // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(1090, 518); this.Controls.Add(this.pivotGridControl1); this.Controls.Add(this.ucRo_Menu); this.Name = "XFACT_FJ_Rpt008_frm"; this.Text = "XFACT_FJ_Rpt006_frm"; ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup(); this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl(); this.Col_pe_cedulaRuc = new DevExpress.XtraPivotGrid.PivotGridField(); this.Col_zo_descripcion = new DevExpress.XtraPivotGrid.PivotGridField(); this.cOL_fu_descripcion = new DevExpress.XtraPivotGrid.PivotGridField(); this.cOL_DISCO = new DevExpress.XtraPivotGrid.PivotGridField(); this.cOL_Placa = new DevExpress.XtraPivotGrid.PivotGridField(); this.cOL_ru_descripcion = new DevExpress.XtraPivotGrid.PivotGridField(); this.cOL_em_fechaIngaRol = new DevExpress.XtraPivotGrid.PivotGridField(); this.cOL_pe_FechaIni = new DevExpress.XtraPivotGrid.PivotGridField(); this.cOL_em_fechaSalida = new DevExpress.XtraPivotGrid.PivotGridField(); this.cOL_Cedula = new DevExpress.XtraPivotGrid.PivotGridField(); this.cOLNombres = new DevExpress.XtraPivotGrid.PivotGridField(); this.cOL_ca_descripcion = new DevExpress.XtraPivotGrid.PivotGridField(); this.cOL_ca_orden = new DevExpress.XtraPivotGrid.PivotGridField(); this.cOL_Descripcion = new DevExpress.XtraPivotGrid.PivotGridField(); this.COL_Valor = new DevExpress.XtraPivotGrid.PivotGridField(); this.Col_Catalogo = new DevExpress.XtraPivotGrid.PivotGridField(); this.ucRo_Menu = new Core.Erp.Reportes.Controles.UCRo_Menu_Reportes(); this.Col_Dias_vacaciones = new DevExpress.XtraPivotGrid.PivotGridField(); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit(); this.SuspendLayout(); // // pivotGridControl1 // this.pivotGridControl1.Appearance.FieldHeader.BackColor = System.Drawing.Color.White; this.pivotGridControl1.Appearance.FieldHeader.BackColor2 = System.Drawing.Color.White; this.pivotGridControl1.Appearance.FieldHeader.ForeColor = System.Drawing.Color.Red; this.pivotGridControl1.Appearance.FieldHeader.Options.UseBackColor = true; this.pivotGridControl1.Appearance.FieldHeader.Options.UseForeColor = true; this.pivotGridControl1.Appearance.FieldValue.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(128)))), ((int)(((byte)(0))))); this.pivotGridControl1.Appearance.FieldValue.Options.UseForeColor = true; this.pivotGridControl1.Appearance.FieldValueTotal.ForeColor = System.Drawing.Color.Black; this.pivotGridControl1.Appearance.FieldValueTotal.Options.UseForeColor = true; this.pivotGridControl1.AppearancePrint.FieldHeader.BackColor = System.Drawing.Color.Black; this.pivotGridControl1.AppearancePrint.FieldHeader.BackColor2 = System.Drawing.Color.White; this.pivotGridControl1.AppearancePrint.FieldHeader.ForeColor = System.Drawing.Color.Red; this.pivotGridControl1.AppearancePrint.FieldHeader.Options.UseBackColor = true; this.pivotGridControl1.AppearancePrint.FieldHeader.Options.UseBorderColor = true; this.pivotGridControl1.AppearancePrint.FieldHeader.Options.UseFont = true; this.pivotGridControl1.AppearancePrint.FieldHeader.Options.UseForeColor = true; this.pivotGridControl1.AppearancePrint.FieldValue.BackColor = System.Drawing.Color.Transparent; this.pivotGridControl1.AppearancePrint.FieldValue.BackColor2 = System.Drawing.Color.Transparent; this.pivotGridControl1.AppearancePrint.FieldValue.ForeColor = System.Drawing.Color.Black; this.pivotGridControl1.AppearancePrint.FieldValue.Options.UseBackColor = true; this.pivotGridControl1.AppearancePrint.FieldValue.Options.UseForeColor = true; this.pivotGridControl1.AppearancePrint.FieldValueTotal.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(128)))), ((int)(((byte)(128)))), ((int)(((byte)(255))))); this.pivotGridControl1.AppearancePrint.FieldValueTotal.Options.UseForeColor = true; this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill; this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] { this.Col_pe_cedulaRuc, this.Col_zo_descripcion, this.cOL_fu_descripcion, this.cOL_DISCO, this.cOL_Placa, this.cOL_ru_descripcion, this.cOL_em_fechaIngaRol, this.cOL_pe_FechaIni, this.cOL_em_fechaSalida, this.cOL_Cedula, this.cOLNombres, this.cOL_ca_descripcion, this.cOL_ca_orden, this.cOL_Descripcion, this.COL_Valor, this.Col_Catalogo, this.Col_Dias_vacaciones }); pivotGridGroup1.Caption = "Grupos"; pivotGridGroup1.Hierarchy = null; pivotGridGroup1.ShowNewValues = true; this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] { pivotGridGroup1 }); this.pivotGridControl1.Location = new System.Drawing.Point(0, 74); this.pivotGridControl1.Name = "pivotGridControl1"; this.pivotGridControl1.OptionsBehavior.HorizontalScrolling = DevExpress.XtraPivotGrid.PivotGridScrolling.Control; this.pivotGridControl1.OptionsPrint.MergeColumnFieldValues = false; this.pivotGridControl1.OptionsPrint.MergeRowFieldValues = false; this.pivotGridControl1.OptionsPrint.PrintHeadersOnEveryPage = true; this.pivotGridControl1.OptionsPrint.PrintUnusedFilterFields = false; this.pivotGridControl1.OptionsPrint.UsePrintAppearance = true; this.pivotGridControl1.OptionsView.ShowColumnGrandTotalHeader = false; this.pivotGridControl1.OptionsView.ShowColumnGrandTotals = false; this.pivotGridControl1.OptionsView.ShowColumnTotals = false; this.pivotGridControl1.OptionsView.ShowRowGrandTotalHeader = false; this.pivotGridControl1.OptionsView.ShowRowGrandTotals = false; this.pivotGridControl1.OptionsView.ShowRowTotals = false; this.pivotGridControl1.Size = new System.Drawing.Size(1284, 417); this.pivotGridControl1.TabIndex = 149; this.pivotGridControl1.Click += new System.EventHandler(this.pivotGridControl1_Click); // // Col_pe_cedulaRuc // this.Col_pe_cedulaRuc.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.Col_pe_cedulaRuc.AreaIndex = 0; this.Col_pe_cedulaRuc.Caption = "Cedula"; this.Col_pe_cedulaRuc.FieldName = "pe_cedulaRuc"; this.Col_pe_cedulaRuc.Name = "Col_pe_cedulaRuc"; this.Col_pe_cedulaRuc.Options.ReadOnly = true; this.Col_pe_cedulaRuc.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Count; // // Col_zo_descripcion // this.Col_zo_descripcion.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.Col_zo_descripcion.AreaIndex = 1; this.Col_zo_descripcion.Caption = "ZONA"; this.Col_zo_descripcion.FieldName = "zo_descripcion"; this.Col_zo_descripcion.Name = "Col_zo_descripcion"; // // cOL_fu_descripcion // this.cOL_fu_descripcion.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.cOL_fu_descripcion.AreaIndex = 2; this.cOL_fu_descripcion.Caption = "FUERZA"; this.cOL_fu_descripcion.FieldName = "fu_descripcion"; this.cOL_fu_descripcion.Name = "cOL_fu_descripcion"; // // cOL_DISCO // this.cOL_DISCO.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.cOL_DISCO.AreaIndex = 3; this.cOL_DISCO.Caption = "DISCO"; this.cOL_DISCO.FieldName = "Disco"; this.cOL_DISCO.Name = "cOL_DISCO"; // // cOL_Placa // this.cOL_Placa.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.cOL_Placa.AreaIndex = 4; this.cOL_Placa.Caption = "PLACA"; this.cOL_Placa.FieldName = "Placa"; this.cOL_Placa.Name = "cOL_Placa"; // // cOL_ru_descripcion // this.cOL_ru_descripcion.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.cOL_ru_descripcion.AreaIndex = 5; this.cOL_ru_descripcion.Caption = "RUTA"; this.cOL_ru_descripcion.FieldName = "ru_descripcion"; this.cOL_ru_descripcion.Name = "cOL_ru_descripcion"; // // cOL_em_fechaIngaRol // this.cOL_em_fechaIngaRol.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.cOL_em_fechaIngaRol.AreaIndex = 6; this.cOL_em_fechaIngaRol.Caption = "FECHA INGRESO"; this.cOL_em_fechaIngaRol.FieldName = "em_fechaIngaRol"; this.cOL_em_fechaIngaRol.Name = "cOL_em_fechaIngaRol"; // // cOL_pe_FechaIni // this.cOL_pe_FechaIni.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.cOL_pe_FechaIni.AreaIndex = 7; this.cOL_pe_FechaIni.Caption = "FECHA MES"; this.cOL_pe_FechaIni.FieldName = "pe_FechaIni"; this.cOL_pe_FechaIni.Name = "cOL_pe_FechaIni"; // // cOL_em_fechaSalida // this.cOL_em_fechaSalida.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.cOL_em_fechaSalida.AreaIndex = 8; this.cOL_em_fechaSalida.Caption = "FECHA SALIDA"; this.cOL_em_fechaSalida.FieldName = "em_fechaSalida"; this.cOL_em_fechaSalida.Name = "cOL_em_fechaSalida"; // // cOL_Cedula // this.cOL_Cedula.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.cOL_Cedula.AreaIndex = 9; this.cOL_Cedula.Caption = "CEDULA"; this.cOL_Cedula.FieldName = "pe_cedulaRuc"; this.cOL_Cedula.Name = "cOL_Cedula"; // // cOLNombres // this.cOLNombres.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.cOLNombres.AreaIndex = 10; this.cOLNombres.Caption = "APELLIDOS Y NOMBRES"; this.cOLNombres.FieldName = "Nombres"; this.cOLNombres.Name = "cOLNombres"; // // cOL_ca_descripcion // this.cOL_ca_descripcion.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.cOL_ca_descripcion.AreaIndex = 11; this.cOL_ca_descripcion.Caption = "CARGO"; this.cOL_ca_descripcion.FieldName = "ca_descripcion"; this.cOL_ca_descripcion.Name = "cOL_ca_descripcion"; // // cOL_ca_orden // this.cOL_ca_orden.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.cOL_ca_orden.AreaIndex = 1; this.cOL_ca_orden.Caption = "ORDEN2"; this.cOL_ca_orden.FieldName = "Orden"; this.cOL_ca_orden.Name = "cOL_ca_orden"; // // cOL_Descripcion // this.cOL_Descripcion.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.cOL_Descripcion.AreaIndex = 2; this.cOL_Descripcion.Caption = "RUBRO"; this.cOL_Descripcion.FieldName = "Descripcion"; this.cOL_Descripcion.Name = "cOL_Descripcion"; // // COL_Valor // this.COL_Valor.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.COL_Valor.AreaIndex = 0; this.COL_Valor.Caption = "VALOR"; this.COL_Valor.FieldName = "Valor"; this.COL_Valor.Name = "COL_Valor"; // // Col_Catalogo // this.Col_Catalogo.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.Col_Catalogo.AreaIndex = 0; this.Col_Catalogo.Caption = "ORDEN1"; this.Col_Catalogo.FieldName = "Catalogo"; this.Col_Catalogo.Name = "Col_Catalogo"; // // ucRo_Menu // this.ucRo_Menu.caption_bei_check1 = "Check"; this.ucRo_Menu.Dock = System.Windows.Forms.DockStyle.Top; this.ucRo_Menu.EnableBotonImprimir = true; this.ucRo_Menu.Location = new System.Drawing.Point(0, 0); this.ucRo_Menu.Name = "ucRo_Menu"; this.ucRo_Menu.Size = new System.Drawing.Size(1284, 74); this.ucRo_Menu.TabIndex = 148; this.ucRo_Menu.Visible_bei_check1 = DevExpress.XtraBars.BarItemVisibility.Never; this.ucRo_Menu.VisibleCmbCentroCosto = DevExpress.XtraBars.BarItemVisibility.Never; this.ucRo_Menu.VisibleCmbDivision = DevExpress.XtraBars.BarItemVisibility.Never; this.ucRo_Menu.VisibleCmbEmpleado = DevExpress.XtraBars.BarItemVisibility.Never; this.ucRo_Menu.VisibleCmbNominaTipo = DevExpress.XtraBars.BarItemVisibility.Always; this.ucRo_Menu.VisibleCmbNominaTipoLiqui = DevExpress.XtraBars.BarItemVisibility.Always; this.ucRo_Menu.VisibleCmbPeriodo = DevExpress.XtraBars.BarItemVisibility.Always; this.ucRo_Menu.VisibleCmbRubro = DevExpress.XtraBars.BarItemVisibility.Never; this.ucRo_Menu.VisibleDepartamento = DevExpress.XtraBars.BarItemVisibility.Always; this.ucRo_Menu.VisibleEstado = DevExpress.XtraBars.BarItemVisibility.Always; this.ucRo_Menu.VisibleGrupoFecha = false; this.ucRo_Menu.VisibleGrupoFiltro1 = true; this.ucRo_Menu.VisibleGrupoFiltro2 = false; this.ucRo_Menu.VisubleArea = DevExpress.XtraBars.BarItemVisibility.Always; this.ucRo_Menu.event_cmdCargar_ItemClick += new Core.Erp.Reportes.Controles.UCRo_Menu_Reportes.delegate_cmdCargar_ItemClick(this.ucRo_Menu_event_cmdCargar_ItemClick); this.ucRo_Menu.event_btnsalir_ItemClick += new Core.Erp.Reportes.Controles.UCRo_Menu_Reportes.delegate_btnsalir_ItemClick(this.ucRo_Menu_event_btnsalir_ItemClick); // // Col_Dias_vacaciones // this.Col_Dias_vacaciones.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.Col_Dias_vacaciones.AreaIndex = 12; this.Col_Dias_vacaciones.Caption = "Días vacaciones"; this.Col_Dias_vacaciones.FieldName = "Dias_vacaciones"; this.Col_Dias_vacaciones.Name = "Col_Dias_vacaciones"; // // XROLES_Rpt012_frm // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(1284, 491); this.Controls.Add(this.pivotGridControl1); this.Controls.Add(this.ucRo_Menu); this.Name = "XROLES_Rpt012_frm"; this.Text = "XROLES_Rpt012_frm"; ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit(); this.ResumeLayout(false); }
/// <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.Utils.SerializableAppearanceObject serializableAppearanceObject1 = new DevExpress.Utils.SerializableAppearanceObject(); DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup(); this.repositoryItemDateEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit(); this.dockManagerMain = new DevExpress.XtraBars.Docking.DockManager(this.components); this.barManager1 = new DevExpress.XtraBars.BarManager(this.components); this.bar2 = new DevExpress.XtraBars.Bar(); this.bbiExcelPivot = new DevExpress.XtraBars.BarButtonItem(); this.bbiExportRow = new DevExpress.XtraBars.BarButtonItem(); this.bbiPrint = new DevExpress.XtraBars.BarButtonItem(); this.bar3 = new DevExpress.XtraBars.Bar(); this.barDockControlTop = new DevExpress.XtraBars.BarDockControl(); this.barDockControlBottom = new DevExpress.XtraBars.BarDockControl(); this.barDockControlLeft = new DevExpress.XtraBars.BarDockControl(); this.barDockControlRight = new DevExpress.XtraBars.BarDockControl(); this.bbiExcelDynamicUpdate = new DevExpress.XtraBars.BarButtonItem(); this.panelContainerMain = new DevExpress.XtraBars.Docking.DockPanel(); this.dockPanelDashboard = new DevExpress.XtraBars.Docking.DockPanel(); this.dockPanel2_Container = new DevExpress.XtraBars.Docking.ControlContainer(); this.layoutControlParamter = new DevExpress.XtraLayout.LayoutControl(); this.layoutControlGroup2 = new DevExpress.XtraLayout.LayoutControlGroup(); this.layoutControlGroupParamters = new DevExpress.XtraLayout.LayoutControlGroup(); this.layoutControlDatasource = new DevExpress.XtraLayout.LayoutControl(); this.btnDeleteLayout = new DevExpress.XtraEditors.SimpleButton(); this.btnSaveAsLayout = new DevExpress.XtraEditors.SimpleButton(); this.btnLoadLayout = new DevExpress.XtraEditors.SimpleButton(); this.btnSaveLayout = new DevExpress.XtraEditors.SimpleButton(); this.lueLayout = new DevExpress.XtraEditors.GridLookUpEdit(); this.LSMSLayout = new DevExpress.Data.Linq.LinqServerModeSource(); this.gridView2 = new DevExpress.XtraGrid.Views.Grid.GridView(); this.colDatasourceLayoutName = new DevExpress.XtraGrid.Columns.GridColumn(); this.gridColumn4 = new DevExpress.XtraGrid.Columns.GridColumn(); this.gridColumn5 = new DevExpress.XtraGrid.Columns.GridColumn(); this.gridColumn3 = new DevExpress.XtraGrid.Columns.GridColumn(); this.ppWait = new DevExpress.XtraWaitForm.ProgressPanel(); this.btnLoadDashboard = new DevExpress.XtraEditors.SimpleButton(); this.layoutControlGroupDatasource = new DevExpress.XtraLayout.LayoutControlGroup(); this.layoutControlItem2 = new DevExpress.XtraLayout.LayoutControlItem(); this.layoutControlItemLoadLayout = new DevExpress.XtraLayout.LayoutControlItem(); this.layoutControlItemSave = new DevExpress.XtraLayout.LayoutControlItem(); this.lciWait = new DevExpress.XtraLayout.LayoutControlItem(); this.layoutControlItemSaveAs = new DevExpress.XtraLayout.LayoutControlItem(); this.layoutControlItemDelete = new DevExpress.XtraLayout.LayoutControlItem(); this.layoutControlItemLoad = new DevExpress.XtraLayout.LayoutControlItem(); this.dockPanelProperties = new DevExpress.XtraBars.Docking.DockPanel(); this.dockPanel1_Container = new DevExpress.XtraBars.Docking.ControlContainer(); this.layoutControl1 = new DevExpress.XtraLayout.LayoutControl(); this.pgcProperties = new DevExpress.XtraVerticalGrid.PropertyGridControl(); this.layoutControlGroup3 = new DevExpress.XtraLayout.LayoutControlGroup(); this.layoutControlItemPropertiesControl = new DevExpress.XtraLayout.LayoutControlItem(); this.LSMSDatasource = new DevExpress.Data.Linq.LinqServerModeSource(); this.pivotGridControlMain = new DevExpress.XtraPivotGrid.PivotGridControl(); this.get_sp_PramTableAdapter = new NICSQLTools.Data.dsQryTableAdapters.Get_sp_PramTableAdapter(); this.appDatasourceLayoutTableAdapter = new NICSQLTools.Data.dsDataTableAdapters.AppDatasourceLayoutTableAdapter(); this.appDashboardDSTableAdapter = new NICSQLTools.Data.dsDataSourceTableAdapters.AppDatasourceTableAdapter(); this.appDashboardDSPramTableAdapter = new NICSQLTools.Data.dsDataSourceTableAdapters.AppDatasourceParamTableAdapter(); this.sfd = new System.Windows.Forms.SaveFileDialog(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1.CalendarTimeProperties)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dockManagerMain)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.barManager1)).BeginInit(); this.panelContainerMain.SuspendLayout(); this.dockPanelDashboard.SuspendLayout(); this.dockPanel2_Container.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.layoutControlParamter)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.layoutControlGroupParamters)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.layoutControlDatasource)).BeginInit(); this.layoutControlDatasource.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.lueLayout.Properties)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.LSMSLayout)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.gridView2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.layoutControlGroupDatasource)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.layoutControlItemLoadLayout)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.layoutControlItemSave)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.lciWait)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.layoutControlItemSaveAs)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.layoutControlItemDelete)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.layoutControlItemLoad)).BeginInit(); this.dockPanelProperties.SuspendLayout(); this.dockPanel1_Container.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.layoutControl1)).BeginInit(); this.layoutControl1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.pgcProperties)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.layoutControlItemPropertiesControl)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.LSMSDatasource)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControlMain)).BeginInit(); this.SuspendLayout(); // // repositoryItemDateEdit1 // this.repositoryItemDateEdit1.AutoHeight = false; this.repositoryItemDateEdit1.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] { new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)}); this.repositoryItemDateEdit1.CalendarTimeProperties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] { new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)}); this.repositoryItemDateEdit1.DisplayFormat.FormatString = "d/M/yyyy hh:mm:ss"; this.repositoryItemDateEdit1.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime; this.repositoryItemDateEdit1.EditFormat.FormatString = "d/M/yyyy hh:mm:ss"; this.repositoryItemDateEdit1.EditFormat.FormatType = DevExpress.Utils.FormatType.DateTime; this.repositoryItemDateEdit1.Mask.EditMask = "d/M/yyyy hh:mm:ss"; this.repositoryItemDateEdit1.Name = "repositoryItemDateEdit1"; // // dockManagerMain // this.dockManagerMain.Form = this; this.dockManagerMain.MenuManager = this.barManager1; this.dockManagerMain.RootPanels.AddRange(new DevExpress.XtraBars.Docking.DockPanel[] { this.panelContainerMain}); this.dockManagerMain.TopZIndexControls.AddRange(new string[] { "DevExpress.XtraBars.BarDockControl", "DevExpress.XtraBars.StandaloneBarDockControl", "System.Windows.Forms.StatusBar", "System.Windows.Forms.MenuStrip", "System.Windows.Forms.StatusStrip", "DevExpress.XtraBars.Ribbon.RibbonStatusBar", "DevExpress.XtraBars.Ribbon.RibbonControl"}); // // barManager1 // this.barManager1.Bars.AddRange(new DevExpress.XtraBars.Bar[] { this.bar2, this.bar3}); this.barManager1.DockControls.Add(this.barDockControlTop); this.barManager1.DockControls.Add(this.barDockControlBottom); this.barManager1.DockControls.Add(this.barDockControlLeft); this.barManager1.DockControls.Add(this.barDockControlRight); this.barManager1.DockManager = this.dockManagerMain; this.barManager1.Form = this; this.barManager1.Items.AddRange(new DevExpress.XtraBars.BarItem[] { this.bbiExcelPivot, this.bbiPrint, this.bbiExportRow, this.bbiExcelDynamicUpdate}); this.barManager1.MainMenu = this.bar2; this.barManager1.MaxItemId = 8; this.barManager1.StatusBar = this.bar3; // // bar2 // this.bar2.BarName = "Main menu"; this.bar2.DockCol = 0; this.bar2.DockRow = 0; this.bar2.DockStyle = DevExpress.XtraBars.BarDockStyle.Top; this.bar2.LinksPersistInfo.AddRange(new DevExpress.XtraBars.LinkPersistInfo[] { new DevExpress.XtraBars.LinkPersistInfo(this.bbiExcelPivot), new DevExpress.XtraBars.LinkPersistInfo(this.bbiExportRow), new DevExpress.XtraBars.LinkPersistInfo(this.bbiPrint)}); this.bar2.OptionsBar.MultiLine = true; this.bar2.OptionsBar.UseWholeRow = true; this.bar2.Text = "Main menu"; // // bbiExcelPivot // this.bbiExcelPivot.Caption = "Excel Pivot"; this.bbiExcelPivot.Glyph = global::NICSQLTools.Properties.Resources.Export; this.bbiExcelPivot.Id = 0; this.bbiExcelPivot.Name = "bbiExcelPivot"; this.bbiExcelPivot.PaintStyle = DevExpress.XtraBars.BarItemPaintStyle.CaptionGlyph; this.bbiExcelPivot.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.bbiExcelPivot_ItemClick); // // bbiExportRow // this.bbiExportRow.Caption = "Export Table"; this.bbiExportRow.Glyph = global::NICSQLTools.Properties.Resources.grid_16x16; this.bbiExportRow.Id = 6; this.bbiExportRow.LargeGlyph = global::NICSQLTools.Properties.Resources.grid_32x32; this.bbiExportRow.Name = "bbiExportRow"; this.bbiExportRow.PaintStyle = DevExpress.XtraBars.BarItemPaintStyle.CaptionGlyph; this.bbiExportRow.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.bbiExportRow_ItemClick); // // bbiPrint // this.bbiPrint.Caption = "Print Pivot"; this.bbiPrint.Glyph = global::NICSQLTools.Properties.Resources.print_16x16; this.bbiPrint.Id = 4; this.bbiPrint.Name = "bbiPrint"; this.bbiPrint.PaintStyle = DevExpress.XtraBars.BarItemPaintStyle.CaptionGlyph; this.bbiPrint.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.bbiPrint_ItemClick); // // bar3 // this.bar3.BarName = "Status bar"; this.bar3.CanDockStyle = DevExpress.XtraBars.BarCanDockStyle.Bottom; this.bar3.DockCol = 0; this.bar3.DockRow = 0; this.bar3.DockStyle = DevExpress.XtraBars.BarDockStyle.Bottom; this.bar3.OptionsBar.AllowQuickCustomization = false; this.bar3.OptionsBar.DrawDragBorder = false; this.bar3.OptionsBar.UseWholeRow = true; this.bar3.Text = "Status bar"; // // barDockControlTop // this.barDockControlTop.CausesValidation = false; this.barDockControlTop.Dock = System.Windows.Forms.DockStyle.Top; this.barDockControlTop.Location = new System.Drawing.Point(0, 0); this.barDockControlTop.Size = new System.Drawing.Size(757, 24); // // barDockControlBottom // this.barDockControlBottom.CausesValidation = false; this.barDockControlBottom.Dock = System.Windows.Forms.DockStyle.Bottom; this.barDockControlBottom.Location = new System.Drawing.Point(0, 463); this.barDockControlBottom.Size = new System.Drawing.Size(757, 23); // // barDockControlLeft // this.barDockControlLeft.CausesValidation = false; this.barDockControlLeft.Dock = System.Windows.Forms.DockStyle.Left; this.barDockControlLeft.Location = new System.Drawing.Point(0, 24); this.barDockControlLeft.Size = new System.Drawing.Size(0, 439); // // barDockControlRight // this.barDockControlRight.CausesValidation = false; this.barDockControlRight.Dock = System.Windows.Forms.DockStyle.Right; this.barDockControlRight.Location = new System.Drawing.Point(757, 24); this.barDockControlRight.Size = new System.Drawing.Size(0, 439); // // bbiExcelDynamicUpdate // this.bbiExcelDynamicUpdate.Caption = "Excel Dynamic Update"; this.bbiExcelDynamicUpdate.Glyph = global::NICSQLTools.Properties.Resources.Excel16; this.bbiExcelDynamicUpdate.Id = 7; this.bbiExcelDynamicUpdate.Name = "bbiExcelDynamicUpdate"; this.bbiExcelDynamicUpdate.PaintStyle = DevExpress.XtraBars.BarItemPaintStyle.CaptionGlyph; // // panelContainerMain // this.panelContainerMain.ActiveChild = this.dockPanelDashboard; this.panelContainerMain.Controls.Add(this.dockPanelDashboard); this.panelContainerMain.Controls.Add(this.dockPanelProperties); this.panelContainerMain.Dock = DevExpress.XtraBars.Docking.DockingStyle.Left; this.panelContainerMain.ID = new System.Guid("b03cb66a-f343-43c5-9f00-cc38f1b88658"); this.panelContainerMain.Location = new System.Drawing.Point(0, 24); this.panelContainerMain.Name = "panelContainerMain"; this.panelContainerMain.OriginalSize = new System.Drawing.Size(363, 200); this.panelContainerMain.Size = new System.Drawing.Size(363, 439); this.panelContainerMain.Tabbed = true; this.panelContainerMain.Text = "panelContainer1"; // // dockPanelDashboard // this.dockPanelDashboard.Controls.Add(this.dockPanel2_Container); this.dockPanelDashboard.Dock = DevExpress.XtraBars.Docking.DockingStyle.Fill; this.dockPanelDashboard.FloatVertical = true; this.dockPanelDashboard.ID = new System.Guid("2fa5a753-1d56-4b04-8069-bd742a7da53c"); this.dockPanelDashboard.Image = global::NICSQLTools.Properties.Resources.properties_32x32; this.dockPanelDashboard.Location = new System.Drawing.Point(4, 23); this.dockPanelDashboard.Name = "dockPanelDashboard"; this.dockPanelDashboard.Options.ShowCloseButton = false; this.dockPanelDashboard.OriginalSize = new System.Drawing.Size(350, 368); this.dockPanelDashboard.Size = new System.Drawing.Size(355, 368); this.dockPanelDashboard.Text = "Control Panal"; // // dockPanel2_Container // this.dockPanel2_Container.Controls.Add(this.layoutControlParamter); this.dockPanel2_Container.Controls.Add(this.layoutControlDatasource); this.dockPanel2_Container.Location = new System.Drawing.Point(0, 0); this.dockPanel2_Container.Name = "dockPanel2_Container"; this.dockPanel2_Container.Size = new System.Drawing.Size(355, 368); this.dockPanel2_Container.TabIndex = 0; // // layoutControlParamter // this.layoutControlParamter.Dock = System.Windows.Forms.DockStyle.Fill; this.layoutControlParamter.Location = new System.Drawing.Point(0, 157); this.layoutControlParamter.Name = "layoutControlParamter"; this.layoutControlParamter.OptionsCustomizationForm.DesignTimeCustomizationFormPositionAndSize = new System.Drawing.Rectangle(406, 100, 434, 493); this.layoutControlParamter.Root = this.layoutControlGroup2; this.layoutControlParamter.Size = new System.Drawing.Size(355, 211); this.layoutControlParamter.TabIndex = 1; this.layoutControlParamter.Text = "layoutControl2"; // // layoutControlGroup2 // this.layoutControlGroup2.CustomizationFormText = "Root"; this.layoutControlGroup2.EnableIndentsWithoutBorders = DevExpress.Utils.DefaultBoolean.True; this.layoutControlGroup2.GroupBordersVisible = false; this.layoutControlGroup2.Items.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] { this.layoutControlGroupParamters}); this.layoutControlGroup2.Location = new System.Drawing.Point(0, 0); this.layoutControlGroup2.Name = "Root"; this.layoutControlGroup2.Size = new System.Drawing.Size(355, 211); this.layoutControlGroup2.TextVisible = false; // // layoutControlGroupParamters // this.layoutControlGroupParamters.CustomizationFormText = "Paramters"; this.layoutControlGroupParamters.Location = new System.Drawing.Point(0, 0); this.layoutControlGroupParamters.Name = "layoutControlGroupParamters"; this.layoutControlGroupParamters.Size = new System.Drawing.Size(335, 191); this.layoutControlGroupParamters.Text = "Paramters"; // // layoutControlDatasource // this.layoutControlDatasource.Controls.Add(this.btnDeleteLayout); this.layoutControlDatasource.Controls.Add(this.btnSaveAsLayout); this.layoutControlDatasource.Controls.Add(this.btnLoadLayout); this.layoutControlDatasource.Controls.Add(this.btnSaveLayout); this.layoutControlDatasource.Controls.Add(this.lueLayout); this.layoutControlDatasource.Controls.Add(this.ppWait); this.layoutControlDatasource.Controls.Add(this.btnLoadDashboard); this.layoutControlDatasource.Dock = System.Windows.Forms.DockStyle.Top; this.layoutControlDatasource.Location = new System.Drawing.Point(0, 0); this.layoutControlDatasource.Name = "layoutControlDatasource"; this.layoutControlDatasource.OptionsCustomizationForm.DesignTimeCustomizationFormPositionAndSize = new System.Drawing.Rectangle(569, 119, 328, 452); this.layoutControlDatasource.Root = this.layoutControlGroupDatasource; this.layoutControlDatasource.Size = new System.Drawing.Size(355, 157); this.layoutControlDatasource.TabIndex = 0; this.layoutControlDatasource.Text = "layoutControl1"; // // btnDeleteLayout // this.btnDeleteLayout.Image = global::NICSQLTools.Properties.Resources.delete_16x16; this.btnDeleteLayout.Location = new System.Drawing.Point(262, 123); this.btnDeleteLayout.Name = "btnDeleteLayout"; this.btnDeleteLayout.Size = new System.Drawing.Size(81, 22); this.btnDeleteLayout.StyleController = this.layoutControlDatasource; this.btnDeleteLayout.TabIndex = 8; this.btnDeleteLayout.Text = "Delete"; this.btnDeleteLayout.Click += new System.EventHandler(this.btnDeleteLayout_Click); // // btnSaveAsLayout // this.btnSaveAsLayout.Image = global::NICSQLTools.Properties.Resources.saveall_16x16; this.btnSaveAsLayout.Location = new System.Drawing.Point(96, 123); this.btnSaveAsLayout.Name = "btnSaveAsLayout"; this.btnSaveAsLayout.Size = new System.Drawing.Size(89, 22); this.btnSaveAsLayout.StyleController = this.layoutControlDatasource; this.btnSaveAsLayout.TabIndex = 7; this.btnSaveAsLayout.Text = "Save As"; this.btnSaveAsLayout.Click += new System.EventHandler(this.btnSaveAsLayout_Click); // // btnLoadLayout // this.btnLoadLayout.Image = global::NICSQLTools.Properties.Resources.loadfrom_16x16; this.btnLoadLayout.Location = new System.Drawing.Point(189, 123); this.btnLoadLayout.Name = "btnLoadLayout"; this.btnLoadLayout.Size = new System.Drawing.Size(69, 22); this.btnLoadLayout.StyleController = this.layoutControlDatasource; this.btnLoadLayout.TabIndex = 6; this.btnLoadLayout.Text = "Load"; this.btnLoadLayout.Click += new System.EventHandler(this.btnLoadLayout_Click); // // btnSaveLayout // this.btnSaveLayout.Image = global::NICSQLTools.Properties.Resources.save_16x16; this.btnSaveLayout.Location = new System.Drawing.Point(12, 123); this.btnSaveLayout.Name = "btnSaveLayout"; this.btnSaveLayout.Size = new System.Drawing.Size(80, 22); this.btnSaveLayout.StyleController = this.layoutControlDatasource; this.btnSaveLayout.TabIndex = 5; this.btnSaveLayout.Text = "Save"; this.btnSaveLayout.Click += new System.EventHandler(this.btnSaveLayout_Click); // // lueLayout // this.lueLayout.EditValue = ""; this.lueLayout.Location = new System.Drawing.Point(48, 97); this.lueLayout.Name = "lueLayout"; this.lueLayout.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup; this.lueLayout.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] { new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo), new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Glyph, "", -1, true, true, false, DevExpress.XtraEditors.ImageLocation.MiddleCenter, global::NICSQLTools.Properties.Resources.refresh_16x16, new DevExpress.Utils.KeyShortcut(System.Windows.Forms.Keys.None), serializableAppearanceObject1, "", null, null, true)}); this.lueLayout.Properties.DataSource = this.LSMSLayout; this.lueLayout.Properties.DisplayMember = "DatasourceLayoutName"; this.lueLayout.Properties.NullText = ""; this.lueLayout.Properties.PopupFilterMode = DevExpress.XtraEditors.PopupFilterMode.StartsWith; this.lueLayout.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard; this.lueLayout.Properties.ValueMember = "DatasourceLayoutId"; this.lueLayout.Properties.View = this.gridView2; this.lueLayout.Properties.ButtonClick += new DevExpress.XtraEditors.Controls.ButtonPressedEventHandler(this.lueLayout_Properties_ButtonClick); this.lueLayout.Size = new System.Drawing.Size(295, 22); this.lueLayout.StyleController = this.layoutControlDatasource; this.lueLayout.TabIndex = 4; // // LSMSLayout // this.LSMSLayout.ElementType = typeof(NICSQLTools.Data.Linq.vAppDatasourceLayout_LUE); this.LSMSLayout.KeyExpression = "[DatasourceLayoutId]"; // // gridView2 // this.gridView2.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] { this.colDatasourceLayoutName, this.gridColumn4, this.gridColumn5, this.gridColumn3}); this.gridView2.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFocus; this.gridView2.Name = "gridView2"; this.gridView2.OptionsSelection.EnableAppearanceFocusedCell = false; this.gridView2.OptionsView.AnimationType = DevExpress.XtraGrid.Views.Base.GridAnimationType.AnimateAllContent; this.gridView2.OptionsView.ColumnAutoWidth = false; this.gridView2.OptionsView.EnableAppearanceEvenRow = true; this.gridView2.OptionsView.EnableAppearanceOddRow = true; this.gridView2.OptionsView.ShowAutoFilterRow = true; this.gridView2.OptionsView.ShowGroupPanel = false; this.gridView2.OptionsView.ShowIndicator = false; this.gridView2.OptionsView.WaitAnimationOptions = DevExpress.XtraEditors.WaitAnimationOptions.Panel; // // colDatasourceLayoutName // this.colDatasourceLayoutName.Caption = "Dashboard Schema Name"; this.colDatasourceLayoutName.FieldName = "DatasourceLayoutName"; this.colDatasourceLayoutName.Name = "colDatasourceLayoutName"; this.colDatasourceLayoutName.Visible = true; this.colDatasourceLayoutName.VisibleIndex = 0; this.colDatasourceLayoutName.Width = 132; // // gridColumn4 // this.gridColumn4.Caption = "Last Edit"; this.gridColumn4.ColumnEdit = this.repositoryItemDateEdit1; this.gridColumn4.FieldName = "DateIn"; this.gridColumn4.Name = "gridColumn4"; this.gridColumn4.Visible = true; this.gridColumn4.VisibleIndex = 1; // // gridColumn5 // this.gridColumn5.Caption = "Edit User"; this.gridColumn5.FieldName = "RealName"; this.gridColumn5.Name = "gridColumn5"; this.gridColumn5.Visible = true; this.gridColumn5.VisibleIndex = 2; // // gridColumn3 // this.gridColumn3.Caption = "Data Source"; this.gridColumn3.FieldName = "DatasourceName"; this.gridColumn3.Name = "gridColumn3"; this.gridColumn3.Visible = true; this.gridColumn3.VisibleIndex = 3; // // ppWait // this.ppWait.Appearance.BackColor = System.Drawing.Color.Transparent; this.ppWait.Appearance.Options.UseBackColor = true; this.ppWait.AppearanceCaption.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F); this.ppWait.AppearanceCaption.Options.UseFont = true; this.ppWait.AppearanceDescription.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F); this.ppWait.AppearanceDescription.Options.UseFont = true; this.ppWait.Location = new System.Drawing.Point(12, 12); this.ppWait.Name = "ppWait"; this.ppWait.Size = new System.Drawing.Size(331, 46); this.ppWait.StyleController = this.layoutControlDatasource; this.ppWait.TabIndex = 2; this.ppWait.Text = "Loading ..."; // // btnLoadDashboard // this.btnLoadDashboard.Image = global::NICSQLTools.Properties.Resources.technology_32x32; this.btnLoadDashboard.Location = new System.Drawing.Point(12, 62); this.btnLoadDashboard.Name = "btnLoadDashboard"; this.btnLoadDashboard.Size = new System.Drawing.Size(331, 31); this.btnLoadDashboard.StyleController = this.layoutControlDatasource; this.btnLoadDashboard.TabIndex = 1; this.btnLoadDashboard.Text = "Load Datasource"; this.btnLoadDashboard.Click += new System.EventHandler(this.btnLoadDatasource_Click); // // layoutControlGroupDatasource // this.layoutControlGroupDatasource.CustomizationFormText = "layoutControlGroup Datasource"; this.layoutControlGroupDatasource.EnableIndentsWithoutBorders = DevExpress.Utils.DefaultBoolean.True; this.layoutControlGroupDatasource.GroupBordersVisible = false; this.layoutControlGroupDatasource.Items.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] { this.layoutControlItem2, this.layoutControlItemLoadLayout, this.layoutControlItemSave, this.lciWait, this.layoutControlItemSaveAs, this.layoutControlItemDelete, this.layoutControlItemLoad}); this.layoutControlGroupDatasource.Location = new System.Drawing.Point(0, 0); this.layoutControlGroupDatasource.Name = "Root"; this.layoutControlGroupDatasource.Size = new System.Drawing.Size(355, 157); this.layoutControlGroupDatasource.Text = "Datasource"; this.layoutControlGroupDatasource.TextVisible = false; // // layoutControlItem2 // this.layoutControlItem2.Control = this.btnLoadDashboard; this.layoutControlItem2.CustomizationFormText = "btnLoad"; this.layoutControlItem2.Location = new System.Drawing.Point(0, 50); this.layoutControlItem2.MaxSize = new System.Drawing.Size(0, 35); this.layoutControlItem2.MinSize = new System.Drawing.Size(128, 30); this.layoutControlItem2.Name = "layoutControlItem2"; this.layoutControlItem2.Size = new System.Drawing.Size(335, 35); this.layoutControlItem2.SizeConstraintsType = DevExpress.XtraLayout.SizeConstraintsType.Custom; this.layoutControlItem2.TextSize = new System.Drawing.Size(0, 0); this.layoutControlItem2.TextVisible = false; // // layoutControlItemLoadLayout // this.layoutControlItemLoadLayout.Control = this.lueLayout; this.layoutControlItemLoadLayout.CustomizationFormText = "Layout"; this.layoutControlItemLoadLayout.Location = new System.Drawing.Point(0, 85); this.layoutControlItemLoadLayout.Name = "layoutControlItemLoadLayout"; this.layoutControlItemLoadLayout.Size = new System.Drawing.Size(335, 26); this.layoutControlItemLoadLayout.Text = "Layout"; this.layoutControlItemLoadLayout.TextSize = new System.Drawing.Size(33, 13); // // layoutControlItemSave // this.layoutControlItemSave.Control = this.btnSaveLayout; this.layoutControlItemSave.CustomizationFormText = "Save"; this.layoutControlItemSave.Location = new System.Drawing.Point(0, 111); this.layoutControlItemSave.Name = "layoutControlItemSave"; this.layoutControlItemSave.Size = new System.Drawing.Size(84, 26); this.layoutControlItemSave.TextSize = new System.Drawing.Size(0, 0); this.layoutControlItemSave.TextVisible = false; // // lciWait // this.lciWait.Control = this.ppWait; this.lciWait.CustomizationFormText = "lciWait"; this.lciWait.Location = new System.Drawing.Point(0, 0); this.lciWait.MaxSize = new System.Drawing.Size(0, 50); this.lciWait.MinSize = new System.Drawing.Size(54, 50); this.lciWait.Name = "lciWait"; this.lciWait.Size = new System.Drawing.Size(335, 50); this.lciWait.SizeConstraintsType = DevExpress.XtraLayout.SizeConstraintsType.Custom; this.lciWait.TextSize = new System.Drawing.Size(0, 0); this.lciWait.TextVisible = false; this.lciWait.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never; // // layoutControlItemSaveAs // this.layoutControlItemSaveAs.Control = this.btnSaveAsLayout; this.layoutControlItemSaveAs.CustomizationFormText = "Save As"; this.layoutControlItemSaveAs.Location = new System.Drawing.Point(84, 111); this.layoutControlItemSaveAs.Name = "layoutControlItemSaveAs"; this.layoutControlItemSaveAs.Size = new System.Drawing.Size(93, 26); this.layoutControlItemSaveAs.TextSize = new System.Drawing.Size(0, 0); this.layoutControlItemSaveAs.TextVisible = false; // // layoutControlItemDelete // this.layoutControlItemDelete.Control = this.btnDeleteLayout; this.layoutControlItemDelete.CustomizationFormText = "Delete"; this.layoutControlItemDelete.Location = new System.Drawing.Point(250, 111); this.layoutControlItemDelete.Name = "layoutControlItemDelete"; this.layoutControlItemDelete.Size = new System.Drawing.Size(85, 26); this.layoutControlItemDelete.TextSize = new System.Drawing.Size(0, 0); this.layoutControlItemDelete.TextVisible = false; // // layoutControlItemLoad // this.layoutControlItemLoad.Control = this.btnLoadLayout; this.layoutControlItemLoad.CustomizationFormText = "Load"; this.layoutControlItemLoad.Location = new System.Drawing.Point(177, 111); this.layoutControlItemLoad.Name = "layoutControlItemLoad"; this.layoutControlItemLoad.Size = new System.Drawing.Size(73, 26); this.layoutControlItemLoad.TextSize = new System.Drawing.Size(0, 0); this.layoutControlItemLoad.TextVisible = false; // // dockPanelProperties // this.dockPanelProperties.Controls.Add(this.dockPanel1_Container); this.dockPanelProperties.Dock = DevExpress.XtraBars.Docking.DockingStyle.Fill; this.dockPanelProperties.ID = new System.Guid("634f77b0-9bd0-4566-89ca-9c7d09a3bde3"); this.dockPanelProperties.Image = global::NICSQLTools.Properties.Resources.pagesetup_32x32; this.dockPanelProperties.Location = new System.Drawing.Point(4, 23); this.dockPanelProperties.Name = "dockPanelProperties"; this.dockPanelProperties.Options.ShowCloseButton = false; this.dockPanelProperties.OriginalSize = new System.Drawing.Size(350, 368); this.dockPanelProperties.Size = new System.Drawing.Size(355, 368); this.dockPanelProperties.Text = "Properties"; // // dockPanel1_Container // this.dockPanel1_Container.Controls.Add(this.layoutControl1); this.dockPanel1_Container.Location = new System.Drawing.Point(0, 0); this.dockPanel1_Container.Name = "dockPanel1_Container"; this.dockPanel1_Container.Size = new System.Drawing.Size(355, 368); this.dockPanel1_Container.TabIndex = 0; // // layoutControl1 // this.layoutControl1.Controls.Add(this.pgcProperties); this.layoutControl1.Dock = System.Windows.Forms.DockStyle.Fill; this.layoutControl1.Location = new System.Drawing.Point(0, 0); this.layoutControl1.Name = "layoutControl1"; this.layoutControl1.OptionsCustomizationForm.DesignTimeCustomizationFormPositionAndSize = new System.Drawing.Rectangle(541, 139, 250, 350); this.layoutControl1.Root = this.layoutControlGroup3; this.layoutControl1.Size = new System.Drawing.Size(355, 368); this.layoutControl1.TabIndex = 1; this.layoutControl1.Text = "layoutControl1"; // // pgcProperties // this.pgcProperties.AutoGenerateRows = true; this.pgcProperties.Location = new System.Drawing.Point(12, 12); this.pgcProperties.Name = "pgcProperties"; this.pgcProperties.Size = new System.Drawing.Size(331, 344); this.pgcProperties.TabIndex = 0; // // layoutControlGroup3 // this.layoutControlGroup3.CustomizationFormText = "layoutControlGroup3"; this.layoutControlGroup3.EnableIndentsWithoutBorders = DevExpress.Utils.DefaultBoolean.True; this.layoutControlGroup3.GroupBordersVisible = false; this.layoutControlGroup3.Items.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] { this.layoutControlItemPropertiesControl}); this.layoutControlGroup3.Location = new System.Drawing.Point(0, 0); this.layoutControlGroup3.Name = "layoutControlGroup3"; this.layoutControlGroup3.Size = new System.Drawing.Size(355, 368); this.layoutControlGroup3.TextVisible = false; // // layoutControlItemPropertiesControl // this.layoutControlItemPropertiesControl.Control = this.pgcProperties; this.layoutControlItemPropertiesControl.CustomizationFormText = "Properties Control"; this.layoutControlItemPropertiesControl.Location = new System.Drawing.Point(0, 0); this.layoutControlItemPropertiesControl.Name = "layoutControlItemPropertiesControl"; this.layoutControlItemPropertiesControl.Size = new System.Drawing.Size(335, 348); this.layoutControlItemPropertiesControl.Text = "Properties Control"; this.layoutControlItemPropertiesControl.TextSize = new System.Drawing.Size(0, 0); this.layoutControlItemPropertiesControl.TextVisible = false; // // LSMSDatasource // this.LSMSDatasource.ElementType = typeof(NICSQLTools.Data.Linq.vAppDatasource_LUE); this.LSMSDatasource.KeyExpression = "[DatasourceID]"; // // pivotGridControlMain // this.pivotGridControlMain.Appearance.Cell.Font = new System.Drawing.Font("Tahoma", 10F); this.pivotGridControlMain.Appearance.Cell.Options.UseFont = true; this.pivotGridControlMain.Appearance.FieldHeader.Font = new System.Drawing.Font("Tahoma", 10F); this.pivotGridControlMain.Appearance.FieldHeader.Options.UseFont = true; this.pivotGridControlMain.Appearance.FieldValue.Font = new System.Drawing.Font("Tahoma", 10F); this.pivotGridControlMain.Appearance.FieldValue.Options.UseFont = true; this.pivotGridControlMain.Dock = System.Windows.Forms.DockStyle.Fill; pivotGridGroup1.Caption = "Sales District Level"; pivotGridGroup1.Hierarchy = "[Route].[Sales District Level]"; pivotGridGroup1.ShowNewValues = true; this.pivotGridControlMain.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] { pivotGridGroup1}); this.pivotGridControlMain.Location = new System.Drawing.Point(363, 24); this.pivotGridControlMain.Name = "pivotGridControlMain"; this.pivotGridControlMain.OLAPConnectionString = ""; this.pivotGridControlMain.OLAPDataProvider = DevExpress.XtraPivotGrid.OLAPDataProvider.OleDb; this.pivotGridControlMain.OptionsData.DataFieldUnboundExpressionMode = DevExpress.XtraPivotGrid.DataFieldUnboundExpressionMode.UseSummaryValues; this.pivotGridControlMain.OptionsLayout.AddNewGroups = true; this.pivotGridControlMain.OptionsLayout.Columns.RemoveOldColumns = false; this.pivotGridControlMain.OptionsLayout.Columns.StoreAllOptions = true; this.pivotGridControlMain.OptionsLayout.Columns.StoreAppearance = true; this.pivotGridControlMain.OptionsLayout.StoreAllOptions = true; this.pivotGridControlMain.OptionsLayout.StoreAppearance = true; this.pivotGridControlMain.OptionsLayout.StoreLayoutOptions = true; this.pivotGridControlMain.Size = new System.Drawing.Size(394, 439); this.pivotGridControlMain.TabIndex = 2; this.pivotGridControlMain.PopupMenuShowing += new DevExpress.XtraPivotGrid.PopupMenuShowingEventHandler(this.pivotGridControlMain_PopupMenuShowing); // // get_sp_PramTableAdapter // this.get_sp_PramTableAdapter.ClearBeforeFill = true; // // appDatasourceLayoutTableAdapter // this.appDatasourceLayoutTableAdapter.ClearBeforeFill = true; // // appDashboardDSTableAdapter // this.appDashboardDSTableAdapter.ClearBeforeFill = true; // // appDashboardDSPramTableAdapter // this.appDashboardDSPramTableAdapter.ClearBeforeFill = true; // // sfd // this.sfd.Filter = "excel workbook (*.xlsx)|*.xlsx"; this.sfd.Title = "export to excel file (xlsx)"; // // QryPivotUC // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.Controls.Add(this.pivotGridControlMain); this.Controls.Add(this.panelContainerMain); this.Controls.Add(this.barDockControlLeft); this.Controls.Add(this.barDockControlRight); this.Controls.Add(this.barDockControlBottom); this.Controls.Add(this.barDockControlTop); this.Name = "QryPivotUC"; this.Size = new System.Drawing.Size(757, 486); this.Load += new System.EventHandler(this.QryPivotUC_Load); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1.CalendarTimeProperties)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dockManagerMain)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.barManager1)).EndInit(); this.panelContainerMain.ResumeLayout(false); this.dockPanelDashboard.ResumeLayout(false); this.dockPanel2_Container.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.layoutControlParamter)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.layoutControlGroupParamters)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.layoutControlDatasource)).EndInit(); this.layoutControlDatasource.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.lueLayout.Properties)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.LSMSLayout)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.gridView2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.layoutControlGroupDatasource)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.layoutControlItemLoadLayout)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.layoutControlItemSave)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.lciWait)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.layoutControlItemSaveAs)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.layoutControlItemDelete)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.layoutControlItemLoad)).EndInit(); this.dockPanelProperties.ResumeLayout(false); this.dockPanel1_Container.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.layoutControl1)).EndInit(); this.layoutControl1.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.pgcProperties)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.layoutControlItemPropertiesControl)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.LSMSDatasource)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControlMain)).EndInit(); this.ResumeLayout(false); this.PerformLayout(); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1)); DevExpress.DataAccess.Excel.FieldInfo fieldInfo1 = new DevExpress.DataAccess.Excel.FieldInfo(); DevExpress.DataAccess.Excel.FieldInfo fieldInfo2 = new DevExpress.DataAccess.Excel.FieldInfo(); DevExpress.DataAccess.Excel.FieldInfo fieldInfo3 = new DevExpress.DataAccess.Excel.FieldInfo(); DevExpress.DataAccess.Excel.FieldInfo fieldInfo4 = new DevExpress.DataAccess.Excel.FieldInfo(); DevExpress.DataAccess.Excel.FieldInfo fieldInfo5 = new DevExpress.DataAccess.Excel.FieldInfo(); DevExpress.DataAccess.Excel.FieldInfo fieldInfo6 = new DevExpress.DataAccess.Excel.FieldInfo(); DevExpress.DataAccess.Excel.FieldInfo fieldInfo7 = new DevExpress.DataAccess.Excel.FieldInfo(); DevExpress.DataAccess.Excel.FieldInfo fieldInfo8 = new DevExpress.DataAccess.Excel.FieldInfo(); DevExpress.DataAccess.Excel.FieldInfo fieldInfo9 = new DevExpress.DataAccess.Excel.FieldInfo(); DevExpress.DataAccess.Excel.FieldInfo fieldInfo10 = new DevExpress.DataAccess.Excel.FieldInfo(); DevExpress.DataAccess.Excel.FieldInfo fieldInfo11 = new DevExpress.DataAccess.Excel.FieldInfo(); DevExpress.DataAccess.Excel.FieldInfo fieldInfo12 = new DevExpress.DataAccess.Excel.FieldInfo(); DevExpress.DataAccess.Excel.ExcelWorksheetSettings excelWorksheetSettings1 = new DevExpress.DataAccess.Excel.ExcelWorksheetSettings(); DevExpress.DataAccess.Excel.ExcelSourceOptions excelSourceOptions1 = new DevExpress.DataAccess.Excel.ExcelSourceOptions(excelWorksheetSettings1); this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl(); this.excelDataSource1 = new DevExpress.DataAccess.Excel.ExcelDataSource(); this.btnSave = new DevExpress.XtraEditors.SimpleButton(); this.btnLoad = new DevExpress.XtraEditors.SimpleButton(); this.fieldFirstName1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.btnClear = new DevExpress.XtraEditors.SimpleButton(); this.fieldCategoryName1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldProductName1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldSalesPerson1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldExtendedPrice1 = new DevExpress.XtraPivotGrid.PivotGridField(); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit(); this.SuspendLayout(); // // pivotGridControl1 // this.pivotGridControl1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.pivotGridControl1.DataSource = this.excelDataSource1; this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] { this.fieldCategoryName1, this.fieldProductName1, this.fieldSalesPerson1, this.fieldExtendedPrice1 }); this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] { pivotGridGroup1 }); this.pivotGridControl1.Location = new System.Drawing.Point(12, 41); this.pivotGridControl1.Name = "pivotGridControl1"; this.pivotGridControl1.Size = new System.Drawing.Size(727, 416); this.pivotGridControl1.TabIndex = 0; // // excelDataSource1 // this.excelDataSource1.Name = "excelDataSource1"; this.excelDataSource1.ResultSchemaSerializable = resources.GetString("excelDataSource1.ResultSchemaSerializable"); fieldInfo1.Name = "CategoryName"; fieldInfo1.Type = typeof(string); fieldInfo2.Name = "Country"; fieldInfo2.Type = typeof(string); fieldInfo3.Name = "FirstName"; fieldInfo3.Type = typeof(string); fieldInfo4.Name = "LastName"; fieldInfo4.Type = typeof(string); fieldInfo5.Name = "ProductName"; fieldInfo5.Type = typeof(string); fieldInfo6.Name = "Sales Person"; fieldInfo6.Type = typeof(string); fieldInfo7.Name = "OrderDate"; fieldInfo7.Type = typeof(System.DateTime); fieldInfo8.Name = "OrderID"; fieldInfo8.Type = typeof(double); fieldInfo9.Name = "Quantity"; fieldInfo9.Type = typeof(double); fieldInfo10.Name = "Discount"; fieldInfo10.Type = typeof(double); fieldInfo11.Name = "Extended Price"; fieldInfo11.Type = typeof(double); fieldInfo12.Name = "UnitPrice"; fieldInfo12.Type = typeof(double); this.excelDataSource1.Schema.AddRange(new DevExpress.DataAccess.Excel.FieldInfo[] { fieldInfo1, fieldInfo2, fieldInfo3, fieldInfo4, fieldInfo5, fieldInfo6, fieldInfo7, fieldInfo8, fieldInfo9, fieldInfo10, fieldInfo11, fieldInfo12 }); excelWorksheetSettings1.CellRange = null; excelWorksheetSettings1.WorksheetName = "Data"; excelSourceOptions1.ImportSettings = excelWorksheetSettings1; this.excelDataSource1.SourceOptions = excelSourceOptions1; // // btnSave // this.btnSave.Location = new System.Drawing.Point(13, 12); this.btnSave.Name = "btnSave"; this.btnSave.Size = new System.Drawing.Size(75, 23); this.btnSave.TabIndex = 1; this.btnSave.Text = "Save"; this.btnSave.Click += new System.EventHandler(this.btnSave_Click); // // btnLoad // this.btnLoad.Location = new System.Drawing.Point(94, 12); this.btnLoad.Name = "btnLoad"; this.btnLoad.Size = new System.Drawing.Size(75, 23); this.btnLoad.TabIndex = 2; this.btnLoad.Text = "Load"; this.btnLoad.Click += new System.EventHandler(this.btnLoad_Click); // // fieldFirstName1 // this.fieldFirstName1.AreaIndex = 0; this.fieldFirstName1.Caption = "First Name"; this.fieldFirstName1.FieldName = "FirstName"; this.fieldFirstName1.Name = "fieldFirstName1"; // // btnClear // this.btnClear.Location = new System.Drawing.Point(175, 12); this.btnClear.Name = "btnClear"; this.btnClear.Size = new System.Drawing.Size(75, 23); this.btnClear.TabIndex = 3; this.btnClear.Text = "Clear"; this.btnClear.Click += new System.EventHandler(this.btnClear_Click); // // fieldCategoryName1 // this.fieldCategoryName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldCategoryName1.AreaIndex = 0; this.fieldCategoryName1.Caption = "Category Name"; this.fieldCategoryName1.FieldName = "CategoryName"; this.fieldCategoryName1.Name = "fieldCategoryName1"; // // fieldProductName1 // this.fieldProductName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldProductName1.AreaIndex = 1; this.fieldProductName1.Caption = "Product Name"; this.fieldProductName1.FieldName = "ProductName"; this.fieldProductName1.Name = "fieldProductName1"; // // fieldSalesPerson1 // this.fieldSalesPerson1.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldSalesPerson1.AreaIndex = 0; this.fieldSalesPerson1.Caption = "Sales Person"; this.fieldSalesPerson1.FieldName = "Sales Person"; this.fieldSalesPerson1.Name = "fieldSalesPerson1"; // // fieldExtendedPrice1 // this.fieldExtendedPrice1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldExtendedPrice1.AreaIndex = 0; this.fieldExtendedPrice1.Caption = "Extended Price"; this.fieldExtendedPrice1.FieldName = "Extended Price"; this.fieldExtendedPrice1.Name = "fieldExtendedPrice1"; // // Form1 // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(751, 469); this.Controls.Add(this.btnClear); this.Controls.Add(this.btnLoad); this.Controls.Add(this.btnSave); this.Controls.Add(this.pivotGridControl1); this.Name = "Form1"; this.Text = "RestoreLayoutExample"; this.Load += new System.EventHandler(this.Form1_Load); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit(); this.ResumeLayout(false); }
/// <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.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup(); DevExpress.XtraPivotGrid.DataSourceColumnBinding dataSourceColumnBinding1 = new DevExpress.XtraPivotGrid.DataSourceColumnBinding(); DevExpress.XtraPivotGrid.DataSourceColumnBinding dataSourceColumnBinding2 = new DevExpress.XtraPivotGrid.DataSourceColumnBinding(); DevExpress.XtraPivotGrid.DataSourceColumnBinding dataSourceColumnBinding3 = new DevExpress.XtraPivotGrid.DataSourceColumnBinding(); DevExpress.XtraPivotGrid.DataSourceColumnBinding dataSourceColumnBinding4 = new DevExpress.XtraPivotGrid.DataSourceColumnBinding(); DevExpress.XtraPivotGrid.DataSourceColumnBinding dataSourceColumnBinding5 = new DevExpress.XtraPivotGrid.DataSourceColumnBinding(); DevExpress.XtraPivotGrid.DataSourceColumnBinding dataSourceColumnBinding6 = new DevExpress.XtraPivotGrid.DataSourceColumnBinding(); DevExpress.XtraPivotGrid.DataSourceColumnBinding dataSourceColumnBinding7 = new DevExpress.XtraPivotGrid.DataSourceColumnBinding(); DevExpress.XtraPivotGrid.DataSourceColumnBinding dataSourceColumnBinding8 = new DevExpress.XtraPivotGrid.DataSourceColumnBinding(); DevExpress.XtraPivotGrid.DataSourceColumnBinding dataSourceColumnBinding9 = new DevExpress.XtraPivotGrid.DataSourceColumnBinding(); DevExpress.XtraPivotGrid.DataSourceColumnBinding dataSourceColumnBinding10 = new DevExpress.XtraPivotGrid.DataSourceColumnBinding(); DevExpress.XtraPivotGrid.DataSourceColumnBinding dataSourceColumnBinding11 = new DevExpress.XtraPivotGrid.DataSourceColumnBinding(); DevExpress.XtraPivotGrid.DataSourceColumnBinding dataSourceColumnBinding12 = new DevExpress.XtraPivotGrid.DataSourceColumnBinding(); DevExpress.XtraPivotGrid.DataSourceColumnBinding dataSourceColumnBinding13 = new DevExpress.XtraPivotGrid.DataSourceColumnBinding(); DevExpress.XtraPivotGrid.DataSourceColumnBinding dataSourceColumnBinding14 = new DevExpress.XtraPivotGrid.DataSourceColumnBinding(); this.roomBookingCollection = new DevExpress.Xpo.XPCollection(this.components); this.session = new DevExpress.Xpo.Session(this.components); this.splitContainerControl1 = new DevExpress.XtraEditors.SplitContainerControl(); this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl(); this.fieldCapacityRequirementName1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCapacityRequirementCapacity1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCapacityRequirementRoomSetup1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCapacityRequirementEventName1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCapacityRequirementEventStartDate1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCapacityRequirementEventEndDate1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCapacityRequirementEventVenueName1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCapacityRequirementEventCustomerName1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldRoomName2 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldStartTime3 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldEndTime3 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCapacityRequirementCapacity2 = new DevExpress.XtraPivotGrid.PivotGridField(); this.pivotGridField1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.pivotGridField2 = new DevExpress.XtraPivotGrid.PivotGridField(); this.ribbonControl1 = new DevExpress.XtraBars.Ribbon.RibbonControl(); this.printExportItem = new DevExpress.XtraBars.BarButtonItem(); this.ribbonPageCategory1 = new DevExpress.XtraBars.Ribbon.RibbonPageCategory(); this.ribbonPage1 = new DevExpress.XtraBars.Ribbon.RibbonPage(); this.ribbonPageGroup1 = new DevExpress.XtraBars.Ribbon.RibbonPageGroup(); ((System.ComponentModel.ISupportInitialize)(this.roomBookingCollection)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.session)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.splitContainerControl1)).BeginInit(); this.splitContainerControl1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.ribbonControl1)).BeginInit(); this.SuspendLayout(); // // roomBookingCollection // this.roomBookingCollection.ObjectType = typeof(EventsDB.RoomBooking); this.roomBookingCollection.Session = this.session; // // splitContainerControl1 // this.splitContainerControl1.Dock = System.Windows.Forms.DockStyle.Fill; this.splitContainerControl1.FixedPanel = DevExpress.XtraEditors.SplitFixedPanel.Panel2; this.splitContainerControl1.Horizontal = false; this.splitContainerControl1.Location = new System.Drawing.Point(0, 150); this.splitContainerControl1.Name = "splitContainerControl1"; this.splitContainerControl1.Panel1.Controls.Add(this.pivotGridControl1); this.splitContainerControl1.Panel1.Text = "Panel1"; this.splitContainerControl1.Panel2.Text = "Panel2"; this.splitContainerControl1.Size = new System.Drawing.Size(1000, 550); this.splitContainerControl1.SplitterPosition = 156; this.splitContainerControl1.TabIndex = 1; this.splitContainerControl1.Text = "splitContainerControl1"; // // pivotGridControl1 // this.pivotGridControl1.DataSource = this.roomBookingCollection; this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill; this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] { this.fieldCapacityRequirementName1, this.fieldCapacityRequirementCapacity1, this.fieldCapacityRequirementRoomSetup1, this.fieldCapacityRequirementEventName1, this.fieldCapacityRequirementEventStartDate1, this.fieldCapacityRequirementEventEndDate1, this.fieldCapacityRequirementEventVenueName1, this.fieldCapacityRequirementEventCustomerName1, this.fieldRoomName2, this.fieldStartTime3, this.fieldEndTime3, this.fieldCapacityRequirementCapacity2, this.pivotGridField1, this.pivotGridField2 }); pivotGridGroup1.Caption = "Event Start"; pivotGridGroup1.Fields.Add(this.pivotGridField2); pivotGridGroup1.Fields.Add(this.pivotGridField1); this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] { pivotGridGroup1 }); this.pivotGridControl1.Location = new System.Drawing.Point(0, 0); this.pivotGridControl1.MenuManager = this.ribbonControl1; this.pivotGridControl1.Name = "pivotGridControl1"; this.pivotGridControl1.OptionsCustomization.CustomizationFormStyle = DevExpress.XtraPivotGrid.Customization.CustomizationFormStyle.Excel2007; this.pivotGridControl1.OptionsData.DataProcessingEngine = DevExpress.XtraPivotGrid.PivotDataProcessingEngine.Optimized; this.pivotGridControl1.OptionsData.RetrieveNestedFields = DevExpress.Utils.DefaultBoolean.True; this.pivotGridControl1.OptionsMenu.ShowDateTimeGroupIntervalItems = DevExpress.XtraPivotGrid.DateTimeGroupIntervals.ExtendedIntervals; this.pivotGridControl1.Size = new System.Drawing.Size(1000, 384); this.pivotGridControl1.TabIndex = 0; // // fieldCapacityRequirementName1 // this.fieldCapacityRequirementName1.AreaIndex = 3; this.fieldCapacityRequirementName1.Caption = "CapReq"; dataSourceColumnBinding1.ColumnName = "CapacityRequirement.Name"; this.fieldCapacityRequirementName1.DataBinding = dataSourceColumnBinding1; this.fieldCapacityRequirementName1.DisplayFolder = "CapacityRequirement"; this.fieldCapacityRequirementName1.FieldName = "CapacityRequirement.Name"; this.fieldCapacityRequirementName1.Name = "fieldCapacityRequirementName1"; this.fieldCapacityRequirementName1.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Count; // // fieldCapacityRequirementCapacity1 // this.fieldCapacityRequirementCapacity1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldCapacityRequirementCapacity1.AreaIndex = 1; this.fieldCapacityRequirementCapacity1.Caption = "Capacity"; this.fieldCapacityRequirementCapacity1.CellFormat.FormatString = "n2"; this.fieldCapacityRequirementCapacity1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; dataSourceColumnBinding2.ColumnName = "CapacityRequirement.Capacity"; this.fieldCapacityRequirementCapacity1.DataBinding = dataSourceColumnBinding2; this.fieldCapacityRequirementCapacity1.DisplayFolder = "CapacityRequirement"; this.fieldCapacityRequirementCapacity1.FieldName = "CapacityRequirement.Capacity"; this.fieldCapacityRequirementCapacity1.Name = "fieldCapacityRequirementCapacity1"; this.fieldCapacityRequirementCapacity1.Options.AllowRunTimeSummaryChange = true; this.fieldCapacityRequirementCapacity1.Options.ShowSummaryTypeName = true; // // fieldCapacityRequirementRoomSetup1 // this.fieldCapacityRequirementRoomSetup1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldCapacityRequirementRoomSetup1.AreaIndex = 1; this.fieldCapacityRequirementRoomSetup1.Caption = "Room Setup"; dataSourceColumnBinding3.ColumnName = "CapacityRequirement.RoomSetup"; this.fieldCapacityRequirementRoomSetup1.DataBinding = dataSourceColumnBinding3; this.fieldCapacityRequirementRoomSetup1.DisplayFolder = "CapacityRequirement"; this.fieldCapacityRequirementRoomSetup1.FieldName = "CapacityRequirement.RoomSetup"; this.fieldCapacityRequirementRoomSetup1.Name = "fieldCapacityRequirementRoomSetup1"; this.fieldCapacityRequirementRoomSetup1.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Count; // // fieldCapacityRequirementEventName1 // this.fieldCapacityRequirementEventName1.AreaIndex = 2; this.fieldCapacityRequirementEventName1.Caption = "Event"; dataSourceColumnBinding4.ColumnName = "CapacityRequirement.Event.Name"; this.fieldCapacityRequirementEventName1.DataBinding = dataSourceColumnBinding4; this.fieldCapacityRequirementEventName1.DisplayFolder = "CapacityRequirement\\Event"; this.fieldCapacityRequirementEventName1.FieldName = "CapacityRequirement.Event.Name"; this.fieldCapacityRequirementEventName1.Name = "fieldCapacityRequirementEventName1"; this.fieldCapacityRequirementEventName1.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Count; // // fieldCapacityRequirementEventStartDate1 // this.fieldCapacityRequirementEventStartDate1.AreaIndex = 4; this.fieldCapacityRequirementEventStartDate1.Caption = "Event Start"; dataSourceColumnBinding5.ColumnName = "CapacityRequirement.Event.StartDate"; this.fieldCapacityRequirementEventStartDate1.DataBinding = dataSourceColumnBinding5; this.fieldCapacityRequirementEventStartDate1.DisplayFolder = "CapacityRequirement\\Event"; this.fieldCapacityRequirementEventStartDate1.FieldName = "CapacityRequirement.Event.StartDate"; this.fieldCapacityRequirementEventStartDate1.Name = "fieldCapacityRequirementEventStartDate1"; this.fieldCapacityRequirementEventStartDate1.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Count; // // fieldCapacityRequirementEventEndDate1 // this.fieldCapacityRequirementEventEndDate1.AreaIndex = 5; this.fieldCapacityRequirementEventEndDate1.Caption = "Event End"; dataSourceColumnBinding6.ColumnName = "CapacityRequirement.Event.EndDate"; this.fieldCapacityRequirementEventEndDate1.DataBinding = dataSourceColumnBinding6; this.fieldCapacityRequirementEventEndDate1.DisplayFolder = "CapacityRequirement\\Event"; this.fieldCapacityRequirementEventEndDate1.FieldName = "CapacityRequirement.Event.EndDate"; this.fieldCapacityRequirementEventEndDate1.Name = "fieldCapacityRequirementEventEndDate1"; this.fieldCapacityRequirementEventEndDate1.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Count; // // fieldCapacityRequirementEventVenueName1 // this.fieldCapacityRequirementEventVenueName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldCapacityRequirementEventVenueName1.AreaIndex = 0; this.fieldCapacityRequirementEventVenueName1.Caption = "Venue"; dataSourceColumnBinding7.ColumnName = "CapacityRequirement.Event.Venue.Name"; this.fieldCapacityRequirementEventVenueName1.DataBinding = dataSourceColumnBinding7; this.fieldCapacityRequirementEventVenueName1.DisplayFolder = "CapacityRequirement\\Event\\Venue"; this.fieldCapacityRequirementEventVenueName1.FieldName = "CapacityRequirement.Event.Venue.Name"; this.fieldCapacityRequirementEventVenueName1.Name = "fieldCapacityRequirementEventVenueName1"; this.fieldCapacityRequirementEventVenueName1.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Count; // // fieldCapacityRequirementEventCustomerName1 // this.fieldCapacityRequirementEventCustomerName1.AreaIndex = 6; this.fieldCapacityRequirementEventCustomerName1.Caption = "Customer"; dataSourceColumnBinding8.ColumnName = "CapacityRequirement.Event.Customer.Name"; this.fieldCapacityRequirementEventCustomerName1.DataBinding = dataSourceColumnBinding8; this.fieldCapacityRequirementEventCustomerName1.DisplayFolder = "CapacityRequirement\\Event\\Customer"; this.fieldCapacityRequirementEventCustomerName1.FieldName = "CapacityRequirement.Event.Customer.Name"; this.fieldCapacityRequirementEventCustomerName1.Name = "fieldCapacityRequirementEventCustomerName1"; this.fieldCapacityRequirementEventCustomerName1.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Count; // // fieldRoomName2 // this.fieldRoomName2.AreaIndex = 7; this.fieldRoomName2.Caption = "Room"; dataSourceColumnBinding9.ColumnName = "CapacityRequirement.RoomBooking.Room.Name"; this.fieldRoomName2.DataBinding = dataSourceColumnBinding9; this.fieldRoomName2.DisplayFolder = "Room"; this.fieldRoomName2.FieldName = "Room.Name"; this.fieldRoomName2.Name = "fieldRoomName2"; this.fieldRoomName2.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Count; // // fieldStartTime3 // this.fieldStartTime3.AreaIndex = 0; this.fieldStartTime3.Caption = "Room Booking Start Time"; dataSourceColumnBinding10.ColumnName = "StartTime"; this.fieldStartTime3.DataBinding = dataSourceColumnBinding10; this.fieldStartTime3.FieldName = "StartTime"; this.fieldStartTime3.Name = "fieldStartTime3"; this.fieldStartTime3.Options.AllowRunTimeSummaryChange = true; this.fieldStartTime3.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Count; // // fieldEndTime3 // this.fieldEndTime3.AreaIndex = 1; this.fieldEndTime3.Caption = "Room Booking End Time"; dataSourceColumnBinding11.ColumnName = "EndTime"; this.fieldEndTime3.DataBinding = dataSourceColumnBinding11; this.fieldEndTime3.FieldName = "EndTime"; this.fieldEndTime3.Name = "fieldEndTime3"; this.fieldEndTime3.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Count; // // fieldCapacityRequirementCapacity2 // this.fieldCapacityRequirementCapacity2.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldCapacityRequirementCapacity2.AreaIndex = 0; this.fieldCapacityRequirementCapacity2.Caption = "Capacity"; this.fieldCapacityRequirementCapacity2.CellFormat.FormatString = "n2"; this.fieldCapacityRequirementCapacity2.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; dataSourceColumnBinding12.ColumnName = "CapacityRequirement.Capacity"; this.fieldCapacityRequirementCapacity2.DataBinding = dataSourceColumnBinding12; this.fieldCapacityRequirementCapacity2.FieldName = "CapacityRequirement.Capacity"; this.fieldCapacityRequirementCapacity2.Name = "fieldCapacityRequirementCapacity2"; this.fieldCapacityRequirementCapacity2.Options.AllowRunTimeSummaryChange = true; this.fieldCapacityRequirementCapacity2.Options.ShowSummaryTypeName = true; this.fieldCapacityRequirementCapacity2.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Average; // // pivotGridField1 // this.pivotGridField1.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.pivotGridField1.AreaIndex = 1; this.pivotGridField1.Caption = "Event Start Month"; dataSourceColumnBinding13.ColumnName = "CapacityRequirement.Event.StartDate"; dataSourceColumnBinding13.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateMonth; this.pivotGridField1.DataBinding = dataSourceColumnBinding13; this.pivotGridField1.Name = "pivotGridField1"; this.pivotGridField1.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Count; this.pivotGridField1.Visible = false; // // pivotGridField2 // this.pivotGridField2.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.pivotGridField2.AreaIndex = 0; this.pivotGridField2.Caption = "Event Start Year"; dataSourceColumnBinding14.ColumnName = "CapacityRequirement.Event.StartDate"; dataSourceColumnBinding14.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateYear; this.pivotGridField2.DataBinding = dataSourceColumnBinding14; this.pivotGridField2.ExpandedInFieldsGroup = false; this.pivotGridField2.Name = "pivotGridField2"; // // ribbonControl1 // this.ribbonControl1.ExpandCollapseItem.Id = 0; this.ribbonControl1.Items.AddRange(new DevExpress.XtraBars.BarItem[] { this.ribbonControl1.ExpandCollapseItem, this.ribbonControl1.SearchEditItem, this.printExportItem }); this.ribbonControl1.Location = new System.Drawing.Point(0, 0); this.ribbonControl1.MaxItemId = 1; this.ribbonControl1.Name = "ribbonControl1"; this.ribbonControl1.PageCategories.AddRange(new DevExpress.XtraBars.Ribbon.RibbonPageCategory[] { this.ribbonPageCategory1 }); this.ribbonControl1.Size = new System.Drawing.Size(1000, 150); // // printExportItem // this.printExportItem.Caption = "Print && Export"; this.printExportItem.Id = 0; this.printExportItem.ImageOptions.SvgImage = global::sample_5_14.Properties.Resources.printexport; this.printExportItem.Name = "printExportItem"; // // ribbonPageCategory1 // this.ribbonPageCategory1.Appearance.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(128)))), ((int)(((byte)(0))))); this.ribbonPageCategory1.Appearance.Options.UseBackColor = true; this.ribbonPageCategory1.Name = "ribbonPageCategory1"; this.ribbonPageCategory1.Pages.AddRange(new DevExpress.XtraBars.Ribbon.RibbonPage[] { this.ribbonPage1 }); this.ribbonPageCategory1.Text = "Pivot Overview"; // // ribbonPage1 // this.ribbonPage1.Groups.AddRange(new DevExpress.XtraBars.Ribbon.RibbonPageGroup[] { this.ribbonPageGroup1 }); this.ribbonPage1.Name = "ribbonPage1"; this.ribbonPage1.Text = "Data Operations"; // // ribbonPageGroup1 // this.ribbonPageGroup1.ItemLinks.Add(this.printExportItem); this.ribbonPageGroup1.Name = "ribbonPageGroup1"; this.ribbonPageGroup1.Text = "Tools"; // // PivotOverview // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.Controls.Add(this.splitContainerControl1); this.Controls.Add(this.ribbonControl1); this.Name = "PivotOverview"; this.Size = new System.Drawing.Size(1000, 700); ((System.ComponentModel.ISupportInitialize)(this.roomBookingCollection)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.session)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.splitContainerControl1)).EndInit(); this.splitContainerControl1.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.ribbonControl1)).EndInit(); this.ResumeLayout(false); this.PerformLayout(); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup(); DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup2 = new DevExpress.XtraPivotGrid.PivotGridGroup(); this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl(); this.btnBegin = new DevExpress.XtraEditors.SimpleButton(); this.groupBox1 = new System.Windows.Forms.GroupBox(); this.rbUnlocked = new System.Windows.Forms.RadioButton(); this.rbLocked = new System.Windows.Forms.RadioButton(); this.label3 = new System.Windows.Forms.Label(); this.pivotGridField1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.pivotGridField2 = new DevExpress.XtraPivotGrid.PivotGridField(); this.pivotGridField3 = new DevExpress.XtraPivotGrid.PivotGridField(); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit(); this.groupBox1.SuspendLayout(); this.SuspendLayout(); // // pivotGridControl1 // this.pivotGridControl1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] { this.pivotGridField1, this.pivotGridField2, this.pivotGridField3 }); pivotGridGroup1.Hierarchy = null; pivotGridGroup2.Hierarchy = null; this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] { pivotGridGroup1, pivotGridGroup2 }); this.pivotGridControl1.Location = new System.Drawing.Point(12, 84); this.pivotGridControl1.Name = "pivotGridControl1"; this.pivotGridControl1.Size = new System.Drawing.Size(423, 417); this.pivotGridControl1.TabIndex = 0; // // btnBegin // this.btnBegin.Location = new System.Drawing.Point(12, 55); this.btnBegin.Name = "btnBegin"; this.btnBegin.Size = new System.Drawing.Size(75, 23); this.btnBegin.TabIndex = 1; this.btnBegin.Text = "Transpose"; this.btnBegin.Click += new System.EventHandler(this.btnBegin_Click); // // groupBox1 // this.groupBox1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.groupBox1.Controls.Add(this.rbUnlocked); this.groupBox1.Controls.Add(this.rbLocked); this.groupBox1.Location = new System.Drawing.Point(207, 12); this.groupBox1.Name = "groupBox1"; this.groupBox1.Size = new System.Drawing.Size(228, 66); this.groupBox1.TabIndex = 2; this.groupBox1.TabStop = false; this.groupBox1.Text = "Pivot Grid Locking Options"; // // rbUnlocked // this.rbUnlocked.AutoSize = true; this.rbUnlocked.Location = new System.Drawing.Point(6, 42); this.rbUnlocked.Name = "rbUnlocked"; this.rbUnlocked.Size = new System.Drawing.Size(153, 17); this.rbUnlocked.TabIndex = 1; this.rbUnlocked.Text = "Do Not Lock the Pivot Grid"; this.rbUnlocked.UseVisualStyleBackColor = true; // // rbLocked // this.rbLocked.AutoSize = true; this.rbLocked.Checked = true; this.rbLocked.Location = new System.Drawing.Point(6, 19); this.rbLocked.Name = "rbLocked"; this.rbLocked.Size = new System.Drawing.Size(116, 17); this.rbLocked.TabIndex = 0; this.rbLocked.TabStop = true; this.rbLocked.Text = "Lock the Pivot Grid"; this.rbLocked.UseVisualStyleBackColor = true; // // label3 // this.label3.Location = new System.Drawing.Point(12, 12); this.label3.Name = "label3"; this.label3.Size = new System.Drawing.Size(189, 40); this.label3.TabIndex = 8; this.label3.Text = "Try transposing the pivot grid with and without locking it, to see the difference" + " in performance."; // // pivotGridField1 // this.pivotGridField1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.pivotGridField1.AreaIndex = 0; this.pivotGridField1.FieldName = "A"; this.pivotGridField1.Name = "pivotGridField1"; // // pivotGridField2 // this.pivotGridField2.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.pivotGridField2.AreaIndex = 0; this.pivotGridField2.FieldName = "B"; this.pivotGridField2.Name = "pivotGridField2"; // // pivotGridField3 // this.pivotGridField3.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.pivotGridField3.AreaIndex = 0; this.pivotGridField3.FieldName = "Data"; this.pivotGridField3.Name = "pivotGridField3"; // // Form1 // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(447, 513); this.Controls.Add(this.label3); this.Controls.Add(this.groupBox1); this.Controls.Add(this.btnBegin); this.Controls.Add(this.pivotGridControl1); this.MinimumSize = new System.Drawing.Size(463, 310); this.Name = "Form1"; this.Text = "Form1"; this.Load += new System.EventHandler(this.Form1_Load); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit(); this.groupBox1.ResumeLayout(false); this.groupBox1.PerformLayout(); this.ResumeLayout(false); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1)); DevExpress.DataAccess.Excel.FieldInfo fieldInfo1 = new DevExpress.DataAccess.Excel.FieldInfo(); DevExpress.DataAccess.Excel.FieldInfo fieldInfo2 = new DevExpress.DataAccess.Excel.FieldInfo(); DevExpress.DataAccess.Excel.FieldInfo fieldInfo3 = new DevExpress.DataAccess.Excel.FieldInfo(); DevExpress.DataAccess.Excel.FieldInfo fieldInfo4 = new DevExpress.DataAccess.Excel.FieldInfo(); DevExpress.DataAccess.Excel.FieldInfo fieldInfo5 = new DevExpress.DataAccess.Excel.FieldInfo(); DevExpress.DataAccess.Excel.FieldInfo fieldInfo6 = new DevExpress.DataAccess.Excel.FieldInfo(); DevExpress.DataAccess.Excel.FieldInfo fieldInfo7 = new DevExpress.DataAccess.Excel.FieldInfo(); DevExpress.DataAccess.Excel.FieldInfo fieldInfo8 = new DevExpress.DataAccess.Excel.FieldInfo(); DevExpress.DataAccess.Excel.FieldInfo fieldInfo9 = new DevExpress.DataAccess.Excel.FieldInfo(); DevExpress.DataAccess.Excel.FieldInfo fieldInfo10 = new DevExpress.DataAccess.Excel.FieldInfo(); DevExpress.DataAccess.Excel.FieldInfo fieldInfo11 = new DevExpress.DataAccess.Excel.FieldInfo(); DevExpress.DataAccess.Excel.FieldInfo fieldInfo12 = new DevExpress.DataAccess.Excel.FieldInfo(); DevExpress.DataAccess.Excel.ExcelWorksheetSettings excelWorksheetSettings1 = new DevExpress.DataAccess.Excel.ExcelWorksheetSettings(); DevExpress.DataAccess.Excel.ExcelSourceOptions excelSourceOptions1 = new DevExpress.DataAccess.Excel.ExcelSourceOptions(excelWorksheetSettings1); this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl(); this.excelDataSource1 = new DevExpress.DataAccess.Excel.ExcelDataSource(); this.fieldCategoryName1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldProductName1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldSalesPerson1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldOrderDate1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldExtendedPrice1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.pivotGridField1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.splitContainerControl1 = new DevExpress.XtraEditors.SplitContainerControl(); this.gridControl1 = new DevExpress.XtraGrid.GridControl(); this.gridView1 = new DevExpress.XtraGrid.Views.Grid.GridView(); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.splitContainerControl1)).BeginInit(); this.splitContainerControl1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.gridControl1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.gridView1)).BeginInit(); this.SuspendLayout(); // // pivotGridControl1 // this.pivotGridControl1.DataSource = this.excelDataSource1; this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill; this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] { this.fieldCategoryName1, this.fieldProductName1, this.fieldSalesPerson1, this.fieldOrderDate1, this.fieldExtendedPrice1 }); pivotGridGroup1.Caption = "Calendar"; this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] { pivotGridGroup1 }); this.pivotGridControl1.Location = new System.Drawing.Point(0, 0); this.pivotGridControl1.Name = "pivotGridControl1"; this.pivotGridControl1.Size = new System.Drawing.Size(590, 406); this.pivotGridControl1.TabIndex = 0; this.pivotGridControl1.CellDoubleClick += new DevExpress.XtraPivotGrid.PivotCellEventHandler(this.pivotGridControl1_CellDoubleClick); // // excelDataSource1 // this.excelDataSource1.FileName = "C:\\Data\\SalesPerson.xlsx"; this.excelDataSource1.Name = "excelDataSource1"; this.excelDataSource1.ResultSchemaSerializable = resources.GetString("excelDataSource1.ResultSchemaSerializable"); fieldInfo1.Name = "CategoryName"; fieldInfo1.Type = typeof(string); fieldInfo2.Name = "Country"; fieldInfo2.Type = typeof(string); fieldInfo3.Name = "FirstName"; fieldInfo3.Type = typeof(string); fieldInfo4.Name = "LastName"; fieldInfo4.Type = typeof(string); fieldInfo5.Name = "ProductName"; fieldInfo5.Type = typeof(string); fieldInfo6.Name = "Sales Person"; fieldInfo6.Type = typeof(string); fieldInfo7.Name = "OrderDate"; fieldInfo7.Type = typeof(System.DateTime); fieldInfo8.Name = "OrderID"; fieldInfo8.Type = typeof(double); fieldInfo9.Name = "Quantity"; fieldInfo9.Type = typeof(double); fieldInfo10.Name = "Discount"; fieldInfo10.Type = typeof(double); fieldInfo11.Name = "Extended Price"; fieldInfo11.Type = typeof(double); fieldInfo12.Name = "UnitPrice"; fieldInfo12.Type = typeof(double); this.excelDataSource1.Schema.AddRange(new DevExpress.DataAccess.Excel.FieldInfo[] { fieldInfo1, fieldInfo2, fieldInfo3, fieldInfo4, fieldInfo5, fieldInfo6, fieldInfo7, fieldInfo8, fieldInfo9, fieldInfo10, fieldInfo11, fieldInfo12 }); excelWorksheetSettings1.CellRange = null; excelWorksheetSettings1.WorksheetName = "Data"; excelSourceOptions1.ImportSettings = excelWorksheetSettings1; this.excelDataSource1.SourceOptions = excelSourceOptions1; // // fieldCategoryName1 // this.fieldCategoryName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldCategoryName1.AreaIndex = 0; this.fieldCategoryName1.Caption = "Category Name"; this.fieldCategoryName1.FieldName = "CategoryName"; this.fieldCategoryName1.Name = "fieldCategoryName1"; // // fieldProductName1 // this.fieldProductName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldProductName1.AreaIndex = 1; this.fieldProductName1.Caption = "Product Name"; this.fieldProductName1.FieldName = "ProductName"; this.fieldProductName1.Name = "fieldProductName1"; // // fieldSalesPerson1 // this.fieldSalesPerson1.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldSalesPerson1.AreaIndex = 1; this.fieldSalesPerson1.Caption = "Sales Person"; this.fieldSalesPerson1.FieldName = "Sales Person"; this.fieldSalesPerson1.Name = "fieldSalesPerson1"; // // fieldOrderDate1 // this.fieldOrderDate1.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldOrderDate1.AreaIndex = 0; this.fieldOrderDate1.Caption = "OrderDate"; this.fieldOrderDate1.FieldName = "OrderDate"; this.fieldOrderDate1.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateYear; this.fieldOrderDate1.Name = "fieldOrderDate1"; this.fieldOrderDate1.UnboundFieldName = "fieldOrderDate1"; // // fieldExtendedPrice1 // this.fieldExtendedPrice1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldExtendedPrice1.AreaIndex = 0; this.fieldExtendedPrice1.Caption = "Extended Price"; this.fieldExtendedPrice1.FieldName = "Extended Price"; this.fieldExtendedPrice1.Name = "fieldExtendedPrice1"; // // pivotGridField1 // this.pivotGridField1.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.pivotGridField1.AreaIndex = 0; this.pivotGridField1.Caption = "Year"; this.pivotGridField1.FieldName = "OrderDate"; this.pivotGridField1.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateYear; this.pivotGridField1.Name = "pivotGridField1"; this.pivotGridField1.UnboundFieldName = "fieldOrderDate"; // // splitContainerControl1 // this.splitContainerControl1.Dock = System.Windows.Forms.DockStyle.Fill; this.splitContainerControl1.Location = new System.Drawing.Point(0, 0); this.splitContainerControl1.Name = "splitContainerControl1"; this.splitContainerControl1.Panel1.Controls.Add(this.pivotGridControl1); this.splitContainerControl1.Panel1.Text = "Panel1"; this.splitContainerControl1.Panel2.Controls.Add(this.gridControl1); this.splitContainerControl1.Panel2.Text = "Panel2"; this.splitContainerControl1.Size = new System.Drawing.Size(887, 406); this.splitContainerControl1.SplitterPosition = 590; this.splitContainerControl1.TabIndex = 2; this.splitContainerControl1.Text = "splitContainerControl1"; // // gridControl1 // this.gridControl1.Dock = System.Windows.Forms.DockStyle.Fill; this.gridControl1.Location = new System.Drawing.Point(0, 0); this.gridControl1.MainView = this.gridView1; this.gridControl1.Name = "gridControl1"; this.gridControl1.Size = new System.Drawing.Size(287, 406); this.gridControl1.TabIndex = 0; this.gridControl1.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] { this.gridView1 }); // // gridView1 // this.gridView1.GridControl = this.gridControl1; this.gridView1.HorzScrollVisibility = DevExpress.XtraGrid.Views.Base.ScrollVisibility.Always; this.gridView1.Name = "gridView1"; this.gridView1.OptionsBehavior.AllowAddRows = DevExpress.Utils.DefaultBoolean.False; this.gridView1.OptionsBehavior.AllowDeleteRows = DevExpress.Utils.DefaultBoolean.False; this.gridView1.OptionsBehavior.Editable = false; this.gridView1.OptionsBehavior.ReadOnly = true; // // Form1 // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(887, 406); this.Controls.Add(this.splitContainerControl1); this.Name = "Form1"; this.Text = "Double click a cell to display the same level data"; this.Load += new System.EventHandler(this.Form1_Load); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.splitContainerControl1)).EndInit(); this.splitContainerControl1.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.gridControl1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.gridView1)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup(); this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl(); this.dtspstk01 = new BeSmartMRP.Report.LocalDataSet.DTSPSTK01(); this.fieldCIOTYPE = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCLOT = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCQCFRWHOUSE = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCQCPDGRP = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCQCPDTYPE = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCQCPROD = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCQCSECT = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCQCSUBCOOR = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCQCTOWHOUSE = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCQCWHOUSE = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCQN2SUBCOOR = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCQNFRWHOUSE = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCQNPDGRP = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCQNPDTYPE = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCQNPROD = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCQNSECT = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCQNSUBCOOR = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCQNTOWHOUSE = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCQNUM = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCQNWHOUSE = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCREFNO = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCSERIALNO = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCWHTYPE = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldDDATE = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldNQTY = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldNQTYIN = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldNQTYOUT = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldQCWHLOCA = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldQNWHLOCA = new DevExpress.XtraPivotGrid.PivotGridField(); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dtspstk01)).BeginInit(); this.SuspendLayout(); // // pivotGridControl1 // this.pivotGridControl1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.pivotGridControl1.DataMember = "XRPSTMOVE"; this.pivotGridControl1.DataSource = this.dtspstk01; this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] { this.fieldCIOTYPE, this.fieldCLOT, this.fieldCQCFRWHOUSE, this.fieldCQCPDGRP, this.fieldCQCPDTYPE, this.fieldCQCPROD, this.fieldCQCSECT, this.fieldCQCSUBCOOR, this.fieldCQCTOWHOUSE, this.fieldCQCWHOUSE, this.fieldCQN2SUBCOOR, this.fieldCQNFRWHOUSE, this.fieldCQNPDGRP, this.fieldCQNPDTYPE, this.fieldCQNPROD, this.fieldCQNSECT, this.fieldCQNSUBCOOR, this.fieldCQNTOWHOUSE, this.fieldCQNUM, this.fieldCQNWHOUSE, this.fieldCREFNO, this.fieldCSERIALNO, this.fieldCWHTYPE, this.fieldDDATE, this.fieldNQTY, this.fieldNQTYIN, this.fieldNQTYOUT, this.fieldQCWHLOCA, this.fieldQNWHLOCA }); pivotGridGroup1.Fields.Add(this.fieldCQCPROD); pivotGridGroup1.Fields.Add(this.fieldCQNPROD); pivotGridGroup1.Hierarchy = null; pivotGridGroup1.ShowNewValues = true; this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] { pivotGridGroup1 }); this.pivotGridControl1.Location = new System.Drawing.Point(12, 61); this.pivotGridControl1.Name = "pivotGridControl1"; this.pivotGridControl1.Size = new System.Drawing.Size(741, 281); this.pivotGridControl1.TabIndex = 0; // // dtspstk01 // this.dtspstk01.DataSetName = "DTSPSTK01"; this.dtspstk01.Locale = new System.Globalization.CultureInfo("en-US"); this.dtspstk01.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // fieldCIOTYPE // this.fieldCIOTYPE.AreaIndex = 28; this.fieldCIOTYPE.Caption = "IO"; this.fieldCIOTYPE.FieldName = "CIOTYPE"; this.fieldCIOTYPE.Name = "fieldCIOTYPE"; // // fieldCLOT // this.fieldCLOT.AreaIndex = 0; this.fieldCLOT.Caption = "Lot"; this.fieldCLOT.FieldName = "CLOT"; this.fieldCLOT.Name = "fieldCLOT"; // // fieldCQCFRWHOUSE // this.fieldCQCFRWHOUSE.AreaIndex = 1; this.fieldCQCFRWHOUSE.Caption = "รหัสคลังสินค้าต้นทาง"; this.fieldCQCFRWHOUSE.FieldName = "CQCFRWHOUSE"; this.fieldCQCFRWHOUSE.Name = "fieldCQCFRWHOUSE"; // // fieldCQCPDGRP // this.fieldCQCPDGRP.AreaIndex = 2; this.fieldCQCPDGRP.Caption = "รหัสกลุ่มสินค้า"; this.fieldCQCPDGRP.FieldName = "CQCPDGRP"; this.fieldCQCPDGRP.Name = "fieldCQCPDGRP"; // // fieldCQCPDTYPE // this.fieldCQCPDTYPE.AreaIndex = 3; this.fieldCQCPDTYPE.Caption = "รหัสชนิดสินค้า"; this.fieldCQCPDTYPE.FieldName = "CQCPDTYPE"; this.fieldCQCPDTYPE.Name = "fieldCQCPDTYPE"; // // fieldCQCPROD // this.fieldCQCPROD.AreaIndex = 4; this.fieldCQCPROD.Caption = "รหัสสินค้า"; this.fieldCQCPROD.FieldName = "CQCPROD"; this.fieldCQCPROD.Name = "fieldCQCPROD"; // // fieldCQCSECT // this.fieldCQCSECT.AreaIndex = 6; this.fieldCQCSECT.Caption = "รหัสแผนก"; this.fieldCQCSECT.FieldName = "CQCSECT"; this.fieldCQCSECT.Name = "fieldCQCSECT"; // // fieldCQCSUBCOOR // this.fieldCQCSUBCOOR.AreaIndex = 7; this.fieldCQCSUBCOOR.FieldName = "CQCSUBCOOR"; this.fieldCQCSUBCOOR.Name = "fieldCQCSUBCOOR"; // // fieldCQCTOWHOUSE // this.fieldCQCTOWHOUSE.AreaIndex = 8; this.fieldCQCTOWHOUSE.Caption = "รหัสคลังปลายทาง"; this.fieldCQCTOWHOUSE.FieldName = "CQCTOWHOUSE"; this.fieldCQCTOWHOUSE.Name = "fieldCQCTOWHOUSE"; // // fieldCQCWHOUSE // this.fieldCQCWHOUSE.AreaIndex = 9; this.fieldCQCWHOUSE.Caption = "รหัสคลังสินค้า"; this.fieldCQCWHOUSE.FieldName = "CQCWHOUSE"; this.fieldCQCWHOUSE.Name = "fieldCQCWHOUSE"; // // fieldCQN2SUBCOOR // this.fieldCQN2SUBCOOR.AreaIndex = 10; this.fieldCQN2SUBCOOR.FieldName = "CQN2SUBCOOR"; this.fieldCQN2SUBCOOR.Name = "fieldCQN2SUBCOOR"; // // fieldCQNFRWHOUSE // this.fieldCQNFRWHOUSE.AreaIndex = 11; this.fieldCQNFRWHOUSE.Caption = "ชื่อคลังสินค้าต้นทาง"; this.fieldCQNFRWHOUSE.FieldName = "CQNFRWHOUSE"; this.fieldCQNFRWHOUSE.Name = "fieldCQNFRWHOUSE"; // // fieldCQNPDGRP // this.fieldCQNPDGRP.AreaIndex = 12; this.fieldCQNPDGRP.Caption = "ชื่อกลุ่มสินค้า"; this.fieldCQNPDGRP.FieldName = "CQNPDGRP"; this.fieldCQNPDGRP.Name = "fieldCQNPDGRP"; // // fieldCQNPDTYPE // this.fieldCQNPDTYPE.AreaIndex = 13; this.fieldCQNPDTYPE.Caption = "ชื่อประเภทสินค้า"; this.fieldCQNPDTYPE.FieldName = "CQNPDTYPE"; this.fieldCQNPDTYPE.Name = "fieldCQNPDTYPE"; // // fieldCQNPROD // this.fieldCQNPROD.AreaIndex = 5; this.fieldCQNPROD.Caption = "ชื่อสินค้า"; this.fieldCQNPROD.FieldName = "CQNPROD"; this.fieldCQNPROD.Name = "fieldCQNPROD"; // // fieldCQNSECT // this.fieldCQNSECT.AreaIndex = 14; this.fieldCQNSECT.Caption = "ชื่อแผนก"; this.fieldCQNSECT.FieldName = "CQNSECT"; this.fieldCQNSECT.Name = "fieldCQNSECT"; // // fieldCQNSUBCOOR // this.fieldCQNSUBCOOR.AreaIndex = 15; this.fieldCQNSUBCOOR.FieldName = "CQNSUBCOOR"; this.fieldCQNSUBCOOR.Name = "fieldCQNSUBCOOR"; // // fieldCQNTOWHOUSE // this.fieldCQNTOWHOUSE.AreaIndex = 16; this.fieldCQNTOWHOUSE.Caption = "ชื่อคลังสินค้าปลายทาง"; this.fieldCQNTOWHOUSE.FieldName = "CQNTOWHOUSE"; this.fieldCQNTOWHOUSE.Name = "fieldCQNTOWHOUSE"; // // fieldCQNUM // this.fieldCQNUM.AreaIndex = 17; this.fieldCQNUM.Caption = "ชื่อหน่วยนับ"; this.fieldCQNUM.FieldName = "CQNUM"; this.fieldCQNUM.Name = "fieldCQNUM"; // // fieldCQNWHOUSE // this.fieldCQNWHOUSE.AreaIndex = 18; this.fieldCQNWHOUSE.Caption = "ชื่อคลังสินค้า"; this.fieldCQNWHOUSE.FieldName = "CQNWHOUSE"; this.fieldCQNWHOUSE.Name = "fieldCQNWHOUSE"; // // fieldCREFNO // this.fieldCREFNO.AreaIndex = 19; this.fieldCREFNO.Caption = "เลขที่อ้างอิง"; this.fieldCREFNO.FieldName = "CREFNO"; this.fieldCREFNO.Name = "fieldCREFNO"; // // fieldCSERIALNO // this.fieldCSERIALNO.AreaIndex = 20; this.fieldCSERIALNO.Caption = "SERIAL NO."; this.fieldCSERIALNO.FieldName = "CSERIALNO"; this.fieldCSERIALNO.Name = "fieldCSERIALNO"; // // fieldCWHTYPE // this.fieldCWHTYPE.AreaIndex = 21; this.fieldCWHTYPE.Caption = "ประเภทคลังสินค้า"; this.fieldCWHTYPE.FieldName = "CWHTYPE"; this.fieldCWHTYPE.Name = "fieldCWHTYPE"; // // fieldDDATE // this.fieldDDATE.AreaIndex = 22; this.fieldDDATE.Caption = "วันที่เอกสาร"; this.fieldDDATE.FieldName = "DDATE"; this.fieldDDATE.Name = "fieldDDATE"; // // fieldNQTY // this.fieldNQTY.AreaIndex = 23; this.fieldNQTY.Caption = "จำนวน"; this.fieldNQTY.FieldName = "NQTY"; this.fieldNQTY.Name = "fieldNQTY"; // // fieldNQTYIN // this.fieldNQTYIN.AreaIndex = 24; this.fieldNQTYIN.Caption = "จำนวน รับ"; this.fieldNQTYIN.FieldName = "NQTY_IN"; this.fieldNQTYIN.Name = "fieldNQTYIN"; // // fieldNQTYOUT // this.fieldNQTYOUT.AreaIndex = 25; this.fieldNQTYOUT.Caption = "จำนวนจ่าย"; this.fieldNQTYOUT.FieldName = "NQTY_OUT"; this.fieldNQTYOUT.Name = "fieldNQTYOUT"; // // fieldQCWHLOCA // this.fieldQCWHLOCA.AreaIndex = 26; this.fieldQCWHLOCA.Caption = "รหัสที่เก็บสินค้า"; this.fieldQCWHLOCA.FieldName = "QCWHLOCA"; this.fieldQCWHLOCA.Name = "fieldQCWHLOCA"; // // fieldQNWHLOCA // this.fieldQNWHLOCA.AreaIndex = 27; this.fieldQNWHLOCA.Caption = "ชื่อที่เก็บสินค้า"; this.fieldQNWHLOCA.FieldName = "QNWHLOCA"; this.fieldQNWHLOCA.Name = "fieldQNWHLOCA"; // // frmStockQuery1 // this.Appearance.BackColor = System.Drawing.Color.SkyBlue; this.Appearance.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(222))); this.Appearance.Options.UseBackColor = true; this.Appearance.Options.UseFont = true; this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(765, 370); this.Controls.Add(this.pivotGridControl1); this.Name = "frmStockQuery1"; this.Text = "STOCK INQUIRY"; ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dtspstk01)).EndInit(); this.ResumeLayout(false); }
/// <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.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup(); this.fieldOrderDate1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldOrderDate = new DevExpress.XtraPivotGrid.PivotGridField(); this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl(); this.salesPersonBindingSource = new System.Windows.Forms.BindingSource(this.components); this.nwindDataSet = new GroupFilter.nwindDataSet(); this.fieldProductName1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldExtendedPrice1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCategoryName1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.salesPersonTableAdapter = new GroupFilter.nwindDataSetTableAdapters.SalesPersonTableAdapter(); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.salesPersonBindingSource)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.nwindDataSet)).BeginInit(); this.SuspendLayout(); // // fieldOrderDate1 // this.fieldOrderDate1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldOrderDate1.AreaIndex = 0; this.fieldOrderDate1.Caption = "Year"; this.fieldOrderDate1.FieldName = "OrderDate"; this.fieldOrderDate1.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateYear; this.fieldOrderDate1.Name = "fieldOrderDate1"; this.fieldOrderDate1.UnboundFieldName = "fieldOrderDate1"; // // fieldOrderDate // this.fieldOrderDate.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldOrderDate.AreaIndex = 1; this.fieldOrderDate.Caption = "Month"; this.fieldOrderDate.FieldName = "OrderDate"; this.fieldOrderDate.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateMonth; this.fieldOrderDate.Name = "fieldOrderDate"; this.fieldOrderDate.UnboundFieldName = "fieldOrderDate"; // // pivotGridControl1 // this.pivotGridControl1.DataSource = this.salesPersonBindingSource; this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill; this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] { this.fieldProductName1, this.fieldExtendedPrice1, this.fieldCategoryName1, this.fieldOrderDate1, this.fieldOrderDate }); pivotGridGroup1.Caption = "OrderDateGroup"; pivotGridGroup1.Fields.Add(this.fieldOrderDate1); pivotGridGroup1.Fields.Add(this.fieldOrderDate); pivotGridGroup1.Hierarchy = null; pivotGridGroup1.ShowNewValues = true; this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] { pivotGridGroup1 }); this.pivotGridControl1.Location = new System.Drawing.Point(0, 0); this.pivotGridControl1.LookAndFeel.SkinName = "Office 2010 Silver"; this.pivotGridControl1.LookAndFeel.UseDefaultLookAndFeel = false; this.pivotGridControl1.Name = "pivotGridControl1"; this.pivotGridControl1.Size = new System.Drawing.Size(598, 310); this.pivotGridControl1.TabIndex = 0; // // salesPersonBindingSource // this.salesPersonBindingSource.DataMember = "SalesPerson"; this.salesPersonBindingSource.DataSource = this.nwindDataSet; // // nwindDataSet // this.nwindDataSet.DataSetName = "nwindDataSet"; this.nwindDataSet.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // fieldProductName1 // this.fieldProductName1.AreaIndex = 0; this.fieldProductName1.Caption = "Product Name"; this.fieldProductName1.FieldName = "ProductName"; this.fieldProductName1.Name = "fieldProductName1"; // // fieldExtendedPrice1 // this.fieldExtendedPrice1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldExtendedPrice1.AreaIndex = 0; this.fieldExtendedPrice1.Caption = "Extended Price"; this.fieldExtendedPrice1.FieldName = "Extended Price"; this.fieldExtendedPrice1.Name = "fieldExtendedPrice1"; // // fieldCategoryName1 // this.fieldCategoryName1.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldCategoryName1.AreaIndex = 0; this.fieldCategoryName1.Caption = "Category Name"; this.fieldCategoryName1.FieldName = "CategoryName"; this.fieldCategoryName1.Name = "fieldCategoryName1"; // // salesPersonTableAdapter // this.salesPersonTableAdapter.ClearBeforeFill = true; // // Form1 // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(598, 310); this.Controls.Add(this.pivotGridControl1); this.Name = "Form1"; this.Text = "Form1"; this.Load += new System.EventHandler(this.Form1_Load); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.salesPersonBindingSource)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.nwindDataSet)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup(); this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl(); this.fieldCategory = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldProduct = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldSubcategory = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldTotalProductCost = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCalendarYear = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldSalesTerritoryCountry = new DevExpress.XtraPivotGrid.PivotGridField(); this.button1 = new System.Windows.Forms.Button(); this.fieldSalesAmount = new DevExpress.XtraPivotGrid.PivotGridField(); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit(); this.SuspendLayout(); // // pivotGridControl1 // this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill; this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] { this.fieldCategory, this.fieldProduct, this.fieldSubcategory, this.fieldTotalProductCost, this.fieldCalendarYear, this.fieldSalesTerritoryCountry, this.fieldSalesAmount }); pivotGridGroup1.Caption = "Product Categories"; pivotGridGroup1.Fields.Add(this.fieldCategory); pivotGridGroup1.Fields.Add(this.fieldSubcategory); pivotGridGroup1.Fields.Add(this.fieldProduct); pivotGridGroup1.Hierarchy = "[Product].[Product Categories]"; this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] { pivotGridGroup1 }); this.pivotGridControl1.Location = new System.Drawing.Point(0, 0); this.pivotGridControl1.Name = "pivotGridControl1"; this.pivotGridControl1.OLAPConnectionString = "provider=MSOLAP;data source=local;initial catalog=\"Adventure Works DW Standard Ed" + "ition\";cube name=\"Adventure Works\""; this.pivotGridControl1.Size = new System.Drawing.Size(648, 386); this.pivotGridControl1.TabIndex = 0; // // fieldCategory // this.fieldCategory.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldCategory.AreaIndex = 0; this.fieldCategory.Caption = "Category"; this.fieldCategory.FieldName = "[Product].[Product Categories].[Category]"; this.fieldCategory.Name = "fieldCategory"; // // fieldProduct // this.fieldProduct.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldProduct.AreaIndex = 2; this.fieldProduct.Caption = "Product"; this.fieldProduct.FieldName = "[Product].[Product Categories].[Product]"; this.fieldProduct.Name = "fieldProduct"; // // fieldSubcategory // this.fieldSubcategory.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldSubcategory.AreaIndex = 1; this.fieldSubcategory.Caption = "Subcategory"; this.fieldSubcategory.FieldName = "[Product].[Product Categories].[Subcategory]"; this.fieldSubcategory.Name = "fieldSubcategory"; // // fieldTotalProductCost // this.fieldTotalProductCost.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldTotalProductCost.AreaIndex = 0; this.fieldTotalProductCost.Caption = "Total Product Cost"; this.fieldTotalProductCost.CellFormat.FormatString = "c"; this.fieldTotalProductCost.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldTotalProductCost.FieldName = "[Measures].[Total Product Cost]"; this.fieldTotalProductCost.Name = "fieldTotalProductCost"; // // fieldCalendarYear // this.fieldCalendarYear.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldCalendarYear.AreaIndex = 0; this.fieldCalendarYear.Caption = "Calendar Year"; this.fieldCalendarYear.FieldName = "[Date].[Calendar Year].[Calendar Year]"; this.fieldCalendarYear.Name = "fieldCalendarYear"; // // fieldSalesTerritoryCountry // this.fieldSalesTerritoryCountry.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldSalesTerritoryCountry.AreaIndex = 1; this.fieldSalesTerritoryCountry.Caption = "Sales Territory Country"; this.fieldSalesTerritoryCountry.FieldName = "[Sales Territory].[Sales Territory Country].[Sales Territory Country]"; this.fieldSalesTerritoryCountry.Name = "fieldSalesTerritoryCountry"; // // button1 // this.button1.Location = new System.Drawing.Point(536, 0); this.button1.Name = "button1"; this.button1.Size = new System.Drawing.Size(112, 23); this.button1.TabIndex = 1; this.button1.Text = "Query Server"; this.button1.UseVisualStyleBackColor = true; this.button1.Click += new System.EventHandler(this.button1_Click); // // fieldSalesAmount // this.fieldSalesAmount.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldSalesAmount.AreaIndex = 1; this.fieldSalesAmount.Caption = "Sales Amount"; this.fieldSalesAmount.CellFormat.FormatString = "c"; this.fieldSalesAmount.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldSalesAmount.FieldName = "[Measures].[Sales Amount]"; this.fieldSalesAmount.Name = "fieldSalesAmount"; // // Form1 // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(648, 386); this.Controls.Add(this.button1); this.Controls.Add(this.pivotGridControl1); this.Name = "Form1"; this.Text = "Form1"; this.Load += new System.EventHandler(this.Form1_Load); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit(); this.ResumeLayout(false); }
/// <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.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(xFrmUrunRapor)); this.fieldFiyat1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldTutar = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldKarOran = new DevExpress.XtraPivotGrid.PivotGridField(); this.urunlerPivotGridControl = new DevExpress.XtraPivotGrid.PivotGridControl(); this.urunRaporBindingSource = new System.Windows.Forms.BindingSource(this.components); this.fieldFirmaKod1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldUrunAdi1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldKategoriAdi1 = new DevExpress.XtraPivotGrid.PivotGridField(); ((System.ComponentModel.ISupportInitialize)(this.urunlerPivotGridControl)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.urunRaporBindingSource)).BeginInit(); this.SuspendLayout(); // // fieldFiyat1 // this.fieldFiyat1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea))); this.fieldFiyat1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldFiyat1.AreaIndex = 0; this.fieldFiyat1.Caption = "Alış Fiyatı"; this.fieldFiyat1.CellFormat.FormatString = "###,###,##0.00"; this.fieldFiyat1.CellFormat.FormatType = DevExpress.Utils.FormatType.Custom; this.fieldFiyat1.FieldName = "Fiyat"; this.fieldFiyat1.Name = "fieldFiyat1"; this.fieldFiyat1.Options.AllowEdit = false; this.fieldFiyat1.Options.ShowCustomTotals = false; this.fieldFiyat1.Options.ShowGrandTotal = false; this.fieldFiyat1.Options.ShowTotals = false; this.fieldFiyat1.TotalsVisibility = DevExpress.XtraPivotGrid.PivotTotalsVisibility.None; this.fieldFiyat1.Width = 65; // // fieldTutar // this.fieldTutar.Appearance.Cell.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Bold); this.fieldTutar.Appearance.Cell.Options.UseFont = true; this.fieldTutar.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldTutar.AreaIndex = 1; this.fieldTutar.Caption = "Satış Fiyatı"; this.fieldTutar.CellFormat.FormatString = "###,###,##0.00"; this.fieldTutar.CellFormat.FormatType = DevExpress.Utils.FormatType.Custom; this.fieldTutar.FieldName = "Tutar"; this.fieldTutar.Name = "fieldTutar"; this.fieldTutar.Width = 65; // // fieldKarOran // this.fieldKarOran.AreaIndex = 0; this.fieldKarOran.FieldName = "KarOran"; this.fieldKarOran.Name = "fieldKarOran"; this.fieldKarOran.Visible = false; // // urunlerPivotGridControl // this.urunlerPivotGridControl.Appearance.ColumnHeaderArea.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Bold); this.urunlerPivotGridControl.Appearance.ColumnHeaderArea.Options.UseFont = true; this.urunlerPivotGridControl.DataSource = this.urunRaporBindingSource; this.urunlerPivotGridControl.Dock = System.Windows.Forms.DockStyle.Fill; this.urunlerPivotGridControl.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] { this.fieldFiyat1, this.fieldKarOran, this.fieldTutar, this.fieldFirmaKod1, this.fieldUrunAdi1, this.fieldKategoriAdi1 }); pivotGridGroup1.Caption = "Fiyatlar"; pivotGridGroup1.Fields.Add(this.fieldFiyat1); pivotGridGroup1.Fields.Add(this.fieldTutar); pivotGridGroup1.Hierarchy = null; this.urunlerPivotGridControl.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] { pivotGridGroup1 }); this.urunlerPivotGridControl.Location = new System.Drawing.Point(0, 0); this.urunlerPivotGridControl.Name = "urunlerPivotGridControl"; this.urunlerPivotGridControl.OptionsView.ShowColumnGrandTotalHeader = false; this.urunlerPivotGridControl.OptionsView.ShowColumnGrandTotals = false; this.urunlerPivotGridControl.OptionsView.ShowColumnHeaders = false; this.urunlerPivotGridControl.OptionsView.ShowColumnTotals = false; this.urunlerPivotGridControl.OptionsView.ShowDataHeaders = false; this.urunlerPivotGridControl.OptionsView.ShowFilterHeaders = false; this.urunlerPivotGridControl.OptionsView.ShowFilterSeparatorBar = false; this.urunlerPivotGridControl.OptionsView.ShowRowGrandTotalHeader = false; this.urunlerPivotGridControl.OptionsView.ShowRowGrandTotals = false; this.urunlerPivotGridControl.OptionsView.ShowRowHeaders = false; this.urunlerPivotGridControl.OptionsView.ShowRowTotals = false; this.urunlerPivotGridControl.Size = new System.Drawing.Size(641, 360); this.urunlerPivotGridControl.TabIndex = 0; // // urunRaporBindingSource // this.urunRaporBindingSource.DataSource = typeof(EasySupply.UrunRapor); // // fieldFirmaKod1 // this.fieldFirmaKod1.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldFirmaKod1.AreaIndex = 0; this.fieldFirmaKod1.Caption = "Firma Kod"; this.fieldFirmaKod1.FieldName = "FirmaKod"; this.fieldFirmaKod1.Name = "fieldFirmaKod1"; // // fieldUrunAdi1 // this.fieldUrunAdi1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldUrunAdi1.AreaIndex = 1; this.fieldUrunAdi1.Caption = "Urun Adi"; this.fieldUrunAdi1.FieldName = "UrunAdi"; this.fieldUrunAdi1.Name = "fieldUrunAdi1"; this.fieldUrunAdi1.Options.AllowEdit = false; this.fieldUrunAdi1.TotalsVisibility = DevExpress.XtraPivotGrid.PivotTotalsVisibility.None; this.fieldUrunAdi1.Width = 275; // // fieldKategoriAdi1 // this.fieldKategoriAdi1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldKategoriAdi1.AreaIndex = 0; this.fieldKategoriAdi1.Caption = "Kategori Adi"; this.fieldKategoriAdi1.FieldName = "KategoriAdi"; this.fieldKategoriAdi1.Name = "fieldKategoriAdi1"; this.fieldKategoriAdi1.TotalsVisibility = DevExpress.XtraPivotGrid.PivotTotalsVisibility.None; this.fieldKategoriAdi1.Width = 20; // // xFrmUrunRapor // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(641, 360); this.Controls.Add(this.urunlerPivotGridControl); this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon"))); this.Name = "xFrmUrunRapor"; this.Text = "Ürün Raporu"; this.FormClosing += new System.Windows.Forms.FormClosingEventHandler(this.xFrmUrunRapor_FormClosing); this.Load += new System.EventHandler(this.xFrmUrunRapor_Load); ((System.ComponentModel.ISupportInitialize)(this.urunlerPivotGridControl)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.urunRaporBindingSource)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup(); this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl(); this.fieldInternetSalesAmount = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCountry = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldYear = new DevExpress.XtraPivotGrid.PivotGridField(); this.repositoryItemProgressBar1 = new DevExpress.XtraEditors.Repository.RepositoryItemProgressBar(); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemProgressBar1)).BeginInit(); this.SuspendLayout(); // // pivotGridControl1 // this.pivotGridControl1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] { this.fieldInternetSalesAmount, this.fieldCountry, this.fieldYear }); pivotGridGroup1.Caption = "Year - Month"; pivotGridGroup1.Hierarchy = null; this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] { pivotGridGroup1 }); this.pivotGridControl1.Location = new System.Drawing.Point(12, 12); this.pivotGridControl1.Name = "pivotGridControl1"; this.pivotGridControl1.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] { this.repositoryItemProgressBar1 }); this.pivotGridControl1.Size = new System.Drawing.Size(651, 281); this.pivotGridControl1.TabIndex = 0; // // fieldInternetSalesAmount // this.fieldInternetSalesAmount.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldInternetSalesAmount.AreaIndex = 0; this.fieldInternetSalesAmount.Caption = "Sales"; this.fieldInternetSalesAmount.FieldName = "[Measures].[Internet Sales Amount]"; this.fieldInternetSalesAmount.Name = "fieldInternetSalesAmount"; // // fieldCountry // this.fieldCountry.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldCountry.AreaIndex = 0; this.fieldCountry.Caption = "Country"; this.fieldCountry.FieldName = "[Customer].[Country].[Country]"; this.fieldCountry.Name = "fieldCountry"; // // fieldYear // this.fieldYear.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldYear.AreaIndex = 0; this.fieldYear.Caption = "Year"; this.fieldYear.FieldName = "[Date].[Fiscal].[Fiscal Year]"; this.fieldYear.Name = "fieldYear"; // // repositoryItemProgressBar1 // this.repositoryItemProgressBar1.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.NoBorder; this.repositoryItemProgressBar1.DisplayFormat.FormatString = "{0}%"; this.repositoryItemProgressBar1.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom; this.repositoryItemProgressBar1.Name = "repositoryItemProgressBar1"; this.repositoryItemProgressBar1.ShowTitle = true; // // Form1 // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(675, 305); this.Controls.Add(this.pivotGridControl1); this.Name = "Form1"; this.Text = "Form1"; this.Load += new System.EventHandler(this.Form1_Load); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemProgressBar1)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup(); DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup2 = new DevExpress.XtraPivotGrid.PivotGridGroup(); this.fieldYear = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldQuarter = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldMonth = new DevExpress.XtraPivotGrid.PivotGridField(); this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl(); this.fieldProductName = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldProductSales = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCategoryName = new DevExpress.XtraPivotGrid.PivotGridField(); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit(); this.SuspendLayout(); // // fieldYear // this.fieldYear.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldYear.AreaIndex = 0; this.fieldYear.Caption = "Year"; this.fieldYear.FieldName = "ShippedDate"; this.fieldYear.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateYear; this.fieldYear.Name = "fieldYear"; this.fieldYear.UnboundFieldName = "fieldYear"; // // fieldQuarter // this.fieldQuarter.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldQuarter.AreaIndex = 1; this.fieldQuarter.Caption = "Quarter"; this.fieldQuarter.FieldName = "ShippedDate"; this.fieldQuarter.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateQuarter; this.fieldQuarter.Name = "fieldQuarter"; this.fieldQuarter.UnboundFieldName = "fieldQuarter"; // // fieldMonth // this.fieldMonth.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldMonth.AreaIndex = 2; this.fieldMonth.Caption = "Month"; this.fieldMonth.FieldName = "ShippedDate"; this.fieldMonth.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateMonth; this.fieldMonth.Name = "fieldMonth"; this.fieldMonth.UnboundFieldName = "fieldMonth"; // // pivotGridControl1 // this.pivotGridControl1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] { this.fieldYear, this.fieldProductName, this.fieldProductSales, this.fieldCategoryName, this.fieldQuarter, this.fieldMonth }); pivotGridGroup1.Fields.Add(this.fieldYear); pivotGridGroup1.Fields.Add(this.fieldQuarter); pivotGridGroup1.Fields.Add(this.fieldMonth); pivotGridGroup1.Hierarchy = null; pivotGridGroup1.ShowNewValues = true; pivotGridGroup2.Caption = "Category - Product"; pivotGridGroup2.Fields.Add(this.fieldCategoryName); pivotGridGroup2.Fields.Add(this.fieldProductName); pivotGridGroup2.Hierarchy = null; pivotGridGroup2.ShowNewValues = true; this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] { pivotGridGroup1, pivotGridGroup2 }); this.pivotGridControl1.Location = new System.Drawing.Point(12, 12); this.pivotGridControl1.Name = "pivotGridControl1"; this.pivotGridControl1.Size = new System.Drawing.Size(726, 452); this.pivotGridControl1.TabIndex = 0; this.pivotGridControl1.CustomCellValue += new System.EventHandler <DevExpress.XtraPivotGrid.PivotCellValueEventArgs>(this.pivotGridControl1_CustomCellValue); // // fieldProductName // this.fieldProductName.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldProductName.AreaIndex = 1; this.fieldProductName.Caption = "Product Name"; this.fieldProductName.FieldName = "ProductName"; this.fieldProductName.Name = "fieldProductName"; // // fieldProductSales // this.fieldProductSales.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldProductSales.AreaIndex = 0; this.fieldProductSales.Caption = "Sales"; this.fieldProductSales.FieldName = "ProductSales"; this.fieldProductSales.Name = "fieldProductSales"; // // fieldCategoryName // this.fieldCategoryName.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldCategoryName.AreaIndex = 0; this.fieldCategoryName.Caption = "Category Name"; this.fieldCategoryName.FieldName = "CategoryName"; this.fieldCategoryName.Name = "fieldCategoryName"; // // Form1 // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(750, 476); this.Controls.Add(this.pivotGridControl1); this.Name = "Form1"; this.Text = "Form1"; this.Load += new System.EventHandler(this.Form1_Load); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup(); this.Col_Grupo = new DevExpress.XtraPivotGrid.PivotGridField(); this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl(); this.Col_pe_cedulaRuc = new DevExpress.XtraPivotGrid.PivotGridField(); this.Col_pe_nombre = new DevExpress.XtraPivotGrid.PivotGridField(); this.Col_Cargo = new DevExpress.XtraPivotGrid.PivotGridField(); this.Col_em_status = new DevExpress.XtraPivotGrid.PivotGridField(); this.Col_Orden = new DevExpress.XtraPivotGrid.PivotGridField(); this.Col_Valor = new DevExpress.XtraPivotGrid.PivotGridField(); this.Col_rubro = new DevExpress.XtraPivotGrid.PivotGridField(); this.Col_pe_FechaIni = new DevExpress.XtraPivotGrid.PivotGridField(); this.Col_Centro_costo = new DevExpress.XtraPivotGrid.PivotGridField(); this.Col_FechaInicio = new DevExpress.XtraPivotGrid.PivotGridField(); this.Col_Antiguedad = new DevExpress.XtraPivotGrid.PivotGridField(); this.Col_Af_DescripcionCorta = new DevExpress.XtraPivotGrid.PivotGridField(); this.ucRo_Menu = new Core.Erp.Reportes.Controles.UCRo_Menu_Reportes(); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit(); this.SuspendLayout(); // // Col_Grupo // this.Col_Grupo.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.Col_Grupo.AreaIndex = 0; this.Col_Grupo.Caption = "Grupo"; this.Col_Grupo.FieldName = "Grupo"; this.Col_Grupo.Name = "Col_Grupo"; // // pivotGridControl1 // this.pivotGridControl1.Appearance.FieldHeader.BackColor = System.Drawing.Color.White; this.pivotGridControl1.Appearance.FieldHeader.BackColor2 = System.Drawing.Color.White; this.pivotGridControl1.Appearance.FieldHeader.ForeColor = System.Drawing.Color.Red; this.pivotGridControl1.Appearance.FieldHeader.Options.UseBackColor = true; this.pivotGridControl1.Appearance.FieldHeader.Options.UseForeColor = true; this.pivotGridControl1.Appearance.FieldValue.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(128)))), ((int)(((byte)(0))))); this.pivotGridControl1.Appearance.FieldValue.Options.UseForeColor = true; this.pivotGridControl1.Appearance.FieldValueTotal.ForeColor = System.Drawing.Color.Black; this.pivotGridControl1.Appearance.FieldValueTotal.Options.UseForeColor = true; this.pivotGridControl1.AppearancePrint.FieldHeader.BackColor = System.Drawing.Color.Black; this.pivotGridControl1.AppearancePrint.FieldHeader.BackColor2 = System.Drawing.Color.White; this.pivotGridControl1.AppearancePrint.FieldHeader.ForeColor = System.Drawing.Color.Red; this.pivotGridControl1.AppearancePrint.FieldHeader.Options.UseBackColor = true; this.pivotGridControl1.AppearancePrint.FieldHeader.Options.UseBorderColor = true; this.pivotGridControl1.AppearancePrint.FieldHeader.Options.UseFont = true; this.pivotGridControl1.AppearancePrint.FieldHeader.Options.UseForeColor = true; this.pivotGridControl1.AppearancePrint.FieldValue.BackColor = System.Drawing.Color.Transparent; this.pivotGridControl1.AppearancePrint.FieldValue.BackColor2 = System.Drawing.Color.Transparent; this.pivotGridControl1.AppearancePrint.FieldValue.ForeColor = System.Drawing.Color.Black; this.pivotGridControl1.AppearancePrint.FieldValue.Options.UseBackColor = true; this.pivotGridControl1.AppearancePrint.FieldValue.Options.UseForeColor = true; this.pivotGridControl1.AppearancePrint.FieldValueTotal.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(128)))), ((int)(((byte)(128)))), ((int)(((byte)(255))))); this.pivotGridControl1.AppearancePrint.FieldValueTotal.Options.UseForeColor = true; this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill; this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] { this.Col_pe_cedulaRuc, this.Col_pe_nombre, this.Col_Cargo, this.Col_em_status, this.Col_Orden, this.Col_Valor, this.Col_rubro, this.Col_pe_FechaIni, this.Col_Grupo, this.Col_Centro_costo, this.Col_FechaInicio, this.Col_Antiguedad, this.Col_Af_DescripcionCorta }); pivotGridGroup1.Caption = "Grupos"; pivotGridGroup1.Fields.Add(this.Col_Grupo); pivotGridGroup1.Hierarchy = null; pivotGridGroup1.ShowNewValues = true; this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] { pivotGridGroup1 }); this.pivotGridControl1.Location = new System.Drawing.Point(0, 74); this.pivotGridControl1.Name = "pivotGridControl1"; this.pivotGridControl1.OptionsBehavior.HorizontalScrolling = DevExpress.XtraPivotGrid.PivotGridScrolling.Control; this.pivotGridControl1.OptionsPrint.MergeRowFieldValues = false; this.pivotGridControl1.OptionsPrint.PrintHeadersOnEveryPage = true; this.pivotGridControl1.OptionsPrint.PrintUnusedFilterFields = false; this.pivotGridControl1.OptionsPrint.UsePrintAppearance = true; this.pivotGridControl1.OptionsView.ShowColumnGrandTotalHeader = false; this.pivotGridControl1.OptionsView.ShowColumnGrandTotals = false; this.pivotGridControl1.OptionsView.ShowColumnTotals = false; this.pivotGridControl1.OptionsView.ShowRowGrandTotalHeader = false; this.pivotGridControl1.OptionsView.ShowRowGrandTotals = false; this.pivotGridControl1.OptionsView.ShowRowTotals = false; this.pivotGridControl1.Size = new System.Drawing.Size(1284, 417); this.pivotGridControl1.TabIndex = 149; this.pivotGridControl1.Click += new System.EventHandler(this.pivotGridControl1_Click); // // Col_pe_cedulaRuc // this.Col_pe_cedulaRuc.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.Col_pe_cedulaRuc.AreaIndex = 0; this.Col_pe_cedulaRuc.Caption = "Cedula"; this.Col_pe_cedulaRuc.FieldName = "pe_cedulaRuc"; this.Col_pe_cedulaRuc.Name = "Col_pe_cedulaRuc"; this.Col_pe_cedulaRuc.Options.ReadOnly = true; this.Col_pe_cedulaRuc.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Min; // // Col_pe_nombre // this.Col_pe_nombre.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.Col_pe_nombre.AreaIndex = 1; this.Col_pe_nombre.Caption = "Empleado"; this.Col_pe_nombre.FieldName = "pe_apellido"; this.Col_pe_nombre.Name = "Col_pe_nombre"; this.Col_pe_nombre.Options.ReadOnly = true; // // Col_Cargo // this.Col_Cargo.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.Col_Cargo.AreaIndex = 2; this.Col_Cargo.Caption = "Cargo"; this.Col_Cargo.FieldName = "ca_descripcion"; this.Col_Cargo.Name = "Col_Cargo"; this.Col_Cargo.Options.ReadOnly = true; // // Col_em_status // this.Col_em_status.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.Col_em_status.AreaIndex = 7; this.Col_em_status.Caption = "Fecha Salida"; this.Col_em_status.FieldName = "EstadoEmpleado"; this.Col_em_status.Name = "Col_em_status"; // // Col_Orden // this.Col_Orden.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.Col_Orden.AreaIndex = 1; this.Col_Orden.Caption = "Orden"; this.Col_Orden.FieldName = "Orden"; this.Col_Orden.Name = "Col_Orden"; // // Col_Valor // this.Col_Valor.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.Col_Valor.AreaIndex = 0; this.Col_Valor.Caption = "Valor"; this.Col_Valor.FieldName = "Valor"; this.Col_Valor.Name = "Col_Valor"; // // Col_rubro // this.Col_rubro.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.Col_rubro.AreaIndex = 2; this.Col_rubro.Caption = "Rubro"; this.Col_rubro.FieldName = "Descripcion"; this.Col_rubro.Name = "Col_rubro"; // // Col_pe_FechaIni // this.Col_pe_FechaIni.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.Col_pe_FechaIni.AreaIndex = 6; this.Col_pe_FechaIni.Caption = "Fecha Mes"; this.Col_pe_FechaIni.CellFormat.FormatString = "{0:d}"; this.Col_pe_FechaIni.CellFormat.FormatType = DevExpress.Utils.FormatType.DateTime; this.Col_pe_FechaIni.FieldName = "pe_FechaIni"; this.Col_pe_FechaIni.Name = "Col_pe_FechaIni"; // // Col_Centro_costo // this.Col_Centro_costo.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.Col_Centro_costo.AreaIndex = 3; this.Col_Centro_costo.Caption = "Ubicacion"; this.Col_Centro_costo.FieldName = "Centro_costo"; this.Col_Centro_costo.Name = "Col_Centro_costo"; this.Col_Centro_costo.SortOrder = DevExpress.XtraPivotGrid.PivotSortOrder.Descending; // // Col_FechaInicio // this.Col_FechaInicio.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.Col_FechaInicio.AreaIndex = 5; this.Col_FechaInicio.Caption = "Fecha Ingreso"; this.Col_FechaInicio.FieldName = "FechaInicio"; this.Col_FechaInicio.Name = "Col_FechaInicio"; // // Col_Antiguedad // this.Col_Antiguedad.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.Col_Antiguedad.AreaIndex = 8; this.Col_Antiguedad.Caption = "Antiguedad"; this.Col_Antiguedad.FieldName = "Antiguedad"; this.Col_Antiguedad.Name = "Col_Antiguedad"; // // Col_Af_DescripcionCorta // this.Col_Af_DescripcionCorta.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.Col_Af_DescripcionCorta.AreaIndex = 4; this.Col_Af_DescripcionCorta.Caption = "Maquina"; this.Col_Af_DescripcionCorta.FieldName = "Af_DescripcionCorta"; this.Col_Af_DescripcionCorta.Name = "Col_Af_DescripcionCorta"; // // ucRo_Menu // this.ucRo_Menu.Dock = System.Windows.Forms.DockStyle.Top; this.ucRo_Menu.EnableBotonImprimir = true; this.ucRo_Menu.Location = new System.Drawing.Point(0, 0); this.ucRo_Menu.Name = "ucRo_Menu"; this.ucRo_Menu.Size = new System.Drawing.Size(1284, 74); this.ucRo_Menu.TabIndex = 148; this.ucRo_Menu.VisibleCmbCentroCosto = DevExpress.XtraBars.BarItemVisibility.Never; this.ucRo_Menu.VisibleCmbDivision = DevExpress.XtraBars.BarItemVisibility.Never; this.ucRo_Menu.VisibleCmbEmpleado = DevExpress.XtraBars.BarItemVisibility.Never; this.ucRo_Menu.VisibleCmbNominaTipo = DevExpress.XtraBars.BarItemVisibility.Always; this.ucRo_Menu.VisibleCmbNominaTipoLiqui = DevExpress.XtraBars.BarItemVisibility.Always; this.ucRo_Menu.VisibleCmbPeriodo = DevExpress.XtraBars.BarItemVisibility.Always; this.ucRo_Menu.VisibleCmbRubro = DevExpress.XtraBars.BarItemVisibility.Never; this.ucRo_Menu.VisibleDepartamento = DevExpress.XtraBars.BarItemVisibility.Always; this.ucRo_Menu.VisibleEstado = DevExpress.XtraBars.BarItemVisibility.Always; this.ucRo_Menu.VisibleGrupoFecha = false; this.ucRo_Menu.VisibleGrupoFiltro1 = true; this.ucRo_Menu.VisibleGrupoFiltro2 = false; this.ucRo_Menu.VisubleArea = DevExpress.XtraBars.BarItemVisibility.Always; this.ucRo_Menu.event_cmdCargar_ItemClick += new Core.Erp.Reportes.Controles.UCRo_Menu_Reportes.delegate_cmdCargar_ItemClick(this.ucRo_Menu_event_cmdCargar_ItemClick); this.ucRo_Menu.event_btnsalir_ItemClick += new Core.Erp.Reportes.Controles.UCRo_Menu_Reportes.delegate_btnsalir_ItemClick(this.ucRo_Menu_event_btnsalir_ItemClick); // // XROLES_Rpt009_frm // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(1284, 491); this.Controls.Add(this.pivotGridControl1); this.Controls.Add(this.ucRo_Menu); this.Name = "XROLES_Rpt009_frm"; this.Text = "XROLES_Rpt009_frm"; ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit(); this.ResumeLayout(false); }
/// <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.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition1 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup(); DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup2 = new DevExpress.XtraPivotGrid.PivotGridGroup(); DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup3 = new DevExpress.XtraPivotGrid.PivotGridGroup(); DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup4 = new DevExpress.XtraPivotGrid.PivotGridGroup(); this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl(); this.pivotGridField4 = new DevExpress.XtraPivotGrid.PivotGridField(); this.nwindDataSet = new PivotSample.nwindDataSet(); this.customerReportsBindingSource = new System.Windows.Forms.BindingSource(this.components); this.customerReportsTableAdapter = new PivotSample.nwindDataSetTableAdapters.CustomerReportsTableAdapter(); this.popupControlContainer1 = new DevExpress.XtraBars.PopupControlContainer(this.components); this.customFieldFilterControl1 = new PivotSample.CustomFieldFilterControl(); this.panelControl1 = new DevExpress.XtraEditors.PanelControl(); this.simpleButton3 = new DevExpress.XtraEditors.SimpleButton(); this.simpleButton4 = new DevExpress.XtraEditors.SimpleButton(); this.barManager1 = new DevExpress.XtraBars.BarManager(this.components); this.barDockControlTop = new DevExpress.XtraBars.BarDockControl(); this.barDockControlBottom = new DevExpress.XtraBars.BarDockControl(); this.barDockControlLeft = new DevExpress.XtraBars.BarDockControl(); this.barDockControlRight = new DevExpress.XtraBars.BarDockControl(); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.nwindDataSet)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.customerReportsBindingSource)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.popupControlContainer1)).BeginInit(); this.popupControlContainer1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.panelControl1)).BeginInit(); this.panelControl1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.barManager1)).BeginInit(); this.SuspendLayout(); // // pivotGridControl1 // this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill; pivotGridStyleFormatCondition1.Appearance.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(224)))), ((int)(((byte)(192))))); pivotGridStyleFormatCondition1.Appearance.Options.UseBackColor = true; pivotGridStyleFormatCondition1.ApplyToCell = false; pivotGridStyleFormatCondition1.Condition = DevExpress.XtraGrid.FormatConditionEnum.Greater; pivotGridStyleFormatCondition1.FieldName = ""; pivotGridStyleFormatCondition1.Value1 = new decimal(new int[] { 0, 0, 0, 0 }); this.pivotGridControl1.FormatConditions.AddRange(new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition[] { pivotGridStyleFormatCondition1 }); pivotGridGroup1.Caption = "Category Name"; pivotGridGroup1.Hierarchy = "[Categories].[Category Name]"; pivotGridGroup1.ShowNewValues = true; pivotGridGroup2.Caption = "City"; pivotGridGroup2.Hierarchy = "[Customers].[City]"; pivotGridGroup2.ShowNewValues = true; pivotGridGroup3.Caption = "Country"; pivotGridGroup3.Hierarchy = "[Customers].[Country]"; pivotGridGroup3.ShowNewValues = true; pivotGridGroup4.Caption = "Products"; pivotGridGroup4.Hierarchy = "[Products].[Products]"; pivotGridGroup4.ShowNewValues = true; this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] { pivotGridGroup1, pivotGridGroup2, pivotGridGroup3, pivotGridGroup4 }); this.pivotGridControl1.Location = new System.Drawing.Point(0, 0); this.pivotGridControl1.LookAndFeel.UseDefaultLookAndFeel = false; this.pivotGridControl1.Name = "pivotGridControl1"; this.pivotGridControl1.OLAPConnectionString = ""; this.pivotGridControl1.OptionsCustomization.CustomizationFormStyle = DevExpress.XtraPivotGrid.Customization.CustomizationFormStyle.Excel2007; this.pivotGridControl1.OptionsDataField.Area = DevExpress.XtraPivotGrid.PivotDataArea.ColumnArea; this.pivotGridControl1.OptionsDataField.AreaIndex = 0; this.pivotGridControl1.OptionsView.RowTreeWidth = 238; this.pivotGridControl1.OptionsView.ShowColumnGrandTotals = false; this.pivotGridControl1.OptionsView.ShowRowGrandTotals = false; this.pivotGridControl1.OptionsView.ShowTotalsForSingleValues = true; this.pivotGridControl1.Size = new System.Drawing.Size(593, 500); this.pivotGridControl1.TabIndex = 0; this.pivotGridControl1.MouseDown += new System.Windows.Forms.MouseEventHandler(this.pivotGridControl1_MouseDown); // // pivotGridField4 // this.pivotGridField4.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.pivotGridField4.AreaIndex = 0; this.pivotGridField4.FieldName = "Date"; this.pivotGridField4.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateMonth; this.pivotGridField4.Name = "pivotGridField4"; this.pivotGridField4.UnboundFieldName = "pivotGridField3"; // // nwindDataSet // this.nwindDataSet.DataSetName = "nwindDataSet"; this.nwindDataSet.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // customerReportsBindingSource // this.customerReportsBindingSource.DataMember = "CustomerReports"; this.customerReportsBindingSource.DataSource = this.nwindDataSet; // // customerReportsTableAdapter // this.customerReportsTableAdapter.ClearBeforeFill = true; // // popupControlContainer1 // this.popupControlContainer1.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.NoBorder; this.popupControlContainer1.Controls.Add(this.customFieldFilterControl1); this.popupControlContainer1.Controls.Add(this.panelControl1); this.popupControlContainer1.Location = new System.Drawing.Point(139, 189); this.popupControlContainer1.Manager = this.barManager1; this.popupControlContainer1.Name = "popupControlContainer1"; this.popupControlContainer1.Size = new System.Drawing.Size(404, 287); this.popupControlContainer1.TabIndex = 3; this.popupControlContainer1.Visible = false; // // customFieldFilterControl1 // this.customFieldFilterControl1.Dock = System.Windows.Forms.DockStyle.Fill; this.customFieldFilterControl1.Field = null; this.customFieldFilterControl1.Location = new System.Drawing.Point(0, 0); this.customFieldFilterControl1.Name = "customFieldFilterControl1"; this.customFieldFilterControl1.Size = new System.Drawing.Size(404, 261); this.customFieldFilterControl1.TabIndex = 0; // // panelControl1 // this.panelControl1.Controls.Add(this.simpleButton3); this.panelControl1.Controls.Add(this.simpleButton4); this.panelControl1.Dock = System.Windows.Forms.DockStyle.Bottom; this.panelControl1.Location = new System.Drawing.Point(0, 261); this.panelControl1.Name = "panelControl1"; this.panelControl1.Size = new System.Drawing.Size(404, 26); this.panelControl1.TabIndex = 2; // // simpleButton3 // this.simpleButton3.Dock = System.Windows.Forms.DockStyle.Right; this.simpleButton3.Location = new System.Drawing.Point(252, 2); this.simpleButton3.Name = "simpleButton3"; this.simpleButton3.Size = new System.Drawing.Size(75, 22); this.simpleButton3.TabIndex = 1; this.simpleButton3.Text = "Ok"; this.simpleButton3.Click += new System.EventHandler(this.simpleButton3_Click); // // simpleButton4 // this.simpleButton4.Dock = System.Windows.Forms.DockStyle.Right; this.simpleButton4.Location = new System.Drawing.Point(327, 2); this.simpleButton4.Name = "simpleButton4"; this.simpleButton4.Size = new System.Drawing.Size(75, 22); this.simpleButton4.TabIndex = 0; this.simpleButton4.Text = "Cancel"; this.simpleButton4.Click += new System.EventHandler(this.simpleButton4_Click); // // barManager1 // this.barManager1.DockControls.Add(this.barDockControlTop); this.barManager1.DockControls.Add(this.barDockControlBottom); this.barManager1.DockControls.Add(this.barDockControlLeft); this.barManager1.DockControls.Add(this.barDockControlRight); this.barManager1.Form = this; this.barManager1.MaxItemId = 0; // // barDockControlTop // this.barDockControlTop.CausesValidation = false; this.barDockControlTop.Dock = System.Windows.Forms.DockStyle.Top; this.barDockControlTop.Location = new System.Drawing.Point(0, 0); this.barDockControlTop.Size = new System.Drawing.Size(593, 0); // // barDockControlBottom // this.barDockControlBottom.CausesValidation = false; this.barDockControlBottom.Dock = System.Windows.Forms.DockStyle.Bottom; this.barDockControlBottom.Location = new System.Drawing.Point(0, 500); this.barDockControlBottom.Size = new System.Drawing.Size(593, 0); // // barDockControlLeft // this.barDockControlLeft.CausesValidation = false; this.barDockControlLeft.Dock = System.Windows.Forms.DockStyle.Left; this.barDockControlLeft.Location = new System.Drawing.Point(0, 0); this.barDockControlLeft.Size = new System.Drawing.Size(0, 500); // // barDockControlRight // this.barDockControlRight.CausesValidation = false; this.barDockControlRight.Dock = System.Windows.Forms.DockStyle.Right; this.barDockControlRight.Location = new System.Drawing.Point(593, 0); this.barDockControlRight.Size = new System.Drawing.Size(0, 500); // // Form1 // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(593, 500); this.Controls.Add(this.popupControlContainer1); this.Controls.Add(this.pivotGridControl1); this.Controls.Add(this.barDockControlLeft); this.Controls.Add(this.barDockControlRight); this.Controls.Add(this.barDockControlBottom); this.Controls.Add(this.barDockControlTop); this.Name = "Form1"; this.Text = "Form1"; ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.nwindDataSet)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.customerReportsBindingSource)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.popupControlContainer1)).EndInit(); this.popupControlContainer1.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.panelControl1)).EndInit(); this.panelControl1.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.barManager1)).EndInit(); this.ResumeLayout(false); this.PerformLayout(); }
/// <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.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup(); DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup2 = new DevExpress.XtraPivotGrid.PivotGridGroup(); DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup3 = new DevExpress.XtraPivotGrid.PivotGridGroup(); this.fieldOrderDate = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldOrderDate1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldOrderDate2 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldOrderDate3 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldShipCountry1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldShipCity1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCategoryName1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldProductName1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl(); this.xtraPivotGridTutorialBindingSource = new System.Windows.Forms.BindingSource(this.components); this.nwindDataSet = new NwindDataSet.nwindDataSet(); this.fieldUnitPrice1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldQuantity1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldPrice1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldExtendedPrice1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldFreight1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldSalesPerson1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldShipperCompany1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldOrderDate4 = new DevExpress.XtraPivotGrid.PivotGridField(); this.xtraPivotGridTutorialViewTableAdapter = new NwindDataSet.nwindDataSetTableAdapters.XtraPivotGridTutorialViewTableAdapter(); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xtraPivotGridTutorialBindingSource)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.nwindDataSet)).BeginInit(); this.SuspendLayout(); // // fieldOrderDate // this.fieldOrderDate.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldOrderDate.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldOrderDate.AreaIndex = 0; this.fieldOrderDate.Caption = "Year"; this.fieldOrderDate.FieldName = "OrderDate"; this.fieldOrderDate.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateYear; this.fieldOrderDate.Name = "fieldOrderDate"; this.fieldOrderDate.UnboundFieldName = "fieldOrderDate"; // // fieldOrderDate1 // this.fieldOrderDate1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldOrderDate1.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldOrderDate1.AreaIndex = 1; this.fieldOrderDate1.Caption = "Quarter"; this.fieldOrderDate1.ExpandedInFieldsGroup = false; this.fieldOrderDate1.FieldName = "OrderDate"; this.fieldOrderDate1.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateQuarter; this.fieldOrderDate1.Name = "fieldOrderDate1"; this.fieldOrderDate1.UnboundFieldName = "fieldOrderDate1"; this.fieldOrderDate1.ValueFormat.FormatString = "Quarter {0}"; this.fieldOrderDate1.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric; // // fieldOrderDate2 // this.fieldOrderDate2.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldOrderDate2.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldOrderDate2.AreaIndex = 2; this.fieldOrderDate2.Caption = "Month"; this.fieldOrderDate2.ExpandedInFieldsGroup = false; this.fieldOrderDate2.FieldName = "OrderDate"; this.fieldOrderDate2.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateMonth; this.fieldOrderDate2.Name = "fieldOrderDate2"; this.fieldOrderDate2.UnboundFieldName = "fieldOrderDate2"; this.fieldOrderDate2.Visible = false; // // fieldOrderDate3 // this.fieldOrderDate3.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldOrderDate3.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldOrderDate3.AreaIndex = 3; this.fieldOrderDate3.Caption = "Day"; this.fieldOrderDate3.FieldName = "OrderDate"; this.fieldOrderDate3.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateDay; this.fieldOrderDate3.Name = "fieldOrderDate3"; this.fieldOrderDate3.UnboundFieldName = "fieldOrderDate3"; this.fieldOrderDate3.Visible = false; // // fieldShipCountry1 // this.fieldShipCountry1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldShipCountry1.AreaIndex = 0; this.fieldShipCountry1.Caption = "Ship Country"; this.fieldShipCountry1.FieldName = "ShipCountry"; this.fieldShipCountry1.Name = "fieldShipCountry1"; this.fieldShipCountry1.Visible = false; // // fieldShipCity1 // this.fieldShipCity1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldShipCity1.AreaIndex = 1; this.fieldShipCity1.Caption = "Ship City"; this.fieldShipCity1.FieldName = "ShipCity"; this.fieldShipCity1.Name = "fieldShipCity1"; this.fieldShipCity1.Visible = false; // // fieldCategoryName1 // this.fieldCategoryName1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldCategoryName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldCategoryName1.AreaIndex = 0; this.fieldCategoryName1.Caption = "Category"; this.fieldCategoryName1.FieldName = "CategoryName"; this.fieldCategoryName1.Name = "fieldCategoryName1"; // // fieldProductName1 // this.fieldProductName1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldProductName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldProductName1.AreaIndex = 1; this.fieldProductName1.Caption = "Product"; this.fieldProductName1.FieldName = "ProductName"; this.fieldProductName1.Name = "fieldProductName1"; // // pivotGridControl1 // this.pivotGridControl1.DataSource = this.xtraPivotGridTutorialBindingSource; this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill; this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] { this.fieldCategoryName1, this.fieldProductName1, this.fieldUnitPrice1, this.fieldQuantity1, this.fieldPrice1, this.fieldExtendedPrice1, this.fieldFreight1, this.fieldSalesPerson1, this.fieldShipCountry1, this.fieldShipCity1, this.fieldShipperCompany1, this.fieldOrderDate, this.fieldOrderDate1, this.fieldOrderDate2, this.fieldOrderDate3, this.fieldOrderDate4 }); pivotGridGroup1.Caption = "Calendar"; pivotGridGroup1.Fields.Add(this.fieldOrderDate); pivotGridGroup1.Fields.Add(this.fieldOrderDate1); pivotGridGroup1.Fields.Add(this.fieldOrderDate2); pivotGridGroup1.Fields.Add(this.fieldOrderDate3); pivotGridGroup1.Hierarchy = null; pivotGridGroup1.ShowNewValues = true; pivotGridGroup2.Caption = "Ship Info"; pivotGridGroup2.Fields.Add(this.fieldShipCountry1); pivotGridGroup2.Fields.Add(this.fieldShipCity1); pivotGridGroup2.Hierarchy = null; pivotGridGroup2.ShowNewValues = true; pivotGridGroup3.Caption = "Product Info"; pivotGridGroup3.Fields.Add(this.fieldCategoryName1); pivotGridGroup3.Fields.Add(this.fieldProductName1); pivotGridGroup3.Hierarchy = null; pivotGridGroup3.ShowNewValues = true; this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] { pivotGridGroup1, pivotGridGroup2, pivotGridGroup3 }); this.pivotGridControl1.Location = new System.Drawing.Point(0, 0); this.pivotGridControl1.Name = "pivotGridControl1"; this.pivotGridControl1.Size = new System.Drawing.Size(1012, 541); this.pivotGridControl1.TabIndex = 0; // // xtraPivotGridTutorialBindingSource // this.xtraPivotGridTutorialBindingSource.DataMember = "XtraPivotGridTutorialView"; this.xtraPivotGridTutorialBindingSource.DataSource = this.nwindDataSet; // // nwindDataSet // this.nwindDataSet.DataSetName = "nwindDataSet"; this.nwindDataSet.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // fieldUnitPrice1 // this.fieldUnitPrice1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldUnitPrice1.AreaIndex = 0; this.fieldUnitPrice1.Caption = "Unit Price"; this.fieldUnitPrice1.FieldName = "UnitPrice"; this.fieldUnitPrice1.Name = "fieldUnitPrice1"; this.fieldUnitPrice1.Visible = false; // // fieldQuantity1 // this.fieldQuantity1.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea; this.fieldQuantity1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldQuantity1.AreaIndex = 1; this.fieldQuantity1.Caption = "Quantity"; this.fieldQuantity1.FieldName = "Quantity"; this.fieldQuantity1.Name = "fieldQuantity1"; // // fieldPrice1 // this.fieldPrice1.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea; this.fieldPrice1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldPrice1.AreaIndex = 0; this.fieldPrice1.Caption = "Amount"; this.fieldPrice1.CellFormat.FormatString = "C0"; this.fieldPrice1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldPrice1.FieldName = "Price"; this.fieldPrice1.Name = "fieldPrice1"; // // fieldExtendedPrice1 // this.fieldExtendedPrice1.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea; this.fieldExtendedPrice1.AreaIndex = 0; this.fieldExtendedPrice1.Caption = "Extended Amount"; this.fieldExtendedPrice1.CellFormat.FormatString = "C0"; this.fieldExtendedPrice1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldExtendedPrice1.FieldName = "ExtendedPrice"; this.fieldExtendedPrice1.Name = "fieldExtendedPrice1"; this.fieldExtendedPrice1.Visible = false; // // fieldFreight1 // this.fieldFreight1.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea; this.fieldFreight1.AreaIndex = 0; this.fieldFreight1.Caption = "Freight"; this.fieldFreight1.CellFormat.FormatString = "C0"; this.fieldFreight1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldFreight1.FieldName = "Freight"; this.fieldFreight1.Name = "fieldFreight1"; this.fieldFreight1.Visible = false; // // fieldSalesPerson1 // this.fieldSalesPerson1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldSalesPerson1.AreaIndex = 0; this.fieldSalesPerson1.Caption = "Sales Person"; this.fieldSalesPerson1.FieldName = "SalesPerson"; this.fieldSalesPerson1.Name = "fieldSalesPerson1"; this.fieldSalesPerson1.Visible = false; // // fieldShipperCompany1 // this.fieldShipperCompany1.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldShipperCompany1.AreaIndex = 0; this.fieldShipperCompany1.Caption = "Shipper Company"; this.fieldShipperCompany1.FieldName = "ShipperCompany"; this.fieldShipperCompany1.Name = "fieldShipperCompany1"; this.fieldShipperCompany1.Visible = false; // // fieldOrderDate4 // this.fieldOrderDate4.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea) | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea))); this.fieldOrderDate4.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldOrderDate4.AreaIndex = 4; this.fieldOrderDate4.Caption = "Date"; this.fieldOrderDate4.FieldName = "OrderDate"; this.fieldOrderDate4.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.Date; this.fieldOrderDate4.Name = "fieldOrderDate4"; this.fieldOrderDate4.UnboundFieldName = "fieldOrderDate4"; this.fieldOrderDate4.Visible = false; // // xtraPivotGridTutorialViewTableAdapter // this.xtraPivotGridTutorialViewTableAdapter.ClearBeforeFill = true; // // Form1 // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(1012, 541); this.Controls.Add(this.pivotGridControl1); this.Name = "Form1"; this.Text = "XtraPivotGridTutorial.Step2"; this.Load += new System.EventHandler(this.Form1_Load); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xtraPivotGridTutorialBindingSource)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.nwindDataSet)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup(); this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl(); this.pivotGridField1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.pivotGridField2 = new DevExpress.XtraPivotGrid.PivotGridField(); this.pivotGridField3 = new DevExpress.XtraPivotGrid.PivotGridField(); this.pivotGridField4 = new DevExpress.XtraPivotGrid.PivotGridField(); this.pivotGridField5 = new DevExpress.XtraPivotGrid.PivotGridField(); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit(); this.SuspendLayout(); // // pivotGridControl1 // this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill; this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] { this.pivotGridField1, this.pivotGridField2, this.pivotGridField3, this.pivotGridField4, this.pivotGridField5 }); pivotGridGroup1.Caption = "Date.Fiscal"; pivotGridGroup1.Fields.Add(this.pivotGridField3); pivotGridGroup1.Fields.Add(this.pivotGridField4); pivotGridGroup1.Hierarchy = "[Date].[Fiscal]"; pivotGridGroup1.ShowNewValues = true; this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] { pivotGridGroup1 }); this.pivotGridControl1.Location = new System.Drawing.Point(0, 0); this.pivotGridControl1.Name = "pivotGridControl1"; this.pivotGridControl1.OLAPConnectionString = "provider=MSOLAP;data source=https://demos.devexpress.com/Services/OLAP/msmdpump.d" + "ll;initial catalog=\"Adventure Works DW Standard Edition\";cube name=\"Adventure Wo" + "rks\""; this.pivotGridControl1.OLAPDataProvider = DevExpress.XtraPivotGrid.OLAPDataProvider.Adomd; this.pivotGridControl1.OptionsData.DataProcessingEngine = DevExpress.XtraPivotGrid.PivotDataProcessingEngine.LegacyOptimized; this.pivotGridControl1.Size = new System.Drawing.Size(768, 362); this.pivotGridControl1.TabIndex = 0; // // pivotGridField1 // this.pivotGridField1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.pivotGridField1.AreaIndex = 0; this.pivotGridField1.Caption = "Country"; this.pivotGridField1.DisplayFolder = "Location"; this.pivotGridField1.FieldName = "[Customer].[Country].[Country]"; this.pivotGridField1.Name = "pivotGridField1"; // // pivotGridField2 // this.pivotGridField2.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.pivotGridField2.AreaIndex = 1; this.pivotGridField2.Caption = "City"; this.pivotGridField2.DisplayFolder = "Location"; this.pivotGridField2.FieldName = "[Customer].[City].[City]"; this.pivotGridField2.Name = "pivotGridField2"; // // pivotGridField3 // this.pivotGridField3.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.pivotGridField3.AreaIndex = 0; this.pivotGridField3.Caption = "Fiscal Year"; this.pivotGridField3.DisplayFolder = "Fiscal"; this.pivotGridField3.FieldName = "[Date].[Fiscal].[Fiscal Year]"; this.pivotGridField3.Name = "pivotGridField3"; // // pivotGridField4 // this.pivotGridField4.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.pivotGridField4.AreaIndex = 1; this.pivotGridField4.Caption = "Fiscal Quarter"; this.pivotGridField4.DisplayFolder = "Fiscal"; this.pivotGridField4.FieldName = "[Date].[Fiscal].[Fiscal Quarter]"; this.pivotGridField4.Name = "pivotGridField4"; // // pivotGridField5 // this.pivotGridField5.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.pivotGridField5.AreaIndex = 0; this.pivotGridField5.Caption = "Internet Sales Amount"; this.pivotGridField5.DisplayFolder = "Internet Sales"; this.pivotGridField5.FieldName = "[Measures].[Internet Sales Amount]"; this.pivotGridField5.Name = "pivotGridField5"; // // Form1 // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(768, 362); this.Controls.Add(this.pivotGridControl1); this.Name = "Form1"; this.Text = "Form1"; ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup(); this.fieldYear = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldMonth = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldDay = new DevExpress.XtraPivotGrid.PivotGridField(); this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl(); this.fieldName = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldPrice = new DevExpress.XtraPivotGrid.PivotGridField(); this.radioGroup1 = new DevExpress.XtraEditors.RadioGroup(); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.radioGroup1.Properties)).BeginInit(); this.SuspendLayout(); // // fieldYear // this.fieldYear.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldYear.AreaIndex = 0; this.fieldYear.FieldName = "Year"; this.fieldYear.Name = "fieldYear"; // // fieldMonth // this.fieldMonth.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldMonth.AreaIndex = 1; this.fieldMonth.FieldName = "Month"; this.fieldMonth.Name = "fieldMonth"; // // fieldDay // this.fieldDay.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldDay.AreaIndex = 2; this.fieldDay.FieldName = "Day"; this.fieldDay.Name = "fieldDay"; // // pivotGridControl1 // this.pivotGridControl1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] { this.fieldName, this.fieldPrice, this.fieldYear, this.fieldMonth, this.fieldDay }); pivotGridGroup1.Fields.Add(this.fieldYear); pivotGridGroup1.Fields.Add(this.fieldMonth); pivotGridGroup1.Fields.Add(this.fieldDay); pivotGridGroup1.Hierarchy = null; this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] { pivotGridGroup1 }); this.pivotGridControl1.Location = new System.Drawing.Point(12, 92); this.pivotGridControl1.Name = "pivotGridControl1"; this.pivotGridControl1.OptionsView.RowTotalsLocation = DevExpress.XtraPivotGrid.PivotRowTotalsLocation.Tree; this.pivotGridControl1.OptionsView.ShowTotalsForSingleValues = true; this.pivotGridControl1.Size = new System.Drawing.Size(719, 367); this.pivotGridControl1.TabIndex = 0; this.pivotGridControl1.FieldValueDisplayText += new DevExpress.XtraPivotGrid.PivotFieldDisplayTextEventHandler(this.pivotGridControl1_FieldValueDisplayText); // // fieldName // this.fieldName.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldName.AreaIndex = 0; this.fieldName.FieldName = "Name"; this.fieldName.Name = "fieldName"; // // fieldPrice // this.fieldPrice.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldPrice.AreaIndex = 0; this.fieldPrice.FieldName = "Price"; this.fieldPrice.Name = "fieldPrice"; // // radioGroup1 // this.radioGroup1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.radioGroup1.EditValue = 1; this.radioGroup1.Location = new System.Drawing.Point(12, 12); this.radioGroup1.Name = "radioGroup1"; this.radioGroup1.Properties.Columns = 2; this.radioGroup1.Properties.Items.AddRange(new DevExpress.XtraEditors.Controls.RadioGroupItem[] { new DevExpress.XtraEditors.Controls.RadioGroupItem(1, "Show all data"), new DevExpress.XtraEditors.Controls.RadioGroupItem(2, "Show December 2009 and January 2010 only"), new DevExpress.XtraEditors.Controls.RadioGroupItem(2, "Hide 2009 year"), new DevExpress.XtraEditors.Controls.RadioGroupItem(3, "Show first days of months only") }); this.radioGroup1.Size = new System.Drawing.Size(719, 74); this.radioGroup1.TabIndex = 5; this.radioGroup1.SelectedIndexChanged += new System.EventHandler(this.radioGroup1_SelectedIndexChanged); // // Form1 // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(743, 471); this.Controls.Add(this.radioGroup1); this.Controls.Add(this.pivotGridControl1); this.Name = "Form1"; this.Text = "Hierarchical Filters"; this.Load += new System.EventHandler(this.Form1_Load); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.radioGroup1.Properties)).EndInit(); this.ResumeLayout(false); }
//通过配置的PivotList 设置PivotField 的信息 private Dictionary <DevExpress.XtraPivotGrid.PivotGridField, ColPivotInfo> setPivotFieldByCfg(ColPivotList xmlCfgLst, DevExpress.XtraPivotGrid.PivotGridControl gridCtl, MB.WinBase.Common.ColumnPropertyInfo fieldInfo) { if (xmlCfgLst == null) { return(null); } if (xmlCfgLst.Columns.Count == 0 && !xmlCfgLst.AutoCreatedGridField) { return(null); } IList <MB.XWinLib.PivotGrid.ColPivotInfo> infos = xmlCfgLst.GetColPivotInfos(fieldInfo.Name); DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup = null; if (infos.Count > 1 && xmlCfgLst.SameFieldGroup) { pivotGridGroup = new DevExpress.XtraPivotGrid.PivotGridGroup(); gridCtl.Groups.Add(pivotGridGroup); } if (infos.Count == 0) { createNewPivotField(fieldInfo.Name, fieldInfo.Description, gridCtl); //add by aifang 去掉汇总后金额显示格式(原来不管是金额还是数量都显示¥前缀)begin if (fieldInfo.DataType.Equals("System.Decimal")) { gridCtl.Fields[fieldInfo.Name].CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; } //add by aifang end return(null); } else { Dictionary <DevExpress.XtraPivotGrid.PivotGridField, ColPivotInfo> expressionFields = new Dictionary <DevExpress.XtraPivotGrid.PivotGridField, ColPivotInfo>(); //处理一个字段对应多个分组的情况 foreach (ColPivotInfo info in infos) { DevExpress.XtraPivotGrid.PivotGridField pivField = createNewPivotField(fieldInfo.Name, fieldInfo.Description, gridCtl); //如果定义了Expression则表示该列的值是通过其他列或其他手段推算而出的 if (!string.IsNullOrEmpty(info.Expression)) { expressionFields.Add(pivField, info); } if (info.Description != null && info.Description.Length > 0) { pivField.Caption = info.Description; } pivField.Area = info.IniArea; pivField.AreaIndex = info.AreaIndex; pivField.AllowedAreas = info.AllowedAreas; pivField.TopValueCount = info.TopValueCount; pivField.GroupInterval = info.GroupInterval; if (info.SummaryItemType != null && info.SummaryItemType.Length > 0) { pivField.SummaryType = (DevExpress.Data.PivotGrid.PivotSummaryType)Enum.Parse(typeof(DevExpress.Data.PivotGrid.PivotSummaryType), info.SummaryItemType); } //setDefaultFormatByGroup(pivField); //格式化显示数据。 if (info.CellFormat != DevExpress.Utils.FormatInfo.Empty) { pivField.CellFormat.Format = info.CellFormat.Format; pivField.CellFormat.FormatType = info.CellFormat.FormatType; pivField.CellFormat.FormatString = info.CellFormat.FormatString; } if (info.ValueFormat != DevExpress.Utils.FormatInfo.Empty) { pivField.ValueFormat.Format = info.CellFormat.Format; pivField.ValueFormat.FormatType = info.CellFormat.FormatType; pivField.ValueFormat.FormatString = info.CellFormat.FormatString; } //加入字段绑定分组。 if (pivotGridGroup != null) { pivotGridGroup.Add(pivField); } //DevExpress.XtraPivotGrid.PivotGroupInterval.DateDayOfWeek } return(expressionFields); } }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup1 = new DevExpress.XtraPivotGrid.PivotGridGroup(); this.fieldFiscalYear = new DevExpress.XtraPivotGrid.PivotGridField(); this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl(); this.fieldSalesAmount = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldProduct = new DevExpress.XtraPivotGrid.PivotGridField(); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit(); this.SuspendLayout(); // // fieldFiscalYear // this.fieldFiscalYear.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldFiscalYear.AreaIndex = 0; this.fieldFiscalYear.Caption = "Year"; this.fieldFiscalYear.DisplayFolder = "Fiscal"; this.fieldFiscalYear.FieldName = "[Date].[Fiscal].[Fiscal Year]"; this.fieldFiscalYear.Name = "fieldFiscalYear"; // // pivotGridControl1 // this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill; this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] { this.fieldSalesAmount, this.fieldProduct, this.fieldFiscalYear }); pivotGridGroup1.Caption = "Date.Fiscal"; pivotGridGroup1.Fields.Add(this.fieldFiscalYear); pivotGridGroup1.Hierarchy = "[Date].[Fiscal]"; pivotGridGroup1.ShowNewValues = true; this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] { pivotGridGroup1 }); this.pivotGridControl1.Location = new System.Drawing.Point(0, 0); this.pivotGridControl1.Name = "pivotGridControl1"; this.pivotGridControl1.OLAPConnectionString = "provider=MSOLAP;data source=http://demos.devexpress.com/Services/OLAP/msmdpump.dl" + "l;initial catalog=\"Adventure Works DW Standard Edition\";cube name=\"Adventure Wor" + "ks\""; this.pivotGridControl1.OLAPDataProvider = DevExpress.XtraPivotGrid.OLAPDataProvider.Adomd; this.pivotGridControl1.Size = new System.Drawing.Size(719, 466); this.pivotGridControl1.TabIndex = 0; this.pivotGridControl1.CustomServerModeSort += new System.EventHandler <DevExpress.XtraPivotGrid.CustomServerModeSortEventArgs>(this.pivotGridControl1_CustomServerModeSort); this.pivotGridControl1.FieldValueDisplayText += new DevExpress.XtraPivotGrid.PivotFieldDisplayTextEventHandler(this.pivotGridControl1_FieldValueDisplayText); // // fieldSalesAmount // this.fieldSalesAmount.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldSalesAmount.AreaIndex = 0; this.fieldSalesAmount.Caption = "Sales Amount"; this.fieldSalesAmount.DisplayFolder = "Sales Summary"; this.fieldSalesAmount.FieldName = "[Measures].[Sales Amount]"; this.fieldSalesAmount.Name = "fieldSalesAmount"; // // fieldProduct // this.fieldProduct.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldProduct.AreaIndex = 0; this.fieldProduct.Caption = "Product"; this.fieldProduct.FieldName = "[Product].[Product].[Product]"; this.fieldProduct.Name = "fieldProduct"; this.fieldProduct.Width = 200; // // Form1 // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(719, 466); this.Controls.Add(this.pivotGridControl1); this.Name = "Form1"; this.Text = "Custom OLAP Sorting"; ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup2 = new DevExpress.XtraPivotGrid.PivotGridGroup(); this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl(); this.panelControl1 = new DevExpress.XtraEditors.PanelControl(); this.btnRetrieveFields = new DevExpress.XtraEditors.SimpleButton(); this.btnCreateUnboundFields = new DevExpress.XtraEditors.SimpleButton(); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.panelControl1)).BeginInit(); this.panelControl1.SuspendLayout(); this.SuspendLayout(); // // pivotGridControl1 // this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill; pivotGridGroup2.Caption = "Date.Fiscal"; pivotGridGroup2.Hierarchy = "[Date].[Fiscal]"; this.pivotGridControl1.Groups.AddRange(new DevExpress.XtraPivotGrid.PivotGridGroup[] { pivotGridGroup2 }); this.pivotGridControl1.Location = new System.Drawing.Point(0, 52); this.pivotGridControl1.Name = "pivotGridControl1"; this.pivotGridControl1.OLAPConnectionString = ""; this.pivotGridControl1.OLAPDataProvider = DevExpress.XtraPivotGrid.OLAPDataProvider.Adomd; this.pivotGridControl1.Size = new System.Drawing.Size(755, 387); this.pivotGridControl1.TabIndex = 0; // // panelControl1 // this.panelControl1.Controls.Add(this.btnCreateUnboundFields); this.panelControl1.Controls.Add(this.btnRetrieveFields); this.panelControl1.Dock = System.Windows.Forms.DockStyle.Top; this.panelControl1.Location = new System.Drawing.Point(0, 0); this.panelControl1.Name = "panelControl1"; this.panelControl1.Size = new System.Drawing.Size(755, 52); this.panelControl1.TabIndex = 1; // // btnRetrieveFields // this.btnRetrieveFields.AccessibleDescription = " pivotGridControl1.Fields[\"[Customer].[Country].[Country]\"]"; this.btnRetrieveFields.Location = new System.Drawing.Point(30, 12); this.btnRetrieveFields.Name = "btnRetrieveFields"; this.btnRetrieveFields.Size = new System.Drawing.Size(107, 23); this.btnRetrieveFields.TabIndex = 0; this.btnRetrieveFields.Text = "Retrieve Fields"; this.btnRetrieveFields.Click += new System.EventHandler(this.btnRetrieveFields_Click); // // btnCreateUnboundFields // this.btnCreateUnboundFields.AccessibleDescription = ""; this.btnCreateUnboundFields.Location = new System.Drawing.Point(174, 12); this.btnCreateUnboundFields.Name = "btnCreateUnboundFields"; this.btnCreateUnboundFields.Size = new System.Drawing.Size(107, 23); this.btnCreateUnboundFields.TabIndex = 1; this.btnCreateUnboundFields.Text = "Create Fields"; this.btnCreateUnboundFields.Click += new System.EventHandler(this.btnCreateFields_Click); // // Form1 // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(755, 439); this.Controls.Add(this.pivotGridControl1); this.Controls.Add(this.panelControl1); this.Name = "Form1"; this.Text = "WinForms Pivot Grid OLAP Example"; ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.panelControl1)).EndInit(); this.panelControl1.ResumeLayout(false); this.ResumeLayout(false); }