wumu
2024-03-05 2a6c60a34a892b1a7296535952d86a9d6b195d64
0305
4个文件已修改
99 ■■■■■ 已修改文件
internal_system_v1/clientmainwindow.cpp 2 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
internal_system_v1/searchinfo.cpp 95 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
internal_system_v1/searchinfo.h 2 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
审计系统.mmap 补丁 | 查看 | 原始文档 | blame | 历史
internal_system_v1/clientmainwindow.cpp
@@ -343,6 +343,7 @@
                val += ui->tableWidget->item(j,3)->text().toInt();
            }
            ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val)));
            ui->tableWidget->setItem(5,3,new QTableWidgetItem(QString::number(val))); // å†…部审计人员数量
        }
        if(i==11){ // èŒç§°
@@ -351,6 +352,7 @@
                val += ui->tableWidget->item(j,3)->text().toInt();
            }
            ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val)));
        }
        if(i==20){ // çŸ¥è¯†ç»“æž„
internal_system_v1/searchinfo.cpp
@@ -146,8 +146,103 @@
    // é—®é¢˜æ¸…单信息表 åˆ›å»º
    createTableProblemListInfo("problem_list_info");
    // ç»¼åˆå½•入信息表 åˆ›å»º
    createTableComprehensiveEntryInfo("comprehensive_entry_info");
}
// ç»¼åˆå½•入信息表 ä»¥ç¼–码作为指标名
void SearchInfo::createTableComprehensiveEntryInfo(QString tableName){
    QString sql = QString("CREATE TABLE %1 (\
            id       INTEGER      PRIMARY KEY AUTOINCREMENT,\
            name     VARCHAR (30),\
            _030000     TEXT,\
            _030001     TEXT,\
            _030100     TEXT,\
            _030101     TEXT,\
            _030200     TEXT,\
            _030210     TEXT,\
            _030220     TEXT,\
            _030221     TEXT,\
            _030222     TEXT,\
_030222     TEXT,\
_030222     TEXT,\
_030222     TEXT,\
_030222     TEXT,\
_030222     TEXT,\
_030222     TEXT,\
_030222     TEXT,\
_030222     TEXT,\
_030222     TEXT,\
_030222     TEXT,\
_030222     TEXT,\
_030222     TEXT,\
_030222     TEXT,\
_030222     TEXT,\
_030222     TEXT,\
_030222     TEXT,\
_030222     TEXT,\
_030222     TEXT,\
_030222     TEXT,\
_030222     TEXT,\
_030222     TEXT,\
_030222     TEXT,\
_030222     TEXT,\
_030222     TEXT,\
_030222     TEXT,\
_030222     TEXT,\
_030222     TEXT,\
_030222     TEXT,\
_030222     TEXT,\
_030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
                          _030222     TEXT,\
            company_type     TEXT)").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::createTableRectifyResultInfo(QString tableName){
    QString sql = QString("CREATE TABLE %1 (\
internal_system_v1/searchinfo.h
@@ -29,6 +29,8 @@
    void createTableAllComInfo(QString tableName); // å•位信息表全
    void createTableRectifyResultInfo(QString tableName); // æ•´æ”¹ç»“果信息表
    void createTableProblemListInfo(QString tableName);  // é—®é¢˜æ¸…单列表信息表
    void createTableComprehensiveEntryInfo(QString tableName); // ç»¼åˆå½•入信息表
private slots:
    void on_pushButton_search_clicked();
Éó¼ÆÏµÍ³.mmap
Binary files differ