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