// append a searchcondition to a sql string
public static void Append(StringBuilder sql, string condition, MatchRule mr)
{
if (sql.Length > 0)
sql.AppendFormat(" {0} ", mr.GetSqlLogicalOperator());
sql.Append('(').Append(condition).Append(')');
}
public FreeTextSearchCriteria(string searchString, IFreeTextSearchField fields, TextCompareOperator compareOperator, MatchRule fieldMatchRule)
{
if (searchString == null)
throw new ArgumentNullException("searchString");
if (searchString.Length < VolumeDatabase.MIN_SEARCHSTR_LENGTH)
throw new ArgumentException(string.Format("Length of a searchstring must be at least {0}",
VolumeDatabase.MIN_SEARCHSTR_LENGTH), "searchString");
// if (fields == FreeTextSearchField.None)
if (fields == null || fields.IsEmpty)
throw new ArgumentException("No searchfield specified", "fields");
this.searchString = searchString.Replace("'","''");
this.fields = fields;
this.compareOperator = compareOperator;
this.fieldMatchRule = fieldMatchRule;
}
public SearchCriteriaGroup(MatchRule membersMatchRule)
{
this.membersMatchRule = membersMatchRule;
this.memberCriteria = new List <ISearchCriteria>();
this.searchCriteriaType = SearchCriteriaType.None;
}
public FreeTextSearchCriteria(string searchString, IFreeTextSearchField fields, TextCompareOperator compareOperator, MatchRule fieldMatchRule)
{
if (searchString == null)
{
throw new ArgumentNullException("searchString");
}
if (searchString.Length < VolumeDatabase.MIN_SEARCHSTR_LENGTH)
{
throw new ArgumentException(string.Format("Length of a searchstring must be at least {0}",
VolumeDatabase.MIN_SEARCHSTR_LENGTH), "searchString");
}
// if (fields == FreeTextSearchField.None)
if (fields == null || fields.IsEmpty)
{
throw new ArgumentException("No searchfield specified", "fields");
}
this.searchString = searchString.Replace("'", "''");
this.fields = fields;
this.compareOperator = compareOperator;
this.fieldMatchRule = fieldMatchRule;
}