0921

wumu

2023-09-20 332ab3cdf6fd91e5cee4f0a773ab2b270df2ed66

0921

 internal_system_v1/auditproject.cpp

@@ -43,6 +43,7 @@
void AuditProject::on_pushButton_clicked()
{


    // å†æ¬¡ç»Ÿè®¡ä¸€æŠŠ
    int sum = 0;
    for(int i=1;i<9;++i){
@@ -67,6 +68,8 @@
    }else{
        qDebug()<<"fail sql"<<__FUNCTION__;
    }
    static int cnt=1;
    ui->pushButton->setText(QString("提交--审计项目_%1次").arg(cnt++));
}

void AuditProject::showData(QVariantList vlist)
@@ -76,4 +79,10 @@
            ui->tableWidget->setItem(i,2,new QTableWidgetItem(vlist.at(i).toString()));
        }
    }
    // å†æ¬¡ç»Ÿè®¡ä¸€æŠŠ
    int sum = 0;
    for(int i=1;i<9;++i){
        sum += ui->tableWidget->item(i,2)->text().toInt();
    }
    ui->tableWidget->setItem(0,2,new QTableWidgetItem(QString::number(sum)));
}

 internal_system_v1/auditworkload.cpp

@@ -36,6 +36,8 @@
    }else{
        qDebug()<<"fail sql"<<__FUNCTION__;
    }
    static int cnt=1;
    ui->pushButton->setText(QString("提交--内审工作量_%1次").arg(cnt++));
}

void AuditWorkload::showData(QVariantList vlist)

 internal_system_v1/caseclue.cpp

@@ -38,6 +38,8 @@
    }else{
        qDebug()<<"fail sql"<<__FUNCTION__;
    }
    static int cnt=1;
    ui->pushButton->setText(QString("提交--案件线索_%1次").arg(cnt++));
}

void CaseClue::showData(QVariantList vlist)

 internal_system_v1/clientmainwindow.cpp

@@ -107,7 +107,8 @@
        if(comName.isValid()){
            if(!readDataFromSQL(comName.toString())){
                QMessageBox::information(this,"导入中断","请确认公司基本信息已经存在");
                return;
                break;
                //return;
            }
            qDebug()<<comName<<g_comId;
        }

 internal_system_v1/coverinfo.cpp

@@ -98,11 +98,15 @@
                QVariant name = valRows[9].toList().at(8);
                if(name.isValid()){
                    ui->label_name->setText(name.toString());
                }else{
                    ui->label_name->setText("");
                }
                // æœºæž„类型
                QVariant comType = valRows[12].toList().at(3);
                if(comType.isValid()){
                    ui->label_comType->setText(comType.toString());
                }else{
                    ui->label_comType->setText("");
                }
                // ä¸»è¦ä¸šåŠ¡æ´»åŠ¨
                QString business;
@@ -122,11 +126,15 @@
                }
                if(business.size() > 0){
                    ui->label_business->setText(business);
                }else{
                    ui->label_business->setText("");
                }
                // ä¸šåŠ¡ä»£ç 
                QVariant busCode = valRows[19].toList().at(4);
                if(busCode.isValid()){
                    ui->label_businessCode->setText(busCode.toString());
                }else{
                    ui->label_businessCode->setText("");
                }
                // æ³¨å†Œåœ°å€
                QString addr="";
@@ -145,40 +153,89 @@
                if(street.isValid()) addr += street.toString();
                if(Sub.isValid()) addr += Sub.toString();
                if(committee.isValid()) addr += committee.toString();
                if(addr.size()>10)ui->label_addr->setText(addr);
                if(addr.size()>10){
                    ui->label_addr->setText(addr);
                }else{
                    ui->label_addr->setText("");
                }
                // åŒºåŸŸä»£ç 
                QVariant areaCode = valRows[24].toList().at(2);
                if(areaCode.isValid()) ui->label_areaCode->setText(areaCode.toString());
                if(areaCode.isValid()){
                    ui->label_areaCode->setText(areaCode.toString());
                }else{
                    ui->label_areaCode->setText("");
                }
                // åŸŽä¹¡ä»£ç 
                QVariant townCode = valRows[24].toList().at(6);
                if(townCode.isValid()) ui->label_townCode->setText(townCode.toString());
                if(townCode.isValid()) {
                    ui->label_townCode->setText(townCode.toString());
                }else{
                    ui->label_townCode->setText("");
                }

                // å•ä½è§„模
                QVariant scale = valRows[25].toList().at(3);
                if(scale.isValid()) ui->label_scale->setText(scale.toString());
                if(scale.isValid()){
                    ui->label_scale->setText(scale.toString());
                }else{
                    ui->label_scale->setText("");
                }
                // ä»Žä¸šäººæ•°
                QVariant people = valRows[26].toList().at(6);
                if(people.isValid()) ui->label_people->setText(people.toString());
                if(people.isValid()) {
                    ui->label_people->setText(people.toString());
                }else{
                    ui->label_people->setText("");
                }
                // æ³•äºº
                QVariant representative = valRows[27].toList().at(4);
                if(representative.isValid()) ui->label_representative->setText(representative.toString());
                if(representative.isValid()) {
                    ui->label_representative->setText(representative.toString());
                }else{
                    ui->label_representative->setText("");
                }
                // ä¼šè®¡æ ‡å‡†ç±»åˆ« standardType
                QVariant standardType = valRows[27].toList().at(8);
                if(standardType.isValid()) ui->label_standardType->setText(standardType.toString());
                if(standardType.isValid()){
                    ui->label_standardType->setText(standardType.toString());
                }else{
                    ui->label_standardType->setText("");
                }
                // é•¿é€”区号
                QVariant trunkCode = valRows[31].toList().at(2);
                if(trunkCode.isValid()) ui->label_trunkCode->setText(trunkCode.toString());
                if(trunkCode.isValid()){
                    ui->label_trunkCode->setText(trunkCode.toString());
                }else{
                    ui->label_trunkCode->setText("");
                }
                // å›ºå®šç”µè¯
                QVariant fixedTel = valRows[32].toList().at(2);
                if(fixedTel.isValid()) ui->label_fixedTel->setText(fixedTel.toString());
                if(fixedTel.isValid()) {
                    ui->label_fixedTel->setText(fixedTel.toString());
                }else{
                    ui->label_fixedTel->setText("");
                }
                // é‚®æ”¿ç¼–码
                QVariant postCode = valRows[33].toList().at(2);
                if(postCode.isValid()) ui->label_postCode->setText(postCode.toString());
                if(postCode.isValid()){
                    ui->label_postCode->setText(postCode.toString());
                }else{
                    ui->label_postCode->setText("");
                }
                // ç”µå­é‚®ç®±
                QVariant email = valRows[30].toList().at(5);
                if(email.isValid()) ui->label_email->setText(email.toString());
                if(email.isValid()) {
                    ui->label_email->setText(email.toString());
                }else{
                    ui->label_email->setText("");
                }
                // ç½‘址
                QVariant webSite = valRows[32].toList().at(5);
                if(webSite.isValid()) ui->label_webSite->setText(webSite.toString());
                if(webSite.isValid()) {
                    ui->label_webSite->setText(webSite.toString());
                }else{
                    ui->label_webSite->setText("");
                }
            }
            wbs->dynamicCall("Close()");
            excel.dynamicCall("Quit(void)");
@@ -276,6 +333,97 @@
        QVariant  val = usedRange->dynamicCall("Value"); // æ‹¿åˆ°äºŒç»´è¡¨æ ¼
        QVariantList valRows = val.toList();
        // ç»Ÿä¸€ä¿¡ç”¨ä»£ç 
//        QVariant uniCode = valRows[9].toList().at(3);
//        if(uniCode.isValid()){
//            ui->label_creditCode->setText(uniCode.toString());
//        }
//        // å•ä½åç§°
//        QVariant name = valRows[9].toList().at(8);
//        if(name.isValid()){
//            ui->label_name->setText(name.toString());
//        }
//        // æœºæž„类型
//        QVariant comType = valRows[12].toList().at(3);
//        if(comType.isValid()){
//            ui->label_comType->setText(comType.toString());
//        }
//        // ä¸»è¦ä¸šåŠ¡æ´»åŠ¨
//        QString business;
//        QVariant first = valRows[18].toList().at(2);
//        if(first.isValid()){
//            business.append(first.toString());
//        }
//        QVariant sec = valRows[18].toList().at(5);
//        if(sec.isValid()){
//            business += "、";
//            business.append(sec.toString());
//        }
//        QVariant third = valRows[18].toList().at(8);
//        if(third.isValid()){
//            business += "、";
//            business.append(third.toString());
//        }
//        if(business.size() > 0){
//            ui->label_business->setText(business);
//        }
//        // ä¸šåŠ¡ä»£ç 
//        QVariant busCode = valRows[19].toList().at(4);
//        if(busCode.isValid()){
//            ui->label_businessCode->setText(busCode.toString());
//        }
//        // æ³¨å†Œåœ°å€
//        QString addr="";
//        QVariant province = valRows[21].toList().at(1); // çœä»½
//        QVariant city = valRows[21].toList().at(4); // åŸŽå¸‚
//        QVariant district = valRows[21].toList().at(7); // ç®¡è¾–区
//        QVariant village = valRows[22].toList().at(2); // ä¹¡é•‡
//        QVariant street = valRows[22].toList().at(4); // è¡—道
//        QVariant Sub = valRows[23].toList().at(2); // è¡—道办事处
//        QVariant committee = valRows[25].toList().at(3); // å±…委会
//        //qDebug()<<province<<city<<district<<village<<street<<Sub<<committee;
//        if(province.isValid()) addr += province.toString();
//        if(city.isValid()) addr += city.toString();
//        if(district.isValid()) addr += district.toString();
//        if(village.isValid()) addr += village.toString();
//        if(street.isValid()) addr += street.toString();
//        if(Sub.isValid()) addr += Sub.toString();
//        if(committee.isValid()) addr += committee.toString();
//        if(addr.size()>10)ui->label_addr->setText(addr);
//        // åŒºåŸŸä»£ç 
//        QVariant areaCode = valRows[24].toList().at(2);
//        if(areaCode.isValid()) ui->label_areaCode->setText(areaCode.toString());
//        // åŸŽä¹¡ä»£ç 
//        QVariant townCode = valRows[24].toList().at(6);
//        if(townCode.isValid()) ui->label_townCode->setText(townCode.toString());
//        // å•ä½è§„模
//        QVariant scale = valRows[25].toList().at(3);
//        if(scale.isValid()) ui->label_scale->setText(scale.toString());
//        // ä»Žä¸šäººæ•°
//        QVariant people = valRows[26].toList().at(6);
//        if(people.isValid()) ui->label_people->setText(people.toString());
//        // æ³•äºº
//        QVariant representative = valRows[27].toList().at(4);
//        if(representative.isValid()) ui->label_representative->setText(representative.toString());
//        // ä¼šè®¡æ ‡å‡†ç±»åˆ« standardType
//        QVariant standardType = valRows[27].toList().at(8);
//        if(standardType.isValid()) ui->label_standardType->setText(standardType.toString());
//        // é•¿é€”区号
//        QVariant trunkCode = valRows[31].toList().at(2);
//        if(trunkCode.isValid()) ui->label_trunkCode->setText(trunkCode.toString());
//        // å›ºå®šç”µè¯
//        QVariant fixedTel = valRows[32].toList().at(2);
//        if(fixedTel.isValid()) ui->label_fixedTel->setText(fixedTel.toString());
//        // é‚®æ”¿ç¼–码
//        QVariant postCode = valRows[33].toList().at(2);
//        if(postCode.isValid()) ui->label_postCode->setText(postCode.toString());
//        // ç”µå­é‚®ç®±
//        QVariant email = valRows[30].toList().at(5);
//        if(email.isValid()) ui->label_email->setText(email.toString());
//        // ç½‘址
//        QVariant webSite = valRows[32].toList().at(5);
//        if(webSite.isValid()) ui->label_webSite->setText(webSite.toString());

        // ç»Ÿä¸€ä¿¡ç”¨ä»£ç 
        QVariant uniCode = valRows[9].toList().at(3);
        if(uniCode.isValid()){
            ui->label_creditCode->setText(uniCode.toString());
@@ -284,11 +432,15 @@
        QVariant name = valRows[9].toList().at(8);
        if(name.isValid()){
            ui->label_name->setText(name.toString());
        }else{
            ui->label_name->setText("");
        }
        // æœºæž„类型
        QVariant comType = valRows[12].toList().at(3);
        if(comType.isValid()){
            ui->label_comType->setText(comType.toString());
        }else{
            ui->label_comType->setText("");
        }
        // ä¸»è¦ä¸šåŠ¡æ´»åŠ¨
        QString business;
@@ -308,11 +460,15 @@
        }
        if(business.size() > 0){
            ui->label_business->setText(business);
        }else{
            ui->label_business->setText("");
        }
        // ä¸šåŠ¡ä»£ç 
        QVariant busCode = valRows[19].toList().at(4);
        if(busCode.isValid()){
            ui->label_businessCode->setText(busCode.toString());
        }else{
            ui->label_businessCode->setText("");
        }
        // æ³¨å†Œåœ°å€
        QString addr="";
@@ -331,40 +487,89 @@
        if(street.isValid()) addr += street.toString();
        if(Sub.isValid()) addr += Sub.toString();
        if(committee.isValid()) addr += committee.toString();
        if(addr.size()>10)ui->label_addr->setText(addr);
        if(addr.size()>10){
            ui->label_addr->setText(addr);
        }else{
            ui->label_addr->setText("");
        }
        // åŒºåŸŸä»£ç 
        QVariant areaCode = valRows[24].toList().at(2);
        if(areaCode.isValid()) ui->label_areaCode->setText(areaCode.toString());
        if(areaCode.isValid()){
            ui->label_areaCode->setText(areaCode.toString());
        }else{
            ui->label_areaCode->setText("");
        }
        // åŸŽä¹¡ä»£ç 
        QVariant townCode = valRows[24].toList().at(6);
        if(townCode.isValid()) ui->label_townCode->setText(townCode.toString());
        if(townCode.isValid()) {
            ui->label_townCode->setText(townCode.toString());
        }else{
            ui->label_townCode->setText("");
        }

        // å•ä½è§„模
        QVariant scale = valRows[25].toList().at(3);
        if(scale.isValid()) ui->label_scale->setText(scale.toString());
        if(scale.isValid()){
            ui->label_scale->setText(scale.toString());
        }else{
            ui->label_scale->setText("");
        }
        // ä»Žä¸šäººæ•°
        QVariant people = valRows[26].toList().at(6);
        if(people.isValid()) ui->label_people->setText(people.toString());
        if(people.isValid()) {
            ui->label_people->setText(people.toString());
        }else{
            ui->label_people->setText("");
        }
        // æ³•äºº
        QVariant representative = valRows[27].toList().at(4);
        if(representative.isValid()) ui->label_representative->setText(representative.toString());
        if(representative.isValid()) {
            ui->label_representative->setText(representative.toString());
        }else{
            ui->label_representative->setText("");
        }
        // ä¼šè®¡æ ‡å‡†ç±»åˆ« standardType
        QVariant standardType = valRows[27].toList().at(8);
        if(standardType.isValid()) ui->label_standardType->setText(standardType.toString());
        if(standardType.isValid()){
            ui->label_standardType->setText(standardType.toString());
        }else{
            ui->label_standardType->setText("");
        }
        // é•¿é€”区号
        QVariant trunkCode = valRows[31].toList().at(2);
        if(trunkCode.isValid()) ui->label_trunkCode->setText(trunkCode.toString());
        if(trunkCode.isValid()){
            ui->label_trunkCode->setText(trunkCode.toString());
        }else{
            ui->label_trunkCode->setText("");
        }
        // å›ºå®šç”µè¯
        QVariant fixedTel = valRows[32].toList().at(2);
        if(fixedTel.isValid()) ui->label_fixedTel->setText(fixedTel.toString());
        if(fixedTel.isValid()) {
            ui->label_fixedTel->setText(fixedTel.toString());
        }else{
            ui->label_fixedTel->setText("");
        }
        // é‚®æ”¿ç¼–码
        QVariant postCode = valRows[33].toList().at(2);
        if(postCode.isValid()) ui->label_postCode->setText(postCode.toString());
        if(postCode.isValid()){
            ui->label_postCode->setText(postCode.toString());
        }else{
            ui->label_postCode->setText("");
        }
        // ç”µå­é‚®ç®±
        QVariant email = valRows[30].toList().at(5);
        if(email.isValid()) ui->label_email->setText(email.toString());
        if(email.isValid()) {
            ui->label_email->setText(email.toString());
        }else{
            ui->label_email->setText("");
        }
        // ç½‘址
        QVariant webSite = valRows[32].toList().at(5);
        if(webSite.isValid()) ui->label_webSite->setText(webSite.toString());
        if(webSite.isValid()) {
            ui->label_webSite->setText(webSite.toString());
        }else{
            ui->label_webSite->setText("");
        }

        // å¦‚果单位是新增加的，得写入到数据库中保存起来
        readDataFromSQL(); // å†æ¬¡è°ƒç”¨API ç¡®è®¤æ•°æ®è¿›åˆ°è¡¨ä¸­

 internal_system_v1/problemcount.cpp

@@ -85,6 +85,8 @@
    }else{
        qDebug()<<"fail sql"<<__FUNCTION__;
    }
    static int cnt=1;
    ui->pushButton->setText(QString("提交--问题数量_%1次").arg(cnt++));
}

void ProblemCount::showData(QVariantList vlist)
@@ -94,4 +96,6 @@
            ui->tableWidget->setItem(i,2,new QTableWidgetItem(vlist.at(i).toString()));
        }
    }
    // å†ç»Ÿè®¡ä¸€æŠŠ
    on_tableWidget_activated(QModelIndex());
}

 internal_system_v1/problemmoney.cpp

@@ -35,6 +35,9 @@

void ProblemMoney::on_pushButton_clicked()
{
    // ç»Ÿè®¡
    on_tableWidget_activated(QModelIndex());

    QString values = "";
    for(int i=0;i<ui->tableWidget->rowCount();++i){
        values += QString("('%1','%2',%3,'%4',%5,'%6'),").arg(ui->tableWidget->item(i,0)->text())
@@ -51,6 +54,8 @@
    }else{
        qDebug()<<"fail sql"<<__FUNCTION__;
    }
    static int cnt=1;
    ui->pushButton->setText(QString("提交--问题金额_%1次").arg(cnt++));
}

void ProblemMoney::showData(QVariantList vlist)
@@ -60,4 +65,24 @@
            ui->tableWidget->setItem(i,2,new QTableWidgetItem(vlist.at(i).toString()));
        }
    }
    // ç»Ÿè®¡
    on_tableWidget_activated(QModelIndex());
}

void ProblemMoney::on_tableWidget_activated(const QModelIndex &index)
{
    // å…ˆè®¡ç®—合规性问题金额
    double allComSum = 0;
    for(int i=3;i<11;++i){
        allComSum += ui->tableWidget->item(i,2)->text().toDouble();
    }
    ui->tableWidget->setItem(2,2,new QTableWidgetItem(QString::number(allComSum)));
    allComSum += ui->tableWidget->item(1,2)->text().toDouble();
    ui->tableWidget->setItem(0,2,new QTableWidgetItem(QString::number(allComSum)));
}

void ProblemMoney::on_tableWidget_clicked(const QModelIndex &index)
{
    // ç»Ÿè®¡
    on_tableWidget_activated(QModelIndex());
}

 internal_system_v1/problemmoney.h

@@ -22,6 +22,10 @@

    void showData(QVariantList vlist);

    void on_tableWidget_activated(const QModelIndex &index);

    void on_tableWidget_clicked(const QModelIndex &index);

private:
    Ui::ProblemMoney *ui;
    int m_comId;

 internal_system_v1/problemnotmoney.cpp

@@ -65,6 +65,8 @@
    }else{
        qDebug()<<"fail sql"<<__FUNCTION__;
    }
    static int cnt=1;
    ui->pushButton->setText(QString("提交--问题整改非金额_%1次").arg(cnt++));
}

void ProblemNotMoney::showData(QVariantList vlist)
@@ -74,4 +76,6 @@
            ui->tableWidget->setItem(i,2,new QTableWidgetItem(vlist.at(i).toString()));
        }
    }
    // å†ç»Ÿè®¡ä¸€æŠŠ
    on_tableWidget_clicked(QModelIndex());
}

 internal_system_v1/problemrectification.cpp

@@ -37,9 +37,9 @@

void ProblemRectification::on_tableWidget_clicked(const QModelIndex &index)
{
    int allCnt = 0;
    double allCnt = 0;
    for(int i=1;i<ui->tableWidget->rowCount();++i){
        allCnt += ui->tableWidget->item(i,2)->text().toInt();
        allCnt += ui->tableWidget->item(i,2)->text().toDouble();
    }
    ui->tableWidget->setItem(0,2,new QTableWidgetItem(QString::number(allCnt)));
}
@@ -65,6 +65,8 @@
    }else{
        qDebug()<<"fail sql"<<__FUNCTION__;
    }
    static int cnt=1;
    ui->pushButton->setText(QString("提交--问题整改_%1次").arg(cnt++));
}

void ProblemRectification::showData(QVariantList vlist)
@@ -74,4 +76,6 @@
            ui->tableWidget->setItem(i,2,new QTableWidgetItem(vlist.at(i).toString()));
        }
    }
    // å†ç»Ÿè®¡ä¸€æŠŠ
    on_tableWidget_clicked(QModelIndex());
}

 internal_system_v1/punish.cpp

@@ -50,6 +50,8 @@
    }else{
        qDebug()<<"fail sql"<<__FUNCTION__;
    }
    static int cnt=1;
    ui->pushButton->setText(QString("提交--处分_%1次").arg(cnt++));
}

void Punish::showData(QVariantList vlist)
@@ -59,4 +61,6 @@
            ui->tableWidget->setItem(i,2,new QTableWidgetItem(vlist.at(i).toString()));
        }
    }
    // å†ç»Ÿè®¡ä¸€æŠŠ
    on_tableWidget_clicked(QModelIndex());
}

 ĿǰϵͳÐèÓÅ»¯µÄµØ·½_0920.docx

Binary files differ