Редакция 44 | Редакция 46 | К новейшей редакции | Только различия | Учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 44 | Редакция 45 | ||
---|---|---|---|
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); |
9 | // settdialog = new SettingsDialog(this);
|
10 | // settdialog = new SettingsDialog(this);
|
10 | settdialog.show(); |
11 | settdialog.show(); |
11 | sql.setDatabaseName(tr("an_db")); |
12 | sql.setDatabaseName(tr("an_db")); |
12 | field = new TableField(tr("Ñîòðóäíèêè"), this); |
13 | field = new TableField(tr("Ñîòðóäíèêè"), this); |
13 | field->setNotNull(true); |
14 | field->setNotNull(true); |
14 | field->setDefaultValue(tr("ñîòðóäíèê")); |
15 | field->setDefaultValue(tr("ñîòðóäíèê")); |
15 | 16 | ||
16 | table = new SqlTable (tr("NewTable"), this); |
17 | table = new SqlTable (tr("NewTable"), this); |
17 | table->setName(tr("NewTable")); |
18 | table->setName(tr("NewTable")); |
18 | table->fields().at(0)->setNotNull(true); |
19 | table->fields().at(0)->setNotNull(true); |
19 | if (!(table->setPrimaryKey(tr("ID")))) { |
20 | if (!(table->setPrimaryKey(tr("ID")))) { |
20 | ui->label_3->setText(table->lastError()); |
21 | ui->label_3->setText(table->lastError()); |
21 | }
|
22 | }
|
22 | else ui->label_3->setText(table->primaryKey()); |
23 | else ui->label_3->setText(table->primaryKey()); |
23 | table->append(field); |
24 | table->append(field); |
24 | 25 | ||
25 | field = new TableField(tr("Êîìïüþòåðû"), this); |
26 | field = new TableField(tr("Êîìïüþòåðû"), this); |
26 | field->setNotNull(true); |
27 | field->setNotNull(true); |
27 | field->setDefaultValue(tr("êîìïüþòåð")); |
28 | field->setDefaultValue(tr("êîìïüþòåð")); |
28 | table->append(field); |
29 | table->append(field); |
29 | 30 | ||
30 | field = new TableField(tr("Ìîíèòîðû"), this); |
31 | field = new TableField(tr("Ìîíèòîðû"), this); |
31 | field->setNotNull(true); |
32 | field->setNotNull(true); |
32 | field->setDefaultValue(tr("ìîíèòîð")); |
33 | field->setDefaultValue(tr("ìîíèòîð")); |
33 | table->append(field); |
34 | table->append(field); |
34 | 35 | ||
35 | field = new TableField(tr("Êîëè÷åñòâî (øòóê)"), this); |
36 | field = new TableField(tr("Êîëè÷åñòâî (øòóê)"), this); |
36 | field->setNotNull(true); |
37 | field->setNotNull(true); |
37 | field->setType(tr("INTEGER")); |
38 | field->setType(tr("INTEGER")); |
38 | field->setDefaultValue(tr("1")); |
39 | field->setDefaultValue(tr("1")); |
39 | table->append(field); |
40 | table->append(field); |
40 | 41 | ||
41 | field = new TableField(tr("Äåíü ðîæäåíèÿ"), this); |
42 | field = new TableField(tr("Äåíü ðîæäåíèÿ"), this); |
42 | field->setNotNull(false); |
43 | field->setNotNull(false); |
43 | field->setType(tr("DATE")); |
44 | field->setType(tr("DATE")); |
44 | field->setDefaultValue(tr("NULL")); |
45 | field->setDefaultValue(tr("NULL")); |
45 | table->append(field); |
46 | table->append(field); |
46 | 47 | ||
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");
|
60 | format.setFontFamily("Arial"); |
65 | format.setFontFamily("Arial");
|
61 | //format.setFontItalic(false);
|
66 | //format.setFontItalic(false);
|
62 | 67 | ||
63 | format.setFontWeight(QFont::Normal); |
68 | format.setFontWeight(QFont::Normal);
|
64 | QTextCharFormat boldFormat = format; |
69 | QTextCharFormat boldFormat = format;
|
65 | boldFormat.setFontWeight(QFont::Bold); |
70 | boldFormat.setFontWeight(QFont::Bold);
|
66 | 71 | ||
67 | QTextCharFormat italicFormat = format; |
72 | QTextCharFormat italicFormat = format;
|
68 | //format.setFontFamily("Courier");
|
73 | //format.setFontFamily("Courier");
|
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")); |
79 | sql.setPassword(tr("393939")); |
86 | sql.setPassword(tr("393939")); |
80 | 87 | ||
81 | bool ok; |
88 | bool ok; |
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( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
93 | this, // Ðîäèòåëüñêèé âèäæåò. |
100 | this, // Ðîäèòåëüñêèé âèäæåò. |
94 | QObject::tr("Database Connect"), // Çàãîëîâîê. |
101 | QObject::tr("Database Connect"), // Çàãîëîâîê. |
95 | QObject::tr("Ñîåäèíåíèå ñ áàçîé äàííûõ óñïåøíî óñòàíîâëåíî.")); // Òåêñò ñîîáùåíèÿ. |
102 | QObject::tr("Ñîåäèíåíèå ñ áàçîé äàííûõ óñïåøíî óñòàíîâëåíî.")); // Òåêñò ñîîáùåíèÿ. |
96 | 103 | ||
97 | 104 | ||
98 | 105 | ||
99 | 106 | ||
100 | 107 | ||
101 | }
|
108 | }
|
102 | 109 | ||
103 | 110 | ||
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;
|
132 | }
|
184 | }
|
133 | 185 | ||
134 | void ClassEditor::changeEvent(QEvent *e) |
186 | void ClassEditor::changeEvent(QEvent *e) |
135 | {
|
187 | {
|
136 | QMainWindow::changeEvent(e); |
188 | QMainWindow::changeEvent(e); |
137 | switch (e->type()) { |
189 | switch (e->type()) { |
138 | case QEvent::LanguageChange: |
190 | case QEvent::LanguageChange: |
139 | ui->retranslateUi(this); |
191 | ui->retranslateUi(this); |
140 | break; |
192 | break; |
141 | default: |
193 | default: |
142 | break; |
194 | break; |
143 | }
|
195 | }
|
144 | }
|
196 | }
|
145 | 197 |