public Livraison(string code) { InitializeComponent(); facture.FindByKey(code); labelDateP.Text = facture.Date_Payement.ToLongDateString(); labelModeP.Text = facture.Mode_Payement; }
private void textBox1_KeyUp(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Escape) { this.Close(); } if (e.KeyCode == Keys.Enter) { if (facture.FindByKey(textBox1.Text)) { if ((facture.Etat == "Non Reglee") || (facture.Livree == "Non Livree")) { label9.Visible = false; Payement p = new Payement(textBox1.Text); p.ShowDialog(this.Owner); this.Close(); } else { label9.Visible = true; label9.Text = "Ticket Trouvee\nReglee le " + facture.Date_Payement.ToLongDateString() + "\n" + "Livree le " + facture.Date_livraison.ToLongDateString(); } } else { label9.Visible = true; label9.Text = "Numeros de Ticket non trouvee ...\nVERIFIEZ !"; } } }
public IndoFacture(string Code) { InitializeComponent(); Save = false; currentFacture = new TB_Facture(); currentFacture.FindByKey(Code); TextCodeFacture.Value = currentFacture.Code; TextAdresseClient.Value = currentFacture.Client.Adresse; TextTelClient.Value = currentFacture.Client.NTel; TextNomClient.Value = currentFacture.Client.Nom; TextPrenomClient.Value = currentFacture.Client.Prenom; NumericPrixAvance.Value = currentFacture.Prix_Partiel; NumericPrixTotal.Value = currentFacture.Prix_Total; DateRecuFacture.Value = currentFacture.Date_Recu; DateLivraisonFacutre.Value = currentFacture.Date_livraison; comboModePayement.Text = currentFacture.Mode_Payement; DB_PostgreSQL dataBase = new DB_PostgreSQL(); DataSet ARFAC = dataBase.returnDataSet("SELECT \"Code_Article\",\"Libelle\",\"Quantite\",\"Operation\",\"Prix\" FROM \"Articles\",\"Ar_Fac\" WHERE \"Ar_Fac\".\"Code_Facture\"='" + Code + "' AND" + "\"Articles\".\"Code\"=\"Ar_Fac\".\"Code_Article\""); c1TrueDBGrid1.DataSource = ARFAC.Tables[0]; DataSet Client = dataBase.returnDataSet("SELECT * FROM \"Client\""); c1Combo1.DataSource = Client.Tables[0]; c1Combo1.Text = currentFacture.Client.Code; c1Combo1.DisplayMember = "Code"; c1Label1.Value = currentFacture.Etat; c1Label2.Value = currentFacture.Livree; if (currentFacture.Livree == "Non Livree") { dateSortie.Visible = false; } else { dateSortie.Value = currentFacture.Date_livraison; } Npgsql.NpgsqlDataReader reader = dataBase.returnDataReader("SELECT * FROM \"Cheque\" WHERE \"Code_Facture\"='" + Code + "'"); if (reader.Read()) { comboBox1.Text = (string)reader["Banque"]; c1TextBox1.Value = (string)reader["Montant"]; c1TextBox2.Value = (string)reader["Num"]; c1DateEdit1.Value = (DateTime)reader["Date"]; } }
public Payement(string Code) { facture.FindByKey(Code); InitializeComponent(); labelclient.Text = facture.Client.Nom + " " + facture.Client.Prenom; labelTel.Text = facture.Client.NTel; labelDateRecu.Text = facture.Date_Recu.ToShortDateString(); labelAdresse.Text = facture.Client.Adresse; labelTotal.Text = facture.Prix_Total.ToString(); labelPrixPaye.Text = facture.Prix_Partiel.ToString(); labelTotalPaye.Text = (facture.Prix_Total - facture.Prix_Partiel).ToString(); List <ListAF> s = ListAF.GetList(facture.Code); foreach (ListAF a in s) { listBox1.Items.Add(a.article.Libelle + "\t" + a.article.Famille.Libelle + "\t x" + a.Quantite + "\t" + a.Operation + "\t" + a.Prix + " TND"); } }