void AppForm::primeUpdateQuery()
{
"!!! Here message !!!",
mb.setIconPixmap(exportSuccess);
/* It get the value of the QDataTable Current */
getCurrentItemIdSql = dataTable->currentRecord();
register int i = dataTable->currentRow();
if ( i == -1 ) i = 0; /* Always use the first row */
else if ( getCurrentItemIdSql )
{
switch( mb.exec() )
{
/* Now, it executes query for the exit of the occurrence */
queryUpdateSaida.prepare( QUERY_EXIT_OCCURRENCE "id_ocorrencia= :id_ocorrencia AND id_viatura= :id_viatura "
"AND id_cidade= :id_cidade ;" );
queryUpdateSaida.bindValue( ":id_ocorrencia", getCurrentItemIdSql->value("id_ocorrencia").toInt() );
queryUpdateSaida.bindValue( ":id_viatura", getCurrentItemIdSql->value("id_viatura").toString() );
queryUpdateSaida.bindValue( ":id_cidade", getCurrentItemIdSql->value("id_cidade").toInt() );
if ( queryUpdateSaida.exec() )
{
cout << "App ==> OK" << endl;
} else {
cout << "App ==> Error" << endl;
}
dataTable->refresh(QDataTable::RefreshData);
break;
dataTable->refresh(QDataTable::RefreshData);
break;
default:
cout << "App ==> Case default" << endl;
}
return;
}
}
void AppForm::primeUpdateQuery()
{
QMessageBox mb("App",
"!!! Here message !!!",
QMessageBox::NoIcon,
QMessageBox::Yes | QMessageBox::Default,
QMessageBox::Cancel, QMessageBox::Escape );
mb.setButtonText( QMessageBox::Yes, "Ok" );
mb.setButtonText( QMessageBox::Cancel, "Cancel" );
QPixmap exportSuccess( QPixmap::fromMimeSource( "message.png" ) );
mb.setIconPixmap(exportSuccess);
/* It get the value of the QDataTable Current */
QSqlRecord *getCurrentItemIdSql = new QSqlRecord();
getCurrentItemIdSql = dataTable->currentRecord();
register int i = dataTable->currentRow();
if ( i == -1 ) i = 0; /* Always use the first row */
else if ( getCurrentItemIdSql )
{
QSqlQuery queryUpdateSaida;
switch( mb.exec() )
{
case QMessageBox::Yes:
/* Now, it executes query for the exit of the occurrence */
queryUpdateSaida.prepare( QUERY_EXIT_OCCURRENCE "id_ocorrencia= :id_ocorrencia AND id_viatura= :id_viatura "
"AND id_cidade= :id_cidade ;" );
queryUpdateSaida.bindValue( ":id_ocorrencia", getCurrentItemIdSql->value("id_ocorrencia").toInt() );
queryUpdateSaida.bindValue( ":id_viatura", getCurrentItemIdSql->value("id_viatura").toString() );
queryUpdateSaida.bindValue( ":id_cidade", getCurrentItemIdSql->value("id_cidade").toInt() );
if ( queryUpdateSaida.exec() )
{
cout << "App ==> OK" << endl;
} else {
cout << "App ==> Error" << endl;
}
dataTable->refresh(QDataTable::RefreshData);
break;
case QMessageBox::Cancel:
dataTable->refresh(QDataTable::RefreshData);
break;
default:
cout << "App ==> Case default" << endl;
}
return;
}
}
To copy to clipboard, switch view to plain text mode
Bookmarks