public void TestBetween_1()
{
//结果
var result = new String();
result.Append("Where [a].[B]>=@_p_0 And [a].[B]<=@_p_1");
//执行
_clause.Between("a.B", 1, 2, Boundary.Both);
//验证
Assert.Equal(1, _parameterManager.GetParams()["@_p_0"]);
Assert.Equal(2, _parameterManager.GetParams()["@_p_1"]);
Assert.Equal(result.ToString(), GetSql());
}
/// <summary>
/// 设置范围查询条件
/// </summary>
/// <param name="column">列名</param>
/// <param name="min">最小值</param>
/// <param name="max">最大值</param>
/// <param name="includeTime">是否包含时间</param>
/// <param name="boundary">包含边界</param>
/// <returns></returns>
public ISqlBuilder Between(string column, DateTime?min, DateTime?max, bool includeTime = true,
Boundary?boundary = null)
{
WhereClause.Between(column, min, max, includeTime, boundary);
return(this);
}
/// <summary>
/// 设置范围查询条件
/// </summary>
/// <typeparam name="TEntity">实体类型</typeparam>
/// <param name="expression">列名表达式</param>
/// <param name="min">最小值</param>
/// <param name="max">最大值</param>
/// <param name="includeTime">是否包含时间</param>
/// <param name="boundary">包含边界</param>
/// <returns></returns>
public ISqlBuilder Between <TEntity>(Expression <Func <TEntity, object> > expression, DateTime?min, DateTime?max, bool includeTime = true,
Boundary?boundary = null) where TEntity : class
{
WhereClause.Between(expression, min, max, includeTime, boundary);
return(this);
}
/// <summary>
/// 设置范围查询条件
/// </summary>
/// <param name="column">列名</param>
/// <param name="min">最小值</param>
/// <param name="max">最大值</param>
/// <param name="boundary">包含边界</param>
/// <returns></returns>
public ISqlBuilder Between(string column, decimal?min, decimal?max, Boundary boundary = Boundary.Both)
{
WhereClause.Between(column, min, max, boundary);
return(this);
}
/// <summary>
/// 设置范围查询条件
/// </summary>
/// <typeparam name="TEntity">实体类型</typeparam>
/// <param name="expression">列名表达式</param>
/// <param name="min">最小值</param>
/// <param name="max">最大值</param>
/// <param name="boundary">包含边界</param>
/// <returns></returns>
public ISqlBuilder Between <TEntity>(Expression <Func <TEntity, object> > expression, decimal?min, decimal?max, Boundary boundary = Boundary.Both) where TEntity : class
{
WhereClause.Between(expression, min, max, boundary);
return(this);
}