Редакция 93 | Редакция 95 | К новейшей редакции | Только различия | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 93 | Редакция 94 | ||
---|---|---|---|
1 | #include "mainwindow.h"
|
1 | #include "mainwindow.h"
|
2 | #include "ui_mainwindow.h"
|
2 | #include "ui_mainwindow.h"
|
3 | 3 | ||
4 | MainWindow::MainWindow(QWidget *parent) : |
4 | MainWindow::MainWindow(QWidget *parent) : |
5 | QMainWindow(parent), |
5 | QMainWindow(parent), |
6 | ui(new Ui::MainWindow) |
6 | ui(new Ui::MainWindow) |
7 | {
|
7 | {
|
8 | ui->setupUi(this); |
8 | ui->setupUi(this); |
9 | 9 | ||
10 | MainWindow::readModel(); |
10 | MainWindow::readModel(); |
11 | 11 | ||
12 | //QString model_str;
|
12 | //QString model_str;
|
13 | MainWindow::creatModelString(); |
13 | MainWindow::creatModelString(); |
14 | int i; |
14 | int i; |
15 | i++; |
15 | i++; |
16 | QFile file_tmp("./temp.txt"); |
16 | QFile file_tmp("./temp.txt"); |
17 | bool ok; |
17 | bool ok; |
18 | ok = file_tmp.open(QIODevice::ReadWrite | QIODevice::Text); |
18 | ok = file_tmp.open(QIODevice::ReadWrite | QIODevice::Text); |
19 | QTextStream out(&file_tmp); |
19 | QTextStream out(&file_tmp); |
20 | out << MainWindow::modelString; |
20 | out << MainWindow::modelString; |
21 | file_tmp.close(); |
21 | file_tmp.close(); |
22 | 22 | ||
23 | MainWindow::openDataBase(); |
23 | MainWindow::openDataBase(); |
24 | 24 | ||
25 | }
|
25 | }
|
26 | 26 | ||
27 | MainWindow::~MainWindow() |
27 | MainWindow::~MainWindow() |
28 | {
|
28 | {
|
29 | delete ui; |
29 | delete ui; |
30 | }
|
30 | }
|
31 | 31 | ||
32 | void MainWindow::changeEvent(QEvent *e) |
32 | void MainWindow::changeEvent(QEvent *e) |
33 | {
|
33 | {
|
34 | Q |
34 | QMainWindow::changeEvent(e); |
35 | 35 | switch (e->type()) { |
|
36 | 36 | case QEvent::LanguageChange: |
|
37 | 37 | ui->retranslateUi(this); |
|
38 | 38 | break; |
|
39 | 39 | default: |
|
40 | 40 | break; |
|
41 | 41 | }
|
|
42 | 42 | }
|
|
43 | 43 | ||
44 | 44 | ||
45 | 45 | bool MainWindow::readModel(){ |
|
46 | 46 | bool result; |
|
47 | 47 | QString model_str;
|
|
48 | 48 | QFile file(":/model.txt"); |
|
49 | 49 | ||
50 | 50 | rootItem1 = new QTreeWidgetItem(ui->treeWidget); |
|
51 | 51 | rootItem1->setText(0, tr("Óðîâåíü 1")); |
|
52 | 52 | // rootItem2 = new QTreeWidgetItem(rootItem1);
|
|
53 | 53 | // rootItem2->setText(0, tr("óðîâåíü 2"));
|
|
54 | 54 | rootItem1->setCheckState(0,Qt::Checked); |
|
55 | 55 | // rootItem2->setCheckState(0,Qt::Checked);
|
|
56 | 56 | ||
57 | 57 | ||
58 | 58 | ||
59 | 59 | result = file.open(QIODevice::ReadOnly); |
|
60 | 60 | if (result) { |
|
61 | 61 | model_str = QString(tr(file.readAll())); |
|
62 | 62 | }
|
|
63 | 63 | ||
64 | 64 | setupModelData(model_str.split(QString("\n")), rootItem1); |
|
65 | 65 | ||
66 | 66 | ||
67 | 67 | return result; |
|
68 | 68 | ||
69 | 69 | }
|
|
70 | 70 | ||
71 | 71 | ||
72 | 72 | void MainWindow::setupModelData(const QStringList &lines, QTreeWidgetItem *parent) |
|
73 | 73 | {
|
|
74 | 74 | QList<QTreeWidgetItem*> parents; |
|
75 | 75 | QList<int> indentations; |
|
76 | 76 | parents << parent; |
|
77 | 77 | indentations << 0; |
|
78 | 78 | ||
79 | 79 | int number = 0; |
|
80 | 80 | ||
81 | 81 | while (number < lines.count()) { |
|
82 | 82 | int position = 0; |
|
83 | 83 | while (position < lines[number].length()) { |
|
84 | 84 | if (lines[number].mid(position, 1) != " ") |
|
85 | 85 | break; |
|
86 | 86 | position++; |
|
87 | 87 | }
|
|
88 | 88 | ||
89 | 89 | QString lineData = lines[number].mid(position).trimmed(); |
|
90 | 90 | ||
91 | 91 | if (!lineData.isEmpty()) { |
|
92 | 92 | // Read the column data from the rest of the line.
|
|
93 | 93 | QStringList columnStrings = lineData.split("\t", QString::SkipEmptyParts); |
|
94 | 94 | QList<QVariant> columnData; |
|
95 | 95 | for (int column = 0; column < columnStrings.count(); ++column) |
|
96 | 96 | columnData << columnStrings[column]; |
|
97 | 97 | ||
98 | 98 | if (position > indentations.last()) { |
|
99 | 99 | // The last child of the current parent is now the new parent
|
|
100 | 100 | // unless the current parent has no children.
|
|
101 | 101 | ||
102 | 102 | if (parents.last()->childCount() > 0) { |
|
103 | 103 | parents << parents.last()->child(parents.last()->childCount()-1); |
|
104 | 104 | indentations << position; |
|
105 | 105 | }
|
|
106 | 106 | } else { |
|
107 | 107 | while (position < indentations.last() && parents.count() > 0) { |
|
108 | 108 | parents.pop_back(); |
|
109 | 109 | indentations.pop_back(); |
|
110 | 110 | }
|
|
111 | 111 | }
|
|
112 | 112 | ||
113 | 113 | // Append a new item to the current parent's list of children.
|
|
114 | 114 | // // // parents.last()->appendChild(new QTreeWidgetItem(columnData, parents.last()));
|
|
115 | 115 | QTreeWidgetItem* itm_tmp; |
|
116 | 116 | itm_tmp = new QTreeWidgetItem( parents.last()); |
|
117 | 117 | ||
118 | 118 | itm_tmp->setText(0, QString(columnData.at(0).toString())); |
|
119 | 119 | if (columnData.at(1).toString() == "true") { |
|
120 | 120 | itm_tmp->setCheckState(0,Qt::Checked); |
|
121 | 121 | }
|
|
122 | 122 | else itm_tmp->setCheckState(0,Qt::Unchecked); |
|
123 | 123 | itm_tmp->setText(1, QString(columnData.at(2).toString())); |
|
124 | 124 | itm_tmp->setText(2, QVariant(number).toString()); // íîìåð ñòðîêè â ôàéëå-ìîäåëè îòîáðàæåíèÿ |
|
125 | 125 | itm_tmp->setText(3, QVariant(indentations.size()).toString()); |
|
126 | 126 | }
|
|
127 | 127 | ||
128 | 128 | number++; |
|
129 | 129 | }
|
|
130 | 130 | }
|
|
131 | 131 | ||
132 | 132 | ||
133 | 133 | /*
|
|
134 | 134 | void MainWindow::openBase()
|
|
135 | 135 | {
|
|
136 | 136 | ||
137 | 137 | db = QSqlDatabase::addDatabase("QMYSQL");
|
|
138 | 138 | pdb = &db;
|
|
139 | 139 | raportFrm.pdb = &db;
|
|
140 | 140 | ||
141 | 141 | pdb->setHostName(hostName);
|
|
142 | 142 | pdb->setDatabaseName(baseName);
|
|
143 | 143 | pdb->setUserName(userName);
|
|
144 | 144 | pdb->setPassword(password);
|
|
145 | 145 | bool ok = pdb->open();
|
|
146 | 146 | if (!ok) {
|
|
147 | 147 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
|
|
148 | 148 | this, // Ðîäèòåëüñêèé âèäæåò.
|
|
149 | 149 | QObject::tr("Database Error"), // Çàãîëîâîê.
|
|
150 | 150 | pdb->lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
|
151 | 151 | }
|
|
152 | 152 | if (ok)
|
|
153 | 153 | {lineEdit-> insert(tr("Áàçà óñïåøíî îòêðûòà"));
|
|
154 | 154 | }
|
|
155 | 155 | else {lineEdit-> insert(tr("Áàçà íåäîñòóïíà. Êîä îøèáêè: "));
|
|
156 | 156 | lineEdit-> insert(pdb->lastError().text());
|
|
157 | 157 | }
|
|
158 | 158 | ||
159 | 159 | ||
160 | 160 | ||
161 | 161 | model = new QSqlTableModel(this);
|
|
162 | 162 | model->setTable(tableName);
|
|
163 | 163 | ||
164 | 164 | model->setEditStrategy(QSqlTableModel::OnManualSubmit);
|
|
165 | 165 | model->setSort(0, Qt::AscendingOrder);
|
|
166 | 166 | ||
167 | 167 | model->select();
|
|
168 | 168 | ||
169 | 169 | ||
170 | 170 | QSqlField field(tr("age"), QVariant::Int);
|
|
171 | 171 | field.setValue(QString(tr("123")));
|
|
172 | 172 | ||
173 | 173 | bool okey;
|
|
174 | 174 | int index;
|
|
175 | 175 | QSqlRecord record;
|
|
176 | 176 | ||
177 | 177 | ||
178 | 178 | tableView->setModel(model);
|
|
179 | 179 | view.setModel(model);
|
|
180 | 180 | ||
181 | 181 | ||
182 | 182 | tableView->setAlternatingRowColors(true);
|
|
183 | 183 | view.setAlternatingRowColors(true);
|
|
184 | 184 | ||
185 | 185 | tableView->resizeColumnsToContents();
|
|
186 | 186 | ||
187 | 187 | ||
188 | 188 | view.resizeColumnsToContents();
|
|
189 | 189 | ||
190 | 190 | tableView->show();
|
|
191 | 191 | ||
192 | 192 | ||
193 | 193 | ||
194 | 194 | initTreeWidget();
|
|
195 | 195 | }
|
|
196 | 196 | */
|
|
197 | 197 | ||
198 | 198 | ||
199 | 199 | void MainWindow::creatModelString(){ |
|
200 | 200 | ||
201 | 201 | MainWindow::modelString.clear(); // î÷èùàåì ñòðîêó ìîäåëè |
|
202 | 202 | // for (int i =0; i < rootItem1->childCount(); ++i )
|
|
203 | 203 | ||
204 | 204 | {MainWindow::addChildsString(rootItem1, 0);} |
|
205 | 205 | ||
206 | 206 | int root_item_child_count; |
|
207 | 207 | int i; |
|
208 | 208 | root_item_child_count = rootItem1->childCount(); |
|
209 | 209 | i++; |
|
210 | 210 | ||
211 | 211 | }
|
|
212 | 212 | ||
213 | 213 | ||
214 | 214 | void MainWindow::addChildsString(QTreeWidgetItem *parentItem, int level){ |
|
215 | 215 | int child_count; |
|
216 | 216 | child_count = parentItem->childCount(); |
|
217 | 217 | for (int i=0; i < child_count; ++i){ |
|
218 | 218 | for (int m=0; m < level; ++m){ |
|
219 | 219 | modelString.append(tr(" ")); // ÷åòûðå ïðîáåëà - ïðèçíàê òîãî, ÷òî ýòî íîâûé óðîâåíü âëîæåíèÿ |
|
220 | 220 | }
|
|
221 | 221 | modelString.append(parentItem->child(i)->text(0)); // â ïåðâîé êîëîíêå - èìÿ êëàññà |
|
222 | 222 | modelString.append(tr("\t\t\t\t")); // ÷åòûðå òàáóëÿöèè - ïðèçíàê íîâîãî ñòîëáöà |
|
223 | 223 | if (parentItem->child(i)->checkState(0) == Qt::Checked) {modelString.append(tr("true"));} // åñëè ãàëî÷êà ñòîèò, çàíîñèì "true", ýëåìåíòû êëàññà â ïðåäñòàâëåíèè îòîáðàæàòüñÿ áóäóò |
|
224 | 224 | else {modelString.append(tr("false"));} // åñëè êëàññ íå âûáðàí - çàíîñèì "false", ýëåìåíòû êëàññà â ïðåäñòàâëåíèè îòîáðàæàòüñÿ íå áóäóò |
|
225 | 225 | modelString.append(tr("\t\t\t\t")); // ÷åòûðå òàáóëÿöèè - ïðèçíàê íîâîãî ñòîëáöà |
|
226 | 226 | modelString.append(parentItem->child(i)->text(1)); // âî âòîðîé êîëîíêå - ID êëàññà |
|
227 | 227 | modelString.append(tr("\n")); // êîíåö ñòðîêè |
|
228 | 228 | if (parentItem->child(i)->childCount() > 0) { MainWindow::addChildsString(parentItem->child(i), level+1);} |
|
229 | 229 | ||
230 | 230 | }
|
|
231 | 231 | int i; |
|
232 | 232 | i++; |
|
233 | 233 | }
|
|
234 | 234 | ||
235 | 235 | ||
236 | 236 | bool MainWindow::openDataBase(){ |
|
237 | 237 | QString errorString;
|
|
238 | 238 | sql = QSqlDatabase::addDatabase("QMYSQL"); |
|
239 | 239 | sql.setDatabaseName(tr("an_db")); |
|
240 | 240 | sql.setHostName(tr("localhost")); |
|
241 | 241 | sql.setUserName(tr("an")); |
|
242 | 242 | sql.setPassword(tr("393939")); |
|
243 | 243 | ||
244 | 244 | bool ok; |
|
245 | 245 | ok = sql.open(); |
|
246 | 246 | ||
247 | 247 | /*
|
|
248 | 248 | if (!ok) {
|
|
249 | 249 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
|
|
250 | 250 | this, // Ðîäèòåëüñêèé âèäæåò.
|
|
251 | 251 | QObject::tr("Database Error"), // Çàãîëîâîê.
|
|
252 | 252 | sql.lastError().text() ); // Òåêñò ñîîáùåíèÿ.
|
|
253 | 253 | ||
254 | 254 | ||
255 | 255 | }
|
|
256 | 256 | ||
257 | 257 | */
|
|
258 | 258 | if (!ok) { |
|
259 | 259 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
|
260 | 260 | this, // Ðîäèòåëüñêèé âèäæåò. |
|
261 | 261 | QObject::tr("Database Error"), // Çàãîëîâîê. |
|
262 | 262 | sql.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
|
263 | 263 | }
|
|
264 | 264 | else { |
|
265 | 265 | ||
266 | 266 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
|
267 | 267 | this, // Ðîäèòåëüñêèé âèäæåò. |
|
268 | 268 | QObject::tr("Database Connect"), // Çàãîëîâîê. |
|
269 | 269 | QObject::tr("Ñîåäèíåíèå ñ áàçîé äàííûõ óñïåøíî óñòàíîâëåíî.")); // Òåêñò ñîîáùåíèÿ. |
|
270 | 270 | ||
271 | 271 | ||
272 | 272 | ||
273 | 273 | ||
274 | 274 | ||
275 | 275 | }
|
|
276 | 276 | ||
277 | 277 | return ok; |
|
278 | 278 | }
|
|
- | 279 | ||
- | 280 | ||
- | 281 | bool MainWindow::buildPreviewModel(QString rootClassID){ |
|
- | 282 | QSqlQuery q;
|
|
- | 283 | QString sql_str;
|
|
- | 284 | int field_name; |
|
- | 285 | sql_str = tr("select * " |
|
- | 286 | " from DescriptionOfClasses where DescriptionOfClasses.ID = "
|
|
- | 287 | ); |
|
- | 288 | sql_str.append(rootClassID); |
|
- | 289 | ||
- | 290 | ||
- | 291 | }
|
|
- | 292 |