| public static ProcessParams ( string _sql, object args_src, List | ||
| _sql | string | |
| args_src | object | |
| args_dest | List | |
| return | string | |
private void Build(StringBuilder sb, List <object> args, Sql lhs)
{
if (!string.IsNullOrEmpty(_sql))
{
// add SQL to the string
if (sb.Length > 0)
{
sb.Append("\n");
}
var sql = ParameterHelper.ProcessParams(_sql, _args, args);
if (Is(lhs, "WHERE ") && Is(this, "WHERE "))
{
sql = "AND " + sql.Substring(6);
}
if (Is(lhs, "ORDER BY ") && Is(this, "ORDER BY "))
{
sql = ", " + sql.Substring(9);
}
sb.Append(sql);
}
// now do rhs
_rhs?.Build(sb, args, this);
}
public string ResolveClauses(List <object> finalParams)
{
foreach (var item in this)
{
item.ResolvedSql = ParameterHelper.ProcessParams(item.Sql, item.Parameters.ToArray(), finalParams);
}
return(prefix + string.Join(joiner, this.Select(c => c.ResolvedSql).ToArray()) + postfix);
}
public Template(SqlBuilder builder, string sql, params object[] parameters)
{
this.sql = ParameterHelper.ProcessParams(sql, parameters, finalParams);
this.builder = builder;
}
