private void cmbentreprise_SelectedIndexChanged(object sender, EventArgs e) { if (cmbentreprise.SelectedIndex > -1) { cmbentreprisesource.SelectedIndex = cmbentreprise.SelectedIndex; string sql = "SELECT fact_entreprise.*, typetva.taux as tauxtva, typetva.idtva FROM fact_entreprise LEFT JOIN typetva ON typetva.idtva = fact_entreprise.idtauxtva where identreprise =" + cmbentreprisesource.SelectedValue.ToString(); DeltaSQLCon.CommandText = sql; MySqlDataReader mr = DeltaSQLCon.ExecuteReader(); if (mr.Read()) { identreprisesel = cmbentreprisesource.SelectedValue.ToString(); decimal.TryParse(Util.GetValue(mr, "tauxtva"), out dtvachf); int.TryParse(Util.GetValue(mr, "echeance"), out iecheance); nombasecompta = Util.GetValue(mr, "basededonnees"); comptedebit = Util.GetValue(mr, "comptedebit"); compteb = Util.GetValue(mr, "compteb"); comptefacture = Util.GetValue(mr, "comptefacture"); } mr.Close(); } }
private void button5_Click(object sender, EventArgs e) { //connecter(); DeltaSQLCon.CommandText = "SELECT nomprenom, username, password, initials, idcollaborateur FROM " + baseInit + ".Collaborateur WHERE username = '******' AND password = '******'"; MySqlDataReader myReader = DeltaSQLCon.ExecuteReader(); if (myReader.Read()) { //var result = MessageBox.Show(myReader.GetString(myReader.GetOrdinal("nomprenom")) + ". Vous êtes connecté !"); Menu1.Enabled = true; ToolBar1.Enabled = true; panel1.Enabled = true; panel3.Visible = false; this.StatusLabel.Text = "Accès réussi de : " + myReader.GetString(myReader.GetOrdinal("nomprenom")) + "!"; lUser = myReader.GetString(myReader.GetOrdinal("nomprenom")); InitUser = myReader.GetString(myReader.GetOrdinal("initials")); idUser = myReader.GetInt32(myReader.GetOrdinal("idcollaborateur")); } else { Util.AfficherErreur("Attention ! Login ou Mot de pass incorrect ! Veuillez rééssayer !"); edUser.Focus(); myReader.Close(); return; } myReader.Close(); szU = Inif.ReadString("BDD", "user"); szH = Inif.ReadString("BDD", "Hostname"); szP = Inif.ReadString("BDD", "password"); //if (cb_base.SelectedIndex > 0) //{ bclosing = true; DeltaCon.Close(); DeltaConTmp1.Close(); deltaConTmp2.Close(); deltaConMod.Close(); string ConStr = "SERVER=" + Inif.ReadString("BDD", "hostname") + "; Allow User Variables=True; DATABASE=" + basefact + "; UID=" + Inif.ReadString("BDD", "user") + "; PASSWORD="******"BDD", "password") + "; PORT=" + Inif.ReadString("BDD", "port") + ";default command timeout=600;ConnectionTimeout=600"; DeltaCon.ConnectionString = DeltaConTmp1.ConnectionString = deltaConMod.ConnectionString = deltaConTmp2.ConnectionString = ConStr; Properties.Settings.Default["deltarealConnectionString"] = ConStr; bclosing = false; DeltaCon.Open(); DeltaConTmp1.Open(); deltaConTmp2.Open(); deltaConMod.Open(); myReader.Close(); Util.RemplirCombo(cmbentreprisesource, "SELECT identreprise, if (entreprise.iddeltareal > 0, concat(clidelta.socligne1, ' ', clidelta.socligne2), concat(entreprise.socligne1, ' ', entreprise.socligne2)) as entreprise FROM fact_entreprise entreprise left join " + baseInit + ".client clidelta ON clidelta.idclient = entreprise.iddeltareal ORDER BY identreprise", DeltaSQLCon, mySqlDataAdapter1); if (cmbentreprisesource.Items.Count == 0) { Util.AfficherErreur("Il n'y a pas encore d'entreprise enregistré ! Veuillez vérifier."); bt_marchandises.Enabled = bt_debiteur.Enabled = bt_facture.Enabled = false; } else { for (int i = 0; i < cmbentreprisesource.Items.Count; i++) { cmbentreprise.Items.Add(cmbentreprisesource.GetItemText(cmbentreprisesource.Items[i])); } cmbentreprise.SelectedItem = cmbentreprise.Items[0]; } this.Text = "DeltaFact v.1.2" + " - Base : " + basefact + " - Entreprise : " + cmbentreprisesource.Text; }