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; }