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