/// <summary>
/// Permet d'énumrer les figurines_stuff liés à cette figurine
/// </summary>
/// <returns></returns>
public IEnumerable <FigurineStuff> EnumererFigurineStuff()
{
if (base.Connexion == null)
{
return(new FigurineStuff[0]);
}
return(FigurineStuff.Enumerer(Connexion, Connexion.Enumerer(
@"SELECT fi_id, fi_name,
fs_id,
st_id, st_name
FROM figurine
INNER JOIN figurine_stuff on fi_id = fs_fk_figurine_id
INNER JOIN stuff on st_id = fs_fk_stuff_id
WHERE fi_id = {0}",
Id)));
}
public IEnumerable <FigurineStuff> EnumererFigurineStuff(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(FigurineStuff.Enumerer(m_BD, m_BD.Enumerer("SELECT {0} FROM {1} {2} {3} {4}", ValeurSouhaitee, c_NomTable_FigurineStuff, ClauseJoin, ClauseWhere, ClauseOrderBy)));
}
