Beispiel #1
0
        //根据分组的类型设置默认的分组数据。
//		private static void setDefaultFormatByGroup(DevExpress.XtraPivotGrid.PivotGridField pivField){
//			switch(pivField.GroupInterval){
//				case DevExpress.XtraPivotGrid.PivotGroupInterval.DateYear:
//					pivField.ValueFormat.FormatString = "{0} 年";
//					pivField.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
//					break;
//				case DevExpress.XtraPivotGrid.PivotGroupInterval.DateQuarter:
//					pivField.ValueFormat.FormatString = "季节 {0}";
//					pivField.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
//					break;
//				case DevExpress.XtraPivotGrid.PivotGroupInterval.DateMonth:
//					pivField.ValueFormat.FormatString = "{0} 月";
//					pivField.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
//					break;
//				case DevExpress.XtraPivotGrid.PivotGroupInterval.DateWeekOfYear:
//				case DevExpress.XtraPivotGrid.PivotGroupInterval.DateWeekOfMonth:
//					pivField.ValueFormat.FormatString = "第 {0} 周";
//					pivField.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
//					break;
//				case DevExpress.XtraPivotGrid.PivotGroupInterval.DateDayOfWeek:
//					pivField.ValueFormat.FormatString = "星期 {0}";
//					pivField.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
//					break;
//				case DevExpress.XtraPivotGrid.PivotGroupInterval.DateDay:
//					break;
//				default:
//					break;
//			}
//
//		}
        //创建一个新的PivotGridField 对象。
        private DevExpress.XtraPivotGrid.PivotGridField createNewPivotField(string fieldName, string fieldDesc, DevExpress.XtraPivotGrid.PivotGridControl gridCtl)
        {
            DevExpress.XtraPivotGrid.PivotGridField pivField = new DevExpress.XtraPivotGrid.PivotGridField();
            pivField.Name      = "pivCol" + fieldName;
            pivField.FieldName = fieldName;
            pivField.Caption   = fieldDesc;
            gridCtl.Fields.Add(pivField);
            gridCtl.OptionsLayout.StoreAllOptions = true;
            return(pivField);
        }
Beispiel #2
0
        private void okSimpleButton_Click(object sender, EventArgs e)
        {
            int    columnCount;
            string fieldName = "";

            DevExpress.Data.UnboundColumnType dataType;

            if (!dxValidationProvider1.Validate())
            {
                return;
            }

            try
            {
                dataType = (DevExpress.Data.UnboundColumnType)radioGroup1.EditValue;
                switch (gridType)
                {
                case CurrentGridType.GridView:

                    columnCount = gridView.Columns.Count;
                    fieldName   = "ExpressionCol" + columnCount;
                    gridView.Columns.AddVisible(fieldName, captionTextEdit.Text);
                    gridView.Columns[fieldName].ShowUnboundExpressionMenu = true;
                    gridView.Columns[fieldName].UnboundType             = dataType;
                    gridView.Columns[fieldName].OptionsColumn.AllowEdit = false;
                    gridView.ShowUnboundExpressionEditor(gridView.Columns[fieldName]);

                    break;

                case CurrentGridType.PivotGrid:
                    columnCount = pvc.Fields.Count;
                    fieldName   = "ExpressionCol" + columnCount;
                    DevExpress.XtraPivotGrid.PivotGridField expField = new DevExpress.XtraPivotGrid.PivotGridField(fieldName, DevExpress.XtraPivotGrid.PivotArea.FilterArea);
                    expField.Options.ShowUnboundExpressionMenu = true;
                    expField.UnboundType = dataType;
                    expField.Caption     = captionTextEdit.Text;
                    pvc.Fields.Add(expField);
                    pvc.ShowUnboundExpressionEditor(pvc.Fields[fieldName]);
                    pvc.OptionsLayout.StoreAllOptions = true;

                    break;

                default:
                    break;
                }

                this.Close();
            }
            catch (Exception ex)
            {
                XtraMessageBox.Show(ex.Message);
            }
        }
Beispiel #3
0
        private void PivotGridEx_FieldAreaChanged(object sender, DevExpress.XtraPivotGrid.PivotFieldEventArgs e)
        {
            createSummarySortItem();

            foreach (DevExpress.XtraPivotGrid.PivotGridField info in this.Fields)
            {
                if (info.Area == DevExpress.XtraPivotGrid.PivotArea.RowArea)
                {
                    _SummarySortField = info;
                }
            }
        }
Beispiel #4
0
 private void InitNewReport(DevExpress.XtraGrid.Views.Grid.GridView sourceGridView)
 {
     pivotGridControl1.Fields.Clear();
     foreach (DevExpress.XtraGrid.Columns.GridColumn c in sourceGridView.Columns)
     {
         DevExpress.XtraPivotGrid.PivotGridField newField = new DevExpress.XtraPivotGrid.PivotGridField(c.FieldName, DevExpress.XtraPivotGrid.PivotArea.FilterArea);
         newField.Name                    = "field" + c.FieldName;
         newField.Caption                 = c.Caption;
         newField.CellFormat.Format       = c.DisplayFormat.Format;
         newField.ValueFormat.Format      = c.DisplayFormat.Format;
         newField.TotalValueFormat.Format = c.DisplayFormat.Format;
         pivotGridControl1.Fields.Add(newField);
     }
 }
Beispiel #5
0
 //处理字段结合绑定的情况
 private void processUnitField(ColPivotList xmlCfgLst, DevExpress.XtraPivotGrid.PivotGridControl gridCtl)
 {
     if (xmlCfgLst == null || xmlCfgLst.FieldGroups == null || xmlCfgLst.FieldGroups.Length == 0)
     {
         return;
     }
     string[] groups = xmlCfgLst.FieldGroups.Split(';');
     foreach (string group in groups)
     {
         string[] fields = group.Split(',');
         DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup = new DevExpress.XtraPivotGrid.PivotGridGroup();
         gridCtl.Groups.Add(pivotGridGroup);
         foreach (string field in fields)
         {
             DevExpress.XtraPivotGrid.PivotGridField pivField = gridCtl.Fields[field];
             if (pivField == null)
             {
                 continue;
             }
             pivotGridGroup.Add(pivField);
         }
     }
 }
Beispiel #6
0
 /// <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();
     this.gvGymAnalysis           = new DevExpress.XtraPivotGrid.PivotGridControl();
     this.pivotGridField1         = new DevExpress.XtraPivotGrid.PivotGridField();
     this.pivotGridField2         = new DevExpress.XtraPivotGrid.PivotGridField();
     this.pivotGridField3         = new DevExpress.XtraPivotGrid.PivotGridField();
     this.DateFrom                = new DevExpress.XtraEditors.DateEdit();
     this.DateTo                  = new DevExpress.XtraEditors.DateEdit();
     this.TimeFrom                = new DevExpress.XtraEditors.TimeEdit();
     this.TimeTo                  = new DevExpress.XtraEditors.TimeEdit();
     this.label63                 = new System.Windows.Forms.Label();
     this.label1                  = new System.Windows.Forms.Label();
     this.label2                  = new System.Windows.Forms.Label();
     this.label3                  = new System.Windows.Forms.Label();
     this.btnReset                = new DevExpress.XtraEditors.SimpleButton();
     this.PRINT1                  = new DevExpress.XtraEditors.HyperLinkEdit();
     this.printingSystem1         = new DevExpress.XtraPrinting.PrintingSystem(this.components);
     this.printableComponentLink1 = new DevExpress.XtraPrinting.PrintableComponentLink(this.components);
     ((System.ComponentModel.ISupportInitialize)(this.gvGymAnalysis)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.DateFrom.Properties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.DateTo.Properties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.TimeFrom.Properties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.TimeTo.Properties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.PRINT1.Properties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.printingSystem1)).BeginInit();
     this.SuspendLayout();
     //
     // gvGymAnalysis
     //
     this.gvGymAnalysis.Cursor = System.Windows.Forms.Cursors.Default;
     this.gvGymAnalysis.Dock   = System.Windows.Forms.DockStyle.Bottom;
     this.gvGymAnalysis.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
         this.pivotGridField1,
         this.pivotGridField2,
         this.pivotGridField3
     });
     this.gvGymAnalysis.Location = new System.Drawing.Point(0, 38);
     this.gvGymAnalysis.Name     = "gvGymAnalysis";
     this.gvGymAnalysis.OptionsCustomization.AllowDrag   = false;
     this.gvGymAnalysis.OptionsCustomization.AllowFilter = false;
     this.gvGymAnalysis.OptionsCustomization.AllowSort   = false;
     this.gvGymAnalysis.OptionsView.ShowDataHeaders      = false;
     this.gvGymAnalysis.OptionsView.ShowFilterHeaders    = false;
     this.gvGymAnalysis.Size     = new System.Drawing.Size(962, 448);
     this.gvGymAnalysis.TabIndex = 0;
     //
     // pivotGridField1
     //
     this.pivotGridField1.Area        = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.pivotGridField1.AreaIndex   = 0;
     this.pivotGridField1.FieldName   = "nClassInstanceID";
     this.pivotGridField1.Name        = "pivotGridField1";
     this.pivotGridField1.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Count;
     //
     // pivotGridField2
     //
     this.pivotGridField2.Area      = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
     this.pivotGridField2.AreaIndex = 0;
     this.pivotGridField2.Caption   = "Branch";
     this.pivotGridField2.FieldName = "strBranchCode";
     this.pivotGridField2.Name      = "pivotGridField2";
     //
     // pivotGridField3
     //
     this.pivotGridField3.Area      = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.pivotGridField3.AreaIndex = 0;
     this.pivotGridField3.Caption   = "Date";
     this.pivotGridField3.FieldName = "dtDate";
     this.pivotGridField3.Name      = "pivotGridField3";
     this.pivotGridField3.ValueFormat.FormatString = "MM/dd/yyyy";
     this.pivotGridField3.ValueFormat.FormatType   = DevExpress.Utils.FormatType.DateTime;
     //
     // DateFrom
     //
     this.DateFrom.EditValue = null;
     this.DateFrom.Location  = new System.Drawing.Point(80, 8);
     this.DateFrom.Name      = "DateFrom";
     //
     // DateFrom.Properties
     //
     this.DateFrom.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
         new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)
     });
     this.DateFrom.Properties.DisplayFormat.FormatString = "dd/MM/yyyy";
     this.DateFrom.Properties.DisplayFormat.FormatType   = DevExpress.Utils.FormatType.Custom;
     this.DateFrom.Properties.EditFormat.FormatString    = "dd/MM/yyyy";
     this.DateFrom.Properties.EditFormat.FormatType      = DevExpress.Utils.FormatType.Custom;
     this.DateFrom.Properties.Mask.EditMask = "dd/MM/yyyy";
     this.DateFrom.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.DateTimeAdvancingCaret;
     this.DateFrom.TabIndex = 1;
     //
     // DateTo
     //
     this.DateTo.EditValue = null;
     this.DateTo.Location  = new System.Drawing.Point(256, 8);
     this.DateTo.Name      = "DateTo";
     //
     // DateTo.Properties
     //
     this.DateTo.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
         new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)
     });
     this.DateTo.Properties.DisplayFormat.FormatString = "dd/MM/yyyy";
     this.DateTo.Properties.DisplayFormat.FormatType   = DevExpress.Utils.FormatType.Custom;
     this.DateTo.Properties.EditFormat.FormatString    = "dd/MM/yyyy";
     this.DateTo.Properties.EditFormat.FormatType      = DevExpress.Utils.FormatType.Custom;
     this.DateTo.Properties.Mask.EditMask = "dd/MM/yyyy";
     this.DateTo.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.DateTimeAdvancingCaret;
     this.DateTo.TabIndex = 2;
     //
     // TimeFrom
     //
     this.TimeFrom.EditValue = new System.DateTime(2006, 8, 23, 0, 0, 0, 0);
     this.TimeFrom.Location  = new System.Drawing.Point(456, 8);
     this.TimeFrom.Name      = "TimeFrom";
     //
     // TimeFrom.Properties
     //
     this.TimeFrom.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
         new DevExpress.XtraEditors.Controls.EditorButton()
     });
     this.TimeFrom.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.DateTimeAdvancingCaret;
     this.TimeFrom.TabIndex = 3;
     //
     // TimeTo
     //
     this.TimeTo.EditValue = new System.DateTime(2006, 8, 23, 0, 0, 0, 0);
     this.TimeTo.Location  = new System.Drawing.Point(624, 8);
     this.TimeTo.Name      = "TimeTo";
     //
     // TimeTo.Properties
     //
     this.TimeTo.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
         new DevExpress.XtraEditors.Controls.EditorButton()
     });
     this.TimeTo.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.DateTimeAdvancingCaret;
     this.TimeTo.TabIndex = 4;
     //
     // label63
     //
     this.label63.BackColor  = System.Drawing.Color.Transparent;
     this.label63.Font       = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
     this.label63.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
     this.label63.Location   = new System.Drawing.Point(8, 8);
     this.label63.Name       = "label63";
     this.label63.Size       = new System.Drawing.Size(64, 16);
     this.label63.TabIndex   = 37;
     this.label63.Text       = "Date From";
     //
     // label1
     //
     this.label1.BackColor = System.Drawing.Color.Transparent;
     this.label1.Font      = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
     this.label1.Location  = new System.Drawing.Point(200, 8);
     this.label1.Name      = "label1";
     this.label1.Size      = new System.Drawing.Size(48, 16);
     this.label1.TabIndex  = 38;
     this.label1.Text      = "Date To";
     //
     // label2
     //
     this.label2.BackColor  = System.Drawing.Color.Transparent;
     this.label2.Font       = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
     this.label2.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
     this.label2.Location   = new System.Drawing.Point(384, 8);
     this.label2.Name       = "label2";
     this.label2.Size       = new System.Drawing.Size(64, 16);
     this.label2.TabIndex   = 39;
     this.label2.Text       = "Time From";
     //
     // label3
     //
     this.label3.BackColor  = System.Drawing.Color.Transparent;
     this.label3.Font       = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
     this.label3.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
     this.label3.Location   = new System.Drawing.Point(568, 8);
     this.label3.Name       = "label3";
     this.label3.Size       = new System.Drawing.Size(48, 16);
     this.label3.TabIndex   = 40;
     this.label3.Text       = "Time To";
     //
     // btnReset
     //
     this.btnReset.Appearance.Font            = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
     this.btnReset.Appearance.Options.UseFont = true;
     this.btnReset.ButtonStyle = DevExpress.XtraEditors.Controls.BorderStyles.Simple;
     this.btnReset.Location    = new System.Drawing.Point(792, 8);
     this.btnReset.LookAndFeel.UseDefaultLookAndFeel = false;
     this.btnReset.Name     = "btnReset";
     this.btnReset.Size     = new System.Drawing.Size(72, 24);
     this.btnReset.TabIndex = 216;
     this.btnReset.Text     = "Generate";
     this.btnReset.Click   += new System.EventHandler(this.btnReset_Click);
     //
     // PRINT1
     //
     this.PRINT1.EditValue = "PRINT";
     this.PRINT1.Location  = new System.Drawing.Point(880, 16);
     this.PRINT1.Name      = "PRINT1";
     //
     // PRINT1.Properties
     //
     this.PRINT1.Properties.Appearance.BackColor            = System.Drawing.SystemColors.Control;
     this.PRINT1.Properties.Appearance.Options.UseBackColor = true;
     this.PRINT1.Properties.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.NoBorder;
     this.PRINT1.Size      = new System.Drawing.Size(40, 18);
     this.PRINT1.TabIndex  = 217;
     this.PRINT1.OpenLink += new DevExpress.XtraEditors.Controls.OpenLinkEventHandler(this.PRINT1_OpenLink);
     //
     // printingSystem1
     //
     this.printingSystem1.Links.AddRange(new object[] {
         this.printableComponentLink1
     });
     //
     // printableComponentLink1
     //
     this.printableComponentLink1.Component        = this.gvGymAnalysis;
     this.printableComponentLink1.PageHeaderFooter = new DevExpress.XtraPrinting.PageHeaderFooter(new DevExpress.XtraPrinting.PageHeaderArea(new string[] {
         "GYM ANALYSIS REPORT",
         "",
         "[Date Printed] [Time Printed]"
     }, new System.Drawing.Font("Microsoft Sans Serif", 12F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Underline))), System.Drawing.GraphicsUnit.Point, ((System.Byte)(0))), DevExpress.XtraPrinting.BrickAlignment.Near), new DevExpress.XtraPrinting.PageFooterArea(new string[] {
         "",
         "",
         "[Page # of Pages #]"
     }, new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))), DevExpress.XtraPrinting.BrickAlignment.Near));
     this.printableComponentLink1.PrintingSystem = this.printingSystem1;
     //
     // RPGymAnalysis
     //
     this.AutoScale         = false;
     this.AutoScaleBaseSize = new System.Drawing.Size(5, 14);
     this.AutoScroll        = true;
     this.ClientSize        = new System.Drawing.Size(962, 486);
     this.Controls.Add(this.PRINT1);
     this.Controls.Add(this.btnReset);
     this.Controls.Add(this.label3);
     this.Controls.Add(this.label2);
     this.Controls.Add(this.label1);
     this.Controls.Add(this.label63);
     this.Controls.Add(this.TimeTo);
     this.Controls.Add(this.TimeFrom);
     this.Controls.Add(this.DateTo);
     this.Controls.Add(this.DateFrom);
     this.Controls.Add(this.gvGymAnalysis);
     this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedToolWindow;
     this.Name            = "RPGymAnalysis";
     this.Text            = "Gym Analysis";
     this.WindowState     = System.Windows.Forms.FormWindowState.Maximized;
     this.Load           += new System.EventHandler(this.RPGymAnalysis_Load);
     ((System.ComponentModel.ISupportInitialize)(this.gvGymAnalysis)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.DateFrom.Properties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.DateTo.Properties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.TimeFrom.Properties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.TimeTo.Properties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.PRINT1.Properties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.printingSystem1)).EndInit();
     this.ResumeLayout(false);
 }
Beispiel #7
0
        //内部函数处理,把数据加载到pivot grid 控件中。
        private void addDataToCtl(DevExpress.XtraPivotGrid.PivotGridControl gridCtl, object dataSource
                                  , MB.WinBase.IFace.IClientRuleQueryBase baseRule, ColPivotList xmlCfgLst)
        {
            Dictionary <string, MB.WinBase.Common.ColumnPropertyInfo> colPros = XtraGridDynamicHelper.Instance.GetDynamicColumns(baseRule);

            //modify by aifang 2012-08-29 动态列加载  Dictionary<string, MB.WinBase.Common.ColumnPropertyInfo> colPros = baseRule.UIRuleXmlConfigInfo.GetDefaultColumns();

            if (colPros == null)
            {
                return;
            }

            //清除历史的设置
            gridCtl.Fields.Clear();
            gridCtl.Groups.Clear();

            List <Dictionary <DevExpress.XtraPivotGrid.PivotGridField, ColPivotInfo> > expressionFieldsList = new List <Dictionary <DevExpress.XtraPivotGrid.PivotGridField, ColPivotInfo> >();

            foreach (MB.WinBase.Common.ColumnPropertyInfo info in colPros.Values)
            {
                if (!info.IsPivotExpressionSourceColumn && (!info.Visibled || info.VisibleWidth < 1))
                {
                    continue;
                }
                var result = setPivotFieldByCfg(xmlCfgLst, gridCtl, info);
                if (result != null)
                {
                    expressionFieldsList.Add(result);
                }
            }

            //在绑定一般列以后再处理非绑定列的表达式,如果在一起处理会发生列的加载先后顺序
            foreach (Dictionary <DevExpress.XtraPivotGrid.PivotGridField, ColPivotInfo> expressionFields in expressionFieldsList)
            {
                foreach (KeyValuePair <DevExpress.XtraPivotGrid.PivotGridField, ColPivotInfo> expressionField in expressionFields)
                {
                    expressionField.Key.UnboundType = DevExpress.Data.UnboundColumnType.Object;

                    string[] sourceColumns          = expressionField.Value.ExpressionSourceColumns.Split(',');
                    string[] formattedSourceColumns = new string[sourceColumns.Length];
                    for (int i = 0; i < sourceColumns.Length; i++)
                    {
                        DevExpress.XtraPivotGrid.PivotGridField sourceField = gridCtl.Fields[sourceColumns[i]];
                        if (sourceField == null)
                        {
                            throw new MB.Util.APPException(string.Format("ExpressionSourceColumns中的列{0}中Expression中的列不存在,请注意配置中依赖列必需在被依赖列的前面", sourceColumns[i], MB.Util.APPMessageType.SysErrInfo));
                        }

                        formattedSourceColumns[i] = sourceField.ExpressionFieldName;
                    }

                    expressionField.Key.UnboundExpression = string.Format(expressionField.Value.Expression, formattedSourceColumns);
                }
            }

            //处理字段帮定的情况。
            processUnitField(xmlCfgLst, gridCtl);

            //通过条件增加样式
            addConditionsForStyles(gridCtl, baseRule);

            gridCtl.DataSource = dataSource;
        }
Beispiel #8
0
        //通过配置的PivotList 设置PivotField 的信息
        private Dictionary <DevExpress.XtraPivotGrid.PivotGridField, ColPivotInfo> setPivotFieldByCfg(ColPivotList xmlCfgLst, DevExpress.XtraPivotGrid.PivotGridControl gridCtl,
                                                                                                      MB.WinBase.Common.ColumnPropertyInfo fieldInfo)
        {
            if (xmlCfgLst == null)
            {
                return(null);
            }
            if (xmlCfgLst.Columns.Count == 0 && !xmlCfgLst.AutoCreatedGridField)
            {
                return(null);
            }

            IList <MB.XWinLib.PivotGrid.ColPivotInfo> infos = xmlCfgLst.GetColPivotInfos(fieldInfo.Name);

            DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup = null;
            if (infos.Count > 1 && xmlCfgLst.SameFieldGroup)
            {
                pivotGridGroup = new DevExpress.XtraPivotGrid.PivotGridGroup();
                gridCtl.Groups.Add(pivotGridGroup);
            }
            if (infos.Count == 0)
            {
                createNewPivotField(fieldInfo.Name, fieldInfo.Description, gridCtl);
                //add by aifang 去掉汇总后金额显示格式(原来不管是金额还是数量都显示¥前缀)begin
                if (fieldInfo.DataType.Equals("System.Decimal"))
                {
                    gridCtl.Fields[fieldInfo.Name].CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
                }
                //add by aifang end
                return(null);
            }
            else
            {
                Dictionary <DevExpress.XtraPivotGrid.PivotGridField, ColPivotInfo> expressionFields =
                    new Dictionary <DevExpress.XtraPivotGrid.PivotGridField, ColPivotInfo>();


                //处理一个字段对应多个分组的情况
                foreach (ColPivotInfo info in infos)
                {
                    DevExpress.XtraPivotGrid.PivotGridField pivField = createNewPivotField(fieldInfo.Name, fieldInfo.Description, gridCtl);
                    //如果定义了Expression则表示该列的值是通过其他列或其他手段推算而出的
                    if (!string.IsNullOrEmpty(info.Expression))
                    {
                        expressionFields.Add(pivField, info);
                    }

                    if (info.Description != null && info.Description.Length > 0)
                    {
                        pivField.Caption = info.Description;
                    }

                    pivField.Area          = info.IniArea;
                    pivField.AreaIndex     = info.AreaIndex;
                    pivField.AllowedAreas  = info.AllowedAreas;
                    pivField.TopValueCount = info.TopValueCount;
                    pivField.GroupInterval = info.GroupInterval;

                    if (info.SummaryItemType != null && info.SummaryItemType.Length > 0)
                    {
                        pivField.SummaryType = (DevExpress.Data.PivotGrid.PivotSummaryType)Enum.Parse(typeof(DevExpress.Data.PivotGrid.PivotSummaryType), info.SummaryItemType);
                    }

                    //setDefaultFormatByGroup(pivField);
                    //格式化显示数据。
                    if (info.CellFormat != DevExpress.Utils.FormatInfo.Empty)
                    {
                        pivField.CellFormat.Format       = info.CellFormat.Format;
                        pivField.CellFormat.FormatType   = info.CellFormat.FormatType;
                        pivField.CellFormat.FormatString = info.CellFormat.FormatString;
                    }
                    if (info.ValueFormat != DevExpress.Utils.FormatInfo.Empty)
                    {
                        pivField.ValueFormat.Format       = info.CellFormat.Format;
                        pivField.ValueFormat.FormatType   = info.CellFormat.FormatType;
                        pivField.ValueFormat.FormatString = info.CellFormat.FormatString;
                    }
                    //加入字段绑定分组。
                    if (pivotGridGroup != null)
                    {
                        pivotGridGroup.Add(pivField);
                    }
                    //DevExpress.XtraPivotGrid.PivotGroupInterval.DateDayOfWeek
                }
                return(expressionFields);
            }
        }
Beispiel #9
0
        private void AddXtraDateFeildsManually(DevExpress.XtraPivotGrid.PivotGridField datePVF, bool withFieldPrefix)
        {
            //Adding xtra fields for each date field Month
            DevExpress.XtraPivotGrid.PivotGridControl pivotGridControl = datePVF.PivotGrid;
            DevExpress.XtraPivotGrid.PivotGridField   newField         = new DevExpress.XtraPivotGrid.PivotGridField();
            newField.FieldName = datePVF.FieldName + "_Month";
            if (datePVF.Caption == string.Empty)
            {
                newField.Caption = datePVF.FieldName + "_Month";
            }
            else
            {
                newField.Caption = datePVF.Caption + "_Month";
            }

            //newField.CellFormat.Format = c.DisplayFormat.Format;
            //string exp = string.Format("(  GetYear([{0}])*100  ) + GetMonth([{1}])",datePVF.FieldName,datePVF.FieldName);
            string exp = string.Format("(  GetYear([{0}])) + '-' + GetMonth([{1}]) + '-01' ", datePVF.FieldName, datePVF.FieldName);

            newField.UnboundExpression        = exp;
            newField.UnboundType              = DevExpress.Data.UnboundColumnType.DateTime;
            newField.ValueFormat.FormatType   = DevExpress.Utils.FormatType.DateTime;
            newField.ValueFormat.FormatString = "yyyy-MMM";
            newField.Area = DevExpress.XtraPivotGrid.PivotArea.FilterArea;
            pivotGridControl.Fields.Add(newField);

            //Adding xtra fields for each date field Year

            newField           = new DevExpress.XtraPivotGrid.PivotGridField();
            newField.FieldName = datePVF.FieldName + "_Year";
            if (datePVF.Caption == string.Empty)
            {
                newField.Caption = datePVF.FieldName + "_Year";
            }
            else
            {
                newField.Caption = datePVF.Caption + "_Year";
            }

            exp = string.Format("(  GetYear([{0}])) + '-01-01' ", datePVF.FieldName);

            newField.UnboundExpression        = exp;
            newField.UnboundType              = DevExpress.Data.UnboundColumnType.DateTime;
            newField.ValueFormat.FormatType   = DevExpress.Utils.FormatType.DateTime;
            newField.ValueFormat.FormatString = "yyyy";
            newField.Area = DevExpress.XtraPivotGrid.PivotArea.FilterArea;
            pivotGridControl.Fields.Add(newField);

            //Adding xtra fields for each date field Month Only

            newField           = new DevExpress.XtraPivotGrid.PivotGridField();
            newField.FieldName = datePVF.FieldName + "_MonthOnly";
            if (datePVF.Caption == string.Empty)
            {
                newField.Caption = datePVF.FieldName + "_MonthOnly";
            }
            else
            {
                newField.Caption = datePVF.Caption + "_MonthOnly";
            }
            exp = string.Format("(  GetMonth([{0}])) ", datePVF.FieldName);

            newField.UnboundExpression = exp;
            newField.UnboundType       = DevExpress.Data.UnboundColumnType.Integer;
            //newField.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
            //newField.ValueFormat.FormatString = "MMM";
            newField.Area = DevExpress.XtraPivotGrid.PivotArea.FilterArea;
            pivotGridControl.Fields.Add(newField);
        }
Beispiel #10
0
 void mn_Click(object sender, EventArgs e)
 {
     DevExpress.Utils.Menu.DXMenuItem        mn           = (DevExpress.Utils.Menu.DXMenuItem)sender;
     DevExpress.XtraPivotGrid.PivotGridField clickedField = (DevExpress.XtraPivotGrid.PivotGridField)mn.Tag;
     AddXtraDateFeildsManually(clickedField, true);
 }
 /// <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();
     this.vQry56BindingSource = new System.Windows.Forms.BindingSource(this.components);
     this.dsQueries = new RetirementCenter.DataSources.dsQueries();
     this.panelControl1 = new DevExpress.XtraEditors.PanelControl();
     this.btnPrintExport = new DevExpress.XtraEditors.SimpleButton();
     this.vQry56TableAdapter = new RetirementCenter.DataSources.dsQueriesTableAdapters.vQry56TableAdapter();
     this.pivotGridControlMain = new DevExpress.XtraPivotGrid.PivotGridControl();
     this.fieldSyndicate1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldWarasaType1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldAgeState1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldNUM1 = new DevExpress.XtraPivotGrid.PivotGridField();
     ((System.ComponentModel.ISupportInitialize)(this.vQry56BindingSource)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dsQueries)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.panelControl1)).BeginInit();
     this.panelControl1.SuspendLayout();
     ((System.ComponentModel.ISupportInitialize)(this.pivotGridControlMain)).BeginInit();
     this.SuspendLayout();
     //
     // vQry56BindingSource
     //
     this.vQry56BindingSource.DataMember = "vQry56";
     this.vQry56BindingSource.DataSource = this.dsQueries;
     //
     // dsQueries
     //
     this.dsQueries.DataSetName = "dsQueries";
     this.dsQueries.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
     //
     // 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(969, 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(823, 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);
     //
     // vQry56TableAdapter
     //
     this.vQry56TableAdapter.ClearBeforeFill = true;
     //
     // 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.vQry56BindingSource;
     this.pivotGridControlMain.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
     this.fieldSyndicate1,
     this.fieldWarasaType1,
     this.fieldAgeState1,
     this.fieldNUM1});
     this.pivotGridControlMain.Location = new System.Drawing.Point(0, 53);
     this.pivotGridControlMain.Name = "pivotGridControlMain";
     this.pivotGridControlMain.Size = new System.Drawing.Size(969, 409);
     this.pivotGridControlMain.TabIndex = 4;
     //
     // fieldSyndicate1
     //
     this.fieldSyndicate1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.fieldSyndicate1.AreaIndex = 0;
     this.fieldSyndicate1.Caption = "الفرعية";
     this.fieldSyndicate1.FieldName = "Syndicate";
     this.fieldSyndicate1.Name = "fieldSyndicate1";
     //
     // fieldWarasaType1
     //
     this.fieldWarasaType1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.fieldWarasaType1.AreaIndex = 1;
     this.fieldWarasaType1.Caption = "نوع الوريث";
     this.fieldWarasaType1.FieldName = "WarasaType";
     this.fieldWarasaType1.Name = "fieldWarasaType1";
     //
     // fieldAgeState1
     //
     this.fieldAgeState1.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
     this.fieldAgeState1.AreaIndex = 0;
     this.fieldAgeState1.Caption = "الفئة العمرية";
     this.fieldAgeState1.FieldName = "AgeState";
     this.fieldAgeState1.Name = "fieldAgeState1";
     //
     // fieldNUM1
     //
     this.fieldNUM1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.fieldNUM1.AreaIndex = 0;
     this.fieldNUM1.Caption = "العدد";
     this.fieldNUM1.FieldName = "NUM";
     this.fieldNUM1.Name = "fieldNUM1";
     //
     // Qry56Frm
     //
     this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
     this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
     this.ClientSize = new System.Drawing.Size(969, 462);
     this.Controls.Add(this.pivotGridControlMain);
     this.Controls.Add(this.panelControl1);
     this.Name = "Qry56Frm";
     this.Text = "الفئات العمرية للورثة";
     this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
     this.Load += new System.EventHandler(this.Qry06Frm_Load);
     ((System.ComponentModel.ISupportInitialize)(this.vQry56BindingSource)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dsQueries)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.panelControl1)).EndInit();
     this.panelControl1.ResumeLayout(false);
     ((System.ComponentModel.ISupportInitialize)(this.pivotGridControlMain)).EndInit();
     this.ResumeLayout(false);
 }
Beispiel #13
0
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     this.components = new System.ComponentModel.Container();
     DevExpress.DataAccess.Sql.SelectQuery          selectQuery1      = new DevExpress.DataAccess.Sql.SelectQuery();
     DevExpress.DataAccess.Sql.Column               column1           = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression     columnExpression1 = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Table                table1            = new DevExpress.DataAccess.Sql.Table();
     DevExpress.DataAccess.Sql.Column               column2           = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression     columnExpression2 = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Column               column3           = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression     columnExpression3 = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Column               column4           = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression     columnExpression4 = new DevExpress.DataAccess.Sql.ColumnExpression();
     System.ComponentModel.ComponentResourceManager resources         = new System.ComponentModel.ComponentResourceManager(typeof(XtraReport1));
     this.Detail            = new DevExpress.XtraReports.UI.DetailBand();
     this.xrPivotGrid1      = new DevExpress.XtraReports.UI.XRPivotGrid();
     this.fieldCategoryName = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField();
     this.fieldProductName  = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField();
     this.fieldProductSales = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField();
     this.pivotGridField3   = new DevExpress.XtraPivotGrid.PivotGridField();
     this.topMarginBand1    = new DevExpress.XtraReports.UI.TopMarginBand();
     this.bottomMarginBand1 = new DevExpress.XtraReports.UI.BottomMarginBand();
     this.sqlDataSource1    = new DevExpress.DataAccess.Sql.SqlDataSource(this.components);
     ((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
     //
     // Detail
     //
     this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
         this.xrPivotGrid1
     });
     this.Detail.HeightF       = 245F;
     this.Detail.Name          = "Detail";
     this.Detail.Padding       = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F);
     this.Detail.PageBreak     = DevExpress.XtraReports.UI.PageBreak.AfterBand;
     this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
     this.Detail.BeforePrint  += new System.Drawing.Printing.PrintEventHandler(this.Detail_BeforePrint);
     //
     // xrPivotGrid1
     //
     this.xrPivotGrid1.Appearance.Cell.Font                 = new System.Drawing.Font("Tahoma", 8.25F);
     this.xrPivotGrid1.Appearance.CustomTotalCell.Font      = new System.Drawing.Font("Tahoma", 8.25F);
     this.xrPivotGrid1.Appearance.FieldHeader.Font          = new System.Drawing.Font("Tahoma", 8.25F);
     this.xrPivotGrid1.Appearance.FieldValue.Font           = new System.Drawing.Font("Tahoma", 8.25F);
     this.xrPivotGrid1.Appearance.FieldValueGrandTotal.Font = new System.Drawing.Font("Tahoma", 8.25F);
     this.xrPivotGrid1.Appearance.FieldValueTotal.Font      = new System.Drawing.Font("Tahoma", 8.25F);
     this.xrPivotGrid1.Appearance.GrandTotalCell.Font       = new System.Drawing.Font("Tahoma", 8.25F);
     this.xrPivotGrid1.Appearance.Lines.Font                = new System.Drawing.Font("Tahoma", 8.25F);
     this.xrPivotGrid1.Appearance.TotalCell.Font            = new System.Drawing.Font("Tahoma", 8.25F);
     this.xrPivotGrid1.DataMember = "ProductReports";
     this.xrPivotGrid1.DataSource = this.sqlDataSource1;
     this.xrPivotGrid1.Fields.AddRange(new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField[] {
         this.fieldCategoryName,
         this.fieldProductName,
         this.fieldProductSales
     });
     this.xrPivotGrid1.LocationFloat = new DevExpress.Utils.PointFloat(7.999992F, 7.999992F);
     this.xrPivotGrid1.Name          = "xrPivotGrid1";
     this.xrPivotGrid1.SizeF         = new System.Drawing.SizeF(733F, 117F);
     //
     // fieldCategoryName
     //
     this.fieldCategoryName.Area      = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.fieldCategoryName.AreaIndex = 0;
     this.fieldCategoryName.FieldName = "CategoryName";
     this.fieldCategoryName.Name      = "fieldCategoryName";
     //
     // fieldProductName
     //
     this.fieldProductName.Area      = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.fieldProductName.AreaIndex = 1;
     this.fieldProductName.FieldName = "ProductName";
     this.fieldProductName.Name      = "fieldProductName";
     //
     // fieldProductSales
     //
     this.fieldProductSales.Area      = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.fieldProductSales.AreaIndex = 0;
     this.fieldProductSales.FieldName = "ProductSales";
     this.fieldProductSales.Name      = "fieldProductSales";
     //
     // pivotGridField3
     //
     this.pivotGridField3.Area      = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.pivotGridField3.AreaIndex = 0;
     this.pivotGridField3.FieldName = "CategoryName";
     this.pivotGridField3.Name      = "pivotGridField3";
     //
     // topMarginBand1
     //
     this.topMarginBand1.HeightF = 48F;
     this.topMarginBand1.Name    = "topMarginBand1";
     //
     // bottomMarginBand1
     //
     this.bottomMarginBand1.HeightF = 48F;
     this.bottomMarginBand1.Name    = "bottomMarginBand1";
     //
     // sqlDataSource1
     //
     this.sqlDataSource1.ConnectionName = "nwindConnectionString";
     this.sqlDataSource1.Name           = "sqlDataSource1";
     columnExpression1.ColumnName       = "CategoryName";
     table1.Name                  = "ProductReports";
     columnExpression1.Table      = table1;
     column1.Expression           = columnExpression1;
     columnExpression2.ColumnName = "ProductName";
     columnExpression2.Table      = table1;
     column2.Expression           = columnExpression2;
     columnExpression3.ColumnName = "ProductSales";
     columnExpression3.Table      = table1;
     column3.Expression           = columnExpression3;
     columnExpression4.ColumnName = "ShippedDate";
     columnExpression4.Table      = table1;
     column4.Expression           = columnExpression4;
     selectQuery1.Columns.Add(column1);
     selectQuery1.Columns.Add(column2);
     selectQuery1.Columns.Add(column3);
     selectQuery1.Columns.Add(column4);
     selectQuery1.Name = "ProductReports";
     selectQuery1.Tables.Add(table1);
     this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
         selectQuery1
     });
     this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable");
     //
     // XtraReport1
     //
     this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
         this.Detail,
         this.topMarginBand1,
         this.bottomMarginBand1
     });
     this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] {
         this.sqlDataSource1
     });
     this.Margins = new System.Drawing.Printing.Margins(50, 49, 48, 48);
     this.Version = "18.1";
     ((System.ComponentModel.ISupportInitialize)(this)).EndInit();
 }
Beispiel #14
0
        public void AddXtraDateFields(DataTable dTable, DevExpress.XtraPivotGrid.PivotGridControl pivotGridControl, bool withFieldPrefix)
        {
            //Add month value integer
            DevExpress.XtraPivotGrid.PivotGridField dateField;
            List <DataColumn> colList = new List <DataColumn>();

            foreach (DataColumn c in dTable.Columns)
            {
                colList.Add(c);
            }

            foreach (DataColumn col in colList)
            {
                if (col.DataType == Type.GetType("System.DateTime"))
                {
                    #region OldCode
                    //Add MonthValue
                    //DataColumn monthValue = dTable.Columns.Add(col.ColumnName + "_MonthValue", Type.GetType("System.Int32"));
                    //DataColumn monthDisplay = dTable.Columns.Add(col.ColumnName + "_MonthDisplay", Type.GetType("System.String"));

                    //monthDisplay.Caption = col.Caption + "_Month";

                    //foreach (DataRow dr in dTable.Rows)
                    //{
                    //    DateTime dVal = (DateTime)dr[col.ColumnName];
                    //    string format = "yyyy-MMM";
                    //    dr[monthValue.ColumnName] = (dVal.Year * 100) + dVal.Month;
                    //    dr[monthDisplay] = dVal.Date.ToString(format);

                    //}
                    #endregion
                    //Adding xtra fields for each date field Month

                    if (withFieldPrefix)
                    {
                        dateField = pivotGridControl.Fields.GetFieldByName("field" + col.ColumnName);
                    }
                    else
                    {
                        dateField = pivotGridControl.Fields.GetFieldByName(col.ColumnName);
                    }


                    DevExpress.XtraPivotGrid.PivotGridField newField = new DevExpress.XtraPivotGrid.PivotGridField();
                    newField.FieldName = dateField.FieldName + "_Month";
                    if (dateField.Caption == string.Empty)
                    {
                        newField.Caption = dateField.FieldName + "_Month";
                    }
                    else
                    {
                        newField.Caption = dateField.Caption + "_Month";
                    }

                    //newField.CellFormat.Format = c.DisplayFormat.Format;
                    //string exp = string.Format("(  GetYear([{0}])*100  ) + GetMonth([{1}])",dateField.FieldName,dateField.FieldName);
                    string exp = string.Format("(  GetYear([{0}])) + '-' + GetMonth([{1}]) + '-01' ", dateField.FieldName, dateField.FieldName);

                    newField.UnboundExpression        = exp;
                    newField.UnboundType              = DevExpress.Data.UnboundColumnType.DateTime;
                    newField.ValueFormat.FormatType   = DevExpress.Utils.FormatType.DateTime;
                    newField.ValueFormat.FormatString = "yyyy-MMM";
                    newField.Area = DevExpress.XtraPivotGrid.PivotArea.FilterArea;
                    pivotGridControl.Fields.Add(newField);

                    //Adding xtra fields for each date field Year

                    newField           = new DevExpress.XtraPivotGrid.PivotGridField();
                    newField.FieldName = dateField.FieldName + "_Year";
                    if (dateField.Caption == string.Empty)
                    {
                        newField.Caption = dateField.FieldName + "_Year";
                    }
                    else
                    {
                        newField.Caption = dateField.Caption + "_Year";
                    }

                    exp = string.Format("(  GetYear([{0}])) + '-01-01' ", dateField.FieldName);

                    newField.UnboundExpression        = exp;
                    newField.UnboundType              = DevExpress.Data.UnboundColumnType.DateTime;
                    newField.ValueFormat.FormatType   = DevExpress.Utils.FormatType.DateTime;
                    newField.ValueFormat.FormatString = "yyyy";
                    newField.Area = DevExpress.XtraPivotGrid.PivotArea.FilterArea;
                    pivotGridControl.Fields.Add(newField);
                }
            }
        }
Beispiel #15
0
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     this.DateFrom         = new DevExpress.XtraEditors.DateEdit();
     this.DateTo           = new System.Windows.Forms.Label();
     this.label1           = new System.Windows.Forms.Label();
     this.DateRangeTo      = new DevExpress.XtraEditors.DateEdit();
     this.label2           = new System.Windows.Forms.Label();
     this.lkedtEmployee    = new DevExpress.XtraEditors.LookUpEdit();
     this.GridStockRequest = new DevExpress.XtraPivotGrid.PivotGridControl();
     this.pivotGridField6  = new DevExpress.XtraPivotGrid.PivotGridField();
     this.pivotGridField1  = new DevExpress.XtraPivotGrid.PivotGridField();
     this.pivotGridField8  = new DevExpress.XtraPivotGrid.PivotGridField();
     this.pivotGridField9  = new DevExpress.XtraPivotGrid.PivotGridField();
     this.pivotGridField3  = new DevExpress.XtraPivotGrid.PivotGridField();
     this.pivotGridField2  = new DevExpress.XtraPivotGrid.PivotGridField();
     this.pivotGridField4  = new DevExpress.XtraPivotGrid.PivotGridField();
     this.pivotGridField5  = new DevExpress.XtraPivotGrid.PivotGridField();
     this.pivotGridField7  = new DevExpress.XtraPivotGrid.PivotGridField();
     this.panelControl1    = new DevExpress.XtraEditors.PanelControl();
     this.lkedtProductType = new DevExpress.XtraEditors.LookUpEdit();
     this.label8           = new System.Windows.Forms.Label();
     this.lkedtBrandCode   = new DevExpress.XtraEditors.LookUpEdit();
     this.label7           = new System.Windows.Forms.Label();
     this.btnReset         = new DevExpress.XtraEditors.SimpleButton();
     this.btnSearch        = new DevExpress.XtraEditors.SimpleButton();
     this.label5           = new System.Windows.Forms.Label();
     this.txtStyleDesc     = new DevExpress.XtraEditors.TextEdit();
     this.label4           = new System.Windows.Forms.Label();
     this.txtStyleCode     = new DevExpress.XtraEditors.TextEdit();
     this.label3           = new System.Windows.Forms.Label();
     this.txtItemDesc      = new DevExpress.XtraEditors.TextEdit();
     this.label6           = new System.Windows.Forms.Label();
     this.txtItemCode      = new DevExpress.XtraEditors.TextEdit();
     ((System.ComponentModel.ISupportInitialize)(this.DateFrom.Properties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.DateRangeTo.Properties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.lkedtEmployee.Properties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.GridStockRequest)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.panelControl1)).BeginInit();
     this.panelControl1.SuspendLayout();
     ((System.ComponentModel.ISupportInitialize)(this.lkedtProductType.Properties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.lkedtBrandCode.Properties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.txtStyleDesc.Properties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.txtStyleCode.Properties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.txtItemDesc.Properties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.txtItemCode.Properties)).BeginInit();
     this.SuspendLayout();
     //
     // DateFrom
     //
     this.DateFrom.EditValue = new System.DateTime(2006, 8, 21, 1, 50, 21, 359);
     this.DateFrom.Location  = new System.Drawing.Point(56, 8);
     this.DateFrom.Name      = "DateFrom";
     //
     // DateFrom.Properties
     //
     this.DateFrom.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
         new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)
     });
     this.DateFrom.Properties.DisplayFormat.FormatString = "dd/MM/yyyy";
     this.DateFrom.Properties.DisplayFormat.FormatType   = DevExpress.Utils.FormatType.Custom;
     this.DateFrom.Properties.EditFormat.FormatString    = "dd/MM/yyyy";
     this.DateFrom.Properties.EditFormat.FormatType      = DevExpress.Utils.FormatType.Custom;
     this.DateFrom.Properties.Mask.EditMask = "dd/MM/yyyy";
     this.DateFrom.TabIndex          = 13;
     this.DateFrom.EditValueChanged += new System.EventHandler(this.DateFrom_EditValueChanged);
     //
     // DateTo
     //
     this.DateTo.Font     = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
     this.DateTo.Location = new System.Drawing.Point(200, 8);
     this.DateTo.Name     = "DateTo";
     this.DateTo.Size     = new System.Drawing.Size(24, 16);
     this.DateTo.TabIndex = 12;
     this.DateTo.Text     = "To";
     //
     // label1
     //
     this.label1.Font     = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
     this.label1.Location = new System.Drawing.Point(8, 8);
     this.label1.Name     = "label1";
     this.label1.Size     = new System.Drawing.Size(40, 16);
     this.label1.TabIndex = 11;
     this.label1.Text     = "From";
     //
     // DateRangeTo
     //
     this.DateRangeTo.EditValue = new System.DateTime(2006, 8, 21, 1, 50, 31, 328);
     this.DateRangeTo.Location  = new System.Drawing.Point(232, 8);
     this.DateRangeTo.Name      = "DateRangeTo";
     //
     // DateRangeTo.Properties
     //
     this.DateRangeTo.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
         new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)
     });
     this.DateRangeTo.Properties.DisplayFormat.FormatString = "dd/MM/yyyy";
     this.DateRangeTo.Properties.DisplayFormat.FormatType   = DevExpress.Utils.FormatType.DateTime;
     this.DateRangeTo.Properties.EditFormat.FormatString    = "dd/MM/yyyy";
     this.DateRangeTo.Properties.EditFormat.FormatType      = DevExpress.Utils.FormatType.DateTime;
     this.DateRangeTo.Properties.Mask.EditMask = "dd/MM/yyyy";
     this.DateRangeTo.TabIndex          = 10;
     this.DateRangeTo.EditValueChanged += new System.EventHandler(this.DateRangeTo_EditValueChanged);
     //
     // label2
     //
     this.label2.Font     = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
     this.label2.Location = new System.Drawing.Point(360, 8);
     this.label2.Name     = "label2";
     this.label2.Size     = new System.Drawing.Size(80, 16);
     this.label2.TabIndex = 14;
     this.label2.Text     = "Employee";
     //
     // lkedtEmployee
     //
     this.lkedtEmployee.EditValue = "";
     this.lkedtEmployee.Location  = new System.Drawing.Point(440, 8);
     this.lkedtEmployee.Name      = "lkedtEmployee";
     //
     // lkedtEmployee.Properties
     //
     this.lkedtEmployee.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
         new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)
     });
     this.lkedtEmployee.Size              = new System.Drawing.Size(184, 20);
     this.lkedtEmployee.TabIndex          = 15;
     this.lkedtEmployee.EditValueChanged += new System.EventHandler(this.lkedtEmployee_EditValueChanged);
     //
     // GridStockRequest
     //
     this.GridStockRequest.Cursor = System.Windows.Forms.Cursors.Default;
     this.GridStockRequest.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
         this.pivotGridField6,
         this.pivotGridField1,
         this.pivotGridField8,
         this.pivotGridField9,
         this.pivotGridField3,
         this.pivotGridField2,
         this.pivotGridField4,
         this.pivotGridField5,
         this.pivotGridField7
     });
     this.GridStockRequest.Location = new System.Drawing.Point(0, 120);
     this.GridStockRequest.Name     = "GridStockRequest";
     this.GridStockRequest.OptionsCustomization.AllowDrag   = false;
     this.GridStockRequest.OptionsCustomization.AllowExpand = false;
     this.GridStockRequest.OptionsCustomization.AllowFilter = false;
     this.GridStockRequest.OptionsCustomization.AllowSort   = false;
     this.GridStockRequest.OptionsView.ShowDataHeaders      = false;
     this.GridStockRequest.OptionsView.ShowFilterHeaders    = false;
     this.GridStockRequest.Size     = new System.Drawing.Size(974, 424);
     this.GridStockRequest.TabIndex = 63;
     //
     // pivotGridField6
     //
     this.pivotGridField6.Area      = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
     this.pivotGridField6.AreaIndex = 0;
     this.pivotGridField6.Caption   = "Branch";
     this.pivotGridField6.FieldName = "strBranchCode";
     this.pivotGridField6.Name      = "pivotGridField6";
     //
     // pivotGridField1
     //
     this.pivotGridField1.Area                = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.pivotGridField1.AreaIndex           = 0;
     this.pivotGridField1.Caption             = "Item Code";
     this.pivotGridField1.FieldName           = "strProductCode";
     this.pivotGridField1.Name                = "pivotGridField1";
     this.pivotGridField1.Options.AllowFilter = DevExpress.Utils.DefaultBoolean.True;
     //
     // pivotGridField8
     //
     this.pivotGridField8.Area                = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.pivotGridField8.AreaIndex           = 5;
     this.pivotGridField8.Caption             = "Item Desc";
     this.pivotGridField8.FieldName           = "ProductDesc";
     this.pivotGridField8.Name                = "pivotGridField8";
     this.pivotGridField8.Options.AllowFilter = DevExpress.Utils.DefaultBoolean.True;
     //
     // pivotGridField9
     //
     this.pivotGridField9.Area      = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.pivotGridField9.AreaIndex = 6;
     this.pivotGridField9.Caption   = "Product Type";
     this.pivotGridField9.FieldName = "nProductTypeID";
     this.pivotGridField9.Name      = "pivotGridField9";
     //
     // pivotGridField3
     //
     this.pivotGridField3.Area                = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.pivotGridField3.AreaIndex           = 2;
     this.pivotGridField3.Caption             = "Style Code";
     this.pivotGridField3.FieldName           = "strStyleCode";
     this.pivotGridField3.Name                = "pivotGridField3";
     this.pivotGridField3.Options.AllowFilter = DevExpress.Utils.DefaultBoolean.True;
     //
     // pivotGridField2
     //
     this.pivotGridField2.Area      = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.pivotGridField2.AreaIndex = 1;
     this.pivotGridField2.Caption   = "Brand";
     this.pivotGridField2.FieldName = "strBrandCode";
     this.pivotGridField2.Name      = "pivotGridField2";
     //
     // pivotGridField4
     //
     this.pivotGridField4.Area                = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.pivotGridField4.AreaIndex           = 3;
     this.pivotGridField4.Caption             = "Color";
     this.pivotGridField4.FieldName           = "strColorCode";
     this.pivotGridField4.Name                = "pivotGridField4";
     this.pivotGridField4.Options.AllowFilter = DevExpress.Utils.DefaultBoolean.True;
     //
     // pivotGridField5
     //
     this.pivotGridField5.Area                = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.pivotGridField5.AreaIndex           = 4;
     this.pivotGridField5.Caption             = "Size";
     this.pivotGridField5.FieldName           = "strSizeCode";
     this.pivotGridField5.Name                = "pivotGridField5";
     this.pivotGridField5.Options.AllowFilter = DevExpress.Utils.DefaultBoolean.True;
     //
     // pivotGridField7
     //
     this.pivotGridField7.Area      = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.pivotGridField7.AreaIndex = 0;
     this.pivotGridField7.Caption   = "Quantity";
     this.pivotGridField7.FieldName = "nQuantity";
     this.pivotGridField7.Name      = "pivotGridField7";
     //
     // panelControl1
     //
     this.panelControl1.Controls.Add(this.lkedtProductType);
     this.panelControl1.Controls.Add(this.label8);
     this.panelControl1.Controls.Add(this.lkedtBrandCode);
     this.panelControl1.Controls.Add(this.label7);
     this.panelControl1.Controls.Add(this.btnReset);
     this.panelControl1.Controls.Add(this.btnSearch);
     this.panelControl1.Controls.Add(this.label5);
     this.panelControl1.Controls.Add(this.txtStyleDesc);
     this.panelControl1.Controls.Add(this.label4);
     this.panelControl1.Controls.Add(this.txtStyleCode);
     this.panelControl1.Controls.Add(this.label3);
     this.panelControl1.Controls.Add(this.txtItemDesc);
     this.panelControl1.Controls.Add(this.label6);
     this.panelControl1.Controls.Add(this.txtItemCode);
     this.panelControl1.Location = new System.Drawing.Point(8, 40);
     this.panelControl1.Name     = "panelControl1";
     this.panelControl1.Size     = new System.Drawing.Size(960, 72);
     this.panelControl1.TabIndex = 64;
     this.panelControl1.Text     = "panelControl1";
     //
     // lkedtProductType
     //
     this.lkedtProductType.EditValue = "";
     this.lkedtProductType.Location  = new System.Drawing.Point(360, 40);
     this.lkedtProductType.Name      = "lkedtProductType";
     //
     // lkedtProductType.Properties
     //
     this.lkedtProductType.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
         new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)
     });
     this.lkedtProductType.Size     = new System.Drawing.Size(136, 20);
     this.lkedtProductType.TabIndex = 76;
     //
     // label8
     //
     this.label8.Font     = new System.Drawing.Font("Microsoft Sans Serif", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
     this.label8.Location = new System.Drawing.Point(264, 40);
     this.label8.Name     = "label8";
     this.label8.Size     = new System.Drawing.Size(88, 16);
     this.label8.TabIndex = 75;
     this.label8.Text     = "Product Type";
     //
     // lkedtBrandCode
     //
     this.lkedtBrandCode.EditValue = "";
     this.lkedtBrandCode.Location  = new System.Drawing.Point(96, 40);
     this.lkedtBrandCode.Name      = "lkedtBrandCode";
     //
     // lkedtBrandCode.Properties
     //
     this.lkedtBrandCode.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
         new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)
     });
     this.lkedtBrandCode.Size     = new System.Drawing.Size(136, 20);
     this.lkedtBrandCode.TabIndex = 74;
     //
     // label7
     //
     this.label7.Font     = new System.Drawing.Font("Microsoft Sans Serif", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
     this.label7.Location = new System.Drawing.Point(8, 40);
     this.label7.Name     = "label7";
     this.label7.Size     = new System.Drawing.Size(80, 16);
     this.label7.TabIndex = 73;
     this.label7.Text     = "Brand Code";
     //
     // btnReset
     //
     this.btnReset.ButtonStyle = DevExpress.XtraEditors.Controls.BorderStyles.Simple;
     this.btnReset.Location    = new System.Drawing.Point(696, 40);
     this.btnReset.Name        = "btnReset";
     this.btnReset.Size        = new System.Drawing.Size(72, 20);
     this.btnReset.TabIndex    = 72;
     this.btnReset.Text        = "Reset";
     this.btnReset.Click      += new System.EventHandler(this.btnReset_Click);
     //
     // btnSearch
     //
     this.btnSearch.ButtonStyle = DevExpress.XtraEditors.Controls.BorderStyles.Simple;
     this.btnSearch.Location    = new System.Drawing.Point(616, 40);
     this.btnSearch.Name        = "btnSearch";
     this.btnSearch.Size        = new System.Drawing.Size(72, 20);
     this.btnSearch.TabIndex    = 71;
     this.btnSearch.Text        = "Search";
     this.btnSearch.Click      += new System.EventHandler(this.btnSearch_Click);
     //
     // label5
     //
     this.label5.Font     = new System.Drawing.Font("Microsoft Sans Serif", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
     this.label5.Location = new System.Drawing.Point(544, 8);
     this.label5.Name     = "label5";
     this.label5.Size     = new System.Drawing.Size(72, 16);
     this.label5.TabIndex = 70;
     this.label5.Text     = "Style Desc";
     //
     // txtStyleDesc
     //
     this.txtStyleDesc.EditValue = "";
     this.txtStyleDesc.Location  = new System.Drawing.Point(624, 8);
     this.txtStyleDesc.Name      = "txtStyleDesc";
     this.txtStyleDesc.Size      = new System.Drawing.Size(144, 20);
     this.txtStyleDesc.TabIndex  = 69;
     //
     // label4
     //
     this.label4.Font     = new System.Drawing.Font("Microsoft Sans Serif", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
     this.label4.Location = new System.Drawing.Point(376, 8);
     this.label4.Name     = "label4";
     this.label4.Size     = new System.Drawing.Size(80, 16);
     this.label4.TabIndex = 68;
     this.label4.Text     = "Style Code";
     //
     // txtStyleCode
     //
     this.txtStyleCode.EditValue = "";
     this.txtStyleCode.Location  = new System.Drawing.Point(456, 8);
     this.txtStyleCode.Name      = "txtStyleCode";
     this.txtStyleCode.Size      = new System.Drawing.Size(80, 20);
     this.txtStyleCode.TabIndex  = 67;
     //
     // label3
     //
     this.label3.Font     = new System.Drawing.Font("Microsoft Sans Serif", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
     this.label3.Location = new System.Drawing.Point(160, 8);
     this.label3.Name     = "label3";
     this.label3.Size     = new System.Drawing.Size(72, 16);
     this.label3.TabIndex = 66;
     this.label3.Text     = "Item Desc";
     //
     // txtItemDesc
     //
     this.txtItemDesc.EditValue = "";
     this.txtItemDesc.Location  = new System.Drawing.Point(232, 8);
     this.txtItemDesc.Name      = "txtItemDesc";
     this.txtItemDesc.Size      = new System.Drawing.Size(136, 20);
     this.txtItemDesc.TabIndex  = 65;
     //
     // label6
     //
     this.label6.Font     = new System.Drawing.Font("Microsoft Sans Serif", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
     this.label6.Location = new System.Drawing.Point(8, 8);
     this.label6.Name     = "label6";
     this.label6.Size     = new System.Drawing.Size(72, 16);
     this.label6.TabIndex = 64;
     this.label6.Text     = "Item Code";
     //
     // txtItemCode
     //
     this.txtItemCode.EditValue = "";
     this.txtItemCode.Location  = new System.Drawing.Point(80, 8);
     this.txtItemCode.Name      = "txtItemCode";
     this.txtItemCode.Size      = new System.Drawing.Size(80, 20);
     this.txtItemCode.TabIndex  = 63;
     //
     // RPStockSalon
     //
     this.AutoScale         = false;
     this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
     this.ClientSize        = new System.Drawing.Size(974, 548);
     this.Controls.Add(this.panelControl1);
     this.Controls.Add(this.GridStockRequest);
     this.Controls.Add(this.lkedtEmployee);
     this.Controls.Add(this.label2);
     this.Controls.Add(this.DateFrom);
     this.Controls.Add(this.DateTo);
     this.Controls.Add(this.label1);
     this.Controls.Add(this.DateRangeTo);
     this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle;
     this.MaximizeBox     = false;
     this.MinimizeBox     = false;
     this.Name            = "RPStockSalon";
     this.Text            = "Stock Inventory - Salon Use";
     this.Load           += new System.EventHandler(this.RPStockSalon_Load);
     ((System.ComponentModel.ISupportInitialize)(this.DateFrom.Properties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.DateRangeTo.Properties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.lkedtEmployee.Properties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.GridStockRequest)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.panelControl1)).EndInit();
     this.panelControl1.ResumeLayout(false);
     ((System.ComponentModel.ISupportInitialize)(this.lkedtProductType.Properties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.lkedtBrandCode.Properties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.txtStyleDesc.Properties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.txtStyleCode.Properties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.txtItemDesc.Properties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.txtItemCode.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()
 {
     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);
 }
Beispiel #17
0
 /// <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();
     this.Detail            = new DevExpress.XtraReports.UI.DetailBand();
     this.pivotGridField3   = new DevExpress.XtraPivotGrid.PivotGridField();
     this.topMarginBand1    = new DevExpress.XtraReports.UI.TopMarginBand();
     this.bottomMarginBand1 = new DevExpress.XtraReports.UI.BottomMarginBand();
     this.fieldProductSales = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField();
     this.fieldProductName  = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField();
     this.fieldCategoryName = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField();
     this.xrPivotGrid1      = new DevExpress.XtraReports.UI.XRPivotGrid();
     this.objectDataSource1 = new DevExpress.DataAccess.ObjectBinding.ObjectDataSource(this.components);
     ((System.ComponentModel.ISupportInitialize)(this.objectDataSource1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
     //
     // Detail
     //
     this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
         this.xrPivotGrid1
     });
     this.Detail.HeightF       = 99.99998F;
     this.Detail.Name          = "Detail";
     this.Detail.Padding       = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F);
     this.Detail.PageBreak     = DevExpress.XtraReports.UI.PageBreak.AfterBand;
     this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
     //
     // pivotGridField3
     //
     this.pivotGridField3.Area      = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.pivotGridField3.AreaIndex = 0;
     this.pivotGridField3.FieldName = "CategoryName";
     this.pivotGridField3.Name      = "pivotGridField3";
     //
     // topMarginBand1
     //
     this.topMarginBand1.HeightF = 48F;
     this.topMarginBand1.Name    = "topMarginBand1";
     //
     // bottomMarginBand1
     //
     this.bottomMarginBand1.HeightF = 48F;
     this.bottomMarginBand1.Name    = "bottomMarginBand1";
     //
     // fieldProductSales
     //
     this.fieldProductSales.Area      = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.fieldProductSales.AreaIndex = 0;
     this.fieldProductSales.FieldName = "ProductSales";
     this.fieldProductSales.Name      = "fieldProductSales";
     //
     // fieldProductName
     //
     this.fieldProductName.Area      = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.fieldProductName.AreaIndex = 1;
     this.fieldProductName.FieldName = "ProductName";
     this.fieldProductName.Name      = "fieldProductName";
     //
     // fieldCategoryName
     //
     this.fieldCategoryName.Area      = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.fieldCategoryName.AreaIndex = 0;
     this.fieldCategoryName.FieldName = "CategoryName";
     this.fieldCategoryName.Name      = "fieldCategoryName";
     //
     // xrPivotGrid1
     //
     this.xrPivotGrid1.DataSource = this.objectDataSource1;
     this.xrPivotGrid1.Fields.AddRange(new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField[] {
         this.fieldCategoryName,
         this.fieldProductName,
         this.fieldProductSales
     });
     this.xrPivotGrid1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F);
     this.xrPivotGrid1.Name          = "xrPivotGrid1";
     this.xrPivotGrid1.SizeF         = new System.Drawing.SizeF(751F, 99.99998F);
     //
     // objectDataSource1
     //
     this.objectDataSource1.DataSource = typeof(DXWebApplication3.Models.ProductReport);
     this.objectDataSource1.Name       = "objectDataSource1";
     //
     // XtraReport1
     //
     this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
         this.Detail,
         this.topMarginBand1,
         this.bottomMarginBand1
     });
     this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] {
         this.objectDataSource1
     });
     this.Margins = new System.Drawing.Printing.Margins(50, 49, 48, 48);
     this.Version = "19.2";
     ((System.ComponentModel.ISupportInitialize)(this.objectDataSource1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this)).EndInit();
 }
Beispiel #18
0
        //增加网格显示的格式化样式信息。
        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);
                }
            }
        }
Beispiel #19
0
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     this.DateFrom = new DevExpress.XtraEditors.DateEdit();
     this.DateTo = new System.Windows.Forms.Label();
     this.label1 = new System.Windows.Forms.Label();
     this.DateRangeTo = new DevExpress.XtraEditors.DateEdit();
     this.label2 = new System.Windows.Forms.Label();
     this.lkedtEmployee = new DevExpress.XtraEditors.LookUpEdit();
     this.GridStockRequest = new DevExpress.XtraPivotGrid.PivotGridControl();
     this.pivotGridField6 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.pivotGridField1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.pivotGridField8 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.pivotGridField9 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.pivotGridField3 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.pivotGridField2 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.pivotGridField4 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.pivotGridField5 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.pivotGridField7 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.panelControl1 = new DevExpress.XtraEditors.PanelControl();
     this.lkedtProductType = new DevExpress.XtraEditors.LookUpEdit();
     this.label8 = new System.Windows.Forms.Label();
     this.lkedtBrandCode = new DevExpress.XtraEditors.LookUpEdit();
     this.label7 = new System.Windows.Forms.Label();
     this.btnReset = new DevExpress.XtraEditors.SimpleButton();
     this.btnSearch = new DevExpress.XtraEditors.SimpleButton();
     this.label5 = new System.Windows.Forms.Label();
     this.txtStyleDesc = new DevExpress.XtraEditors.TextEdit();
     this.label4 = new System.Windows.Forms.Label();
     this.txtStyleCode = new DevExpress.XtraEditors.TextEdit();
     this.label3 = new System.Windows.Forms.Label();
     this.txtItemDesc = new DevExpress.XtraEditors.TextEdit();
     this.label6 = new System.Windows.Forms.Label();
     this.txtItemCode = new DevExpress.XtraEditors.TextEdit();
     ((System.ComponentModel.ISupportInitialize)(this.DateFrom.Properties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.DateRangeTo.Properties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.lkedtEmployee.Properties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.GridStockRequest)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.panelControl1)).BeginInit();
     this.panelControl1.SuspendLayout();
     ((System.ComponentModel.ISupportInitialize)(this.lkedtProductType.Properties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.lkedtBrandCode.Properties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.txtStyleDesc.Properties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.txtStyleCode.Properties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.txtItemDesc.Properties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.txtItemCode.Properties)).BeginInit();
     this.SuspendLayout();
     //
     // DateFrom
     //
     this.DateFrom.EditValue = new System.DateTime(2006, 8, 21, 1, 50, 21, 359);
     this.DateFrom.Location = new System.Drawing.Point(56, 8);
     this.DateFrom.Name = "DateFrom";
     //
     // DateFrom.Properties
     //
     this.DateFrom.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
                                                                                                      new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
     this.DateFrom.Properties.DisplayFormat.FormatString = "dd/MM/yyyy";
     this.DateFrom.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
     this.DateFrom.Properties.EditFormat.FormatString = "dd/MM/yyyy";
     this.DateFrom.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.Custom;
     this.DateFrom.Properties.Mask.EditMask = "dd/MM/yyyy";
     this.DateFrom.TabIndex = 13;
     this.DateFrom.EditValueChanged += new System.EventHandler(this.DateFrom_EditValueChanged);
     //
     // DateTo
     //
     this.DateTo.Font = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
     this.DateTo.Location = new System.Drawing.Point(200, 8);
     this.DateTo.Name = "DateTo";
     this.DateTo.Size = new System.Drawing.Size(24, 16);
     this.DateTo.TabIndex = 12;
     this.DateTo.Text = "To";
     //
     // label1
     //
     this.label1.Font = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
     this.label1.Location = new System.Drawing.Point(8, 8);
     this.label1.Name = "label1";
     this.label1.Size = new System.Drawing.Size(40, 16);
     this.label1.TabIndex = 11;
     this.label1.Text = "From";
     //
     // DateRangeTo
     //
     this.DateRangeTo.EditValue = new System.DateTime(2006, 8, 21, 1, 50, 31, 328);
     this.DateRangeTo.Location = new System.Drawing.Point(232, 8);
     this.DateRangeTo.Name = "DateRangeTo";
     //
     // DateRangeTo.Properties
     //
     this.DateRangeTo.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
                                                                                                         new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
     this.DateRangeTo.Properties.DisplayFormat.FormatString = "dd/MM/yyyy";
     this.DateRangeTo.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
     this.DateRangeTo.Properties.EditFormat.FormatString = "dd/MM/yyyy";
     this.DateRangeTo.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
     this.DateRangeTo.Properties.Mask.EditMask = "dd/MM/yyyy";
     this.DateRangeTo.TabIndex = 10;
     this.DateRangeTo.EditValueChanged += new System.EventHandler(this.DateRangeTo_EditValueChanged);
     //
     // label2
     //
     this.label2.Font = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
     this.label2.Location = new System.Drawing.Point(360, 8);
     this.label2.Name = "label2";
     this.label2.Size = new System.Drawing.Size(80, 16);
     this.label2.TabIndex = 14;
     this.label2.Text = "Employee";
     //
     // lkedtEmployee
     //
     this.lkedtEmployee.EditValue = "";
     this.lkedtEmployee.Location = new System.Drawing.Point(440, 8);
     this.lkedtEmployee.Name = "lkedtEmployee";
     //
     // lkedtEmployee.Properties
     //
     this.lkedtEmployee.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
                                                                                                           new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
     this.lkedtEmployee.Size = new System.Drawing.Size(184, 20);
     this.lkedtEmployee.TabIndex = 15;
     this.lkedtEmployee.EditValueChanged += new System.EventHandler(this.lkedtEmployee_EditValueChanged);
     //
     // GridStockRequest
     //
     this.GridStockRequest.Cursor = System.Windows.Forms.Cursors.Default;
     this.GridStockRequest.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
                                                                                             this.pivotGridField6,
                                                                                             this.pivotGridField1,
                                                                                             this.pivotGridField8,
                                                                                             this.pivotGridField9,
                                                                                             this.pivotGridField3,
                                                                                             this.pivotGridField2,
                                                                                             this.pivotGridField4,
                                                                                             this.pivotGridField5,
                                                                                             this.pivotGridField7});
     this.GridStockRequest.Location = new System.Drawing.Point(0, 120);
     this.GridStockRequest.Name = "GridStockRequest";
     this.GridStockRequest.OptionsCustomization.AllowDrag = false;
     this.GridStockRequest.OptionsCustomization.AllowExpand = false;
     this.GridStockRequest.OptionsCustomization.AllowFilter = false;
     this.GridStockRequest.OptionsCustomization.AllowSort = false;
     this.GridStockRequest.OptionsView.ShowDataHeaders = false;
     this.GridStockRequest.OptionsView.ShowFilterHeaders = false;
     this.GridStockRequest.Size = new System.Drawing.Size(974, 424);
     this.GridStockRequest.TabIndex = 63;
     //
     // pivotGridField6
     //
     this.pivotGridField6.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
     this.pivotGridField6.AreaIndex = 0;
     this.pivotGridField6.Caption = "Branch";
     this.pivotGridField6.FieldName = "strBranchCode";
     this.pivotGridField6.Name = "pivotGridField6";
     //
     // pivotGridField1
     //
     this.pivotGridField1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.pivotGridField1.AreaIndex = 0;
     this.pivotGridField1.Caption = "Item Code";
     this.pivotGridField1.FieldName = "strProductCode";
     this.pivotGridField1.Name = "pivotGridField1";
     this.pivotGridField1.Options.AllowFilter = DevExpress.Utils.DefaultBoolean.True;
     //
     // pivotGridField8
     //
     this.pivotGridField8.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.pivotGridField8.AreaIndex = 5;
     this.pivotGridField8.Caption = "Item Desc";
     this.pivotGridField8.FieldName = "ProductDesc";
     this.pivotGridField8.Name = "pivotGridField8";
     this.pivotGridField8.Options.AllowFilter = DevExpress.Utils.DefaultBoolean.True;
     //
     // pivotGridField9
     //
     this.pivotGridField9.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.pivotGridField9.AreaIndex = 6;
     this.pivotGridField9.Caption = "Product Type";
     this.pivotGridField9.FieldName = "nProductTypeID";
     this.pivotGridField9.Name = "pivotGridField9";
     //
     // pivotGridField3
     //
     this.pivotGridField3.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.pivotGridField3.AreaIndex = 2;
     this.pivotGridField3.Caption = "Style Code";
     this.pivotGridField3.FieldName = "strStyleCode";
     this.pivotGridField3.Name = "pivotGridField3";
     this.pivotGridField3.Options.AllowFilter = DevExpress.Utils.DefaultBoolean.True;
     //
     // pivotGridField2
     //
     this.pivotGridField2.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.pivotGridField2.AreaIndex = 1;
     this.pivotGridField2.Caption = "Brand";
     this.pivotGridField2.FieldName = "strBrandCode";
     this.pivotGridField2.Name = "pivotGridField2";
     //
     // pivotGridField4
     //
     this.pivotGridField4.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.pivotGridField4.AreaIndex = 3;
     this.pivotGridField4.Caption = "Color";
     this.pivotGridField4.FieldName = "strColorCode";
     this.pivotGridField4.Name = "pivotGridField4";
     this.pivotGridField4.Options.AllowFilter = DevExpress.Utils.DefaultBoolean.True;
     //
     // pivotGridField5
     //
     this.pivotGridField5.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.pivotGridField5.AreaIndex = 4;
     this.pivotGridField5.Caption = "Size";
     this.pivotGridField5.FieldName = "strSizeCode";
     this.pivotGridField5.Name = "pivotGridField5";
     this.pivotGridField5.Options.AllowFilter = DevExpress.Utils.DefaultBoolean.True;
     //
     // pivotGridField7
     //
     this.pivotGridField7.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.pivotGridField7.AreaIndex = 0;
     this.pivotGridField7.Caption = "Quantity";
     this.pivotGridField7.FieldName = "nQuantity";
     this.pivotGridField7.Name = "pivotGridField7";
     //
     // panelControl1
     //
     this.panelControl1.Controls.Add(this.lkedtProductType);
     this.panelControl1.Controls.Add(this.label8);
     this.panelControl1.Controls.Add(this.lkedtBrandCode);
     this.panelControl1.Controls.Add(this.label7);
     this.panelControl1.Controls.Add(this.btnReset);
     this.panelControl1.Controls.Add(this.btnSearch);
     this.panelControl1.Controls.Add(this.label5);
     this.panelControl1.Controls.Add(this.txtStyleDesc);
     this.panelControl1.Controls.Add(this.label4);
     this.panelControl1.Controls.Add(this.txtStyleCode);
     this.panelControl1.Controls.Add(this.label3);
     this.panelControl1.Controls.Add(this.txtItemDesc);
     this.panelControl1.Controls.Add(this.label6);
     this.panelControl1.Controls.Add(this.txtItemCode);
     this.panelControl1.Location = new System.Drawing.Point(8, 40);
     this.panelControl1.Name = "panelControl1";
     this.panelControl1.Size = new System.Drawing.Size(960, 72);
     this.panelControl1.TabIndex = 64;
     this.panelControl1.Text = "panelControl1";
     //
     // lkedtProductType
     //
     this.lkedtProductType.EditValue = "";
     this.lkedtProductType.Location = new System.Drawing.Point(360, 40);
     this.lkedtProductType.Name = "lkedtProductType";
     //
     // lkedtProductType.Properties
     //
     this.lkedtProductType.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
                                                                                                              new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
     this.lkedtProductType.Size = new System.Drawing.Size(136, 20);
     this.lkedtProductType.TabIndex = 76;
     //
     // label8
     //
     this.label8.Font = new System.Drawing.Font("Microsoft Sans Serif", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
     this.label8.Location = new System.Drawing.Point(264, 40);
     this.label8.Name = "label8";
     this.label8.Size = new System.Drawing.Size(88, 16);
     this.label8.TabIndex = 75;
     this.label8.Text = "Product Type";
     //
     // lkedtBrandCode
     //
     this.lkedtBrandCode.EditValue = "";
     this.lkedtBrandCode.Location = new System.Drawing.Point(96, 40);
     this.lkedtBrandCode.Name = "lkedtBrandCode";
     //
     // lkedtBrandCode.Properties
     //
     this.lkedtBrandCode.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
                                                                                                            new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
     this.lkedtBrandCode.Size = new System.Drawing.Size(136, 20);
     this.lkedtBrandCode.TabIndex = 74;
     //
     // label7
     //
     this.label7.Font = new System.Drawing.Font("Microsoft Sans Serif", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
     this.label7.Location = new System.Drawing.Point(8, 40);
     this.label7.Name = "label7";
     this.label7.Size = new System.Drawing.Size(80, 16);
     this.label7.TabIndex = 73;
     this.label7.Text = "Brand Code";
     //
     // btnReset
     //
     this.btnReset.ButtonStyle = DevExpress.XtraEditors.Controls.BorderStyles.Simple;
     this.btnReset.Location = new System.Drawing.Point(696, 40);
     this.btnReset.Name = "btnReset";
     this.btnReset.Size = new System.Drawing.Size(72, 20);
     this.btnReset.TabIndex = 72;
     this.btnReset.Text = "Reset";
     this.btnReset.Click += new System.EventHandler(this.btnReset_Click);
     //
     // btnSearch
     //
     this.btnSearch.ButtonStyle = DevExpress.XtraEditors.Controls.BorderStyles.Simple;
     this.btnSearch.Location = new System.Drawing.Point(616, 40);
     this.btnSearch.Name = "btnSearch";
     this.btnSearch.Size = new System.Drawing.Size(72, 20);
     this.btnSearch.TabIndex = 71;
     this.btnSearch.Text = "Search";
     this.btnSearch.Click += new System.EventHandler(this.btnSearch_Click);
     //
     // label5
     //
     this.label5.Font = new System.Drawing.Font("Microsoft Sans Serif", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
     this.label5.Location = new System.Drawing.Point(544, 8);
     this.label5.Name = "label5";
     this.label5.Size = new System.Drawing.Size(72, 16);
     this.label5.TabIndex = 70;
     this.label5.Text = "Style Desc";
     //
     // txtStyleDesc
     //
     this.txtStyleDesc.EditValue = "";
     this.txtStyleDesc.Location = new System.Drawing.Point(624, 8);
     this.txtStyleDesc.Name = "txtStyleDesc";
     this.txtStyleDesc.Size = new System.Drawing.Size(144, 20);
     this.txtStyleDesc.TabIndex = 69;
     //
     // label4
     //
     this.label4.Font = new System.Drawing.Font("Microsoft Sans Serif", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
     this.label4.Location = new System.Drawing.Point(376, 8);
     this.label4.Name = "label4";
     this.label4.Size = new System.Drawing.Size(80, 16);
     this.label4.TabIndex = 68;
     this.label4.Text = "Style Code";
     //
     // txtStyleCode
     //
     this.txtStyleCode.EditValue = "";
     this.txtStyleCode.Location = new System.Drawing.Point(456, 8);
     this.txtStyleCode.Name = "txtStyleCode";
     this.txtStyleCode.Size = new System.Drawing.Size(80, 20);
     this.txtStyleCode.TabIndex = 67;
     //
     // label3
     //
     this.label3.Font = new System.Drawing.Font("Microsoft Sans Serif", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
     this.label3.Location = new System.Drawing.Point(160, 8);
     this.label3.Name = "label3";
     this.label3.Size = new System.Drawing.Size(72, 16);
     this.label3.TabIndex = 66;
     this.label3.Text = "Item Desc";
     //
     // txtItemDesc
     //
     this.txtItemDesc.EditValue = "";
     this.txtItemDesc.Location = new System.Drawing.Point(232, 8);
     this.txtItemDesc.Name = "txtItemDesc";
     this.txtItemDesc.Size = new System.Drawing.Size(136, 20);
     this.txtItemDesc.TabIndex = 65;
     //
     // label6
     //
     this.label6.Font = new System.Drawing.Font("Microsoft Sans Serif", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
     this.label6.Location = new System.Drawing.Point(8, 8);
     this.label6.Name = "label6";
     this.label6.Size = new System.Drawing.Size(72, 16);
     this.label6.TabIndex = 64;
     this.label6.Text = "Item Code";
     //
     // txtItemCode
     //
     this.txtItemCode.EditValue = "";
     this.txtItemCode.Location = new System.Drawing.Point(80, 8);
     this.txtItemCode.Name = "txtItemCode";
     this.txtItemCode.Size = new System.Drawing.Size(80, 20);
     this.txtItemCode.TabIndex = 63;
     //
     // RPStockSalon
     //
     this.AutoScale = false;
     this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
     this.ClientSize = new System.Drawing.Size(974, 548);
     this.Controls.Add(this.panelControl1);
     this.Controls.Add(this.GridStockRequest);
     this.Controls.Add(this.lkedtEmployee);
     this.Controls.Add(this.label2);
     this.Controls.Add(this.DateFrom);
     this.Controls.Add(this.DateTo);
     this.Controls.Add(this.label1);
     this.Controls.Add(this.DateRangeTo);
     this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle;
     this.MaximizeBox = false;
     this.MinimizeBox = false;
     this.Name = "RPStockSalon";
     this.Text = "Stock Inventory - Salon Use";
     this.Load += new System.EventHandler(this.RPStockSalon_Load);
     ((System.ComponentModel.ISupportInitialize)(this.DateFrom.Properties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.DateRangeTo.Properties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.lkedtEmployee.Properties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.GridStockRequest)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.panelControl1)).EndInit();
     this.panelControl1.ResumeLayout(false);
     ((System.ComponentModel.ISupportInitialize)(this.lkedtProductType.Properties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.lkedtBrandCode.Properties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.txtStyleDesc.Properties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.txtStyleCode.Properties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.txtItemDesc.Properties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.txtItemCode.Properties)).EndInit();
     this.ResumeLayout(false);
 }
 private bool IsNullValue(DevExpress.XtraPivotGrid.PivotDrillDownDataSource ds, DevExpress.XtraPivotGrid.PivotGridField field)
 {
     if (ds.RowCount == 0)
     {
         return(false);
     }
     for (int i = 0; i < ds.RowCount; i++)
     {
         if (!Equals(ds[i][field], null))
         {
             return(false);
         }
     }
     return(true);
 }
Beispiel #21
0
 public XtraPivotMenu(string text, System.EventHandler click, XtraContextMenuType menuType, DevExpress.XtraPivotGrid.PivotGridField sortField) : base(text, click)
 {
     _MenuType  = menuType;
     _SortField = sortField;
 }
 /// <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);
 }
Beispiel #23
0
 /// <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();
     this.gvGymAnalysis = new DevExpress.XtraPivotGrid.PivotGridControl();
     this.pivotGridField1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.pivotGridField2 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.pivotGridField3 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.DateFrom = new DevExpress.XtraEditors.DateEdit();
     this.DateTo = new DevExpress.XtraEditors.DateEdit();
     this.TimeFrom = new DevExpress.XtraEditors.TimeEdit();
     this.TimeTo = new DevExpress.XtraEditors.TimeEdit();
     this.label63 = new System.Windows.Forms.Label();
     this.label1 = new System.Windows.Forms.Label();
     this.label2 = new System.Windows.Forms.Label();
     this.label3 = new System.Windows.Forms.Label();
     this.btnReset = new DevExpress.XtraEditors.SimpleButton();
     this.PRINT1 = new DevExpress.XtraEditors.HyperLinkEdit();
     this.printingSystem1 = new DevExpress.XtraPrinting.PrintingSystem(this.components);
     this.printableComponentLink1 = new DevExpress.XtraPrinting.PrintableComponentLink(this.components);
     ((System.ComponentModel.ISupportInitialize)(this.gvGymAnalysis)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.DateFrom.Properties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.DateTo.Properties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.TimeFrom.Properties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.TimeTo.Properties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.PRINT1.Properties)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.printingSystem1)).BeginInit();
     this.SuspendLayout();
     //
     // gvGymAnalysis
     //
     this.gvGymAnalysis.Cursor = System.Windows.Forms.Cursors.Default;
     this.gvGymAnalysis.Dock = System.Windows.Forms.DockStyle.Bottom;
     this.gvGymAnalysis.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
                                                                                          this.pivotGridField1,
                                                                                          this.pivotGridField2,
                                                                                          this.pivotGridField3});
     this.gvGymAnalysis.Location = new System.Drawing.Point(0, 38);
     this.gvGymAnalysis.Name = "gvGymAnalysis";
     this.gvGymAnalysis.OptionsCustomization.AllowDrag = false;
     this.gvGymAnalysis.OptionsCustomization.AllowFilter = false;
     this.gvGymAnalysis.OptionsCustomization.AllowSort = false;
     this.gvGymAnalysis.OptionsView.ShowDataHeaders = false;
     this.gvGymAnalysis.OptionsView.ShowFilterHeaders = false;
     this.gvGymAnalysis.Size = new System.Drawing.Size(962, 448);
     this.gvGymAnalysis.TabIndex = 0;
     //
     // pivotGridField1
     //
     this.pivotGridField1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.pivotGridField1.AreaIndex = 0;
     this.pivotGridField1.FieldName = "nClassInstanceID";
     this.pivotGridField1.Name = "pivotGridField1";
     this.pivotGridField1.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Count;
     //
     // pivotGridField2
     //
     this.pivotGridField2.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
     this.pivotGridField2.AreaIndex = 0;
     this.pivotGridField2.Caption = "Branch";
     this.pivotGridField2.FieldName = "strBranchCode";
     this.pivotGridField2.Name = "pivotGridField2";
     //
     // pivotGridField3
     //
     this.pivotGridField3.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.pivotGridField3.AreaIndex = 0;
     this.pivotGridField3.Caption = "Date";
     this.pivotGridField3.FieldName = "dtDate";
     this.pivotGridField3.Name = "pivotGridField3";
     this.pivotGridField3.ValueFormat.FormatString = "MM/dd/yyyy";
     this.pivotGridField3.ValueFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
     //
     // DateFrom
     //
     this.DateFrom.EditValue = null;
     this.DateFrom.Location = new System.Drawing.Point(80, 8);
     this.DateFrom.Name = "DateFrom";
     //
     // DateFrom.Properties
     //
     this.DateFrom.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
                                                                                                      new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
     this.DateFrom.Properties.DisplayFormat.FormatString = "dd/MM/yyyy";
     this.DateFrom.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
     this.DateFrom.Properties.EditFormat.FormatString = "dd/MM/yyyy";
     this.DateFrom.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.Custom;
     this.DateFrom.Properties.Mask.EditMask = "dd/MM/yyyy";
     this.DateFrom.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.DateTimeAdvancingCaret;
     this.DateFrom.TabIndex = 1;
     //
     // DateTo
     //
     this.DateTo.EditValue = null;
     this.DateTo.Location = new System.Drawing.Point(256, 8);
     this.DateTo.Name = "DateTo";
     //
     // DateTo.Properties
     //
     this.DateTo.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
                                                                                                    new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
     this.DateTo.Properties.DisplayFormat.FormatString = "dd/MM/yyyy";
     this.DateTo.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
     this.DateTo.Properties.EditFormat.FormatString = "dd/MM/yyyy";
     this.DateTo.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.Custom;
     this.DateTo.Properties.Mask.EditMask = "dd/MM/yyyy";
     this.DateTo.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.DateTimeAdvancingCaret;
     this.DateTo.TabIndex = 2;
     //
     // TimeFrom
     //
     this.TimeFrom.EditValue = new System.DateTime(2006, 8, 23, 0, 0, 0, 0);
     this.TimeFrom.Location = new System.Drawing.Point(456, 8);
     this.TimeFrom.Name = "TimeFrom";
     //
     // TimeFrom.Properties
     //
     this.TimeFrom.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
                                                                                                      new DevExpress.XtraEditors.Controls.EditorButton()});
     this.TimeFrom.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.DateTimeAdvancingCaret;
     this.TimeFrom.TabIndex = 3;
     //
     // TimeTo
     //
     this.TimeTo.EditValue = new System.DateTime(2006, 8, 23, 0, 0, 0, 0);
     this.TimeTo.Location = new System.Drawing.Point(624, 8);
     this.TimeTo.Name = "TimeTo";
     //
     // TimeTo.Properties
     //
     this.TimeTo.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
                                                                                                    new DevExpress.XtraEditors.Controls.EditorButton()});
     this.TimeTo.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.DateTimeAdvancingCaret;
     this.TimeTo.TabIndex = 4;
     //
     // label63
     //
     this.label63.BackColor = System.Drawing.Color.Transparent;
     this.label63.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
     this.label63.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
     this.label63.Location = new System.Drawing.Point(8, 8);
     this.label63.Name = "label63";
     this.label63.Size = new System.Drawing.Size(64, 16);
     this.label63.TabIndex = 37;
     this.label63.Text = "Date From";
     //
     // label1
     //
     this.label1.BackColor = System.Drawing.Color.Transparent;
     this.label1.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
     this.label1.Location = new System.Drawing.Point(200, 8);
     this.label1.Name = "label1";
     this.label1.Size = new System.Drawing.Size(48, 16);
     this.label1.TabIndex = 38;
     this.label1.Text = "Date To";
     //
     // label2
     //
     this.label2.BackColor = System.Drawing.Color.Transparent;
     this.label2.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
     this.label2.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
     this.label2.Location = new System.Drawing.Point(384, 8);
     this.label2.Name = "label2";
     this.label2.Size = new System.Drawing.Size(64, 16);
     this.label2.TabIndex = 39;
     this.label2.Text = "Time From";
     //
     // label3
     //
     this.label3.BackColor = System.Drawing.Color.Transparent;
     this.label3.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
     this.label3.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
     this.label3.Location = new System.Drawing.Point(568, 8);
     this.label3.Name = "label3";
     this.label3.Size = new System.Drawing.Size(48, 16);
     this.label3.TabIndex = 40;
     this.label3.Text = "Time To";
     //
     // btnReset
     //
     this.btnReset.Appearance.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
     this.btnReset.Appearance.Options.UseFont = true;
     this.btnReset.ButtonStyle = DevExpress.XtraEditors.Controls.BorderStyles.Simple;
     this.btnReset.Location = new System.Drawing.Point(792, 8);
     this.btnReset.LookAndFeel.UseDefaultLookAndFeel = false;
     this.btnReset.Name = "btnReset";
     this.btnReset.Size = new System.Drawing.Size(72, 24);
     this.btnReset.TabIndex = 216;
     this.btnReset.Text = "Generate";
     this.btnReset.Click += new System.EventHandler(this.btnReset_Click);
     //
     // PRINT1
     //
     this.PRINT1.EditValue = "PRINT";
     this.PRINT1.Location = new System.Drawing.Point(880, 16);
     this.PRINT1.Name = "PRINT1";
     //
     // PRINT1.Properties
     //
     this.PRINT1.Properties.Appearance.BackColor = System.Drawing.SystemColors.Control;
     this.PRINT1.Properties.Appearance.Options.UseBackColor = true;
     this.PRINT1.Properties.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.NoBorder;
     this.PRINT1.Size = new System.Drawing.Size(40, 18);
     this.PRINT1.TabIndex = 217;
     this.PRINT1.OpenLink += new DevExpress.XtraEditors.Controls.OpenLinkEventHandler(this.PRINT1_OpenLink);
     //
     // printingSystem1
     //
     this.printingSystem1.Links.AddRange(new object[] {
                                                          this.printableComponentLink1});
     //
     // printableComponentLink1
     //
     this.printableComponentLink1.Component = this.gvGymAnalysis;
     this.printableComponentLink1.PageHeaderFooter = new DevExpress.XtraPrinting.PageHeaderFooter(new DevExpress.XtraPrinting.PageHeaderArea(new string[] {
                                                                                                                                                              "GYM ANALYSIS REPORT",
                                                                                                                                                              "",
                                                                                                                                                              "[Date Printed] [Time Printed]"}, new System.Drawing.Font("Microsoft Sans Serif", 12F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Underline))), System.Drawing.GraphicsUnit.Point, ((System.Byte)(0))), DevExpress.XtraPrinting.BrickAlignment.Near), new DevExpress.XtraPrinting.PageFooterArea(new string[] {
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           "",
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           "",
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           "[Page # of Pages #]"}, new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))), DevExpress.XtraPrinting.BrickAlignment.Near));
     this.printableComponentLink1.PrintingSystem = this.printingSystem1;
     //
     // RPGymAnalysis
     //
     this.AutoScale = false;
     this.AutoScaleBaseSize = new System.Drawing.Size(5, 14);
     this.AutoScroll = true;
     this.ClientSize = new System.Drawing.Size(962, 486);
     this.Controls.Add(this.PRINT1);
     this.Controls.Add(this.btnReset);
     this.Controls.Add(this.label3);
     this.Controls.Add(this.label2);
     this.Controls.Add(this.label1);
     this.Controls.Add(this.label63);
     this.Controls.Add(this.TimeTo);
     this.Controls.Add(this.TimeFrom);
     this.Controls.Add(this.DateTo);
     this.Controls.Add(this.DateFrom);
     this.Controls.Add(this.gvGymAnalysis);
     this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedToolWindow;
     this.Name = "RPGymAnalysis";
     this.Text = "Gym Analysis";
     this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
     this.Load += new System.EventHandler(this.RPGymAnalysis_Load);
     ((System.ComponentModel.ISupportInitialize)(this.gvGymAnalysis)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.DateFrom.Properties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.DateTo.Properties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.TimeFrom.Properties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.TimeTo.Properties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.PRINT1.Properties)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.printingSystem1)).EndInit();
     this.ResumeLayout(false);
 }
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 protected void InitializeComponent()
 {
     this.components = new System.ComponentModel.Container();
     this.barManager1 = new DevExpress.XtraBars.BarManager(this.components);
     this.MainBar = new DevExpress.XtraBars.Bar();
     this.barButtonItemSearch = new DevExpress.XtraBars.BarButtonItem();
     this.popupMenuFilter = new DevExpress.XtraBars.PopupMenu(this.components);
     this.barCheckItemFilter = new DevExpress.XtraBars.BarCheckItem();
     this.barButtonItemTuyChonXemDoThi = new DevExpress.XtraBars.BarButtonItem();
     this.barItemIn = new DevExpress.XtraBars.BarButtonItem();
     this.popupIn = new DevExpress.XtraBars.PopupMenu(this.components);
     this.barItemXemTruoc = new DevExpress.XtraBars.BarButtonItem();
     this.barButtonItemExport = new DevExpress.XtraBars.BarSubItem();
     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.barButtonItem3 = new DevExpress.XtraBars.BarButtonItem();
     this.splitContainerControl1 = new DevExpress.XtraEditors.SplitContainerControl();
     this.pivotGridMaster = new DevExpress.XtraPivotGrid.PivotGridControl();
     this.fieldKenhPhat = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldTietMuc = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldNoiDung = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldTenGoc = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldTongTap = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldNuocSX = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldNgayPhatTapDau = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldSoLanPhat = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldNam = new DevExpress.XtraPivotGrid.PivotGridField();
     this.fieldThang = new DevExpress.XtraPivotGrid.PivotGridField();
     this.popupControlContainerFilter = new DevExpress.XtraBars.PopupControlContainer(this.components);
     this.thoiGian = new ProtocolVN.Framework.Win.Trial.PLDateSelection();
     this.labelControl4 = new DevExpress.XtraEditors.LabelControl();
     ((System.ComponentModel.ISupportInitialize)(this.barManager1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.popupMenuFilter)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.popupIn)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.splitContainerControl1)).BeginInit();
     this.splitContainerControl1.SuspendLayout();
     ((System.ComponentModel.ISupportInitialize)(this.pivotGridMaster)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.popupControlContainerFilter)).BeginInit();
     this.popupControlContainerFilter.SuspendLayout();
     this.SuspendLayout();
     //
     // barManager1
     //
     this.barManager1.Bars.AddRange(new DevExpress.XtraBars.Bar[] {
     this.MainBar});
     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.Items.AddRange(new DevExpress.XtraBars.BarItem[] {
     this.barButtonItemExport,
     this.barButtonItemSearch,
     this.barButtonItemTuyChonXemDoThi,
     this.barCheckItemFilter,
     this.barButtonItem3,
     this.barItemXemTruoc,
     this.barItemIn});
     this.barManager1.MaxItemId = 36;
     //
     // MainBar
     //
     this.MainBar.BarName = "MainBar";
     this.MainBar.DockCol = 0;
     this.MainBar.DockRow = 0;
     this.MainBar.DockStyle = DevExpress.XtraBars.BarDockStyle.Top;
     this.MainBar.FloatLocation = new System.Drawing.Point(39, 133);
     this.MainBar.FloatSize = new System.Drawing.Size(72, 73);
     this.MainBar.LinksPersistInfo.AddRange(new DevExpress.XtraBars.LinkPersistInfo[] {
     new DevExpress.XtraBars.LinkPersistInfo(this.barButtonItemSearch),
     new DevExpress.XtraBars.LinkPersistInfo(this.barButtonItemTuyChonXemDoThi, true),
     new DevExpress.XtraBars.LinkPersistInfo(this.barItemIn, true),
     new DevExpress.XtraBars.LinkPersistInfo(this.barButtonItemExport, true)});
     this.MainBar.OptionsBar.AllowQuickCustomization = false;
     this.MainBar.OptionsBar.DrawDragBorder = false;
     this.MainBar.OptionsBar.RotateWhenVertical = false;
     this.MainBar.OptionsBar.UseWholeRow = true;
     this.MainBar.Text = "Custom 1";
     //
     // barButtonItemSearch
     //
     this.barButtonItemSearch.ButtonStyle = DevExpress.XtraBars.BarButtonStyle.DropDown;
     this.barButtonItemSearch.Caption = "Xem &thống kê";
     this.barButtonItemSearch.DropDownControl = this.popupMenuFilter;
     this.barButtonItemSearch.Id = 27;
     this.barButtonItemSearch.Name = "barButtonItemSearch";
     this.barButtonItemSearch.PaintStyle = DevExpress.XtraBars.BarItemPaintStyle.CaptionGlyph;
     //
     // popupMenuFilter
     //
     this.popupMenuFilter.LinksPersistInfo.AddRange(new DevExpress.XtraBars.LinkPersistInfo[] {
     new DevExpress.XtraBars.LinkPersistInfo(this.barCheckItemFilter)});
     this.popupMenuFilter.Manager = this.barManager1;
     this.popupMenuFilter.Name = "popupMenuFilter";
     //
     // barCheckItemFilter
     //
     this.barCheckItemFilter.Caption = "Hiện điều kiện thống kê";
     this.barCheckItemFilter.Checked = true;
     this.barCheckItemFilter.Id = 29;
     this.barCheckItemFilter.Name = "barCheckItemFilter";
     this.barCheckItemFilter.PaintStyle = DevExpress.XtraBars.BarItemPaintStyle.CaptionGlyph;
     //
     // barButtonItemTuyChonXemDoThi
     //
     this.barButtonItemTuyChonXemDoThi.Caption = "Xem &biểu đồ";
     this.barButtonItemTuyChonXemDoThi.Id = 4;
     this.barButtonItemTuyChonXemDoThi.Name = "barButtonItemTuyChonXemDoThi";
     this.barButtonItemTuyChonXemDoThi.PaintStyle = DevExpress.XtraBars.BarItemPaintStyle.CaptionGlyph;
     //
     // barItemIn
     //
     this.barItemIn.ButtonStyle = DevExpress.XtraBars.BarButtonStyle.DropDown;
     this.barItemIn.Caption = "&In";
     this.barItemIn.DropDownControl = this.popupIn;
     this.barItemIn.Id = 35;
     this.barItemIn.Name = "barItemIn";
     this.barItemIn.PaintStyle = DevExpress.XtraBars.BarItemPaintStyle.CaptionGlyph;
     //
     // popupIn
     //
     this.popupIn.LinksPersistInfo.AddRange(new DevExpress.XtraBars.LinkPersistInfo[] {
     new DevExpress.XtraBars.LinkPersistInfo(this.barItemXemTruoc)});
     this.popupIn.Manager = this.barManager1;
     this.popupIn.Name = "popupIn";
     //
     // barItemXemTruoc
     //
     this.barItemXemTruoc.Caption = "Xem t&rước";
     this.barItemXemTruoc.Id = 34;
     this.barItemXemTruoc.Name = "barItemXemTruoc";
     //
     // barButtonItemExport
     //
     this.barButtonItemExport.Caption = "Xuất ra &file";
     this.barButtonItemExport.Id = 3;
     this.barButtonItemExport.Name = "barButtonItemExport";
     this.barButtonItemExport.PaintStyle = DevExpress.XtraBars.BarItemPaintStyle.CaptionGlyph;
     //
     // barDockControlTop
     //
     this.barDockControlTop.Dock = System.Windows.Forms.DockStyle.Top;
     this.barDockControlTop.Location = new System.Drawing.Point(0, 0);
     this.barDockControlTop.Size = new System.Drawing.Size(925, 24);
     //
     // barDockControlBottom
     //
     this.barDockControlBottom.Dock = System.Windows.Forms.DockStyle.Bottom;
     this.barDockControlBottom.Location = new System.Drawing.Point(0, 497);
     this.barDockControlBottom.Size = new System.Drawing.Size(925, 0);
     //
     // barDockControlLeft
     //
     this.barDockControlLeft.Dock = System.Windows.Forms.DockStyle.Left;
     this.barDockControlLeft.Location = new System.Drawing.Point(0, 24);
     this.barDockControlLeft.Size = new System.Drawing.Size(0, 473);
     //
     // barDockControlRight
     //
     this.barDockControlRight.Dock = System.Windows.Forms.DockStyle.Right;
     this.barDockControlRight.Location = new System.Drawing.Point(925, 24);
     this.barDockControlRight.Size = new System.Drawing.Size(0, 473);
     //
     // barButtonItem3
     //
     this.barButtonItem3.ButtonStyle = DevExpress.XtraBars.BarButtonStyle.DropDown;
     this.barButtonItem3.Caption = "In";
     this.barButtonItem3.Id = 30;
     this.barButtonItem3.Name = "barButtonItem3";
     //
     // splitContainerControl1
     //
     this.splitContainerControl1.Dock = System.Windows.Forms.DockStyle.Fill;
     this.splitContainerControl1.Horizontal = false;
     this.splitContainerControl1.Location = new System.Drawing.Point(0, 61);
     this.splitContainerControl1.Name = "splitContainerControl1";
     this.splitContainerControl1.Panel1.Controls.Add(this.pivotGridMaster);
     this.splitContainerControl1.Panel1.Text = "splitContainerControl1_Panel1";
     this.splitContainerControl1.Panel2.CaptionLocation = DevExpress.Utils.Locations.Left;
     this.splitContainerControl1.Panel2.ShowCaption = true;
     this.splitContainerControl1.Panel2.Text = "splitContainerControl1_Panel2";
     this.splitContainerControl1.PanelVisibility = DevExpress.XtraEditors.SplitPanelVisibility.Panel1;
     this.splitContainerControl1.Size = new System.Drawing.Size(925, 436);
     this.splitContainerControl1.SplitterPosition = 405;
     this.splitContainerControl1.TabIndex = 4;
     this.splitContainerControl1.Text = "splitContainerControl1";
     //
     // pivotGridMaster
     //
     this.pivotGridMaster.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.NoBorder;
     this.pivotGridMaster.Cursor = System.Windows.Forms.Cursors.Default;
     this.pivotGridMaster.Dock = System.Windows.Forms.DockStyle.Fill;
     this.pivotGridMaster.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
     this.fieldKenhPhat,
     this.fieldTietMuc,
     this.fieldNoiDung,
     this.fieldTenGoc,
     this.fieldTongTap,
     this.fieldNuocSX,
     this.fieldNgayPhatTapDau,
     this.fieldSoLanPhat,
     this.fieldNam,
     this.fieldThang});
     this.pivotGridMaster.Location = new System.Drawing.Point(0, 0);
     this.pivotGridMaster.Name = "pivotGridMaster";
     this.pivotGridMaster.OptionsView.ShowFilterHeaders = false;
     this.pivotGridMaster.Size = new System.Drawing.Size(925, 436);
     this.pivotGridMaster.TabIndex = 2;
     //
     // fieldKenhPhat
     //
     this.fieldKenhPhat.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.fieldKenhPhat.AreaIndex = 0;
     this.fieldKenhPhat.Name = "fieldKenhPhat";
     this.fieldKenhPhat.Options.AllowDrag = DevExpress.Utils.DefaultBoolean.True;
     this.fieldKenhPhat.Options.AllowEdit = false;
     this.fieldKenhPhat.Options.ReadOnly = true;
     this.fieldKenhPhat.TotalsVisibility = DevExpress.XtraPivotGrid.PivotTotalsVisibility.None;
     //
     // fieldTietMuc
     //
     this.fieldTietMuc.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.fieldTietMuc.AreaIndex = 1;
     this.fieldTietMuc.Name = "fieldTietMuc";
     this.fieldTietMuc.Options.AllowDrag = DevExpress.Utils.DefaultBoolean.False;
     this.fieldTietMuc.Options.AllowEdit = false;
     this.fieldTietMuc.Options.ReadOnly = true;
     this.fieldTietMuc.TotalsVisibility = DevExpress.XtraPivotGrid.PivotTotalsVisibility.None;
     //
     // fieldNoiDung
     //
     this.fieldNoiDung.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.fieldNoiDung.AreaIndex = 3;
     this.fieldNoiDung.Name = "fieldNoiDung";
     this.fieldNoiDung.Options.AllowDrag = DevExpress.Utils.DefaultBoolean.False;
     this.fieldNoiDung.Options.AllowEdit = false;
     this.fieldNoiDung.Options.ReadOnly = true;
     this.fieldNoiDung.Options.ShowCustomTotals = false;
     this.fieldNoiDung.Options.ShowTotals = false;
     this.fieldNoiDung.TotalsVisibility = DevExpress.XtraPivotGrid.PivotTotalsVisibility.None;
     //
     // fieldTenGoc
     //
     this.fieldTenGoc.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.fieldTenGoc.AreaIndex = 2;
     this.fieldTenGoc.Name = "fieldTenGoc";
     this.fieldTenGoc.Options.AllowDrag = DevExpress.Utils.DefaultBoolean.False;
     this.fieldTenGoc.Options.AllowEdit = false;
     this.fieldTenGoc.Options.ReadOnly = true;
     this.fieldTenGoc.TotalsVisibility = DevExpress.XtraPivotGrid.PivotTotalsVisibility.None;
     //
     // fieldTongTap
     //
     this.fieldTongTap.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.fieldTongTap.AreaIndex = 4;
     this.fieldTongTap.Name = "fieldTongTap";
     this.fieldTongTap.Options.AllowDrag = DevExpress.Utils.DefaultBoolean.False;
     this.fieldTongTap.Options.AllowEdit = false;
     this.fieldTongTap.Options.ReadOnly = true;
     this.fieldTongTap.TotalsVisibility = DevExpress.XtraPivotGrid.PivotTotalsVisibility.None;
     //
     // fieldNuocSX
     //
     this.fieldNuocSX.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.fieldNuocSX.AreaIndex = 5;
     this.fieldNuocSX.Name = "fieldNuocSX";
     this.fieldNuocSX.Options.AllowDrag = DevExpress.Utils.DefaultBoolean.False;
     this.fieldNuocSX.Options.AllowEdit = false;
     this.fieldNuocSX.Options.ReadOnly = true;
     this.fieldNuocSX.TotalsVisibility = DevExpress.XtraPivotGrid.PivotTotalsVisibility.None;
     //
     // fieldNgayPhatTapDau
     //
     this.fieldNgayPhatTapDau.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.fieldNgayPhatTapDau.AreaIndex = 6;
     this.fieldNgayPhatTapDau.Name = "fieldNgayPhatTapDau";
     this.fieldNgayPhatTapDau.Options.AllowDrag = DevExpress.Utils.DefaultBoolean.False;
     this.fieldNgayPhatTapDau.Options.AllowEdit = false;
     this.fieldNgayPhatTapDau.Options.ReadOnly = true;
     this.fieldNgayPhatTapDau.TotalsVisibility = DevExpress.XtraPivotGrid.PivotTotalsVisibility.None;
     this.fieldNgayPhatTapDau.UnboundFieldName = "fieldNgayPhatTapDau";
     //
     // fieldSoLanPhat
     //
     this.fieldSoLanPhat.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.fieldSoLanPhat.AreaIndex = 0;
     this.fieldSoLanPhat.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.fieldSoLanPhat.Name = "fieldSoLanPhat";
     this.fieldSoLanPhat.Options.AllowDrag = DevExpress.Utils.DefaultBoolean.False;
     this.fieldSoLanPhat.Options.AllowEdit = false;
     this.fieldSoLanPhat.Options.ShowGrandTotal = false;
     //
     // fieldNam
     //
     this.fieldNam.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
     this.fieldNam.AreaIndex = 0;
     this.fieldNam.Name = "fieldNam";
     this.fieldNam.Options.AllowDrag = DevExpress.Utils.DefaultBoolean.False;
     this.fieldNam.Options.ShowGrandTotal = false;
     this.fieldNam.Options.ShowTotals = false;
     this.fieldNam.UnboundFieldName = "fieldNam";
     //
     // fieldThang
     //
     this.fieldThang.Appearance.Header.Options.UseTextOptions = true;
     this.fieldThang.Appearance.Header.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
     this.fieldThang.Appearance.Value.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Bold);
     this.fieldThang.Appearance.Value.Options.UseFont = true;
     this.fieldThang.Appearance.Value.Options.UseTextOptions = true;
     this.fieldThang.Appearance.Value.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
     this.fieldThang.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
     this.fieldThang.AreaIndex = 1;
     this.fieldThang.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateMonth;
     this.fieldThang.Name = "fieldThang";
     this.fieldThang.Options.AllowDrag = DevExpress.Utils.DefaultBoolean.False;
     this.fieldThang.Options.ShowGrandTotal = false;
     this.fieldThang.Options.ShowTotals = false;
     this.fieldThang.UnboundFieldName = "fieldThang";
     //
     // popupControlContainerFilter
     //
     this.popupControlContainerFilter.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.NoBorder;
     this.popupControlContainerFilter.Controls.Add(this.thoiGian);
     this.popupControlContainerFilter.Controls.Add(this.labelControl4);
     this.popupControlContainerFilter.Dock = System.Windows.Forms.DockStyle.Top;
     this.popupControlContainerFilter.Location = new System.Drawing.Point(0, 24);
     this.popupControlContainerFilter.Manager = this.barManager1;
     this.popupControlContainerFilter.Name = "popupControlContainerFilter";
     this.popupControlContainerFilter.Size = new System.Drawing.Size(925, 37);
     this.popupControlContainerFilter.TabIndex = 0;
     this.popupControlContainerFilter.Visible = false;
     //
     // thoiGian
     //
     this.thoiGian.Caption = "Năm 2010";
     this.thoiGian.Default = ProtocolVN.Framework.Win.Trial.SelectionTypes.OneYear;
     this.thoiGian.FirstFrom = new System.DateTime(2010, 1, 1, 0, 0, 0, 0);
     this.thoiGian.FirstTo = new System.DateTime(2010, 12, 31, 0, 0, 0, 0);
     this.thoiGian.FromDate = new System.DateTime(2010, 1, 1, 0, 0, 0, 0);
     this.thoiGian.Location = new System.Drawing.Point(53, 6);
     this.thoiGian.Name = "thoiGian";
     this.thoiGian.ReturnType = ProtocolVN.Framework.Win.Trial.TimeType.Date;
     this.thoiGian.SecondFrom = new System.DateTime(2010, 1, 1, 0, 0, 0, 0);
     this.thoiGian.SecondTo = new System.DateTime(2010, 12, 31, 0, 0, 0, 0);
     this.thoiGian.SelectedType = ProtocolVN.Framework.Win.Trial.SelectionTypes.OneYear;
     this.thoiGian.Size = new System.Drawing.Size(122, 20);
     this.thoiGian.TabIndex = 16;
     this.thoiGian.ToDate = new System.DateTime(2010, 12, 31, 0, 0, 0, 0);
     this.thoiGian.Types = ((ProtocolVN.Framework.Win.Trial.SelectionTypes)(((((((((ProtocolVN.Framework.Win.Trial.SelectionTypes.OneDate | ProtocolVN.Framework.Win.Trial.SelectionTypes.OneMonth)
                 | ProtocolVN.Framework.Win.Trial.SelectionTypes.OneQuarter)
                 | ProtocolVN.Framework.Win.Trial.SelectionTypes.OneYear)
                 | ProtocolVN.Framework.Win.Trial.SelectionTypes.SixMonths)
                 | ProtocolVN.Framework.Win.Trial.SelectionTypes.FromDateToDate)
                 | ProtocolVN.Framework.Win.Trial.SelectionTypes.FromMonthToMonth)
                 | ProtocolVN.Framework.Win.Trial.SelectionTypes.FromQuarterToQuarter)
                 | ProtocolVN.Framework.Win.Trial.SelectionTypes.FromYearToYear)));
     //
     // labelControl4
     //
     this.labelControl4.Location = new System.Drawing.Point(4, 9);
     this.labelControl4.Name = "labelControl4";
     this.labelControl4.Size = new System.Drawing.Size(43, 13);
     this.labelControl4.TabIndex = 15;
     this.labelControl4.Text = "Thời gian";
     //
     // frmThongKePCT
     //
     this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
     this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
     this.ClientSize = new System.Drawing.Size(925, 497);
     this.Controls.Add(this.splitContainerControl1);
     this.Controls.Add(this.popupControlContainerFilter);
     this.Controls.Add(this.barDockControlLeft);
     this.Controls.Add(this.barDockControlRight);
     this.Controls.Add(this.barDockControlBottom);
     this.Controls.Add(this.barDockControlTop);
     this.Name = "frmThongKePCT";
     this.ShowInTaskbar = false;
     this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
     this.Text = "Thống kê lịch phát sóng";
     ((System.ComponentModel.ISupportInitialize)(this.barManager1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.popupMenuFilter)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.popupIn)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.splitContainerControl1)).EndInit();
     this.splitContainerControl1.ResumeLayout(false);
     ((System.ComponentModel.ISupportInitialize)(this.pivotGridMaster)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.popupControlContainerFilter)).EndInit();
     this.popupControlContainerFilter.ResumeLayout(false);
     this.popupControlContainerFilter.PerformLayout();
     this.ResumeLayout(false);
 }
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(StatisticByProductNumber));
     this.pivotGridControl = new DevExpress.XtraPivotGrid.PivotGridControl();
     this.pivotGridField1 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.pivotGridField2 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.pivotGridField3 = new DevExpress.XtraPivotGrid.PivotGridField();
     this.ngayBatDauDTPicker = new System.Windows.Forms.DateTimePicker();
     this.ngayKetThucDTPicker = new System.Windows.Forms.DateTimePicker();
     this.titlePanel = new DevExpress.XtraEditors.PanelControl();
     this.titleLabel = new DevExpress.XtraEditors.LabelControl();
     this.label1 = new System.Windows.Forms.Label();
     this.label2 = new System.Windows.Forms.Label();
     this.panelControl1 = new DevExpress.XtraEditors.PanelControl();
     this.presentButton = new DevExpress.XtraEditors.SimpleButton();
     this.panelControl2 = new DevExpress.XtraEditors.PanelControl();
     ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.titlePanel)).BeginInit();
     this.titlePanel.SuspendLayout();
     ((System.ComponentModel.ISupportInitialize)(this.panelControl1)).BeginInit();
     this.panelControl1.SuspendLayout();
     ((System.ComponentModel.ISupportInitialize)(this.panelControl2)).BeginInit();
     this.panelControl2.SuspendLayout();
     this.SuspendLayout();
     //
     // pivotGridControl
     //
     this.pivotGridControl.Dock = System.Windows.Forms.DockStyle.Fill;
     this.pivotGridControl.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] {
     this.pivotGridField1,
     this.pivotGridField2,
     this.pivotGridField3});
     this.pivotGridControl.Location = new System.Drawing.Point(2, 2);
     this.pivotGridControl.Name = "pivotGridControl";
     this.pivotGridControl.Size = new System.Drawing.Size(867, 287);
     this.pivotGridControl.TabIndex = 0;
     //
     // pivotGridField1
     //
     this.pivotGridField1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.pivotGridField1.AreaIndex = 1;
     this.pivotGridField1.Caption = "Product";
     this.pivotGridField1.FieldName = "ProductName";
     this.pivotGridField1.MinWidth = 100;
     this.pivotGridField1.Name = "pivotGridField1";
     this.pivotGridField1.Width = 300;
     //
     // pivotGridField2
     //
     this.pivotGridField2.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
     this.pivotGridField2.AreaIndex = 0;
     this.pivotGridField2.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
     this.pivotGridField2.FieldName = "Quantity";
     this.pivotGridField2.Name = "pivotGridField2";
     this.pivotGridField2.Options.AllowSort = DevExpress.Utils.DefaultBoolean.True;
     this.pivotGridField2.Options.AllowSortBySummary = DevExpress.Utils.DefaultBoolean.True;
     this.pivotGridField2.SortBySummaryInfo.FieldName = "Quantity";
     this.pivotGridField2.SortMode = DevExpress.XtraPivotGrid.PivotSortMode.Value;
     this.pivotGridField2.UnboundFieldName = "pivotGridField2";
     //
     // pivotGridField3
     //
     this.pivotGridField3.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
     this.pivotGridField3.AreaIndex = 0;
     this.pivotGridField3.Caption = "Category";
     this.pivotGridField3.FieldName = "CategoryName";
     this.pivotGridField3.MinWidth = 100;
     this.pivotGridField3.Name = "pivotGridField3";
     this.pivotGridField3.Width = 300;
     //
     // ngayBatDauDTPicker
     //
     this.ngayBatDauDTPicker.Format = System.Windows.Forms.DateTimePickerFormat.Short;
     this.ngayBatDauDTPicker.Location = new System.Drawing.Point(103, 17);
     this.ngayBatDauDTPicker.Name = "ngayBatDauDTPicker";
     this.ngayBatDauDTPicker.Size = new System.Drawing.Size(200, 20);
     this.ngayBatDauDTPicker.TabIndex = 1;
     //
     // ngayKetThucDTPicker
     //
     this.ngayKetThucDTPicker.Format = System.Windows.Forms.DateTimePickerFormat.Short;
     this.ngayKetThucDTPicker.Location = new System.Drawing.Point(415, 16);
     this.ngayKetThucDTPicker.Name = "ngayKetThucDTPicker";
     this.ngayKetThucDTPicker.Size = new System.Drawing.Size(200, 20);
     this.ngayKetThucDTPicker.TabIndex = 2;
     //
     // titlePanel
     //
     this.titlePanel.Controls.Add(this.titleLabel);
     this.titlePanel.Dock = System.Windows.Forms.DockStyle.Top;
     this.titlePanel.Location = new System.Drawing.Point(0, 0);
     this.titlePanel.Name = "titlePanel";
     this.titlePanel.Size = new System.Drawing.Size(871, 44);
     this.titlePanel.TabIndex = 31;
     //
     // titleLabel
     //
     this.titleLabel.Appearance.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Bold);
     this.titleLabel.Appearance.ForeColor = System.Drawing.Color.Maroon;
     this.titleLabel.Location = new System.Drawing.Point(12, 12);
     this.titleLabel.Name = "titleLabel";
     this.titleLabel.Size = new System.Drawing.Size(179, 19);
     this.titleLabel.TabIndex = 0;
     this.titleLabel.Text = "PRODUCT STATISTICS";
     //
     // label1
     //
     this.label1.AutoSize = true;
     this.label1.Location = new System.Drawing.Point(35, 23);
     this.label1.Name = "label1";
     this.label1.Size = new System.Drawing.Size(38, 13);
     this.label1.TabIndex = 32;
     this.label1.Text = "FROM";
     //
     // label2
     //
     this.label2.AutoSize = true;
     this.label2.Location = new System.Drawing.Point(372, 22);
     this.label2.Name = "label2";
     this.label2.Size = new System.Drawing.Size(22, 13);
     this.label2.TabIndex = 33;
     this.label2.Text = "TO";
     //
     // panelControl1
     //
     this.panelControl1.Controls.Add(this.presentButton);
     this.panelControl1.Controls.Add(this.label1);
     this.panelControl1.Controls.Add(this.label2);
     this.panelControl1.Controls.Add(this.ngayKetThucDTPicker);
     this.panelControl1.Controls.Add(this.ngayBatDauDTPicker);
     this.panelControl1.Dock = System.Windows.Forms.DockStyle.Top;
     this.panelControl1.Location = new System.Drawing.Point(0, 44);
     this.panelControl1.Name = "panelControl1";
     this.panelControl1.Size = new System.Drawing.Size(871, 53);
     this.panelControl1.TabIndex = 34;
     //
     // presentButton
     //
     this.presentButton.ButtonStyle = DevExpress.XtraEditors.Controls.BorderStyles.Office2003;
     this.presentButton.Image = ((System.Drawing.Image)(resources.GetObject("presentButton.Image")));
     this.presentButton.Location = new System.Drawing.Point(676, 12);
     this.presentButton.Name = "presentButton";
     this.presentButton.Size = new System.Drawing.Size(87, 33);
     this.presentButton.TabIndex = 34;
     this.presentButton.Text = "Show";
     this.presentButton.Click += new System.EventHandler(this.presentButton_Click);
     //
     // panelControl2
     //
     this.panelControl2.Controls.Add(this.pivotGridControl);
     this.panelControl2.Dock = System.Windows.Forms.DockStyle.Fill;
     this.panelControl2.Location = new System.Drawing.Point(0, 97);
     this.panelControl2.Name = "panelControl2";
     this.panelControl2.Size = new System.Drawing.Size(871, 291);
     this.panelControl2.TabIndex = 35;
     //
     // StatisticByProductNumber
     //
     this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
     this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
     this.ClientSize = new System.Drawing.Size(871, 388);
     this.Controls.Add(this.panelControl2);
     this.Controls.Add(this.panelControl1);
     this.Controls.Add(this.titlePanel);
     this.Name = "StatisticByProductNumber";
     this.Text = "StatisticByProductNumber";
     this.Load += new System.EventHandler(this.StatisticByProductNumber_Load);
     ((System.ComponentModel.ISupportInitialize)(this.pivotGridControl)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.titlePanel)).EndInit();
     this.titlePanel.ResumeLayout(false);
     this.titlePanel.PerformLayout();
     ((System.ComponentModel.ISupportInitialize)(this.panelControl1)).EndInit();
     this.panelControl1.ResumeLayout(false);
     this.panelControl1.PerformLayout();
     ((System.ComponentModel.ISupportInitialize)(this.panelControl2)).EndInit();
     this.panelControl2.ResumeLayout(false);
     this.ResumeLayout(false);
 }