WebSVN - OpenInventory - Различия - Редакция 6 и 17


#include "addmemoryform.h"
#include "mainwindowimpl.h"

// place your code here
addmemoryForm::addmemoryForm(  )
        : QWidget()
{
//      QStringList proizv_list; //ñïèñîê ïðîèçâîäèòåëåé ïàìÿòè
        setupUi(this);
//      proizv_list = getManufacturiesList();
//      comboBox->addItems(proizv_list);
        // TODO
}

QStringList addmemoryForm::getManufacturiesList(){
        QStringList mnfctrlist;
        QString mnfctSqlText, tmp;
        QSqlQuery qproiz;
        int field_proizvoditel;
        mnfctSqlText = tr("select * from proizvoditeli_pamyati");
//      QSqlQuery qns(tr("SET NAMES utf8"));
        qproiz.prepare(mnfctSqlText);
        qproiz.exec();
//      QSqlQuery qproiz("SELECT * FROM Ïðîèçâîäèòåëè_ïàìÿòè");
        field_proizvoditel = qproiz.record().indexOf(tr("Ïðîèçâîäèòåëü"));
        mnfctrlist.clear();
        while (qproiz.next()){
                tmp = qproiz.value(field_proizvoditel).toString();
//      comboBox->addItem(tmp);
                mnfctrlist.append (tmp);
        }
//      comboBox->addItems(mnfctrlist);
        return mnfctrlist;
}


QStringList addmemoryForm::getManufacturiesListVIDEO(){
        QStringList mnfctrlist;
        QString mnfctSqlText, tmp;
        QSqlQuery qproiz;
        int field_proizvoditel;
        mnfctSqlText = tr("select * from proizvoditeli_video");
//      QSqlQuery qns(tr("SET NAMES utf8"));
        qproiz.prepare(mnfctSqlText);
        qproiz.exec();
//      QSqlQuery qproiz("SELECT * FROM Ïðîèçâîäèòåëè_ïàìÿòè");
        field_proizvoditel = qproiz.record().indexOf(tr("Ïðîèçâîäèòåëü"));
        mnfctrlist.clear();
        while (qproiz.next()){
                tmp = qproiz.value(field_proizvoditel).toString();
//      comboBox->addItem(tmp);
                mnfctrlist.append (tmp);
        }
//      comboBox->addItems(mnfctrlist);
        return mnfctrlist;
}




QStringList addmemoryForm::getManufacturiesListMB(){
        QStringList mnfctrlist;
        QString mnfctSqlText, tmp;
        QSqlQuery qproiz;
        int field_proizvoditel;
        mnfctSqlText = tr("select * from proizvoditeli_mb");
//      QSqlQuery qns(tr("SET NAMES utf8"));
        qproiz.prepare(mnfctSqlText);
        qproiz.exec();
//      QSqlQuery qproiz("SELECT * FROM Ïðîèçâîäèòåëè_ïàìÿòè");
        field_proizvoditel = qproiz.record().indexOf(tr("Ïðîèçâîäèòåëü"));
        mnfctrlist.clear();
        while (qproiz.next()){
                tmp = qproiz.value(field_proizvoditel).toString();
//      comboBox->addItem(tmp);
                mnfctrlist.append (tmp);
        }
//      comboBox->addItems(mnfctrlist);
        return mnfctrlist;
}


QStringList addmemoryForm::getManufacturiesListHDD(){
        QStringList mnfctrlist;
        QString mnfctSqlText, tmp;
        QSqlQuery qproiz;
        int field_proizvoditel;
        mnfctSqlText = tr("select * from proizvoditeli_hdd");
//      QSqlQuery qns(tr("SET NAMES utf8"));
        qproiz.prepare(mnfctSqlText);
        qproiz.exec();
//      QSqlQuery qproiz("SELECT * FROM Ïðîèçâîäèòåëè_ïàìÿòè");
        field_proizvoditel = qproiz.record().indexOf(tr("Ïðîèçâîäèòåëü"));
        mnfctrlist.clear();
        while (qproiz.next()){
                tmp = qproiz.value(field_proizvoditel).toString();
//      comboBox->addItem(tmp);
                mnfctrlist.append (tmp);
        }
//      comboBox->addItems(mnfctrlist);
        return mnfctrlist;
}

QStringList addmemoryForm::getManufacturiesListCPU(){
        QStringList mnfctrlist;
        QString mnfctSqlText, tmp;
        QSqlQuery qproiz;
        int field_proizvoditel;
        mnfctSqlText = tr("select * from proizvoditeli_cpu");
//      QSqlQuery qns(tr("SET NAMES utf8"));
        qproiz.prepare(mnfctSqlText);
        qproiz.exec();
//      QSqlQuery qproiz("SELECT * FROM Ïðîèçâîäèòåëè_ïàìÿòè");
        field_proizvoditel = qproiz.record().indexOf(tr("Ïðîèçâîäèòåëü"));
        mnfctrlist.clear();
        while (qproiz.next()){
                tmp = qproiz.value(field_proizvoditel).toString();
//      comboBox->addItem(tmp);
                mnfctrlist.append (tmp);
        }
//      comboBox->addItems(mnfctrlist);
        return mnfctrlist;
}



QStringList addmemoryForm::getModelListMB(QString proizvoditel){
        QStringList modelList;
        QString SqlText, tmp;
        QSqlQuery qmodel;
        int field_model;
        SqlText = tr("select * from Ìîäåëè_ìàòåðèíñêèõ_ïëàò where Ìîäåëè_ìàòåðèíñêèõ_ïëàò.Ïðîèçâîäèòåëü = \"");
        SqlText.append(proizvoditel);
        SqlText.append(tr("\""));
        qmodel.prepare(SqlText);
        qmodel.exec();
        field_model = qmodel.record().indexOf(tr("Ìîäåëü"));
        modelList.clear();
        while (qmodel.next()){
                tmp = qmodel.value(field_model).toString();
//      comboBox->addItem(tmp);
                modelList.append (tmp);
        }
//      comboBox->addItems(mnfctrlist);
        return modelList;
}



QStringList addmemoryForm::getModelListVIDEO(QString proizvoditel){
        QStringList modelList;
        QString SqlText, tmp;
        QSqlQuery qmodel;
        int field_model;
        SqlText = tr("select * from video_models where video_models.Ïðîèçâîäèòåëü = \"");
        SqlText.append(proizvoditel);
        SqlText.append(tr("\""));
        qmodel.prepare(SqlText);
        qmodel.exec();
        field_model = qmodel.record().indexOf(tr("Ìîäåëü"));
        modelList.clear();
        while (qmodel.next()){
                tmp = qmodel.value(field_model).toString();
//      comboBox->addItem(tmp);
                modelList.append (tmp);
        }
//      comboBox->addItems(mnfctrlist);
        return modelList;
}



QStringList addmemoryForm::getModelListCPU(QString proizvoditel){
        QStringList modelList;
        QString SqlText, tmp;
        QSqlQuery qmodel;
        int field_model;
        SqlText = tr("select * from processor_models where processor_models.Ïðîèçâîäèòåëü = \"");
        SqlText.append(proizvoditel);
        SqlText.append(tr("\""));
        qmodel.prepare(SqlText);
        qmodel.exec();
        field_model = qmodel.record().indexOf(tr("Ìîäåëü"));
        modelList.clear();
        while (qmodel.next()){
                tmp = qmodel.value(field_model).toString();
//      comboBox->addItem(tmp);
                modelList.append (tmp);
        }
//      comboBox->addItems(mnfctrlist);
        return modelList;
}


QStringList addmemoryForm::getSystemBlockList(){
        QStringList sysBlockList;
        bool b1, b2;
        QString tmp, SerialNum, InventarNum, DataPokypki, SrokGarantii, UserId, Identifikator;
        int field_identifikator, field_serial_num, field_inventar_num, field_data_pokypki, field_srok_garantii, field_user_id;
        QSqlQuery qysBlockList(tr("select * from system_blocks"));
        field_serial_num = qysBlockList.record().indexOf(tr("Ñåðèéíûé_íîìåð"));
        field_inventar_num = qysBlockList.record().indexOf(tr("Èíâåíòàðíûé_íîìåð"));
        field_data_pokypki = qysBlockList.record().indexOf(tr("Äàòà_ïîêóïêè"));
        field_srok_garantii = qysBlockList.record().indexOf(tr("Ñðîê_ãàðàíòèè"));
        field_user_id = qysBlockList.record().indexOf(tr("Èäåíòèôèêàòîð_îòâåòñòâåííîãî_ëèöà"));
        field_identifikator = qysBlockList.record().indexOf(tr("Èäåíòèôèêàòîð"));
        while (qysBlockList.next()){
        tmp = "";
        SerialNum = qysBlockList.value(field_serial_num).toString();
        InventarNum = qysBlockList.value(field_inventar_num).toString();
        DataPokypki = qysBlockList.value(field_data_pokypki).toString();
        SrokGarantii = qysBlockList.value(field_srok_garantii).toString();
        UserId = qysBlockList.value(field_user_id).toString();
        Identifikator = qysBlockList.value(field_identifikator).toString();
        b1 = (SerialNum !="");
        b2 = (SerialNum !=tr("Ñïèñàí"));
//      if (SerialNum == tr("Ñïèñàí")){continue;}
//      if (SerialNum == tr("Ñêëàä")){sysBlockList << tr("Íà ñêëàä"); continue;}
//      if (SerialNum !="") {tmp.append(tr("S/N: ")); 
//              tmp.append(SerialNum); }
        if (InventarNum == tr("Ñïèñàí")){continue;}
        if (InventarNum == tr("Ñêëàä")){sysBlockList << tr("Íà ñêëàä"); continue;}
        if (InventarNum !="") {tmp.append(tr("Èíâ.íîì:"));
                tmp.append(InventarNum); }
                tmp.append(addmemoryForm::getUserInfo(UserId));
//      if (InventarNum !=""){tmp.append(tr(" Èíâ.íîì: "));
//              tmp.append(InventarNum);}
        if (tmp !="") sysBlockList << tmp;

        }
        return sysBlockList;

}

QString addmemoryForm::getUserInfo(QString userID){
        QString rslt, tmp, sqlQueryText;
        QString identifikator_polzovatela, fio_polzovatela, identifikator_otdela;
        int field_identifikator, field_fio, field_id_otdela;
        QSqlQuery qSqlUserInfo;
        sqlQueryText = tr("select * from Ñîòðóäíèêè where Èäåíòèôèêàòîð = ");
        sqlQueryText.append(userID);
        qSqlUserInfo.prepare(sqlQueryText);
        qSqlUserInfo.exec();
        field_identifikator = qSqlUserInfo.record().indexOf(tr("Èäåíòèôèêàòîð"));
        field_fio = qSqlUserInfo.record().indexOf(tr("ÔÈÎ"));
        field_id_otdela = qSqlUserInfo.record().indexOf(tr("Èäåíòèôèêàòîð_îòäåëà"));
        tmp="";
        while(qSqlUserInfo.next()){
        identifikator_polzovatela =  qSqlUserInfo.value(field_identifikator).toString();
        fio_polzovatela = qSqlUserInfo.value(field_fio).toString();
        identifikator_otdela = qSqlUserInfo.value(field_id_otdela).toString();
        if (fio_polzovatela !="") {
        tmp.append(tr(" "));
        tmp.append(fio_polzovatela);
        tmp.append(addmemoryForm::getOtdelName(identifikator_otdela));
        }
       
        }
        rslt.append(tmp);
        return rslt;
       
}


QString addmemoryForm::getOtdelName(QString otdelID){
        QString otdel, sqlText, tmp;
        QSqlQuery query;
        int field_name;
        sqlText = (tr("select Îòäåëû.Íàçâàíèå from Îòäåëû where Èäåíòèôèêàòîð = "));
        sqlText.append(otdelID);
        query.prepare(sqlText);
        query.exec();
        field_name = query.record().indexOf(tr("Íàçâàíèå"));
        tmp="";
        while(query.next()){
                tmp.append(tr(" "));
                tmp.append( query.value(field_name).toString());
        }
        otdel = tmp;
        return otdel;
}

void addmemoryForm::initTreeWidgrt(){
int fieldName, fieldID;
        QTreeWidgetItem *otdelItem;
        QSqlQuery q(tr("select * from Îòäåëû"));// ïîëó÷àåì ñïèñîê îòäåëîâ
        QString otdel, otdel_id;
        fieldName = q.record().indexOf(tr("Íàçâàíèå"));
        fieldID = q.record().indexOf(tr("Èäåíòèôèêàòîð"));
        while (q.next()){
                otdel = q.value(fieldName).toString();
                otdel_id = q.value(fieldID).toString();
                otdelItem = new QTreeWidgetItem(addmemoryForm::treeWidget);
                otdelItem->setText(0, otdel);
                addmemoryForm::SotrydnikiOtdela(otdel_id, otdelItem);
                }
       
}

void addmemoryForm::SotrydnikiOtdela(QString id_otdela, QTreeWidgetItem * itemOtdela){
        int field_fio_sotrydnika, field_id_sotrydnika;
        QString fio_sotrydnika_otdela, id_sotrydnika_otdela, oboryd;
        QSqlQuery qsotrydnikiOtdela;
        QString sqlQueryString;
        QTreeWidgetItem *treeItem_sotrydnika;
        sqlQueryString = tr("select Èäåíòèôèêàòîð, ÔÈÎ from Ñîòðóäíèêè where Èäåíòèôèêàòîð_îòäåëà=");
        sqlQueryString.append(id_otdela);
        qsotrydnikiOtdela.prepare(sqlQueryString);
        qsotrydnikiOtdela.exec();
        field_fio_sotrydnika = qsotrydnikiOtdela.record().indexOf(tr("ÔÈÎ"));
        field_id_sotrydnika = qsotrydnikiOtdela.record().indexOf(tr("Èäåíòèôèêàòîð"));
        while (qsotrydnikiOtdela.next())
        {
                fio_sotrydnika_otdela = qsotrydnikiOtdela.value(field_fio_sotrydnika).toString();
                id_sotrydnika_otdela = qsotrydnikiOtdela.value(field_id_sotrydnika).toString();
                treeItem_sotrydnika = new QTreeWidgetItem(itemOtdela);
                treeItem_sotrydnika->setText(1, fio_sotrydnika_otdela );
//              treeItem_sotrydnika->setText(2, id_sotrydnika_otdela );
//              oboryd = oborydovanie(id_sotrydnika_otdela, treeItem_sotrydnika);
//              treeItem_sotrydnika->setText(3, oboryd );
        }
}

void addmemoryForm::on_pushButton_clicked(){
QSqlQuery q;
QString sqlText;
if (lineEdit->text() == "")
        {      
                QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
                                                                                this,                      // Ðîäèòåëüñêèé âèäæåò.
                                                                                QObject::tr("Îøèáêà ââîäà äàííûõ"),   // Çàãîëîâîê.  
                                                                                tr("Ââåäèòå èíâåíòàðíûé íîìåð"));          // Òåêñò ñîîáùåíèÿ.
                                                                                return;
                                                                        }
switch (tabWidget->currentIndex())
{
        case 0: //Ìîäóëè ïàìÿòè
        {
                QString id;
               
                id = getIdentifikator(label_7->text());
                q.prepare(tr("insert into memory (Ïðîèçâîäèòåëü, Òèï, Îáúåì, Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà, Èíâåíòàðíûé_íîìåð, Ñåðèéíûé_íîìåð) "
                                        "values (:proizvoditel, :tip, :obem, :sys_id, :inv_num, :serial_num)"));
//              q.bindValue(":ident", "default");
                q.bindValue(tr(":proizvoditel"), comboBox->currentText());
                q.bindValue(tr(":tip"), comboBox_3->currentText());
                q.bindValue(tr(":obem"), comboBox_2->currentText());
//              q.bindValue(tr(":chastota"), "default");
                q.bindValue(tr(":sys_id"), id);
                q.bindValue(tr(":inv_num"), lineEdit->text());
                q.bindValue(tr(":serial_num"), lineEdit_2->text());
//              query.bindValue(":surname", "Simpson");
//              sqlText = tr("insert into Ïàìÿòü vflue()");
                q.exec();
                add_mem_proizvoditel(comboBox->currentText()); //äîáàâèì ïðîèçâîäèòåëÿ â ñïèñîê, åñëè åãî òàì íåò
                emit componentAdd();
                close();
//              MainWindowImpl::initTreeWidget();
        }      
        break;

        case 1: //Âèí÷åñòåðû
        {
                QString id;
               
                id = getIdentifikator(label_7->text());
                q.prepare(tr("insert into harddiscs (Ïðîèçâîäèòåëü, Èíòåðôåéñ, Îáúåì, Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà, Èíâåíòàðíûé_íîìåð, Ñåðèéíûé_íîìåð) "
                                        "values (:proizvoditel, :interface, :obem, :sys_id, :inv_num, :serial_num)"));
//              q.bindValue(":ident", "default");
                q.bindValue(tr(":proizvoditel"), comboBox_13->currentText());
                q.bindValue(tr(":interface"), comboBox_14->currentText());
                q.bindValue(tr(":obem"), comboBox_15->currentText());
//              q.bindValue(tr(":chastota"), "default");
                q.bindValue(tr(":sys_id"), id);
                q.bindValue(tr(":inv_num"), lineEdit->text());
                q.bindValue(tr(":serial_num"), lineEdit_2->text());
//              query.bindValue(":surname", "Simpson");
//              sqlText = tr("insert into Ïàìÿòü vflue()");
                q.exec();
                add_hdd_proizvoditel(comboBox_13->currentText()); //äîáàâèì ïðîèçâîäèòåëÿ â ñïèñîê, åñëè åãî òàì íåò
                emit componentAdd();
                close();
//              MainWindowImpl::initTreeWidget();
        }      
        break;


        case 2: //Ïðîöåññîðû
        {
        QString id;
                id = getIdentifikator(label_7->text());
                q.prepare(tr("insert into processors (Ïðîèçâîäèòåëü, Ìîäåëü, ×àñòîòà , Ñëîò, Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà, Èíâåíòàðíûé_íîìåð, Ñåðèéíûé_íîìåð) "
                                        "values (:proizvoditel, :model, :fqr, :slot, :sys_id, :inv_num, :serial_num)"));
                                        q.bindValue(tr(":proizvoditel"), comboBox_9->currentText());
                                        q.bindValue(tr(":model"), comboBox_12->currentText());
                                        q.bindValue(tr(":slot"), comboBox_11->currentText());
                                        q.bindValue(tr(":fqr"), comboBox_10->currentText());
                                        q.bindValue(tr(":sys_id"), id);
                                        q.bindValue(tr(":inv_num"), lineEdit->text());
                                        q.bindValue(tr(":serial_num"), lineEdit_2->text());
                                        q.exec();
                                        add_mb_proizvoditel(comboBox_5->currentText());
                                        add_cpu_proizvoditel(comboBox_9->currentText());
                                        add_mb_model(comboBox_5->currentText(), comboBox_6->currentText());
                                        add_cpu_model(comboBox_9->currentText(), comboBox_12->currentText());
                                         
                                        emit componentAdd();
                                        close();
        }
        break;
               
        case 3: //Ìàòåðèíñêèå ïëàòû
        {
        QString id;
                id = getIdentifikator(label_7->text());
                q.prepare(tr("insert into matheboards (Ïðîèçâîäèòåëü, Ìîäåëü , Ñëîò, ×àñòîòà_øèíû, Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà, Èíâåíòàðíûé_íîìåð, Ñåðèéíûé_íîìåð) "
                                        "values (:proizvoditel, :model, :slot, :bus_fqr, :sys_id, :inv_num, :serial_num)"));
                                        q.bindValue(tr(":proizvoditel"), comboBox_5->currentText());
                                        q.bindValue(tr(":model"), comboBox_6->currentText());
                                        q.bindValue(tr(":slot"), comboBox_7->currentText());
                                        q.bindValue(tr(":bus_fqr"), comboBox_8->currentText());
                                        q.bindValue(tr(":sys_id"), id);
                                        q.bindValue(tr(":inv_num"), lineEdit->text());
                                        q.bindValue(tr(":serial_num"), lineEdit_2->text());
                                        q.exec();
                                        add_mb_proizvoditel(comboBox_5->currentText());
                                        add_mb_model(comboBox_5->currentText(), comboBox_6->currentText());
                                        emit componentAdd();
                                        close();
        }
        break;
       
        case 4: //CD/DVD ïðèâîäû
        {
        QString id;
                id = getIdentifikator(label_7->text());
                q.prepare(tr("insert into cd_dvd (Òèï, Ïðîèçâîäèòåëü, Ñêîðîñòü, Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà, Èíâåíòàðíûé_íîìåð, Ñåðèéíûé_íîìåð) "
                                        "values (:tip, :proizvoditel, :skorost, :sys_id, :inv_num, :serial_num)"));
                                        q.bindValue(tr(":tip"), comboBox_16->currentText());
                                        q.bindValue(tr(":proizvoditel"), comboBox_17->currentText());
                                        q.bindValue(tr(":skorost"), comboBox_18->currentText());
                                        q.bindValue(tr(":sys_id"), id);
                                        q.bindValue(tr(":inv_num"), lineEdit->text());
                                        q.bindValue(tr(":serial_num"), lineEdit_2->text());
                                        q.exec();
                                        add_mb_proizvoditel(comboBox_5->currentText());
                                        add_mb_model(comboBox_5->currentText(), comboBox_6->currentText());
                                        emit componentAdd();
                                        close();
                                }
       
       
        break;
       
        case 5: //Âèäåîêàðòû
        {
               
        QString id;
                id = getIdentifikator(label_7->text());
                q.prepare(tr("insert into videocards (Ïðîèçâîäèòåëü, Ìîäåëü , Èíòåðôåéñ, Ïàìÿòü, Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà, Èíâåíòàðíûé_íîìåð, Ñåðèéíûé_íîìåð) "
                                        "values (:proizvoditel, :model, :interface, :memory, :sys_id, :inv_num, :serial_num)"));
                                        q.bindValue(tr(":proizvoditel"), comboBox_19->currentText());
                                        q.bindValue(tr(":model"), comboBox_20->currentText());
                                        q.bindValue(tr(":interface"), comboBox_21->currentText());
                                        q.bindValue(tr(":memory"), comboBox_22->currentText());
                                        q.bindValue(tr(":sys_id"), id);
                                        q.bindValue(tr(":inv_num"), lineEdit->text());
                                        q.bindValue(tr(":serial_num"), lineEdit_2->text());
                                        q.exec();
                                        add_video_proizvoditel(comboBox_19->currentText());
                                        add_video_model(comboBox_19->currentText(), comboBox_20->currentText());
                                        emit componentAdd();
                                        close();
                                }
        break;
       
        case 6: //Çâóêîâûå êàðòû
        {
               
        QString id;
                id = getIdentifikator(label_7->text());
                q.prepare(tr("insert into soundcards (Ïðîèçâîäèòåëü, Ìîäåëü , Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà, Èíâåíòàðíûé_íîìåð, Ñåðèéíûé_íîìåð) "
                                        "values (:proizvoditel, :model, :sys_id, :inv_num, :serial_num)"));
                                        q.bindValue(tr(":proizvoditel"), comboBox_23->currentText());
                                        q.bindValue(tr(":model"), comboBox_24->currentText());
                                        q.bindValue(tr(":sys_id"), id);
                                        q.bindValue(tr(":inv_num"), lineEdit->text());
                                        q.bindValue(tr(":serial_num"), lineEdit_2->text());
                                        q.exec();
                                        add_mb_proizvoditel(comboBox_5->currentText());
                                        add_mb_model(comboBox_5->currentText(), comboBox_6->currentText());
                                        emit componentAdd();
                                        close();
               
        }
        break; 
        case 7: //Ñåòåâûå êàðòû
        {
               
        QString id;
                id = getIdentifikator(label_7->text());
                q.prepare(tr("insert into lancards (Ïðîèçâîäèòåëü, Ìîäåëü , Ñêîðîñòü_ïåðåäà÷è_äàííûõ, Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà, Èíâåíòàðíûé_íîìåð, Ñåðèéíûé_íîìåð) "
                                        "values (:proizvoditel, :model, :spd, :sys_id, :inv_num, :serial_num)"));
                                        q.bindValue(tr(":proizvoditel"), comboBox_25->currentText());
                                        q.bindValue(tr(":model"), comboBox_26->currentText());
                                        q.bindValue(tr(":spd"), comboBox_27->currentText());
                                        q.bindValue(tr(":sys_id"), id);
                                        q.bindValue(tr(":inv_num"), lineEdit->text());
                                        q.bindValue(tr(":serial_num"), lineEdit_2->text());
                                        q.exec();
                                        add_mb_proizvoditel(comboBox_5->currentText());
                                        add_mb_model(comboBox_5->currentText(), comboBox_6->currentText());
                                        emit componentAdd();
                                        close();
               
        }
        break; 

        default:
       
       
        break;
}

void componentAdd();

       
       
       


}

QString addmemoryForm::getIdentifikator(QString inventar_num){
        QSqlQuery q;
        QString sqltext;
        int field_id;
        QString identifikator;
        if (inventar_num == tr("Íà ñêëàä")) return tr("1");
        sqltext = tr("select * from system_blocks where system_blocks.Èíâåíòàðíûé_íîìåð = \"");
        sqltext.append(inventar_num);
        sqltext.append(tr("\""));
        q.prepare(sqltext);
        q.exec();
        field_id = q.record().indexOf(tr("Èäåíòèôèêàòîð"));
        if (q.next()) {identifikator = q.value(field_id).toString();}
        else { 
                QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
                                                                                this,                      // Ðîäèòåëüñêèé âèäæåò.
                                                                                QObject::tr("Îøèáêà ââîäà äàííûõ"),   // Çàãîëîâîê.  
                                                                                tr("Íåâîçìîæíî îïðåäåëèòü èäåíòèôèêàòîð ñèñòåìíîãî áëîêà"));          // Òåêñò ñîîáùåíèÿ.
                                                                                return identifikator;
               
               
                };
        return identifikator;
}






void addmemoryForm::add_video_proizvoditel(QString brend){
        QSqlQuery q;
        QString sqltext;
        int field_proizvoditel;
        QString proizv;
        sqltext = tr("select * from proizvoditeli_video where proizvoditeli_video.Ïðîèçâîäèòåëü = \"");
        sqltext.append(brend);
        sqltext.append(tr("\""));
        q.prepare(sqltext);
        q.exec();
        field_proizvoditel = q.record().indexOf(tr("Ïðîèçâîäèòåëü"));
        if (q.next()) {return;}
        else {
        q.prepare(tr("insert into proizvoditeli_video (Ïðîèçâîäèòåëü) "
                                        "values (:proizvoditel)"));
        q.bindValue(tr(":proizvoditel"), brend);
        q.exec();
        }
       
}


void addmemoryForm::add_mem_proizvoditel(QString brend){
        QSqlQuery q;
        QString sqltext;
        int field_proizvoditel;
        QString proizv;
        sqltext = tr("select * from proizvoditeli_pamyati where proizvoditeli_pamyati.Ïðîèçâîäèòåëü = \"");
        sqltext.append(brend);
        sqltext.append(tr("\""));
        q.prepare(sqltext);
        q.exec();
        field_proizvoditel = q.record().indexOf(tr("Ïðîèçâîäèòåëü"));
        if (q.next()) {return;}
        else {
        q.prepare(tr("insert into proizvoditeli_pamyati (Ïðîèçâîäèòåëü) "
                                        "values (:proizvoditel)"));
        q.bindValue(tr(":proizvoditel"), brend);
        q.exec();
        }
       
}


void addmemoryForm::add_mb_proizvoditel(QString brend){
        QSqlQuery q;
        QString sqltext;
        int field_proizvoditel;
        QString proizv;
        sqltext = tr("select * from proizvoditeli_mb where proizvoditeli_mb.Ïðîèçâîäèòåëü = \"");
        sqltext.append(brend);
        sqltext.append(tr("\""));
        q.prepare(sqltext);
        q.exec();
        field_proizvoditel = q.record().indexOf(tr("Ïðîèçâîäèòåëü"));
        if (q.next()) {return;}
        else {
        q.prepare(tr("insert into proizvoditeli_mb (Ïðîèçâîäèòåëü) "
                                        "values (:proizvoditel)"));
        q.bindValue(tr(":proizvoditel"), brend);
        q.exec();
        }
       
}

void addmemoryForm::add_hdd_proizvoditel(QString brend){
        QSqlQuery q;
        QString sqltext;
        int field_proizvoditel;
        QString proizv;
        sqltext = tr("select * from proizvoditeli_hdd where proizvoditeli_hdd.Ïðîèçâîäèòåëü = \"");
        sqltext.append(brend);
        sqltext.append(tr("\""));
        q.prepare(sqltext);
        q.exec();
        field_proizvoditel = q.record().indexOf(tr("Ïðîèçâîäèòåëü"));
        if (q.next()) {return;}
        else {
        q.prepare(tr("insert into proizvoditeli_hdd (Ïðîèçâîäèòåëü) "
                                        "values (:proizvoditel)"));
        q.bindValue(tr(":proizvoditel"), brend);
        q.exec();
        }
       
}

void addmemoryForm::add_cpu_proizvoditel(QString brend){
        QSqlQuery q;
        QString sqltext;
        int field_proizvoditel;
        QString proizv;
        sqltext = tr("select * from proizvoditeli_cpu where proizvoditeli_hdd.Ïðîèçâîäèòåëü = \"");
        sqltext.append(brend);
        sqltext.append(tr("\""));
        q.prepare(sqltext);
        q.exec();
        field_proizvoditel = q.record().indexOf(tr("Ïðîèçâîäèòåëü"));
        if (q.next()) {return;}
        else {
        q.prepare(tr("insert into proizvoditeli_cpu (Ïðîèçâîäèòåëü) "
                                        "values (:proizvoditel)"));
        q.bindValue(tr(":proizvoditel"), brend);
        q.exec();
        }
       
}

void addmemoryForm::add_mb_model(QString brend, QString model){
        QSqlQuery q;
        QString sqltext;
        int field_proizvoditel;
        QString proizv;
        sqltext = tr("select * from Ìîäåëè_ìàòåðèíñêèõ_ïëàò where Ìîäåëè_ìàòåðèíñêèõ_ïëàò.Ïðîèçâîäèòåëü = \"");
        sqltext.append(brend);
        sqltext.append(tr("\" and Ìîäåëè_ìàòåðèíñêèõ_ïëàò.Ìîäåëü = \""));
        sqltext.append(model);
        sqltext.append(tr("\""));
        q.prepare(sqltext);
        q.exec();
        field_proizvoditel = q.record().indexOf(tr("Ïðîèçâîäèòåëü"));
        if (q.next()) {return;}
        else {
        q.prepare(tr("insert into Ìîäåëè_ìàòåðèíñêèõ_ïëàò (Ìîäåëü, Ïðîèçâîäèòåëü) "
                                        "values (:model, :proizvoditel)"));
        q.bindValue(tr(":model"), model);
        q.bindValue(tr(":proizvoditel"), brend);
        q.exec();
        }
       
}



void addmemoryForm::add_cpu_model(QString brend, QString model){
        QSqlQuery q;
        QString sqltext;
        int field_proizvoditel;
        QString proizv;
        sqltext = tr("select * from processor_models where processor_models.Ïðîèçâîäèòåëü = \"");
        sqltext.append(brend);
        sqltext.append(tr("\" and processor_models.Ìîäåëü = \""));
        sqltext.append(model);
        sqltext.append(tr("\""));
        q.prepare(sqltext);
        q.exec();
        field_proizvoditel = q.record().indexOf(tr("Ïðîèçâîäèòåëü"));
        if (q.next()) {return;}
        else {
        q.prepare(tr("insert into processor_models (Ìîäåëü, Ïðîèçâîäèòåëü) "
                                        "values (:model, :proizvoditel)"));
        q.bindValue(tr(":model"), model);
        q.bindValue(tr(":proizvoditel"), brend);
        q.exec();
        }
       
}

void addmemoryForm::add_video_model(QString brend, QString model){
        QSqlQuery q;
        QString sqltext;
        int field_proizvoditel;
        QString proizv;
        sqltext = tr("select * from video_models where video_models.Ïðîèçâîäèòåëü = \"");
        sqltext.append(brend);
        sqltext.append(tr("\" and video_models.Ìîäåëü = \""));
        sqltext.append(model);
        sqltext.append(tr("\""));
        q.prepare(sqltext);
        q.exec();
        field_proizvoditel = q.record().indexOf(tr("Ïðîèçâîäèòåëü"));
        if (q.next()) {return;}
        else {
        q.prepare(tr("insert into video_models (Ìîäåëü, Ïðîèçâîäèòåëü) "
                                        "values (:model, :proizvoditel)"));
        q.bindValue(tr(":model"), model);
        q.bindValue(tr(":proizvoditel"), brend);
        q.exec();
        }
       
}


//void addmemoryForm::hide (){
//      treeWidget->setEnabled(true);
//}

void addmemoryForm::closeEvent ( QCloseEvent * event )  {
        emit formClose();
}


 

Редакция 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;

Хранилища Subversion OpenInventory

(root)/trunk/source_code/src/addmemoryform.cpp - Редакция 6 → 17