public Query Where(Where where, bool clearWhereList) { if (_ListWhere == null) _ListWhere = new WhereList(); if (clearWhereList) _ListWhere.Clear(); _ListWhere.Add(where); return this; }
public Query AddWhere(Where where) { return Where(where, false); }
public Query OR(string columnName, object betweenValue, object andValue) { Where where = new Where(WhereCondition.OR, columnName, ValueObjectType.ColumnName, betweenValue, ValueObjectType.Value, andValue, ValueObjectType.Value); return Where(where, false); }
public static Round Round(Where where) { return new Round(where); }
public Query AND(string tableName, string columnName, object betweenValue, object andValue) { Where where = new Where(WhereCondition.AND, columnName, ValueObjectType.ColumnName, betweenValue, ValueObjectType.Value, andValue, ValueObjectType.Value); where.FirstTableName = tableName; return Where(where, false); }
public static JsonExtract JsonExtract(Where where, string path = "$") { return new JsonExtract(where, path); }
public static RandWeight RandWeight(Where where) { return new RandWeight(where); }
public Query Having(WhereCondition condition, string tableName, string columnName, object betweenValue, object andValue) { Where where = new Where(condition, columnName, ValueObjectType.ColumnName, betweenValue, ValueObjectType.Value, andValue, ValueObjectType.Value); where.FirstTableName = tableName; return Having(where); }
public Query Having(Where where) { if (_ListHaving == null) _ListHaving = new WhereList(); _ListHaving.Add(where); return this; }
public static ValueWrapper From(Where where) { return new ValueWrapper(where); }
public ValueWrapper(Where where) { this.TableName = null; this.Value = where; this.Type = ValueObjectType.Value; }
/// <summary> /// Adds a where condition. Does not remove any existing conditions. /// </summary> /// <param name="where"></param> /// <returns>Current <typeparamref name="Query"/> object</returns> public Query Where(Where where) { if (_ListWhere == null) _ListWhere = new WhereList(); _ListWhere.Add(where); return this; }