//根据分组的类型设置默认的分组数据。
// 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);
}
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);
}
}
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;
}
}
}
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);
}
}
//处理字段结合绑定的情况
private void processUnitField(ColPivotList xmlCfgLst, DevExpress.XtraPivotGrid.PivotGridControl gridCtl)
{
if (xmlCfgLst == null || xmlCfgLst.FieldGroups == null || xmlCfgLst.FieldGroups.Length == 0)
{
return;
}
string[] groups = xmlCfgLst.FieldGroups.Split(';');
foreach (string group in groups)
{
string[] fields = group.Split(',');
DevExpress.XtraPivotGrid.PivotGridGroup pivotGridGroup = new DevExpress.XtraPivotGrid.PivotGridGroup();
gridCtl.Groups.Add(pivotGridGroup);
foreach (string field in fields)
{
DevExpress.XtraPivotGrid.PivotGridField pivField = gridCtl.Fields[field];
if (pivField == null)
{
continue;
}
pivotGridGroup.Add(pivField);
}
}
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
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);
}
//内部函数处理，把数据加载到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;
}
//通过配置的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);
}
}
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);
}
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);
}
/// <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();
}
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);
}
}
}
/// <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);
}
/// <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();
}
//增加网格显示的格式化样式信息。
private void addConditionsForStyles(DevExpress.XtraPivotGrid.PivotGridControl gridCtl, MB.WinBase.IFace.IClientRuleQueryBase busObj)
{
if (busObj == null)
{
return;
}
Dictionary <string, MB.WinBase.Common.StyleConditionInfo> styleConditions = busObj.UIRuleXmlConfigInfo.GetDefaultStyleConditions();
if (styleConditions == null)
{
return;
}
XWinLib.Share.StyleCfgList styleList = XWinLib.Share.StyleCfgList.CreateInstance();
if (styleList == null)
{
return;
}
foreach (MB.WinBase.Common.StyleConditionInfo info in styleConditions.Values)
{
//判断定义的样式是否存在。
if (!styleList.ContainsKey(info.StyleName))
{
MB.Util.TraceEx.Write(string.Format("样式 {0} 需要在AppStylesConfig.xml 文件中配置,如果已经配置请检查大小写。", info.StyleName), MB.Util.APPMessageType.SysErrInfo);
continue;
}
DevExpress.XtraPivotGrid.PivotGridField pivField = gridCtl.Fields[info.ColumnName];
if (pivField == null)
{
MB.Util.TraceEx.Write(string.Format("字段 {0} 的 Style Format condition 列名称的配置，在数据源中找不到对应的列，请检查。", info.ColumnName), MB.Util.APPMessageType.SysErrInfo);
continue;
}
XWinLib.Share.StyleCfgInfo styleInfo = styleList[info.StyleName];
//如果存在DispColName 的话，需要也是处理，在本应该程序中是在GridView的RowCellStyle事件中进行处理。
if (info.IsByEvent || (info.DispColName != null && info.DispColName.Length > 0 && info.DispColName != info.ColumnName))
{
continue;
}
//创建FormatCondition。
if (gridCtl.FormatConditions[info.Name] == null)
{
DevExpress.XtraGrid.FormatConditionEnum cc = (DevExpress.XtraGrid.FormatConditionEnum)Enum.Parse(typeof(DevExpress.XtraGrid.FormatConditionEnum), Enum.GetName(typeof(DataFilterConditions), info.Condition));
DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition styleCondition = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition();
styleCondition.Appearance.BackColor = styleInfo.BackColor;
styleCondition.Appearance.ForeColor = styleInfo.ForeColor;
styleCondition.Appearance.Font = styleInfo.Font;
styleCondition.Appearance.Options.UseBackColor = true;
styleCondition.Appearance.Options.UseForeColor = true;
styleCondition.ApplyToCustomTotalCell = false;
styleCondition.ApplyToGrandTotalCell = false;
styleCondition.ApplyToTotalCell = false;
styleCondition.Condition = (DevExpress.XtraGrid.FormatConditionEnum)Enum.Parse(typeof(DevExpress.XtraGrid.FormatConditionEnum), Enum.GetName(typeof(DataFilterConditions), info.Condition));
styleCondition.Field = pivField;
styleCondition.Value1 = info.Value;
styleCondition.Value2 = info.Value2;
gridCtl.FormatConditions.Add(styleCondition);
}
}
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
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);
}
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);
}
/// <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);
}