Редакция 86 | Только различия | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 86 | Редакция 134 | ||
---|---|---|---|
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; // ñîõðàíèì ñòàðîå çíà÷åíèå |
27 | QVariant old_value; // ñîõðàíèì ñòàðîå çíà÷åíèå |
28 | old_value = data(index); |
28 | old_value = data(index); |
29 | 29 | ||
30 | if (index.column()==1){ // åñëè ïîìåíÿëîñü èìÿ ïîëÿ |
30 | if (index.column()==1){ // åñëè ïîìåíÿëîñü èìÿ ïîëÿ |
31 | QSqlQuery qu;
|
31 | QSqlQuery qu;
|
32 | QString old_field_name; // ñòàðîå èìÿ ïîëÿ |
32 | QString old_field_name; // ñòàðîå èìÿ ïîëÿ |
33 | QString new_field_name; // íîâîå èìÿ ïîëÿ |
33 | QString new_field_name; // íîâîå èìÿ ïîëÿ |
34 | QString query_str;
|
34 | QString query_str;
|
35 | QString type_str; // òèï äàííûõ ïîëÿ |
35 | QString type_str; // òèï äàííûõ ïîëÿ |
36 | old_field_name = old_value.toString(); // îïðåäåëèì òåêóùåå (êîòîðîå íóæíî ïîìåíÿòü) èìÿ ïîëÿ |
36 | old_field_name = old_value.toString(); // îïðåäåëèì òåêóùåå (êîòîðîå íóæíî ïîìåíÿòü) èìÿ ïîëÿ |
37 | new_field_name = value.toString(); |
37 | new_field_name = value.toString(); |
38 | // type_str = data(ModelForPointers::index(index.row(), 3)).toString(); // òèï ïîëÿ õðàíèòüñÿ â 3 ñòîëáöå, ñ÷èòûâàåì åãî çíà÷åíèå
|
38 | // type_str = data(ModelForPointers::index(index.row(), 3)).toString(); // òèï ïîëÿ õðàíèòüñÿ â 3 ñòîëáöå, ñ÷èòûâàåì åãî çíà÷åíèå
|
39 | type_str = tr("CHAR(10)"); |
39 | type_str = tr("CHAR(10)"); |
40 | 40 | ||
41 | query_str = tr("ALTER TABLE "); |
41 | query_str = tr("ALTER TABLE "); |
42 | query_str.append(ModelForPointers::Inctance); |
42 | query_str.append(ModelForPointers::Inctance); |
43 | query_str.append(tr(" CHANGE COLUMN `")); |
43 | query_str.append(tr(" CHANGE COLUMN `")); |
44 | query_str.append(old_field_name); |
44 | query_str.append(old_field_name); |
45 | query_str.append(tr("` `")); |
45 | query_str.append(tr("` `")); |
46 | query_str.append(new_field_name); |
46 | query_str.append(new_field_name); |
47 | query_str.append(tr("` ")); |
47 | query_str.append(tr("` ")); |
48 | query_str.append(type_str); |
48 | query_str.append(type_str); |
49 | query_str.append(tr(" CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT NULL")); |
49 | query_str.append(tr(" CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT NULL")); |
50 | qu.prepare(query_str); |
50 | qu.prepare(query_str); |
51 | bool ok; |
51 | bool ok; |
52 | ok = qu.exec(); |
52 | ok = qu.exec(); |
53 | if (!ok) return false; |
53 | if (!ok) return false; |
54 | }
|
54 | }
|
55 | 55 | ||
56 | 56 | ||
57 | 57 | ||
58 | lResult = QSqlTableModel::setData(index, value, role); |
58 | lResult = QSqlTableModel::setData(index, value, role); |
59 | if (lResult) { |
59 | if (lResult) { |
60 | QModelIndex newindex;
|
60 | QModelIndex newindex;
|
61 | QSqlRecord rec = record(index.row()); |
61 | QSqlRecord rec = record(index.row()); |
62 | 62 | ||
63 | rec.setValue(index.column(), value); |
63 | rec.setValue(index.column(), value); |
64 | rec.setGenerated(index.column(), true); |
64 | rec.setGenerated(index.column(), true); |
65 | 65 | ||
66 | 66 | ||
67 | lResult = updateRowInTable(index.row(), rec); |
67 | lResult = updateRowInTable(index.row(), rec); |
68 | emit field_changed(); |
68 | emit field_changed(); |
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 ModelForPointers::data(const QModelIndex &index, int role) const { |
78 | QVariant ModelForPointers::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: { |
- | 83 | if(index.column() == 4){ |
|
- | 84 | QSqlQuery q;
|
|
- | 85 | QString sql_str;
|
|
- | 86 | bool ok; |
|
- | 87 | sql_str = tr("select * from `ListOfClasses` where `ID` = "); |
|
- | 88 | sql_str.append(value.toString()); |
|
- | 89 | ||
- | 90 | q.prepare(sql_str); |
|
- | 91 | ||
- | 92 | ok = q.exec(); |
|
- | 93 | ||
- | 94 | if (ok) { |
|
- | 95 | while(q.next()){ |
|
- | 96 | QString class_name = q.value(1).toString(); |
|
- | 97 | if (!class_name.isEmpty()) return class_name; |
|
- | 98 | ||
- | 99 | }
|
|
- | 100 | ||
- | 101 | ||
- | 102 | }
|
|
- | 103 | ||
- | 104 | }
|
|
- | 105 | ||
- | 106 | ||
- | 107 | return value; |
|
- | 108 | }
|
|
- | 109 | ||
- | 110 | ||
- | 111 | ||
83 | case Qt::EditRole: return value; |
112 | case Qt::EditRole: return value; |
84 | case Qt::TextColorRole: |
113 | case Qt::TextColorRole: |
85 | if(index.column() == 1) |
114 | if(index.column() == 1) |
86 | return qVariantFromValue(QColor(Qt::blue)); |
115 | return qVariantFromValue(QColor(Qt::blue)); |
87 | else
|
116 | else
|
88 | return value; |
117 | return value; |
89 | case Qt::TextAlignmentRole: return value; |
118 | case Qt::TextAlignmentRole: return value; |
90 | case Qt::FontRole: |
119 | case Qt::FontRole: |
91 | if(index.column() == 1) { |
120 | if(index.column() == 1) { |
92 | QFont font = QFont("Helvetica", 16, QFont::Bold); |
121 | QFont font = QFont("Helvetica", 16, QFont::Bold); |
93 | return qVariantFromValue(font); |
122 | return qVariantFromValue(font); |
94 | }else |
123 | }else |
95 | return value; |
124 | return value; |
96 | 125 | ||
97 | case Qt::BackgroundColorRole: { |
126 | case Qt::BackgroundColorRole: { |
98 | int a = (index.row() % 2) ? 14 : 0; |
127 | int a = (index.row() % 2) ? 14 : 0; |
99 | if(index.column() == 2) |
128 | if(index.column() == 2) |
100 | return qVariantFromValue(QColor(220,240-a,230-a)); |
129 | return qVariantFromValue(QColor(220,240-a,230-a)); |
101 | else if(index.column() == 4) |
130 | else if(index.column() == 4) |
102 | return qVariantFromValue(QColor(200,220-a,255-a)); |
131 | return qVariantFromValue(QColor(200,220-a,255-a)); |
103 | else
|
132 | else
|
104 | return value; |
133 | return value; |
105 | }
|
134 | }
|
106 | 135 | ||
107 | 136 | ||
108 | 137 | ||
109 | case Qt::CheckStateRole: return value; |
138 | case Qt::CheckStateRole: return value; |
110 | 139 | ||
111 | case Qt::SizeHintRole:return value; |
140 | case Qt::SizeHintRole:return value; |
112 | 141 | ||
113 | }
|
142 | }
|
114 | return value; |
143 | return value; |
115 | }
|
144 | }
|
116 | 145 | ||
117 | void ModelForPointers::setInctance(QString currInctatce){ // ïåðåäàåì èìÿ òåêóùåé òàáëèöû-õðàíèëèùà |
146 | void ModelForPointers::setInctance(QString currInctatce){ // ïåðåäàåì èìÿ òåêóùåé òàáëèöû-õðàíèëèùà |
118 | ModelForPointers::Inctance = currInctatce; |
147 | ModelForPointers::Inctance = currInctatce; |
119 | }
|
148 | }
|
120 | 149 | ||
121 | 150 | ||
122 | bool ModelForPointers::onlySetData(const QModelIndex &index, const QVariant &value, int role){ |
151 | bool ModelForPointers::onlySetData(const QModelIndex &index, const QVariant &value, int role){ |
123 | bool lResult = false; |
152 | bool lResult = false; |
124 | 153 | ||
125 | QSqlRecord rec = record(index.row()); |
154 | QSqlRecord rec = record(index.row()); |
126 | rec.setValue(index.column(), value); |
155 | rec.setValue(index.column(), value); |
127 | rec.setGenerated(index.column(), true); |
156 | rec.setGenerated(index.column(), true); |
128 | 157 | ||
129 | 158 | ||
130 | lResult = QSqlTableModel::setData(index, value, role); |
159 | lResult = QSqlTableModel::setData(index, value, role); |
131 | if (lResult) { |
160 | if (lResult) { |
132 | lResult = updateRowInTable(index.row(), rec); |
161 | lResult = updateRowInTable(index.row(), rec); |
133 | // emit field_changed();
|
162 | // emit field_changed();
|
134 | /// QSqlTableModel::setData(newindex, QVariant(str_tmp), Qt::EditRole);
|
163 | /// QSqlTableModel::setData(newindex, QVariant(str_tmp), Qt::EditRole);
|
135 | }
|
164 | }
|
136 | 165 | ||
137 | 166 | ||
138 | 167 | ||
139 | 168 | ||
140 | return lResult; |
169 | return lResult; |
141 | 170 | ||
142 | }
|
171 | }
|
143 | 172 | ||
144 | 173 | ||
145 | 174 |