/// <summary> /// Devuelve una instancia de <see cref="DataFilter"/>. /// </summary> public DataFilter(string name, OleDbType type, string value, FilterComparator comparationType) { Name = name; Type = type; Value = value; ComparationType = comparationType; }
internal bool Compare(FilterComparator attribute, string value) { bool result = default(bool); switch (attribute) { case FilterComparator.EVENT_TYPE: result = (this.eventInfo.Type == value); break; case FilterComparator.EVENT_MONITOR: result = (this.Monitor == value); break; case FilterComparator.EVENT_GCID: result = this.CID.Contains(value); break; } return(result); }
private void HandleFilter(CustomBindingList<string> sender, ListChangedEventArgs e, FilterComparator compareAttribute) { CSMEvent tag; switch (e.ListChangedType) { case ListChangedType.ItemAdded: foreach (TreeNode node in listFilterNode) { tag = (CSMEvent)node.Tag; if (tag.Compare(compareAttribute, sender[e.NewIndex])) { tag.filterSet |= (int)compareAttribute; } } for (int index = listNode.Count - 1; index >= 0; index--) { tag = (CSMEvent)listNode[index].Tag; if (tag.Compare(compareAttribute, sender[e.NewIndex])) { tag.filterSet |= (int)compareAttribute; listFilterNode.Add(listNode[index]); listNode.RemoveAt(index); } } break; case ListChangedType.ItemDeleted: for (int index = listFilterNode.Count - 1; index >= 0; index--) { tag = (CSMEvent)listFilterNode[index].Tag; if (tag.Compare(compareAttribute, sender.RemovedItem)) { tag.filterSet &= (int)(~compareAttribute); if (tag.filterSet == 0) { listNode.Add(listFilterNode[index]); listFilterNode.RemoveAt(index); } } } break; case ListChangedType.Reset: foreach (TreeNode item in listFilterNode) { listNode.Add(item); } listFilterNode.Clear(); break; default: break; } }
public void WhereSimpleFieldMatches(EpcisField field, FilterComparator filterOperator, object value) => _query = _query.Where($"{field.ToPgSql()} {filterOperator.ToSql()} {_parameters.Add(value)}");
public void WhereCustomFieldMatches(bool inner, FieldType type, string fieldNamespace, string fieldName, FilterComparator comparator, object value) => throw new NotImplementedException();
public void WhereEpcQuantityMatches(FilterComparator filterOperator, double value) => _query = _query.Where($"EXISTS(SELECT epc.event_id FROM epcis.epc epc WHERE epc.type = {EpcType.Quantity} AND epc.quantity {filterOperator.ToSql()} {_parameters.Add(value)} AND epc.event_id = event.id)");
public void WhereCustomFieldMatches(CustomField field, bool inner, FilterComparator comparator, object value) => throw new NotImplementedException();
internal bool Compare(FilterComparator attribute, string value) { bool result = default(bool); switch (attribute) { case FilterComparator.EVENT_TYPE: result = (this.eventInfo.Type == value); break; case FilterComparator.EVENT_MONITOR: result = (this.Monitor == value); break; case FilterComparator.EVENT_GCID: result = this.CID.Contains(value); break; } return result; }
private void HandleFilter(CustomBindingList <string> sender, ListChangedEventArgs e, FilterComparator compareAttribute) { CSMEvent tag; switch (e.ListChangedType) { case ListChangedType.ItemAdded: foreach (TreeNode node in listFilterNode) { tag = (CSMEvent)node.Tag; if (tag.Compare(compareAttribute, sender[e.NewIndex])) { tag.filterSet |= (int)compareAttribute; } } for (int index = listNode.Count - 1; index >= 0; index--) { tag = (CSMEvent)listNode[index].Tag; if (tag.Compare(compareAttribute, sender[e.NewIndex])) { tag.filterSet |= (int)compareAttribute; listFilterNode.Add(listNode[index]); listNode.RemoveAt(index); } } break; case ListChangedType.ItemDeleted: for (int index = listFilterNode.Count - 1; index >= 0; index--) { tag = (CSMEvent)listFilterNode[index].Tag; if (tag.Compare(compareAttribute, sender.RemovedItem)) { tag.filterSet &= (int)(~compareAttribute); if (tag.filterSet == 0) { listNode.Add(listFilterNode[index]); listFilterNode.RemoveAt(index); } } } break; case ListChangedType.Reset: foreach (TreeNode item in listFilterNode) { listNode.Add(item); } listFilterNode.Clear(); break; default: break; } }
public static string ToSql(this FilterComparator op) => GetValue(op, FilterOperators) ?? throw new Exception($"Unknown filterOperator: '{op?.DisplayName}'");