Редакция 44 | Редакция 46 | К новейшей редакции | Весь файл | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
| Редакция 44 | Редакция 45 | ||
|---|---|---|---|
| Строка 1... | Строка 1... | ||
| 1 | #include "classeditor.h"
|
1 | #include "classeditor.h"
|
| 2 | #include "ui_classeditor.h"
|
2 | #include "ui_classeditor.h"
|
| 3 | 3 | ||
| - | 4 | ||
| 4 | ClassEditor::ClassEditor(QWidget *parent) : |
5 | ClassEditor::ClassEditor(QWidget *parent) : |
| 5 | QMainWindow(parent), |
6 | QMainWindow(parent), |
| 6 | ui(new Ui::ClassEditor) |
7 | ui(new Ui::ClassEditor) |
| 7 | {
|
8 | {
|
| 8 | ui->setupUi(this); |
9 | ui->setupUi(this); |
| Строка 47... | Строка 48... | ||
| 47 | ui->label_2->setText(table->name()); |
48 | ui->label_2->setText(table->name()); |
| 48 | ui->label->setText(table->fields().at(0)->sqlString()); |
49 | ui->label->setText(table->fields().at(0)->sqlString()); |
| 49 | ui->label_4->setText(table->sqlString()); |
50 | ui->label_4->setText(table->sqlString()); |
| 50 | ////// ui->lineEdit->insert(table->sqlString());
|
51 | ////// ui->lineEdit->insert(table->sqlString());
|
| 51 | 52 | ||
| - | 53 | ||
| - | 54 | /**********************************************
|
|
| - | 55 | ||
| 52 | QTextDocument *document; |
56 | QTextDocument *document;
|
| 53 | // = ui->textEdit->document();
|
57 | // = ui->textEdit->document();
|
| 54 | QTextCursor *cursor; |
58 | QTextCursor *cursor;
|
| - | 59 | ||
| 55 | document = ui->textEdit->document(); |
60 | document = ui->textEdit->document();
|
| 56 | cursor = new QTextCursor(document); |
61 | cursor = new QTextCursor(document);
|
| 57 | cursor->movePosition(QTextCursor::Start); |
62 | cursor->movePosition(QTextCursor::Start);
|
| 58 | QTextCharFormat format(cursor->charFormat()); |
63 | QTextCharFormat format(cursor->charFormat());
|
| 59 | //format.setFontFamily("Courier");
|
64 | //format.setFontFamily("Courier");
|
| Строка 69... | Строка 74... | ||
| 69 | // format.setFontFamily("Arial");
|
74 | // format.setFontFamily("Arial");
|
| 70 | italicFormat.setFontItalic(true); |
75 | italicFormat.setFontItalic(true);
|
| 71 | 76 | ||
| 72 | cursor->insertText(table->sqlString(), format); |
77 | cursor->insertText(table->sqlString(), format);
|
| 73 | 78 | ||
| - | 79 | ****************************************************/
|
|
| - | 80 | ||
| 74 | QString errorString;
|
81 | QString errorString;
|
| 75 | 82 | ||
| 76 | sql.setDatabaseName(tr("an_db")); |
83 | sql.setDatabaseName(tr("an_db")); |
| 77 | sql.setHostName(tr("localhost")); |
84 | sql.setHostName(tr("localhost")); |
| 78 | sql.setUserName(tr("an")); |
85 | sql.setUserName(tr("an")); |
| Строка 82... | Строка 89... | ||
| 82 | ok = sql.connect(); |
89 | ok = sql.connect(); |
| 83 | if (!ok) { |
90 | if (!ok) { |
| 84 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
91 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
| 85 | this, // Ðîäèòåëüñêèé âèäæåò. |
92 | this, // Ðîäèòåëüñêèé âèäæåò. |
| 86 | QObject::tr("Database Error"), // Çàãîëîâîê. |
93 | QObject::tr("Database Error"), // Çàãîëîâîê. |
| 87 | sql.mysqlLastError); // Òåêñò ñîîáùåíèÿ. |
94 | sql.lasError()); // Òåêñò ñîîáùåíèÿ. |
| 88 | 95 | ||
| 89 | }
|
96 | }
|
| 90 | else { |
97 | else { |
| 91 | 98 | ||
| 92 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
99 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
| Строка 104... | Строка 111... | ||
| 104 | ok = sql.createTable(table); |
111 | ok = sql.createTable(table); |
| 105 | if (!ok) { |
112 | if (!ok) { |
| 106 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
113 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
| 107 | this, // Ðîäèòåëüñêèé âèäæåò. |
114 | this, // Ðîäèòåëüñêèé âèäæåò. |
| 108 | QObject::tr("Database Error"), // Çàãîëîâîê. |
115 | QObject::tr("Database Error"), // Çàãîëîâîê. |
| 109 | sql.mysqlLastError); // Òåêñò ñîîáùåíèÿ. |
116 | sql.lasError()); // Òåêñò ñîîáùåíèÿ. |
| 110 | - | ||
| 111 | }
|
117 | }
|
| 112 | else { |
118 | else { |
| 113 | 119 | ||
| 114 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
120 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
| 115 | this, // Ðîäèòåëüñêèé âèäæåò. |
121 | this, // Ðîäèòåëüñêèé âèäæåò. |
| 116 | QObject::tr("Database Connect"), // Çàãîëîâîê. |
122 | QObject::tr("Database Connect"), // Çàãîëîâîê. |
| 117 | QObject::tr("Òàáëèöà â áàçå äàííûõ óñïåøíî ñîçäàíà.")); // Òåêñò ñîîáùåíèÿ. |
123 | QObject::tr("Òàáëèöà â áàçå äàííûõ óñïåøíî ñîçäàíà.")); // Òåêñò ñîîáùåíèÿ. |
| - | 124 | }
|
|
| 118 | 125 | ||
| 119 | 126 | ||
| 120 | 127 | ||
| 121 | 128 | ||
| 122 | 129 | ||
| - | 130 | ok = sql.createDataBase(); |
|
| 123 | }
|
131 | |
| - | 132 | if (!ok) { |
|
| - | 133 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
|
| - | 134 | this, // Ðîäèòåëüñêèé âèäæåò. |
|
| - | 135 | QObject::tr("Database Error"), // Çàãîëîâîê. |
|
| - | 136 | sql.lasError()); // Òåêñò ñîîáùåíèÿ. |
|
| - | 137 | ||
| - | 138 | }
|
|
| - | 139 | else { |
|
| 124 | 140 | ||
| - | 141 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
|
| - | 142 | this, // Ðîäèòåëüñêèé âèäæåò. |
|
| - | 143 | QObject::tr("Database Create"), // Çàãîëîâîê. |
|
| - | 144 | QObject::tr("Áàçà äàííûõ óñïåøíî ñîçäàíà.")); // Òåêñò ñîîáùåíèÿ. |
|
| - | 145 | }
|
|
| - | 146 | ||
| - | 147 | ||
| - | 148 | model = new QSqlTableModel(this); |
|
| - | 149 | model->setTable(tr("ListOfClasses")); |
|
| - | 150 | /////model->setEditStrategy(QSqlTableModel::OnManualSubmit);
|
|
| - | 151 | model->setEditStrategy(QSqlTableModel::OnFieldChange); |
|
| - | 152 | model->setSort(0, Qt::AscendingOrder); |
|
| - | 153 | // model->setFilter(tr("Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà = '7' and Èíâåíòàðíûé_íîìåð = 'i09090909'"));
|
|
| - | 154 | model->select(); |
|
| - | 155 | ui->tableView->setModel(model); |
|
| - | 156 | ui->tableView->setAlternatingRowColors(true); |
|
| - | 157 | ui->tableView->resizeColumnsToContents(); |
|
| - | 158 | ui->tableView->hideColumn(0); |
|
| - | 159 | ||
| - | 160 | int row = model->rowCount(); |
|
| - | 161 | model->insertRows(row, 1); |
|
| - | 162 | model->setData(model->index(row, 0), row+1); |
|
| - | 163 | // model->setData(model->index(row, 1), tr("Âàñÿ Ïóïê èí"));
|
|
| - | 164 | // model->setData(model->index(row, 2) , tr("Ìóõîñðà íñê, Çàæîïèíñêèå âûñåëêè ä 1"));
|
|
| - | 165 | ||
| - | 166 | model->submitAll(); |
|
| 125 | }
|
167 | }
|
| 126 | 168 | ||
| - | 169 | ||
| - | 170 | ||
| - | 171 | ||
| - | 172 | ||
| - | 173 | ||
| - | 174 | ||
| - | 175 | ||
| - | 176 | ||
| - | 177 | ||
| - | 178 | ||
| 127 | ClassEditor::~ClassEditor() |
179 | ClassEditor::~ClassEditor() |
| 128 | {
|
180 | {
|
| 129 | delete ui; |
181 | delete ui; |
| 130 | // delete field;
|
182 | // delete field;
|
| 131 | // delete settdialog;
|
183 | // delete settdialog;
|