/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition1 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
this.col_SaldoNaturaleza = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotBalance = new DevExpress.XtraPivotGrid.PivotGridControl();
this.pivotGridField1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridField2 = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridField4 = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridField5 = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridField3 = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridField6 = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridField7 = new DevExpress.XtraPivotGrid.PivotGridField();
this.uCct_Menu_Reportes1 = new Core.Erp.Reportes.Controles.UCct_Menu_Reportes();
this.splashScreenManager1 = new DevExpress.XtraSplashScreen.SplashScreenManager(this, typeof(global::Core.Erp.Reportes.frmEspere), true, true);
this.toolStrip1 = new System.Windows.Forms.ToolStrip();
this.btn_imprimir = new System.Windows.Forms.ToolStripButton();
this.progressBarControl1 = new DevExpress.XtraEditors.ProgressBarControl();
((System.ComponentModel.ISupportInitialize)(this.pivotBalance)).BeginInit();
this.toolStrip1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.progressBarControl1.Properties)).BeginInit();
this.SuspendLayout();
//
// col_SaldoNaturaleza
//
this.col_SaldoNaturaleza.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.col_SaldoNaturaleza.AreaIndex = 0;
this.col_SaldoNaturaleza.Caption = "Saldo";
this.col_SaldoNaturaleza.FieldName = "SaldoNaturaleza";
this.col_SaldoNaturaleza.Name = "col_SaldoNaturaleza";
//
// pivotBalance
//
this.pivotBalance.Dock = System.Windows.Forms.DockStyle.Fill;
this.pivotBalance.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.pivotGridField1,
this.pivotGridField2,
this.col_SaldoNaturaleza,
this.pivotGridField4,
this.pivotGridField5,
this.pivotGridField3,
this.pivotGridField6,
this.pivotGridField7
});
pivotGridStyleFormatCondition1.Appearance.Font = new System.Drawing.Font("Tahoma", 7.8F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
pivotGridStyleFormatCondition1.Appearance.Options.UseFont = true;
pivotGridStyleFormatCondition1.Expression = "[EsCuentaMovimiento] = True";
pivotGridStyleFormatCondition1.Field = this.col_SaldoNaturaleza;
pivotGridStyleFormatCondition1.FieldName = "col_SaldoNaturaleza";
this.pivotBalance.FormatConditions.AddRange(new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition[] {
pivotGridStyleFormatCondition1
});
this.pivotBalance.Location = new System.Drawing.Point(0, 128);
this.pivotBalance.Name = "pivotBalance";
this.pivotBalance.OptionsBehavior.BestFitConsiderCustomAppearance = true;
this.pivotBalance.OptionsBehavior.BestFitMode = ((DevExpress.XtraPivotGrid.PivotGridBestFitMode)((DevExpress.XtraPivotGrid.PivotGridBestFitMode.FieldValue | DevExpress.XtraPivotGrid.PivotGridBestFitMode.Cell)));
this.pivotBalance.OptionsPrint.PrintColumnHeaders = DevExpress.Utils.DefaultBoolean.False;
this.pivotBalance.OptionsPrint.PrintDataHeaders = DevExpress.Utils.DefaultBoolean.False;
this.pivotBalance.OptionsPrint.PrintFilterHeaders = DevExpress.Utils.DefaultBoolean.False;
this.pivotBalance.OptionsPrint.PrintUnusedFilterFields = false;
this.pivotBalance.OptionsView.ShowColumnTotals = false;
this.pivotBalance.OptionsView.ShowRowGrandTotals = false;
this.pivotBalance.Size = new System.Drawing.Size(1272, 472);
this.pivotBalance.TabIndex = 1;
this.pivotBalance.CustomAppearance += new DevExpress.XtraPivotGrid.PivotCustomAppearanceEventHandler(this.pivotBalance_CustomAppearance);
this.pivotBalance.CustomDrawFieldValue += new DevExpress.XtraPivotGrid.PivotCustomDrawFieldValueEventHandler(this.pivotBalance_CustomDrawFieldValue);
//
// pivotGridField1
//
this.pivotGridField1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.pivotGridField1.AreaIndex = 0;
this.pivotGridField1.Caption = "IdCtaCble";
this.pivotGridField1.FieldName = "IdCtaCble";
this.pivotGridField1.Name = "pivotGridField1";
this.pivotGridField1.Width = 200;
//
// pivotGridField2
//
this.pivotGridField2.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.pivotGridField2.AreaIndex = 1;
this.pivotGridField2.Caption = "Cuenta contable";
this.pivotGridField2.FieldName = "NombreCuenta";
this.pivotGridField2.Name = "pivotGridField2";
this.pivotGridField2.Width = 300;
//
// pivotGridField4
//
this.pivotGridField4.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.pivotGridField4.AreaIndex = 0;
this.pivotGridField4.Caption = "IdCentroCosto";
this.pivotGridField4.FieldName = "IdCentroCosto";
this.pivotGridField4.Name = "pivotGridField4";
//
// pivotGridField5
//
this.pivotGridField5.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.pivotGridField5.AreaIndex = 1;
this.pivotGridField5.Caption = "Centro de costo";
this.pivotGridField5.FieldName = "NombreCentroCosto";
this.pivotGridField5.Name = "pivotGridField5";
//
// pivotGridField3
//
this.pivotGridField3.AreaIndex = 1;
this.pivotGridField3.Caption = "Tipo Cuenta";
this.pivotGridField3.FieldName = "TipoCuenta";
this.pivotGridField3.Name = "pivotGridField3";
//
// pivotGridField6
//
this.pivotGridField6.AreaIndex = 0;
this.pivotGridField6.Caption = "Es cuenta movimiento";
this.pivotGridField6.FieldName = "EsCuentaMovimiento";
this.pivotGridField6.Name = "pivotGridField6";
//
// pivotGridField7
//
this.pivotGridField7.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.pivotGridField7.AreaIndex = 2;
this.pivotGridField7.Caption = "Nivel";
this.pivotGridField7.FieldName = "NivelCuenta";
this.pivotGridField7.Name = "pivotGridField7";
this.pivotGridField7.SortOrder = DevExpress.XtraPivotGrid.PivotSortOrder.Descending;
//
// uCct_Menu_Reportes1
//
this.uCct_Menu_Reportes1.caption_bei_Check = "Mostrar saldo 0";
this.uCct_Menu_Reportes1.caption_bei_Check2 = "Mostrar saldo 0";
this.uCct_Menu_Reportes1.caption_bei_Check3 = "Check";
this.uCct_Menu_Reportes1.caption_bei_Check4 = "Check";
this.uCct_Menu_Reportes1.Dock = System.Windows.Forms.DockStyle.Top;
this.uCct_Menu_Reportes1.Location = new System.Drawing.Point(0, 0);
this.uCct_Menu_Reportes1.Margin = new System.Windows.Forms.Padding(4);
this.uCct_Menu_Reportes1.Name = "uCct_Menu_Reportes1";
this.uCct_Menu_Reportes1.Size = new System.Drawing.Size(1272, 101);
this.uCct_Menu_Reportes1.TabIndex = 0;
this.uCct_Menu_Reportes1.Visible_bei_Centro_costo = DevExpress.XtraBars.BarItemVisibility.Never;
this.uCct_Menu_Reportes1.Visible_bei_Centro_costo_chk = DevExpress.XtraBars.BarItemVisibility.Always;
this.uCct_Menu_Reportes1.Visible_bei_Centro_costo_sub_centro_costo = DevExpress.XtraBars.BarItemVisibility.Never;
this.uCct_Menu_Reportes1.Visible_bei_Check2 = DevExpress.XtraBars.BarItemVisibility.Never;
this.uCct_Menu_Reportes1.Visible_bei_Check3 = DevExpress.XtraBars.BarItemVisibility.Never;
this.uCct_Menu_Reportes1.Visible_bei_Check4 = DevExpress.XtraBars.BarItemVisibility.Never;
this.uCct_Menu_Reportes1.Visible_bei_CtaCble = DevExpress.XtraBars.BarItemVisibility.Never;
this.uCct_Menu_Reportes1.Visible_bei_Desde = DevExpress.XtraBars.BarItemVisibility.Never;
this.uCct_Menu_Reportes1.Visible_bei_GrupoCble = DevExpress.XtraBars.BarItemVisibility.Never;
this.uCct_Menu_Reportes1.Visible_bei_GrupoCble_chk = DevExpress.XtraBars.BarItemVisibility.Never;
this.uCct_Menu_Reportes1.Visible_bei_Hasta = DevExpress.XtraBars.BarItemVisibility.Always;
this.uCct_Menu_Reportes1.Visible_bei_Nivel = DevExpress.XtraBars.BarItemVisibility.Always;
this.uCct_Menu_Reportes1.Visible_bei_punto_cargo = DevExpress.XtraBars.BarItemVisibility.Never;
this.uCct_Menu_Reportes1.Visible_btn_Mostrar_en_tabla = DevExpress.XtraBars.BarItemVisibility.Never;
this.uCct_Menu_Reportes1.Visible_Grupo_centro_costo = true;
this.uCct_Menu_Reportes1.Visible_Grupo_Check = true;
this.uCct_Menu_Reportes1.Visible_Grupo_cuentas = true;
this.uCct_Menu_Reportes1.Visible_Grupo_Punto_cargo = false;
this.uCct_Menu_Reportes1.event_btnConsultar_ItemClick += new Core.Erp.Reportes.Controles.UCct_Menu_Reportes.delegate_btnConsultar_ItemClick(this.uCct_Menu_Reportes1_event_btnConsultar_ItemClick);
this.uCct_Menu_Reportes1.event_btnSalir_ItemClick += new Core.Erp.Reportes.Controles.UCct_Menu_Reportes.delegate_btnSalir_ItemClick(this.uCct_Menu_Reportes1_event_btnSalir_ItemClick);
//
// toolStrip1
//
this.toolStrip1.Items.AddRange(new System.Windows.Forms.ToolStripItem[] {
this.btn_imprimir
});
this.toolStrip1.Location = new System.Drawing.Point(0, 101);
this.toolStrip1.Name = "toolStrip1";
this.toolStrip1.Size = new System.Drawing.Size(1272, 27);
this.toolStrip1.TabIndex = 2;
this.toolStrip1.Text = "toolStrip1";
//
// btn_imprimir
//
this.btn_imprimir.Image = global::Core.Erp.Reportes.Properties.Resources.imprimir5_64x64;
this.btn_imprimir.ImageTransparentColor = System.Drawing.Color.Magenta;
this.btn_imprimir.Name = "btn_imprimir";
this.btn_imprimir.Size = new System.Drawing.Size(86, 24);
this.btn_imprimir.Text = "Imprimir";
this.btn_imprimir.Click += new System.EventHandler(this.btn_imprimir_Click);
//
// progressBarControl1
//
this.progressBarControl1.Dock = System.Windows.Forms.DockStyle.Bottom;
this.progressBarControl1.Location = new System.Drawing.Point(0, 600);
this.progressBarControl1.Name = "progressBarControl1";
this.progressBarControl1.Size = new System.Drawing.Size(1272, 18);
this.progressBarControl1.TabIndex = 3;
//
// XCONTA_Rpt023_frm
//
this.AutoScaleDimensions = new System.Drawing.SizeF(8F, 16F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(1272, 618);
this.Controls.Add(this.pivotBalance);
this.Controls.Add(this.toolStrip1);
this.Controls.Add(this.uCct_Menu_Reportes1);
this.Controls.Add(this.progressBarControl1);
this.Name = "XCONTA_Rpt023_frm";
this.Text = "XCONTA_Rpt023_frm";
this.Load += new System.EventHandler(this.XCONTA_Rpt023_frm_Load);
((System.ComponentModel.ISupportInitialize)(this.pivotBalance)).EndInit();
this.toolStrip1.ResumeLayout(false);
this.toolStrip1.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.progressBarControl1.Properties)).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.PivotGridStyleFormatCondition pivotGridStyleFormatCondition1 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition2 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
this.pivotGridControl1 = new DevExpress.XtraPivotGrid.PivotGridControl();
this.dataSet1 = new System.Data.DataSet();
this.dataTable1 = new System.Data.DataTable();
this.dataColumn1 = new System.Data.DataColumn();
this.dataColumn2 = new System.Data.DataColumn();
this.dataColumn3 = new System.Data.DataColumn();
this.fiedName = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldDate = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldValue = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldDate1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.toolTipController1 = new DevExpress.Utils.ToolTipController(this.components);
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataTable1)).BeginInit();
this.SuspendLayout();
//
// pivotGridControl1
//
this.pivotGridControl1.Cursor = System.Windows.Forms.Cursors.Default;
this.pivotGridControl1.DataMember = "Data";
this.pivotGridControl1.DataSource = this.dataSet1;
this.pivotGridControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.pivotGridControl1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.fiedName,
this.fieldDate,
this.fieldValue,
this.fieldDate1
});
pivotGridStyleFormatCondition1.Appearance.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(255)))), ((int)(((byte)(192)))));
pivotGridStyleFormatCondition1.Appearance.Options.UseBackColor = true;
pivotGridStyleFormatCondition1.Condition = DevExpress.XtraGrid.FormatConditionEnum.Expression;
pivotGridStyleFormatCondition1.Expression = "[Name] == \'Aaa\'";
pivotGridStyleFormatCondition1.FieldName = "";
pivotGridStyleFormatCondition1.Tag = "Yellow Condition";
pivotGridStyleFormatCondition2.Appearance.ForeColor = System.Drawing.Color.Lime;
pivotGridStyleFormatCondition2.Appearance.Options.UseForeColor = true;
pivotGridStyleFormatCondition2.Condition = DevExpress.XtraGrid.FormatConditionEnum.Greater;
pivotGridStyleFormatCondition2.FieldName = "";
pivotGridStyleFormatCondition2.Tag = "Lime Condition";
pivotGridStyleFormatCondition2.Value1 = 20;
this.pivotGridControl1.FormatConditions.AddRange(new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition[] {
pivotGridStyleFormatCondition1,
pivotGridStyleFormatCondition2
});
this.pivotGridControl1.Location = new System.Drawing.Point(0, 0);
this.pivotGridControl1.Name = "pivotGridControl1";
this.pivotGridControl1.Size = new System.Drawing.Size(796, 292);
this.pivotGridControl1.TabIndex = 0;
this.pivotGridControl1.ToolTipController = this.toolTipController1;
//
// dataSet1
//
this.dataSet1.DataSetName = "NewDataSet";
this.dataSet1.Tables.AddRange(new System.Data.DataTable[] {
this.dataTable1
});
//
// dataTable1
//
this.dataTable1.Columns.AddRange(new System.Data.DataColumn[] {
this.dataColumn1,
this.dataColumn2,
this.dataColumn3
});
this.dataTable1.TableName = "Data";
//
// dataColumn1
//
this.dataColumn1.ColumnName = "Name";
//
// dataColumn2
//
this.dataColumn2.ColumnName = "Date";
this.dataColumn2.DataType = typeof(System.DateTime);
//
// dataColumn3
//
this.dataColumn3.ColumnName = "Value";
this.dataColumn3.DataType = typeof(decimal);
//
// fiedName
//
this.fiedName.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fiedName.AreaIndex = 0;
this.fiedName.FieldName = "Name";
this.fiedName.Name = "fiedName";
//
// fieldDate
//
this.fieldDate.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldDate.AreaIndex = 0;
this.fieldDate.Caption = "Year";
this.fieldDate.FieldName = "Date";
this.fieldDate.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateYear;
this.fieldDate.Name = "fieldDate";
this.fieldDate.UnboundFieldName = "fieldDate";
//
// fieldValue
//
this.fieldValue.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldValue.AreaIndex = 0;
this.fieldValue.Caption = "Sum";
this.fieldValue.FieldName = "Value";
this.fieldValue.Name = "fieldValue";
//
// fieldDate1
//
this.fieldDate1.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldDate1.AreaIndex = 1;
this.fieldDate1.Caption = "Date";
this.fieldDate1.FieldName = "Date";
this.fieldDate1.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.Date;
this.fieldDate1.Name = "fieldDate1";
this.fieldDate1.UnboundFieldName = "fieldDate1";
//
// toolTipController1
//
this.toolTipController1.GetActiveObjectInfo += new DevExpress.Utils.ToolTipControllerGetActiveObjectInfoEventHandler(this.toolTipController1_GetActiveObjectInfo);
//
// Form1
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(796, 292);
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.dataSet1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataTable1)).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.PivotGridStyleFormatCondition pivotGridStyleFormatCondition1 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
this.colOutstandingAmount = new DevExpress.XtraPivotGrid.PivotGridField();
this.pvGrid = new DevExpress.XtraPivotGrid.PivotGridControl();
this.colDepartmentName = new DevExpress.XtraPivotGrid.PivotGridField();
this.colRegistrationDate = new DevExpress.XtraPivotGrid.PivotGridField();
this.colServiceUnitName = new DevExpress.XtraPivotGrid.PivotGridField();
this.colBusinessPartnerName = new DevExpress.XtraPivotGrid.PivotGridField();
this.colParamedicName = new DevExpress.XtraPivotGrid.PivotGridField();
this.colRegistrationNo = new DevExpress.XtraPivotGrid.PivotGridField();
this.colNoSEP = new DevExpress.XtraPivotGrid.PivotGridField();
this.colMRN = new DevExpress.XtraPivotGrid.PivotGridField();
this.colServiceAmount = new DevExpress.XtraPivotGrid.PivotGridField();
this.colDrugSuppliesAmount = new DevExpress.XtraPivotGrid.PivotGridField();
this.colPharmacyAmount = new DevExpress.XtraPivotGrid.PivotGridField();
this.colLaboratoryAmount = new DevExpress.XtraPivotGrid.PivotGridField();
this.colOtherDiagnosticAmount = new DevExpress.XtraPivotGrid.PivotGridField();
this.colTransactionAmount = new DevExpress.XtraPivotGrid.PivotGridField();
this.colCashAmount = new DevExpress.XtraPivotGrid.PivotGridField();
this.colDebitCardAmount = new DevExpress.XtraPivotGrid.PivotGridField();
this.colCreditCardAmount = new DevExpress.XtraPivotGrid.PivotGridField();
this.colPersonalARAmount = new DevExpress.XtraPivotGrid.PivotGridField();
this.colPayerARAmount = new DevExpress.XtraPivotGrid.PivotGridField();
this.colPaymentAmount = new DevExpress.XtraPivotGrid.PivotGridField();
this.colDateYear = new DevExpress.XtraPivotGrid.PivotGridField();
this.colDateMonth = new DevExpress.XtraPivotGrid.PivotGridField();
this.colDateMonthWeek = new DevExpress.XtraPivotGrid.PivotGridField();
this.colPayerType = new DevExpress.XtraPivotGrid.PivotGridField();
this.colFinalDiscount = new DevExpress.XtraPivotGrid.PivotGridField();
this.colBillingTransferAmount = new DevExpress.XtraPivotGrid.PivotGridField();
((System.ComponentModel.ISupportInitialize)(this.pvGrid)).BeginInit();
this.SuspendLayout();
//
// colOutstandingAmount
//
this.colOutstandingAmount.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.colOutstandingAmount.Appearance.Cell.Options.UseTextOptions = true;
this.colOutstandingAmount.Appearance.Cell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
this.colOutstandingAmount.Appearance.CellGrandTotal.Options.UseTextOptions = true;
this.colOutstandingAmount.Appearance.CellGrandTotal.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
this.colOutstandingAmount.Appearance.CellTotal.Options.UseTextOptions = true;
this.colOutstandingAmount.Appearance.CellTotal.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
this.colOutstandingAmount.Appearance.Header.Options.UseTextOptions = true;
this.colOutstandingAmount.Appearance.Header.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
this.colOutstandingAmount.Appearance.Value.Options.UseTextOptions = true;
this.colOutstandingAmount.Appearance.Value.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
this.colOutstandingAmount.Appearance.ValueGrandTotal.Options.UseTextOptions = true;
this.colOutstandingAmount.Appearance.ValueGrandTotal.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
this.colOutstandingAmount.Appearance.ValueTotal.Options.UseTextOptions = true;
this.colOutstandingAmount.Appearance.ValueTotal.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
this.colOutstandingAmount.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.colOutstandingAmount.AreaIndex = 3;
this.colOutstandingAmount.Caption = "Sisa Tagihan";
this.colOutstandingAmount.CellFormat.FormatString = "N2";
this.colOutstandingAmount.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.colOutstandingAmount.FieldName = "OutstandingAmount";
this.colOutstandingAmount.Name = "colOutstandingAmount";
//
// pvGrid
//
this.pvGrid.Appearance.FieldValueTotal.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Bold);
this.pvGrid.Appearance.FieldValueTotal.Options.UseFont = true;
this.pvGrid.Appearance.GrandTotalCell.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Bold);
this.pvGrid.Appearance.GrandTotalCell.Options.UseFont = true;
this.pvGrid.Appearance.TotalCell.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Bold);
this.pvGrid.Appearance.TotalCell.Options.UseFont = true;
this.pvGrid.Dock = System.Windows.Forms.DockStyle.Fill;
this.pvGrid.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.colDepartmentName,
this.colRegistrationDate,
this.colServiceUnitName,
this.colBusinessPartnerName,
this.colParamedicName,
this.colRegistrationNo,
this.colNoSEP,
this.colMRN,
this.colServiceAmount,
this.colDrugSuppliesAmount,
this.colPharmacyAmount,
this.colLaboratoryAmount,
this.colOtherDiagnosticAmount,
this.colTransactionAmount,
this.colCashAmount,
this.colDebitCardAmount,
this.colCreditCardAmount,
this.colPersonalARAmount,
this.colPayerARAmount,
this.colPaymentAmount,
this.colOutstandingAmount,
this.colDateYear,
this.colDateMonth,
this.colDateMonthWeek,
this.colPayerType,
this.colFinalDiscount,
this.colBillingTransferAmount});
pivotGridStyleFormatCondition1.Appearance.ForeColor = System.Drawing.Color.Red;
pivotGridStyleFormatCondition1.Appearance.Options.UseForeColor = true;
pivotGridStyleFormatCondition1.Expression = "[OutstandingAmount] > 0";
pivotGridStyleFormatCondition1.Field = this.colOutstandingAmount;
pivotGridStyleFormatCondition1.FieldName = "colOutstandingAmount";
this.pvGrid.FormatConditions.AddRange(new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition[] {
pivotGridStyleFormatCondition1});
this.pvGrid.Location = new System.Drawing.Point(0, 0);
this.pvGrid.Name = "pvGrid";
this.pvGrid.OptionsPrint.PrintColumnHeaders = DevExpress.Utils.DefaultBoolean.True;
this.pvGrid.OptionsPrint.PrintDataHeaders = DevExpress.Utils.DefaultBoolean.False;
this.pvGrid.OptionsPrint.PrintFilterHeaders = DevExpress.Utils.DefaultBoolean.True;
this.pvGrid.OptionsPrint.PrintUnusedFilterFields = false;
this.pvGrid.Size = new System.Drawing.Size(649, 400);
this.pvGrid.TabIndex = 5;
//
// colDepartmentName
//
this.colDepartmentName.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.colDepartmentName.AreaIndex = 0;
this.colDepartmentName.Caption = "Departemen";
this.colDepartmentName.FieldName = "DepartmentName";
this.colDepartmentName.Name = "colDepartmentName";
//
// colRegistrationDate
//
this.colRegistrationDate.Appearance.Cell.Options.UseTextOptions = true;
this.colRegistrationDate.Appearance.Cell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.colRegistrationDate.Appearance.Header.Options.UseTextOptions = true;
this.colRegistrationDate.Appearance.Header.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.colRegistrationDate.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.colRegistrationDate.AreaIndex = 2;
this.colRegistrationDate.Caption = "Tanggal";
this.colRegistrationDate.CellFormat.FormatString = "d";
this.colRegistrationDate.CellFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
this.colRegistrationDate.FieldName = "RegistrationDateInString";
this.colRegistrationDate.Name = "colRegistrationDate";
//
// colServiceUnitName
//
this.colServiceUnitName.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.colServiceUnitName.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.colServiceUnitName.AreaIndex = 1;
this.colServiceUnitName.Caption = "Unit Pelayanan";
this.colServiceUnitName.FieldName = "ServiceUnitName";
this.colServiceUnitName.Name = "colServiceUnitName";
this.colServiceUnitName.Width = 200;
//
// colBusinessPartnerName
//
this.colBusinessPartnerName.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.colBusinessPartnerName.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.colBusinessPartnerName.AreaIndex = 5;
this.colBusinessPartnerName.Caption = "Penjamin";
this.colBusinessPartnerName.FieldName = "PayerName";
this.colBusinessPartnerName.Name = "colBusinessPartnerName";
//
// colParamedicName
//
this.colParamedicName.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.colParamedicName.AreaIndex = 0;
this.colParamedicName.Caption = "Dokter/Tenaga Medis";
this.colParamedicName.FieldName = "ParamedicName";
this.colParamedicName.Name = "colParamedicName";
this.colParamedicName.Width = 200;
//
// colRegistrationNo
//
this.colRegistrationNo.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea;
this.colRegistrationNo.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.colRegistrationNo.AreaIndex = 3;
this.colRegistrationNo.Caption = "Nomor Registrasi";
this.colRegistrationNo.FieldName = "RegistrationNo";
this.colRegistrationNo.Name = "colRegistrationNo";
this.colRegistrationNo.Width = 120;
//
// colNoSEP
//
this.colNoSEP.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea;
this.colNoSEP.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.colNoSEP.AreaIndex = 4;
this.colNoSEP.Caption = "No. SEP";
this.colNoSEP.FieldName = "NoSEP";
this.colNoSEP.Name = "colNoSEP";
this.colNoSEP.Visible = false;
this.colNoSEP.Width = 120;
//
// colMRN
//
this.colMRN.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.colMRN.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.colMRN.AreaIndex = 4;
this.colMRN.Caption = "Pasien";
this.colMRN.FieldName = "MRN";
this.colMRN.Name = "colMRN";
this.colMRN.Width = 250;
//
// colServiceAmount
//
this.colServiceAmount.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.colServiceAmount.Appearance.Cell.Options.UseTextOptions = true;
this.colServiceAmount.Appearance.Cell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
this.colServiceAmount.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.colServiceAmount.AreaIndex = 3;
this.colServiceAmount.Caption = "Pelayanan";
this.colServiceAmount.CellFormat.FormatString = "N2";
this.colServiceAmount.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.colServiceAmount.FieldName = "ServiceAmount";
this.colServiceAmount.Name = "colServiceAmount";
this.colServiceAmount.Visible = false;
this.colServiceAmount.Width = 110;
//
// colDrugSuppliesAmount
//
this.colDrugSuppliesAmount.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.colDrugSuppliesAmount.Appearance.Cell.Options.UseTextOptions = true;
this.colDrugSuppliesAmount.Appearance.Cell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
this.colDrugSuppliesAmount.Appearance.Header.Options.UseTextOptions = true;
this.colDrugSuppliesAmount.Appearance.Header.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
this.colDrugSuppliesAmount.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.colDrugSuppliesAmount.AreaIndex = 3;
this.colDrugSuppliesAmount.Caption = "Obat dan BHP";
this.colDrugSuppliesAmount.CellFormat.FormatString = "N2";
this.colDrugSuppliesAmount.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.colDrugSuppliesAmount.FieldName = "DrugSuppliesAmount";
this.colDrugSuppliesAmount.Name = "colDrugSuppliesAmount";
this.colDrugSuppliesAmount.Visible = false;
//
// colPharmacyAmount
//
this.colPharmacyAmount.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.colPharmacyAmount.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.colPharmacyAmount.AreaIndex = 2;
this.colPharmacyAmount.Caption = "Resep";
this.colPharmacyAmount.CellFormat.FormatString = "N2";
this.colPharmacyAmount.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.colPharmacyAmount.FieldName = "PharmacyAmount";
this.colPharmacyAmount.Name = "colPharmacyAmount";
this.colPharmacyAmount.Visible = false;
//
// colLaboratoryAmount
//
this.colLaboratoryAmount.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.colLaboratoryAmount.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.colLaboratoryAmount.AreaIndex = 3;
this.colLaboratoryAmount.Caption = "Laboratorium";
this.colLaboratoryAmount.CellFormat.FormatString = "N2";
this.colLaboratoryAmount.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.colLaboratoryAmount.FieldName = "LaboratoryAmount";
this.colLaboratoryAmount.Name = "colLaboratoryAmount";
this.colLaboratoryAmount.Visible = false;
//
// colOtherDiagnosticAmount
//
this.colOtherDiagnosticAmount.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.colOtherDiagnosticAmount.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.colOtherDiagnosticAmount.AreaIndex = 3;
this.colOtherDiagnosticAmount.Caption = "Penunjang Medis";
this.colOtherDiagnosticAmount.CellFormat.FormatString = "N2";
this.colOtherDiagnosticAmount.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.colOtherDiagnosticAmount.FieldName = "OtherDiagnosticAmount";
this.colOtherDiagnosticAmount.Name = "colOtherDiagnosticAmount";
this.colOtherDiagnosticAmount.Visible = false;
//
// colTransactionAmount
//
this.colTransactionAmount.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.colTransactionAmount.Appearance.Cell.Options.UseTextOptions = true;
this.colTransactionAmount.Appearance.Cell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
this.colTransactionAmount.Appearance.CellGrandTotal.Options.UseTextOptions = true;
this.colTransactionAmount.Appearance.CellGrandTotal.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
this.colTransactionAmount.Appearance.CellTotal.Options.UseTextOptions = true;
this.colTransactionAmount.Appearance.CellTotal.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
this.colTransactionAmount.Appearance.Header.Options.UseTextOptions = true;
this.colTransactionAmount.Appearance.Header.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
this.colTransactionAmount.Appearance.Value.Options.UseTextOptions = true;
this.colTransactionAmount.Appearance.Value.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
this.colTransactionAmount.Appearance.ValueGrandTotal.Options.UseTextOptions = true;
this.colTransactionAmount.Appearance.ValueGrandTotal.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
this.colTransactionAmount.Appearance.ValueTotal.Options.UseTextOptions = true;
this.colTransactionAmount.Appearance.ValueTotal.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
this.colTransactionAmount.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.colTransactionAmount.AreaIndex = 0;
this.colTransactionAmount.Caption = "Tagihan";
this.colTransactionAmount.CellFormat.FormatString = "N2";
this.colTransactionAmount.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.colTransactionAmount.FieldName = "TransactionAmount";
this.colTransactionAmount.Name = "colTransactionAmount";
//
// colCashAmount
//
this.colCashAmount.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.colCashAmount.Appearance.Cell.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Bold);
this.colCashAmount.Appearance.Cell.Options.UseFont = true;
this.colCashAmount.Appearance.Header.Options.UseTextOptions = true;
this.colCashAmount.Appearance.Header.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
this.colCashAmount.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.colCashAmount.AreaIndex = 3;
this.colCashAmount.Caption = "Cash";
this.colCashAmount.CellFormat.FormatString = "N2";
this.colCashAmount.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.colCashAmount.FieldName = "CashAmount";
this.colCashAmount.Name = "colCashAmount";
this.colCashAmount.Visible = false;
//
// colDebitCardAmount
//
this.colDebitCardAmount.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.colDebitCardAmount.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.colDebitCardAmount.AreaIndex = 3;
this.colDebitCardAmount.Caption = "Debit Card";
this.colDebitCardAmount.CellFormat.FormatString = "N2";
this.colDebitCardAmount.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.colDebitCardAmount.FieldName = "DebitCardAmount";
this.colDebitCardAmount.Name = "colDebitCardAmount";
this.colDebitCardAmount.Visible = false;
//
// colCreditCardAmount
//
this.colCreditCardAmount.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.colCreditCardAmount.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.colCreditCardAmount.AreaIndex = 3;
this.colCreditCardAmount.Caption = "Credit Card";
this.colCreditCardAmount.CellFormat.FormatString = "N2";
this.colCreditCardAmount.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.colCreditCardAmount.FieldName = "CreditCardAmount";
this.colCreditCardAmount.Name = "colCreditCardAmount";
this.colCreditCardAmount.Visible = false;
//
// colPersonalARAmount
//
this.colPersonalARAmount.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.colPersonalARAmount.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.colPersonalARAmount.AreaIndex = 3;
this.colPersonalARAmount.Caption = "Piutang Pribadi";
this.colPersonalARAmount.CellFormat.FormatString = "N2";
this.colPersonalARAmount.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.colPersonalARAmount.FieldName = "PersonalARAmount";
this.colPersonalARAmount.Name = "colPersonalARAmount";
this.colPersonalARAmount.Visible = false;
//
// colPayerARAmount
//
this.colPayerARAmount.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.colPayerARAmount.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.colPayerARAmount.AreaIndex = 3;
this.colPayerARAmount.Caption = "Piutang Instansi";
this.colPayerARAmount.CellFormat.FormatString = "N2";
this.colPayerARAmount.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.colPayerARAmount.FieldName = "PayerARAmount";
this.colPayerARAmount.Name = "colPayerARAmount";
this.colPayerARAmount.Visible = false;
//
// colPaymentAmount
//
this.colPaymentAmount.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.colPaymentAmount.Appearance.Cell.Options.UseTextOptions = true;
this.colPaymentAmount.Appearance.Cell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
this.colPaymentAmount.Appearance.CellGrandTotal.Options.UseTextOptions = true;
this.colPaymentAmount.Appearance.CellGrandTotal.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
this.colPaymentAmount.Appearance.CellTotal.Options.UseTextOptions = true;
this.colPaymentAmount.Appearance.CellTotal.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
this.colPaymentAmount.Appearance.Header.Options.UseTextOptions = true;
this.colPaymentAmount.Appearance.Header.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
this.colPaymentAmount.Appearance.Value.Options.UseTextOptions = true;
this.colPaymentAmount.Appearance.Value.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
this.colPaymentAmount.Appearance.ValueGrandTotal.Options.UseTextOptions = true;
this.colPaymentAmount.Appearance.ValueGrandTotal.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
this.colPaymentAmount.Appearance.ValueTotal.Options.UseTextOptions = true;
this.colPaymentAmount.Appearance.ValueTotal.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
this.colPaymentAmount.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.colPaymentAmount.AreaIndex = 1;
this.colPaymentAmount.Caption = "Pembayaran";
this.colPaymentAmount.CellFormat.FormatString = "N2";
this.colPaymentAmount.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.colPaymentAmount.FieldName = "PaymentAmount";
this.colPaymentAmount.Name = "colPaymentAmount";
//
// colDateYear
//
this.colDateYear.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.colDateYear.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.colDateYear.Caption = "Tahun";
this.colDateYear.FieldName = "TransactionDate";
this.colDateYear.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateYear;
this.colDateYear.Name = "colDateYear";
this.colDateYear.UnboundFieldName = "colDateYear";
this.colDateYear.Visible = false;
//
// colDateMonth
//
this.colDateMonth.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.colDateMonth.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.colDateMonth.Caption = "Bulan";
this.colDateMonth.FieldName = "TransactionDate";
this.colDateMonth.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateMonth;
this.colDateMonth.Name = "colDateMonth";
this.colDateMonth.UnboundFieldName = "colDateMonth";
this.colDateMonth.Visible = false;
//
// colDateMonthWeek
//
this.colDateMonthWeek.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.colDateMonthWeek.Caption = "Minggu";
this.colDateMonthWeek.FieldName = "TransactionDate";
this.colDateMonthWeek.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateWeekOfMonth;
this.colDateMonthWeek.Name = "colDateMonthWeek";
this.colDateMonthWeek.UnboundFieldName = "colMonthWeek";
this.colDateMonthWeek.Visible = false;
//
// colPayerType
//
this.colPayerType.AllowedAreas = ((DevExpress.XtraPivotGrid.PivotGridAllowedAreas)(((DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea | DevExpress.XtraPivotGrid.PivotGridAllowedAreas.ColumnArea)
| DevExpress.XtraPivotGrid.PivotGridAllowedAreas.FilterArea)));
this.colPayerType.AreaIndex = 1;
this.colPayerType.Caption = "Tipe Penjamin";
this.colPayerType.FieldName = "PayerType";
this.colPayerType.Name = "colPayerType";
//
// colFinalDiscount
//
this.colFinalDiscount.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.colFinalDiscount.Appearance.Cell.Options.UseTextOptions = true;
this.colFinalDiscount.Appearance.Cell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
this.colFinalDiscount.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.colFinalDiscount.AreaIndex = 2;
this.colFinalDiscount.Caption = "Diskon Tagihan";
this.colFinalDiscount.CellFormat.FormatString = "n2";
this.colFinalDiscount.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.colFinalDiscount.FieldName = "FinalDiscount";
this.colFinalDiscount.Name = "colFinalDiscount";
//
// colBillingTransferAmount
//
this.colBillingTransferAmount.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.DataArea;
this.colBillingTransferAmount.Appearance.Cell.Options.UseTextOptions = true;
this.colBillingTransferAmount.Appearance.Cell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
this.colBillingTransferAmount.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.colBillingTransferAmount.Caption = "Transfer Rawat Inap";
this.colBillingTransferAmount.CellFormat.FormatString = "n2";
this.colBillingTransferAmount.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.colBillingTransferAmount.FieldName = "BillingTransferAmount";
this.colBillingTransferAmount.Name = "colBillingTransferAmount";
this.colBillingTransferAmount.Visible = false;
//
// PivotOutpatientPayment1Ctl
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.AutoSize = true;
this.Controls.Add(this.pvGrid);
this.Name = "PivotOutpatientPayment1Ctl";
this.Size = new System.Drawing.Size(649, 400);
((System.ComponentModel.ISupportInitialize)(this.pvGrid)).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.PivotGridStyleFormatCondition pivotGridStyleFormatCondition2 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition3 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition4 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition5 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition6 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition7 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition8 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
this.calcCases = new DevExpress.XtraPivotGrid.PivotGridField();
this.calcNPS = new DevExpress.XtraPivotGrid.PivotGridField();
this.calcVolume = new DevExpress.XtraPivotGrid.PivotGridField();
this.calcPPL = new DevExpress.XtraPivotGrid.PivotGridField();
this.repositoryItemTextEditf2 = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit();
this.repositoryItemTextEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit();
this.popupMenuMain = new DevExpress.XtraBars.PopupMenu(this.components);
this.barManagerMain = new DevExpress.XtraBars.BarManager(this.components);
this.bar1 = new DevExpress.XtraBars.Bar();
this.barHeaderItem1 = new DevExpress.XtraBars.BarHeaderItem();
this.bbiStartDate = new DevExpress.XtraBars.BarEditItem();
this.repositoryItemDateEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit();
this.barHeaderItem2 = new DevExpress.XtraBars.BarHeaderItem();
this.bbiEndDate = new DevExpress.XtraBars.BarEditItem();
this.repositoryItemDateEdit3 = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit();
this.bbiGetData = new DevExpress.XtraBars.BarLargeButtonItem();
this.bbiExport = new DevExpress.XtraBars.BarButtonItem();
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.repositoryItemDateEdit2 = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit();
this.dxValidationProviderMain = new DevExpress.XtraEditors.DXErrorProvider.DXValidationProvider(this.components);
this.pivotGridControlMain = new DevExpress.XtraPivotGrid.PivotGridControl();
this.pro0004BindingSource = new System.Windows.Forms.BindingSource(this.components);
this.dsNMQry = new NestleICSales.DataSources.dsQry();
this.fieldMaterialNumber1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldTypeName1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldDistributionChannel1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldMaterialName1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldProductBase1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldBrand1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldProductGroup31 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldProductGroup21 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldProductGroup11 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldPriceChanges1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldPricePointRang1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldMaterialType1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldFlavor1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldNPDS1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldPricePoint1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCases1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldNPS1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldVolume1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldPPL1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldYearNo = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCustHierLevel3Name = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCustomerGroup = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCustomerType = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCustomerType2 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldRouteNumber = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldSubchannelName = new DevExpress.XtraPivotGrid.PivotGridField();
this.repositoryItemTextEditPer = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit();
this.pro_0004TableAdapter = new NestleICSales.DataSources.dsQryTableAdapters.Pro_0004TableAdapter();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditf2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEdit1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.popupMenuMain)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.barManagerMain)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1.CalendarTimeProperties)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit3)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit3.CalendarTimeProperties)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2.CalendarTimeProperties)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dxValidationProviderMain)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControlMain)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.pro0004BindingSource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dsNMQry)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditPer)).BeginInit();
this.SuspendLayout();
//
// calcCases
//
this.calcCases.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.calcCases.AreaIndex = 1;
this.calcCases.Caption = "Cases%";
this.calcCases.CellFormat.FormatString = "p2";
this.calcCases.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.calcCases.DisplayFolder = "0.0%";
this.calcCases.EmptyCellText = "0.0%";
this.calcCases.FieldName = "Cases";
this.calcCases.GrandTotalCellFormat.FormatString = "p2";
this.calcCases.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.calcCases.Name = "calcCases";
this.calcCases.Options.ShowGrandTotal = false;
this.calcCases.Options.ShowUnboundExpressionMenu = true;
this.calcCases.TotalCellFormat.FormatString = "p2";
this.calcCases.TotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.calcCases.TotalValueFormat.FormatString = "p2";
this.calcCases.TotalValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.calcCases.ValueFormat.FormatString = "p2";
this.calcCases.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
//
// calcNPS
//
this.calcNPS.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.calcNPS.AreaIndex = 3;
this.calcNPS.Caption = "NPS%";
this.calcNPS.CellFormat.FormatString = "p2";
this.calcNPS.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.calcNPS.DisplayFolder = "0.0%";
this.calcNPS.EmptyCellText = "0.0%";
this.calcNPS.FieldName = "NPS";
this.calcNPS.GrandTotalCellFormat.FormatString = "p2";
this.calcNPS.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.calcNPS.Name = "calcNPS";
this.calcNPS.Options.ShowGrandTotal = false;
this.calcNPS.Options.ShowUnboundExpressionMenu = true;
this.calcNPS.TotalCellFormat.FormatString = "p2";
this.calcNPS.TotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.calcNPS.TotalValueFormat.FormatString = "p2";
this.calcNPS.TotalValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.calcNPS.ValueFormat.FormatString = "p2";
this.calcNPS.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
//
// calcVolume
//
this.calcVolume.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.calcVolume.AreaIndex = 5;
this.calcVolume.Caption = "Volume%";
this.calcVolume.CellFormat.FormatString = "p2";
this.calcVolume.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.calcVolume.DisplayFolder = "0.0%";
this.calcVolume.EmptyCellText = "0.0%";
this.calcVolume.FieldName = "Volume";
this.calcVolume.GrandTotalCellFormat.FormatString = "p2";
this.calcVolume.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.calcVolume.Name = "calcVolume";
this.calcVolume.Options.ShowGrandTotal = false;
this.calcVolume.Options.ShowUnboundExpressionMenu = true;
this.calcVolume.TotalCellFormat.FormatString = "p2";
this.calcVolume.TotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.calcVolume.TotalValueFormat.FormatString = "p2";
this.calcVolume.TotalValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.calcVolume.ValueFormat.FormatString = "p2";
this.calcVolume.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
//
// calcPPL
//
this.calcPPL.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.calcPPL.AreaIndex = 7;
this.calcPPL.Caption = "PPL%";
this.calcPPL.CellFormat.FormatString = "p2";
this.calcPPL.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.calcPPL.DisplayFolder = "0.0%";
this.calcPPL.EmptyCellText = "0.0%";
this.calcPPL.FieldName = "PPL";
this.calcPPL.GrandTotalCellFormat.FormatString = "p2";
this.calcPPL.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.calcPPL.Name = "calcPPL";
this.calcPPL.Options.ShowGrandTotal = false;
this.calcPPL.Options.ShowUnboundExpressionMenu = true;
this.calcPPL.TotalCellFormat.FormatString = "p2";
this.calcPPL.TotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.calcPPL.TotalValueFormat.FormatString = "p2";
this.calcPPL.TotalValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.calcPPL.ValueFormat.FormatString = "p2";
this.calcPPL.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
//
// repositoryItemTextEditf2
//
this.repositoryItemTextEditf2.AutoHeight = false;
this.repositoryItemTextEditf2.DisplayFormat.FormatString = "f2";
this.repositoryItemTextEditf2.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.repositoryItemTextEditf2.Mask.EditMask = "f2";
this.repositoryItemTextEditf2.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
this.repositoryItemTextEditf2.Name = "repositoryItemTextEditf2";
//
// repositoryItemTextEdit1
//
this.repositoryItemTextEdit1.AutoHeight = false;
this.repositoryItemTextEdit1.Name = "repositoryItemTextEdit1";
//
// popupMenuMain
//
this.popupMenuMain.Manager = this.barManagerMain;
this.popupMenuMain.Name = "popupMenuMain";
//
// barManagerMain
//
this.barManagerMain.Bars.AddRange(new DevExpress.XtraBars.Bar[] {
this.bar1});
this.barManagerMain.DockControls.Add(this.barDockControlTop);
this.barManagerMain.DockControls.Add(this.barDockControlBottom);
this.barManagerMain.DockControls.Add(this.barDockControlLeft);
this.barManagerMain.DockControls.Add(this.barDockControlRight);
this.barManagerMain.Form = this;
this.barManagerMain.Items.AddRange(new DevExpress.XtraBars.BarItem[] {
this.bbiExport,
this.bbiStartDate,
this.barHeaderItem1,
this.bbiGetData,
this.barHeaderItem2,
this.bbiEndDate});
this.barManagerMain.MaxItemId = 13;
this.barManagerMain.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] {
this.repositoryItemDateEdit1,
this.repositoryItemDateEdit2,
this.repositoryItemDateEdit3});
//
// bar1
//
this.bar1.BarName = "Main";
this.bar1.DockCol = 0;
this.bar1.DockRow = 0;
this.bar1.DockStyle = DevExpress.XtraBars.BarDockStyle.Top;
this.bar1.LinksPersistInfo.AddRange(new DevExpress.XtraBars.LinkPersistInfo[] {
new DevExpress.XtraBars.LinkPersistInfo(this.barHeaderItem1),
new DevExpress.XtraBars.LinkPersistInfo(this.bbiStartDate),
new DevExpress.XtraBars.LinkPersistInfo(this.barHeaderItem2),
new DevExpress.XtraBars.LinkPersistInfo(this.bbiEndDate),
new DevExpress.XtraBars.LinkPersistInfo(DevExpress.XtraBars.BarLinkUserDefines.PaintStyle, this.bbiGetData, DevExpress.XtraBars.BarItemPaintStyle.CaptionGlyph),
new DevExpress.XtraBars.LinkPersistInfo(this.bbiExport)});
this.bar1.Text = "Custom 2";
//
// barHeaderItem1
//
this.barHeaderItem1.Caption = "Select Date";
this.barHeaderItem1.Id = 3;
this.barHeaderItem1.Name = "barHeaderItem1";
//
// bbiStartDate
//
this.bbiStartDate.Caption = "Date Start";
this.bbiStartDate.Edit = this.repositoryItemDateEdit1;
this.bbiStartDate.Id = 2;
this.bbiStartDate.ItemShortcut = new DevExpress.XtraBars.BarShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.D1));
this.bbiStartDate.Name = "bbiStartDate";
this.bbiStartDate.Width = 120;
//
// 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";
//
// barHeaderItem2
//
this.barHeaderItem2.Caption = "End Date";
this.barHeaderItem2.Id = 11;
this.barHeaderItem2.Name = "barHeaderItem2";
//
// bbiEndDate
//
this.bbiEndDate.Caption = "Date End";
this.bbiEndDate.Edit = this.repositoryItemDateEdit3;
this.bbiEndDate.Id = 12;
this.bbiEndDate.ItemShortcut = new DevExpress.XtraBars.BarShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.D2));
this.bbiEndDate.Name = "bbiEndDate";
this.bbiEndDate.Width = 120;
//
// repositoryItemDateEdit3
//
this.repositoryItemDateEdit3.AutoHeight = false;
this.repositoryItemDateEdit3.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
this.repositoryItemDateEdit3.CalendarTimeProperties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
this.repositoryItemDateEdit3.Name = "repositoryItemDateEdit3";
//
// bbiGetData
//
this.bbiGetData.Caption = "Get Data";
this.bbiGetData.CaptionAlignment = DevExpress.XtraBars.BarItemCaptionAlignment.Right;
this.bbiGetData.Glyph = global::NestleICSales.Properties.Resources.apply_16x16;
this.bbiGetData.Id = 9;
this.bbiGetData.ItemShortcut = new DevExpress.XtraBars.BarShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.G));
this.bbiGetData.Name = "bbiGetData";
this.bbiGetData.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.bbiGetData_ItemClick);
//
// bbiExport
//
this.bbiExport.Caption = "Export";
this.bbiExport.Glyph = global::NestleICSales.Properties.Resources.Export;
this.bbiExport.Id = 1;
this.bbiExport.ItemShortcut = new DevExpress.XtraBars.BarShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.E));
this.bbiExport.Name = "bbiExport";
this.bbiExport.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.bbiExport_ItemClick);
//
// 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(1132, 31);
//
// barDockControlBottom
//
this.barDockControlBottom.CausesValidation = false;
this.barDockControlBottom.Dock = System.Windows.Forms.DockStyle.Bottom;
this.barDockControlBottom.Location = new System.Drawing.Point(0, 311);
this.barDockControlBottom.Size = new System.Drawing.Size(1132, 0);
//
// barDockControlLeft
//
this.barDockControlLeft.CausesValidation = false;
this.barDockControlLeft.Dock = System.Windows.Forms.DockStyle.Left;
this.barDockControlLeft.Location = new System.Drawing.Point(0, 31);
this.barDockControlLeft.Size = new System.Drawing.Size(0, 280);
//
// barDockControlRight
//
this.barDockControlRight.CausesValidation = false;
this.barDockControlRight.Dock = System.Windows.Forms.DockStyle.Right;
this.barDockControlRight.Location = new System.Drawing.Point(1132, 31);
this.barDockControlRight.Size = new System.Drawing.Size(0, 280);
//
// repositoryItemDateEdit2
//
this.repositoryItemDateEdit2.AutoHeight = false;
this.repositoryItemDateEdit2.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
this.repositoryItemDateEdit2.CalendarTimeProperties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
this.repositoryItemDateEdit2.Name = "repositoryItemDateEdit2";
//
// pivotGridControlMain
//
this.pivotGridControlMain.DataSource = this.pro0004BindingSource;
this.pivotGridControlMain.Dock = System.Windows.Forms.DockStyle.Fill;
this.pivotGridControlMain.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.fieldMaterialNumber1,
this.fieldTypeName1,
this.fieldDistributionChannel1,
this.fieldMaterialName1,
this.fieldProductBase1,
this.fieldBrand1,
this.fieldProductGroup31,
this.fieldProductGroup21,
this.fieldProductGroup11,
this.fieldPriceChanges1,
this.fieldPricePointRang1,
this.fieldMaterialType1,
this.fieldFlavor1,
this.fieldNPDS1,
this.fieldPricePoint1,
this.fieldCases1,
this.fieldNPS1,
this.fieldVolume1,
this.fieldPPL1,
this.calcCases,
this.calcNPS,
this.calcVolume,
this.calcPPL,
this.fieldYearNo,
this.fieldCustHierLevel3Name,
this.fieldCustomerGroup,
this.fieldCustomerType,
this.fieldCustomerType2,
this.fieldRouteNumber,
this.fieldSubchannelName});
pivotGridStyleFormatCondition1.Appearance.ForeColor = System.Drawing.Color.Red;
pivotGridStyleFormatCondition1.Appearance.Options.UseForeColor = true;
pivotGridStyleFormatCondition1.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less;
pivotGridStyleFormatCondition1.Field = this.calcCases;
pivotGridStyleFormatCondition1.FieldName = "calcCases";
pivotGridStyleFormatCondition1.Value1 = "1";
pivotGridStyleFormatCondition2.Appearance.ForeColor = System.Drawing.Color.Green;
pivotGridStyleFormatCondition2.Appearance.Options.UseForeColor = true;
pivotGridStyleFormatCondition2.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual;
pivotGridStyleFormatCondition2.Field = this.calcCases;
pivotGridStyleFormatCondition2.FieldName = "calcCases";
pivotGridStyleFormatCondition2.Value1 = "1";
pivotGridStyleFormatCondition3.Appearance.ForeColor = System.Drawing.Color.Red;
pivotGridStyleFormatCondition3.Appearance.Options.UseForeColor = true;
pivotGridStyleFormatCondition3.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less;
pivotGridStyleFormatCondition3.Field = this.calcNPS;
pivotGridStyleFormatCondition3.FieldName = "calcNPS";
pivotGridStyleFormatCondition3.Value1 = "1";
pivotGridStyleFormatCondition4.Appearance.ForeColor = System.Drawing.Color.Green;
pivotGridStyleFormatCondition4.Appearance.Options.UseForeColor = true;
pivotGridStyleFormatCondition4.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual;
pivotGridStyleFormatCondition4.Field = this.calcNPS;
pivotGridStyleFormatCondition4.FieldName = "calcNPS";
pivotGridStyleFormatCondition4.Value1 = "1";
pivotGridStyleFormatCondition5.Appearance.ForeColor = System.Drawing.Color.Red;
pivotGridStyleFormatCondition5.Appearance.Options.UseForeColor = true;
pivotGridStyleFormatCondition5.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less;
pivotGridStyleFormatCondition5.Field = this.calcVolume;
pivotGridStyleFormatCondition5.FieldName = "calcVolume";
pivotGridStyleFormatCondition5.Value1 = "1";
pivotGridStyleFormatCondition6.Appearance.ForeColor = System.Drawing.Color.Green;
pivotGridStyleFormatCondition6.Appearance.Options.UseForeColor = true;
pivotGridStyleFormatCondition6.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual;
pivotGridStyleFormatCondition6.Field = this.calcVolume;
pivotGridStyleFormatCondition6.FieldName = "calcVolume";
pivotGridStyleFormatCondition6.Value1 = "1";
pivotGridStyleFormatCondition7.Appearance.ForeColor = System.Drawing.Color.Red;
pivotGridStyleFormatCondition7.Appearance.Options.UseForeColor = true;
pivotGridStyleFormatCondition7.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less;
pivotGridStyleFormatCondition7.Field = this.calcPPL;
pivotGridStyleFormatCondition7.FieldName = "calcPPL";
pivotGridStyleFormatCondition7.Value1 = "1";
pivotGridStyleFormatCondition8.Appearance.ForeColor = System.Drawing.Color.Green;
pivotGridStyleFormatCondition8.Appearance.Options.UseForeColor = true;
pivotGridStyleFormatCondition8.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual;
pivotGridStyleFormatCondition8.Field = this.calcPPL;
pivotGridStyleFormatCondition8.FieldName = "calcPPL";
pivotGridStyleFormatCondition8.Value1 = "1";
this.pivotGridControlMain.FormatConditions.AddRange(new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition[] {
pivotGridStyleFormatCondition1,
pivotGridStyleFormatCondition2,
pivotGridStyleFormatCondition3,
pivotGridStyleFormatCondition4,
pivotGridStyleFormatCondition5,
pivotGridStyleFormatCondition6,
pivotGridStyleFormatCondition7,
pivotGridStyleFormatCondition8});
this.pivotGridControlMain.Location = new System.Drawing.Point(0, 31);
this.pivotGridControlMain.Name = "pivotGridControlMain";
this.pivotGridControlMain.OptionsData.DataFieldUnboundExpressionMode = DevExpress.XtraPivotGrid.DataFieldUnboundExpressionMode.UseSummaryValues;
this.pivotGridControlMain.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] {
this.repositoryItemTextEditPer});
this.pivotGridControlMain.Size = new System.Drawing.Size(1132, 280);
this.pivotGridControlMain.TabIndex = 14;
this.pivotGridControlMain.CustomCellValue += new System.EventHandler<DevExpress.XtraPivotGrid.PivotCellValueEventArgs>(this.pivotGridControlMain_CustomCellValue);
this.pivotGridControlMain.CellDoubleClick += new DevExpress.XtraPivotGrid.PivotCellEventHandler(this.pivotGridControlMain_CellDoubleClick);
//
// pro0004BindingSource
//
this.pro0004BindingSource.DataMember = "Pro_0004";
this.pro0004BindingSource.DataSource = this.dsNMQry;
//
// dsNMQry
//
this.dsNMQry.DataSetName = "dsNMQry";
this.dsNMQry.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// fieldMaterialNumber1
//
this.fieldMaterialNumber1.AreaIndex = 0;
this.fieldMaterialNumber1.Caption = "Material Number";
this.fieldMaterialNumber1.FieldName = "MaterialNumber";
this.fieldMaterialNumber1.Name = "fieldMaterialNumber1";
//
// fieldTypeName1
//
this.fieldTypeName1.AreaIndex = 1;
this.fieldTypeName1.Caption = "Type Name";
this.fieldTypeName1.FieldName = "TypeName";
this.fieldTypeName1.Name = "fieldTypeName1";
//
// fieldDistributionChannel1
//
this.fieldDistributionChannel1.AreaIndex = 2;
this.fieldDistributionChannel1.Caption = "Distribution Channel";
this.fieldDistributionChannel1.FieldName = "DistributionChannel";
this.fieldDistributionChannel1.Name = "fieldDistributionChannel1";
//
// fieldMaterialName1
//
this.fieldMaterialName1.AreaIndex = 3;
this.fieldMaterialName1.Caption = "Material Name";
this.fieldMaterialName1.FieldName = "MaterialName";
this.fieldMaterialName1.Name = "fieldMaterialName1";
//
// fieldProductBase1
//
this.fieldProductBase1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldProductBase1.AreaIndex = 1;
this.fieldProductBase1.Caption = "Product Base";
this.fieldProductBase1.FieldName = "ProductBase";
this.fieldProductBase1.Name = "fieldProductBase1";
//
// fieldBrand1
//
this.fieldBrand1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldBrand1.AreaIndex = 0;
this.fieldBrand1.Caption = "Brand";
this.fieldBrand1.FieldName = "Brand";
this.fieldBrand1.Name = "fieldBrand1";
this.fieldBrand1.Width = 255;
//
// fieldProductGroup31
//
this.fieldProductGroup31.AreaIndex = 4;
this.fieldProductGroup31.Caption = "Product Group3";
this.fieldProductGroup31.FieldName = "ProductGroup3";
this.fieldProductGroup31.Name = "fieldProductGroup31";
//
// fieldProductGroup21
//
this.fieldProductGroup21.AreaIndex = 5;
this.fieldProductGroup21.Caption = "Product Group2";
this.fieldProductGroup21.FieldName = "ProductGroup2";
this.fieldProductGroup21.Name = "fieldProductGroup21";
//
// fieldProductGroup11
//
this.fieldProductGroup11.AreaIndex = 6;
this.fieldProductGroup11.Caption = "Product Group1";
this.fieldProductGroup11.FieldName = "ProductGroup1";
this.fieldProductGroup11.Name = "fieldProductGroup11";
//
// fieldPriceChanges1
//
this.fieldPriceChanges1.AreaIndex = 7;
this.fieldPriceChanges1.Caption = "Price Changes";
this.fieldPriceChanges1.FieldName = "PriceChanges";
this.fieldPriceChanges1.Name = "fieldPriceChanges1";
//
// fieldPricePointRang1
//
this.fieldPricePointRang1.AreaIndex = 8;
this.fieldPricePointRang1.Caption = "Price Point Rang";
this.fieldPricePointRang1.FieldName = "PricePointRang";
this.fieldPricePointRang1.Name = "fieldPricePointRang1";
//
// fieldMaterialType1
//
this.fieldMaterialType1.AreaIndex = 9;
this.fieldMaterialType1.Caption = "Material Type";
this.fieldMaterialType1.FieldName = "MaterialType";
this.fieldMaterialType1.Name = "fieldMaterialType1";
//
// fieldFlavor1
//
this.fieldFlavor1.AreaIndex = 10;
this.fieldFlavor1.Caption = "Flavor";
this.fieldFlavor1.FieldName = "Flavor";
this.fieldFlavor1.Name = "fieldFlavor1";
//
// fieldNPDS1
//
this.fieldNPDS1.AreaIndex = 11;
this.fieldNPDS1.Caption = "NPDS";
this.fieldNPDS1.FieldName = "NPDS";
this.fieldNPDS1.Name = "fieldNPDS1";
//
// fieldPricePoint1
//
this.fieldPricePoint1.AreaIndex = 12;
this.fieldPricePoint1.Caption = "Price Point";
this.fieldPricePoint1.FieldName = "PricePoint";
this.fieldPricePoint1.Name = "fieldPricePoint1";
//
// fieldCases1
//
this.fieldCases1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldCases1.AreaIndex = 0;
this.fieldCases1.Caption = "Cases";
this.fieldCases1.CellFormat.FormatString = "f2";
this.fieldCases1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldCases1.EmptyCellText = "0.0";
this.fieldCases1.EmptyValueText = "0.0";
this.fieldCases1.FieldName = "Cases";
this.fieldCases1.GrandTotalCellFormat.FormatString = "f2";
this.fieldCases1.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldCases1.Name = "fieldCases1";
this.fieldCases1.Options.ShowGrandTotal = false;
this.fieldCases1.TotalCellFormat.FormatString = "f2";
this.fieldCases1.TotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldCases1.TotalValueFormat.FormatString = "f2";
this.fieldCases1.TotalValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldCases1.ValueFormat.FormatString = "f2";
this.fieldCases1.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
//
// fieldNPS1
//
this.fieldNPS1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldNPS1.AreaIndex = 2;
this.fieldNPS1.Caption = "NPS";
this.fieldNPS1.CellFormat.FormatString = "f2";
this.fieldNPS1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldNPS1.EmptyCellText = "0.0";
this.fieldNPS1.EmptyValueText = "0.0";
this.fieldNPS1.FieldName = "NPS";
this.fieldNPS1.GrandTotalCellFormat.FormatString = "f2";
this.fieldNPS1.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldNPS1.Name = "fieldNPS1";
this.fieldNPS1.Options.ShowGrandTotal = false;
this.fieldNPS1.TotalCellFormat.FormatString = "f2";
this.fieldNPS1.TotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldNPS1.TotalValueFormat.FormatString = "f2";
this.fieldNPS1.TotalValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldNPS1.ValueFormat.FormatString = "f2";
this.fieldNPS1.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
//
// fieldVolume1
//
this.fieldVolume1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldVolume1.AreaIndex = 4;
this.fieldVolume1.Caption = "Volume";
this.fieldVolume1.CellFormat.FormatString = "f2";
this.fieldVolume1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldVolume1.EmptyCellText = "0.0";
this.fieldVolume1.EmptyValueText = "0.0";
this.fieldVolume1.FieldName = "Volume";
this.fieldVolume1.GrandTotalCellFormat.FormatString = "f2";
this.fieldVolume1.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldVolume1.Name = "fieldVolume1";
this.fieldVolume1.Options.ShowGrandTotal = false;
this.fieldVolume1.TotalCellFormat.FormatString = "f2";
this.fieldVolume1.TotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldVolume1.TotalValueFormat.FormatString = "f2";
this.fieldVolume1.TotalValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldVolume1.ValueFormat.FormatString = "f2";
this.fieldVolume1.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
//
// fieldPPL1
//
this.fieldPPL1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldPPL1.AreaIndex = 6;
this.fieldPPL1.Caption = "PPL";
this.fieldPPL1.CellFormat.FormatString = "f2";
this.fieldPPL1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldPPL1.EmptyCellText = "0.0";
this.fieldPPL1.EmptyValueText = "0.0";
this.fieldPPL1.FieldName = "PPL";
this.fieldPPL1.GrandTotalCellFormat.FormatString = "f2";
this.fieldPPL1.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldPPL1.Name = "fieldPPL1";
this.fieldPPL1.Options.ShowGrandTotal = false;
this.fieldPPL1.TotalCellFormat.FormatString = "f2";
this.fieldPPL1.TotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldPPL1.TotalValueFormat.FormatString = "f2";
this.fieldPPL1.TotalValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldPPL1.ValueFormat.FormatString = "f2";
this.fieldPPL1.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
//
// fieldYearNo
//
this.fieldYearNo.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldYearNo.AreaIndex = 0;
this.fieldYearNo.Caption = "Year";
this.fieldYearNo.FieldName = "YearNo";
this.fieldYearNo.Name = "fieldYearNo";
//
// fieldCustHierLevel3Name
//
this.fieldCustHierLevel3Name.AreaIndex = 13;
this.fieldCustHierLevel3Name.Caption = "CustHierLevel3";
this.fieldCustHierLevel3Name.FieldName = "CustHierLevel3Name";
this.fieldCustHierLevel3Name.Name = "fieldCustHierLevel3Name";
//
// fieldCustomerGroup
//
this.fieldCustomerGroup.AreaIndex = 14;
this.fieldCustomerGroup.Caption = "CustomerGroup";
this.fieldCustomerGroup.FieldName = "CustomerGroup";
this.fieldCustomerGroup.Name = "fieldCustomerGroup";
//
// fieldCustomerType
//
this.fieldCustomerType.AreaIndex = 15;
this.fieldCustomerType.Caption = "CustomerType";
this.fieldCustomerType.FieldName = "CustomerType";
this.fieldCustomerType.Name = "fieldCustomerType";
//
// fieldCustomerType2
//
this.fieldCustomerType2.AreaIndex = 16;
this.fieldCustomerType2.Caption = "CustomerType2";
this.fieldCustomerType2.FieldName = "CustomerType2";
this.fieldCustomerType2.Name = "fieldCustomerType2";
//
// fieldRouteNumber
//
this.fieldRouteNumber.AreaIndex = 17;
this.fieldRouteNumber.Caption = "RouteNumber";
this.fieldRouteNumber.FieldName = "RouteNumber";
this.fieldRouteNumber.Name = "fieldRouteNumber";
//
// fieldSubchannelName
//
this.fieldSubchannelName.AreaIndex = 18;
this.fieldSubchannelName.Caption = "Subchannel";
this.fieldSubchannelName.FieldName = "SubchannelName";
this.fieldSubchannelName.Name = "fieldSubchannelName";
//
// repositoryItemTextEditPer
//
this.repositoryItemTextEditPer.AutoHeight = false;
this.repositoryItemTextEditPer.DisplayFormat.FormatString = "c";
this.repositoryItemTextEditPer.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.repositoryItemTextEditPer.Mask.EditMask = "p";
this.repositoryItemTextEditPer.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
this.repositoryItemTextEditPer.Mask.UseMaskAsDisplayFormat = true;
this.repositoryItemTextEditPer.Name = "repositoryItemTextEditPer";
//
// pro_0004TableAdapter
//
this.pro_0004TableAdapter.ClearBeforeFill = true;
//
// QryPro_0004Frm
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(1132, 311);
this.Controls.Add(this.pivotGridControlMain);
this.Controls.Add(this.barDockControlLeft);
this.Controls.Add(this.barDockControlRight);
this.Controls.Add(this.barDockControlBottom);
this.Controls.Add(this.barDockControlTop);
this.Icon = global::NestleICSales.Properties.Resources.Qry16;
this.Name = "QryPro_0004Frm";
this.Text = "Sales Per SKU";
((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditf2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEdit1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.popupMenuMain)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.barManagerMain)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1.CalendarTimeProperties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit3.CalendarTimeProperties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit3)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2.CalendarTimeProperties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dxValidationProviderMain)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControlMain)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.pro0004BindingSource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dsNMQry)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditPer)).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.PivotGridStyleFormatCondition pivotGridStyleFormatCondition2 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition3 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition4 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition5 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition6 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition7 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition8 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition9 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition10 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition11 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition12 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition13 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition14 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition15 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition16 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
this.calcAPOSVsTargetDay = new DevExpress.XtraPivotGrid.PivotGridField();
this.calcAPOSVsTargetMonth = new DevExpress.XtraPivotGrid.PivotGridField();
this.calcINVVsTargetDay = new DevExpress.XtraPivotGrid.PivotGridField();
this.calcINVVsTargetMonth = new DevExpress.XtraPivotGrid.PivotGridField();
this.calcNPSVsTargetDay = new DevExpress.XtraPivotGrid.PivotGridField();
this.calcNPSVsTargetMonth = new DevExpress.XtraPivotGrid.PivotGridField();
this.calcDSVsTargetDay = new DevExpress.XtraPivotGrid.PivotGridField();
this.calcDSVsTargetMonth = new DevExpress.XtraPivotGrid.PivotGridField();
this.repositoryItemTextEditPers = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit();
this.repositoryItemTextEditf2 = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit();
this.repositoryItemTextEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit();
this.popupMenuMain = new DevExpress.XtraBars.PopupMenu(this.components);
this.barManagerMain = new DevExpress.XtraBars.BarManager(this.components);
this.bar1 = new DevExpress.XtraBars.Bar();
this.barHeaderItem1 = new DevExpress.XtraBars.BarHeaderItem();
this.bbiStartDate = new DevExpress.XtraBars.BarEditItem();
this.repositoryItemDateEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit();
this.barHeaderItem2 = new DevExpress.XtraBars.BarHeaderItem();
this.bbiEndDate = new DevExpress.XtraBars.BarEditItem();
this.repositoryItemDateEdit3 = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit();
this.bbiGetData = new DevExpress.XtraBars.BarLargeButtonItem();
this.bbiExport = new DevExpress.XtraBars.BarButtonItem();
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.repositoryItemDateEdit2 = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit();
this.pivotGridControlMain = new DevExpress.XtraPivotGrid.PivotGridControl();
this.pro0001BindingSource = new System.Windows.Forms.BindingSource(this.components);
this.dsNMQry = new NestleICSales.DataSources.dsQry();
this.fieldRouteNumber1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldRouteName1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldSupervisor1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldRouteBrand1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldPlantSalesDistrict1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldPlantName1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldPlantBaseName1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldDistributionChannel1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldAPOSLD = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldTargetAPOSDay = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldAPOS = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldTargetAPOS = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldINVLD = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldTargetINVDay = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldINV = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldTargetINV = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldNPSLD = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldTargetNPSDay = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldNPS = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldTargetNPS = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldDSLD1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldTargetDSDay = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldDS = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldTargetDS = new DevExpress.XtraPivotGrid.PivotGridField();
this.dxValidationProviderMain = new DevExpress.XtraEditors.DXErrorProvider.DXValidationProvider(this.components);
this.pro_0001TableAdapter = new NestleICSales.DataSources.dsQryTableAdapters.Pro_0001TableAdapter();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditPers)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditf2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEdit1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.popupMenuMain)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.barManagerMain)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1.CalendarTimeProperties)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit3)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit3.CalendarTimeProperties)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2.CalendarTimeProperties)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControlMain)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.pro0001BindingSource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dsNMQry)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dxValidationProviderMain)).BeginInit();
this.SuspendLayout();
//
// calcAPOSVsTargetDay
//
this.calcAPOSVsTargetDay.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.calcAPOSVsTargetDay.AreaIndex = 2;
this.calcAPOSVsTargetDay.Caption = "APOS Vs Target LD";
this.calcAPOSVsTargetDay.EmptyCellText = "0";
this.calcAPOSVsTargetDay.EmptyValueText = "0";
this.calcAPOSVsTargetDay.GrandTotalCellFormat.FormatString = "p";
this.calcAPOSVsTargetDay.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.calcAPOSVsTargetDay.Name = "calcAPOSVsTargetDay";
this.calcAPOSVsTargetDay.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Average;
this.calcAPOSVsTargetDay.UnboundExpression = "([APOSLD] * 1.0) / [TargetAPOSDay]";
this.calcAPOSVsTargetDay.UnboundFieldName = "calcAPOSVsTarget";
this.calcAPOSVsTargetDay.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
//
// calcAPOSVsTargetMonth
//
this.calcAPOSVsTargetMonth.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.calcAPOSVsTargetMonth.AreaIndex = 5;
this.calcAPOSVsTargetMonth.Caption = "APOS Vs Target MTD";
this.calcAPOSVsTargetMonth.EmptyCellText = "0";
this.calcAPOSVsTargetMonth.EmptyValueText = "0";
this.calcAPOSVsTargetMonth.GrandTotalCellFormat.FormatString = "p";
this.calcAPOSVsTargetMonth.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.calcAPOSVsTargetMonth.Name = "calcAPOSVsTargetMonth";
this.calcAPOSVsTargetMonth.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Average;
this.calcAPOSVsTargetMonth.UnboundExpression = "([APOS] * 1.0) / [TargetAPOS]";
this.calcAPOSVsTargetMonth.UnboundFieldName = "calcAPOSVsTargetMonth";
this.calcAPOSVsTargetMonth.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
//
// calcINVVsTargetDay
//
this.calcINVVsTargetDay.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.calcINVVsTargetDay.AreaIndex = 8;
this.calcINVVsTargetDay.Caption = "INV Vs Target LD";
this.calcINVVsTargetDay.EmptyCellText = "0";
this.calcINVVsTargetDay.EmptyValueText = "0";
this.calcINVVsTargetDay.GrandTotalCellFormat.FormatString = "p";
this.calcINVVsTargetDay.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.calcINVVsTargetDay.Name = "calcINVVsTargetDay";
this.calcINVVsTargetDay.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Average;
this.calcINVVsTargetDay.UnboundExpression = "([INVLD] * 1.0) / [TargetINVDay]";
this.calcINVVsTargetDay.UnboundFieldName = "calcINVVsTargetDay";
this.calcINVVsTargetDay.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
//
// calcINVVsTargetMonth
//
this.calcINVVsTargetMonth.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.calcINVVsTargetMonth.AreaIndex = 11;
this.calcINVVsTargetMonth.Caption = "INV Vs Target MTD";
this.calcINVVsTargetMonth.EmptyCellText = "0";
this.calcINVVsTargetMonth.EmptyValueText = "0";
this.calcINVVsTargetMonth.GrandTotalCellFormat.FormatString = "p";
this.calcINVVsTargetMonth.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.calcINVVsTargetMonth.Name = "calcINVVsTargetMonth";
this.calcINVVsTargetMonth.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Average;
this.calcINVVsTargetMonth.UnboundExpression = "([INV] * 1.0) / [TargetINV]";
this.calcINVVsTargetMonth.UnboundFieldName = "calcINVVsTargetMonth";
this.calcINVVsTargetMonth.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
//
// calcNPSVsTargetDay
//
this.calcNPSVsTargetDay.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.calcNPSVsTargetDay.AreaIndex = 14;
this.calcNPSVsTargetDay.Caption = "NPS Vs Target LD";
this.calcNPSVsTargetDay.EmptyCellText = "0";
this.calcNPSVsTargetDay.EmptyValueText = "0";
this.calcNPSVsTargetDay.GrandTotalCellFormat.FormatString = "p";
this.calcNPSVsTargetDay.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.calcNPSVsTargetDay.Name = "calcNPSVsTargetDay";
this.calcNPSVsTargetDay.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Average;
this.calcNPSVsTargetDay.UnboundExpression = "([NPSLD] * 1.0) / [TargetNPSDay]";
this.calcNPSVsTargetDay.UnboundFieldName = "calcNPSVsTargetDay";
this.calcNPSVsTargetDay.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
//
// calcNPSVsTargetMonth
//
this.calcNPSVsTargetMonth.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.calcNPSVsTargetMonth.AreaIndex = 17;
this.calcNPSVsTargetMonth.Caption = "NPS Vs Target MTD";
this.calcNPSVsTargetMonth.EmptyCellText = "0";
this.calcNPSVsTargetMonth.EmptyValueText = "0";
this.calcNPSVsTargetMonth.GrandTotalCellFormat.FormatString = "p";
this.calcNPSVsTargetMonth.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.calcNPSVsTargetMonth.Name = "calcNPSVsTargetMonth";
this.calcNPSVsTargetMonth.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Average;
this.calcNPSVsTargetMonth.UnboundExpression = "([NPS] * 1.0) / [TargetNPS]";
this.calcNPSVsTargetMonth.UnboundFieldName = "calcNPSVsTargetMonth";
this.calcNPSVsTargetMonth.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
//
// calcDSVsTargetDay
//
this.calcDSVsTargetDay.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.calcDSVsTargetDay.AreaIndex = 20;
this.calcDSVsTargetDay.Caption = "DS Vs Target LD";
this.calcDSVsTargetDay.EmptyCellText = "0";
this.calcDSVsTargetDay.EmptyValueText = "0";
this.calcDSVsTargetDay.GrandTotalCellFormat.FormatString = "p";
this.calcDSVsTargetDay.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.calcDSVsTargetDay.Name = "calcDSVsTargetDay";
this.calcDSVsTargetDay.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Average;
this.calcDSVsTargetDay.UnboundExpression = "([DSLD] * 1.0) / [TargetDSDay]";
this.calcDSVsTargetDay.UnboundFieldName = "calcDSVsTargetDay";
this.calcDSVsTargetDay.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
//
// calcDSVsTargetMonth
//
this.calcDSVsTargetMonth.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.calcDSVsTargetMonth.AreaIndex = 23;
this.calcDSVsTargetMonth.Caption = "DS Vs Target MTD";
this.calcDSVsTargetMonth.EmptyCellText = "0";
this.calcDSVsTargetMonth.EmptyValueText = "0";
this.calcDSVsTargetMonth.GrandTotalCellFormat.FormatString = "p";
this.calcDSVsTargetMonth.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.calcDSVsTargetMonth.Name = "calcDSVsTargetMonth";
this.calcDSVsTargetMonth.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Average;
this.calcDSVsTargetMonth.UnboundExpression = "([DS] * 1.0) / [TargetDS]";
this.calcDSVsTargetMonth.UnboundFieldName = "calcDSVsTargetMonth";
this.calcDSVsTargetMonth.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
//
// repositoryItemTextEditPers
//
this.repositoryItemTextEditPers.AutoHeight = false;
this.repositoryItemTextEditPers.EditFormat.FormatString = "P1";
this.repositoryItemTextEditPers.EditFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.repositoryItemTextEditPers.ExportMode = DevExpress.XtraEditors.Repository.ExportMode.DisplayText;
this.repositoryItemTextEditPers.Mask.EditMask = "P1";
this.repositoryItemTextEditPers.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
this.repositoryItemTextEditPers.Mask.UseMaskAsDisplayFormat = true;
this.repositoryItemTextEditPers.Name = "repositoryItemTextEditPers";
//
// repositoryItemTextEditf2
//
this.repositoryItemTextEditf2.AutoHeight = false;
this.repositoryItemTextEditf2.DisplayFormat.FormatString = "f2";
this.repositoryItemTextEditf2.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.repositoryItemTextEditf2.Mask.EditMask = "f2";
this.repositoryItemTextEditf2.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
this.repositoryItemTextEditf2.Name = "repositoryItemTextEditf2";
//
// repositoryItemTextEdit1
//
this.repositoryItemTextEdit1.AutoHeight = false;
this.repositoryItemTextEdit1.Name = "repositoryItemTextEdit1";
//
// popupMenuMain
//
this.popupMenuMain.Manager = this.barManagerMain;
this.popupMenuMain.Name = "popupMenuMain";
//
// barManagerMain
//
this.barManagerMain.Bars.AddRange(new DevExpress.XtraBars.Bar[] {
this.bar1});
this.barManagerMain.DockControls.Add(this.barDockControlTop);
this.barManagerMain.DockControls.Add(this.barDockControlBottom);
this.barManagerMain.DockControls.Add(this.barDockControlLeft);
this.barManagerMain.DockControls.Add(this.barDockControlRight);
this.barManagerMain.Form = this;
this.barManagerMain.Items.AddRange(new DevExpress.XtraBars.BarItem[] {
this.bbiExport,
this.bbiStartDate,
this.barHeaderItem1,
this.bbiGetData,
this.barHeaderItem2,
this.bbiEndDate});
this.barManagerMain.MaxItemId = 12;
this.barManagerMain.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] {
this.repositoryItemDateEdit1,
this.repositoryItemDateEdit2,
this.repositoryItemDateEdit3});
//
// bar1
//
this.bar1.BarName = "Main";
this.bar1.DockCol = 0;
this.bar1.DockRow = 0;
this.bar1.DockStyle = DevExpress.XtraBars.BarDockStyle.Top;
this.bar1.LinksPersistInfo.AddRange(new DevExpress.XtraBars.LinkPersistInfo[] {
new DevExpress.XtraBars.LinkPersistInfo(this.barHeaderItem1),
new DevExpress.XtraBars.LinkPersistInfo(this.bbiStartDate),
new DevExpress.XtraBars.LinkPersistInfo(this.barHeaderItem2),
new DevExpress.XtraBars.LinkPersistInfo(this.bbiEndDate),
new DevExpress.XtraBars.LinkPersistInfo(DevExpress.XtraBars.BarLinkUserDefines.PaintStyle, this.bbiGetData, DevExpress.XtraBars.BarItemPaintStyle.CaptionGlyph),
new DevExpress.XtraBars.LinkPersistInfo(this.bbiExport)});
this.bar1.Text = "Custom 2";
//
// barHeaderItem1
//
this.barHeaderItem1.Caption = "Start Date";
this.barHeaderItem1.Id = 3;
this.barHeaderItem1.Name = "barHeaderItem1";
//
// bbiStartDate
//
this.bbiStartDate.Caption = "Start Date";
this.bbiStartDate.Edit = this.repositoryItemDateEdit1;
this.bbiStartDate.Id = 2;
this.bbiStartDate.ItemShortcut = new DevExpress.XtraBars.BarShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.D1));
this.bbiStartDate.Name = "bbiStartDate";
this.bbiStartDate.Width = 120;
//
// 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";
//
// barHeaderItem2
//
this.barHeaderItem2.Caption = "EndDate";
this.barHeaderItem2.Id = 10;
this.barHeaderItem2.Name = "barHeaderItem2";
//
// bbiEndDate
//
this.bbiEndDate.Caption = "End Date";
this.bbiEndDate.Edit = this.repositoryItemDateEdit3;
this.bbiEndDate.Id = 11;
this.bbiEndDate.Name = "bbiEndDate";
this.bbiEndDate.Width = 120;
//
// repositoryItemDateEdit3
//
this.repositoryItemDateEdit3.AutoHeight = false;
this.repositoryItemDateEdit3.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
this.repositoryItemDateEdit3.CalendarTimeProperties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
this.repositoryItemDateEdit3.Name = "repositoryItemDateEdit3";
//
// bbiGetData
//
this.bbiGetData.Caption = "Get Data";
this.bbiGetData.CaptionAlignment = DevExpress.XtraBars.BarItemCaptionAlignment.Right;
this.bbiGetData.Glyph = global::NestleICSales.Properties.Resources.apply_16x16;
this.bbiGetData.Id = 9;
this.bbiGetData.ItemShortcut = new DevExpress.XtraBars.BarShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.G));
this.bbiGetData.Name = "bbiGetData";
this.bbiGetData.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.bbiGetData_ItemClick);
//
// bbiExport
//
this.bbiExport.Caption = "Export";
this.bbiExport.Glyph = global::NestleICSales.Properties.Resources.Export;
this.bbiExport.Id = 1;
this.bbiExport.ItemShortcut = new DevExpress.XtraBars.BarShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.E));
this.bbiExport.Name = "bbiExport";
this.bbiExport.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.bbiExport_ItemClick);
//
// 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(1132, 31);
//
// barDockControlBottom
//
this.barDockControlBottom.CausesValidation = false;
this.barDockControlBottom.Dock = System.Windows.Forms.DockStyle.Bottom;
this.barDockControlBottom.Location = new System.Drawing.Point(0, 311);
this.barDockControlBottom.Size = new System.Drawing.Size(1132, 0);
//
// barDockControlLeft
//
this.barDockControlLeft.CausesValidation = false;
this.barDockControlLeft.Dock = System.Windows.Forms.DockStyle.Left;
this.barDockControlLeft.Location = new System.Drawing.Point(0, 31);
this.barDockControlLeft.Size = new System.Drawing.Size(0, 280);
//
// barDockControlRight
//
this.barDockControlRight.CausesValidation = false;
this.barDockControlRight.Dock = System.Windows.Forms.DockStyle.Right;
this.barDockControlRight.Location = new System.Drawing.Point(1132, 31);
this.barDockControlRight.Size = new System.Drawing.Size(0, 280);
//
// repositoryItemDateEdit2
//
this.repositoryItemDateEdit2.AutoHeight = false;
this.repositoryItemDateEdit2.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
this.repositoryItemDateEdit2.CalendarTimeProperties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
this.repositoryItemDateEdit2.Name = "repositoryItemDateEdit2";
//
// pivotGridControlMain
//
this.pivotGridControlMain.DataSource = this.pro0001BindingSource;
this.pivotGridControlMain.Dock = System.Windows.Forms.DockStyle.Fill;
this.pivotGridControlMain.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.fieldRouteNumber1,
this.fieldRouteName1,
this.fieldSupervisor1,
this.fieldRouteBrand1,
this.fieldPlantSalesDistrict1,
this.fieldPlantName1,
this.fieldPlantBaseName1,
this.fieldDistributionChannel1,
this.fieldAPOSLD,
this.fieldTargetAPOSDay,
this.fieldAPOS,
this.fieldTargetAPOS,
this.fieldINVLD,
this.fieldTargetINVDay,
this.fieldINV,
this.fieldTargetINV,
this.fieldNPSLD,
this.fieldTargetNPSDay,
this.fieldNPS,
this.fieldTargetNPS,
this.fieldDSLD1,
this.fieldTargetDSDay,
this.fieldDS,
this.fieldTargetDS,
this.calcAPOSVsTargetDay,
this.calcAPOSVsTargetMonth,
this.calcINVVsTargetDay,
this.calcINVVsTargetMonth,
this.calcNPSVsTargetDay,
this.calcNPSVsTargetMonth,
this.calcDSVsTargetDay,
this.calcDSVsTargetMonth});
pivotGridStyleFormatCondition1.Appearance.BackColor = System.Drawing.Color.Red;
pivotGridStyleFormatCondition1.Appearance.BackColor2 = System.Drawing.Color.White;
pivotGridStyleFormatCondition1.Appearance.Options.UseBackColor = true;
pivotGridStyleFormatCondition1.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less;
pivotGridStyleFormatCondition1.Field = this.calcAPOSVsTargetDay;
pivotGridStyleFormatCondition1.FieldName = "calcAPOSVsTargetDay";
pivotGridStyleFormatCondition1.Value1 = "1";
pivotGridStyleFormatCondition2.Appearance.BackColor = System.Drawing.Color.Green;
pivotGridStyleFormatCondition2.Appearance.BackColor2 = System.Drawing.Color.White;
pivotGridStyleFormatCondition2.Appearance.Options.UseBackColor = true;
pivotGridStyleFormatCondition2.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual;
pivotGridStyleFormatCondition2.Field = this.calcAPOSVsTargetDay;
pivotGridStyleFormatCondition2.FieldName = "calcAPOSVsTargetDay";
pivotGridStyleFormatCondition2.Value1 = "1";
pivotGridStyleFormatCondition3.Appearance.BackColor = System.Drawing.Color.Red;
pivotGridStyleFormatCondition3.Appearance.BackColor2 = System.Drawing.Color.White;
pivotGridStyleFormatCondition3.Appearance.Options.UseBackColor = true;
pivotGridStyleFormatCondition3.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less;
pivotGridStyleFormatCondition3.Field = this.calcAPOSVsTargetMonth;
pivotGridStyleFormatCondition3.FieldName = "calcAPOSVsTargetMonth";
pivotGridStyleFormatCondition3.Value1 = "1";
pivotGridStyleFormatCondition4.Appearance.BackColor = System.Drawing.Color.Green;
pivotGridStyleFormatCondition4.Appearance.BackColor2 = System.Drawing.Color.White;
pivotGridStyleFormatCondition4.Appearance.Options.UseBackColor = true;
pivotGridStyleFormatCondition4.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual;
pivotGridStyleFormatCondition4.Field = this.calcAPOSVsTargetMonth;
pivotGridStyleFormatCondition4.FieldName = "calcAPOSVsTargetMonth";
pivotGridStyleFormatCondition4.Value1 = "1";
pivotGridStyleFormatCondition5.Appearance.BackColor = System.Drawing.Color.Red;
pivotGridStyleFormatCondition5.Appearance.BackColor2 = System.Drawing.Color.White;
pivotGridStyleFormatCondition5.Appearance.Options.UseBackColor = true;
pivotGridStyleFormatCondition5.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less;
pivotGridStyleFormatCondition5.Field = this.calcINVVsTargetDay;
pivotGridStyleFormatCondition5.FieldName = "calcINVVsTargetDay";
pivotGridStyleFormatCondition5.Value1 = "1";
pivotGridStyleFormatCondition6.Appearance.BackColor = System.Drawing.Color.Green;
pivotGridStyleFormatCondition6.Appearance.BackColor2 = System.Drawing.Color.White;
pivotGridStyleFormatCondition6.Appearance.Options.UseBackColor = true;
pivotGridStyleFormatCondition6.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual;
pivotGridStyleFormatCondition6.Field = this.calcINVVsTargetDay;
pivotGridStyleFormatCondition6.FieldName = "calcINVVsTargetDay";
pivotGridStyleFormatCondition6.Value1 = "1";
pivotGridStyleFormatCondition7.Appearance.BackColor = System.Drawing.Color.Red;
pivotGridStyleFormatCondition7.Appearance.BackColor2 = System.Drawing.Color.White;
pivotGridStyleFormatCondition7.Appearance.Options.UseBackColor = true;
pivotGridStyleFormatCondition7.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less;
pivotGridStyleFormatCondition7.Field = this.calcINVVsTargetMonth;
pivotGridStyleFormatCondition7.FieldName = "calcINVVsTargetMonth";
pivotGridStyleFormatCondition7.Value1 = "1";
pivotGridStyleFormatCondition8.Appearance.BackColor = System.Drawing.Color.Green;
pivotGridStyleFormatCondition8.Appearance.BackColor2 = System.Drawing.Color.White;
pivotGridStyleFormatCondition8.Appearance.Options.UseBackColor = true;
pivotGridStyleFormatCondition8.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual;
pivotGridStyleFormatCondition8.Field = this.calcINVVsTargetMonth;
pivotGridStyleFormatCondition8.FieldName = "calcINVVsTargetMonth";
pivotGridStyleFormatCondition8.Value1 = "1";
pivotGridStyleFormatCondition9.Appearance.BackColor = System.Drawing.Color.Red;
pivotGridStyleFormatCondition9.Appearance.BackColor2 = System.Drawing.Color.White;
pivotGridStyleFormatCondition9.Appearance.Options.UseBackColor = true;
pivotGridStyleFormatCondition9.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less;
pivotGridStyleFormatCondition9.Field = this.calcNPSVsTargetDay;
pivotGridStyleFormatCondition9.FieldName = "calcNPSVsTargetDay";
pivotGridStyleFormatCondition9.Value1 = "1";
pivotGridStyleFormatCondition10.Appearance.BackColor = System.Drawing.Color.Green;
pivotGridStyleFormatCondition10.Appearance.BackColor2 = System.Drawing.Color.White;
pivotGridStyleFormatCondition10.Appearance.Options.UseBackColor = true;
pivotGridStyleFormatCondition10.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual;
pivotGridStyleFormatCondition10.Field = this.calcNPSVsTargetDay;
pivotGridStyleFormatCondition10.FieldName = "calcNPSVsTargetDay";
pivotGridStyleFormatCondition10.Value1 = "1";
pivotGridStyleFormatCondition11.Appearance.BackColor = System.Drawing.Color.Red;
pivotGridStyleFormatCondition11.Appearance.BackColor2 = System.Drawing.Color.White;
pivotGridStyleFormatCondition11.Appearance.Options.UseBackColor = true;
pivotGridStyleFormatCondition11.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less;
pivotGridStyleFormatCondition11.Field = this.calcNPSVsTargetMonth;
pivotGridStyleFormatCondition11.FieldName = "calcNPSVsTargetMonth";
pivotGridStyleFormatCondition11.Value1 = "1";
pivotGridStyleFormatCondition12.Appearance.BackColor = System.Drawing.Color.Green;
pivotGridStyleFormatCondition12.Appearance.BackColor2 = System.Drawing.Color.White;
pivotGridStyleFormatCondition12.Appearance.Options.UseBackColor = true;
pivotGridStyleFormatCondition12.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual;
pivotGridStyleFormatCondition12.Field = this.calcNPSVsTargetMonth;
pivotGridStyleFormatCondition12.FieldName = "calcNPSVsTargetMonth";
pivotGridStyleFormatCondition12.Value1 = "1";
pivotGridStyleFormatCondition13.Appearance.BackColor = System.Drawing.Color.Red;
pivotGridStyleFormatCondition13.Appearance.BackColor2 = System.Drawing.Color.White;
pivotGridStyleFormatCondition13.Appearance.Options.UseBackColor = true;
pivotGridStyleFormatCondition13.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less;
pivotGridStyleFormatCondition13.Field = this.calcDSVsTargetDay;
pivotGridStyleFormatCondition13.FieldName = "calcDSVsTargetDay";
pivotGridStyleFormatCondition13.Value1 = "1";
pivotGridStyleFormatCondition14.Appearance.BackColor = System.Drawing.Color.Green;
pivotGridStyleFormatCondition14.Appearance.BackColor2 = System.Drawing.Color.White;
pivotGridStyleFormatCondition14.Appearance.Options.UseBackColor = true;
pivotGridStyleFormatCondition14.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual;
pivotGridStyleFormatCondition14.Field = this.calcDSVsTargetDay;
pivotGridStyleFormatCondition14.FieldName = "calcDSVsTargetDay";
pivotGridStyleFormatCondition14.Value1 = "1";
pivotGridStyleFormatCondition15.Appearance.BackColor = System.Drawing.Color.Red;
pivotGridStyleFormatCondition15.Appearance.BackColor2 = System.Drawing.Color.White;
pivotGridStyleFormatCondition15.Appearance.Options.UseBackColor = true;
pivotGridStyleFormatCondition15.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less;
pivotGridStyleFormatCondition15.Field = this.calcDSVsTargetMonth;
pivotGridStyleFormatCondition15.FieldName = "calcDSVsTargetMonth";
pivotGridStyleFormatCondition15.Value1 = "1";
pivotGridStyleFormatCondition16.Appearance.BackColor = System.Drawing.Color.Green;
pivotGridStyleFormatCondition16.Appearance.BackColor2 = System.Drawing.Color.White;
pivotGridStyleFormatCondition16.Appearance.Options.UseBackColor = true;
pivotGridStyleFormatCondition16.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual;
pivotGridStyleFormatCondition16.Field = this.calcDSVsTargetMonth;
pivotGridStyleFormatCondition16.FieldName = "calcDSVsTargetMonth";
pivotGridStyleFormatCondition16.Value1 = "1";
this.pivotGridControlMain.FormatConditions.AddRange(new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition[] {
pivotGridStyleFormatCondition1,
pivotGridStyleFormatCondition2,
pivotGridStyleFormatCondition3,
pivotGridStyleFormatCondition4,
pivotGridStyleFormatCondition5,
pivotGridStyleFormatCondition6,
pivotGridStyleFormatCondition7,
pivotGridStyleFormatCondition8,
pivotGridStyleFormatCondition9,
pivotGridStyleFormatCondition10,
pivotGridStyleFormatCondition11,
pivotGridStyleFormatCondition12,
pivotGridStyleFormatCondition13,
pivotGridStyleFormatCondition14,
pivotGridStyleFormatCondition15,
pivotGridStyleFormatCondition16});
this.pivotGridControlMain.Location = new System.Drawing.Point(0, 31);
this.pivotGridControlMain.Name = "pivotGridControlMain";
this.pivotGridControlMain.OptionsPrint.PrintColumnHeaders = DevExpress.Utils.DefaultBoolean.False;
this.pivotGridControlMain.OptionsPrint.PrintDataHeaders = DevExpress.Utils.DefaultBoolean.False;
this.pivotGridControlMain.OptionsPrint.PrintFilterHeaders = DevExpress.Utils.DefaultBoolean.False;
this.pivotGridControlMain.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] {
this.repositoryItemTextEditPers});
this.pivotGridControlMain.Size = new System.Drawing.Size(1132, 280);
this.pivotGridControlMain.TabIndex = 9;
//
// pro0001BindingSource
//
this.pro0001BindingSource.DataMember = "Pro_0001";
this.pro0001BindingSource.DataSource = this.dsNMQry;
//
// dsNMQry
//
this.dsNMQry.DataSetName = "dsNMQry";
this.dsNMQry.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// fieldRouteNumber1
//
this.fieldRouteNumber1.AreaIndex = 0;
this.fieldRouteNumber1.Caption = "Route Number";
this.fieldRouteNumber1.FieldName = "RouteNumber";
this.fieldRouteNumber1.Name = "fieldRouteNumber1";
//
// fieldRouteName1
//
this.fieldRouteName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldRouteName1.AreaIndex = 1;
this.fieldRouteName1.Caption = "Route Name";
this.fieldRouteName1.FieldName = "RouteName";
this.fieldRouteName1.Name = "fieldRouteName1";
//
// fieldSupervisor1
//
this.fieldSupervisor1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldSupervisor1.AreaIndex = 0;
this.fieldSupervisor1.Caption = "Supervisor";
this.fieldSupervisor1.FieldName = "Supervisor";
this.fieldSupervisor1.Name = "fieldSupervisor1";
//
// fieldRouteBrand1
//
this.fieldRouteBrand1.AreaIndex = 1;
this.fieldRouteBrand1.Caption = "Route Brand";
this.fieldRouteBrand1.FieldName = "RouteBrand";
this.fieldRouteBrand1.Name = "fieldRouteBrand1";
//
// fieldPlantSalesDistrict1
//
this.fieldPlantSalesDistrict1.AreaIndex = 2;
this.fieldPlantSalesDistrict1.Caption = "Plant Sales District";
this.fieldPlantSalesDistrict1.FieldName = "PlantSalesDistrict";
this.fieldPlantSalesDistrict1.Name = "fieldPlantSalesDistrict1";
//
// fieldPlantName1
//
this.fieldPlantName1.AreaIndex = 3;
this.fieldPlantName1.Caption = "Plant Name";
this.fieldPlantName1.FieldName = "PlantName";
this.fieldPlantName1.Name = "fieldPlantName1";
//
// fieldPlantBaseName1
//
this.fieldPlantBaseName1.AreaIndex = 4;
this.fieldPlantBaseName1.Caption = "Plant Base Name";
this.fieldPlantBaseName1.FieldName = "PlantBaseName";
this.fieldPlantBaseName1.Name = "fieldPlantBaseName1";
//
// fieldDistributionChannel1
//
this.fieldDistributionChannel1.AreaIndex = 5;
this.fieldDistributionChannel1.Caption = "Distribution Channel";
this.fieldDistributionChannel1.FieldName = "DistributionChannel";
this.fieldDistributionChannel1.Name = "fieldDistributionChannel1";
//
// fieldAPOSLD
//
this.fieldAPOSLD.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldAPOSLD.AreaIndex = 0;
this.fieldAPOSLD.Caption = "APOS LD";
this.fieldAPOSLD.CellFormat.FormatString = "f2";
this.fieldAPOSLD.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldAPOSLD.EmptyCellText = "0";
this.fieldAPOSLD.EmptyValueText = "0";
this.fieldAPOSLD.FieldName = "APOSLD";
this.fieldAPOSLD.Name = "fieldAPOSLD";
//
// fieldTargetAPOSDay
//
this.fieldTargetAPOSDay.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldTargetAPOSDay.AreaIndex = 1;
this.fieldTargetAPOSDay.Caption = "APOS Target LD";
this.fieldTargetAPOSDay.CellFormat.FormatString = "f2";
this.fieldTargetAPOSDay.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldTargetAPOSDay.EmptyCellText = "0";
this.fieldTargetAPOSDay.EmptyValueText = "0";
this.fieldTargetAPOSDay.FieldName = "TargetAPOSDay";
this.fieldTargetAPOSDay.Name = "fieldTargetAPOSDay";
//
// fieldAPOS
//
this.fieldAPOS.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldAPOS.AreaIndex = 3;
this.fieldAPOS.Caption = "APOS MTD";
this.fieldAPOS.CellFormat.FormatString = "f2";
this.fieldAPOS.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldAPOS.EmptyCellText = "0";
this.fieldAPOS.EmptyValueText = "0";
this.fieldAPOS.FieldName = "APOS";
this.fieldAPOS.Name = "fieldAPOS";
//
// fieldTargetAPOS
//
this.fieldTargetAPOS.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldTargetAPOS.AreaIndex = 4;
this.fieldTargetAPOS.Caption = "APOS Target MTD";
this.fieldTargetAPOS.CellFormat.FormatString = "f2";
this.fieldTargetAPOS.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldTargetAPOS.EmptyCellText = "0";
this.fieldTargetAPOS.EmptyValueText = "0";
this.fieldTargetAPOS.FieldName = "TargetAPOS";
this.fieldTargetAPOS.Name = "fieldTargetAPOS";
//
// fieldINVLD
//
this.fieldINVLD.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldINVLD.AreaIndex = 6;
this.fieldINVLD.Caption = "INV LD";
this.fieldINVLD.CellFormat.FormatString = "f2";
this.fieldINVLD.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldINVLD.EmptyCellText = "0";
this.fieldINVLD.EmptyValueText = "0";
this.fieldINVLD.FieldName = "INVLD";
this.fieldINVLD.Name = "fieldINVLD";
//
// fieldTargetINVDay
//
this.fieldTargetINVDay.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldTargetINVDay.AreaIndex = 7;
this.fieldTargetINVDay.Caption = "INV Target LD";
this.fieldTargetINVDay.CellFormat.FormatString = "f2";
this.fieldTargetINVDay.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldTargetINVDay.EmptyCellText = "0";
this.fieldTargetINVDay.EmptyValueText = "0";
this.fieldTargetINVDay.FieldName = "TargetINVDay";
this.fieldTargetINVDay.Name = "fieldTargetINVDay";
//
// fieldINV
//
this.fieldINV.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldINV.AreaIndex = 9;
this.fieldINV.Caption = "INV MTD";
this.fieldINV.CellFormat.FormatString = "f2";
this.fieldINV.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldINV.EmptyCellText = "0";
this.fieldINV.EmptyValueText = "0";
this.fieldINV.FieldName = "INV";
this.fieldINV.Name = "fieldINV";
//
// fieldTargetINV
//
this.fieldTargetINV.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldTargetINV.AreaIndex = 10;
this.fieldTargetINV.Caption = "INV Target MTD";
this.fieldTargetINV.CellFormat.FormatString = "f2";
this.fieldTargetINV.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldTargetINV.EmptyCellText = "0";
this.fieldTargetINV.EmptyValueText = "0";
this.fieldTargetINV.FieldName = "TargetINV";
this.fieldTargetINV.Name = "fieldTargetINV";
//
// fieldNPSLD
//
this.fieldNPSLD.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldNPSLD.AreaIndex = 12;
this.fieldNPSLD.Caption = "NPS LD";
this.fieldNPSLD.CellFormat.FormatString = "f2";
this.fieldNPSLD.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldNPSLD.EmptyCellText = "0";
this.fieldNPSLD.EmptyValueText = "0";
this.fieldNPSLD.FieldName = "NPSLD";
this.fieldNPSLD.Name = "fieldNPSLD";
//
// fieldTargetNPSDay
//
this.fieldTargetNPSDay.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldTargetNPSDay.AreaIndex = 13;
this.fieldTargetNPSDay.Caption = "NPS Target LD";
this.fieldTargetNPSDay.CellFormat.FormatString = "f2";
this.fieldTargetNPSDay.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldTargetNPSDay.EmptyCellText = "0";
this.fieldTargetNPSDay.EmptyValueText = "0";
this.fieldTargetNPSDay.FieldName = "TargetNPSDay";
this.fieldTargetNPSDay.Name = "fieldTargetNPSDay";
//
// fieldNPS
//
this.fieldNPS.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldNPS.AreaIndex = 15;
this.fieldNPS.Caption = "NPS MTD";
this.fieldNPS.CellFormat.FormatString = "f2";
this.fieldNPS.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldNPS.EmptyCellText = "0";
this.fieldNPS.EmptyValueText = "0";
this.fieldNPS.FieldName = "NPS";
this.fieldNPS.Name = "fieldNPS";
//
// fieldTargetNPS
//
this.fieldTargetNPS.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldTargetNPS.AreaIndex = 16;
this.fieldTargetNPS.Caption = "NPS Target MTD";
this.fieldTargetNPS.CellFormat.FormatString = "f2";
this.fieldTargetNPS.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldTargetNPS.EmptyCellText = "0";
this.fieldTargetNPS.EmptyValueText = "0";
this.fieldTargetNPS.FieldName = "TargetNPS";
this.fieldTargetNPS.Name = "fieldTargetNPS";
//
// fieldDSLD1
//
this.fieldDSLD1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldDSLD1.AreaIndex = 18;
this.fieldDSLD1.Caption = "DS LD";
this.fieldDSLD1.CellFormat.FormatString = "f2";
this.fieldDSLD1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldDSLD1.EmptyCellText = "0";
this.fieldDSLD1.EmptyValueText = "0";
this.fieldDSLD1.FieldName = "DSLD";
this.fieldDSLD1.Name = "fieldDSLD1";
//
// fieldTargetDSDay
//
this.fieldTargetDSDay.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldTargetDSDay.AreaIndex = 19;
this.fieldTargetDSDay.Caption = "DS Target LD";
this.fieldTargetDSDay.CellFormat.FormatString = "f2";
this.fieldTargetDSDay.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldTargetDSDay.EmptyCellText = "0";
this.fieldTargetDSDay.EmptyValueText = "0";
this.fieldTargetDSDay.FieldName = "TargetDSDay";
this.fieldTargetDSDay.Name = "fieldTargetDSDay";
//
// fieldDS
//
this.fieldDS.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldDS.AreaIndex = 21;
this.fieldDS.Caption = "DS MTD";
this.fieldDS.CellFormat.FormatString = "f2";
this.fieldDS.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldDS.EmptyCellText = "0";
this.fieldDS.EmptyValueText = "0";
this.fieldDS.FieldName = "DS";
this.fieldDS.Name = "fieldDS";
//
// fieldTargetDS
//
this.fieldTargetDS.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldTargetDS.AreaIndex = 22;
this.fieldTargetDS.Caption = "DS Target MTD";
this.fieldTargetDS.CellFormat.FormatString = "f2";
this.fieldTargetDS.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldTargetDS.EmptyCellText = "0";
this.fieldTargetDS.EmptyValueText = "0";
this.fieldTargetDS.FieldName = "TargetDS";
this.fieldTargetDS.Name = "fieldTargetDS";
//
// pro_0001TableAdapter
//
this.pro_0001TableAdapter.ClearBeforeFill = true;
//
// QryPro_0001BFrm
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(1132, 311);
this.Controls.Add(this.pivotGridControlMain);
this.Controls.Add(this.barDockControlLeft);
this.Controls.Add(this.barDockControlRight);
this.Controls.Add(this.barDockControlBottom);
this.Controls.Add(this.barDockControlTop);
this.Icon = global::NestleICSales.Properties.Resources.Qry16;
this.Name = "QryPro_0001BFrm";
this.Text = "Actual KPI Vs Target";
((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditPers)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditf2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEdit1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.popupMenuMain)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.barManagerMain)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1.CalendarTimeProperties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit3.CalendarTimeProperties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit3)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2.CalendarTimeProperties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControlMain)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.pro0001BindingSource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dsNMQry)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dxValidationProviderMain)).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.PivotGridStyleFormatCondition pivotGridStyleFormatCondition2 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition3 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition4 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraCharts.XYDiagram xyDiagram1 = new DevExpress.XtraCharts.XYDiagram();
DevExpress.XtraCharts.SideBySideBarSeriesLabel sideBySideBarSeriesLabel1 = new DevExpress.XtraCharts.SideBySideBarSeriesLabel();
this.ribbon = new DevExpress.XtraBars.Ribbon.RibbonControl();
this.barButtonItemExcel = new DevExpress.XtraBars.BarButtonItem();
this.barButtonItemPrint = new DevExpress.XtraBars.BarButtonItem();
this.barButtonItemSaveLayout = new DevExpress.XtraBars.BarButtonItem();
this.barButtonItemLoadLayout = new DevExpress.XtraBars.BarButtonItem();
this.barCheckItemRow = new DevExpress.XtraBars.BarCheckItem();
this.barCheckItemCols = new DevExpress.XtraBars.BarCheckItem();
this.barButtonShowFields = new DevExpress.XtraBars.BarButtonItem();
this.barButtonItemBestFit = new DevExpress.XtraBars.BarButtonItem();
this.barCheckItemGrafico = new DevExpress.XtraBars.BarCheckItem();
this.barButtonItemStampaGrafico = new DevExpress.XtraBars.BarButtonItem();
this.barButtonItemExcelChart = new DevExpress.XtraBars.BarButtonItem();
this.ribbonPage1 = new DevExpress.XtraBars.Ribbon.RibbonPage();
this.ribbonPageGroup3 = new DevExpress.XtraBars.Ribbon.RibbonPageGroup();
this.ribbonPageGroup1 = new DevExpress.XtraBars.Ribbon.RibbonPageGroup();
this.ribbonPageGroupChart = new DevExpress.XtraBars.Ribbon.RibbonPageGroup();
this.ribbonPageGroupTotal = new DevExpress.XtraBars.Ribbon.RibbonPageGroup();
this.ribbonPageGroupOpt = new DevExpress.XtraBars.Ribbon.RibbonPageGroup();
this.ribbonStatusBar = new DevExpress.XtraBars.Ribbon.RibbonStatusBar();
this.clientPanel = new DevExpress.XtraEditors.PanelControl();
this.pivotGridControlStampe = new DevExpress.XtraPivotGrid.PivotGridControl();
this.xpCollectionEntrata = new DevExpress.Xpo.XPCollection();
this.unitOfWork1 = new DevExpress.Xpo.UnitOfWork();
this.fieldModificatoDa = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldModificatoIl = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCreatoDa = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCreatoIl = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldRigaStampaIngressoIngressoDescrizione = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldDataOraEntrata = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldQuantita = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldDataOraEntrata1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldDataOraEntrata2 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldDataOraEntrata3 = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridFieldDataVendita = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridFieldPostazione = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridFieldStruttura = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridFieldTotalePersone = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridFieldTotaleIngressi = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridFieldCodiceVendita = new DevExpress.XtraPivotGrid.PivotGridField();
this.dockPanelGrafico = new DevExpress.XtraBars.Docking.DockPanel();
this.controlContainer1 = new DevExpress.XtraBars.Docking.ControlContainer();
this.chartControlPivot = new DevExpress.XtraCharts.ChartControl();
this.dockManager1 = new DevExpress.XtraBars.Docking.DockManager(this.components);
this.dockPanelFiltro = new DevExpress.XtraBars.Docking.DockPanel();
this.dockPanel1_Container = new DevExpress.XtraBars.Docking.ControlContainer();
this.checkEditPeriodo = new DevExpress.XtraEditors.CheckEdit();
this.simpleButtonQuery = new DevExpress.XtraEditors.SimpleButton();
this.labelControl3 = new DevExpress.XtraEditors.LabelControl();
this.checkedListBoxControl1 = new DevExpress.XtraEditors.CheckedListBoxControl();
this.labelControl2 = new DevExpress.XtraEditors.LabelControl();
this.labelControl1 = new DevExpress.XtraEditors.LabelControl();
this.dateEditEnd = new DevExpress.XtraEditors.DateEdit();
this.dateEditStart = new DevExpress.XtraEditors.DateEdit();
this.saveFileDialogXls = new System.Windows.Forms.SaveFileDialog();
this.openFileDialogXML = new System.Windows.Forms.OpenFileDialog();
this.saveFileDialogXML = new System.Windows.Forms.SaveFileDialog();
((System.ComponentModel.ISupportInitialize)(this.ribbon)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.clientPanel)).BeginInit();
this.clientPanel.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControlStampe)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.xpCollectionEntrata)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.unitOfWork1)).BeginInit();
this.dockPanelGrafico.SuspendLayout();
this.controlContainer1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.chartControlPivot)).BeginInit();
((System.ComponentModel.ISupportInitialize)(xyDiagram1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(sideBySideBarSeriesLabel1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dockManager1)).BeginInit();
this.dockPanelFiltro.SuspendLayout();
this.dockPanel1_Container.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.checkEditPeriodo.Properties)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.checkedListBoxControl1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dateEditEnd.Properties.VistaTimeProperties)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dateEditEnd.Properties)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dateEditStart.Properties.VistaTimeProperties)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dateEditStart.Properties)).BeginInit();
this.SuspendLayout();
//
// ribbon
//
this.ribbon.ApplicationButtonText = "XPSoft";
this.ribbon.ApplicationIcon = global::WinTicketNext.Properties.Resources.Logo;
//
//
//
this.ribbon.ExpandCollapseItem.Id = 0;
this.ribbon.ExpandCollapseItem.Name = "";
this.ribbon.Items.AddRange(new DevExpress.XtraBars.BarItem[] {
this.ribbon.ExpandCollapseItem,
this.barButtonItemExcel,
this.barButtonItemPrint,
this.barButtonItemSaveLayout,
this.barButtonItemLoadLayout,
this.barCheckItemRow,
this.barCheckItemCols,
this.barButtonShowFields,
this.barButtonItemBestFit,
this.barCheckItemGrafico,
this.barButtonItemStampaGrafico,
this.barButtonItemExcelChart
});
this.ribbon.Location = new System.Drawing.Point(0, 0);
this.ribbon.MaxItemId = 15;
this.ribbon.Name = "ribbon";
this.ribbon.Pages.AddRange(new DevExpress.XtraBars.Ribbon.RibbonPage[] {
this.ribbonPage1
});
this.ribbon.RibbonStyle = DevExpress.XtraBars.Ribbon.RibbonControlStyle.Office2010;
this.ribbon.SelectedPage = this.ribbonPage1;
this.ribbon.ShowExpandCollapseButton = DevExpress.Utils.DefaultBoolean.False;
this.ribbon.ShowToolbarCustomizeItem = false;
this.ribbon.Size = new System.Drawing.Size(758, 145);
this.ribbon.StatusBar = this.ribbonStatusBar;
this.ribbon.Toolbar.ShowCustomizeItem = false;
this.ribbon.ToolbarLocation = DevExpress.XtraBars.Ribbon.RibbonQuickAccessToolbarLocation.Hidden;
this.ribbon.ApplicationButtonClick += new System.EventHandler(this.ribbon_ApplicationButtonClick);
//
// barButtonItemExcel
//
this.barButtonItemExcel.Caption = "Excel";
this.barButtonItemExcel.Id = 0;
this.barButtonItemExcel.LargeGlyph = global::WinTicketNext.Properties.Resources.symbol_sum;
this.barButtonItemExcel.Name = "barButtonItemExcel";
this.barButtonItemExcel.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.barButtonItemExcel_ItemClick);
//
// barButtonItemPrint
//
this.barButtonItemPrint.Caption = "Stampa";
this.barButtonItemPrint.Id = 1;
this.barButtonItemPrint.LargeGlyph = global::WinTicketNext.Properties.Resources.printer;
this.barButtonItemPrint.Name = "barButtonItemPrint";
this.barButtonItemPrint.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.barButtonItemPrint_ItemClick);
//
// barButtonItemSaveLayout
//
this.barButtonItemSaveLayout.Caption = "Save";
this.barButtonItemSaveLayout.Id = 4;
this.barButtonItemSaveLayout.LargeGlyph = global::WinTicketNext.Properties.Resources.floppy_disk_yellow;
this.barButtonItemSaveLayout.Name = "barButtonItemSaveLayout";
this.barButtonItemSaveLayout.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.barButtonItemSaveLayout_ItemClick);
//
// barButtonItemLoadLayout
//
this.barButtonItemLoadLayout.Caption = "Load";
this.barButtonItemLoadLayout.Id = 5;
this.barButtonItemLoadLayout.LargeGlyph = global::WinTicketNext.Properties.Resources.folder_document;
this.barButtonItemLoadLayout.Name = "barButtonItemLoadLayout";
this.barButtonItemLoadLayout.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.barButtonItemLoadLayout_ItemClick);
//
// barCheckItemRow
//
this.barCheckItemRow.Caption = "Mostra Totale Righe";
this.barCheckItemRow.Checked = true;
this.barCheckItemRow.Id = 6;
this.barCheckItemRow.Name = "barCheckItemRow";
this.barCheckItemRow.CheckedChanged += new DevExpress.XtraBars.ItemClickEventHandler(this.barCheckItemRow_CheckedChanged);
//
// barCheckItemCols
//
this.barCheckItemCols.Caption = "Mostra Totale Colonne";
this.barCheckItemCols.Checked = true;
this.barCheckItemCols.Id = 7;
this.barCheckItemCols.Name = "barCheckItemCols";
this.barCheckItemCols.CheckedChanged += new DevExpress.XtraBars.ItemClickEventHandler(this.barCheckItemCols_CheckedChanged);
//
// barButtonShowFields
//
this.barButtonShowFields.Caption = "Elenco Campi";
this.barButtonShowFields.Id = 10;
this.barButtonShowFields.Name = "barButtonShowFields";
this.barButtonShowFields.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.barButtonShowFields_ItemClick);
//
// barButtonItemBestFit
//
this.barButtonItemBestFit.Caption = "Adatta Colonne";
this.barButtonItemBestFit.Id = 11;
this.barButtonItemBestFit.Name = "barButtonItemBestFit";
this.barButtonItemBestFit.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.barButtonItemBestFit_ItemClick);
//
// barCheckItemGrafico
//
this.barCheckItemGrafico.Caption = "Abilita Grafico";
this.barCheckItemGrafico.Id = 12;
this.barCheckItemGrafico.Name = "barCheckItemGrafico";
this.barCheckItemGrafico.CheckedChanged += new DevExpress.XtraBars.ItemClickEventHandler(this.barCheckItemGrafico_CheckedChanged);
//
// barButtonItemStampaGrafico
//
this.barButtonItemStampaGrafico.Caption = "Stampa";
this.barButtonItemStampaGrafico.Id = 13;
this.barButtonItemStampaGrafico.LargeGlyph = global::WinTicketNext.Properties.Resources.printer;
this.barButtonItemStampaGrafico.Name = "barButtonItemStampaGrafico";
this.barButtonItemStampaGrafico.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.barButtonItemStampaGrafico_ItemClick);
//
// barButtonItemExcelChart
//
this.barButtonItemExcelChart.Caption = "Excel";
this.barButtonItemExcelChart.Id = 14;
this.barButtonItemExcelChart.LargeGlyph = global::WinTicketNext.Properties.Resources.symbol_sum;
this.barButtonItemExcelChart.Name = "barButtonItemExcelChart";
this.barButtonItemExcelChart.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.barButtonItemExcelChart_ItemClick);
//
// ribbonPage1
//
this.ribbonPage1.Groups.AddRange(new DevExpress.XtraBars.Ribbon.RibbonPageGroup[] {
this.ribbonPageGroup3,
this.ribbonPageGroup1,
this.ribbonPageGroupChart,
this.ribbonPageGroupTotal,
this.ribbonPageGroupOpt
});
this.ribbonPage1.Name = "ribbonPage1";
this.ribbonPage1.Text = "Pivot Grid";
//
// ribbonPageGroup3
//
this.ribbonPageGroup3.ItemLinks.Add(this.barButtonItemLoadLayout);
this.ribbonPageGroup3.ItemLinks.Add(this.barButtonItemSaveLayout, true);
this.ribbonPageGroup3.Name = "ribbonPageGroup3";
this.ribbonPageGroup3.Text = "Layout";
//
// ribbonPageGroup1
//
this.ribbonPageGroup1.ItemLinks.Add(this.barButtonItemExcel);
this.ribbonPageGroup1.ItemLinks.Add(this.barButtonItemPrint, true);
this.ribbonPageGroup1.Name = "ribbonPageGroup1";
this.ribbonPageGroup1.Text = "Pivot";
//
// ribbonPageGroupChart
//
this.ribbonPageGroupChart.ItemLinks.Add(this.barButtonItemExcelChart);
this.ribbonPageGroupChart.ItemLinks.Add(this.barButtonItemStampaGrafico);
this.ribbonPageGroupChart.Name = "ribbonPageGroupChart";
this.ribbonPageGroupChart.Text = "Grafico";
//
// ribbonPageGroupTotal
//
this.ribbonPageGroupTotal.ItemLinks.Add(this.barCheckItemRow);
this.ribbonPageGroupTotal.ItemLinks.Add(this.barCheckItemCols);
this.ribbonPageGroupTotal.ItemLinks.Add(this.barCheckItemGrafico);
this.ribbonPageGroupTotal.Name = "ribbonPageGroupTotal";
this.ribbonPageGroupTotal.Text = "Opzioni";
//
// ribbonPageGroupOpt
//
this.ribbonPageGroupOpt.ItemLinks.Add(this.barButtonItemBestFit);
this.ribbonPageGroupOpt.ItemLinks.Add(this.barButtonShowFields);
this.ribbonPageGroupOpt.Name = "ribbonPageGroupOpt";
this.ribbonPageGroupOpt.Text = "Comandi";
//
// ribbonStatusBar
//
this.ribbonStatusBar.Location = new System.Drawing.Point(0, 696);
this.ribbonStatusBar.Name = "ribbonStatusBar";
this.ribbonStatusBar.Ribbon = this.ribbon;
this.ribbonStatusBar.Size = new System.Drawing.Size(758, 31);
//
// clientPanel
//
this.clientPanel.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.NoBorder;
this.clientPanel.Controls.Add(this.pivotGridControlStampe);
this.clientPanel.Dock = System.Windows.Forms.DockStyle.Fill;
this.clientPanel.Location = new System.Drawing.Point(200, 145);
this.clientPanel.Name = "clientPanel";
this.clientPanel.Size = new System.Drawing.Size(558, 551);
this.clientPanel.TabIndex = 2;
//
// pivotGridControlStampe
//
this.pivotGridControlStampe.Appearance.FieldValueGrandTotal.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Bold);
this.pivotGridControlStampe.Appearance.FieldValueGrandTotal.Options.UseFont = true;
this.pivotGridControlStampe.Appearance.FieldValueTotal.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Bold);
this.pivotGridControlStampe.Appearance.FieldValueTotal.Options.UseFont = true;
this.pivotGridControlStampe.Appearance.GrandTotalCell.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(255)))), ((int)(((byte)(128)))));
this.pivotGridControlStampe.Appearance.GrandTotalCell.Options.UseBackColor = true;
this.pivotGridControlStampe.Appearance.TotalCell.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(255)))), ((int)(((byte)(192)))));
this.pivotGridControlStampe.Appearance.TotalCell.Options.UseBackColor = true;
this.pivotGridControlStampe.Cursor = System.Windows.Forms.Cursors.Default;
this.pivotGridControlStampe.DataSource = this.xpCollectionEntrata;
this.pivotGridControlStampe.Dock = System.Windows.Forms.DockStyle.Fill;
this.pivotGridControlStampe.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.fieldModificatoDa,
this.fieldModificatoIl,
this.fieldCreatoDa,
this.fieldCreatoIl,
this.fieldRigaStampaIngressoIngressoDescrizione,
this.fieldDataOraEntrata,
this.fieldQuantita,
this.fieldDataOraEntrata1,
this.fieldDataOraEntrata2,
this.fieldDataOraEntrata3,
this.pivotGridFieldDataVendita,
this.pivotGridFieldPostazione,
this.pivotGridFieldStruttura,
this.pivotGridFieldTotalePersone,
this.pivotGridFieldTotaleIngressi,
this.pivotGridFieldCodiceVendita
});
pivotGridStyleFormatCondition1.Appearance.ForeColor = System.Drawing.Color.Transparent;
pivotGridStyleFormatCondition1.Appearance.Options.UseForeColor = true;
pivotGridStyleFormatCondition1.Condition = DevExpress.XtraGrid.FormatConditionEnum.Equal;
pivotGridStyleFormatCondition1.FieldName = "";
pivotGridStyleFormatCondition1.Value1 = "0";
pivotGridStyleFormatCondition2.Appearance.ForeColor = System.Drawing.Color.Transparent;
pivotGridStyleFormatCondition2.Appearance.Options.UseForeColor = true;
pivotGridStyleFormatCondition2.Condition = DevExpress.XtraGrid.FormatConditionEnum.Equal;
pivotGridStyleFormatCondition2.FieldName = "";
pivotGridStyleFormatCondition2.Value1 = "0";
pivotGridStyleFormatCondition3.Appearance.ForeColor = System.Drawing.Color.Transparent;
pivotGridStyleFormatCondition3.Appearance.Options.UseForeColor = true;
pivotGridStyleFormatCondition3.Condition = DevExpress.XtraGrid.FormatConditionEnum.Equal;
pivotGridStyleFormatCondition3.FieldName = "";
pivotGridStyleFormatCondition3.Value1 = "0";
pivotGridStyleFormatCondition4.Appearance.ForeColor = System.Drawing.Color.Transparent;
pivotGridStyleFormatCondition4.Appearance.Options.UseForeColor = true;
pivotGridStyleFormatCondition4.Condition = DevExpress.XtraGrid.FormatConditionEnum.Equal;
pivotGridStyleFormatCondition4.FieldName = "";
pivotGridStyleFormatCondition4.Value1 = "0";
this.pivotGridControlStampe.FormatConditions.AddRange(new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition[] {
pivotGridStyleFormatCondition1,
pivotGridStyleFormatCondition2,
pivotGridStyleFormatCondition3,
pivotGridStyleFormatCondition4
});
this.pivotGridControlStampe.Location = new System.Drawing.Point(0, 0);
this.pivotGridControlStampe.Name = "pivotGridControlStampe";
this.pivotGridControlStampe.OptionsChartDataSource.FieldValuesProvideMode = DevExpress.XtraPivotGrid.PivotChartFieldValuesProvideMode.DisplayText;
this.pivotGridControlStampe.OptionsLayout.StoreAllOptions = true;
this.pivotGridControlStampe.OptionsPrint.PageSettings.Landscape = true;
this.pivotGridControlStampe.OptionsPrint.PageSettings.Margins = new System.Drawing.Printing.Margins(50, 50, 50, 50);
this.pivotGridControlStampe.OptionsPrint.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.A4;
this.pivotGridControlStampe.OptionsView.ShowGrandTotalsForSingleValues = true;
this.pivotGridControlStampe.OptionsView.ShowTotalsForSingleValues = true;
this.pivotGridControlStampe.Size = new System.Drawing.Size(558, 551);
this.pivotGridControlStampe.TabIndex = 0;
this.pivotGridControlStampe.CustomSummary += new DevExpress.XtraPivotGrid.PivotGridCustomSummaryEventHandler(this.pivotGridControlStampe_CustomSummary);
this.pivotGridControlStampe.CellDoubleClick += new DevExpress.XtraPivotGrid.PivotCellEventHandler(this.pivotGridControlStampe_CellDoubleClick);
//
// xpCollectionEntrata
//
this.xpCollectionEntrata.CriteriaString = "[Oid] Is Null";
this.xpCollectionEntrata.ObjectType = typeof(Musei.Module.Entrata);
this.xpCollectionEntrata.Session = this.unitOfWork1;
//
// fieldModificatoDa
//
this.fieldModificatoDa.AreaIndex = 2;
this.fieldModificatoDa.Caption = "Modificato Da";
this.fieldModificatoDa.FieldName = "ModificatoDa";
this.fieldModificatoDa.Name = "fieldModificatoDa";
this.fieldModificatoDa.Visible = false;
//
// fieldModificatoIl
//
this.fieldModificatoIl.AreaIndex = 2;
this.fieldModificatoIl.Caption = "Modificato Il";
this.fieldModificatoIl.FieldName = "ModificatoIl";
this.fieldModificatoIl.Name = "fieldModificatoIl";
this.fieldModificatoIl.Visible = false;
//
// fieldCreatoDa
//
this.fieldCreatoDa.AreaIndex = 2;
this.fieldCreatoDa.Caption = "Creato Da";
this.fieldCreatoDa.FieldName = "CreatoDa";
this.fieldCreatoDa.Name = "fieldCreatoDa";
this.fieldCreatoDa.Visible = false;
//
// fieldCreatoIl
//
this.fieldCreatoIl.AreaIndex = 2;
this.fieldCreatoIl.Caption = "Creato Il";
this.fieldCreatoIl.FieldName = "CreatoIl";
this.fieldCreatoIl.Name = "fieldCreatoIl";
this.fieldCreatoIl.Visible = false;
//
// fieldRigaStampaIngressoIngressoDescrizione
//
this.fieldRigaStampaIngressoIngressoDescrizione.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldRigaStampaIngressoIngressoDescrizione.AreaIndex = 2;
this.fieldRigaStampaIngressoIngressoDescrizione.Caption = "Ingresso";
this.fieldRigaStampaIngressoIngressoDescrizione.FieldName = "RigaStampaIngresso.Ingresso.Descrizione";
this.fieldRigaStampaIngressoIngressoDescrizione.Name = "fieldRigaStampaIngressoIngressoDescrizione";
//
// fieldDataOraEntrata
//
this.fieldDataOraEntrata.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldDataOraEntrata.AreaIndex = 0;
this.fieldDataOraEntrata.Caption = "Ora";
this.fieldDataOraEntrata.FieldName = "DataOraEntrata";
this.fieldDataOraEntrata.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.Hour;
this.fieldDataOraEntrata.Name = "fieldDataOraEntrata";
this.fieldDataOraEntrata.UnboundFieldName = "fieldDataOraEntrata";
//
// fieldQuantita
//
this.fieldQuantita.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldQuantita.AreaIndex = 0;
this.fieldQuantita.Caption = "Quantita";
this.fieldQuantita.FieldName = "Quantita";
this.fieldQuantita.Name = "fieldQuantita";
//
// fieldDataOraEntrata1
//
this.fieldDataOraEntrata1.AreaIndex = 0;
this.fieldDataOraEntrata1.Caption = "Data";
this.fieldDataOraEntrata1.FieldName = "DataOraEntrata";
this.fieldDataOraEntrata1.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.Date;
this.fieldDataOraEntrata1.Name = "fieldDataOraEntrata1";
this.fieldDataOraEntrata1.UnboundFieldName = "fieldDataOraEntrata1";
//
// fieldDataOraEntrata2
//
this.fieldDataOraEntrata2.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldDataOraEntrata2.AreaIndex = 1;
this.fieldDataOraEntrata2.Caption = "Mese";
this.fieldDataOraEntrata2.FieldName = "DataOraEntrata";
this.fieldDataOraEntrata2.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateMonth;
this.fieldDataOraEntrata2.Name = "fieldDataOraEntrata2";
this.fieldDataOraEntrata2.UnboundFieldName = "fieldDataOraEntrata2";
//
// fieldDataOraEntrata3
//
this.fieldDataOraEntrata3.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldDataOraEntrata3.AreaIndex = 0;
this.fieldDataOraEntrata3.Caption = "Anno";
this.fieldDataOraEntrata3.FieldName = "DataOraEntrata";
this.fieldDataOraEntrata3.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateYear;
this.fieldDataOraEntrata3.Name = "fieldDataOraEntrata3";
this.fieldDataOraEntrata3.UnboundFieldName = "fieldDataOraEntrata3";
//
// pivotGridFieldDataVendita
//
this.pivotGridFieldDataVendita.AreaIndex = 2;
this.pivotGridFieldDataVendita.Caption = "Data Vendita";
this.pivotGridFieldDataVendita.CellFormat.FormatString = "d";
this.pivotGridFieldDataVendita.CellFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
this.pivotGridFieldDataVendita.FieldName = "RigaStampaIngresso.Stampa.Vendita.DataContabile";
this.pivotGridFieldDataVendita.Name = "pivotGridFieldDataVendita";
//
// pivotGridFieldPostazione
//
this.pivotGridFieldPostazione.AreaIndex = 1;
this.pivotGridFieldPostazione.Caption = "Postazione";
this.pivotGridFieldPostazione.FieldName = "RigaStampaIngresso.Stampa.Vendita.Postazione.Nome";
this.pivotGridFieldPostazione.Name = "pivotGridFieldPostazione";
//
// pivotGridFieldStruttura
//
this.pivotGridFieldStruttura.AreaIndex = 3;
this.pivotGridFieldStruttura.Caption = "Struttura";
this.pivotGridFieldStruttura.FieldName = "RigaStampaIngresso.Stampa.Vendita.Struttura.Descrizione";
this.pivotGridFieldStruttura.Name = "pivotGridFieldStruttura";
//
// pivotGridFieldTotalePersone
//
this.pivotGridFieldTotalePersone.AreaIndex = 4;
this.pivotGridFieldTotalePersone.Caption = "Totale Persone";
this.pivotGridFieldTotalePersone.FieldName = "RigaStampaIngresso.TotalePersone";
this.pivotGridFieldTotalePersone.Name = "pivotGridFieldTotalePersone";
this.pivotGridFieldTotalePersone.Visible = false;
//
// pivotGridFieldTotaleIngressi
//
this.pivotGridFieldTotaleIngressi.AreaIndex = 4;
this.pivotGridFieldTotaleIngressi.Caption = "Totale Ingressi";
this.pivotGridFieldTotaleIngressi.FieldName = "RigaStampaIngresso.TotaleIngressi";
this.pivotGridFieldTotaleIngressi.Name = "pivotGridFieldTotaleIngressi";
this.pivotGridFieldTotaleIngressi.Visible = false;
//
// pivotGridFieldCodiceVendita
//
this.pivotGridFieldCodiceVendita.AreaIndex = 4;
this.pivotGridFieldCodiceVendita.Caption = "Codice Vendita";
this.pivotGridFieldCodiceVendita.FieldName = "RigaStampaIngresso.Stampa.Vendita.CodiceLeggibile";
this.pivotGridFieldCodiceVendita.Name = "pivotGridFieldCodiceVendita";
this.pivotGridFieldCodiceVendita.Visible = false;
//
// dockPanelGrafico
//
this.dockPanelGrafico.Controls.Add(this.controlContainer1);
this.dockPanelGrafico.Dock = DevExpress.XtraBars.Docking.DockingStyle.Bottom;
this.dockPanelGrafico.ID = new System.Guid("4687cf1d-5f4c-4189-a660-fb5e452d1fd2");
this.dockPanelGrafico.Location = new System.Drawing.Point(200, 502);
this.dockPanelGrafico.Name = "dockPanelGrafico";
this.dockPanelGrafico.OriginalSize = new System.Drawing.Size(758, 200);
this.dockPanelGrafico.SavedDock = DevExpress.XtraBars.Docking.DockingStyle.Bottom;
this.dockPanelGrafico.SavedIndex = 1;
this.dockPanelGrafico.Size = new System.Drawing.Size(558, 200);
this.dockPanelGrafico.Text = "Chart";
this.dockPanelGrafico.Visibility = DevExpress.XtraBars.Docking.DockVisibility.Hidden;
//
// controlContainer1
//
this.controlContainer1.Controls.Add(this.chartControlPivot);
this.controlContainer1.Location = new System.Drawing.Point(3, 25);
this.controlContainer1.Name = "controlContainer1";
this.controlContainer1.Size = new System.Drawing.Size(552, 172);
this.controlContainer1.TabIndex = 0;
//
// chartControlPivot
//
this.chartControlPivot.DataSource = this.pivotGridControlStampe;
xyDiagram1.AxisX.Label.Staggered = true;
xyDiagram1.AxisX.Range.ScrollingRange.SideMarginsEnabled = true;
xyDiagram1.AxisX.Range.SideMarginsEnabled = true;
xyDiagram1.AxisX.VisibleInPanesSerializable = "-1";
xyDiagram1.AxisY.Range.ScrollingRange.SideMarginsEnabled = true;
xyDiagram1.AxisY.Range.SideMarginsEnabled = true;
xyDiagram1.AxisY.VisibleInPanesSerializable = "-1";
this.chartControlPivot.Diagram = xyDiagram1;
this.chartControlPivot.Dock = System.Windows.Forms.DockStyle.Fill;
this.chartControlPivot.Enabled = false;
this.chartControlPivot.Legend.MaxHorizontalPercentage = 30D;
this.chartControlPivot.Location = new System.Drawing.Point(0, 0);
this.chartControlPivot.Name = "chartControlPivot";
this.chartControlPivot.SeriesDataMember = "Series";
this.chartControlPivot.SeriesSerializable = new DevExpress.XtraCharts.Series[0];
this.chartControlPivot.SeriesTemplate.ArgumentDataMember = "Arguments";
sideBySideBarSeriesLabel1.LineVisible = true;
this.chartControlPivot.SeriesTemplate.Label = sideBySideBarSeriesLabel1;
this.chartControlPivot.SeriesTemplate.ValueDataMembersSerializable = "Values";
this.chartControlPivot.Size = new System.Drawing.Size(552, 172);
this.chartControlPivot.TabIndex = 0;
//
// dockManager1
//
this.dockManager1.Form = this;
this.dockManager1.HiddenPanels.AddRange(new DevExpress.XtraBars.Docking.DockPanel[] {
this.dockPanelGrafico
});
this.dockManager1.RootPanels.AddRange(new DevExpress.XtraBars.Docking.DockPanel[] {
this.dockPanelFiltro
});
this.dockManager1.TopZIndexControls.AddRange(new string[] {
"DevExpress.XtraBars.BarDockControl",
"System.Windows.Forms.StatusBar",
"DevExpress.XtraBars.Ribbon.RibbonStatusBar",
"DevExpress.XtraBars.Ribbon.RibbonControl"
});
//
// dockPanelFiltro
//
this.dockPanelFiltro.Appearance.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(247)))), ((int)(((byte)(245)))), ((int)(((byte)(241)))));
this.dockPanelFiltro.Appearance.Options.UseBackColor = true;
this.dockPanelFiltro.Controls.Add(this.dockPanel1_Container);
this.dockPanelFiltro.Dock = DevExpress.XtraBars.Docking.DockingStyle.Left;
this.dockPanelFiltro.ID = new System.Guid("b27d6157-0761-400f-8b25-71104558d951");
this.dockPanelFiltro.Location = new System.Drawing.Point(0, 145);
this.dockPanelFiltro.Name = "dockPanelFiltro";
this.dockPanelFiltro.OriginalSize = new System.Drawing.Size(200, 200);
this.dockPanelFiltro.Size = new System.Drawing.Size(200, 551);
this.dockPanelFiltro.Text = "Filtro";
//
// dockPanel1_Container
//
this.dockPanel1_Container.Controls.Add(this.checkEditPeriodo);
this.dockPanel1_Container.Controls.Add(this.simpleButtonQuery);
this.dockPanel1_Container.Controls.Add(this.labelControl3);
this.dockPanel1_Container.Controls.Add(this.checkedListBoxControl1);
this.dockPanel1_Container.Controls.Add(this.labelControl2);
this.dockPanel1_Container.Controls.Add(this.labelControl1);
this.dockPanel1_Container.Controls.Add(this.dateEditEnd);
this.dockPanel1_Container.Controls.Add(this.dateEditStart);
this.dockPanel1_Container.Location = new System.Drawing.Point(4, 23);
this.dockPanel1_Container.Name = "dockPanel1_Container";
this.dockPanel1_Container.Size = new System.Drawing.Size(192, 524);
this.dockPanel1_Container.TabIndex = 0;
//
// checkEditPeriodo
//
this.checkEditPeriodo.Location = new System.Drawing.Point(7, 129);
this.checkEditPeriodo.MenuManager = this.ribbon;
this.checkEditPeriodo.Name = "checkEditPeriodo";
this.checkEditPeriodo.Properties.Caption = "Stesso periodo anno per anno";
this.checkEditPeriodo.Size = new System.Drawing.Size(184, 19);
this.checkEditPeriodo.TabIndex = 7;
//
// simpleButtonQuery
//
this.simpleButtonQuery.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right)));
this.simpleButtonQuery.Image = global::WinTicketNext.Properties.Resources.media_play_green;
this.simpleButtonQuery.Location = new System.Drawing.Point(89, 472);
this.simpleButtonQuery.Name = "simpleButtonQuery";
this.simpleButtonQuery.Size = new System.Drawing.Size(100, 40);
this.simpleButtonQuery.TabIndex = 6;
this.simpleButtonQuery.Text = "Esegui";
this.simpleButtonQuery.Click += new System.EventHandler(this.simpleButtonQuery_Click);
//
// labelControl3
//
this.labelControl3.Location = new System.Drawing.Point(9, 169);
this.labelControl3.Name = "labelControl3";
this.labelControl3.Size = new System.Drawing.Size(42, 13);
this.labelControl3.TabIndex = 5;
this.labelControl3.Text = "Ingressi:";
//
// checkedListBoxControl1
//
this.checkedListBoxControl1.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.checkedListBoxControl1.CheckOnClick = true;
this.checkedListBoxControl1.DisplayMember = "Descrizione";
this.checkedListBoxControl1.HighlightedItemStyle = DevExpress.XtraEditors.HighlightStyle.Skinned;
this.checkedListBoxControl1.Location = new System.Drawing.Point(10, 188);
this.checkedListBoxControl1.Name = "checkedListBoxControl1";
this.checkedListBoxControl1.Size = new System.Drawing.Size(179, 278);
this.checkedListBoxControl1.TabIndex = 4;
this.checkedListBoxControl1.ValueMember = "This";
//
// labelControl2
//
this.labelControl2.Location = new System.Drawing.Point(9, 70);
this.labelControl2.Name = "labelControl2";
this.labelControl2.Size = new System.Drawing.Size(46, 13);
this.labelControl2.TabIndex = 3;
this.labelControl2.Text = "Data Fine";
//
// labelControl1
//
this.labelControl1.Location = new System.Drawing.Point(9, 16);
this.labelControl1.Name = "labelControl1";
this.labelControl1.Size = new System.Drawing.Size(51, 13);
this.labelControl1.TabIndex = 2;
this.labelControl1.Text = "Data Inizio";
//
// dateEditEnd
//
this.dateEditEnd.EditValue = null;
this.dateEditEnd.Location = new System.Drawing.Point(9, 89);
this.dateEditEnd.Name = "dateEditEnd";
this.dateEditEnd.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)
});
this.dateEditEnd.Properties.VistaTimeProperties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton()
});
this.dateEditEnd.Size = new System.Drawing.Size(100, 20);
this.dateEditEnd.TabIndex = 1;
//
// dateEditStart
//
this.dateEditStart.EditValue = null;
this.dateEditStart.Location = new System.Drawing.Point(9, 35);
this.dateEditStart.Name = "dateEditStart";
this.dateEditStart.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)
});
this.dateEditStart.Properties.VistaTimeProperties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton()
});
this.dateEditStart.Size = new System.Drawing.Size(100, 20);
this.dateEditStart.TabIndex = 0;
//
// saveFileDialogXls
//
this.saveFileDialogXls.DefaultExt = "xls";
this.saveFileDialogXls.Filter = "File Excel (*.xls)|*.xls|Tutti i file (*.*)|*.*";
//
// openFileDialogXML
//
this.openFileDialogXML.Filter = "File XML (*.xml)|*.xml|Tutti i file (*.*)|*.*";
//
// saveFileDialogXML
//
this.saveFileDialogXML.Filter = "File XML (*.xml)|*.xml|Tutti i file (*.*)|*.*";
//
// RibbonFormPivotEntrate
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(758, 727);
this.Controls.Add(this.clientPanel);
this.Controls.Add(this.dockPanelFiltro);
this.Controls.Add(this.ribbonStatusBar);
this.Controls.Add(this.ribbon);
this.Name = "RibbonFormPivotEntrate";
this.Ribbon = this.ribbon;
this.StatusBar = this.ribbonStatusBar;
this.Text = "Pivot Entrate";
this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
((System.ComponentModel.ISupportInitialize)(this.ribbon)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.clientPanel)).EndInit();
this.clientPanel.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.pivotGridControlStampe)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.xpCollectionEntrata)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.unitOfWork1)).EndInit();
this.dockPanelGrafico.ResumeLayout(false);
this.controlContainer1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(xyDiagram1)).EndInit();
((System.ComponentModel.ISupportInitialize)(sideBySideBarSeriesLabel1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.chartControlPivot)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dockManager1)).EndInit();
this.dockPanelFiltro.ResumeLayout(false);
this.dockPanel1_Container.ResumeLayout(false);
this.dockPanel1_Container.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.checkEditPeriodo.Properties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.checkedListBoxControl1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dateEditEnd.Properties.VistaTimeProperties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dateEditEnd.Properties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dateEditStart.Properties.VistaTimeProperties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dateEditStart.Properties)).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.XtraCharts.XYDiagram xyDiagram1 = new DevExpress.XtraCharts.XYDiagram();
DevExpress.XtraCharts.Series series1 = new DevExpress.XtraCharts.Series();
DevExpress.XtraCharts.SideBySideBarSeriesLabel sideBySideBarSeriesLabel1 = new DevExpress.XtraCharts.SideBySideBarSeriesLabel();
DevExpress.XtraCharts.Series series2 = new DevExpress.XtraCharts.Series();
DevExpress.XtraCharts.SideBySideBarSeriesLabel sideBySideBarSeriesLabel2 = new DevExpress.XtraCharts.SideBySideBarSeriesLabel();
DevExpress.XtraCharts.SideBySideBarSeriesLabel sideBySideBarSeriesLabel3 = new DevExpress.XtraCharts.SideBySideBarSeriesLabel();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition1 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(XBAN_Rpt001_frm));
this.fieldValor1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldBanco1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldEsChqImpreso1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.dockManager1 = new DevExpress.XtraBars.Docking.DockManager();
this.dockPanel1 = new DevExpress.XtraBars.Docking.DockPanel();
this.dockPanel1_Container = new DevExpress.XtraBars.Docking.ControlContainer();
this.chartControlBancos = new DevExpress.XtraCharts.ChartControl();
this.pivotGridControl_Matriz_cbte_ban = new DevExpress.XtraPivotGrid.PivotGridControl();
this.fieldTipoCbte1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldNumCbte1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldFchCbte1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldObservacion1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCheque1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldChqGiradoA1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldTipoFlujo1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldTipoNota1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldFchPostFechado1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldFchChq1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCtaCbleBanco1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldAnioFiscal1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldNombreMes1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldNombreCortoFecha1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldpcCuenta1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridFieldEstado = new DevExpress.XtraPivotGrid.PivotGridField();
this.toolStripMenuChard = new System.Windows.Forms.ToolStrip();
this.btn_imprimir_grafico = new System.Windows.Forms.ToolStripButton();
this.xBANRpt001InfoBindingSource = new System.Windows.Forms.BindingSource();
this.ucGe_Menu = new Core.Erp.Reportes.Controles.UCCom_Menu_Reportes();
this.panel1 = new System.Windows.Forms.Panel();
((System.ComponentModel.ISupportInitialize)(this.dockManager1)).BeginInit();
this.dockPanel1.SuspendLayout();
this.dockPanel1_Container.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.chartControlBancos)).BeginInit();
((System.ComponentModel.ISupportInitialize)(xyDiagram1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(series1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(sideBySideBarSeriesLabel1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(series2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(sideBySideBarSeriesLabel2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(sideBySideBarSeriesLabel3)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl_Matriz_cbte_ban)).BeginInit();
this.toolStripMenuChard.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.xBANRpt001InfoBindingSource)).BeginInit();
this.panel1.SuspendLayout();
this.SuspendLayout();
//
// fieldValor1
//
this.fieldValor1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldValor1.AreaIndex = 0;
this.fieldValor1.Caption = "Valor";
this.fieldValor1.FieldName = "Valor";
this.fieldValor1.Name = "fieldValor1";
//
// fieldBanco1
//
this.fieldBanco1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldBanco1.AreaIndex = 0;
this.fieldBanco1.Caption = "Banco";
this.fieldBanco1.FieldName = "Banco";
this.fieldBanco1.Name = "fieldBanco1";
this.fieldBanco1.Width = 113;
//
// fieldEsChqImpreso1
//
this.fieldEsChqImpreso1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldEsChqImpreso1.AreaIndex = 3;
this.fieldEsChqImpreso1.Caption = "Es Chq Impreso?";
this.fieldEsChqImpreso1.FieldName = "Es_Chq_Impreso";
this.fieldEsChqImpreso1.Name = "fieldEsChqImpreso1";
//
// dockManager1
//
this.dockManager1.Form = this;
this.dockManager1.RootPanels.AddRange(new DevExpress.XtraBars.Docking.DockPanel[] {
this.dockPanel1
});
this.dockManager1.TopZIndexControls.AddRange(new string[] {
"DevExpress.XtraBars.BarDockControl",
"DevExpress.XtraBars.StandaloneBarDockControl",
"System.Windows.Forms.StatusBar",
"DevExpress.XtraBars.Ribbon.RibbonStatusBar",
"DevExpress.XtraBars.Ribbon.RibbonControl"
});
//
// dockPanel1
//
this.dockPanel1.Controls.Add(this.dockPanel1_Container);
this.dockPanel1.Dock = DevExpress.XtraBars.Docking.DockingStyle.Bottom;
this.dockPanel1.ID = new System.Guid("423498d5-f61e-49a3-b692-7f321d698296");
this.dockPanel1.Location = new System.Drawing.Point(0, 314);
this.dockPanel1.Name = "dockPanel1";
this.dockPanel1.OriginalSize = new System.Drawing.Size(200, 185);
this.dockPanel1.Size = new System.Drawing.Size(1011, 185);
//
// dockPanel1_Container
//
this.dockPanel1_Container.Controls.Add(this.chartControlBancos);
this.dockPanel1_Container.Controls.Add(this.toolStripMenuChard);
this.dockPanel1_Container.Location = new System.Drawing.Point(4, 23);
this.dockPanel1_Container.Name = "dockPanel1_Container";
this.dockPanel1_Container.Size = new System.Drawing.Size(1003, 158);
this.dockPanel1_Container.TabIndex = 0;
//
// chartControlBancos
//
this.chartControlBancos.DataSource = this.pivotGridControl_Matriz_cbte_ban;
xyDiagram1.AxisX.Range.ScrollingRange.SideMarginsEnabled = true;
xyDiagram1.AxisX.Range.SideMarginsEnabled = true;
xyDiagram1.AxisX.VisibleInPanesSerializable = "-1";
xyDiagram1.AxisY.Range.ScrollingRange.SideMarginsEnabled = true;
xyDiagram1.AxisY.Range.SideMarginsEnabled = true;
xyDiagram1.AxisY.VisibleInPanesSerializable = "-1";
this.chartControlBancos.Diagram = xyDiagram1;
this.chartControlBancos.Dock = System.Windows.Forms.DockStyle.Fill;
this.chartControlBancos.Legend.MaxHorizontalPercentage = 30D;
this.chartControlBancos.Location = new System.Drawing.Point(0, 25);
this.chartControlBancos.Name = "chartControlBancos";
this.chartControlBancos.SeriesDataMember = "Series";
sideBySideBarSeriesLabel1.LineVisible = true;
series1.Label = sideBySideBarSeriesLabel1;
series1.Name = "Series 1";
sideBySideBarSeriesLabel2.LineVisible = true;
series2.Label = sideBySideBarSeriesLabel2;
series2.Name = "Series 2";
this.chartControlBancos.SeriesSerializable = new DevExpress.XtraCharts.Series[] {
series1,
series2
};
this.chartControlBancos.SeriesTemplate.ArgumentDataMember = "Arguments";
this.chartControlBancos.SeriesTemplate.ArgumentScaleType = DevExpress.XtraCharts.ScaleType.Qualitative;
sideBySideBarSeriesLabel3.LineVisible = true;
this.chartControlBancos.SeriesTemplate.Label = sideBySideBarSeriesLabel3;
this.chartControlBancos.SeriesTemplate.ValueDataMembersSerializable = "Values";
this.chartControlBancos.Size = new System.Drawing.Size(1003, 133);
this.chartControlBancos.TabIndex = 1;
//
// pivotGridControl_Matriz_cbte_ban
//
this.pivotGridControl_Matriz_cbte_ban.Dock = System.Windows.Forms.DockStyle.Fill;
this.pivotGridControl_Matriz_cbte_ban.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.fieldTipoCbte1,
this.fieldNumCbte1,
this.fieldBanco1,
this.fieldFchCbte1,
this.fieldObservacion1,
this.fieldValor1,
this.fieldCheque1,
this.fieldChqGiradoA1,
this.fieldTipoFlujo1,
this.fieldTipoNota1,
this.fieldFchPostFechado1,
this.fieldEsChqImpreso1,
this.fieldFchChq1,
this.fieldCtaCbleBanco1,
this.fieldAnioFiscal1,
this.fieldNombreMes1,
this.fieldNombreCortoFecha1,
this.fieldpcCuenta1,
this.pivotGridFieldEstado
});
pivotGridStyleFormatCondition1.Appearance.ForeColor = System.Drawing.Color.Red;
pivotGridStyleFormatCondition1.Appearance.Options.UseForeColor = true;
pivotGridStyleFormatCondition1.ApplyToCustomTotalCell = false;
pivotGridStyleFormatCondition1.ApplyToGrandTotalCell = false;
pivotGridStyleFormatCondition1.ApplyToTotalCell = false;
pivotGridStyleFormatCondition1.Condition = DevExpress.XtraGrid.FormatConditionEnum.Expression;
pivotGridStyleFormatCondition1.Expression = "[Es_Chq_Impreso] == \'No Impreso\'";
pivotGridStyleFormatCondition1.Field = this.fieldValor1;
pivotGridStyleFormatCondition1.FieldName = "fieldValor1";
this.pivotGridControl_Matriz_cbte_ban.FormatConditions.AddRange(new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition[] {
pivotGridStyleFormatCondition1
});
this.pivotGridControl_Matriz_cbte_ban.Location = new System.Drawing.Point(0, 0);
this.pivotGridControl_Matriz_cbte_ban.Name = "pivotGridControl_Matriz_cbte_ban";
this.pivotGridControl_Matriz_cbte_ban.Size = new System.Drawing.Size(1011, 219);
this.pivotGridControl_Matriz_cbte_ban.TabIndex = 0;
//
// fieldTipoCbte1
//
this.fieldTipoCbte1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldTipoCbte1.AreaIndex = 1;
this.fieldTipoCbte1.Caption = "Tipo/Cbte";
this.fieldTipoCbte1.FieldName = "Tipo_Cbte";
this.fieldTipoCbte1.Name = "fieldTipoCbte1";
//
// fieldNumCbte1
//
this.fieldNumCbte1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldNumCbte1.AreaIndex = 2;
this.fieldNumCbte1.Caption = "#Cbte";
this.fieldNumCbte1.FieldName = "Num_Cbte";
this.fieldNumCbte1.Name = "fieldNumCbte1";
//
// fieldFchCbte1
//
this.fieldFchCbte1.AreaIndex = 2;
this.fieldFchCbte1.Caption = "Fch/Cbte";
this.fieldFchCbte1.FieldName = "Fch_Cbte";
this.fieldFchCbte1.Name = "fieldFchCbte1";
//
// fieldObservacion1
//
this.fieldObservacion1.AreaIndex = 5;
this.fieldObservacion1.Caption = "Observacion";
this.fieldObservacion1.FieldName = "Observacion";
this.fieldObservacion1.Name = "fieldObservacion1";
//
// fieldCheque1
//
this.fieldCheque1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldCheque1.AreaIndex = 4;
this.fieldCheque1.Caption = "Cheque#";
this.fieldCheque1.FieldName = "Cheque";
this.fieldCheque1.Name = "fieldCheque1";
//
// fieldChqGiradoA1
//
this.fieldChqGiradoA1.AreaIndex = 6;
this.fieldChqGiradoA1.Caption = "Beneficiario";
this.fieldChqGiradoA1.FieldName = "Chq_Girado_A";
this.fieldChqGiradoA1.Name = "fieldChqGiradoA1";
//
// fieldTipoFlujo1
//
this.fieldTipoFlujo1.AreaIndex = 7;
this.fieldTipoFlujo1.Caption = "Tipo/Flujo";
this.fieldTipoFlujo1.FieldName = "Tipo_Flujo";
this.fieldTipoFlujo1.Name = "fieldTipoFlujo1";
//
// fieldTipoNota1
//
this.fieldTipoNota1.AreaIndex = 9;
this.fieldTipoNota1.Caption = "Tipo/Nota";
this.fieldTipoNota1.FieldName = "Tipo_Nota";
this.fieldTipoNota1.Name = "fieldTipoNota1";
//
// fieldFchPostFechado1
//
this.fieldFchPostFechado1.AreaIndex = 3;
this.fieldFchPostFechado1.Caption = "Fch PostFechado";
this.fieldFchPostFechado1.FieldName = "Fch_PostFechado";
this.fieldFchPostFechado1.Name = "fieldFchPostFechado1";
this.fieldFchPostFechado1.SortOrder = DevExpress.XtraPivotGrid.PivotSortOrder.Descending;
//
// fieldFchChq1
//
this.fieldFchChq1.AreaIndex = 4;
this.fieldFchChq1.Caption = "Fch Cheque";
this.fieldFchChq1.FieldName = "Fch_Chq";
this.fieldFchChq1.Name = "fieldFchChq1";
//
// fieldCtaCbleBanco1
//
this.fieldCtaCbleBanco1.AreaIndex = 0;
this.fieldCtaCbleBanco1.Caption = "Codigo Cble/Banco";
this.fieldCtaCbleBanco1.FieldName = "Cta_Cble_Banco";
this.fieldCtaCbleBanco1.Name = "fieldCtaCbleBanco1";
//
// fieldAnioFiscal1
//
this.fieldAnioFiscal1.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldAnioFiscal1.AreaIndex = 0;
this.fieldAnioFiscal1.Caption = "Año Fiscal";
this.fieldAnioFiscal1.FieldName = "AnioFiscal";
this.fieldAnioFiscal1.Name = "fieldAnioFiscal1";
//
// fieldNombreMes1
//
this.fieldNombreMes1.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldNombreMes1.AreaIndex = 1;
this.fieldNombreMes1.Caption = "Mes";
this.fieldNombreMes1.FieldName = "NombreMes";
this.fieldNombreMes1.Name = "fieldNombreMes1";
//
// fieldNombreCortoFecha1
//
this.fieldNombreCortoFecha1.AreaIndex = 8;
this.fieldNombreCortoFecha1.Caption = "Fecha";
this.fieldNombreCortoFecha1.FieldName = "NombreCortoFecha";
this.fieldNombreCortoFecha1.Name = "fieldNombreCortoFecha1";
//
// fieldpcCuenta1
//
this.fieldpcCuenta1.AreaIndex = 1;
this.fieldpcCuenta1.Caption = "Nombre Cble Banco";
this.fieldpcCuenta1.FieldName = "pc_Cuenta";
this.fieldpcCuenta1.Name = "fieldpcCuenta1";
//
// pivotGridFieldEstado
//
this.pivotGridFieldEstado.AreaIndex = 10;
this.pivotGridFieldEstado.FieldName = "Estado";
this.pivotGridFieldEstado.Name = "pivotGridFieldEstado";
//
// toolStripMenuChard
//
this.toolStripMenuChard.Items.AddRange(new System.Windows.Forms.ToolStripItem[] {
this.btn_imprimir_grafico
});
this.toolStripMenuChard.Location = new System.Drawing.Point(0, 0);
this.toolStripMenuChard.Name = "toolStripMenuChard";
this.toolStripMenuChard.Size = new System.Drawing.Size(1003, 25);
this.toolStripMenuChard.TabIndex = 0;
this.toolStripMenuChard.Text = "toolStrip1";
//
// btn_imprimir_grafico
//
this.btn_imprimir_grafico.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;
this.btn_imprimir_grafico.Image = ((System.Drawing.Image)(resources.GetObject("btn_imprimir_grafico.Image")));
this.btn_imprimir_grafico.ImageTransparentColor = System.Drawing.Color.Magenta;
this.btn_imprimir_grafico.Name = "btn_imprimir_grafico";
this.btn_imprimir_grafico.Size = new System.Drawing.Size(23, 22);
this.btn_imprimir_grafico.Text = "Imprimir";
this.btn_imprimir_grafico.Click += new System.EventHandler(this.btn_imprimir_grafico_Click);
//
// xBANRpt001InfoBindingSource
//
this.xBANRpt001InfoBindingSource.DataSource = typeof(Core.Erp.Reportes.Bancos.XBAN_Rpt001_Info);
//
// ucGe_Menu
//
this.ucGe_Menu.Dock = System.Windows.Forms.DockStyle.Top;
this.ucGe_Menu.Enable_boton_Imprimir = true;
this.ucGe_Menu.Enable_boton_Refrescar = true;
this.ucGe_Menu.Enable_boton_Salir = true;
this.ucGe_Menu.Location = new System.Drawing.Point(0, 0);
this.ucGe_Menu.Name = "ucGe_Menu";
this.ucGe_Menu.Size = new System.Drawing.Size(1011, 95);
this.ucGe_Menu.TabIndex = 0;
this.ucGe_Menu.Visible_boton_Imprimir = DevExpress.XtraBars.BarItemVisibility.Always;
this.ucGe_Menu.Visible_boton_Refrescar = DevExpress.XtraBars.BarItemVisibility.Always;
this.ucGe_Menu.Visible_boton_Salir = DevExpress.XtraBars.BarItemVisibility.Always;
this.ucGe_Menu.Visible_Grupo_acciones = true;
this.ucGe_Menu.Visible_Grupo_filtro = true;
this.ucGe_Menu.event_btnImprimir_ItemClick += new Core.Erp.Reportes.Controles.UCCom_Menu_Reportes.delegate_btnImprimir_ItemClick(this.ucGe_Menu_event_btnImprimir_ItemClick);
this.ucGe_Menu.event_btnRefrescar_ItemClick += new Core.Erp.Reportes.Controles.UCCom_Menu_Reportes.delegate_btnRefrescar_ItemClick(this.ucGe_Menu_event_btnRefrescar_ItemClick);
this.ucGe_Menu.event_btnsalir_ItemClick += new Core.Erp.Reportes.Controles.UCCom_Menu_Reportes.delegate_btnsalir_ItemClick(this.ucGe_Menu_event_btnsalir_ItemClick);
//
// panel1
//
this.panel1.Controls.Add(this.pivotGridControl_Matriz_cbte_ban);
this.panel1.Dock = System.Windows.Forms.DockStyle.Fill;
this.panel1.Location = new System.Drawing.Point(0, 95);
this.panel1.Name = "panel1";
this.panel1.Size = new System.Drawing.Size(1011, 219);
this.panel1.TabIndex = 8;
//
// XBAN_Rpt001_frm
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(1011, 499);
this.Controls.Add(this.panel1);
this.Controls.Add(this.ucGe_Menu);
this.Controls.Add(this.dockPanel1);
this.Name = "XBAN_Rpt001_frm";
this.Text = "XBAN_Rpt001_frm";
((System.ComponentModel.ISupportInitialize)(this.dockManager1)).EndInit();
this.dockPanel1.ResumeLayout(false);
this.dockPanel1_Container.ResumeLayout(false);
this.dockPanel1_Container.PerformLayout();
((System.ComponentModel.ISupportInitialize)(xyDiagram1)).EndInit();
((System.ComponentModel.ISupportInitialize)(sideBySideBarSeriesLabel1)).EndInit();
((System.ComponentModel.ISupportInitialize)(series1)).EndInit();
((System.ComponentModel.ISupportInitialize)(sideBySideBarSeriesLabel2)).EndInit();
((System.ComponentModel.ISupportInitialize)(series2)).EndInit();
((System.ComponentModel.ISupportInitialize)(sideBySideBarSeriesLabel3)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.chartControlBancos)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControl_Matriz_cbte_ban)).EndInit();
this.toolStripMenuChard.ResumeLayout(false);
this.toolStripMenuChard.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.xBANRpt001InfoBindingSource)).EndInit();
this.panel1.ResumeLayout(false);
this.ResumeLayout(false);
}
//增加网格显示的格式化样式信息。
private void addConditionsForStyles(DevExpress.XtraPivotGrid.PivotGridControl gridCtl, MB.WinBase.IFace.IClientRuleQueryBase busObj)
{
if (busObj == null)
{
return;
}
Dictionary <string, MB.WinBase.Common.StyleConditionInfo> styleConditions = busObj.UIRuleXmlConfigInfo.GetDefaultStyleConditions();
if (styleConditions == null)
{
return;
}
XWinLib.Share.StyleCfgList styleList = XWinLib.Share.StyleCfgList.CreateInstance();
if (styleList == null)
{
return;
}
foreach (MB.WinBase.Common.StyleConditionInfo info in styleConditions.Values)
{
//判断定义的样式是否存在。
if (!styleList.ContainsKey(info.StyleName))
{
MB.Util.TraceEx.Write(string.Format("样式 {0} 需要在AppStylesConfig.xml 文件中配置,如果已经配置请检查大小写。", info.StyleName), MB.Util.APPMessageType.SysErrInfo);
continue;
}
DevExpress.XtraPivotGrid.PivotGridField pivField = gridCtl.Fields[info.ColumnName];
if (pivField == null)
{
MB.Util.TraceEx.Write(string.Format("字段 {0} 的 Style Format condition 列名称的配置，在数据源中找不到对应的列，请检查。", info.ColumnName), MB.Util.APPMessageType.SysErrInfo);
continue;
}
XWinLib.Share.StyleCfgInfo styleInfo = styleList[info.StyleName];
//如果存在DispColName 的话，需要也是处理，在本应该程序中是在GridView的RowCellStyle事件中进行处理。
if (info.IsByEvent || (info.DispColName != null && info.DispColName.Length > 0 && info.DispColName != info.ColumnName))
{
continue;
}
//创建FormatCondition。
if (gridCtl.FormatConditions[info.Name] == null)
{
DevExpress.XtraGrid.FormatConditionEnum cc = (DevExpress.XtraGrid.FormatConditionEnum)Enum.Parse(typeof(DevExpress.XtraGrid.FormatConditionEnum), Enum.GetName(typeof(DataFilterConditions), info.Condition));
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition styleCondition = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
styleCondition.Appearance.BackColor = styleInfo.BackColor;
styleCondition.Appearance.ForeColor = styleInfo.ForeColor;
styleCondition.Appearance.Font = styleInfo.Font;
styleCondition.Appearance.Options.UseBackColor = true;
styleCondition.Appearance.Options.UseForeColor = true;
styleCondition.ApplyToCustomTotalCell = false;
styleCondition.ApplyToGrandTotalCell = false;
styleCondition.ApplyToTotalCell = false;
styleCondition.Condition = (DevExpress.XtraGrid.FormatConditionEnum)Enum.Parse(typeof(DevExpress.XtraGrid.FormatConditionEnum), Enum.GetName(typeof(DataFilterConditions), info.Condition));
styleCondition.Field = pivField;
styleCondition.Value1 = info.Value;
styleCondition.Value2 = info.Value2;
gridCtl.FormatConditions.Add(styleCondition);
}
}
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(f402_tong_hop_cham_cong));
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition1 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition2 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition3 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition4 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition5 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
this.panelControl1 = new DevExpress.XtraEditors.PanelControl();
this.m_cmd_export_excel = new DevExpress.XtraEditors.SimpleButton();
this.m_sle_chon_nhan_vien = new DevExpress.XtraEditors.SearchLookUpEdit();
this.searchLookUpEdit1View = new DevExpress.XtraGrid.Views.Grid.GridView();
this.gridColumn1 = new DevExpress.XtraGrid.Columns.GridColumn();
this.gridColumn2 = new DevExpress.XtraGrid.Columns.GridColumn();
this.m_pv = 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();
this.pivotGridField6 = new DevExpress.XtraPivotGrid.PivotGridField();
this.pivotGridField7 = new DevExpress.XtraPivotGrid.PivotGridField();
this.panelControl2 = new DevExpress.XtraEditors.PanelControl();
((System.ComponentModel.ISupportInitialize)(this.panelControl1)).BeginInit();
this.panelControl1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.m_sle_chon_nhan_vien.Properties)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.searchLookUpEdit1View)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.m_pv)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.panelControl2)).BeginInit();
this.panelControl2.SuspendLayout();
this.SuspendLayout();
//
// panelControl1
//
this.panelControl1.Controls.Add(this.m_cmd_export_excel);
this.panelControl1.Dock = System.Windows.Forms.DockStyle.Bottom;
this.panelControl1.Location = new System.Drawing.Point(0, 421);
this.panelControl1.Name = "panelControl1";
this.panelControl1.Size = new System.Drawing.Size(857, 48);
this.panelControl1.TabIndex = 1;
//
// m_cmd_export_excel
//
this.m_cmd_export_excel.Dock = System.Windows.Forms.DockStyle.Left;
this.m_cmd_export_excel.Image = ((System.Drawing.Image)(resources.GetObject("m_cmd_export_excel.Image")));
this.m_cmd_export_excel.ImageIndex = 1;
this.m_cmd_export_excel.Location = new System.Drawing.Point(2, 2);
this.m_cmd_export_excel.Name = "m_cmd_export_excel";
this.m_cmd_export_excel.Size = new System.Drawing.Size(142, 44);
this.m_cmd_export_excel.TabIndex = 23;
this.m_cmd_export_excel.Text = "Trích xuất dữ liệu";
//
// m_sle_chon_nhan_vien
//
this.m_sle_chon_nhan_vien.Location = new System.Drawing.Point(12, 12);
this.m_sle_chon_nhan_vien.Name = "m_sle_chon_nhan_vien";
this.m_sle_chon_nhan_vien.Properties.Appearance.Font = new System.Drawing.Font("Tahoma", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.m_sle_chon_nhan_vien.Properties.Appearance.Options.UseFont = true;
this.m_sle_chon_nhan_vien.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
this.m_sle_chon_nhan_vien.Properties.DisplayMember = "HO_TEN";
this.m_sle_chon_nhan_vien.Properties.NullText = "-----Tất cả nhân viên-----";
this.m_sle_chon_nhan_vien.Properties.ValueMember = "ID";
this.m_sle_chon_nhan_vien.Properties.View = this.searchLookUpEdit1View;
this.m_sle_chon_nhan_vien.Size = new System.Drawing.Size(187, 20);
this.m_sle_chon_nhan_vien.TabIndex = 5;
//
// searchLookUpEdit1View
//
this.searchLookUpEdit1View.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] {
this.gridColumn1,
this.gridColumn2});
this.searchLookUpEdit1View.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFocus;
this.searchLookUpEdit1View.Name = "searchLookUpEdit1View";
this.searchLookUpEdit1View.OptionsSelection.EnableAppearanceFocusedCell = false;
this.searchLookUpEdit1View.OptionsView.ShowGroupPanel = false;
//
// gridColumn1
//
this.gridColumn1.Caption = "MÃ_NV";
this.gridColumn1.FieldName = "MA_NV";
this.gridColumn1.Name = "gridColumn1";
this.gridColumn1.Visible = true;
this.gridColumn1.VisibleIndex = 0;
//
// gridColumn2
//
this.gridColumn2.Caption = "HỌ TÊN";
this.gridColumn2.FieldName = "HO_TEN";
this.gridColumn2.Name = "gridColumn2";
this.gridColumn2.Visible = true;
this.gridColumn2.VisibleIndex = 1;
//
// m_pv
//
this.m_pv.Dock = System.Windows.Forms.DockStyle.Fill;
this.m_pv.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.pivotGridField1,
this.pivotGridField2,
this.pivotGridField3,
this.pivotGridField4,
this.pivotGridField5,
this.pivotGridField6,
this.pivotGridField7});
pivotGridStyleFormatCondition1.Appearance.BackColor = System.Drawing.Color.Silver;
pivotGridStyleFormatCondition1.Appearance.Options.UseBackColor = true;
pivotGridStyleFormatCondition1.ApplyToCustomTotalCell = false;
pivotGridStyleFormatCondition1.ApplyToGrandTotalCell = false;
pivotGridStyleFormatCondition1.ApplyToTotalCell = false;
pivotGridStyleFormatCondition1.Condition = DevExpress.XtraGrid.FormatConditionEnum.Equal;
pivotGridStyleFormatCondition1.FieldName = "";
pivotGridStyleFormatCondition1.Value1 = "";
pivotGridStyleFormatCondition2.Appearance.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(255)))));
pivotGridStyleFormatCondition2.Appearance.Options.UseBackColor = true;
pivotGridStyleFormatCondition2.ApplyToCustomTotalCell = false;
pivotGridStyleFormatCondition2.ApplyToGrandTotalCell = false;
pivotGridStyleFormatCondition2.ApplyToTotalCell = false;
pivotGridStyleFormatCondition2.Condition = DevExpress.XtraGrid.FormatConditionEnum.Equal;
pivotGridStyleFormatCondition2.FieldName = "";
pivotGridStyleFormatCondition2.Value1 = "TS";
pivotGridStyleFormatCondition3.Appearance.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(192)))), ((int)(((byte)(255)))));
pivotGridStyleFormatCondition3.Appearance.Options.UseBackColor = true;
pivotGridStyleFormatCondition3.ApplyToCustomTotalCell = false;
pivotGridStyleFormatCondition3.ApplyToGrandTotalCell = false;
pivotGridStyleFormatCondition3.ApplyToTotalCell = false;
pivotGridStyleFormatCondition3.FieldName = "";
pivotGridStyleFormatCondition3.Value1 = "OM";
pivotGridStyleFormatCondition4.Appearance.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(255)))), ((int)(((byte)(128)))));
pivotGridStyleFormatCondition4.Appearance.Options.UseBackColor = true;
pivotGridStyleFormatCondition4.ApplyToCustomTotalCell = false;
pivotGridStyleFormatCondition4.ApplyToGrandTotalCell = false;
pivotGridStyleFormatCondition4.ApplyToTotalCell = false;
pivotGridStyleFormatCondition4.Condition = DevExpress.XtraGrid.FormatConditionEnum.Expression;
pivotGridStyleFormatCondition4.Expression = "[MA_NGAY_CONG] != \'X\' And [MA_NGAY_CONG] != \'\'";
pivotGridStyleFormatCondition4.FieldName = "";
pivotGridStyleFormatCondition5.Appearance.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(224)))), ((int)(((byte)(224)))), ((int)(((byte)(224)))));
pivotGridStyleFormatCondition5.Appearance.Options.UseBackColor = true;
pivotGridStyleFormatCondition5.ApplyToCustomTotalCell = false;
pivotGridStyleFormatCondition5.ApplyToGrandTotalCell = false;
pivotGridStyleFormatCondition5.ApplyToTotalCell = false;
pivotGridStyleFormatCondition5.Condition = DevExpress.XtraGrid.FormatConditionEnum.Expression;
pivotGridStyleFormatCondition5.Expression = "GetDayOfWeek( [NGAY_CHAM_CONG]) = 6 and GetDayOfWeek( [NGAY_CHAM_CONG]) = 0.";
pivotGridStyleFormatCondition5.FieldName = "";
this.m_pv.FormatConditions.AddRange(new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition[] {
pivotGridStyleFormatCondition1,
pivotGridStyleFormatCondition2,
pivotGridStyleFormatCondition3,
pivotGridStyleFormatCondition4,
pivotGridStyleFormatCondition5});
this.m_pv.Location = new System.Drawing.Point(0, 39);
this.m_pv.Name = "m_pv";
this.m_pv.OptionsView.ShowColumnGrandTotalHeader = false;
this.m_pv.OptionsView.ShowColumnGrandTotals = false;
this.m_pv.OptionsView.ShowColumnTotals = false;
this.m_pv.OptionsView.ShowRowGrandTotalHeader = false;
this.m_pv.OptionsView.ShowRowGrandTotals = false;
this.m_pv.OptionsView.ShowRowTotals = false;
this.m_pv.Size = new System.Drawing.Size(857, 382);
this.m_pv.TabIndex = 2;
//
// pivotGridField1
//
this.pivotGridField1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.pivotGridField1.AreaIndex = 2;
this.pivotGridField1.Caption = "Họ tên";
this.pivotGridField1.FieldName = "HO_TEN";
this.pivotGridField1.Name = "pivotGridField1";
this.pivotGridField1.Options.AllowSort = DevExpress.Utils.DefaultBoolean.False;
this.pivotGridField1.Options.ShowGrandTotal = false;
this.pivotGridField1.SortMode = DevExpress.XtraPivotGrid.PivotSortMode.None;
this.pivotGridField1.Width = 170;
//
// pivotGridField2
//
this.pivotGridField2.Appearance.Cell.Options.UseTextOptions = true;
this.pivotGridField2.Appearance.Cell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.pivotGridField2.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.pivotGridField2.AreaIndex = 0;
this.pivotGridField2.Caption = "Mã ngày công";
this.pivotGridField2.FieldName = "MA_NGAY_CONG";
this.pivotGridField2.Name = "pivotGridField2";
this.pivotGridField2.Options.ShowGrandTotal = false;
this.pivotGridField2.SortOrder = DevExpress.XtraPivotGrid.PivotSortOrder.Descending;
this.pivotGridField2.Width = 60;
//
// pivotGridField3
//
this.pivotGridField3.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.pivotGridField3.AreaIndex = 0;
this.pivotGridField3.Caption = "Số ngày công";
this.pivotGridField3.FieldName = "SO_NGAY_CONG";
this.pivotGridField3.Name = "pivotGridField3";
this.pivotGridField3.Options.ShowGrandTotal = false;
this.pivotGridField3.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Max;
//
// pivotGridField4
//
this.pivotGridField4.Appearance.Cell.Options.UseTextOptions = true;
this.pivotGridField4.Appearance.Cell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.pivotGridField4.Appearance.Value.Options.UseTextOptions = true;
this.pivotGridField4.Appearance.Value.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.pivotGridField4.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.pivotGridField4.AreaIndex = 3;
this.pivotGridField4.Caption = "Số NC tiêu chuẩn";
this.pivotGridField4.FieldName = "SO_NGAY_CONG_TIEU_CHUAN";
this.pivotGridField4.Name = "pivotGridField4";
this.pivotGridField4.Options.ShowGrandTotal = false;
this.pivotGridField4.Width = 120;
//
// pivotGridField5
//
this.pivotGridField5.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.pivotGridField5.AreaIndex = 1;
this.pivotGridField5.Caption = "Mã NV";
this.pivotGridField5.FieldName = "MA_NV";
this.pivotGridField5.Name = "pivotGridField5";
//
// pivotGridField6
//
this.pivotGridField6.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.pivotGridField6.AreaIndex = 0;
this.pivotGridField6.Caption = "Đơn vị";
this.pivotGridField6.FieldName = "TEN_DON_VI";
this.pivotGridField6.Name = "pivotGridField6";
this.pivotGridField6.Width = 150;
//
// pivotGridField7
//
this.pivotGridField7.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.pivotGridField7.AreaIndex = 0;
this.pivotGridField7.Caption = "Thứ tự hiển thị";
this.pivotGridField7.FieldName = "THU_TU_DON_VI";
this.pivotGridField7.Name = "pivotGridField7";
this.pivotGridField7.Visible = false;
//
// panelControl2
//
this.panelControl2.Controls.Add(this.m_sle_chon_nhan_vien);
this.panelControl2.Dock = System.Windows.Forms.DockStyle.Top;
this.panelControl2.Location = new System.Drawing.Point(0, 0);
this.panelControl2.Name = "panelControl2";
this.panelControl2.Size = new System.Drawing.Size(857, 39);
this.panelControl2.TabIndex = 3;
this.panelControl2.Visible = false;
//
// f402_tong_hop_cham_cong
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(857, 469);
this.Controls.Add(this.m_pv);
this.Controls.Add(this.panelControl2);
this.Controls.Add(this.panelControl1);
this.Name = "f402_tong_hop_cham_cong";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "F402 - Tổng hợp chấm công";
this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
((System.ComponentModel.ISupportInitialize)(this.panelControl1)).EndInit();
this.panelControl1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.m_sle_chon_nhan_vien.Properties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.searchLookUpEdit1View)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.m_pv)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.panelControl2)).EndInit();
this.panelControl2.ResumeLayout(false);
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.PivotGridStyleFormatCondition pivotGridStyleFormatCondition1 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition2 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition3 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition4 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
this.fieldRouteBrand1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.repositoryItemTextEditPers = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit();
this.repositoryItemTextEditf2 = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit();
this.repositoryItemTextEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit();
this.popupMenuMain = new DevExpress.XtraBars.PopupMenu(this.components);
this.barManagerMain = new DevExpress.XtraBars.BarManager(this.components);
this.bar1 = new DevExpress.XtraBars.Bar();
this.barHeaderItem1 = new DevExpress.XtraBars.BarHeaderItem();
this.bbiStartDate = new DevExpress.XtraBars.BarEditItem();
this.repositoryItemDateEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit();
this.bbiGetData = new DevExpress.XtraBars.BarLargeButtonItem();
this.bbiExport = new DevExpress.XtraBars.BarButtonItem();
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.repositoryItemDateEdit2 = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit();
this.pivotGridControlMain = new DevExpress.XtraPivotGrid.PivotGridControl();
this.dsNMQry = new NestleICSales.DataSources.dsQry();
this.fieldRouteNumber1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldRouteName1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldSupervisor1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldPlantSalesDistrict1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldPlantName1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldPlantBaseName1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldDistributionChannel1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldActive1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldEquipment1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCustomer = new DevExpress.XtraPivotGrid.PivotGridField();
this.calcEqAvg = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCType = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldCustomerType = new DevExpress.XtraPivotGrid.PivotGridField();
this.dxValidationProviderMain = new DevExpress.XtraEditors.DXErrorProvider.DXValidationProvider(this.components);
this.pro0002BindingSource = new System.Windows.Forms.BindingSource(this.components);
this.pro_0002TableAdapter = new NestleICSales.DataSources.dsQryTableAdapters.Pro_0002TableAdapter();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditPers)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditf2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEdit1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.popupMenuMain)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.barManagerMain)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1.CalendarTimeProperties)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2.CalendarTimeProperties)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControlMain)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dsNMQry)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dxValidationProviderMain)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.pro0002BindingSource)).BeginInit();
this.SuspendLayout();
//
// fieldRouteBrand1
//
this.fieldRouteBrand1.AreaIndex = 1;
this.fieldRouteBrand1.Caption = "Route Brand";
this.fieldRouteBrand1.FieldName = "RouteBrand";
this.fieldRouteBrand1.Name = "fieldRouteBrand1";
//
// repositoryItemTextEditPers
//
this.repositoryItemTextEditPers.AutoHeight = false;
this.repositoryItemTextEditPers.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.repositoryItemTextEditPers.EditFormat.FormatString = "P1";
this.repositoryItemTextEditPers.EditFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.repositoryItemTextEditPers.ExportMode = DevExpress.XtraEditors.Repository.ExportMode.DisplayText;
this.repositoryItemTextEditPers.Mask.EditMask = "P1";
this.repositoryItemTextEditPers.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
this.repositoryItemTextEditPers.Mask.UseMaskAsDisplayFormat = true;
this.repositoryItemTextEditPers.Name = "repositoryItemTextEditPers";
//
// repositoryItemTextEditf2
//
this.repositoryItemTextEditf2.AutoHeight = false;
this.repositoryItemTextEditf2.DisplayFormat.FormatString = "f2";
this.repositoryItemTextEditf2.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.repositoryItemTextEditf2.Mask.EditMask = "f2";
this.repositoryItemTextEditf2.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
this.repositoryItemTextEditf2.Name = "repositoryItemTextEditf2";
//
// repositoryItemTextEdit1
//
this.repositoryItemTextEdit1.AutoHeight = false;
this.repositoryItemTextEdit1.Name = "repositoryItemTextEdit1";
//
// popupMenuMain
//
this.popupMenuMain.Manager = this.barManagerMain;
this.popupMenuMain.Name = "popupMenuMain";
//
// barManagerMain
//
this.barManagerMain.Bars.AddRange(new DevExpress.XtraBars.Bar[] {
this.bar1});
this.barManagerMain.DockControls.Add(this.barDockControlTop);
this.barManagerMain.DockControls.Add(this.barDockControlBottom);
this.barManagerMain.DockControls.Add(this.barDockControlLeft);
this.barManagerMain.DockControls.Add(this.barDockControlRight);
this.barManagerMain.Form = this;
this.barManagerMain.Items.AddRange(new DevExpress.XtraBars.BarItem[] {
this.bbiExport,
this.bbiStartDate,
this.barHeaderItem1,
this.bbiGetData});
this.barManagerMain.MaxItemId = 10;
this.barManagerMain.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] {
this.repositoryItemDateEdit1,
this.repositoryItemDateEdit2});
//
// bar1
//
this.bar1.BarName = "Main";
this.bar1.DockCol = 0;
this.bar1.DockRow = 0;
this.bar1.DockStyle = DevExpress.XtraBars.BarDockStyle.Top;
this.bar1.LinksPersistInfo.AddRange(new DevExpress.XtraBars.LinkPersistInfo[] {
new DevExpress.XtraBars.LinkPersistInfo(this.barHeaderItem1),
new DevExpress.XtraBars.LinkPersistInfo(this.bbiStartDate),
new DevExpress.XtraBars.LinkPersistInfo(DevExpress.XtraBars.BarLinkUserDefines.PaintStyle, this.bbiGetData, DevExpress.XtraBars.BarItemPaintStyle.CaptionGlyph),
new DevExpress.XtraBars.LinkPersistInfo(this.bbiExport)});
this.bar1.Text = "Custom 2";
//
// barHeaderItem1
//
this.barHeaderItem1.Caption = "Select Date";
this.barHeaderItem1.Id = 3;
this.barHeaderItem1.Name = "barHeaderItem1";
//
// bbiStartDate
//
this.bbiStartDate.Caption = "Start Date";
this.bbiStartDate.Edit = this.repositoryItemDateEdit1;
this.bbiStartDate.Id = 2;
this.bbiStartDate.ItemShortcut = new DevExpress.XtraBars.BarShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.D1));
this.bbiStartDate.Name = "bbiStartDate";
this.bbiStartDate.Width = 120;
//
// 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";
//
// bbiGetData
//
this.bbiGetData.Caption = "Get Data";
this.bbiGetData.CaptionAlignment = DevExpress.XtraBars.BarItemCaptionAlignment.Right;
this.bbiGetData.Glyph = global::NestleICSales.Properties.Resources.apply_16x16;
this.bbiGetData.Id = 9;
this.bbiGetData.ItemShortcut = new DevExpress.XtraBars.BarShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.G));
this.bbiGetData.Name = "bbiGetData";
this.bbiGetData.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.bbiGetData_ItemClick);
//
// bbiExport
//
this.bbiExport.Caption = "Export";
this.bbiExport.Glyph = global::NestleICSales.Properties.Resources.Export;
this.bbiExport.Id = 1;
this.bbiExport.ItemShortcut = new DevExpress.XtraBars.BarShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.E));
this.bbiExport.Name = "bbiExport";
this.bbiExport.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.bbiExport_ItemClick);
//
// 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(1132, 31);
//
// barDockControlBottom
//
this.barDockControlBottom.CausesValidation = false;
this.barDockControlBottom.Dock = System.Windows.Forms.DockStyle.Bottom;
this.barDockControlBottom.Location = new System.Drawing.Point(0, 311);
this.barDockControlBottom.Size = new System.Drawing.Size(1132, 0);
//
// barDockControlLeft
//
this.barDockControlLeft.CausesValidation = false;
this.barDockControlLeft.Dock = System.Windows.Forms.DockStyle.Left;
this.barDockControlLeft.Location = new System.Drawing.Point(0, 31);
this.barDockControlLeft.Size = new System.Drawing.Size(0, 280);
//
// barDockControlRight
//
this.barDockControlRight.CausesValidation = false;
this.barDockControlRight.Dock = System.Windows.Forms.DockStyle.Right;
this.barDockControlRight.Location = new System.Drawing.Point(1132, 31);
this.barDockControlRight.Size = new System.Drawing.Size(0, 280);
//
// repositoryItemDateEdit2
//
this.repositoryItemDateEdit2.AutoHeight = false;
this.repositoryItemDateEdit2.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
this.repositoryItemDateEdit2.CalendarTimeProperties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
this.repositoryItemDateEdit2.Name = "repositoryItemDateEdit2";
//
// pivotGridControlMain
//
this.pivotGridControlMain.DataSource = this.pro0002BindingSource;
this.pivotGridControlMain.Dock = System.Windows.Forms.DockStyle.Fill;
this.pivotGridControlMain.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.fieldRouteNumber1,
this.fieldRouteName1,
this.fieldSupervisor1,
this.fieldRouteBrand1,
this.fieldPlantSalesDistrict1,
this.fieldPlantName1,
this.fieldPlantBaseName1,
this.fieldDistributionChannel1,
this.fieldActive1,
this.fieldEquipment1,
this.fieldCustomer,
this.calcEqAvg,
this.fieldCType,
this.fieldCustomerType});
pivotGridStyleFormatCondition1.Appearance.BackColor = System.Drawing.Color.Red;
pivotGridStyleFormatCondition1.Appearance.BackColor2 = System.Drawing.Color.White;
pivotGridStyleFormatCondition1.Appearance.GradientMode = System.Drawing.Drawing2D.LinearGradientMode.ForwardDiagonal;
pivotGridStyleFormatCondition1.Appearance.Options.UseBackColor = true;
pivotGridStyleFormatCondition1.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less;
pivotGridStyleFormatCondition1.Field = this.fieldRouteBrand1;
pivotGridStyleFormatCondition1.FieldName = "fieldRouteBrand1";
pivotGridStyleFormatCondition1.Value1 = "1";
pivotGridStyleFormatCondition2.Appearance.BackColor = System.Drawing.Color.Green;
pivotGridStyleFormatCondition2.Appearance.BackColor2 = System.Drawing.Color.White;
pivotGridStyleFormatCondition2.Appearance.GradientMode = System.Drawing.Drawing2D.LinearGradientMode.ForwardDiagonal;
pivotGridStyleFormatCondition2.Appearance.Options.UseBackColor = true;
pivotGridStyleFormatCondition2.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual;
pivotGridStyleFormatCondition2.Field = this.fieldRouteBrand1;
pivotGridStyleFormatCondition2.FieldName = "fieldRouteBrand1";
pivotGridStyleFormatCondition2.Value1 = "1";
pivotGridStyleFormatCondition3.Appearance.BackColor = System.Drawing.Color.Red;
pivotGridStyleFormatCondition3.Appearance.BackColor2 = System.Drawing.Color.White;
pivotGridStyleFormatCondition3.Appearance.GradientMode = System.Drawing.Drawing2D.LinearGradientMode.ForwardDiagonal;
pivotGridStyleFormatCondition3.Appearance.Options.UseBackColor = true;
pivotGridStyleFormatCondition3.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less;
pivotGridStyleFormatCondition3.Field = this.fieldRouteBrand1;
pivotGridStyleFormatCondition3.FieldName = "fieldRouteBrand1";
pivotGridStyleFormatCondition3.Value1 = "1";
pivotGridStyleFormatCondition4.Appearance.BackColor = System.Drawing.Color.Green;
pivotGridStyleFormatCondition4.Appearance.BackColor2 = System.Drawing.Color.White;
pivotGridStyleFormatCondition4.Appearance.GradientMode = System.Drawing.Drawing2D.LinearGradientMode.ForwardDiagonal;
pivotGridStyleFormatCondition4.Appearance.Options.UseBackColor = true;
pivotGridStyleFormatCondition4.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual;
pivotGridStyleFormatCondition4.Field = this.fieldRouteBrand1;
pivotGridStyleFormatCondition4.FieldName = "fieldRouteBrand1";
pivotGridStyleFormatCondition4.Value1 = "1";
this.pivotGridControlMain.FormatConditions.AddRange(new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition[] {
pivotGridStyleFormatCondition1,
pivotGridStyleFormatCondition2,
pivotGridStyleFormatCondition3,
pivotGridStyleFormatCondition4});
this.pivotGridControlMain.Location = new System.Drawing.Point(0, 31);
this.pivotGridControlMain.Name = "pivotGridControlMain";
this.pivotGridControlMain.OptionsPrint.PrintColumnHeaders = DevExpress.Utils.DefaultBoolean.False;
this.pivotGridControlMain.OptionsPrint.PrintDataHeaders = DevExpress.Utils.DefaultBoolean.False;
this.pivotGridControlMain.OptionsPrint.PrintFilterHeaders = DevExpress.Utils.DefaultBoolean.False;
this.pivotGridControlMain.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] {
this.repositoryItemTextEditPers});
this.pivotGridControlMain.Size = new System.Drawing.Size(1132, 280);
this.pivotGridControlMain.TabIndex = 9;
//
// dsNMQry
//
this.dsNMQry.DataSetName = "dsNMQry";
this.dsNMQry.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// fieldRouteNumber1
//
this.fieldRouteNumber1.AreaIndex = 0;
this.fieldRouteNumber1.Caption = "Route Number";
this.fieldRouteNumber1.FieldName = "RouteNumber";
this.fieldRouteNumber1.Name = "fieldRouteNumber1";
//
// fieldRouteName1
//
this.fieldRouteName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldRouteName1.AreaIndex = 1;
this.fieldRouteName1.Caption = "Route Name";
this.fieldRouteName1.FieldName = "RouteName";
this.fieldRouteName1.Name = "fieldRouteName1";
//
// fieldSupervisor1
//
this.fieldSupervisor1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldSupervisor1.AreaIndex = 0;
this.fieldSupervisor1.Caption = "Supervisor";
this.fieldSupervisor1.FieldName = "Supervisor";
this.fieldSupervisor1.Name = "fieldSupervisor1";
//
// fieldPlantSalesDistrict1
//
this.fieldPlantSalesDistrict1.AreaIndex = 2;
this.fieldPlantSalesDistrict1.Caption = "Plant Sales District";
this.fieldPlantSalesDistrict1.FieldName = "PlantSalesDistrict";
this.fieldPlantSalesDistrict1.Name = "fieldPlantSalesDistrict1";
//
// fieldPlantName1
//
this.fieldPlantName1.AreaIndex = 3;
this.fieldPlantName1.Caption = "Plant Name";
this.fieldPlantName1.FieldName = "PlantName";
this.fieldPlantName1.Name = "fieldPlantName1";
//
// fieldPlantBaseName1
//
this.fieldPlantBaseName1.AreaIndex = 4;
this.fieldPlantBaseName1.Caption = "Plant Base Name";
this.fieldPlantBaseName1.FieldName = "PlantBaseName";
this.fieldPlantBaseName1.Name = "fieldPlantBaseName1";
//
// fieldDistributionChannel1
//
this.fieldDistributionChannel1.AreaIndex = 5;
this.fieldDistributionChannel1.Caption = "Distribution Channel";
this.fieldDistributionChannel1.FieldName = "DistributionChannel";
this.fieldDistributionChannel1.Name = "fieldDistributionChannel1";
//
// fieldActive1
//
this.fieldActive1.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldActive1.AreaIndex = 0;
this.fieldActive1.Caption = "Active";
this.fieldActive1.FieldName = "Active";
this.fieldActive1.Name = "fieldActive1";
//
// fieldEquipment1
//
this.fieldEquipment1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldEquipment1.AreaIndex = 1;
this.fieldEquipment1.Caption = "Frz";
this.fieldEquipment1.FieldName = "Equipment";
this.fieldEquipment1.Name = "fieldEquipment1";
//
// fieldCustomer
//
this.fieldCustomer.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldCustomer.AreaIndex = 0;
this.fieldCustomer.Caption = "Customer";
this.fieldCustomer.FieldName = "Customer";
this.fieldCustomer.Name = "fieldCustomer";
//
// calcEqAvg
//
this.calcEqAvg.Appearance.Cell.ForeColor = System.Drawing.Color.Red;
this.calcEqAvg.Appearance.Cell.Options.UseForeColor = true;
this.calcEqAvg.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.calcEqAvg.AreaIndex = 2;
this.calcEqAvg.Caption = "Arg Frz";
this.calcEqAvg.FieldName = "Equipment";
this.calcEqAvg.Name = "calcEqAvg";
this.calcEqAvg.SummaryDisplayType = DevExpress.Data.PivotGrid.PivotSummaryDisplayType.PercentOfRow;
//
// fieldCType
//
this.fieldCType.AreaIndex = 6;
this.fieldCType.Caption = "Frz Type";
this.fieldCType.FieldName = "CType";
this.fieldCType.Name = "fieldCType";
//
// fieldCustomerType
//
this.fieldCustomerType.AreaIndex = 7;
this.fieldCustomerType.Caption = "Customer Type";
this.fieldCustomerType.FieldName = "CustomerType";
this.fieldCustomerType.Name = "fieldCustomerType";
//
// pro0002BindingSource
//
this.pro0002BindingSource.DataMember = "Pro_0002";
this.pro0002BindingSource.DataSource = this.dsNMQry;
//
// pro_0002TableAdapter
//
this.pro_0002TableAdapter.ClearBeforeFill = true;
//
// QryPro_0002Frm
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(1132, 311);
this.Controls.Add(this.pivotGridControlMain);
this.Controls.Add(this.barDockControlLeft);
this.Controls.Add(this.barDockControlRight);
this.Controls.Add(this.barDockControlBottom);
this.Controls.Add(this.barDockControlTop);
this.Icon = global::NestleICSales.Properties.Resources.Qry16;
this.Name = "QryPro_0002Frm";
this.Text = "Zero Sales MTD";
((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditPers)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditf2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEdit1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.popupMenuMain)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.barManagerMain)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1.CalendarTimeProperties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2.CalendarTimeProperties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControlMain)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dsNMQry)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dxValidationProviderMain)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.pro0002BindingSource)).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.PivotGridStyleFormatCondition pivotGridStyleFormatCondition2 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
this.calcMashHalaPer = new DevExpress.XtraPivotGrid.PivotGridField();
this.panelControl1 = new DevExpress.XtraEditors.PanelControl();
this.btnPrintExport = new DevExpress.XtraEditors.SimpleButton();
this.pivotGridControlMain = new DevExpress.XtraPivotGrid.PivotGridControl();
this.vQry31BindingSource = new System.Windows.Forms.BindingSource(this.components);
this.dsQueries = new RetirementCenter.DataSources.dsQueries();
this.fieldCountMMashatId = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldyasref1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldSarfExpetion1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldmcompletesarf1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldSyndicate1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldSubCommitte1 = new DevExpress.XtraPivotGrid.PivotGridField();
this.fieldMashHala = new DevExpress.XtraPivotGrid.PivotGridField();
this.vQry31TableAdapter = new RetirementCenter.DataSources.dsQueriesTableAdapters.vQry31TableAdapter();
((System.ComponentModel.ISupportInitialize)(this.panelControl1)).BeginInit();
this.panelControl1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.pivotGridControlMain)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.vQry31BindingSource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dsQueries)).BeginInit();
this.SuspendLayout();
//
// calcMashHalaPer
//
this.calcMashHalaPer.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.calcMashHalaPer.AreaIndex = 1;
this.calcMashHalaPer.Caption = "نسبة";
this.calcMashHalaPer.CellFormat.FormatString = "p2";
this.calcMashHalaPer.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.calcMashHalaPer.FieldName = "CountMMashatId";
this.calcMashHalaPer.GrandTotalCellFormat.FormatString = "p2";
this.calcMashHalaPer.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.calcMashHalaPer.Name = "calcMashHalaPer";
this.calcMashHalaPer.Options.ShowGrandTotal = false;
this.calcMashHalaPer.SummaryDisplayType = DevExpress.Data.PivotGrid.PivotSummaryDisplayType.PercentOfRowGrandTotal;
this.calcMashHalaPer.TotalCellFormat.FormatString = "p2";
this.calcMashHalaPer.TotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.calcMashHalaPer.TotalValueFormat.FormatString = "p2";
this.calcMashHalaPer.TotalValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.calcMashHalaPer.ValueFormat.FormatString = "p2";
this.calcMashHalaPer.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
//
// panelControl1
//
this.panelControl1.Controls.Add(this.btnPrintExport);
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(734, 47);
this.panelControl1.TabIndex = 3;
//
// btnPrintExport
//
this.btnPrintExport.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.btnPrintExport.Location = new System.Drawing.Point(588, 12);
this.btnPrintExport.Name = "btnPrintExport";
this.btnPrintExport.Size = new System.Drawing.Size(134, 23);
this.btnPrintExport.TabIndex = 0;
this.btnPrintExport.Text = "طباعه و تصدير";
this.btnPrintExport.Click += new System.EventHandler(this.btnPrintExport_Click);
//
// pivotGridControlMain
//
this.pivotGridControlMain.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.pivotGridControlMain.DataSource = this.vQry31BindingSource;
this.pivotGridControlMain.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
this.fieldCountMMashatId,
this.fieldyasref1,
this.fieldSarfExpetion1,
this.fieldmcompletesarf1,
this.fieldSyndicate1,
this.fieldSubCommitte1,
this.fieldMashHala,
this.calcMashHalaPer});
pivotGridStyleFormatCondition1.Appearance.ForeColor = System.Drawing.Color.Green;
pivotGridStyleFormatCondition1.Appearance.Options.UseForeColor = true;
pivotGridStyleFormatCondition1.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual;
pivotGridStyleFormatCondition1.Field = this.calcMashHalaPer;
pivotGridStyleFormatCondition1.FieldName = "calcMashHalaPer";
pivotGridStyleFormatCondition1.Value1 = ".5";
pivotGridStyleFormatCondition2.Appearance.ForeColor = System.Drawing.Color.Red;
pivotGridStyleFormatCondition2.Appearance.Options.UseForeColor = true;
pivotGridStyleFormatCondition2.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less;
pivotGridStyleFormatCondition2.Field = this.calcMashHalaPer;
pivotGridStyleFormatCondition2.FieldName = "calcMashHalaPer";
pivotGridStyleFormatCondition2.Value1 = ".5";
this.pivotGridControlMain.FormatConditions.AddRange(new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition[] {
pivotGridStyleFormatCondition1,
pivotGridStyleFormatCondition2});
this.pivotGridControlMain.Location = new System.Drawing.Point(0, 53);
this.pivotGridControlMain.Name = "pivotGridControlMain";
this.pivotGridControlMain.Size = new System.Drawing.Size(734, 408);
this.pivotGridControlMain.TabIndex = 4;
//
// vQry31BindingSource
//
this.vQry31BindingSource.DataMember = "vQry31";
this.vQry31BindingSource.DataSource = this.dsQueries;
//
// dsQueries
//
this.dsQueries.DataSetName = "dsQueries";
this.dsQueries.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// fieldCountMMashatId
//
this.fieldCountMMashatId.Appearance.Cell.Options.UseTextOptions = true;
this.fieldCountMMashatId.Appearance.Cell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.fieldCountMMashatId.Appearance.Header.Options.UseTextOptions = true;
this.fieldCountMMashatId.Appearance.Header.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.fieldCountMMashatId.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldCountMMashatId.AreaIndex = 0;
this.fieldCountMMashatId.Caption = "العدد";
this.fieldCountMMashatId.FieldName = "CountMMashatId";
this.fieldCountMMashatId.Name = "fieldCountMMashatId";
//
// fieldyasref1
//
this.fieldyasref1.Appearance.Cell.Options.UseTextOptions = true;
this.fieldyasref1.Appearance.Cell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.fieldyasref1.Appearance.Header.Options.UseTextOptions = true;
this.fieldyasref1.Appearance.Header.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.fieldyasref1.AreaIndex = 0;
this.fieldyasref1.Caption = "يصرف";
this.fieldyasref1.FieldName = "yasref";
this.fieldyasref1.Name = "fieldyasref1";
//
// fieldSarfExpetion1
//
this.fieldSarfExpetion1.Appearance.Cell.Options.UseTextOptions = true;
this.fieldSarfExpetion1.Appearance.Cell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.fieldSarfExpetion1.Appearance.Header.Options.UseTextOptions = true;
this.fieldSarfExpetion1.Appearance.Header.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.fieldSarfExpetion1.AreaIndex = 1;
this.fieldSarfExpetion1.Caption = "استثناء";
this.fieldSarfExpetion1.FieldName = "SarfExpetion";
this.fieldSarfExpetion1.Name = "fieldSarfExpetion1";
//
// fieldmcompletesarf1
//
this.fieldmcompletesarf1.Appearance.Cell.Options.UseTextOptions = true;
this.fieldmcompletesarf1.Appearance.Cell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.fieldmcompletesarf1.Appearance.Header.Options.UseTextOptions = true;
this.fieldmcompletesarf1.Appearance.Header.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.fieldmcompletesarf1.AreaIndex = 2;
this.fieldmcompletesarf1.Caption = "صرف كامل";
this.fieldmcompletesarf1.FieldName = "mcompletesarf";
this.fieldmcompletesarf1.Name = "fieldmcompletesarf1";
//
// fieldSyndicate1
//
this.fieldSyndicate1.Appearance.Cell.Options.UseTextOptions = true;
this.fieldSyndicate1.Appearance.Cell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.fieldSyndicate1.Appearance.Header.Options.UseTextOptions = true;
this.fieldSyndicate1.Appearance.Header.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.fieldSyndicate1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldSyndicate1.AreaIndex = 0;
this.fieldSyndicate1.Caption = "فرعية";
this.fieldSyndicate1.FieldName = "Syndicate";
this.fieldSyndicate1.Name = "fieldSyndicate1";
//
// fieldSubCommitte1
//
this.fieldSubCommitte1.Appearance.Cell.Options.UseTextOptions = true;
this.fieldSubCommitte1.Appearance.Cell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.fieldSubCommitte1.Appearance.Header.Options.UseTextOptions = true;
this.fieldSubCommitte1.Appearance.Header.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.fieldSubCommitte1.AreaIndex = 3;
this.fieldSubCommitte1.Caption = "لجنة";
this.fieldSubCommitte1.FieldName = "SubCommitte";
this.fieldSubCommitte1.Name = "fieldSubCommitte1";
//
// fieldMashHala
//
this.fieldMashHala.Appearance.Cell.Options.UseTextOptions = true;
this.fieldMashHala.Appearance.Cell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.fieldMashHala.Appearance.Header.Options.UseTextOptions = true;
this.fieldMashHala.Appearance.Header.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.fieldMashHala.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldMashHala.AreaIndex = 0;
this.fieldMashHala.Caption = "الحالة";
this.fieldMashHala.FieldName = "MashHala";
this.fieldMashHala.Name = "fieldMashHala";
//
// vQry31TableAdapter
//
this.vQry31TableAdapter.ClearBeforeFill = true;
//
// Qry31Frm
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(734, 462);
this.Controls.Add(this.pivotGridControlMain);
this.Controls.Add(this.panelControl1);
this.Name = "Qry31Frm";
this.Text = "احصائيات الاعضاء";
this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
this.Load += new System.EventHandler(this.Qry06Frm_Load);
this.Shown += new System.EventHandler(this.Qry31Frm_Shown);
((System.ComponentModel.ISupportInitialize)(this.panelControl1)).EndInit();
this.panelControl1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.pivotGridControlMain)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.vQry31BindingSource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dsQueries)).EndInit();
this.ResumeLayout(false);
}
