WebSVN - OpenInventory - Различия - Редакция 55 и 56


#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.createListOfClassesTable();

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

                     }
else {

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


 
 


ok = sql.createDescriptionOfClassesTable();

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);
mymodel = new MyModel(this);
modelForDescription = new QSqlTableModel(this);

/////////////////model->setTable(tr("ListOfClasses"));
mymodel->setTable(tr("ListOfClasses"));
modelForDescription->setTable(tr("DescriptionOfClasses"));
modelForDescription->setEditStrategy(QSqlTableModel::OnFieldChange);

/////model->setEditStrategy(QSqlTableModel::OnManualSubmit);

/*
model->setEditStrategy(QSqlTableModel::OnFieldChange);
mymodel->setEditStrategy(QSqlTableModel::OnFieldChange);
*/


//////////////////model->setSort(0, Qt::AscendingOrder);
mymodel->setSort(0, Qt::AscendingOrder);
modelForDescription->setSort(0, Qt::AscendingOrder);


//       model->setFilter(tr("Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà = '7' and Èíâåíòàðíûé_íîìåð = 'i09090909'"));
////////////////////model->select();
mymodel->select();
modelForDescription->setFilter(tr("ClassIdentifer = 1"));
modelForDescription->select();


/////////////////////////model->setHeaderData(1, Qt::Horizontal, tr("Èìÿ êëàññà"));
mymodel->setHeaderData(1, Qt::Horizontal, tr("Èìÿ êëàññà"));



////////////////////////model->setHeaderData(2, Qt::Horizontal, tr("Ïñåâäîíèì êëàññà"));
mymodel->setHeaderData(2, Qt::Horizontal, tr("Ïñåâäîíèì êëàññà"));

//ui->tableView->setModel(model);
ui->tableView->setModel(mymodel);
 
 
//tableForDescription = new QTableView();
ui->tableView_2->setModel(modelForDescription);
ui->tableView_2->setAlternatingRowColors(true);
ui->tableView_2->resizeColumnsToContents();
//tableForDescription->show();


ui->tableView->setAlternatingRowColors(true);
ui->tableView->resizeColumnsToContents();
//ui->tableView->hideColumn(0);
ui->tableView->hideColumn(3);


//connect(ui->tableView, SIGNAL(clicked(const QModelIndex)), this, SLOT(on_tableView_clicked(const QModelIndex)));
}











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



void  ClassEditor::addNewClass(){

    int row = model->rowCount();

    model->insertRows(row, 1);
    model->setData(model->index(row, 1), tr("New class")); // ïðèñâàèâàåì íîâîå çíà÷åíèå ïîëþ "èìÿ êëàññà"


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


    model->submitAll();

    row = model->rowCount();
    QString tmp_str;
    int i_tmp;
    i_tmp = model->data(model->index(row-1, 0)).toInt();
    tmp_str = model->data(model->index(row-1, 0)).toString(); // ãåíåðèì èìÿ òàáëèöû-õðàíèëèùà îáúåêòîâ êëàññà

    tmp_str.append(tr("_Inctance"));
    model->setData(model->index(row-1, 3), tmp_str );  // è çàíîñèì çíà÷åíèå â òàáëèöó

    model->submitAll();
    mymodel->select();


}


void  ClassEditor::addNewClass_new(){

    int row = mymodel->rowCount();

    mymodel->insertRows(row, 1);
    mymodel->setData(mymodel->index(row, 1), QVariant(tr("New classs")), Qt::EditRole); // ïðèñâàèâàåì íîâîå çíà÷åíèå ïîëþ "èìÿ êëàññà"

    mymodel->submitAll();

    row = mymodel->rowCount();
    QString tmp_str1;
    int i_tmp1;
    i_tmp1 = mymodel->data(mymodel->index(row-1, 0)).toInt();
    tmp_str1 = mymodel->data(mymodel->index(row-1, 0)).toString(); // ãåíåðèì èìÿ òàáëèöû-õðàíèëèùà îáúåêòîâ êëàññà

    tmp_str1.append(tr("_Inctance"));
    mymodel->setData(mymodel->index(row-1, 3), QVariant(tmp_str1), Qt::EditRole);  // è çàíîñèì çíà÷åíèå â òàáëèöó

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


    //mymodel->submitAll();

    //row = mymodel->rowCount();


  //mymodel->select();


}


void ClassEditor::on_pushButton_clicked(){
//int i;
//i++;
/////ClassEditor::addNewClass();
ClassEditor::addNewClass_new();
 mymodel->select();
//ui->tableView->setModel(mymodel);

}

void ClassEditor::on_tableView_clicked(const QModelIndex & index ){
    int i, row, column;
    i++;
    row = index.row();
    column = index.column();
   QModelIndex index_tmp;
    QString tmp_str, filter_str;
   index_tmp = ui->tableView->model()->index(row, 0);
   tmp_str = ui->tableView->model()->data(index_tmp).toString();
   ui->label->setText(tmp_str);
   filter_str = tr("ClassIdentifer = ");
   filter_str.append(tmp_str);
   modelForDescription->setFilter(filter_str);
   i++;
}

 

Редакция 55	Редакция 56
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
13	field = new TableField(tr("Ñîòðóäíèêè"), this);	14	field = new TableField(tr("Ñîòðóäíèêè"), this);
14	field->setNotNull(true);	15	field->setNotNull(true);
15	field->setDefaultValue(tr("ñîòðóäíèê"));	16	field->setDefaultValue(tr("ñîòðóäíèê"));
16		17
17	table = new SqlTable (tr("NewTable"), this);	18	table = new SqlTable (tr("NewTable"), this);
18	table->setName(tr("NewTable"));	19	table->setName(tr("NewTable"));
19	table->fields().at(0)->setNotNull(true);	20	table->fields().at(0)->setNotNull(true);
20	if (!(table->setPrimaryKey(tr("ID")))) {	21	if (!(table->setPrimaryKey(tr("ID")))) {
21	ui->label_3->setText(table->lastError());	22	ui->label_3->setText(table->lastError());
22	}	23	}
23	else ui->label_3->setText(table->primaryKey());	24	else ui->label_3->setText(table->primaryKey());
24	table->append(field);	25	table->append(field);
25		26
26	field = new TableField(tr("Êîìïüþòåðû"), this);	27	field = new TableField(tr("Êîìïüþòåðû"), this);
27	field->setNotNull(true);	28	field->setNotNull(true);
28	field->setDefaultValue(tr("êîìïüþòåð"));	29	field->setDefaultValue(tr("êîìïüþòåð"));
29	table->append(field);	30	table->append(field);
30		31
31	field = new TableField(tr("Ìîíèòîðû"), this);	32	field = new TableField(tr("Ìîíèòîðû"), this);
32	field->setNotNull(true);	33	field->setNotNull(true);
33	field->setDefaultValue(tr("ìîíèòîð"));	34	field->setDefaultValue(tr("ìîíèòîð"));
34	table->append(field);	35	table->append(field);
35		36
36	field = new TableField(tr("Êîëè÷åñòâî (øòóê)"), this);	37	field = new TableField(tr("Êîëè÷åñòâî (øòóê)"), this);
37	field->setNotNull(true);	38	field->setNotNull(true);
38	field->setType(tr("INTEGER"));	39	field->setType(tr("INTEGER"));
39	field->setDefaultValue(tr("1"));	40	field->setDefaultValue(tr("1"));
40	table->append(field);	41	table->append(field);
41		42
42	field = new TableField(tr("Äåíü ðîæäåíèÿ"), this);	43	field = new TableField(tr("Äåíü ðîæäåíèÿ"), this);
43	field->setNotNull(false);	44	field->setNotNull(false);
44	field->setType(tr("DATE"));	45	field->setType(tr("DATE"));
45	field->setDefaultValue(tr("NULL"));	46	field->setDefaultValue(tr("NULL"));
46	table->append(field);	47	table->append(field);
47		48
48	ui->label_2->setText(table->name());	49	ui->label_2->setText(table->name());
49	ui->label->setText(table->fields().at(0)->sqlString());	50	ui->label->setText(table->fields().at(0)->sqlString());
50	ui->label_4->setText(table->sqlString());	51	ui->label_4->setText(table->sqlString());
51	////// ui->lineEdit->insert(table->sqlString());	52	////// ui->lineEdit->insert(table->sqlString());
52		53
53		54
54	/**********************************************	55	/**********************************************
55		56
56	QTextDocument *document;	57	QTextDocument *document;
57	// = ui->textEdit->document();	58	// = ui->textEdit->document();
58	QTextCursor *cursor;	59	QTextCursor *cursor;
59		60
60	document = ui->textEdit->document();	61	document = ui->textEdit->document();
61	cursor = new QTextCursor(document);	62	cursor = new QTextCursor(document);
62	cursor->movePosition(QTextCursor::Start);	63	cursor->movePosition(QTextCursor::Start);
63	QTextCharFormat format(cursor->charFormat());	64	QTextCharFormat format(cursor->charFormat());
64	//format.setFontFamily("Courier");	65	//format.setFontFamily("Courier");
65	format.setFontFamily("Arial");	66	format.setFontFamily("Arial");
66	//format.setFontItalic(false);	67	//format.setFontItalic(false);
67		68
68	format.setFontWeight(QFont::Normal);	69	format.setFontWeight(QFont::Normal);
69	QTextCharFormat boldFormat = format;	70	QTextCharFormat boldFormat = format;
70	boldFormat.setFontWeight(QFont::Bold);	71	boldFormat.setFontWeight(QFont::Bold);
71		72
72	QTextCharFormat italicFormat = format;	73	QTextCharFormat italicFormat = format;
73	//format.setFontFamily("Courier");	74	//format.setFontFamily("Courier");
74	// format.setFontFamily("Arial");	75	// format.setFontFamily("Arial");
75	italicFormat.setFontItalic(true);	76	italicFormat.setFontItalic(true);
76		77
77	cursor->insertText(table->sqlString(), format);	78	cursor->insertText(table->sqlString(), format);
78		79
79	****************************************************/	80	****************************************************/
80		81
81	QString errorString;	82	QString errorString;
82		83
83	sql.setDatabaseName(tr("an_db"));	84	sql.setDatabaseName(tr("an_db"));
84	sql.setHostName(tr("localhost"));	85	sql.setHostName(tr("localhost"));
85	sql.setUserName(tr("an"));	86	sql.setUserName(tr("an"));
86	sql.setPassword(tr("393939"));	87	sql.setPassword(tr("393939"));
87		88
88	bool ok;	89	bool ok;
89	ok = sql.connect();	90	ok = sql.connect();
90	if (!ok) {	91	if (!ok) {
91	QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.	92	QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
92	this, // Ðîäèòåëüñêèé âèäæåò.	93	this, // Ðîäèòåëüñêèé âèäæåò.
93	QObject::tr("Database Error"), // Çàãîëîâîê.	94	QObject::tr("Database Error"), // Çàãîëîâîê.
94	sql.lasError()); // Òåêñò ñîîáùåíèÿ.	95	sql.lasError()); // Òåêñò ñîîáùåíèÿ.
95		96
96	}	97	}
97	else {	98	else {
98		99
99	QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.	100	QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
100	this, // Ðîäèòåëüñêèé âèäæåò.	101	this, // Ðîäèòåëüñêèé âèäæåò.
101	QObject::tr("Database Connect"), // Çàãîëîâîê.	102	QObject::tr("Database Connect"), // Çàãîëîâîê.
102	QObject::tr("Ñîåäèíåíèå ñ áàçîé äàííûõ óñïåøíî óñòàíîâëåíî.")); // Òåêñò ñîîáùåíèÿ.	103	QObject::tr("Ñîåäèíåíèå ñ áàçîé äàííûõ óñïåøíî óñòàíîâëåíî.")); // Òåêñò ñîîáùåíèÿ.
103		104
104		105
105		106
106		107
107		108
108	}	109	}
109		110
110		111
111	ok = sql.createTable(table);	112	ok = sql.createTable(table);
112	if (!ok) {	113	if (!ok) {
113	QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.	114	QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
114	this, // Ðîäèòåëüñêèé âèäæåò.	115	this, // Ðîäèòåëüñêèé âèäæåò.
115	QObject::tr("Database Error"), // Çàãîëîâîê.	116	QObject::tr("Database Error"), // Çàãîëîâîê.
116	sql.lasError()); // Òåêñò ñîîáùåíèÿ.	117	sql.lasError()); // Òåêñò ñîîáùåíèÿ.
117	}	118	}
118	else {	119	else {
119		120
120	QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.	121	QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
121	this, // Ðîäèòåëüñêèé âèäæåò.	122	this, // Ðîäèòåëüñêèé âèäæåò.
122	QObject::tr("Database Connect"), // Çàãîëîâîê.	123	QObject::tr("Database Connect"), // Çàãîëîâîê.
123	QObject::tr("Òàáëèöà â áàçå äàííûõ óñïåøíî ñîçäàíà.")); // Òåêñò ñîîáùåíèÿ.	124	QObject::tr("Òàáëèöà â áàçå äàííûõ óñïåøíî ñîçäàíà.")); // Òåêñò ñîîáùåíèÿ.
124	}	125	}
125		126
126		127
127		128
128		129
129		130
130	ok = sql.createDataBase();	131	ok = sql.createListOfClassesTable();
131		132
132	if (!ok) {	133	if (!ok) {
133	QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.	134	QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
134	this, // Ðîäèòåëüñêèé âèäæåò.	135	this, // Ðîäèòåëüñêèé âèäæåò.
135	QObject::tr("Database Error"), // Çàãîëîâîê.	136	QObject::tr("Database Error"), // Çàãîëîâîê.
136	sql.lasError()); // Òåêñò ñîîáùåíèÿ.	137	sql.lasError()); // Òåêñò ñîîáùåíèÿ.
137		138
138	}	139	}
139	else {	140	else {
140		141
141	QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.	142	QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
142	this, // Ðîäèòåëüñêèé âèäæåò.	143	this, // Ðîäèòåëüñêèé âèäæåò.
143	QObject::tr("Database Create"), // Çàãîëîâîê.	144	QObject::tr("Database Create"), // Çàãîëîâîê.
144	QObject::tr("Áàçà äàííûõ óñïåøíî ñîçäàíà.")); // Òåêñò ñîîáùåíèÿ.	145	QObject::tr("Áàçà äàííûõ óñïåøíî ñîçäàíà.")); // Òåêñò ñîîáùåíèÿ.
145	}	146	}
146		147
147		148
148	model = new QSqlTableModel(this);	-
149	mymodel = new MyModel(this);	-
150		149
151		150
-		151	ok = sql.createDescriptionOfClassesTable();
-		152
-		153	if (!ok) {
-		154	QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
-		155	this, // Ðîäèòåëüñêèé âèäæåò.
-		156	QObject::tr("Database Error"), // Çàãîëîâîê.
-		157	sql.lasError()); // Òåêñò ñîîáùåíèÿ.
-		158
-		159	}
-		160	else {
-		161
-		162	QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
-		163	this, // Ðîäèòåëüñêèé âèäæåò.
-		164	QObject::tr("Database Create"), // Çàãîëîâîê.
-		165	QObject::tr("Áàçà äàííûõ óñïåøíî ñîçäàíà.")); // Òåêñò ñîîáùåíèÿ.
-		166	}
-		167
-		168
-		169
-		170
-		171
-		172
-		173
-		174	/////////////////model = new QSqlTableModel(this);
-		175	mymodel = new MyModel(this);
-		176	modelForDescription = new QSqlTableModel(this);
-		177
152	model->setTable(tr("ListOfClasses"));	178	/////////////////model->setTable(tr("ListOfClasses"));
153	mymodel->setTable(tr("ListOfClasses"));	179	mymodel->setTable(tr("ListOfClasses"));
-		180	modelForDescription->setTable(tr("DescriptionOfClasses"));
-		181	modelForDescription->setEditStrategy(QSqlTableModel::OnFieldChange);
154		182
155	/////model->setEditStrategy(QSqlTableModel::OnManualSubmit);	183	/////model->setEditStrategy(QSqlTableModel::OnManualSubmit);
156		184
157	/*	185	/*
158	model->setEditStrategy(QSqlTableModel::OnFieldChange);	186	model->setEditStrategy(QSqlTableModel::OnFieldChange);
159	mymodel->setEditStrategy(QSqlTableModel::OnFieldChange);	187	mymodel->setEditStrategy(QSqlTableModel::OnFieldChange);
160	*/	188	*/
161		189
162		190
163	model->setSort(0, Qt::AscendingOrder);	191	//////////////////model->setSort(0, Qt::AscendingOrder);
164	mymodel->setSort(0, Qt::AscendingOrder);	192	mymodel->setSort(0, Qt::AscendingOrder);
-		193	modelForDescription->setSort(0, Qt::AscendingOrder);
-		194
165		195
166	// model->setFilter(tr("Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà = '7' and Èíâåíòàðíûé_íîìåð = 'i09090909'"));	196	// model->setFilter(tr("Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà = '7' and Èíâåíòàðíûé_íîìåð = 'i09090909'"));
167	model->select();	197	////////////////////model->select();
168	mymodel->select();	198	mymodel->select();
-		199	modelForDescription->setFilter(tr("ClassIdentifer = 1"));
-		200	modelForDescription->select();
-		201
169		202
170	model->setHeaderData(1, Qt::Horizontal, tr("Èìÿ êëàññà"));	203	/////////////////////////model->setHeaderData(1, Qt::Horizontal, tr("Èìÿ êëàññà"));
171	mymodel->setHeaderData(1, Qt::Horizontal, tr("Èìÿ êëàññà"));	204	mymodel->setHeaderData(1, Qt::Horizontal, tr("Èìÿ êëàññà"));
172		205
173		206
174		207
175	model->setHeaderData(2, Qt::Horizontal, tr("Ïñåâäîíèì êëàññà"));	208	////////////////////////model->setHeaderData(2, Qt::Horizontal, tr("Ïñåâäîíèì êëàññà"));
176	mymodel->setHeaderData(2, Qt::Horizontal, tr("Ïñåâäîíèì êëàññà"));	209	mymodel->setHeaderData(2, Qt::Horizontal, tr("Ïñåâäîíèì êëàññà"));
177		210
178	//ui->tableView->setModel(model);	211	//ui->tableView->setModel(model);
179	ui->tableView->setModel(mymodel);	212	ui->tableView->setModel(mymodel);
180		-
181		-
-		213	//tableForDescription = new QTableView();
-		214	ui->tableView_2->setModel(modelForDescription);
-		215	ui->tableView_2->setAlternatingRowColors(true);
-		216	ui->tableView_2->resizeColumnsToContents();
-		217	//tableForDescription->show();
182		218
183		219
184	ui->tableView->setAlternatingRowColors(true);	220	ui->tableView->setAlternatingRowColors(true);
185	ui->tableView->resizeColumnsToContents();	221	ui->tableView->resizeColumnsToContents();
186	ui->tableView->hideColumn(0);	222	//ui->tableView->hideColumn(0);
187	ui->tableView->hideColumn(3);	223	ui->tableView->hideColumn(3);
188		224
189		225
190	//connect(ui->tableView, SIGNAL(clicked(const QModelIndex)), this, SLOT(on_tableView_clicked(const QModelIndex)));	226	//connect(ui->tableView, SIGNAL(clicked(const QModelIndex)), this, SLOT(on_tableView_clicked(const QModelIndex)));
191	}	227	}
192		228
193		229
194		230
195		231
196		232
197		233
198		234
199		235
200		236
201		237
202		238
203	ClassEditor::~ClassEditor()	239	ClassEditor::~ClassEditor()
204	{	240	{
205	delete ui;	241	delete ui;
206	// delete field;	242	// delete field;
207	// delete settdialog;	243	// delete settdialog;
208	}	244	}
209		245
210	void ClassEditor::changeEvent(QEvent *e)	246	void ClassEditor::changeEvent(QEvent *e)
211	{	247	{
212	QMainWindow::changeEvent(e);	248	QMainWindow::changeEvent(e);
213	switch (e->type()) {	249	switch (e->type()) {
214	case QEvent::LanguageChange:	250	case QEvent::LanguageChange:
215	ui->retranslateUi(this);	251	ui->retranslateUi(this);
216	break;	252	break;
217	default:	253	default:
218	break;	254	break;
219	}	255	}
220	}	256	}
221		257
222		258
223		259
224	void ClassEditor::addNewClass(){	260	void ClassEditor::addNewClass(){
225		261
226	int row = model->rowCount();	262	int row = model->rowCount();
227		263
228	model->insertRows(row, 1);	264	model->insertRows(row, 1);
229	model->setData(model->index(row, 1), tr("New class")); // ïðèñâàèâàåì íîâîå çíà÷åíèå ïîëþ "èìÿ êëàññà"	265	model->setData(model->index(row, 1), tr("New class")); // ïðèñâàèâàåì íîâîå çíà÷åíèå ïîëþ "èìÿ êëàññà"
230		266
231		267
232	// model->setData(model->index(row, 1), tr("Âàñÿ Ïóïê èí"));	268	// model->setData(model->index(row, 1), tr("Âàñÿ Ïóïê èí"));
233	// model->setData(model->index(row, 2) , tr("Ìóõîñðà íñê, Çàæîïèíñêèå âûñåëêè ä 1"));	269	// model->setData(model->index(row, 2) , tr("Ìóõîñðà íñê, Çàæîïèíñêèå âûñåëêè ä 1"));
234		270
235		271
236	model->submitAll();	272	model->submitAll();
237		273
238	row = model->rowCount();	274	row = model->rowCount();
239	QString tmp_str;	275	QString tmp_str;
240	int i_tmp;	276	int i_tmp;
241	i_tmp = model->data(model->index(row-1, 0)).toInt();	277	i_tmp = model->data(model->index(row-1, 0)).toInt();
242	tmp_str = model->data(model->index(row-1, 0)).toString(); // ãåíåðèì èìÿ òàáëèöû-õðàíèëèùà îáúåêòîâ êëàññà	278	tmp_str = model->data(model->index(row-1, 0)).toString(); // ãåíåðèì èìÿ òàáëèöû-õðàíèëèùà îáúåêòîâ êëàññà
243		279
244	tmp_str.append(tr("_Inctance"));	280	tmp_str.append(tr("_Inctance"));
245	model->setData(model->index(row-1, 3), tmp_str ); // è çàíîñèì çíà÷åíèå â òàáëèöó	281	model->setData(model->index(row-1, 3), tmp_str ); // è çàíîñèì çíà÷åíèå â òàáëèöó
246		282
247	model->submitAll();	283	model->submitAll();
248	mymodel->select();	284	mymodel->select();
249		285
250		286
251	}	287	}
252		288
253		289
254	void ClassEditor::addNewClass_new(){	290	void ClassEditor::addNewClass_new(){
255		291
256	int row = mymodel->rowCount();	292	int row = mymodel->rowCount();
257		293
258	mymodel->insertRows(row, 1);	294	mymodel->insertRows(row, 1);
259	mymodel->setData(mymodel->index(row, 1), QVariant(tr("New classs")), Qt::EditRole); // ïðèñâàèâàåì íîâîå çíà÷åíèå ïîëþ "èìÿ êëàññà"	295	mymodel->setData(mymodel->index(row, 1), QVariant(tr("New classs")), Qt::EditRole); // ïðèñâàèâàåì íîâîå çíà÷åíèå ïîëþ "èìÿ êëàññà"
260		296
261	mymodel->submitAll();	297	mymodel->submitAll();
262		298
263	row = mymodel->rowCount();	299	row = mymodel->rowCount();
264	QString tmp_str1;	300	QString tmp_str1;
265	int i_tmp1;	301	int i_tmp1;
266	i_tmp1 = mymodel->data(mymodel->index(row-1, 0)).toInt();	302	i_tmp1 = mymodel->data(mymodel->index(row-1, 0)).toInt();
267	tmp_str1 = mymodel->data(mymodel->index(row-1, 0)).toString(); // ãåíåðèì èìÿ òàáëèöû-õðàíèëèùà îáúåêòîâ êëàññà	303	tmp_str1 = mymodel->data(mymodel->index(row-1, 0)).toString(); // ãåíåðèì èìÿ òàáëèöû-õðàíèëèùà îáúåêòîâ êëàññà
268		304
269	tmp_str1.append(tr("_Inctance"));	305	tmp_str1.append(tr("_Inctance"));
270	mymodel->setData(mymodel->index(row-1, 3), QVariant(tmp_str1), Qt::EditRole); // è çàíîñèì çíà÷åíèå â òàáëèöó	306	mymodel->setData(mymodel->index(row-1, 3), QVariant(tmp_str1), Qt::EditRole); // è çàíîñèì çíà÷åíèå â òàáëèöó
271		307
272	// model->setData(model->index(row, 1), tr("Âàñÿ Ïóïê èí"));	308	// model->setData(model->index(row, 1), tr("Âàñÿ Ïóïê èí"));
273	// model->setData(model->index(row, 2) , tr("Ìóõîñðà íñê, Çàæîïèíñêèå âûñåëêè ä 1"));	309	// model->setData(model->index(row, 2) , tr("Ìóõîñðà íñê, Çàæîïèíñêèå âûñåëêè ä 1"));
274		310
275		311
276	mymodel->submitAll();	312	//mymodel->submitAll();
277		313
278	//row = mymodel->rowCount();	314	//row = mymodel->rowCount();
279		315
280		316
281	mymodel->select();	317	//mymodel->select();
282		318
283		319
284	}	320	}
285		321
286		322
287	void ClassEditor::on_pushButton_clicked(){	323	void ClassEditor::on_pushButton_clicked(){
288	//int i;	324	//int i;
289	//i++;	325	//i++;
290	/////ClassEditor::addNewClass();	326	/////ClassEditor::addNewClass();
291	ClassEditor::addNewClass_new();	327	ClassEditor::addNewClass_new();
292	mymodel->select();	328	mymodel->select();
293	//ui->tableView->setModel(mymodel);	329	//ui->tableView->setModel(mymodel);
294		330
295	}	331	}
296		332
297	void ClassEditor::on_tableView_clicked(const QModelIndex & index ){	333	void ClassEditor::on_tableView_clicked(const QModelIndex & index ){
298	int i, row, column;	334	int i, row, column;
299	i++;	335	i++;
300	row = index.row();	336	row = index.row();
301	column = index.column();	337	column = index.column();
-		338	QModelIndex index_tmp;
-		339	QString tmp_str, filter_str;
-		340	index_tmp = ui->tableView->model()->index(row, 0);
-		341	tmp_str = ui->tableView->model()->data(index_tmp).toString();
-		342	ui->label->setText(tmp_str);
-		343	filter_str = tr("ClassIdentifer = ");
-		344	filter_str.append(tmp_str);
-		345	modelForDescription->setFilter(filter_str);
-		346	i++;
302	}	347	}
303		348
304		349

Хранилища Subversion OpenInventory

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