10,6 → 10,7 |
// settdialog = new SettingsDialog(this); |
settdialog.show(); |
sql.setDatabaseName(tr("an_db")); |
|
field = new TableField(tr("Ñîòðóäíèêè"), this); |
field->setNotNull(true); |
field->setDefaultValue(tr("ñîòðóäíèê")); |
127,7 → 128,7 |
|
|
|
ok = sql.createDataBase(); |
ok = sql.createListOfClassesTable(); |
|
if (!ok) { |
QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
145,12 → 146,39 |
} |
|
|
model = new QSqlTableModel(this); |
|
|
ok = sql.createDescriptionOfClassesTable(); |
|
if (!ok) { |
QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
this, // Ðîäèòåëüñêèé âèäæåò. |
QObject::tr("Database Error"), // Çàãîëîâîê. |
sql.lasError()); // Òåêñò ñîîáùåíèÿ. |
|
} |
else { |
|
QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
this, // Ðîäèòåëüñêèé âèäæåò. |
QObject::tr("Database Create"), // Çàãîëîâîê. |
QObject::tr("Áàçà äàííûõ óñïåøíî ñîçäàíà.")); // Òåêñò ñîîáùåíèÿ. |
} |
|
|
|
|
|
|
|
/////////////////model = new QSqlTableModel(this); |
mymodel = new MyModel(this); |
modelForDescription = new QSqlTableModel(this); |
|
|
model->setTable(tr("ListOfClasses")); |
/////////////////model->setTable(tr("ListOfClasses")); |
mymodel->setTable(tr("ListOfClasses")); |
modelForDescription->setTable(tr("DescriptionOfClasses")); |
modelForDescription->setEditStrategy(QSqlTableModel::OnFieldChange); |
|
/////model->setEditStrategy(QSqlTableModel::OnManualSubmit); |
|
160,30 → 188,38 |
*/ |
|
|
model->setSort(0, Qt::AscendingOrder); |
//////////////////model->setSort(0, Qt::AscendingOrder); |
mymodel->setSort(0, Qt::AscendingOrder); |
modelForDescription->setSort(0, Qt::AscendingOrder); |
|
|
// model->setFilter(tr("Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà = '7' and Èíâåíòàðíûé_íîìåð = 'i09090909'")); |
model->select(); |
////////////////////model->select(); |
mymodel->select(); |
modelForDescription->setFilter(tr("ClassIdentifer = 1")); |
modelForDescription->select(); |
|
model->setHeaderData(1, Qt::Horizontal, tr("Èìÿ êëàññà")); |
|
/////////////////////////model->setHeaderData(1, Qt::Horizontal, tr("Èìÿ êëàññà")); |
mymodel->setHeaderData(1, Qt::Horizontal, tr("Èìÿ êëàññà")); |
|
|
|
model->setHeaderData(2, Qt::Horizontal, tr("Ïñåâäîíèì êëàññà")); |
////////////////////////model->setHeaderData(2, Qt::Horizontal, tr("Ïñåâäîíèì êëàññà")); |
mymodel->setHeaderData(2, Qt::Horizontal, tr("Ïñåâäîíèì êëàññà")); |
|
//ui->tableView->setModel(model); |
ui->tableView->setModel(mymodel); |
//tableForDescription = new QTableView(); |
ui->tableView_2->setModel(modelForDescription); |
ui->tableView_2->setAlternatingRowColors(true); |
ui->tableView_2->resizeColumnsToContents(); |
//tableForDescription->show(); |
|
|
|
|
ui->tableView->setAlternatingRowColors(true); |
ui->tableView->resizeColumnsToContents(); |
ui->tableView->hideColumn(0); |
//ui->tableView->hideColumn(0); |
ui->tableView->hideColumn(3); |
|
|
273,12 → 309,12 |
// model->setData(model->index(row, 2) , tr("Ìóõîñðà íñê, Çàæîïèíñêèå âûñåëêè ä 1")); |
|
|
mymodel->submitAll(); |
//mymodel->submitAll(); |
|
//row = mymodel->rowCount(); |
|
|
mymodel->select(); |
//mymodel->select(); |
|
|
} |
299,5 → 335,14 |
i++; |
row = index.row(); |
column = index.column(); |
QModelIndex index_tmp; |
QString tmp_str, filter_str; |
index_tmp = ui->tableView->model()->index(row, 0); |
tmp_str = ui->tableView->model()->data(index_tmp).toString(); |
ui->label->setText(tmp_str); |
filter_str = tr("ClassIdentifer = "); |
filter_str.append(tmp_str); |
modelForDescription->setFilter(filter_str); |
i++; |
} |
|