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