Редакция 55 | Редакция 59 | К новейшей редакции | Весь файл | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
| Редакция 55 | Редакция 56 | ||
|---|---|---|---|
| Строка 8... | Строка 8... | ||
| 8 | {
|
8 | {
|
| 9 | ui->setupUi(this); |
9 | ui->setupUi(this); |
| 10 | // settdialog = new SettingsDialog(this);
|
10 | // settdialog = new SettingsDialog(this);
|
| 11 | settdialog.show(); |
11 | settdialog.show(); |
| 12 | sql.setDatabaseName(tr("an_db")); |
12 | sql.setDatabaseName(tr("an_db")); |
| - | 13 | ||
| 13 | field = new TableField(tr("Ñîòðóäíèêè"), this); |
14 | field = new TableField(tr("Ñîòðóäíèêè"), this); |
| 14 | field->setNotNull(true); |
15 | field->setNotNull(true); |
| 15 | field->setDefaultValue(tr("ñîòðóäíèê")); |
16 | field->setDefaultValue(tr("ñîòðóäíèê")); |
| 16 | 17 | ||
| 17 | table = new SqlTable (tr("NewTable"), this); |
18 | table = new SqlTable (tr("NewTable"), this); |
| Строка 125... | Строка 126... | ||
| 125 | 126 | ||
| 126 | 127 | ||
| 127 | 128 | ||
| 128 | 129 | ||
| 129 | 130 | ||
| 130 | ok = sql.createDataBase(); |
131 | ok = sql.createListOfClassesTable(); |
| 131 | 132 | ||
| 132 | if (!ok) { |
133 | if (!ok) { |
| 133 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
134 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
| 134 | this, // Ðîäèòåëüñêèé âèäæåò. |
135 | this, // Ðîäèòåëüñêèé âèäæåò. |
| 135 | QObject::tr("Database Error"), // Çàãîëîâîê. |
136 | QObject::tr("Database Error"), // Çàãîëîâîê. |
| Строка 143... | Строка 144... | ||
| 143 | QObject::tr("Database Create"), // Çàãîëîâîê. |
144 | QObject::tr("Database Create"), // Çàãîëîâîê. |
| 144 | QObject::tr("Áàçà äàííûõ óñïåøíî ñîçäàíà.")); // Òåêñò ñîîáùåíèÿ. |
145 | QObject::tr("Áàçà äàííûõ óñïåøíî ñîçäàíà.")); // Òåêñò ñîîáùåíèÿ. |
| 145 | }
|
146 | }
|
| 146 | 147 | ||
| 147 | 148 | ||
| 148 | model = new QSqlTableModel(this); |
- | |
| 149 | mymodel = new MyModel(this); |
- | |
| 150 | 149 | ||
| 151 | 150 | ||
| - | 151 | ok = sql.createDescriptionOfClassesTable(); |
|
| - | 152 | ||
| - | 153 | if (!ok) { |
|
| - | 154 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
|
| - | 155 | this, // Ðîäèòåëüñêèé âèäæåò. |
|
| - | 156 | QObject::tr("Database Error"), // Çàãîëîâîê. |
|
| - | 157 | sql.lasError()); // Òåêñò ñîîáùåíèÿ. |
|
| - | 158 | ||
| - | 159 | }
|
|
| - | 160 | else { |
|
| - | 161 | ||
| - | 162 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
|
| - | 163 | this, // Ðîäèòåëüñêèé âèäæåò. |
|
| - | 164 | QObject::tr("Database Create"), // Çàãîëîâîê. |
|
| - | 165 | QObject::tr("Áàçà äàííûõ óñïåøíî ñîçäàíà.")); // Òåêñò ñîîáùåíèÿ. |
|
| - | 166 | }
|
|
| - | 167 | ||
| - | 168 | ||
| - | 169 | ||
| - | 170 | ||
| - | 171 | ||
| - | 172 | ||
| - | 173 | ||
| - | 174 | /////////////////model = new QSqlTableModel(this);
|
|
| - | 175 | mymodel = new MyModel(this); |
|
| - | 176 | modelForDescription = new QSqlTableModel(this); |
|
| - | 177 | ||
| 152 | model->setTable(tr("ListOfClasses")); |
178 | /////////////////model->setTable(tr("ListOfClasses"));
|
| 153 | mymodel->setTable(tr("ListOfClasses")); |
179 | mymodel->setTable(tr("ListOfClasses")); |
| - | 180 | modelForDescription->setTable(tr("DescriptionOfClasses")); |
|
| - | 181 | modelForDescription->setEditStrategy(QSqlTableModel::OnFieldChange); |
|
| 154 | 182 | ||
| 155 | /////model->setEditStrategy(QSqlTableModel::OnManualSubmit);
|
183 | /////model->setEditStrategy(QSqlTableModel::OnManualSubmit);
|
| 156 | 184 | ||
| 157 | /*
|
185 | /*
|
| 158 | model->setEditStrategy(QSqlTableModel::OnFieldChange);
|
186 | model->setEditStrategy(QSqlTableModel::OnFieldChange);
|
| 159 | mymodel->setEditStrategy(QSqlTableModel::OnFieldChange);
|
187 | mymodel->setEditStrategy(QSqlTableModel::OnFieldChange);
|
| 160 | */
|
188 | */
|
| 161 | 189 | ||
| 162 | 190 | ||
| 163 | model->setSort(0, Qt::AscendingOrder); |
191 | //////////////////model->setSort(0, Qt::AscendingOrder);
|
| 164 | mymodel->setSort(0, Qt::AscendingOrder); |
192 | mymodel->setSort(0, Qt::AscendingOrder); |
| - | 193 | modelForDescription->setSort(0, Qt::AscendingOrder); |
|
| - | 194 | ||
| 165 | 195 | ||
| 166 | // model->setFilter(tr("Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà = '7' and Èíâåíòàðíûé_íîìåð = 'i09090909'"));
|
196 | // model->setFilter(tr("Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà = '7' and Èíâåíòàðíûé_íîìåð = 'i09090909'"));
|
| 167 | model->select(); |
197 | ////////////////////model->select();
|
| 168 | mymodel->select(); |
198 | mymodel->select(); |
| - | 199 | modelForDescription->setFilter(tr("ClassIdentifer = 1")); |
|
| - | 200 | modelForDescription->select(); |
|
| - | 201 | ||
| 169 | 202 | ||
| 170 | model->setHeaderData(1, Qt::Horizontal, tr("Èìÿ êëàññà")); |
203 | /////////////////////////model->setHeaderData(1, Qt::Horizontal, tr("Èìÿ êëàññà"));
|
| 171 | mymodel->setHeaderData(1, Qt::Horizontal, tr("Èìÿ êëàññà")); |
204 | mymodel->setHeaderData(1, Qt::Horizontal, tr("Èìÿ êëàññà")); |
| 172 | 205 | ||
| 173 | 206 | ||
| 174 | 207 | ||
| 175 | model->setHeaderData(2, Qt::Horizontal, tr("Ïñåâäîíèì êëàññà")); |
208 | ////////////////////////model->setHeaderData(2, Qt::Horizontal, tr("Ïñåâäîíèì êëàññà"));
|
| 176 | mymodel->setHeaderData(2, Qt::Horizontal, tr("Ïñåâäîíèì êëàññà")); |
209 | mymodel->setHeaderData(2, Qt::Horizontal, tr("Ïñåâäîíèì êëàññà")); |
| 177 | 210 | ||
| 178 | //ui->tableView->setModel(model);
|
211 | //ui->tableView->setModel(model);
|
| 179 | ui->tableView->setModel(mymodel); |
212 | ui->tableView->setModel(mymodel); |
| 180 | - | ||
| 181 | - | ||
| - | 213 | //tableForDescription = new QTableView();
|
|
| - | 214 | ui->tableView_2->setModel(modelForDescription); |
|
| - | 215 | ui->tableView_2->setAlternatingRowColors(true); |
|
| - | 216 | ui->tableView_2->resizeColumnsToContents(); |
|
| - | 217 | //tableForDescription->show();
|
|
| 182 | 218 | ||
| 183 | 219 | ||
| 184 | ui->tableView->setAlternatingRowColors(true); |
220 | ui->tableView->setAlternatingRowColors(true); |
| 185 | ui->tableView->resizeColumnsToContents(); |
221 | ui->tableView->resizeColumnsToContents(); |
| 186 | ui->tableView->hideColumn(0); |
222 | //ui->tableView->hideColumn(0);
|
| 187 | ui->tableView->hideColumn(3); |
223 | ui->tableView->hideColumn(3); |
| 188 | 224 | ||
| 189 | 225 | ||
| 190 | //connect(ui->tableView, SIGNAL(clicked(const QModelIndex)), this, SLOT(on_tableView_clicked(const QModelIndex)));
|
226 | //connect(ui->tableView, SIGNAL(clicked(const QModelIndex)), this, SLOT(on_tableView_clicked(const QModelIndex)));
|
| 191 | }
|
227 | }
|
| Строка 271... | Строка 307... | ||
| 271 | 307 | ||
| 272 | // model->setData(model->index(row, 1), tr("Âàñÿ Ïóïê èí"));
|
308 | // model->setData(model->index(row, 1), tr("Âàñÿ Ïóïê èí"));
|
| 273 | // model->setData(model->index(row, 2) , tr("Ìóõîñðà íñê, Çàæîïèíñêèå âûñåëêè ä 1"));
|
309 | // model->setData(model->index(row, 2) , tr("Ìóõîñðà íñê, Çàæîïèíñêèå âûñåëêè ä 1"));
|
| 274 | 310 | ||
| 275 | 311 | ||
| 276 | mymodel->submitAll(); |
312 | //mymodel->submitAll();
|
| 277 | 313 | ||
| 278 | //row = mymodel->rowCount();
|
314 | //row = mymodel->rowCount();
|
| 279 | 315 | ||
| 280 | 316 | ||
| 281 | mymodel->select(); |
317 | //mymodel->select();
|
| 282 | 318 | ||
| 283 | 319 | ||
| 284 | }
|
320 | }
|
| 285 | 321 | ||
| 286 | 322 | ||
| Строка 297... | Строка 333... | ||
| 297 | void ClassEditor::on_tableView_clicked(const QModelIndex & index ){ |
333 | void ClassEditor::on_tableView_clicked(const QModelIndex & index ){ |
| 298 | int i, row, column; |
334 | int i, row, column; |
| 299 | i++; |
335 | i++; |
| 300 | row = index.row(); |
336 | row = index.row(); |
| 301 | column = index.column(); |
337 | column = index.column(); |
| - | 338 | QModelIndex index_tmp;
|
|
| - | 339 | QString tmp_str, filter_str;
|
|
| - | 340 | index_tmp = ui->tableView->model()->index(row, 0); |
|
| - | 341 | tmp_str = ui->tableView->model()->data(index_tmp).toString(); |
|
| - | 342 | ui->label->setText(tmp_str); |
|
| - | 343 | filter_str = tr("ClassIdentifer = "); |
|
| - | 344 | filter_str.append(tmp_str); |
|
| - | 345 | modelForDescription->setFilter(filter_str); |
|
| - | 346 | i++; |
|
| 302 | }
|
347 | }
|
| 303 | 348 | ||