~admin/audit_system.git

parent: 4bfbba2f | 补丁 | 提交 | ignore whitespace

wumu

2024-02-26 0d17c4e8a79283c64cb8950484ff908b6123e99d

5个文件已修改

21个文件已添加

	Data/33内审统01表_单位及内部审计机构基本情况表-1.301版.xls	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	Data/44内审统01表_单位及内部审计机构基本情况表-1.301版.xls	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	Data/55内审统01表_单位及内部审计机构基本情况表-1.301版.xls	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	Data/66内审统01表_单位及内部审计机构基本情况表-1.301版.xls	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	Data/save2.xls	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	Data/test.xlsx	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	Data/内审统01表_单位及内部审计机构基本情况表-1.301版.xls	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	Data/单位内部审计业务情况表.xls	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	Data/单位内部审计业务情况表_码蚁软件技术(西安)有限公司.xls	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	Data/单位内部审计业务情况表_码蚁软件技术(西安)有限公司2.xls	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	Data/单位内部审计业务情况表_码蚁软件技术(西安)有限公司7.xls	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	Data/目前系统需优化的地方.docx	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	Data/附件1-问题整改台账.xlsx	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	Data/附件2_内审统01表_单位及内部审计机构基本情况表-1.301版(1).xls	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	Data/附件3_内审统02表_单位内部审计业务情况表.xls	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	Data/附件3_内审统02表_单位内部审计业务情况表1.xls	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	Data/附件3_内审统02表_单位内部审计业务情况表2.xls	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	Data/附件3_内审统02表_单位内部审计业务情况表_码蚁软件技术(西安)有限公司.xls	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	Data/附件4_内审统03表_内部审计统计综合表.xls	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	internal_system_v1/converinfo2.cpp	374 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	internal_system_v1/converinfo2.h	5 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	internal_system_v1/converinfo2.ui	144 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	internal_system_v1/internal_system_v1.pro	3 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	internal_system_v1/struct_data.h	71 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	~$审计系统.mmap.~$lock	2 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	审计系统.mmap	补丁 \| 查看 \| 原始文档 \| blame \| 历史

 Data/33ÄÚÉóÍ³01±í_µ¥Î»¼°ÄÚ²¿Éó¼Æ»ú¹¹»ù±¾Çé¿ö±í-1.301°æ.xls

Binary files differ

 Data/44ÄÚÉóÍ³01±í_µ¥Î»¼°ÄÚ²¿Éó¼Æ»ú¹¹»ù±¾Çé¿ö±í-1.301°æ.xls

Binary files differ

 Data/55ÄÚÉóÍ³01±í_µ¥Î»¼°ÄÚ²¿Éó¼Æ»ú¹¹»ù±¾Çé¿ö±í-1.301°æ.xls

Binary files differ

 Data/66ÄÚÉóÍ³01±í_µ¥Î»¼°ÄÚ²¿Éó¼Æ»ú¹¹»ù±¾Çé¿ö±í-1.301°æ.xls

Binary files differ

 Data/save2.xls

Binary files differ

 Data/test.xlsx

Binary files differ

 Data/ÄÚÉóÍ³01±í_µ¥Î»¼°ÄÚ²¿Éó¼Æ»ú¹¹»ù±¾Çé¿ö±í-1.301°æ.xls

Binary files differ

 Data/µ¥Î»ÄÚ²¿Éó¼ÆÒµÎñÇé¿ö±í.xls

Binary files differ

 Data/µ¥Î»ÄÚ²¿Éó¼ÆÒµÎñÇé¿ö±í_ÂëÒÏÈí¼þ¼¼Êõ(Î÷°²)ÓÐÏÞ¹«Ë¾.xls

Binary files differ

 Data/µ¥Î»ÄÚ²¿Éó¼ÆÒµÎñÇé¿ö±í_ÂëÒÏÈí¼þ¼¼Êõ(Î÷°²)ÓÐÏÞ¹«Ë¾2.xls

Binary files differ

 Data/µ¥Î»ÄÚ²¿Éó¼ÆÒµÎñÇé¿ö±í_ÂëÒÏÈí¼þ¼¼Êõ(Î÷°²)ÓÐÏÞ¹«Ë¾7.xls

Binary files differ

 Data/Ä¿Ç°ÏµÍ³ÐèÓÅ»¯µÄµØ·½.docx

Binary files differ

 Data/¸½¼þ1-ÎÊÌâÕû¸ÄÌ¨ÕË.xlsx

Binary files differ

 Data/¸½¼þ2_ÄÚÉóÍ³01±í_µ¥Î»¼°ÄÚ²¿Éó¼Æ»ú¹¹»ù±¾Çé¿ö±í-1.301°æ(1).xls

Binary files differ

 Data/¸½¼þ3_ÄÚÉóÍ³02±í_µ¥Î»ÄÚ²¿Éó¼ÆÒµÎñÇé¿ö±í.xls

Binary files differ

 Data/¸½¼þ3_ÄÚÉóÍ³02±í_µ¥Î»ÄÚ²¿Éó¼ÆÒµÎñÇé¿ö±í1.xls

Binary files differ

 Data/¸½¼þ3_ÄÚÉóÍ³02±í_µ¥Î»ÄÚ²¿Éó¼ÆÒµÎñÇé¿ö±í2.xls

Binary files differ

 Data/¸½¼þ3_ÄÚÉóÍ³02±í_µ¥Î»ÄÚ²¿Éó¼ÆÒµÎñÇé¿ö±í_ÂëÒÏÈí¼þ¼¼Êõ(Î÷°²)ÓÐÏÞ¹«Ë¾.xls

Binary files differ

 Data/¸½¼þ4_ÄÚÉóÍ³03±í_ÄÚ²¿Éó¼ÆÍ³¼Æ×ÛºÏ±í.xls

Binary files differ

 internal_system_v1/converinfo2.cpp

@@ -1,13 +1,20 @@
ï»¿#include "converinfo2.h"
#include "ui_converinfo2.h"
#include <QDebug>
#include <QDirIterator>
#include <QFileDialog>
#include <QSqlQuery>
#include <QSqlRecord>

ConverInfo2::ConverInfo2(QWidget *parent) :
    QMainWindow(parent),
    ui(new Ui::ConverInfo2)
{
    ui->setupUi(this);
    initUi();
    m_menu = nullptr;
    //initUi();
    readInfo(); // å è½½è¡¨æ ¼
    addMenu(); // å¢å èå
}

ConverInfo2::~ConverInfo2()
@@ -90,3 +97,368 @@
{
    qDebug()<<"åå»"<<index;
}

void ConverInfo2::readInfo()
{
//    QXlsx::Document doc("./debug/Data/test.xlsx");
//    QString cc = doc.read("A1").toString();
//    qDebug()<<"cc"<<cc;
//    ui->label_creditCode->setText(cc);
    extern QString g_dataRootPath;

    QString dirPath = "./debug/Data";
    QString dirPathRelease = "./release/Data";
    QString dirPathData = "./Data";
    QDir dir(dirPathData);
    if(dir.exists()){
        dirPath = dirPathData; // åå¨åè¦ç
    }

    QDir dirRe(dirPathRelease);
    if(dirRe.exists()){
        dirPath = dirPathRelease;
    }
    g_dataRootPath = dirPath; // å°æ ¹ç®å½ä¿åèµ·æ¥
    QStringList list;
    QDirIterator it(dirPath, {"*.xls","*.xlsx"}, QDir::Files | QDir::NoSymLinks | QDir::NoDotAndDotDot, QDirIterator::Subdirectories);
    while(it.hasNext())
    {
        it.next();
        list.append(it.fileInfo().absoluteFilePath());
    }
    foreach(QString str, list)
    {
        qDebug() << str;
        int index = str.indexOf("åå®¡ç»01è¡¨");
        qDebug()<<"index:"<<index;
        if(index > 0){
            QAxObject excel("Excel.Application");
            excel.setProperty("Visible",false);
            excel.setProperty("DisplayAlerts",false);
            qDebug()<<"open:"<<str;
            qDebug()<<"excel:"<<excel.className();
            QAxObject * wbs = excel.querySubObject("WorkBooks");
            QAxObject * wb = wbs->querySubObject("Open(QString&)",str);
            //QAxObject* pWorkBook = excel.querySubObject("ActiveWorkBook");
            //QAxObject* pWorkSheets = pWorkBook->querySubObject("Sheets");//è·åå·¥ä½è¡¨
            QAxObject * shs = wb->querySubObject("Sheets"); // WorkSheets ä¹å¯ä»¥
            int cnt = shs->property("Count").toInt();
            qDebug()<<"cnt="<<cnt;
            for(int i=0;i<cnt;++i){
                QAxObject * sheet = shs->querySubObject("Item(int)", i+1);
                QString sheetName = sheet->property("Name").toString();
                qDebug()<<"sh name:"<<sheetName;
                QAxObject *usedRange = sheet->querySubObject("UsedRange");
                int rows = usedRange->querySubObject("Rows")->property("Count").toInt();
                int columns = usedRange->querySubObject("Columns")->property("Count").toInt();
                qDebug()<<"r--c:"<<rows<<columns;
                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;
                        }

                    }
                }

                // å®ä¾åç»æä½ï¼ç¶åæ¨ä¸ªèµå¼
                ComInfo curComInfo;

                // ç»ä¸ä¿¡ç¨ä»£ç 
                QVariant uniCode = valRows[9].toList().at(3);
                if(uniCode.isValid()){
                    ui->label_creditCode->setText(uniCode.toString());
                    strcpy(curComInfo.creditCode,uniCode.toString().toLocal8Bit().data());
                }
                // åä½åç§°
                QVariant name = valRows[9].toList().at(8);
                if(name.isValid()){
                    ui->label_name->setText(name.toString());
                    QTreeWidgetItem *top1 = new QTreeWidgetItem(ui->treeWidget);
                    top1->setText(0,name.toString());

                }else{
                    ui->label_name->setText("");
                }
                // æºæç±»å
                QVariant comType = valRows[12].toList().at(3);
                if(comType.isValid()){
                    ui->label_comType->setText(comType.toString());
                    strcpy(curComInfo.comType,comType.toString().toLocal8Bit().data());
                }else{
                    ui->label_comType->setText("");
                }
                // ä¸»è¦ä¸å¡æ´»å¨
                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);
                    ui->label_business->setToolTip(business);
                    strcpy(curComInfo.business,business.toLocal8Bit().data());
                }else{
                    ui->label_business->setText("");
                }
                // ä¸å¡ä»£ç 
                QVariant busCode = valRows[19].toList().at(4);
                if(busCode.isValid()){
                    ui->label_businessCode->setText(busCode.toString());
                    strcpy(curComInfo.businessCode,busCode.toString().toLocal8Bit().data());
                }else{
                    ui->label_businessCode->setText("");
                }
                // æ³¨åå°å
                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);
                    strcpy(curComInfo.addr,addr.toLocal8Bit().data());
                }else{
                    ui->label_addr->setText("");
                }
                // åºåä»£ç 
                QVariant areaCode = valRows[24].toList().at(2);
                if(areaCode.isValid()){
                    ui->label_areaCode->setText(areaCode.toString());
                    strcpy(curComInfo.areaCode,areaCode.toString().toLocal8Bit().data());
                }else{
                    ui->label_areaCode->setText("");
                }
                // åä¹¡ä»£ç 
                QVariant townCode = valRows[24].toList().at(6);
                if(townCode.isValid()) {
                    ui->label_townCode->setText(townCode.toString());
                    strcpy(curComInfo.townCode,townCode.toString().toLocal8Bit().data());
                }else{
                    ui->label_townCode->setText("");
                }

                // åä½è§æ¨¡
                QVariant scale = valRows[25].toList().at(3);
                if(scale.isValid()){
                    ui->label_scale->setText(scale.toString());
                    strcpy(curComInfo.scale,scale.toString().toLocal8Bit().data());
                }else{
                    ui->label_scale->setText("");
                }
                // ä»ä¸äººæ°
                QVariant people = valRows[26].toList().at(6);
                if(people.isValid()) {
                    ui->label_people->setText(people.toString());
                    //strcpy(curComInfo.people,people.toString().toLocal8Bit().data());
                    curComInfo.people = people.toInt();
                }else{
                    ui->label_people->setText("");
                }
                // æ³äºº
                QVariant representative = valRows[27].toList().at(4);
                if(representative.isValid()) {
                    ui->label_representative->setText(representative.toString());
                    strcpy(curComInfo.representative,representative.toString().toLocal8Bit().data());
                }else{
                    ui->label_representative->setText("");
                }
                // ä¼è®¡æ åç±»å« standardType
                QVariant standardType = valRows[27].toList().at(8);
                if(standardType.isValid()){
                    ui->label_standardType->setText(standardType.toString());
                    strcpy(curComInfo.standardType,standardType.toString().toLocal8Bit());
                }else{
                    ui->label_standardType->setText("");
                }
                // é¿éåºå·
                QVariant trunkCode = valRows[31].toList().at(2);
                if(trunkCode.isValid()){
                    ui->label_trunkCode->setText(trunkCode.toString());
                    strcpy(curComInfo.trunkCode,trunkCode.toString().toLocal8Bit().data());
                }else{
                    ui->label_trunkCode->setText("");
                }
                // åºå®çµè¯
                QVariant fixedTel = valRows[32].toList().at(2);
                if(fixedTel.isValid()) {
                    ui->label_fixedTel->setText(fixedTel.toString());
                    strcpy(curComInfo.fixedTel,fixedTel.toString().toLocal8Bit().data());
                }else{
                    ui->label_fixedTel->setText("");
                }
                // é®æ¿ç¼ç 
                QVariant postCode = valRows[33].toList().at(2);
                if(postCode.isValid()){
                    ui->label_postCode->setText(postCode.toString());
                    strcpy(curComInfo.postCode,postCode.toString().toLocal8Bit().data());
                }else{
                    ui->label_postCode->setText("");
                }
                // çµåé®ç®±
                QVariant email = valRows[30].toList().at(5);
                if(email.isValid()) {
                    ui->label_email->setText(email.toString());
                    strcpy(curComInfo.email,email.toString().toLocal8Bit().data());
                }else{
                    ui->label_email->setText("");
                }
                // ç½å
                QVariant webSite = valRows[32].toList().at(5);
                if(webSite.isValid()) {
                    ui->label_webSite->setText(webSite.toString());
                    strcpy(curComInfo.webSite,webSite.toString().toLocal8Bit().data());
                }else{
                    ui->label_webSite->setText("");
                }

                // äºãåä½ç»ç»ç»ææåµ
                // æ¯å¦æä¸ä¸çº§æ³äºº
                QVariant hasUpLegal = valRows[35].toList().at(4);
                if(hasUpLegal.isValid()){
                    strcpy(curComInfo.hasUpLegal,hasUpLegal.toString().toLocal8Bit().data());
                    qDebug()<<"has up legal"<<hasUpLegal;
                }
                // ä¸çº§æ³äººåä½ç»ä¸ç¤¾ä¼ä¿¡ç¨ä»£ç 
                QVariant upCreditCode = valRows[36].toList().at(7);
                if(upCreditCode.isValid()){
                    strcpy(curComInfo.upCreditCode,upCreditCode.toString().toLocal8Bit().data());
                    qDebug()<<"upCreditCode"<<upCreditCode;
                }else {
                    qDebug()<<"upCreditCode fail"<<name;
                }
                // åç»ç»æºæä»£ç 
                QVariant oldCreditCode = valRows[37].toList().at(7);
                if(oldCreditCode.isValid()){
                    strcpy(curComInfo.oldCreditCode,oldCreditCode.toString().toLocal8Bit().data());
                    qDebug()<<"oldCreditCode"<<oldCreditCode;
                }
                // ä¸ä¸çº§åä½è¯¦ç»åç§°
                QVariant upName = valRows[38].toList().at(7);
                if(upName.isValid()){
                    strcpy(curComInfo.upName,upName.toString().toLocal8Bit().data());
                    qDebug()<<"upName"<<upName;
                }

                // æ»å®¡è®¡å¸ä¸åå®¡æºæåºæ¬æåµ

                // æ¯å¦è®¾ç½®æ»å®¡è®¡å¸
                QVariant hasChiefDesigner = valRows[40].toList().at(4);
                if(hasChiefDesigner.isValid()){
                    strcpy(curComInfo.hasChiefDesigner,hasChiefDesigner.toString().toLocal8Bit().data());
                    qDebug()<<"hasChiefDesigner"<<hasChiefDesigner;
                }
                // æ»å®¡è®¡å¸èä½å±çº§
                QVariant ChiefDesignerLevel = valRows[41].toList().at(4);
                if(ChiefDesignerLevel.isValid()){
                    strcpy(curComInfo.ChiefDesignerLevel,ChiefDesignerLevel.toString().toLocal8Bit().data());
                    qDebug()<<"ChiefDesignerLevel"<<ChiefDesignerLevel;
                }
                // æ»å®¡è®¡å¸ä»»èæ¹å¼
                QVariant employmentMode = valRows[44].toList().at(4);
                if(employmentMode.isValid()){
                    strcpy(curComInfo.employmentMode,employmentMode.toString().toLocal8Bit().data());
                    qDebug()<<"employmentMode"<<employmentMode;
                }

                // æ¯å¦è®¾ç½®åå®¡æºæ
                QVariant hasSetIntervalAudit = valRows[47].toList().at(4);
                if(hasSetIntervalAudit.isValid()){
                    strcpy(curComInfo.hasSetIntervalAudit,hasSetIntervalAudit.toString().toLocal8Bit().data());
                    qDebug()<<"hasSetIntervalAudit"<<hasSetIntervalAudit;
                }
                // åå®¡æºæåç§°
                QVariant internalName = valRows[48].toList().at(4);
                if(internalName.isValid()){
                    strcpy(curComInfo.internalName,internalName.toString().toLocal8Bit().data());
                    qDebug()<<"internalName"<<internalName;
                }
                // åå®¡å·¥ä½çé¢å¯¼æºæ
                QVariant leadingOrganization = valRows[49].toList().at(4);
                if(leadingOrganization.isValid()){
                    strcpy(curComInfo.leadingOrganization,leadingOrganization.toString().toLocal8Bit().data());
                    qDebug()<<"leadingOrganization"<<leadingOrganization;
                }
                // æ¯å¦ç¬ç«è®¾ç½®åå®¡æºæ
                QVariant hasSetSeparateIA = valRows[53].toList().at(4);
                if(hasSetSeparateIA.isValid()){
                    strcpy(curComInfo.hasSetSeparateIA,hasSetSeparateIA.toString().toLocal8Bit().data());
                    qDebug()<<"hasSetSeparateIA"<<hasSetSeparateIA;
                }
                // åå¹¶è®¾ç½® è´¢å¡é¨é¨
                QVariant financeDepartment = valRows[55].toList().at(4);
                if(financeDepartment.isValid()){
                    //strcpy(curComInfo.financeDepartment,financeDepartment.toString().toLocal8Bit().data());
                    curComInfo.financeDepartment = financeDepartment.toBool();
                    qDebug()<<"financeDepartment"<<financeDepartment;
                }
                // æ³å¡é¨é¨ãåé¨æ§å¶é¨é¨ãçºªæ£é¨é¨ãå¶ä»é¨é¨

                // åå®¡æºæå±çº§
                QVariant intavalAuditLeval = valRows[56].toList().at(4);
                if(intavalAuditLeval.isValid()){
                    strcpy(curComInfo.intavalAuditLeval,intavalAuditLeval.toString().toLocal8Bit().data());
                    qDebug()<<"intavalAuditLeval"<<intavalAuditLeval;
                }

                // æååå°mapä¸
                m_nameAndComInfos[name.toString()]=curComInfo;

            }
            wbs->dynamicCall("Close()");
            excel.dynamicCall("Quit(void)");

            qDebug()<<"åä½ä¿¡æ¯æ°éï¼"<<m_nameAndComInfos.size();
        }
    }


//    QAxObject excel("./debug/Data/éä»¶2_åå®¡ç»01è¡¨_åä½ååé¨å®¡è®¡æºæåºæ¬æåµè¡¨-1.301ç(1).xls");
//    excel.setProperty("Visible",true);
//    excel.setProperty("DisplayAlerts",false);

}

void ConverInfo2::addMenu()
{
    // è®¾ç½®èå:æ·»å åä½ãå é¤åä½
    if(m_menu==nullptr){
        m_menu = new QMenu(this);
        qDebug()<<"init menu ok";
    }

    m_menu->addAction("å é¤");
    m_menu->addAction("å¢å ");

    ui->treeWidget->setContextMenuPolicy(Qt::CustomContextMenu);
    connect(ui->treeWidget,SIGNAL(customContextMenuRequested(QPoint)),this,SLOT(showMenu(QPoint)));

    connect(m_menu->actions().at(0),SIGNAL(triggered(bool)),this,SLOT(deleteInfo()));
    connect(m_menu->actions().at(1),SIGNAL(triggered(bool)),this,SLOT(addInfo()));
}

 internal_system_v1/converinfo2.h

@@ -4,6 +4,8 @@
#include <QMainWindow>
#include <QMenu>
#include <QTreeWidgetItem>
#include <QAxObject>
#include "struct_data.h"

namespace Ui {
class ConverInfo2;
@@ -17,6 +19,8 @@
    explicit ConverInfo2(QWidget *parent = 0);
    ~ConverInfo2();
    void initUi();
    void readInfo();
    void addMenu();
private slots:
    void showMenu(QPoint p);
    void addInfo();
@@ -27,6 +31,7 @@
    Ui::ConverInfo2 *ui;
    QMenu *m_menu;
    QTreeWidgetItem *m_curItem;
    QMap<QString,ComInfo> m_nameAndComInfos; // åä½æ å°ä¿¡æ¯è¡¨
};

#endif // CONVERINFO2_H

 internal_system_v1/converinfo2.ui

@@ -38,8 +38,8 @@
      <widget class="QWidget" name="scrollAreaWidgetContents">
       <property name="geometry">
        <rect>
         <x>0</x>
         <y>-400</y>
         <x>-15</x>
         <y>-908</y>
         <width>1000</width>
         <height>3000</height>
        </rect>
@@ -1346,7 +1346,7 @@
         <set>Qt::AlignCenter</set>
        </property>
       </widget>
       <widget class="QComboBox" name="comboBox_3">
       <widget class="QComboBox" name="comboBox_hasUpLegal">
        <property name="geometry">
         <rect>
          <x>410</x>
@@ -1475,7 +1475,7 @@
         </rect>
        </property>
       </widget>
       <widget class="QComboBox" name="comboBox_4">
       <widget class="QComboBox" name="comboBox_hasChiefDesigner">
        <property name="geometry">
         <rect>
          <x>410</x>
@@ -1577,7 +1577,7 @@
         <set>Qt::AlignCenter</set>
        </property>
       </widget>
       <widget class="QComboBox" name="comboBox_5">
       <widget class="QComboBox" name="comboBox_ChiefDesignerLevel">
        <property name="geometry">
         <rect>
          <x>410</x>
@@ -1613,7 +1613,7 @@
         </property>
        </item>
       </widget>
       <widget class="QComboBox" name="comboBox_6">
       <widget class="QComboBox" name="comboBox_employmentMode">
        <property name="geometry">
         <rect>
          <x>410</x>
@@ -1687,7 +1687,7 @@
         <set>Qt::AlignCenter</set>
        </property>
       </widget>
       <widget class="QComboBox" name="comboBox_7">
       <widget class="QComboBox" name="comboBox_hasSetIntervalAudit">
        <property name="geometry">
         <rect>
          <x>410</x>
@@ -1780,7 +1780,7 @@
         </rect>
        </property>
       </widget>
       <widget class="QComboBox" name="comboBox_8">
       <widget class="QComboBox" name="comboBox_leadingOrganization">
        <property name="geometry">
         <rect>
          <x>410</x>
@@ -1859,7 +1859,7 @@
         <set>Qt::AlignCenter</set>
        </property>
       </widget>
       <widget class="QComboBox" name="comboBox_9">
       <widget class="QComboBox" name="comboBox_hasSetSeparateIA">
        <property name="geometry">
         <rect>
          <x>410</x>
@@ -1942,7 +1942,7 @@
         <set>Qt::AlignCenter</set>
        </property>
       </widget>
       <widget class="QCheckBox" name="checkBox">
       <widget class="QCheckBox" name="checkBox_financeDepartment">
        <property name="geometry">
         <rect>
          <x>100</x>
@@ -1955,7 +1955,7 @@
         <string>1 è´¢å¡é¨é¨</string>
        </property>
       </widget>
       <widget class="QCheckBox" name="checkBox_2">
       <widget class="QCheckBox" name="checkBox_legalDepartment">
        <property name="geometry">
         <rect>
          <x>220</x>
@@ -1968,7 +1968,7 @@
         <string>2 æ³å¡é¨é¨</string>
        </property>
       </widget>
       <widget class="QCheckBox" name="checkBox_3">
       <widget class="QCheckBox" name="checkBox_internalConDepart">
        <property name="geometry">
         <rect>
          <x>340</x>
@@ -1981,7 +1981,7 @@
         <string>3 åé¨æ§å¶é¨é¨</string>
        </property>
       </widget>
       <widget class="QCheckBox" name="checkBox_4">
       <widget class="QCheckBox" name="checkBox_disceplineInDepart">
        <property name="geometry">
         <rect>
          <x>480</x>
@@ -1994,7 +1994,7 @@
         <string>4 çºªæ£é¨é¨</string>
        </property>
       </widget>
       <widget class="QCheckBox" name="checkBox_5">
       <widget class="QCheckBox" name="checkBox_otherDepart">
        <property name="geometry">
         <rect>
          <x>600</x>
@@ -2026,7 +2026,7 @@
         <set>Qt::AlignCenter</set>
        </property>
       </widget>
       <widget class="QComboBox" name="comboBox_10">
       <widget class="QComboBox" name="comboBox_intavalAuditLeval">
        <property name="geometry">
         <rect>
          <x>410</x>
@@ -2157,7 +2157,7 @@
         <set>Qt::AlignCenter</set>
        </property>
       </widget>
       <widget class="QLineEdit" name="lineEdit_upName_2">
       <widget class="QLineEdit" name="lineEdit_organazationNum">
        <property name="geometry">
         <rect>
          <x>420</x>
@@ -2167,7 +2167,7 @@
         </rect>
        </property>
       </widget>
       <widget class="QLineEdit" name="lineEdit_upName_3">
       <widget class="QLineEdit" name="lineEdit_realNum">
        <property name="geometry">
         <rect>
          <x>660</x>
@@ -2196,7 +2196,7 @@
         <set>Qt::AlignCenter</set>
        </property>
       </widget>
       <widget class="QLineEdit" name="lineEdit_upName_4">
       <widget class="QLineEdit" name="lineEdit_professionalNum">
        <property name="geometry">
         <rect>
          <x>920</x>
@@ -2263,7 +2263,7 @@
         <set>Qt::AlignCenter</set>
        </property>
       </widget>
       <widget class="QLineEdit" name="lineEdit_upName_5">
       <widget class="QLineEdit" name="lineEdit_CIANum">
        <property name="geometry">
         <rect>
          <x>420</x>
@@ -2330,7 +2330,7 @@
         <set>Qt::AlignCenter</set>
        </property>
       </widget>
       <widget class="QLineEdit" name="lineEdit_upName_6">
       <widget class="QLineEdit" name="lineEdit_masterNum">
        <property name="geometry">
         <rect>
          <x>420</x>
@@ -2397,7 +2397,7 @@
         <set>Qt::AlignCenter</set>
        </property>
       </widget>
       <widget class="QLineEdit" name="lineEdit_upName_7">
       <widget class="QLineEdit" name="lineEdit_undergraduatesNum">
        <property name="geometry">
         <rect>
          <x>420</x>
@@ -2445,7 +2445,7 @@
         <set>Qt::AlignCenter</set>
        </property>
       </widget>
       <widget class="QLineEdit" name="lineEdit_upName_8">
       <widget class="QLineEdit" name="lineEdit_juniorNum">
        <property name="geometry">
         <rect>
          <x>420</x>
@@ -2607,7 +2607,7 @@
         <set>Qt::AlignCenter</set>
        </property>
       </widget>
       <widget class="QLineEdit" name="lineEdit_upName_9">
       <widget class="QLineEdit" name="lineEdit_primaryNum">
        <property name="geometry">
         <rect>
          <x>420</x>
@@ -2617,7 +2617,7 @@
         </rect>
        </property>
       </widget>
       <widget class="QLineEdit" name="lineEdit_upName_10">
       <widget class="QLineEdit" name="lineEdit_intermediateNum">
        <property name="geometry">
         <rect>
          <x>420</x>
@@ -2627,7 +2627,7 @@
         </rect>
        </property>
       </widget>
       <widget class="QLineEdit" name="lineEdit_upName_11">
       <widget class="QLineEdit" name="lineEdit_seniorNum">
        <property name="geometry">
         <rect>
          <x>420</x>
@@ -2675,7 +2675,7 @@
         <set>Qt::AlignCenter</set>
        </property>
       </widget>
       <widget class="QLineEdit" name="lineEdit_upName_12">
       <widget class="QLineEdit" name="lineEdit_noTitleNum">
        <property name="geometry">
         <rect>
          <x>420</x>
@@ -2837,7 +2837,7 @@
         <set>Qt::AlignCenter</set>
        </property>
       </widget>
       <widget class="QLineEdit" name="lineEdit_upName_13">
       <widget class="QLineEdit" name="lineEdit_downThirtyOldNum">
        <property name="geometry">
         <rect>
          <x>420</x>
@@ -2847,7 +2847,7 @@
         </rect>
        </property>
       </widget>
       <widget class="QLineEdit" name="lineEdit_upName_14">
       <widget class="QLineEdit" name="lineEdit_upThirtyOldNum">
        <property name="geometry">
         <rect>
          <x>420</x>
@@ -2857,7 +2857,7 @@
         </rect>
        </property>
       </widget>
       <widget class="QLineEdit" name="lineEdit_upName_15">
       <widget class="QLineEdit" name="lineEdit_upFiftyOldNum">
        <property name="geometry">
         <rect>
          <x>420</x>
@@ -2905,7 +2905,7 @@
         <set>Qt::AlignCenter</set>
        </property>
       </widget>
       <widget class="QLineEdit" name="lineEdit_upName_16">
       <widget class="QLineEdit" name="lineEdit_economyNum">
        <property name="geometry">
         <rect>
          <x>420</x>
@@ -2934,7 +2934,7 @@
         <set>Qt::AlignCenter</set>
        </property>
       </widget>
       <widget class="QLineEdit" name="lineEdit_upName_17">
       <widget class="QLineEdit" name="lineEdit_auditNum">
        <property name="geometry">
         <rect>
          <x>420</x>
@@ -3039,7 +3039,7 @@
         <set>Qt::AlignCenter</set>
        </property>
       </widget>
       <widget class="QLineEdit" name="lineEdit_upName_18">
       <widget class="QLineEdit" name="lineEdit_accountingNum">
        <property name="geometry">
         <rect>
          <x>420</x>
@@ -3068,7 +3068,7 @@
         <set>Qt::AlignCenter</set>
        </property>
       </widget>
       <widget class="QLineEdit" name="lineEdit_upName_19">
       <widget class="QLineEdit" name="lineEdit_lawNum">
        <property name="geometry">
         <rect>
          <x>420</x>
@@ -3135,7 +3135,7 @@
         <set>Qt::AlignCenter</set>
        </property>
       </widget>
       <widget class="QLineEdit" name="lineEdit_upName_20">
       <widget class="QLineEdit" name="lineEdit_managerNum">
        <property name="geometry">
         <rect>
          <x>420</x>
@@ -3164,7 +3164,7 @@
         <set>Qt::AlignCenter</set>
        </property>
       </widget>
       <widget class="QLineEdit" name="lineEdit_upName_21">
       <widget class="QLineEdit" name="lineEdit_otherNum">
        <property name="geometry">
         <rect>
          <x>420</x>
@@ -3193,7 +3193,7 @@
         <set>Qt::AlignCenter</set>
        </property>
       </widget>
       <widget class="QLineEdit" name="lineEdit_upName_22">
       <widget class="QLineEdit" name="lineEdit_itNum">
        <property name="geometry">
         <rect>
          <x>420</x>
@@ -3279,7 +3279,7 @@
         <set>Qt::AlignCenter</set>
        </property>
       </widget>
       <widget class="QLineEdit" name="lineEdit_upName_23">
       <widget class="QLineEdit" name="lineEdit_engineeringNum">
        <property name="geometry">
         <rect>
          <x>420</x>
@@ -3437,7 +3437,7 @@
       <zorder>label_49</zorder>
       <zorder>label_50</zorder>
       <zorder>label_51</zorder>
       <zorder>comboBox_3</zorder>
       <zorder>comboBox_hasUpLegal</zorder>
       <zorder>label_52</zorder>
       <zorder>label_53</zorder>
       <zorder>label_54</zorder>
@@ -3445,57 +3445,57 @@
       <zorder>lineEdit_upCreditCode</zorder>
       <zorder>lineEdit_oldCreditCode</zorder>
       <zorder>lineEdit_upName</zorder>
       <zorder>comboBox_4</zorder>
       <zorder>comboBox_hasChiefDesigner</zorder>
       <zorder>label_56</zorder>
       <zorder>label_57</zorder>
       <zorder>label_58</zorder>
       <zorder>label_59</zorder>
       <zorder>comboBox_5</zorder>
       <zorder>comboBox_6</zorder>
       <zorder>comboBox_ChiefDesignerLevel</zorder>
       <zorder>comboBox_employmentMode</zorder>
       <zorder>label_60</zorder>
       <zorder>label_61</zorder>
       <zorder>comboBox_7</zorder>
       <zorder>comboBox_hasSetIntervalAudit</zorder>
       <zorder>label_62</zorder>
       <zorder>label_63</zorder>
       <zorder>label_64</zorder>
       <zorder>lineEdit_internalName</zorder>
       <zorder>comboBox_8</zorder>
       <zorder>comboBox_leadingOrganization</zorder>
       <zorder>label_65</zorder>
       <zorder>label_66</zorder>
       <zorder>comboBox_9</zorder>
       <zorder>comboBox_hasSetSeparateIA</zorder>
       <zorder>label_67</zorder>
       <zorder>label_68</zorder>
       <zorder>label_69</zorder>
       <zorder>checkBox</zorder>
       <zorder>checkBox_2</zorder>
       <zorder>checkBox_3</zorder>
       <zorder>checkBox_4</zorder>
       <zorder>checkBox_5</zorder>
       <zorder>comboBox_10</zorder>
       <zorder>checkBox_financeDepartment</zorder>
       <zorder>checkBox_legalDepartment</zorder>
       <zorder>checkBox_internalConDepart</zorder>
       <zorder>checkBox_disceplineInDepart</zorder>
       <zorder>checkBox_otherDepart</zorder>
       <zorder>comboBox_intavalAuditLeval</zorder>
       <zorder>label_71</zorder>
       <zorder>label_72</zorder>
       <zorder>label_73</zorder>
       <zorder>label_74</zorder>
       <zorder>label_75</zorder>
       <zorder>lineEdit_upName_2</zorder>
       <zorder>lineEdit_upName_3</zorder>
       <zorder>lineEdit_organazationNum</zorder>
       <zorder>lineEdit_realNum</zorder>
       <zorder>label_76</zorder>
       <zorder>lineEdit_upName_4</zorder>
       <zorder>lineEdit_professionalNum</zorder>
       <zorder>label_77</zorder>
       <zorder>label_78</zorder>
       <zorder>label_79</zorder>
       <zorder>lineEdit_upName_5</zorder>
       <zorder>lineEdit_CIANum</zorder>
       <zorder>label_80</zorder>
       <zorder>label_81</zorder>
       <zorder>label_82</zorder>
       <zorder>lineEdit_upName_6</zorder>
       <zorder>lineEdit_masterNum</zorder>
       <zorder>label_83</zorder>
       <zorder>label_84</zorder>
       <zorder>label_86</zorder>
       <zorder>lineEdit_upName_7</zorder>
       <zorder>lineEdit_undergraduatesNum</zorder>
       <zorder>label_87</zorder>
       <zorder>label_89</zorder>
       <zorder>lineEdit_upName_8</zorder>
       <zorder>lineEdit_juniorNum</zorder>
       <zorder>label_88</zorder>
       <zorder>label_85</zorder>
       <zorder>label_90</zorder>
@@ -3504,12 +3504,12 @@
       <zorder>label_93</zorder>
       <zorder>label_94</zorder>
       <zorder>label_95</zorder>
       <zorder>lineEdit_upName_9</zorder>
       <zorder>lineEdit_upName_10</zorder>
       <zorder>lineEdit_upName_11</zorder>
       <zorder>lineEdit_primaryNum</zorder>
       <zorder>lineEdit_intermediateNum</zorder>
       <zorder>lineEdit_seniorNum</zorder>
       <zorder>label_96</zorder>
       <zorder>label_97</zorder>
       <zorder>lineEdit_upName_12</zorder>
       <zorder>lineEdit_noTitleNum</zorder>
       <zorder>label_98</zorder>
       <zorder>label_99</zorder>
       <zorder>label_100</zorder>
@@ -3518,35 +3518,35 @@
       <zorder>label_103</zorder>
       <zorder>label_104</zorder>
       <zorder>label_105</zorder>
       <zorder>lineEdit_upName_13</zorder>
       <zorder>lineEdit_upName_14</zorder>
       <zorder>lineEdit_upName_15</zorder>
       <zorder>lineEdit_downThirtyOldNum</zorder>
       <zorder>lineEdit_upThirtyOldNum</zorder>
       <zorder>lineEdit_upFiftyOldNum</zorder>
       <zorder>label_106</zorder>
       <zorder>label_107</zorder>
       <zorder>lineEdit_upName_16</zorder>
       <zorder>lineEdit_economyNum</zorder>
       <zorder>label_108</zorder>
       <zorder>lineEdit_upName_17</zorder>
       <zorder>lineEdit_auditNum</zorder>
       <zorder>label_109</zorder>
       <zorder>label_110</zorder>
       <zorder>label_111</zorder>
       <zorder>label_112</zorder>
       <zorder>label_113</zorder>
       <zorder>lineEdit_upName_18</zorder>
       <zorder>lineEdit_accountingNum</zorder>
       <zorder>label_114</zorder>
       <zorder>lineEdit_upName_19</zorder>
       <zorder>lineEdit_lawNum</zorder>
       <zorder>label_115</zorder>
       <zorder>label_116</zorder>
       <zorder>label_117</zorder>
       <zorder>lineEdit_upName_20</zorder>
       <zorder>lineEdit_managerNum</zorder>
       <zorder>label_118</zorder>
       <zorder>lineEdit_upName_21</zorder>
       <zorder>lineEdit_otherNum</zorder>
       <zorder>label_119</zorder>
       <zorder>lineEdit_upName_22</zorder>
       <zorder>lineEdit_itNum</zorder>
       <zorder>label_120</zorder>
       <zorder>label_121</zorder>
       <zorder>label_122</zorder>
       <zorder>label_123</zorder>
       <zorder>lineEdit_upName_23</zorder>
       <zorder>lineEdit_engineeringNum</zorder>
       <zorder>label_124</zorder>
       <zorder>label_125</zorder>
       <zorder>label_228</zorder>

 internal_system_v1/internal_system_v1.pro

@@ -52,7 +52,8 @@
    coverinfo.h \
    searchinfo.h \
    problemrectstandingbook.h \
    converinfo2.h
    converinfo2.h \
    struct_data.h

FORMS += \
        clientmainwindow.ui \

 internal_system_v1/struct_data.h

New file
@@ -0,0 +1,71 @@
ï»¿#ifndef STRUCT_DATA_H
#define STRUCT_DATA_H

// åä½åºæ¬ä¿¡æ¯
struct ComInfo{
    // åºæ¬æåµ
    char creditCode[64]; // ç»ä¸ç¤¾ä¼ä¿¡ç¨ä»£ç 
    char name[128]; // åä½åç§°
    char comType[64]; // æºæç±»å æ¯ä¸ä¸ªä¸ææ¡éé¡¹
    char business[256]; // ä¸å¡æ´»å¨
    char businessCode[32]; // è¡ä¸ä»£ç 
    char addr[256]; // æ³¨åå°ååºå
    char areaCode[32]; // åºåä»£ç 
    char townCode[32]; // åä¹¡ä»£ç 
    char scale[32]; // åä½è§æ¨¡ ä¸ææ¡éé¡¹
    int people; // ä»ä¸äººåæ°é
    char representative[32]; // æ³äºº
    char standardType[32]; // æ§è¡ä¼è®¡æ åç±»å«
    char trunkCode[32]; // é¿éåºå·
    char fixedTel[32]; // åºå®çµè¯
    char postCode[32]; // é®æ¿ç¼ç 
    char email[32]; // çµåé®ç®±
    char webSite[128]; // ç½å

    // äºãåä½ç»ç»ç»ææåµ
    char hasUpLegal[32]; // æ¯å¦æä¸ä¸çº§æ³äºº
    char upCreditCode[32]; // ä¸ä¸çº§ç»ä¸ç¤¾ä¼ä¿¡ç¨ä»£ç 
    char oldCreditCode[32]; // åç»ç»æºæä»£ç 
    char upName[128]; // ä¸ä¸çº§åä½åç§°

    // æ»å®¡è®¡å¸ä¸åé¨å®¡è®¡æºæåºæ¬æåµ
    char hasChiefDesigner[32]; // æ¯å¦è®¾ç½®æ»å®¡è®¡å¸
    char ChiefDesignerLevel[32]; // æ»å®¡è®¡å¸èä½å±çº§
    char employmentMode[32]; // æ»å®¡ä»»èæ¹å¼
    char hasSetIntervalAudit[32]; // æ¯å¦è®¾ç½®åå®¡æºæ
    char internalName[128]; // åå®¡æºæåç§°
    char leadingOrganization[32]; // é¢å¯¼æºæ
    char hasSetSeparateIA[32]; // æ¯å¦ç¬ç«è®¾ç½®åå®¡æºæ
    bool financeDepartment; // è´¢å¡é¨é¨
    bool legalDepartment; // æ³å¡é¨é¨
    bool internalConDepart; // åé¨æ§å¶é¨é¨
    bool disceplineInDepart; // çºªæ£é¨é¨
    bool otherDepart; // å¶ä»é¨é¨
    char intavalAuditLeval[32]; // åå®¡å±çº§

    // åé¨å®¡è®¡äººåéå¤åºæ¬æåµ
    int organazationNum; // ç¼å¶æ°é
    int realNum; // å®æäººåæ°
    int professionalNum; // ä¸èäººåæ°é
    int CIANum; // æ¥æCIAäººæ°
    int masterNum; // ç¡å£«å¦åä»¥ä¸äººæ°
    int undergraduatesNum; // æ¬ç§äººæ°
    int juniorNum; // ä¸ç§åä»¥ä¸äººæ°
    int seniorNum; // é«çº§èç§°äººæ°
    int intermediateNum; // ä¸çº§èç§°äººæ°
    int primaryNum; // åçº§èç§°äººæ°
    int noTitleNum; // æ èç§°äººæ°
    int upFiftyOldNum; // 50å²ä»¥ä¸äººæ°
    int upThirtyOldNum; // 30-50å²äººæ°
    int downThirtyOldNum; // 30å²ä»¥ä¸äººæ°
    int auditNum; // å®¡è®¡æ°é
    int accountingNum; // ä¼è®¡æ°é
    int economyNum; // ç»æµæ°é
    int lawNum; // æ³å¾æ°é
    int managerNum; // ç®¡çæ°é
    int itNum; // ä¿¡æ¯ææ¯æ°é
    int engineeringNum; // å·¥ç¨æ°é
    int otherNum; // å¶ä»æ°é
};

#endif // STRUCT_DATA_H

 ~$Éó¼ÆÏµÍ³.mmap.~$lock

New file
@@ -0,0 +1,2 @@
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<Lock xmlns="http://schemas.mindjet.com/MindManager/Lock/2003"><LockOwner UserName="Windows User" UserEmail=""/></Lock>

 Éó¼ÆÏµÍ³.mmap

Binary files differ

			@@ -1,13 +1,20 @@
			ï»¿#include "converinfo2.h"
			#include "ui_converinfo2.h"
			#include <QDebug>
			#include <QDirIterator>
			#include <QFileDialog>
			#include <QSqlQuery>
			#include <QSqlRecord>

			ConverInfo2::ConverInfo2(QWidget *parent) :
			QMainWindow(parent),
			ui(new Ui::ConverInfo2)
			{
			ui->setupUi(this);
			initUi();
			m_menu = nullptr;
			//initUi();
			readInfo(); // å è½½è¡¨æ ¼
			addMenu(); // å¢å èå
			}

			ConverInfo2::~ConverInfo2()
			@@ -90,3 +97,368 @@
			{
			qDebug()<<"åå»"<<index;
			}

			void ConverInfo2::readInfo()
			{
			// QXlsx::Document doc("./debug/Data/test.xlsx");
			// QString cc = doc.read("A1").toString();
			// qDebug()<<"cc"<<cc;
			// ui->label_creditCode->setText(cc);
			extern QString g_dataRootPath;

			QString dirPath = "./debug/Data";
			QString dirPathRelease = "./release/Data";
			QString dirPathData = "./Data";
			QDir dir(dirPathData);
			if(dir.exists()){
			dirPath = dirPathData; // åå¨åè¦ç
			}

			QDir dirRe(dirPathRelease);
			if(dirRe.exists()){
			dirPath = dirPathRelease;
			}
			g_dataRootPath = dirPath; // å°æ ¹ç®å½ä¿åèµ·æ¥
			QStringList list;
			QDirIterator it(dirPath, {".xls",".xlsx"}, QDir::Files \| QDir::NoSymLinks \| QDir::NoDotAndDotDot, QDirIterator::Subdirectories);
			while(it.hasNext())
			{
			it.next();
			list.append(it.fileInfo().absoluteFilePath());
			}
			foreach(QString str, list)
			{
			qDebug() << str;
			int index = str.indexOf("åå®¡ç»01è¡¨");
			qDebug()<<"index:"<<index;
			if(index > 0){
			QAxObject excel("Excel.Application");
			excel.setProperty("Visible",false);
			excel.setProperty("DisplayAlerts",false);
			qDebug()<<"open:"<<str;
			qDebug()<<"excel:"<<excel.className();
			QAxObject * wbs = excel.querySubObject("WorkBooks");
			QAxObject * wb = wbs->querySubObject("Open(QString&)",str);
			//QAxObject* pWorkBook = excel.querySubObject("ActiveWorkBook");
			//QAxObject* pWorkSheets = pWorkBook->querySubObject("Sheets");//è·åå·¥ä½è¡¨
			QAxObject * shs = wb->querySubObject("Sheets"); // WorkSheets ä¹å¯ä»¥
			int cnt = shs->property("Count").toInt();
			qDebug()<<"cnt="<<cnt;
			for(int i=0;i<cnt;++i){
			QAxObject * sheet = shs->querySubObject("Item(int)", i+1);
			QString sheetName = sheet->property("Name").toString();
			qDebug()<<"sh name:"<<sheetName;
			QAxObject *usedRange = sheet->querySubObject("UsedRange");
			int rows = usedRange->querySubObject("Rows")->property("Count").toInt();
			int columns = usedRange->querySubObject("Columns")->property("Count").toInt();
			qDebug()<<"r--c:"<<rows<<columns;
			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;
			}

			}
			}

			// å®ä¾åç»æä½ï¼ç¶åæ¨ä¸ªèµå¼
			ComInfo curComInfo;

			// ç»ä¸ä¿¡ç¨ä»£ç
			QVariant uniCode = valRows[9].toList().at(3);
			if(uniCode.isValid()){
			ui->label_creditCode->setText(uniCode.toString());
			strcpy(curComInfo.creditCode,uniCode.toString().toLocal8Bit().data());
			}
			// åä½åç§°
			QVariant name = valRows[9].toList().at(8);
			if(name.isValid()){
			ui->label_name->setText(name.toString());
			QTreeWidgetItem *top1 = new QTreeWidgetItem(ui->treeWidget);
			top1->setText(0,name.toString());

			}else{
			ui->label_name->setText("");
			}
			// æºæç±»å
			QVariant comType = valRows[12].toList().at(3);
			if(comType.isValid()){
			ui->label_comType->setText(comType.toString());
			strcpy(curComInfo.comType,comType.toString().toLocal8Bit().data());
			}else{
			ui->label_comType->setText("");
			}
			// ä¸»è¦ä¸å¡æ´»å¨
			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);
			ui->label_business->setToolTip(business);
			strcpy(curComInfo.business,business.toLocal8Bit().data());
			}else{
			ui->label_business->setText("");
			}
			// ä¸å¡ä»£ç
			QVariant busCode = valRows[19].toList().at(4);
			if(busCode.isValid()){
			ui->label_businessCode->setText(busCode.toString());
			strcpy(curComInfo.businessCode,busCode.toString().toLocal8Bit().data());
			}else{
			ui->label_businessCode->setText("");
			}
			// æ³¨åå°å
			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);
			strcpy(curComInfo.addr,addr.toLocal8Bit().data());
			}else{
			ui->label_addr->setText("");
			}
			// åºåä»£ç
			QVariant areaCode = valRows[24].toList().at(2);
			if(areaCode.isValid()){
			ui->label_areaCode->setText(areaCode.toString());
			strcpy(curComInfo.areaCode,areaCode.toString().toLocal8Bit().data());
			}else{
			ui->label_areaCode->setText("");
			}
			// åä¹¡ä»£ç
			QVariant townCode = valRows[24].toList().at(6);
			if(townCode.isValid()) {
			ui->label_townCode->setText(townCode.toString());
			strcpy(curComInfo.townCode,townCode.toString().toLocal8Bit().data());
			}else{
			ui->label_townCode->setText("");
			}

			// åä½è§æ¨¡
			QVariant scale = valRows[25].toList().at(3);
			if(scale.isValid()){
			ui->label_scale->setText(scale.toString());
			strcpy(curComInfo.scale,scale.toString().toLocal8Bit().data());
			}else{
			ui->label_scale->setText("");
			}
			// ä»ä¸äººæ°
			QVariant people = valRows[26].toList().at(6);
			if(people.isValid()) {
			ui->label_people->setText(people.toString());
			//strcpy(curComInfo.people,people.toString().toLocal8Bit().data());
			curComInfo.people = people.toInt();
			}else{
			ui->label_people->setText("");
			}
			// æ³äºº
			QVariant representative = valRows[27].toList().at(4);
			if(representative.isValid()) {
			ui->label_representative->setText(representative.toString());
			strcpy(curComInfo.representative,representative.toString().toLocal8Bit().data());
			}else{
			ui->label_representative->setText("");
			}
			// ä¼è®¡æ åç±»å« standardType
			QVariant standardType = valRows[27].toList().at(8);
			if(standardType.isValid()){
			ui->label_standardType->setText(standardType.toString());
			strcpy(curComInfo.standardType,standardType.toString().toLocal8Bit());
			}else{
			ui->label_standardType->setText("");
			}
			// é¿éåºå·
			QVariant trunkCode = valRows[31].toList().at(2);
			if(trunkCode.isValid()){
			ui->label_trunkCode->setText(trunkCode.toString());
			strcpy(curComInfo.trunkCode,trunkCode.toString().toLocal8Bit().data());
			}else{
			ui->label_trunkCode->setText("");
			}
			// åºå®çµè¯
			QVariant fixedTel = valRows[32].toList().at(2);
			if(fixedTel.isValid()) {
			ui->label_fixedTel->setText(fixedTel.toString());
			strcpy(curComInfo.fixedTel,fixedTel.toString().toLocal8Bit().data());
			}else{
			ui->label_fixedTel->setText("");
			}
			// é®æ¿ç¼ç
			QVariant postCode = valRows[33].toList().at(2);
			if(postCode.isValid()){
			ui->label_postCode->setText(postCode.toString());
			strcpy(curComInfo.postCode,postCode.toString().toLocal8Bit().data());
			}else{
			ui->label_postCode->setText("");
			}
			// çµåé®ç®±
			QVariant email = valRows[30].toList().at(5);
			if(email.isValid()) {
			ui->label_email->setText(email.toString());
			strcpy(curComInfo.email,email.toString().toLocal8Bit().data());
			}else{
			ui->label_email->setText("");
			}
			// ç½å
			QVariant webSite = valRows[32].toList().at(5);
			if(webSite.isValid()) {
			ui->label_webSite->setText(webSite.toString());
			strcpy(curComInfo.webSite,webSite.toString().toLocal8Bit().data());
			}else{
			ui->label_webSite->setText("");
			}

			// äºãåä½ç»ç»ç»ææåµ
			// æ¯å¦æä¸ä¸çº§æ³äºº
			QVariant hasUpLegal = valRows[35].toList().at(4);
			if(hasUpLegal.isValid()){
			strcpy(curComInfo.hasUpLegal,hasUpLegal.toString().toLocal8Bit().data());
			qDebug()<<"has up legal"<<hasUpLegal;
			}
			// ä¸çº§æ³äººåä½ç»ä¸ç¤¾ä¼ä¿¡ç¨ä»£ç
			QVariant upCreditCode = valRows[36].toList().at(7);
			if(upCreditCode.isValid()){
			strcpy(curComInfo.upCreditCode,upCreditCode.toString().toLocal8Bit().data());
			qDebug()<<"upCreditCode"<<upCreditCode;
			}else {
			qDebug()<<"upCreditCode fail"<<name;
			}
			// åç»ç»æºæä»£ç
			QVariant oldCreditCode = valRows[37].toList().at(7);
			if(oldCreditCode.isValid()){
			strcpy(curComInfo.oldCreditCode,oldCreditCode.toString().toLocal8Bit().data());
			qDebug()<<"oldCreditCode"<<oldCreditCode;
			}
			// ä¸ä¸çº§åä½è¯¦ç»åç§°
			QVariant upName = valRows[38].toList().at(7);
			if(upName.isValid()){
			strcpy(curComInfo.upName,upName.toString().toLocal8Bit().data());
			qDebug()<<"upName"<<upName;
			}

			// æ»å®¡è®¡å¸ä¸åå®¡æºæåºæ¬æåµ

			// æ¯å¦è®¾ç½®æ»å®¡è®¡å¸
			QVariant hasChiefDesigner = valRows[40].toList().at(4);
			if(hasChiefDesigner.isValid()){
			strcpy(curComInfo.hasChiefDesigner,hasChiefDesigner.toString().toLocal8Bit().data());
			qDebug()<<"hasChiefDesigner"<<hasChiefDesigner;
			}
			// æ»å®¡è®¡å¸èä½å±çº§
			QVariant ChiefDesignerLevel = valRows[41].toList().at(4);
			if(ChiefDesignerLevel.isValid()){
			strcpy(curComInfo.ChiefDesignerLevel,ChiefDesignerLevel.toString().toLocal8Bit().data());
			qDebug()<<"ChiefDesignerLevel"<<ChiefDesignerLevel;
			}
			// æ»å®¡è®¡å¸ä»»èæ¹å¼
			QVariant employmentMode = valRows[44].toList().at(4);
			if(employmentMode.isValid()){
			strcpy(curComInfo.employmentMode,employmentMode.toString().toLocal8Bit().data());
			qDebug()<<"employmentMode"<<employmentMode;
			}

			// æ¯å¦è®¾ç½®åå®¡æºæ
			QVariant hasSetIntervalAudit = valRows[47].toList().at(4);
			if(hasSetIntervalAudit.isValid()){
			strcpy(curComInfo.hasSetIntervalAudit,hasSetIntervalAudit.toString().toLocal8Bit().data());
			qDebug()<<"hasSetIntervalAudit"<<hasSetIntervalAudit;
			}
			// åå®¡æºæåç§°
			QVariant internalName = valRows[48].toList().at(4);
			if(internalName.isValid()){
			strcpy(curComInfo.internalName,internalName.toString().toLocal8Bit().data());
			qDebug()<<"internalName"<<internalName;
			}
			// åå®¡å·¥ä½çé¢å¯¼æºæ
			QVariant leadingOrganization = valRows[49].toList().at(4);
			if(leadingOrganization.isValid()){
			strcpy(curComInfo.leadingOrganization,leadingOrganization.toString().toLocal8Bit().data());
			qDebug()<<"leadingOrganization"<<leadingOrganization;
			}
			// æ¯å¦ç¬ç«è®¾ç½®åå®¡æºæ
			QVariant hasSetSeparateIA = valRows[53].toList().at(4);
			if(hasSetSeparateIA.isValid()){
			strcpy(curComInfo.hasSetSeparateIA,hasSetSeparateIA.toString().toLocal8Bit().data());
			qDebug()<<"hasSetSeparateIA"<<hasSetSeparateIA;
			}
			// åå¹¶è®¾ç½® è´¢å¡é¨é¨
			QVariant financeDepartment = valRows[55].toList().at(4);
			if(financeDepartment.isValid()){
			//strcpy(curComInfo.financeDepartment,financeDepartment.toString().toLocal8Bit().data());
			curComInfo.financeDepartment = financeDepartment.toBool();
			qDebug()<<"financeDepartment"<<financeDepartment;
			}
			// æ³å¡é¨é¨ãåé¨æ§å¶é¨é¨ãçºªæ£é¨é¨ãå¶ä»é¨é¨

			// åå®¡æºæå±çº§
			QVariant intavalAuditLeval = valRows[56].toList().at(4);
			if(intavalAuditLeval.isValid()){
			strcpy(curComInfo.intavalAuditLeval,intavalAuditLeval.toString().toLocal8Bit().data());
			qDebug()<<"intavalAuditLeval"<<intavalAuditLeval;
			}

			// æååå°mapä¸
			m_nameAndComInfos[name.toString()]=curComInfo;

			}
			wbs->dynamicCall("Close()");
			excel.dynamicCall("Quit(void)");

			qDebug()<<"åä½ä¿¡æ¯æ°éï¼"<<m_nameAndComInfos.size();
			}
			}


			// QAxObject excel("./debug/Data/éä»¶2_åå®¡ç»01è¡¨_åä½ååé¨å®¡è®¡æºæåºæ¬æåµè¡¨-1.301ç(1).xls");
			// excel.setProperty("Visible",true);
			// excel.setProperty("DisplayAlerts",false);

			}

			void ConverInfo2::addMenu()
			{
			// è®¾ç½®èå:æ·»å åä½ãå é¤åä½
			if(m_menu==nullptr){
			m_menu = new QMenu(this);
			qDebug()<<"init menu ok";
			}

			m_menu->addAction("å é¤");
			m_menu->addAction("å¢å ");

			ui->treeWidget->setContextMenuPolicy(Qt::CustomContextMenu);
			connect(ui->treeWidget,SIGNAL(customContextMenuRequested(QPoint)),this,SLOT(showMenu(QPoint)));

			connect(m_menu->actions().at(0),SIGNAL(triggered(bool)),this,SLOT(deleteInfo()));
			connect(m_menu->actions().at(1),SIGNAL(triggered(bool)),this,SLOT(addInfo()));
			}

			@@ -4,6 +4,8 @@
			#include <QMainWindow>
			#include <QMenu>
			#include <QTreeWidgetItem>
			#include <QAxObject>
			#include "struct_data.h"

			namespace Ui {
			class ConverInfo2;
			@@ -17,6 +19,8 @@
			explicit ConverInfo2(QWidget *parent = 0);
			~ConverInfo2();
			void initUi();
			void readInfo();
			void addMenu();
			private slots:
			void showMenu(QPoint p);
			void addInfo();
			@@ -27,6 +31,7 @@
			Ui::ConverInfo2 *ui;
			QMenu *m_menu;
			QTreeWidgetItem *m_curItem;
			QMap<QString,ComInfo> m_nameAndComInfos; // åä½æ å°ä¿¡æ¯è¡¨
			};

			#endif // CONVERINFO2_H

			@@ -38,8 +38,8 @@
			<widget class="QWidget" name="scrollAreaWidgetContents">
			<property name="geometry">
			<rect>
			<x>0</x>
			<y>-400</y>
			<x>-15</x>
			<y>-908</y>
			<width>1000</width>
			<height>3000</height>
			</rect>
			@@ -1346,7 +1346,7 @@
			<set>Qt::AlignCenter</set>
			</property>
			</widget>
			<widget class="QComboBox" name="comboBox_3">
			<widget class="QComboBox" name="comboBox_hasUpLegal">
			<property name="geometry">
			<rect>
			<x>410</x>
			@@ -1475,7 +1475,7 @@
			</rect>
			</property>
			</widget>
			<widget class="QComboBox" name="comboBox_4">
			<widget class="QComboBox" name="comboBox_hasChiefDesigner">
			<property name="geometry">
			<rect>
			<x>410</x>
			@@ -1577,7 +1577,7 @@
			<set>Qt::AlignCenter</set>
			</property>
			</widget>
			<widget class="QComboBox" name="comboBox_5">
			<widget class="QComboBox" name="comboBox_ChiefDesignerLevel">
			<property name="geometry">
			<rect>
			<x>410</x>
			@@ -1613,7 +1613,7 @@
			</property>
			</item>
			</widget>
			<widget class="QComboBox" name="comboBox_6">
			<widget class="QComboBox" name="comboBox_employmentMode">
			<property name="geometry">
			<rect>
			<x>410</x>
			@@ -1687,7 +1687,7 @@
			<set>Qt::AlignCenter</set>
			</property>
			</widget>
			<widget class="QComboBox" name="comboBox_7">
			<widget class="QComboBox" name="comboBox_hasSetIntervalAudit">
			<property name="geometry">
			<rect>
			<x>410</x>
			@@ -1780,7 +1780,7 @@
			</rect>
			</property>
			</widget>
			<widget class="QComboBox" name="comboBox_8">
			<widget class="QComboBox" name="comboBox_leadingOrganization">
			<property name="geometry">
			<rect>
			<x>410</x>
			@@ -1859,7 +1859,7 @@
			<set>Qt::AlignCenter</set>
			</property>
			</widget>
			<widget class="QComboBox" name="comboBox_9">
			<widget class="QComboBox" name="comboBox_hasSetSeparateIA">
			<property name="geometry">
			<rect>
			<x>410</x>
			@@ -1942,7 +1942,7 @@
			<set>Qt::AlignCenter</set>
			</property>
			</widget>
			<widget class="QCheckBox" name="checkBox">
			<widget class="QCheckBox" name="checkBox_financeDepartment">
			<property name="geometry">
			<rect>
			<x>100</x>
			@@ -1955,7 +1955,7 @@
			<string>1 è´¢å¡é¨é¨</string>
			</property>
			</widget>
			<widget class="QCheckBox" name="checkBox_2">
			<widget class="QCheckBox" name="checkBox_legalDepartment">
			<property name="geometry">
			<rect>
			<x>220</x>
			@@ -1968,7 +1968,7 @@
			<string>2 æ³å¡é¨é¨</string>
			</property>
			</widget>
			<widget class="QCheckBox" name="checkBox_3">
			<widget class="QCheckBox" name="checkBox_internalConDepart">
			<property name="geometry">
			<rect>
			<x>340</x>
			@@ -1981,7 +1981,7 @@
			<string>3 åé¨æ§å¶é¨é¨</string>
			</property>
			</widget>
			<widget class="QCheckBox" name="checkBox_4">
			<widget class="QCheckBox" name="checkBox_disceplineInDepart">
			<property name="geometry">
			<rect>
			<x>480</x>
			@@ -1994,7 +1994,7 @@
			<string>4 çºªæ£é¨é¨</string>
			</property>
			</widget>
			<widget class="QCheckBox" name="checkBox_5">
			<widget class="QCheckBox" name="checkBox_otherDepart">
			<property name="geometry">
			<rect>
			<x>600</x>
			@@ -2026,7 +2026,7 @@
			<set>Qt::AlignCenter</set>
			</property>
			</widget>
			<widget class="QComboBox" name="comboBox_10">
			<widget class="QComboBox" name="comboBox_intavalAuditLeval">
			<property name="geometry">
			<rect>
			<x>410</x>
			@@ -2157,7 +2157,7 @@
			<set>Qt::AlignCenter</set>
			</property>
			</widget>
			<widget class="QLineEdit" name="lineEdit_upName_2">
			<widget class="QLineEdit" name="lineEdit_organazationNum">
			<property name="geometry">
			<rect>
			<x>420</x>
			@@ -2167,7 +2167,7 @@
			</rect>
			</property>
			</widget>
			<widget class="QLineEdit" name="lineEdit_upName_3">
			<widget class="QLineEdit" name="lineEdit_realNum">
			<property name="geometry">
			<rect>
			<x>660</x>
			@@ -2196,7 +2196,7 @@
			<set>Qt::AlignCenter</set>
			</property>
			</widget>
			<widget class="QLineEdit" name="lineEdit_upName_4">
			<widget class="QLineEdit" name="lineEdit_professionalNum">
			<property name="geometry">
			<rect>
			<x>920</x>
			@@ -2263,7 +2263,7 @@
			<set>Qt::AlignCenter</set>
			</property>
			</widget>
			<widget class="QLineEdit" name="lineEdit_upName_5">
			<widget class="QLineEdit" name="lineEdit_CIANum">
			<property name="geometry">
			<rect>
			<x>420</x>
			@@ -2330,7 +2330,7 @@
			<set>Qt::AlignCenter</set>
			</property>
			</widget>
			<widget class="QLineEdit" name="lineEdit_upName_6">
			<widget class="QLineEdit" name="lineEdit_masterNum">
			<property name="geometry">
			<rect>
			<x>420</x>
			@@ -2397,7 +2397,7 @@
			<set>Qt::AlignCenter</set>
			</property>
			</widget>
			<widget class="QLineEdit" name="lineEdit_upName_7">
			<widget class="QLineEdit" name="lineEdit_undergraduatesNum">
			<property name="geometry">
			<rect>
			<x>420</x>
			@@ -2445,7 +2445,7 @@
			<set>Qt::AlignCenter</set>
			</property>
			</widget>
			<widget class="QLineEdit" name="lineEdit_upName_8">
			<widget class="QLineEdit" name="lineEdit_juniorNum">
			<property name="geometry">
			<rect>
			<x>420</x>
			@@ -2607,7 +2607,7 @@
			<set>Qt::AlignCenter</set>
			</property>
			</widget>
			<widget class="QLineEdit" name="lineEdit_upName_9">
			<widget class="QLineEdit" name="lineEdit_primaryNum">
			<property name="geometry">
			<rect>
			<x>420</x>
			@@ -2617,7 +2617,7 @@
			</rect>
			</property>
			</widget>
			<widget class="QLineEdit" name="lineEdit_upName_10">
			<widget class="QLineEdit" name="lineEdit_intermediateNum">
			<property name="geometry">
			<rect>
			<x>420</x>
			@@ -2627,7 +2627,7 @@
			</rect>
			</property>
			</widget>
			<widget class="QLineEdit" name="lineEdit_upName_11">
			<widget class="QLineEdit" name="lineEdit_seniorNum">
			<property name="geometry">
			<rect>
			<x>420</x>
			@@ -2675,7 +2675,7 @@
			<set>Qt::AlignCenter</set>
			</property>
			</widget>
			<widget class="QLineEdit" name="lineEdit_upName_12">
			<widget class="QLineEdit" name="lineEdit_noTitleNum">
			<property name="geometry">
			<rect>
			<x>420</x>
			@@ -2837,7 +2837,7 @@
			<set>Qt::AlignCenter</set>
			</property>
			</widget>
			<widget class="QLineEdit" name="lineEdit_upName_13">
			<widget class="QLineEdit" name="lineEdit_downThirtyOldNum">
			<property name="geometry">
			<rect>
			<x>420</x>
			@@ -2847,7 +2847,7 @@
			</rect>
			</property>
			</widget>
			<widget class="QLineEdit" name="lineEdit_upName_14">
			<widget class="QLineEdit" name="lineEdit_upThirtyOldNum">
			<property name="geometry">
			<rect>
			<x>420</x>
			@@ -2857,7 +2857,7 @@
			</rect>
			</property>
			</widget>
			<widget class="QLineEdit" name="lineEdit_upName_15">
			<widget class="QLineEdit" name="lineEdit_upFiftyOldNum">
			<property name="geometry">
			<rect>
			<x>420</x>
			@@ -2905,7 +2905,7 @@
			<set>Qt::AlignCenter</set>
			</property>
			</widget>
			<widget class="QLineEdit" name="lineEdit_upName_16">
			<widget class="QLineEdit" name="lineEdit_economyNum">
			<property name="geometry">
			<rect>
			<x>420</x>
			@@ -2934,7 +2934,7 @@
			<set>Qt::AlignCenter</set>
			</property>
			</widget>
			<widget class="QLineEdit" name="lineEdit_upName_17">
			<widget class="QLineEdit" name="lineEdit_auditNum">
			<property name="geometry">
			<rect>
			<x>420</x>
			@@ -3039,7 +3039,7 @@
			<set>Qt::AlignCenter</set>
			</property>
			</widget>
			<widget class="QLineEdit" name="lineEdit_upName_18">
			<widget class="QLineEdit" name="lineEdit_accountingNum">
			<property name="geometry">
			<rect>
			<x>420</x>
			@@ -3068,7 +3068,7 @@
			<set>Qt::AlignCenter</set>
			</property>
			</widget>
			<widget class="QLineEdit" name="lineEdit_upName_19">
			<widget class="QLineEdit" name="lineEdit_lawNum">
			<property name="geometry">
			<rect>
			<x>420</x>
			@@ -3135,7 +3135,7 @@
			<set>Qt::AlignCenter</set>
			</property>
			</widget>
			<widget class="QLineEdit" name="lineEdit_upName_20">
			<widget class="QLineEdit" name="lineEdit_managerNum">
			<property name="geometry">
			<rect>
			<x>420</x>
			@@ -3164,7 +3164,7 @@
			<set>Qt::AlignCenter</set>
			</property>
			</widget>
			<widget class="QLineEdit" name="lineEdit_upName_21">
			<widget class="QLineEdit" name="lineEdit_otherNum">
			<property name="geometry">
			<rect>
			<x>420</x>
			@@ -3193,7 +3193,7 @@
			<set>Qt::AlignCenter</set>
			</property>
			</widget>
			<widget class="QLineEdit" name="lineEdit_upName_22">
			<widget class="QLineEdit" name="lineEdit_itNum">
			<property name="geometry">
			<rect>
			<x>420</x>
			@@ -3279,7 +3279,7 @@
			<set>Qt::AlignCenter</set>
			</property>
			</widget>
			<widget class="QLineEdit" name="lineEdit_upName_23">
			<widget class="QLineEdit" name="lineEdit_engineeringNum">
			<property name="geometry">
			<rect>
			<x>420</x>
			@@ -3437,7 +3437,7 @@
			<zorder>label_49</zorder>
			<zorder>label_50</zorder>
			<zorder>label_51</zorder>
			<zorder>comboBox_3</zorder>
			<zorder>comboBox_hasUpLegal</zorder>
			<zorder>label_52</zorder>
			<zorder>label_53</zorder>
			<zorder>label_54</zorder>
			@@ -3445,57 +3445,57 @@
			<zorder>lineEdit_upCreditCode</zorder>
			<zorder>lineEdit_oldCreditCode</zorder>
			<zorder>lineEdit_upName</zorder>
			<zorder>comboBox_4</zorder>
			<zorder>comboBox_hasChiefDesigner</zorder>
			<zorder>label_56</zorder>
			<zorder>label_57</zorder>
			<zorder>label_58</zorder>
			<zorder>label_59</zorder>
			<zorder>comboBox_5</zorder>
			<zorder>comboBox_6</zorder>
			<zorder>comboBox_ChiefDesignerLevel</zorder>
			<zorder>comboBox_employmentMode</zorder>
			<zorder>label_60</zorder>
			<zorder>label_61</zorder>
			<zorder>comboBox_7</zorder>
			<zorder>comboBox_hasSetIntervalAudit</zorder>
			<zorder>label_62</zorder>
			<zorder>label_63</zorder>
			<zorder>label_64</zorder>
			<zorder>lineEdit_internalName</zorder>
			<zorder>comboBox_8</zorder>
			<zorder>comboBox_leadingOrganization</zorder>
			<zorder>label_65</zorder>
			<zorder>label_66</zorder>
			<zorder>comboBox_9</zorder>
			<zorder>comboBox_hasSetSeparateIA</zorder>
			<zorder>label_67</zorder>
			<zorder>label_68</zorder>
			<zorder>label_69</zorder>
			<zorder>checkBox</zorder>
			<zorder>checkBox_2</zorder>
			<zorder>checkBox_3</zorder>
			<zorder>checkBox_4</zorder>
			<zorder>checkBox_5</zorder>
			<zorder>comboBox_10</zorder>
			<zorder>checkBox_financeDepartment</zorder>
			<zorder>checkBox_legalDepartment</zorder>
			<zorder>checkBox_internalConDepart</zorder>
			<zorder>checkBox_disceplineInDepart</zorder>
			<zorder>checkBox_otherDepart</zorder>
			<zorder>comboBox_intavalAuditLeval</zorder>
			<zorder>label_71</zorder>
			<zorder>label_72</zorder>
			<zorder>label_73</zorder>
			<zorder>label_74</zorder>
			<zorder>label_75</zorder>
			<zorder>lineEdit_upName_2</zorder>
			<zorder>lineEdit_upName_3</zorder>
			<zorder>lineEdit_organazationNum</zorder>
			<zorder>lineEdit_realNum</zorder>
			<zorder>label_76</zorder>
			<zorder>lineEdit_upName_4</zorder>
			<zorder>lineEdit_professionalNum</zorder>
			<zorder>label_77</zorder>
			<zorder>label_78</zorder>
			<zorder>label_79</zorder>
			<zorder>lineEdit_upName_5</zorder>
			<zorder>lineEdit_CIANum</zorder>
			<zorder>label_80</zorder>
			<zorder>label_81</zorder>
			<zorder>label_82</zorder>
			<zorder>lineEdit_upName_6</zorder>
			<zorder>lineEdit_masterNum</zorder>
			<zorder>label_83</zorder>
			<zorder>label_84</zorder>
			<zorder>label_86</zorder>
			<zorder>lineEdit_upName_7</zorder>
			<zorder>lineEdit_undergraduatesNum</zorder>
			<zorder>label_87</zorder>
			<zorder>label_89</zorder>
			<zorder>lineEdit_upName_8</zorder>
			<zorder>lineEdit_juniorNum</zorder>
			<zorder>label_88</zorder>
			<zorder>label_85</zorder>
			<zorder>label_90</zorder>
			@@ -3504,12 +3504,12 @@
			<zorder>label_93</zorder>
			<zorder>label_94</zorder>
			<zorder>label_95</zorder>
			<zorder>lineEdit_upName_9</zorder>
			<zorder>lineEdit_upName_10</zorder>
			<zorder>lineEdit_upName_11</zorder>
			<zorder>lineEdit_primaryNum</zorder>
			<zorder>lineEdit_intermediateNum</zorder>
			<zorder>lineEdit_seniorNum</zorder>
			<zorder>label_96</zorder>
			<zorder>label_97</zorder>
			<zorder>lineEdit_upName_12</zorder>
			<zorder>lineEdit_noTitleNum</zorder>
			<zorder>label_98</zorder>
			<zorder>label_99</zorder>
			<zorder>label_100</zorder>
			@@ -3518,35 +3518,35 @@
			<zorder>label_103</zorder>
			<zorder>label_104</zorder>
			<zorder>label_105</zorder>
			<zorder>lineEdit_upName_13</zorder>
			<zorder>lineEdit_upName_14</zorder>
			<zorder>lineEdit_upName_15</zorder>
			<zorder>lineEdit_downThirtyOldNum</zorder>
			<zorder>lineEdit_upThirtyOldNum</zorder>
			<zorder>lineEdit_upFiftyOldNum</zorder>
			<zorder>label_106</zorder>
			<zorder>label_107</zorder>
			<zorder>lineEdit_upName_16</zorder>
			<zorder>lineEdit_economyNum</zorder>
			<zorder>label_108</zorder>
			<zorder>lineEdit_upName_17</zorder>
			<zorder>lineEdit_auditNum</zorder>
			<zorder>label_109</zorder>
			<zorder>label_110</zorder>
			<zorder>label_111</zorder>
			<zorder>label_112</zorder>
			<zorder>label_113</zorder>
			<zorder>lineEdit_upName_18</zorder>
			<zorder>lineEdit_accountingNum</zorder>
			<zorder>label_114</zorder>
			<zorder>lineEdit_upName_19</zorder>
			<zorder>lineEdit_lawNum</zorder>
			<zorder>label_115</zorder>
			<zorder>label_116</zorder>
			<zorder>label_117</zorder>
			<zorder>lineEdit_upName_20</zorder>
			<zorder>lineEdit_managerNum</zorder>
			<zorder>label_118</zorder>
			<zorder>lineEdit_upName_21</zorder>
			<zorder>lineEdit_otherNum</zorder>
			<zorder>label_119</zorder>
			<zorder>lineEdit_upName_22</zorder>
			<zorder>lineEdit_itNum</zorder>
			<zorder>label_120</zorder>
			<zorder>label_121</zorder>
			<zorder>label_122</zorder>
			<zorder>label_123</zorder>
			<zorder>lineEdit_upName_23</zorder>
			<zorder>lineEdit_engineeringNum</zorder>
			<zorder>label_124</zorder>
			<zorder>label_125</zorder>
			<zorder>label_228</zorder>

			@@ -52,7 +52,8 @@
			coverinfo.h \
			searchinfo.h \
			problemrectstandingbook.h \
			converinfo2.h
			converinfo2.h \
			struct_data.h

			FORMS += \
			clientmainwindow.ui \

New file
			@@ -0,0 +1,71 @@
			ï»¿#ifndef STRUCT_DATA_H
			#define STRUCT_DATA_H

			// åä½åºæ¬ä¿¡æ¯
			struct ComInfo{
			// åºæ¬æåµ
			char creditCode[64]; // ç»ä¸ç¤¾ä¼ä¿¡ç¨ä»£ç
			char name[128]; // åä½åç§°
			char comType[64]; // æºæç±»å æ¯ä¸ä¸ªä¸ææ¡éé¡¹
			char business[256]; // ä¸å¡æ´»å¨
			char businessCode[32]; // è¡ä¸ä»£ç
			char addr[256]; // æ³¨åå°ååºå
			char areaCode[32]; // åºåä»£ç
			char townCode[32]; // åä¹¡ä»£ç
			char scale[32]; // åä½è§æ¨¡ ä¸ææ¡éé¡¹
			int people; // ä»ä¸äººåæ°é
			char representative[32]; // æ³äºº
			char standardType[32]; // æ§è¡ä¼è®¡æ åç±»å«
			char trunkCode[32]; // é¿éåºå·
			char fixedTel[32]; // åºå®çµè¯
			char postCode[32]; // é®æ¿ç¼ç
			char email[32]; // çµåé®ç®±
			char webSite[128]; // ç½å

			// äºãåä½ç»ç»ç»ææåµ
			char hasUpLegal[32]; // æ¯å¦æä¸ä¸çº§æ³äºº
			char upCreditCode[32]; // ä¸ä¸çº§ç»ä¸ç¤¾ä¼ä¿¡ç¨ä»£ç
			char oldCreditCode[32]; // åç»ç»æºæä»£ç
			char upName[128]; // ä¸ä¸çº§åä½åç§°

			// æ»å®¡è®¡å¸ä¸åé¨å®¡è®¡æºæåºæ¬æåµ
			char hasChiefDesigner[32]; // æ¯å¦è®¾ç½®æ»å®¡è®¡å¸
			char ChiefDesignerLevel[32]; // æ»å®¡è®¡å¸èä½å±çº§
			char employmentMode[32]; // æ»å®¡ä»»èæ¹å¼
			char hasSetIntervalAudit[32]; // æ¯å¦è®¾ç½®åå®¡æºæ
			char internalName[128]; // åå®¡æºæåç§°
			char leadingOrganization[32]; // é¢å¯¼æºæ
			char hasSetSeparateIA[32]; // æ¯å¦ç¬ç«è®¾ç½®åå®¡æºæ
			bool financeDepartment; // è´¢å¡é¨é¨
			bool legalDepartment; // æ³å¡é¨é¨
			bool internalConDepart; // åé¨æ§å¶é¨é¨
			bool disceplineInDepart; // çºªæ£é¨é¨
			bool otherDepart; // å¶ä»é¨é¨
			char intavalAuditLeval[32]; // åå®¡å±çº§

			// åé¨å®¡è®¡äººåéå¤åºæ¬æåµ
			int organazationNum; // ç¼å¶æ°é
			int realNum; // å®æäººåæ°
			int professionalNum; // ä¸èäººåæ°é
			int CIANum; // æ¥æCIAäººæ°
			int masterNum; // ç¡å£«å¦åä»¥ä¸äººæ°
			int undergraduatesNum; // æ¬ç§äººæ°
			int juniorNum; // ä¸ç§åä»¥ä¸äººæ°
			int seniorNum; // é«çº§èç§°äººæ°
			int intermediateNum; // ä¸çº§èç§°äººæ°
			int primaryNum; // åçº§èç§°äººæ°
			int noTitleNum; // æ èç§°äººæ°
			int upFiftyOldNum; // 50å²ä»¥ä¸äººæ°
			int upThirtyOldNum; // 30-50å²äººæ°
			int downThirtyOldNum; // 30å²ä»¥ä¸äººæ°
			int auditNum; // å®¡è®¡æ°é
			int accountingNum; // ä¼è®¡æ°é
			int economyNum; // ç»æµæ°é
			int lawNum; // æ³å¾æ°é
			int managerNum; // ç®¡çæ°é
			int itNum; // ä¿¡æ¯ææ¯æ°é
			int engineeringNum; // å·¥ç¨æ°é
			int otherNum; // å¶ä»æ°é
			};

			#endif // STRUCT_DATA_H

New file
			@@ -0,0 +1,2 @@
			<?xml version="1.0" encoding="UTF-8" standalone="no"?>
			<Lock xmlns="http://schemas.mindjet.com/MindManager/Lock/2003"><LockOwner UserName="Windows User" UserEmail=""/></Lock>