//chercher une liste de fonction selon un critére public void chercher_ListeDepartement(String critere, out String erreur, out List <Departement_Class> list, out String dbb, out Boolean exist) { erreur = null; dbb = ""; list = new List <Departement_Class>(); Departement_Class dep = new Departement_Class(); exist = false; rsql = "select * from DEPARTEMENT " + critere; cnx.select(rsql, out erreur, out dr); if (erreur == null) { if (dr.HasRows == true) { exist = true; while (dr.Read()) { dep = new Departement_Class(); dep.ID_DEP = dr.GetString(0); dep.DESG_Dep = dr.GetString(1); dep.RESPONSABLE = dr.GetString(2); dep.Seuuuilee = dr.GetInt32(3); list.Add(dep); } dr.Close(); } } }
public void chercher_Departement3(String id, out string erreur, out string nom, out int seuil, out string rsp, out Boolean exist) { erreur = null; rsp = ""; Departement_Class fn = new Departement_Class(); nom = null; exist = false; seuil = 0; rsql = "select * from DEPARTEMENT where DEPARTEMENT.ID_DEPARTMENT='" + id + "' "; cnx.select(rsql, out erreur, out dr); if (erreur == null) { if (dr.HasRows == true) { exist = true; while (dr.Read()) { fn = new Departement_Class(); nom = fn.DESG_Dep = dr.GetString(1); rsp = dr.GetString(2); seuil = dr.GetInt32(3); } dr.Close(); } } }
public void modifier_DEPARTEMENT(Departement_Class dep, out String erreur) { erreur = null; //update DEPARTEMENT d set d.DESGN_DEPARTEMENT ='XX' ,d.REPONSABLE_DEP='Emp5' where d.ID_DEPARTMENT='D6' and not exists //(select 1 from DEPARTEMENT where 'Emp5' = REPONSABLE_DEP); rsql = "update DEPARTEMENT set DESGN_DEPARTEMENT ='" + dep.DESG_Dep + "',REPONSABLE_DEP='" + dep.RESPONSABLE + "',SEUILE_DEPARTEMENT='" + dep.Seuuuilee + "' where ID_DEPARTMENT='" + dep.ID_DEP + "' "; cnx.maj(rsql, out erreur); }
//chercher fonction public void Chercher_Departement(string id, out string erreur, out Departement_Class dep, out Boolean exist) { erreur = null; dep = new Departement_Class(); exist = false; rsql = "select * from DEPARTEMENT where DEPARTEMENT.ID_DEPARTMENT=" + id + " "; cnx.select(rsql, out erreur, out dr); if (erreur == null) { if (dr.HasRows == true) { exist = true; dr.Read(); dep.ID_DEP = dr.GetString(0); dep.DESG_Dep = dr.GetString(1); dep.RESPONSABLE = dr.GetString(2); dep.Seuuuilee = dr.GetInt32(3); } dr.Close(); } }
public void supprimer_DEPARTEMENT(Departement_Class dep, out String erreur) { erreur = null; rsql = "delete from DEPARTEMENT where ID_DEPARTMENT='" + dep.ID_DEP + "' "; cnx.maj(rsql, out erreur); }
public void ajouter_DEPARTEMENT(Departement_Class dep, out String erreur) { erreur = null; rsql = "insert into DEPARTEMENT values('" + dep.ID_DEP + "','" + dep.DESG_Dep + "','" + dep.RESPONSABLE + "','" + dep.Seuuuilee + "')"; cnx.maj(rsql, out erreur); }