Содержимое файла | Последнее изменение | Открыть журнал | RSS
Редакция | Автор | № строки | Строка |
---|---|---|---|
6 | pingvin | 1 | #include "addsysblockform.h" |
2 | #include "mainwindowimpl.h" |
||
3 | // place your code here |
||
4 | |||
5 | |||
6 | addsysblockForm::addsysblockForm() |
||
7 | : QDialog(){ |
||
8 | setupUi(this); |
||
9 | connect(buttonBox, SIGNAL(accepted()), this, SLOT(addNewSysBlockSlot())); |
||
10 | } |
||
11 | |||
12 | void addsysblockForm::closeEvent ( QCloseEvent * event ) { |
||
13 | emit formClose(); |
||
14 | } |
||
15 | |||
16 | void addsysblockForm::addNewSysBlockSlot(){ |
||
17 | int i; |
||
18 | i++; |
||
19 | //test cvs |
||
20 | QDate data_p; |
||
21 | QSqlQuery q; |
||
22 | QString sqltext; |
||
23 | int field_fio, field_identifikator, field_inventar_num; |
||
24 | QString serial_num, inventar_num, data_str, garant_str, id, fio, id_otdela; |
||
25 | bool ok; |
||
26 | if (lineEdit_2->text()==""){ |
||
27 | QMessageBox::critical( // . |
||
28 | this, // . |
||
29 | QObject::tr(" "), // . |
||
30 | tr(" !")); // . |
||
31 | return; |
||
32 | } |
||
33 | |||
34 | |||
35 | sqltext = tr("select * from system_blocks where system_blocks._ = \""); |
||
36 | sqltext.append(lineEdit_2->text()); |
||
37 | sqltext.append(tr("\"")); |
||
38 | q.prepare(sqltext); |
||
39 | ok = q.exec(); |
||
40 | field_inventar_num = q.record().indexOf(tr("_")); |
||
41 | if (q.next()) { |
||
42 | QMessageBox::critical( // . |
||
43 | this, // . |
||
44 | QObject::tr(" !"), // . |
||
45 | tr(" !")); // . |
||
46 | return; |
||
47 | } |
||
48 | else { |
||
49 | q.clear(); |
||
50 | data_p = dateEdit->date(); |
||
51 | data_str = data_p.toString(tr("yyyy-MM-dd")); |
||
52 | garant_str = QVariant(spinBox->value()).toString(); |
||
53 | q.prepare(tr("insert into system_blocks (_, _, _, _, __) " |
||
54 | "values (:ser_num, :inv_num, :date, :garant, :id_otv_lica)")); |
||
55 | q.bindValue(tr(":ser_num"), lineEdit->text()); |
||
56 | q.bindValue(tr(":inv_num"), lineEdit_2->text()); |
||
57 | q.bindValue(tr(":date"), data_str); |
||
58 | q.bindValue(tr(":garant"), garant_str); |
||
59 | q.bindValue(tr(":id_otv_lica"), tr("1")); |
||
60 | ok = q.exec(); |
||
61 | emit componentAdd(); |
||
62 | close(); |
||
63 | } |
||
64 | |||
65 | |||
66 | } |
||
67 |