WebSVN - OpenInventory - Различия - Редакция 43 и 44


#include "classeditor.h"
#include "ui_classeditor.h"

ClassEditor::ClassEditor(QWidget *parent) :
    QMainWindow(parent),
    ui(new Ui::ClassEditor)
{
    ui->setupUi(this);
//    settdialog = new SettingsDialog(this);
    settdialog.show();
    sql.setDatabaseName(tr("an_db"));
    field = new TableField(tr("Ñîòðóäíèêè"), this);
    field->setNotNull(true);
    field->setDefaultValue(tr("ñîòðóäíèê"));

    table = new SqlTable (tr("NewTable"), this);
    table->setName(tr("NewTable"));
    table->fields().at(0)->setNotNull(true);
    if (!(table->setPrimaryKey(tr("ID")))) {
         ui->label_3->setText(table->lastError());
    }
    else  ui->label_3->setText(table->primaryKey());
    table->append(field);

    field = new TableField(tr("Êîìïüþòåðû"), this);
    field->setNotNull(true);
    field->setDefaultValue(tr("êîìïüþòåð"));
    table->append(field);

    field = new TableField(tr("Ìîíèòîðû"), this);
    field->setNotNull(true);
    field->setDefaultValue(tr("ìîíèòîð"));
    table->append(field);

    field = new TableField(tr("Êîëè÷åñòâî (øòóê)"), this);
    field->setNotNull(true);
    field->setType(tr("INTEGER"));
    field->setDefaultValue(tr("1"));
    table->append(field);

    field = new TableField(tr("Äåíü ðîæäåíèÿ"), this);
    field->setNotNull(false);
    field->setType(tr("DATE"));
    field->setDefaultValue(tr("NULL"));
    table->append(field);

    ui->label_2->setText(table->name());
    ui->label->setText(table->fields().at(0)->sqlString());
    ui->label_4->setText(table->sqlString());
   ////// ui->lineEdit->insert(table->sqlString());

    QTextDocument *document;
    // = ui->textEdit->document();
    QTextCursor *cursor;
    document = ui->textEdit->document();
    cursor = new QTextCursor(document);
    cursor->movePosition(QTextCursor::Start);
QTextCharFormat format(cursor->charFormat());
//format.setFontFamily("Courier");
format.setFontFamily("Arial");
//format.setFontItalic(false);

format.setFontWeight(QFont::Normal);
QTextCharFormat boldFormat = format;
boldFormat.setFontWeight(QFont::Bold);

QTextCharFormat italicFormat = format;
//format.setFontFamily("Courier");
//     format.setFontFamily("Arial");
italicFormat.setFontItalic(true);

cursor->insertText(table->sqlString(), format);

QString errorString;

sql.setDatabaseName(tr("an_db"));
sql.setHostName(tr("localhost"));
sql.setUserName(tr("an"));
sql.setPassword(tr("393939"));

bool ok;
ok = sql.connect();
if (!ok) {
                            QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
                                                                            this,                      // Ðîäèòåëüñêèé âèäæåò.
                                                                            QObject::tr("Database Error"),   // Çàãîëîâîê.
                                                                            sql.mysqlLastError);         // Òåêñò ñîîáùåíèÿ.

                     }
else {

    QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
                                                    this,                      // Ðîäèòåëüñêèé âèäæåò.
                                                    QObject::tr("Database Connect"),   // Çàãîëîâîê.
                                                    QObject::tr("Ñîåäèíåíèå ñ áàçîé äàííûõ óñïåøíî óñòàíîâëåíî."));         // Òåêñò ñîîáùåíèÿ.





}


ok = sql.createTable(table);
if (!ok) {
                            QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
                                                                            this,                      // Ðîäèòåëüñêèé âèäæåò.
                                                                            QObject::tr("Database Error"),   // Çàãîëîâîê.
                                                                            sql.mysqlLastError);         // Òåêñò ñîîáùåíèÿ.

                     }
else {

    QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
                                                    this,                      // Ðîäèòåëüñêèé âèäæåò.
                                                    QObject::tr("Database Connect"),   // Çàãîëîâîê.
                                                    QObject::tr("Òàáëèöà â áàçå äàííûõ óñïåøíî ñîçäàíà."));         // Òåêñò ñîîáùåíèÿ.





}

}

ClassEditor::~ClassEditor()
{
    delete ui;
 //    delete field;
   // delete settdialog;
}

void ClassEditor::changeEvent(QEvent *e)
{
    QMainWindow::changeEvent(e);
    switch (e->type()) {
    case QEvent::LanguageChange:
        ui->retranslateUi(this);
        break;
    default:
        break;
    }
}
 

Редакция 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

Хранилища Subversion OpenInventory

(root)/trunk/ClassEditor/classeditor.cpp - Редакция 43 → 44