public void FiltrarMetais(Metal[] metais)
{
StringBuilder str = new StringBuilder();
str.Append("DELETE FROM tmpPesquisaMercadoria WHERE SUBSTR(referencia, 9, 1) NOT IN (");
FiltrarMetais(metais, str);
using (IDbCommand cmd = conexão.CreateCommand())
{
cmd.CommandText = str.ToString();
cmd.ExecuteNonQuery();
}
}
private static void FiltrarMetais(Metal[] metais, StringBuilder str)
{
int cnt = 0;
foreach (Metal metal in metais)
{
if (cnt++ > 0)
str.Append(", ");
str.Append(DbTransformar(metal.Código));
}
str.Append(")");
}
