public void CellsPivotTablesPutWorksheetPivotTableFilterTest()
{
// TODO uncomment below to test the method and replace null with proper value
string name = PivTestFile;
string sheetName = SHEET4;
int? pivotTableIndex = 0;
PivotFilter pivotFilter = new PivotFilter();
pivotFilter.FieldIndex = 1;
pivotFilter.FilterType = "Count";
AutoFilter autoFilter = new AutoFilter();
autoFilter.FilterColumns = new List <FilterColumn>();
FilterColumn filterColumn = new FilterColumn();
filterColumn.FilterType = "Top10";
filterColumn.FieldIndex = 0;
filterColumn.Top10Filter = new Top10Filter();
filterColumn.Top10Filter.Items = 1;
filterColumn.Top10Filter.IsTop = true;
filterColumn.Top10Filter.IsPercent = false;
autoFilter.FilterColumns.Add(filterColumn);
pivotFilter.AutoFilter = autoFilter;
bool? needReCalculate = true;
string folder = TEMPFOLDER;
UpdateDataFile(instance, folder, name);
var response = instance.CellsPivotTablesPutWorksheetPivotTableFilter(name, sheetName, pivotTableIndex, pivotFilter, needReCalculate, folder);
Assert.IsInstanceOf <CellsCloudResponse>(response, "response is CellsCloudResponse");
Assert.AreEqual(response.Code, 200);
}
private questStatus create(MasterPricingEntities dbContext, List <Quest.Functional.MasterPricing.FilterColumn> filterColumnList, out List <Quest.Functional.MasterPricing.FilterColumn> filterColumnIdList)
{
// Initialize
filterColumnIdList = null;
// Perform create
try
{
List <Quest.Services.Dbio.MasterPricing.FilterColumns> _filterColumnList = new List <Quest.Services.Dbio.MasterPricing.FilterColumns>();
foreach (Quest.Functional.MasterPricing.FilterColumn filterColumn in filterColumnList)
{
Quest.Services.Dbio.MasterPricing.FilterColumns _filterColumn = new Quest.Services.Dbio.MasterPricing.FilterColumns();
BufferMgr.TransferBuffer(filterColumn, _filterColumn);
_filterColumnList.Add(_filterColumn);
}
dbContext.FilterColumns.AddRange(_filterColumnList);
dbContext.SaveChanges();
filterColumnIdList = new List <FilterColumn>();
foreach (Quest.Services.Dbio.MasterPricing.FilterColumns _filterColumn in _filterColumnList)
{
Quest.Functional.MasterPricing.FilterColumn filterColumn = new FilterColumn();
filterColumn.Id = _filterColumn.Id;
filterColumnIdList.Add(filterColumn);
}
}
catch (System.Exception ex)
{
return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
ex.InnerException != null ? ex.InnerException.Message : ex.Message)));
}
return(new questStatus(Severity.Success));
}
public void CellsPivotTablesPutWorksheetPivotTableFilterTest()
{
string name = "TestCase.xlsx";
string sheetName = "SHEET4";
int? pivotTableIndex = 0;
PivotFilter pivotFilter = new PivotFilter();
pivotFilter.FieldIndex = 1;
pivotFilter.FilterType = "Count";
AutoFilter autoFilter = new AutoFilter();
autoFilter.FilterColumns = new List <FilterColumn>();
FilterColumn filterColumn = new FilterColumn();
filterColumn.FilterType = "Top10";
filterColumn.FieldIndex = 0;
filterColumn.Top10Filter = new Top10Filter();
filterColumn.Top10Filter.Items = 1;
filterColumn.Top10Filter.IsTop = true;
filterColumn.Top10Filter.IsPercent = false;
autoFilter.FilterColumns.Add(filterColumn);
pivotFilter.AutoFilter = autoFilter;
bool? needReCalculate = true;
string folder = "TEMPFOLDER";
new Config().UpdateDataFile(folder, name);
var response = instance.CellsPivotTablesPutWorksheetPivotTableFilter(name, sheetName, pivotTableIndex, pivotFilter, needReCalculate, folder);
Console.WriteLine(response);
}
void AddButton_Activated(object sender, EventArgs e)
{
var isValid = ValidateFilter();
if (isValid)
{
FilterColumn col = new FilterColumn();
Operator oper = new Operator();
var selColumnValue = ColumnComboBox.SelectedValue as NSString;
var column = (FilterColumn)col.GetByDescription(selColumnValue.ToString());
var selOpValue = OperatorComboBox.SelectedValue as NSString;
var op = (Operator)oper.GetByDescription(selOpValue.ToString());
var criteria = new FilterCriteriaDto
{
Column = column,
Operator = op,
Value = ValueTextField.StringValue
};
var isDuplicate = IsDuplicate(criteria);
if (!isDuplicate)
{
Filters.Add(criteria);
RefreshGrid(Filters);
ValueTextField.StringValue = (NSString)string.Empty;
}
else
{
UIErrorHelper.ShowAlert(null, "You are trying to add a duplicate filter.");
}
}
SetDeleteButtonStatus();
SetUpdateButtonStatus();
}
private void FillTree()
{
var fvm = GetFilterViewModel();
if (fvm == null)
{
return;
}
var columns = new List <FilterColumn>();
foreach (var field in fvm.Fields)
{
var column = new FilterColumn
{
ColumnCaption = field.Caption,
ColumnType = field.FieldType,
FieldName = field.SourceName,
EditSettings = CreateEditorSettings(field)
};
columns.Add(column);
}
baseFilter.FilterColumns = columns;
// таким хитрым способом заставляем перерисоваться фильтр
var prev = fvm.FilterExpression;
fvm.FilterExpression = null;
fvm.FilterExpression = prev;
}
private List <string> GetDataSource(FilterColumn value)
{
var isNum = IsNumeric(value);
var columns = isNum ? GetNumericSource() : GetStringSource();
return(columns);
}
void InitFilter()
{
List <FilterColumn> columns = new List <FilterColumn>();
GridColumn column = gridMain.Columns["FPassportNo"];
FilterColumn newColumn = new FilterColumn()
{
FieldName = column.FieldName,
ColumnCaption = column.Header,
ColumnType = typeof(string)
};
columns.Add(newColumn);
column = gridMain.Columns["FAutoID"];
newColumn = new FilterColumn()
{
FieldName = column.FieldName,
ColumnCaption = column.Header,
ColumnType = typeof(string)
};
columns.Add(newColumn);
filter.FilterColumns = columns;
this.gridMain.FilterString = "[FPassportNo] = ? and [FAutoID] = ? ";
dateFrom.EditValue = DateTime.Today.AddDays(-7);
dateTo.EditValue = DateTime.Today;
}
private bool IsNumeric(FilterColumn value)
{
return
((value == FilterColumn.Start)
||
(value == FilterColumn.Duration));
}
private questStatus getFilterColumn(BulkUpdateColumnValue bulkUpdateColumnValue, Filter filter, int numFROMEntities)
{
// Initialize
string[] pp = null;
string entityName = null;
string columnName = null;
FilterColumn filterColumn = null;
if (filter.FilterTableList.Count == 1)
{
entityName = filter.FilterTableList[0].TablesetTable.Table.Name;
columnName = bulkUpdateColumnValue.Name;
}
else
{
pp = bulkUpdateColumnValue.Name.Split('_');
entityName = pp[0];
columnName = pp[1];
filterColumn = null;
}
// Get FilterColumn of given bulk update column.
FilterTable filterTable = filter.FilterTableList.Find(delegate(FilterTable t) { return(t.TablesetTable.Table.Name == entityName); });
if (filterTable != null)
{
filterColumn = filter.FilterColumnList.Find(delegate(FilterColumn c) {
return(c.TablesetColumn.Column.Name == columnName && c.TablesetColumn.Column.EntityTypeId == EntityType.Table && c.TablesetColumn.Column.EntityId == filterTable.TablesetTable.Table.Id);
});
if (filterColumn == null)
{
return(new questStatus(Severity.Error, String.Format("ERROR: filter column not found for bulk update column {0}",
bulkUpdateColumnValue.Name)));
}
}
else
{
FilterView filterView = filter.FilterViewList.Find(delegate(FilterView v) { return(v.TablesetView.View.Name == entityName); });
if (filterView == null)
{
return(new questStatus(Severity.Error, String.Format("ERROR: filter view not found for bulk update column {0}",
bulkUpdateColumnValue.Name)));
}
filterColumn = filter.FilterColumnList.Find(delegate(FilterColumn c) {
return(c.TablesetColumn.Column.Name == columnName && c.TablesetColumn.Column.EntityTypeId == EntityType.View && c.TablesetColumn.Column.EntityId == filterView.TablesetView.View.Id);
});
if (filterColumn == null)
{
return(new questStatus(Severity.Error, String.Format("ERROR: filter column not found for bulk update column {0} (view search)",
bulkUpdateColumnValue.Name)));
}
}
bulkUpdateColumnValue.FilterColumn = filterColumn;
return(new questStatus(Severity.Success));
}
public MyFilterBuilder(FilterColumnCollection columns, IDXMenuManager manager, UserLookAndFeel lookAndFeel,
ColumnView view, FilterColumn fColumn)
: base(columns, manager, lookAndFeel, view, fColumn)
{
sbOK.Enabled = sbApply.Enabled = false;
((FilterControl)fcMain).FilterChanged +=
new FilterChangedEventHandler(OnFilterControlFilterChanged);
}
public JoinEntity()
{
Type = new FilterEntityType();
FilterItem = new FilterItem();
FilterTable = new FilterTable();
FilterView = new FilterView();
TablesetColumn = new TablesetColumn();
FilterColumn = new FilterColumn();
FilterItemJoin = new FilterItemJoin();
}
private questStatus getJoinTargetColumnId(Filter filter, FilterItemJoin filterItemJoin)
{
if (filterItemJoin.TargetEntityTypeId == FilterEntityType.Table)
{
// Get the TablesetColumnId for the given join.
FilterTable filterTable = filter.FilterTableList.Find(delegate(FilterTable t)
{
return(filterItemJoin.TargetSchema == t.Schema && filterItemJoin.TargetEntityName == t.Name);
});
if (filterTable == null)
{
return(new questStatus(String.Format("ERROR: seeking FilterItemJoin {0} TablesetColumnId not found (FilterTable) [{1}].[{2}]",
filterItemJoin.Id, filterItemJoin.TargetSchema, filterItemJoin.TargetEntityName)));
}
// Now get the TablesetColumnId for the given column name
FilterColumn filterColumn = filterTable.FilterColumnList.Find(delegate(FilterColumn fc)
{
return(filterItemJoin.TargetColumnName == fc.TablesetColumn.Name);
});
if (filterColumn == null)
{
return(new questStatus(String.Format("ERROR: seeking FilterItemJoin {0} FilterColumn not found (FilterTable) [{1}].[{2}]",
filterItemJoin.Id, filterItemJoin.TargetSchema, filterItemJoin.TargetEntityName)));
}
filterItemJoin.ColumnId = filterColumn.TablesetColumn.Id;
}
else if (filterItemJoin.TargetEntityTypeId == FilterEntityType.View)
{
// Get the TablesetColumnId for the given join.
FilterView filterView = filter.FilterViewList.Find(delegate(FilterView v)
{
return(filterItemJoin.TargetSchema == v.Schema && filterItemJoin.TargetEntityName == v.Name);
});
if (filterView == null)
{
return(new questStatus(String.Format("ERROR: seeking FilterItemJoin {0} TablesetColumnId not found (FilterView) [{1}].[{2}]",
filterItemJoin.Id, filterItemJoin.TargetSchema, filterItemJoin.TargetEntityName)));
}
// Now get the TablesetColumnId for the given column name
FilterColumn filterColumn = filterView.FilterColumnList.Find(delegate(FilterColumn fc)
{
return(filterItemJoin.TargetColumnName == fc.TablesetColumn.Name);
});
if (filterColumn == null)
{
return(new questStatus(String.Format("ERROR: seeking FilterItemJoin {0} FilterColumn not found (FilterView) [{1}].[{2}]",
filterItemJoin.Id, filterItemJoin.TargetSchema, filterItemJoin.TargetEntityName)));
}
filterItemJoin.ColumnId = filterColumn.TablesetColumn.Id;
}
return(new questStatus(Severity.Success));
}
private void LoadDefaults()
{
FilterColumn column = new FilterColumn();
var list = column.ToDictionary().Select(x => NSObject.FromObject(x.Value)).ToArray();
ColumnComboBox.Add(list);
SetDeleteButtonStatus();
SetAddButtonStatus();
SetUpdateButtonStatus();
_originalFilters = new FilterCriteriaDto[Filters.Count];
Filters.CopyTo(_originalFilters, 0);
RefreshGrid(Filters);
}
public questStatus Update(DbMgrTransaction trans, FilterColumn filterColumn)
{
// Initialize
questStatus status = null;
// Update filterColumn
status = _dbFilterColumnsMgr.Update(trans, filterColumn);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus GetResultsColumnIdentifier(Filter filter, FilterItem filterItem, int numItemEntities, out string columnIdentifier, out FilterColumn filterColumn)
{
// Initialize
columnIdentifier = null;
filterColumn = null;
FilterColumn _filterColumn = filterItem.FilterColumn;
if (_filterColumn == null)
{
return(new questStatus(Severity.Error, String.Format("ERROR: filter item {0} filter column not found in filter (building lookups)", filterItem.FilterEntityId)));
}
filterColumn = _filterColumn;
// If column labeled, that's it.
if (!string.IsNullOrEmpty(filterItem.Label))
{
columnIdentifier = filterItem.Label;
return(new questStatus(Severity.Success));
}
// Determine column identifier.
// Single-entity filters, it's the column name alone.
// More than one entity, it's the entity name + "_" + column name.
if (numItemEntities == 1)
{
columnIdentifier = _filterColumn.TablesetColumn.Column.Name;
}
else
{
if (_filterColumn.FilterEntityTypeId == FilterEntityType.Table)
{
FilterTable filterTable = filter.FilterTableList.Find(delegate(FilterTable t) { return(t.Id == _filterColumn.FilterEntityId); });
columnIdentifier = filterTable.TablesetTable.Table.Name + "_" + _filterColumn.TablesetColumn.Column.Name;
}
else if (_filterColumn.FilterEntityTypeId == FilterEntityType.View)
{
FilterView filterView = filter.FilterViewList.Find(delegate(FilterView v) { return(v.Id == _filterColumn.FilterEntityId); });
columnIdentifier = filterView.TablesetView.View.Name + "_" + _filterColumn.TablesetColumn.Column.Name;
}
else
{
return(new questStatus(Severity.Error, String.Format("ERROR: invalid filter column {0} entity type id: {1} (determining column identifier)",
_filterColumn.FilterEntityId, _filterColumn.FilterEntityTypeId)));
}
}
return(new questStatus(Severity.Success));
}
private List <ContractViewModel> GetFilteredConstractsQuery(FilterColumn filterCol, string filterString, int page, out int totalRows)
{
var list = new List <ContractViewModel>();
using (var context = new DealerContractContext())
{
int excludedRows = (page - 1) * ContractListingViewModel.ItemPerPage;
string processedFilterString = filterString;
if (filterCol == FilterColumn.Added) //convert username to int first
{
var user = context.Users.Where(u => u.Username == filterString);
if (user == null || user.Count() < 1)
{
processedFilterString = "-1";
}
else
{
processedFilterString = user.First().UserId.ToString();
}
}
var query = context.Contracts
.OrderBy(c => c.ContractId)
.Where(ExpressionHelper.GetContainsExpression <Contracts>(filterCol.ToString(), processedFilterString));
totalRows = query.Count();
query = query.Skip(excludedRows).Take(ContractListingViewModel.ItemPerPage);
if (query.Any())
{
list = (from c in query
select new ContractViewModel()
{
ContractId = c.ContractId,
Name = c.Name,
Address = c.Address,
Commission = c.Commission,
Effective = c.Effective,
Phone = c.Phone,
ScannedContractUrl = c.ScannedContractUrl,
TaxId = c.TaxId,
UserId = c.UserId,
Username = c.User.Username
}).ToList();
}
#if DEBUG
Debug.Print($"filterd list count: {list.Count}");
#endif
return(list);
}
}
public questStatus Read(FilterColumnId filterColumnId, out FilterColumn filterColumn)
{
// Initialize
questStatus status = null;
filterColumn = null;
// Read filterColumn
status = _dbFilterColumnsMgr.Read(filterColumnId, out filterColumn);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus FormatBootstrapTreeviewNode(FilterView filterView, FilterColumn filterColumn, out BootstrapTreenodeViewModel bootstrapTreenodeViewModel)
{
// Initialize
bootstrapTreenodeViewModel = new BootstrapTreenodeViewModel();
bootstrapTreenodeViewModel.Id = filterColumn.TablesetColumn.Id;
bootstrapTreenodeViewModel.ParentId = filterColumn.TablesetColumn.TableSetEntityId;
bootstrapTreenodeViewModel.type = "column";
bootstrapTreenodeViewModel.parentType = "view";
bootstrapTreenodeViewModel.icon = "fa fa-square-o padding-right-20 ";
bootstrapTreenodeViewModel.text = filterColumn.TablesetColumn.Name + " : " + GetColumnDataType(filterColumn.TablesetColumn.Column);
bootstrapTreenodeViewModel.Schema = null;
bootstrapTreenodeViewModel.Name = filterColumn.TablesetColumn.Name;
bootstrapTreenodeViewModel.selectable = "true";
return(new questStatus(Severity.Success));
}
public questStatus Create(DbMgrTransaction trans, FilterColumn filterColumn, out FilterColumnId filterColumnId)
{
// Initialize
questStatus status = null;
filterColumnId = null;
// Create filterColumn
status = _dbFilterColumnsMgr.Create(trans, filterColumn, out filterColumnId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
void ColumnComboBox_SelectionChanged(object sender, EventArgs e)
{
var rowId = ((int)ColumnComboBox.SelectedIndex);
if (rowId > -1)
{
FilterColumn column = new FilterColumn();
var selColumnValue = ColumnComboBox.SelectedValue as NSString;
var col = (FilterColumn)column.GetByDescription(selColumnValue.ToString());
var operators = GetDataSource(col);
var ops = operators.Select(x => NSObject.FromObject(x)).ToArray();
OperatorComboBox.StringValue = (NSString)string.Empty;
OperatorComboBox.RemoveAll();
OperatorComboBox.Add(ops);
SetAddButtonStatus();
SetUpdateButtonStatus();
}
}
private void LoadDefaults()
{
FilterColumn column = new FilterColumn();
var dict = column.ToDictionary();
var columns = dict.Select(x => new ComboBoxItem {
Value = x.Key, Display = x.Value
}).ToList();
cbColumn.DataSource = columns;
cbColumn.DisplayMember = "Display";
cbColumn.ValueMember = "Value";
SetDeleteButtonStatus();
SetAddButtonStatus();
SetUpdateButtonStatus();
_originalFilters = new FilterCriteriaDto[Filters.Count];
Filters.CopyTo(_originalFilters, 0);
RefreshGrid(Filters);
}
public DashboardViewModel()
{
Timer.Tick += (ea, sa) =>
{
TodayTime = string.Format("{0:hh:mm:ss tt}", DateTime.Now);
};
Timer.Interval = new TimeSpan(0, 0, 1);
Timer.Start();
clientRepo = new ClientRepository();
App.ContainerVM.AYMenuVisbility = System.Windows.Visibility.Visible;
FilterColumn.Add(string.Empty);
FilterColumn.Add("PanCard");
FilterColumn.Add("Name");
Messenger.Default.Register <AddClientViewModel>(this, (send) =>
{
LoadClietns();
});
}
/// <summary>
/// Makes a call to the database getting the unique filters based on the command string supplied
/// </summary>
/// <param name="_cmdString">The unique command string used to request the filters</param>
/// <returns>returns the result (unique filters)</returns>
private static void GetFilterData(ref HashSet <string> _uniqueFilters, FilterColumn _column)
{
try
{
// Create a command string based on the filter column supplied.
string cmdString = "SELECT DISTINCT " + DatabaseManager.TargetTable + ".[" + filterColumns[(int)_column] + "] FROM " + DatabaseManager.TargetTable;
// Get the connection to the database
OleDbConnection conn = DatabaseManager.GetDatabaseConnection();
// Create a new SQL Statement
OleDbCommand cmd = new OleDbCommand(cmdString, conn);
// Read each result returned from the SQL Statement
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
// If the cell in the database is blank, mark is as [Blanks] like excel
if (reader[filterColumns[(int)_column]] == DBNull.Value)
{
_uniqueFilters.Add("[Blanks]");
continue;
}
else
{
// Add the unique filter to the list of filters.
_uniqueFilters.Add(reader[filterColumns[(int)_column]].ToString());
}
}
}
}
catch (InvalidOperationException)
{
MessageBox.Show("An invalid operation exception was thrown", "Unique Filter Request", MessageBoxButtons.OK, MessageBoxIcon.Error);
// Close the application
Application.Exit();
}
}
void SearchControl_Loaded(object sender, RoutedEventArgs e)
{
this.Loaded -= SearchControl_Loaded;
if (DesignerProperties.GetIsInDesignMode(this) || QueryName == null)
{
return;
}
if (qd == null)
{
qd = DynamicQueryServer.GetQueryDescription(QueryName);
}
if (FilterColumn.HasText())
{
FilterOptions.Add(new FilterOption
{
ColumnName = FilterColumn,
Operation = FilterOperation.EqualTo,
Frozen = true,
}.Bind(FilterOption.ValueProperty, new Binding("DataContext" + (FilterRoute.HasText() ? "." + FilterRoute : null))
{
Source = this
}));
ColumnOptions.Add(new ColumnOption(FilterColumn));
ColumnOptionsMode = ColumnOptionsMode.Remove;
}
FilterOption.SetFilterTokens(FilterOptions, qd);
AutomationProperties.SetName(this, QueryUtils.GetQueryUniqueKey(QueryName));
Search();
foreach (var item in FilterOptions)
{
item.BindingValueChanged += new DependencyPropertyChangedEventHandler(item_BindingValueChanged);
}
}
internal FilterColumn ToFilterColumn()
{
var fc = new FilterColumn();
if (HasFilters)
{
fc.Filters = Filters.ToFilters();
}
if (HasTop10)
{
fc.Top10 = Top10.ToTop10();
}
if (HasCustomFilters)
{
fc.CustomFilters = CustomFilters.ToCustomFilters();
}
if (HasDynamicFilter)
{
fc.DynamicFilter = DynamicFilter.ToDynamicFilter();
}
if (HasColorFilter)
{
fc.ColorFilter = ColorFilter.ToColorFilter();
}
if (HasIconFilter)
{
fc.IconFilter = IconFilter.ToIconFilter();
}
fc.ColumnId = ColumnId;
if ((HiddenButton != null) && HiddenButton.Value)
{
fc.HiddenButton = HiddenButton.Value;
}
if ((ShowButton != null) && !ShowButton.Value)
{
fc.ShowButton = ShowButton.Value;
}
return(fc);
}
internal void FromFilterColumn(FilterColumn fc)
{
this.SetAllNull();
if (fc.Filters != null)
{
this.Filters.FromFilters(fc.Filters);
this.HasFilters = true;
}
if (fc.Top10 != null)
{
this.Top10.FromTop10(fc.Top10);
this.HasTop10 = true;
}
if (fc.CustomFilters != null)
{
this.CustomFilters.FromCustomFilters(fc.CustomFilters);
this.HasCustomFilters = true;
}
if (fc.DynamicFilter != null)
{
this.DynamicFilter.FromDynamicFilter(fc.DynamicFilter);
this.HasDynamicFilter = true;
}
if (fc.ColorFilter != null)
{
this.ColorFilter.FromColorFilter(fc.ColorFilter);
this.HasColorFilter = true;
}
if (fc.IconFilter != null)
{
this.IconFilter.FromIconFilter(fc.IconFilter);
this.HasIconFilter = true;
}
this.ColumnId = fc.ColumnId.Value;
if (fc.HiddenButton != null && fc.HiddenButton.Value) this.HiddenButton = fc.HiddenButton.Value;
if (fc.ShowButton != null && !fc.ShowButton.Value) this.ShowButton = fc.ShowButton.Value;
}
private void RefreshColumnCollection()
{
FilterControl component = (FilterControl)base.Component;
ISupportInitializeNotification dataSource = component.DataSource as ISupportInitializeNotification;
if ((dataSource == null) || dataSource.IsInitialized)
{
IComponentChangeService service = null;
PropertyDescriptor member = null;
IDesignerHost provider = base.Component.Site.GetService(typeof(IDesignerHost)) as IDesignerHost;
if (!this.ProcessSimilarSchema(component))
{
PropertyDescriptorCollection itemProperties = null;
if (this.cm != null)
{
try
{
itemProperties = this.cm.GetItemProperties();
}
catch (ArgumentException exception)
{
throw new InvalidOperationException("DataSourceNoLongerValid", exception);
}
}
IContainer container = (component.Site != null) ? component.Site.Container : null;
service = base.Component.Site.GetService(typeof(IComponentChangeService)) as IComponentChangeService;
member = TypeDescriptor.GetProperties(base.Component)["Columns"];
service.OnComponentChanging(base.Component, member);
FilterColumn[] columnArray = new FilterColumn[component.Columns.Count];
int index = 0;
for (int i = 0; i < component.Columns.Count; i++)
{
FilterColumn column = component.Columns[i];
if (column.DataPropertyName.IsNotEmpty())
{
PropertyDescriptor descriptor2 = TypeDescriptor.GetProperties(column)["UserAddedColumn"];
if ((descriptor2 == null) || !((bool)descriptor2.GetValue(column)))
{
columnArray[index] = column;
index++;
}
}
}
for (int j = 0; j < index; j++)
{
component.Columns.Remove(columnArray[j]);
}
service.OnComponentChanged(base.Component, member, null, null);
if (container != null)
{
for (int m = 0; m < index; m++)
{
container.Remove(columnArray[m]);
}
}
FilterColumn[] columnArray2 = null;
int num5 = 0;
if (component.DataSource != null)
{
columnArray2 = new FilterColumn[itemProperties.Count];
num5 = 0;
for (int n = 0; n < itemProperties.Count; n++)
{
System.Type typeofDataGridViewImageColumn;
FilterColumn column2 = null;
TypeConverter converter = TypeDescriptor.GetConverter(typeof(Image));
System.Type propertyType = itemProperties[n].PropertyType;
if ((propertyType == typeof(bool)) || (propertyType == typeof(CheckState)))
{
typeofDataGridViewImageColumn = typeofFilterCheckBoxColumn;
}
else
{
typeofDataGridViewImageColumn = typeofFilterTextBoxColumn;
}
string name = DesignerUtils.NameFromText(itemProperties[n].Name, typeofDataGridViewImageColumn, base.Component.Site);
column2 = TypeDescriptor.CreateInstance(provider, typeofDataGridViewImageColumn, null, null) as FilterColumn;
column2.DataPropertyName = itemProperties[n].Name;
column2.HeaderText = itemProperties[n].DisplayName.IsNotEmpty() ? itemProperties[n].DisplayName : itemProperties[n].Name;
column2.Name = itemProperties[n].Name;
provider.Container.Add(column2, name);
columnArray2[num5] = column2;
num5++;
}
}
service.OnComponentChanging(base.Component, member);
for (int k = 0; k < num5; k++)
{
component.Columns.Add(columnArray2[k]);
}
service.OnComponentChanged(base.Component, member, null, null);
}
}
}
// Generates content of pivotTablePart9.
private void GeneratePivotTablePart9Content(PivotTablePart pivotTablePart9)
{
PivotTableDefinition pivotTableDefinition17 = new PivotTableDefinition(){ Name = "PivotTable1", CacheId = (UInt32Value)1U, ApplyNumberFormats = false, ApplyBorderFormats = false, ApplyFontFormats = false, ApplyPatternFormats = false, ApplyAlignmentFormats = false, ApplyWidthHeightFormats = true, DataCaption = "Values", UpdatedVersion = 5, MinRefreshableVersion = 5, UseAutoFormatting = true, ItemPrintTitles = true, CreatedVersion = 4, Indent = (UInt32Value)0U, Outline = true, OutlineData = true, MultipleFieldFilters = false, ChartFormat = (UInt32Value)17U };
Location location9 = new Location(){ Reference = "A1:B5", FirstHeaderRow = (UInt32Value)1U, FirstDataRow = (UInt32Value)1U, FirstDataColumn = (UInt32Value)1U };
PivotFields pivotFields9 = new PivotFields(){ Count = (UInt32Value)7U };
PivotField pivotField56 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };
Items items31 = new Items(){ Count = (UInt32Value)15U };
Item item270 = new Item(){ Index = (UInt32Value)0U };
Item item271 = new Item(){ Index = (UInt32Value)1U };
Item item272 = new Item(){ Index = (UInt32Value)2U };
Item item273 = new Item(){ Index = (UInt32Value)3U };
Item item274 = new Item(){ Index = (UInt32Value)4U };
Item item275 = new Item(){ Index = (UInt32Value)5U };
Item item276 = new Item(){ Index = (UInt32Value)6U };
Item item277 = new Item(){ Index = (UInt32Value)7U };
Item item278 = new Item(){ Index = (UInt32Value)8U };
Item item279 = new Item(){ Index = (UInt32Value)9U };
Item item280 = new Item(){ Index = (UInt32Value)10U };
Item item281 = new Item(){ Index = (UInt32Value)11U };
Item item282 = new Item(){ Index = (UInt32Value)12U };
Item item283 = new Item(){ Index = (UInt32Value)13U };
Item item284 = new Item(){ ItemType = ItemValues.Default };
items31.Append(item270);
items31.Append(item271);
items31.Append(item272);
items31.Append(item273);
items31.Append(item274);
items31.Append(item275);
items31.Append(item276);
items31.Append(item277);
items31.Append(item278);
items31.Append(item279);
items31.Append(item280);
items31.Append(item281);
items31.Append(item282);
items31.Append(item283);
items31.Append(item284);
pivotField56.Append(items31);
PivotField pivotField57 = new PivotField(){ Axis = PivotTableAxisValues.AxisRow, ShowAll = false };
Items items32 = new Items(){ Count = (UInt32Value)11U };
Item item285 = new Item(){ Index = (UInt32Value)0U };
Item item286 = new Item(){ Missing = true, Index = (UInt32Value)4U };
Item item287 = new Item(){ Missing = true, Index = (UInt32Value)3U };
Item item288 = new Item(){ Index = (UInt32Value)1U };
Item item289 = new Item(){ Index = (UInt32Value)2U };
Item item290 = new Item(){ Missing = true, Index = (UInt32Value)9U };
Item item291 = new Item(){ Missing = true, Index = (UInt32Value)8U };
Item item292 = new Item(){ Missing = true, Index = (UInt32Value)7U };
Item item293 = new Item(){ Missing = true, Index = (UInt32Value)6U };
Item item294 = new Item(){ Missing = true, Index = (UInt32Value)5U };
Item item295 = new Item(){ ItemType = ItemValues.Default };
items32.Append(item285);
items32.Append(item286);
items32.Append(item287);
items32.Append(item288);
items32.Append(item289);
items32.Append(item290);
items32.Append(item291);
items32.Append(item292);
items32.Append(item293);
items32.Append(item294);
items32.Append(item295);
pivotField57.Append(items32);
PivotField pivotField58 = new PivotField(){ DataField = true, ShowAll = false };
PivotField pivotField59 = new PivotField(){ ShowAll = false };
PivotField pivotField60 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };
Items items33 = new Items(){ Count = (UInt32Value)5U };
Item item296 = new Item(){ Index = (UInt32Value)0U };
Item item297 = new Item(){ Index = (UInt32Value)1U };
Item item298 = new Item(){ Index = (UInt32Value)3U };
Item item299 = new Item(){ Index = (UInt32Value)2U };
Item item300 = new Item(){ ItemType = ItemValues.Default };
items33.Append(item296);
items33.Append(item297);
items33.Append(item298);
items33.Append(item299);
items33.Append(item300);
pivotField60.Append(items33);
PivotField pivotField61 = new PivotField(){ ShowAll = false };
PivotField pivotField62 = new PivotField(){ ShowAll = false, DefaultSubtotal = false };
Items items34 = new Items(){ Count = (UInt32Value)5U };
Item item301 = new Item(){ Index = (UInt32Value)0U };
Item item302 = new Item(){ Index = (UInt32Value)1U };
Item item303 = new Item(){ Index = (UInt32Value)2U };
Item item304 = new Item(){ Index = (UInt32Value)3U };
Item item305 = new Item(){ Index = (UInt32Value)4U };
items34.Append(item301);
items34.Append(item302);
items34.Append(item303);
items34.Append(item304);
items34.Append(item305);
pivotField62.Append(items34);
pivotFields9.Append(pivotField56);
pivotFields9.Append(pivotField57);
pivotFields9.Append(pivotField58);
pivotFields9.Append(pivotField59);
pivotFields9.Append(pivotField60);
pivotFields9.Append(pivotField61);
pivotFields9.Append(pivotField62);
RowFields rowFields9 = new RowFields(){ Count = (UInt32Value)1U };
Field field9 = new Field(){ Index = 1 };
rowFields9.Append(field9);
RowItems rowItems9 = new RowItems(){ Count = (UInt32Value)4U };
RowItem rowItem41 = new RowItem();
MemberPropertyIndex memberPropertyIndex33 = new MemberPropertyIndex();
rowItem41.Append(memberPropertyIndex33);
RowItem rowItem42 = new RowItem();
MemberPropertyIndex memberPropertyIndex34 = new MemberPropertyIndex(){ Val = 3 };
rowItem42.Append(memberPropertyIndex34);
RowItem rowItem43 = new RowItem();
MemberPropertyIndex memberPropertyIndex35 = new MemberPropertyIndex(){ Val = 4 };
rowItem43.Append(memberPropertyIndex35);
RowItem rowItem44 = new RowItem(){ ItemType = ItemValues.Grand };
MemberPropertyIndex memberPropertyIndex36 = new MemberPropertyIndex();
rowItem44.Append(memberPropertyIndex36);
rowItems9.Append(rowItem41);
rowItems9.Append(rowItem42);
rowItems9.Append(rowItem43);
rowItems9.Append(rowItem44);
ColumnItems columnItems9 = new ColumnItems(){ Count = (UInt32Value)1U };
RowItem rowItem45 = new RowItem();
columnItems9.Append(rowItem45);
DataFields dataFields9 = new DataFields(){ Count = (UInt32Value)1U };
DataField dataField9 = new DataField(){ Name = "Sum of Quantity", Field = (UInt32Value)2U, BaseField = 0, BaseItem = (UInt32Value)0U };
dataFields9.Append(dataField9);
ChartFormats chartFormats9 = new ChartFormats(){ Count = (UInt32Value)13U };
ChartFormat chartFormat70 = new ChartFormat(){ Chart = (UInt32Value)4U, Format = (UInt32Value)0U, Series = true };
PivotArea pivotArea70 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences70 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference70 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem92 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference70.Append(fieldItem92);
pivotAreaReferences70.Append(pivotAreaReference70);
pivotArea70.Append(pivotAreaReferences70);
chartFormat70.Append(pivotArea70);
ChartFormat chartFormat71 = new ChartFormat(){ Chart = (UInt32Value)5U, Format = (UInt32Value)2U, Series = true };
PivotArea pivotArea71 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences71 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference71 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem93 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference71.Append(fieldItem93);
pivotAreaReferences71.Append(pivotAreaReference71);
pivotArea71.Append(pivotAreaReferences71);
chartFormat71.Append(pivotArea71);
ChartFormat chartFormat72 = new ChartFormat(){ Chart = (UInt32Value)6U, Format = (UInt32Value)0U, Series = true };
PivotArea pivotArea72 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences72 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference72 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem94 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference72.Append(fieldItem94);
pivotAreaReferences72.Append(pivotAreaReference72);
pivotArea72.Append(pivotAreaReferences72);
chartFormat72.Append(pivotArea72);
ChartFormat chartFormat73 = new ChartFormat(){ Chart = (UInt32Value)7U, Format = (UInt32Value)14U, Series = true };
PivotArea pivotArea73 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences73 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference73 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem95 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference73.Append(fieldItem95);
pivotAreaReferences73.Append(pivotAreaReference73);
pivotArea73.Append(pivotAreaReferences73);
chartFormat73.Append(pivotArea73);
ChartFormat chartFormat74 = new ChartFormat(){ Chart = (UInt32Value)8U, Format = (UInt32Value)1U, Series = true };
PivotArea pivotArea74 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences74 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference74 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem96 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference74.Append(fieldItem96);
pivotAreaReferences74.Append(pivotAreaReference74);
pivotArea74.Append(pivotAreaReferences74);
chartFormat74.Append(pivotArea74);
ChartFormat chartFormat75 = new ChartFormat(){ Chart = (UInt32Value)9U, Format = (UInt32Value)15U, Series = true };
PivotArea pivotArea75 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences75 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference75 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem97 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference75.Append(fieldItem97);
pivotAreaReferences75.Append(pivotAreaReference75);
pivotArea75.Append(pivotAreaReferences75);
chartFormat75.Append(pivotArea75);
ChartFormat chartFormat76 = new ChartFormat(){ Chart = (UInt32Value)10U, Format = (UInt32Value)2U, Series = true };
PivotArea pivotArea76 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences76 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference76 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem98 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference76.Append(fieldItem98);
pivotAreaReferences76.Append(pivotAreaReference76);
pivotArea76.Append(pivotAreaReferences76);
chartFormat76.Append(pivotArea76);
ChartFormat chartFormat77 = new ChartFormat(){ Chart = (UInt32Value)11U, Format = (UInt32Value)16U, Series = true };
PivotArea pivotArea77 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences77 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference77 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem99 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference77.Append(fieldItem99);
pivotAreaReferences77.Append(pivotAreaReference77);
pivotArea77.Append(pivotAreaReferences77);
chartFormat77.Append(pivotArea77);
ChartFormat chartFormat78 = new ChartFormat(){ Chart = (UInt32Value)12U, Format = (UInt32Value)3U, Series = true };
PivotArea pivotArea78 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences78 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference78 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem100 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference78.Append(fieldItem100);
pivotAreaReferences78.Append(pivotAreaReference78);
pivotArea78.Append(pivotAreaReferences78);
chartFormat78.Append(pivotArea78);
ChartFormat chartFormat79 = new ChartFormat(){ Chart = (UInt32Value)13U, Format = (UInt32Value)17U, Series = true };
PivotArea pivotArea79 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences79 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference79 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem101 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference79.Append(fieldItem101);
pivotAreaReferences79.Append(pivotAreaReference79);
pivotArea79.Append(pivotAreaReferences79);
chartFormat79.Append(pivotArea79);
ChartFormat chartFormat80 = new ChartFormat(){ Chart = (UInt32Value)14U, Format = (UInt32Value)4U, Series = true };
PivotArea pivotArea80 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences80 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference80 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem102 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference80.Append(fieldItem102);
pivotAreaReferences80.Append(pivotAreaReference80);
pivotArea80.Append(pivotAreaReferences80);
chartFormat80.Append(pivotArea80);
ChartFormat chartFormat81 = new ChartFormat(){ Chart = (UInt32Value)15U, Format = (UInt32Value)18U, Series = true };
PivotArea pivotArea81 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences81 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference81 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem103 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference81.Append(fieldItem103);
pivotAreaReferences81.Append(pivotAreaReference81);
pivotArea81.Append(pivotAreaReferences81);
chartFormat81.Append(pivotArea81);
ChartFormat chartFormat82 = new ChartFormat(){ Chart = (UInt32Value)16U, Format = (UInt32Value)5U, Series = true };
PivotArea pivotArea82 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences82 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference82 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem104 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference82.Append(fieldItem104);
pivotAreaReferences82.Append(pivotAreaReference82);
pivotArea82.Append(pivotAreaReferences82);
chartFormat82.Append(pivotArea82);
chartFormats9.Append(chartFormat70);
chartFormats9.Append(chartFormat71);
chartFormats9.Append(chartFormat72);
chartFormats9.Append(chartFormat73);
chartFormats9.Append(chartFormat74);
chartFormats9.Append(chartFormat75);
chartFormats9.Append(chartFormat76);
chartFormats9.Append(chartFormat77);
chartFormats9.Append(chartFormat78);
chartFormats9.Append(chartFormat79);
chartFormats9.Append(chartFormat80);
chartFormats9.Append(chartFormat81);
chartFormats9.Append(chartFormat82);
PivotTableStyle pivotTableStyle9 = new PivotTableStyle(){ Name = "PivotStyleLight16", ShowRowHeaders = true, ShowColumnHeaders = true, ShowRowStripes = false, ShowColumnStripes = false, ShowLastColumn = true };
PivotFilters pivotFilters1 = new PivotFilters(){ Count = (UInt32Value)1U };
PivotFilter pivotFilter1 = new PivotFilter(){ Field = (UInt32Value)4U, Type = PivotFilterValues.DateBetween, EvaluationOrder = -1, Id = (UInt32Value)6U, Name = "DeliveryDate" };
AutoFilter autoFilter7 = new AutoFilter(){ Reference = "A1" };
FilterColumn filterColumn1 = new FilterColumn(){ ColumnId = (UInt32Value)0U };
CustomFilters customFilters1 = new CustomFilters(){ And = true };
CustomFilter customFilter1 = new CustomFilter(){ Operator = FilterOperatorValues.GreaterThanOrEqual, Val = "36526" };
CustomFilter customFilter2 = new CustomFilter(){ Operator = FilterOperatorValues.LessThanOrEqual, Val = "37986" };
customFilters1.Append(customFilter1);
customFilters1.Append(customFilter2);
filterColumn1.Append(customFilters1);
autoFilter7.Append(filterColumn1);
PivotFilterExtensionList pivotFilterExtensionList1 = new PivotFilterExtensionList();
PivotFilterExtension pivotFilterExtension1 = new PivotFilterExtension(){ Uri = "{0605FD5F-26C8-4aeb-8148-2DB25E43C511}" };
pivotFilterExtension1.AddNamespaceDeclaration("x15", "http://schemas.microsoft.com/office/spreadsheetml/2010/11/main");
X15.PivotFilter pivotFilter2 = new X15.PivotFilter(){ UseWholeDay = true };
pivotFilterExtension1.Append(pivotFilter2);
pivotFilterExtensionList1.Append(pivotFilterExtension1);
pivotFilter1.Append(autoFilter7);
pivotFilter1.Append(pivotFilterExtensionList1);
pivotFilters1.Append(pivotFilter1);
PivotTableDefinitionExtensionList pivotTableDefinitionExtensionList9 = new PivotTableDefinitionExtensionList();
PivotTableDefinitionExtension pivotTableDefinitionExtension9 = new PivotTableDefinitionExtension(){ Uri = "{962EF5D1-5CA2-4c93-8EF4-DBF5C05439D2}" };
pivotTableDefinitionExtension9.AddNamespaceDeclaration("x14", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main");
X14.PivotTableDefinition pivotTableDefinition18 = new X14.PivotTableDefinition(){ HideValuesRow = true };
pivotTableDefinition18.AddNamespaceDeclaration("xm", "http://schemas.microsoft.com/office/excel/2006/main");
pivotTableDefinitionExtension9.Append(pivotTableDefinition18);
pivotTableDefinitionExtensionList9.Append(pivotTableDefinitionExtension9);
pivotTableDefinition17.Append(location9);
pivotTableDefinition17.Append(pivotFields9);
pivotTableDefinition17.Append(rowFields9);
pivotTableDefinition17.Append(rowItems9);
pivotTableDefinition17.Append(columnItems9);
pivotTableDefinition17.Append(dataFields9);
pivotTableDefinition17.Append(chartFormats9);
pivotTableDefinition17.Append(pivotTableStyle9);
pivotTableDefinition17.Append(pivotFilters1);
pivotTableDefinition17.Append(pivotTableDefinitionExtensionList9);
pivotTablePart9.PivotTableDefinition = pivotTableDefinition17;
}
internal FilterColumn ToFilterColumn()
{
FilterColumn fc = new FilterColumn();
if (HasFilters) fc.Filters = this.Filters.ToFilters();
if (HasTop10) fc.Top10 = this.Top10.ToTop10();
if (HasCustomFilters) fc.CustomFilters = this.CustomFilters.ToCustomFilters();
if (HasDynamicFilter) fc.DynamicFilter = this.DynamicFilter.ToDynamicFilter();
if (HasColorFilter) fc.ColorFilter = this.ColorFilter.ToColorFilter();
if (HasIconFilter) fc.IconFilter = this.IconFilter.ToIconFilter();
fc.ColumnId = this.ColumnId;
if (this.HiddenButton != null && this.HiddenButton.Value) fc.HiddenButton = this.HiddenButton.Value;
if (this.ShowButton != null && !this.ShowButton.Value) fc.ShowButton = this.ShowButton.Value;
return fc;
}
private static void PopulateAutoFilter(XLAutoFilter xlAutoFilter, AutoFilter autoFilter)
{
var filterRange = xlAutoFilter.Range;
autoFilter.Reference = filterRange.RangeAddress.ToString();
foreach (var kp in xlAutoFilter.Filters)
{
var filterColumn = new FilterColumn {ColumnId = (UInt32)kp.Key - 1};
var xlFilterColumn = xlAutoFilter.Column(kp.Key);
var filterType = xlFilterColumn.FilterType;
if (filterType == XLFilterType.Custom)
{
var customFilters = new CustomFilters();
foreach (var filter in kp.Value)
{
var customFilter = new CustomFilter {Val = filter.Value.ToString()};
if (filter.Operator != XLFilterOperator.Equal)
customFilter.Operator = filter.Operator.ToOpenXml();
if (filter.Connector == XLConnector.And)
customFilters.And = true;
customFilters.Append(customFilter);
}
filterColumn.Append(customFilters);
}
else if (filterType == XLFilterType.TopBottom)
{
var top101 = new Top10 {Val = (double)xlFilterColumn.TopBottomValue};
if (xlFilterColumn.TopBottomType == XLTopBottomType.Percent)
top101.Percent = true;
if (xlFilterColumn.TopBottomPart == XLTopBottomPart.Bottom)
top101.Top = false;
filterColumn.Append(top101);
}
else if (filterType == XLFilterType.Dynamic)
{
var dynamicFilter = new DynamicFilter
{Type = xlFilterColumn.DynamicType.ToOpenXml(), Val = xlFilterColumn.DynamicValue};
filterColumn.Append(dynamicFilter);
}
else
{
var filters = new Filters();
foreach (var filter in kp.Value)
{
filters.Append(new Filter {Val = filter.Value.ToString()});
}
filterColumn.Append(filters);
}
autoFilter.Append(filterColumn);
}
if (xlAutoFilter.Sorted)
{
var sortState = new SortState
{
Reference =
filterRange.Range(filterRange.FirstCell().CellBelow(), filterRange.LastCell()).RangeAddress.
ToString()
};
var sortCondition = new SortCondition
{
Reference =
filterRange.Range(1, xlAutoFilter.SortColumn, filterRange.RowCount(),
xlAutoFilter.SortColumn).RangeAddress.ToString()
};
if (xlAutoFilter.SortOrder == XLSortOrder.Descending)
sortCondition.Descending = true;
sortState.Append(sortCondition);
autoFilter.Append(sortState);
}
}
protected override Form CreateFilterBuilderDialog(FilterColumnCollection filterColumns, FilterColumn defaultFilterColumn){
return this.CreateFilterBuilderDialogEx(filterColumns,defaultFilterColumn,_gridListEditor.Model.GetFullTextMembers());
}
private static bool IsColumnAddedByUser(FilterColumn col)
{
PropertyDescriptor descriptor = TypeDescriptor.GetProperties(col)["UserAddedColumn"];
return ((descriptor != null) && ((bool)descriptor.GetValue(col)));
}
public void SetUp()
{
theColumn = new FilterColumn<Case>(c => c.Condition);
}
void InitFilter()
{
List<FilterColumn> columns = new List<FilterColumn>();
GridColumn column = gridMain.Columns["FPurpose"];
FilterColumn newColumn = new FilterColumn()
{
FieldName = column.FieldName,
ColumnCaption = column.Header,
ColumnType = typeof(string)
};
columns.Add(newColumn);
column = gridMain.Columns["FCreateCompany"];
newColumn = new FilterColumn()
{
FieldName = column.FieldName,
ColumnCaption = column.Header,
ColumnType = typeof(string)
};
columns.Add(newColumn);
column = gridMain.Columns["FPassportNo"];
newColumn = new FilterColumn()
{
FieldName = column.FieldName,
ColumnCaption = column.Header,
ColumnType = typeof(string)
};
columns.Add(newColumn);
columns.Add(newColumn);
column = gridMain.Columns["FName"];
newColumn = new FilterColumn()
{
FieldName = column.FieldName,
ColumnCaption = column.Header,
ColumnType = typeof(string)
};
columns.Add(newColumn);
column = gridMain.Columns["FQZID"];
newColumn = new FilterColumn()
{
FieldName = column.FieldName,
ColumnCaption = column.Header,
ColumnType = typeof(string)
};
columns.Add(newColumn);
column = gridMain.Columns["FAutoID"];
newColumn = new FilterColumn()
{
FieldName = column.FieldName,
ColumnCaption = column.Header,
ColumnType = typeof(string)
};
columns.Add(newColumn);
column = gridMain.Columns["FYNCom"];
newColumn = new FilterColumn()
{
FieldName = column.FieldName,
ColumnCaption = column.Header,
ColumnType = typeof(string)
};
columns.Add(newColumn);
filter.FilterColumns = columns;
this.gridMain.FilterString = "[FPurpose] = ? and [FCreateCompany] = ? and [FPassportNo] = ? and [FQZID] = ? and [FName] = ? and [FAutoID] = ? and [FYNCom] = ?";
dateFrom.EditValue = DateTime.Today.AddDays(-7);
dateTo.EditValue = DateTime.Today;
//gridMain.FilterCriteria = new BinaryOperator("FPassportNo","E",BinaryOperatorType.Like);
//gridMain.FilterCriteria += new BinaryOperator("FName", "", BinaryOperatorType.Like);
}
void InitFilter()
{
List<FilterColumn> columns = new List<FilterColumn>();
GridColumn column = gridMain.Columns["FPassportNo"];
FilterColumn newColumn = new FilterColumn()
{
FieldName = column.FieldName,
ColumnCaption = column.Header,
ColumnType = typeof(string)
};
columns.Add(newColumn);
column = gridMain.Columns["FAutoID"];
newColumn = new FilterColumn()
{
FieldName = column.FieldName,
ColumnCaption = column.Header,
ColumnType = typeof(string)
};
columns.Add(newColumn);
filter.FilterColumns = columns;
this.gridMain.FilterString = "[FPassportNo] = ? and [FAutoID] = ? ";
dateFrom.EditValue = DateTime.Today.AddDays(-7);
dateTo.EditValue = DateTime.Today;
}
private void CommitChanges()
{
if (this.formIsDirty)
{
try
{
IComponentChangeService service = (IComponentChangeService)this.liveFilterControl.Site.GetService(iComponentChangeServiceType);
PropertyDescriptor member = TypeDescriptor.GetProperties(this.liveFilterControl)["Columns"];
IContainer container = (this.liveFilterControl.Site != null) ? this.liveFilterControl.Site.Container : null;
FilterColumn[] array = new FilterColumn[this.liveFilterControl.Columns.Count];
this.liveFilterControl.Columns.CopyTo(array, 0);
service.OnComponentChanging(this.liveFilterControl, member);
this.liveFilterControl.Columns.Clear();
service.OnComponentChanged(this.liveFilterControl, member, null, null);
if (container != null)
{
for (int m = 0; m < array.Length; m++)
{
container.Remove(array[m]);
}
}
FilterColumn[] columnArray2 = new FilterColumn[this.columnsPrivateCopy.Count];
bool[] flagArray = new bool[this.columnsPrivateCopy.Count];
string[] strArray = new string[this.columnsPrivateCopy.Count];
for (int i = 0; i < this.columnsPrivateCopy.Count; i++)
{
FilterColumn column = (FilterColumn)this.columnsPrivateCopy[i].Clone();
//column.ContextMenuStrip = this.columnsPrivateCopy[i].ContextMenuStrip;
columnArray2[i] = column;
flagArray[i] = (bool)this.userAddedColumns[this.columnsPrivateCopy[i]];
strArray[i] = (string)this.columnsNames[this.columnsPrivateCopy[i]];
}
if (container != null)
{
for (int n = 0; n < columnArray2.Length; n++)
{
if (strArray[n].IsNotEmpty() && ValidateName(container, strArray[n], columnArray2[n]))
{
container.Add(columnArray2[n], strArray[n]);
}
else
{
container.Add(columnArray2[n]);
}
}
}
service.OnComponentChanging(this.liveFilterControl, member);
for (int j = 0; j < columnArray2.Length; j++)
{
PropertyDescriptor descriptor2 = TypeDescriptor.GetProperties(columnArray2[j])["DisplayIndex"];
if (descriptor2 != null)
{
descriptor2.SetValue(columnArray2[j], -1);
}
this.liveFilterControl.Columns.Add(columnArray2[j]);
}
service.OnComponentChanged(this.liveFilterControl, member, null, null);
for (int k = 0; k < flagArray.Length; k++)
{
PropertyDescriptor descriptor3 = TypeDescriptor.GetProperties(columnArray2[k])["UserAddedColumn"];
if (descriptor3 != null)
{
descriptor3.SetValue(columnArray2[k], flagArray[k]);
}
}
}
catch (InvalidOperationException exception)
{
IUIService uiService = (IUIService)this.liveFilterControl.Site.GetService(typeof(IUIService));
FilterControlDesigner.ShowErrorDialog(uiService, exception, this.liveFilterControl);
base.DialogResult = DialogResult.Cancel;
}
}
}
private void FilterAddColumnDialog_Closed(object sender, EventArgs e)
{
if (this.persistChangesToDesigner)
{
try
{
IComponentChangeService service = (IComponentChangeService)this.liveFilterControl.Site.GetService(iComponentChangeServiceType);
if (service == null)
{
return;
}
FilterColumn[] columns = new FilterColumn[this.liveFilterControl.Columns.Count - this.initialFilterColumnsCount];
for (int i = this.initialFilterColumnsCount; i < this.liveFilterControl.Columns.Count; i++)
{
columns[i - this.initialFilterColumnsCount] = this.liveFilterControl.Columns[i];
}
int initialFilterColumnsCount = this.initialFilterColumnsCount;
while (initialFilterColumnsCount < this.liveFilterControl.Columns.Count)
{
this.liveFilterControl.Columns.RemoveAt(this.initialFilterColumnsCount);
}
PropertyDescriptor member = TypeDescriptor.GetProperties(this.liveFilterControl)["Columns"];
service.OnComponentChanging(this.liveFilterControl, member);
this.liveFilterControl.Columns.AddRange(columns);
service.OnComponentChanged(this.liveFilterControl, member, null, null);
}
catch (InvalidOperationException exc)
{
MessageBox.Show(exc.ToString());
}
}
base.DialogResult = DialogResult.OK;
}
public XpandFilterBuilder(FilterColumnCollection columns, IDXMenuManager manager, UserLookAndFeel lookAndFeel, DevExpress.XtraGrid.Views.Base.ColumnView view, FilterColumn fColumn, IEnumerable<IModelMember> modelMembers): base(columns, manager, lookAndFeel, view, fColumn){
_modelMembers = modelMembers;
}
public ListBoxItem(FilterColumn column, FilterColumnCollectionDialog owner, ComponentDesigner compDesigner)
{
this.column = column;
this.owner = owner;
this.compDesigner = compDesigner;
if (this.compDesigner != null)
{
this.compDesigner.Initialize(column);
TypeDescriptor.CreateAssociation(this.column, this.compDesigner);
}
ToolboxBitmapAttribute attribute = TypeDescriptor.GetAttributes(column)[FilterColumnCollectionDialog.toolboxBitmapAttributeType] as ToolboxBitmapAttribute;
if (attribute != null)
{
this.toolboxBitmap = attribute.GetImage(column, false);
}
else
{
this.toolboxBitmap = this.owner.SelectedColumnsItemBitmap;
}
FilterColumnDesigner designer = compDesigner as FilterColumnDesigner;
if (designer != null)
{
designer.LiveFilterControl = this.owner.liveFilterControl;
}
}
private static void CopyFilterColumnProperties(FilterColumn srcColumn, FilterColumn destColumn)
{
destColumn.DataPropertyName = srcColumn.DataPropertyName;
destColumn.HeaderText = srcColumn.HeaderText;
destColumn.Name = srcColumn.Name;
destColumn.Tag = srcColumn.Tag;
destColumn.ToolTipText = srcColumn.ToolTipText;
destColumn.Width = srcColumn.Width;
destColumn.Visible = srcColumn.Visible;
}
