From 41da0809fad858e523f85dcf9cec3e1e874810ff Mon Sep 17 00:00:00 2001 From: wumu <mayi@mayi.com> Date: 星期五, 01 十一月 2024 23:35:04 +0800 Subject: [PATCH] 1101 --- internal_system_v1/clientmainwindow.cpp | 103 ++++++++++++++------ 修改_241015/内审系统存在问题反馈1015.docx | 0 附件4_内审统03表_内部审计统计综合表.xls | 0 internal_system_v1/exporttofile.cpp | 172 ++++++++++++++++++++++++++++++++-- 4 files changed, 232 insertions(+), 43 deletions(-) diff --git a/internal_system_v1/clientmainwindow.cpp b/internal_system_v1/clientmainwindow.cpp index aa67295..6ec89c0 100644 --- a/internal_system_v1/clientmainwindow.cpp +++ b/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() diff --git a/internal_system_v1/exporttofile.cpp b/internal_system_v1/exporttofile.cpp index 8a7533b..89cc27a 100644 --- a/internal_system_v1/exporttofile.cpp +++ b/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]); // 缁忔祹璐d换瀹¤ + } + 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]); // 鍏朵腑锛氭秹妗堜汉鍛� + } // 瀹屼簨浜嗭紝缁撴潫锛屼繚瀛樻垨鑰呴��鍑� diff --git "a/\344\277\256\346\224\271_241015/\345\206\205\345\256\241\347\263\273\347\273\237\345\255\230\345\234\250\351\227\256\351\242\230\345\217\215\351\246\2101015.docx" "b/\344\277\256\346\224\271_241015/\345\206\205\345\256\241\347\263\273\347\273\237\345\255\230\345\234\250\351\227\256\351\242\230\345\217\215\351\246\2101015.docx" index c4c9902..d52e909 100644 --- "a/\344\277\256\346\224\271_241015/\345\206\205\345\256\241\347\263\273\347\273\237\345\255\230\345\234\250\351\227\256\351\242\230\345\217\215\351\246\2101015.docx" +++ "b/\344\277\256\346\224\271_241015/\345\206\205\345\256\241\347\263\273\347\273\237\345\255\230\345\234\250\351\227\256\351\242\230\345\217\215\351\246\2101015.docx" Binary files differ diff --git "a/\351\231\204\344\273\2664_\345\206\205\345\256\241\347\273\23703\350\241\250_\345\206\205\351\203\250\345\256\241\350\256\241\347\273\237\350\256\241\347\273\274\345\220\210\350\241\250.xls" "b/\351\231\204\344\273\2664_\345\206\205\345\256\241\347\273\23703\350\241\250_\345\206\205\351\203\250\345\256\241\350\256\241\347\273\237\350\256\241\347\273\274\345\220\210\350\241\250.xls" index 9f281dd..e7183a3 100644 --- "a/\351\231\204\344\273\2664_\345\206\205\345\256\241\347\273\23703\350\241\250_\345\206\205\351\203\250\345\256\241\350\256\241\347\273\237\350\256\241\347\273\274\345\220\210\350\241\250.xls" +++ "b/\351\231\204\344\273\2664_\345\206\205\345\256\241\347\273\23703\350\241\250_\345\206\205\351\203\250\345\256\241\350\256\241\347\273\237\350\256\241\347\273\274\345\220\210\350\241\250.xls" Binary files differ -- Gitblit v1.8.0