public static string GetFilterQuery(this Condition condition, OperatorCombine operatorCombine = OperatorCombine.WithWhere)
{
if (condition == null || string.IsNullOrEmpty(condition.ToString()))
{
return(null);
}
string filterQuery = condition.ToString();
switch (operatorCombine)
{
case OperatorCombine.WithNone:
break;
case OperatorCombine.WithWhere:
filterQuery = filterQuery.Insert(0, " WHERE ");
break;
case OperatorCombine.WithAnd:
filterQuery = filterQuery.Insert(0, " AND ");
break;
case OperatorCombine.WithOr:
filterQuery = filterQuery.Insert(0, " OR ");
break;
case OperatorCombine.WithAndBrackets:
filterQuery = filterQuery.Insert(0, " AND (");
filterQuery += ")";
break;
case OperatorCombine.WithOrBrackets:
filterQuery = filterQuery.Insert(0, " OR (");
filterQuery += ")";
break;
}
return(filterQuery);
}
public static string GetFilterQuery <TEntity>(this Condition condition, out IList <SqlParameter> sqlParameters, OperatorCombine operatorCombine = OperatorCombine.WithWhere, bool removeConditions = true, bool convertToValueType = true, params string[] columns)
{
if (removeConditions)
{
condition = condition.RemoveConditions <TEntity>(columns);
}
else if (columns?.Length > 0)
{
condition = condition.RemoveConditions(columns);
}
if (convertToValueType)
{
condition = condition.ConvertToValueType <TEntity>();
}
sqlParameters = condition.GetSqlParameters();
return(condition.GetFilterQuery(operatorCombine));
}
public static string GetFilterQuery(this Condition condition, out IList <SqlParameter> sqlParameters, OperatorCombine operatorCombine = OperatorCombine.WithWhere, params string[] columns)
{
condition = condition.RemoveConditions(columns);
sqlParameters = condition.GetSqlParameters();
return(condition.GetFilterQuery(operatorCombine));
}
public static string GetFilterQuery(this Condition condition, out IDictionary <string, object> dictionaries, OperatorCombine operatorCombine = OperatorCombine.WithWhere, params string[] columns)
{
condition = condition.RemoveConditions(columns);
dictionaries = condition.GetDictionaries();
return(condition.GetFilterQuery(operatorCombine));
}
public static string GetFilterQuery <TEntity>(this Condition condition, out IDictionary <string, object> dictionaries, OperatorCombine operatorCombine = OperatorCombine.WithWhere, bool removeConditions = true, bool convertToValueType = true, params string[] columns)
{
if (removeConditions)
{
condition = condition.RemoveConditions <TEntity>(columns);
}
else if (columns?.Length > 0)
{
condition = condition.RemoveConditions(columns);
}
if (convertToValueType)
{
condition = condition.ConvertToValueType <TEntity>();
}
dictionaries = condition.GetDictionaries();
return(condition.GetFilterQuery(operatorCombine));
}
