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();
    }

}