Как QSqlTableModel перевести в QString или распечатать

Question

Михаиллл

Jan. 2, 2019, 6:06 p.m.

Как QSqlTableModel перевести в QString или распечатать

qt, QSqlTableModel, QString

Здравствуйте.
Как QSqlTableModel перевести в QString или распечатать?

We recommend hosting TIMEWEB

Stable hosting, on which the social network EVILEG is located. For projects on Django we recommend VDS hosting.

Subscribe to the discussion2

Section subscription252

Do you like it? Share on social networks!

706

1

0

Jan. 2, 2019, 6:28 p.m.

Модель на печать не выводил а вот содержимое QTavleView выводил так.

void MainWindow::slotPrintTavleView(QTableView *tblView)
{
    // make a html-dump of table view
    QString printStr;
        if (tblView) {
 
            QTextStream out(&printStr);
 
            const int rowCount = tblView->model()->rowCount();
            const int columnCount = tblView->model()->columnCount();
 
            out <<  "<html>\n"
                    "<head>\n"
                    "<meta Content=\"Text/html; charset=utf-8\">\n"
                <<  QString("<title>%1</title>\n").arg("refTitleName")
                <<  "</head>\n"
                    "<body bgcolor=#ffffff link=#5000A0>\n"
                    "<table border=1 cellspacing=0 cellpadding=2>\n";
 
            // headers
            out << "<tr bgcolor=#f0f0f0>";
            for (int column = 0; column < columnCount; column++)
                if (!tblView->isColumnHidden(column))
                    out << QString("<th>%1</th>").arg(tblView->model()->headerData(column, Qt::Horizontal).toString());
            out << "</tr>\n";
            for (int row = 0; row < rowCount; row++) {
                out << "<tr>";
                for (int column = 0; column < columnCount; column++) {
                    if (!tblView->isColumnHidden(column)) {
                        QString data = tblView->model()->data(tblView->model()->index(row, column)).toString().simplified();
 
                        out << QString("<td bkcolor=0>%1</td>").arg((!data.isEmpty()) ? data : QString("&nbsp;"));
                    }
                }
                out << "</tr>\n";
            }
            out <<  "</table>\n"
                "</body>\n"
                "</html>\n";
        }
        document = new QTextDocument();
 
        document->setHtml(printStr);
 
 
 
 
            QPrintPreviewDialog  *prDialog = new QPrintPreviewDialog(&printer, this);
            connect(prDialog,SIGNAL(paintRequested(QPrinter*)),this,SLOT(printPreviewNeeds(QPrinter*)));
 
        prDialog->showMaximized();
        prDialog->exec();
}
 
void MainWindow::printPreviewNeeds(QPrinter *)
{
    document->print(&printer);
//    delete document;
}

Как QSqlTableModel перевести в QString или распечатать

We recommend hosting TIMEWEB

Comments

Actions