/// <summary>
/// Gets the liste equipes for ddl.
/// </summary>
/// <returns>The liste equipes for ddl.</returns>
public List <objDropDownListItem> getListeEquipesForDDL()
{
List <objDropDownListItem> result = new List <objDropDownListItem>();
try
{
string requete = "select Id, Libelle, ordre ";
requete = requete + "from tblEquipe where isActif=1 order by ordre";
// Création d'un premier élément null à mettre au début de la liste de valeurs
objDropDownListItem objetNull = new objDropDownListItem();
objetNull.ID = -1;
objetNull.VALEUR_STRING = "";
objetNull.Ordre = 1;
DataTable data = db.recupererDonnees(requete);
result.Add(objetNull);
for (int i = 0; i < data.Rows.Count; i++)
{
DataRow dr = data.Rows[i];
objDropDownListItem objet = new objDropDownListItem();
objet.ID = Convert.ToInt32(dr[0]);
objet.VALEUR_STRING = Convert.ToString(dr[1]);
objet.Ordre = Convert.ToInt32(dr[2]);
result.Add(objet);
}
}
catch (Exception e)
{
Commons.Logger.genererErreur(typeof(EquipeDAL), e.ToString());
}
return(result);
}
/// <summary>
/// Gets the liste categories document for ddl.
/// </summary>
/// <returns>The liste categories document for ddl.</returns>
public List <objDropDownListItem> getListeCategoriesDocumentForDDL()
{
List <objDropDownListItem> result = new List <objDropDownListItem>();
try
{
string requete = "select c.Id, c.Libelle, c.ordre,m.libelle ";
requete = requete + "from tblCategorieDocument c";
requete = requete + " left join tblCategorieDocument m on c.idCategorieDocumentPere=m.id ";
requete = requete + " where 0=(select count(*) from tblCategorieDocument c2";
requete = requete + " where c2.idCategorieDocumentPere=c.Id) ";
requete = requete + "order by m.ordre,c.ordre";
DataTable data = db.recupererDonnees(requete);
for (int i = 0; i < data.Rows.Count; i++)
{
DataRow dr = data.Rows[i];
objDropDownListItem objet = new objDropDownListItem();
objet.ID = Convert.ToInt32(dr[0]);
objet.Ordre = Convert.ToInt32(dr[2]);
if (dr[3] == DBNull.Value)
{
objet.VALEUR_STRING = Convert.ToString(dr[1]);
}
else
{
objet.VALEUR_STRING = Convert.ToString(dr[3]) + " - " + Convert.ToString(dr[1]);
}
result.Add(objet);
}
}
catch (Exception e)
{
Commons.Logger.genererErreur(typeof(DocumentDAL), e.ToString());
}
return(result);
}
