From 162311be680b94a0dcd5250acbf36aead6350cb1 Mon Sep 17 00:00:00 2001
From: wumu <mayi@mayi.com>
Date: 星期三, 30 十月 2024 23:50:34 +0800
Subject: [PATCH] 1030
---
internal_system_v1/converinfo2.cpp | 83 ++++++++++++++++++++++++++++++-----------
1 files changed, 60 insertions(+), 23 deletions(-)
diff --git a/internal_system_v1/converinfo2.cpp b/internal_system_v1/converinfo2.cpp
index 466e8b9..0afa25e 100644
--- a/internal_system_v1/converinfo2.cpp
+++ b/internal_system_v1/converinfo2.cpp
@@ -570,136 +570,137 @@
// 鍥涖�佸唴瀹′汉鍛橀厤澶囧熀鏈儏鍐�
// 缂栧埗鏁�
- QVariant organazationNum = valRows[56].toList().at(4);
+ //QVariant organazationNum = valRows[56].toList().at(4);
+ QVariant organazationNum = valRows[60].toList().at(4);
if(organazationNum.isValid()){
curComInfo.organazationNum = organazationNum.toInt();
qDebug()<<"organazationNum"<<organazationNum;
}
// 瀹炴湁浜哄憳鏁�
- QVariant realNum = valRows[56].toList().at(4);
+ QVariant realNum = valRows[60].toList().at(6);
if(realNum.isValid()){
curComInfo.realNum = realNum.toInt();
qDebug()<<"realNum"<<realNum;
}
// 涓撹亴浜哄憳鏁�
- QVariant professionalNum = valRows[56].toList().at(4);
+ QVariant professionalNum = valRows[60].toList().at(8);
if(professionalNum.isValid()){
curComInfo.professionalNum = professionalNum.toInt();
qDebug()<<"professionalNum"<<professionalNum;
}
// 鎷ユ湁CIA浜哄憳鏁�
- QVariant CIANum = valRows[56].toList().at(4);
+ QVariant CIANum = valRows[61].toList().at(6);
if(CIANum.isValid()){
curComInfo.CIANum = CIANum.toInt();
qDebug()<<"CIANum"<<CIANum;
}
// 瀛﹀巻锛氱澹強浠ヤ笂 浜哄憳鏁�
- QVariant masterNum = valRows[56].toList().at(4);
+ QVariant masterNum = valRows[62].toList().at(6);
if(masterNum.isValid()){
curComInfo.masterNum = masterNum.toInt();
qDebug()<<"masterNum"<<masterNum;
}
// 澶у鏈
- QVariant undergraduatesNum = valRows[56].toList().at(4);
+ QVariant undergraduatesNum = valRows[63].toList().at(6);
if(undergraduatesNum.isValid()){
curComInfo.undergraduatesNum = undergraduatesNum.toInt();
qDebug()<<"undergraduatesNum"<<undergraduatesNum;
}
// 涓撶鍙婁互涓�
- QVariant juniorNum = valRows[56].toList().at(4);
+ QVariant juniorNum = valRows[64].toList().at(6);
if(juniorNum.isValid()){
curComInfo.juniorNum = juniorNum.toInt();
qDebug()<<"juniorNum"<<juniorNum;
}
// 鑱岀О 楂樼骇鑱岀О
- QVariant seniorNum = valRows[56].toList().at(4);
+ QVariant seniorNum = valRows[65].toList().at(6);
if(seniorNum.isValid()){
curComInfo.seniorNum = seniorNum.toInt();
qDebug()<<"seniorNum"<<seniorNum;
}
// 涓骇鑱岀О
- QVariant intermediateNum = valRows[56].toList().at(4);
+ QVariant intermediateNum = valRows[66].toList().at(6);
if(intermediateNum.isValid()){
curComInfo.intermediateNum = intermediateNum.toInt();
qDebug()<<"intermediateNum"<<intermediateNum;
}
// 鍒濈骇鑱岀О
- QVariant primaryNum = valRows[56].toList().at(4);
+ QVariant primaryNum = valRows[67].toList().at(6);
if(primaryNum.isValid()){
curComInfo.primaryNum = primaryNum.toInt();
qDebug()<<"primaryNum"<<primaryNum;
}
// 鏃犺亴绉�
- QVariant noTitleNum = valRows[56].toList().at(4);
+ QVariant noTitleNum = valRows[68].toList().at(6);
if(noTitleNum.isValid()){
curComInfo.noTitleNum = noTitleNum.toInt();
qDebug()<<"noTitleNum"<<noTitleNum;
}
// 骞撮緞缁撴瀯 50宀佷互涓�
- QVariant upFiftyOldNum = valRows[56].toList().at(4);
+ QVariant upFiftyOldNum = valRows[69].toList().at(6);
if(upFiftyOldNum.isValid()){
curComInfo.upFiftyOldNum = upFiftyOldNum.toInt();
qDebug()<<"upFiftyOldNum"<<upFiftyOldNum;
}
// 30-50宀�
- QVariant upThirtyOldNum = valRows[56].toList().at(4);
+ QVariant upThirtyOldNum = valRows[70].toList().at(6);
if(upThirtyOldNum.isValid()){
curComInfo.upThirtyOldNum = upThirtyOldNum.toInt();
qDebug()<<"upThirtyOldNum"<<upThirtyOldNum;
}
// 30宀佷互涓�
- QVariant downThirtyOldNum = valRows[56].toList().at(4);
+ QVariant downThirtyOldNum = valRows[71].toList().at(6);
if(downThirtyOldNum.isValid()){
curComInfo.downThirtyOldNum = downThirtyOldNum.toInt();
qDebug()<<"downThirtyOldNum"<<downThirtyOldNum;
}
// 鐭ヨ瘑缁撴瀯 瀹¤
- QVariant auditNum = valRows[56].toList().at(4);
+ QVariant auditNum = valRows[72].toList().at(6);
if(auditNum.isValid()){
curComInfo.auditNum = auditNum.toInt();
qDebug()<<"auditNum"<<auditNum;
}
// 浼氳
- QVariant accountingNum = valRows[56].toList().at(4);
+ QVariant accountingNum = valRows[73].toList().at(6);
if(accountingNum.isValid()){
curComInfo.accountingNum = accountingNum.toInt();
qDebug()<<"accountingNum"<<accountingNum;
}
// 缁忔祹
- QVariant economyNum = valRows[56].toList().at(4);
+ QVariant economyNum = valRows[74].toList().at(6);
if(economyNum.isValid()){
curComInfo.economyNum = economyNum.toInt();
qDebug()<<"economyNum"<<economyNum;
}
// 娉曞緥
- QVariant lawNum = valRows[56].toList().at(4);
+ QVariant lawNum = valRows[75].toList().at(6);
if(lawNum.isValid()){
curComInfo.lawNum = lawNum.toInt();
qDebug()<<"lawNum"<<lawNum;
}
// 绠＄悊
- QVariant managerNum = valRows[56].toList().at(4);
+ QVariant managerNum = valRows[76].toList().at(6);
if(managerNum.isValid()){
curComInfo.managerNum = managerNum.toInt();
qDebug()<<"managerNum"<<managerNum;
}
// 淇℃伅鎶�鏈�
- QVariant itNum = valRows[56].toList().at(4);
+ QVariant itNum = valRows[77].toList().at(6);
if(itNum.isValid()){
curComInfo.itNum = itNum.toInt();
qDebug()<<"itNum"<<itNum;
}
// 宸ョ▼
- QVariant engineeringNum = valRows[56].toList().at(4);
+ QVariant engineeringNum = valRows[78].toList().at(6);
if(engineeringNum.isValid()){
curComInfo.engineeringNum = engineeringNum.toInt();
qDebug()<<"engineeringNum"<<engineeringNum;
}
// 鍏朵粬
- QVariant otherNum = valRows[56].toList().at(4);
+ QVariant otherNum = valRows[79].toList().at(6);
if(otherNum.isValid()){
curComInfo.otherNum = otherNum.toInt();
qDebug()<<"otherNum"<<otherNum;
@@ -1086,7 +1087,7 @@
qDebug()<<"excel:"<<excel.className();
QAxObject * wbs = excel.querySubObject("WorkBooks");
qDebug()<<"wbs:"<<wbs->className();
- QAxObject * wb = wbs->querySubObject("Open(QString&)",path);
+ QAxObject * wb = wbs->querySubObject("Open(QString&)",path); // 鍝釜瀵硅薄鏄疧pen鐨勮繑鍥炲�硷紝鍝釜灏卞彲浠ヤ繚瀛�
//QAxObject* pWorkBook = excel.querySubObject("ActiveWorkBook");
//QAxObject* pWorkSheets = pWorkBook->querySubObject("Sheets");//鑾峰彇宸ヤ綔琛�
//QAxObject * shs = wb->querySubObject("Sheets"); // WorkSheets 涔熷彲浠�
@@ -1378,6 +1379,30 @@
qDebug()<<"financeDepartment"<<financeDepartment;
}
// 娉曞姟閮ㄩ棬銆佸唴閮ㄦ帶鍒堕儴闂ㄣ�佺邯妫�閮ㄩ棬銆佸叾浠栭儴闂�
+ // 闇�瑕佺壒娈婅幏鍙�
+ QAxObject *checkBox = sheet->querySubObject("CheckBoxes(const QString&)", QString::fromLocal8Bit("璐㈠姟閮ㄩ棬"));
+ if(checkBox){
+ qDebug()<<"鍙栧埌璐㈠姟閮ㄩ棬"<<checkBox->property("Value2").toInt()<<checkBox->property("Value").toInt()<<checkBox->property("Value2").toBool();
+ if(checkBox->property("Value").toBool()){
+ qDebug()<<"璐㈠姟閮ㄩ棬鍕鹃��";
+ }else{
+ qDebug()<<"璐㈠姟閮ㄩ棬鏈嬀閫�";
+ }
+ }else{
+ qDebug()<<"鏈彇鍒拌储鍔￠儴闂�";
+ }
+
+ QAxObject *checkBox1 = sheet->querySubObject("CheckBoxes(const QString&)", QString::fromLocal8Bit("娉曞姟閮ㄩ棬"));
+ if(checkBox1){
+ qDebug()<<"鍙栧埌娉曞姟閮ㄩ棬"<<checkBox1->property("Value").toInt();
+ if(checkBox1->property("Value").toBool()){
+ qDebug()<<"娉曞姟閮ㄩ棬鍕鹃��";
+ }else{
+ qDebug()<<"娉曞姟閮ㄩ棬鏈嬀閫�";
+ }
+ }else{
+ qDebug()<<"鏈彇鍒版硶鍔￠儴闂�";
+ }
// 鍐呭鏈烘瀯灞傜骇
QVariant intavalAuditLeval = valRows[56].toList().at(4);
@@ -1681,3 +1706,15 @@
{
readInfo(); // 鍔犺浇琛ㄦ牸
}
+
+void ConverInfo2::on_pushButton_save_to_file_clicked()
+{
+ QString name = ui->lineEdit_name->text();
+ if(name.size()== 0){
+ QMessageBox::information(this,"鍗曚綅鍚嶇О涓虹┖,璇峰厛閫変腑涓�瀹跺崟浣�","璇峰厛閫変腑涓�瀹跺崟浣�");
+ return;
+ }
+ ExportToFile etf(this);
+ ComInfo cif = m_nameAndComInfos[name];
+ etf.saveToExcelFromComInfo(cif);
+}
--
Gitblit v1.8.0