Редакция 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(); |
|
169 | 201 | ||
- | 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 |