Авторство |
Последнее изменение |
Открыть журнал
| Скачать
| RSS
#include "addsysblockform.h"
#include "mainwindowimpl.h"
// place your code here
addsysblockForm::addsysblockForm()
: QDialog(){
setupUi(this);
connect(buttonBox, SIGNAL(accepted()), this, SLOT(addNewSysBlockSlot()));
}
void addsysblockForm::closeEvent ( QCloseEvent * event ) {
emit formClose();
}
void addsysblockForm::addNewSysBlockSlot(){
int i;
i++;
//test cvs
QDate data_p;
QSqlQuery q;
QString sqltext;
int field_fio, field_identifikator, field_inventar_num;
QString serial_num, inventar_num, data_str, garant_str, id, fio, id_otdela;
bool ok;
if (lineEdit_2->text()==""){
QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
this, // Ðîäèòåëüñêèé âèäæåò.
QObject::tr("Îøèáêà äîáîâëåíèÿ ñèñòåìíîãî áëîêà íà ñêëàä"), // Çàãîëîâîê.
tr("Âû íå ââåëè èíâåíòàðíûé íîìåð ñèñòåìíîãî áëîêà!")); // Òåêñò ñîîáùåíèÿ.
return;
}
sqltext = tr("select * from system_blocks where system_blocks.Èíâåíòàðíûé_íîìåð = \"");
sqltext.append(lineEdit_2->text());
sqltext.append(tr("\""));
q.prepare(sqltext);
ok = q.exec();
field_inventar_num = q.record().indexOf(tr("Èíâåíòàðíûé_íîìåð"));
if (q.next()) {
QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
this, // Ðîäèòåëüñêèé âèäæåò.
QObject::tr("Îøèáêà äîáîâëåíèÿ ñèñòåìíîãî áëîêà íà ñêëàä!"), // Çàãîëîâîê.
tr("Ñèñòåìíûé áëîê ñ òàêèì èíâåíòàðíûì íîìåðîì óæå åñòü â áàçå äàííûõ!")); // Òåêñò ñîîáùåíèÿ.
return;
}
else {
q.clear();
data_p = dateEdit->date();
data_str = data_p.toString(tr("yyyy-MM-dd"));
garant_str = QVariant(spinBox->value()).toString();
q.prepare(tr("insert into system_blocks (Ñåðèéíûé_íîìåð, Èíâåíòàðíûé_íîìåð, Äàòà_ïîêóïêè, Ñðîê_ãàðàíòèè, Èäåíòèôèêàòîð_îòâåòñòâåííîãî_ëèöà) "
"values (:ser_num, :inv_num, :date, :garant, :id_otv_lica)"));
q.bindValue(tr(":ser_num"), lineEdit->text());
q.bindValue(tr(":inv_num"), lineEdit_2->text());
q.bindValue(tr(":date"), data_str);
q.bindValue(tr(":garant"), garant_str);
q.bindValue(tr(":id_otv_lica"), tr("1"));
ok = q.exec();
emit componentAdd();
close();
}
}