public void ResolveExpression(Expression expression = null, SqlWhereType whereType = SqlWhereType.And) { if (expression == null) { _SqlWhere = string.Empty; return; } var sqlFormat = (whereType == SqlWhereType.And) ? " AND {0} " : " OR {0} "; SqlLmdResolver.MemberType type = SqlLmdResolver.MemberType.None; this._SqlWhere = string.Format(sqlFormat, GetResolveAll(expression, ref type).SqlConditions); }
/// <summary> /// Constructor /// </summary> /// <param name="name"></param> /// <param name="value"></param> public WhereItem(string name, object value) { _name = name; _whereType = SqlWhereType.Equal; _value = value; //_conditionName = string.Format("{0}{1}{2}", _name, _whereType, _value); }
/// <summary> /// /// </summary> /// <param name="name"></param> /// <param name="whereType"></param> /// <param name="value"></param> /// <returns></returns> public SqlWhere Where(string name, SqlWhereType whereType, object value) { _list.Add(new WhereItem(name, whereType, value)); return this; }
/// <summary> /// /// </summary> /// <param name="name"></param> /// <param name="whereType"></param> /// <param name="value"></param> /// <returns></returns> public SqlSelect Where(string name, SqlWhereType whereType, object value) { if (Condition == null) Condition = new SqlWhere(); this.Condition.List.Add(new WhereItem(name, whereType, value)); return this; }
private string GetWhereTypeString(SqlWhereType type) { return((type == SqlWhereType.And) ? " AND " : " OR "); }