/// <summary> /// 创建新的Sql条件语句集合 /// </summary> /// <param name="concatType">连接类型</param> /// <param name="conditions">查询语句集合</param> /// <exception cref="ArgumentNullException">查询语句集合不能为空</exception> /// <returns>Sql条件语句集合</returns> public static SqlConditionList CreateList(SqlWhereConcatType concatType, List <ISqlCondition> conditions) { if (conditions == null) { throw new ArgumentNullException("conditions"); } return(SqlCondition.CreateList(SqlWhereConcatType.And, conditions.ToArray())); }
/// <summary> /// 两个Sql条件语句执行或操作 /// </summary> /// <param name="condition1">条件1</param> /// <param name="condition2">条件2</param> /// <returns>条件列表</returns> public static SqlConditionList operator |(SqlConditionList condition1, AbstractSqlCondition condition2) { if (condition1.ConcatType == SqlWhereConcatType.Or) { condition1.Add(condition2); return(condition1); } else { return(SqlCondition.Or(condition1, condition2)); } }
/// <summary> /// 两个Sql条件语句执行与操作 /// </summary> /// <param name="condition1">条件1</param> /// <param name="condition2">条件2</param> /// <returns>条件列表</returns> public static SqlConditionList operator &(AbstractSqlCondition condition1, SqlConditionList condition2) { if (condition2.ConcatType == SqlWhereConcatType.And) { condition2.Add(condition2); return(condition2); } else { return(SqlCondition.And(condition1, condition2)); } }
/// <summary> /// 创建判断是否相似的Sql条件语句 /// </summary> /// <param name="columnName">字段名</param> /// <param name="value">数据</param> /// <returns>Sql条件语句</returns> public static SqlBasicParameterCondition Like(String columnName, String value) { return(SqlCondition.Like(SqlParameter.Create(columnName, value))); }
/// <summary> /// 两个Sql条件语句执行或操作 /// </summary> /// <param name="condition1">条件1</param> /// <param name="condition2">条件2</param> /// <returns>条件列表</returns> public static SqlConditionList operator |(AbstractSqlCondition condition1, AbstractSqlCondition condition2) { return(SqlCondition.Or(condition1, condition2)); }
/// <summary> /// 创建判断是否不在范围内的Sql条件语句 /// </summary> /// <param name="columnName">字段名</param> /// <param name="paramName">参数名</param> /// <param name="valueOne">数据一</param> /// <param name="valueTwo">数据二</param> /// <returns>Sql查询语句类</returns> public static SqlBasicParameterCondition NotBetween(String columnName, String paramName, Object valueOne, Object valueTwo) { return(SqlCondition.NotBetween(SqlParameter.Create(columnName, paramName + "_One", valueOne), SqlParameter.Create(columnName, paramName + "_Two", valueTwo))); }
/// <summary> /// 创建判断是否开头不包含的Sql条件语句 /// </summary> /// <param name="columnName">字段名</param> /// <param name="value">数据</param> /// <returns>Sql条件语句</returns> public static SqlBasicParameterCondition NotLikeStartWith(String columnName, String value) { return(SqlCondition.NotLike(SqlParameter.Create(columnName, "%" + value))); }
/// <summary> /// 创建判断是否结尾不包含的Sql条件语句 /// </summary> /// <param name="columnName">字段名</param> /// <param name="paramName">参数名</param> /// <param name="value">数据</param> /// <returns>Sql查询语句类</returns> public static SqlBasicParameterCondition NotLikeEndWith(String columnName, String paramName, String value) { return(SqlCondition.NotLike(SqlParameter.Create(columnName, paramName, value + "%"))); }
/// <summary> /// 创建判断是否结尾不包含的Sql条件语句 /// </summary> /// <param name="columnName">字段名</param> /// <param name="tableNameTwo">数据表名二</param> /// <param name="columnNameTwo">字段名二</param> /// <returns>Sql条件语句</returns> public static SqlBasicParameterCondition NotLikeColumn(String columnName, String tableNameTwo, String columnNameTwo) { return(SqlCondition.NotLike(SqlParameter.CreateCustomAction(columnName, GetFieldName(tableNameTwo, columnNameTwo)))); }
/// <summary> /// 创建判断是否包含的Sql条件语句 /// </summary> /// <param name="columnName">字段名</param> /// <param name="paramName">参数名</param> /// <param name="value">数据</param> /// <returns>Sql条件语句</returns> public static SqlBasicParameterCondition LikeAll(String columnName, String paramName, String value) { return(SqlCondition.Like(SqlParameter.Create(columnName, paramName, "%" + value + "%"))); }
/// <summary> /// 创建判断是否小于等于的Sql条件语句 /// </summary> /// <param name="columnName">字段名</param> /// <param name="tableNameTwo">数据表名二</param> /// <param name="columnNameTwo">字段名二</param> /// <returns>Sql条件语句</returns> public static SqlBasicParameterCondition LessThanOrEqualColumn(String columnName, String tableNameTwo, String columnNameTwo) { return(SqlCondition.LessThanOrEqual(SqlParameter.CreateCustomAction(columnName, GetFieldName(tableNameTwo, columnNameTwo)))); }
/// <summary> /// 创建新的Sql条件语句 /// </summary> /// <param name="function">合计函数类型</param> /// <param name="op">条件运算符</param> /// <param name="value">数据</param> /// <returns>Sql条件语句</returns> public static SqlBasicParameterCondition Create(SqlAggregateFunction function, SqlOperator op, Object value) { return(SqlCondition.Create(function, "*", op, value)); }
/// <summary> /// 创建判断是否小于等于的Sql条件语句 /// </summary> /// <param name="columnName">字段名</param> /// <param name="paramName">参数名</param> /// <param name="value">数据</param> /// <returns>Sql查询语句类</returns> public static SqlBasicParameterCondition LessThanOrEqual(String columnName, String paramName, Object value) { return(SqlCondition.LessThanOrEqual(SqlParameter.Create(columnName, paramName, value))); }
/// <summary> /// 创建判断是否大于的Sql条件语句 /// </summary> /// <param name="columnName">字段名</param> /// <param name="value">数据</param> /// <returns>Sql条件语句</returns> public static SqlBasicParameterCondition GreaterThan(String columnName, Object value) { return(SqlCondition.GreaterThan(SqlParameter.Create(columnName, value))); }
/// <summary> /// 创建判断是否非空的Sql条件语句 /// </summary> /// <param name="columnName">字段名</param> /// <returns>Sql条件语句</returns> public static SqlBasicParameterCondition IsNotNull(String columnName) { return(SqlCondition.IsNotNull(SqlParameter.Create(columnName, null))); }
/// <summary> /// 创建或连接的Sql条件语句集合 /// </summary> /// <param name="conditions">查询语句集合</param> /// <returns>Sql条件语句集合</returns> public static SqlConditionList Or(List <ISqlCondition> conditions) { return(SqlCondition.CreateList(SqlWhereConcatType.Or, conditions.ToArray())); }
/// <summary> /// 创建或连接的Sql条件语句集合 /// </summary> /// <param name="conditions">查询语句集合</param> /// <returns>Sql条件语句集合</returns> public static SqlConditionList Or(params ISqlCondition[] conditions) { return(SqlCondition.CreateList(SqlWhereConcatType.Or, conditions)); }