} // getWhereClause
/// <summary>
///Create the resulting Query WHERE Clause
/// </summary>
/// <param name="fullyQualified">fullyQualified fully qualified Table.ColumnName</param>
/// <returns></returns>
public string GetWhereClause(bool fullyQualified)
{
bool qualified = fullyQualified;
if (qualified && (_tableName == null || _tableName.Length == 0))
{
qualified = false;
}
//
StringBuilder sb = new StringBuilder();
for (int i = 0; i < _list.Count; i++)
{
QueryRestriction r = _list[i];
if (i != 0)
{
sb.Append(r.AndCondition ? " AND " : " OR ");
//sb.Append("");
}
if (qualified)
{
sb.Append(r.GetSQL(_tableName));
}
else
{
sb.Append(r.GetSQL(null));
}
}
return(sb.ToString());
}
} // getWhereClause
public String GetWhereClause(int index)
{
StringBuilder sb = new StringBuilder();
if (index >= 0 && index < _list.Count)
{
QueryRestriction r = _list[index];
sb.Append(r.GetSQL(null));
}
return(sb.ToString());
} // getWhereClause