コード例 #1
0
        public static List <DisciplineSet> getDisciplineSetsByDiscipline(Discipline discipline)
        {
            List <Dictionary <string, object> > results = querySql(""
                                                                   + "SELECT "
                                                                   + "* "
                                                                   + "FROM "
                                                                   + "`" + tableName + "` "
                                                                   + "WHERE "
                                                                   + "`" + field_disciplineId + "` = " + discipline.DisciplineId
                                                                   );

            List <DisciplineSet> disciplineSets = new List <DisciplineSet>();

            foreach (var row in results)
            {
                disciplineSets.Add(DisciplineSetProvider.getDisciplineSetById(Convert.ToInt32(row[field_disciplineSetId])));
            }

            return(disciplineSets);
        }