Редакция 45 |
Редакция 50 |
К новейшей редакции |
Авторство |
Сравнить с предыдущей |
Последнее изменение |
Открыть журнал
| Скачать
| RSS
#include "classeditor.h"
#include "ui_classeditor.h"
ClassEditor::ClassEditor(QWidget *parent) :
QMainWindow(parent),
ui(new Ui::ClassEditor)
{
ui->setupUi(this);
// settdialog = new SettingsDialog(this);
settdialog.show();
sql.setDatabaseName(tr("an_db"));
field = new TableField(tr("Ñîòðóäíèêè"), this);
field->setNotNull(true);
field->setDefaultValue(tr("ñîòðóäíèê"));
table = new SqlTable (tr("NewTable"), this);
table->setName(tr("NewTable"));
table->fields().at(0)->setNotNull(true);
if (!(table->setPrimaryKey(tr("ID")))) {
ui->label_3->setText(table->lastError());
}
else ui->label_3->setText(table->primaryKey());
table->append(field);
field = new TableField(tr("Êîìïüþòåðû"), this);
field->setNotNull(true);
field->setDefaultValue(tr("êîìïüþòåð"));
table->append(field);
field = new TableField(tr("Ìîíèòîðû"), this);
field->setNotNull(true);
field->setDefaultValue(tr("ìîíèòîð"));
table->append(field);
field = new TableField(tr("Êîëè÷åñòâî (øòóê)"), this);
field->setNotNull(true);
field->setType(tr("INTEGER"));
field->setDefaultValue(tr("1"));
table->append(field);
field = new TableField(tr("Äåíü ðîæäåíèÿ"), this);
field->setNotNull(false);
field->setType(tr("DATE"));
field->setDefaultValue(tr("NULL"));
table->append(field);
ui->label_2->setText(table->name());
ui->label->setText(table->fields().at(0)->sqlString());
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);
QTextCharFormat format(cursor->charFormat());
//format.setFontFamily("Courier");
format.setFontFamily("Arial");
//format.setFontItalic(false);
format.setFontWeight(QFont::Normal);
QTextCharFormat boldFormat = format;
boldFormat.setFontWeight(QFont::Bold);
QTextCharFormat italicFormat = format;
//format.setFontFamily("Courier");
// format.setFontFamily("Arial");
italicFormat.setFontItalic(true);
cursor->insertText(table->sqlString(), format);
****************************************************/
QString errorString;
sql.setDatabaseName(tr("an_db"));
sql.setHostName(tr("localhost"));
sql.setUserName(tr("an"));
sql.setPassword(tr("393939"));
bool ok;
ok = sql.connect();
if (!ok) {
QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
this, // Ðîäèòåëüñêèé âèäæåò.
QObject::tr("Database Error"), // Çàãîëîâîê.
sql.lasError()); // Òåêñò ñîîáùåíèÿ.
}
else {
QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
this, // Ðîäèòåëüñêèé âèäæåò.
QObject::tr("Database Connect"), // Çàãîëîâîê.
QObject::tr("Ñîåäèíåíèå ñ áàçîé äàííûõ óñïåøíî óñòàíîâëåíî.")); // Òåêñò ñîîáùåíèÿ.
}
ok = sql.createTable(table);
if (!ok) {
QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
this, // Ðîäèòåëüñêèé âèäæåò.
QObject::tr("Database Error"), // Çàãîëîâîê.
sql.lasError()); // Òåêñò ñîîáùåíèÿ.
}
else {
QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
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();
model->setHeaderData(1, Qt::Horizontal, tr("Èìÿ êëàññà"));
model->setHeaderData(2, Qt::Horizontal, tr("Ïñåâäîíèì êëàññà"));
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;
// delete field;
// delete settdialog;
}
void ClassEditor::changeEvent(QEvent *e)
{
QMainWindow::changeEvent(e);
switch (e->type()) {
case QEvent::LanguageChange:
ui->retranslateUi(this);
break;
default:
break;
}
}