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