public override void AppendSqlString(StringBuilder aBuilder, List <SqlParameter> aParameters) { //({0} IN (@{0},@{1},...)) //({0} IN ( aBuilder.Append(SqlSyntax.LEFT_PARENTHESE); aBuilder.Append(Property); aBuilder.Append(SqlSyntax.SPACE); aBuilder.Append(SqlSyntax.IN); aBuilder.Append(SqlSyntax.SPACE); aBuilder.Append(SqlSyntax.LEFT_PARENTHESE); ParemetersHelper helper = ParemetersHelperFactory.GetParemeterHelper(); //@{1},@{2},... for (int i = 0; i < Value.Length; i++) { aBuilder.Append(helper.GetParameterString(aParameters.Count)); if (i != Value.Length - 1) { aBuilder.Append(SqlSyntax.COMMA); } AddExpressionParameters(aParameters, Value[i]); } //)) aBuilder.Append(SqlSyntax.RIGHT_PARENTHESE); aBuilder.Append(SqlSyntax.RIGHT_PARENTHESE); }
protected void AppendSql(StringBuilder aBuilder, List <SqlParameter> aParameters, String Op, Object aValue) { //property Op @property[X] aBuilder.Append(SqlSyntax.LEFT_PARENTHESE); aBuilder.Append(Property); aBuilder.Append(SqlSyntax.SPACE); aBuilder.Append(Op); aBuilder.Append(SqlSyntax.SPACE); ParemetersHelper helper = ParemetersHelperFactory.GetParemeterHelper(); aBuilder.Append(helper.GetParameterString(aParameters.Count)); aBuilder.Append(SqlSyntax.RIGHT_PARENTHESE); //adding paremeters AddExpressionParameters(aParameters, aValue); }
public override void AppendSqlString(StringBuilder aBuilder, List <SqlParameter> aParameters) { //property Op @property[X] aBuilder.Append(SqlSyntax.LEFT_PARENTHESE); aBuilder.Append(Property); aBuilder.Append(SqlSyntax.SPACE); aBuilder.Append(Op); aBuilder.Append(SqlSyntax.SPACE); ParemetersHelper helper = ParemetersHelperFactory.GetParemeterHelper(); aBuilder.AppendFormat(FormatFunction, helper.GetParameterString(aParameters.Count)); aBuilder.Append(SqlSyntax.RIGHT_PARENTHESE); foreach (Object value in Value) { AddExpressionParameters(aParameters, value); } }
protected void AddExpressionParameters(List <SqlParameter> aParameters, Object aValue) { ParemetersHelper helper = ParemetersHelperFactory.GetParemeterHelper(); aParameters.Add(helper.GetSqlParemeter(aParameters.Count, aValue)); }