public QueryCondition(string field, ConditionEquality equality, object value)
: this()
{
this.field = field;
this.equality = equality;
this.value = value;
}
public QueryCondition(ConditionRelations relation, string field, ConditionEquality equality, object value)
: this()
{
this.relation = relation;
this.field = field;
this.equality = equality;
this.value = value;
}
public QueryCondition AddCondition(ConditionRelations relation, string field, ConditionEquality equality, object value)
{
if (conditions.Count == 0)
{
return conditions.AddCondition(ConditionRelations.First, field, equality, value);
}
else
{
return conditions.AddCondition(relation, field, equality, value);
}
}
public static string GetStringEquality(ConditionEquality conditionEquality)
{
if (_stringEquality == null)
{
_stringEquality = new Dictionary<string, string>
{
{ConditionEquality.Equality.ToString(), " = "},
{ConditionEquality.Greater.ToString(), " > "},
{ConditionEquality.GreaterOrEqual.ToString(), " >= "},
{ConditionEquality.Less.ToString(), " < "},
{ConditionEquality.LessOrEqual.ToString(), " <= "},
{ConditionEquality.NotEqual.ToString(), " != "},
{ConditionEquality.In.ToString(), " IN "}
};
}
return _stringEquality[conditionEquality.ToString()];
}
public QueryCondition AddCondition(ConditionRelations relation, string field, ConditionEquality equality, object value)
{
QueryCondition condition = new QueryCondition(field, equality, value);
conditions.Add(new KeyValuePair<QueryCondition, ConditionRelations>(condition, relation));
return condition;
}
public QueryCondition AddCondition(ConditionRelations relation, QueryOperation field, ConditionEquality equality, object value)
{
return AddCondition(relation, field.ToString(), equality, value);
}
public QueryCondition AddCondition(string field, ConditionEquality equality, object value)
{
if (conditions.Count == 0 && string.IsNullOrEmpty(field))
{
return AddCondition(ConditionRelations.First, field, equality, value);
}
else
{
return AddCondition(ConditionRelations.And, field, equality, value);
}
}
public QueryCondition AddCondition(DataField field, ConditionEquality equality, object value)
{
if (conditions.Count == 0 && field != null)
{
return AddCondition(ConditionRelations.First, field, equality, value);
}
else
{
return AddCondition(ConditionRelations.And, field, equality, value);
}
}
public static string EqualityToString(ConditionEquality equality)
{
switch (equality)
{
case ConditionEquality.Equal:
return "=";
case ConditionEquality.GreaterThan:
return ">";
case ConditionEquality.GreaterThanEqual:
return ">=";
case ConditionEquality.LessThan:
return "<";
case ConditionEquality.LessThanEqual:
return "<=";
case ConditionEquality.NotEqual:
return "<>";
case ConditionEquality.In:
return "IN";
case ConditionEquality.NotIn:
return "NOT IN";
case ConditionEquality.Like:
return "LIKE";
}
return String.Empty;
}
public static Query Eq(this Query query, string columnName, object value, bool doNotGenerateForNullValue = false, ConditionEquality conditionEquality = ConditionEquality.Equality)
{
//if (!IsNullOrEmpty(value) || !doNotGenerateForNullValue)
if (AddCondition(value, doNotGenerateForNullValue))
{
var item = new SearchItem
{
ColumnName = columnName,
ConditionEquality = conditionEquality,
ConditionStringType = ConditionStringType.Equal,
ConditionType = ConditionType.And,
ValueInSearch = value,
};
query.AddCondition(item);
}
return(query);
}
public static SearchItem GetSearchItem(string columnName, object valueInSaearch, ConditionEquality conditionEquality)
{
var searchItem = new SearchItem();
searchItem.ColumnName = columnName;
searchItem.ValueInSearch = valueInSaearch;
searchItem.ConditionEquality = conditionEquality;
searchItem.ConditionType = ConditionType.And;
searchItem.ConditionStringType = ConditionStringType.LikeBetween;
return(searchItem);
}
public QueryCondition AddCondition(QueryOperation field, ConditionEquality equality, object value)
{
if (conditions.Count == 0)
{
return conditions.AddCondition(ConditionRelations.First, field.ToString(), equality, value);
}
else
{
return conditions.AddCondition(ConditionRelations.And, field.ToString(), equality, value);
}
}
