public static string ParseWildCard(string fieldValue, EWildCardType type, EWildCardFieldType fieldType) { string result = string.Empty; switch (fieldType) { case EWildCardFieldType.Bool: case EWildCardFieldType.DateTime: case EWildCardFieldType.Float: case EWildCardFieldType.Int: return(fieldValue); case EWildCardFieldType.String: switch (type) { case EWildCardType.After: result = String.Format("{0}%", fieldValue); break; case EWildCardType.Before: result = String.Format("%{0}", fieldValue); break; case EWildCardType.Both: result = String.Format("%{0}%", fieldValue); break; case EWildCardType.None: result = fieldValue; break; } break; } return(result); }
public WildCardDefinition(string fieldName, string wildCardType, EWildCardFieldType fieldType) { FieldName = fieldName; try { WildCardType = (EWildCardType)EnumFormatter.ToEnum(wildCardType, WildCardType.GetType()); } catch { throw new Exception("Unable to resolve WildCardType or improper type passed."); } WildCardFieldType = fieldType; }
public static string ParseOperator(EWildCardType type, EWildCardFieldType fieldType) { string result = string.Empty; switch (fieldType) { case EWildCardFieldType.Bool: case EWildCardFieldType.DateTime: case EWildCardFieldType.Float: case EWildCardFieldType.Int: switch (type) { case EWildCardType.After: result = " > "; break; case EWildCardType.Before: result = " < "; break; case EWildCardType.Both: result = " <> "; break; case EWildCardType.None: result = " = "; break; } break; case EWildCardFieldType.String: switch (type) { case EWildCardType.After: case EWildCardType.Before: case EWildCardType.Both: result = " LIKE "; break; case EWildCardType.None: result = " = "; break; } break; } return(result); }
public WildCardDefinition(string fieldname, EWildCardType type, EWildCardFieldType fieldType) { FieldName = fieldname; WildCardType = type; WildCardFieldType = fieldType; }