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)); }