private void AfficherListe() { float s = 0; DetailsCde unDetail = new DetailsCde(); List<DetailsCde> mesDetails; string numero, libelle, ville, prixUnitaire, qte, prixTotal, livre; ListViewItem lvitem_cde; try { mesDetails = unDetail.getDetailsCde(numCommande); foreach (DetailsCde d in mesDetails) { numero = d.Art.No_article; libelle = d.Art.Lib_article; ville = d.Art.Ville_art; prixUnitaire = d.Art.Prix_art; qte = d.Qte_cdee; prixTotal = d.Total; livre = d.Livree; lvitem_cde = new ListViewItem(new string[] { numero, libelle, ville, prixUnitaire, qte, prixTotal, livre }, -1, Color.Black, Color.LightGray, null); lvart.Items.Add(lvitem_cde); s=s + float.Parse(prixTotal); } this.HT.Text += " " + s; s = s * ((float)12/10) ; this.TTC.Text += " " + s; lvart.FullRowSelect = true; lvart.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize); } catch (MonException erreur) { MessageBox.Show(erreur.MessageSysteme(), "Erreur de modification"); } }
private void AfficherListe() { DetailsCde unDetail = new DetailsCde(); List<DetailsCde> mesDetails; string numArt, libelle, ville, prixU, qte, prixT, livre; ListViewItem lvitem_cde; //lvcdes.Items.Clear(); //lvcdes.Columns.Clear(); //lvcdes.View = View.Details; //lvcdes.Columns.Add("1", "Numéro"); //lvcdes.Columns.Add("2", "Numéro Vendeur"); //lvcdes.Columns.Add("3", "Numéro Client"); //lvcdes.Columns.Add("4", "Date Commande"); //lvcdes.Columns.Add("5", "Facture"); try { mesDetails = unDetail.getDetailsCde(noCmd); foreach (DetailsCde d in mesDetails) { numArt = d.Art.No_article; libelle = d.Art.Lib_article; ville = d.Art.Ville_art; prixU = d.Art.Prix_art; qte = d.Qte_cdee; prixT = d.Total; livre = d.Livree; lvitem_cde = new ListViewItem(new string[] { numArt, libelle, ville, prixU, qte, prixT, livre }, -1, Color.Black, Color.LightGray, null); lvart.Items.Add(lvitem_cde); } lvart.FullRowSelect = true; lvart.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize); } catch (MonException erreur) { MessageBox.Show(erreur.MessageSysteme(), "Erreur de modification"); } }
public List <DetailsCde> getDetailsCde(String noCmd) { DataTable dt; sErreurs err = new sErreurs("", ""); //MySqlConnection cnx = Connexion.getInstance().getConnexion(); String mysql = "SELECT articles.*, detail_cde.QTE_CDEE, detail_cde.LIVREE " + "FROM articles, detail_cde " + "WHERE detail_cde.NO_COMMAND = " + noCmd + " AND articles.NO_ARTICLE = detail_cde.NO_ARTICLE " + "ORDER BY NO_ARTICLE ASC"; Console.Write(mysql); try { dt = DbInterface.Lecture(mysql, err); List <DetailsCde> mesDetails = new List <DetailsCde>(); foreach (DataRow dataRow in dt.Rows) { Article unart = new Article(); unart.No_article = dataRow[0].ToString(); unart.Lib_article = dataRow[1].ToString(); unart.Qte_dispo = dataRow[2].ToString(); unart.Ville_art = dataRow[3].ToString(); unart.Prix_art = dataRow[4].ToString(); unart.Interrompu = dataRow[5].ToString(); DetailsCde unDetail = new DetailsCde(unart, dataRow[6].ToString(), dataRow[7].ToString()); mesDetails.Add(unDetail); } return(mesDetails); } catch (MonException erreur) { throw erreur; } }
public List<DetailsCde> getDetailsCde(String noCmd) { DataTable dt; sErreurs err = new sErreurs("", ""); //MySqlConnection cnx = Connexion.getInstance().getConnexion(); String mysql = "SELECT articles.*, detail_cde.QTE_CDEE, detail_cde.LIVREE " +"FROM articles, detail_cde "+"WHERE detail_cde.NO_COMMAND = " + noCmd + " AND articles.NO_ARTICLE = detail_cde.NO_ARTICLE " + "ORDER BY NO_ARTICLE ASC"; Console.Write(mysql); try { dt = DbInterface.Lecture(mysql, err); List<DetailsCde> mesDetails = new List<DetailsCde>(); foreach (DataRow dataRow in dt.Rows) { Article unart = new Article(); unart.No_article = dataRow[0].ToString(); unart.Lib_article = dataRow[1].ToString(); unart.Qte_dispo = dataRow[2].ToString(); unart.Ville_art = dataRow[3].ToString(); unart.Prix_art = dataRow[4].ToString(); unart.Interrompu = dataRow[5].ToString(); DetailsCde unDetail = new DetailsCde(unart, dataRow[6].ToString(), dataRow[7].ToString()); mesDetails.Add(unDetail); } return mesDetails; } catch (MonException erreur) { throw erreur; } }