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