1,6 → 1,7 |
#include "classeditor.h" |
#include "ui_classeditor.h" |
|
|
ClassEditor::ClassEditor(QWidget *parent) : |
QMainWindow(parent), |
ui(new Ui::ClassEditor) |
49,9 → 50,13 |
ui->label_4->setText(table->sqlString()); |
////// ui->lineEdit->insert(table->sqlString()); |
|
|
/********************************************** |
|
QTextDocument *document; |
// = ui->textEdit->document(); |
QTextCursor *cursor; |
|
document = ui->textEdit->document(); |
cursor = new QTextCursor(document); |
cursor->movePosition(QTextCursor::Start); |
71,6 → 76,8 |
|
cursor->insertText(table->sqlString(), format); |
|
****************************************************/ |
|
QString errorString; |
|
sql.setDatabaseName(tr("an_db")); |
84,7 → 91,7 |
QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
this, // Ðîäèòåëüñêèé âèäæåò. |
QObject::tr("Database Error"), // Çàãîëîâîê. |
sql.mysqlLastError); // Òåêñò ñîîáùåíèÿ. |
sql.lasError()); // Òåêñò ñîîáùåíèÿ. |
|
} |
else { |
106,8 → 113,7 |
QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
this, // Ðîäèòåëüñêèé âèäæåò. |
QObject::tr("Database Error"), // Çàãîëîâîê. |
sql.mysqlLastError); // Òåêñò ñîîáùåíèÿ. |
|
sql.lasError()); // Òåêñò ñîîáùåíèÿ. |
} |
else { |
|
115,15 → 121,61 |
this, // Ðîäèòåëüñêèé âèäæåò. |
QObject::tr("Database Connect"), // Çàãîëîâîê. |
QObject::tr("Òàáëèöà â áàçå äàííûõ óñïåøíî ñîçäàíà.")); // Òåêñò ñîîáùåíèÿ. |
} |
|
|
|
|
|
ok = sql.createDataBase(); |
|
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); |
model->setTable(tr("ListOfClasses")); |
/////model->setEditStrategy(QSqlTableModel::OnManualSubmit); |
model->setEditStrategy(QSqlTableModel::OnFieldChange); |
model->setSort(0, Qt::AscendingOrder); |
// model->setFilter(tr("Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà = '7' and Èíâåíòàðíûé_íîìåð = 'i09090909'")); |
model->select(); |
ui->tableView->setModel(model); |
ui->tableView->setAlternatingRowColors(true); |
ui->tableView->resizeColumnsToContents(); |
ui->tableView->hideColumn(0); |
|
int row = model->rowCount(); |
model->insertRows(row, 1); |
model->setData(model->index(row, 0), row+1); |
// model->setData(model->index(row, 1), tr("Âàñÿ Ïóïê èí")); |
// model->setData(model->index(row, 2) , tr("Ìóõîñðà íñê, Çàæîïèíñêèå âûñåëêè ä 1")); |
|
model->submitAll(); |
} |
|
|
|
|
|
|
|
|
|
|
|
ClassEditor::~ClassEditor() |
{ |
delete ui; |