/// <summary>
/// 添加In过滤条件
/// </summary>
private void AddIn(StringBuilder result, string name, object value, int index)
{
if (!IsValid(name, value))
{
return;
}
var paramName = SqlCondition.GetParamName(string.Format("{0}{1}", name, index));
result.AppendFormat("{0}{1},", GetParamPrefix(), paramName);
_params.Add(paramName, value);
}
/// <summary>
/// 添加参数
/// </summary>
private void AddParam(string name, object value, Operator @operator)
{
switch (@operator)
{
case Operator.Contains:
value = string.Format("%{0}%", value);
break;
case Operator.Starts:
value = string.Format("{0}%", value);
break;
case Operator.Ends:
value = string.Format("%{0}", value);
break;
}
_params.Add(SqlCondition.GetParamName(name), value);
}
public void TestGetParamName()
{
Assert.AreEqual("a", SqlCondition.GetParamName("a"));
Assert.AreEqual("a_b", SqlCondition.GetParamName("a.b"));
Assert.AreEqual("a_b", SqlCondition.GetParamName("a.[b]"));
}
