Редакция 78 | Редакция 80 | К новейшей редакции | Только различия | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 78 | Редакция 79 | ||
---|---|---|---|
1 | #include "modelfordescriptiontable.h"
|
1 | #include "modelfordescriptiontable.h"
|
2 | 2 | ||
3 | ModelForDescriptionTable::ModelForDescriptionTable(QObject *parent) : |
3 | ModelForDescriptionTable::ModelForDescriptionTable(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 ModelForDescriptionTable::flags( |
9 | Qt::ItemFlags ModelForDescriptionTable::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() != 5) && (index.column() != 0)) |
12 | if ((index.column() != 5) && (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() == 0) || (index.column() == 5)) flags &= ~Qt::ItemIsEditable; // çàïðåùàåì ðåäàêòèðîâàíèå òðåòüåãî ñòîëáöà |
18 | if ((index.column() == 0) || (index.column() == 5)) flags &= ~Qt::ItemIsEditable; // çàïðåùàåì ðåäàêòèðîâàíèå òðåòüåãî ñòîëáöà |
19 | }
|
19 | }
|
20 | return flags; |
20 | return flags; |
21 | }
|
21 | }
|
22 | 22 | ||
23 | 23 | ||
24 | bool ModelForDescriptionTable::setData(const QModelIndex &index, const QVariant &value, int role) { |
24 | bool ModelForDescriptionTable::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 | 30 | ||
31 | /*
|
31 | /*
|
32 | QString str_tmp;
|
32 | QString str_tmp;
|
33 | if (index.column()==1) { // åñëè ìåíÿåì èìÿ êëàññà
|
33 | if (index.column()==1) { // åñëè ìåíÿåì èìÿ êëàññà
|
34 | str_tmp = value.toString(); // òî ïîìåíÿåì è èìÿ òàáëèöû
|
34 | str_tmp = value.toString(); // òî ïîìåíÿåì è èìÿ òàáëèöû
|
35 | str_tmp.append(tr(" instance"));
|
35 | str_tmp.append(tr(" instance"));
|
36 | }
|
36 | }
|
37 | */
|
37 | */
|
38 | /*
|
38 | /*
|
39 | QString str_tmp;
|
39 | QString str_tmp;
|
40 | if (index.column()==0) { // åñëè ìåíÿåì èìÿ êëàññà
|
40 | if (index.column()==0) { // åñëè ìåíÿåì èìÿ êëàññà
|
41 | str_tmp = value.toString(); // òî ïîìåíÿåì è èìÿ òàáëèöû
|
41 | str_tmp = value.toString(); // òî ïîìåíÿåì è èìÿ òàáëèöû
|
42 | str_tmp.append(tr("_instance"));
|
42 | str_tmp.append(tr("_instance"));
|
43 | }
|
43 | }
|
44 | */
|
44 | */
|
45 | 45 | ||
46 | QModelIndex newindex;
|
46 | QModelIndex newindex;
|
47 | 47 | ||
48 | 48 | ||
49 | 49 | ||
50 | 50 | ||
51 | 51 | ||
52 | if (index.column()==1){ // åñëè ïîìåíÿëîñü èìÿ ïîëÿ |
52 | if (index.column()==1){ // åñëè ïîìåíÿëîñü èìÿ ïîëÿ |
53 | QSqlQuery qu;
|
53 | QSqlQuery qu;
|
54 | QString old_field_name; // ñòàðîå èìÿ ïîëÿ |
54 | QString old_field_name; // ñòàðîå èìÿ ïîëÿ |
55 | QString new_field_name; // íîâîå èìÿ ïîëÿ |
55 | QString new_field_name; // íîâîå èìÿ ïîëÿ |
56 | QString query_str;
|
56 | QString query_str;
|
57 | QString type_str; // òèï äàííûõ ïîëÿ |
57 | QString type_str; // òèï äàííûõ ïîëÿ |
58 | old_field_name = old_value.toString(); // îïðåäåëèì òåêóùåå (êîòîðîå íóæíî ïîìåíÿòü) èìÿ ïîëÿ |
58 | old_field_name = old_value.toString(); // îïðåäåëèì òåêóùåå (êîòîðîå íóæíî ïîìåíÿòü) èìÿ ïîëÿ |
59 | new_field_name = value.toString(); |
59 | new_field_name = value.toString(); |
60 | type_str = data(ModelForDescriptionTable::index(index.row(), 3)).toString(); // òèï ïîëÿ õðàíèòüñÿ â 3 ñòîëáöå, ñ÷èòûâàåì åãî çíà÷åíèå |
60 | type_str = data(ModelForDescriptionTable::index(index.row(), 3)).toString(); // òèï ïîëÿ õðàíèòüñÿ â 3 ñòîëáöå, ñ÷èòûâàåì åãî çíà÷åíèå |
61 | query_str = tr("ALTER TABLE "); |
61 | query_str = tr("ALTER TABLE "); |
62 | query_str.append(ModelForDescriptionTable::Inctance); |
62 | query_str.append(ModelForDescriptionTable::Inctance); |
63 | query_str.append(tr(" CHANGE COLUMN `")); |
63 | query_str.append(tr(" CHANGE COLUMN `")); |
64 | query_str.append(old_field_name); |
64 | query_str.append(old_field_name); |
65 | query_str.append(tr("` `")); |
65 | query_str.append(tr("` `")); |
66 | query_str.append(new_field_name); |
66 | query_str.append(new_field_name); |
67 | query_str.append(tr("` ")); |
67 | query_str.append(tr("` ")); |
68 | query_str.append(type_str); |
68 | query_str.append(type_str); |
69 | query_str.append(tr(" CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT NULL")); |
69 | query_str.append(tr(" CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT NULL")); |
70 | qu.prepare(query_str); |
70 | qu.prepare(query_str); |
71 | bool ok; |
71 | bool ok; |
72 | ok = qu.exec(); |
72 | ok = qu.exec(); |
73 | if (!ok) return false; |
73 | if (!ok) return false; |
74 | 74 | }
|
|
75 | /*
|
75 | /*
|
76 | if (!ok) {
|
76 | if (!ok) {
|
77 | 77 | ||
78 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
|
78 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
|
79 | this, // Ðîäèòåëüñêèé âèäæåò.
|
79 | this, // Ðîäèòåëüñêèé âèäæåò.
|
80 | QObject::tr("Database Error"), // Çàãîëîâîê.
|
80 | QObject::tr("Database Error"), // Çàãîëîâîê.
|
81 | qu.lastError().text() ); // Òåêñò ñîîáùåíèÿ.
|
81 | qu.lastError().text() ); // Òåêñò ñîîáùåíèÿ.
|
82 | 82 | ||
83 | return ok; // âûõîäèì íå ïðèìåíÿÿ èçìåíåíèé
|
83 | return ok; // âûõîäèì íå ïðèìåíÿÿ èçìåíåíèé
|
84 | 84 | ||
85 | }
|
85 | }
|
86 | 86 | ||
87 | */
|
87 | */
|
88 | 88 | ||
89 | 89 | ||
90 | // rec.setValue(index.column()+2, QVariant(str_tmp));
|
90 | // rec.setValue(index.column()+2, QVariant(str_tmp));
|
91 | // rec.setGenerated(index.column()+2, true);
|
91 | // rec.setGenerated(index.column()+2, true);
|
92 | // newindex = MyModel::index(index.row(), index.column()+2);
|
92 | // newindex = MyModel::index(index.row(), index.column()+2);
|
93 | // QSqlTableModel::setData(newindex, QVariant(str_tmp), Qt::EditRole);
|
93 | // QSqlTableModel::setData(newindex, QVariant(str_tmp), Qt::EditRole);
|
94 | }
|
94 | |
95 | 95 | ||
96 | 96 | ||
97 | /*
|
97 | /*
|
98 | 98 | ||
99 | if (index.column()==0){
|
99 | if (index.column()==0){
|
100 | rec.setValue(index.column()+3, QVariant(str_tmp));
|
100 | rec.setValue(index.column()+3, QVariant(str_tmp));
|
101 | rec.setGenerated(index.column()+3, true);
|
101 | rec.setGenerated(index.column()+3, true);
|
102 | newindex = MyModel::index(index.row(), index.column()+3);
|
102 | newindex = MyModel::index(index.row(), index.column()+3);
|
103 | QSqlTableModel::setData(newindex, QVariant(str_tmp), Qt::EditRole);
|
103 | QSqlTableModel::setData(newindex, QVariant(str_tmp), Qt::EditRole);
|
104 | }
|
104 | }
|
105 | */
|
105 | */
|
106 | 106 | ||
107 | if (index.column()==3){ // åñëè ïîìåíÿëñÿ òèï äàííûõ |
107 | if (index.column()==3){ // åñëè ïîìåíÿëñÿ òèï äàííûõ |
108 | ///ALTER TABLE `an_db`.`1_Inctance` MODIFY COLUMN `int` INTEGER;
|
108 | ///ALTER TABLE `an_db`.`1_Inctance` MODIFY COLUMN `int` INTEGER;
|
- | 109 | ||
- | 110 | bool ok; |
|
- | 111 | ok = setData(ModelForDescriptionTable::index(index.row(), 4), QVariant(tr("NULL")), Qt::EditRole); // ñáðîñèì çíà÷åíèå ïî óìîë÷àíèþ |
|
- | 112 | if (ok) { |
|
- | 113 | ||
- | 114 | ||
109 | QSqlQuery qu;
|
115 | QSqlQuery qu;
|
110 | QString old_type, new_type, field_name, query_str;
|
116 | QString old_type, new_type, field_name, query_str;
|
111 | old_type = old_value.toString(); // îïðåäåëèì òåêóùèé (êîòîðîå íóæíî ïîìåíÿòü) òèï ïîëÿ |
117 | old_type = old_value.toString(); // îïðåäåëèì òåêóùèé (êîòîðîå íóæíî ïîìåíÿòü) òèï ïîëÿ |
112 | new_type = value.toString(); // íîâûé òèï ïîëÿ |
118 | new_type = value.toString(); // íîâûé òèï ïîëÿ |
113 | field_name = data(ModelForDescriptionTable::index(index.row(), 1)).toString(); // èìÿ ïîëÿ õðàíèòüñÿ â 1 ñòîëáöå, ñ÷èòûâàåì åãî çíà÷åíèå |
119 | field_name = data(ModelForDescriptionTable::index(index.row(), 1)).toString(); // èìÿ ïîëÿ õðàíèòüñÿ â 1 ñòîëáöå, ñ÷èòûâàåì åãî çíà÷åíèå |
114 | query_str = tr("ALTER TABLE "); |
120 | query_str = tr("ALTER TABLE "); |
115 | query_str.append(ModelForDescriptionTable::Inctance); |
121 | query_str.append(ModelForDescriptionTable::Inctance); |
116 | query_str.append(tr(" MODIFY COLUMN `")); |
122 | query_str.append(tr(" MODIFY COLUMN `")); |
117 | query_str.append(field_name); |
123 | query_str.append(field_name); |
118 | query_str.append(tr("` ")); |
124 | query_str.append(tr("` ")); |
119 | query_str.append(new_type); |
125 | query_str.append(new_type); |
120 | qu.prepare(query_str); |
126 | qu.prepare(query_str); |
121 | bool ok; |
- | |
- | 127 | ||
122 | ok = qu.exec(); |
128 | ok = qu.exec(); |
123 | if (!ok) return false; |
129 | if (!ok) return false; |
124 | else setData(ModelForDescriptionTable::index(index.row(), 4), QVariant(tr("NULL")), Qt::EditRole); // ñáðîñèì çíà÷åíèå ïî óìîë÷àíèþ |
- | |
125 | }
|
130 | }
|
- | 131 | else return false; |
|
126 | 132 | }
|
|
127 | if (index.column()==4){ // åñëè ïîìåíÿëîñü çíà÷åíèå ïî óìîë÷àíèþ |
133 | if (index.column()==4){ // åñëè ïîìåíÿëîñü çíà÷åíèå ïî óìîë÷àíèþ |
128 | ///ALTER TABLE `an_db`.`2_Inctance` MODIFY COLUMN `Îò÷åñòâî` CHAR(10) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT 'Èâàíîâè÷';
|
134 | ///ALTER TABLE `an_db`.`2_Inctance` MODIFY COLUMN `Îò÷åñòâî` CHAR(10) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT 'Èâàíîâè÷';
|
129 | QSqlQuery qu;
|
135 | QSqlQuery qu;
|
130 | QString field_type, new_default_value, field_name, query_str;
|
136 | QString field_type, new_default_value, field_name, query_str;
|
131 | 137 | ||
132 | field_type = data(ModelForDescriptionTable::index(index.row(), 3)).toString(); // òèï ïîëÿ õðàíèòüñÿ â 3 ñòîëáöå, ñ÷èòûâàåì åãî çíà÷åíèå |
138 | field_type = data(ModelForDescriptionTable::index(index.row(), 3)).toString(); // òèï ïîëÿ õðàíèòüñÿ â 3 ñòîëáöå, ñ÷èòûâàåì åãî çíà÷åíèå |
133 | field_name = data(ModelForDescriptionTable::index(index.row(), 1)).toString(); // èìÿ ïîëÿ õðàíèòüñÿ â 1 ñòîëáöå, ñ÷èòûâàåì åãî çíà÷åíèå |
139 | field_name = data(ModelForDescriptionTable::index(index.row(), 1)).toString(); // èìÿ ïîëÿ õðàíèòüñÿ â 1 ñòîëáöå, ñ÷èòûâàåì åãî çíà÷åíèå |
134 | new_default_value = value.toString(); |
140 | new_default_value = value.toString(); |
135 | query_str = tr("ALTER TABLE "); |
141 | query_str = tr("ALTER TABLE "); |
136 | query_str.append(ModelForDescriptionTable::Inctance); |
142 | query_str.append(ModelForDescriptionTable::Inctance); |
137 | query_str.append(tr(" MODIFY COLUMN `")); |
143 | query_str.append(tr(" MODIFY COLUMN `")); |
138 | query_str.append(field_name); |
144 | query_str.append(field_name); |
139 | query_str.append(tr("` ")); |
145 | query_str.append(tr("` ")); |
140 | query_str.append(field_type); |
146 | query_str.append(field_type); |
141 | 147 | ||
142 | if (new_default_value != tr("NULL")) { |
148 | if (new_default_value != tr("NULL")) { |
143 | query_str.append(tr(" DEFAULT '")); |
149 | query_str.append(tr(" DEFAULT '")); |
144 | 150 | ||
145 | 151 | ||
146 | query_str.append(new_default_value); |
152 | query_str.append(new_default_value); |
147 | query_str.append(tr("'")); } |
153 | query_str.append(tr("'")); } |
148 | else { |
154 | else { |
149 | query_str.append(tr(" DEFAULT ")); // Åñëè íàäî çàäàòü çíà÷åíèå NULL òî àïîñòðîôû íå ñòàâèì |
155 | query_str.append(tr(" DEFAULT ")); // Åñëè íàäî çàäàòü çíà÷åíèå NULL òî àïîñòðîôû íå ñòàâèì |
150 | query_str.append(new_default_value); |
156 | query_str.append(new_default_value); |
151 | }
|
157 | }
|
152 | qu.prepare(query_str); |
158 | qu.prepare(query_str); |
153 | bool ok; |
159 | bool ok; |
154 | ok = qu.exec(); |
160 | ok = qu.exec(); |
155 | if (!ok) return false; |
161 | if (!ok) return false; |
156 | 162 | ||
157 | }
|
163 | }
|
158 | 164 | ||
159 | 165 | ||
160 | QSqlRecord rec = record(index.row()); |
166 | QSqlRecord rec = record(index.row()); |
161 | rec.setValue(index.column(), value); |
167 | rec.setValue(index.column(), value); |
162 | rec.setGenerated(index.column(), true); |
168 | rec.setGenerated(index.column(), true); |
163 | 169 | ||
164 | 170 | ||
165 | lResult = QSqlTableModel::setData(index, value, role); |
171 | lResult = QSqlTableModel::setData(index, value, role); |
166 | if (lResult) { |
172 | if (lResult) { |
167 | lResult = updateRowInTable(index.row(), rec); |
173 | lResult = updateRowInTable(index.row(), rec); |
168 | emit field_changed(); |
174 | emit field_changed(); |
169 | /// QSqlTableModel::setData(newindex, QVariant(str_tmp), Qt::EditRole);
|
175 | /// QSqlTableModel::setData(newindex, QVariant(str_tmp), Qt::EditRole);
|
170 | 176 | ||
171 | 177 | ||
172 | }
|
178 | }
|
173 | 179 | ||
174 | 180 | ||
175 | 181 | ||
176 | 182 | ||
177 | return lResult; |
183 | return lResult; |
178 | }
|
184 | }
|
179 | 185 | ||
180 | 186 | ||
181 | 187 | ||
182 | QVariant ModelForDescriptionTable::data(const QModelIndex &index, int role) const { |
188 | QVariant ModelForDescriptionTable::data(const QModelIndex &index, int role) const { |
183 | 189 | ||
184 | QVariant value = QSqlTableModel::data(index, role); |
190 | QVariant value = QSqlTableModel::data(index, role); |
185 | switch (role) { |
191 | switch (role) { |
186 | case Qt::DisplayRole: return value; |
192 | case Qt::DisplayRole: return value; |
187 | case Qt::EditRole: return value; |
193 | case Qt::EditRole: return value; |
188 | case Qt::TextColorRole: |
194 | case Qt::TextColorRole: |
189 | if(index.column() == 1) |
195 | if(index.column() == 1) |
190 | return qVariantFromValue(QColor(Qt::darkGreen)); |
196 | return qVariantFromValue(QColor(Qt::darkGreen)); |
191 | else
|
197 | else
|
192 | return value; |
198 | return value; |
193 | case Qt::TextAlignmentRole: return value; |
199 | case Qt::TextAlignmentRole: return value; |
194 | case Qt::FontRole: |
200 | case Qt::FontRole: |
195 | if(index.column() == 1) { |
201 | if(index.column() == 1) { |
196 | QFont font = QFont("Helvetica", 16, QFont::Bold); |
202 | QFont font = QFont("Helvetica", 16, QFont::Bold); |
197 | return qVariantFromValue(font); |
203 | return qVariantFromValue(font); |
198 | }else |
204 | }else |
199 | return value; |
205 | return value; |
200 | 206 | ||
201 | case Qt::BackgroundColorRole: { |
207 | case Qt::BackgroundColorRole: { |
202 | int a = (index.row() % 2) ? 14 : 0; |
208 | int a = (index.row() % 2) ? 14 : 0; |
203 | if(index.column() == 2) |
209 | if(index.column() == 2) |
204 | return qVariantFromValue(QColor(220,240-a,230-a)); |
210 | return qVariantFromValue(QColor(220,240-a,230-a)); |
205 | else if(index.column() == 6) |
211 | else if(index.column() == 6) |
206 | return qVariantFromValue(QColor(200,220-a,255-a)); |
212 | return qVariantFromValue(QColor(200,220-a,255-a)); |
207 | else
|
213 | else
|
208 | return value; |
214 | return value; |
209 | }
|
215 | }
|
210 | 216 | ||
211 | 217 | ||
212 | 218 | ||
213 | case Qt::CheckStateRole: return value; |
219 | case Qt::CheckStateRole: return value; |
214 | 220 | ||
215 | case Qt::SizeHintRole:return value; |
221 | case Qt::SizeHintRole:return value; |
216 | 222 | ||
217 | }
|
223 | }
|
218 | return value; |
224 | return value; |
219 | }
|
225 | }
|
220 | 226 | ||
221 | 227 | ||
222 | void ModelForDescriptionTable::setInctance(QString currInctatce){ // ïåðåäàåì èìÿ òåêóùåé òàáëèöû-õðàíèëèùà |
228 | void ModelForDescriptionTable::setInctance(QString currInctatce){ // ïåðåäàåì èìÿ òåêóùåé òàáëèöû-õðàíèëèùà |
223 | ModelForDescriptionTable::Inctance = currInctatce; |
229 | ModelForDescriptionTable::Inctance = currInctatce; |
224 | }
|
230 | }
|
225 | 231 |