0305

wumu

2024-03-05 2a6c60a34a892b1a7296535952d86a9d6b195d64

 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 (\