From cefa8da6b9d9765bc8af450210c34d2e080840b2 Mon Sep 17 00:00:00 2001
From: wumu <mayi@mayi.com>
Date: 星期二, 27 二月 2024 22:03:30 +0800
Subject: [PATCH] 0227
---
internal_system_v1/converinfo2.cpp | 233 +++++++++++++++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 221 insertions(+), 12 deletions(-)
diff --git a/internal_system_v1/converinfo2.cpp b/internal_system_v1/converinfo2.cpp
index ac5178e..b7cefa2 100644
--- a/internal_system_v1/converinfo2.cpp
+++ b/internal_system_v1/converinfo2.cpp
@@ -6,6 +6,8 @@
#include <QSqlQuery>
#include <QSqlRecord>
+#pragma execution_character_set("utf-8")
+
ConverInfo2::ConverInfo2(QWidget *parent) :
QMainWindow(parent),
ui(new Ui::ConverInfo2)
@@ -95,7 +97,73 @@
void ConverInfo2::on_treeWidget_doubleClicked(const QModelIndex &index)
{
- qDebug()<<"鍙屽嚮"<<index;
+ QString name = index.model()->data(index).toString();
+ qDebug()<<"鍙屽嚮"<<index<<name;
+ ComInfo curCominfo = m_nameAndComInfos[name];
+ // 涓�銆佸崟浣嶅熀鏈儏鍐�
+ ui->lineEdit_creditCode->setText(curCominfo.creditCode);
+ ui->lineEdit_name->setText(QString::fromLocal8Bit( curCominfo.name));
+ qDebug()<<"name:"<<QString::fromLocal8Bit( curCominfo.name)<<QByteArray(curCominfo.name);
+ ui->comboBox_comType->setCurrentText(QString::fromLocal8Bit(curCominfo.comType));
+ ui->lineEdit_business->setText(QString::fromLocal8Bit(curCominfo.business));
+ ui->lineEdit_businessCode->setText(curCominfo.businessCode);
+ ui->lineEdit_addr->setText(QString::fromLocal8Bit(curCominfo.addr));
+ ui->lineEdit_areaCode->setText(curCominfo.areaCode);
+ ui->lineEdit_townCode->setText(curCominfo.townCode);
+ ui->comboBox_scale->setCurrentText(QString::fromLocal8Bit(curCominfo.scale));
+ ui->lineEdit_people->setText(QString::number(curCominfo.people));
+ ui->lineEdit_representative->setText(QString::fromLocal8Bit(curCominfo.representative));
+ ui->comboBox_standardType->setCurrentText(QString::fromLocal8Bit(curCominfo.standardType));
+ ui->lineEdit_trunkCode->setText(curCominfo.trunkCode);
+ ui->lineEdit_fixedTel->setText(curCominfo.fixedTel);
+ ui->lineEdit_postCode->setText(curCominfo.postCode);
+ ui->lineEdit_email->setText(curCominfo.email);
+ ui->lineEdit_webSite->setText(curCominfo.webSite);
+
+ // 浜屻�佸崟浣嶇粍缁囩粨鏋勬儏鍐�
+ ui->comboBox_hasUpLegal->setCurrentText(QString::fromLocal8Bit(curCominfo.hasUpLegal));
+ ui->lineEdit_upCreditCode->setText(curCominfo.upCreditCode);
+ ui->lineEdit_oldCreditCode->setText(curCominfo.oldCreditCode);
+ ui->lineEdit_upName->setText(QString::fromLocal8Bit(curCominfo.upName));
+
+ // 涓夈�佹�诲璁″笀涓庡唴瀹℃満鏋勫熀鏈儏鍐�
+ ui->comboBox_hasChiefDesigner->setCurrentText(QString::fromLocal8Bit(curCominfo.hasChiefDesigner));
+ ui->comboBox_ChiefDesignerLevel->setCurrentText(QString::fromLocal8Bit(curCominfo.ChiefDesignerLevel));
+ ui->comboBox_employmentMode->setCurrentText(QString::fromLocal8Bit(curCominfo.employmentMode));
+ ui->comboBox_hasSetIntervalAudit->setCurrentText(QString::fromLocal8Bit(curCominfo.hasSetIntervalAudit));
+ ui->lineEdit_internalName->setText(QString::fromLocal8Bit(curCominfo.internalName));
+ ui->comboBox_leadingOrganization->setCurrentText(QString::fromLocal8Bit(curCominfo.leadingOrganization));
+ ui->comboBox_hasSetSeparateIA->setCurrentText(QString::fromLocal8Bit(curCominfo.hasSetSeparateIA));
+ ui->checkBox_financeDepartment->setChecked(curCominfo.financeDepartment);
+ ui->checkBox_legalDepartment->setChecked(curCominfo.legalDepartment);
+ ui->checkBox_internalConDepart->setChecked(curCominfo.internalConDepart);
+ ui->checkBox_disceplineInDepart->setChecked(curCominfo.disceplineInDepart);
+ ui->checkBox_otherDepart->setChecked(curCominfo.otherDepart);
+ ui->comboBox_intavalAuditLeval->setCurrentText(QString::fromLocal8Bit(curCominfo.intavalAuditLeval));
+
+ // 鍥涖�佸唴瀹′汉鍛橀厤澶囧熀鏈儏鍐�
+ ui->lineEdit_organazationNum->setText(QString::number(curCominfo.organazationNum));
+ ui->lineEdit_realNum->setText(QString::number(curCominfo.realNum));
+ ui->lineEdit_professionalNum->setText(QString::number(curCominfo.professionalNum));
+ ui->lineEdit_CIANum->setText(QString::number(curCominfo.CIANum));
+ ui->lineEdit_masterNum->setText(QString::number(curCominfo.masterNum));
+ ui->lineEdit_undergraduatesNum->setText(QString::number(curCominfo.undergraduatesNum));
+ ui->lineEdit_juniorNum->setText(QString::number(curCominfo.juniorNum));
+ ui->lineEdit_seniorNum->setText(QString::number(curCominfo.seniorNum));
+ ui->lineEdit_intermediateNum->setText(QString::number(curCominfo.intermediateNum));
+ ui->lineEdit_primaryNum->setText(QString::number(curCominfo.primaryNum));
+ ui->lineEdit_noTitleNum->setText(QString::number(curCominfo.noTitleNum));
+ ui->lineEdit_upFiftyOldNum->setText(QString::number(curCominfo.upFiftyOldNum));
+ ui->lineEdit_upThirtyOldNum->setText(QString::number(curCominfo.upThirtyOldNum));
+ ui->lineEdit_downThirtyOldNum->setText(QString::number(curCominfo.downThirtyOldNum));
+ ui->lineEdit_auditNum->setText(QString::number(curCominfo.auditNum));
+ ui->lineEdit_accountingNum->setText(QString::number(curCominfo.accountingNum));
+ ui->lineEdit_economyNum->setText(QString::number(curCominfo.economyNum));
+ ui->lineEdit_lawNum->setText(QString::number(curCominfo.lawNum));
+ ui->lineEdit_managerNum->setText(QString::number(curCominfo.managerNum));
+ ui->lineEdit_itNum->setText(QString::number(curCominfo.itNum));
+ ui->lineEdit_engineeringNum->setText(QString::number(curCominfo.engineeringNum));
+ ui->lineEdit_otherNum->setText(QString::number(curCominfo.otherNum));
}
void ConverInfo2::readInfo()
@@ -142,6 +210,8 @@
//QAxObject* pWorkBook = excel.querySubObject("ActiveWorkBook");
//QAxObject* pWorkSheets = pWorkBook->querySubObject("Sheets");//鑾峰彇宸ヤ綔琛�
QAxObject * shs = wb->querySubObject("Sheets"); // WorkSheets 涔熷彲浠�
+// QAxObject *checkBoxs = shs->querySubObject("CheckBoxes");
+// qDebug() << "澶嶉�夋:checkBoxs:" << checkBoxs->asVariant();
int cnt = shs->property("Count").toInt();
qDebug()<<"cnt="<<cnt;
for(int i=0;i<cnt;++i){
@@ -155,16 +225,16 @@
QVariant val = usedRange->dynamicCall("Value"); // 鎷垮埌浜岀淮琛ㄦ牸
QVariantList valRows = val.toList();
// 閬嶅巻姣忎竴椤�
- for(int i=0;i<rows;++i){
- QVariantList valrow = valRows[i].toList();
- for(int j=0;j<columns;++j){
- QVariant valData = valrow[j];
- if(valData.isValid()){
- qDebug()<<"val:"<< i<< j << valData;
- }
+// for(int i=0;i<rows;++i){
+// QVariantList valrow = valRows[i].toList();
+// for(int j=0;j<columns;++j){
+// QVariant valData = valrow[j];
+// if(valData.isValid()){
+// qDebug()<<"val:"<< i<< j << valData;
+// }
- }
- }
+// }
+// }
// 瀹炰緥鍖栫粨鏋勪綋锛岀劧鍚庢尐涓祴鍊�
ComInfo curComInfo;
@@ -181,6 +251,7 @@
ui->label_name->setText(name.toString());
QTreeWidgetItem *top1 = new QTreeWidgetItem(ui->treeWidget);
top1->setText(0,name.toString());
+ strcpy(curComInfo.name,name.toString().toLocal8Bit().data());
}else{
ui->label_name->setText("");
@@ -411,8 +482,9 @@
strcpy(curComInfo.hasSetSeparateIA,hasSetSeparateIA.toString().toLocal8Bit().data());
qDebug()<<"hasSetSeparateIA"<<hasSetSeparateIA;
}
- // 鍚堝苟璁剧疆 璐㈠姟閮ㄩ棬
- QVariant financeDepartment = valRows[55].toList().at(4);
+ // 鍚堝苟璁剧疆 璐㈠姟閮ㄩ棬 澶嶉�夋
+
+ QVariant financeDepartment = valRows[55].toList().at(1);
if(financeDepartment.isValid()){
//strcpy(curComInfo.financeDepartment,financeDepartment.toString().toLocal8Bit().data());
curComInfo.financeDepartment = financeDepartment.toBool();
@@ -427,6 +499,143 @@
qDebug()<<"intavalAuditLeval"<<intavalAuditLeval;
}
+ // 鍥涖�佸唴瀹′汉鍛橀厤澶囧熀鏈儏鍐�
+ // 缂栧埗鏁�
+ QVariant organazationNum = valRows[56].toList().at(4);
+ if(organazationNum.isValid()){
+ curComInfo.organazationNum = organazationNum.toInt();
+ qDebug()<<"organazationNum"<<organazationNum;
+ }
+ // 瀹炴湁浜哄憳鏁�
+ QVariant realNum = valRows[56].toList().at(4);
+ if(realNum.isValid()){
+ curComInfo.realNum = realNum.toInt();
+ qDebug()<<"realNum"<<realNum;
+ }
+ // 涓撹亴浜哄憳鏁�
+ QVariant professionalNum = valRows[56].toList().at(4);
+ if(professionalNum.isValid()){
+ curComInfo.professionalNum = professionalNum.toInt();
+ qDebug()<<"professionalNum"<<professionalNum;
+ }
+ // 鎷ユ湁CIA浜哄憳鏁�
+ QVariant CIANum = valRows[56].toList().at(4);
+ if(CIANum.isValid()){
+ curComInfo.CIANum = CIANum.toInt();
+ qDebug()<<"CIANum"<<CIANum;
+ }
+ // 瀛﹀巻锛氱澹強浠ヤ笂 浜哄憳鏁�
+ QVariant masterNum = valRows[56].toList().at(4);
+ if(masterNum.isValid()){
+ curComInfo.masterNum = masterNum.toInt();
+ qDebug()<<"masterNum"<<masterNum;
+ }
+ // 澶у鏈
+ QVariant undergraduatesNum = valRows[56].toList().at(4);
+ if(undergraduatesNum.isValid()){
+ curComInfo.undergraduatesNum = undergraduatesNum.toInt();
+ qDebug()<<"undergraduatesNum"<<undergraduatesNum;
+ }
+ // 涓撶鍙婁互涓�
+ QVariant juniorNum = valRows[56].toList().at(4);
+ if(juniorNum.isValid()){
+ curComInfo.juniorNum = juniorNum.toInt();
+ qDebug()<<"juniorNum"<<juniorNum;
+ }
+
+ // 鑱岀О 楂樼骇鑱岀О
+ QVariant seniorNum = valRows[56].toList().at(4);
+ if(seniorNum.isValid()){
+ curComInfo.seniorNum = seniorNum.toInt();
+ qDebug()<<"seniorNum"<<seniorNum;
+ }
+ // 涓骇鑱岀О
+ QVariant intermediateNum = valRows[56].toList().at(4);
+ if(intermediateNum.isValid()){
+ curComInfo.intermediateNum = intermediateNum.toInt();
+ qDebug()<<"intermediateNum"<<intermediateNum;
+ }
+ // 鍒濈骇鑱岀О
+ QVariant primaryNum = valRows[56].toList().at(4);
+ if(primaryNum.isValid()){
+ curComInfo.primaryNum = primaryNum.toInt();
+ qDebug()<<"primaryNum"<<primaryNum;
+ }
+ // 鏃犺亴绉�
+ QVariant noTitleNum = valRows[56].toList().at(4);
+ if(noTitleNum.isValid()){
+ curComInfo.noTitleNum = noTitleNum.toInt();
+ qDebug()<<"noTitleNum"<<noTitleNum;
+ }
+
+ // 骞撮緞缁撴瀯 50宀佷互涓�
+ QVariant upFiftyOldNum = valRows[56].toList().at(4);
+ if(upFiftyOldNum.isValid()){
+ curComInfo.upFiftyOldNum = upFiftyOldNum.toInt();
+ qDebug()<<"upFiftyOldNum"<<upFiftyOldNum;
+ }
+ // 30-50宀�
+ QVariant upThirtyOldNum = valRows[56].toList().at(4);
+ if(upThirtyOldNum.isValid()){
+ curComInfo.upThirtyOldNum = upThirtyOldNum.toInt();
+ qDebug()<<"upThirtyOldNum"<<upThirtyOldNum;
+ }
+ // 30宀佷互涓�
+ QVariant downThirtyOldNum = valRows[56].toList().at(4);
+ if(downThirtyOldNum.isValid()){
+ curComInfo.downThirtyOldNum = downThirtyOldNum.toInt();
+ qDebug()<<"downThirtyOldNum"<<downThirtyOldNum;
+ }
+
+ // 鐭ヨ瘑缁撴瀯 瀹¤
+ QVariant auditNum = valRows[56].toList().at(4);
+ if(auditNum.isValid()){
+ curComInfo.auditNum = auditNum.toInt();
+ qDebug()<<"auditNum"<<auditNum;
+ }
+ // 浼氳
+ QVariant accountingNum = valRows[56].toList().at(4);
+ if(accountingNum.isValid()){
+ curComInfo.accountingNum = accountingNum.toInt();
+ qDebug()<<"accountingNum"<<accountingNum;
+ }
+ // 缁忔祹
+ QVariant economyNum = valRows[56].toList().at(4);
+ if(economyNum.isValid()){
+ curComInfo.economyNum = economyNum.toInt();
+ qDebug()<<"economyNum"<<economyNum;
+ }
+ // 娉曞緥
+ QVariant lawNum = valRows[56].toList().at(4);
+ if(lawNum.isValid()){
+ curComInfo.lawNum = lawNum.toInt();
+ qDebug()<<"lawNum"<<lawNum;
+ }
+ // 绠＄悊
+ QVariant managerNum = valRows[56].toList().at(4);
+ if(managerNum.isValid()){
+ curComInfo.managerNum = managerNum.toInt();
+ qDebug()<<"managerNum"<<managerNum;
+ }
+ // 淇℃伅鎶�鏈�
+ QVariant itNum = valRows[56].toList().at(4);
+ if(itNum.isValid()){
+ curComInfo.itNum = itNum.toInt();
+ qDebug()<<"itNum"<<itNum;
+ }
+ // 宸ョ▼
+ QVariant engineeringNum = valRows[56].toList().at(4);
+ if(engineeringNum.isValid()){
+ curComInfo.engineeringNum = engineeringNum.toInt();
+ qDebug()<<"engineeringNum"<<engineeringNum;
+ }
+ // 鍏朵粬
+ QVariant otherNum = valRows[56].toList().at(4);
+ if(otherNum.isValid()){
+ curComInfo.otherNum = otherNum.toInt();
+ qDebug()<<"otherNum"<<otherNum;
+ }
+
// 鏈�鍚庡瓨鍒癿ap涓�
m_nameAndComInfos[name.toString()]=curComInfo;
--
Gitblit v1.8.0