1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
| try
{
RAP.FRM_Rapport frmrap = new RAP.FRM_Rapport();
Gestion_de_StockDataSet2 DB = new Gestion_de_StockDataSet2();
int idcommande = (int)dvgfacture.CurrentRow.Cells[0].Value;
SqlDataAdapter adpt;
System.Data.DataTable dt;
con.Open();
adpt = new SqlDataAdapter("select ID_DetailsCommande,Details_Commande.ID_Commande,Nom_Produit,Quantite,Prix,Remise,Total,Date_Commande,CONCAT(Nom_Client, ' ', Prenom_Client)as nom_prenom,Adresse_Client,Telephone_Client,Email_client,Total_HT,TVA,Total_TTC from Details_Commande INNER JOIN Commande ON Details_Commande.ID_Commande = Commande.ID_Commande INNER JOIN Client ON Client.ID_Client = Commande.ID_Client where Details_Commande.ID_Commande=" + idcommande, con);
dt = new System.Data.DataTable();
adpt.Fill(DB, DB.Tables[0].TableName);
con.Close();
frmrap.RPafficher.LocalReport.ReportEmbeddedResource = "GestiondeStock.RAP.RPT_Facture.rdlc";
frmrap.RPafficher.LocalReport.DataSources.Add(new ReportDataSource("DataFacture", DB.Tables[0]));
ReportParameter NomPrenom = new ReportParameter("NomPrenomClient", );
ReportParameter Adresse = new ReportParameter("AdresseC", );
ReportParameter Telephone = new ReportParameter("TelephoneC", );
ReportParameter Email = new ReportParameter("EmailC",);
ReportParameter Numerocommande = new ReportParameter("IDCommande", );
ReportParameter datecommande = new ReportParameter("DateCommande", );
ReportParameter totalht = new ReportParameter("TotalHT", );
ReportParameter tva = new ReportParameter("TVA",);
ReportParameter totalttc = new ReportParameter("TotalTTC", );
frmrap.RPafficher.LocalReport.SetParameters(new ReportParameter[] { NomPrenom, Adresse, Telephone, Email, Numerocommande, datecommande, totalht, tva, totalttc });
frmrap.RPafficher.RefreshReport();
frmrap.ShowDialog();
}
catch (Exception)
{
throw;
} |
