/// <summary>
/// 使用And连接条件
/// </summary>
/// <param name="condition">过滤条件</param>
public ISqlBuilder And(string condition)
{
if (condition.IsEmpty())
{
return(this);
}
if (_condition == null)
{
_condition = SqlCondition.Create(condition);
return(this);
}
_condition = new AndCondition(_condition.GetCondition(), condition);
return(this);
}
/// <summary>
/// 使用Or连接条件
/// </summary>
/// <param name="condition">过滤条件</param>
public ISqlBuilder Or( ISqlCondition condition ) {
return Or( condition.GetCondition() );
}
/// <summary>
/// 使用And连接条件
/// </summary>
/// <param name="condition">过滤条件</param>
public ISqlBuilder And( ISqlCondition condition ) {
return And( condition.GetCondition() );
}
/// <summary>
/// 使用Or连接条件
/// </summary>
/// <param name="condition">过滤条件</param>
public ISqlBuilder Or(ISqlCondition condition)
{
return(Or(condition.GetCondition()));
}
public void TestEnds() {
_condition = SqlCondition.Create( "a", "@", Operator.Ends );
Assert.AreEqual( "a Like @a", _condition.GetCondition() );
}
/// <summary>
/// 使用And连接条件
/// </summary>
/// <param name="condition">过滤条件</param>
public ISqlBuilder And(ISqlCondition condition)
{
return(And(condition.GetCondition()));
}
public void TestLessEqual() {
_condition = SqlCondition.Create( "a", "@", Operator.LessEqual );
Assert.AreEqual( "a<=@a", _condition.GetCondition() );
}
public void TestGreater() {
_condition = SqlCondition.Create( "a", "@", Operator.Greater );
Assert.AreEqual( "a>@a", _condition.GetCondition() );
}
public void TestEnds()
{
_condition = SqlCondition.Create("a", "@", Operator.Ends);
Assert.AreEqual("a Like @a", _condition.GetCondition());
}
public void TestLessEqual()
{
_condition = SqlCondition.Create("a", "@", Operator.LessEqual);
Assert.AreEqual("a<=@a", _condition.GetCondition());
}
public void TestGreater()
{
_condition = SqlCondition.Create("a", "@", Operator.Greater);
Assert.AreEqual("a>@a", _condition.GetCondition());
}
