0830

wumu

2023-08-30 8d02dbd0ba6c82ed15f510651a8aa3f09c19721a

0830

 internal_system_v1/auditproject.cpp

@@ -1,5 +1,7 @@
#include "auditproject.h"
#include "ui_auditproject.h"
#include <QDebug>
#include <QSqlQuery>

AuditProject::AuditProject(QWidget *parent) :
    QMainWindow(parent),
@@ -14,6 +16,7 @@
        }
    }
    ui->tableWidget->setColumnWidth(0,300);
    m_comId = 1; // 单位id

}

@@ -32,3 +35,32 @@
        ui->tableWidget->setItem(0,2,new QTableWidgetItem(QString::number(sum)));
    }
}

void AuditProject::on_pushButton_clicked()
{

    // 再次统计一把
    int sum = 0;
    for(int i=1;i<9;++i){
        sum += ui->tableWidget->item(i,2)->text().toInt();
    }
    ui->tableWidget->setItem(0,2,new QTableWidgetItem(QString::number(sum)));

    QString values = "";
    for(int i=0;i<ui->tableWidget->rowCount();++i){
        values += QString("('%1','%2',%3,%4),").arg(ui->tableWidget->item(i,0)->text())
                .arg(ui->tableWidget->item(i,1)->text()).arg(ui->tableWidget->item(i,2)->text().toInt())
                .arg(m_comId);
    }
    //qDebug()<<values;
    values = values.left(values.length()-1);
    //qDebug()<<values;
    QString sql = QString("insert into audit_project (kpi_name,code,num,com_id) values %1").arg(values);
    qDebug()<<sql;
    QSqlQuery query;
    if(query.exec(sql)){
        qDebug()<<"OK sql"<<__FUNCTION__;
    }else{
        qDebug()<<"fail sql"<<__FUNCTION__;
    }
}

 internal_system_v1/auditproject.h

@@ -18,8 +18,11 @@
private slots:
    void on_tableWidget_clicked(const QModelIndex &index);

    void on_pushButton_clicked();

private:
    Ui::AuditProject *ui;
    int m_comId;
};

#endif // AUDITPROJECT_H

 internal_system_v1/auditproject.ui

@@ -250,6 +250,19 @@
      </item>
     </widget>
    </item>
    <item row="2" column="0">
     <widget class="QPushButton" name="pushButton">
      <property name="minimumSize">
       <size>
        <width>0</width>
        <height>50</height>
       </size>
      </property>
      <property name="text">
       <string>提交--审计项目</string>
      </property>
     </widget>
    </item>
   </layout>
  </widget>
  <widget class="QMenuBar" name="menubar">

 internal_system_v1/auditworkload.cpp

@@ -1,5 +1,7 @@
#include "auditworkload.h"
#include "ui_auditworkload.h"
#include <QDebug>
#include <QSqlQuery>

AuditWorkload::AuditWorkload(QWidget *parent) :
    QMainWindow(parent),
@@ -7,9 +9,29 @@
{
    ui->setupUi(this);
    ui->tableWidget->setColumnWidth(0,260);
    m_comId = 1;
}

AuditWorkload::~AuditWorkload()
{
    delete ui;
}

void AuditWorkload::on_pushButton_clicked()
{
    QString values = "";
    for(int i=0;i<ui->tableWidget->rowCount();++i){
        values += QString("('%1','%2',%3,%4),").arg(ui->tableWidget->item(i,0)->text())
                .arg(ui->tableWidget->item(i,1)->text()).arg(ui->tableWidget->item(i,2)->text().toInt())
                .arg(m_comId);
    }
    values = values.left(values.length()-1);
    QString sql = QString("insert into audit_workload (kpi_name,code,num,com_id) values %1").arg(values);
    qDebug()<<sql;
    QSqlQuery query;
    if(query.exec(sql)){
        qDebug()<<"OK sql"<<__FUNCTION__;
    }else{
        qDebug()<<"fail sql"<<__FUNCTION__;
    }
}

 internal_system_v1/auditworkload.h

@@ -15,8 +15,12 @@
    explicit AuditWorkload(QWidget *parent = 0);
    ~AuditWorkload();

private slots:
    void on_pushButton_clicked();

private:
    Ui::AuditWorkload *ui;
    int m_comId;
};

#endif // AUDITWORKLOAD_H

 internal_system_v1/auditworkload.ui

@@ -64,6 +64,19 @@
      </item>
     </widget>
    </item>
    <item row="2" column="0">
     <widget class="QPushButton" name="pushButton">
      <property name="minimumSize">
       <size>
        <width>0</width>
        <height>50</height>
       </size>
      </property>
      <property name="text">
       <string>提交--内审工作量</string>
      </property>
     </widget>
    </item>
   </layout>
  </widget>
  <widget class="QMenuBar" name="menubar">

 internal_system_v1/caseclue.cpp

@@ -1,5 +1,7 @@
#include "caseclue.h"
#include "ui_caseclue.h"
#include <QDebug>
#include <QSqlQuery>

CaseClue::CaseClue(QWidget *parent) :
    QMainWindow(parent),
@@ -7,9 +9,30 @@
{
    ui->setupUi(this);
    ui->tableWidget->setColumnWidth(0,300);
    m_comId = 1;
}

CaseClue::~CaseClue()
{
    delete ui;
}

void CaseClue::on_pushButton_clicked()
{
    QString values = "";
    for(int i=0;i<ui->tableWidget->rowCount();++i){
        values += QString("('%1','%2','%3',%4,%5),").arg(ui->tableWidget->item(i,0)->text())
                .arg(ui->tableWidget->item(i,1)->text()).arg(ui->tableWidget->item(i,2)->text())
                .arg(ui->tableWidget->item(i,3)->text().toInt())
                .arg(m_comId);
    }
    values = values.left(values.length()-1);
    QString sql = QString("insert into case_clue (kpi_name,code,unit,num,com_id) values %1").arg(values);
    qDebug()<<sql;
    QSqlQuery query;
    if(query.exec(sql)){
        qDebug()<<"OK sql"<<__FUNCTION__;
    }else{
        qDebug()<<"fail sql"<<__FUNCTION__;
    }
}

 internal_system_v1/caseclue.h

@@ -15,8 +15,12 @@
    explicit CaseClue(QWidget *parent = 0);
    ~CaseClue();

private slots:
    void on_pushButton_clicked();

private:
    Ui::CaseClue *ui;
    int m_comId;
};

#endif // CASECLUE_H

 internal_system_v1/caseclue.ui

@@ -99,6 +99,19 @@
      </item>
     </widget>
    </item>
    <item row="2" column="0">
     <widget class="QPushButton" name="pushButton">
      <property name="minimumSize">
       <size>
        <width>0</width>
        <height>50</height>
       </size>
      </property>
      <property name="text">
       <string>提交--案件线索</string>
      </property>
     </widget>
    </item>
   </layout>
  </widget>
  <widget class="QMenuBar" name="menubar">

 internal_system_v1/coverinfo.ui

@@ -907,6 +907,21 @@
     <set>Qt::AlignCenter</set>
    </property>
   </widget>
   <widget class="QComboBox" name="comboBox">
    <property name="geometry">
     <rect>
      <x>670</x>
      <y>30</y>
      <width>291</width>
      <height>22</height>
     </rect>
    </property>
    <item>
     <property name="text">
      <string>公司名称</string>
     </property>
    </item>
   </widget>
  </widget>
  <widget class="QMenuBar" name="menubar">
   <property name="geometry">

 internal_system_v1/problemcount.cpp

@@ -1,6 +1,9 @@
#include "problemcount.h"
#include "ui_problemcount.h"
#include <QDebug>
#include <QFileDialog>
#include <QPushButton>
#include <QSqlQuery>

ProblemCount::ProblemCount(QWidget *parent) :
    QMainWindow(parent),
@@ -8,6 +11,19 @@
{
    ui->setupUi(this);
    ui->tableWidget->setColumnWidth(0,300);
    m_comId = 1;
    for(int i=0;i<ui->tableWidget->rowCount();++i){
        QPushButton *btn = new QPushButton("上传",this);
        ui->tableWidget->setCellWidget(i,3,btn);
        connect(btn,&QPushButton::clicked,this,[=]{
            QStringList files = QFileDialog::getOpenFileNames();
            QString str;
            for(auto f:files){
                str += f + " ";
            }
            ui->tableWidget->setItem(i,4,new QTableWidgetItem(str));
        });
    }
}

ProblemCount::~ProblemCount()
@@ -43,3 +59,27 @@
    ui->tableWidget->setItem(0,2,new QTableWidgetItem(QString::number(allCnt)));

}

void ProblemCount::on_pushButton_clicked()
{
    // 再统计一把
    on_tableWidget_activated(QModelIndex());


    QString values = "";
    for(int i=0;i<ui->tableWidget->rowCount();++i){
        values += QString("('%1','%2',%3,'%4',%5),").arg(ui->tableWidget->item(i,0)->text())
                .arg(ui->tableWidget->item(i,1)->text()).arg(ui->tableWidget->item(i,2)->text().toInt())
                .arg(ui->tableWidget->item(i,4)->text())
                .arg(m_comId);
    }
    values = values.left(values.length()-1);
    QString sql = QString("insert into problem_count (kpi_name,code,num,evidences,com_id) values %1").arg(values);
    qDebug()<<sql;
    QSqlQuery query;
    if(query.exec(sql)){
        qDebug()<<"OK sql"<<__FUNCTION__;
    }else{
        qDebug()<<"fail sql"<<__FUNCTION__;
    }
}

 internal_system_v1/problemcount.h

@@ -20,8 +20,11 @@

    void on_tableWidget_activated(const QModelIndex &index);

    void on_pushButton_clicked();

private:
    Ui::ProblemCount *ui;
    int m_comId;
};

#endif // PROBLEMCOUNT_H

 internal_system_v1/problemcount.ui

@@ -82,6 +82,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="2">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="0" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="1" column="0">
@@ -112,6 +122,11 @@
        <string>0</string>
       </property>
      </item>
      <item row="1" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="2" column="0">
       <property name="text">
        <string>非金额类问题个数</string>
@@ -125,6 +140,11 @@
      <item row="2" column="2">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="2" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="3" column="0">
@@ -142,6 +162,11 @@
        <string>0</string>
       </property>
      </item>
      <item row="3" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="4" column="0">
       <property name="text">
        <string>发展规划与战略决策方面</string>
@@ -155,6 +180,11 @@
      <item row="4" column="2">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="4" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="5" column="0">
@@ -172,6 +202,11 @@
        <string>0</string>
       </property>
      </item>
      <item row="5" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="6" column="0">
       <property name="text">
        <string>其他</string>
@@ -187,6 +222,24 @@
        <string>0</string>
       </property>
      </item>
      <item row="6" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
     </widget>
    </item>
    <item row="2" column="0">
     <widget class="QPushButton" name="pushButton">
      <property name="minimumSize">
       <size>
        <width>0</width>
        <height>50</height>
       </size>
      </property>
      <property name="text">
       <string>提交--问题个数</string>
      </property>
     </widget>
    </item>
   </layout>

 internal_system_v1/problemmoney.cpp

@@ -1,5 +1,8 @@
#include "problemmoney.h"
#include "ui_problemmoney.h"
#include <QPushButton>
#include <QDebug>
#include <QSqlQuery>

ProblemMoney::ProblemMoney(QWidget *parent) :
    QMainWindow(parent),
@@ -7,9 +10,42 @@
{
    ui->setupUi(this);
    ui->tableWidget->setColumnWidth(0,300);
    m_comId = 1;
    for(int i=0;i<ui->tableWidget->rowCount();++i){
        QPushButton *btn = new QPushButton("上传",this);
        ui->tableWidget->setCellWidget(i,3,btn);
        connect(btn,&QPushButton::clicked,this,[=]{
            QStringList files = QFileDialog::getOpenFileNames();
            QString str;
            for(auto f:files){
                str += f + " ";
            }
            ui->tableWidget->setItem(i,4,new QTableWidgetItem(str));
        });
    }
}

ProblemMoney::~ProblemMoney()
{
    delete ui;
}

void ProblemMoney::on_pushButton_clicked()
{
    QString values = "";
    for(int i=0;i<ui->tableWidget->rowCount();++i){
        values += QString("('%1','%2',%3,'%4',%5),").arg(ui->tableWidget->item(i,0)->text())
                .arg(ui->tableWidget->item(i,1)->text()).arg(ui->tableWidget->item(i,2)->text().toInt())
                .arg(ui->tableWidget->item(i,4)->text())
                .arg(m_comId);
    }
    values = values.left(values.length()-1);
    QString sql = QString("insert into problem_money (kpi_name,code,num,evidences,com_id) values %1").arg(values);
    qDebug()<<sql;
    QSqlQuery query;
    if(query.exec(sql)){
        qDebug()<<"OK sql"<<__FUNCTION__;
    }else{
        qDebug()<<"fail sql"<<__FUNCTION__;
    }
}

 internal_system_v1/problemmoney.h

@@ -2,6 +2,7 @@
#define PROBLEMMONEY_H

#include <QMainWindow>
#include <QFileDialog>

namespace Ui {
class ProblemMoney;
@@ -15,8 +16,12 @@
    explicit ProblemMoney(QWidget *parent = 0);
    ~ProblemMoney();

private slots:
    void on_pushButton_clicked();

private:
    Ui::ProblemMoney *ui;
    int m_comId;
};

#endif // PROBLEMMONEY_H

 internal_system_v1/problemmoney.ui

@@ -15,13 +15,6 @@
  </property>
  <widget class="QWidget" name="centralwidget">
   <layout class="QGridLayout" name="gridLayout">
    <item row="0" column="0">
     <widget class="QLabel" name="label">
      <property name="text">
       <string>问题金额</string>
      </property>
     </widget>
    </item>
    <item row="1" column="0">
     <widget class="QTableWidget" name="tableWidget">
      <attribute name="verticalHeaderVisible">
@@ -102,6 +95,11 @@
        <string>上传佐证资料</string>
       </property>
      </column>
      <column>
       <property name="text">
        <string>佐证资料</string>
       </property>
      </column>
      <item row="0" column="0">
       <property name="text">
        <string>审计发现问题金额</string>
@@ -115,6 +113,11 @@
      <item row="0" column="2">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="0" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="1" column="0">
@@ -132,6 +135,11 @@
        <string>0</string>
       </property>
      </item>
      <item row="1" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="2" column="0">
       <property name="text">
        <string>合规性问题金额</string>
@@ -145,6 +153,11 @@
      <item row="2" column="2">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="2" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="3" column="0">
@@ -162,6 +175,11 @@
        <string>0</string>
       </property>
      </item>
      <item row="3" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="4" column="0">
       <property name="text">
        <string>违规使用资金</string>
@@ -175,6 +193,11 @@
      <item row="4" column="2">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="4" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="5" column="0">
@@ -192,6 +215,11 @@
        <string>0</string>
       </property>
      </item>
      <item row="5" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="6" column="0">
       <property name="text">
        <string>损失浪费</string>
@@ -205,6 +233,11 @@
      <item row="6" column="2">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="6" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="7" column="0">
@@ -222,6 +255,11 @@
        <string>0</string>
       </property>
      </item>
      <item row="7" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="8" column="0">
       <property name="text">
        <string>偷漏税费</string>
@@ -235,6 +273,11 @@
      <item row="8" column="2">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="8" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="9" column="0">
@@ -252,6 +295,11 @@
        <string>0</string>
       </property>
      </item>
      <item row="9" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="10" column="0">
       <property name="text">
        <string>其他</string>
@@ -267,6 +315,31 @@
        <string>0</string>
       </property>
      </item>
      <item row="10" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
     </widget>
    </item>
    <item row="0" column="0">
     <widget class="QLabel" name="label">
      <property name="text">
       <string>问题金额</string>
      </property>
     </widget>
    </item>
    <item row="2" column="0">
     <widget class="QPushButton" name="pushButton">
      <property name="minimumSize">
       <size>
        <width>0</width>
        <height>50</height>
       </size>
      </property>
      <property name="text">
       <string>提交--问题金额</string>
      </property>
     </widget>
    </item>
   </layout>

 internal_system_v1/problemnotmoney.cpp

@@ -1,12 +1,30 @@
#include "problemnotmoney.h"
#include "ui_problemnotmoney.h"

#include <QFileDialog>
#include <QPushButton>
#include <QSqlQuery>
#include <QDebug>

ProblemNotMoney::ProblemNotMoney(QWidget *parent) :
    QMainWindow(parent),
    ui(new Ui::ProblemNotMoney)
{
    ui->setupUi(this);
    ui->tableWidget->setColumnWidth(0,300);
    m_comId = 1;
    for(int i=0;i<ui->tableWidget->rowCount();++i){
        QPushButton *btn = new QPushButton("上传",this);
        ui->tableWidget->setCellWidget(i,3,btn);
        connect(btn,&QPushButton::clicked,this,[=]{
            QStringList files = QFileDialog::getOpenFileNames();
            QString str;
            for(auto f:files){
                str += f + " ";
            }
            ui->tableWidget->setItem(i,4,new QTableWidgetItem(str));
        });
    }
}

ProblemNotMoney::~ProblemNotMoney()
@@ -22,3 +40,26 @@
    }
    ui->tableWidget->setItem(0,2,new QTableWidgetItem(QString::number(allCnt)));
}

void ProblemNotMoney::on_pushButton_clicked()
{
    // 再统计一把
    on_tableWidget_clicked(QModelIndex());

    QString values = "";
    for(int i=0;i<ui->tableWidget->rowCount();++i){
        values += QString("('%1','%2',%3,'%4',%5),").arg(ui->tableWidget->item(i,0)->text())
                .arg(ui->tableWidget->item(i,1)->text()).arg(ui->tableWidget->item(i,2)->text().toInt())
                .arg(ui->tableWidget->item(i,4)->text())
                .arg(m_comId);
    }
    values = values.left(values.length()-1);
    QString sql = QString("insert into problem_no_money (kpi_name,code,num,evidences,com_id) values %1").arg(values);
    qDebug()<<sql;
    QSqlQuery query;
    if(query.exec(sql)){
        qDebug()<<"OK sql"<<__FUNCTION__;
    }else{
        qDebug()<<"fail sql"<<__FUNCTION__;
    }
}

 internal_system_v1/problemnotmoney.h

@@ -18,8 +18,11 @@
private slots:
    void on_tableWidget_clicked(const QModelIndex &index);

    void on_pushButton_clicked();

private:
    Ui::ProblemNotMoney *ui;
    int m_comId;
};

#endif // PROBLEMNOTMONEY_H

 internal_system_v1/problemnotmoney.ui

@@ -72,6 +72,11 @@
        <string>上传佐证资料</string>
       </property>
      </column>
      <column>
       <property name="text">
        <string>佐证资料</string>
       </property>
      </column>
      <item row="0" column="0">
       <property name="text">
        <string>审计发现问题整改（非金额类）</string>
@@ -85,6 +90,11 @@
      <item row="0" column="2">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="0" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="1" column="0">
@@ -102,6 +112,11 @@
        <string>0</string>
       </property>
      </item>
      <item row="1" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="2" column="0">
       <property name="text">
        <string>修订完善制度</string>
@@ -115,6 +130,11 @@
      <item row="2" column="2">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="2" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="3" column="0">
@@ -132,6 +152,11 @@
        <string>0</string>
       </property>
      </item>
      <item row="3" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="4" column="0">
       <property name="text">
        <string>其他</string>
@@ -147,6 +172,24 @@
        <string>0</string>
       </property>
      </item>
      <item row="4" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
     </widget>
    </item>
    <item row="2" column="0">
     <widget class="QPushButton" name="pushButton">
      <property name="minimumSize">
       <size>
        <width>0</width>
        <height>50</height>
       </size>
      </property>
      <property name="text">
       <string>提交--问题整改非金额</string>
      </property>
     </widget>
    </item>
   </layout>

 internal_system_v1/problemrectification.cpp

@@ -1,12 +1,30 @@
#include "problemrectification.h"
#include "ui_problemrectification.h"

#include <QFileDialog>
#include <QPushButton>
#include <QSqlQuery>
#include <QDebug>

ProblemRectification::ProblemRectification(QWidget *parent) :
    QMainWindow(parent),
    ui(new Ui::ProblemRectification)
{
    ui->setupUi(this);
    ui->tableWidget->setColumnWidth(0,300);
    m_comId = 1;
    for(int i=0;i<ui->tableWidget->rowCount();++i){
        QPushButton *btn = new QPushButton("上传",this);
        ui->tableWidget->setCellWidget(i,3,btn);
        connect(btn,&QPushButton::clicked,this,[=]{
            QStringList files = QFileDialog::getOpenFileNames();
            QString str;
            for(auto f:files){
                str += f + " ";
            }
            ui->tableWidget->setItem(i,4,new QTableWidgetItem(str));
        });
    }
}

ProblemRectification::~ProblemRectification()
@@ -22,3 +40,26 @@
    }
    ui->tableWidget->setItem(0,2,new QTableWidgetItem(QString::number(allCnt)));
}

void ProblemRectification::on_pushButton_clicked()
{
    // 再统计一把
    on_tableWidget_clicked(QModelIndex());

    QString values = "";
    for(int i=0;i<ui->tableWidget->rowCount();++i){
        values += QString("('%1','%2',%3,'%4',%5),").arg(ui->tableWidget->item(i,0)->text())
                .arg(ui->tableWidget->item(i,1)->text()).arg(ui->tableWidget->item(i,2)->text().toInt())
                .arg(ui->tableWidget->item(i,4)->text())
                .arg(m_comId);
    }
    values = values.left(values.length()-1);
    QString sql = QString("insert into problem_rectification (kpi_name,code,num,evidences,com_id) values %1").arg(values);
    qDebug()<<sql;
    QSqlQuery query;
    if(query.exec(sql)){
        qDebug()<<"OK sql"<<__FUNCTION__;
    }else{
        qDebug()<<"fail sql"<<__FUNCTION__;
    }
}

 internal_system_v1/problemrectification.h

@@ -18,8 +18,11 @@
private slots:
    void on_tableWidget_clicked(const QModelIndex &index);

    void on_pushButton_clicked();

private:
    Ui::ProblemRectification *ui;
    int m_comId;
};

#endif // PROBLEMRECTIFICATION_H

 internal_system_v1/problemrectification.ui

@@ -82,6 +82,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="2">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="0" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="1" column="0">
@@ -112,6 +122,11 @@
        <string>0</string>
       </property>
      </item>
      <item row="1" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="2" column="0">
       <property name="text">
        <string>收回资金</string>
@@ -125,6 +140,11 @@
      <item row="2" column="2">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="2" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="3" column="0">
@@ -142,6 +162,11 @@
        <string>0</string>
       </property>
      </item>
      <item row="3" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="4" column="0">
       <property name="text">
        <string>归还原资金渠道</string>
@@ -155,6 +180,11 @@
      <item row="4" column="2">
       <property name="text">
        <string>0</string>
       </property>
      </item>
      <item row="4" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="5" column="0">
@@ -172,6 +202,11 @@
        <string>0</string>
       </property>
      </item>
      <item row="5" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
      <item row="6" column="0">
       <property name="text">
        <string>其他</string>
@@ -187,6 +222,24 @@
        <string>0</string>
       </property>
      </item>
      <item row="6" column="4">
       <property name="text">
        <string>无</string>
       </property>
      </item>
     </widget>
    </item>
    <item row="2" column="0">
     <widget class="QPushButton" name="pushButton">
      <property name="minimumSize">
       <size>
        <width>0</width>
        <height>50</height>
       </size>
      </property>
      <property name="text">
       <string>提交--问题整改</string>
      </property>
     </widget>
    </item>
   </layout>

 internal_system_v1/punish.cpp

@@ -1,12 +1,16 @@
#include "punish.h"
#include "ui_punish.h"

#include <QSqlQuery>
#include <QDebug>

Punish::Punish(QWidget *parent) :
    QMainWindow(parent),
    ui(new Ui::Punish)
{
    ui->setupUi(this);
    ui->tableWidget->setColumnWidth(0,320);
    m_comId = 1;
}

Punish::~Punish()
@@ -22,3 +26,25 @@
    }
    ui->tableWidget->setItem(0,2,new QTableWidgetItem(QString::number(allCnt)));
}

void Punish::on_pushButton_clicked()
{
    // 再统计一把
    on_tableWidget_clicked(QModelIndex());

    QString values = "";
    for(int i=0;i<ui->tableWidget->rowCount();++i){
        values += QString("('%1','%2',%3,%4),").arg(ui->tableWidget->item(i,0)->text())
                .arg(ui->tableWidget->item(i,1)->text()).arg(ui->tableWidget->item(i,2)->text().toInt())
                .arg(m_comId);
    }
    values = values.left(values.length()-1);
    QString sql = QString("insert into punish (kpi_name,code,num,com_id) values %1").arg(values);
    qDebug()<<sql;
    QSqlQuery query;
    if(query.exec(sql)){
        qDebug()<<"OK sql"<<__FUNCTION__;
    }else{
        qDebug()<<"fail sql"<<__FUNCTION__;
    }
}

 internal_system_v1/punish.h

@@ -18,8 +18,11 @@
private slots:
    void on_tableWidget_clicked(const QModelIndex &index);

    void on_pushButton_clicked();

private:
    Ui::Punish *ui;
    int m_comId;
};

#endif // PUNISH_H

 internal_system_v1/punish.ui

@@ -124,6 +124,19 @@
      </item>
     </widget>
    </item>
    <item row="2" column="0">
     <widget class="QPushButton" name="pushButton">
      <property name="minimumSize">
       <size>
        <width>0</width>
        <height>50</height>
       </size>
      </property>
      <property name="text">
       <string>提交--处分</string>
      </property>
     </widget>
    </item>
   </layout>
  </widget>
  <widget class="QMenuBar" name="menubar">

 internal_system_v1/searchinfo.cpp

@@ -1,6 +1,8 @@
#include "searchinfo.h"
#include "ui_searchinfo.h"
#include <QDebug>
#include <QSqlError>
#include <QSqlQuery>

SearchInfo::SearchInfo(QWidget *parent) :
    QMainWindow(parent),
@@ -15,7 +17,8 @@
    m_db.setDatabaseName("sqlData.db");
    if(m_db.open()){
        qDebug()<<"db open ok";
        m_db.close();
        createSqlite();
        //m_db.close();
    }else{
        qDebug()<<"db open fail";
    }
@@ -25,5 +28,121 @@

SearchInfo::~SearchInfo()
{
    m_db.close();
    delete ui;
}

void SearchInfo::createSqlite()
{
    // 建表
    QString sql = "create table Internal_1 (id int primary key, name varchar(30), _020100 int)";
    QSqlQuery query;
    if(query.exec(sql))
    {
        qDebug()<<"create Internal_1 ok...";
    }else{
        qDebug()<<"create Internal_1 fail..."<<query.lastError().text();
    }

    sql = "CREATE TABLE file_up_info (\
            id      INTEGER      PRIMARY KEY AUTOINCREMENT,\
            name    VARCHAR (30),\
            code    TEXT,\
            up_time TEXT\
        )";
    if(query.exec(sql))
    {
        qDebug()<<"create file_up_info ok...";
    }else{
        qDebug()<<"create file_up_info fail..."<<query.lastError().text();
    }

    sql = "create table company_info (id INTEGER PRIMARY key AUTOINCREMENT, name varchar(30), code varchar(30))";
    if(query.exec(sql))
    {
        qDebug()<<"create company_info ok...";
    }else{
        qDebug()<<"create company_info fail..."<<query.lastError().text();
    }

    // 审计项目表
    createTableNoEvidences("audit_project");

    // 内审工作量表
    createTableNoEvidences("audit_workload");

    // 问题金额表
    createTableHasEvidences("problem_money");

    // 问题个数表
    createTableHasEvidences("problem_count");

    // 问题整改表
    createTableHasEvidences("problem_rectification");

    // 问题整改--非金额表
    createTableHasEvidences("problem_no_money");

    // 处分表
    createTableNoEvidences("punish");

    // 案件线索表
    createTableHasUnit("case_clue");

}

void SearchInfo::createTableHasEvidences(QString tableName)
{
    QString sql =QString( "CREATE TABLE %1 ( \
            id        INTEGER PRIMARY KEY AUTOINCREMENT,\
            kpi_name  TEXT,\
            code      TEXT,\
            num       INTEGER,\
            evidences TEXT,\
            com_id  INTEGER\
        )").arg(tableName);
    QSqlQuery query;
    if(query.exec(sql))
    {
        qDebug()<<QString("create %1 ok...").arg(tableName);
    }else{
        qDebug()<<QString("create %1 fail...").arg(tableName)<<query.lastError().text();
    }
}

void SearchInfo::createTableNoEvidences(QString tableName)
{
    QString sql = QString("CREATE TABLE %1 (\
            id       INTEGER PRIMARY KEY AUTOINCREMENT,\
            kpi_name TEXT,\
            code     TEXT,\
            num      INTEGER,\
            com_id  INTEGER\
        )").arg(tableName);
    QSqlQuery query;
    if(query.exec(sql))
    {
        qDebug()<<QString("create %1 ok...").arg(tableName);
    }else{
        qDebug()<<QString("create %1 fail...").arg(tableName)<<query.lastError().text();
    }
}

void SearchInfo::createTableHasUnit(QString tableName)
{
    QString sql = QString("CREATE TABLE %1 (\
            id       INTEGER PRIMARY KEY AUTOINCREMENT,\
            kpi_name TEXT,\
            code     TEXT,\
            unit     TEXT,\
            num      INTEGER,\
            com_id  INTEGER\
        )").arg(tableName);
    QSqlQuery query;
    if(query.exec(sql))
    {
        qDebug()<<QString("create %1 ok...").arg(tableName);
    }else{
        qDebug()<<QString("create %1 fail...").arg(tableName)<<query.lastError().text();
    }
}

 internal_system_v1/searchinfo.h

@@ -15,6 +15,10 @@
public:
    explicit SearchInfo(QWidget *parent = 0);
    ~SearchInfo();
    void createSqlite();
    void createTableHasEvidences(QString tableName); // 有佐证的表
    void createTableNoEvidences(QString tableName); // 无佐证的表
    void createTableHasUnit(QString tableName); // 无佐证的表且有计量单位的表

private:
    Ui::SearchInfo *ui;

 internal_system_v1/searchinfo.ui

@@ -37,12 +37,37 @@
         </item>
         <item>
          <property name="text">
           <string>内审工作量</string>
          </property>
         </item>
         <item>
          <property name="text">
           <string>问题金额</string>
          </property>
         </item>
         <item>
          <property name="text">
           <string>问题个数</string>
          </property>
         </item>
         <item>
          <property name="text">
           <string>问题整改</string>
          </property>
         </item>
         <item>
          <property name="text">
           <string>问题整改--非金额</string>
          </property>
         </item>
         <item>
          <property name="text">
           <string>处分</string>
          </property>
         </item>
         <item>
          <property name="text">
           <string>案件线索</string>
          </property>
         </item>
        </widget>
@@ -69,6 +94,16 @@
       </item>
       <item>
        <widget class="QDateTimeEdit" name="dateTimeEdit">
         <property name="dateTime">
          <datetime>
           <hour>0</hour>
           <minute>0</minute>
           <second>0</second>
           <year>2022</year>
           <month>1</month>
           <day>1</day>
          </datetime>
         </property>
         <property name="calendarPopup">
          <bool>true</bool>
         </property>
@@ -83,6 +118,16 @@
       </item>
       <item>
        <widget class="QDateTimeEdit" name="dateTimeEdit_2">
         <property name="dateTime">
          <datetime>
           <hour>0</hour>
           <minute>0</minute>
           <second>0</second>
           <year>2023</year>
           <month>1</month>
           <day>1</day>
          </datetime>
         </property>
         <property name="calendarPopup">
          <bool>true</bool>
         </property>

 sqlData.sql

New file
@@ -0,0 +1,16 @@
--
-- SQLiteStudio v3.4.3 生成的文件，周五 8月 25 15:43:41 2023
--
-- 所用的文本编码：System
--
PRAGMA foreign_keys = off;
BEGIN TRANSACTION;

-- 表：file_up_info
CREATE TABLE IF NOT EXISTS file_up_info (id int PRIMARY KEY, name varchar (30), code int, up_time TEXT);

-- 表：Internal_1
CREATE TABLE IF NOT EXISTS Internal_1 (id int PRIMARY KEY, name varchar (30), _020100 int, _020101 int, _020102 int, _020103 int, _020104 int, _020105 int, _020106 int, _020107 int, _020108 int, _020111 int, _020200 int, _020700 int, _020701 int, _020702 int, _020703 int, _020800 int, _020801 int);

COMMIT TRANSACTION;
PRAGMA foreign_keys = on;