private void button1_Click(object sender, EventArgs e) { try { data = new SqlDataAdapter("select * from Livraison where CodeLivr=" + textBox8.Text, con); data.Fill(set, "Livraison"); data = new SqlDataAdapter("select cha.* from Charge_Commande as cha inner join Chargement as ch on ch.CodeChargement=cha.CodeChargement inner Join Livraison as l on l.CodeChargement=ch.CodeChargement where l.CodeLivr=" + textBox8.Text, con); data.Fill(set, "Charge_Commande"); data = new SqlDataAdapter("select ch.* from Chargement as ch inner Join Livraison as l on l.CodeChargement=ch.CodeChargement where l.CodeLivr=" + textBox8.Text, con); data.Fill(set, "Chargement"); data = new SqlDataAdapter("select chau.* from chauffeur as chau inner join Chargement as ch on chau.CodeChauffeur=ch.CodeChauf inner Join Livraison as l on l.CodeChargement=ch.CodeChargement where l.CodeLivr=" + textBox8.Text, con); data.Fill(set, "Chauffeur"); data = new SqlDataAdapter("select C.* from Commande as C inner Join Charge_Commande as char on C.Codecommande=char.CodeCommande inner join Chargement as ch on ch.CodeChargement=char.CodeChargement inner Join Livraison as l on l.CodeChargement=ch.CodeChargement where l.CodeLivr=" + textBox8.Text, con); data.Fill(set, "Commande"); data = new SqlDataAdapter("select Cl.* from Client as Cl inner Join Commande as C on C.CodeClient=Cl.Codeclient inner Join Charge_Commande as char on C.Codecommande=char.CodeCommande inner join Chargement as ch on ch.CodeChargement=char.CodeChargement inner Join Livraison as l on l.CodeChargement=ch.CodeChargement where l.CodeLivr=" + textBox8.Text, con); data.Fill(set, "Client"); BonLivraison b = new BonLivraison(); b.SetDataSource(set); Report_Viewer_Form r = new Report_Viewer_Form(); r.Text = "Bon de Livraison N° " + textBox8.Text; r.crystalReportViewer1.ReportSource = b; r.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public static void LivrerCommande_Print(int CodeCommande) { try { int CodeTournee = int.Parse(ExecuteScalar("select numTournee from Commande where Codecommande = '" + CodeCommande + "'").ToString()); int CodeChargement = int.Parse(ExecuteScalar("select CodeChargement from Chargement where CodeTournee = '" + CodeTournee + "'").ToString()); ExecuteQuery("insert into Livraison(CodeChargement) values('" + CodeChargement + "')"); int CodeLivraison = int.Parse(ExecuteScalar("select IDENT_CURRENT('Livraison')").ToString()); DataSet Data_Set = getBonLivraison(CodeLivraison); BonLivraison reportCommande = new BonLivraison(); reportCommande.SetDataSource(Data_Set); Report_Viewer_Form frm = new Report_Viewer_Form(); frm.Text = "Bon De Livraison N°: " + CodeLivraison + " pour la commande N°: " + CodeCommande; frm.crystalReportViewer1.ReportSource = reportCommande; frm.Show(); } catch (Exception Err) { MessageBox.Show(Err.Message, "Un Erreur est survenue", MessageBoxButtons.OK, MessageBoxIcon.Error); } }