From 332ab3cdf6fd91e5cee4f0a773ab2b270df2ed66 Mon Sep 17 00:00:00 2001 From: wumu <mayi@mayi.com> Date: 星期三, 20 九月 2023 23:18:51 +0800 Subject: [PATCH] 0921 --- internal_system_v1/auditproject.cpp | 9 + internal_system_v1/clientmainwindow.cpp | 3 internal_system_v1/punish.cpp | 4 internal_system_v1/problemrectification.cpp | 8 + internal_system_v1/auditworkload.cpp | 2 internal_system_v1/problemcount.cpp | 4 internal_system_v1/problemmoney.h | 4 internal_system_v1/problemmoney.cpp | 25 ++++ internal_system_v1/problemnotmoney.cpp | 4 internal_system_v1/coverinfo.cpp | 253 ++++++++++++++++++++++++++++++++++++++---- internal_system_v1/caseclue.cpp | 2 目前系统需优化的地方_0920.docx | 0 12 files changed, 291 insertions(+), 27 deletions(-) diff --git a/internal_system_v1/auditproject.cpp b/internal_system_v1/auditproject.cpp index 2c09921..11bdfb1 100644 --- a/internal_system_v1/auditproject.cpp +++ b/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))); } diff --git a/internal_system_v1/auditworkload.cpp b/internal_system_v1/auditworkload.cpp index 611da80..8264d0d 100644 --- a/internal_system_v1/auditworkload.cpp +++ b/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) diff --git a/internal_system_v1/caseclue.cpp b/internal_system_v1/caseclue.cpp index 4b8a34c..058b291 100644 --- a/internal_system_v1/caseclue.cpp +++ b/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) diff --git a/internal_system_v1/clientmainwindow.cpp b/internal_system_v1/clientmainwindow.cpp index ee72cbb..579c8e8 100644 --- a/internal_system_v1/clientmainwindow.cpp +++ b/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; } diff --git a/internal_system_v1/coverinfo.cpp b/internal_system_v1/coverinfo.cpp index f211e18..b1eb2ea 100644 --- a/internal_system_v1/coverinfo.cpp +++ b/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(""); } // 涓氬姟浠g爜 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(""); + } // 鍖哄煙浠g爜 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(""); + } // 鍩庝埂浠g爜 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(); // 缁熶竴淇$敤浠g爜 +// 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); +// } +// // 涓氬姟浠g爜 +// 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); +// // 鍖哄煙浠g爜 +// QVariant areaCode = valRows[24].toList().at(2); +// if(areaCode.isValid()) ui->label_areaCode->setText(areaCode.toString()); +// // 鍩庝埂浠g爜 +// 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()); + + // 缁熶竴淇$敤浠g爜 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(""); } // 涓氬姟浠g爜 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(""); + } // 鍖哄煙浠g爜 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(""); + } // 鍩庝埂浠g爜 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 纭鏁版嵁杩涘埌琛ㄤ腑 diff --git a/internal_system_v1/problemcount.cpp b/internal_system_v1/problemcount.cpp index 1117191..d7e89e1 100644 --- a/internal_system_v1/problemcount.cpp +++ b/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()); } diff --git a/internal_system_v1/problemmoney.cpp b/internal_system_v1/problemmoney.cpp index b55a4fb..b592b42 100644 --- a/internal_system_v1/problemmoney.cpp +++ b/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()); } diff --git a/internal_system_v1/problemmoney.h b/internal_system_v1/problemmoney.h index 84ccd40..4295eaa 100644 --- a/internal_system_v1/problemmoney.h +++ b/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; diff --git a/internal_system_v1/problemnotmoney.cpp b/internal_system_v1/problemnotmoney.cpp index 6f07fa2..5c3b0d1 100644 --- a/internal_system_v1/problemnotmoney.cpp +++ b/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()); } diff --git a/internal_system_v1/problemrectification.cpp b/internal_system_v1/problemrectification.cpp index ed5b2dd..43cdd79 100644 --- a/internal_system_v1/problemrectification.cpp +++ b/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()); } diff --git a/internal_system_v1/punish.cpp b/internal_system_v1/punish.cpp index 3cfa550..2868e26 100644 --- a/internal_system_v1/punish.cpp +++ b/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()); } diff --git "a/\347\233\256\345\211\215\347\263\273\347\273\237\351\234\200\344\274\230\345\214\226\347\232\204\345\234\260\346\226\271_0920.docx" "b/\347\233\256\345\211\215\347\263\273\347\273\237\351\234\200\344\274\230\345\214\226\347\232\204\345\234\260\346\226\271_0920.docx" new file mode 100644 index 0000000..7df7e38 --- /dev/null +++ "b/\347\233\256\345\211\215\347\263\273\347\273\237\351\234\200\344\274\230\345\214\226\347\232\204\345\234\260\346\226\271_0920.docx" Binary files differ -- Gitblit v1.8.0