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