WebSVN - OpenInventory - Различия - Редакция 45 и 46


#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.lasError());         // Òåêñò ñîîáùåíèÿ.

                     }
else {

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





}


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

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





ok = sql.createDataBase();

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

                     }
else {

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


model = new QSqlTableModel(this);
model->setTable(tr("ListOfClasses"));
/////model->setEditStrategy(QSqlTableModel::OnManualSubmit);
model->setEditStrategy(QSqlTableModel::OnFieldChange);
model->setSort(0, Qt::AscendingOrder);
//       model->setFilter(tr("Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà = '7' and Èíâåíòàðíûé_íîìåð = 'i09090909'"));
model->select();
model->setHeaderData(1, Qt::Horizontal, tr("Èìÿ êëàññà"));
model->setHeaderData(2, Qt::Horizontal, tr("Ïñåâäîíèì êëàññà"));
ui->tableView->setModel(model);
ui->tableView->setAlternatingRowColors(true);
ui->tableView->resizeColumnsToContents();
ui->tableView->hideColumn(0);

int row = model->rowCount();
model->insertRows(row, 1);
model->setData(model->index(row, 0), row+1);
// model->setData(model->index(row, 1), tr("Âàñÿ Ïóïê  èí"));
// model->setData(model->index(row, 2) , tr("Ìóõîñðà  íñê, Çàæîïèíñêèå âûñåëêè ä 1"));

model->submitAll();
}











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;
    }
}
 

Редакция 45	Редакция 46
1	#include "classeditor.h"	1	#include "classeditor.h"
2	#include "ui_classeditor.h"	2	#include "ui_classeditor.h"
3		3
4		4
5	ClassEditor::ClassEditor(QWidget *parent) :	5	ClassEditor::ClassEditor(QWidget *parent) :
6	QMainWindow(parent),	6	QMainWindow(parent),
7	ui(new Ui::ClassEditor)	7	ui(new Ui::ClassEditor)
8	{	8	{
9	ui->setupUi(this);	9	ui->setupUi(this);
10	// settdialog = new SettingsDialog(this);	10	// settdialog = new SettingsDialog(this);
11	settdialog.show();	11	settdialog.show();
12	sql.setDatabaseName(tr("an_db"));	12	sql.setDatabaseName(tr("an_db"));
13	field = new TableField(tr("Ñîòðóäíèêè"), this);	13	field = new TableField(tr("Ñîòðóäíèêè"), this);
14	field->setNotNull(true);	14	field->setNotNull(true);
15	field->setDefaultValue(tr("ñîòðóäíèê"));	15	field->setDefaultValue(tr("ñîòðóäíèê"));
16		16
17	table = new SqlTable (tr("NewTable"), this);	17	table = new SqlTable (tr("NewTable"), this);
18	table->setName(tr("NewTable"));	18	table->setName(tr("NewTable"));
19	table->fields().at(0)->setNotNull(true);	19	table->fields().at(0)->setNotNull(true);
20	if (!(table->setPrimaryKey(tr("ID")))) {	20	if (!(table->setPrimaryKey(tr("ID")))) {
21	ui->label_3->setText(table->lastError());	21	ui->label_3->setText(table->lastError());
22	}	22	}
23	else ui->label_3->setText(table->primaryKey());	23	else ui->label_3->setText(table->primaryKey());
24	table->append(field);	24	table->append(field);
25		25
26	field = new TableField(tr("Êîìïüþòåðû"), this);	26	field = new TableField(tr("Êîìïüþòåðû"), this);
27	field->setNotNull(true);	27	field->setNotNull(true);
28	field->setDefaultValue(tr("êîìïüþòåð"));	28	field->setDefaultValue(tr("êîìïüþòåð"));
29	table->append(field);	29	table->append(field);
30		30
31	field = new TableField(tr("Ìîíèòîðû"), this);	31	field = new TableField(tr("Ìîíèòîðû"), this);
32	field->setNotNull(true);	32	field->setNotNull(true);
33	field->setDefaultValue(tr("ìîíèòîð"));	33	field->setDefaultValue(tr("ìîíèòîð"));
34	table->append(field);	34	table->append(field);
35		35
36	field = new TableField(tr("Êîëè÷åñòâî (øòóê)"), this);	36	field = new TableField(tr("Êîëè÷åñòâî (øòóê)"), this);
37	field->setNotNull(true);	37	field->setNotNull(true);
38	field->setType(tr("INTEGER"));	38	field->setType(tr("INTEGER"));
39	field->setDefaultValue(tr("1"));	39	field->setDefaultValue(tr("1"));
40	table->append(field);	40	table->append(field);
41		41
42	field = new TableField(tr("Äåíü ðîæäåíèÿ"), this);	42	field = new TableField(tr("Äåíü ðîæäåíèÿ"), this);
43	field->setNotNull(false);	43	field->setNotNull(false);
44	field->setType(tr("DATE"));	44	field->setType(tr("DATE"));
45	field->setDefaultValue(tr("NULL"));	45	field->setDefaultValue(tr("NULL"));
46	table->append(field);	46	table->append(field);
47		47
48	ui->label_2->setText(table->name());	48	ui->label_2->setText(table->name());
49	ui->label->setText(table->fields().at(0)->sqlString());	49	ui->label->setText(table->fields().at(0)->sqlString());
50	ui->label_4->setText(table->sqlString());	50	ui->label_4->setText(table->sqlString());
51	////// ui->lineEdit->insert(table->sqlString());	51	////// ui->lineEdit->insert(table->sqlString());
52		52
53		53
54	/**********************************************	54	/**********************************************
55		55
56	QTextDocument *document;	56	QTextDocument *document;
57	// = ui->textEdit->document();	57	// = ui->textEdit->document();
58	QTextCursor *cursor;	58	QTextCursor *cursor;
59		59
60	document = ui->textEdit->document();	60	document = ui->textEdit->document();
61	cursor = new QTextCursor(document);	61	cursor = new QTextCursor(document);
62	cursor->movePosition(QTextCursor::Start);	62	cursor->movePosition(QTextCursor::Start);
63	QTextCharFormat format(cursor->charFormat());	63	QTextCharFormat format(cursor->charFormat());
64	//format.setFontFamily("Courier");	64	//format.setFontFamily("Courier");
65	format.setFontFamily("Arial");	65	format.setFontFamily("Arial");
66	//format.setFontItalic(false);	66	//format.setFontItalic(false);
67		67
68	format.setFontWeight(QFont::Normal);	68	format.setFontWeight(QFont::Normal);
69	QTextCharFormat boldFormat = format;	69	QTextCharFormat boldFormat = format;
70	boldFormat.setFontWeight(QFont::Bold);	70	boldFormat.setFontWeight(QFont::Bold);
71		71
72	QTextCharFormat italicFormat = format;	72	QTextCharFormat italicFormat = format;
73	//format.setFontFamily("Courier");	73	//format.setFontFamily("Courier");
74	// format.setFontFamily("Arial");	74	// format.setFontFamily("Arial");
75	italicFormat.setFontItalic(true);	75	italicFormat.setFontItalic(true);
76		76
77	cursor->insertText(table->sqlString(), format);	77	cursor->insertText(table->sqlString(), format);
78		78
79	****************************************************/	79	****************************************************/
80		80
81	QString errorString;	81	QString errorString;
82		82
83	sql.setDatabaseName(tr("an_db"));	83	sql.setDatabaseName(tr("an_db"));
84	sql.setHostName(tr("localhost"));	84	sql.setHostName(tr("localhost"));
85	sql.setUserName(tr("an"));	85	sql.setUserName(tr("an"));
86	sql.setPassword(tr("393939"));	86	sql.setPassword(tr("393939"));
87		87
88	bool ok;	88	bool ok;
89	ok = sql.connect();	89	ok = sql.connect();
90	if (!ok) {	90	if (!ok) {
91	QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.	91	QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
92	this, // Ðîäèòåëüñêèé âèäæåò.	92	this, // Ðîäèòåëüñêèé âèäæåò.
93	QObject::tr("Database Error"), // Çàãîëîâîê.	93	QObject::tr("Database Error"), // Çàãîëîâîê.
94	sql.lasError()); // Òåêñò ñîîáùåíèÿ.	94	sql.lasError()); // Òåêñò ñîîáùåíèÿ.
95		95
96	}	96	}
97	else {	97	else {
98		98
99	QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.	99	QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
100	this, // Ðîäèòåëüñêèé âèäæåò.	100	this, // Ðîäèòåëüñêèé âèäæåò.
101	QObject::tr("Database Connect"), // Çàãîëîâîê.	101	QObject::tr("Database Connect"), // Çàãîëîâîê.
102	QObject::tr("Ñîåäèíåíèå ñ áàçîé äàííûõ óñïåøíî óñòàíîâëåíî.")); // Òåêñò ñîîáùåíèÿ.	102	QObject::tr("Ñîåäèíåíèå ñ áàçîé äàííûõ óñïåøíî óñòàíîâëåíî.")); // Òåêñò ñîîáùåíèÿ.
103		103
104		104
105		105
106		106
107		107
108	}	108	}
109		109
110		110
111	ok = sql.createTable(table);	111	ok = sql.createTable(table);
112	if (!ok) {	112	if (!ok) {
113	QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.	113	QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
114	this, // Ðîäèòåëüñêèé âèäæåò.	114	this, // Ðîäèòåëüñêèé âèäæåò.
115	QObject::tr("Database Error"), // Çàãîëîâîê.	115	QObject::tr("Database Error"), // Çàãîëîâîê.
116	sql.lasError()); // Òåêñò ñîîáùåíèÿ.	116	sql.lasError()); // Òåêñò ñîîáùåíèÿ.
117	}	117	}
118	else {	118	else {
119		119
120	QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.	120	QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
121	this, // Ðîäèòåëüñêèé âèäæåò.	121	this, // Ðîäèòåëüñêèé âèäæåò.
122	QObject::tr("Database Connect"), // Çàãîëîâîê.	122	QObject::tr("Database Connect"), // Çàãîëîâîê.
123	QObject::tr("Òàáëèöà â áàçå äàííûõ óñïåøíî ñîçäàíà.")); // Òåêñò ñîîáùåíèÿ.	123	QObject::tr("Òàáëèöà â áàçå äàííûõ óñïåøíî ñîçäàíà.")); // Òåêñò ñîîáùåíèÿ.
124	}	124	}
125		125
126		126
127		127
128		128
129		129
130	ok = sql.createDataBase();	130	ok = sql.createDataBase();
131		131
132	if (!ok) {	132	if (!ok) {
133	QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.	133	QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
134	this, // Ðîäèòåëüñêèé âèäæåò.	134	this, // Ðîäèòåëüñêèé âèäæåò.
135	QObject::tr("Database Error"), // Çàãîëîâîê.	135	QObject::tr("Database Error"), // Çàãîëîâîê.
136	sql.lasError()); // Òåêñò ñîîáùåíèÿ.	136	sql.lasError()); // Òåêñò ñîîáùåíèÿ.
137		137
138	}	138	}
139	else {	139	else {
140		140
141	QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.	141	QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
142	this, // Ðîäèòåëüñêèé âèäæåò.	142	this, // Ðîäèòåëüñêèé âèäæåò.
143	QObject::tr("Database Create"), // Çàãîëîâîê.	143	QObject::tr("Database Create"), // Çàãîëîâîê.
144	QObject::tr("Áàçà äàííûõ óñïåøíî ñîçäàíà.")); // Òåêñò ñîîáùåíèÿ.	144	QObject::tr("Áàçà äàííûõ óñïåøíî ñîçäàíà.")); // Òåêñò ñîîáùåíèÿ.
145	}	145	}
146		146
147		147
148	model = new QSqlTableModel(this);	148	model = new QSqlTableModel(this);
149	model->setTable(tr("ListOfClasses"));	149	model->setTable(tr("ListOfClasses"));
150	/////model->setEditStrategy(QSqlTableModel::OnManualSubmit);	150	/////model->setEditStrategy(QSqlTableModel::OnManualSubmit);
151	model->setEditStrategy(QSqlTableModel::OnFieldChange);	151	model->setEditStrategy(QSqlTableModel::OnFieldChange);
152	model->setSort(0, Qt::AscendingOrder);	152	model->setSort(0, Qt::AscendingOrder);
153	// model->setFilter(tr("Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà = '7' and Èíâåíòàðíûé_íîìåð = 'i09090909'"));	153	// model->setFilter(tr("Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà = '7' and Èíâåíòàðíûé_íîìåð = 'i09090909'"));
154	model->select();	154	model->select();
-		155	model->setHeaderData(1, Qt::Horizontal, tr("Èìÿ êëàññà"));
-		156	model->setHeaderData(2, Qt::Horizontal, tr("Ïñåâäîíèì êëàññà"));
155	ui->tableView->setModel(model);	157	ui->tableView->setModel(model);
156	ui->tableView->setAlternatingRowColors(true);	158	ui->tableView->setAlternatingRowColors(true);
157	ui->tableView->resizeColumnsToContents();	159	ui->tableView->resizeColumnsToContents();
158	ui->tableView->hideColumn(0);	160	ui->tableView->hideColumn(0);
159		161
160	int row = model->rowCount();	162	int row = model->rowCount();
161	model->insertRows(row, 1);	163	model->insertRows(row, 1);
162	model->setData(model->index(row, 0), row+1);	164	model->setData(model->index(row, 0), row+1);
163	// model->setData(model->index(row, 1), tr("Âàñÿ Ïóïê èí"));	165	// model->setData(model->index(row, 1), tr("Âàñÿ Ïóïê èí"));
164	// model->setData(model->index(row, 2) , tr("Ìóõîñðà íñê, Çàæîïèíñêèå âûñåëêè ä 1"));	166	// model->setData(model->index(row, 2) , tr("Ìóõîñðà íñê, Çàæîïèíñêèå âûñåëêè ä 1"));
165		167
166	model->submitAll();	168	model->submitAll();
167	}	169	}
168		170
169		171
170		172
171		173
172		174
173		175
174		176
175		177
176		178
177		179
178		180
179	ClassEditor::~ClassEditor()	181	ClassEditor::~ClassEditor()
180	{	182	{
181	delete ui;	183	delete ui;
182	// delete field;	184	// delete field;
183	// delete settdialog;	185	// delete settdialog;
184	}	186	}
185		187
186	void ClassEditor::changeEvent(QEvent *e)	188	void ClassEditor::changeEvent(QEvent *e)
187	{	189	{
188	QMainWindow::changeEvent(e);	190	QMainWindow::changeEvent(e);
189	switch (e->type()) {	191	switch (e->type()) {
190	case QEvent::LanguageChange:	192	case QEvent::LanguageChange:
191	ui->retranslateUi(this);	193	ui->retranslateUi(this);
192	break;	194	break;
193	default:	195	default:
194	break;	196	break;
195	}	197	}
196	}	198	}
197		199

Хранилища Subversion OpenInventory

(root)/trunk/ClassEditor/classeditor.cpp @ 50 - Редакция 45 → 46