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;
}
}
