/// <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]")); }