0831

wumu

2023-08-31 10457ff67b999e9cc99624801c635e7f25e0d5ef

0831

 internal_system_v1/auditproject.cpp

@@ -3,6 +3,7 @@
#include <QDebug>
#include <QSqlQuery>

extern int g_comId;
AuditProject::AuditProject(QWidget *parent) :
    QMainWindow(parent),
    ui(new Ui::AuditProject)
@@ -16,7 +17,7 @@
        }
    }
    ui->tableWidget->setColumnWidth(0,300);
    m_comId = 1; // 单位id
    m_comId = g_comId; // 单位id

}

@@ -50,7 +51,7 @@
    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);
                .arg(g_comId);
    }
    //qDebug()<<values;
    values = values.left(values.length()-1);

 internal_system_v1/auditworkload.cpp

@@ -3,13 +3,15 @@
#include <QDebug>
#include <QSqlQuery>

extern int g_comId;

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

AuditWorkload::~AuditWorkload()
@@ -23,7 +25,7 @@
    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);
                .arg(g_comId);
    }
    values = values.left(values.length()-1);
    QString sql = QString("insert into audit_workload (kpi_name,code,num,com_id) values %1").arg(values);

 internal_system_v1/caseclue.cpp

@@ -3,13 +3,15 @@
#include <QDebug>
#include <QSqlQuery>

extern int g_comId;

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

CaseClue::~CaseClue()
@@ -24,7 +26,7 @@
        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);
                .arg(g_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);

 internal_system_v1/clientmainwindow.cpp

@@ -19,6 +19,12 @@

void ClientMainWindow::initUi()
{
    m_searchInfo = new SearchInfo(this);
    ui->tabWidget->addTab(m_searchInfo,"信息查询");

    m_coverInfo = new CoverInfo(this);
    m_coverInfo->setParent(ui->tab);

    m_auditPro = new AuditProject(this);
    m_auditworkload = new AuditWorkload(this);
    m_problemMon = new ProblemMoney(this);
@@ -39,11 +45,13 @@

    ui->stackedWidget->setCurrentIndex(0);

    m_coverInfo = new CoverInfo(this);
    m_coverInfo->setParent(ui->tab);
//    m_searchInfo = new SearchInfo(this);
//    ui->tabWidget->addTab(m_searchInfo,"信息查询");

    m_searchInfo = new SearchInfo(this);
    ui->tabWidget->addTab(m_searchInfo,"信息查询");
//    m_coverInfo = new CoverInfo(this);
//    m_coverInfo->setParent(ui->tab);


}

void ClientMainWindow::on_pushButton_auditPro_clicked()

 internal_system_v1/coverinfo.cpp

@@ -2,6 +2,10 @@
#include "ui_coverinfo.h"
#include <QDebug>
#include <QDirIterator>
#include <QSqlQuery>
#include <QSqlRecord>

int g_comId = 0; // 全局变量，保存单位id

CoverInfo::CoverInfo(QWidget *parent) :
    QMainWindow(parent),
@@ -9,6 +13,8 @@
{
    ui->setupUi(this);
    readInfo();
    readDataFromSQL(); // 从数据库读取数据

}

CoverInfo::~CoverInfo()
@@ -161,9 +167,6 @@
                // 网址
                QVariant webSite = valRows[32].toList().at(5);
                if(webSite.isValid()) ui->label_webSite->setText(webSite.toString());



            }
            wbs->dynamicCall("Close()");
            excel.dynamicCall("Quit(void)");
@@ -176,3 +179,84 @@
//    excel.setProperty("DisplayAlerts",false);

}

void CoverInfo::readDataFromSQL()
{
    QSqlQuery query;
    QString sql;
    if(ui->label_name->text().size() > 1){
        sql = QString("select id,name from company_info where name='%1'").arg(ui->label_name->text());
        qDebug()<<"查询公司sql:"<<sql;
        if(query.exec(sql)){
            qDebug()<<"OK sql"<<__FUNCTION__;
            QSqlRecord res = query.record();
            qDebug()<<query.size()<<query.numRowsAffected()<<res.count();
            if(!query.next()){
                // 插入一条单位信息：
                sql = QString("insert into company_info (name,code,机构类型,主要业务活动,行业代码,单位注册地及区域,"
                              "区域代码,城乡代码,单位规模,从业期末人数,法定代表人,执行会记标准类别,长途区号,固定电话,邮政编码,"
                              "电子邮箱,网址) values ('%1','%2','%3','%4','%5','%6','%7','%8','%9','%10','%11','%12','%13','%14','%15','%16','%17')").arg(ui->label_name->text())
                        .arg(ui->label_creditCode->text()).arg(ui->label_comType->text()).arg(ui->label_business->text()).arg(ui->label_businessCode->text()).arg(ui->label_addr->text())
                        .arg(ui->label_areaCode->text()).arg(ui->label_townCode->text()).arg(ui->label_scale->text()).arg(ui->label_people->text()).arg(ui->label_representative->text())
                        .arg(ui->label_standardType->text()).arg(ui->label_trunkCode->text()).arg(ui->label_fixedTel->text()).arg(ui->label_postCode->text()).arg(ui->label_email->text())
                        .arg(ui->label_webSite->text());
                qDebug()<<"com_insert sql:"<<sql;
                if(query.exec(sql)){
                    qDebug()<<"insert com ok";
                }else{
                    qDebug()<<"insert com fail";
                }

            }else{
                g_comId = query.value(0).toInt();
            }
        }else{
            qDebug()<<"fail sql"<<__FUNCTION__;
        }
    }
    sql = QString("select id,name from company_info");
    if(query.exec(sql)){
        qDebug()<<"size:"<<query.size();
        while(query.next()){
            int id = query.value(0).toInt();
            QString name = query.value(1).toString();
            qDebug()<<"com select:"<<id<<name;
            m_com[name] = id;
            ui->comboBox->addItem(name);
        }
    }

}

void CoverInfo::on_comboBox_currentIndexChanged(const QString &arg1)
{
    QString sql = QString("select * from company_info where name='%1'").arg(arg1);
    QSqlQuery query;
    if(query.exec(sql)){
        qDebug()<<"切换查询成功:"<<arg1;
        while (query.next()) {
            qDebug()<<"切换查询成功查询到目标单位:"<<arg1;
            g_comId = query.value(0).toInt();
            ui->label_name->setText(query.value(1).toString());
            ui->label_creditCode->setText(query.value(2).toString());
            ui->label_comType->setText(query.value(3).toString());
            ui->label_business->setText(query.value(4).toString());
            ui->label_businessCode->setText(query.value(5).toString());
            ui->label_addr->setText(query.value(6).toString());
            ui->label_areaCode->setText(query.value(7).toString());
            ui->label_townCode->setText(query.value(8).toString());
            ui->label_scale->setText(query.value(9).toString());
            ui->label_people->setText(query.value(10).toString());
            ui->label_representative->setText(query.value(11).toString());
            ui->label_standardType->setText(query.value(12).toString());
            ui->label_trunkCode->setText(query.value(13).toString());
            ui->label_fixedTel->setText(query.value(14).toString());
            ui->label_postCode->setText(query.value(15).toString());
            ui->label_email->setText(query.value(16).toString());
            ui->label_webSite->setText(query.value(17).toString());
            break;
        }
    }else{
        qDebug()<<"切换查询失败:"<<arg1;
    }
}

 internal_system_v1/coverinfo.h

@@ -17,8 +17,13 @@
    explicit CoverInfo(QWidget *parent = 0);
    ~CoverInfo();
    void readInfo();
    void readDataFromSQL();
private slots:
    void on_comboBox_currentIndexChanged(const QString &arg1);

private:
    Ui::CoverInfo *ui;
    QMap<QString,int> m_com;
};

#endif // COVERINFO_H

 internal_system_v1/problemcount.cpp

@@ -5,13 +5,15 @@
#include <QPushButton>
#include <QSqlQuery>

extern int g_comId;

ProblemCount::ProblemCount(QWidget *parent) :
    QMainWindow(parent),
    ui(new Ui::ProblemCount)
{
    ui->setupUi(this);
    ui->tableWidget->setColumnWidth(0,300);
    m_comId = 1;
    m_comId = g_comId;
    for(int i=0;i<ui->tableWidget->rowCount();++i){
        QPushButton *btn = new QPushButton("上传",this);
        ui->tableWidget->setCellWidget(i,3,btn);
@@ -71,7 +73,7 @@
        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);
                .arg(g_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);

 internal_system_v1/problemmoney.cpp

@@ -4,13 +4,15 @@
#include <QDebug>
#include <QSqlQuery>

extern int g_comId;

ProblemMoney::ProblemMoney(QWidget *parent) :
    QMainWindow(parent),
    ui(new Ui::ProblemMoney)
{
    ui->setupUi(this);
    ui->tableWidget->setColumnWidth(0,300);
    m_comId = 1;
    m_comId = g_comId;
    for(int i=0;i<ui->tableWidget->rowCount();++i){
        QPushButton *btn = new QPushButton("上传",this);
        ui->tableWidget->setCellWidget(i,3,btn);
@@ -37,7 +39,7 @@
        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);
                .arg(g_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);

 internal_system_v1/problemnotmoney.cpp

@@ -6,13 +6,15 @@
#include <QSqlQuery>
#include <QDebug>

extern int g_comId;

ProblemNotMoney::ProblemNotMoney(QWidget *parent) :
    QMainWindow(parent),
    ui(new Ui::ProblemNotMoney)
{
    ui->setupUi(this);
    ui->tableWidget->setColumnWidth(0,300);
    m_comId = 1;
    m_comId = g_comId;
    for(int i=0;i<ui->tableWidget->rowCount();++i){
        QPushButton *btn = new QPushButton("上传",this);
        ui->tableWidget->setCellWidget(i,3,btn);
@@ -51,7 +53,7 @@
        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);
                .arg(g_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);

 internal_system_v1/problemrectification.cpp

@@ -6,13 +6,15 @@
#include <QSqlQuery>
#include <QDebug>

extern int g_comId;

ProblemRectification::ProblemRectification(QWidget *parent) :
    QMainWindow(parent),
    ui(new Ui::ProblemRectification)
{
    ui->setupUi(this);
    ui->tableWidget->setColumnWidth(0,300);
    m_comId = 1;
    m_comId = g_comId;
    for(int i=0;i<ui->tableWidget->rowCount();++i){
        QPushButton *btn = new QPushButton("上传",this);
        ui->tableWidget->setCellWidget(i,3,btn);
@@ -51,7 +53,7 @@
        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);
                .arg(g_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);

 internal_system_v1/punish.cpp

@@ -4,13 +4,15 @@
#include <QSqlQuery>
#include <QDebug>

extern int g_comId;

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

Punish::~Punish()
@@ -36,7 +38,7 @@
    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);
                .arg(g_comId);
    }
    values = values.left(values.length()-1);
    QString sql = QString("insert into punish (kpi_name,code,num,com_id) values %1").arg(values);

 internal_system_v1/searchinfo.cpp

@@ -57,7 +57,26 @@
        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))";
    sql = "CREATE TABLE company_info (\
            id       INTEGER      PRIMARY KEY AUTOINCREMENT,\
            name     VARCHAR (30),\
            code     VARCHAR (30),\
            机构类型     TEXT,\
            主要业务活动   TEXT,\
            行业代码     TEXT,\
            单位注册地及区域 TEXT,\
            区域代码     TEXT,\
            城乡代码     TEXT,\
            单位规模     TEXT,\
            从业期末人数   TEXT,\
            法定代表人    TEXT,\
            执行会记标准类别 TEXT,\
            长途区号     TEXT,\
            固定电话     TEXT,\
            邮政编码     TEXT,\
            电子邮箱     TEXT,\
            网址       TEXT\
        )";
    if(query.exec(sql))
    {
        qDebug()<<"create company_info ok...";

 internal_system_v1/searchinfo.ui

@@ -147,6 +147,22 @@
        </spacer>
       </item>
       <item>
        <widget class="QLabel" name="label_4">
         <property name="text">
          <string>单位名称:</string>
         </property>
        </widget>
       </item>
       <item>
        <widget class="QComboBox" name="comboBox_2">
         <item>
          <property name="text">
           <string>公司名称</string>
          </property>
         </item>
        </widget>
       </item>
       <item>
        <widget class="QPushButton" name="pushButton">
         <property name="text">
          <string>查询</string>