Хранилища Subversion OpenInventory

Редакция

Редакция 14 | К новейшей редакции | Содержимое файла | Последнее изменение | Открыть журнал | RSS

Редакция Автор № строки Строка
6 pingvin 1 
#include "mainwindowimpl.h"
2 
//
3 
MainWindowImpl::MainWindowImpl( QWidget * parent, Qt::WFlags f)
4 
	: QMainWindow(parent, f)
5 
{
6 
 
7 
 
8 
 
9 
	setupUi(this);
10 
	fEnable_component_add = false; //
11 
	fEnable_naznachit_otvetstv = false;
12 
	curr_task = no_task;
13 
	readSettings();
14 
	lineEdit->insert(baseName);
15 
	metaDataAction = new QAction(tr(""), treeWidget);
16 
	addMemoryAction = new QAction(tr("  "), treeWidget);
17 
	MB_na_skladAction = new QAction(tr("  "), treeWidget);
18 
	new_sotrydnikAction = new QAction(tr(" "), treeWidget);
19 
	novoe_oborydovanieAction = new QAction(tr(" "), treeWidget);
20 
	pereimenovat_otdelAction = new QAction(tr(" "), treeWidget);
21 
	perevesti_sotrydnika_v_drygo1_otdelAction = new QAction(tr("   "), treeWidget);
22 
	yvolit_sotrydnikaAction = new QAction(tr(" "), treeWidget);
23 
	SpliterAction = new QAction(tr(""), treeWidget);
24 
	naznachit_otvetstvennim_za_oborydovanieAction = new QAction(tr("   "), treeWidget);
25 
	ystanovit_novie_complektyushieAction = new QAction(tr("  "), treeWidget);
26 
	sozdat_otdelAction = new QAction(tr("  "), treeWidget);
27 
 
28 
	novaya_SYSTEM_BLOCK_na_skladAction = new QAction(tr("     "), treeWidget);
29 
	novaya_MB_na_skladAction = new QAction(tr("     "), treeWidget);
30 
	novaya_RAM_na_skladAction = new QAction(tr("     "),  treeWidget);
31 
	novaya_CPU_na_skladAction = new QAction(tr("    "),  treeWidget);
32 
	novaya_HDD_na_skladAction = new QAction(tr("    "),  treeWidget);
33 
	novaya_CD_DVD_na_skladAction = new QAction(tr("    "),  treeWidget);
34 
	novaya_VIDEO_na_skladAction = new QAction(tr("    "),  treeWidget);
35 
	novaya_SoundCard_na_skladAction = new QAction(tr("     "),  treeWidget);
36 
	novaya_LAN_na_skladAction = new QAction(tr("     "),  treeWidget);
37 
	peredat_sys_block_pod_otveystvennostAction = new QAction(tr("     "),  treeWidget);
38 
 
39 
 
40 
//	novaya_SoundCard_na_skladAction = new QAction(tr("     "),  treeWidget);
41 
//	novaya_LAN_na_skladAction = new QAction(tr("     "),  treeWidget);
42 
 
43 
	insert_MB_to_system_blockAction = new QAction(tr("   "), treeWidget);
44 
 
45 
	treeWidget->addAction(metaDataAction);
46 
	treeWidget->addAction(addMemoryAction);
47 
 
48 
 
49 
	connect(insert_MB_to_system_blockAction, SIGNAL(triggered()), SLOT(insert_MB_to_system_block()));
50 
	connect(novaya_MB_na_skladAction, SIGNAL(triggered()), SLOT(novaya_MB_na_sklad()));
51 
	connect(novaya_RAM_na_skladAction, SIGNAL(triggered()), SLOT(novaya_RAM_na_sklad()));
52 
	connect(novaya_CPU_na_skladAction, SIGNAL(triggered()), SLOT(novaya_CPU_na_sklad()));
53 
	connect(novaya_HDD_na_skladAction, SIGNAL(triggered()), SLOT(novaya_HDD_na_sklad()));
54 
	connect(novaya_CD_DVD_na_skladAction, SIGNAL(triggered()), SLOT(novaya_CD_DVD_na_sklad()));
55 
	connect(novaya_VIDEO_na_skladAction, SIGNAL(triggered()), SLOT(novaya_VIDEO_na_sklad()));
56 
	connect(novaya_SoundCard_na_skladAction, SIGNAL(triggered()), SLOT(novaya_SoundCard_na_sklad()));
57 
	connect(novaya_LAN_na_skladAction, SIGNAL(triggered()), SLOT(novaya_LAN_na_sklad()));
58 
	connect(novaya_SYSTEM_BLOCK_na_skladAction, SIGNAL(triggered()), SLOT(novaya_SYSTEM_BLOCK_na_sklad()));
59 
 
60 
	connect(peredat_sys_block_pod_otveystvennostAction, SIGNAL(triggered()), SLOT(peredat_sys_block_pod_otveystvennost()));
61 
 
62 
	connect(sozdat_otdelAction, SIGNAL(triggered()), SLOT(addNewOtdel()));
63 
 
64 
 
65 
	connect(metaDataAction, SIGNAL(triggered()), SLOT(editTreeWidget()));
66 
	connect(addMemoryAction, SIGNAL(triggered()), SLOT(addNewMemory()));
67 
	connect(MB_na_skladAction, SIGNAL(triggered()), SLOT(move_to_sklad()));
68 
	connect(new_sotrydnikAction, SIGNAL(triggered()), SLOT(new_sotrydnik()));
69 
	connect(novoe_oborydovanieAction, SIGNAL(triggered()), SLOT(novoe_oborydovanie()));
70 
	connect(pereimenovat_otdelAction, SIGNAL(triggered()), SLOT(pereimenovft_otdel()));
71 
	connect(yvolit_sotrydnikaAction, SIGNAL(triggered()), SLOT(yvolit_sotrydnika()));
72 
	connect(naznachit_otvetstvennim_za_oborydovanieAction, SIGNAL(triggered()), SLOT(naznachit_otvetstvennim_za_oborydovanie()));
73 
	connect(ystanovit_novie_complektyushieAction, SIGNAL(triggered()), SLOT(ystanovit_novie_complektyushie()));
74 
	treeWidget->setContextMenuPolicy(Qt::ActionsContextMenu);
75 
	connect(openBaseAct, SIGNAL(triggered()), this, SLOT(openBase()));
76 
	connect(openMemoryTableAct, SIGNAL(triggered()), this, SLOT(openMemoryTable()));
77 
	connect(getsettingAct, SIGNAL(triggered()), this, SLOT(getSetting()));
78 
	connect(addStringAct, SIGNAL(triggered()), this, SLOT(addString()));
79 
	connect(delStringAct, SIGNAL(triggered()), this, SLOT(delString()));
80 
	connect(FiltrButton, SIGNAL(clicked()), this, SLOT(filter()));
81 
	connect(hiddenButton, SIGNAL(clicked()), this, SLOT(hiddenRow()));
82 
	connect(showButton, SIGNAL(clicked()), this, SLOT(showRow()));
83 
	connect(appyButton, SIGNAL(clicked()), this, SLOT(dbUpdate()));
84 
	connect(treeWidget, SIGNAL(itemActivated(QTreeWidgetItem *item, int column)), this, SLOT(dblClick(QTreeWidgetItem *item, int column)));
85 
	connect(&addmemFrm, SIGNAL(componentAdd()), this, SLOT(refreshTree()));//   addmemFrm  treeWidget
86 
	connect(&addotdelFrm, SIGNAL(componentAdd()), this, SLOT(refreshTree()));//   addotdelFrm  treeWidget
87 
	connect(&addsotrydnikFrm, SIGNAL(componentAdd()), this, SLOT(refreshTree()));//   addsotFrm  treeWidget
88 
	connect(&addsysblockFrm, SIGNAL(componentAdd()), this, SLOT(refreshTree()));//   addsysblockFrm  treeWidget
89 
 
90 
	connect(&addmemFrm, SIGNAL(formClose()), this, SLOT(on_addmemoryForm_formClose()));
91 
	connect(&addotdelFrm, SIGNAL(formClose()), this, SLOT(on_addmemoryForm_formClose()));
92 
	connect(&addsotrydnikFrm, SIGNAL(formClose()), this, SLOT(on_addmemoryForm_formClose()));
93 
	connect(&addsysblockFrm, SIGNAL(formClose()), this, SLOT(on_addmemoryForm_formClose()));
94 
 
95 
	connect(&process, SIGNAL(readyReadStandardOutput()), this, SLOT(readStandartProcessOutput()));
96 
 
97 
	comp_icon.addFile("./pc.png");
98 
/////	hdd_icon.addFile("./gnome-dev-harddisk.png");
99 
	hdd_icon.addFile("./hdd5.png");
100 
	memory_icon.addFile("./memory1.png");
101 
	cd_dvd_icon.addFile("./cd_dvd3.png");
102 
//	memory_icon.addFile("./gnome-dev-memory.png");
103 
	matheboard_icon.addFile("./icon_motherboard.png");
104 
	cpu_icon.addFile("./cpu3.png");
105 
	vidio_card_icon.addFile("./vidiocard2.png");
106 
	sound_card_icon.addFile("./soundcard1.png");
107 
	lan_card_icon.addFile("./lan1.png");
108 
	appyButton->setIcon(comp_icon);
109 
/////	 for (int i = 0; i < 10; ++i)
110 
/////     items.append(new QTreeWidgetItem((QTreeWidget*)0, QStringList(QString("item: %1").arg(i))));
111 
/////	 treeWidget->insertTopLevelItems(0, items);
112 
//////items.append(new QTreeWidgetItem((QTreeWidget*)0, QStringList(QString(tr(": %1")).arg(0))));
113 
/////////items.append(new QTreeWidgetItem((QTreeWidget*)0, QStringList(QString(tr(":")))));
114 
/////////items.append(new QTreeWidgetItem((QTreeWidget*)0, QStringList(QString(tr(":")))));
115 
/////////treeWidget->insertTopLevelItems(0, items);
116 
 
117 
//->itm = new QTreeWidgetItem(treeWidget);
118 
//->itm->setText(0, tr(""));
119 
/////////itm->setText(1, "hello1");
120 
//->QTreeWidgetItem *itm1 = new QTreeWidgetItem(itm);
121 
//->itm1->setText(1, tr("M1"));
122 
//->QTreeWidgetItem *itm1_1 = new QTreeWidgetItem(itm1);
123 
//->itm1_1->setText(2, tr(""));
124 
//->QTreeWidgetItem *itm1_2 = new QTreeWidgetItem(itm1);
125 
//->itm1_2->setText(2, tr(""));
126 
 
127 
//->QTreeWidgetItem *itm2 = new QTreeWidgetItem(itm);
128 
//->itm2->setText(1, tr("M2"));
129 
//////treeWidget->insertTopLevelItem(new QTreeWidgetItem((QTreeWidget*)0, QStringList(QString(tr(":")))));
130 
}
131 
 
132 
MainWindowImpl::~MainWindowImpl()
133 
{
134 
	db.close();
135 
//	delete setFrm;
136 
}
137 
 
138 
 
139 
void MainWindowImpl::delString()
140 
{
141 
	QModelIndex index;
142 
	int column, row;
143 
	QSqlRecord record;
144 
	index=view.currentIndex();
145 
	column=view.currentIndex().column();
146 
	row=view.currentIndex().row();
147 
	record = model->record(row);
148 
	int UserNameIndex = record.indexOf(tr(""));
149 
	QString ls_UserName=record.value(UserNameIndex).toString();
150 
	model->removeRows(row, 1);
151 
}
152 
 
153 
//
154 
void MainWindowImpl::openBase()
155 
{
156 
	lineEdit->insert(tr("  "));
157 
//	db = new QSqlDatabase("QMYSQL");
158 
	db = QSqlDatabase::addDatabase("QMYSQL");
159 
	pdb = &db;
160 
	raportFrm.pdb = &db;
161 
//	db->addDatabase("QMYSQL");
162 
//db = QSqlDatabase::addDatabase("QSQLITE");
163 
	pdb->setHostName(hostName);
164 
	pdb->setDatabaseName(baseName);
165 
	pdb->setUserName(userName);
166 
	pdb->setPassword(password);
167 
	bool ok = pdb->open();
168 
	if (!ok) {
169 
				QMessageBox::critical( //     .
170 
										this,                      //  .
171 
										QObject::tr("Database Error"),   // .
172 
										pdb->lastError().text());          //  .
173 
			 }
174 
	if (ok)
175 
	{lineEdit-> insert(tr("  "));
176 
	}
177 
	else {lineEdit-> insert(tr(" .  : "));
178 
		  lineEdit-> insert(pdb->lastError().text());
179 
		 }
180 
//	QSqlQuery q;
181 
//	q.prepare(tr("set NAMES cp1251"));
182 
 
183 
//	ok = q.exec();
184 
	model = new QSqlTableModel();
185 
	model->setTable(tableName);
186 
 
187 
	model->setEditStrategy(QSqlTableModel::OnFieldChange);
188 
//	model->setEditStrategy(QSqlTableModel::OnManualSubmit);
189 
	model->setSort(0, Qt::AscendingOrder);
190 
	model->select();
191 
//	model->setHeaderData(0, Qt::Horizontal,
192 
//	                        QObject::tr("\n"));
193 
//	model->setHeaderData(1, Qt::Horizontal,
194 
//	                       QObject::tr(""));
195 
//	model->setHeaderData(2, Qt::Horizontal,
196 
//	                       QObject::tr("IP "));
197 
//	model->setHeaderData(3, Qt::Horizontal,
198 
//	                       QObject::tr("\n"));
199 
//	model->setHeaderData(4, Qt::Horizontal,
200 
//	                       QObject::tr("\n"));
201 
//	view = new QTableView();
202 
	view.setModel(model);
203 
	view.setAlternatingRowColors(true);
204 
//   	view->resizeRowsToContents();
205 
   	view.resizeColumnsToContents();
206 
	view.show();
207 
	initTreeWidget();
208 
}
209 
 
210 
void MainWindowImpl::openMemoryTable()
211 
{
212 
	memory_model = new QSqlTableModel();
213 
	memory_model->setTable(tr(""));
214 
//	memory_model->setTable(tableName);
215 
	memory_model->setEditStrategy(QSqlTableModel::OnFieldChange);
216 
//	model->setEditStrategy(QSqlTableModel::OnManualSubmit);
217 
	memory_model->setSort(0, Qt::AscendingOrder);
218 
	memory_model->select();
219 
	tableView->setModel(memory_model);
220 
	tableView->setAlternatingRowColors(true);
221 
	tableView->resizeColumnsToContents();
222 
	tableView->show();
223 
/////	memory_view.setModel(memory_model);
224 
/////	memory_view.setAlternatingRowColors(true);
225 
//   	view->resizeRowsToContents();
226 
/////   	memory_view.resizeColumnsToContents();
227 
/////	memory_view.show();
228 
}
229 
 
230 
 
231 
void MainWindowImpl::applySetting()
232 
{
233 
	int i;
234 
	i=5;
235 
	lineEdit->insert(tr(" !"));
236 
	baseName = setFrm->lineEdit->text();
237 
	userName = setFrm->lineEdit_2->text();
238 
	password = setFrm->lineEdit_3->text();
239 
	tableName = setFrm->lineEdit_4->text();
240 
	hostName = setFrm->lineEdit_5->text();
241 
	i+=1;
242 
	writeSettings();
243 
	setFrm->close();
244 
	delete setFrm;
245 
}
246 
 
247 
void MainWindowImpl::writeSettings()
248 
{
249 
	QSettings settings("Trolltech", "Application Example");
250 
	settings.setValue("baseName", baseName);
251 
	settings.setValue("userName", userName);
252 
	settings.setValue("password", password);
253 
	settings.setValue("tableName", tableName);
254 
	settings.setValue("hostName", hostName);
255 
}
256 
 
257 
 
258 
void MainWindowImpl::readSettings()
259 
{
260 
	QSettings settings("Trolltech", "Application Example");
261 
	baseName = settings.value("baseName", "an_db").toString();
262 
	userName = settings.value("userName", "an").toString();
263 
	password = settings.value("password", "393939").toString();
264 
	tableName = settings.value("tableName", "inventar").toString();
265 
	hostName = settings.value("hostName", "server").toString();
266 
//     resize(size);
267 
//     move(pos);tableName
268 
}
269 
 
270 
void MainWindowImpl::getSetting()
271 
{
272 
	setFrm = new settingForm;
273 
	connect(setFrm->pushButton, SIGNAL(clicked()), this, SLOT(applySetting()));
274 
	setFrm->lineEdit->setText(baseName);
275 
	setFrm->lineEdit_2->setText(userName);
276 
	setFrm->lineEdit_3->setText(password);
277 
	setFrm->lineEdit_4->setText(tableName);
278 
	setFrm->lineEdit_5->setText(hostName);
279 
	setFrm->show();
280 
 
281 
 
282 
 
283 
}
284 
 
285 
 
286 
void MainWindowImpl::addString()
287 
{
288 
	QString query_begin=(tr("INSERT INTO "));
289 
//	QString query_end=(tr(" VALUES(' ',' ',' ',' ',default)"));
290 
	QString query_end=(tr(" VALUES()"));
291 
	query_begin.append(tableName);
292 
	query_begin.append(query_end);
293 
	QSqlQuery query;
294 
	query.prepare(query_begin);
295 
//	query.prepare(tr("INSERT INTO inventar VALUES(' ',' ',' ',' ',default)"));
296 
//	query.bindValue(":tab", "inventar");
297 
//	 if (!query.execBatch())
298 
//		qDebug() << query.lastError();
299 
	query.exec();
300 
	model->select();
301 
// 	view->close();
302 
	view.setModel(model);
303 
	//view->show();
304 
	lineEdit->insert(tr(" !"));
305 
}
306 
 
307 
//
308 
void MainWindowImpl::filter()
309 
{
310 
//	int i;
311 
//	i++;
312 
	model->setFilter(tr("=''"));
313 
	model->select();
314 
// 	view->close();
315 
	view.setModel(model);
316 
}
317 
//TEST CVS gh
318 
void MainWindowImpl::hiddenRow()
319 
{
320 
	int n;
321 
	for(n=0;n<20;n++) view.setRowHidden(n,true);
322 
}
323 
 
324 
 
325 
void MainWindowImpl::showRow()
326 
{
327 
	int n;
328 
	for(n=0;n<20;n++) view.setRowHidden(n,false);
329 
}
330 
 
331 
void MainWindowImpl::dbUpdate()
332 
{
333 
	model->submitAll();
334 
	addString();
335 
}
336 
 
337 
 
338 
void  MainWindowImpl::novaya_MB_na_sklad(){
339 
	addmemFrm.tabWidget->setCurrentIndex(3);
340 
	addmemFrm.pushButton->setEnabled(true);
341 
	addmemFrm.show();
342 
	addmemFrm.label_7->setText(tr(" "));
343 
	addNewMemory(tr(" "));
344 
 
345 
 
346 
}
347 
 
348 
void  MainWindowImpl::novaya_HDD_na_sklad(){
349 
	addmemFrm.tabWidget->setCurrentIndex(1);
350 
	addmemFrm.pushButton->setEnabled(true);
351 
	addmemFrm.show();
352 
	addmemFrm.label_7->setText(tr(" "));
353 
	addNewMemory(tr(" "));
354 
 
355 
 
356 
}
357 
 
358 
 
359 
void  MainWindowImpl::novaya_CD_DVD_na_sklad(){
360 
	addmemFrm.tabWidget->setCurrentIndex(4);
361 
	addmemFrm.pushButton->setEnabled(true);
362 
	addmemFrm.show();
363 
	addmemFrm.label_7->setText(tr(" "));
364 
	addNewMemory(tr(" "));
365 
 
366 
 
367 
}
368 
 
369 
void  MainWindowImpl::novaya_VIDEO_na_sklad(){
370 
	addmemFrm.tabWidget->setCurrentIndex(5);
371 
	addmemFrm.pushButton->setEnabled(true);
372 
	addmemFrm.show();
373 
	addmemFrm.label_7->setText(tr(" "));
374 
	addNewMemory(tr(" "));
375 
 
376 
 
377 
}
378 
 
379 
 
380 
void  MainWindowImpl::novaya_RAM_na_sklad(){
381 
	addmemFrm.tabWidget->setCurrentIndex(0);
382 
	addmemFrm.pushButton->setEnabled(true);
383 
	addmemFrm.show();
384 
	addmemFrm.label_7->setText(tr(" "));
385 
	addNewMemory(tr(" "));
386 
 
387 
 
388 
}
389 
 
390 
 
391 
void  MainWindowImpl::novaya_SoundCard_na_sklad(){
392 
	addmemFrm.tabWidget->setCurrentIndex(6);
393 
	addmemFrm.pushButton->setEnabled(true);
394 
	addmemFrm.show();
395 
	addmemFrm.label_7->setText(tr(" "));
396 
	addNewMemory(tr(" "));
397 
 
398 
 
399 
}
400 
 
401 
void  MainWindowImpl::novaya_LAN_na_sklad(){
402 
	addmemFrm.tabWidget->setCurrentIndex(7);
403 
	addmemFrm.pushButton->setEnabled(true);
404 
	addmemFrm.show();
405 
	addmemFrm.label_7->setText(tr(" "));
406 
	addNewMemory(tr(" "));
407 
}
408 
 
409 
 
410 
 
411 
 
412 
void  MainWindowImpl::novaya_CPU_na_sklad(){
413 
	addmemFrm.tabWidget->setCurrentIndex(2);
414 
	addmemFrm.pushButton->setEnabled(true);
415 
	addmemFrm.show();
416 
	addmemFrm.label_7->setText(tr(" "));
417 
	addNewMemory(tr(" "));
418 
 
419 
 
420 
}
421 
 
422 
void  MainWindowImpl::peredat_sys_block_pod_otveystvennost(){
423 
 
424 
	QMessageBox::information( //     .
425 
										this,                      //  .
426 
										QObject::tr("  "),   // .
427 
//										db.lastError().text());          //  .
428 
										tr("   (  ),      ."));
429 
	fEnable_naznachit_otvetstv = true;
430 
	curr_sys_block_id = treeWidget-> currentItem ()->text(12);
431 
}
432 
 
433 
 
434 
 
435 
void MainWindowImpl::on_treeWidget_itemClicked(QTreeWidgetItem *item, int column)
436 
{
437 
	QString tmp;
438 
	tmp = item->text(3);
439 
	if (tmp !=""){
440 
		addmemFrm.pushButton->setEnabled(true);
441 
		}
442 
	else addmemFrm.pushButton->setEnabled(false);
443 
	addmemFrm.label_7->setText(tmp);
444 
}
445 
 
446 
 
447 
 
448 
void MainWindowImpl::editTreeWidget()
449 
{
450 
	QString inventar_num;
451 
	QTreeWidgetItem * currItem;
452 
	int currColomn;
453 
	int top_item_index;
454 
	lineEdit->insert(tr(""));
455 
	currItem = treeWidget->currentItem ();
456 
	top_item_index = treeWidget->indexOfTopLevelItem(currItem);
457 
	currColomn = treeWidget->currentColumn();
458 
	MainWindowImpl::on_treeWidget_itemClicked(currItem, 3); //
459 
//	inventar_num = tr(".: ");
460 
	inventar_num.append(currItem ->text(3));
461 
	if (currColomn == 1){
462 
		addmemFrm.tabWidget->setCurrentIndex(4);
463 
		addmemFrm.show();
464 
	};
465 
	if (inventar_num == "") return;
466 
	lineEdit->insert(currItem ->text(currColomn));
467 
	switch(currColomn)
468 
	{
469 
		case 1://
470 
		{
471 
		addmemFrm.tabWidget->setCurrentIndex(4);
472 
		addmemFrm.show();
473 
 
474 
		}
475 
		break;
476 
 
477 
 
478 
		case 4: //
479 
		{
480 
		addmemFrm.tabWidget->setCurrentIndex(2);
481 
		addmemFrm.show();
482 
		}
483 
		break;
484 
 
485 
		case 5: //
486 
		{
487 
		addmemFrm.tabWidget->setCurrentIndex(3);
488 
		addmemFrm.show();
489 
		}
490 
		break;
491 
 
492 
		case 6: //
493 
		{
494 
		addmemFrm.tabWidget->setCurrentIndex(0);
495 
		addNewMemory(inventar_num);
496 
//		addmemFrm.show();
497 
		}
498 
		break;
499 
 
500 
		case 7: //
501 
		{
502 
		addmemFrm.tabWidget->setCurrentIndex(1);
503 
		addmemFrm.show();
504 
		}
505 
		break;
506 
 
507 
 
508 
		case 2: break;
509 
		defaul: break;
510 
	}
511 
	addmemFrm.treeWidget->clear();
512 
//	addmemFrm.initTreeWidgrt();
513 
}
514 
 
515 
void MainWindowImpl::initTreeWidget()//
516 
{
517 
	QStringList treeHeaders;//  treeWidget
518 
	treeWidget->setColumnCount(15);
519 
	treeHeaders << tr("") 					//0
520 
				<< tr("") 				//1
521 
				<< tr("") 			//2
522 
				<< tr("")			//3
523 
				<< tr("") 					//4
524 
				<< tr("")					//5
525 
				<< tr("")						//6
526 
				<< tr("")					//7
527 
				<< tr("")						//8
528 
				<< tr("")					//9
529 
				<< tr(" ")				//10
530 
				<< tr(" ")				//11
531 
				<< tr("")				//12
532 
				<< tr("  ")	//13
533 
				<< tr("ID  "); //14
534 
	treeWidget->setHeaderLabels(QStringList (treeHeaders));
535 
//	treeWidget->setColumnHidden(2, true);
536 
//	treeWidget->setColumnHidden(12, true);
537 
//	treeWidget->setColumnHidden(13, true);
538 
	treeWidget->clear();
539 
	addOtdels();
540 
	treeWidget->sortItems(0, Qt::AscendingOrder);
541 
}
542 
 
543 
void MainWindowImpl::addOtdels()
544 
{
545 
	int fieldName, fieldID;
546 
	QTreeWidgetItem *otdelItem;
547 
	QSqlQuery q(tr("select * from otdeli"));//
548 
	QString otdel, otdel_id;
549 
	fieldName = q.record().indexOf(tr(""));
550 
	fieldID = q.record().indexOf(tr(""));
551 
	while (q.next()){
552 
		otdel = q.value(fieldName).toString();
553 
		otdel_id = q.value(fieldID).toString();
554 
		otdelItem = new QTreeWidgetItem(treeWidget);
555 
		if (otdel == tr("")) { otdelItem->setText(0, otdel);
556 
			otdelItem->setText(2, tr(""));
557 
			otdelItem->setText(12, otdel_id);
558 
			SotrydnikiOtdela(otdel_id, otdelItem);
559 
			continue;
560 
			 }
561 
		otdelItem->setText(0, otdel);
562 
		otdelItem->setText(2, tr(""));
563 
		otdelItem->setText(12, otdel_id);
564 
		SotrydnikiOtdela(otdel_id, otdelItem);
565 
	}
566 
}
567 
 
568 
 
569 
void MainWindowImpl::SotrydnikiOtdela(QString id_otdela, QTreeWidgetItem * itemOtdela) //
570 
{
571 
	int field_fio_sotrydnika, field_id_sotrydnika;
572 
	int kolichestvo_sotrudnikov=0;
573 
	QString fio_sotrydnika_otdela, id_sotrydnika_otdela, oboryd;
574 
	QSqlQuery qsotrydnikiOtdela;
575 
	QString sqlQueryString;
576 
	QTreeWidgetItem *treeItem_sotrydnika;
577 
	sqlQueryString = tr("select ,  from sotrydniki where _=");
578 
	sqlQueryString.append(id_otdela);
579 
	qsotrydnikiOtdela.prepare(sqlQueryString);
580 
	qsotrydnikiOtdela.exec();
581 
	field_fio_sotrydnika = qsotrydnikiOtdela.record().indexOf(tr(""));
582 
	field_id_sotrydnika = qsotrydnikiOtdela.record().indexOf(tr(""));
583 
	while (qsotrydnikiOtdela.next())
584 
	{
585 
		fio_sotrydnika_otdela = qsotrydnikiOtdela.value(field_fio_sotrydnika).toString();
586 
		id_sotrydnika_otdela = qsotrydnikiOtdela.value(field_id_sotrydnika).toString();
587 
 
588 
 
589 
		treeItem_sotrydnika = new QTreeWidgetItem(itemOtdela);
590 
		treeItem_sotrydnika->setText(1, fio_sotrydnika_otdela );
591 
		treeItem_sotrydnika->setText(2, tr(""));
592 
		treeItem_sotrydnika->setText(14, id_sotrydnika_otdela );
593 
		if (id_sotrydnika_otdela == "1"){
594 
			itm_sklad_system_blocks = new QTreeWidgetItem(treeItem_sotrydnika);
595 
			itm_sklad_system_blocks->setText(2, tr(" "));
596 
			itm_sklad_orgtehnika = new QTreeWidgetItem(treeItem_sotrydnika);
597 
			itm_sklad_orgtehnika->setText(2, tr(""));
598 
			itm_sklad_orgtehnika_printers =  new QTreeWidgetItem(itm_sklad_orgtehnika);
599 
			itm_sklad_orgtehnika_printers->setText(2, tr(""));
600 
			itm_sklad_orgtehnika_mfy =   new QTreeWidgetItem(itm_sklad_orgtehnika);
601 
			itm_sklad_orgtehnika_mfy->setText(2, tr(""));
602 
			itm_sklad_komplectyushie = new QTreeWidgetItem(treeItem_sotrydnika);
603 
			itm_sklad_komplectyushie->setText(2, tr(""));
604 
			itm_sklad_orgtehnika_scaners = new QTreeWidgetItem(itm_sklad_orgtehnika);
605 
			itm_sklad_orgtehnika_scaners->setText(2, tr(""));
606 
			itm_sklad_rashodniki = new QTreeWidgetItem(treeItem_sotrydnika);
607 
			itm_sklad_rashodniki->setText(2, tr(" "));
608 
		}
609 
		oboryd = oborydovanie(id_sotrydnika_otdela, treeItem_sotrydnika);
610 
//		treeItem_sotrydnika->setText(3, oboryd );
611 
		++kolichestvo_sotrudnikov;
612 
	}
613 
	itemOtdela->setText(13, QVariant(kolichestvo_sotrudnikov).toString());
614 
}
615 
 
616 
QString MainWindowImpl::oborydovanie(QString id_sotrydnika, QTreeWidgetItem * itemSotrydnika){
617 
	QString result, prResult;
618 
	QString sqlQueryText;
619 
	QString serial_num, inventar_num, proizvoditel, model, system_block_id;
620 
	QSqlQuery quer;
621 
	QString MB_information, Memory_information, CPU_information, HDD_information, CD_DVD_information, Vidio_information;
622 
	QString Sound_card_information, Lan_card_information;
623 
	int field_serialNum, field_inventarNum, field_proizvoditel, field_model, field_system_block_id;
624 
//	QSqlQuery qns(tr("SET NAMES utf8"));//
625 
	QTreeWidgetItem *itemSysBlock;
626 
//	sqlQueryText.reserve(300);
627 
	sqlQueryText = tr("select system_blocks._, system_blocks._, system_blocks."
628 
	" from system_blocks"
629 
	" where system_blocks.__ =");
630 
	sqlQueryText.append(id_sotrydnika);
631 
//	sqlQueryText.append(tr(" AND _.__ = _."));
632 
	quer.prepare(sqlQueryText);
633 
//	quer.prepare(tr("select _._, _._,_., _. from _,_ where _.__ = 4 AND _.__ = _.;"));
634 
	quer.exec();
635 
	field_serialNum = quer.record().indexOf(tr("_"));
636 
	field_inventarNum = quer.record().indexOf(tr("_"));
637 
	field_system_block_id = quer.record().indexOf(tr(""));
638 
//	field_proizvoditel = quer.record().indexOf(tr(""));
639 
//	field_model = quer.record().indexOf(tr(""));
640 
	while(quer.next()){
641 
	system_block_id = quer.value(field_system_block_id).toString();					//
642 
	prResult = "";
643 
	serial_num = quer.value(field_serialNum).toString();
644 
	inventar_num = quer.value(field_inventarNum).toString();
645 
////	if (serial_num != "") {prResult.append(tr("s/n: "));
646 
////		prResult.append(serial_num);}
647 
	if (inventar_num != "") {
648 
////	prResult.append(tr(" .: "));
649 
	prResult.append(inventar_num);
650 
////	prResult.append(tr(" "));
651 
}
652 
 
653 
//	result.append(q.value(field_proizvoditel).toString());
654 
//	result.append(tr(" "));
655 
//	result.append(q.value(field_model).toString());
656 
 
657 
 
658 
 
659 
 
660 
 
661 
//	if (id_sotrydnika == "1" & system_block_id == "1") itemSysBlock->setText(2, tr(""));//
662 
	if (id_sotrydnika == "1" && system_block_id == "1") itemSysBlock = itm_sklad_komplectyushie;//
663 
	else if (id_sotrydnika == "1" ){
664 
		itemSysBlock = new QTreeWidgetItem(itm_sklad_system_blocks); //
665 
		itemSysBlock->setText(2, tr(" "));
666 
		itemSysBlock->setIcon(3, comp_icon);
667 
		if (system_block_id !="") itemSysBlock->setText(12, system_block_id);
668 
		if (id_sotrydnika !="") itemSysBlock->setText(14, id_sotrydnika);
669 
	}
670 
 
671 
	else {
672 
		itemSysBlock = new QTreeWidgetItem(itemSotrydnika);
673 
		itemSysBlock->setText(2, tr(" "));
674 
		itemSysBlock->setIcon(3, comp_icon);
675 
		if (system_block_id !="") itemSysBlock->setText(12, system_block_id);
676 
		if (id_sotrydnika !="") itemSysBlock->setText(14, id_sotrydnika);
677 
 
678 
		}
679 
 
680 
	MB_information = addMatheBoardInformation (id_sotrydnika, system_block_id, itemSysBlock);		//
681 
////	prResult.append(MB_information);
682 
	Memory_information = addMemoryInformation(id_sotrydnika, system_block_id, itemSysBlock);		//
683 
////	prResult.append(Memory_information);
684 
	CPU_information = addCpuInformation(id_sotrydnika, system_block_id, itemSysBlock);
685 
////	prResult.append(CPU_information);
686 
	HDD_information = addHDDInformation(id_sotrydnika, system_block_id, itemSysBlock);
687 
////	prResult.append(HDD_information);
688 
	CD_DVD_information = add_CD_DVD_Information(id_sotrydnika, system_block_id, itemSysBlock);
689 
////	prResult.append(CD_DVD_information);
690 
	Vidio_information = add_Vidio_Information(id_sotrydnika, system_block_id, itemSysBlock);
691 
	Sound_card_information = add_Sound_Card_Information(id_sotrydnika, system_block_id, itemSysBlock);
692 
	Lan_card_information = add_Lan_Card_Information(id_sotrydnika, system_block_id, itemSysBlock);
693 
	if (system_block_id != "1"){
694 
 
695 
		itemSysBlock->setText(3, prResult);
696 
		result.append(prResult);
697 
}
698 
 
699 
 
700 
	}
701 
	return result;
702 
}
703 
 
704 
QString MainWindowImpl::addMatheBoardInformation(QString id_otvetstvennogo_lica, QString id_systemBlock, QTreeWidgetItem * itemSysBlock)
705 
{
706 
	QString result, tmp;
707 
	QString MB_proizvoditel, MB_model, MB_identifikator, MB_serial_num, MB_inventar_num;
708 
	QString MatheBoardSqlQueryText;
709 
	QSqlQuery MatheBoardQuery;
710 
	int field_proizvoditel, field_model, field_identifikator, field_serial_num, field_inventar_num;
711 
	QTreeWidgetItem *itemMB, *itmMB_block;
712 
	MatheBoardSqlQueryText = tr("select * "
713 
	" from matheboards where matheboards.__ = "
714 
	);
715 
	MatheBoardSqlQueryText.append(id_systemBlock);
716 
	MatheBoardQuery.prepare(MatheBoardSqlQueryText);
717 
	MatheBoardQuery.exec();
718 
	field_identifikator = MatheBoardQuery.record().indexOf(tr(""));
719 
	field_proizvoditel = MatheBoardQuery.record().indexOf(tr(""));
720 
	field_model = MatheBoardQuery.record().indexOf(tr(""));
721 
	field_serial_num = MatheBoardQuery.record().indexOf(tr("_"));
722 
	field_inventar_num = MatheBoardQuery.record().indexOf(tr("_"));
723 
 
724 
	if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){
725 
		itmMB_block = new QTreeWidgetItem(itm_sklad_komplectyushie);
726 
		itmMB_block->setText(2, tr(" "));
727 
//		itmMB_block->setIcon(3, matheboard_icon);
728 
		}
729 
 
730 
	while(MatheBoardQuery.next()){
731 
		tmp = "";
732 
		MB_identifikator = MatheBoardQuery.value(field_identifikator).toString();
733 
		MB_proizvoditel = MatheBoardQuery.value(field_proizvoditel).toString();
734 
		MB_model = MatheBoardQuery.value(field_model).toString();
735 
		MB_serial_num = MatheBoardQuery.value(field_serial_num).toString();
736 
		MB_inventar_num = MatheBoardQuery.value(field_inventar_num).toString();
737 
 
738 
	if (MB_proizvoditel != "") {
739 
//		tmp.append(tr("MB: "));
740 
		tmp.append(MB_proizvoditel);
741 
		}
742 
	if (MB_model != "") {tmp.append(tr(" "));
743 
	tmp.append(MB_model);
744 
	tmp.append(tr(" "));}
745 
	result.append(tmp);
746 
	if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1") {itemMB = new QTreeWidgetItem(itmMB_block);
747 
	}
748 
	else itemMB = new QTreeWidgetItem(itemSysBlock);
749 
	itemMB->setIcon(4, matheboard_icon);
750 
	itemMB->setText(4, tmp);
751 
	itemMB->setText(12, MB_identifikator);
752 
	itemMB->setText(13, id_systemBlock);
753 
	itemMB->setText(14, id_otvetstvennogo_lica);
754 
	itemMB->setText(2, tr(" "));
755 
	itemMB->setText(3, MB_inventar_num);
756 
	if (id_systemBlock !="1") itemSysBlock->setText(5, tmp);
757 
 
758 
		}
759 
	return result;
760 
}
761 
 
762 
 
763 
QString MainWindowImpl::addMemoryInformation(QString id_otvetstvennogo_lica, QString id_systemBlock, QTreeWidgetItem * itemSysBlock)
764 
{
765 
	QString result, tmp;
766 
	QString Memiry_id, Memory_proizvoditel, Memory_type, Memory_obem, Memory_inventar_num, Memory_serial_num;
767 
	QString MemorySqlQueryText;
768 
	QSqlQuery MemoryQuery;
769 
	int field_proizvoditel, field_type, field_obem, field_id, field_inventar_num, field_sereal_num;
770 
	QTreeWidgetItem *itemMemory, *itemMemory_block;
771 
	MemorySqlQueryText = tr("select memory.* "
772 
	" from memory where memory.__ = "
773 
	);
774 
	MemorySqlQueryText.append(id_systemBlock);
775 
	MemoryQuery.prepare(MemorySqlQueryText);
776 
	MemoryQuery.exec();
777 
	field_id = MemoryQuery.record().indexOf(tr(""));
778 
	field_proizvoditel = MemoryQuery.record().indexOf(tr(""));
779 
	field_type = MemoryQuery.record().indexOf(tr(""));
780 
	field_obem = MemoryQuery.record().indexOf(tr(""));
781 
	field_inventar_num = MemoryQuery.record().indexOf(tr("_"));
782 
	field_sereal_num = MemoryQuery.record().indexOf(tr("_"));
783 
		if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){
784 
		itemMemory_block = new QTreeWidgetItem(itm_sklad_komplectyushie);
785 
		itemMemory_block->setText(2, tr(" "));
786 
	}
787 
	while(MemoryQuery.next()){
788 
//		tmp = tr("RAM: ");
789 
		tmp = tr("");
790 
		Memiry_id = MemoryQuery.value(field_id).toString();
791 
		Memory_proizvoditel = MemoryQuery.value(field_proizvoditel).toString();
792 
		Memory_type = MemoryQuery.value(field_type).toString();
793 
		Memory_obem = MemoryQuery.value(field_obem).toString();
794 
		Memory_inventar_num = MemoryQuery.value(field_inventar_num).toString();
795 
		Memory_serial_num = MemoryQuery.value(field_sereal_num).toString();
796 
////	if (Memory_proizvoditel != "") {
797 
////		tmp.append(Memory_proizvoditel);}
798 
	if (Memory_type != "") {tmp.append(tr(" "));
799 
	tmp.append(Memory_type);
800 
	tmp.append(tr(" "));}
801 
	if (Memory_obem != "") {tmp.append(tr(" "));
802 
	tmp.append(Memory_obem);
803 
	tmp.append(tr("MB; "));}
804 
	result.append(tmp);
805 
	if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){
806 
		itemMemory = new QTreeWidgetItem(itemMemory_block);
807 
	}
808 
	else itemMemory = new QTreeWidgetItem(itemSysBlock);
809 
	itemMemory->setIcon(4, memory_icon);
810 
	itemMemory->setText(4, tmp);
811 
 
812 
	itemMemory->setText(2, tr(" "));
813 
	itemMemory->setText(12, Memiry_id);
814 
	itemMemory->setText(13, id_systemBlock);
815 
	itemMemory->setText(14, id_otvetstvennogo_lica);
816 
	itemMemory->setText(3, Memory_inventar_num);
817 
 
818 
		}
819 
	if (id_systemBlock !="1") itemSysBlock->setText(6, result);
820 
	return result;
821 
}
822 
 
823 
 
824 
QString MainWindowImpl::addCpuInformation(QString id_otvetstvennogo_lica, QString id_systemBlock, QTreeWidgetItem * itemSysBlock)
825 
{
826 
	QString result, tmp;
827 
	QString CPU_id, CPU_proizvoditel, CPU_slot, CPU_fqr, CPU_inventar_num, CPU_serial_num;
828 
	QString CpuSqlQueryText;
829 
	QSqlQuery CpuQuery;
830 
	int field_id, field_proizvoditel, field_slot, field_fqr, field_inventar_num, field_serial_num;
831 
	QTreeWidgetItem *itemCpu, *itemCpu_block;
832 
	CpuSqlQueryText = tr("select processors.* "
833 
	" from processors where processors.__ = "
834 
	);
835 
	CpuSqlQueryText.append(id_systemBlock);
836 
	CpuQuery.prepare(CpuSqlQueryText);
837 
	CpuQuery.exec();
838 
	field_id = CpuQuery.record().indexOf(tr(""));
839 
	field_proizvoditel = CpuQuery.record().indexOf(tr(""));
840 
	field_slot = CpuQuery.record().indexOf(tr(""));
841 
	field_fqr = CpuQuery.record().indexOf(tr(""));
842 
	field_inventar_num = CpuQuery.record().indexOf(tr("_"));
843 
	field_serial_num = CpuQuery.record().indexOf(tr("_"));
844 
 
845 
	if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){
846 
		itemCpu_block = new QTreeWidgetItem(itemSysBlock);
847 
		itemCpu_block->setText(2, tr(""));
848 
		itemCpu_block->setText(14, id_otvetstvennogo_lica);
849 
	}
850 
 
851 
 
852 
	while(CpuQuery.next()){
853 
//		tmp = tr("CPU: ");
854 
	tmp = tr("");
855 
		CPU_id = CpuQuery.value(field_id).toString();
856 
		CPU_proizvoditel = CpuQuery.value(field_proizvoditel).toString();
857 
		CPU_slot = CpuQuery.value(field_slot).toString();
858 
		CPU_fqr = CpuQuery.value(field_fqr).toString();
859 
		CPU_inventar_num =  CpuQuery.value(field_inventar_num).toString();
860 
		CPU_serial_num = CpuQuery.value(field_serial_num).toString();
861 
 
862 
	if (CPU_proizvoditel != "") {
863 
		tmp.append(CPU_proizvoditel);}
864 
//	if (CPU_slot != "") {tmp.append(tr(" "));
865 
//	tmp.append(CPU_slot);
866 
//	tmp.append(tr(" "));}
867 
	if (CPU_fqr != "") {tmp.append(tr(" "));
868 
	tmp.append(CPU_fqr);
869 
	tmp.append(tr("MGz "));}
870 
	result.append(tmp);
871 
	if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){
872 
		itemCpu = new QTreeWidgetItem(itemCpu_block);
873 
	}
874 
	else itemCpu = new QTreeWidgetItem(itemSysBlock);
875 
 
876 
 
877 
//	itemCpu = new QTreeWidgetItem(itemSysBlock);
878 
	itemCpu->setText(2, tr(""));
879 
	itemCpu->setText(12, CPU_id);
880 
	itemCpu->setText(13, id_systemBlock);
881 
	itemCpu->setText(14, id_otvetstvennogo_lica);
882 
 
883 
	itemCpu->setIcon(4, cpu_icon);
884 
	itemCpu->setText(4, tmp);
885 
 
886 
	itemCpu->setText(3, CPU_inventar_num);
887 
		}
888 
	if (id_systemBlock !="1") itemSysBlock->setText(4, tmp);
889 
	return result;
890 
}
891 
 
892 
QString MainWindowImpl::addHDDInformation(QString id_otvetstvennogo_lica, QString id_systemBlock, QTreeWidgetItem * itemSysBlock)
893 
{
894 
	QString result, tmp;
895 
	QString HDD_id, HDD_proizvoditel, HDD_interfeis, HDD_obem, HDD_inventar_num, HDD_serial_num;
896 
	QString HDDSqlQueryText;
897 
	QSqlQuery HDDQuery;
898 
	int field_id, field_proizvoditel, field_interfeis, field_obem, field_inventar_num, field_serial_num;
899 
	QTreeWidgetItem *itemHDD;
900 
	QTreeWidgetItem *itemHDD_block;
901 
	HDDSqlQueryText = tr("select harddiscs.* "
902 
	" from harddiscs where harddiscs.__ = "
903 
	);
904 
	HDDSqlQueryText.append(id_systemBlock);
905 
	HDDQuery.prepare(HDDSqlQueryText);
906 
	HDDQuery.exec();
907 
	field_id = HDDQuery.record().indexOf(tr(""));
908 
	field_proizvoditel = HDDQuery.record().indexOf(tr(""));
909 
	field_interfeis = HDDQuery.record().indexOf(tr(""));
910 
	field_obem = HDDQuery.record().indexOf(tr(""));
911 
	field_inventar_num = HDDQuery.record().indexOf(tr("_"));
912 
	field_serial_num = HDDQuery.record().indexOf(tr("_"));
913 
 
914 
	if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){
915 
		itemHDD_block = new QTreeWidgetItem(itemSysBlock);
916 
		itemHDD_block->setText(2, tr(""));
917 
		itemHDD_block->setText(14, id_otvetstvennogo_lica);
918 
	}
919 
 
920 
 
921 
	while(HDDQuery.next()){
922 
//		tmp = tr("HDD: ");
923 
		tmp = tr("");
924 
		HDD_id = HDDQuery.value(field_id).toString();
925 
		HDD_proizvoditel = HDDQuery.value(field_proizvoditel).toString();
926 
		HDD_interfeis = HDDQuery.value(field_interfeis).toString();
927 
		HDD_obem = HDDQuery.value(field_obem).toString();
928 
		HDD_inventar_num =  HDDQuery.value(field_inventar_num).toString();
929 
		HDD_serial_num = HDDQuery.value(field_serial_num).toString();
930 
	if (HDD_proizvoditel != "") {
931 
		tmp.append(HDD_proizvoditel);}
932 
	if (HDD_interfeis != "") {tmp.append(tr(" "));
933 
	tmp.append(HDD_interfeis);
934 
	tmp.append(tr(" "));}
935 
	if (HDD_obem != "") {tmp.append(tr(" "));
936 
	tmp.append(HDD_obem);
937 
	tmp.append(tr("GB; "));}
938 
	result.append(tmp);
939 
 
940 
	if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){
941 
		itemHDD  = new QTreeWidgetItem(itemHDD_block);
942 
	}
943 
	else itemHDD  = new QTreeWidgetItem(itemSysBlock);
944 
 
945 
 
946 
//	itemHDD = new QTreeWidgetItem(itemSysBlock);
947 
 
948 
	itemHDD->setText(2, tr(" "));
949 
	itemHDD->setText(12, HDD_id);
950 
	itemHDD->setText(13, id_systemBlock);
951 
	itemHDD->setText(14, id_otvetstvennogo_lica);
952 
 
953 
	itemHDD->setIcon(4, hdd_icon);
954 
	itemHDD->setText(4, tmp);
955 
	itemHDD->setText(3, HDD_inventar_num);
956 
		}
957 
//	if (result!="") itemSysBlock->setIcon(7, hdd_icon);
958 
	if (id_systemBlock !="1") itemSysBlock->setText(7, result);
959 
	return result;
960 
}
961 
 
962 
QString MainWindowImpl::add_CD_DVD_Information(QString id_otvetstvennogo_lica, QString id_systemBlock, QTreeWidgetItem * itemSysBlock)
963 
{
964 
	QString result, tmp;
965 
	QString CD_DVD_id, CD_DVD_proizvoditel, CD_DVD_type, CD_DVD_speed, CD_DVD_serial_num, CD_DVD_inventar_num;
966 
	QString CD_DVD_SqlQueryText;
967 
	QSqlQuery CD_DVD_Query;
968 
	int field_id, field_proizvoditel, field_type, field_speed, field_serial_num, field_inventar_num;
969 
	QTreeWidgetItem *item_CD_DVD;
970 
	QTreeWidgetItem *item_CD_DVD_block;
971 
	CD_DVD_SqlQueryText = tr("select cd_dvd.* "
972 
	" from cd_dvd where cd_dvd.__ = "
973 
	);
974 
	CD_DVD_SqlQueryText.append(id_systemBlock);
975 
	CD_DVD_Query.prepare(CD_DVD_SqlQueryText);
976 
	CD_DVD_Query.exec();
977 
	field_id = CD_DVD_Query.record().indexOf(tr(""));
978 
	field_proizvoditel = CD_DVD_Query.record().indexOf(tr(""));
979 
	field_type = CD_DVD_Query.record().indexOf(tr(""));
980 
	field_speed = CD_DVD_Query.record().indexOf(tr(""));
981 
	field_inventar_num = CD_DVD_Query.record().indexOf(tr("_"));
982 
	field_serial_num = CD_DVD_Query.record().indexOf(tr("_"));
983 
 
984 
	if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){
985 
		item_CD_DVD_block = new QTreeWidgetItem(itemSysBlock);
986 
		item_CD_DVD_block->setText(2, tr(""));
987 
		item_CD_DVD_block->setText(14, id_otvetstvennogo_lica);
988 
	}
989 
 
990 
 
991 
	while(CD_DVD_Query.next()){
992 
//		tmp = tr("CD/DVD: ");
993 
	tmp = tr("");
994 
		CD_DVD_id = CD_DVD_Query.value(field_id).toString();
995 
		CD_DVD_proizvoditel = CD_DVD_Query.value(field_proizvoditel).toString();
996 
		CD_DVD_type = CD_DVD_Query.value(field_type).toString();
997 
		CD_DVD_speed = CD_DVD_Query.value(field_speed).toString();
998 
		CD_DVD_serial_num = CD_DVD_Query.value(field_serial_num).toString();
999 
		CD_DVD_inventar_num = CD_DVD_Query.value(field_inventar_num).toString();
1000 
 
1001 
	if (CD_DVD_type != "") {
1002 
		tmp.append(CD_DVD_type);}
1003 
	if (CD_DVD_proizvoditel != "") {tmp.append(tr(" "));
1004 
	tmp.append(CD_DVD_proizvoditel);
1005 
	tmp.append(tr(" "));}
1006 
	if (CD_DVD_speed != "") {tmp.append(tr(" "));
1007 
	tmp.append(CD_DVD_speed);
1008 
	tmp.append(tr(" "));}
1009 
	result.append(tmp);
1010 
 
1011 
if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){
1012 
		item_CD_DVD  = new QTreeWidgetItem(item_CD_DVD_block);
1013 
	}
1014 
	else item_CD_DVD = new QTreeWidgetItem(itemSysBlock);
1015 
 
1016 
	item_CD_DVD->setText(2, tr(""));
1017 
	item_CD_DVD->setText(12, CD_DVD_id);
1018 
	item_CD_DVD->setText(13, id_systemBlock);
1019 
	item_CD_DVD->setText(14, id_otvetstvennogo_lica);
1020 
	item_CD_DVD->setIcon(4, cd_dvd_icon);
1021 
	item_CD_DVD->setText(4, tmp);
1022 
	item_CD_DVD->setText(3, CD_DVD_inventar_num);
1023 
		}
1024 
	if (id_systemBlock !="1") itemSysBlock->setText(8, result);
1025 
	return result;
1026 
}
1027 
 
1028 
QString MainWindowImpl::add_Vidio_Information(QString id_otvetstvennogo_lica, QString id_systemBlock, QTreeWidgetItem * itemSysBlock){
1029 
 
1030 
	QString result, tmp;
1031 
	QString Vidio_id, Vidio_proizvoditel, Vidio_model, Vidio_interfeis, Vidio_ram, Vidio_inventar_num, Vidio_sereal_num;
1032 
	QString Vidio_SqlQueryText;
1033 
	QSqlQuery Vidio_Query;
1034 
	int field_id, field_proizvoditel, field_model, field_interfeis, field_ram, field_inventar_num, field_sereal_num;
1035 
	QTreeWidgetItem *item_Vidio, *item_Vidio_block;
1036 
	Vidio_SqlQueryText = tr("select videocards.* "
1037 
	" from videocards where videocards.__ = "
1038 
	);
1039 
	Vidio_SqlQueryText.append(id_systemBlock);
1040 
	Vidio_Query.prepare(Vidio_SqlQueryText);
1041 
	Vidio_Query.exec();
1042 
	field_id = Vidio_Query.record().indexOf(tr(""));
1043 
	field_proizvoditel = Vidio_Query.record().indexOf(tr(""));
1044 
	field_model = Vidio_Query.record().indexOf(tr(""));
1045 
	field_interfeis  = Vidio_Query.record().indexOf(tr(""));
1046 
	field_ram = Vidio_Query.record().indexOf(tr(""));
1047 
	field_inventar_num = Vidio_Query.record().indexOf(tr("_"));
1048 
	field_sereal_num = Vidio_Query.record().indexOf(tr("_"));
1049 
 
1050 
	if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){
1051 
		item_Vidio_block = new QTreeWidgetItem(itemSysBlock);
1052 
		item_Vidio_block->setText(2, tr(""));
1053 
		item_Vidio_block->setText(14, id_otvetstvennogo_lica);
1054 
	}
1055 
 
1056 
 
1057 
 
1058 
	while(Vidio_Query.next()){
1059 
//		tmp = tr("CD/DVD: ");
1060 
	tmp = tr("");
1061 
		Vidio_id = Vidio_Query.value(field_id).toString();
1062 
		Vidio_proizvoditel = Vidio_Query.value(field_proizvoditel).toString();
1063 
		Vidio_model = Vidio_Query.value(field_model).toString();
1064 
		Vidio_interfeis = Vidio_Query.value(field_interfeis).toString();
1065 
		Vidio_ram = Vidio_Query.value(field_ram).toString();
1066 
		Vidio_inventar_num = Vidio_Query.value(field_inventar_num).toString();
1067 
		Vidio_sereal_num =  Vidio_Query.value(field_sereal_num).toString();
1068 
	if (Vidio_interfeis != "") {tmp.append(tr(" "));
1069 
	tmp.append(Vidio_interfeis);}
1070 
	if (Vidio_proizvoditel != "") {tmp.append(tr(" "));
1071 
	tmp.append(Vidio_proizvoditel);}
1072 
	if (Vidio_model != "") {tmp.append(tr(" "));
1073 
		tmp.append(Vidio_model);}
1074 
 
1075 
	if (Vidio_ram !=""){tmp.append(tr(" "));
1076 
	tmp.append(Vidio_ram);
1077 
	tmp.append(tr(" Mb"));
1078 
 
1079 
	}
1080 
	result.append(tmp);
1081 
 
1082 
	if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){
1083 
		item_Vidio  = new QTreeWidgetItem(item_Vidio_block);
1084 
	}
1085 
	else item_Vidio = new QTreeWidgetItem(itemSysBlock);
1086 
 
1087 
 
1088 
//	item_Vidio = new QTreeWidgetItem(itemSysBlock);
1089 
 
1090 
	item_Vidio->setText(2, tr(""));
1091 
	item_Vidio->setText(12, Vidio_id);
1092 
	item_Vidio->setText(13, id_systemBlock);
1093 
	item_Vidio->setText(14, id_otvetstvennogo_lica);
1094 
	item_Vidio->setIcon(4, vidio_card_icon);
1095 
	item_Vidio->setText(4, tmp);
1096 
	item_Vidio->setText(3, Vidio_inventar_num);
1097 
		}
1098 
	if (id_systemBlock !="1") itemSysBlock->setText(9, result);
1099 
	return result;
1100 
}
1101 
 
1102 
 
1103 
QString MainWindowImpl::add_Sound_Card_Information(QString id_otvetstvennogo_lica, QString id_systemBlock, QTreeWidgetItem * itemSysBlock){
1104 
 
1105 
 
1106 
	QString result, tmp;
1107 
	QString Sound_card_id, Sound_card_proizvoditel, Sound_card_model, Sound_card_inventar_num, Sound_card_serial_num;
1108 
	QString Sound_card_SqlQueryText;
1109 
	QSqlQuery Sound_card_Query;
1110 
	int field_id, field_proizvoditel, field_model, field_inventar_num, field_serial_num;
1111 
	QTreeWidgetItem *item_Sound_card, *item_Sound_card_block;
1112 
	Sound_card_SqlQueryText = tr("select soundcards.* "
1113 
	" from soundcards where soundcards.__ = "
1114 
	);
1115 
	Sound_card_SqlQueryText.append(id_systemBlock);
1116 
	Sound_card_Query.prepare(Sound_card_SqlQueryText);
1117 
	Sound_card_Query.exec();
1118 
	field_id = Sound_card_Query.record().indexOf(tr(""));
1119 
	field_proizvoditel = Sound_card_Query.record().indexOf(tr(""));
1120 
	field_model = Sound_card_Query.record().indexOf(tr(""));
1121 
	field_inventar_num =  Sound_card_Query.record().indexOf(tr("_"));
1122 
	field_serial_num = Sound_card_Query.record().indexOf(tr("_"));
1123 
 
1124 
 
1125 
	if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){
1126 
		item_Sound_card_block = new QTreeWidgetItem(itemSysBlock);
1127 
		item_Sound_card_block->setText(2, tr(" "));
1128 
		item_Sound_card_block->setText(14, id_otvetstvennogo_lica);
1129 
	}
1130 
 
1131 
	while(Sound_card_Query.next()){
1132 
//		tmp = tr("CD/DVD: ");
1133 
	tmp = tr("");
1134 
		Sound_card_id = Sound_card_Query.value(field_id).toString();
1135 
		Sound_card_proizvoditel = Sound_card_Query.value(field_proizvoditel).toString();
1136 
		Sound_card_model = Sound_card_Query.value(field_model).toString();
1137 
		Sound_card_inventar_num = Sound_card_Query.value(field_inventar_num).toString();
1138 
		Sound_card_serial_num = Sound_card_Query.value(field_serial_num).toString();
1139 
 
1140 
//		Vidio_interfeis = Vidio_Query.value(field_interfeis).toString();
1141 
//		Vidio_ram = Vidio_Query.value(field_ram).toString();
1142 
	if (Sound_card_proizvoditel != "") {tmp.append(tr(" "));
1143 
	tmp.append(Sound_card_proizvoditel);}
1144 
 
1145 
	if (Sound_card_model != "") {tmp.append(tr(" "));
1146 
		tmp.append(Sound_card_model);}
1147 
 
1148 
///	if (Vidio_ram !=""){tmp.append(tr(" "));
1149 
///	tmp.append(Vidio_ram);
1150 
///	tmp.append(tr(" Mb"));
1151 
 
1152 
///	}
1153 
	result.append(tmp);
1154 
 
1155 
	if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){
1156 
		item_Sound_card  = new QTreeWidgetItem(item_Sound_card_block);
1157 
	}
1158 
	else item_Sound_card = new QTreeWidgetItem(itemSysBlock);
1159 
 
1160 
 
1161 
//	item_Sound_card = new QTreeWidgetItem(itemSysBlock);
1162 
 
1163 
 
1164 
	item_Sound_card->setText(2, tr(" "));
1165 
	item_Sound_card->setText(12, Sound_card_id);
1166 
	item_Sound_card->setText(13, id_systemBlock);
1167 
	item_Sound_card->setText(14, id_otvetstvennogo_lica);
1168 
	item_Sound_card->setIcon(4, sound_card_icon);
1169 
	item_Sound_card->setText(4, tmp);
1170 
	item_Sound_card->setText(3, Sound_card_inventar_num);
1171 
		}
1172 
	if (id_systemBlock !="1") itemSysBlock->setText(10, result);
1173 
	return result;
1174 
 
1175 
}
1176 
 
1177 
QString MainWindowImpl::add_Lan_Card_Information(QString id_otvetstvennogo_lica, QString id_systemBlock, QTreeWidgetItem * itemSysBlock){
1178 
 
1179 
 
1180 
	QString result, tmp;
1181 
	QString Lan_card_id, Lan_card_proizvoditel, Lan_card_model, Lan_speed, Lan_inventar_num, Lan_serial_num;
1182 
	QString Lan_card_SqlQueryText;
1183 
	QSqlQuery Lan_card_Query;
1184 
	int field_id, field_proizvoditel, field_model, field_speed, field_serial_num, field_inventar_num;
1185 
	QTreeWidgetItem *item_Lan_card, *item_Lan_card_block;
1186 
	Lan_card_SqlQueryText = tr("select lancards.* "
1187 
	" from lancards where lancards.__ = "
1188 
	);
1189 
	Lan_card_SqlQueryText.append(id_systemBlock);
1190 
	Lan_card_Query.prepare(Lan_card_SqlQueryText);
1191 
	Lan_card_Query.exec();
1192 
	field_id = Lan_card_Query.record().indexOf(tr(""));
1193 
	field_proizvoditel = Lan_card_Query.record().indexOf(tr(""));
1194 
	field_model = Lan_card_Query.record().indexOf(tr(""));
1195 
	field_speed = Lan_card_Query.record().indexOf(tr("__"));
1196 
	field_serial_num = Lan_card_Query.record().indexOf(tr("_"));
1197 
	field_inventar_num = Lan_card_Query.record().indexOf(tr("_"));
1198 
 
1199 
	if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){
1200 
		item_Lan_card_block = new QTreeWidgetItem(itemSysBlock);
1201 
		item_Lan_card_block->setText(2, tr(" "));
1202 
		item_Lan_card_block->setText(14, id_otvetstvennogo_lica);
1203 
	}
1204 
 
1205 
	while(Lan_card_Query.next()){
1206 
//		tmp = tr("CD/DVD: ");
1207 
	tmp = tr("");
1208 
		Lan_card_id = Lan_card_Query.value(field_id).toString();
1209 
		Lan_card_proizvoditel = Lan_card_Query.value(field_proizvoditel).toString();
1210 
		Lan_card_model = Lan_card_Query.value(field_model).toString();
1211 
		Lan_speed = Lan_card_Query.value(field_speed).toString();
1212 
		Lan_inventar_num =  Lan_card_Query.value(field_inventar_num).toString();
1213 
		Lan_serial_num = Lan_card_Query.value(field_serial_num).toString();
1214 
 
1215 
 
1216 
//		Vidio_interfeis = Vidio_Query.value(field_interfeis).toString();
1217 
//		Vidio_ram = Vidio_Query.value(field_ram).toString();
1218 
	if (Lan_card_proizvoditel != "") {tmp.append(tr(" "));
1219 
	tmp.append(Lan_card_proizvoditel);}
1220 
 
1221 
	if (Lan_card_model != "") {tmp.append(tr(" "));
1222 
		tmp.append(Lan_card_model);}
1223 
 
1224 
	if (Lan_speed != "") {tmp.append(tr(" "));
1225 
		tmp.append(Lan_speed);
1226 
		tmp.append(tr(" Mbit"));}
1227 
 
1228 
///	if (Vidio_ram !=""){tmp.append(tr(" "));
1229 
///	tmp.append(Vidio_ram);
1230 
///	tmp.append(tr(" Mb"));
1231 
 
1232 
///	}
1233 
	result.append(tmp);
1234 
 
1235 
	if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){
1236 
		item_Lan_card  = new QTreeWidgetItem(item_Lan_card_block);
1237 
	}
1238 
	else item_Lan_card = new QTreeWidgetItem(itemSysBlock);
1239 
 
1240 
//	item_Lan_card = new QTreeWidgetItem(itemSysBlock);
1241 
 
1242 
 
1243 
	item_Lan_card->setText(2, tr(" "));
1244 
	item_Lan_card->setText(12, Lan_card_id);
1245 
	item_Lan_card->setText(13, id_systemBlock);
1246 
	item_Lan_card->setText(14, id_otvetstvennogo_lica);
1247 
	item_Lan_card->setIcon(4, lan_card_icon);
1248 
	item_Lan_card->setText(4, tmp);
1249 
	item_Lan_card->setText(3, Lan_inventar_num);
1250 
		}
1251 
	if (id_systemBlock !="1") itemSysBlock->setText(11, result);
1252 
	return result;
1253 
 
1254 
}
1255 
 
1256 
void MainWindowImpl::refreshTree(){
1257 
 
1258 
	initTreeWidget();
1259 
}
1260 
 
1261 
int MainWindowImpl::select_system_block(){
1262 
	return 1;
1263 
}
1264