Редакция 134 | Редакция 137 | К новейшей редакции | Весь файл | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 134 | Редакция 135 | ||
---|---|---|---|
Строка 10... | Строка 10... | ||
10 | 10 | ||
11 | 11 | ||
12 | 12 | ||
13 | // settdialog = new SettingsDialog(this);
|
13 | // settdialog = new SettingsDialog(this);
|
14 | ///////////////////////////////////////////////////// settdialog.show();
|
14 | ///////////////////////////////////////////////////// settdialog.show();
|
- | 15 | ||
- | 16 | readSettings(); |
|
- | 17 | ||
15 | sql.setDatabaseName(tr("an_db")); |
18 | // sql.setDatabaseName(tr("an_db"));
|
- | 19 | ||
- | 20 | ||
- | 21 | ||
16 | 22 | ||
17 | /*
|
23 | /*
|
18 | field = new TableField(tr("Ñîòðóäíèêè"), this);
|
24 | field = new TableField(tr("Ñîòðóäíèêè"), this);
|
19 | field->setNotNull(true);
|
25 | field->setNotNull(true);
|
20 | field->setDefaultValue(tr("ñîòðóäíèê"));
|
26 | field->setDefaultValue(tr("ñîòðóäíèê"));
|
Строка 83... | Строка 89... | ||
83 | 89 | ||
84 | ****************************************************/
|
90 | ****************************************************/
|
85 | 91 | ||
86 | QString errorString;
|
92 | QString errorString;
|
87 | 93 | ||
88 | sql.setDatabaseName(tr("an_db")); |
94 | // sql.setDatabaseName(tr("an_db"));
|
- | 95 | ||
- | 96 | sql.setDatabaseName(baseName); |
|
89 | // sql.setDatabaseName(tr("inventory"));
|
97 | // sql.setDatabaseName(tr("inventory"));
|
- | 98 | ||
90 | sql.setHostName(tr("localhost")); |
99 | // sql.setHostName(tr("localhost"));
|
- | 100 | sql.setHostName(hostName); |
|
- | 101 | ||
91 | sql.setUserName(tr("an")); |
102 | // sql.setUserName(tr("an"));
|
- | 103 | ||
- | 104 | sql.setUserName(userName); |
|
- | 105 | ||
92 | sql.setPassword(tr("393939")); |
106 | // sql.setPassword(tr("393939"));
|
- | 107 | ||
- | 108 | sql.setPassword(password); |
|
93 | 109 | ||
94 | bool ok; |
110 | bool ok; |
95 | ok = sql.connect(); |
111 | ok = sql.connect(); |
96 | if (!ok) { |
112 | if (!ok) { |
97 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
113 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
Строка 255... | Строка 271... | ||
255 | delegateForDefaultValueColomn.getItems(); |
271 | delegateForDefaultValueColomn.getItems(); |
256 | ui->tableView_3->setItemDelegateForColumn(4, &delegateForDefaultValueColomn); |
272 | ui->tableView_3->setItemDelegateForColumn(4, &delegateForDefaultValueColomn); |
257 | 273 | ||
258 | 274 | ||
259 | 275 | ||
- | 276 | if (mymodel->rowCount() > 0) { |
|
- | 277 | ||
- | 278 | ||
- | 279 | ||
260 | if (mymodel->rowCount() > 0) currIndexOfClassesTable = mymodel->index(0, 1); |
280 | currIndexOfClassesTable = mymodel->index(0, 1); |
261 | QModelIndex index_temp;
|
281 | QModelIndex index_temp;
|
262 | 282 | ||
263 | 283 | ||
264 | 284 | ||
265 | currClassID = mymodel->data(mymodel->index(0,0)).toString(); |
285 | currClassID = mymodel->data(mymodel->index(0,0)).toString(); |
Строка 311... | Строка 331... | ||
311 | modelForPointers->setFilter(str_fltr); |
331 | modelForPointers->setFilter(str_fltr); |
312 | modelForPointers->select(); |
332 | modelForPointers->select(); |
313 | ui->tableView_3->setModel(modelForPointers); |
333 | ui->tableView_3->setModel(modelForPointers); |
314 | ui->tableView_3->resizeColumnsToContents(); |
334 | ui->tableView_3->resizeColumnsToContents(); |
315 | 335 | ||
- | 336 | }
|
|
- | 337 | ||
316 | //connect(ui->tableView, SIGNAL(clicked(const QModelIndex)), this, SLOT(on_tableView_clicked(const QModelIndex)));
|
338 | //connect(ui->tableView, SIGNAL(clicked(const QModelIndex)), this, SLOT(on_tableView_clicked(const QModelIndex)));
|
317 | connect(mymodel, SIGNAL(dataChanged(QModelIndex,QModelIndex)), this, SLOT(on_myModel_dataChanged(QModelIndex,QModelIndex))); |
339 | connect(mymodel, SIGNAL(dataChanged(QModelIndex,QModelIndex)), this, SLOT(on_myModel_dataChanged(QModelIndex,QModelIndex))); |
318 | connect(modelForDescription, SIGNAL(dataChanged(QModelIndex,QModelIndex)), this, SLOT(on_modelForDescription_dataChanged(QModelIndex,QModelIndex))); |
340 | connect(modelForDescription, SIGNAL(dataChanged(QModelIndex,QModelIndex)), this, SLOT(on_modelForDescription_dataChanged(QModelIndex,QModelIndex))); |
319 | //connect(ui->newClassAction, SIGNAL(triggered(bool)), this, SLOT(on_pushButton_clicked(bool)));
|
341 | //connect(ui->newClassAction, SIGNAL(triggered(bool)), this, SLOT(on_pushButton_clicked(bool)));
|
320 | connect(ui->action_ID, SIGNAL(triggered(bool)), this, SLOT(on_action_ID_triggered(bool))); |
342 | connect(ui->action_ID, SIGNAL(triggered(bool)), this, SLOT(on_action_ID_triggered(bool))); |
Строка 332... | Строка 354... | ||
332 | connect(ui->action_removeSelectedPointers, SIGNAL(triggered()), this, SLOT(on_action_removeSelectedPointers())); // óäàëèòü âûäåëåííûå êëàññû |
354 | connect(ui->action_removeSelectedPointers, SIGNAL(triggered()), this, SLOT(on_action_removeSelectedPointers())); // óäàëèòü âûäåëåííûå êëàññû |
333 | connect(modelForDescription, SIGNAL(field_changed()), this, SLOT(on_field_changed())); // â òàáëèöå ïîëåé ïðîèçîøëè èçìåíåíèÿ |
355 | connect(modelForDescription, SIGNAL(field_changed()), this, SLOT(on_field_changed())); // â òàáëèöå ïîëåé ïðîèçîøëè èçìåíåíèÿ |
334 | connect(ClassEditor::modelForPointers, SIGNAL(field_changed()), this, SLOT(on_field_changed())); // â òàáëèöå óêàçàòåëåé ïðîèçîøëè èçìåíåíèÿ |
356 | connect(ClassEditor::modelForPointers, SIGNAL(field_changed()), this, SLOT(on_field_changed())); // â òàáëèöå óêàçàòåëåé ïðîèçîøëè èçìåíåíèÿ |
335 | 357 | ||
336 | 358 | ||
- | 359 | connect(ui->getsettingAct, SIGNAL(triggered()), this, SLOT(getSetting())); // âûáîð â ãëàâíîé ôîðìå â ìåíþ "Áàçà äàííûõ" ïóíêòà "Ïàðàìåòðû ñîåäèíåíèÿ" |
|
- | 360 | connect(setFrm.pushButton, SIGNAL(clicked()), this, SLOT(applySetting())); |
|
- | 361 | ||
- | 362 | ||
- | 363 | ||
337 | 364 | ||
338 | }
|
365 | }
|
339 | 366 | ||
340 | 367 | ||
341 | 368 | ||
Строка 536... | Строка 563... | ||
536 | modelForPointers->onlySetData(modelForPointers->index(row, 4), QVariant(tr("NULL")), Qt::EditRole); |
563 | modelForPointers->onlySetData(modelForPointers->index(row, 4), QVariant(tr("NULL")), Qt::EditRole); |
537 | 564 | ||
538 | 565 | ||
539 | modelForPointers->submitAll(); |
566 | modelForPointers->submitAll(); |
540 | 567 | ||
- | 568 | ||
- | 569 | ||
- | 570 | ||
- | 571 | ||
- | 572 | ||
- | 573 | ||
- | 574 | ||
- | 575 | /*
|
|
- | 576 | ||
- | 577 | str_fltr = tr("ClassIdentifer = ");
|
|
- | 578 | modelForPointers->setInctance(Inctance_str); // ïåðåäàåì â ìîäåëü ïîëåé èìÿ òåêóùåé òàáëèöû-õðàíèëèùà
|
|
- | 579 | str_fltr.append(class_indx);
|
|
- | 580 | str_fltr.append(tr(" AND FieldType = \"pointer\""));
|
|
- | 581 | // str_fltr.append( tr(" FieldType = pointer "));
|
|
- | 582 | ||
- | 583 | ||
- | 584 | ||
- | 585 | modelForPointers->setFilter(str_fltr);
|
|
- | 586 | modelForPointers->select();
|
|
- | 587 | ui->tableView_3->setModel(modelForPointers);
|
|
- | 588 | ui->tableView_3->resizeColumnsToContents();
|
|
- | 589 | */
|
|
- | 590 | ||
- | 591 | ||
- | 592 | ||
- | 593 | ||
- | 594 | // modelForPointers->select();
|
|
- | 595 | ||
- | 596 | ||
- | 597 | ||
- | 598 | ||
- | 599 | ||
541 | ClassEditor::refreshInctance(); |
600 | ClassEditor::refreshInctance(); |
542 | 601 | ||
543 | 602 | ||
544 | 603 | ||
545 | 604 | ||
Строка 929... | Строка 988... | ||
929 | ClassEditor::modelForPointers->select(); |
988 | ClassEditor::modelForPointers->select(); |
930 | ui->tableView_3->resizeColumnsToContents(); |
989 | ui->tableView_3->resizeColumnsToContents(); |
931 | 990 | ||
932 | }
|
991 | }
|
933 | 992 | ||
- | 993 | ||
- | 994 | // Ñ÷èòûâàåì íàñòðîéêè
|
|
- | 995 | ||
- | 996 | void ClassEditor::readSettings() |
|
- | 997 | {
|
|
- | 998 | QSettings settings("Trolltech", "Application Example"); |
|
- | 999 | baseName = settings.value("baseName", "an_db").toString(); |
|
- | 1000 | userName = settings.value("userName", "an").toString(); |
|
- | 1001 | password = settings.value("password", "393939").toString(); |
|
- | 1002 | tableName = settings.value("tableName", "inventar").toString(); |
|
- | 1003 | hostName = settings.value("hostName", "server").toString(); |
|
- | 1004 | // resize(size);
|
|
- | 1005 | // move(pos);tableName
|
|
- | 1006 | }
|
|
- | 1007 | ||
- | 1008 | ||
- | 1009 | void ClassEditor::writeSettings() |
|
- | 1010 | {
|
|
- | 1011 | QSettings settings("Trolltech", "Application Example"); |
|
- | 1012 | settings.setValue("baseName", baseName); |
|
- | 1013 | settings.setValue("userName", userName); |
|
- | 1014 | settings.setValue("password", password); |
|
- | 1015 | settings.setValue("tableName", tableName); |
|
- | 1016 | settings.setValue("hostName", hostName); |
|
- | 1017 | }
|
|
- | 1018 | ||
- | 1019 | ||
- | 1020 | void ClassEditor::applySetting() |
|
- | 1021 | {
|
|
- | 1022 | bool ok; |
|
- | 1023 | baseName = setFrm.lineEdit->text(); |
|
- | 1024 | userName = setFrm.lineEdit_2->text(); |
|
- | 1025 | password = setFrm.lineEdit_3->text(); |
|
- | 1026 | // tableName = setFrm->lineEdit_4->text();
|
|
- | 1027 | hostName = setFrm.lineEdit_5->text(); |
|
- | 1028 | writeSettings(); |
|
- | 1029 | ||
- | 1030 | sql.close(); // ðàçðûâàåì ñîåäèíåíèå ñ áàçîé |
|
- | 1031 | ||
- | 1032 | sql.setDatabaseName(baseName); |
|
- | 1033 | // sql.setDatabaseName(tr("inventory"));
|
|
- | 1034 | ||
- | 1035 | // sql.setHostName(tr("localhost"));
|
|
- | 1036 | sql.setHostName(hostName); |
|
- | 1037 | ||
- | 1038 | // sql.setUserName(tr("an"));
|
|
- | 1039 | ||
- | 1040 | sql.setUserName(userName); |
|
- | 1041 | ||
- | 1042 | // sql.setPassword(tr("393939"));
|
|
- | 1043 | ||
- | 1044 | sql.setPassword(password); |
|
- | 1045 | ||
- | 1046 | ok = sql.connect(); |
|
- | 1047 | if (!ok) { |
|
- | 1048 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
|
- | 1049 | this, // Ðîäèòåëüñêèé âèäæåò. |
|
- | 1050 | QObject::tr("Database Error"), // Çàãîëîâîê. |
|
- | 1051 | sql.lasError()); // Òåêñò ñîîáùåíèÿ. |
|
- | 1052 | ||
- | 1053 | }
|
|
- | 1054 | else { |
|
- | 1055 | ||
- | 1056 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
|
- | 1057 | this, // Ðîäèòåëüñêèé âèäæåò. |
|
- | 1058 | QObject::tr("Database Connect"), // Çàãîëîâîê. |
|
- | 1059 | QObject::tr("Ñîåäèíåíèå ñ áàçîé äàííûõ óñïåøíî óñòàíîâëåíî.")); // Òåêñò ñîîáùåíèÿ. |
|
- | 1060 | ||
- | 1061 | ||
- | 1062 | ||
- | 1063 | ||
- | 1064 | ||
- | 1065 | }
|
|
- | 1066 | ||
- | 1067 | ||
- | 1068 | mymodel->select(); |
|
- | 1069 | model->select(); |
|
- | 1070 | modelForDescription->select(); |
|
- | 1071 | ||
- | 1072 | //////////// ok=openDataBase();
|
|
- | 1073 | //////////// if (!ok) return;
|
|
- | 1074 | // // // ui->treeWidget->clear(); // î÷èùàåì äåðåâî ñ ìîäåëüþ
|
|
- | 1075 | ||
- | 1076 | // // // buildPreviewModel(tr("Ìîÿ ìîäåëü"), tr("1"));
|
|
- | 1077 | //////////// class_list_map.clear(); // î÷èùàåì ñïèñîê êëàññîâ
|
|
- | 1078 | //////////// initComboBox();
|
|
- | 1079 | // // // getDatabaseData();
|
|
- | 1080 | // delete setFrm;
|
|
- | 1081 | setFrm.close(); |
|
- | 1082 | }
|
|
- | 1083 | ||
- | 1084 | void ClassEditor::getSetting() |
|
- | 1085 | {
|
|
- | 1086 | // setFrm = new settingForm;
|
|
- | 1087 | // // // connect(setFrm.pushButton, SIGNAL(clicked()), this, SLOT(applySetting()));
|
|
- | 1088 | setFrm.lineEdit->setText(baseName); |
|
- | 1089 | setFrm.lineEdit_2->setText(userName); |
|
- | 1090 | setFrm.lineEdit_3->setText(password); |
|
- | 1091 | // setFrm->lineEdit_4->setText(tableName);
|
|
- | 1092 | setFrm.lineEdit_5->setText(hostName); |
|
- | 1093 | setFrm.show(); |
|
- | 1094 | ||
- | 1095 | ||
- | 1096 | ||
- | 1097 | }
|
|
- | 1098 | ||
- | 1099 | ||
- | 1100 | void ClassEditor::initDataBase(){ // íàñòðîéêà ïàðàìåòðîâ ñîåäèíåíèÿ è óñòàíîâêà ñîåäèíåíèÿ |
|
- | 1101 | ||
- | 1102 | ||
- | 1103 | }
|