+ if (this->m_DB->open() && !this->m_DB->tables().empty())
+ {
+ this->m_DbPath = db;
+ this->LoadStudies();
+ return true;
+ }
+
+ this->m_DB->close();
+ this->m_StatusLabel->setText(QString("Status: DB NOT connected!"));
+ return false;
+}
+
+void QtDicomBrowser::LoadStudies()
+{
+ if (this->m_DB->isOpen())
+ {
+ if (this->m_StudiesModel)
+ {
+ delete this->m_StudiesModel;
+ }
+
+ this->m_StudiesModel = new QSqlQueryModel();
+ this->m_StudiesModel->setQuery("SELECT Studies.StudyInstanceUID, Studies.StudyDate as Date, Studies.StudyDescription as Description, Patients.PatientsName as Name, Patients.PatientsBirthDate as 'Birth date' from Patients,Studies where Patients.UID = Studies.PatientsUID");
+ QString query("SELECT Series.SeriesInstanceUID, Series.SeriesNumber as Number, Series.SeriesDate as Date, Series.SeriesDescription as Description from Series where Series.StudyInstanceUID = '");