Редакция 6 | Только различия | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
| Редакция 6 | Редакция 17 | ||
|---|---|---|---|
| 1 | #include "mainwindowimpl.h"
|
1 | #include "mainwindowimpl.h"
|
| 2 | // place your code here
|
2 | // place your code here
|
| 3 | // ïðîâåðêà
|
3 | // ïðîâåðêà
|
| 4 | 4 | ||
| 5 | void MainWindowImpl::addNewMemory(){ |
5 | void MainWindowImpl::addNewMemory(){ |
| 6 | QStringList proizv_list; //ñïèñîê ïðîèçâîäèòåëåé ïàìÿòè |
6 | QStringList proizv_list; //ñïèñîê ïðîèçâîäèòåëåé ïàìÿòè |
| 7 | QStringList user_list;
|
7 | QStringList user_list;
|
| 8 | // addmemFrm = new addmemoryForm;
|
8 | // addmemFrm = new addmemoryForm;
|
| 9 | // QString temp;
|
9 | // QString temp;
|
| 10 | // int lsize;
|
10 | // int lsize;
|
| 11 | addmemFrm.treeWidget->clear(); |
11 | addmemFrm.treeWidget->clear(); |
| 12 | addmemFrm.comboBox->clear(); |
12 | addmemFrm.comboBox->clear(); |
| 13 | addmemFrm.comboBox_4->clear(); |
13 | addmemFrm.comboBox_4->clear(); |
| 14 | proizv_list = addmemFrm.getManufacturiesList(); |
14 | proizv_list = addmemFrm.getManufacturiesList(); |
| 15 | user_list = addmemFrm.getSystemBlockList(); |
15 | user_list = addmemFrm.getSystemBlockList(); |
| 16 | 16 | ||
| 17 | // lsize = proizv_list.size();
|
17 | // lsize = proizv_list.size();
|
| 18 | //for (int i = 0; i < lsize; ++i){
|
18 | //for (int i = 0; i < lsize; ++i){
|
| 19 | // temp = proizv_list.at(i); }
|
19 | // temp = proizv_list.at(i); }
|
| 20 | addmemFrm.comboBox->addItems(proizv_list); |
20 | addmemFrm.comboBox->addItems(proizv_list); |
| 21 | addmemFrm.comboBox_4->addItems(user_list); |
21 | addmemFrm.comboBox_4->addItems(user_list); |
| 22 | addmemFrm.show(); |
22 | addmemFrm.show(); |
| 23 | }
|
23 | }
|
| 24 | 24 | ||
| 25 | void MainWindowImpl::addNewMemory(QString inventar_num){ |
25 | void MainWindowImpl::addNewMemory(QString inventar_num){ |
| 26 | QStringList proizv_list; //ñïèñîê ïðîèçâîäèòåëåé ïàìÿòè |
26 | QStringList proizv_list; //ñïèñîê ïðîèçâîäèòåëåé ïàìÿòè |
| 27 | QStringList mb_proizv_list; //ñïèñîê ïðîèçâîäèòåëåé ìàòåðèíñêèõ ïëàò |
27 | QStringList mb_proizv_list; //ñïèñîê ïðîèçâîäèòåëåé ìàòåðèíñêèõ ïëàò |
| 28 | QStringList hdd_proizv_list; //ñïèñîê ïðîèçâîäèòåëåé âèí÷åñòåðîâ |
28 | QStringList hdd_proizv_list; //ñïèñîê ïðîèçâîäèòåëåé âèí÷åñòåðîâ |
| 29 | QStringList cpu_proizv_list; //ñïèñîê ïðîèçâîäèòåëåé âèí÷åñòåðîâ |
29 | QStringList cpu_proizv_list; //ñïèñîê ïðîèçâîäèòåëåé âèí÷åñòåðîâ |
| 30 | QStringList video_proizv_list; //ñïèñîê ïðîèçâîäèòåëåé âèäåîêàðò |
30 | QStringList video_proizv_list; //ñïèñîê ïðîèçâîäèòåëåé âèäåîêàðò |
| 31 | QStringList mb_model_list;//ñïèñîê ìîäåëåé ìàòåðèíñêèõ ïëàò |
31 | QStringList mb_model_list;//ñïèñîê ìîäåëåé ìàòåðèíñêèõ ïëàò |
| 32 | QStringList user_list;
|
32 | QStringList user_list;
|
| 33 | QString currProizvoditel;
|
33 | QString currProizvoditel;
|
| 34 | // addmemFrm = new addmemoryForm;
|
34 | // addmemFrm = new addmemoryForm;
|
| 35 | // QString temp;
|
35 | // QString temp;
|
| 36 | // int lsize;
|
36 | // int lsize;
|
| 37 | treeWidget->setEnabled(false); |
37 | treeWidget->setEnabled(false); |
| 38 | 38 | ||
| 39 | addmemFrm.label_7->setText(inventar_num); |
39 | addmemFrm.label_7->setText(inventar_num); |
| 40 | addmemFrm.treeWidget->clear(); |
40 | addmemFrm.treeWidget->clear(); |
| 41 | addmemFrm.comboBox->clear(); |
41 | addmemFrm.comboBox->clear(); |
| 42 | addmemFrm.comboBox_4->clear(); |
42 | addmemFrm.comboBox_4->clear(); |
| 43 | addmemFrm.comboBox_5->clear(); |
43 | addmemFrm.comboBox_5->clear(); |
| 44 | addmemFrm.comboBox_6->clear(); |
44 | addmemFrm.comboBox_6->clear(); |
| 45 | addmemFrm.comboBox_13->clear();//ïðîèçâîäèòåëè HDD |
45 | addmemFrm.comboBox_13->clear();//ïðîèçâîäèòåëè HDD |
| 46 | addmemFrm.comboBox_9->clear();//ïðîèçâîäèòåëè CPU |
46 | addmemFrm.comboBox_9->clear();//ïðîèçâîäèòåëè CPU |
| 47 | addmemFrm.comboBox_19->clear();//ïðîèçâîäèòåëè VIDEO |
47 | addmemFrm.comboBox_19->clear();//ïðîèçâîäèòåëè VIDEO |
| 48 | addmemFrm.comboBox_20->clear();//ìîäåëè âèäåîêàðò |
48 | addmemFrm.comboBox_20->clear();//ìîäåëè âèäåîêàðò |
| 49 | addmemFrm.lineEdit_2->clear(); |
49 | addmemFrm.lineEdit_2->clear(); |
| 50 | addmemFrm.lineEdit->clear(); |
50 | addmemFrm.lineEdit->clear(); |
| 51 | 51 | ||
| 52 | proizv_list = addmemFrm.getManufacturiesList(); |
52 | proizv_list = addmemFrm.getManufacturiesList(); |
| 53 | mb_proizv_list = addmemFrm.getManufacturiesListMB(); |
53 | mb_proizv_list = addmemFrm.getManufacturiesListMB(); |
| 54 | hdd_proizv_list = addmemFrm.getManufacturiesListHDD(); |
54 | hdd_proizv_list = addmemFrm.getManufacturiesListHDD(); |
| 55 | cpu_proizv_list = addmemFrm.getManufacturiesListCPU(); |
55 | cpu_proizv_list = addmemFrm.getManufacturiesListCPU(); |
| 56 | video_proizv_list = addmemFrm.getManufacturiesListVIDEO(); |
56 | video_proizv_list = addmemFrm.getManufacturiesListVIDEO(); |
| 57 | 57 | ||
| 58 | user_list = addmemFrm.getSystemBlockList(); |
58 | user_list = addmemFrm.getSystemBlockList(); |
| 59 | 59 | ||
| 60 | 60 | ||
| 61 | // lsize = proizv_list.size();
|
61 | // lsize = proizv_list.size();
|
| 62 | //for (int i = 0; i < lsize; ++i){
|
62 | //for (int i = 0; i < lsize; ++i){
|
| 63 | // temp = proizv_list.at(i); }
|
63 | // temp = proizv_list.at(i); }
|
| 64 | addmemFrm.comboBox->addItems(proizv_list); |
64 | addmemFrm.comboBox->addItems(proizv_list); |
| 65 | addmemFrm.comboBox_5->addItems(mb_proizv_list); |
65 | addmemFrm.comboBox_5->addItems(mb_proizv_list); |
| 66 | addmemFrm.comboBox_13->addItems(hdd_proizv_list); |
66 | addmemFrm.comboBox_13->addItems(hdd_proizv_list); |
| 67 | addmemFrm.comboBox_9->addItems(cpu_proizv_list); |
67 | addmemFrm.comboBox_9->addItems(cpu_proizv_list); |
| 68 | addmemFrm.comboBox_19->addItems(video_proizv_list); |
68 | addmemFrm.comboBox_19->addItems(video_proizv_list); |
| 69 | currProizvoditel = addmemFrm.comboBox_5->currentText(); |
69 | currProizvoditel = addmemFrm.comboBox_5->currentText(); |
| 70 | // mb_model_list = addmemFrm.getModelListMB(currProizvoditel);
|
70 | // mb_model_list = addmemFrm.getModelListMB(currProizvoditel);
|
| 71 | // addmemFrm.comboBox_6->addItems(mb_model_list);
|
71 | // addmemFrm.comboBox_6->addItems(mb_model_list);
|
| 72 | addmemFrm.comboBox_4->addItems(user_list); |
72 | addmemFrm.comboBox_4->addItems(user_list); |
| 73 | 73 | ||
| 74 | addmemFrm.show(); |
74 | addmemFrm.show(); |
| 75 | }
|
75 | }
|
| 76 | 76 | ||
| 77 | 77 | ||
| 78 | QString MainWindowImpl::get_info_from_system_block(QString inventar_num){ |
78 | QString MainWindowImpl::get_info_from_system_block(QString inventar_num){ |
| 79 | 79 | ||
| 80 | QSqlQuery query;
|
80 | QSqlQuery query;
|
| 81 | int field_id, field_serial_num, field_inventar_num, field_data_pokypki, field_srok_garantii, field_id_otv_lica; |
81 | int field_id, field_serial_num, field_inventar_num, field_data_pokypki, field_srok_garantii, field_id_otv_lica; |
| 82 | QString sql_query_text, tmp;
|
82 | QString sql_query_text, tmp;
|
| 83 | QString identifikator, serial_num, data_pokypki, srok_garantii, id_otv_lica ;
|
83 | QString identifikator, serial_num, data_pokypki, srok_garantii, id_otv_lica ;
|
| 84 | 84 | ||
| 85 | sql_query_text = tr("select Ñèñòåìíûå_áëîêè.* from Ñèñòåìíûå_áëîêè where Ñèñòåìíûå_áëîêè.Èíâåíòàðíûé_íîìåð = "); |
85 | sql_query_text = tr("select Ñèñòåìíûå_áëîêè.* from Ñèñòåìíûå_áëîêè where Ñèñòåìíûå_áëîêè.Èíâåíòàðíûé_íîìåð = "); |
| 86 | sql_query_text.append(inventar_num); |
86 | sql_query_text.append(inventar_num); |
| 87 | query.prepare(sql_query_text); |
87 | query.prepare(sql_query_text); |
| 88 | query.exec(); |
88 | query.exec(); |
| 89 | 89 | ||
| 90 | field_id = query.record().indexOf(tr("Èäåíòèôèêàòîð")); |
90 | field_id = query.record().indexOf(tr("Èäåíòèôèêàòîð")); |
| 91 | field_serial_num = query.record().indexOf(tr("Ñåðèéíûé_íîìåð")); |
91 | field_serial_num = query.record().indexOf(tr("Ñåðèéíûé_íîìåð")); |
| 92 | field_data_pokypki = query.record().indexOf(tr("Äàòà_ïîêóïêè")); |
92 | field_data_pokypki = query.record().indexOf(tr("Äàòà_ïîêóïêè")); |
| 93 | field_srok_garantii = query.record().indexOf(tr("Ñðîê_ãàðàíòèè")); |
93 | field_srok_garantii = query.record().indexOf(tr("Ñðîê_ãàðàíòèè")); |
| 94 | field_id_otv_lica = query.record().indexOf(tr("Èäåíòèôèêàòîð_îòâåòñòâåííîãî_ëèöà")); |
94 | field_id_otv_lica = query.record().indexOf(tr("Èäåíòèôèêàòîð_îòâåòñòâåííîãî_ëèöà")); |
| 95 | 95 | ||
| 96 | identifikator = query.value(field_id).toString(); |
96 | identifikator = query.value(field_id).toString(); |
| 97 | serial_num = query.value(field_serial_num).toString(); |
97 | serial_num = query.value(field_serial_num).toString(); |
| 98 | data_pokypki = query.value(field_data_pokypki).toString(); |
98 | data_pokypki = query.value(field_data_pokypki).toString(); |
| 99 | srok_garantii = query.value(field_srok_garantii).toString(); |
99 | srok_garantii = query.value(field_srok_garantii).toString(); |
| 100 | id_otv_lica = query.value(field_id_otv_lica).toString(); |
100 | id_otv_lica = query.value(field_id_otv_lica).toString(); |
| 101 | 101 | ||
| 102 | tmp = "Èíâ. íîì: "; |
102 | tmp = "Èíâ. íîì: "; |
| 103 | tmp.append(inventar_num); |
103 | tmp.append(inventar_num); |
| 104 | 104 | ||
| 105 | 105 | ||
| 106 | return tmp; |
106 | return tmp; |
| 107 | }
|
107 | }
|
| 108 | 108 | ||
| 109 | void MainWindowImpl::on_treeWidget_itemSelectionChanged (){ |
109 | void MainWindowImpl::on_treeWidget_itemSelectionChanged (){ |
| 110 | if (fEnable_component_add || fEnable_naznachit_otvetstv) { |
110 | if (fEnable_component_add || fEnable_naznachit_otvetstv) { |
| 111 | delete_all_actions(); |
111 | delete_all_actions(); |
| 112 | return; |
112 | return; |
| 113 | }
|
113 | }
|
| 114 | QTreeWidgetItem *currItm; |
114 | QTreeWidgetItem *currItm; |
| 115 | QString txt;
|
115 | QString txt;
|
| 116 | QString id_otv_lica;
|
116 | QString id_otv_lica;
|
| 117 | int i; |
117 | int i; |
| 118 | i++; |
118 | i++; |
| 119 | currItm = treeWidget-> currentItem (); |
119 | currItm = treeWidget-> currentItem (); |
| 120 | txt = currItm->text(2); |
120 | txt = currItm->text(2); |
| 121 | id_otv_lica = currItm->text(14); |
121 | id_otv_lica = currItm->text(14); |
| 122 | if (txt==tr("Îòäåë")){ |
122 | if (txt==tr("Îòäåë")){ |
| 123 | delete_all_actions(); |
123 | delete_all_actions(); |
| 124 | add_actions_for_otdel(); |
124 | add_actions_for_otdel(); |
| 125 | // treeWidget->removeAction(MB_na_skladAction);
|
125 | // treeWidget->removeAction(MB_na_skladAction);
|
| 126 | // treeWidget->removeAction(addMemoryAction);
|
126 | // treeWidget->removeAction(addMemoryAction);
|
| 127 | // treeWidget->removeAction(novoe_oborydovanieAction);
|
127 | // treeWidget->removeAction(novoe_oborydovanieAction);
|
| 128 | }
|
128 | }
|
| 129 | else if (txt==tr("Ñîòðóäíèê")) { |
129 | else if (txt==tr("Ñîòðóäíèê")) { |
| 130 | delete_all_actions(); |
130 | delete_all_actions(); |
| 131 | add_actions_for_sotrydnik(); |
131 | add_actions_for_sotrydnik(); |
| 132 | // treeWidget->removeAction(addMemoryAction);
|
132 | // treeWidget->removeAction(addMemoryAction);
|
| 133 | // treeWidget->removeAction(MB_na_skladAction);
|
133 | // treeWidget->removeAction(MB_na_skladAction);
|
| 134 | // treeWidget->removeAction(new_sotrydnikAction);
|
134 | // treeWidget->removeAction(new_sotrydnikAction);
|
| 135 | }
|
135 | }
|
| 136 | else if (txt==tr("Ñêëàä")) { |
136 | else if (txt==tr("Ñêëàä")) { |
| 137 | delete_all_actions(); |
137 | delete_all_actions(); |
| 138 | // treeWidget->removeAction(MB_na_skladAction);
|
138 | // treeWidget->removeAction(MB_na_skladAction);
|
| 139 | // treeWidget->removeAction(addMemoryAction);
|
139 | // treeWidget->removeAction(addMemoryAction);
|
| 140 | add_actions_for_sklad(); |
140 | add_actions_for_sklad(); |
| 141 | }
|
141 | }
|
| 142 | else if (txt==tr("Ñèñòåìíûé áëîê") && id_otv_lica != tr("1")){ |
142 | else if (txt==tr("Ñèñòåìíûé áëîê") && id_otv_lica != tr("1")){ |
| 143 | delete_all_actions(); |
143 | delete_all_actions(); |
| 144 | add_actions_for_system_block(); |
144 | add_actions_for_system_block(); |
| 145 | // treeWidget->removeAction(new_sotrydnikAction);
|
145 | // treeWidget->removeAction(new_sotrydnikAction);
|
| 146 | }
|
146 | }
|
| 147 | else if (txt==tr("Ñèñòåìíûé áëîê") && id_otv_lica == tr("1")){ |
147 | else if (txt==tr("Ñèñòåìíûé áëîê") && id_otv_lica == tr("1")){ |
| 148 | delete_all_actions(); |
148 | delete_all_actions(); |
| 149 | add_actions_for_sklad_system_block(); |
149 | add_actions_for_sklad_system_block(); |
| 150 | // treeWidget->removeAction(new_sotrydnikAction);
|
150 | // treeWidget->removeAction(new_sotrydnikAction);
|
| 151 | }
|
151 | }
|
| 152 | else if (txt==tr("ÌÀÒÅÐÈÍÑÊÈÅ ÏËÀÒÛ")){ |
152 | else if (txt==tr("ÌÀÒÅÐÈÍÑÊÈÅ ÏËÀÒÛ")){ |
| 153 | delete_all_actions(); |
153 | delete_all_actions(); |
| 154 | add_actions_for_sklad_MB(); |
154 | add_actions_for_sklad_MB(); |
| 155 | // treeWidget->removeAction(new_sotrydnikAction);
|
155 | // treeWidget->removeAction(new_sotrydnikAction);
|
| 156 | }
|
156 | }
|
| 157 | else if (txt==tr("ÌÎÄÓËÈ ÏÀÌßÒÈ")){ |
157 | else if (txt==tr("ÌÎÄÓËÈ ÏÀÌßÒÈ")){ |
| 158 | delete_all_actions(); |
158 | delete_all_actions(); |
| 159 | add_actions_for_sklad_RAM(); |
159 | add_actions_for_sklad_RAM(); |
| 160 | // treeWidget->removeAction(new_sotrydnikAction);
|
160 | // treeWidget->removeAction(new_sotrydnikAction);
|
| 161 | }
|
161 | }
|
| 162 | 162 | ||
| 163 | else if (txt==tr("ÏÐÎÖÅÑÑÎÐÛ")){ |
163 | else if (txt==tr("ÏÐÎÖÅÑÑÎÐÛ")){ |
| 164 | delete_all_actions(); |
164 | delete_all_actions(); |
| 165 | add_actions_for_sklad_CPU(); |
165 | add_actions_for_sklad_CPU(); |
| 166 | // treeWidget->removeAction(new_sotrydnikAction);
|
166 | // treeWidget->removeAction(new_sotrydnikAction);
|
| 167 | }
|
167 | }
|
| 168 | 168 | ||
| 169 | else if (txt==tr("ÂÈÍ×ÅÑÒÅÐÛ")){ |
169 | else if (txt==tr("ÂÈÍ×ÅÑÒÅÐÛ")){ |
| 170 | delete_all_actions(); |
170 | delete_all_actions(); |
| 171 | add_actions_for_sklad_HDD(); |
171 | add_actions_for_sklad_HDD(); |
| 172 | // treeWidget->removeAction(new_sotrydnikAction);
|
172 | // treeWidget->removeAction(new_sotrydnikAction);
|
| 173 | }
|
173 | }
|
| 174 | 174 | ||
| 175 | else if (txt==tr("ÏÐÈÂÎÄÛ")){ |
175 | else if (txt==tr("ÏÐÈÂÎÄÛ")){ |
| 176 | delete_all_actions(); |
176 | delete_all_actions(); |
| 177 | add_actions_for_sklad_CD_DVD(); |
177 | add_actions_for_sklad_CD_DVD(); |
| 178 | // treeWidget->removeAction(new_sotrydnikAction);
|
178 | // treeWidget->removeAction(new_sotrydnikAction);
|
| 179 | }
|
179 | }
|
| 180 | 180 | ||
| 181 | else if (txt==tr("ÂÈÄÅÎÊÀÐÒÛ")){ |
181 | else if (txt==tr("ÂÈÄÅÎÊÀÐÒÛ")){ |
| 182 | delete_all_actions(); |
182 | delete_all_actions(); |
| 183 | add_actions_for_sklad_VIDEO(); |
183 | add_actions_for_sklad_VIDEO(); |
| 184 | // treeWidget->removeAction(new_sotrydnikAction);
|
184 | // treeWidget->removeAction(new_sotrydnikAction);
|
| 185 | }
|
185 | }
|
| 186 | 186 | ||
| 187 | else if (txt==tr("ÇÂÓÊÎÂÛÅ ÊÀÐÒÛ")){ |
187 | else if (txt==tr("ÇÂÓÊÎÂÛÅ ÊÀÐÒÛ")){ |
| 188 | delete_all_actions(); |
188 | delete_all_actions(); |
| 189 | add_actions_for_sklad_SoundCard(); |
189 | add_actions_for_sklad_SoundCard(); |
| 190 | // treeWidget->removeAction(new_sotrydnikAction);
|
190 | // treeWidget->removeAction(new_sotrydnikAction);
|
| 191 | }
|
191 | }
|
| 192 | 192 | ||
| 193 | else if (txt==tr("ÑÅÒÅÂÛÅ ÊÀÐÒÛ")){ |
193 | else if (txt==tr("ÑÅÒÅÂÛÅ ÊÀÐÒÛ")){ |
| 194 | delete_all_actions(); |
194 | delete_all_actions(); |
| 195 | add_actions_for_sklad_LAN(); |
195 | add_actions_for_sklad_LAN(); |
| 196 | // treeWidget->removeAction(new_sotrydnikAction);
|
196 | // treeWidget->removeAction(new_sotrydnikAction);
|
| 197 | }
|
197 | }
|
| 198 | 198 | ||
| 199 | else if (txt==tr("ÑÈÑÒÅÌÍÛÅ ÁËÎÊÈ")){ |
199 | else if (txt==tr("ÑÈÑÒÅÌÍÛÅ ÁËÎÊÈ")){ |
| 200 | delete_all_actions(); |
200 | delete_all_actions(); |
| 201 | add_actions_for_sklad_SB(); |
201 | add_actions_for_sklad_SB(); |
| 202 | // treeWidget->removeAction(new_sotrydnikAction);
|
202 | // treeWidget->removeAction(new_sotrydnikAction);
|
| 203 | }
|
203 | }
|
| 204 | 204 | ||
| 205 | 205 | ||
| 206 | /* else if (txt==tr("Ìàòåðèíñêàÿ ïëàòà") && id_otv_lica == tr("1")){
|
206 | /* else if (txt==tr("Ìàòåðèíñêàÿ ïëàòà") && id_otv_lica == tr("1")){
|
| 207 | delete_all_actions();
|
207 | delete_all_actions();
|
| 208 | add_actions_for_insert_MB_to_system_block();
|
208 | add_actions_for_insert_MB_to_system_block();
|
| 209 | // treeWidget->removeAction(new_sotrydnikAction);
|
209 | // treeWidget->removeAction(new_sotrydnikAction);
|
| 210 | } */
|
210 | } */
|
| 211 | 211 | ||
| 212 | 212 | ||
| 213 | else if (id_otv_lica != tr("1")){treeWidget->addAction(addMemoryAction); //íå ñêëàä |
213 | else if (id_otv_lica != tr("1")){treeWidget->addAction(addMemoryAction); //íå ñêëàä |
| 214 | delete_all_actions(); |
214 | delete_all_actions(); |
| 215 | add_actions_for_kompletyushie(); |
215 | add_actions_for_kompletyushie(); |
| 216 | // treeWidget->addAction(SpliterAction);
|
216 | // treeWidget->addAction(SpliterAction);
|
| 217 | 217 | ||
| 218 | // SpliterAction->setSeparator (true);
|
218 | // SpliterAction->setSeparator (true);
|
| 219 | // treeWidget->addAction(MB_na_skladAction);
|
219 | // treeWidget->addAction(MB_na_skladAction);
|
| 220 | }
|
220 | }
|
| 221 | 221 | ||
| 222 | else {treeWidget->addAction(addMemoryAction); // ñêëàä |
222 | else {treeWidget->addAction(addMemoryAction); // ñêëàä |
| 223 | delete_all_actions(); |
223 | delete_all_actions(); |
| 224 | add_actions_for_insert_MB_to_system_block();//íàçâàíèå ôóíêöèè íàäî ïîìåíÿòü, ýòî êî âñåì êîìïëåêòóþùèì îòíîñèòñÿ |
224 | add_actions_for_insert_MB_to_system_block();//íàçâàíèå ôóíêöèè íàäî ïîìåíÿòü, ýòî êî âñåì êîìïëåêòóþùèì îòíîñèòñÿ |
| 225 | // treeWidget->addAction(SpliterAction);
|
225 | // treeWidget->addAction(SpliterAction);
|
| 226 | 226 | ||
| 227 | // SpliterAction->setSeparator (true);
|
227 | // SpliterAction->setSeparator (true);
|
| 228 | // treeWidget->addAction(MB_na_skladAction);
|
228 | // treeWidget->addAction(MB_na_skladAction);
|
| 229 | }
|
229 | }
|
| 230 | 230 | ||
| 231 | // if (txt==tr("Ñèñòåìíûé áëîê")) {i++;}
|
231 | // if (txt==tr("Ñèñòåìíûé áëîê")) {i++;}
|
| 232 | }
|
232 | }
|
| 233 | 233 | ||
| 234 | 234 | ||
| 235 | 235 | ||
| 236 | 236 | ||
| 237 | 237 | ||
| 238 | 238 | ||
| 239 | void MainWindowImpl::novoe_oborydovanie(){ |
239 | void MainWindowImpl::novoe_oborydovanie(){ |
| 240 | 240 | ||
| 241 | }
|
241 | }
|
| 242 | 242 | ||
| 243 | 243 | ||
| 244 | void MainWindowImpl::pereimenovft_otdel(){ |
244 | void MainWindowImpl::pereimenovft_otdel(){ |
| 245 | 245 | ||
| 246 | }
|
246 | }
|
| 247 | 247 | ||
| 248 | void MainWindowImpl::yvolit_sotrydnika(){ |
248 | void MainWindowImpl::yvolit_sotrydnika(){ |
| 249 | 249 | ||
| 250 | }
|
250 | }
|
| 251 | 251 | ||
| 252 | void MainWindowImpl::perevesti_sotrydnika_v_drygo1_otdel(){ |
252 | void MainWindowImpl::perevesti_sotrydnika_v_drygo1_otdel(){ |
| 253 | int i; |
253 | int i; |
| 254 | i++; |
254 | i++; |
| 255 | }
|
255 | }
|
| 256 | 256 | ||
| 257 | void MainWindowImpl::naznachit_otvetstvennim_za_oborydovanie(){ |
257 | void MainWindowImpl::naznachit_otvetstvennim_za_oborydovanie(){ |
| 258 | 258 | ||
| 259 | }
|
259 | }
|
| 260 | 260 | ||
| 261 | void MainWindowImpl::ystanovit_novie_complektyushie(){ |
261 | void MainWindowImpl::ystanovit_novie_complektyushie(){ |
| 262 | QString inventar_num;
|
262 | QString inventar_num;
|
| 263 | QTreeWidgetItem * currItem; |
263 | QTreeWidgetItem * currItem; |
| 264 | int currColomn; |
264 | int currColomn; |
| 265 | int top_item_index; |
265 | int top_item_index; |
| 266 | lineEdit->insert(tr("Ðåäàêòèðîâàòü")); |
266 | lineEdit->insert(tr("Ðåäàêòèðîâàòü")); |
| 267 | currItem = treeWidget->currentItem (); |
267 | currItem = treeWidget->currentItem (); |
| 268 | top_item_index = treeWidget->indexOfTopLevelItem(currItem); |
268 | top_item_index = treeWidget->indexOfTopLevelItem(currItem); |
| 269 | currColomn = treeWidget->currentColumn(); |
269 | currColomn = treeWidget->currentColumn(); |
| 270 | MainWindowImpl::on_treeWidget_itemClicked(currItem, 3); //âûâîäèì íîìåð ñèñòåìíèêà íà ôîðìó |
270 | MainWindowImpl::on_treeWidget_itemClicked(currItem, 3); //âûâîäèì íîìåð ñèñòåìíèêà íà ôîðìó |
| 271 | // inventar_num = tr("Èíâ.íîì: ");
|
271 | // inventar_num = tr("Èíâ.íîì: ");
|
| 272 | inventar_num.append(currItem ->text(3)); |
272 | inventar_num.append(currItem ->text(3)); |
| 273 | if (currColomn == 1){ |
273 | if (currColomn == 1){ |
| 274 | addmemFrm.tabWidget->setCurrentIndex(4); |
274 | addmemFrm.tabWidget->setCurrentIndex(4); |
| 275 | addmemFrm.show(); |
275 | addmemFrm.show(); |
| 276 | }; |
276 | }; |
| 277 | if (inventar_num == "") return; |
277 | if (inventar_num == "") return; |
| 278 | lineEdit->insert(currItem ->text(currColomn)); |
278 | lineEdit->insert(currItem ->text(currColomn)); |
| 279 | switch(currColomn) |
279 | switch(currColomn) |
| 280 | {
|
280 | {
|
| 281 | case 1://Ñîòðóäíèêè |
281 | case 1://Ñîòðóäíèêè |
| 282 | {
|
282 | {
|
| 283 | addmemFrm.tabWidget->setCurrentIndex(4); |
283 | addmemFrm.tabWidget->setCurrentIndex(4); |
| 284 | addNewMemory(inventar_num); |
284 | addNewMemory(inventar_num); |
| 285 | 285 | ||
| 286 | }
|
286 | }
|
| 287 | break; |
287 | break; |
| 288 | 288 | ||
| 289 | 289 | ||
| 290 | case 4: //Ïðîöåññîð |
290 | case 4: //Ïðîöåññîð |
| 291 | {
|
291 | {
|
| 292 | addmemFrm.tabWidget->setCurrentIndex(2); |
292 | addmemFrm.tabWidget->setCurrentIndex(2); |
| 293 | addNewMemory(inventar_num); |
293 | addNewMemory(inventar_num); |
| 294 | }
|
294 | }
|
| 295 | break; |
295 | break; |
| 296 | 296 | ||
| 297 | case 5: //Ìàòåðèíñêèå ïëàòû |
297 | case 5: //Ìàòåðèíñêèå ïëàòû |
| 298 | {
|
298 | {
|
| 299 | addmemFrm.tabWidget->setCurrentIndex(3); |
299 | addmemFrm.tabWidget->setCurrentIndex(3); |
| 300 | addNewMemory(inventar_num); |
300 | addNewMemory(inventar_num); |
| 301 | }
|
301 | }
|
| 302 | break; |
302 | break; |
| 303 | 303 | ||
| 304 | case 6: //Ïàìÿòü |
304 | case 6: //Ïàìÿòü |
| 305 | {
|
305 | {
|
| 306 | addmemFrm.tabWidget->setCurrentIndex(0); |
306 | addmemFrm.tabWidget->setCurrentIndex(0); |
| 307 | addNewMemory(inventar_num); |
307 | addNewMemory(inventar_num); |
| 308 | // addmemFrm.show();
|
308 | // addmemFrm.show();
|
| 309 | }
|
309 | }
|
| 310 | break; |
310 | break; |
| 311 | 311 | ||
| 312 | case 7: //Âèí÷åñòåð |
312 | case 7: //Âèí÷åñòåð |
| 313 | {
|
313 | {
|
| 314 | addmemFrm.tabWidget->setCurrentIndex(1); |
314 | addmemFrm.tabWidget->setCurrentIndex(1); |
| 315 | addNewMemory(inventar_num); |
315 | addNewMemory(inventar_num); |
| 316 | }
|
316 | }
|
| 317 | break; |
317 | break; |
| 318 | 318 | ||
| 319 | 319 | ||
| 320 | // case 2: break;
|
320 | // case 2: break;
|
| 321 | default : { |
321 | default : { |
| 322 | addmemFrm.tabWidget->setCurrentIndex(0); |
322 | addmemFrm.tabWidget->setCurrentIndex(0); |
| 323 | addNewMemory(inventar_num); |
323 | addNewMemory(inventar_num); |
| 324 | }
|
324 | }
|
| 325 | 325 | ||
| 326 | break; |
326 | break; |
| 327 | }
|
327 | }
|
| 328 | addmemFrm.treeWidget->clear(); |
328 | addmemFrm.treeWidget->clear(); |
| 329 | 329 | ||
| 330 | 330 | ||
| 331 | 331 | ||
| 332 | 332 | ||
| 333 | 333 | ||
| 334 | addmemFrm.treeWidget->clear(); |
334 | addmemFrm.treeWidget->clear(); |
| 335 | }
|
335 | }
|
| 336 | 336 | ||
| 337 | 337 | ||
| 338 | 338 | ||
| 339 | 339 | ||
| 340 | 340 | ||
| 341 | 341 | ||
| 342 | 342 | ||
| 343 | void MainWindowImpl::on_addmemoryForm_formClose(){ |
343 | void MainWindowImpl::on_addmemoryForm_formClose(){ |
| 344 | treeWidget->setEnabled(true); |
344 | treeWidget->setEnabled(true); |
| 345 | }
|
345 | }
|
| 346 | 346 | ||
| 347 | 347 | ||
| 348 | 348 | ||
| 349 | 349 | ||
| 350 | 350 | ||
| 351 | void MainWindowImpl::insert_MB_to_system_block(){ // óñòàíàâëèâàåì êîìïîíåíòû ñî ñêëàäà |
351 | void MainWindowImpl::insert_MB_to_system_block(){ // óñòàíàâëèâàåì êîìïîíåíòû ñî ñêëàäà |
| 352 | QTreeWidgetItem * currItem; |
352 | QTreeWidgetItem * currItem; |
| 353 | QString tip_komplekt;
|
353 | QString tip_komplekt;
|
| 354 | QString identifikator_kimplekt; // èäåíòèôèêàòîð êîìïëåêòóþùåãî â òàáëèöå |
354 | QString identifikator_kimplekt; // èäåíòèôèêàòîð êîìïëåêòóþùåãî â òàáëèöå |
| 355 | currItem = treeWidget->currentItem (); |
355 | currItem = treeWidget->currentItem (); |
| 356 | tip_komplekt = currItem->text(2); |
356 | tip_komplekt = currItem->text(2); |
| 357 | identifikator_kimplekt = currItem->text(12); |
357 | identifikator_kimplekt = currItem->text(12); |
| 358 | if (tip_komplekt == tr("Ìàòåðèíñêàÿ ïëàòà")){ |
358 | if (tip_komplekt == tr("Ìàòåðèíñêàÿ ïëàòà")){ |
| 359 | component_table = tr("matheboards"); |
359 | component_table = tr("matheboards"); |
| 360 | component_id = identifikator_kimplekt; |
360 | component_id = identifikator_kimplekt; |
| 361 | fEnable_component_add = true; |
361 | fEnable_component_add = true; |
| 362 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
362 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
| 363 | this, // Ðîäèòåëüñêèé âèäæåò. |
363 | this, // Ðîäèòåëüñêèé âèäæåò. |
| 364 | QObject::tr("Óêàæèòå ñèñòåìíûé áëîê "), // Çàãîëîâîê. |
364 | QObject::tr("Óêàæèòå ñèñòåìíûé áëîê "), // Çàãîëîâîê. |
| 365 | // db.lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
365 | // db.lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
| 366 | tr("Òåïåðü âèáåðèòå ñèñòåìíûé áëîê (äâîéíûì êëèêîì ìûøêè), â êîòîðûé õîòèòå óñòàíîâèòü ìàòåðèíñêóþ ïëàòó.")); |
366 | tr("Òåïåðü âèáåðèòå ñèñòåìíûé áëîê (äâîéíûì êëèêîì ìûøêè), â êîòîðûé õîòèòå óñòàíîâèòü ìàòåðèíñêóþ ïëàòó.")); |
| 367 | 367 | ||
| 368 | }
|
368 | }
|
| 369 | else if (tip_komplekt == tr("Ìîäóëü ïàìÿòè")){ |
369 | else if (tip_komplekt == tr("Ìîäóëü ïàìÿòè")){ |
| 370 | component_table = tr("memory"); |
370 | component_table = tr("memory"); |
| 371 | component_id = identifikator_kimplekt; |
371 | component_id = identifikator_kimplekt; |
| 372 | fEnable_component_add = true; |
372 | fEnable_component_add = true; |
| 373 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
373 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
| 374 | this, // Ðîäèòåëüñêèé âèäæåò. |
374 | this, // Ðîäèòåëüñêèé âèäæåò. |
| 375 | QObject::tr("Óêàæèòå ñèñòåìíûé áëîê "), // Çàãîëîâîê. |
375 | QObject::tr("Óêàæèòå ñèñòåìíûé áëîê "), // Çàãîëîâîê. |
| 376 | // db.lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
376 | // db.lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
| 377 | tr("Òåïåðü âèáåðèòå ñèñòåìíûé áëîê (äâîéíûì êëèêîì ìûøêè), â êîòîðûé òðåáóåòñÿ óñòàíîâèòü ìîäóëü ïàìÿòè.")); |
377 | tr("Òåïåðü âèáåðèòå ñèñòåìíûé áëîê (äâîéíûì êëèêîì ìûøêè), â êîòîðûé òðåáóåòñÿ óñòàíîâèòü ìîäóëü ïàìÿòè.")); |
| 378 | }
|
378 | }
|
| 379 | 379 | ||
| 380 | else if (tip_komplekt == tr("Ïðîöåññîð")){ |
380 | else if (tip_komplekt == tr("Ïðîöåññîð")){ |
| 381 | component_table = tr("processors"); |
381 | component_table = tr("processors"); |
| 382 | component_id = identifikator_kimplekt; |
382 | component_id = identifikator_kimplekt; |
| 383 | fEnable_component_add = true; |
383 | fEnable_component_add = true; |
| 384 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
384 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
| 385 | this, // Ðîäèòåëüñêèé âèäæåò. |
385 | this, // Ðîäèòåëüñêèé âèäæåò. |
| 386 | QObject::tr("Óêàæèòå ñèñòåìíûé áëîê "), // Çàãîëîâîê. |
386 | QObject::tr("Óêàæèòå ñèñòåìíûé áëîê "), // Çàãîëîâîê. |
| 387 | // db.lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
387 | // db.lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
| 388 | tr("Òåïåðü âèáåðèòå ñèñòåìíûé áëîê (äâîéíûì êëèêîì ìûøêè), â êîòîðûé òðåáóåòñÿ óñòàíîâèòü ïðîöåññîð.")); |
388 | tr("Òåïåðü âèáåðèòå ñèñòåìíûé áëîê (äâîéíûì êëèêîì ìûøêè), â êîòîðûé òðåáóåòñÿ óñòàíîâèòü ïðîöåññîð.")); |
| 389 | }
|
389 | }
|
| 390 | 390 | ||
| 391 | else if (tip_komplekt == tr("Âèäåîêàðòà")){ |
391 | else if (tip_komplekt == tr("Âèäåîêàðòà")){ |
| 392 | component_table = tr("videocards"); |
392 | component_table = tr("videocards"); |
| 393 | component_id = identifikator_kimplekt; |
393 | component_id = identifikator_kimplekt; |
| 394 | fEnable_component_add = true; |
394 | fEnable_component_add = true; |
| 395 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
395 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
| 396 | this, // Ðîäèòåëüñêèé âèäæåò. |
396 | this, // Ðîäèòåëüñêèé âèäæåò. |
| 397 | QObject::tr("Óêàæèòå ñèñòåìíûé áëîê "), // Çàãîëîâîê. |
397 | QObject::tr("Óêàæèòå ñèñòåìíûé áëîê "), // Çàãîëîâîê. |
| 398 | // db.lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
398 | // db.lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
| 399 | tr("Òåïåðü âèáåðèòå ñèñòåìíûé áëîê (äâîéíûì êëèêîì ìûøêè), â êîòîðûé òðåáóåòñÿ óñòàíîâèòü âèäåîêàðòó.")); |
399 | tr("Òåïåðü âèáåðèòå ñèñòåìíûé áëîê (äâîéíûì êëèêîì ìûøêè), â êîòîðûé òðåáóåòñÿ óñòàíîâèòü âèäåîêàðòó.")); |
| 400 | }
|
400 | }
|
| 401 | 401 | ||
| 402 | else if (tip_komplekt == tr("Ïðèâîä")){ |
402 | else if (tip_komplekt == tr("Ïðèâîä")){ |
| 403 | component_table = tr("cd_dvd"); |
403 | component_table = tr("cd_dvd"); |
| 404 | component_id = identifikator_kimplekt; |
404 | component_id = identifikator_kimplekt; |
| 405 | fEnable_component_add = true; |
405 | fEnable_component_add = true; |
| 406 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
406 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
| 407 | this, // Ðîäèòåëüñêèé âèäæåò. |
407 | this, // Ðîäèòåëüñêèé âèäæåò. |
| 408 | QObject::tr("Óêàæèòå ñèñòåìíûé áëîê "), // Çàãîëîâîê. |
408 | QObject::tr("Óêàæèòå ñèñòåìíûé áëîê "), // Çàãîëîâîê. |
| 409 | // db.lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
409 | // db.lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
| 410 | tr("Òåïåðü âèáåðèòå ñèñòåìíûé áëîê (äâîéíûì êëèêîì ìûøêè), â êîòîðûé òðåáóåòñÿ óñòàíîâèòü ïðèâîä.")); |
410 | tr("Òåïåðü âèáåðèòå ñèñòåìíûé áëîê (äâîéíûì êëèêîì ìûøêè), â êîòîðûé òðåáóåòñÿ óñòàíîâèòü ïðèâîä.")); |
| 411 | }
|
411 | }
|
| 412 | 412 | ||
| 413 | else if (tip_komplekt == tr("Çâóêîâàÿ êàðòà")){ |
413 | else if (tip_komplekt == tr("Çâóêîâàÿ êàðòà")){ |
| 414 | component_table = tr("soundcards"); |
414 | component_table = tr("soundcards"); |
| 415 | component_id = identifikator_kimplekt; |
415 | component_id = identifikator_kimplekt; |
| 416 | fEnable_component_add = true; |
416 | fEnable_component_add = true; |
| 417 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
417 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
| 418 | this, // Ðîäèòåëüñêèé âèäæåò. |
418 | this, // Ðîäèòåëüñêèé âèäæåò. |
| 419 | QObject::tr("Óêàæèòå ñèñòåìíûé áëîê "), // Çàãîëîâîê. |
419 | QObject::tr("Óêàæèòå ñèñòåìíûé áëîê "), // Çàãîëîâîê. |
| 420 | // db.lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
420 | // db.lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
| 421 | tr("Òåïåðü âèáåðèòå ñèñòåìíûé áëîê (äâîéíûì êëèêîì ìûøêè), â êîòîðûé òðåáóåòñÿ óñòàíîâèòü çâóêîâóþ êàðòó.")); |
421 | tr("Òåïåðü âèáåðèòå ñèñòåìíûé áëîê (äâîéíûì êëèêîì ìûøêè), â êîòîðûé òðåáóåòñÿ óñòàíîâèòü çâóêîâóþ êàðòó.")); |
| 422 | }
|
422 | }
|
| 423 | 423 | ||
| 424 | else if (tip_komplekt == tr("Ñåòåâàÿ êàðòà")){ |
424 | else if (tip_komplekt == tr("Ñåòåâàÿ êàðòà")){ |
| 425 | component_table = tr("lancards"); |
425 | component_table = tr("lancards"); |
| 426 | component_id = identifikator_kimplekt; |
426 | component_id = identifikator_kimplekt; |
| 427 | fEnable_component_add = true; |
427 | fEnable_component_add = true; |
| 428 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
428 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
| 429 | this, // Ðîäèòåëüñêèé âèäæåò. |
429 | this, // Ðîäèòåëüñêèé âèäæåò. |
| 430 | QObject::tr("Óêàæèòå ñèñòåìíûé áëîê "), // Çàãîëîâîê. |
430 | QObject::tr("Óêàæèòå ñèñòåìíûé áëîê "), // Çàãîëîâîê. |
| 431 | // db.lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
431 | // db.lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
| 432 | tr("Òåïåðü âèáåðèòå ñèñòåìíûé áëîê (äâîéíûì êëèêîì ìûøêè), â êîòîðûé òðåáóåòñÿ óñòàíîâèòü ñåòåâóþ êàðòó.")); |
432 | tr("Òåïåðü âèáåðèòå ñèñòåìíûé áëîê (äâîéíûì êëèêîì ìûøêè), â êîòîðûé òðåáóåòñÿ óñòàíîâèòü ñåòåâóþ êàðòó.")); |
| 433 | }
|
433 | }
|
| 434 | 434 | ||
| 435 | else if (tip_komplekt == tr("Æåñòêèé äèñê")){ |
435 | else if (tip_komplekt == tr("Æåñòêèé äèñê")){ |
| 436 | component_table = tr("harddiscs"); |
436 | component_table = tr("harddiscs"); |
| 437 | component_id = identifikator_kimplekt; |
437 | component_id = identifikator_kimplekt; |
| 438 | fEnable_component_add = true; |
438 | fEnable_component_add = true; |
| 439 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
439 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
| 440 | this, // Ðîäèòåëüñêèé âèäæåò. |
440 | this, // Ðîäèòåëüñêèé âèäæåò. |
| 441 | QObject::tr("Óêàæèòå ñèñòåìíûé áëîê "), // Çàãîëîâîê. |
441 | QObject::tr("Óêàæèòå ñèñòåìíûé áëîê "), // Çàãîëîâîê. |
| 442 | // db.lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
442 | // db.lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
| 443 | tr("Òåïåðü âèáåðèòå ñèñòåìíûé áëîê (äâîéíûì êëèêîì ìûøêè), â êîòîðûé òðåáóåòñÿ óñòàíîâèòü æåñòêèé äèñê.")); |
443 | tr("Òåïåðü âèáåðèòå ñèñòåìíûé áëîê (äâîéíûì êëèêîì ìûøêè), â êîòîðûé òðåáóåòñÿ óñòàíîâèòü æåñòêèé äèñê.")); |
| 444 | }
|
444 | }
|
| 445 | 445 | ||
| 446 | // select an_db.Îòäåëû.Íàçâàíèå, an_db.Ñîòðóäíèêè.ÔÈÎ, an_db.Ñèñòåìíûå_áëîêè.Èíâåíòàðíûé_íîìåð from an_db.Îòäåëû , an_db.Ñîòðóäíèêè, an_db.Ñèñòåìíûå_áëîêè where an_db.Îòäåëû.Èäåíòèôèêàòîð = an_db.Ñîòðóäíèêè.Èäåíòèôèêàòîð_îòäåëà and an_db.Ñîòðóäíèêè.Èäåíòèôèêàòîð = an_db.Ñèñòåìíûå_áëîêè.Èäåíòèôèêàòîð_îòâåòñòâåííîãî_ëèöà;
|
446 | // select an_db.Îòäåëû.Íàçâàíèå, an_db.Ñîòðóäíèêè.ÔÈÎ, an_db.Ñèñòåìíûå_áëîêè.Èíâåíòàðíûé_íîìåð from an_db.Îòäåëû , an_db.Ñîòðóäíèêè, an_db.Ñèñòåìíûå_áëîêè where an_db.Îòäåëû.Èäåíòèôèêàòîð = an_db.Ñîòðóäíèêè.Èäåíòèôèêàòîð_îòäåëà and an_db.Ñîòðóäíèêè.Èäåíòèôèêàòîð = an_db.Ñèñòåìíûå_áëîêè.Èäåíòèôèêàòîð_îòâåòñòâåííîãî_ëèöà;
|
| 447 | // select an_db.Îòäåëû.Íàçâàíèå, an_db.Ñîòðóäíèêè.ÔÈÎ, an_db.Ñèñòåìíûå_áëîêè.Èíâåíòàðíûé_íîìåð, an_db.Ñèñòåìíûå_áëîêè.Èäåíòèôèêàòîð from an_db.Îòäåëû , an_db.Ñîòðóäíèêè, an_db.Ñèñòåìíûå_áëîêè where an_db.Îòäåëû.Èäåíòèôèêàòîð = an_db.Ñîòðóäíèêè.Èäåíòèôèêàòîð_îòäåëà and an_db.Ñîòðóäíèêè.Èäåíòèôèêàòîð = an_db.Ñèñòåìíûå_áëîêè.Èäåíòèôèêàòîð_îòâåòñòâåííîãî_ëèöà and an_db.Ñèñòåìíûå_áëîêè.Èäåíòèôèêàòîð != 1 and an_db.Îòäåëû.Íàçâàíèå = "ÑÀÏÐ";
|
447 | // select an_db.Îòäåëû.Íàçâàíèå, an_db.Ñîòðóäíèêè.ÔÈÎ, an_db.Ñèñòåìíûå_áëîêè.Èíâåíòàðíûé_íîìåð, an_db.Ñèñòåìíûå_áëîêè.Èäåíòèôèêàòîð from an_db.Îòäåëû , an_db.Ñîòðóäíèêè, an_db.Ñèñòåìíûå_áëîêè where an_db.Îòäåëû.Èäåíòèôèêàòîð = an_db.Ñîòðóäíèêè.Èäåíòèôèêàòîð_îòäåëà and an_db.Ñîòðóäíèêè.Èäåíòèôèêàòîð = an_db.Ñèñòåìíûå_áëîêè.Èäåíòèôèêàòîð_îòâåòñòâåííîãî_ëèöà and an_db.Ñèñòåìíûå_áëîêè.Èäåíòèôèêàòîð != 1 and an_db.Îòäåëû.Íàçâàíèå = "ÑÀÏÐ";
|
| 448 | 448 | ||
| 449 | 449 | ||
| 450 | int i; |
450 | int i; |
| 451 | i++; |
451 | i++; |
| 452 | 452 | ||
| 453 | 453 | ||
| 454 | }
|
454 | }
|
| 455 | 455 | ||
| 456 | void MainWindowImpl::dblClick(QTreeWidgetItem *item, int column) |
456 | void MainWindowImpl::dblClick(QTreeWidgetItem *item, int column) |
| 457 | {
|
457 | {
|
| 458 | lineEdit->insert(item->text(column)); |
458 | lineEdit->insert(item->text(column)); |
| 459 | 459 | ||
| 460 | 460 | ||
| 461 | }
|
461 | }
|
| 462 | 462 | ||
| 463 | void MainWindowImpl::move_to_sklad(){ |
463 | void MainWindowImpl::move_to_sklad(){ |
| 464 | QString SqlText;
|
464 | QString SqlText;
|
| 465 | QString currID;
|
465 | QString currID;
|
| 466 | QString typeOdorydovaniya;
|
466 | QString typeOdorydovaniya;
|
| 467 | QString tableName;
|
467 | QString tableName;
|
| 468 | QTreeWidgetItem * currItem; |
468 | QTreeWidgetItem * currItem; |
| 469 | QString TipOborydovaniya;
|
469 | QString TipOborydovaniya;
|
| 470 | QSqlQuery UpdateSqlQuery;
|
470 | QSqlQuery UpdateSqlQuery;
|
| 471 | currItem = treeWidget->currentItem (); |
471 | currItem = treeWidget->currentItem (); |
| 472 | currID = currItem->text(12); |
472 | currID = currItem->text(12); |
| 473 | typeOdorydovaniya = currItem->text(2); |
473 | typeOdorydovaniya = currItem->text(2); |
| 474 | 474 | ||
| 475 | // tableName =
|
475 | // tableName =
|
| 476 | if (typeOdorydovaniya == tr("Ìîäóëü ïàìÿòè")){ |
476 | if (typeOdorydovaniya == tr("Ìîäóëü ïàìÿòè")){ |
| 477 | tableName = tr("memory"); |
477 | tableName = tr("memory"); |
| 478 | }
|
478 | }
|
| 479 | else if (typeOdorydovaniya == tr("Ìàòåðèíñêàÿ ïëàòà")){ |
479 | else if (typeOdorydovaniya == tr("Ìàòåðèíñêàÿ ïëàòà")){ |
| 480 | tableName = tr("matheboards"); |
480 | tableName = tr("matheboards"); |
| 481 | }
|
481 | }
|
| 482 | else if (typeOdorydovaniya == tr("Ïðîöåññîð")){ |
482 | else if (typeOdorydovaniya == tr("Ïðîöåññîð")){ |
| 483 | tableName = tr("processors"); |
483 | tableName = tr("processors"); |
| 484 | }
|
484 | }
|
| 485 | else if (typeOdorydovaniya == tr("Âèäåîêàðòà")){ |
485 | else if (typeOdorydovaniya == tr("Âèäåîêàðòà")){ |
| 486 | tableName = tr("videocards"); |
486 | tableName = tr("videocards"); |
| 487 | }
|
487 | }
|
| 488 | else if (typeOdorydovaniya == tr("Ïðèâîä")){ |
488 | else if (typeOdorydovaniya == tr("Ïðèâîä")){ |
| 489 | tableName = tr("cd_dvd"); |
489 | tableName = tr("cd_dvd"); |
| 490 | }
|
490 | }
|
| 491 | else if (typeOdorydovaniya == tr("Çâóêîâàÿ êàðòà")){ |
491 | else if (typeOdorydovaniya == tr("Çâóêîâàÿ êàðòà")){ |
| 492 | tableName = tr("soundcards"); |
492 | tableName = tr("soundcards"); |
| 493 | }
|
493 | }
|
| 494 | else if (typeOdorydovaniya == tr("Æåñòêèé äèñê")){ |
494 | else if (typeOdorydovaniya == tr("Æåñòêèé äèñê")){ |
| 495 | tableName = tr("harddiscs"); |
495 | tableName = tr("harddiscs"); |
| 496 | }
|
496 | }
|
| 497 | else if (typeOdorydovaniya == tr("Ñåòåâàÿ êàðòà")){ |
497 | else if (typeOdorydovaniya == tr("Ñåòåâàÿ êàðòà")){ |
| 498 | tableName = tr("lancards"); |
498 | tableName = tr("lancards"); |
| 499 | }
|
499 | }
|
| 500 | 500 | ||
| 501 | else return; |
501 | else return; |
| 502 | SqlText = tr("update "); |
502 | SqlText = tr("update "); |
| 503 | SqlText.append(tableName); |
503 | SqlText.append(tableName); |
| 504 | SqlText.append(tr(" set Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà = 1 where Èäåíòèôèêàòîð = ")); |
504 | SqlText.append(tr(" set Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà = 1 where Èäåíòèôèêàòîð = ")); |
| 505 | SqlText.append(currID); |
505 | SqlText.append(currID); |
| 506 | UpdateSqlQuery.prepare(SqlText); |
506 | UpdateSqlQuery.prepare(SqlText); |
| 507 | UpdateSqlQuery.exec(); |
507 | UpdateSqlQuery.exec(); |
| 508 | initTreeWidget(); |
508 | initTreeWidget(); |
| 509 | }
|
509 | }
|
| 510 | 510 | ||
| 511 | 511 | ||
| 512 | 512 | ||
| 513 | void MainWindowImpl::on_treeWidget_itemActivated(QTreeWidgetItem *item, int column)// ñîáûòèå íàñòóïàåò ïðè äâîéíîì êëèêå ìûøêè |
513 | void MainWindowImpl::on_treeWidget_itemActivated(QTreeWidgetItem *item, int column)// ñîáûòèå íàñòóïàåò ïðè äâîéíîì êëèêå ìûøêè |
| 514 | {
|
514 | {
|
| 515 | if (fEnable_naznachit_otvetstv) { |
515 | if (fEnable_naznachit_otvetstv) { |
| 516 | QString SqlText;
|
516 | QString SqlText;
|
| 517 | QSqlQuery UpdateSqlQuery;
|
517 | QSqlQuery UpdateSqlQuery;
|
| 518 | QString id_sotrydnika;
|
518 | QString id_sotrydnika;
|
| 519 | if (item ->text(2) == tr("Ñîòðóäíèê")) { |
519 | if (item ->text(2) == tr("Ñîòðóäíèê")) { |
| 520 | id_sotrydnika = item ->text(14); |
520 | id_sotrydnika = item ->text(14); |
| 521 | SqlText = tr("update system_blocks set Èäåíòèôèêàòîð_îòâåòñòâåííîãî_ëèöà = "); |
521 | SqlText = tr("update system_blocks set Èäåíòèôèêàòîð_îòâåòñòâåííîãî_ëèöà = "); |
| 522 | SqlText.append(id_sotrydnika); |
522 | SqlText.append(id_sotrydnika); |
| 523 | SqlText.append(tr(" where system_blocks.Èäåíòèôèêàòîð = ")); |
523 | SqlText.append(tr(" where system_blocks.Èäåíòèôèêàòîð = ")); |
| 524 | SqlText.append(tr(curr_sys_block_id)); |
524 | SqlText.append(tr(curr_sys_block_id)); |
| 525 | UpdateSqlQuery.prepare(SqlText); |
525 | UpdateSqlQuery.prepare(SqlText); |
| 526 | UpdateSqlQuery.exec(); |
526 | UpdateSqlQuery.exec(); |
| 527 | initTreeWidget(); |
527 | initTreeWidget(); |
| 528 | fEnable_naznachit_otvetstv = false; |
528 | fEnable_naznachit_otvetstv = false; |
| 529 | 529 | ||
| 530 | }
|
530 | }
|
| 531 | }
|
531 | }
|
| 532 | 532 | ||
| 533 | else if (!fEnable_component_add) lineEdit->insert(item->text(column)); |
533 | else if (!fEnable_component_add) lineEdit->insert(item->text(column)); |
| 534 | else { |
534 | else { |
| 535 | QString SqlText;
|
535 | QString SqlText;
|
| 536 | QSqlQuery UpdateSqlQuery;
|
536 | QSqlQuery UpdateSqlQuery;
|
| 537 | QString id_sys_block;
|
537 | QString id_sys_block;
|
| 538 | // QTreeWidgetItem * currItem;
|
538 | // QTreeWidgetItem * currItem;
|
| 539 | // currItem = treeWidget->currentItem ();
|
539 | // currItem = treeWidget->currentItem ();
|
| 540 | if (item ->text(2) == tr("Ñèñòåìíûé áëîê")) { |
540 | if (item ->text(2) == tr("Ñèñòåìíûé áëîê")) { |
| 541 | id_sys_block = item ->text(12); |
541 | id_sys_block = item ->text(12); |
| 542 | SqlText = tr("update "); |
542 | SqlText = tr("update "); |
| 543 | SqlText.append(component_table); |
543 | SqlText.append(component_table); |
| 544 | SqlText.append(tr(" set Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà = ")); |
544 | SqlText.append(tr(" set Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà = ")); |
| 545 | SqlText.append(id_sys_block); |
545 | SqlText.append(id_sys_block); |
| 546 | SqlText.append(tr(" where Èäåíòèôèêàòîð = ")); |
546 | SqlText.append(tr(" where Èäåíòèôèêàòîð = ")); |
| 547 | SqlText.append(tr(component_id)); |
547 | SqlText.append(tr(component_id)); |
| 548 | UpdateSqlQuery.prepare(SqlText); |
548 | UpdateSqlQuery.prepare(SqlText); |
| 549 | UpdateSqlQuery.exec(); |
549 | UpdateSqlQuery.exec(); |
| 550 | initTreeWidget(); |
550 | initTreeWidget(); |
| 551 | fEnable_component_add = false; |
551 | fEnable_component_add = false; |
| 552 | }
|
552 | }
|
| 553 | 553 | ||
| 554 | else return; |
554 | else return; |
| 555 | 555 | ||
| 556 | 556 | ||
| 557 | }
|
557 | }
|
| 558 | 558 | ||
| 559 | }
|
559 | }
|
| 560 | 560 | ||
| 561 | void addmemoryForm::on_comboBox_5_currentIndexChanged (QString newText){ |
561 | void addmemoryForm::on_comboBox_5_currentIndexChanged (QString newText){ |
| 562 | QStringList mb_model_list;
|
562 | QStringList mb_model_list;
|
| 563 | comboBox_6->clear(); |
563 | comboBox_6->clear(); |
| 564 | mb_model_list = getModelListMB(newText); |
564 | mb_model_list = getModelListMB(newText); |
| 565 | comboBox_6->addItems(mb_model_list); |
565 | comboBox_6->addItems(mb_model_list); |
| 566 | 566 | ||
| 567 | // int i;
|
567 | // int i;
|
| 568 | // i++;
|
568 | // i++;
|
| 569 | // i++;
|
569 | // i++;
|
| 570 | }
|
570 | }
|
| 571 | 571 | ||
| 572 | void addmemoryForm::on_comboBox_19_currentIndexChanged (QString newText){ |
572 | void addmemoryForm::on_comboBox_19_currentIndexChanged (QString newText){ |
| 573 | QStringList video_model_list;
|
573 | QStringList video_model_list;
|
| 574 | comboBox_20->clear(); |
574 | comboBox_20->clear(); |
| 575 | video_model_list = getModelListVIDEO(newText); |
575 | video_model_list = getModelListVIDEO(newText); |
| 576 | comboBox_20->addItems(video_model_list); |
576 | comboBox_20->addItems(video_model_list); |
| 577 | 577 | ||
| 578 | // int i;
|
578 | // int i;
|
| 579 | // i++;
|
579 | // i++;
|
| 580 | // i++;
|
580 | // i++;
|
| 581 | }
|
581 | }
|
| 582 | 582 | ||
| 583 | 583 | ||
| 584 | void addmemoryForm::on_comboBox_9_currentIndexChanged (QString newText){ |
584 | void addmemoryForm::on_comboBox_9_currentIndexChanged (QString newText){ |
| 585 | QStringList mb_model_list;
|
585 | QStringList mb_model_list;
|
| 586 | comboBox_12->clear(); |
586 | comboBox_12->clear(); |
| 587 | mb_model_list = getModelListCPU(newText); |
587 | mb_model_list = getModelListCPU(newText); |
| 588 | comboBox_12->addItems(mb_model_list); |
588 | comboBox_12->addItems(mb_model_list); |
| 589 | 589 | ||
| 590 | // int i;
|
590 | // int i;
|
| 591 | // i++;
|
591 | // i++;
|
| 592 | // i++;
|
592 | // i++;
|
| 593 | }
|
593 | }
|
| 594 | 594 | ||
| 595 | void MainWindowImpl::on_createButton_clicked(){ |
595 | void MainWindowImpl::on_createButton_clicked(){ |
| 596 | // int i;
|
596 | // int i;
|
| 597 | // i++;
|
597 | // i++;
|
| 598 | // i++;
|
598 | // i++;
|
| 599 | bool ok; |
599 | bool ok; |
| 600 | QSqlQuery q;
|
600 | QSqlQuery q;
|
| 601 | //q.prepare(tr("set NAMES cp1251"));
|
601 | //q.prepare(tr("set NAMES cp1251"));
|
| 602 | //ok = q.exec();
|
602 | //ok = q.exec();
|
| 603 | // q.clear();
|
603 | // q.clear();
|
| 604 | 604 | ||
| 605 | //Ñîçäàåì òàáëèöó îòäåëîâ
|
605 | //Ñîçäàåì òàáëèöó îòäåëîâ
|
| 606 | 606 | ||
| 607 | 607 | ||
| 608 | q.prepare(tr("CREATE TABLE an_db.otdeli ( Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, " |
608 | q.prepare(tr("CREATE TABLE otdeli ( Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, " |
| 609 | "Íàçâàíèå CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå çàäàíî\", "
|
609 | "Íàçâàíèå CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå çàäàíî\", "
|
| 610 | "Ñïðàâêà CHAR(255) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåò\", "
|
610 | "Ñïðàâêà CHAR(255) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåò\", "
|
| 611 | "PRIMARY KEY ( Èäåíòèôèêàòîð )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
611 | "PRIMARY KEY ( Èäåíòèôèêàòîð )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
| 612 | 612 | ||
| 613 | ok = q.exec(); |
613 | ok = q.exec(); |
| 614 | 614 | ||
| 615 | 615 | ||
| 616 | //Ñîçäàåì òàáëèöó ñîòðóäíèêîâ
|
616 | //Ñîçäàåì òàáëèöó ñîòðóäíèêîâ
|
| 617 | 617 | ||
| 618 | q.clear(); |
618 | q.clear(); |
| 619 | 619 | ||
| 620 | q.prepare(tr("CREATE TABLE an_db.sotrydniki ( Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, " |
620 | q.prepare(tr("CREATE TABLE sotrydniki ( Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, " |
| 621 | "ÔÈÎ CHAR(80) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå çàäàíî\", "
|
621 | "ÔÈÎ CHAR(80) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå çàäàíî\", "
|
| 622 | "Èäåíòèôèêàòîð_îòäåëà INTEGER UNSIGNED, "
|
622 | "Èäåíòèôèêàòîð_îòäåëà INTEGER UNSIGNED, "
|
| 623 | "PRIMARY KEY ( Èäåíòèôèêàòîð )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
623 | "PRIMARY KEY ( Èäåíòèôèêàòîð )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
| 624 | 624 | ||
| 625 | ok = q.exec(); |
625 | ok = q.exec(); |
| 626 | 626 | ||
| 627 | q.clear(); |
627 | q.clear(); |
| 628 | 628 | ||
| 629 | //Ñîçäàåì òàáëèöó ñèñòåìíûõ áëîêîâ
|
629 | //Ñîçäàåì òàáëèöó ñèñòåìíûõ áëîêîâ
|
| 630 | 630 | ||
| 631 | q.prepare(tr("CREATE TABLE an_db.system_blocks ( Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, " |
631 | q.prepare(tr("CREATE TABLE system_blocks ( Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, " |
| 632 | "Ñåðèéíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
632 | "Ñåðèéíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
| 633 | "Èíâåíòàðíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå çàäàí\", "
|
633 | "Èíâåíòàðíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå çàäàí\", "
|
| 634 | "Äàòà_ïîêóïêè DATE, "
|
634 | "Äàòà_ïîêóïêè DATE, "
|
| 635 | "Ñðîê_ãàðàíòèè INTEGER UNSIGNED NOT NULL DEFAULT 0, "
|
635 | "Ñðîê_ãàðàíòèè INTEGER UNSIGNED NOT NULL DEFAULT 0, "
|
| 636 | "Èäåíòèôèêàòîð_îòâåòñòâåííîãî_ëèöà INTEGER UNSIGNED DEFAULT 1, "
|
636 | "Èäåíòèôèêàòîð_îòâåòñòâåííîãî_ëèöà INTEGER UNSIGNED DEFAULT 1, "
|
| 637 | "PRIMARY KEY ( Èäåíòèôèêàòîð )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
637 | "PRIMARY KEY ( Èäåíòèôèêàòîð )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
| 638 | 638 | ||
| 639 | ok = q.exec(); |
639 | ok = q.exec(); |
| 640 | 640 | ||
| 641 | q.clear(); |
641 | q.clear(); |
| 642 | 642 | ||
| 643 | //Ñîçäàåì òàáëèöó ìàòåðèíñêèõ ïëàò
|
643 | //Ñîçäàåì òàáëèöó ìàòåðèíñêèõ ïëàò
|
| 644 | 644 | ||
| 645 | q.prepare(tr("CREATE TABLE an_db.matheboards ( Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, " |
645 | q.prepare(tr("CREATE TABLE matheboards ( Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, " |
| 646 | "Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
646 | "Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
| 647 | "Ìîäåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå èçâåñòíà\", "
|
647 | "Ìîäåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå èçâåñòíà\", "
|
| 648 | "Ñëîò CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòíî\", "
|
648 | "Ñëîò CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòíî\", "
|
| 649 | "×àñòîòà_øèíû INTEGER UNSIGNED DEFAULT 100, "
|
649 | "×àñòîòà_øèíû INTEGER UNSIGNED DEFAULT 100, "
|
| 650 | "Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà INTEGER UNSIGNED DEFAULT 1, "
|
650 | "Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà INTEGER UNSIGNED DEFAULT 1, "
|
| 651 | "Èíâåíòàðíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå çàäàí\", "
|
651 | "Èíâåíòàðíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå çàäàí\", "
|
| 652 | "Ñåðèéíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
652 | "Ñåðèéíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
| 653 | "PRIMARY KEY ( Èäåíòèôèêàòîð )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
653 | "PRIMARY KEY ( Èäåíòèôèêàòîð )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
| 654 | 654 | ||
| 655 | ok = q.exec(); |
655 | ok = q.exec(); |
| 656 | 656 | ||
| 657 | q.clear(); |
657 | q.clear(); |
| 658 | 658 | ||
| 659 | //Ñîçäàåì òàáëèöó ìîäóëåé ïàìÿòè
|
659 | //Ñîçäàåì òàáëèöó ìîäóëåé ïàìÿòè
|
| 660 | 660 | ||
| 661 | ok = q.prepare(tr("CREATE TABLE an_db.memory ( Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, " |
661 | ok = q.prepare(tr("CREATE TABLE memory ( Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, " |
| 662 | "Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
662 | "Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
| 663 | "Ìîäåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå èçâåñòíà\", "
|
663 | "Ìîäåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå èçâåñòíà\", "
|
| 664 | "Òèï ENUM(\"DIM\",\"DDR\",\"DDRII\",\"RIMM\",\"SIMM\") DEFAULT \"DDRII\", "
|
664 | "Òèï ENUM(\"DIM\",\"DDR\",\"DDRII\",\"RIMM\",\"SIMM\") DEFAULT \"DDRII\", "
|
| 665 | "Îáúåì INTEGER UNSIGNED, "
|
665 | "Îáúåì INTEGER UNSIGNED, "
|
| 666 | "×àñòîòà_øèíû INTEGER UNSIGNED, "
|
666 | "×àñòîòà_øèíû INTEGER UNSIGNED, "
|
| 667 | "Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà INTEGER UNSIGNED DEFAULT 1, "
|
667 | "Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà INTEGER UNSIGNED DEFAULT 1, "
|
| 668 | "Ñåðèéíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
668 | "Ñåðèéíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
| 669 | "Èíâåíòàðíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå çàäàí\", "
|
669 | "Èíâåíòàðíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå çàäàí\", "
|
| 670 | "PRIMARY KEY ( Èäåíòèôèêàòîð )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
670 | "PRIMARY KEY ( Èäåíòèôèêàòîð )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
| 671 | 671 | ||
| 672 | ok = q.exec(); |
672 | ok = q.exec(); |
| 673 | 673 | ||
| 674 | q.clear(); |
674 | q.clear(); |
| 675 | 675 | ||
| 676 | ok = q.prepare(tr("CREATE TABLE an_db.proizvoditeli_pamyati (Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci NOT NULL, " |
676 | ok = q.prepare(tr("CREATE TABLE proizvoditeli_pamyati (Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci NOT NULL, " |
| 677 | "PRIMARY KEY ( Ïðîèçâîäèòåëü )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
677 | "PRIMARY KEY ( Ïðîèçâîäèòåëü )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
| 678 | 678 | ||
| 679 | ok = q.exec(); |
679 | ok = q.exec(); |
| 680 | 680 | ||
| 681 | q.clear(); |
681 | q.clear(); |
| 682 | 682 | ||
| 683 | ok = q.prepare(tr("CREATE TABLE an_db.processors (Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, " |
683 | ok = q.prepare(tr("CREATE TABLE processors (Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, " |
| 684 | "Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
684 | "Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
| 685 | "Ìîäåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå èçâåñòíà\", "
|
685 | "Ìîäåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå èçâåñòíà\", "
|
| 686 | "×àñòîòà INTEGER UNSIGNED, "
|
686 | "×àñòîòà INTEGER UNSIGNED, "
|
| 687 | "Ñëîò CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå èçâåñòåí\", "
|
687 | "Ñëîò CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå èçâåñòåí\", "
|
| 688 | "Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà INTEGER UNSIGNED DEFAULT 1, "
|
688 | "Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà INTEGER UNSIGNED DEFAULT 1, "
|
| 689 | "Ñåðèéíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
689 | "Ñåðèéíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
| 690 | "Èíâåíòàðíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå çàäàí\", "
|
690 | "Èíâåíòàðíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå çàäàí\", "
|
| 691 | "PRIMARY KEY ( Èäåíòèôèêàòîð )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
691 | "PRIMARY KEY ( Èäåíòèôèêàòîð )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
| 692 | 692 | ||
| 693 | ok = q.exec(); |
693 | ok = q.exec(); |
| 694 | 694 | ||
| 695 | q.clear(); |
695 | q.clear(); |
| 696 | 696 | ||
| 697 | ok = q.prepare(tr("CREATE TABLE an_db.processor_models (Ìîäåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå èçâåñòíà\", " |
697 | ok = q.prepare(tr("CREATE TABLE processor_models (Ìîäåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå èçâåñòíà\", " |
| 698 | "Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå èçâåñòåí\""
|
698 | "Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå èçâåñòåí\""
|
| 699 | ") ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
699 | ") ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
| 700 | 700 | ||
| 701 | ok = q.exec(); |
701 | ok = q.exec(); |
| 702 | 702 | ||
| 703 | q.clear(); |
703 | q.clear(); |
| 704 | 704 | ||
| 705 | 705 | ||
| 706 | 706 | ||
| 707 | 707 | ||
| 708 | ok = q.prepare(tr("CREATE TABLE an_db.harddiscs (Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, " |
708 | ok = q.prepare(tr("CREATE TABLE harddiscs (Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, " |
| 709 | "Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
709 | "Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
| 710 | "Èíòåðôåéñ CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
710 | "Èíòåðôåéñ CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
| 711 | "Îáúåì INTEGER UNSIGNED, "
|
711 | "Îáúåì INTEGER UNSIGNED, "
|
| 712 | "Ìîäåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå èçâåñòíà\", "
|
712 | "Ìîäåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå èçâåñòíà\", "
|
| 713 | "Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà INTEGER UNSIGNED DEFAULT 1, "
|
713 | "Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà INTEGER UNSIGNED DEFAULT 1, "
|
| 714 | "Ñåðèéíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
714 | "Ñåðèéíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
| 715 | "Èíâåíòàðíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå çàäàí\", "
|
715 | "Èíâåíòàðíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå çàäàí\", "
|
| 716 | "PRIMARY KEY ( Èäåíòèôèêàòîð )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
716 | "PRIMARY KEY ( Èäåíòèôèêàòîð )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
| 717 | 717 | ||
| 718 | ok = q.exec(); |
718 | ok = q.exec(); |
| 719 | 719 | ||
| 720 | q.clear(); |
720 | q.clear(); |
| 721 | 721 | ||
| 722 | 722 | ||
| 723 | ok = q.prepare(tr("CREATE TABLE an_db.proizvoditeli_hdd (Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci NOT NULL, " |
723 | ok = q.prepare(tr("CREATE TABLE proizvoditeli_hdd (Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci NOT NULL, " |
| 724 | "PRIMARY KEY ( Ïðîèçâîäèòåëü )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
724 | "PRIMARY KEY ( Ïðîèçâîäèòåëü )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
| 725 | 725 | ||
| 726 | ok = q.exec(); |
726 | ok = q.exec(); |
| 727 | 727 | ||
| 728 | q.clear(); |
728 | q.clear(); |
| 729 | 729 | ||
| 730 | 730 | ||
| 731 | ok = q.prepare(tr("CREATE TABLE an_db.proizvoditeli_mb (Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci NOT NULL, " |
731 | ok = q.prepare(tr("CREATE TABLE proizvoditeli_mb (Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci NOT NULL, " |
| 732 | "PRIMARY KEY ( Ïðîèçâîäèòåëü )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
732 | "PRIMARY KEY ( Ïðîèçâîäèòåëü )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
| 733 | 733 | ||
| 734 | ok = q.exec(); |
734 | ok = q.exec(); |
| 735 | 735 | ||
| 736 | q.clear(); |
736 | q.clear(); |
| 737 | 737 | ||
| 738 | 738 | ||
| 739 | 739 | ||
| 740 | 740 | ||
| 741 | ok = q.prepare(tr("CREATE TABLE an_db.proizvoditeli_cpu (Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci NOT NULL, " |
741 | ok = q.prepare(tr("CREATE TABLE proizvoditeli_cpu (Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci NOT NULL, " |
| 742 | "PRIMARY KEY ( Ïðîèçâîäèòåëü )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
742 | "PRIMARY KEY ( Ïðîèçâîäèòåëü )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
| 743 | 743 | ||
| 744 | ok = q.exec(); |
744 | ok = q.exec(); |
| 745 | 745 | ||
| 746 | q.clear(); |
746 | q.clear(); |
| 747 | 747 | ||
| 748 | 748 | ||
| 749 | 749 | ||
| 750 | 750 | ||
| 751 | 751 | ||
| 752 | ok = q.prepare(tr("CREATE TABLE an_db.proizvoditeli_mb (Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci NOT NULL, " |
752 | ok = q.prepare(tr("CREATE TABLE proizvoditeli_mb (Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci NOT NULL, " |
| 753 | "PRIMARY KEY ( Ïðîèçâîäèòåëü )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
753 | "PRIMARY KEY ( Ïðîèçâîäèòåëü )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
| 754 | 754 | ||
| 755 | ok = q.exec(); |
755 | ok = q.exec(); |
| 756 | 756 | ||
| 757 | q.clear(); |
757 | q.clear(); |
| 758 | 758 | ||
| 759 | 759 | ||
| 760 | 760 | ||
| 761 | 761 | ||
| 762 | 762 | ||
| 763 | ok = q.prepare(tr("CREATE TABLE an_db.proizvoditeli_video (Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci NOT NULL, " |
763 | ok = q.prepare(tr("CREATE TABLE proizvoditeli_video (Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci NOT NULL, " |
| 764 | "PRIMARY KEY ( Ïðîèçâîäèòåëü )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
764 | "PRIMARY KEY ( Ïðîèçâîäèòåëü )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
| 765 | 765 | ||
| 766 | ok = q.exec(); |
766 | ok = q.exec(); |
| 767 | 767 | ||
| 768 | q.clear(); |
768 | q.clear(); |
| 769 | 769 | ||
| 770 | 770 | ||
| 771 | 771 | ||
| 772 | ok = q.prepare(tr("CREATE TABLE an_db.video_models (Ìîäåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå èçâåñòíà\", " |
772 | ok = q.prepare(tr("CREATE TABLE video_models (Ìîäåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå èçâåñòíà\", " |
| 773 | "Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå èçâåñòåí\""
|
773 | "Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå èçâåñòåí\""
|
| 774 | ") ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
774 | ") ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
| 775 | 775 | ||
| 776 | ok = q.exec(); |
776 | ok = q.exec(); |
| 777 | 777 | ||
| 778 | q.clear(); |
778 | q.clear(); |
| 779 | 779 | ||
| 780 | 780 | ||
| 781 | 781 | ||
| 782 | 782 | ||
| 783 | 783 | ||
| 784 | ok = q.prepare(tr("CREATE TABLE an_db.cd_dvd (Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, " |
784 | ok = q.prepare(tr("CREATE TABLE cd_dvd (Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, " |
| 785 | "Òèï CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
785 | "Òèï CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
| 786 | "Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
786 | "Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
| 787 | "Ñêîðîñòü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåíà\", "
|
787 | "Ñêîðîñòü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåíà\", "
|
| 788 | "Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà INTEGER UNSIGNED DEFAULT 1, "
|
788 | "Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà INTEGER UNSIGNED DEFAULT 1, "
|
| 789 | "Èíâåíòàðíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå çàäàí\", "
|
789 | "Èíâåíòàðíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå çàäàí\", "
|
| 790 | "Ñåðèéíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
790 | "Ñåðèéíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
| 791 | "PRIMARY KEY ( Èäåíòèôèêàòîð )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
791 | "PRIMARY KEY ( Èäåíòèôèêàòîð )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
| 792 | 792 | ||
| 793 | ok = q.exec(); |
793 | ok = q.exec(); |
| 794 | 794 | ||
| 795 | q.clear(); |
795 | q.clear(); |
| 796 | 796 | ||
| 797 | 797 | ||
| 798 | ok = q.prepare(tr("CREATE TABLE an_db.videocards (Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, " |
798 | ok = q.prepare(tr("CREATE TABLE videocards (Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, " |
| 799 | "Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
799 | "Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
| 800 | "Ìîäåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåíà\", "
|
800 | "Ìîäåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåíà\", "
|
| 801 | "Èíòåðôåéñ CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
801 | "Èíòåðôåéñ CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
| 802 | "Ïàìÿòü INTEGER UNSIGNED, "
|
802 | "Ïàìÿòü INTEGER UNSIGNED, "
|
| 803 | "Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà INTEGER UNSIGNED DEFAULT 1, "
|
803 | "Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà INTEGER UNSIGNED DEFAULT 1, "
|
| 804 | "Èíâåíòàðíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå çàäàí\", "
|
804 | "Èíâåíòàðíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå çàäàí\", "
|
| 805 | "Ñåðèéíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
805 | "Ñåðèéíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
| 806 | "PRIMARY KEY ( Èäåíòèôèêàòîð )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
806 | "PRIMARY KEY ( Èäåíòèôèêàòîð )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
| 807 | 807 | ||
| 808 | ok = q.exec(); |
808 | ok = q.exec(); |
| 809 | 809 | ||
| 810 | q.clear(); |
810 | q.clear(); |
| 811 | 811 | ||
| 812 | ok = q.prepare(tr("CREATE TABLE an_db.soundcards (Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, " |
812 | ok = q.prepare(tr("CREATE TABLE soundcards (Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, " |
| 813 | "Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
813 | "Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
| 814 | "Ìîäåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåíà\", "
|
814 | "Ìîäåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåíà\", "
|
| 815 | "Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà INTEGER UNSIGNED DEFAULT 1, "
|
815 | "Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà INTEGER UNSIGNED DEFAULT 1, "
|
| 816 | "Èíâåíòàðíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå çàäàí\", "
|
816 | "Èíâåíòàðíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå çàäàí\", "
|
| 817 | "Ñåðèéíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
817 | "Ñåðèéíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
| 818 | "PRIMARY KEY ( Èäåíòèôèêàòîð )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
818 | "PRIMARY KEY ( Èäåíòèôèêàòîð )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
| 819 | 819 | ||
| 820 | ok = q.exec(); |
820 | ok = q.exec(); |
| 821 | 821 | ||
| 822 | q.clear(); |
822 | q.clear(); |
| 823 | 823 | ||
| 824 | ok = q.prepare(tr("CREATE TABLE an_db.lancards (Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, " |
824 | ok = q.prepare(tr("CREATE TABLE lancards (Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, " |
| 825 | "Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
825 | "Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
| 826 | "Ìîäåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåíà\", "
|
826 | "Ìîäåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåíà\", "
|
| 827 | "Ñêîðîñòü_ïåðåäà÷è_äàííûõ INTEGER UNSIGNED DEFAULT 100, "
|
827 | "Ñêîðîñòü_ïåðåäà÷è_äàííûõ INTEGER UNSIGNED DEFAULT 100, "
|
| 828 | "Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà INTEGER UNSIGNED DEFAULT 1, "
|
828 | "Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà INTEGER UNSIGNED DEFAULT 1, "
|
| 829 | "Èíâåíòàðíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå çàäàí\", "
|
829 | "Èíâåíòàðíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå çàäàí\", "
|
| 830 | "Ñåðèéíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
830 | "Ñåðèéíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
|
| 831 | "PRIMARY KEY ( Èäåíòèôèêàòîð )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
831 | "PRIMARY KEY ( Èäåíòèôèêàòîð )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci")); |
| 832 | 832 | ||
| 833 | ok = q.exec(); |
833 | ok = q.exec(); |
| 834 | 834 | ||
| 835 | q.clear(); |
835 | q.clear(); |
| 836 | 836 | ||
| 837 | ok = q.prepare(tr("INSERT INTO an_db.otdeli VALUES( default, \"Ñêëàä\", \"Ñêëàä\")")); |
837 | ok = q.prepare(tr("INSERT INTO otdeli VALUES( default, \"Ñêëàä\", \"Ñêëàä\")")); |
| 838 | 838 | ||
| 839 | ok = q.exec(); |
839 | ok = q.exec(); |
| 840 | 840 | ||
| 841 | q.clear(); |
841 | q.clear(); |
| 842 | 842 | ||
| 843 | 843 | ||
| 844 | 844 | ||
| 845 | //sotrydniki
|
845 | //sotrydniki
|
| 846 | 846 | ||
| 847 | q.prepare(tr("insert into sotrydniki (ÔÈÎ, Èäåíòèôèêàòîð_îòäåëà) " |
847 | q.prepare(tr("insert into sotrydniki (ÔÈÎ, Èäåíòèôèêàòîð_îòäåëà) " |
| 848 | "values (:fio, :id_otd)")); |
848 | "values (:fio, :id_otd)")); |
| 849 | q.bindValue(tr(":fio"), tr("Êëàäîâùèê")); |
849 | q.bindValue(tr(":fio"), tr("Êëàäîâùèê")); |
| 850 | q.bindValue(tr(":id_otd"), tr("1")); |
850 | q.bindValue(tr(":id_otd"), tr("1")); |
| 851 | 851 | ||
| 852 | ok = q.exec(); |
852 | ok = q.exec(); |
| 853 | 853 | ||
| 854 | 854 | ||
| 855 | }
|
855 | }
|
| 856 | 856 | ||
| 857 | 857 | ||
| 858 | 858 | ||
| 859 | void MainWindowImpl::on_exportButton_clicked(){ |
859 | void MainWindowImpl::on_exportButton_clicked(){ |
| 860 | 860 | ||
| 861 | raportFrm.show(); |
861 | raportFrm.show(); |
| 862 | /*
|
862 | /*
|
| 863 | 863 | ||
| 864 | int ch;
|
864 | int ch;
|
| 865 | QChar qch = 'Ï';
|
865 | QChar qch = 'Ï';
|
| 866 | 866 | ||
| 867 | char ch_arr[32];
|
867 | char ch_arr[32];
|
| 868 | ch_arr[0] = char('À');
|
868 | ch_arr[0] = char('À');
|
| 869 | ch_arr[1] = char('í');
|
869 | ch_arr[1] = char('í');
|
| 870 | ch_arr[2] = char('ä');
|
870 | ch_arr[2] = char('ä');
|
| 871 | ch_arr[3] = char('ð');
|
871 | ch_arr[3] = char('ð');
|
| 872 | ch_arr[4] = char('å');
|
872 | ch_arr[4] = char('å');
|
| 873 | 873 | ||
| 874 | ch = qch.unicode();
|
874 | ch = qch.unicode();
|
| 875 |
|
875 |
|
| 876 | // int y;
|
876 | // int y;
|
| 877 | // y = 20 / 0;
|
877 | // y = 20 / 0;
|
| 878 | if (!(myfun())){
|
878 | if (!(myfun())){
|
| 879 |
|
879 |
|
| 880 | //connecttoregistry();
|
880 | //connecttoregistry();
|
| 881 | //initcomponentcontext();
|
881 | //initcomponentcontext();
|
| 882 | //send();
|
882 | //send();
|
| 883 |
|
883 |
|
| 884 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
|
884 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
|
| 885 | this, // Ðîäèòåëüñêèé âèäæåò.
|
885 | this, // Ðîäèòåëüñêèé âèäæåò.
|
| 886 | QObject::tr("Îøèáêà ïîäêëþ÷åíèÿ "), // Çàãîëîâîê.
|
886 | QObject::tr("Îøèáêà ïîäêëþ÷åíèÿ "), // Çàãîëîâîê.
|
| 887 | // db.lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
887 | // db.lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
| 888 | tr("Íå óäàëîñü ïîäêëþ÷èòüñÿ ê ñåðâåðó OpenOffice."));
|
888 | tr("Íå óäàëîñü ïîäêëþ÷èòüñÿ ê ñåðâåðó OpenOffice."));
|
| 889 | }
|
889 | }
|
| 890 |
|
890 |
|
| 891 |
|
891 |
|
| 892 |
|
892 |
|
| 893 | if (!(connecttoregistry())){
|
893 | if (!(connecttoregistry())){
|
| 894 |
|
894 |
|
| 895 | //connecttoregistry();
|
895 | //connecttoregistry();
|
| 896 | //initcomponentcontext();
|
896 | //initcomponentcontext();
|
| 897 | //send();
|
897 | //send();
|
| 898 |
|
898 |
|
| 899 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
|
899 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
|
| 900 | this, // Ðîäèòåëüñêèé âèäæåò.
|
900 | this, // Ðîäèòåëüñêèé âèäæåò.
|
| 901 | QObject::tr("Îøèáêà ïîäêëþ÷åíèÿ "), // Çàãîëîâîê.
|
901 | QObject::tr("Îøèáêà ïîäêëþ÷åíèÿ "), // Çàãîëîâîê.
|
| 902 | // db.lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
902 | // db.lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
| 903 | tr("Íå óäàëîñü ïîäêëþ÷èòüñÿ ê ñåðâåðó OpenOffice."));
|
903 | tr("Íå óäàëîñü ïîäêëþ÷èòüñÿ ê ñåðâåðó OpenOffice."));
|
| 904 | }
|
904 | }
|
| 905 | if (!(initcomponentcontext())){
|
905 | if (!(initcomponentcontext())){
|
| 906 |
|
906 |
|
| 907 | //connecttoregistry();
|
907 | //connecttoregistry();
|
| 908 | //initcomponentcontext();
|
908 | //initcomponentcontext();
|
| 909 | //send();
|
909 | //send();
|
| 910 |
|
910 |
|
| 911 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
|
911 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
|
| 912 | this, // Ðîäèòåëüñêèé âèäæåò.
|
912 | this, // Ðîäèòåëüñêèé âèäæåò.
|
| 913 | QObject::tr("Îøèáêà ïîäêëþ÷åíèÿ "), // Çàãîëîâîê.
|
913 | QObject::tr("Îøèáêà ïîäêëþ÷åíèÿ "), // Çàãîëîâîê.
|
| 914 | // db.lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
914 | // db.lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
| 915 | tr("Íå óäàëîñü ïîäêëþ÷èòüñÿ ê ñåðâåðó OpenOffice."));
|
915 | tr("Íå óäàëîñü ïîäêëþ÷èòüñÿ ê ñåðâåðó OpenOffice."));
|
| 916 | }
|
916 | }
|
| 917 |
|
917 |
|
| 918 | if (!(send(10))){
|
918 | if (!(send(10))){
|
| 919 |
|
919 |
|
| 920 | //connecttoregistry();
|
920 | //connecttoregistry();
|
| 921 | //initcomponentcontext();
|
921 | //initcomponentcontext();
|
| 922 | //send();
|
922 | //send();
|
| 923 |
|
923 |
|
| 924 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
|
924 | QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
|
| 925 | this, // Ðîäèòåëüñêèé âèäæåò.
|
925 | this, // Ðîäèòåëüñêèé âèäæåò.
|
| 926 | QObject::tr("Îøèáêà ïîäêëþ÷åíèÿ "), // Çàãîëîâîê.
|
926 | QObject::tr("Îøèáêà ïîäêëþ÷åíèÿ "), // Çàãîëîâîê.
|
| 927 | // db.lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
927 | // db.lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
| 928 | tr("Íå óäàëîñü ïîäêëþ÷èòüñÿ ê ñåðâåðó OpenOffice."));
|
928 | tr("Íå óäàëîñü ïîäêëþ÷èòüñÿ ê ñåðâåðó OpenOffice."));
|
| 929 | }
|
929 | }
|
| 930 |
|
930 |
|
| 931 |
|
931 |
|
| 932 |
|
932 |
|
| 933 | 933 | ||
| 934 | 934 | ||
| 935 | */
|
935 | */
|
| 936 | 936 | ||
| 937 | }; |
937 | }; |
| 938 | 938 | ||
| 939 | 939 | ||
| 940 | void MainWindowImpl::on_wmiButton_clicked(){ |
940 | void MainWindowImpl::on_wmiButton_clicked(){ |
| 941 | 941 | ||
| 942 | // QString program = tr(" wmic -U Àäìèíèñòðàòîð%Patr10t //192.168.0.135 \"select * from Win32_ComputerSystem\"");
|
942 | // QString program = tr(" wmic -U Àäìèíèñòðàòîð%Patr10t //192.168.0.135 \"select * from Win32_ComputerSystem\"");
|
| 943 | QString program = tr("wmic"); |
943 | QString program = tr("wmic"); |
| 944 | QStringList arguments;
|
944 | QStringList arguments;
|
| 945 | 945 | ||
| 946 | // arguments << tr(" -U Àäìèíèñòðàòîð%Patr10t //192.168.0.135 \"select * from Win32_ComputerSystem\"");
|
946 | // arguments << tr(" -U Àäìèíèñòðàòîð%Patr10t //192.168.0.135 \"select * from Win32_ComputerSystem\"");
|
| 947 | program.append(tr(" -U Àäìèíèñòðàòîð%Patr10t //192.168.0.135 \"select * from Win32_ComputerSystem\"")); |
947 | program.append(tr(" -U Àäìèíèñòðàòîð%Patr10t //192.168.0.135 \"select * from Win32_ComputerSystem\"")); |
| 948 | int i; |
948 | int i; |
| 949 | i++; |
949 | i++; |
| 950 | process.start(program); |
950 | process.start(program); |
| 951 | 951 | ||
| 952 | }
|
952 | }
|
| 953 | 953 | ||
| 954 | 954 | ||
| 955 | void MainWindowImpl::addNewOtdel(){ |
955 | void MainWindowImpl::addNewOtdel(){ |
| 956 | int i=0; |
956 | int i=0; |
| 957 | i++; |
957 | i++; |
| 958 | addotdelFrm.lineEdit->clear(); |
958 | addotdelFrm.lineEdit->clear(); |
| 959 | addotdelFrm.lineEdit_2->clear(); |
959 | addotdelFrm.lineEdit_2->clear(); |
| 960 | treeWidget->setEnabled(false); |
960 | treeWidget->setEnabled(false); |
| 961 | addotdelFrm.show(); |
961 | addotdelFrm.show(); |
| 962 | 962 | ||
| 963 | }
|
963 | }
|
| 964 | 964 | ||
| 965 | void MainWindowImpl::new_sotrydnik(){ |
965 | void MainWindowImpl::new_sotrydnik(){ |
| 966 | QTreeWidgetItem *currItm; |
966 | QTreeWidgetItem *currItm; |
| 967 | currItm = treeWidget-> currentItem (); |
967 | currItm = treeWidget-> currentItem (); |
| 968 | int i=0; |
968 | int i=0; |
| 969 | i++; |
969 | i++; |
| 970 | addsotrydnikFrm.lineEdit->clear(); |
970 | addsotrydnikFrm.lineEdit->clear(); |
| 971 | addsotrydnikFrm.IdOtdela = currItm->text(12); |
971 | addsotrydnikFrm.IdOtdela = currItm->text(12); |
| 972 | treeWidget->setEnabled(false); |
972 | treeWidget->setEnabled(false); |
| 973 | addsotrydnikFrm.show(); |
973 | addsotrydnikFrm.show(); |
| 974 | 974 | ||
| 975 | }
|
975 | }
|
| 976 | 976 | ||
| 977 | void MainWindowImpl::novaya_SYSTEM_BLOCK_na_sklad(){ |
977 | void MainWindowImpl::novaya_SYSTEM_BLOCK_na_sklad(){ |
| 978 | int i=0; |
978 | int i=0; |
| 979 | i++; |
979 | i++; |
| 980 | treeWidget->setEnabled(false); |
980 | treeWidget->setEnabled(false); |
| 981 | addsysblockFrm.show(); |
981 | addsysblockFrm.show(); |
| 982 | 982 | ||
| 983 | }
|
983 | }
|
| 984 | 984 | ||
| 985 | void MainWindowImpl::readStandartProcessOutput(){ |
985 | void MainWindowImpl::readStandartProcessOutput(){ |
| 986 | QByteArray arr;
|
986 | QByteArray arr;
|
| 987 | QStringList result;
|
987 | QStringList result;
|
| 988 | QString str1, str2;
|
988 | QString str1, str2;
|
| 989 | int i; |
989 | int i; |
| 990 | arr = process.readAllStandardOutput(); |
990 | arr = process.readAllStandardOutput(); |
| 991 | QTextCodec *codecUTF = QTextCodec::codecForName("utf8"); |
991 | QTextCodec *codecUTF = QTextCodec::codecForName("utf8"); |
| 992 | QTextCodec *codec = QTextCodec::codecForName("cp1251"); |
992 | QTextCodec *codec = QTextCodec::codecForName("cp1251"); |
| 993 | QTextCodec::setCodecForTr(codecUTF); |
993 | QTextCodec::setCodecForTr(codecUTF); |
| 994 | str1 = QString(tr(arr)); |
994 | str1 = QString(tr(arr)); |
| 995 | QTextCodec::setCodecForTr(codec); |
995 | QTextCodec::setCodecForTr(codec); |
| 996 | result << QStringList(arr); |
996 | result << QStringList(arr); |
| 997 | // str2 << arr;
|
997 | // str2 << arr;
|
| 998 | i = result.size(); |
998 | i = result.size(); |
| 999 | // str1 = result.at(0);
|
999 | // str1 = result.at(0);
|
| 1000 | i++; |
1000 | i++; |
| 1001 | lineEdit->insert(str1); |
1001 | lineEdit->insert(str1); |
| 1002 | 1002 | ||
| 1003 | }
|
1003 | }
|
| 1004 | 1004 | ||
| 1005 | void MainWindowImpl::readStandartProcessError(){ |
1005 | void MainWindowImpl::readStandartProcessError(){ |
| 1006 | QByteArray arr;
|
1006 | QByteArray arr;
|
| 1007 | arr = process.readAllStandardError(); |
1007 | arr = process.readAllStandardError(); |
| 1008 | 1008 | ||
| 1009 | }
|
1009 | }
|
| 1010 | 1010 | ||