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);
}
//Assuming @p0, @p1 is the paremeters
public static SqlQuery SimpleQueryHelper(String aQuery, params object[] aValues)
{
NativeQuery query = new NativeQuery();
query.Query = aQuery;
for (int i = 0; i < aValues.Length; i++)
{
ParemetersHelper helper = ParemetersHelperFactory.GetParemeterHelper();
query.Parameters.Add(helper.GetSqlParemeter(query.Parameters.Count, aValues[i]));
}
return(query);
}
public static SqlQuery GetSQLQuery(String aStoreProcedurName, Dictionary <String, Object> aParamaters)
{
ParemetersHelper helper = ParemetersHelperFactory.GetParemeterHelper();
NativeStoredProcedureQuery query = new NativeStoredProcedureQuery();
query.ProcedureName = aStoreProcedurName;
foreach (KeyValuePair <string, object> entry in aParamaters)
{
var sqlparam = helper.GetSqlParemeter(entry.Key, entry.Value);
query.Parameters.Add(sqlparam);
}
return(query);
}
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);
}
}
public override string ToString()
{
ParemetersHelper helper = ParemetersHelperFactory.GetParemeterHelper();
StringBuilder result = new StringBuilder();
result.Append("[");
result.Append(Query);
result.Append("]");
result.AppendLine();
result.Append("[");
foreach (System.Data.SqlClient.SqlParameter paremeter in this.Parameters)
{
result.Append(SqlSyntax.AT);
result.Append(paremeter.ParameterName);
result.Append(SqlSyntax.EQ);
result.Append(paremeter.SqlValue);
result.Append(SqlSyntax.SPACE);
}
result.Append("]");
return(result.ToString());
}
public ParemeterStatement()
{
FieldValue = new Dictionary <String, Object>();
ParemeterHelper = ParemetersHelperFactory.GetParemeterHelper();
}
protected void AddExpressionParameters(List <SqlParameter> aParameters, Object aValue)
{
ParemetersHelper helper = ParemetersHelperFactory.GetParemeterHelper();
aParameters.Add(helper.GetSqlParemeter(aParameters.Count, aValue));
}
