/** * @ 增加一个条件 * @ field 字段名称 * @ expr 运算符 * @ value 值,支持空值 * */ public SQLHelper AddWhere(string field, SQLExpression.ExprOperator expr, object value) { SQLCondition lsc = new SQLCondition(field, value, expr); Conditions.Add(lsc); return(this); }
/** * @ 构造函数第一次重载 * @ name 字段名称 * @ value 参数值 * @ expr 表达式运算符号 * @ joinType 该参数连接上一个参数的连接符号 * */ public SQLCondition(string name, object value, SQLExpression.ExprOperator expr, SQLExpression.JoinType joinType) { this.name = name; this.val = value; this.expr = expr; this.joinType = joinType; }
/** * @ 增加一个条件 * @ field 字段名称 * @ expr 运算符 * @ value 值,支持空值 * @ joinType 连接上一个条件的运算位 * */ public SQLHelper AddWhere(string field, SQLExpression.ExprOperator expr, object value, SQLExpression.JoinType joinType) { Conditions.Add(new SQLCondition(field, value, expr, joinType)); return(this); }
/** * @ 获取枚举的字符串表现形式 * */ public static string GetEnumString(this SQLExpression.ExprOperator value) { string defaultExpression = string.Empty; switch (value) { /** * @ 大于 * */ case SQLExpression.ExprOperator.Gt: defaultExpression = ">"; break; /** * @ 小于 * */ case SQLExpression.ExprOperator.Lt: defaultExpression = "<"; break; /** * @ 大于等于 * */ case SQLExpression.ExprOperator.GtEq: defaultExpression = ">="; break; /** * @ 小于等于 * */ case SQLExpression.ExprOperator.LtEq: defaultExpression = "<="; break; /** * @ 模糊查询 * */ case SQLExpression.ExprOperator.Like: defaultExpression = "LIKE"; break; /** * @ 相当于is not null * */ case SQLExpression.ExprOperator.NotNull: defaultExpression = "IS NOT"; break; /** * @ 相当于 is not like * */ case SQLExpression.ExprOperator.NotLike: defaultExpression = "IS NOT LIKE"; break; /** * @ 在xxx中,相当于in * */ case SQLExpression.ExprOperator.In: defaultExpression = "IN"; break; /** * @ 不存在在xxx中,相当于 not in * */ case SQLExpression.ExprOperator.NotIn: defaultExpression = "NOT IN"; break; /** * @ 相当于 is null * */ case SQLExpression.ExprOperator.IsNull: defaultExpression = "IS"; break; /** * @ 默认Eq * */ default: defaultExpression = "="; break; } return(defaultExpression); }
/** * @ 构造函数第一次重载 * @ name 字段名称 * @ value 参数值 * @ expr 表达式运算符号 * */ public SQLCondition(string name, object value, SQLExpression.ExprOperator expr) : this(name, value, expr, SQLExpression.JoinType.AND) { }