0305

wumu

2024-03-05 2a6c60a34a892b1a7296535952d86a9d6b195d64

 internal_system_v1/searchinfo.cpp

@@ -140,6 +140,160 @@
    // 单位的所有信息表  创建
    createTableAllComInfo("all_company_info");

    // 整改结果信息表 创建
    createTableRectifyResultInfo("rectify_result_info");

    // 问题清单信息表 创建
    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 (\
            id       INTEGER      PRIMARY KEY AUTOINCREMENT,\
            name     VARCHAR (30),\
            修订制度     TEXT,\
            新增制度     TEXT,\
            挽回损失     TEXT,\
            剔除     TEXT,\
            审减     TEXT,\
            处理人     TEXT,\
            宣贯培训     TEXT,\
            其他     TEXT,\
            审核结果     TEXT,\
            注销     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::createTableProblemListInfo(QString tableName){
    QString sql = QString("CREATE TABLE %1 (\
            id       INTEGER      PRIMARY KEY AUTOINCREMENT,\
            name     VARCHAR (30),\
            序号     TEXT,\
            摘要     TEXT,\
            检查时间     TEXT,\
            检查方式     TEXT,\
            纠正问题     TEXT,\
            完善制度     TEXT,\
            完成时间     TEXT,\
            主要原因     TEXT,\
            完成时限     TEXT,\
            主要原因1     TEXT,\
            责任部门或责任人     TEXT,\
            完成时限1     TEXT,\
            是否销号     TEXT,\
            销号时间     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();
    }

}

@@ -192,9 +346,9 @@
            中级职称人数       INTEGER,\
            初级职称人数       INTEGER,\
            无职称人数       INTEGER,\
            50岁以上人数       INTEGER,\
            30-50岁岁人数       INTEGER,\
            30岁以下人数       INTEGER,\
            五十岁以上人数       INTEGER,\
            三十至五十岁岁人数       INTEGER,\
            三十岁以下人数       INTEGER,\
            审计数量       INTEGER,\
            会计数量       INTEGER,\
            经济数量       INTEGER,\
@@ -206,7 +360,7 @@
            统计负责人       TEXT,\
            填表人       TEXT,\
            联系电话       TEXT,\
            填报日期       TEXT,\
            填报日期       TEXT\
        )").arg(tableName);
    QSqlQuery query;
    if(query.exec(sql))