}//makeWhereClause() public string FilterModeToString(CswNbtSubField SubField, CswEnumNbtFilterMode FilterMode) { return(_CswNbtFieldTypeRuleDefault.FilterModeToString(SubField, FilterMode)); }
public CswNbtFieldTypeRuleLocation(CswNbtFieldResources CswNbtFieldResources) { _CswNbtFieldResources = CswNbtFieldResources; _CswNbtFieldTypeRuleDefault = new CswNbtFieldTypeRuleDefaultImpl(_CswNbtFieldResources); NameSubField = new CswNbtSubField(_CswNbtFieldResources, CswEnumNbtPropColumn.Field1, SubFieldName.Name); NameSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Begins); NameSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Contains); NameSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.NotContains); NameSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Ends); NameSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Equals); NameSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.NotEquals); NameSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.NotNull); NameSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Null); SubFields.add(NameSubField, true); NodeIdSubField = new CswNbtSubField(_CswNbtFieldResources, CswEnumNbtPropColumn.Field1_FK, SubFieldName.NodeID, true); NodeIdSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Equals); NodeIdSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.NotEquals); NodeIdSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.NotNull); NodeIdSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Null); NodeIdSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.In); SubFields.add(NodeIdSubField); RowSubField = new CswNbtSubField(_CswNbtFieldResources, CswEnumNbtPropColumn.Field2, SubFieldName.Row); RowSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Equals); RowSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.GreaterThan); RowSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.LessThan); RowSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.NotEquals); RowSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.NotNull); RowSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Null); SubFields.add(RowSubField); ColumnSubField = new CswNbtSubField(_CswNbtFieldResources, CswEnumNbtPropColumn.Field3, SubFieldName.Column); ColumnSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Equals); ColumnSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.GreaterThan); ColumnSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.LessThan); ColumnSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.NotEquals); ColumnSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.NotNull); ColumnSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Null); SubFields.add(ColumnSubField); PathSubField = new CswNbtSubField(_CswNbtFieldResources, CswEnumNbtPropColumn.Field4, SubFieldName.Path); PathSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Contains); PathSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.NotContains); PathSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.NotNull); PathSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Null); SubFields.add(PathSubField); BarcodeSubField = new CswNbtSubField(_CswNbtFieldResources, CswEnumNbtPropColumn.Field5, SubFieldName.Barcode); BarcodeSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Begins); BarcodeSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Contains); BarcodeSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.NotContains); BarcodeSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Ends); BarcodeSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Equals); BarcodeSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.GreaterThan); BarcodeSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.LessThan); BarcodeSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.NotEquals); BarcodeSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.NotNull); BarcodeSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Null); SubFields.add(BarcodeSubField); }//ctor
}//makeWhereClause() public string FilterModeToString(CswNbtSubField SubField, CswEnumNbtFilterMode FilterMode) { return(CswNbtFieldTypeRuleDateImpl.FilterModeToString(FilterMode)); }
public string GetPropRowValue(CswNbtSubField SubField) { return(GetPropRowValue(SubField.Column)); }
} // GetPropRowValue() public DateTime GetPropRowValueDate(CswNbtSubField SubField) { return(GetPropRowValueDate(SubField.Column)); }
protected string GetPropRowValue(CswNbtSubField SubField) { return(_CswNbtNodePropData.GetPropRowValue(SubField)); }
protected DateTime GetPropRowValueDate(CswNbtSubField SubField) { return(_CswNbtNodePropData.GetPropRowValueDate(SubField)); }
} // onBeforeUpdateNodePropRow() protected bool SetPropRowValue(CswNbtSubField SubField, object value, bool IsNonModifying = false) { return(_CswNbtNodePropData.SetPropRowValue(SubField, value, IsNonModifying)); }
// This is used by CswNbtNodeProp for unique value enforcement public void AddUniqueFilterToView(CswNbtView View, CswNbtViewProperty UniqueValueViewProperty, CswNbtNodePropWrapper PropertyValueToCheck, bool EnforceNullEntries = false, CswNbtSubField SubField = null) { if (SubField == null) { SubField = SubFields.Default; } string StringValueToCheck = PropertyValueToCheck.GetSubFieldValue(SubField); // case 31292 - Kludge fix for NodeID filters if (SubField.Name == CswEnumNbtSubFieldName.NodeID && false == string.IsNullOrEmpty(StringValueToCheck)) { CswPrimaryKey pkValue = new CswPrimaryKey(); pkValue.FromString(StringValueToCheck); StringValueToCheck = pkValue.PrimaryKey.ToString(); } CswEnumNbtFilterMode FilterMode; //case 27670 - in order to reserve the right for compound unique props to be empty, it has to be explicitly stated when creating the ForCompundUnique view if (EnforceNullEntries && String.IsNullOrEmpty(StringValueToCheck)) { FilterMode = CswEnumNbtFilterMode.Null; } else { FilterMode = CswEnumNbtFilterMode.Equals; } View.AddViewPropertyFilter(UniqueValueViewProperty, SubField.Name, FilterMode, StringValueToCheck.Trim(), false); }
}//makeWhereClause() public string FilterModeToString(CswNbtSubField SubField, CswEnumNbtFilterMode FilterMode) { // Default implementation return(FilterMode.ToString()); }
public CswNbtFieldTypeRuleQuestion(CswNbtFieldResources CswNbtFieldResources) { _CswNbtFieldResources = CswNbtFieldResources; _CswNbtFieldTypeRuleDefault = new CswNbtFieldTypeRuleDefaultImpl(_CswNbtFieldResources); //List AnswerSubField = new CswNbtSubField(_CswNbtFieldResources, CswEnumNbtPropColumn.Field1, SubFieldName.Answer, true); AnswerSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Equals); AnswerSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.NotEquals); AnswerSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.NotNull); AnswerSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Null); SubFields.add(AnswerSubField, true); //List CorrectiveActionSubField = new CswNbtSubField(_CswNbtFieldResources, CswEnumNbtPropColumn.Field2, SubFieldName.CorrectiveAction, true); CorrectiveActionSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Equals); CorrectiveActionSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.NotEquals); CorrectiveActionSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.NotNull); CorrectiveActionSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Null); SubFields.add(CorrectiveActionSubField); //Logical IsCompliantSubField = new CswNbtSubField(_CswNbtFieldResources, CswEnumNbtPropColumn.Field3, SubFieldName.IsCompliant, true); IsCompliantSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Equals); IsCompliantSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.NotEquals); IsCompliantSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.NotNull); IsCompliantSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Null); SubFields.add(IsCompliantSubField); //Memo CommentsSubField = new CswNbtSubField(_CswNbtFieldResources, CswEnumNbtPropColumn.ClobData, SubFieldName.Comments, true); CommentsSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Equals); CommentsSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Begins); CommentsSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Ends); CommentsSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Contains); CommentsSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.NotContains); CommentsSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.NotNull); CommentsSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Null); SubFields.add(CommentsSubField); //Date DateAnsweredSubField = new CswNbtSubField(_CswNbtFieldResources, CswEnumNbtPropColumn.Field1_Date, SubFieldName.DateAnswered, true); DateAnsweredSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Equals); DateAnsweredSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.GreaterThan); DateAnsweredSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.GreaterThanOrEquals); DateAnsweredSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.LessThan); DateAnsweredSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.LessThanOrEquals); DateAnsweredSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.NotEquals); DateAnsweredSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.NotNull); DateAnsweredSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Null); SubFields.add(DateAnsweredSubField); //Date DateCorrectedSubField = new CswNbtSubField(_CswNbtFieldResources, CswEnumNbtPropColumn.Field2_Date, SubFieldName.DateCorrected, true); DateCorrectedSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Equals); DateCorrectedSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.GreaterThan); DateCorrectedSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.GreaterThanOrEquals); DateCorrectedSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.LessThan); DateCorrectedSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.LessThanOrEquals); DateCorrectedSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.NotEquals); DateCorrectedSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.NotNull); DateCorrectedSubField.SupportedFilterModes.Add(CswEnumNbtFilterMode.Null); SubFields.add(DateCorrectedSubField); }//ctor
public string renderViewPropFilter(ICswNbtUser RunAsUser, CswNbtViewPropertyFilter CswNbtViewPropertyFilterIn, Dictionary <string, string> ParameterCollection, int FilterNumber) { string ReturnVal = string.Empty; CswNbtSubField CswNbtSubField = null; CswNbtSubField = SubFields[CswNbtViewPropertyFilterIn.SubfieldName]; if (!CswNbtSubField.SupportedFilterModes.Contains(CswNbtViewPropertyFilterIn.FilterMode)) { throw (new CswDniException("Filter mode " + CswNbtViewPropertyFilterIn.FilterMode.ToString() + " is not supported for sub field: " + CswNbtSubField.Name + "; view name is: " + CswNbtViewPropertyFilterIn.View.ViewName)); } // Are we using a Date filter? if (CswNbtSubField.Name == DateAnsweredSubField.Name || CswNbtSubField.Name == DateCorrectedSubField.Name) { ReturnVal = CswNbtFieldTypeRuleDateImpl.renderViewPropFilter(RunAsUser, _CswNbtFieldResources, CswNbtViewPropertyFilterIn, CswNbtSubField.Column); } else if (CswNbtSubField.Name == IsCompliantSubField.Name) { string ValueColumn = "jnp." + CswNbtSubField.Column.ToString(); if (CswNbtViewPropertyFilterIn.FilterMode == CswEnumNbtFilterMode.Equals) { if (CswNbtViewPropertyFilterIn.Value == "1" || CswNbtViewPropertyFilterIn.Value.ToLower() == "true") { ReturnVal = ValueColumn + " = '1' "; } else if (CswNbtViewPropertyFilterIn.Value == "0" || CswNbtViewPropertyFilterIn.Value.ToLower() == "false") { ReturnVal = ValueColumn + " = '0' "; } else { ReturnVal = ValueColumn + " is null"; } } else if (CswNbtViewPropertyFilterIn.FilterMode == CswEnumNbtFilterMode.NotEquals) { if (CswNbtViewPropertyFilterIn.Value == "1" || CswNbtViewPropertyFilterIn.Value.ToLower() == "true") { ReturnVal = "(" + ValueColumn + " = '0' or " + ValueColumn + " is null) "; } else if (CswNbtViewPropertyFilterIn.Value == "0" || CswNbtViewPropertyFilterIn.Value.ToLower() == "false") { ReturnVal = "(" + ValueColumn + " = '1' or " + ValueColumn + " is null) "; } else { ReturnVal = "(" + ValueColumn + " = '1' or " + ValueColumn + " = '0') "; } } else { throw new CswDniException(CswEnumErrorType.Error, "Invalid filter", "An invalid FilterMode was encountered in CswNbtFieldTypeRuleQuestion.renderViewPropFilter()"); } } else { ReturnVal = (_CswNbtFieldTypeRuleDefault.renderViewPropFilter(RunAsUser, CswNbtViewPropertyFilterIn, ParameterCollection, FilterNumber)); } return(ReturnVal); }//renderViewPropFilter()