public void alteraJobAposExclusao(Connection conn, JobLote job) throws SQLException {
ValoresAtualizaJob valores = retornaNovosValores(conn, job);
PreparedStatement stmt = null;
String update =
"update job set qtd_transf = ?, hr_tot = ?, qtd_sucata = ?, status = ? where job = ? and operacao = ? ";
stmt = conn.prepareStatement(update);
stmt.setDouble(1, valores.getQtdTransf());
stmt.setDouble(2, valores.getHoraTotal());
stmt.setDouble(3, valores.getQtdSucata());
stmt.setString(4, "R");
stmt.setString(5, job.getJob().trim().replace(".", ""));
stmt.setInt(6, job.getOperNum());
stmt.executeUpdate();
}
