Редакция 43 | Редакция 45 | К новейшей редакции | Только различия | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 43 | Редакция 44 | ||
---|---|---|---|
1 | #include "classeditor.h"
|
1 | #include "classeditor.h"
|
2 | #include "ui_classeditor.h"
|
2 | #include "ui_classeditor.h"
|
3 | 3 | ||
4 | ClassEditor::ClassEditor(QWidget *parent) : |
4 | ClassEditor::ClassEditor(QWidget *parent) : |
5 | QMainWindow(parent), |
5 | QMainWindow(parent), |
6 | ui(new Ui::ClassEditor) |
6 | ui(new Ui::ClassEditor) |
7 | {
|
7 | {
|
8 | ui->setupUi(this); |
8 | ui->setupUi(this); |
9 | // settdialog = new SettingsDialog(this);
|
9 | // settdialog = new SettingsDialog(this);
|
10 | settdialog.show(); |
10 | settdialog.show(); |
11 | sql.setDatabaseName(tr("an_db")); |
11 | sql.setDatabaseName(tr("an_db")); |
12 | field = new TableField(tr("Ñîòðóäíèêè"), this); |
12 | field = new TableField(tr("Ñîòðóäíèêè"), this); |
13 | field->setNotNull(true); |
13 | field->setNotNull(true); |
14 | field->setDefaultValue(tr("ñîòðóäíèê")); |
14 | field->setDefaultValue(tr("ñîòðóäíèê")); |
15 | 15 | ||
16 | table = new SqlTable (tr("NewTable"), this); |
16 | table = new SqlTable (tr("NewTable"), this); |
17 | table->setName(tr("NewTable")); |
17 | table->setName(tr("NewTable")); |
18 | table->fields().at(0)->setNotNull(true); |
18 | table->fields().at(0)->setNotNull(true); |
19 | if (!(table->setPrimaryKey(tr("ID")))) { |
19 | if (!(table->setPrimaryKey(tr("ID")))) { |
20 | ui->label_3->setText(table->lastError()); |
20 | ui->label_3->setText(table->lastError()); |
21 | }
|
21 | }
|
22 | else ui->label_3->setText(table->primaryKey()); |
22 | else ui->label_3->setText(table->primaryKey()); |
23 | table->append(field); |
23 | table->append(field); |
24 | 24 | ||
25 | field = new TableField(tr("Êîìïüþòåðû"), this); |
25 | field = new TableField(tr("Êîìïüþòåðû"), this); |
26 | field->setNotNull(true); |
26 | field->setNotNull(true); |
27 | field->setDefaultValue(tr("êîìïüþòåð")); |
27 | field->setDefaultValue(tr("êîìïüþòåð")); |
28 | table->append(field); |
28 | table->append(field); |
29 | 29 | ||
30 | field = new TableField(tr("Ìîíèòîðû"), this); |
30 | field = new TableField(tr("Ìîíèòîðû"), this); |
31 | field->setNotNull(true); |
31 | field->setNotNull(true); |
32 | field->setDefaultValue(tr("ìîíèòîð")); |
32 | field->setDefaultValue(tr("ìîíèòîð")); |
33 | table->append(field); |
33 | table->append(field); |
34 | 34 | ||
35 | field = new TableField(tr("Êîëè÷åñòâî (øòóê)"), this); |
35 | field = new TableField(tr("Êîëè÷åñòâî (øòóê)"), this); |
36 | field->setNotNull(true); |
36 | field->setNotNull(true); |
37 | field->setType(tr("INTEGER")); |
37 | field->setType(tr("INTEGER")); |
38 | field->setDefaultValue(tr("1")); |
38 | field->setDefaultValue(tr("1")); |
39 | table->append(field); |
39 | table->append(field); |
40 | 40 | ||
41 | field = new TableField(tr("Äåíü ðîæäåíèÿ"), this); |
41 | field = new TableField(tr("Äåíü ðîæäåíèÿ"), this); |
42 | field->setNotNull(false); |
42 | field->setNotNull(false); |
43 | field->setType(tr("DATE")); |
43 | field->setType(tr("DATE")); |
44 | field->setDefaultValue(tr("NULL")); |
44 | field->setDefaultValue(tr("NULL")); |
45 | table->append(field); |
45 | table->append(field); |
46 | 46 | ||
47 | ui->label_2->setText(table->name()); |
47 | ui->label_2->setText(table->name()); |
48 | ui->label->setText(table->fields().at(0)->sqlString()); |
48 | ui->label->setText(table->fields().at(0)->sqlString()); |
49 | ui->label_4->setText(table->sqlString()); |
49 | ui->label_4->setText(table->sqlString()); |
50 | ////// ui->lineEdit->insert(table->sqlString());
|
50 | ////// ui->lineEdit->insert(table->sqlString());
|
51 | 51 | ||
52 | QTextDocument *document; |
52 | QTextDocument *document; |
53 | // = ui->textEdit->document();
|
53 | // = ui->textEdit->document();
|
54 | QTextCursor *cursor; |
54 | QTextCursor *cursor; |
55 | document = ui->textEdit->document(); |
55 | document = ui->textEdit->document(); |
56 | cursor = new QTextCursor(document); |
56 | cursor = new QTextCursor(document); |
57 | cursor->movePosition(QTextCursor::Start); |
57 | cursor->movePosition(QTextCursor::Start); |
58 | QTextCharFormat format(cursor->charFormat()); |
58 | QTextCharFormat format(cursor->charFormat()); |
59 | //format.setFontFamily("Courier");
|
59 | //format.setFontFamily("Courier");
|
60 | format.setFontFamily("Arial"); |
60 | format.setFontFamily("Arial"); |
61 | //format.setFontItalic(false);
|
61 | //format.setFontItalic(false);
|
62 | 62 | ||
63 | format.setFontWeight(QFont::Normal); |
63 | format.setFontWeight(QFont::Normal); |
64 | QTextCharFormat boldFormat = format; |
64 | QTextCharFormat boldFormat = format; |
65 | boldFormat.setFontWeight(QFont::Bold); |
65 | boldFormat.setFontWeight(QFont::Bold); |
66 | 66 | ||
67 | QTextCharFormat italicFormat = format; |
67 | QTextCharFormat italicFormat = format; |
68 | //format.setFontFamily("Courier");
|
68 | //format.setFontFamily("Courier");
|
69 | // format.setFontFamily("Arial");
|
69 | // format.setFontFamily("Arial");
|
70 | italicFormat.setFontItalic(true); |
70 | italicFormat.setFontItalic(true); |
71 | 71 | ||
72 | cursor->insertText(table->sqlString(), format); |
72 | cursor->insertText(table->sqlString(), format); |
73 | 73 | ||
74 | QString errorString;
|
74 | QString errorString;
|
75 | 75 | ||
76 | sql.setDatabaseName(tr("an_db")); |
76 | sql.setDatabaseName(tr("an_db")); |
77 | sql.setHostName(tr("localhost")); |
77 | sql.setHostName(tr("localhost")); |
78 | sql.setUserName(tr("an")); |
78 | sql.setUserName(tr("an")); |
79 | sql.setPassword(tr("393939")); |
79 | sql.setPassword(tr("393939")); |
80 | 80 | ||
81 | bool ok; |
81 | bool ok; |
82 | ok = sql.connect(&errorString); |
82 | ok = sql.connect(); |
83 | if (!ok) { |
83 | if (!ok) { |
84 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
84 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
85 | this, // Ðîäèòåëüñêèé âèäæåò. |
85 | this, // Ðîäèòåëüñêèé âèäæåò. |
86 | QObject::tr("Database Error"), // Çàãîëîâîê. |
86 | QObject::tr("Database Error"), // Çàãîëîâîê. |
87 | errorString); // Òåêñò ñîîáùåíèÿ. |
87 | sql.mysqlLastError); // Òåêñò ñîîáùåíèÿ. |
88 | 88 | ||
89 | }
|
89 | }
|
90 | else { |
90 | else { |
91 | 91 | ||
92 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
92 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
93 | this, // Ðîäèòåëüñêèé âèäæåò. |
93 | this, // Ðîäèòåëüñêèé âèäæåò. |
94 | QObject::tr("Database Connect"), // Çàãîëîâîê. |
94 | QObject::tr("Database Connect"), // Çàãîëîâîê. |
95 | QObject::tr("Ñîåäèíåíèå ñ áàçîé äàííûõ óñïåøíî óñòàíîâëåíî.")); // Òåêñò ñîîáùåíèÿ. |
95 | QObject::tr("Ñîåäèíåíèå ñ áàçîé äàííûõ óñïåøíî óñòàíîâëåíî.")); // Òåêñò ñîîáùåíèÿ. |
96 | 96 | ||
97 | 97 | ||
98 | 98 | ||
99 | 99 | ||
100 | 100 | ||
101 | }
|
101 | }
|
102 | 102 | ||
103 | 103 | ||
104 | ok = sql.createTable(table, &errorString); |
104 | ok = sql.createTable(table); |
105 | if (!ok) { |
105 | if (!ok) { |
106 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
106 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
107 | this, // Ðîäèòåëüñêèé âèäæåò. |
107 | this, // Ðîäèòåëüñêèé âèäæåò. |
108 | QObject::tr("Database Error"), // Çàãîëîâîê. |
108 | QObject::tr("Database Error"), // Çàãîëîâîê. |
109 | errorString); // Òåêñò ñîîáùåíèÿ. |
109 | sql.mysqlLastError); // Òåêñò ñîîáùåíèÿ. |
110 | 110 | ||
111 | }
|
111 | }
|
112 | else { |
112 | else { |
113 | 113 | ||
114 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
114 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
115 | this, // Ðîäèòåëüñêèé âèäæåò. |
115 | this, // Ðîäèòåëüñêèé âèäæåò. |
116 | QObject::tr("Database Connect"), // Çàãîëîâîê. |
116 | QObject::tr("Database Connect"), // Çàãîëîâîê. |
117 | QObject::tr("Òàáëèöà â áàçå äàííûõ óñïåøíî ñîçäàíà.")); // Òåêñò ñîîáùåíèÿ. |
117 | QObject::tr("Òàáëèöà â áàçå äàííûõ óñïåøíî ñîçäàíà.")); // Òåêñò ñîîáùåíèÿ. |
118 | 118 | ||
119 | 119 | ||
120 | 120 | ||
121 | 121 | ||
122 | 122 | ||
123 | }
|
123 | }
|
124 | 124 | ||
125 | }
|
125 | }
|
126 | 126 | ||
127 | ClassEditor::~ClassEditor() |
127 | ClassEditor::~ClassEditor() |
128 | {
|
128 | {
|
129 | delete ui; |
129 | delete ui; |
130 | // delete field;
|
130 | // delete field;
|
131 | // delete settdialog;
|
131 | // delete settdialog;
|
132 | }
|
132 | }
|
133 | 133 | ||
134 | void ClassEditor::changeEvent(QEvent *e) |
134 | void ClassEditor::changeEvent(QEvent *e) |
135 | {
|
135 | {
|
136 | QMainWindow::changeEvent(e); |
136 | QMainWindow::changeEvent(e); |
137 | switch (e->type()) { |
137 | switch (e->type()) { |
138 | case QEvent::LanguageChange: |
138 | case QEvent::LanguageChange: |
139 | ui->retranslateUi(this); |
139 | ui->retranslateUi(this); |
140 | break; |
140 | break; |
141 | default: |
141 | default: |
142 | break; |
142 | break; |
143 | }
|
143 | }
|
144 | }
|
144 | }
|
145 | 145 |