Редакция 6 | Только различия | Учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 6 | Редакция 17 | ||
---|---|---|---|
1 | #include "addmemoryform.h"
|
1 | #include "addmemoryform.h"
|
2 | #include "mainwindowimpl.h"
|
2 | #include "mainwindowimpl.h"
|
3 | 3 | ||
4 | // place your code here
|
4 | // place your code here
|
5 | addmemoryForm::addmemoryForm( ) |
5 | addmemoryForm::addmemoryForm( ) |
6 | : QWidget() |
6 | : QWidget() |
7 | {
|
7 | {
|
8 | // QStringList proizv_list; //ñïèñîê ïðîèçâîäèòåëåé ïàìÿòè
|
8 | // QStringList proizv_list; //ñïèñîê ïðîèçâîäèòåëåé ïàìÿòè
|
9 | setupUi(this); |
9 | setupUi(this); |
10 | // proizv_list = getManufacturiesList();
|
10 | // proizv_list = getManufacturiesList();
|
11 | // comboBox->addItems(proizv_list);
|
11 | // comboBox->addItems(proizv_list);
|
12 | // TODO
|
12 | // TODO
|
13 | }
|
13 | }
|
14 | 14 | ||
15 | QStringList addmemoryForm::getManufacturiesList(){ |
15 | QStringList addmemoryForm::getManufacturiesList(){ |
16 | QStringList mnfctrlist;
|
16 | QStringList mnfctrlist;
|
17 | QString mnfctSqlText, tmp;
|
17 | QString mnfctSqlText, tmp;
|
18 | QSqlQuery qproiz;
|
18 | QSqlQuery qproiz;
|
19 | int field_proizvoditel; |
19 | int field_proizvoditel; |
20 | mnfctSqlText = tr("select * from an_db.proizvoditeli_pamyati"); |
20 | mnfctSqlText = tr("select * from proizvoditeli_pamyati"); |
21 | // QSqlQuery qns(tr("SET NAMES utf8"));
|
21 | // QSqlQuery qns(tr("SET NAMES utf8"));
|
22 | qproiz.prepare(mnfctSqlText); |
22 | qproiz.prepare(mnfctSqlText); |
23 | qproiz.exec(); |
23 | qproiz.exec(); |
24 | // QSqlQuery qproiz("SELECT * FROM an_db.Ïðîèçâîäèòåëè_ïàìÿòè");
|
24 | // QSqlQuery qproiz("SELECT * FROM Ïðîèçâîäèòåëè_ïàìÿòè");
|
25 | field_proizvoditel = qproiz.record().indexOf(tr("Ïðîèçâîäèòåëü")); |
25 | field_proizvoditel = qproiz.record().indexOf(tr("Ïðîèçâîäèòåëü")); |
26 | mnfctrlist.clear(); |
26 | mnfctrlist.clear(); |
27 | while (qproiz.next()){ |
27 | while (qproiz.next()){ |
28 | tmp = qproiz.value(field_proizvoditel).toString(); |
28 | tmp = qproiz.value(field_proizvoditel).toString(); |
29 | // comboBox->addItem(tmp);
|
29 | // comboBox->addItem(tmp);
|
30 | mnfctrlist.append (tmp); |
30 | mnfctrlist.append (tmp); |
31 | }
|
31 | }
|
32 | // comboBox->addItems(mnfctrlist);
|
32 | // comboBox->addItems(mnfctrlist);
|
33 | return mnfctrlist; |
33 | return mnfctrlist; |
34 | }
|
34 | }
|
35 | 35 | ||
36 | 36 | ||
37 | QStringList addmemoryForm::getManufacturiesListVIDEO(){ |
37 | QStringList addmemoryForm::getManufacturiesListVIDEO(){ |
38 | QStringList mnfctrlist;
|
38 | QStringList mnfctrlist;
|
39 | QString mnfctSqlText, tmp;
|
39 | QString mnfctSqlText, tmp;
|
40 | QSqlQuery qproiz;
|
40 | QSqlQuery qproiz;
|
41 | int field_proizvoditel; |
41 | int field_proizvoditel; |
42 | mnfctSqlText = tr("select * from an_db.proizvoditeli_video"); |
42 | mnfctSqlText = tr("select * from proizvoditeli_video"); |
43 | // QSqlQuery qns(tr("SET NAMES utf8"));
|
43 | // QSqlQuery qns(tr("SET NAMES utf8"));
|
44 | qproiz.prepare(mnfctSqlText); |
44 | qproiz.prepare(mnfctSqlText); |
45 | qproiz.exec(); |
45 | qproiz.exec(); |
46 | // QSqlQuery qproiz("SELECT * FROM an_db.Ïðîèçâîäèòåëè_ïàìÿòè");
|
46 | // QSqlQuery qproiz("SELECT * FROM Ïðîèçâîäèòåëè_ïàìÿòè");
|
47 | field_proizvoditel = qproiz.record().indexOf(tr("Ïðîèçâîäèòåëü")); |
47 | field_proizvoditel = qproiz.record().indexOf(tr("Ïðîèçâîäèòåëü")); |
48 | mnfctrlist.clear(); |
48 | mnfctrlist.clear(); |
49 | while (qproiz.next()){ |
49 | while (qproiz.next()){ |
50 | tmp = qproiz.value(field_proizvoditel).toString(); |
50 | tmp = qproiz.value(field_proizvoditel).toString(); |
51 | // comboBox->addItem(tmp);
|
51 | // comboBox->addItem(tmp);
|
52 | mnfctrlist.append (tmp); |
52 | mnfctrlist.append (tmp); |
53 | }
|
53 | }
|
54 | // comboBox->addItems(mnfctrlist);
|
54 | // comboBox->addItems(mnfctrlist);
|
55 | return mnfctrlist; |
55 | return mnfctrlist; |
56 | }
|
56 | }
|
57 | 57 | ||
58 | 58 | ||
59 | 59 | ||
60 | 60 | ||
61 | QStringList addmemoryForm::getManufacturiesListMB(){ |
61 | QStringList addmemoryForm::getManufacturiesListMB(){ |
62 | QStringList mnfctrlist;
|
62 | QStringList mnfctrlist;
|
63 | QString mnfctSqlText, tmp;
|
63 | QString mnfctSqlText, tmp;
|
64 | QSqlQuery qproiz;
|
64 | QSqlQuery qproiz;
|
65 | int field_proizvoditel; |
65 | int field_proizvoditel; |
66 | mnfctSqlText = tr("select * from an_db.proizvoditeli_mb"); |
66 | mnfctSqlText = tr("select * from proizvoditeli_mb"); |
67 | // QSqlQuery qns(tr("SET NAMES utf8"));
|
67 | // QSqlQuery qns(tr("SET NAMES utf8"));
|
68 | qproiz.prepare(mnfctSqlText); |
68 | qproiz.prepare(mnfctSqlText); |
69 | qproiz.exec(); |
69 | qproiz.exec(); |
70 | // QSqlQuery qproiz("SELECT * FROM an_db.Ïðîèçâîäèòåëè_ïàìÿòè");
|
70 | // QSqlQuery qproiz("SELECT * FROM Ïðîèçâîäèòåëè_ïàìÿòè");
|
71 | field_proizvoditel = qproiz.record().indexOf(tr("Ïðîèçâîäèòåëü")); |
71 | field_proizvoditel = qproiz.record().indexOf(tr("Ïðîèçâîäèòåëü")); |
72 | mnfctrlist.clear(); |
72 | mnfctrlist.clear(); |
73 | while (qproiz.next()){ |
73 | while (qproiz.next()){ |
74 | tmp = qproiz.value(field_proizvoditel).toString(); |
74 | tmp = qproiz.value(field_proizvoditel).toString(); |
75 | // comboBox->addItem(tmp);
|
75 | // comboBox->addItem(tmp);
|
76 | mnfctrlist.append (tmp); |
76 | mnfctrlist.append (tmp); |
77 | }
|
77 | }
|
78 | // comboBox->addItems(mnfctrlist);
|
78 | // comboBox->addItems(mnfctrlist);
|
79 | return mnfctrlist; |
79 | return mnfctrlist; |
80 | }
|
80 | }
|
81 | 81 | ||
82 | 82 | ||
83 | QStringList addmemoryForm::getManufacturiesListHDD(){ |
83 | QStringList addmemoryForm::getManufacturiesListHDD(){ |
84 | QStringList mnfctrlist;
|
84 | QStringList mnfctrlist;
|
85 | QString mnfctSqlText, tmp;
|
85 | QString mnfctSqlText, tmp;
|
86 | QSqlQuery qproiz;
|
86 | QSqlQuery qproiz;
|
87 | int field_proizvoditel; |
87 | int field_proizvoditel; |
88 | mnfctSqlText = tr("select * from an_db.proizvoditeli_hdd"); |
88 | mnfctSqlText = tr("select * from proizvoditeli_hdd"); |
89 | // QSqlQuery qns(tr("SET NAMES utf8"));
|
89 | // QSqlQuery qns(tr("SET NAMES utf8"));
|
90 | qproiz.prepare(mnfctSqlText); |
90 | qproiz.prepare(mnfctSqlText); |
91 | qproiz.exec(); |
91 | qproiz.exec(); |
92 | // QSqlQuery qproiz("SELECT * FROM an_db.Ïðîèçâîäèòåëè_ïàìÿòè");
|
92 | // QSqlQuery qproiz("SELECT * FROM Ïðîèçâîäèòåëè_ïàìÿòè");
|
93 | field_proizvoditel = qproiz.record().indexOf(tr("Ïðîèçâîäèòåëü")); |
93 | field_proizvoditel = qproiz.record().indexOf(tr("Ïðîèçâîäèòåëü")); |
94 | mnfctrlist.clear(); |
94 | mnfctrlist.clear(); |
95 | while (qproiz.next()){ |
95 | while (qproiz.next()){ |
96 | tmp = qproiz.value(field_proizvoditel).toString(); |
96 | tmp = qproiz.value(field_proizvoditel).toString(); |
97 | // comboBox->addItem(tmp);
|
97 | // comboBox->addItem(tmp);
|
98 | mnfctrlist.append (tmp); |
98 | mnfctrlist.append (tmp); |
99 | }
|
99 | }
|
100 | // comboBox->addItems(mnfctrlist);
|
100 | // comboBox->addItems(mnfctrlist);
|
101 | return mnfctrlist; |
101 | return mnfctrlist; |
102 | }
|
102 | }
|
103 | 103 | ||
104 | QStringList addmemoryForm::getManufacturiesListCPU(){ |
104 | QStringList addmemoryForm::getManufacturiesListCPU(){ |
105 | QStringList mnfctrlist;
|
105 | QStringList mnfctrlist;
|
106 | QString mnfctSqlText, tmp;
|
106 | QString mnfctSqlText, tmp;
|
107 | QSqlQuery qproiz;
|
107 | QSqlQuery qproiz;
|
108 | int field_proizvoditel; |
108 | int field_proizvoditel; |
109 | mnfctSqlText = tr("select * from an_db.proizvoditeli_cpu"); |
109 | mnfctSqlText = tr("select * from proizvoditeli_cpu"); |
110 | // QSqlQuery qns(tr("SET NAMES utf8"));
|
110 | // QSqlQuery qns(tr("SET NAMES utf8"));
|
111 | qproiz.prepare(mnfctSqlText); |
111 | qproiz.prepare(mnfctSqlText); |
112 | qproiz.exec(); |
112 | qproiz.exec(); |
113 | // QSqlQuery qproiz("SELECT * FROM an_db.Ïðîèçâîäèòåëè_ïàìÿòè");
|
113 | // QSqlQuery qproiz("SELECT * FROM Ïðîèçâîäèòåëè_ïàìÿòè");
|
114 | field_proizvoditel = qproiz.record().indexOf(tr("Ïðîèçâîäèòåëü")); |
114 | field_proizvoditel = qproiz.record().indexOf(tr("Ïðîèçâîäèòåëü")); |
115 | mnfctrlist.clear(); |
115 | mnfctrlist.clear(); |
116 | while (qproiz.next()){ |
116 | while (qproiz.next()){ |
117 | tmp = qproiz.value(field_proizvoditel).toString(); |
117 | tmp = qproiz.value(field_proizvoditel).toString(); |
118 | // comboBox->addItem(tmp);
|
118 | // comboBox->addItem(tmp);
|
119 | mnfctrlist.append (tmp); |
119 | mnfctrlist.append (tmp); |
120 | }
|
120 | }
|
121 | // comboBox->addItems(mnfctrlist);
|
121 | // comboBox->addItems(mnfctrlist);
|
122 | return mnfctrlist; |
122 | return mnfctrlist; |
123 | }
|
123 | }
|
124 | 124 | ||
125 | 125 | ||
126 | 126 | ||
127 | QStringList addmemoryForm::getModelListMB(QString proizvoditel){ |
127 | QStringList addmemoryForm::getModelListMB(QString proizvoditel){ |
128 | QStringList modelList;
|
128 | QStringList modelList;
|
129 | QString SqlText, tmp;
|
129 | QString SqlText, tmp;
|
130 | QSqlQuery qmodel;
|
130 | QSqlQuery qmodel;
|
131 | int field_model; |
131 | int field_model; |
132 | SqlText = tr("select * from an_db.Ìîäåëè_ìàòåðèíñêèõ_ïëàò where an_db.Ìîäåëè_ìàòåðèíñêèõ_ïëàò.Ïðîèçâîäèòåëü = \""); |
132 | SqlText = tr("select * from Ìîäåëè_ìàòåðèíñêèõ_ïëàò where Ìîäåëè_ìàòåðèíñêèõ_ïëàò.Ïðîèçâîäèòåëü = \""); |
133 | SqlText.append(proizvoditel); |
133 | SqlText.append(proizvoditel); |
134 | SqlText.append(tr("\"")); |
134 | SqlText.append(tr("\"")); |
135 | qmodel.prepare(SqlText); |
135 | qmodel.prepare(SqlText); |
136 | qmodel.exec(); |
136 | qmodel.exec(); |
137 | field_model = qmodel.record().indexOf(tr("Ìîäåëü")); |
137 | field_model = qmodel.record().indexOf(tr("Ìîäåëü")); |
138 | modelList.clear(); |
138 | modelList.clear(); |
139 | while (qmodel.next()){ |
139 | while (qmodel.next()){ |
140 | tmp = qmodel.value(field_model).toString(); |
140 | tmp = qmodel.value(field_model).toString(); |
141 | // comboBox->addItem(tmp);
|
141 | // comboBox->addItem(tmp);
|
142 | modelList.append (tmp); |
142 | modelList.append (tmp); |
143 | }
|
143 | }
|
144 | // comboBox->addItems(mnfctrlist);
|
144 | // comboBox->addItems(mnfctrlist);
|
145 | return modelList; |
145 | return modelList; |
146 | }
|
146 | }
|
147 | 147 | ||
148 | 148 | ||
149 | 149 | ||
150 | QStringList addmemoryForm::getModelListVIDEO(QString proizvoditel){ |
150 | QStringList addmemoryForm::getModelListVIDEO(QString proizvoditel){ |
151 | QStringList modelList;
|
151 | QStringList modelList;
|
152 | QString SqlText, tmp;
|
152 | QString SqlText, tmp;
|
153 | QSqlQuery qmodel;
|
153 | QSqlQuery qmodel;
|
154 | int field_model; |
154 | int field_model; |
155 | SqlText = tr("select * from an_db.video_models where an_db.video_models.Ïðîèçâîäèòåëü = \""); |
155 | SqlText = tr("select * from video_models where video_models.Ïðîèçâîäèòåëü = \""); |
156 | SqlText.append(proizvoditel); |
156 | SqlText.append(proizvoditel); |
157 | SqlText.append(tr("\"")); |
157 | SqlText.append(tr("\"")); |
158 | qmodel.prepare(SqlText); |
158 | qmodel.prepare(SqlText); |
159 | qmodel.exec(); |
159 | qmodel.exec(); |
160 | field_model = qmodel.record().indexOf(tr("Ìîäåëü")); |
160 | field_model = qmodel.record().indexOf(tr("Ìîäåëü")); |
161 | modelList.clear(); |
161 | modelList.clear(); |
162 | while (qmodel.next()){ |
162 | while (qmodel.next()){ |
163 | tmp = qmodel.value(field_model).toString(); |
163 | tmp = qmodel.value(field_model).toString(); |
164 | // comboBox->addItem(tmp);
|
164 | // comboBox->addItem(tmp);
|
165 | modelList.append (tmp); |
165 | modelList.append (tmp); |
166 | }
|
166 | }
|
167 | // comboBox->addItems(mnfctrlist);
|
167 | // comboBox->addItems(mnfctrlist);
|
168 | return modelList; |
168 | return modelList; |
169 | }
|
169 | }
|
170 | 170 | ||
171 | 171 | ||
172 | 172 | ||
173 | QStringList addmemoryForm::getModelListCPU(QString proizvoditel){ |
173 | QStringList addmemoryForm::getModelListCPU(QString proizvoditel){ |
174 | QStringList modelList;
|
174 | QStringList modelList;
|
175 | QString SqlText, tmp;
|
175 | QString SqlText, tmp;
|
176 | QSqlQuery qmodel;
|
176 | QSqlQuery qmodel;
|
177 | int field_model; |
177 | int field_model; |
178 | SqlText = tr("select * from an_db.processor_models where an_db.processor_models.Ïðîèçâîäèòåëü = \""); |
178 | SqlText = tr("select * from processor_models where processor_models.Ïðîèçâîäèòåëü = \""); |
179 | SqlText.append(proizvoditel); |
179 | SqlText.append(proizvoditel); |
180 | SqlText.append(tr("\"")); |
180 | SqlText.append(tr("\"")); |
181 | qmodel.prepare(SqlText); |
181 | qmodel.prepare(SqlText); |
182 | qmodel.exec(); |
182 | qmodel.exec(); |
183 | field_model = qmodel.record().indexOf(tr("Ìîäåëü")); |
183 | field_model = qmodel.record().indexOf(tr("Ìîäåëü")); |
184 | modelList.clear(); |
184 | modelList.clear(); |
185 | while (qmodel.next()){ |
185 | while (qmodel.next()){ |
186 | tmp = qmodel.value(field_model).toString(); |
186 | tmp = qmodel.value(field_model).toString(); |
187 | // comboBox->addItem(tmp);
|
187 | // comboBox->addItem(tmp);
|
188 | modelList.append (tmp); |
188 | modelList.append (tmp); |
189 | }
|
189 | }
|
190 | // comboBox->addItems(mnfctrlist);
|
190 | // comboBox->addItems(mnfctrlist);
|
191 | return modelList; |
191 | return modelList; |
192 | }
|
192 | }
|
193 | 193 | ||
194 | 194 | ||
195 | QStringList addmemoryForm::getSystemBlockList(){ |
195 | QStringList addmemoryForm::getSystemBlockList(){ |
196 | QStringList sysBlockList;
|
196 | QStringList sysBlockList;
|
197 | bool b1, b2; |
197 | bool b1, b2; |
198 | QString tmp, SerialNum, InventarNum, DataPokypki, SrokGarantii, UserId, Identifikator;
|
198 | QString tmp, SerialNum, InventarNum, DataPokypki, SrokGarantii, UserId, Identifikator;
|
199 | int field_identifikator, field_serial_num, field_inventar_num, field_data_pokypki, field_srok_garantii, field_user_id; |
199 | int field_identifikator, field_serial_num, field_inventar_num, field_data_pokypki, field_srok_garantii, field_user_id; |
200 | QSqlQuery qysBlockList(tr("select * from an_db.system_blocks")); |
200 | QSqlQuery qysBlockList(tr("select * from system_blocks")); |
201 | field_serial_num = qysBlockList.record().indexOf(tr("Ñåðèéíûé_íîìåð")); |
201 | field_serial_num = qysBlockList.record().indexOf(tr("Ñåðèéíûé_íîìåð")); |
202 | field_inventar_num = qysBlockList.record().indexOf(tr("Èíâåíòàðíûé_íîìåð")); |
202 | field_inventar_num = qysBlockList.record().indexOf(tr("Èíâåíòàðíûé_íîìåð")); |
203 | field_data_pokypki = qysBlockList.record().indexOf(tr("Äàòà_ïîêóïêè")); |
203 | field_data_pokypki = qysBlockList.record().indexOf(tr("Äàòà_ïîêóïêè")); |
204 | field_srok_garantii = qysBlockList.record().indexOf(tr("Ñðîê_ãàðàíòèè")); |
204 | field_srok_garantii = qysBlockList.record().indexOf(tr("Ñðîê_ãàðàíòèè")); |
205 | field_user_id = qysBlockList.record().indexOf(tr("Èäåíòèôèêàòîð_îòâåòñòâåííîãî_ëèöà")); |
205 | field_user_id = qysBlockList.record().indexOf(tr("Èäåíòèôèêàòîð_îòâåòñòâåííîãî_ëèöà")); |
206 | field_identifikator = qysBlockList.record().indexOf(tr("Èäåíòèôèêàòîð")); |
206 | field_identifikator = qysBlockList.record().indexOf(tr("Èäåíòèôèêàòîð")); |
207 | while (qysBlockList.next()){ |
207 | while (qysBlockList.next()){ |
208 | tmp = ""; |
208 | tmp = ""; |
209 | SerialNum = qysBlockList.value(field_serial_num).toString(); |
209 | SerialNum = qysBlockList.value(field_serial_num).toString(); |
210 | InventarNum = qysBlockList.value(field_inventar_num).toString(); |
210 | InventarNum = qysBlockList.value(field_inventar_num).toString(); |
211 | DataPokypki = qysBlockList.value(field_data_pokypki).toString(); |
211 | DataPokypki = qysBlockList.value(field_data_pokypki).toString(); |
212 | SrokGarantii = qysBlockList.value(field_srok_garantii).toString(); |
212 | SrokGarantii = qysBlockList.value(field_srok_garantii).toString(); |
213 | UserId = qysBlockList.value(field_user_id).toString(); |
213 | UserId = qysBlockList.value(field_user_id).toString(); |
214 | Identifikator = qysBlockList.value(field_identifikator).toString(); |
214 | Identifikator = qysBlockList.value(field_identifikator).toString(); |
215 | b1 = (SerialNum !=""); |
215 | b1 = (SerialNum !=""); |
216 | b2 = (SerialNum !=tr("Ñïèñàí")); |
216 | b2 = (SerialNum !=tr("Ñïèñàí")); |
217 | // if (SerialNum == tr("Ñïèñàí")){continue;}
|
217 | // if (SerialNum == tr("Ñïèñàí")){continue;}
|
218 | // if (SerialNum == tr("Ñêëàä")){sysBlockList << tr("Íà ñêëàä"); continue;}
|
218 | // if (SerialNum == tr("Ñêëàä")){sysBlockList << tr("Íà ñêëàä"); continue;}
|
219 | // if (SerialNum !="") {tmp.append(tr("S/N: "));
|
219 | // if (SerialNum !="") {tmp.append(tr("S/N: "));
|
220 | // tmp.append(SerialNum); }
|
220 | // tmp.append(SerialNum); }
|
221 | if (InventarNum == tr("Ñïèñàí")){continue;} |
221 | if (InventarNum == tr("Ñïèñàí")){continue;} |
222 | if (InventarNum == tr("Ñêëàä")){sysBlockList << tr("Íà ñêëàä"); continue;} |
222 | if (InventarNum == tr("Ñêëàä")){sysBlockList << tr("Íà ñêëàä"); continue;} |
223 | if (InventarNum !="") {tmp.append(tr("Èíâ.íîì:")); |
223 | if (InventarNum !="") {tmp.append(tr("Èíâ.íîì:")); |
224 | tmp.append(InventarNum); } |
224 | tmp.append(InventarNum); } |
225 | tmp.append(addmemoryForm::getUserInfo(UserId)); |
225 | tmp.append(addmemoryForm::getUserInfo(UserId)); |
226 | // if (InventarNum !=""){tmp.append(tr(" Èíâ.íîì: "));
|
226 | // if (InventarNum !=""){tmp.append(tr(" Èíâ.íîì: "));
|
227 | // tmp.append(InventarNum);}
|
227 | // tmp.append(InventarNum);}
|
228 | if (tmp !="") sysBlockList << tmp; |
228 | if (tmp !="") sysBlockList << tmp; |
229 | 229 | ||
230 | }
|
230 | }
|
231 | return sysBlockList; |
231 | return sysBlockList; |
232 | 232 | ||
233 | }
|
233 | }
|
234 | 234 | ||
235 | QString addmemoryForm::getUserInfo(QString userID){ |
235 | QString addmemoryForm::getUserInfo(QString userID){ |
236 | QString rslt, tmp, sqlQueryText;
|
236 | QString rslt, tmp, sqlQueryText;
|
237 | QString identifikator_polzovatela, fio_polzovatela, identifikator_otdela;
|
237 | QString identifikator_polzovatela, fio_polzovatela, identifikator_otdela;
|
238 | int field_identifikator, field_fio, field_id_otdela; |
238 | int field_identifikator, field_fio, field_id_otdela; |
239 | QSqlQuery qSqlUserInfo;
|
239 | QSqlQuery qSqlUserInfo;
|
240 | sqlQueryText = tr("select * from an_db.Ñîòðóäíèêè where Èäåíòèôèêàòîð = "); |
240 | sqlQueryText = tr("select * from Ñîòðóäíèêè where Èäåíòèôèêàòîð = "); |
241 | sqlQueryText.append(userID); |
241 | sqlQueryText.append(userID); |
242 | qSqlUserInfo.prepare(sqlQueryText); |
242 | qSqlUserInfo.prepare(sqlQueryText); |
243 | qSqlUserInfo.exec(); |
243 | qSqlUserInfo.exec(); |
244 | field_identifikator = qSqlUserInfo.record().indexOf(tr("Èäåíòèôèêàòîð")); |
244 | field_identifikator = qSqlUserInfo.record().indexOf(tr("Èäåíòèôèêàòîð")); |
245 | field_fio = qSqlUserInfo.record().indexOf(tr("ÔÈÎ")); |
245 | field_fio = qSqlUserInfo.record().indexOf(tr("ÔÈÎ")); |
246 | field_id_otdela = qSqlUserInfo.record().indexOf(tr("Èäåíòèôèêàòîð_îòäåëà")); |
246 | field_id_otdela = qSqlUserInfo.record().indexOf(tr("Èäåíòèôèêàòîð_îòäåëà")); |
247 | tmp=""; |
247 | tmp=""; |
248 | while(qSqlUserInfo.next()){ |
248 | while(qSqlUserInfo.next()){ |
249 | identifikator_polzovatela = qSqlUserInfo.value(field_identifikator).toString(); |
249 | identifikator_polzovatela = qSqlUserInfo.value(field_identifikator).toString(); |
250 | fio_polzovatela = qSqlUserInfo.value(field_fio).toString(); |
250 | fio_polzovatela = qSqlUserInfo.value(field_fio).toString(); |
251 | identifikator_otdela = qSqlUserInfo.value(field_id_otdela).toString(); |
251 | identifikator_otdela = qSqlUserInfo.value(field_id_otdela).toString(); |
252 | if (fio_polzovatela !="") { |
252 | if (fio_polzovatela !="") { |
253 | tmp.append(tr(" ")); |
253 | tmp.append(tr(" ")); |
254 | tmp.append(fio_polzovatela); |
254 | tmp.append(fio_polzovatela); |
255 | tmp.append(addmemoryForm::getOtdelName(identifikator_otdela)); |
255 | tmp.append(addmemoryForm::getOtdelName(identifikator_otdela)); |
256 | }
|
256 | }
|
257 | 257 | ||
258 | }
|
258 | }
|
259 | rslt.append(tmp); |
259 | rslt.append(tmp); |
260 | return rslt; |
260 | return rslt; |
261 | 261 | ||
262 | }
|
262 | }
|
263 | 263 | ||
264 | 264 | ||
265 | QString addmemoryForm::getOtdelName(QString otdelID){ |
265 | QString addmemoryForm::getOtdelName(QString otdelID){ |
266 | QString otdel, sqlText, tmp;
|
266 | QString otdel, sqlText, tmp;
|
267 | QSqlQuery query;
|
267 | QSqlQuery query;
|
268 | int field_name; |
268 | int field_name; |
269 | sqlText = (tr("select an_db.Îòäåëû.Íàçâàíèå from an_db.Îòäåëû where Èäåíòèôèêàòîð = ")); |
269 | sqlText = (tr("select Îòäåëû.Íàçâàíèå from Îòäåëû where Èäåíòèôèêàòîð = ")); |
270 | sqlText.append(otdelID); |
270 | sqlText.append(otdelID); |
271 | query.prepare(sqlText); |
271 | query.prepare(sqlText); |
272 | query.exec(); |
272 | query.exec(); |
273 | field_name = query.record().indexOf(tr("Íàçâàíèå")); |
273 | field_name = query.record().indexOf(tr("Íàçâàíèå")); |
274 | tmp=""; |
274 | tmp=""; |
275 | while(query.next()){ |
275 | while(query.next()){ |
276 | tmp.append(tr(" ")); |
276 | tmp.append(tr(" ")); |
277 | tmp.append( query.value(field_name).toString()); |
277 | tmp.append( query.value(field_name).toString()); |
278 | }
|
278 | }
|
279 | otdel = tmp; |
279 | otdel = tmp; |
280 | return otdel; |
280 | return otdel; |
281 | }
|
281 | }
|
282 | 282 | ||
283 | void addmemoryForm::initTreeWidgrt(){ |
283 | void addmemoryForm::initTreeWidgrt(){ |
284 | int fieldName, fieldID; |
284 | int fieldName, fieldID; |
285 | QTreeWidgetItem *otdelItem; |
285 | QTreeWidgetItem *otdelItem; |
286 | QSqlQuery q(tr("select * from Îòäåëû"));// ïîëó÷àåì ñïèñîê îòäåëîâ |
286 | QSqlQuery q(tr("select * from Îòäåëû"));// ïîëó÷àåì ñïèñîê îòäåëîâ |
287 | QString otdel, otdel_id;
|
287 | QString otdel, otdel_id;
|
288 | fieldName = q.record().indexOf(tr("Íàçâàíèå")); |
288 | fieldName = q.record().indexOf(tr("Íàçâàíèå")); |
289 | fieldID = q.record().indexOf(tr("Èäåíòèôèêàòîð")); |
289 | fieldID = q.record().indexOf(tr("Èäåíòèôèêàòîð")); |
290 | while (q.next()){ |
290 | while (q.next()){ |
291 | otdel = q.value(fieldName).toString(); |
291 | otdel = q.value(fieldName).toString(); |
292 | otdel_id = q.value(fieldID).toString(); |
292 | otdel_id = q.value(fieldID).toString(); |
293 | otdelItem = new QTreeWidgetItem(addmemoryForm::treeWidget); |
293 | otdelItem = new QTreeWidgetItem(addmemoryForm::treeWidget); |
294 | otdelItem->setText(0, otdel); |
294 | otdelItem->setText(0, otdel); |
295 | addmemoryForm::SotrydnikiOtdela(otdel_id, otdelItem); |
295 | addmemoryForm::SotrydnikiOtdela(otdel_id, otdelItem); |
296 | }
|
296 | }
|
297 | 297 | ||
298 | }
|
298 | }
|
299 | 299 | ||
300 | void addmemoryForm::SotrydnikiOtdela(QString id_otdela, QTreeWidgetItem * itemOtdela){ |
300 | void addmemoryForm::SotrydnikiOtdela(QString id_otdela, QTreeWidgetItem * itemOtdela){ |
301 | int field_fio_sotrydnika, field_id_sotrydnika; |
301 | int field_fio_sotrydnika, field_id_sotrydnika; |
302 | QString fio_sotrydnika_otdela, id_sotrydnika_otdela, oboryd;
|
302 | QString fio_sotrydnika_otdela, id_sotrydnika_otdela, oboryd;
|
303 | QSqlQuery qsotrydnikiOtdela;
|
303 | QSqlQuery qsotrydnikiOtdela;
|
304 | QString sqlQueryString;
|
304 | QString sqlQueryString;
|
305 | QTreeWidgetItem *treeItem_sotrydnika; |
305 | QTreeWidgetItem *treeItem_sotrydnika; |
306 | sqlQueryString = tr("select Èäåíòèôèêàòîð, ÔÈÎ from Ñîòðóäíèêè where Èäåíòèôèêàòîð_îòäåëà="); |
306 | sqlQueryString = tr("select Èäåíòèôèêàòîð, ÔÈÎ from Ñîòðóäíèêè where Èäåíòèôèêàòîð_îòäåëà="); |
307 | sqlQueryString.append(id_otdela); |
307 | sqlQueryString.append(id_otdela); |
308 | qsotrydnikiOtdela.prepare(sqlQueryString); |
308 | qsotrydnikiOtdela.prepare(sqlQueryString); |
309 | qsotrydnikiOtdela.exec(); |
309 | qsotrydnikiOtdela.exec(); |
310 | field_fio_sotrydnika = qsotrydnikiOtdela.record().indexOf(tr("ÔÈÎ")); |
310 | field_fio_sotrydnika = qsotrydnikiOtdela.record().indexOf(tr("ÔÈÎ")); |
311 | field_id_sotrydnika = qsotrydnikiOtdela.record().indexOf(tr("Èäåíòèôèêàòîð")); |
311 | field_id_sotrydnika = qsotrydnikiOtdela.record().indexOf(tr("Èäåíòèôèêàòîð")); |
312 | while (qsotrydnikiOtdela.next()) |
312 | while (qsotrydnikiOtdela.next()) |
313 | {
|
313 | {
|
314 | fio_sotrydnika_otdela = qsotrydnikiOtdela.value(field_fio_sotrydnika).toString(); |
314 | fio_sotrydnika_otdela = qsotrydnikiOtdela.value(field_fio_sotrydnika).toString(); |
315 | id_sotrydnika_otdela = qsotrydnikiOtdela.value(field_id_sotrydnika).toString(); |
315 | id_sotrydnika_otdela = qsotrydnikiOtdela.value(field_id_sotrydnika).toString(); |
316 | treeItem_sotrydnika = new QTreeWidgetItem(itemOtdela); |
316 | treeItem_sotrydnika = new QTreeWidgetItem(itemOtdela); |
317 | treeItem_sotrydnika->setText(1, fio_sotrydnika_otdela ); |
317 | treeItem_sotrydnika->setText(1, fio_sotrydnika_otdela ); |
318 | // treeItem_sotrydnika->setText(2, id_sotrydnika_otdela );
|
318 | // treeItem_sotrydnika->setText(2, id_sotrydnika_otdela );
|
319 | // oboryd = oborydovanie(id_sotrydnika_otdela, treeItem_sotrydnika);
|
319 | // oboryd = oborydovanie(id_sotrydnika_otdela, treeItem_sotrydnika);
|
320 | // treeItem_sotrydnika->setText(3, oboryd );
|
320 | // treeItem_sotrydnika->setText(3, oboryd );
|
321 | }
|
321 | }
|
322 | }
|
322 | }
|
323 | 323 | ||
324 | void addmemoryForm::on_pushButton_clicked(){ |
324 | void addmemoryForm::on_pushButton_clicked(){ |
325 | QSqlQuery q;
|
325 | QSqlQuery q;
|
326 | QString sqlText;
|
326 | QString sqlText;
|
327 | if (lineEdit->text() == "") |
327 | if (lineEdit->text() == "") |
328 | {
|
328 | {
|
329 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
329 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
330 | this, // Ðîäèòåëüñêèé âèäæåò. |
330 | this, // Ðîäèòåëüñêèé âèäæåò. |
331 | QObject::tr("Îøèáêà ââîäà äàííûõ"), // Çàãîëîâîê. |
331 | QObject::tr("Îøèáêà ââîäà äàííûõ"), // Çàãîëîâîê. |
332 | tr("Ââåäèòå èíâåíòàðíûé íîìåð")); // Òåêñò ñîîáùåíèÿ. |
332 | tr("Ââåäèòå èíâåíòàðíûé íîìåð")); // Òåêñò ñîîáùåíèÿ. |
333 | return; |
333 | return; |
334 | }
|
334 | }
|
335 | switch (tabWidget->currentIndex()) |
335 | switch (tabWidget->currentIndex()) |
336 | {
|
336 | {
|
337 | case 0: //Ìîäóëè ïàìÿòè |
337 | case 0: //Ìîäóëè ïàìÿòè |
338 | {
|
338 | {
|
339 | QString id;
|
339 | QString id;
|
340 | 340 | ||
341 | id = getIdentifikator(label_7->text()); |
341 | id = getIdentifikator(label_7->text()); |
342 | q.prepare(tr("insert into memory (Ïðîèçâîäèòåëü, Òèï, Îáúåì, Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà, Èíâåíòàðíûé_íîìåð, Ñåðèéíûé_íîìåð) " |
342 | q.prepare(tr("insert into memory (Ïðîèçâîäèòåëü, Òèï, Îáúåì, Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà, Èíâåíòàðíûé_íîìåð, Ñåðèéíûé_íîìåð) " |
343 | "values (:proizvoditel, :tip, :obem, :sys_id, :inv_num, :serial_num)")); |
343 | "values (:proizvoditel, :tip, :obem, :sys_id, :inv_num, :serial_num)")); |
344 | // q.bindValue(":ident", "default");
|
344 | // q.bindValue(":ident", "default");
|
345 | q.bindValue(tr(":proizvoditel"), comboBox->currentText()); |
345 | q.bindValue(tr(":proizvoditel"), comboBox->currentText()); |
346 | q.bindValue(tr(":tip"), comboBox_3->currentText()); |
346 | q.bindValue(tr(":tip"), comboBox_3->currentText()); |
347 | q.bindValue(tr(":obem"), comboBox_2->currentText()); |
347 | q.bindValue(tr(":obem"), comboBox_2->currentText()); |
348 | // q.bindValue(tr(":chastota"), "default");
|
348 | // q.bindValue(tr(":chastota"), "default");
|
349 | q.bindValue(tr(":sys_id"), id); |
349 | q.bindValue(tr(":sys_id"), id); |
350 | q.bindValue(tr(":inv_num"), lineEdit->text()); |
350 | q.bindValue(tr(":inv_num"), lineEdit->text()); |
351 | q.bindValue(tr(":serial_num"), lineEdit_2->text()); |
351 | q.bindValue(tr(":serial_num"), lineEdit_2->text()); |
352 | // query.bindValue(":surname", "Simpson");
|
352 | // query.bindValue(":surname", "Simpson");
|
353 | // sqlText = tr("insert into Ïàìÿòü vflue()");
|
353 | // sqlText = tr("insert into Ïàìÿòü vflue()");
|
354 | q.exec(); |
354 | q.exec(); |
355 | add_mem_proizvoditel(comboBox->currentText()); //äîáàâèì ïðîèçâîäèòåëÿ â ñïèñîê, åñëè åãî òàì íåò |
355 | add_mem_proizvoditel(comboBox->currentText()); //äîáàâèì ïðîèçâîäèòåëÿ â ñïèñîê, åñëè åãî òàì íåò |
356 | emit componentAdd(); |
356 | emit componentAdd(); |
357 | close(); |
357 | close(); |
358 | // MainWindowImpl::initTreeWidget();
|
358 | // MainWindowImpl::initTreeWidget();
|
359 | }
|
359 | }
|
360 | break; |
360 | break; |
361 | 361 | ||
362 | case 1: //Âèí÷åñòåðû |
362 | case 1: //Âèí÷åñòåðû |
363 | {
|
363 | {
|
364 | QString id;
|
364 | QString id;
|
365 | 365 | ||
366 | id = getIdentifikator(label_7->text()); |
366 | id = getIdentifikator(label_7->text()); |
367 | q.prepare(tr("insert into harddiscs (Ïðîèçâîäèòåëü, Èíòåðôåéñ, Îáúåì, Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà, Èíâåíòàðíûé_íîìåð, Ñåðèéíûé_íîìåð) " |
367 | q.prepare(tr("insert into harddiscs (Ïðîèçâîäèòåëü, Èíòåðôåéñ, Îáúåì, Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà, Èíâåíòàðíûé_íîìåð, Ñåðèéíûé_íîìåð) " |
368 | "values (:proizvoditel, :interface, :obem, :sys_id, :inv_num, :serial_num)")); |
368 | "values (:proizvoditel, :interface, :obem, :sys_id, :inv_num, :serial_num)")); |
369 | // q.bindValue(":ident", "default");
|
369 | // q.bindValue(":ident", "default");
|
370 | q.bindValue(tr(":proizvoditel"), comboBox_13->currentText()); |
370 | q.bindValue(tr(":proizvoditel"), comboBox_13->currentText()); |
371 | q.bindValue(tr(":interface"), comboBox_14->currentText()); |
371 | q.bindValue(tr(":interface"), comboBox_14->currentText()); |
372 | q.bindValue(tr(":obem"), comboBox_15->currentText()); |
372 | q.bindValue(tr(":obem"), comboBox_15->currentText()); |
373 | // q.bindValue(tr(":chastota"), "default");
|
373 | // q.bindValue(tr(":chastota"), "default");
|
374 | q.bindValue(tr(":sys_id"), id); |
374 | q.bindValue(tr(":sys_id"), id); |
375 | q.bindValue(tr(":inv_num"), lineEdit->text()); |
375 | q.bindValue(tr(":inv_num"), lineEdit->text()); |
376 | q.bindValue(tr(":serial_num"), lineEdit_2->text()); |
376 | q.bindValue(tr(":serial_num"), lineEdit_2->text()); |
377 | // query.bindValue(":surname", "Simpson");
|
377 | // query.bindValue(":surname", "Simpson");
|
378 | // sqlText = tr("insert into Ïàìÿòü vflue()");
|
378 | // sqlText = tr("insert into Ïàìÿòü vflue()");
|
379 | q.exec(); |
379 | q.exec(); |
380 | add_hdd_proizvoditel(comboBox_13->currentText()); //äîáàâèì ïðîèçâîäèòåëÿ â ñïèñîê, åñëè åãî òàì íåò |
380 | add_hdd_proizvoditel(comboBox_13->currentText()); //äîáàâèì ïðîèçâîäèòåëÿ â ñïèñîê, åñëè åãî òàì íåò |
381 | emit componentAdd(); |
381 | emit componentAdd(); |
382 | close(); |
382 | close(); |
383 | // MainWindowImpl::initTreeWidget();
|
383 | // MainWindowImpl::initTreeWidget();
|
384 | }
|
384 | }
|
385 | break; |
385 | break; |
386 | 386 | ||
387 | 387 | ||
388 | case 2: //Ïðîöåññîðû |
388 | case 2: //Ïðîöåññîðû |
389 | {
|
389 | {
|
390 | QString id;
|
390 | QString id;
|
391 | id = getIdentifikator(label_7->text()); |
391 | id = getIdentifikator(label_7->text()); |
392 | q.prepare(tr("insert into processors (Ïðîèçâîäèòåëü, Ìîäåëü, ×àñòîòà , Ñëîò, Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà, Èíâåíòàðíûé_íîìåð, Ñåðèéíûé_íîìåð) " |
392 | q.prepare(tr("insert into processors (Ïðîèçâîäèòåëü, Ìîäåëü, ×àñòîòà , Ñëîò, Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà, Èíâåíòàðíûé_íîìåð, Ñåðèéíûé_íîìåð) " |
393 | "values (:proizvoditel, :model, :fqr, :slot, :sys_id, :inv_num, :serial_num)")); |
393 | "values (:proizvoditel, :model, :fqr, :slot, :sys_id, :inv_num, :serial_num)")); |
394 | q.bindValue(tr(":proizvoditel"), comboBox_9->currentText()); |
394 | q.bindValue(tr(":proizvoditel"), comboBox_9->currentText()); |
395 | q.bindValue(tr(":model"), comboBox_12->currentText()); |
395 | q.bindValue(tr(":model"), comboBox_12->currentText()); |
396 | q.bindValue(tr(":slot"), comboBox_11->currentText()); |
396 | q.bindValue(tr(":slot"), comboBox_11->currentText()); |
397 | q.bindValue(tr(":fqr"), comboBox_10->currentText()); |
397 | q.bindValue(tr(":fqr"), comboBox_10->currentText()); |
398 | q.bindValue(tr(":sys_id"), id); |
398 | q.bindValue(tr(":sys_id"), id); |
399 | q.bindValue(tr(":inv_num"), lineEdit->text()); |
399 | q.bindValue(tr(":inv_num"), lineEdit->text()); |
400 | q.bindValue(tr(":serial_num"), lineEdit_2->text()); |
400 | q.bindValue(tr(":serial_num"), lineEdit_2->text()); |
401 | q.exec(); |
401 | q.exec(); |
402 | add_mb_proizvoditel(comboBox_5->currentText()); |
402 | add_mb_proizvoditel(comboBox_5->currentText()); |
403 | add_cpu_proizvoditel(comboBox_9->currentText()); |
403 | add_cpu_proizvoditel(comboBox_9->currentText()); |
404 | add_mb_model(comboBox_5->currentText(), comboBox_6->currentText()); |
404 | add_mb_model(comboBox_5->currentText(), comboBox_6->currentText()); |
405 | add_cpu_model(comboBox_9->currentText(), comboBox_12->currentText()); |
405 | add_cpu_model(comboBox_9->currentText(), comboBox_12->currentText()); |
406 | 406 | ||
407 | emit componentAdd(); |
407 | emit componentAdd(); |
408 | close(); |
408 | close(); |
409 | }
|
409 | }
|
410 | break; |
410 | break; |
411 | 411 | ||
412 | case 3: //Ìàòåðèíñêèå ïëàòû |
412 | case 3: //Ìàòåðèíñêèå ïëàòû |
413 | {
|
413 | {
|
414 | QString id;
|
414 | QString id;
|
415 | id = getIdentifikator(label_7->text()); |
415 | id = getIdentifikator(label_7->text()); |
416 | q.prepare(tr("insert into matheboards (Ïðîèçâîäèòåëü, Ìîäåëü , Ñëîò, ×àñòîòà_øèíû, Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà, Èíâåíòàðíûé_íîìåð, Ñåðèéíûé_íîìåð) " |
416 | q.prepare(tr("insert into matheboards (Ïðîèçâîäèòåëü, Ìîäåëü , Ñëîò, ×àñòîòà_øèíû, Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà, Èíâåíòàðíûé_íîìåð, Ñåðèéíûé_íîìåð) " |
417 | "values (:proizvoditel, :model, :slot, :bus_fqr, :sys_id, :inv_num, :serial_num)")); |
417 | "values (:proizvoditel, :model, :slot, :bus_fqr, :sys_id, :inv_num, :serial_num)")); |
418 | q.bindValue(tr(":proizvoditel"), comboBox_5->currentText()); |
418 | q.bindValue(tr(":proizvoditel"), comboBox_5->currentText()); |
419 | q.bindValue(tr(":model"), comboBox_6->currentText()); |
419 | q.bindValue(tr(":model"), comboBox_6->currentText()); |
420 | q.bindValue(tr(":slot"), comboBox_7->currentText()); |
420 | q.bindValue(tr(":slot"), comboBox_7->currentText()); |
421 | q.bindValue(tr(":bus_fqr"), comboBox_8->currentText()); |
421 | q.bindValue(tr(":bus_fqr"), comboBox_8->currentText()); |
422 | q.bindValue(tr(":sys_id"), id); |
422 | q.bindValue(tr(":sys_id"), id); |
423 | q.bindValue(tr(":inv_num"), lineEdit->text()); |
423 | q.bindValue(tr(":inv_num"), lineEdit->text()); |
424 | q.bindValue(tr(":serial_num"), lineEdit_2->text()); |
424 | q.bindValue(tr(":serial_num"), lineEdit_2->text()); |
425 | q.exec(); |
425 | q.exec(); |
426 | add_mb_proizvoditel(comboBox_5->currentText()); |
426 | add_mb_proizvoditel(comboBox_5->currentText()); |
427 | add_mb_model(comboBox_5->currentText(), comboBox_6->currentText()); |
427 | add_mb_model(comboBox_5->currentText(), comboBox_6->currentText()); |
428 | emit componentAdd(); |
428 | emit componentAdd(); |
429 | close(); |
429 | close(); |
430 | }
|
430 | }
|
431 | break; |
431 | break; |
432 | 432 | ||
433 | case 4: //CD/DVD ïðèâîäû |
433 | case 4: //CD/DVD ïðèâîäû |
434 | {
|
434 | {
|
435 | QString id;
|
435 | QString id;
|
436 | id = getIdentifikator(label_7->text()); |
436 | id = getIdentifikator(label_7->text()); |
437 | q.prepare(tr("insert into cd_dvd (Òèï, Ïðîèçâîäèòåëü, Ñêîðîñòü, Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà, Èíâåíòàðíûé_íîìåð, Ñåðèéíûé_íîìåð) " |
437 | q.prepare(tr("insert into cd_dvd (Òèï, Ïðîèçâîäèòåëü, Ñêîðîñòü, Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà, Èíâåíòàðíûé_íîìåð, Ñåðèéíûé_íîìåð) " |
438 | "values (:tip, :proizvoditel, :skorost, :sys_id, :inv_num, :serial_num)")); |
438 | "values (:tip, :proizvoditel, :skorost, :sys_id, :inv_num, :serial_num)")); |
439 | q.bindValue(tr(":tip"), comboBox_16->currentText()); |
439 | q.bindValue(tr(":tip"), comboBox_16->currentText()); |
440 | q.bindValue(tr(":proizvoditel"), comboBox_17->currentText()); |
440 | q.bindValue(tr(":proizvoditel"), comboBox_17->currentText()); |
441 | q.bindValue(tr(":skorost"), comboBox_18->currentText()); |
441 | q.bindValue(tr(":skorost"), comboBox_18->currentText()); |
442 | q.bindValue(tr(":sys_id"), id); |
442 | q.bindValue(tr(":sys_id"), id); |
443 | q.bindValue(tr(":inv_num"), lineEdit->text()); |
443 | q.bindValue(tr(":inv_num"), lineEdit->text()); |
444 | q.bindValue(tr(":serial_num"), lineEdit_2->text()); |
444 | q.bindValue(tr(":serial_num"), lineEdit_2->text()); |
445 | q.exec(); |
445 | q.exec(); |
446 | add_mb_proizvoditel(comboBox_5->currentText()); |
446 | add_mb_proizvoditel(comboBox_5->currentText()); |
447 | add_mb_model(comboBox_5->currentText(), comboBox_6->currentText()); |
447 | add_mb_model(comboBox_5->currentText(), comboBox_6->currentText()); |
448 | emit componentAdd(); |
448 | emit componentAdd(); |
449 | close(); |
449 | close(); |
450 | }
|
450 | }
|
451 | 451 | ||
452 | 452 | ||
453 | break; |
453 | break; |
454 | 454 | ||
455 | case 5: //Âèäåîêàðòû |
455 | case 5: //Âèäåîêàðòû |
456 | {
|
456 | {
|
457 | 457 | ||
458 | QString id;
|
458 | QString id;
|
459 | id = getIdentifikator(label_7->text()); |
459 | id = getIdentifikator(label_7->text()); |
460 | q.prepare(tr("insert into videocards (Ïðîèçâîäèòåëü, Ìîäåëü , Èíòåðôåéñ, Ïàìÿòü, Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà, Èíâåíòàðíûé_íîìåð, Ñåðèéíûé_íîìåð) " |
460 | q.prepare(tr("insert into videocards (Ïðîèçâîäèòåëü, Ìîäåëü , Èíòåðôåéñ, Ïàìÿòü, Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà, Èíâåíòàðíûé_íîìåð, Ñåðèéíûé_íîìåð) " |
461 | "values (:proizvoditel, :model, :interface, :memory, :sys_id, :inv_num, :serial_num)")); |
461 | "values (:proizvoditel, :model, :interface, :memory, :sys_id, :inv_num, :serial_num)")); |
462 | q.bindValue(tr(":proizvoditel"), comboBox_19->currentText()); |
462 | q.bindValue(tr(":proizvoditel"), comboBox_19->currentText()); |
463 | q.bindValue(tr(":model"), comboBox_20->currentText()); |
463 | q.bindValue(tr(":model"), comboBox_20->currentText()); |
464 | q.bindValue(tr(":interface"), comboBox_21->currentText()); |
464 | q.bindValue(tr(":interface"), comboBox_21->currentText()); |
465 | q.bindValue(tr(":memory"), comboBox_22->currentText()); |
465 | q.bindValue(tr(":memory"), comboBox_22->currentText()); |
466 | q.bindValue(tr(":sys_id"), id); |
466 | q.bindValue(tr(":sys_id"), id); |
467 | q.bindValue(tr(":inv_num"), lineEdit->text()); |
467 | q.bindValue(tr(":inv_num"), lineEdit->text()); |
468 | q.bindValue(tr(":serial_num"), lineEdit_2->text()); |
468 | q.bindValue(tr(":serial_num"), lineEdit_2->text()); |
469 | q.exec(); |
469 | q.exec(); |
470 | add_video_proizvoditel(comboBox_19->currentText()); |
470 | add_video_proizvoditel(comboBox_19->currentText()); |
471 | add_video_model(comboBox_19->currentText(), comboBox_20->currentText()); |
471 | add_video_model(comboBox_19->currentText(), comboBox_20->currentText()); |
472 | emit componentAdd(); |
472 | emit componentAdd(); |
473 | close(); |
473 | close(); |
474 | }
|
474 | }
|
475 | break; |
475 | break; |
476 | 476 | ||
477 | case 6: //Çâóêîâûå êàðòû |
477 | case 6: //Çâóêîâûå êàðòû |
478 | {
|
478 | {
|
479 | 479 | ||
480 | QString id;
|
480 | QString id;
|
481 | id = getIdentifikator(label_7->text()); |
481 | id = getIdentifikator(label_7->text()); |
482 | q.prepare(tr("insert into soundcards (Ïðîèçâîäèòåëü, Ìîäåëü , Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà, Èíâåíòàðíûé_íîìåð, Ñåðèéíûé_íîìåð) " |
482 | q.prepare(tr("insert into soundcards (Ïðîèçâîäèòåëü, Ìîäåëü , Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà, Èíâåíòàðíûé_íîìåð, Ñåðèéíûé_íîìåð) " |
483 | "values (:proizvoditel, :model, :sys_id, :inv_num, :serial_num)")); |
483 | "values (:proizvoditel, :model, :sys_id, :inv_num, :serial_num)")); |
484 | q.bindValue(tr(":proizvoditel"), comboBox_23->currentText()); |
484 | q.bindValue(tr(":proizvoditel"), comboBox_23->currentText()); |
485 | q.bindValue(tr(":model"), comboBox_24->currentText()); |
485 | q.bindValue(tr(":model"), comboBox_24->currentText()); |
486 | q.bindValue(tr(":sys_id"), id); |
486 | q.bindValue(tr(":sys_id"), id); |
487 | q.bindValue(tr(":inv_num"), lineEdit->text()); |
487 | q.bindValue(tr(":inv_num"), lineEdit->text()); |
488 | q.bindValue(tr(":serial_num"), lineEdit_2->text()); |
488 | q.bindValue(tr(":serial_num"), lineEdit_2->text()); |
489 | q.exec(); |
489 | q.exec(); |
490 | add_mb_proizvoditel(comboBox_5->currentText()); |
490 | add_mb_proizvoditel(comboBox_5->currentText()); |
491 | add_mb_model(comboBox_5->currentText(), comboBox_6->currentText()); |
491 | add_mb_model(comboBox_5->currentText(), comboBox_6->currentText()); |
492 | emit componentAdd(); |
492 | emit componentAdd(); |
493 | close(); |
493 | close(); |
494 | 494 | ||
495 | }
|
495 | }
|
496 | break; |
496 | break; |
497 | case 7: //Ñåòåâûå êàðòû |
497 | case 7: //Ñåòåâûå êàðòû |
498 | {
|
498 | {
|
499 | 499 | ||
500 | QString id;
|
500 | QString id;
|
501 | id = getIdentifikator(label_7->text()); |
501 | id = getIdentifikator(label_7->text()); |
502 | q.prepare(tr("insert into lancards (Ïðîèçâîäèòåëü, Ìîäåëü , Ñêîðîñòü_ïåðåäà÷è_äàííûõ, Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà, Èíâåíòàðíûé_íîìåð, Ñåðèéíûé_íîìåð) " |
502 | q.prepare(tr("insert into lancards (Ïðîèçâîäèòåëü, Ìîäåëü , Ñêîðîñòü_ïåðåäà÷è_äàííûõ, Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà, Èíâåíòàðíûé_íîìåð, Ñåðèéíûé_íîìåð) " |
503 | "values (:proizvoditel, :model, :spd, :sys_id, :inv_num, :serial_num)")); |
503 | "values (:proizvoditel, :model, :spd, :sys_id, :inv_num, :serial_num)")); |
504 | q.bindValue(tr(":proizvoditel"), comboBox_25->currentText()); |
504 | q.bindValue(tr(":proizvoditel"), comboBox_25->currentText()); |
505 | q.bindValue(tr(":model"), comboBox_26->currentText()); |
505 | q.bindValue(tr(":model"), comboBox_26->currentText()); |
506 | q.bindValue(tr(":spd"), comboBox_27->currentText()); |
506 | q.bindValue(tr(":spd"), comboBox_27->currentText()); |
507 | q.bindValue(tr(":sys_id"), id); |
507 | q.bindValue(tr(":sys_id"), id); |
508 | q.bindValue(tr(":inv_num"), lineEdit->text()); |
508 | q.bindValue(tr(":inv_num"), lineEdit->text()); |
509 | q.bindValue(tr(":serial_num"), lineEdit_2->text()); |
509 | q.bindValue(tr(":serial_num"), lineEdit_2->text()); |
510 | q.exec(); |
510 | q.exec(); |
511 | add_mb_proizvoditel(comboBox_5->currentText()); |
511 | add_mb_proizvoditel(comboBox_5->currentText()); |
512 | add_mb_model(comboBox_5->currentText(), comboBox_6->currentText()); |
512 | add_mb_model(comboBox_5->currentText(), comboBox_6->currentText()); |
513 | emit componentAdd(); |
513 | emit componentAdd(); |
514 | close(); |
514 | close(); |
515 | 515 | ||
516 | }
|
516 | }
|
517 | break; |
517 | break; |
518 | 518 | ||
519 | default: |
519 | default: |
520 | 520 | ||
521 | 521 | ||
522 | break; |
522 | break; |
523 | }
|
523 | }
|
524 | 524 | ||
525 | void componentAdd(); |
525 | void componentAdd(); |
526 | 526 | ||
527 | 527 | ||
528 | 528 | ||
529 | 529 | ||
530 | 530 | ||
531 | 531 | ||
532 | }
|
532 | }
|
533 | 533 | ||
534 | QString addmemoryForm::getIdentifikator(QString inventar_num){ |
534 | QString addmemoryForm::getIdentifikator(QString inventar_num){ |
535 | QSqlQuery q;
|
535 | QSqlQuery q;
|
536 | QString sqltext;
|
536 | QString sqltext;
|
537 | int field_id; |
537 | int field_id; |
538 | QString identifikator;
|
538 | QString identifikator;
|
539 | if (inventar_num == tr("Íà ñêëàä")) return tr("1"); |
539 | if (inventar_num == tr("Íà ñêëàä")) return tr("1"); |
540 | sqltext = tr("select * from system_blocks where system_blocks.Èíâåíòàðíûé_íîìåð = \""); |
540 | sqltext = tr("select * from system_blocks where system_blocks.Èíâåíòàðíûé_íîìåð = \""); |
541 | sqltext.append(inventar_num); |
541 | sqltext.append(inventar_num); |
542 | sqltext.append(tr("\"")); |
542 | sqltext.append(tr("\"")); |
543 | q.prepare(sqltext); |
543 | q.prepare(sqltext); |
544 | q.exec(); |
544 | q.exec(); |
545 | field_id = q.record().indexOf(tr("Èäåíòèôèêàòîð")); |
545 | field_id = q.record().indexOf(tr("Èäåíòèôèêàòîð")); |
546 | if (q.next()) {identifikator = q.value(field_id).toString();} |
546 | if (q.next()) {identifikator = q.value(field_id).toString();} |
547 | else { |
547 | else { |
548 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
548 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
549 | this, // Ðîäèòåëüñêèé âèäæåò. |
549 | this, // Ðîäèòåëüñêèé âèäæåò. |
550 | QObject::tr("Îøèáêà ââîäà äàííûõ"), // Çàãîëîâîê. |
550 | QObject::tr("Îøèáêà ââîäà äàííûõ"), // Çàãîëîâîê. |
551 | tr("Íåâîçìîæíî îïðåäåëèòü èäåíòèôèêàòîð ñèñòåìíîãî áëîêà")); // Òåêñò ñîîáùåíèÿ. |
551 | tr("Íåâîçìîæíî îïðåäåëèòü èäåíòèôèêàòîð ñèñòåìíîãî áëîêà")); // Òåêñò ñîîáùåíèÿ. |
552 | return identifikator; |
552 | return identifikator; |
553 | 553 | ||
554 | 554 | ||
555 | }; |
555 | }; |
556 | return identifikator; |
556 | return identifikator; |
557 | }
|
557 | }
|
558 | 558 | ||
559 | 559 | ||
560 | 560 | ||
561 | 561 | ||
562 | 562 | ||
563 | 563 | ||
564 | void addmemoryForm::add_video_proizvoditel(QString brend){ |
564 | void addmemoryForm::add_video_proizvoditel(QString brend){ |
565 | QSqlQuery q;
|
565 | QSqlQuery q;
|
566 | QString sqltext;
|
566 | QString sqltext;
|
567 | int field_proizvoditel; |
567 | int field_proizvoditel; |
568 | QString proizv;
|
568 | QString proizv;
|
569 | sqltext = tr("select * from proizvoditeli_video where proizvoditeli_video.Ïðîèçâîäèòåëü = \""); |
569 | sqltext = tr("select * from proizvoditeli_video where proizvoditeli_video.Ïðîèçâîäèòåëü = \""); |
570 | sqltext.append(brend); |
570 | sqltext.append(brend); |
571 | sqltext.append(tr("\"")); |
571 | sqltext.append(tr("\"")); |
572 | q.prepare(sqltext); |
572 | q.prepare(sqltext); |
573 | q.exec(); |
573 | q.exec(); |
574 | field_proizvoditel = q.record().indexOf(tr("Ïðîèçâîäèòåëü")); |
574 | field_proizvoditel = q.record().indexOf(tr("Ïðîèçâîäèòåëü")); |
575 | if (q.next()) {return;} |
575 | if (q.next()) {return;} |
576 | else { |
576 | else { |
577 | q.prepare(tr("insert into proizvoditeli_video (Ïðîèçâîäèòåëü) " |
577 | q.prepare(tr("insert into proizvoditeli_video (Ïðîèçâîäèòåëü) " |
578 | "values (:proizvoditel)")); |
578 | "values (:proizvoditel)")); |
579 | q.bindValue(tr(":proizvoditel"), brend); |
579 | q.bindValue(tr(":proizvoditel"), brend); |
580 | q.exec(); |
580 | q.exec(); |
581 | }
|
581 | }
|
582 | 582 | ||
583 | }
|
583 | }
|
584 | 584 | ||
585 | 585 | ||
586 | void addmemoryForm::add_mem_proizvoditel(QString brend){ |
586 | void addmemoryForm::add_mem_proizvoditel(QString brend){ |
587 | QSqlQuery q;
|
587 | QSqlQuery q;
|
588 | QString sqltext;
|
588 | QString sqltext;
|
589 | int field_proizvoditel; |
589 | int field_proizvoditel; |
590 | QString proizv;
|
590 | QString proizv;
|
591 | sqltext = tr("select * from proizvoditeli_pamyati where proizvoditeli_pamyati.Ïðîèçâîäèòåëü = \""); |
591 | sqltext = tr("select * from proizvoditeli_pamyati where proizvoditeli_pamyati.Ïðîèçâîäèòåëü = \""); |
592 | sqltext.append(brend); |
592 | sqltext.append(brend); |
593 | sqltext.append(tr("\"")); |
593 | sqltext.append(tr("\"")); |
594 | q.prepare(sqltext); |
594 | q.prepare(sqltext); |
595 | q.exec(); |
595 | q.exec(); |
596 | field_proizvoditel = q.record().indexOf(tr("Ïðîèçâîäèòåëü")); |
596 | field_proizvoditel = q.record().indexOf(tr("Ïðîèçâîäèòåëü")); |
597 | if (q.next()) {return;} |
597 | if (q.next()) {return;} |
598 | else { |
598 | else { |
599 | q.prepare(tr("insert into proizvoditeli_pamyati (Ïðîèçâîäèòåëü) " |
599 | q.prepare(tr("insert into proizvoditeli_pamyati (Ïðîèçâîäèòåëü) " |
600 | "values (:proizvoditel)")); |
600 | "values (:proizvoditel)")); |
601 | q.bindValue(tr(":proizvoditel"), brend); |
601 | q.bindValue(tr(":proizvoditel"), brend); |
602 | q.exec(); |
602 | q.exec(); |
603 | }
|
603 | }
|
604 | 604 | ||
605 | }
|
605 | }
|
606 | 606 | ||
607 | 607 | ||
608 | void addmemoryForm::add_mb_proizvoditel(QString brend){ |
608 | void addmemoryForm::add_mb_proizvoditel(QString brend){ |
609 | QSqlQuery q;
|
609 | QSqlQuery q;
|
610 | QString sqltext;
|
610 | QString sqltext;
|
611 | int field_proizvoditel; |
611 | int field_proizvoditel; |
612 | QString proizv;
|
612 | QString proizv;
|
613 | sqltext = tr("select * from proizvoditeli_mb where proizvoditeli_mb.Ïðîèçâîäèòåëü = \""); |
613 | sqltext = tr("select * from proizvoditeli_mb where proizvoditeli_mb.Ïðîèçâîäèòåëü = \""); |
614 | sqltext.append(brend); |
614 | sqltext.append(brend); |
615 | sqltext.append(tr("\"")); |
615 | sqltext.append(tr("\"")); |
616 | q.prepare(sqltext); |
616 | q.prepare(sqltext); |
617 | q.exec(); |
617 | q.exec(); |
618 | field_proizvoditel = q.record().indexOf(tr("Ïðîèçâîäèòåëü")); |
618 | field_proizvoditel = q.record().indexOf(tr("Ïðîèçâîäèòåëü")); |
619 | if (q.next()) {return;} |
619 | if (q.next()) {return;} |
620 | else { |
620 | else { |
621 | q.prepare(tr("insert into proizvoditeli_mb (Ïðîèçâîäèòåëü) " |
621 | q.prepare(tr("insert into proizvoditeli_mb (Ïðîèçâîäèòåëü) " |
622 | "values (:proizvoditel)")); |
622 | "values (:proizvoditel)")); |
623 | q.bindValue(tr(":proizvoditel"), brend); |
623 | q.bindValue(tr(":proizvoditel"), brend); |
624 | q.exec(); |
624 | q.exec(); |
625 | }
|
625 | }
|
626 | 626 | ||
627 | }
|
627 | }
|
628 | 628 | ||
629 | void addmemoryForm::add_hdd_proizvoditel(QString brend){ |
629 | void addmemoryForm::add_hdd_proizvoditel(QString brend){ |
630 | QSqlQuery q;
|
630 | QSqlQuery q;
|
631 | QString sqltext;
|
631 | QString sqltext;
|
632 | int field_proizvoditel; |
632 | int field_proizvoditel; |
633 | QString proizv;
|
633 | QString proizv;
|
634 | sqltext = tr("select * from proizvoditeli_hdd where proizvoditeli_hdd.Ïðîèçâîäèòåëü = \""); |
634 | sqltext = tr("select * from proizvoditeli_hdd where proizvoditeli_hdd.Ïðîèçâîäèòåëü = \""); |
635 | sqltext.append(brend); |
635 | sqltext.append(brend); |
636 | sqltext.append(tr("\"")); |
636 | sqltext.append(tr("\"")); |
637 | q.prepare(sqltext); |
637 | q.prepare(sqltext); |
638 | q.exec(); |
638 | q.exec(); |
639 | field_proizvoditel = q.record().indexOf(tr("Ïðîèçâîäèòåëü")); |
639 | field_proizvoditel = q.record().indexOf(tr("Ïðîèçâîäèòåëü")); |
640 | if (q.next()) {return;} |
640 | if (q.next()) {return;} |
641 | else { |
641 | else { |
642 | q.prepare(tr("insert into proizvoditeli_hdd (Ïðîèçâîäèòåëü) " |
642 | q.prepare(tr("insert into proizvoditeli_hdd (Ïðîèçâîäèòåëü) " |
643 | "values (:proizvoditel)")); |
643 | "values (:proizvoditel)")); |
644 | q.bindValue(tr(":proizvoditel"), brend); |
644 | q.bindValue(tr(":proizvoditel"), brend); |
645 | q.exec(); |
645 | q.exec(); |
646 | }
|
646 | }
|
647 | 647 | ||
648 | }
|
648 | }
|
649 | 649 | ||
650 | void addmemoryForm::add_cpu_proizvoditel(QString brend){ |
650 | void addmemoryForm::add_cpu_proizvoditel(QString brend){ |
651 | QSqlQuery q;
|
651 | QSqlQuery q;
|
652 | QString sqltext;
|
652 | QString sqltext;
|
653 | int field_proizvoditel; |
653 | int field_proizvoditel; |
654 | QString proizv;
|
654 | QString proizv;
|
655 | sqltext = tr("select * from proizvoditeli_cpu where proizvoditeli_hdd.Ïðîèçâîäèòåëü = \""); |
655 | sqltext = tr("select * from proizvoditeli_cpu where proizvoditeli_hdd.Ïðîèçâîäèòåëü = \""); |
656 | sqltext.append(brend); |
656 | sqltext.append(brend); |
657 | sqltext.append(tr("\"")); |
657 | sqltext.append(tr("\"")); |
658 | q.prepare(sqltext); |
658 | q.prepare(sqltext); |
659 | q.exec(); |
659 | q.exec(); |
660 | field_proizvoditel = q.record().indexOf(tr("Ïðîèçâîäèòåëü")); |
660 | field_proizvoditel = q.record().indexOf(tr("Ïðîèçâîäèòåëü")); |
661 | if (q.next()) {return;} |
661 | if (q.next()) {return;} |
662 | else { |
662 | else { |
663 | q.prepare(tr("insert into proizvoditeli_cpu (Ïðîèçâîäèòåëü) " |
663 | q.prepare(tr("insert into proizvoditeli_cpu (Ïðîèçâîäèòåëü) " |
664 | "values (:proizvoditel)")); |
664 | "values (:proizvoditel)")); |
665 | q.bindValue(tr(":proizvoditel"), brend); |
665 | q.bindValue(tr(":proizvoditel"), brend); |
666 | q.exec(); |
666 | q.exec(); |
667 | }
|
667 | }
|
668 | 668 | ||
669 | }
|
669 | }
|
670 | 670 | ||
671 | void addmemoryForm::add_mb_model(QString brend, QString model){ |
671 | void addmemoryForm::add_mb_model(QString brend, QString model){ |
672 | QSqlQuery q;
|
672 | QSqlQuery q;
|
673 | QString sqltext;
|
673 | QString sqltext;
|
674 | int field_proizvoditel; |
674 | int field_proizvoditel; |
675 | QString proizv;
|
675 | QString proizv;
|
676 | sqltext = tr("select * from Ìîäåëè_ìàòåðèíñêèõ_ïëàò where Ìîäåëè_ìàòåðèíñêèõ_ïëàò.Ïðîèçâîäèòåëü = \""); |
676 | sqltext = tr("select * from Ìîäåëè_ìàòåðèíñêèõ_ïëàò where Ìîäåëè_ìàòåðèíñêèõ_ïëàò.Ïðîèçâîäèòåëü = \""); |
677 | sqltext.append(brend); |
677 | sqltext.append(brend); |
678 | sqltext.append(tr("\" and Ìîäåëè_ìàòåðèíñêèõ_ïëàò.Ìîäåëü = \"")); |
678 | sqltext.append(tr("\" and Ìîäåëè_ìàòåðèíñêèõ_ïëàò.Ìîäåëü = \"")); |
679 | sqltext.append(model); |
679 | sqltext.append(model); |
680 | sqltext.append(tr("\"")); |
680 | sqltext.append(tr("\"")); |
681 | q.prepare(sqltext); |
681 | q.prepare(sqltext); |
682 | q.exec(); |
682 | q.exec(); |
683 | field_proizvoditel = q.record().indexOf(tr("Ïðîèçâîäèòåëü")); |
683 | field_proizvoditel = q.record().indexOf(tr("Ïðîèçâîäèòåëü")); |
684 | if (q.next()) {return;} |
684 | if (q.next()) {return;} |
685 | else { |
685 | else { |
686 | q.prepare(tr("insert into Ìîäåëè_ìàòåðèíñêèõ_ïëàò (Ìîäåëü, Ïðîèçâîäèòåëü) " |
686 | q.prepare(tr("insert into Ìîäåëè_ìàòåðèíñêèõ_ïëàò (Ìîäåëü, Ïðîèçâîäèòåëü) " |
687 | "values (:model, :proizvoditel)")); |
687 | "values (:model, :proizvoditel)")); |
688 | q.bindValue(tr(":model"), model); |
688 | q.bindValue(tr(":model"), model); |
689 | q.bindValue(tr(":proizvoditel"), brend); |
689 | q.bindValue(tr(":proizvoditel"), brend); |
690 | q.exec(); |
690 | q.exec(); |
691 | }
|
691 | }
|
692 | 692 | ||
693 | }
|
693 | }
|
694 | 694 | ||
695 | 695 | ||
696 | 696 | ||
697 | void addmemoryForm::add_cpu_model(QString brend, QString model){ |
697 | void addmemoryForm::add_cpu_model(QString brend, QString model){ |
698 | QSqlQuery q;
|
698 | QSqlQuery q;
|
699 | QString sqltext;
|
699 | QString sqltext;
|
700 | int field_proizvoditel; |
700 | int field_proizvoditel; |
701 | QString proizv;
|
701 | QString proizv;
|
702 | sqltext = tr("select * from processor_models where processor_models.Ïðîèçâîäèòåëü = \""); |
702 | sqltext = tr("select * from processor_models where processor_models.Ïðîèçâîäèòåëü = \""); |
703 | sqltext.append(brend); |
703 | sqltext.append(brend); |
704 | sqltext.append(tr("\" and processor_models.Ìîäåëü = \"")); |
704 | sqltext.append(tr("\" and processor_models.Ìîäåëü = \"")); |
705 | sqltext.append(model); |
705 | sqltext.append(model); |
706 | sqltext.append(tr("\"")); |
706 | sqltext.append(tr("\"")); |
707 | q.prepare(sqltext); |
707 | q.prepare(sqltext); |
708 | q.exec(); |
708 | q.exec(); |
709 | field_proizvoditel = q.record().indexOf(tr("Ïðîèçâîäèòåëü")); |
709 | field_proizvoditel = q.record().indexOf(tr("Ïðîèçâîäèòåëü")); |
710 | if (q.next()) {return;} |
710 | if (q.next()) {return;} |
711 | else { |
711 | else { |
712 | q.prepare(tr("insert into processor_models (Ìîäåëü, Ïðîèçâîäèòåëü) " |
712 | q.prepare(tr("insert into processor_models (Ìîäåëü, Ïðîèçâîäèòåëü) " |
713 | "values (:model, :proizvoditel)")); |
713 | "values (:model, :proizvoditel)")); |
714 | q.bindValue(tr(":model"), model); |
714 | q.bindValue(tr(":model"), model); |
715 | q.bindValue(tr(":proizvoditel"), brend); |
715 | q.bindValue(tr(":proizvoditel"), brend); |
716 | q.exec(); |
716 | q.exec(); |
717 | }
|
717 | }
|
718 | 718 | ||
719 | }
|
719 | }
|
720 | 720 | ||
721 | void addmemoryForm::add_video_model(QString brend, QString model){ |
721 | void addmemoryForm::add_video_model(QString brend, QString model){ |
722 | QSqlQuery q;
|
722 | QSqlQuery q;
|
723 | QString sqltext;
|
723 | QString sqltext;
|
724 | int field_proizvoditel; |
724 | int field_proizvoditel; |
725 | QString proizv;
|
725 | QString proizv;
|
726 | sqltext = tr("select * from video_models where video_models.Ïðîèçâîäèòåëü = \""); |
726 | sqltext = tr("select * from video_models where video_models.Ïðîèçâîäèòåëü = \""); |
727 | sqltext.append(brend); |
727 | sqltext.append(brend); |
728 | sqltext.append(tr("\" and video_models.Ìîäåëü = \"")); |
728 | sqltext.append(tr("\" and video_models.Ìîäåëü = \"")); |
729 | sqltext.append(model); |
729 | sqltext.append(model); |
730 | sqltext.append(tr("\"")); |
730 | sqltext.append(tr("\"")); |
731 | q.prepare(sqltext); |
731 | q.prepare(sqltext); |
732 | q.exec(); |
732 | q.exec(); |
733 | field_proizvoditel = q.record().indexOf(tr("Ïðîèçâîäèòåëü")); |
733 | field_proizvoditel = q.record().indexOf(tr("Ïðîèçâîäèòåëü")); |
734 | if (q.next()) {return;} |
734 | if (q.next()) {return;} |
735 | else { |
735 | else { |
736 | q.prepare(tr("insert into video_models (Ìîäåëü, Ïðîèçâîäèòåëü) " |
736 | q.prepare(tr("insert into video_models (Ìîäåëü, Ïðîèçâîäèòåëü) " |
737 | "values (:model, :proizvoditel)")); |
737 | "values (:model, :proizvoditel)")); |
738 | q.bindValue(tr(":model"), model); |
738 | q.bindValue(tr(":model"), model); |
739 | q.bindValue(tr(":proizvoditel"), brend); |
739 | q.bindValue(tr(":proizvoditel"), brend); |
740 | q.exec(); |
740 | q.exec(); |
741 | }
|
741 | }
|
742 | 742 | ||
743 | }
|
743 | }
|
744 | 744 | ||
745 | 745 | ||
746 | //void addmemoryForm::hide (){
|
746 | //void addmemoryForm::hide (){
|
747 | // treeWidget->setEnabled(true);
|
747 | // treeWidget->setEnabled(true);
|
748 | //}
|
748 | //}
|
749 | 749 | ||
750 | void addmemoryForm::closeEvent ( QCloseEvent * event ) { |
750 | void addmemoryForm::closeEvent ( QCloseEvent * event ) { |
751 | emit formClose(); |
751 | emit formClose(); |
752 | }
|
752 | }
|
753 | 753 | ||
754 | 754 | ||
755 | 755 |