From f5f3281221c5a8cbeb2e615abb356557f2701e9d Mon Sep 17 00:00:00 2001
From: wumu <mayi@mayi.com>
Date: 星期四, 14 三月 2024 00:01:58 +0800
Subject: [PATCH] 0314
---
internal_system_v1/searchinfo.cpp | 95 +++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 95 insertions(+), 0 deletions(-)
diff --git a/internal_system_v1/searchinfo.cpp b/internal_system_v1/searchinfo.cpp
index 47a40e2..d476404 100644
--- a/internal_system_v1/searchinfo.cpp
+++ b/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,\
+ _030223 TEXT,\
+ _030230 TEXT,\
+ _030231 TEXT,\
+ _030232 TEXT,\
+ _030233 TEXT,\
+ _030234 TEXT,\
+ _030240 TEXT,\
+ _030241 TEXT,\
+ _030242 TEXT,\
+ _030243 TEXT,\
+ _030250 TEXT,\
+ _030251 TEXT,\
+ _030252 TEXT,\
+ _030253 TEXT,\
+ _030254 TEXT,\
+ _030255 TEXT,\
+ _030256 TEXT,\
+ _030257 TEXT,\
+ _030258 TEXT,\
+ _030260 TEXT,\
+ _030300 TEXT,\
+ _030301 TEXT,\
+ _030302 TEXT,\
+ _030303 TEXT,\
+ _030304 TEXT,\
+ _030305 TEXT,\
+ _030306 TEXT,\
+ _030307 TEXT,\
+ _030308 TEXT,\
+ _030310 TEXT,\
+ _030400 TEXT,\
+ _030500 TEXT,\
+ _030510 TEXT,\
+ _030520 TEXT,\
+ _030521 TEXT,\
+ _030522 TEXT,\
+ _030523 TEXT,\
+ _030524 TEXT,\
+ _030525 TEXT,\
+ _030526 TEXT,\
+ _030527 TEXT,\
+ _030528 TEXT,\
+ _030600 TEXT,\
+ _030610 TEXT,\
+ _030620 TEXT,\
+ _030621 TEXT,\
+ _030622 TEXT,\
+ _030623 TEXT,\
+ _030624 TEXT,\
+ _030700 TEXT,\
+ _030701 TEXT,\
+ _030702 TEXT,\
+ _030703 TEXT,\
+ _030704 TEXT,\
+ _030705 TEXT,\
+ _030706 TEXT,\
+ _030800 TEXT,\
+ _030801 TEXT,\
+ _030802 TEXT,\
+ _030803 TEXT,\
+ _030804 TEXT,\
+ _030900 TEXT,\
+ _030901 TEXT,\
+ _030902 TEXT,\
+ _030903 TEXT,\
+ _031000 TEXT,\
+ _031001 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 (\
--
Gitblit v1.8.0