"(`PatientName`, `Modality`, `StudyDate`, `SeriesNumber`, `InstanceNumber`, "
"`AnnotationNote`, `AnnotationData`, `AnnotationDate`) "
"VALUES ( :PATIENTNAME, :MODALITY, :STUDYDATE, :SERIESNUMBER, :INSTANCENUMBER,"
":ANNOTATIONNOTE, :IMAGE, :ANNOTATIONDATE") ;
//make query
query.prepare(sql);
query.bindValue(":PATIENTNAME", patientName);
query.bindValue(":MODALITY", modality);
query.bindValue(":STUDYDATE", studyDate);
query.bindValue(":SERIESNUMBER", seriesNumber);
query.bindValue(":INSTANCENUMBER", sliceNumber);
query.
bindValue(":ANNOTATIONNOTE",
QString(""));
query.bindValue(":IMAGE", ba);
query.
bindValue(":ANNOTATIONDATE",
QString("CURRENT_DATE()"));
if( query.exec(sql) == false )
{
QMessageBox::critical(this,
QString("Error in Query"), query.
lastError().
databaseText() );
return;
}
QString sql = QString( "INSERT INTO `Annotation` "
"(`PatientName`, `Modality`, `StudyDate`, `SeriesNumber`, `InstanceNumber`, "
"`AnnotationNote`, `AnnotationData`, `AnnotationDate`) "
"VALUES ( :PATIENTNAME, :MODALITY, :STUDYDATE, :SERIESNUMBER, :INSTANCENUMBER,"
":ANNOTATIONNOTE, :IMAGE, :ANNOTATIONDATE") ;
//make query
QSqlQuery query = QSqlQuery();
query.prepare(sql);
query.bindValue(":PATIENTNAME", patientName);
query.bindValue(":MODALITY", modality);
query.bindValue(":STUDYDATE", studyDate);
query.bindValue(":SERIESNUMBER", seriesNumber);
query.bindValue(":INSTANCENUMBER", sliceNumber);
query.bindValue(":ANNOTATIONNOTE", QString(""));
query.bindValue(":IMAGE", ba);
query.bindValue(":ANNOTATIONDATE", QString("CURRENT_DATE()"));
if( query.exec(sql) == false )
{
QMessageBox::critical(this, QString("Error in Query"), query.lastError().databaseText() );
return;
}
To copy to clipboard, switch view to plain text mode
Bookmarks