1101

wumu

2024-11-01 41da0809fad858e523f85dcf9cec3e1e874810ff

1101

 internal_system_v1/clientmainwindow.cpp

@@ -415,67 +415,92 @@
        }

        if(i==30){ // å®¡è®¡é¡¹ç›®
            int val = 0;
            for(int j = 31;j<=38;++j){
                val += ui->tableWidget->item(j,3)->text().toInt();
            // 6列都得求和
            for(int k=0;k<6;++k){
                int val = 0;
                for(int j = 31;j<=38;++j){
                    val += ui->tableWidget->item(j,3+k)->text().toInt();
                }
                ui->tableWidget->setItem(i,3+k,new QTableWidgetItem(QString::number(val)));
            }
            ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val)));

        }

        if(i==41){ // å®¡è®¡å‘现问题金额
            int val = 0;
            for(int j = 42;j<=43;++j){
                val += ui->tableWidget->item(j,3)->text().toInt();
            for(int k=0;k<6;++k){
                double val = 0;
                for(int j = 42;j<=43;++j){
                    val += ui->tableWidget->item(j,3+k)->text().toDouble();
                }
                ui->tableWidget->setItem(i,3+k,new QTableWidgetItem(QString::number(val)));
            }
            ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val)));

        }

        if(i==43){ // åˆè§„性问题金额
            int val = 0;
            for(int j = 44;j<=51;++j){
                val += ui->tableWidget->item(j,3)->text().toInt();
            for(int k=0;k<6;++k){
                double val = 0;
                for(int j = 44;j<=51;++j){
                    val += ui->tableWidget->item(j,3+k)->text().toDouble();
                }
                ui->tableWidget->setItem(i,3+k,new QTableWidgetItem(QString::number(val)));
            }
            ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val)));

        }

        if(i==52){ // å®¡è®¡å‘现问题个数
            int val = 0;
            for(int j = 53;j<=54;++j){
                val += ui->tableWidget->item(j,3)->text().toInt();
            for(int k=0;k<6;++k){
                int val = 0;
                for(int j = 53;j<=54;++j){
                    val += ui->tableWidget->item(j,3+k)->text().toInt();
                }
                ui->tableWidget->setItem(i,3+k,new QTableWidgetItem(QString::number(val)));
            }
            ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val)));

        }

        if(i==54){ // éžé‡‘额类问题个数
            int val = 0;
            for(int j = 55;j<=58;++j){
                val += ui->tableWidget->item(j,3)->text().toInt();
            for(int k=0;k<6;++k){
                int val = 0;
                for(int j = 55;j<=58;++j){
                    val += ui->tableWidget->item(j,3+k)->text().toInt();
                }
                ui->tableWidget->setItem(i,3+k,new QTableWidgetItem(QString::number(val)));
            }
            ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val)));

        }

        if(i==59){ // å®¡è®¡å‘现问题整改(金额类)
            int val = 0;
            for(int j = 60;j<=65;++j){
                val += ui->tableWidget->item(j,3)->text().toInt();
            for(int k=0;k<6;++k){
                double val = 0;
                for(int j = 60;j<=65;++j){
                    val += ui->tableWidget->item(j,3+k)->text().toDouble();
                }
                ui->tableWidget->setItem(i,3+k,new QTableWidgetItem(QString::number(val)));
            }
            ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val)));

        }

        if(i==66){ // å®¡è®¡å‘现问题整改(非金额类)
            int val = 0;
            for(int j = 67;j<=70;++j){
                val += ui->tableWidget->item(j,3)->text().toInt();
            for(int k=0;k<6;++k){
                int val = 0;
                for(int j = 67;j<=70;++j){
                    val += ui->tableWidget->item(j,3+k)->text().toInt();
                }
                ui->tableWidget->setItem(i,3+k,new QTableWidgetItem(QString::number(val)));
            }
            ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val)));

        }

        if(i==71){ // å¤„分
            int val = 0;
            for(int j = 72;j<=74;++j){
                val += ui->tableWidget->item(j,3)->text().toInt();
            for(int k=0;k<6;++k){
                int val = 0;
                for(int j = 72;j<=74;++j){
                    val += ui->tableWidget->item(j,3+k)->text().toInt();
                }
                ui->tableWidget->setItem(i,3+k,new QTableWidgetItem(QString::number(val)));
            }
            ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val)));

        }
    }
}
@@ -711,6 +736,20 @@
        ui->tableWidget->setItemDelegateForColumn(8,m_tableItemDelegate);
    }

    // ä¿®æ”¹èƒŒæ™¯è‰²
    QColor selectColor(142,213,213);
    QColor unSelectColor(255,255,255);
    QMap<QString,int> index={{"企业(不含金融企业)",4},{"金融企业",5},{"机关",6},{"事业单位",7},{"其他",8}};
    for(int i=4;i<9;++i){
        for(int j=0;j<ui->tableWidget->rowCount();++j){
            if(i==index[arg1]){
                ui->tableWidget->item(j,i)->setBackgroundColor(selectColor);
            }else{
                ui->tableWidget->item(j,i)->setBackgroundColor(unSelectColor);
            }
        }
    }

}

void ClientMainWindow::on_pushButton_reset_clicked()

 internal_system_v1/exporttofile.cpp

@@ -223,12 +223,15 @@
{
    qDebug()<<"内审综合保存导出";

    if(name.size() == 0) return -1; // æ–‡ä»¶ä¸ºç©º
    if(name.size() == 0) {
        QMessageBox::information(nullptr,"公司名为空","请选择一个公司再导出保存");
        return -1; // æ–‡ä»¶ä¸ºç©º
    }

    QString demoPath = QDir::currentPath()+"/Data/附件4_内审统03表_内部审计统计综合表_demo.xls";
    QString demoPath = QDir::currentPath()+"/Data/附件4_内审统03表_内部审计统计综合表.xls";
    QDir dir(demoPath);
    if(!dir.exists()){
        demoPath = QDir::currentPath()+"/release/Data/附件4_内审统03表_内部审计统计综合表_demo.xls";
        demoPath = QDir::currentPath()+"/release/Data/附件4_内审统03表_内部审计统计综合表.xls";
    }
    QString dt = QDateTime::currentDateTime().toString("yyyyMMdd-HHmmss");
    QString savePath = QFileDialog::getSaveFileName(nullptr,"保存文件",QDir::currentPath()+QString("/综合表_%1_%2.xls").arg(name).arg(dt),"Excel File(*.xls;*.xlsx)");
@@ -260,20 +263,167 @@
        // ä¿®æ”¹å†…容

        // å›› é¡¹ç›®å®¡è®¡  å•ä½ ä¸ª
        char index[5]={'G','H','I','J','K'};
        char index[5]={'F','G','H','I','J'};

        for(int i=0;i<5;++i){
            QString cellStr = QString("%1%2").arg(index[i]).arg(40);
            qDebug()<<cellStr<<nszh.code_030300[i];
            qDebug()<<"修改之前:"<<sheet->querySubObject("Range(QVariant, QVariant)", cellStr)->property("Value2").toInt();
            sheet->querySubObject("Range(QVariant, QVariant)", cellStr)->setProperty("Value2", nszh.code_030300[i]); // å®¡è®¡é¡¹ç›®
            qDebug()<<"修改结果:"<<sheet->querySubObject("Range(QVariant, QVariant)", cellStr)->property("Value2").toInt();
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(39))->setProperty("Value2", nszh.code_030300[i]); // å®¡è®¡é¡¹ç›®
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(41))->setProperty("Value2", nszh.code_030301[i]); // å…¶ä¸­ï¼šè´¯å½»è½å®žå›½å®¶é‡å¤§æ”¿ç­–措施审计
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(40))->setProperty("Value2", nszh.code_030301[i]); // å…¶ä¸­ï¼šè´¯å½»è½å®žå›½å®¶é‡å¤§æ”¿ç­–措施审计
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(41))->setProperty("Value2", nszh.code_030302[i]); // è´¢æ”¿è´¢åŠ¡æ”¶æ”¯å®¡è®¡
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(42))->setProperty("Value2", nszh.code_030303[i]); // å›ºå®šèµ„产投资审计
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(43))->setProperty("Value2", nszh.code_030304[i]); // å†…部控制和风险管理审计
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(44))->setProperty("Value2", nszh.code_030305[i]); // ç»æµŽè´£ä»»å®¡è®¡
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(45))->setProperty("Value2", nszh.code_030306[i]); // ä¿¡æ¯ç³»ç»Ÿå®¡è®¡
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(46))->setProperty("Value2", nszh.code_030307[i]); // å¢ƒå¤–审计
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(47))->setProperty("Value2", nszh.code_030308[i]); // å…¶ä»–
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(48))->setProperty("Value2", nszh.code_030310[i]); // å…¶ä¸­ï¼šå§”托外包项目
        }

        qDebug()<<40;
        qDebug()<<39;

        // äº” æœ¬å¡«æŠ¥å‘¨æœŸå†…部审计工作量  éšè—

        // å…­ã€å®¡è®¡å‘现问题金额 å•ä½ å…ƒ
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(50))->setProperty("Value2", nszh.code_030500[i]); // å®¡è®¡å‘现问题金额
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(51))->setProperty("Value2", nszh.code_030510[i]); // å…¶ä¸­ï¼šç»©æ•ˆç±»é—®é¢˜é‡‘额
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(52))->setProperty("Value2", nszh.code_030520[i]); // åˆè§„性问题金额
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(53))->setProperty("Value2", nszh.code_030521[i]); // å…¶ä¸­ï¼šä¼šè®¡æ ¸ç®—方面
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(54))->setProperty("Value2", nszh.code_030522[i]); // è¿è§„使用资金
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(55))->setProperty("Value2", nszh.code_030523[i]); // æˆªç•™ã€æ²‰æ·€èµ„金
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(56))->setProperty("Value2", nszh.code_030524[i]); // æŸå¤±æµªè´¹
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(57))->setProperty("Value2", nszh.code_030525[i]); // æŒªç”¨èµ„金
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(58))->setProperty("Value2", nszh.code_030526[i]); // å·æ¼ç¨Žè´¹
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(59))->setProperty("Value2", nszh.code_030527[i]); // è¿è§„取得收入
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(60))->setProperty("Value2", nszh.code_030528[i]); // å…¶ä»–
        }


        // ä¸ƒã€å®¡è®¡å‘现问题个数
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(61))->setProperty("Value2", nszh.code_030600[i]); // å®¡è®¡å‘现问题个数
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(62))->setProperty("Value2", nszh.code_030610[i]); // å…¶ä¸­ï¼šé‡‘额类问题个数
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(63))->setProperty("Value2", nszh.code_030620[i]); // éžé‡‘额类问题个数
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(64))->setProperty("Value2", nszh.code_030621[i]); // å…¶ä¸­ï¼šå›½å®¶æ”¿ç­–措施落实方面
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(65))->setProperty("Value2", nszh.code_030622[i]); // å‘展规划与战略决策方面
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(66))->setProperty("Value2", nszh.code_030623[i]); // å†…部控制与风险管理方面
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(67))->setProperty("Value2", nszh.code_030624[i]); // å…¶ä»–
        }


        // å…«ã€å®¡è®¡å‘现问题整改（金额类）  å•ä½ å…ƒ
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(68))->setProperty("Value2", nszh.code_030700[i]); // å®¡è®¡å‘现问题整改（金额类）
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(69))->setProperty("Value2", nszh.code_030701[i]); // å…¶ä¸­ï¼šè°ƒæ•´ä¼šè®¡è´¦ç›®
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(70))->setProperty("Value2", nszh.code_030702[i]); // æ”¶å›žèµ„金
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(71))->setProperty("Value2", nszh.code_030703[i]); // æŒ½å›žæŸå¤±
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(72))->setProperty("Value2", nszh.code_030704[i]); // å½’还原资金渠道
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(73))->setProperty("Value2", nszh.code_030705[i]); // è¡¥ç¼´ç¨Žè´¹
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(74))->setProperty("Value2", nszh.code_030706[i]); // å…¶ä»–
        }


        // ä¹ã€å®¡è®¡å‘现问题整改（非金额类）  å•ä½ ä¸ª
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(75))->setProperty("Value2", nszh.code_030800[i]); // å®¡è®¡å‘现问题整改（非金额类）
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(76))->setProperty("Value2", nszh.code_030801[i]); // å…¶ä¸­ï¼šæ–°åˆ¶å®šåˆ¶åº¦
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(77))->setProperty("Value2", nszh.code_030802[i]); // ä¿®è®¢å®Œå–„制度
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(78))->setProperty("Value2", nszh.code_030803[i]); // ä¼˜åŒ–完善业务流程
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(79))->setProperty("Value2", nszh.code_030804[i]); // å…¶ä»–
        }


        // åã€æ ¹æ®å®¡è®¡å»ºè®®ç»™äºˆå…šçºªã€æ”¿åŠ¡å’Œå†…部纪律处分  å•ä½ äºº
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(80))->setProperty("Value2", nszh.code_030900[i]); // æ ¹æ®å®¡è®¡å»ºè®®ç»™äºˆå…šçºªã€æ”¿åŠ¡å’Œå†…部纪律处分
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(81))->setProperty("Value2", nszh.code_030901[i]); // å…¶ä¸­ï¼šå…šçºªå¤„分
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(82))->setProperty("Value2", nszh.code_030902[i]); // æ”¿åŠ¡å¤„分
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(83))->setProperty("Value2", nszh.code_030903[i]); // å†…部纪律处分
        }


        // åä¸€ã€å‘司法机关移送或报告案件线索
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(84))->setProperty("Value2", nszh.code_031000[i]); // å‘司法机关移送或报告案件线索
        }
        for(int i=0;i<5;++i){
            sheet->querySubObject("Range(QVariant, QVariant)", QString("%1%2").arg(index[i]).arg(85))->setProperty("Value2", nszh.code_031001[i]); // å…¶ä¸­ï¼šæ¶‰æ¡ˆäººå‘˜
        }


        // å®Œäº‹äº†ï¼Œç»“束，保存或者退出

 ÐÞ¸Ä_241015/ÄÚÉóϵͳ´æÔÚÎÊÌâ·´À¡1015.docx

Binary files differ

 ¸½¼þ4_ÄÚÉóͳ03±í_ÄÚ²¿Éó¼Æͳ¼Æ×ۺϱí.xls

Binary files differ