Редакция 84 | К новейшей редакции | Только различия | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
| Редакция 84 | Редакция 86 | ||
|---|---|---|---|
| 1 | #include "modelforpointers.h"
|
1 | #include "modelforpointers.h"
|
| 2 | 2 | ||
| 3 | ModelForPointers::ModelForPointers(QObject *parent) : |
3 | ModelForPointers::ModelForPointers(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 ModelForPointers::flags( |
9 | Qt::ItemFlags ModelForPointers::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)) |
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
|
16 | else
|
| 17 | {
|
17 | {
|
| 18 | if ((index.column() == 3) || (index.column() == 0)) flags &= ~Qt::ItemIsEditable; // çàïðåùàåì ðåäàêòèðîâàíèå òðåòüåãî ñòîëáöà |
18 | if ((index.column() == 3) || (index.column() == 0)) flags &= ~Qt::ItemIsEditable; // çàïðåùàåì ðåäàêòèðîâàíèå òðåòüåãî ñòîëáöà |
| 19 | }
|
19 | }
|
| 20 | return flags; |
20 | return flags; |
| 21 | }
|
21 | }
|
| 22 | 22 | ||
| 23 | 23 | ||
| 24 | bool ModelForPointers::setData(const QModelIndex &index, const QVariant &value, int role) { |
24 | bool ModelForPointers::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 | QVariant old_value; // ñîõðàíèì ñòàðîå çíà÷åíèå |
|
| - | 28 | old_value = data(index); |
|
| - | 29 | ||
| - | 30 | if (index.column()==1){ // åñëè ïîìåíÿëîñü èìÿ ïîëÿ |
|
| - | 31 | QSqlQuery qu;
|
|
| - | 32 | QString old_field_name; // ñòàðîå èìÿ ïîëÿ |
|
| - | 33 | QString new_field_name; // íîâîå èìÿ ïîëÿ |
|
| - | 34 | QString query_str;
|
|
| - | 35 | QString type_str; // òèï äàííûõ ïîëÿ |
|
| - | 36 | old_field_name = old_value.toString(); // îïðåäåëèì òåêóùåå (êîòîðîå íóæíî ïîìåíÿòü) èìÿ ïîëÿ |
|
| - | 37 | new_field_name = value.toString(); |
|
| - | 38 | // type_str = data(ModelForPointers::index(index.row(), 3)).toString(); // òèï ïîëÿ õðàíèòüñÿ â 3 ñòîëáöå, ñ÷èòûâàåì åãî çíà÷åíèå
|
|
| - | 39 | type_str = tr("CHAR(10)"); |
|
| - | 40 | ||
| - | 41 | query_str = tr("ALTER TABLE "); |
|
| - | 42 | query_str.append(ModelForPointers::Inctance); |
|
| - | 43 | query_str.append(tr(" CHANGE COLUMN `")); |
|
| - | 44 | query_str.append(old_field_name); |
|
| - | 45 | query_str.append(tr("` `")); |
|
| - | 46 | query_str.append(new_field_name); |
|
| - | 47 | query_str.append(tr("` ")); |
|
| - | 48 | query_str.append(type_str); |
|
| - | 49 | query_str.append(tr(" CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT NULL")); |
|
| - | 50 | qu.prepare(query_str); |
|
| - | 51 | bool ok; |
|
| - | 52 | ok = qu.exec(); |
|
| - | 53 | if (!ok) return false; |
|
| - | 54 | }
|
|
| - | 55 | ||
| 27 | 56 | ||
| 28 | 57 | ||
| 29 | lResult = QSqlTableModel::setData(index, value, role); |
58 | lResult = QSqlTableModel::setData(index, value, role); |
| 30 | if (lResult) { |
59 | if (lResult) { |
| 31 | QModelIndex newindex;
|
60 | QModelIndex newindex;
|
| 32 | QSqlRecord rec = record(index.row()); |
61 | QSqlRecord rec = record(index.row()); |
| 33 | 62 | ||
| 34 | rec.setValue(index.column(), value); |
63 | rec.setValue(index.column(), value); |
| 35 | rec.setGenerated(index.column(), true); |
64 | rec.setGenerated(index.column(), true); |
| 36 | 65 | ||
| 37 | 66 | ||
| 38 | lResult = updateRowInTable(index.row(), rec); |
67 | lResult = updateRowInTable(index.row(), rec); |
| - | 68 | emit field_changed(); |
|
| 39 | /// QSqlTableModel::setData(newindex, QVariant(str_tmp), Qt::EditRole);
|
69 | /// QSqlTableModel::setData(newindex, QVariant(str_tmp), Qt::EditRole);
|
| 40 | 70 | ||
| 41 | 71 | ||
| 42 | }
|
72 | }
|
| 43 | return lResult; |
73 | return lResult; |
| 44 | }
|
74 | }
|
| 45 | 75 | ||
| 46 | 76 | ||
| 47 | 77 | ||
| 48 | QVariant ModelForPointers::data(const QModelIndex &index, int role) const { |
78 | QVariant ModelForPointers::data(const QModelIndex &index, int role) const { |
| 49 | 79 | ||
| 50 | QVariant value = QSqlTableModel::data(index, role); |
80 | QVariant value = QSqlTableModel::data(index, role); |
| 51 | switch (role) { |
81 | switch (role) { |
| 52 | case Qt::DisplayRole: return value; |
82 | case Qt::DisplayRole: return value; |
| 53 | case Qt::EditRole: return value; |
83 | case Qt::EditRole: return value; |
| 54 | case Qt::TextColorRole: |
84 | case Qt::TextColorRole: |
| 55 | if(index.column() == 1) |
85 | if(index.column() == 1) |
| 56 | return qVariantFromValue(QColor(Qt::blue)); |
86 | return qVariantFromValue(QColor(Qt::blue)); |
| 57 | else
|
87 | else
|
| 58 | return value; |
88 | return value; |
| 59 | case Qt::TextAlignmentRole: return value; |
89 | case Qt::TextAlignmentRole: return value; |
| 60 | case Qt::FontRole: |
90 | case Qt::FontRole: |
| 61 | if(index.column() == 1) { |
91 | if(index.column() == 1) { |
| 62 | QFont font = QFont("Helvetica", 16, QFont::Bold); |
92 | QFont font = QFont("Helvetica", 16, QFont::Bold); |
| 63 | return qVariantFromValue(font); |
93 | return qVariantFromValue(font); |
| 64 | }else |
94 | }else |
| 65 | return value; |
95 | return value; |
| 66 | 96 | ||
| 67 | case Qt::BackgroundColorRole: { |
97 | case Qt::BackgroundColorRole: { |
| 68 | int a = (index.row() % 2) ? 14 : 0; |
98 | int a = (index.row() % 2) ? 14 : 0; |
| 69 | if(index.column() == 2) |
99 | if(index.column() == 2) |
| 70 | return qVariantFromValue(QColor(220,240-a,230-a)); |
100 | return qVariantFromValue(QColor(220,240-a,230-a)); |
| 71 | else if(index.column() == 4) |
101 | else if(index.column() == 4) |
| 72 | return qVariantFromValue(QColor(200,220-a,255-a)); |
102 | return qVariantFromValue(QColor(200,220-a,255-a)); |
| 73 | else
|
103 | else
|
| 74 | return value; |
104 | return value; |
| 75 | }
|
105 | }
|
| 76 | 106 | ||
| 77 | 107 | ||
| 78 | 108 | ||
| 79 | case Qt::CheckStateRole: return value; |
109 | case Qt::CheckStateRole: return value; |
| 80 | 110 | ||
| 81 | case Qt::SizeHintRole:return value; |
111 | case Qt::SizeHintRole:return value; |
| 82 | 112 | ||
| 83 | }
|
113 | }
|
| 84 | return value; |
114 | return value; |
| 85 | }
|
115 | }
|
| 86 | 116 | ||
| 87 | void ModelForPointers::setInctance(QString currInctatce){ // ïåðåäàåì èìÿ òåêóùåé òàáëèöû-õðàíèëèùà |
117 | void ModelForPointers::setInctance(QString currInctatce){ // ïåðåäàåì èìÿ òåêóùåé òàáëèöû-õðàíèëèùà |
| 88 | ModelForPointers::Inctance = currInctatce; |
118 | ModelForPointers::Inctance = currInctatce; |
| 89 | }
|
119 | }
|
| 90 | 120 | ||
| 91 | 121 | ||
| 92 | bool ModelForPointers::onlySetData(const QModelIndex &index, const QVariant &value, int role){ |
122 | bool ModelForPointers::onlySetData(const QModelIndex &index, const QVariant &value, int role){ |
| 93 | bool lResult = false; |
123 | bool lResult = false; |
| 94 | 124 | ||
| 95 | QSqlRecord rec = record(index.row()); |
125 | QSqlRecord rec = record(index.row()); |
| 96 | rec.setValue(index.column(), value); |
126 | rec.setValue(index.column(), value); |
| 97 | rec.setGenerated(index.column(), true); |
127 | rec.setGenerated(index.column(), true); |
| 98 | 128 | ||
| 99 | 129 | ||
| 100 | lResult = QSqlTableModel::setData(index, value, role); |
130 | lResult = QSqlTableModel::setData(index, value, role); |
| 101 | if (lResult) { |
131 | if (lResult) { |
| 102 | lResult = updateRowInTable(index.row(), rec); |
132 | lResult = updateRowInTable(index.row(), rec); |
| 103 | // emit field_changed();
|
133 | // emit field_changed();
|
| 104 | /// QSqlTableModel::setData(newindex, QVariant(str_tmp), Qt::EditRole);
|
134 | /// QSqlTableModel::setData(newindex, QVariant(str_tmp), Qt::EditRole);
|
| 105 | }
|
135 | }
|
| 106 | 136 | ||
| 107 | 137 | ||
| 108 | 138 | ||
| 109 | 139 | ||
| 110 | return lResult; |
140 | return lResult; |
| 111 | 141 | ||
| 112 | }
|
142 | }
|
| 113 | 143 | ||
| 114 | 144 | ||
| 115 | 145 | ||