| | |
| | | { |
| | | QString name = index.model()->data(index).toString(); |
| | | qDebug()<<"双击"<<index<<name; |
| | | if(name.contains("(本级)")){ |
| | | QStringList sps = name.split("(本级)"); |
| | | name = sps.at(0); |
| | | }else if(name.contains("(汇总)")){ |
| | | name = name.split("(汇总)").at(0); |
| | | } |
| | | ComInfo curCominfo = m_nameAndComInfos[name]; |
| | | // 一、单位基本情况 |
| | | ui->lineEdit_creditCode->setText(curCominfo.creditCode); |
| | |
| | | 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()); |
| | | //QTreeWidgetItem *top1 = new QTreeWidgetItem(ui->treeWidget); |
| | | //top1->setText(0,name.toString()); |
| | | strcpy(curComInfo.name,name.toString().toLocal8Bit().data()); |
| | | |
| | | }else{ |
| | |
| | | // 最后存到map中 |
| | | m_nameAndComInfos[name.toString()]=curComInfo; |
| | | |
| | | // 添加树形列表节点 |
| | | //addTreeWidgetNode(upName,name); |
| | | |
| | | if(upName.isValid()){ |
| | | if(name.isValid()){ |
| | | m_treeNodes[upName.toString()].push_back(name.toString()); |
| | | } |
| | | }else{ |
| | | if(name.isValid()){ |
| | | m_treeNodes[name.toString()].push_back(name.toString()); |
| | | } |
| | | } |
| | | |
| | | } |
| | | wbs->dynamicCall("Close()"); |
| | | excel.dynamicCall("Quit(void)"); |
| | | |
| | | |
| | | |
| | | qDebug()<<"单位信息数量:"<<m_nameAndComInfos.size(); |
| | | } |
| | | } |
| | | |
| | | createTreeNode(); // 构建树形节点 |
| | | |
| | | |
| | | // QAxObject excel("./debug/Data/附件2_内审统01表_单位及内部审计机构基本情况表-1.301版(1).xls"); |
| | |
| | | |
| | | // 添加左边树形图相关 |
| | | // 菜单相关 当上级公司为空上级时,自己当自己的上级,并且罗列进去当 本级 |
| | | addTreeWidgetNode(upName,name); |
| | | |
| | | // if(upName.isValid()){ |
| | | // if(name.isValid()){ |
| | | // m_treeNodes[upName.toString()].push_back(name.toString()); |
| | | // } |
| | | // }else{ |
| | | // if(name.isValid()){ |
| | | // m_treeNodes[name.toString()].push_back(name.toString()); |
| | | // } |
| | | // } |
| | | |
| | | |
| | | } |
| | | wbs->dynamicCall("Close()"); |
| | | excel.dynamicCall("Quit(void)"); |
| | | |
| | | qDebug()<<"单位信息数量:"<<m_nameAndComInfos.size(); |
| | | } |
| | | |
| | | void ConverInfo2::createTreeNode(){ |
| | | qDebug()<<"构建树形列表"<<m_treeNodes.size(); |
| | | for(auto iter=m_treeNodes.begin();iter != m_treeNodes.end();iter++) |
| | | { |
| | | // 先构建一个每级的父节点 |
| | | addTreeWidgetNode(iter.key(),iter.key()); |
| | | // 再添加孩子节点 |
| | | for(QString node:iter.value()){ |
| | | qDebug()<<iter.key()<<node; |
| | | if(iter.key() != node){ |
| | | addTreeWidgetNode(iter.key(),node); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | void ConverInfo2::addTreeWidgetNode(QVariant upName,QVariant name){ |
| | | // 添加左边树形图相关 |
| | | // 菜单相关 当上级公司为空上级时,自己当自己的上级,并且罗列进去当 本级 |
| | | |
| | | if(upName.isValid()) // 有效 |
| | | { |
| | |
| | | } |
| | | |
| | | } |
| | | |
| | | |
| | | } |
| | | wbs->dynamicCall("Close()"); |
| | | excel.dynamicCall("Quit(void)"); |
| | | |
| | | qDebug()<<"单位信息数量:"<<m_nameAndComInfos.size(); |
| | | } |
| | | |
| | | void ConverInfo2::on_pushButton_laodFile_clicked() |
| | | { |
| | | QString path = QFileDialog::getOpenFileName(this,"选择表格:单位及内部审计机构基本情况表","./","excel(*基本情况表*.xls)"); |