private void f_debiteur_Load(object sender, EventArgs e)
{
//lb_entreprise.Text = uf.ValeurParCond(comrealvista, "fact_entreprise entreprise left join " + Fmain.baseInit + ".client clidelta ON clidelta.idclient = entreprise.iddeltareal", "if (entreprise.iddeltareal > 0, concat(clidelta.socligne1, ' ', clidelta.socligne2), concat(entreprise.socligne1, ' ', entreprise.socligne2)) as entreprise", "entreprise", "identreprise = " + Fmain.identreprisesel);
uf.initialisation(p_affiche);
string sz = "SELECT idCity, zip, cityname FROM " + Fmain.baseInit + ".City ORDER BY Zip";
comrealvista.CommandText = sz;
MySqlDataReader myReader;
myReader = comrealvista.ExecuteReader();
while (myReader.Read())
{
npa.charger(myReader.GetValue(myReader.GetOrdinal("zip")).ToString(),
myReader.GetValue(myReader.GetOrdinal("cityname")).ToString(),
myReader.GetValue(myReader.GetOrdinal("idcity")).ToString());
ville.charger(myReader.GetValue(myReader.GetOrdinal("cityname")).ToString(),
myReader.GetValue(myReader.GetOrdinal("zip")).ToString(),
myReader.GetValue(myReader.GetOrdinal("idcity")).ToString());
}
ville.drom.dataGridView1.Sort(ville.drom.dataGridView1.Columns[0], System.ComponentModel.ListSortDirection.Ascending);
myReader.Close();
uf.RemplirCombo(politesse, "SELECT politesse, idpolitesse FROM " + Fmain.baseInit + ".typepolitesse ORDER by idlangue, idpolitesse", comrealvista, mySqlDataAdapter1);
reqdon = "select cli.idclient as refclient, socligne as raisonsociale, pol.idlangue as idlanguage, lang.language as language, " +
"cli.idpolitesse as idpolitesse, pol.politesse as politesse, cli.nom, cli.prenom, cli.co, " +
"cli.adresse1 as adresse1, cli.adresse2 as adresse2, city.zip as npa, city.cityname as ville, " +
"cli.idville as idville, cli.telpro as telpro, cli.telmob as telmob, " +
"cli.fax as fax, cli.email as email " +
"FROM fact_client cli " +
"LEFT join " + Fmain.baseInit + ".typepolitesse pol ON pol.idpolitesse = cli.idpolitesse LEFT join " + Fmain.baseInit + ".language lang ON lang.idlanguage = pol.idlangue " +
"left join " + Fmain.baseInit + ".city ON city.idcity = cli.idville " +
"ORDER BY idclient, nom, prenom, socligne";
reqarch = reqdon.Replace("fact_client", "fact_clientarchive").Replace("select", "select cli.idarchive as refarchive, cli.datearchive, ");
if (etatrech == 0 && etatajoutimport == 0)
{
affichedonnees(reqdon);
}
else if (etatajoutimport > 0)
{
recherche(false, "", ((f_importation)fImport).GetDonnee("socligne"), ((f_importation)fImport).GetDonnee("nom"), ((f_importation)fImport).GetDonnee("prenom"), "", ((f_importation)fImport).GetDonnee("zip"));
//recherche noprenom, soclign si existe. Si resultat, remplir grille par recherche, sinon ajout
if (gv_client.RowCount == 0)
{
AfficherDonneesAjout(true);
bt_valider_Click(bt_valider, new EventArgs());
}
else
{
AfficherDonneesAjout(false);
}
}
}
private void f_marchandises_Load(object sender, EventArgs e)
{
uf.initialisation(p_affiche);
//remplir les combos
//uf.RemplirCombo(client, "SELECT if (entreprise.iddeltareal > 0, concat(clidelta.socligne1, ' ', clidelta.socligne2), concat(entreprise.socligne1, ' ', entreprise.socligne2)) as entreprise, entreprise.identreprise FROM fact_entreprise entreprise left join " + Fmain.baseInit + ".client clidelta ON clidelta.idclient = entreprise.iddeltareal ORDER BY entreprise.identreprise ", comrealvista, mySqlDataAdapter1);
lb_entreprise.Text = uf.ValeurParCond(comrealvista, "fact_entreprise entreprise left join " + Fmain.baseInit + ".client clidelta ON clidelta.idclient = entreprise.iddeltareal", "if (entreprise.iddeltareal > 0, concat(clidelta.socligne1, ' ', clidelta.socligne2), concat(entreprise.socligne1, ' ', entreprise.socligne2)) as entreprise", "entreprise", "identreprise = " + Fmain.identreprisesel);
uf.RemplirCombo(unite, "SELECT unitecode, unitelibelle, idunite FROM fact_unite ORDER BY unitecode", comrealvista, mySqlDataAdapter1);
reqdon = "select idarticle, codearticle, descriptif_ligne1, descriptif_ligne2, descriptif_ligne3, descriptif_ligne4, descriptif_ligne5, " +
"remarque, concat(unitecode, ' ', unitelibelle) as unite, fact_unite.idunite as idunite FROM fact_articles " +
//"LEFT JOIN fact_entreprise entreprise ON entreprise.identreprise = fact_articles.identreprise AND entreprise.identreprise =" + Fmain.identreprisesel + " " +
//"left join " + Fmain.baseInit + ".client clidelta ON clidelta.idclient = entreprise.iddeltareal " +
"LEFT JOIN fact_unite ON fact_unite.idunite = fact_articles.idunite WHERE fact_articles.identreprise =" + Fmain.identreprisesel + " ORDER BY codearticle";
//uf.afficherInfo(this, reqdon, comrealvista, gv_article, "");
//if (gv_article.RowCount > 0)
// uf.afficherInfo(this, reqdon.Replace("ORDER", "WHERE idarticle =" + gv_article.Rows[0].Cells["g_idarticle"].Value.ToString() + " ORDER"), comrealvista, null, "");
affichedonnees();
//uf.enablecontrol(p_affiche, "2", false);
//uf.enablemulticontrol(p_button, "1", "2,3");
}
private void f_client_Load(object sender, EventArgs e)
{
uf.initialisation(p_client);
string sz = "SELECT idCity, zip, cityname FROM " + Fmain.baseInit + ".City ORDER BY Zip";
comrealvista.CommandText = sz;
MySqlDataReader myReader;
myReader = comrealvista.ExecuteReader();
while (myReader.Read())
{
npa.charger(myReader.GetValue(myReader.GetOrdinal("zip")).ToString(),
myReader.GetValue(myReader.GetOrdinal("cityname")).ToString(),
myReader.GetValue(myReader.GetOrdinal("idcity")).ToString());
ville.charger(myReader.GetValue(myReader.GetOrdinal("cityname")).ToString(),
myReader.GetValue(myReader.GetOrdinal("zip")).ToString(),
myReader.GetValue(myReader.GetOrdinal("idcity")).ToString());
}
ville.drom.dataGridView1.Sort(ville.drom.dataGridView1.Columns[0], System.ComponentModel.ListSortDirection.Ascending);
myReader.Close();
uf.RemplirCombo(tauxtva, "SELECT idtva as idtauxtva, taux, desctva, concat(taux, '>', desctva) as tva FROM typetva order by idtva", comrealvista, mySqlDataAdapter1);
uf.RemplirCombo(monnaie, "SELECT idmonnaie, monnaie FROM fact_monnaie ORDER by (idmonnaie='F') DESC", comrealvista, mySqlDataAdapter1);
uf.RemplirCombo(politesse, "SELECT politesse, idpolitesse FROM " + Fmain.baseInit + ".typepolitesse ORDER by idlangue, idpolitesse", comrealvista, mySqlDataAdapter1);
//uf.RemplirCombo(compte, "SELECT codecompte, idcompte FROM " + Fmain.baseInit + ".cpta_compte where codecompte like '25%' AND length(codecompte) > 3 ORDER BY codecompte ", comrealvista, mySqlDataAdapter1);
//uf.remplircombo(language, comrealvista, "SELECT language, idlanguage FROM " + Fmain.baseInit + ".language ORDER by idlanguage");
reqdon = Fmain.reqdoncli;
uf.afficherInfo(this, reqdon, comrealvista, g_client, "");
annule();
/*
* //sz = sz.Replace("ORDER", "WHERE idarticle =" + g_article.Rows[0].Cells["g_idarticle"].Value.ToString() + " ORDER");
* if (g_client.RowCount > 0)
* {
* uf.afficherInfo(p_client, reqdon.Replace("ORDER", "WHERE client.identreprise =" + g_client.Rows[0].Cells["g_refentreprise"].Value.ToString() + " ORDER"), comrealvista, null, "");
* chargertypeadr(false, g_client.Rows[0].Cells["g_refentreprise"].Value.ToString(), "");
* if (l_adresses.Items.Count > 0)
* {
* l_adresses.SelectedIndex = 0;
* afficheadresse(g_client.Rows[0].Cells["g_refentreprise"].Value.ToString(), "");
* }
* affichefrais(g_client.CurrentRow.Cells["g_refentreprise"].Value.ToString());
* affichecommentaire(g_client.CurrentRow.Cells["g_refentreprise"].Value.ToString());
* }
* else
* {
* uf.enablecontrol(p_adresse, "2", false);
* uf.enablecontrol(p_adresse, "4", false);
*
* }
* //affichedonnees();
* //uf.enablecontrol(p_affiche, "2", false);
* //uf.enablemulticontrol(p_button, "1", "2,3");
*
* uf.enablemulticontrol(p_button, "1", "2");
* uf.enablecontrol(p_client, "2", false);
* uf.enablecontrol(p_client, "3", false);
* uf.enablecontrol(p_client, "12", false);
* uf.enablecontrol(p_client, "8", false);
* pub.Enabled = false;
* if (g_client.RowCount == 0)
* bt_modif.Enabled = bt_suppr.Enabled = false;*/
}
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;
}
