Хранилища Subversion OpenInventory

#include "mainwindowimpl.h"

//��������

MainWindowImpl::MainWindowImpl( QWidget * parent, Qt::WFlags f)

	: QMainWindow(parent, f)

{

	setupUi(this);

	fEnable_component_add = false; //����� ���������� ���������� ��������

	fEnable_naznachit_otvetstv = false;

	curr_task = no_task;

	readSettings();

	lineEdit->insert(baseName);

	metaDataAction = new QAction(tr("��������"), treeWidget);

	addMemoryAction = new QAction(tr("����� ������ ������"), treeWidget);

	MB_na_skladAction = new QAction(tr("����� �� �����"), treeWidget);

	new_sotrydnikAction = new QAction(tr("����� ���������"), treeWidget);

	novoe_oborydovanieAction = new QAction(tr("����� ������������"), treeWidget);

	pereimenovat_otdelAction = new QAction(tr("������������� �����"), treeWidget);

	perevesti_sotrydnika_v_drygo1_otdelAction = new QAction(tr("��������� � ������ �����"), treeWidget);

	yvolit_sotrydnikaAction = new QAction(tr("������� ����������"), treeWidget);

	SpliterAction = new QAction(tr("��������"), treeWidget);

	naznachit_otvetstvennim_za_oborydovanieAction = new QAction(tr("��������� ������������� �� ������������"), treeWidget);

	ystanovit_novie_complektyushieAction = new QAction(tr("���������� ����� �������������"), treeWidget);

	sozdat_otdelAction = new QAction(tr("������� ����� �����"), treeWidget);

	novaya_SYSTEM_BLOCK_na_skladAction = new QAction(tr("�������� ����� ��������� ���� �� �����"), treeWidget);

	novaya_MB_na_skladAction = new QAction(tr("�������� ����� ����������� ����� �� �����"), treeWidget);

	novaya_RAM_na_skladAction = new QAction(tr("�������� ����� ������ ������ �� �����"),  treeWidget);

	novaya_CPU_na_skladAction = new QAction(tr("�������� ����� ��������� �� �����"),  treeWidget);

	novaya_HDD_na_skladAction = new QAction(tr("�������� ����� ��������� �� �����"),  treeWidget);

	novaya_CD_DVD_na_skladAction = new QAction(tr("�������� ����� ������ �� �����"),  treeWidget);

	novaya_VIDEO_na_skladAction = new QAction(tr("�������� ����� ���������� �� �����"),  treeWidget);

	novaya_SoundCard_na_skladAction = new QAction(tr("�������� ����� �������� ����� �� �����"),  treeWidget);

	novaya_LAN_na_skladAction = new QAction(tr("�������� ����� ������� ����� �� �����"),  treeWidget);

	peredat_sys_block_pod_otveystvennostAction = new QAction(tr("�������� ��������� ���� ��� ��������������� ����������"),  treeWidget);

//	novaya_SoundCard_na_skladAction = new QAction(tr("�������� ����� �������� ����� �� �����"),  treeWidget);

//	novaya_LAN_na_skladAction = new QAction(tr("�������� ����� ������� ����� �� �����"),  treeWidget);

	insert_MB_to_system_blockAction = new QAction(tr("���������� � ��������� ����"), treeWidget);

	treeWidget->addAction(metaDataAction);

	treeWidget->addAction(addMemoryAction);

	connect(insert_MB_to_system_blockAction, SIGNAL(triggered()), SLOT(insert_MB_to_system_block()));

	connect(novaya_MB_na_skladAction, SIGNAL(triggered()), SLOT(novaya_MB_na_sklad()));

	connect(novaya_RAM_na_skladAction, SIGNAL(triggered()), SLOT(novaya_RAM_na_sklad()));

	connect(novaya_CPU_na_skladAction, SIGNAL(triggered()), SLOT(novaya_CPU_na_sklad()));

	connect(novaya_HDD_na_skladAction, SIGNAL(triggered()), SLOT(novaya_HDD_na_sklad()));

	connect(novaya_CD_DVD_na_skladAction, SIGNAL(triggered()), SLOT(novaya_CD_DVD_na_sklad()));

	connect(novaya_VIDEO_na_skladAction, SIGNAL(triggered()), SLOT(novaya_VIDEO_na_sklad()));

	connect(novaya_SoundCard_na_skladAction, SIGNAL(triggered()), SLOT(novaya_SoundCard_na_sklad()));

	connect(novaya_LAN_na_skladAction, SIGNAL(triggered()), SLOT(novaya_LAN_na_sklad()));

	connect(novaya_SYSTEM_BLOCK_na_skladAction, SIGNAL(triggered()), SLOT(novaya_SYSTEM_BLOCK_na_sklad()));

	connect(peredat_sys_block_pod_otveystvennostAction, SIGNAL(triggered()), SLOT(peredat_sys_block_pod_otveystvennost()));

	connect(sozdat_otdelAction, SIGNAL(triggered()), SLOT(addNewOtdel()));

	connect(metaDataAction, SIGNAL(triggered()), SLOT(editTreeWidget()));

	connect(addMemoryAction, SIGNAL(triggered()), SLOT(addNewMemory()));

	connect(MB_na_skladAction, SIGNAL(triggered()), SLOT(move_to_sklad()));

	connect(new_sotrydnikAction, SIGNAL(triggered()), SLOT(new_sotrydnik()));

	connect(novoe_oborydovanieAction, SIGNAL(triggered()), SLOT(novoe_oborydovanie()));

	connect(pereimenovat_otdelAction, SIGNAL(triggered()), SLOT(pereimenovft_otdel()));

	connect(yvolit_sotrydnikaAction, SIGNAL(triggered()), SLOT(yvolit_sotrydnika()));

	connect(naznachit_otvetstvennim_za_oborydovanieAction, SIGNAL(triggered()), SLOT(naznachit_otvetstvennim_za_oborydovanie()));

	connect(ystanovit_novie_complektyushieAction, SIGNAL(triggered()), SLOT(ystanovit_novie_complektyushie()));

	treeWidget->setContextMenuPolicy(Qt::ActionsContextMenu);

	connect(openBaseAct, SIGNAL(triggered()), this, SLOT(openBase()));

	connect(openMemoryTableAct, SIGNAL(triggered()), this, SLOT(openMemoryTable()));

	connect(getsettingAct, SIGNAL(triggered()), this, SLOT(getSetting()));

	connect(addStringAct, SIGNAL(triggered()), this, SLOT(addString()));

	connect(delStringAct, SIGNAL(triggered()), this, SLOT(delString()));

	connect(FiltrButton, SIGNAL(clicked()), this, SLOT(filter()));

	connect(hiddenButton, SIGNAL(clicked()), this, SLOT(hiddenRow()));

	connect(showButton, SIGNAL(clicked()), this, SLOT(showRow()));

	connect(appyButton, SIGNAL(clicked()), this, SLOT(dbUpdate()));

	connect(treeWidget, SIGNAL(itemActivated(QTreeWidgetItem *item, int column)), this, SLOT(dblClick(QTreeWidgetItem *item, int column)));

	connect(&addmemFrm, SIGNAL(componentAdd()), this, SLOT(refreshTree()));//��� �������� ����� addmemFrm ��������� treeWidget

	connect(&addotdelFrm, SIGNAL(componentAdd()), this, SLOT(refreshTree()));//��� �������� ����� addotdelFrm ��������� treeWidget

	connect(&addsotrydnikFrm, SIGNAL(componentAdd()), this, SLOT(refreshTree()));//��� �������� ����� addsotFrm ��������� treeWidget

	connect(&addsysblockFrm, SIGNAL(componentAdd()), this, SLOT(refreshTree()));//��� �������� ����� addsysblockFrm ��������� treeWidget

	connect(&addmemFrm, SIGNAL(formClose()), this, SLOT(on_addmemoryForm_formClose()));

	connect(&addotdelFrm, SIGNAL(formClose()), this, SLOT(on_addmemoryForm_formClose()));

	connect(&addsotrydnikFrm, SIGNAL(formClose()), this, SLOT(on_addmemoryForm_formClose()));

	connect(&addsysblockFrm, SIGNAL(formClose()), this, SLOT(on_addmemoryForm_formClose()));

	connect(&process, SIGNAL(readyReadStandardOutput()), this, SLOT(readStandartProcessOutput()));

	comp_icon.addFile("./pc.png");

/////	hdd_icon.addFile("./gnome-dev-harddisk.png");

	hdd_icon.addFile("./hdd5.png");

	memory_icon.addFile("./memory1.png");

	cd_dvd_icon.addFile("./cd_dvd3.png");

//	memory_icon.addFile("./gnome-dev-memory.png");

	matheboard_icon.addFile("./icon_motherboard.png");

	cpu_icon.addFile("./cpu3.png");

	vidio_card_icon.addFile("./vidiocard2.png");

	sound_card_icon.addFile("./soundcard1.png");

	lan_card_icon.addFile("./lan1.png");

	appyButton->setIcon(comp_icon);

	wmiFrm.show();

/////	 for (int i = 0; i < 10; ++i)

/////     items.append(new QTreeWidgetItem((QTreeWidget*)0, QStringList(QString("item: %1").arg(i))));

/////	 treeWidget->insertTopLevelItems(0, items);

//////items.append(new QTreeWidgetItem((QTreeWidget*)0, QStringList(QString(tr("�����: %1")).arg(0))));

/////////items.append(new QTreeWidgetItem((QTreeWidget*)0, QStringList(QString(tr("�����:")))));

/////////items.append(new QTreeWidgetItem((QTreeWidget*)0, QStringList(QString(tr("���:")))));

/////////treeWidget->insertTopLevelItems(0, items);

//->itm = new QTreeWidgetItem(treeWidget);

//->itm->setText(0, tr("�����"));

/////////itm->setText(1, "hello1");

//->QTreeWidgetItem *itm1 = new QTreeWidgetItem(itm);

//->itm1->setText(1, tr("M1"));

//->QTreeWidgetItem *itm1_1 = new QTreeWidgetItem(itm1);

//->itm1_1->setText(2, tr("�������"));

//->QTreeWidgetItem *itm1_2 = new QTreeWidgetItem(itm1);

//->itm1_2->setText(2, tr("�����"));

//->QTreeWidgetItem *itm2 = new QTreeWidgetItem(itm);

//->itm2->setText(1, tr("M2"));

//////treeWidget->insertTopLevelItem(new QTreeWidgetItem((QTreeWidget*)0, QStringList(QString(tr("�����:")))));

}

MainWindowImpl::~MainWindowImpl()

{

	db.close();

//	delete setFrm;

}

void MainWindowImpl::delString()

{

	QModelIndex index;

	int column, row;

	QSqlRecord record;

	index=view.currentIndex();

	column=view.currentIndex().column();

	row=view.currentIndex().row();

	record = model->record(row);

	int UserNameIndex = record.indexOf(tr("������������"));

	QString ls_UserName=record.value(UserNameIndex).toString();

	model->removeRows(row, 1);

}

//

void MainWindowImpl::openBase()

{

	lineEdit->insert(tr("������� ���� "));

//	db = new QSqlDatabase("QMYSQL");

	db = QSqlDatabase::addDatabase("QMYSQL");

	pdb = &db;

	raportFrm.pdb = &db;

//	db->addDatabase("QMYSQL");

//db = QSqlDatabase::addDatabase("QSQLITE");

	pdb->setHostName(hostName);

	pdb->setDatabaseName(baseName);

	pdb->setUserName(userName);

	pdb->setPassword(password);

	bool ok = pdb->open();

	if (!ok) {

				QMessageBox::critical( // ������ � ���������� �� ������.

										this,                      // ������������ ������.

										QObject::tr("Database Error"),   // ���������.

										pdb->lastError().text());          // ����� ���������.

			 }

	if (ok)

	{lineEdit-> insert(tr("���� ������� �������"));

	}

	else {lineEdit-> insert(tr("���� ����������. ��� ������: "));

		  lineEdit-> insert(pdb->lastError().text());

		 }

//	QSqlQuery q;

//	q.prepare(tr("set NAMES cp1251"));

//	ok = q.exec();

	model = new QSqlTableModel();

	model->setTable(tableName);

	model->setEditStrategy(QSqlTableModel::OnFieldChange);

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

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

	model->select();

//	model->setHeaderData(0, Qt::Horizontal,

//	                        QObject::tr("���\n������������"));

//	model->setHeaderData(1, Qt::Horizontal,

//	                       QObject::tr("�����"));

//	model->setHeaderData(2, Qt::Horizontal,

//	                       QObject::tr("IP �����"));

//	model->setHeaderData(3, Qt::Horizontal,

//	                       QObject::tr("�����������\n�����"));

//	model->setHeaderData(4, Qt::Horizontal,

//	                       QObject::tr("������������\n�������"));

//	view = new QTableView();

	view.setModel(model);

	view.setAlternatingRowColors(true);

//   	view->resizeRowsToContents();

   	view.resizeColumnsToContents();

	view.show();

	initTreeWidget();

}

void MainWindowImpl::openMemoryTable()

{

	memory_model = new QSqlTableModel();

	memory_model->setTable(tr("������"));

//	memory_model->setTable(tableName);

	memory_model->setEditStrategy(QSqlTableModel::OnFieldChange);

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

	memory_model->setSort(0, Qt::AscendingOrder);

	memory_model->select();

	tableView->setModel(memory_model);

	tableView->setAlternatingRowColors(true);

	tableView->resizeColumnsToContents();

	tableView->show();

/////	memory_view.setModel(memory_model);

/////	memory_view.setAlternatingRowColors(true);

//   	view->resizeRowsToContents();

/////   	memory_view.resizeColumnsToContents();

/////	memory_view.show();

}

void MainWindowImpl::applySetting()

{

	int i;

	i=5;

	lineEdit->insert(tr("��������� ��������!"));

	baseName = setFrm->lineEdit->text();

	userName = setFrm->lineEdit_2->text();

	password = setFrm->lineEdit_3->text();

	tableName = setFrm->lineEdit_4->text();

	hostName = setFrm->lineEdit_5->text();

	i+=1;

	writeSettings();

	setFrm->close();

	delete setFrm;

}

void MainWindowImpl::writeSettings()

{

	QSettings settings("Trolltech", "Application Example");

	settings.setValue("baseName", baseName);

	settings.setValue("userName", userName);

	settings.setValue("password", password);

	settings.setValue("tableName", tableName);

	settings.setValue("hostName", hostName);

}

void MainWindowImpl::readSettings()

{

	QSettings settings("Trolltech", "Application Example");

	baseName = settings.value("baseName", "an_db").toString();

	userName = settings.value("userName", "an").toString();

	password = settings.value("password", "393939").toString();

	tableName = settings.value("tableName", "inventar").toString();

	hostName = settings.value("hostName", "server").toString();

//     resize(size);

//     move(pos);tableName

}

void MainWindowImpl::getSetting()

{

	setFrm = new settingForm;

	connect(setFrm->pushButton, SIGNAL(clicked()), this, SLOT(applySetting()));

	setFrm->lineEdit->setText(baseName);

	setFrm->lineEdit_2->setText(userName);

	setFrm->lineEdit_3->setText(password);

	setFrm->lineEdit_4->setText(tableName);

	setFrm->lineEdit_5->setText(hostName);

	setFrm->show();

}

void MainWindowImpl::addString()

{

	QString query_begin=(tr("INSERT INTO "));

//	QString query_end=(tr(" VALUES('�� ������','�� ������','�� ������','�� ������',default)"));

	QString query_end=(tr(" VALUES()"));

	query_begin.append(tableName);

	query_begin.append(query_end);

	QSqlQuery query;

	query.prepare(query_begin);

//	query.prepare(tr("INSERT INTO inventar VALUES('�� ������','�� ������','�� ������','�� ������',default)"));

//	query.bindValue(":tab", "inventar");

//	 if (!query.execBatch())

//		qDebug() << query.lastError();

	query.exec();

	model->select();

// 	view->close();

	view.setModel(model);

	//view->show();

	lineEdit->insert(tr("�������� ������!"));

}

//��������� ���������� ���������

void MainWindowImpl::filter()

{

//	int i;

//	i++;

	model->setFilter(tr("����������='����������'"));

	model->select();

// 	view->close();

	view.setModel(model);

}

//TEST CVS gh

void MainWindowImpl::hiddenRow()

{

	int n;

	for(n=0;n<20;n++) view.setRowHidden(n,true);

}

void MainWindowImpl::showRow()

{

	int n;

	for(n=0;n<20;n++) view.setRowHidden(n,false);

}

void MainWindowImpl::dbUpdate()

{

	model->submitAll();

	addString();

}

void  MainWindowImpl::novaya_MB_na_sklad(){

	addmemFrm.tabWidget->setCurrentIndex(3);

	addmemFrm.pushButton->setEnabled(true);

	addmemFrm.show();

	addmemFrm.label_7->setText(tr("�� �����"));

	addNewMemory(tr("�� �����"));

}

void  MainWindowImpl::novaya_HDD_na_sklad(){

	addmemFrm.tabWidget->setCurrentIndex(1);

	addmemFrm.pushButton->setEnabled(true);

	addmemFrm.show();

	addmemFrm.label_7->setText(tr("�� �����"));

	addNewMemory(tr("�� �����"));

}

void  MainWindowImpl::novaya_CD_DVD_na_sklad(){

	addmemFrm.tabWidget->setCurrentIndex(4);

	addmemFrm.pushButton->setEnabled(true);

	addmemFrm.show();

	addmemFrm.label_7->setText(tr("�� �����"));

	addNewMemory(tr("�� �����"));

}

void  MainWindowImpl::novaya_VIDEO_na_sklad(){

	addmemFrm.tabWidget->setCurrentIndex(5);

	addmemFrm.pushButton->setEnabled(true);

	addmemFrm.show();

	addmemFrm.label_7->setText(tr("�� �����"));

	addNewMemory(tr("�� �����"));

}

void  MainWindowImpl::novaya_RAM_na_sklad(){

	addmemFrm.tabWidget->setCurrentIndex(0);

	addmemFrm.pushButton->setEnabled(true);

	addmemFrm.show();

	addmemFrm.label_7->setText(tr("�� �����"));

	addNewMemory(tr("�� �����"));

}

void  MainWindowImpl::novaya_SoundCard_na_sklad(){

	addmemFrm.tabWidget->setCurrentIndex(6);

	addmemFrm.pushButton->setEnabled(true);

	addmemFrm.show();

	addmemFrm.label_7->setText(tr("�� �����"));

	addNewMemory(tr("�� �����"));

}

void  MainWindowImpl::novaya_LAN_na_sklad(){

	addmemFrm.tabWidget->setCurrentIndex(7);

	addmemFrm.pushButton->setEnabled(true);

	addmemFrm.show();

	addmemFrm.label_7->setText(tr("�� �����"));

	addNewMemory(tr("�� �����"));

}

void  MainWindowImpl::novaya_CPU_na_sklad(){

	addmemFrm.tabWidget->setCurrentIndex(2);

	addmemFrm.pushButton->setEnabled(true);

	addmemFrm.show();

	addmemFrm.label_7->setText(tr("�� �����"));

	addNewMemory(tr("�� �����"));

}

void  MainWindowImpl::peredat_sys_block_pod_otveystvennost(){

	QMessageBox::information( // ������ � ���������� �� ������.

										this,                      // ������������ ������.

										QObject::tr("������� ���������� "),   // ���������.

//										db.lastError().text());          // ����� ���������.

										tr("������ �������� ���������� (������� ������ �����), ������� ����� ������������� �� ��������� ����."));

	fEnable_naznachit_otvetstv = true;

	curr_sys_block_id = treeWidget-> currentItem ()->text(12);

}

void MainWindowImpl::on_treeWidget_itemClicked(QTreeWidgetItem *item, int column)

{

	QString tmp;

	tmp = item->text(3);

	if (tmp !=""){

		addmemFrm.pushButton->setEnabled(true);

		}

	else addmemFrm.pushButton->setEnabled(false);

	addmemFrm.label_7->setText(tmp);

}

void MainWindowImpl::editTreeWidget()

{

	QString inventar_num;

	QTreeWidgetItem * currItem;

	int currColomn;

	int top_item_index;

	lineEdit->insert(tr("�������������"));

	currItem = treeWidget->currentItem ();

	top_item_index = treeWidget->indexOfTopLevelItem(currItem);

	currColomn = treeWidget->currentColumn();

	MainWindowImpl::on_treeWidget_itemClicked(currItem, 3); //������� ����� ���������� �� �����

//	inventar_num = tr("���.���: ");

	inventar_num.append(currItem ->text(3));

	if (currColomn == 1){

		addmemFrm.tabWidget->setCurrentIndex(4);

		addmemFrm.show();

	};

	if (inventar_num == "") return;

	lineEdit->insert(currItem ->text(currColomn));

	switch(currColomn)

	{

		case 1://����������

		{

		addmemFrm.tabWidget->setCurrentIndex(4);

		addmemFrm.show();

		}

		break;

		case 4: //���������

		{

		addmemFrm.tabWidget->setCurrentIndex(2);

		addmemFrm.show();

		}

		break;

		case 5: //����������� �����

		{

		addmemFrm.tabWidget->setCurrentIndex(3);

		addmemFrm.show();

		}

		break;

		case 6: //������

		{

		addmemFrm.tabWidget->setCurrentIndex(0);

		addNewMemory(inventar_num);

//		addmemFrm.show();

		}

		break;

		case 7: //���������

		{

		addmemFrm.tabWidget->setCurrentIndex(1);

		addmemFrm.show();

		}

		break;

		case 2: break;

		defaul: break;

	}

	addmemFrm.treeWidget->clear();

//	addmemFrm.initTreeWidgrt();

}

void MainWindowImpl::initTreeWidget()//����������� ������

{

	QStringList treeHeaders;//������ ���������� treeWidget

	treeWidget->setColumnCount(15);

	treeHeaders << tr("������") 					//0  �������

				<< tr("��������") 				//1  �������

				<< tr("��������") 			//2  �������

				<< tr("������������")			//3  �������

				<< tr("���������") 					//4  �������

				<< tr("���������")					//5  �������

				<< tr("������")						//6  �������

				<< tr("���������")					//7  �������

				<< tr("������")						//8  �������

				<< tr("����������")					//9  �������

				<< tr("�������� �����")				//10 �������

				<< tr("������� �����")				//11 �������

				<< tr("�������������")				//12 �������

				<< tr("������������� ��������� �����")	//13 �������

				<< tr("ID ������������� ����"); //14 �������

	treeWidget->setHeaderLabels(QStringList (treeHeaders));

//	treeWidget->setColumnHidden(2, true);

//	treeWidget->setColumnHidden(12, true);

//	treeWidget->setColumnHidden(13, true);

	treeWidget->clear();

	addOtdels();

	treeWidget->sortItems(0, Qt::AscendingOrder);

}

void MainWindowImpl::addOtdels()

{

	int fieldName, fieldID;

	QTreeWidgetItem *otdelItem;

	QSqlQuery q(tr("select * from otdeli"));// �������� ������ �������

	QString otdel, otdel_id;

	fieldName = q.record().indexOf(tr("��������"));

	fieldID = q.record().indexOf(tr("�������������"));

	while (q.next()){

		otdel = q.value(fieldName).toString();

		otdel_id = q.value(fieldID).toString();

		otdelItem = new QTreeWidgetItem(treeWidget);

		if (otdel == tr("�����")) { otdelItem->setText(0, otdel);

			otdelItem->setText(2, tr("�����"));

			otdelItem->setText(12, otdel_id);

			SotrydnikiOtdela(otdel_id, otdelItem);

			continue;

			 }

		otdelItem->setText(0, otdel);

		otdelItem->setText(2, tr("�����"));

		otdelItem->setText(12, otdel_id);

		SotrydnikiOtdela(otdel_id, otdelItem);

	}

}

void MainWindowImpl::SotrydnikiOtdela(QString id_otdela, QTreeWidgetItem * itemOtdela) // ��������� ������ ����������� ������

{

	int field_fio_sotrydnika, field_id_sotrydnika;

	int kolichestvo_sotrudnikov=0;

	QString fio_sotrydnika_otdela, id_sotrydnika_otdela, oboryd;

	QSqlQuery qsotrydnikiOtdela;

	QString sqlQueryString;

	QTreeWidgetItem *treeItem_sotrydnika;

	sqlQueryString = tr("select �������������, ��� from sotrydniki where �������������_������=");

	sqlQueryString.append(id_otdela);

	qsotrydnikiOtdela.prepare(sqlQueryString);

	qsotrydnikiOtdela.exec();

	field_fio_sotrydnika = qsotrydnikiOtdela.record().indexOf(tr("���"));

	field_id_sotrydnika = qsotrydnikiOtdela.record().indexOf(tr("�������������"));

	while (qsotrydnikiOtdela.next())

	{

		fio_sotrydnika_otdela = qsotrydnikiOtdela.value(field_fio_sotrydnika).toString();

		id_sotrydnika_otdela = qsotrydnikiOtdela.value(field_id_sotrydnika).toString();

		treeItem_sotrydnika = new QTreeWidgetItem(itemOtdela);

		treeItem_sotrydnika->setText(1, fio_sotrydnika_otdela );

		treeItem_sotrydnika->setText(2, tr("���������"));

		treeItem_sotrydnika->setText(14, id_sotrydnika_otdela );

		if (id_sotrydnika_otdela == "1"){

			itm_sklad_system_blocks = new QTreeWidgetItem(treeItem_sotrydnika);

			itm_sklad_system_blocks->setText(2, tr("��������� �����"));

			itm_sklad_orgtehnika = new QTreeWidgetItem(treeItem_sotrydnika);

			itm_sklad_orgtehnika->setText(2, tr("����������"));

			itm_sklad_orgtehnika_printers =  new QTreeWidgetItem(itm_sklad_orgtehnika);

			itm_sklad_orgtehnika_printers->setText(2, tr("��������"));

			itm_sklad_orgtehnika_mfy =   new QTreeWidgetItem(itm_sklad_orgtehnika);

			itm_sklad_orgtehnika_mfy->setText(2, tr("���"));

			itm_sklad_komplectyushie = new QTreeWidgetItem(treeItem_sotrydnika);

			itm_sklad_komplectyushie->setText(2, tr("�������������"));

			itm_sklad_orgtehnika_scaners = new QTreeWidgetItem(itm_sklad_orgtehnika);

			itm_sklad_orgtehnika_scaners->setText(2, tr("�������"));

			itm_sklad_rashodniki = new QTreeWidgetItem(treeItem_sotrydnika);

			itm_sklad_rashodniki->setText(2, tr("��������� ���������"));

		}

		oboryd = oborydovanie(id_sotrydnika_otdela, treeItem_sotrydnika);

//		treeItem_sotrydnika->setText(3, oboryd );

		++kolichestvo_sotrudnikov;

	}

	itemOtdela->setText(13, QVariant(kolichestvo_sotrudnikov).toString());

}

QString MainWindowImpl::oborydovanie(QString id_sotrydnika, QTreeWidgetItem * itemSotrydnika){

	QString result, prResult;

	QString sqlQueryText;

	QString serial_num, inventar_num, proizvoditel, model, system_block_id;

	QSqlQuery quer;

	QString MB_information, Memory_information, CPU_information, HDD_information, CD_DVD_information, Vidio_information;

	QString Sound_card_information, Lan_card_information;

	int field_serialNum, field_inventarNum, field_proizvoditel, field_model, field_system_block_id;

//	QSqlQuery qns(tr("SET NAMES utf8"));// �������� ������ �������

	QTreeWidgetItem *itemSysBlock;

//	sqlQueryText.reserve(300);

	sqlQueryText = tr("select system_blocks.��������_�����, system_blocks.�����������_�����, system_blocks.�������������"

	" from system_blocks"

	" where system_blocks.�������������_��������������_���� =");

	sqlQueryText.append(id_sotrydnika);

//	sqlQueryText.append(tr(" AND �����������_�����.�������������_����������_����� = ���������_�����.�������������"));

	quer.prepare(sqlQueryText);

//	quer.prepare(tr("select ���������_�����.��������_�����, ���������_�����.�����������_�����,�����������_�����.�������������, �����������_�����.������ from ���������_�����,�����������_����� where ���������_�����.�������������_��������������_���� = 4 AND �����������_�����.�������������_����������_����� = ���������_�����.�������������;"));

	quer.exec();

	field_serialNum = quer.record().indexOf(tr("��������_�����"));

	field_inventarNum = quer.record().indexOf(tr("�����������_�����"));

	field_system_block_id = quer.record().indexOf(tr("�������������"));

//	field_proizvoditel = quer.record().indexOf(tr("�������������"));

//	field_model = quer.record().indexOf(tr("������"));

	while(quer.next()){

	system_block_id = quer.value(field_system_block_id).toString();					//������������� ���������� �����

	prResult = "";

	serial_num = quer.value(field_serialNum).toString();

	inventar_num = quer.value(field_inventarNum).toString();

////	if (serial_num != "") {prResult.append(tr("s/n: "));

////		prResult.append(serial_num);}

	if (inventar_num != "") {

////	prResult.append(tr(" ���.���: "));

	prResult.append(inventar_num);

////	prResult.append(tr(" "));

}

//	result.append(q.value(field_proizvoditel).toString());

//	result.append(tr(" "));

//	result.append(q.value(field_model).toString());

//	if (id_sotrydnika == "1" & system_block_id == "1") itemSysBlock->setText(2, tr("�������������"));// ��� �����

	if (id_sotrydnika == "1" && system_block_id == "1") itemSysBlock = itm_sklad_komplectyushie;// ��� �����

	else if (id_sotrydnika == "1" ){

		itemSysBlock = new QTreeWidgetItem(itm_sklad_system_blocks); // �� ����� ���������

		itemSysBlock->setText(2, tr("��������� ����"));

		itemSysBlock->setIcon(3, comp_icon);

		if (system_block_id !="") itemSysBlock->setText(12, system_block_id);

		if (id_sotrydnika !="") itemSysBlock->setText(14, id_sotrydnika);

	}

	else {

		itemSysBlock = new QTreeWidgetItem(itemSotrydnika);

		itemSysBlock->setText(2, tr("��������� ����"));

		itemSysBlock->setIcon(3, comp_icon);

		if (system_block_id !="") itemSysBlock->setText(12, system_block_id);

		if (id_sotrydnika !="") itemSysBlock->setText(14, id_sotrydnika);

		}

	MB_information = addMatheBoardInformation (id_sotrydnika, system_block_id, itemSysBlock);		//�������� ���������� � ����������� �����

////	prResult.append(MB_information);

	Memory_information = addMemoryInformation(id_sotrydnika, system_block_id, itemSysBlock);		//�������� ���������� � ������

////	prResult.append(Memory_information);

	CPU_information = addCpuInformation(id_sotrydnika, system_block_id, itemSysBlock);

////	prResult.append(CPU_information);

	HDD_information = addHDDInformation(id_sotrydnika, system_block_id, itemSysBlock);

////	prResult.append(HDD_information);

	CD_DVD_information = add_CD_DVD_Information(id_sotrydnika, system_block_id, itemSysBlock);

////	prResult.append(CD_DVD_information);

	Vidio_information = add_Vidio_Information(id_sotrydnika, system_block_id, itemSysBlock);

	Sound_card_information = add_Sound_Card_Information(id_sotrydnika, system_block_id, itemSysBlock);

	Lan_card_information = add_Lan_Card_Information(id_sotrydnika, system_block_id, itemSysBlock);

	if (system_block_id != "1"){

		itemSysBlock->setText(3, prResult);

		result.append(prResult);

}

	}

	return result;

}

QString MainWindowImpl::addMatheBoardInformation(QString id_otvetstvennogo_lica, QString id_systemBlock, QTreeWidgetItem * itemSysBlock)

{

	QString result, tmp;

	QString MB_proizvoditel, MB_model, MB_identifikator, MB_serial_num, MB_inventar_num;

	QString MatheBoardSqlQueryText;

	QSqlQuery MatheBoardQuery;

	int field_proizvoditel, field_model, field_identifikator, field_serial_num, field_inventar_num;

	QTreeWidgetItem *itemMB, *itmMB_block;

	MatheBoardSqlQueryText = tr("select * "

	" from matheboards where matheboards.�������������_����������_����� = "

	);

	MatheBoardSqlQueryText.append(id_systemBlock);

	MatheBoardQuery.prepare(MatheBoardSqlQueryText);

	MatheBoardQuery.exec();

	field_identifikator = MatheBoardQuery.record().indexOf(tr("�������������"));

	field_proizvoditel = MatheBoardQuery.record().indexOf(tr("�������������"));

	field_model = MatheBoardQuery.record().indexOf(tr("������"));

	field_serial_num = MatheBoardQuery.record().indexOf(tr("��������_�����"));

	field_inventar_num = MatheBoardQuery.record().indexOf(tr("�����������_�����"));

	if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){

		itmMB_block = new QTreeWidgetItem(itm_sklad_komplectyushie);

		itmMB_block->setText(2, tr("����������� �����"));

//		itmMB_block->setIcon(3, matheboard_icon);

		}

	while(MatheBoardQuery.next()){

		tmp = "";

		MB_identifikator = MatheBoardQuery.value(field_identifikator).toString();

		MB_proizvoditel = MatheBoardQuery.value(field_proizvoditel).toString();

		MB_model = MatheBoardQuery.value(field_model).toString();

		MB_serial_num = MatheBoardQuery.value(field_serial_num).toString();

		MB_inventar_num = MatheBoardQuery.value(field_inventar_num).toString();

	if (MB_proizvoditel != "") {

//		tmp.append(tr("MB: "));

		tmp.append(MB_proizvoditel);

		}

	if (MB_model != "") {tmp.append(tr(" "));

	tmp.append(MB_model);

	tmp.append(tr(" "));}

	result.append(tmp);

	if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1") {itemMB = new QTreeWidgetItem(itmMB_block);

	}

	else itemMB = new QTreeWidgetItem(itemSysBlock);

	itemMB->setIcon(4, matheboard_icon);

	itemMB->setText(4, tmp);

	itemMB->setText(12, MB_identifikator);

	itemMB->setText(13, id_systemBlock);

	itemMB->setText(14, id_otvetstvennogo_lica);

	itemMB->setText(2, tr("����������� �����"));

	itemMB->setText(3, MB_inventar_num);

	if (id_systemBlock !="1") itemSysBlock->setText(5, tmp);

		}

	return result;

}

QString MainWindowImpl::addMemoryInformation(QString id_otvetstvennogo_lica, QString id_systemBlock, QTreeWidgetItem * itemSysBlock)

{

	QString result, tmp;

	QString Memiry_id, Memory_proizvoditel, Memory_type, Memory_obem, Memory_inventar_num, Memory_serial_num;

	QString MemorySqlQueryText;

	QSqlQuery MemoryQuery;

	int field_proizvoditel, field_type, field_obem, field_id, field_inventar_num, field_sereal_num;

	QTreeWidgetItem *itemMemory, *itemMemory_block;

	MemorySqlQueryText = tr("select memory.* "

	" from memory where memory.�������������_����������_����� = "

	);

	MemorySqlQueryText.append(id_systemBlock);

	MemoryQuery.prepare(MemorySqlQueryText);

	MemoryQuery.exec();

	field_id = MemoryQuery.record().indexOf(tr("�������������"));

	field_proizvoditel = MemoryQuery.record().indexOf(tr("�������������"));

	field_type = MemoryQuery.record().indexOf(tr("���"));

	field_obem = MemoryQuery.record().indexOf(tr("�����"));

	field_inventar_num = MemoryQuery.record().indexOf(tr("�����������_�����"));

	field_sereal_num = MemoryQuery.record().indexOf(tr("��������_�����"));

		if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){

		itemMemory_block = new QTreeWidgetItem(itm_sklad_komplectyushie);

		itemMemory_block->setText(2, tr("������ ������"));

	}

	while(MemoryQuery.next()){

//		tmp = tr("RAM: ");

		tmp = tr("");

		Memiry_id = MemoryQuery.value(field_id).toString();

		Memory_proizvoditel = MemoryQuery.value(field_proizvoditel).toString();

		Memory_type = MemoryQuery.value(field_type).toString();

		Memory_obem = MemoryQuery.value(field_obem).toString();

		Memory_inventar_num = MemoryQuery.value(field_inventar_num).toString();

		Memory_serial_num = MemoryQuery.value(field_sereal_num).toString();

////	if (Memory_proizvoditel != "") {

////		tmp.append(Memory_proizvoditel);}

	if (Memory_type != "") {tmp.append(tr(" "));

	tmp.append(Memory_type);

	tmp.append(tr(" "));}

	if (Memory_obem != "") {tmp.append(tr(" "));

	tmp.append(Memory_obem);

	tmp.append(tr("MB; "));}

	result.append(tmp);

	if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){

		itemMemory = new QTreeWidgetItem(itemMemory_block);

	}

	else itemMemory = new QTreeWidgetItem(itemSysBlock);

	itemMemory->setIcon(4, memory_icon);

	itemMemory->setText(4, tmp);

	itemMemory->setText(2, tr("������ ������"));

	itemMemory->setText(12, Memiry_id);

	itemMemory->setText(13, id_systemBlock);

	itemMemory->setText(14, id_otvetstvennogo_lica);

	itemMemory->setText(3, Memory_inventar_num);

		}

	if (id_systemBlock !="1") itemSysBlock->setText(6, result);

	return result;

}

QString MainWindowImpl::addCpuInformation(QString id_otvetstvennogo_lica, QString id_systemBlock, QTreeWidgetItem * itemSysBlock)

{

	QString result, tmp;

	QString CPU_id, CPU_proizvoditel, CPU_slot, CPU_fqr, CPU_inventar_num, CPU_serial_num;

	QString CpuSqlQueryText;

	QSqlQuery CpuQuery;

	int field_id, field_proizvoditel, field_slot, field_fqr, field_inventar_num, field_serial_num;

	QTreeWidgetItem *itemCpu, *itemCpu_block;

	CpuSqlQueryText = tr("select processors.* "

	" from processors where processors.�������������_����������_����� = "

	);

	CpuSqlQueryText.append(id_systemBlock);

	CpuQuery.prepare(CpuSqlQueryText);

	CpuQuery.exec();

	field_id = CpuQuery.record().indexOf(tr("�������������"));

	field_proizvoditel = CpuQuery.record().indexOf(tr("�������������"));

	field_slot = CpuQuery.record().indexOf(tr("����"));

	field_fqr = CpuQuery.record().indexOf(tr("�������"));

	field_inventar_num = CpuQuery.record().indexOf(tr("�����������_�����"));

	field_serial_num = CpuQuery.record().indexOf(tr("��������_�����"));

	if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){

		itemCpu_block = new QTreeWidgetItem(itemSysBlock);

		itemCpu_block->setText(2, tr("����������"));

		itemCpu_block->setText(14, id_otvetstvennogo_lica);

	}

	while(CpuQuery.next()){

//		tmp = tr("CPU: ");

	tmp = tr("");

		CPU_id = CpuQuery.value(field_id).toString();

		CPU_proizvoditel = CpuQuery.value(field_proizvoditel).toString();

		CPU_slot = CpuQuery.value(field_slot).toString();

		CPU_fqr = CpuQuery.value(field_fqr).toString();

		CPU_inventar_num =  CpuQuery.value(field_inventar_num).toString();

		CPU_serial_num = CpuQuery.value(field_serial_num).toString();

	if (CPU_proizvoditel != "") {

		tmp.append(CPU_proizvoditel);}

//	if (CPU_slot != "") {tmp.append(tr(" "));

//	tmp.append(CPU_slot);

//	tmp.append(tr(" "));}

	if (CPU_fqr != "") {tmp.append(tr(" "));

	tmp.append(CPU_fqr);

	tmp.append(tr("MGz "));}

	result.append(tmp);

	if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){

		itemCpu = new QTreeWidgetItem(itemCpu_block);

	}

	else itemCpu = new QTreeWidgetItem(itemSysBlock);

//	itemCpu = new QTreeWidgetItem(itemSysBlock);

	itemCpu->setText(2, tr("���������"));

	itemCpu->setText(12, CPU_id);

	itemCpu->setText(13, id_systemBlock);

	itemCpu->setText(14, id_otvetstvennogo_lica);

	itemCpu->setIcon(4, cpu_icon);

	itemCpu->setText(4, tmp);

	itemCpu->setText(3, CPU_inventar_num);

		}

	if (id_systemBlock !="1") itemSysBlock->setText(4, tmp);

	return result;

}

QString MainWindowImpl::addHDDInformation(QString id_otvetstvennogo_lica, QString id_systemBlock, QTreeWidgetItem * itemSysBlock)

{

	QString result, tmp;

	QString HDD_id, HDD_proizvoditel, HDD_interfeis, HDD_obem, HDD_inventar_num, HDD_serial_num;

	QString HDDSqlQueryText;

	QSqlQuery HDDQuery;

	int field_id, field_proizvoditel, field_interfeis, field_obem, field_inventar_num, field_serial_num;

	QTreeWidgetItem *itemHDD;

	QTreeWidgetItem *itemHDD_block;

	HDDSqlQueryText = tr("select harddiscs.* "

	" from harddiscs where harddiscs.�������������_����������_����� = "

	);

	HDDSqlQueryText.append(id_systemBlock);

	HDDQuery.prepare(HDDSqlQueryText);

	HDDQuery.exec();

	field_id = HDDQuery.record().indexOf(tr("�������������"));

	field_proizvoditel = HDDQuery.record().indexOf(tr("�������������"));

	field_interfeis = HDDQuery.record().indexOf(tr("���������"));

	field_obem = HDDQuery.record().indexOf(tr("�����"));

	field_inventar_num = HDDQuery.record().indexOf(tr("�����������_�����"));

	field_serial_num = HDDQuery.record().indexOf(tr("��������_�����"));

	if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){

		itemHDD_block = new QTreeWidgetItem(itemSysBlock);

		itemHDD_block->setText(2, tr("����������"));

		itemHDD_block->setText(14, id_otvetstvennogo_lica);

	}

	while(HDDQuery.next()){

//		tmp = tr("HDD: ");

		tmp = tr("");

		HDD_id = HDDQuery.value(field_id).toString();

		HDD_proizvoditel = HDDQuery.value(field_proizvoditel).toString();

		HDD_interfeis = HDDQuery.value(field_interfeis).toString();

		HDD_obem = HDDQuery.value(field_obem).toString();

		HDD_inventar_num =  HDDQuery.value(field_inventar_num).toString();

		HDD_serial_num = HDDQuery.value(field_serial_num).toString();

	if (HDD_proizvoditel != "") {

		tmp.append(HDD_proizvoditel);}

	if (HDD_interfeis != "") {tmp.append(tr(" "));

	tmp.append(HDD_interfeis);

	tmp.append(tr(" "));}

	if (HDD_obem != "") {tmp.append(tr(" "));

	tmp.append(HDD_obem);

	tmp.append(tr("GB; "));}

	result.append(tmp);

	if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){

		itemHDD  = new QTreeWidgetItem(itemHDD_block);

	}

	else itemHDD  = new QTreeWidgetItem(itemSysBlock);

//	itemHDD = new QTreeWidgetItem(itemSysBlock);

	itemHDD->setText(2, tr("������� ����"));

	itemHDD->setText(12, HDD_id);

	itemHDD->setText(13, id_systemBlock);

	itemHDD->setText(14, id_otvetstvennogo_lica);

	itemHDD->setIcon(4, hdd_icon);

	itemHDD->setText(4, tmp);

	itemHDD->setText(3, HDD_inventar_num);

		}

//	if (result!="") itemSysBlock->setIcon(7, hdd_icon);

	if (id_systemBlock !="1") itemSysBlock->setText(7, result);

	return result;

}

QString MainWindowImpl::add_CD_DVD_Information(QString id_otvetstvennogo_lica, QString id_systemBlock, QTreeWidgetItem * itemSysBlock)

{

	QString result, tmp;

	QString CD_DVD_id, CD_DVD_proizvoditel, CD_DVD_type, CD_DVD_speed, CD_DVD_serial_num, CD_DVD_inventar_num;

	QString CD_DVD_SqlQueryText;

	QSqlQuery CD_DVD_Query;

	int field_id, field_proizvoditel, field_type, field_speed, field_serial_num, field_inventar_num;

	QTreeWidgetItem *item_CD_DVD;

	QTreeWidgetItem *item_CD_DVD_block;

	CD_DVD_SqlQueryText = tr("select cd_dvd.* "

	" from cd_dvd where cd_dvd.�������������_����������_����� = "

	);

	CD_DVD_SqlQueryText.append(id_systemBlock);

	CD_DVD_Query.prepare(CD_DVD_SqlQueryText);

	CD_DVD_Query.exec();

	field_id = CD_DVD_Query.record().indexOf(tr("�������������"));

	field_proizvoditel = CD_DVD_Query.record().indexOf(tr("�������������"));

	field_type = CD_DVD_Query.record().indexOf(tr("���"));

	field_speed = CD_DVD_Query.record().indexOf(tr("��������"));

	field_inventar_num = CD_DVD_Query.record().indexOf(tr("�����������_�����"));

	field_serial_num = CD_DVD_Query.record().indexOf(tr("��������_�����"));

	if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){

		item_CD_DVD_block = new QTreeWidgetItem(itemSysBlock);

		item_CD_DVD_block->setText(2, tr("�������"));

		item_CD_DVD_block->setText(14, id_otvetstvennogo_lica);

	}

	while(CD_DVD_Query.next()){

//		tmp = tr("CD/DVD: ");

	tmp = tr("");

		CD_DVD_id = CD_DVD_Query.value(field_id).toString();

		CD_DVD_proizvoditel = CD_DVD_Query.value(field_proizvoditel).toString();

		CD_DVD_type = CD_DVD_Query.value(field_type).toString();

		CD_DVD_speed = CD_DVD_Query.value(field_speed).toString();

		CD_DVD_serial_num = CD_DVD_Query.value(field_serial_num).toString();

		CD_DVD_inventar_num = CD_DVD_Query.value(field_inventar_num).toString();

	if (CD_DVD_type != "") {

		tmp.append(CD_DVD_type);}

	if (CD_DVD_proizvoditel != "") {tmp.append(tr(" "));

	tmp.append(CD_DVD_proizvoditel);

	tmp.append(tr(" "));}

	if (CD_DVD_speed != "") {tmp.append(tr(" "));

	tmp.append(CD_DVD_speed);

	tmp.append(tr(" "));}

	result.append(tmp);

if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){

		item_CD_DVD  = new QTreeWidgetItem(item_CD_DVD_block);

	}

	else item_CD_DVD = new QTreeWidgetItem(itemSysBlock);

	item_CD_DVD->setText(2, tr("������"));

	item_CD_DVD->setText(12, CD_DVD_id);

	item_CD_DVD->setText(13, id_systemBlock);

	item_CD_DVD->setText(14, id_otvetstvennogo_lica);

	item_CD_DVD->setIcon(4, cd_dvd_icon);

	item_CD_DVD->setText(4, tmp);

	item_CD_DVD->setText(3, CD_DVD_inventar_num);

		}

	if (id_systemBlock !="1") itemSysBlock->setText(8, result);

	return result;

}

QString MainWindowImpl::add_Vidio_Information(QString id_otvetstvennogo_lica, QString id_systemBlock, QTreeWidgetItem * itemSysBlock){

	QString result, tmp;

	QString Vidio_id, Vidio_proizvoditel, Vidio_model, Vidio_interfeis, Vidio_ram, Vidio_inventar_num, Vidio_sereal_num;

	QString Vidio_SqlQueryText;

	QSqlQuery Vidio_Query;

	int field_id, field_proizvoditel, field_model, field_interfeis, field_ram, field_inventar_num, field_sereal_num;

	QTreeWidgetItem *item_Vidio, *item_Vidio_block;

	Vidio_SqlQueryText = tr("select videocards.* "

	" from videocards where videocards.�������������_����������_����� = "

	);

	Vidio_SqlQueryText.append(id_systemBlock);

	Vidio_Query.prepare(Vidio_SqlQueryText);

	Vidio_Query.exec();

	field_id = Vidio_Query.record().indexOf(tr("�������������"));

	field_proizvoditel = Vidio_Query.record().indexOf(tr("�������������"));

	field_model = Vidio_Query.record().indexOf(tr("������"));

	field_interfeis  = Vidio_Query.record().indexOf(tr("���������"));

	field_ram = Vidio_Query.record().indexOf(tr("������"));

	field_inventar_num = Vidio_Query.record().indexOf(tr("�����������_�����"));

	field_sereal_num = Vidio_Query.record().indexOf(tr("��������_�����"));

	if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){

		item_Vidio_block = new QTreeWidgetItem(itemSysBlock);

		item_Vidio_block->setText(2, tr("����������"));

		item_Vidio_block->setText(14, id_otvetstvennogo_lica);

	}

	while(Vidio_Query.next()){

//		tmp = tr("CD/DVD: ");

	tmp = tr("");

		Vidio_id = Vidio_Query.value(field_id).toString();

		Vidio_proizvoditel = Vidio_Query.value(field_proizvoditel).toString();

		Vidio_model = Vidio_Query.value(field_model).toString();

		Vidio_interfeis = Vidio_Query.value(field_interfeis).toString();

		Vidio_ram = Vidio_Query.value(field_ram).toString();

		Vidio_inventar_num = Vidio_Query.value(field_inventar_num).toString();

		Vidio_sereal_num =  Vidio_Query.value(field_sereal_num).toString();

	if (Vidio_interfeis != "") {tmp.append(tr(" "));

	tmp.append(Vidio_interfeis);}

	if (Vidio_proizvoditel != "") {tmp.append(tr(" "));

	tmp.append(Vidio_proizvoditel);}

	if (Vidio_model != "") {tmp.append(tr(" "));

		tmp.append(Vidio_model);}

	if (Vidio_ram !=""){tmp.append(tr(" "));

	tmp.append(Vidio_ram);

	tmp.append(tr(" Mb"));

	}

	result.append(tmp);

	if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){

		item_Vidio  = new QTreeWidgetItem(item_Vidio_block);

	}

	else item_Vidio = new QTreeWidgetItem(itemSysBlock);

//	item_Vidio = new QTreeWidgetItem(itemSysBlock);

	item_Vidio->setText(2, tr("����������"));

	item_Vidio->setText(12, Vidio_id);

	item_Vidio->setText(13, id_systemBlock);

	item_Vidio->setText(14, id_otvetstvennogo_lica);

	item_Vidio->setIcon(4, vidio_card_icon);

	item_Vidio->setText(4, tmp);

	item_Vidio->setText(3, Vidio_inventar_num);

		}

	if (id_systemBlock !="1") itemSysBlock->setText(9, result);

	return result;

}

QString MainWindowImpl::add_Sound_Card_Information(QString id_otvetstvennogo_lica, QString id_systemBlock, QTreeWidgetItem * itemSysBlock){

	QString result, tmp;

	QString Sound_card_id, Sound_card_proizvoditel, Sound_card_model, Sound_card_inventar_num, Sound_card_serial_num;

	QString Sound_card_SqlQueryText;

	QSqlQuery Sound_card_Query;

	int field_id, field_proizvoditel, field_model, field_inventar_num, field_serial_num;

	QTreeWidgetItem *item_Sound_card, *item_Sound_card_block;

	Sound_card_SqlQueryText = tr("select soundcards.* "

	" from soundcards where soundcards.�������������_����������_����� = "

	);

	Sound_card_SqlQueryText.append(id_systemBlock);

	Sound_card_Query.prepare(Sound_card_SqlQueryText);

	Sound_card_Query.exec();

	field_id = Sound_card_Query.record().indexOf(tr("�������������"));

	field_proizvoditel = Sound_card_Query.record().indexOf(tr("�������������"));

	field_model = Sound_card_Query.record().indexOf(tr("������"));

	field_inventar_num =  Sound_card_Query.record().indexOf(tr("�����������_�����"));

	field_serial_num = Sound_card_Query.record().indexOf(tr("��������_�����"));

	if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){