Редакция 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 | }
|
|
- | 125 | ||
118 | 126 | ||
119 | 127 | ||
120 | 128 | ||
121 | 129 | ||
- | 130 | ok = sql.createDataBase(); |
|
- | 131 | ||
- | 132 | if (!ok) { |
|
- | 133 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
|
- | 134 | this, // Ðîäèòåëüñêèé âèäæåò. |
|
- | 135 | QObject::tr("Database Error"), // Çàãîëîâîê. |
|
- | 136 | sql.lasError()); // Òåêñò ñîîáùåíèÿ. |
|
- | 137 | ||
- | 138 | }
|
|
- | 139 | else { |
|
122 | 140 | ||
- | 141 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
|
- | 142 | this, // Ðîäèòåëüñêèé âèäæåò. |
|
- | 143 | QObject::tr("Database Create"), // Çàãîëîâîê. |
|
- | 144 | QObject::tr("Áàçà äàííûõ óñïåøíî ñîçäàíà.")); // Òåêñò ñîîáùåíèÿ. |
|
123 | }
|
145 | }
|
124 | 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;
|