public static JasperPrint generateRecapAdressesClients(Date dateDebut, Date dateFin) {
JasperPrint printImprCheques = new JasperPrint();
Connection conn = null;
long start = System.currentTimeMillis();
try {
Map<String, Object> paramFacture = new HashMap<String, Object>();
paramFacture.put("debut", dateDebut);
paramFacture.put("fin", dateFin);
org.hibernate.Session session = CEFXUtil.getSessionFactory().getCurrentSession();
SessionFactoryImplementor sfi = (SessionFactoryImplementor) session.getSessionFactory();
ConnectionProvider cp = sfi.getConnectionProvider();
conn = cp.getConnection();
printImprCheques =
JasperFillManager.fillReport("src/cefx/report/AdresseAnnee.jasper", paramFacture, conn);
} catch (Exception e) {
throw new RuntimeException("Impossible de générer le recap", e);
} finally {
// it's your responsibility to close the connection, don't forget it!
if (conn != null) {
try {
conn.close();
} catch (Exception e) {
}
}
}
return printImprCheques;
}
public static JasperPrint generateFacture(Integer numFacture) {
Connection conn = null;
JasperPrint printFacture = new JasperPrint();
long start = System.currentTimeMillis();
try {
Map<String, Object> paramFacture = new HashMap<String, Object>();
paramFacture.put("num_commande", numFacture);
org.hibernate.Session session = CEFXUtil.getSessionFactory().getCurrentSession();
SessionFactoryImplementor sfi = (SessionFactoryImplementor) session.getSessionFactory();
ConnectionProvider cp = sfi.getConnectionProvider();
conn = cp.getConnection();
printFacture =
JasperFillManager.fillReport("src/cefx/report/FactureCE.jasper", paramFacture, conn);
// JasperPrint printBDC =
// JasperFillManager.fillReport("src/cefx/report/BonDeCommande.jasper", paramFacture, conn);
} catch (Exception e) {
throw new RuntimeException("Impossible de générer la Facture", e);
// COMMANDE ENREGISTREE MAIS NON IMPRIMEE
} finally {
// it's your responsibility to close the connection, don't forget it!
if (conn != null) {
try {
conn.close();
} catch (Exception e) {
}
}
}
return printFacture;
}
