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