0921

wumu

2023-09-21 dfef23453ad106efad95e40cbeaa191d8b3f6961

0921

 internal_system_v1/clientmainwindow.cpp

@@ -7,6 +7,7 @@
#include <QSqlRecord>

extern int g_comId;
extern QString g_dataRootPath;
QString g_auditDate;

ClientMainWindow::ClientMainWindow(QWidget *parent) :

 internal_system_v1/coverinfo.cpp

@@ -7,6 +7,7 @@
#include <QSqlRecord>

int g_comId = 0; // å…¨å±€å˜é‡ï¼Œä¿å­˜å•ä½id
QString g_dataRootPath; // æ•°æ®çš„根目录

CoverInfo::CoverInfo(QWidget *parent) :
    QMainWindow(parent),
@@ -42,6 +43,7 @@
    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())

 internal_system_v1/problemcount.cpp

@@ -2,11 +2,13 @@
#include "ui_problemcount.h"
#include <QDebug>
#include <QFileDialog>
#include <QProcess>
#include <QPushButton>
#include <QSqlQuery>

extern int g_comId;
extern QString g_auditDate;
extern QString g_dataRootPath;

ProblemCount::ProblemCount(QWidget *parent) :
    QMainWindow(parent),
@@ -22,9 +24,27 @@
            QStringList files = QFileDialog::getOpenFileNames();
            QString str;
            for(auto f:files){
                str += f + " ";
                copyFile(f);
                QString targetPath = g_dataRootPath + QString("/%1/%2").arg(g_comId).arg(f.split("/").back());
                str += targetPath + " ";
            }
            ui->tableWidget->setItem(i,4,new QTableWidgetItem(str));
        });

        // æŸ¥çœ‹ä½è¯
        QPushButton *lookBtn = new QPushButton("查看",this);
        ui->tableWidget->setCellWidget(i,5,lookBtn);
        connect(lookBtn,&QPushButton::clicked,this,[=]{
            QStringList files = ui->tableWidget->item(i,4)->text().split(" ");
            if(files.size() > 0 ){
                QString f = files.at(0);
                qDebug()<<"f:"<<f;
                if(f.size() > 10){
                    f.replace("/", "\\");    //win32下替换斜杠
                    QProcess process;
                    process.startDetached("explorer", QStringList() << QString("/select,") << QString("%1").arg(f));
                }
            }
        });
    }
}
@@ -34,6 +54,25 @@
    delete ui;
}

void ProblemCount::copyFile(QString path)
{
    QStringList paths = path.split("/");
    QString comPath = g_dataRootPath + QString("/%1").arg(g_comId);
    QDir comDir(comPath);
    if(!comDir.exists()){
        // åˆ›å»ºè·¯å¾„
        if(QDir().mkdir(comPath)){
            qDebug()<<"创建目录成功:"<<comPath;
        }
    }
    QString targetPath = g_dataRootPath + QString("/%1/%2").arg(g_comId).arg(paths.back());
    qDebug()<<"targetPath"<<targetPath;
    if(QFile::copy(path,targetPath)){
        qDebug()<<"成功拷贝:"<<path;
    }else{
        qDebug()<<"拷贝失败"<<path;
    }
}
void ProblemCount::on_tableWidget_clicked(const QModelIndex &index)
{
    qDebug()<<"index"<<index;

 internal_system_v1/problemcount.h

@@ -16,6 +16,7 @@
    explicit ProblemCount(QWidget *parent = 0);
    ~ProblemCount();

    void copyFile(QString path);
private slots:
    void on_tableWidget_clicked(const QModelIndex &index);


 internal_system_v1/problemcount.ui

@@ -87,6 +87,11 @@
        <string>佐证资料</string>
       </property>
      </column>
      <column>
       <property name="text">
        <string>查看佐证</string>
       </property>
      </column>
      <item row="0" column="0">
       <property name="text">
        <string>审计发现问题个数</string>
@@ -105,6 +110,11 @@
      <item row="0" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="0" column="5">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="1" column="0">
@@ -127,6 +137,11 @@
        <string>无</string>
       </property>
      </item>
      <item row="1" column="5">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="2" column="0">
       <property name="text">
        <string>非金额类问题个数</string>
@@ -145,6 +160,11 @@
      <item row="2" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="2" column="5">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="3" column="0">
@@ -167,6 +187,11 @@
        <string>无</string>
       </property>
      </item>
      <item row="3" column="5">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="4" column="0">
       <property name="text">
        <string>发展规划与战略决策方面</string>
@@ -185,6 +210,11 @@
      <item row="4" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="4" column="5">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="5" column="0">
@@ -207,6 +237,11 @@
        <string>无</string>
       </property>
      </item>
      <item row="5" column="5">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="6" column="0">
       <property name="text">
        <string>其他</string>
@@ -227,6 +262,11 @@
        <string>无</string>
       </property>
      </item>
      <item row="6" column="5">
       <property name="text">
        <string>0</string>
       </property>
      </item>
     </widget>
    </item>
    <item row="2" column="0">

 internal_system_v1/problemmoney.cpp

@@ -3,9 +3,12 @@
#include <QPushButton>
#include <QDebug>
#include <QSqlQuery>
#include <QFile>
#include <QProcess>

extern int g_comId;
extern QString g_auditDate;
extern QString g_dataRootPath;

ProblemMoney::ProblemMoney(QWidget *parent) :
    QMainWindow(parent),
@@ -21,9 +24,27 @@
            QStringList files = QFileDialog::getOpenFileNames();
            QString str;
            for(auto f:files){
                str += f + " ";
                copyFile(f);
                QString targetPath = g_dataRootPath + QString("/%1/%2").arg(g_comId).arg(f.split("/").back());
                str += targetPath + " ";
            }
            ui->tableWidget->setItem(i,4,new QTableWidgetItem(str));
        });

        // æŸ¥çœ‹ä½è¯
        QPushButton *lookBtn = new QPushButton("查看",this);
        ui->tableWidget->setCellWidget(i,5,lookBtn);
        connect(lookBtn,&QPushButton::clicked,this,[=]{
            QStringList files = ui->tableWidget->item(i,4)->text().split(" ");
            if(files.size() > 0 ){
                QString f = files.at(0);
                qDebug()<<"f:"<<f;
                if(f.size() > 10){
                    f.replace("/", "\\");    //win32下替换斜杠
                    QProcess process;
                    process.startDetached("explorer", QStringList() << QString("/select,") << QString("%1").arg(f));
                }
            }
        });
    }
}
@@ -31,6 +52,26 @@
ProblemMoney::~ProblemMoney()
{
    delete ui;
}

void ProblemMoney::copyFile(QString path)
{
    QStringList paths = path.split("/");
    QString comPath = g_dataRootPath + QString("/%1").arg(g_comId);
    QDir comDir(comPath);
    if(!comDir.exists()){
        // åˆ›å»ºè·¯å¾„
        if(QDir().mkdir(comPath)){
            qDebug()<<"创建目录成功:"<<comPath;
        }
    }
    QString targetPath = g_dataRootPath + QString("/%1/%2").arg(g_comId).arg(paths.back());
    qDebug()<<"targetPath"<<targetPath;
    if(QFile::copy(path,targetPath)){
        qDebug()<<"成功拷贝:"<<path;
    }else{
        qDebug()<<"拷贝失败"<<path;
    }
}

void ProblemMoney::on_pushButton_clicked()
@@ -67,6 +108,8 @@
    }
    // ç»Ÿè®¡
    on_tableWidget_activated(QModelIndex());
    qDebug()<<"g_dataRootPath"<<g_dataRootPath;

}

void ProblemMoney::on_tableWidget_activated(const QModelIndex &index)

 internal_system_v1/problemmoney.h

@@ -17,6 +17,7 @@
    explicit ProblemMoney(QWidget *parent = 0);
    ~ProblemMoney();

    void copyFile(QString path);
private slots:
    void on_pushButton_clicked();


 internal_system_v1/problemmoney.ui

@@ -100,6 +100,11 @@
        <string>佐证资料</string>
       </property>
      </column>
      <column>
       <property name="text">
        <string>查看佐证</string>
       </property>
      </column>
      <item row="0" column="0">
       <property name="text">
        <string>审计发现问题金额</string>
@@ -118,6 +123,11 @@
      <item row="0" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="0" column="5">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="1" column="0">
@@ -140,6 +150,11 @@
        <string>无</string>
       </property>
      </item>
      <item row="1" column="5">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="2" column="0">
       <property name="text">
        <string>合规性问题金额</string>
@@ -158,6 +173,11 @@
      <item row="2" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="2" column="5">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="3" column="0">
@@ -180,6 +200,11 @@
        <string>无</string>
       </property>
      </item>
      <item row="3" column="5">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="4" column="0">
       <property name="text">
        <string>违规使用资金</string>
@@ -198,6 +223,11 @@
      <item row="4" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="4" column="5">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="5" column="0">
@@ -220,6 +250,11 @@
        <string>无</string>
       </property>
      </item>
      <item row="5" column="5">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="6" column="0">
       <property name="text">
        <string>损失浪费</string>
@@ -238,6 +273,11 @@
      <item row="6" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="6" column="5">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="7" column="0">
@@ -260,6 +300,11 @@
        <string>无</string>
       </property>
      </item>
      <item row="7" column="5">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="8" column="0">
       <property name="text">
        <string>偷漏税费</string>
@@ -278,6 +323,11 @@
      <item row="8" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="8" column="5">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="9" column="0">
@@ -300,6 +350,11 @@
        <string>无</string>
       </property>
      </item>
      <item row="9" column="5">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="10" column="0">
       <property name="text">
        <string>其他</string>
@@ -320,6 +375,11 @@
        <string>无</string>
       </property>
      </item>
      <item row="10" column="5">
       <property name="text">
        <string>0</string>
       </property>
      </item>
     </widget>
    </item>
    <item row="0" column="0">

 internal_system_v1/problemnotmoney.cpp

@@ -5,9 +5,11 @@
#include <QPushButton>
#include <QSqlQuery>
#include <QDebug>
#include <QProcess>

extern int g_comId;
extern QString g_auditDate;
extern QString g_dataRootPath;

ProblemNotMoney::ProblemNotMoney(QWidget *parent) :
    QMainWindow(parent),
@@ -23,9 +25,27 @@
            QStringList files = QFileDialog::getOpenFileNames();
            QString str;
            for(auto f:files){
                str += f + " ";
                copyFile(f);
                QString targetPath = g_dataRootPath + QString("/%1/%2").arg(g_comId).arg(f.split("/").back());
                str += targetPath + " ";
            }
            ui->tableWidget->setItem(i,4,new QTableWidgetItem(str));
        });

        // æŸ¥çœ‹ä½è¯
        QPushButton *lookBtn = new QPushButton("查看",this);
        ui->tableWidget->setCellWidget(i,5,lookBtn);
        connect(lookBtn,&QPushButton::clicked,this,[=]{
            QStringList files = ui->tableWidget->item(i,4)->text().split(" ");
            if(files.size() > 0 ){
                QString f = files.at(0);
                qDebug()<<"f:"<<f;
                if(f.size() > 10){
                    f.replace("/", "\\");    //win32下替换斜杠
                    QProcess process;
                    process.startDetached("explorer", QStringList() << QString("/select,") << QString("%1").arg(f));
                }
            }
        });
    }
}
@@ -35,6 +55,26 @@
    delete ui;
}

void ProblemNotMoney::copyFile(QString path)
{
    QStringList paths = path.split("/");
    QString comPath = g_dataRootPath + QString("/%1").arg(g_comId);
    QDir comDir(comPath);
    if(!comDir.exists()){
        // åˆ›å»ºè·¯å¾„
        if(QDir().mkdir(comPath)){
            qDebug()<<"创建目录成功:"<<comPath;
        }
    }
    QString targetPath = g_dataRootPath + QString("/%1/%2").arg(g_comId).arg(paths.back());
    qDebug()<<"targetPath"<<targetPath;
    if(QFile::copy(path,targetPath)){
        qDebug()<<"成功拷贝:"<<path;
    }else{
        qDebug()<<"拷贝失败"<<path;
    }
}

void ProblemNotMoney::on_tableWidget_clicked(const QModelIndex &index)
{
    int allCnt = 0;

 internal_system_v1/problemnotmoney.h

@@ -16,6 +16,7 @@
    explicit ProblemNotMoney(QWidget *parent = 0);
    ~ProblemNotMoney();

    void copyFile(QString path);
private slots:
    void on_tableWidget_clicked(const QModelIndex &index);


 internal_system_v1/problemnotmoney.ui

@@ -77,6 +77,11 @@
        <string>佐证资料</string>
       </property>
      </column>
      <column>
       <property name="text">
        <string>查看佐证</string>
       </property>
      </column>
      <item row="0" column="0">
       <property name="text">
        <string>审计发现问题整改（非金额类）</string>
@@ -95,6 +100,11 @@
      <item row="0" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="0" column="5">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="1" column="0">
@@ -117,6 +127,11 @@
        <string>无</string>
       </property>
      </item>
      <item row="1" column="5">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="2" column="0">
       <property name="text">
        <string>修订完善制度</string>
@@ -135,6 +150,11 @@
      <item row="2" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="2" column="5">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="3" column="0">
@@ -157,6 +177,11 @@
        <string>无</string>
       </property>
      </item>
      <item row="3" column="5">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="4" column="0">
       <property name="text">
        <string>其他</string>
@@ -177,6 +202,11 @@
        <string>无</string>
       </property>
      </item>
      <item row="4" column="5">
       <property name="text">
        <string>0</string>
       </property>
      </item>
     </widget>
    </item>
    <item row="2" column="0">

 internal_system_v1/problemrectification.cpp

@@ -5,9 +5,11 @@
#include <QPushButton>
#include <QSqlQuery>
#include <QDebug>
#include <QProcess>

extern int g_comId;
extern QString g_auditDate;
extern QString g_dataRootPath;

ProblemRectification::ProblemRectification(QWidget *parent) :
    QMainWindow(parent),
@@ -23,9 +25,27 @@
            QStringList files = QFileDialog::getOpenFileNames();
            QString str;
            for(auto f:files){
                str += f + " ";
                copyFile(f);
                QString targetPath = g_dataRootPath + QString("/%1/%2").arg(g_comId).arg(f.split("/").back());
                str += targetPath + " ";
            }
            ui->tableWidget->setItem(i,4,new QTableWidgetItem(str));
        });

        // æŸ¥çœ‹ä½è¯
        QPushButton *lookBtn = new QPushButton("查看",this);
        ui->tableWidget->setCellWidget(i,5,lookBtn);
        connect(lookBtn,&QPushButton::clicked,this,[=]{
            QStringList files = ui->tableWidget->item(i,4)->text().split(" ");
            if(files.size() > 0 ){
                QString f = files.at(0);
                qDebug()<<"f:"<<f;
                if(f.size() > 10){
                    f.replace("/", "\\");    //win32下替换斜杠
                    QProcess process;
                    process.startDetached("explorer", QStringList() << QString("/select,") << QString("%1").arg(f));
                }
            }
        });
    }
}
@@ -35,6 +55,26 @@
    delete ui;
}

void ProblemRectification::copyFile(QString path)
{
    QStringList paths = path.split("/");
    QString comPath = g_dataRootPath + QString("/%1").arg(g_comId);
    QDir comDir(comPath);
    if(!comDir.exists()){
        // åˆ›å»ºè·¯å¾„
        if(QDir().mkdir(comPath)){
            qDebug()<<"创建目录成功:"<<comPath;
        }
    }
    QString targetPath = g_dataRootPath + QString("/%1/%2").arg(g_comId).arg(paths.back());
    qDebug()<<"targetPath"<<targetPath;
    if(QFile::copy(path,targetPath)){
        qDebug()<<"成功拷贝:"<<path;
    }else{
        qDebug()<<"拷贝失败"<<path;
    }
}

void ProblemRectification::on_tableWidget_clicked(const QModelIndex &index)
{
    double allCnt = 0;

 internal_system_v1/problemrectification.h

@@ -16,6 +16,7 @@
    explicit ProblemRectification(QWidget *parent = 0);
    ~ProblemRectification();

    void copyFile(QString path);
private slots:
    void on_tableWidget_clicked(const QModelIndex &index);


 internal_system_v1/problemrectification.ui

@@ -87,6 +87,11 @@
        <string>佐证资料</string>
       </property>
      </column>
      <column>
       <property name="text">
        <string>查看佐证</string>
       </property>
      </column>
      <item row="0" column="0">
       <property name="text">
        <string>审计发现问题整改（金额类）</string>
@@ -105,6 +110,11 @@
      <item row="0" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="0" column="5">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="1" column="0">
@@ -127,6 +137,11 @@
        <string>无</string>
       </property>
      </item>
      <item row="1" column="5">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="2" column="0">
       <property name="text">
        <string>收回资金</string>
@@ -145,6 +160,11 @@
      <item row="2" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="2" column="5">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="3" column="0">
@@ -167,6 +187,11 @@
        <string>无</string>
       </property>
      </item>
      <item row="3" column="5">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="4" column="0">
       <property name="text">
        <string>归还原资金渠道</string>
@@ -185,6 +210,11 @@
      <item row="4" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="4" column="5">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="5" column="0">
@@ -207,6 +237,11 @@
        <string>无</string>
       </property>
      </item>
      <item row="5" column="5">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="6" column="0">
       <property name="text">
        <string>其他</string>
@@ -227,6 +262,11 @@
        <string>无</string>
       </property>
      </item>
      <item row="6" column="5">
       <property name="text">
        <string>0</string>
       </property>
      </item>
     </widget>
    </item>
    <item row="2" column="0">

 internal_system_v1/searchinfo.cpp

@@ -253,6 +253,11 @@
    QString item = ui->comboBox->currentText();
    QString comName = ui->comboBox_company->currentText();
    QString sql = QString("select * from %1 where com_id=%2").arg(m_itemAndTable[item]).arg(m_comInfo[comName]);
    if(ui->checkBox->isChecked()){ // å‹¾é€‰ä¹‹åŽ
        sql = QString("select * from %1 where com_id=%2 and time between '%3' and '%4'").arg(m_itemAndTable[item]).arg(m_comInfo[comName])
                .arg(ui->dateEdit_begin->date().toString("yyyy-MM-dd"))
                .arg(ui->dateEdit_end->date().toString("yyyy-MM-dd"));
    }
    qDebug()<<__FUNCTION__<<sql;
    QSqlQuery query;
    if(query.exec(sql)){

 ĿǰϵͳÐèÓÅ»¯µÄµØ·½_0920.docx

Binary files differ