0227

wumu

2024-02-27 cefa8da6b9d9765bc8af450210c34d2e080840b2

0227

 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;
                }

                // 最后存到map中
                m_nameAndComInfos[name.toString()]=curComInfo;


 internal_system_v1/internal_system_v1.pro.user

@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE QtCreatorProject>
<!-- Written by QtCreator 4.5.0, 2024-02-20T23:42:45. -->
<!-- Written by QtCreator 4.5.0, 2024-02-27T12:03:10. -->
<qtcreator>
 <data>
  <variable>EnvironmentId</variable>