0304

wumu

2024-03-04 31ed29f804a6850ef9a8f60326f4da603e7c8a39

 internal_system_v1/clientmainwindow.cpp

@@ -1,4 +1,4 @@
#include "clientmainwindow.h"
#include "clientmainwindow.h"
#include "ui_clientmainwindow.h"
#include <QDebug>
#include <QFileDialog>
@@ -7,6 +7,7 @@
#include <QSqlRecord>

extern int g_comId;
extern QString g_dataRootPath;
QString g_auditDate;

ClientMainWindow::ClientMainWindow(QWidget *parent) :
@@ -17,12 +18,34 @@

    ui->dateEdit->setDate(QDate::currentDate());
    g_auditDate = QDate::currentDate().toString("yyyy-MM-dd");
    ui->tableWidget->setColumnWidth(0,200);
    ui->tableWidget->setColumnWidth(1,80);
    ui->tableWidget->setColumnWidth(2,80);
    ui->tableWidget->setColumnWidth(4,ui->tableWidget->columnWidth(4)+15);
    initUi();
    searchComName();
}

ClientMainWindow::~ClientMainWindow()
{
    delete ui;
}
void ClientMainWindow::searchComName()
{
    QSqlQuery query;
    QString sql = QString("select id,name,code from company_info");
    if(query.exec(sql)){
        qDebug()<<"size:"<<query.numRowsAffected();
        while(query.next()){
            int id = query.value(0).toInt();
            QString name = query.value(1).toString();
            QString code = query.value(2).toString();
            qDebug()<<"com select:"<<id<<name;
            m_comInfo[name] = id;
            //m_comCode[name] = code;
            ui->comboBox_company->addItem(name);
        }
    }
}

void ClientMainWindow::initUi()
@@ -60,7 +83,16 @@
//    m_coverInfo->setParent(ui->tab);

    // 隐藏掉某个选项
    // 按索引来，从大到小
    ui->tabWidget->removeTab(3); // OK
    ui->tabWidget->removeTab(1); // OK  老业务情况表
    ui->tabWidget->removeTab(0); // OK  老封面



    // 问题整改台账
    m_proRecStandingBook = new ProblemRectStandingBook(this);
    ui->tabWidget->addTab(m_proRecStandingBook,"问题整改台账");

    // 关联各个功能槽
    connect(m_coverInfo,SIGNAL(sendComName(QString)),m_searchInfo,SLOT(addComName(QString)));
@@ -73,6 +105,17 @@
    connect(this,SIGNAL(sendDataToProblemNoMoney(QVariantList)),m_problemNotMon,SLOT(showData(QVariantList)));
    connect(this,SIGNAL(sendDataToPunish(QVariantList)),m_punish,SLOT(showData(QVariantList)));
    connect(this,SIGNAL(sendDataToCaseClue(QVariantList)),m_caseClue,SLOT(showData(QVariantList)));

    // 新版本
    m_conInfo2 = new ConverInfo2(this);
    //ui->tabWidget->addTab(m_conInfo2,"基本信息");
    ui->tabWidget->insertTab(0,m_conInfo2,"封面信息");

    m_problemList = new ProblemList(this);
    ui->tabWidget->addTab(m_problemList,"问题清单");

    m_problemRectifResult = new ProblemRectificationResult(this);
    ui->tabWidget->addTab(m_problemRectifResult,"整改成果");


}
@@ -107,7 +150,8 @@
        if(comName.isValid()){
            if(!readDataFromSQL(comName.toString())){
                QMessageBox::information(this,"导入中断","请确认公司基本信息已经存在");
                return;
                break;
                //return;
            }
            qDebug()<<comName<<g_comId;
        }
@@ -284,8 +328,141 @@

}

void ClientMainWindow::calc()
{
    for(int i=1;i<ui->tableWidget->rowCount();++i){
        int sum = 0;
        for(int j=4;j<ui->tableWidget->columnCount();++j){
            sum += ui->tableWidget->item(i,j)->text().toInt();
        }
        ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(sum)));

        if(i==7){ // 学历
            int val = 0;
            for(int j = 8;j<=10;++j){
                val += ui->tableWidget->item(j,3)->text().toInt();
            }
            ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val)));
        }

        if(i==11){ // 职称
            int val = 0;
            for(int j = 12;j<=15;++j){
                val += ui->tableWidget->item(j,3)->text().toInt();
            }
            ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val)));
        }

        if(i==20){ // 知识结构
            int val = 0;
            for(int j = 21;j<=28;++j){
                val += ui->tableWidget->item(j,3)->text().toInt();
            }
            ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val)));
        }

        if(i==30){ // 审计项目
            int val = 0;
            for(int j = 31;j<=38;++j){
                val += ui->tableWidget->item(j,3)->text().toInt();
            }
            ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val)));
        }

        if(i==41){ // 审计发现问题金额
            int val = 0;
            for(int j = 42;j<=43;++j){
                val += ui->tableWidget->item(j,3)->text().toInt();
            }
            ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val)));
        }

        if(i==43){ // 合规性问题金额
            int val = 0;
            for(int j = 44;j<=51;++j){
                val += ui->tableWidget->item(j,3)->text().toInt();
            }
            ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val)));
        }

        if(i==52){ // 审计发现问题个数
            int val = 0;
            for(int j = 53;j<=54;++j){
                val += ui->tableWidget->item(j,3)->text().toInt();
            }
            ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val)));
        }

        if(i==54){ // 非金额类问题个数
            int val = 0;
            for(int j = 55;j<=58;++j){
                val += ui->tableWidget->item(j,3)->text().toInt();
            }
            ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val)));
        }

        if(i==59){ // 审计发现问题整改(金额类)
            int val = 0;
            for(int j = 60;j<=65;++j){
                val += ui->tableWidget->item(j,3)->text().toInt();
            }
            ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val)));
        }

        if(i==66){ // 审计发现问题整改(非金额类)
            int val = 0;
            for(int j = 67;j<=70;++j){
                val += ui->tableWidget->item(j,3)->text().toInt();
            }
            ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val)));
        }

        if(i==71){ // 处分
            int val = 0;
            for(int j = 72;j<=74;++j){
                val += ui->tableWidget->item(j,3)->text().toInt();
            }
            ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val)));
        }
    }
}

void ClientMainWindow::on_dateEdit_dateChanged(const QDate &date)
{
    g_auditDate = date.toString("yyyy-MM-dd");
    qDebug()<<g_auditDate;
}

void ClientMainWindow::on_tableWidget_activated(const QModelIndex &index)
{
    qDebug()<<__FUNCTION__<<index;
}

void ClientMainWindow::on_tableWidget_clicked(const QModelIndex &index)
{
    qDebug()<<__FUNCTION__<<index;
}

void ClientMainWindow::on_tableWidget_itemEntered(QTableWidgetItem *item)
{
    qDebug()<<__FUNCTION__<<item;
}

void ClientMainWindow::on_tableWidget_cellEntered(int row, int column)
{
    qDebug()<<__FUNCTION__<<row<<column;
    calc();
}

void ClientMainWindow::on_tableWidget_cellClicked(int row, int column)
{
    qDebug()<<__FUNCTION__<<row<<column;
    calc();
}

void ClientMainWindow::on_pushButton_save_clicked()
{
    // 保存数据，结构比较特殊，需要多行多列同时写入
    // 得考虑分段单表处理方可
    // 获取写到文件里面，每个单位一个文件
}