Редакция 48 | Редакция 54 | К новейшей редакции | Только различия | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 48 | Редакция 51 | ||
---|---|---|---|
1 | #include "mymodel.h"
|
1 | #include "mymodel.h"
|
2 | 2 | ||
3 | MyModel::MyModel(QObject *parent) : |
3 | MyModel::MyModel(QObject *parent) : |
4 | QSqlTableModel(parent) |
4 | QSqlTableModel(parent) |
5 | {
|
5 | {
|
6 | setEditStrategy(QSqlTableModel::OnManualSubmit); |
6 | setEditStrategy(QSqlTableModel::OnManualSubmit); |
7 | }
|
7 | }
|
8 | 8 | ||
9 | Qt::ItemFlags MyModel::flags( |
9 | Qt::ItemFlags MyModel::flags( |
10 | const QModelIndex &index) const { |
10 | const QModelIndex &index) const { |
11 | Qt::ItemFlags flags = QSqlTableModel::flags(index); |
11 | Qt::ItemFlags flags = QSqlTableModel::flags(index); |
12 | if (index.column() != 3) |
12 | if ((index.column() != 3) && (index.column() != 0)) |
13 | flags |= Qt::ItemIsEditable; |
13 | flags |= Qt::ItemIsEditable; |
14 | //if (index.column() == 4)
|
14 | //if (index.column() == 4)
|
15 | // flags |= Qt::ItemIsUserCheckable;
|
15 | // flags |= Qt::ItemIsUserCheckable;
|
- | 16 | else
|
|
- | 17 | {
|
|
16 | else flags &= ~Qt::ItemIsEditable; // çàïðåùàåì ðåäàêòèðîâàíèå òðåòüåãî ñòîëáöà |
18 | if ((index.column() == 3) || (index.column() == 0)) flags &= ~Qt::ItemIsEditable; // çàïðåùàåì ðåäàêòèðîâàíèå òðåòüåãî ñòîëáöà |
- | 19 | }
|
|
17 | return flags; |
20 | return flags; |
18 | }
|
21 | }
|
19 | 22 | ||
20 | 23 | ||
21 | bool MyModel::setData(const QModelIndex &index, const QVariant &value, int role) { |
24 | bool MyModel::setData(const QModelIndex &index, const QVariant &value, int role) { |
- | 25 | if (index.column()==3) return false; // â òðåòüåé êîëîíêå íå äàåì ïîìåíÿòü çíà÷åíèå |
|
22 | bool lResult = false; |
26 | bool lResult = false; |
- | 27 | ||
- | 28 | /*
|
|
- | 29 | QString str_tmp;
|
|
- | 30 | if (index.column()==1) { // åñëè ìåíÿåì èìÿ êëàññà
|
|
- | 31 | str_tmp = value.toString(); // òî ïîìåíÿåì è èìÿ òàáëèöû
|
|
- | 32 | str_tmp.append(tr(" instance"));
|
|
- | 33 | }
|
|
- | 34 | */
|
|
- | 35 | ||
23 | lResult = QSqlTableModel::setData(index, value, role); |
36 | lResult = QSqlTableModel::setData(index, value, role); |
24 | if (lResult) { |
37 | if (lResult) { |
- | 38 | QModelIndex newindex;
|
|
25 | QSqlRecord rec = record(index.row()); |
39 | QSqlRecord rec = record(index.row()); |
- | 40 | ||
26 | rec.setValue(index.column(), value); |
41 | rec.setValue(index.column(), value); |
27 | rec.setGenerated(index.column(), true); |
42 | rec.setGenerated(index.column(), true); |
- | 43 | ||
- | 44 | /*
|
|
- | 45 | if (index.column()==1){
|
|
- | 46 | rec.setValue(index.column()+2, QVariant(str_tmp));
|
|
- | 47 | rec.setGenerated(index.column()+2, true);
|
|
- | 48 | newindex = MyModel::index(index.row(), index.column()+2);
|
|
- | 49 | QSqlTableModel::setData(newindex, QVariant(str_tmp), Qt::EditRole);
|
|
- | 50 | }
|
|
- | 51 | */
|
|
- | 52 | ||
- | 53 | ||
28 | lResult = updateRowInTable(index.row(), rec); |
54 | lResult = updateRowInTable(index.row(), rec); |
- | 55 | ||
- | 56 | ||
29 | }
|
57 | }
|
30 | return lResult; |
58 | return lResult; |
31 | }
|
59 | }
|
- | 60 | ||
- | 61 | ||
- | 62 | ||
- | 63 | QVariant MyModel::data(const QModelIndex &index, int role) const { |
|
- | 64 | ||
- | 65 | QVariant value = QSqlTableModel::data(index, role); |
|
- | 66 | switch (role) { |
|
- | 67 | case Qt::DisplayRole: return value; |
|
- | 68 | case Qt::EditRole: return value; |
|
- | 69 | case Qt::TextColorRole: |
|
- | 70 | if(index.column() == 1) |
|
- | 71 | return qVariantFromValue(QColor(Qt::blue)); |
|
- | 72 | else
|
|
- | 73 | return value; |
|
- | 74 | case Qt::TextAlignmentRole: return value; |
|
- | 75 | case Qt::FontRole: |
|
- | 76 | if(index.column() == 1) { |
|
- | 77 | QFont font = QFont("Helvetica", 16, QFont::Bold); |
|
- | 78 | return qVariantFromValue(font); |
|
- | 79 | }else |
|
- | 80 | return value; |
|
- | 81 | ||
- | 82 | case Qt::BackgroundColorRole: { |
|
- | 83 | int a = (index.row() % 2) ? 14 : 0; |
|
- | 84 | if(index.column() == 2) |
|
- | 85 | return qVariantFromValue(QColor(220,240-a,230-a)); |
|
- | 86 | else if(index.column() == 4) |
|
- | 87 | return qVariantFromValue(QColor(200,220-a,255-a)); |
|
- | 88 | else
|
|
- | 89 | return value; |
|
- | 90 | }
|
|
- | 91 | ||
- | 92 | ||
- | 93 | ||
- | 94 | case Qt::CheckStateRole: return value; |
|
- | 95 | ||
- | 96 | case Qt::SizeHintRole:return value; |
|
- | 97 | ||
- | 98 | }
|
|
- | 99 | return value; |
|
- | 100 | }
|
|
- | 101 | ||
32 | 102 |