From 7dd76d103a351caae20261fc7bb67d01bd66e906 Mon Sep 17 00:00:00 2001
From: wumu <mayi@mayi.com>
Date: 星期三, 28 二月 2024 23:52:02 +0800
Subject: [PATCH] 0228
---
internal_system_v1/converinfo2.cpp | 91 +++++++++++++++++++++++++++++++++++++++------
1 files changed, 78 insertions(+), 13 deletions(-)
diff --git a/internal_system_v1/converinfo2.cpp b/internal_system_v1/converinfo2.cpp
index b7cefa2..9160e92 100644
--- a/internal_system_v1/converinfo2.cpp
+++ b/internal_system_v1/converinfo2.cpp
@@ -122,7 +122,7 @@
// 浜屻�佸崟浣嶇粍缁囩粨鏋勬儏鍐�
ui->comboBox_hasUpLegal->setCurrentText(QString::fromLocal8Bit(curCominfo.hasUpLegal));
- ui->lineEdit_upCreditCode->setText(curCominfo.upCreditCode);
+ ui->lineEdit_upCreditCode->setText(QString::fromLocal8Bit(curCominfo.upCreditCode));
ui->lineEdit_oldCreditCode->setText(curCominfo.oldCreditCode);
ui->lineEdit_upName->setText(QString::fromLocal8Bit(curCominfo.upName));
@@ -164,6 +164,12 @@
ui->lineEdit_itNum->setText(QString::number(curCominfo.itNum));
ui->lineEdit_engineeringNum->setText(QString::number(curCominfo.engineeringNum));
ui->lineEdit_otherNum->setText(QString::number(curCominfo.otherNum));
+
+ // 鍏朵粬鐨�4涓俊鎭�
+ ui->lineEdit_statisticalConOfficer->setText(QString::fromLocal8Bit(curCominfo.statisticalConOfficer));
+ ui->lineEdit_personFilling->setText(QString::fromLocal8Bit(curCominfo.personFilling));
+ ui->lineEdit_officerTel->setText(QString::fromLocal8Bit(curCominfo.officerTel));
+ ui->lineEdit_fillingDateTime->setText(QString::fromLocal8Bit(curCominfo.fillingDateTime));
}
void ConverInfo2::readInfo()
@@ -209,9 +215,13 @@
QAxObject * wb = wbs->querySubObject("Open(QString&)",str);
//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();
+ //QAxObject * shs = wb->querySubObject("Sheets"); // WorkSheets 涔熷彲浠�
+ QAxObject * shs = wb->querySubObject("WorkSheets"); // WorkSheets 涔熷彲浠�
+// // 鎸囧畾鍗曞厓鏍兼嬁
+// QAxObject *cell = shs->querySubObject("Cells(int, int)",82,1);
+// qDebug()<<"Cells:82-0:"<<shs->querySubObject("Cells(int, int)",82,0)->dynamicCall("Value()").toString();
+// qDebug()<<"Cells:82-1:"<<cell->dynamicCall("Value()").toString();
+
int cnt = shs->property("Count").toInt();
qDebug()<<"cnt="<<cnt;
for(int i=0;i<cnt;++i){
@@ -225,16 +235,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;
@@ -636,6 +646,34 @@
qDebug()<<"otherNum"<<otherNum;
}
+ // 鍚庨潰鐨�4涓俊鎭�
+ // 缁熻璐熻矗浜�
+ QVariant statisticalConOfficer = valRows[81].toList().at(1);
+ if(statisticalConOfficer.isValid()){
+ strcpy(curComInfo.statisticalConOfficer,statisticalConOfficer.toString().toLocal8Bit().data());
+ qDebug()<<"statisticalConOfficer"<<statisticalConOfficer;
+ }else{
+ qDebug()<<"statisticalConOfficer fail:"<<name.toString();
+ }
+ // 濉〃浜�
+ QVariant personFilling = valRows[81].toList().at(4);
+ if(personFilling.isValid()){
+ strcpy(curComInfo.personFilling,personFilling.toString().toLocal8Bit().data());
+ qDebug()<<"personFilling"<<personFilling;
+ }
+ // 鑱旂郴鐢佃瘽
+ QVariant officerTel = valRows[82].toList().at(1);
+ if(officerTel.isValid()){
+ strcpy(curComInfo.officerTel,officerTel.toString().toLocal8Bit().data());
+ qDebug()<<"officerTel"<<officerTel;
+ }
+ // 濉姤鏃ユ湡
+ QVariant fillingDateTime = valRows[82].toList().at(4);
+ if(fillingDateTime.isValid()){
+ strcpy(curComInfo.fillingDateTime,fillingDateTime.toString().toLocal8Bit().data());
+ qDebug()<<"fillingDateTime"<<fillingDateTime;
+ }
+
// 鏈�鍚庡瓨鍒癿ap涓�
m_nameAndComInfos[name.toString()]=curComInfo;
@@ -671,3 +709,30 @@
connect(m_menu->actions().at(0),SIGNAL(triggered(bool)),this,SLOT(deleteInfo()));
connect(m_menu->actions().at(1),SIGNAL(triggered(bool)),this,SLOT(addInfo()));
}
+
+void ConverInfo2::on_pushButton_commit_clicked()
+{
+ // 灏嗙紪杈戞鐨勬暟鎹洿鏂板埌map涓拰鏁版嵁搴撲腑锛屽悗鏈熷彲浠ユ洿鏂板埌鏂囦欢涓�
+ // 鍗曚綅鍩烘湰鎯呭喌
+ QString creditCode = ui->lineEdit_creditCode->text();
+ QString name = ui->lineEdit_name->text();
+ QString comType = ui->comboBox_comType->currentText();
+ QString business = ui->lineEdit_business->text();
+ QString businessCode = ui->lineEdit_businessCode->text();
+ QString addr = ui->lineEdit_addr->text();
+ QString areaCode = ui->lineEdit_areaCode->text();
+ QString townCode = ui->lineEdit_townCode->text();
+ QString scale = ui->comboBox_scale->currentText();
+ QString people = ui->lineEdit_people->text();
+ QString representative = ui->lineEdit_representative->text();
+ QString standardType = ui->comboBox_standardType->currentText();
+ QString trunkCode = ui->lineEdit_trunkCode->text();
+ QString fixedTel = ui->lineEdit_fixedTel->text();
+ QString postCode = ui->lineEdit_postCode->text();
+ QString email = ui->lineEdit_email->text();
+ QString webSite = ui->lineEdit_webSite->text();
+
+ // 鍗曚綅缁勭粐缁撴瀯鎯呭喌
+
+
+}
--
Gitblit v1.8.0