/// <summary>
/// Permet d'énumrer les stuff_features liés à cette stuff
/// </summary>
/// <returns></returns>
public IEnumerable <StuffFeature> EnumererStuffFeature()
{
if (base.Connexion == null)
{
return(new StuffFeature[0]);
}
return(StuffFeature.Enumerer(Connexion, Connexion.Enumerer(
@"SELECT st_id, st_name,
stf_id, stf_value,
fe_id, fe_name
FROM stuff
INNER JOIN stuff_feature on st_id = stf_fk_stuff_id
INNER JOIN feature on fe_id = stf_fk_feature_id
WHERE st_id = {0}",
Id)));
}
public IEnumerable <StuffFeature> EnumererStuffFeature(MyDB.CodeSql ValeurSouhaitee, MyDB.CodeSql ClauseJoin, MyDB.CodeSql ClauseWhere, MyDB.CodeSql ClauseOrderBy)
{
if (ClauseWhere == null)
{
ClauseWhere = MyDB.CodeSql.Vide;
}
if (ClauseOrderBy == null)
{
ClauseOrderBy = MyDB.CodeSql.Vide;
}
if (ClauseJoin == null)
{
ClauseJoin = MyDB.CodeSql.Vide;
}
if (ValeurSouhaitee == null)
{
ValeurSouhaitee = new MyDB.CodeSql("*");
}
return(StuffFeature.Enumerer(m_BD, m_BD.Enumerer("SELECT {0} FROM {1} {2} {3} {4}", ValeurSouhaitee, c_NomTable_StuffFeature, ClauseJoin, ClauseWhere, ClauseOrderBy)));
}