| 24,7 → 24,10 |
|---|
| bool ModelForDescriptionTable::setData(const QModelIndex &index, const QVariant &value, int role) { |
| //// if (index.column()==3) return false; // â òðåòüåé êîëîíêå íå äàåì ïîìåíÿòü çíà÷åíèå |
| bool lResult = false; |
| QVariant old_value; // ñîõðàíèì ñòàðîå çíà÷åíèå |
| old_value = data(index); |
| |
| |
| /* |
| QString str_tmp; |
| if (index.column()==1) { // åñëè ìåíÿåì èìÿ êëàññà |
| 47,14 → 50,52 |
|---|
| rec.setValue(index.column(), value); |
| rec.setGenerated(index.column(), true); |
| |
| /* |
| if (index.column()==1){ |
| rec.setValue(index.column()+2, QVariant(str_tmp)); |
| rec.setGenerated(index.column()+2, true); |
| newindex = MyModel::index(index.row(), index.column()+2); |
| QSqlTableModel::setData(newindex, QVariant(str_tmp), Qt::EditRole); |
| |
| if (index.column()==1){ // åñëè ïîìåíÿëîñü èìÿ ïîëÿ |
| QSqlQuery qu; |
| QString old_field_name; // ñòàðîå èìÿ ïîëÿ |
| QString new_field_name; // íîâîå èìÿ ïîëÿ |
| QString query_str; |
| QString type_str; // òèï äàííûõ ïîëÿ |
| old_field_name = old_value.toString(); // îïðåäåëèì òåêóùåå (êîòîðîå íóæíî ïîìåíÿòü) èìÿ ïîëÿ |
| new_field_name = value.toString(); |
| type_str = data(ModelForDescriptionTable::index(index.row(), 3)).toString(); // òèï ïîëÿ õðàíèòüñÿ â 3 ñòîëáöå, ñ÷èòûâàåì åãî çíà÷åíèå |
| query_str = tr("ALTER TABLE "); |
| query_str.append(ModelForDescriptionTable::Inctance); |
| query_str.append(tr(" CHANGE COLUMN `")); |
| query_str.append(old_field_name); |
| query_str.append(tr("` `")); |
| query_str.append(new_field_name); |
| query_str.append(tr("` ")); |
| query_str.append(type_str); |
| query_str.append(tr(" CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT NULL")); |
| qu.prepare(query_str); |
| bool ok; |
| ok = qu.exec(); |
| if (!ok) return false; |
| |
| /* |
| if (!ok) { |
| |
| QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
| this, // Ðîäèòåëüñêèé âèäæåò. |
| QObject::tr("Database Error"), // Çàãîëîâîê. |
| qu.lastError().text() ); // Òåêñò ñîîáùåíèÿ. |
| |
| return ok; // âûõîäèì íå ïðèìåíÿÿ èçìåíåíèé |
| |
| } |
| |
| */ |
| |
| |
| // rec.setValue(index.column()+2, QVariant(str_tmp)); |
| // rec.setGenerated(index.column()+2, true); |
| // newindex = MyModel::index(index.row(), index.column()+2); |
| // QSqlTableModel::setData(newindex, QVariant(str_tmp), Qt::EditRole); |
| } |
| */ |
| |
| |
| /* |
| |
| if (index.column()==0){ |
| 113,3 → 154,8 |
|---|
| } |
| return value; |
| } |
| |
| |
| void ModelForDescriptionTable::setInctance(QString currInctatce){ // ïåðåäàåì èìÿ òåêóùåé òàáëèöû-õðàíèëèùà |
| ModelForDescriptionTable::Inctance = currInctatce; |
| } |