1028

wumu

2024-10-28 aa013c2f4e69e2ba4eb72081dc004d8334d59257

1028

 internal_system_v1/converinfo2.cpp

@@ -17,6 +17,7 @@
    //initUi();
    //readInfo(); // åŠ è½½è¡¨æ ¼
    addMenu(); // å¢žåŠ èœå•
    disableWheelEvent(); // ç¦ç”¨ä¸‹æ‹‰æ¡†çš„滚轮事件

    // è‡ªé€‚应处理
    ui->treeWidget->header()->setSectionResizeMode(QHeaderView::ResizeToContents);
@@ -106,13 +107,48 @@
{
    QString name = index.model()->data(index).toString();
    qDebug()<<"双击"<<index<<name;
    ComInfo curCominfo = m_nameAndComInfos[name];
    if(name.contains("(本级)")){
        QStringList sps = name.split("(本级)");
        name = sps.at(0);
        curCominfo = m_nameAndComInfos[name];
    }else if(name.contains("(汇总)")){
        name = name.split("(汇总)").at(0);
        qDebug()<<"汇总处理:";
        // åšä¸€ä¸ªæ±‡æ€»çš„处理，把所有下级的都累加起来
        ComInfo allCominfo = m_nameAndComInfos[name];
        for(QString cur:m_treeNodes[name]){
            if(name != cur){
                ComInfo &tmp = m_nameAndComInfos[cur];
                allCominfo.organazationNum += tmp.organazationNum;
                allCominfo.realNum += tmp.realNum;
                allCominfo.professionalNum += tmp.professionalNum;
                allCominfo.CIANum += tmp.CIANum;
                allCominfo.masterNum += tmp.masterNum;
                allCominfo.undergraduatesNum += tmp.undergraduatesNum;
                allCominfo.juniorNum += tmp.juniorNum;
                allCominfo.seniorNum += tmp.seniorNum;
                allCominfo.intermediateNum += tmp.intermediateNum;
                allCominfo.primaryNum += tmp.primaryNum;
                allCominfo.noTitleNum += tmp.noTitleNum;
                allCominfo.upFiftyOldNum += tmp.upFiftyOldNum;
                allCominfo.upThirtyOldNum += tmp.upThirtyOldNum;
                allCominfo.downThirtyOldNum += tmp.downThirtyOldNum;
                allCominfo.auditNum += tmp.auditNum;
                allCominfo.accountingNum += tmp.accountingNum;
                allCominfo.economyNum += tmp.economyNum;
                allCominfo.lawNum += tmp.lawNum;
                allCominfo.managerNum += tmp.managerNum;
                allCominfo.itNum += tmp.itNum;
                allCominfo.engineeringNum += tmp.engineeringNum;
                allCominfo.otherNum += tmp.otherNum;
            }

        }
        curCominfo = allCominfo;

    }
    ComInfo curCominfo = m_nameAndComInfos[name];
    //ComInfo curCominfo = m_nameAndComInfos[name];
    // ä¸€ã€å•ä½åŸºæœ¬æƒ…况
    ui->lineEdit_creditCode->setText(curCominfo.creditCode);
    ui->lineEdit_name->setText(QString::fromLocal8Bit( curCominfo.name));
@@ -1556,6 +1592,38 @@
        }
    }
}

void ConverInfo2::disableWheelEvent()
{
    ui->comboBox_ChiefDesignerLevel->installEventFilter(this);
    ui->comboBox_comType->installEventFilter(this);
    ui->comboBox_employmentMode->installEventFilter(this);
    ui->comboBox_hasChiefDesigner->installEventFilter(this);
    ui->comboBox_hasSetIntervalAudit->installEventFilter(this);
    ui->comboBox_hasSetSeparateIA->installEventFilter(this);
    ui->comboBox_hasUpLegal->installEventFilter(this);
    ui->comboBox_intavalAuditLeval->installEventFilter(this);
    ui->comboBox_leadingOrganization->installEventFilter(this);
    ui->comboBox_scale->installEventFilter(this);
    ui->comboBox_standardType->installEventFilter(this);
}

bool ConverInfo2::eventFilter(QObject *watched, QEvent *event)
{
    QString cls = watched->metaObject()->className();
    if(cls == "QComboBox"){
        //qDebug()<<"发现下拉框";
        if(event->type() == QEvent::Wheel){
            //qDebug()<<"使用了滚轮";
            return true;  // è¿”回真表示禁用，返回假则能用
        }
    }else{
        qDebug()<<"其他类型:"<<cls;
    }

    return QMainWindow::eventFilter(watched,event);

}
void ConverInfo2::addTreeWidgetNode(QVariant upName,QVariant name){
    // æ·»åŠ å·¦è¾¹æ ‘形图相关
    // èœå•ç›¸å…³  å½“上级公司为空上级时，自己当自己的上级，并且罗列进去当 æœ¬çº§

 internal_system_v1/converinfo2.h

@@ -27,6 +27,11 @@
    void addTreeWidgetNode(QVariant upName, QVariant name);
    void createTreeNode();

    // å¤„理滚轮的操作，禁用下拉框的滚轮事件
    void disableWheelEvent();

    bool eventFilter(QObject *watched, QEvent *event);

signals:
    void loadFinished(); // åŠ è½½å®Œæˆçš„信号
    void loadProgress(int); // åŠ è½½è¿›åº¦

 internal_system_v1/exporttofile.cpp

New file
@@ -0,0 +1,21 @@
#include "exporttofile.h"

ExportToFile::ExportToFile(QObject *parent) : QObject(parent)
{

}

int ExportToFile::saveToExcelFromComInfo(ComInfo &info)
{

}

int ExportToFile::saveToExcelFromThreeMergePro()
{

}

int ExportToFile::saveToExcelFromNeiShenZonghe()
{

}

 internal_system_v1/exporttofile.h

New file
@@ -0,0 +1,23 @@
#ifndef EXPORTTOFILE_H
#define EXPORTTOFILE_H

#include <QObject>
#include "struct_data.h"

// ç»Ÿä¸€å†™å¥½å¯¼å‡ºæŽ¥å£ï¼Œæä¾›ç»™ç›¸åº”模块使用
class ExportToFile : public QObject
{
    Q_OBJECT
public:
    explicit ExportToFile(QObject *parent = nullptr);


    int saveToExcelFromComInfo(ComInfo &info); // å°é¢ä¿¡æ¯å¯¼å‡º
    int saveToExcelFromThreeMergePro(); // 3和1导出
    int saveToExcelFromNeiShenZonghe(); // å†…审综合导出
signals:

public slots:
};

#endif // EXPORTTOFILE_H

 internal_system_v1/internal_system_v1.pro

@@ -46,7 +46,8 @@
    filedialogdelegate.cpp \
    customheaderview.cpp \
    comboboxdelegate.cpp \
    datedelegate.cpp
    datedelegate.cpp \
    exporttofile.cpp

HEADERS += \
        clientmainwindow.h \
@@ -70,7 +71,8 @@
    filedialogdelegate.h \
    customheaderview.h \
    comboboxdelegate.h \
    datedelegate.h
    datedelegate.h \
    exporttofile.h

FORMS += \
        clientmainwindow.ui \

 internal_system_v1/main.cpp

@@ -1,5 +1,8 @@
#include "clientmainwindow.h"
#include <QApplication>
#include <QStandardPaths>
#include <QDebug>
#pragma execution_character_set("utf-8")

int main(int argc, char *argv[])
{
@@ -27,5 +30,32 @@

    w.show();

    // å¤„理快捷方式到桌面

    QString strAppPath = QApplication::applicationFilePath();
    QString strDesktopLink = QStandardPaths::writableLocation(QStandardPaths::DesktopLocation) + "/";
    strDesktopLink += "internal_system.lnk";
    qDebug()<<"桌面路径:"<<strDesktopLink;
    qDebug()<<"app:"<<QApplication::applicationFilePath();

    QFile desk(strDesktopLink);

    QFile fApp(strAppPath);
    if(!desk.exists()){
        fApp.link(strDesktopLink);
        qDebug()<<"添加快捷方式成功";
    }else{
        qDebug()<<"快捷方式已存在，不添加";
    }


//    //建立开始菜单快捷方式
//    QString strMenuLink = QStandardPaths::writableLocation(QStandardPaths::ApplicationsLocation) + "/";
//    strMenuLink += "notepad/";
//    QDir pathDir;
//    pathDir.mkpath(strMenuLink);
//    strMenuLink += "notepad.lnk";
//    fApp.link(strMenuLink);

    return a.exec();
}

 internal_system_v1/threemergeproblemlist.cpp

@@ -172,7 +172,7 @@

// path ä¸ºæ–‡ä»¶å®Œæ•´è·¯å¾„
// id为子目录名字
int ThreeMergeProblemList::saveFile(QString path, QString id,QString &absSavePath)
int ThreeMergeProblemList::saveFile(QString path, QString id,QString &absSavePath,QString proName)
{
    // æ ¹æ®id来指定子目录进行文件的拷贝和存储
    // é»˜è®¤ä¿å­˜åˆ°å½“前evidence目录下的id子目录中
@@ -182,7 +182,7 @@
        return -1;
    }

    QString curPath = QString("./evidence/%1/").arg(id);
    QString curPath = QString("./evidence/%1_%2/").arg(id).arg(proName);
    QDir dir;
    if(!dir.exists(curPath)){
        // åˆ™ç›´æŽ¥åˆ›å»º
@@ -620,19 +620,20 @@
            QString spath = ui->tableWidget->item(row,17)->text();
            QString tpath = ui->tableWidget->item(row,23)->text();
            QString fid = ui->tableWidget->item(row,0)->text();
            qDebug()<<"拷贝文件:"<<fid<<fpath;
            QString proName = ui->tableWidget->item(row,7)->text(); // é¡¹ç›®åç§°
            qDebug()<<"拷贝文件:"<<fid<<proName<<fpath;

            QString absSavePath1,absSavePath2,absSavePath3;

            int sflag1 = saveFile(fpath,fid,absSavePath1); // ä¿å­˜ç¬¬ä¸€ä¸ª
            int sflag1 = saveFile(fpath,fid,absSavePath1,proName); // ä¿å­˜ç¬¬ä¸€ä¸ª
            if(sflag1==1){
                ui->tableWidget->setItem(row,13,new QTableWidgetItem(absSavePath1));
            }
            int sflag2 = saveFile(spath,fid,absSavePath2); // ä¿å­˜ç¬¬äºŒä¸ª
            int sflag2 = saveFile(spath,fid,absSavePath2,proName); // ä¿å­˜ç¬¬äºŒä¸ª
            if(sflag2==1){
                ui->tableWidget->setItem(row,17,new QTableWidgetItem(absSavePath2));
            }
            int sflag3 = saveFile(tpath,fid,absSavePath3); // ä¿å­˜ç¬¬ä¸‰ä¸ª
            int sflag3 = saveFile(tpath,fid,absSavePath3,proName); // ä¿å­˜ç¬¬ä¸‰ä¸ª
            if(sflag3==1){
                ui->tableWidget->setItem(row,23,new QTableWidgetItem(absSavePath3));
            }
@@ -839,19 +840,20 @@
            QString spath = ui->tableWidget->item(i,17)->text();
            QString tpath = ui->tableWidget->item(i,23)->text();
            QString fid = ui->tableWidget->item(i,0)->text();
            qDebug()<<"拷贝文件:"<<fid<<fpath;
            QString proName = ui->tableWidget->item(i,7)->text(); // é¡¹ç›®åç§°
            qDebug()<<"拷贝文件:"<<fid<<proName<<fpath;

            QString absSavePath1,absSavePath2,absSavePath3;

            int sflag1 = saveFile(fpath,fid,absSavePath1); // ä¿å­˜ç¬¬ä¸€ä¸ª
            int sflag1 = saveFile(fpath,fid,absSavePath1,proName); // ä¿å­˜ç¬¬ä¸€ä¸ª
            if(sflag1==1){
                ui->tableWidget->setItem(i,13,new QTableWidgetItem(absSavePath1));
            }
            int sflag2 = saveFile(spath,fid,absSavePath2); // ä¿å­˜ç¬¬äºŒä¸ª
            int sflag2 = saveFile(spath,fid,absSavePath2,proName); // ä¿å­˜ç¬¬äºŒä¸ª
            if(sflag2==1){
                ui->tableWidget->setItem(i,17,new QTableWidgetItem(absSavePath2));
            }
            int sflag3 = saveFile(tpath,fid,absSavePath3); // ä¿å­˜ç¬¬ä¸‰ä¸ª
            int sflag3 = saveFile(tpath,fid,absSavePath3,proName); // ä¿å­˜ç¬¬ä¸‰ä¸ª
            if(sflag3==1){
                ui->tableWidget->setItem(i,23,new QTableWidgetItem(absSavePath3));
            }

 internal_system_v1/threemergeproblemlist.h

@@ -38,7 +38,8 @@
    int selectSQL(QString sql,QVector<QVector<QString>> &result); // æ‹¿ç»“果集的sql
    int changeSQL(QString sql); // æ‹¿æ¡æ•°çš„sql
    int saveDataLine(int row); // ä¿å­˜æŒ‡å®šè¡Œ å…ˆåˆ¤æ–­å¯¹åº”的索引id是否存在，存在则更新，不存在则新建插入
    int saveFile(QString path, QString id,QString &absSavePath); // æ ¹æ®id来指定子目录进行文件的拷贝和存储
    // ä¿æŒè·¯å¾„加上 id+项目名称
    int saveFile(QString path, QString id,QString &absSavePath,QString proName); // æ ¹æ®id来指定子目录进行文件的拷贝和存储

    int loadPdfFile(QString path); // åŠ è½½pdf文件


 ÐÞ¸Ä_241015/ÄÚÉóϵͳ´æÔÚÎÊÌâ·´À¡1015.docx

Binary files differ

 ÐÞ¸Ä_241015/¸½¼þ1-ÎÊÌâÕû¸Ą̈ÕËÐ޸ĺó1015.xlsx

Binary files differ

 ÐÞ¸Ä_241015/¸½¼þ4_ÄÚÉóͳ03±í_ÄÚ²¿Éó¼Æͳ¼Æ×ۺϱíÐ޸ĺó1015.xls

Binary files differ