/// <summary>
/// 空 ISNULL
/// </summary>
/// <param name="fieldName"></param>
/// <returns></returns>
public static WhereExpressionSQL IsNull(string fieldName)
{
WhereExpressionSQL where = new WhereExpressionSQL();
return where.IsNull(fieldName);
}
/// <summary>
/// LIKE % 左匹配
/// </summary>
/// <param name="fieldName"></param>
/// <param name="value"></param>
/// <returns></returns>
public static WhereExpressionSQL LikeLeft(string fieldName, string value)
{
WhereExpressionSQL where = new WhereExpressionSQL();
return where.LikeLeft(fieldName, value);
}
/// <summary>
/// 大于等于>=
/// </summary>
/// <param name="fieldName"></param>
/// <param name="type"></param>
/// <param name="value"></param>
/// <returns></returns>
public static WhereExpressionSQL GTE(string fieldName, DbType type, object value)
{
WhereExpressionSQL where = new WhereExpressionSQL();
return where.GTE(fieldName, type, value);
}
/// <summary>
/// IN
/// </summary>
/// <param name="fieldName"></param>
/// <param name="type"></param>
/// <param name="values"></param>
/// <returns></returns>
public static WhereExpressionSQL In(string fieldName, DbType type, params object[] values)
{
WhereExpressionSQL where = new WhereExpressionSQL();
return where.In(fieldName, type, values);
}
/// <summary>
/// BETWEEN AND
/// </summary>
/// <param name="fieldName"></param>
/// <param name="type"></param>
/// <param name="leftValue"></param>
/// <param name="rightValue"></param>
/// <returns></returns>
public static WhereExpressionSQL Between(string fieldName, DbType type, object leftValue, object rightValue)
{
WhereExpressionSQL where = new WhereExpressionSQL();
return where.Between(fieldName, type, leftValue, rightValue);
}
/// <summary>
/// AND
/// </summary>
/// <param name="expressions"></param>
/// <returns></returns>
public static WhereExpressionSQL And(params WhereExpressionSQL[] expressions)
{
WhereExpressionSQL where = new WhereExpressionSQL();
return where.And(expressions);
}
/// <summary>
/// 空条件
/// </summary>
/// <returns></returns>
public static WhereExpressionSQL Empty()
{
WhereExpressionSQL where = new WhereExpressionSQL();
return where.Empty();
}
/// <summary>
/// 或 OR
/// </summary>
/// <param name="where"></param>
/// <param name="left"></param>
/// <param name="right"></param>
/// <returns></returns>
public static WhereExpressionSQL Or(this WhereExpressionSQL where, WhereExpressionSQL left, WhereExpressionSQL right)
{
if (where == null)
{
return Or(left, right);
}
List<IDbDataParameter> list = new List<IDbDataParameter>();
list.AddRange(left.GetParameters());
list.AddRange(right.GetParameters());
return where.AddExpression(string.Format("({0}) OR ({1})", left.GetExpression(), right.GetExpression()), list.ToArray());
}
/// <summary>
/// 或 OR
/// </summary>
/// <param name="left"></param>
/// <param name="right"></param>
/// <returns></returns>
public static WhereExpressionSQL Or(WhereExpressionSQL left, WhereExpressionSQL right)
{
WhereExpressionSQL where = new WhereExpressionSQL();
return where.Or(left, right);
}