#include <QtGui>
#include <QtOpenGL>
#include <QtSql>
#include "mainwindow.h"
#include "glwidget.h"
#include "customsqlmodel.h" //CustomSqlModel
MainWindow
::MainWindow(QWidget *parent
){
setupUi(this);
setWindowIcon
(QIcon(":/images/triple20.png"));
connect(actionInfo, SIGNAL(triggerred()), this, SLOT(info()));
connect(actionTriple_S, SIGNAL(triggered()), this, SLOT(triple()));
connect(actionAfsluiten, SIGNAL(triggered()), this, SLOT(exit()));
connect(pbVerzend, SIGNAL(clicked()), this, SLOT(verzend()));
connect(pbVerbind, SIGNAL(clicked()), this, SLOT(verbind()));
model = new CustomSqlModel(this);
model->setTable("planning");
model->select();
model->setHeaderData(0, Qt::Horizontal, tr("Categorie")); //HeaderLabels
model->setHeaderData(1, Qt::Horizontal, tr("Klant"));
model->setHeaderData(2, Qt::Horizontal, tr("Plaats"));
model->setHeaderData(3, Qt::Horizontal, tr("Geschat pot"));
model->setHeaderData(4, Qt::Horizontal, tr("Bezocht"));
model->setHeaderData(5, Qt::Horizontal, tr("Planning"));
view->setModel(model);
// etc....
}
#include <QtGui>
#include <QtOpenGL>
#include <QtSql>
#include "mainwindow.h"
#include "glwidget.h"
#include "customsqlmodel.h" //CustomSqlModel
MainWindow::MainWindow(QWidget *parent)
:QMainWindow(parent)
{
setupUi(this);
setWindowIcon(QIcon(":/images/triple20.png"));
connect(actionInfo, SIGNAL(triggerred()), this, SLOT(info()));
connect(actionTriple_S, SIGNAL(triggered()), this, SLOT(triple()));
connect(actionAfsluiten, SIGNAL(triggered()), this, SLOT(exit()));
connect(pbVerzend, SIGNAL(clicked()), this, SLOT(verzend()));
connect(pbVerbind, SIGNAL(clicked()), this, SLOT(verbind()));
model = new CustomSqlModel(this);
model->setTable("planning");
model->setEditStrategy(QSqlTableModel::OnManualSubmit);
model->select();
model->setHeaderData(0, Qt::Horizontal, tr("Categorie")); //HeaderLabels
model->setHeaderData(1, Qt::Horizontal, tr("Klant"));
model->setHeaderData(2, Qt::Horizontal, tr("Plaats"));
model->setHeaderData(3, Qt::Horizontal, tr("Geschat pot"));
model->setHeaderData(4, Qt::Horizontal, tr("Bezocht"));
model->setHeaderData(5, Qt::Horizontal, tr("Planning"));
view->setModel(model);
// etc....
}
To copy to clipboard, switch view to plain text mode
My CustomSqlModel see code snippet h file.
#ifndef CUSTOMSQLMODEL_H
#define CUSTOMSQLMODEL_H
#include <QSqlTableModel>
#include <QVariant>
#include <QModelIndex>
{
Q_OBJECT
public:
CustomSqlModel
(QObject *parent
= 0);
QVariant headerdata
(int section, Qt
::Orientation orientation,
int role
= Qt
::BackgroundColorRole) const;
//int rowCount(const QModelIndex &parent = QModelIndex()) const;
};
#endif
#ifndef CUSTOMSQLMODEL_H
#define CUSTOMSQLMODEL_H
#include <QSqlTableModel>
#include <QVariant>
#include <QModelIndex>
class CustomSqlModel : public QSqlTableModel
{
Q_OBJECT
public:
CustomSqlModel(QObject *parent = 0);
QVariant data(const QModelIndex &item, int role) const;
QVariant headerdata(int section, Qt::Orientation orientation, int role = Qt::BackgroundColorRole) const;
//int rowCount(const QModelIndex &parent = QModelIndex()) const;
};
#endif
To copy to clipboard, switch view to plain text mode
#include <QtGui>
#include "customsqlmodel.h"
CustomSqlModel
::CustomSqlModel(QObject *parent
){
}
{
if (role == Qt::BackgroundColorRole && index.column() == 0)
{
return qVariantFromValue
(QColor(Qt
::gray));
}
// etc....
return val0;
}
QVariant CustomSqlModel
::headerdata(int section, Qt
::Orientation orientation,
int role
) const {
if(role == Qt::BackgroundColorRole)
{
}
}
#include <QtGui>
#include "customsqlmodel.h"
CustomSqlModel::CustomSqlModel(QObject *parent)
: QSqlTableModel(parent)
{
}
QVariant CustomSqlModel::data(const QModelIndex &index, int role) const
{
QVariant val0 = QSqlTableModel::data(index, role);
if (role == Qt::BackgroundColorRole && index.column() == 0)
{
return qVariantFromValue(QColor(Qt::gray));
}
// etc....
return val0;
}
QVariant CustomSqlModel::headerdata(int section, Qt::Orientation orientation, int role) const
{
if(role == Qt::BackgroundColorRole)
{
return (QColor(Qt::yellow));
}
return QVariant();
}
To copy to clipboard, switch view to plain text mode
Bookmarks