Редакция 161 | Редакция 166 | К новейшей редакции | Только различия | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
| Редакция 161 | Редакция 165 | ||
|---|---|---|---|
| 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) && (index.column() != 0) && (index.column() != 5)) |
12 | if ((index.column() != 3) && (index.column() != 0) /* && (index.column() != 5)*/) |
| 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
|
16 | else
|
| 17 | {
|
17 | {
|
| 18 | if ((index.column() == 3) || (index.column() == 0) || (index.column() == 5)) flags &= ~Qt::ItemIsEditable; // çàïðåùàåì ðåäàêòèðîâàíèå 0, 3 è 5 ñòîëáöà |
18 | if ((index.column() == 3) || (index.column() == 0) /* || (index.column() == 5)*/) flags &= ~Qt::ItemIsEditable; // çàïðåùàåì ðåäàêòèðîâàíèå 0, 3 è 5 ñòîëáöà |
| 19 | }
|
19 | }
|
| 20 | return flags; |
20 | return flags; |
| 21 | }
|
21 | }
|
| 22 | 22 | ||
| 23 | 23 | ||
| 24 | 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; // â òðåòüåé êîëîíêå íå äàåì ïîìåíÿòü çíà÷åíèå
|
25 | //// if (index.column()==3) return false; // â òðåòüåé êîëîíêå íå äàåì ïîìåíÿòü çíà÷åíèå
|
| 26 | bool lResult = false; |
26 | bool lResult = false; |
| 27 | 27 | ||
| 28 | /*
|
28 | /*
|
| 29 | QString str_tmp;
|
29 | QString str_tmp;
|
| 30 | if (index.column()==1) { // åñëè ìåíÿåì èìÿ êëàññà
|
30 | if (index.column()==1) { // åñëè ìåíÿåì èìÿ êëàññà
|
| 31 | str_tmp = value.toString(); // òî ïîìåíÿåì è èìÿ òàáëèöû
|
31 | str_tmp = value.toString(); // òî ïîìåíÿåì è èìÿ òàáëèöû
|
| 32 | str_tmp.append(tr(" instance"));
|
32 | str_tmp.append(tr(" instance"));
|
| 33 | }
|
33 | }
|
| 34 | */
|
34 | */
|
| 35 | /*
|
35 | /*
|
| 36 | QString str_tmp;
|
36 | QString str_tmp;
|
| 37 | if (index.column()==0) { // åñëè ìåíÿåì èìÿ êëàññà
|
37 | if (index.column()==0) { // åñëè ìåíÿåì èìÿ êëàññà
|
| 38 | str_tmp = value.toString(); // òî ïîìåíÿåì è èìÿ òàáëèöû
|
38 | str_tmp = value.toString(); // òî ïîìåíÿåì è èìÿ òàáëèöû
|
| 39 | str_tmp.append(tr("_instance"));
|
39 | str_tmp.append(tr("_instance"));
|
| 40 | }
|
40 | }
|
| 41 | */
|
41 | */
|
| 42 | lResult = QSqlTableModel::setData(index, value, role); |
42 | lResult = QSqlTableModel::setData(index, value, role); |
| 43 | if (lResult) { |
43 | if (lResult) { |
| 44 | QModelIndex newindex;
|
44 | QModelIndex newindex;
|
| 45 | QSqlRecord rec = record(index.row()); |
45 | QSqlRecord rec = record(index.row()); |
| 46 | 46 | ||
| 47 | rec.setValue(index.column(), value); |
47 | rec.setValue(index.column(), value); |
| 48 | rec.setGenerated(index.column(), true); |
48 | rec.setGenerated(index.column(), true); |
| 49 | 49 | ||
| 50 | /*
|
50 | /*
|
| 51 | if (index.column()==1){
|
51 | if (index.column()==1){
|
| 52 | rec.setValue(index.column()+2, QVariant(str_tmp));
|
52 | rec.setValue(index.column()+2, QVariant(str_tmp));
|
| 53 | rec.setGenerated(index.column()+2, true);
|
53 | rec.setGenerated(index.column()+2, true);
|
| 54 | newindex = MyModel::index(index.row(), index.column()+2);
|
54 | newindex = MyModel::index(index.row(), index.column()+2);
|
| 55 | QSqlTableModel::setData(newindex, QVariant(str_tmp), Qt::EditRole);
|
55 | QSqlTableModel::setData(newindex, QVariant(str_tmp), Qt::EditRole);
|
| 56 | }
|
56 | }
|
| 57 | */
|
57 | */
|
| 58 | /*
|
58 | /*
|
| 59 | 59 | ||
| 60 | if (index.column()==0){
|
60 | if (index.column()==0){
|
| 61 | rec.setValue(index.column()+3, QVariant(str_tmp));
|
61 | rec.setValue(index.column()+3, QVariant(str_tmp));
|
| 62 | rec.setGenerated(index.column()+3, true);
|
62 | rec.setGenerated(index.column()+3, true);
|
| 63 | newindex = MyModel::index(index.row(), index.column()+3);
|
63 | newindex = MyModel::index(index.row(), index.column()+3);
|
| 64 | QSqlTableModel::setData(newindex, QVariant(str_tmp), Qt::EditRole);
|
64 | QSqlTableModel::setData(newindex, QVariant(str_tmp), Qt::EditRole);
|
| 65 | }
|
65 | }
|
| 66 | */
|
66 | */
|
| 67 | 67 | ||
| 68 | lResult = updateRowInTable(index.row(), rec); |
68 | lResult = updateRowInTable(index.row(), rec); |
| 69 | /// QSqlTableModel::setData(newindex, QVariant(str_tmp), Qt::EditRole);
|
69 | /// QSqlTableModel::setData(newindex, QVariant(str_tmp), Qt::EditRole);
|
| 70 | 70 | ||
| 71 | 71 | ||
| 72 | }
|
72 | }
|
| 73 | return lResult; |
73 | return lResult; |
| 74 | }
|
74 | }
|
| 75 | 75 | ||
| 76 | 76 | ||
| 77 | 77 | ||
| 78 | QVariant MyModel::data(const QModelIndex &index, int role) const { |
78 | QVariant MyModel::data(const QModelIndex &index, int role) const { |
| 79 | 79 | ||
| 80 | QVariant value = QSqlTableModel::data(index, role); |
80 | QVariant value = QSqlTableModel::data(index, role); |
| 81 | switch (role) { |
81 | switch (role) { |
| 82 | case Qt::DisplayRole: return value; |
82 | case Qt::DisplayRole: return value; |
| 83 | case Qt::EditRole: return value; |
83 | case Qt::EditRole: return value; |
| 84 | case Qt::TextColorRole: |
84 | case Qt::TextColorRole: |
| 85 | if(index.column() == 1) |
85 | if(index.column() == 1) |
| 86 | return qVariantFromValue(QColor(Qt::blue)); |
86 | return qVariantFromValue(QColor(Qt::blue)); |
| 87 | else
|
87 | else
|
| 88 | return value; |
88 | return value; |
| 89 | case Qt::TextAlignmentRole: return value; |
89 | case Qt::TextAlignmentRole: return value; |
| 90 | case Qt::FontRole: |
90 | case Qt::FontRole: |
| 91 | if(index.column() == 1) { |
91 | if(index.column() == 1) { |
| 92 | QFont font = QFont("Helvetica", 16, QFont::Bold); |
92 | QFont font = QFont("Helvetica", 16, QFont::Bold); |
| 93 | return qVariantFromValue(font); |
93 | return qVariantFromValue(font); |
| 94 | }else |
94 | }else |
| 95 | return value; |
95 | return value; |
| 96 | 96 | ||
| 97 | case Qt::BackgroundColorRole: { |
97 | case Qt::BackgroundColorRole: { |
| 98 | int a = (index.row() % 2) ? 14 : 0; |
98 | int a = (index.row() % 2) ? 14 : 0; |
| 99 | if(index.column() == 2) |
99 | if(index.column() == 2) |
| 100 | return qVariantFromValue(QColor(220,240-a,230-a)); |
100 | return qVariantFromValue(QColor(220,240-a,230-a)); |
| 101 | else if(index.column() == 4) |
101 | else if(index.column() == 4) |
| 102 | return qVariantFromValue(QColor(200,220-a,255-a)); |
102 | return qVariantFromValue(QColor(200,220-a,255-a)); |
| 103 | else
|
103 | else
|
| 104 | return value; |
104 | return value; |
| 105 | }
|
105 | }
|
| 106 | 106 | ||
| 107 | 107 | ||
| 108 | 108 | ||
| 109 | case Qt::CheckStateRole: return value; |
109 | case Qt::CheckStateRole: return value; |
| 110 | 110 | ||
| 111 | case Qt::SizeHintRole:return value; |
111 | case Qt::SizeHintRole: |
| - | 112 | {
|
|
| - | 113 | // QSize size(200,100);
|
|
| - | 114 | ||
| - | 115 | return value; |
|
| - | 116 | // return QVariant(size);
|
|
| - | 117 | }
|
|
| - | 118 | ||
| - | 119 | case Qt::DecorationRole: { |
|
| - | 120 | /* if(index.column() == 5) {
|
|
| - | 121 | QVariant currentImage = QSqlTableModel::data(index, 0);
|
|
| - | 122 | QByteArray bytes = currentImage.toByteArray();
|
|
| - | 123 | QPixmap pxmp;
|
|
| - | 124 | if (currentImage.isValid()) {
|
|
| - | 125 | pxmp.loadFromData(bytes);
|
|
| - | 126 | QIcon icon;
|
|
| - | 127 | icon.addPixmap(pxmp);
|
|
| - | 128 | return icon;
|
|
| - | 129 | ||
| - | 130 | }
|
|
| - | 131 | else {
|
|
| - | 132 | //QItemDelegate::paint(painter, option, index);
|
|
| - | 133 | return value;
|
|
| - | 134 | }
|
|
| 112 | 135 | ||
| - | 136 | }
|
|
| 113 | }
|
137 | */
|
| - | 138 | ||
| - | 139 | }
|
|
| - | 140 | ||
| - | 141 | ||
| - | 142 | ||
| - | 143 | }
|
|
| 114 | return value; |
144 | return value; |
| 115 | }
|
145 | }
|
| 116 | 146 | ||
| 117 | 147 | ||