From 2a6c60a34a892b1a7296535952d86a9d6b195d64 Mon Sep 17 00:00:00 2001
From: wumu <mayi@mayi.com>
Date: 星期二, 05 三月 2024 23:40:07 +0800
Subject: [PATCH] 0305
---
internal_system_v1/clientmainwindow.cpp | 2 +
internal_system_v1/searchinfo.cpp | 95 +++++++++++++++++++++++++++++++++++++++++++++++
审计系统.mmap | 0
internal_system_v1/searchinfo.h | 2 +
4 files changed, 99 insertions(+), 0 deletions(-)
diff --git a/internal_system_v1/clientmainwindow.cpp b/internal_system_v1/clientmainwindow.cpp
index 035fff8..c7d2327 100644
--- a/internal_system_v1/clientmainwindow.cpp
+++ b/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){ // 鐭ヨ瘑缁撴瀯
diff --git a/internal_system_v1/searchinfo.cpp b/internal_system_v1/searchinfo.cpp
index 47a40e2..c48fad7 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,\
+_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 (\
diff --git a/internal_system_v1/searchinfo.h b/internal_system_v1/searchinfo.h
index 8833cfd..ba60255 100644
--- a/internal_system_v1/searchinfo.h
+++ b/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();
diff --git "a/\345\256\241\350\256\241\347\263\273\347\273\237.mmap" "b/\345\256\241\350\256\241\347\263\273\347\273\237.mmap"
index e8b8c1d..ddb7942 100644
--- "a/\345\256\241\350\256\241\347\263\273\347\273\237.mmap"
+++ "b/\345\256\241\350\256\241\347\263\273\347\273\237.mmap"
Binary files differ
--
Gitblit v1.8.0