public void imprimiTexto(ResultSet rs, TYPE_PRINT bVisualizar, String sCab) { BigDecimal bTotal = new BigDecimal("0"); BigDecimal bSaldo = new BigDecimal("0"); BigDecimal bSaldoLinha = new BigDecimal("0"); BigDecimal bVlrDeb = new BigDecimal("0"); BigDecimal bVlrCred = new BigDecimal("0"); BigDecimal bVlrTotDeb = new BigDecimal("0"); BigDecimal bVlrTotCred = new BigDecimal("0"); BigDecimal bAnt = buscaSaldoAnt(); ImprimeOS imp = new ImprimeOS("", con); String linhafina = StringFunctions.replicate("-", 133); String sDataLanca = ""; String sConta = ""; String sCodConta = txtCodConta.getVlrString(); boolean bPrim = true; int linPag = imp.verifLinPag() - 1; try { imp.limpaPags(); imp.setTitulo("Extrato Bancário"); imp.addSubTitulo("EXTRATO BANCÁRIO"); sConta = "CONTA: " + sCodConta + " - " + txtDescConta.getVlrString(); imp.addSubTitulo(sConta); while (rs.next()) { if (!bPrim) { if (!(sDataLanca.equals(rs.getString("DataSL")))) { bTotal = new BigDecimal(rs.getString("SaldoSL")); } } else { bTotal = new BigDecimal(rs.getString("SaldoSL")); } if (imp.pRow() == linPag) { imp.eject(); imp.incPags(); } if (imp.pRow() == 0) { imp.montaCab(); imp.impCab(136, true); imp.say(0, imp.comprimido()); imp.say(0, "|" + linhafina + "|"); imp.pulaLinha(1, imp.comprimido()); imp.say(0, "| Data"); imp.say(14, "| Historico"); imp.say(69, "| Doc"); imp.say(82, "| Débito"); imp.say(100, "| Crédito"); imp.say(118, "| Saldo"); imp.say(135, "|"); imp.pulaLinha(1, imp.comprimido()); imp.say(0, "|" + linhafina + "|"); if (bPrim) { imp.pulaLinha(1, imp.comprimido()); imp.say(0, "|"); imp.say( 103, "Saldo Anterior: " + Funcoes.strDecimalToStrCurrency(15, Aplicativo.casasDecFin, bAnt.toString())); imp.say(135, "|"); imp.pulaLinha(1, imp.comprimido()); imp.say(0, "|" + linhafina + "|"); bSaldoLinha = new BigDecimal(bAnt.toString()); } } bPrim = false; bSaldo = new BigDecimal(rs.getBigDecimal("SaldoSL").toString()); bAnt = bSaldo; sDataLanca = rs.getString("DataSL"); bSaldoLinha = bSaldoLinha.add(rs.getBigDecimal("VlrSubLanca")); if (rs.getFloat("VlrSubLanca") < 0) { bVlrDeb = new BigDecimal(rs.getBigDecimal("VlrSubLanca").toString()).abs(); bVlrCred = new BigDecimal("0.00"); bVlrTotDeb = bVlrTotDeb.add(new BigDecimal(bVlrDeb.toString())); } else { bVlrCred = new BigDecimal(rs.getBigDecimal("VlrSubLanca").toString()); bVlrDeb = new BigDecimal("0.00"); bVlrTotCred = bVlrTotCred.add(new BigDecimal(bVlrCred.toString())); } imp.pulaLinha(1, imp.comprimido()); imp.say(0, "| " + StringFunctions.sqlDateToStrDate(rs.getDate("DataSL"))); imp.say(14, "| " + Funcoes.copy(rs.getString("HistBLanca"), 0, 50)); imp.say(69, "| " + Funcoes.alinhaDir(rs.getString("DocLanca"), 10)); imp.say(82, "|"); if (bVlrDeb.floatValue() != 0) { imp.say( imp.pRow() + 0, 84, Funcoes.strDecimalToStrCurrency(15, Aplicativo.casasDecFin, bVlrDeb.toString())); } imp.say(100, "|"); if (bVlrCred.floatValue() != 0) { imp.say( 0, 102, Funcoes.strDecimalToStrCurrency(15, Aplicativo.casasDecFin, bVlrCred.toString())); } imp.say( 118, "|" + Funcoes.strDecimalToStrCurrency( 15, Aplicativo.casasDecFin, bSaldoLinha.toString())); imp.say(135, "|"); } imp.pulaLinha(1, imp.comprimido()); imp.say(0, "|" + linhafina + "|"); imp.pulaLinha(1, imp.comprimido()); imp.say(0, "|"); imp.say(82, "|"); imp.say( 84, Funcoes.strDecimalToStrCurrency(15, Aplicativo.casasDecFin, bVlrTotDeb.toString())); imp.say(100, "|"); imp.say( 102, Funcoes.strDecimalToStrCurrency(15, Aplicativo.casasDecFin, bVlrTotCred.toString())); imp.say(118, "|"); imp.say(119, Funcoes.strDecimalToStrCurrency(15, Aplicativo.casasDecFin, bTotal.toString())); imp.say(135, "|"); imp.pulaLinha(1, imp.comprimido()); imp.say(0, "+" + linhafina + "+"); imp.eject(); imp.fechaGravacao(); rs.close(); con.commit(); } catch (Exception e) { e.printStackTrace(); } if (bVisualizar == TYPE_PRINT.VIEW) { imp.preview(this); } else { imp.print(); } }