12931294129512961297129812991300130113021303
Session session = null; try { session = openSession(); Query q = session.createQuery(sql); if (!pagination) { list = (List<LFQuiz>) QueryUtil.list(q, getDialect(), start, end, false);
13511352135313541355135613571358135913601361
Session session = null; try { session = openSession(); Query q = session.createQuery(_SQL_COUNT_LFQUIZ); count = (Long) q.uniqueResult(); FinderCacheUtil.putResult(FINDER_PATH_COUNT_ALL, FINDER_ARGS_EMPTY, count);
242243244245246247248249250251252
Session session = null; try { session = openSession(); Query q = session.createQuery(sql); QueryPos qPos = QueryPos.getInstance(q); if (authorID != null) { qPos.add(authorID.intValue());
578579580581582583584585586587588
10441045104610471048104910501051105210531054
Session session = null; try { session = openSession(); Query q = session.createQuery(sql); if (!pagination) { list = (List<LFSocialPackage>) QueryUtil.list(q, getDialect(), start, end, false);
11021103110411051106110711081109111011111112
Session session = null; try { session = openSession(); Query q = session.createQuery(_SQL_COUNT_LFSOCIALPACKAGE); count = (Long) q.uniqueResult(); FinderCacheUtil.putResult(FINDER_PATH_COUNT_ALL, FINDER_ARGS_EMPTY, count);
270271272273274275276277278279280
Session session = null; try { session = openSession(); Query q = session.createQuery(sql); QueryPos qPos = QueryPos.getInstance(q); if (assetRefID != null) { qPos.add(assetRefID.longValue());
368369370371372373374375376377378
501502503504505506507508509510511
Session session = null; try { session = openSession(); Query q = session.createQuery(sql); QueryPos qPos = QueryPos.getInstance(q); if (courseID != null) { qPos.add(courseID.intValue());
921922923924925926927928929930931
Session session = null; try { session = openSession(); Query q = session.createQuery(sql); QueryPos qPos = QueryPos.getInstance(q); if (courseIDs != null) { for (Integer courseID : courseIDs) {