/// <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))); }