From 10457ff67b999e9cc99624801c635e7f25e0d5ef Mon Sep 17 00:00:00 2001
From: wumu <mayi@mayi.com>
Date: 星期四, 31 八月 2023 23:36:05 +0800
Subject: [PATCH] 0831

---
 internal_system_v1/searchinfo.cpp           |   21 +++++
 internal_system_v1/auditworkload.cpp        |    6 +
 internal_system_v1/problemnotmoney.cpp      |    6 +
 internal_system_v1/coverinfo.cpp            |   90 +++++++++++++++++++++
 internal_system_v1/coverinfo.h              |    5 +
 internal_system_v1/auditproject.cpp         |    5 
 internal_system_v1/clientmainwindow.cpp     |   16 +++-
 internal_system_v1/punish.cpp               |    6 +
 internal_system_v1/problemrectification.cpp |    6 +
 internal_system_v1/problemcount.cpp         |    6 +
 internal_system_v1/problemmoney.cpp         |    6 +
 internal_system_v1/caseclue.cpp             |    6 +
 internal_system_v1/searchinfo.ui            |   16 ++++
 13 files changed, 171 insertions(+), 24 deletions(-)

diff --git a/internal_system_v1/auditproject.cpp b/internal_system_v1/auditproject.cpp
index 9dbb73e..0595766 100644
--- a/internal_system_v1/auditproject.cpp
+++ b/internal_system_v1/auditproject.cpp
@@ -3,6 +3,7 @@
 #include <QDebug>
 #include <QSqlQuery>
 
+extern int g_comId;
 AuditProject::AuditProject(QWidget *parent) :
     QMainWindow(parent),
     ui(new Ui::AuditProject)
@@ -16,7 +17,7 @@
         }
     }
     ui->tableWidget->setColumnWidth(0,300);
-    m_comId = 1; // 鍗曚綅id
+    m_comId = g_comId; // 鍗曚綅id
 
 }
 
@@ -50,7 +51,7 @@
     for(int i=0;i<ui->tableWidget->rowCount();++i){
         values += QString("('%1','%2',%3,%4),").arg(ui->tableWidget->item(i,0)->text())
                 .arg(ui->tableWidget->item(i,1)->text()).arg(ui->tableWidget->item(i,2)->text().toInt())
-                .arg(m_comId);
+                .arg(g_comId);
     }
     //qDebug()<<values;
     values = values.left(values.length()-1);
diff --git a/internal_system_v1/auditworkload.cpp b/internal_system_v1/auditworkload.cpp
index c3b82e6..59efec3 100644
--- a/internal_system_v1/auditworkload.cpp
+++ b/internal_system_v1/auditworkload.cpp
@@ -3,13 +3,15 @@
 #include <QDebug>
 #include <QSqlQuery>
 
+extern int g_comId;
+
 AuditWorkload::AuditWorkload(QWidget *parent) :
     QMainWindow(parent),
     ui(new Ui::AuditWorkload)
 {
     ui->setupUi(this);
     ui->tableWidget->setColumnWidth(0,260);
-    m_comId = 1;
+    m_comId = g_comId;
 }
 
 AuditWorkload::~AuditWorkload()
@@ -23,7 +25,7 @@
     for(int i=0;i<ui->tableWidget->rowCount();++i){
         values += QString("('%1','%2',%3,%4),").arg(ui->tableWidget->item(i,0)->text())
                 .arg(ui->tableWidget->item(i,1)->text()).arg(ui->tableWidget->item(i,2)->text().toInt())
-                .arg(m_comId);
+                .arg(g_comId);
     }
     values = values.left(values.length()-1);
     QString sql = QString("insert into audit_workload (kpi_name,code,num,com_id) values %1").arg(values);
diff --git a/internal_system_v1/caseclue.cpp b/internal_system_v1/caseclue.cpp
index 120a3b4..762be7e 100644
--- a/internal_system_v1/caseclue.cpp
+++ b/internal_system_v1/caseclue.cpp
@@ -3,13 +3,15 @@
 #include <QDebug>
 #include <QSqlQuery>
 
+extern int g_comId;
+
 CaseClue::CaseClue(QWidget *parent) :
     QMainWindow(parent),
     ui(new Ui::CaseClue)
 {
     ui->setupUi(this);
     ui->tableWidget->setColumnWidth(0,300);
-    m_comId = 1;
+    m_comId = g_comId;
 }
 
 CaseClue::~CaseClue()
@@ -24,7 +26,7 @@
         values += QString("('%1','%2','%3',%4,%5),").arg(ui->tableWidget->item(i,0)->text())
                 .arg(ui->tableWidget->item(i,1)->text()).arg(ui->tableWidget->item(i,2)->text())
                 .arg(ui->tableWidget->item(i,3)->text().toInt())
-                .arg(m_comId);
+                .arg(g_comId);
     }
     values = values.left(values.length()-1);
     QString sql = QString("insert into case_clue (kpi_name,code,unit,num,com_id) values %1").arg(values);
diff --git a/internal_system_v1/clientmainwindow.cpp b/internal_system_v1/clientmainwindow.cpp
index b868dd9..1d290f3 100644
--- a/internal_system_v1/clientmainwindow.cpp
+++ b/internal_system_v1/clientmainwindow.cpp
@@ -19,6 +19,12 @@
 
 void ClientMainWindow::initUi()
 {
+    m_searchInfo = new SearchInfo(this);
+    ui->tabWidget->addTab(m_searchInfo,"淇℃伅鏌ヨ");
+
+    m_coverInfo = new CoverInfo(this);
+    m_coverInfo->setParent(ui->tab);
+
     m_auditPro = new AuditProject(this);
     m_auditworkload = new AuditWorkload(this);
     m_problemMon = new ProblemMoney(this);
@@ -39,11 +45,13 @@
 
     ui->stackedWidget->setCurrentIndex(0);
 
-    m_coverInfo = new CoverInfo(this);
-    m_coverInfo->setParent(ui->tab);
+//    m_searchInfo = new SearchInfo(this);
+//    ui->tabWidget->addTab(m_searchInfo,"淇℃伅鏌ヨ");
 
-    m_searchInfo = new SearchInfo(this);
-    ui->tabWidget->addTab(m_searchInfo,"淇℃伅鏌ヨ");
+//    m_coverInfo = new CoverInfo(this);
+//    m_coverInfo->setParent(ui->tab);
+
+
 }
 
 void ClientMainWindow::on_pushButton_auditPro_clicked()
diff --git a/internal_system_v1/coverinfo.cpp b/internal_system_v1/coverinfo.cpp
index d8722ea..90569ed 100644
--- a/internal_system_v1/coverinfo.cpp
+++ b/internal_system_v1/coverinfo.cpp
@@ -2,6 +2,10 @@
 #include "ui_coverinfo.h"
 #include <QDebug>
 #include <QDirIterator>
+#include <QSqlQuery>
+#include <QSqlRecord>
+
+int g_comId = 0; // 鍏ㄥ眬鍙橀噺锛屼繚瀛樺崟浣峣d
 
 CoverInfo::CoverInfo(QWidget *parent) :
     QMainWindow(parent),
@@ -9,6 +13,8 @@
 {
     ui->setupUi(this);
     readInfo();
+    readDataFromSQL(); // 浠庢暟鎹簱璇诲彇鏁版嵁
+
 }
 
 CoverInfo::~CoverInfo()
@@ -161,9 +167,6 @@
                 // 缃戝潃
                 QVariant webSite = valRows[32].toList().at(5);
                 if(webSite.isValid()) ui->label_webSite->setText(webSite.toString());
-
-
-
             }
             wbs->dynamicCall("Close()");
             excel.dynamicCall("Quit(void)");
@@ -176,3 +179,84 @@
 //    excel.setProperty("DisplayAlerts",false);
 
 }
+
+void CoverInfo::readDataFromSQL()
+{
+    QSqlQuery query;
+    QString sql;
+    if(ui->label_name->text().size() > 1){
+        sql = QString("select id,name from company_info where name='%1'").arg(ui->label_name->text());
+        qDebug()<<"鏌ヨ鍏徃sql:"<<sql;
+        if(query.exec(sql)){
+            qDebug()<<"OK sql"<<__FUNCTION__;
+            QSqlRecord res = query.record();
+            qDebug()<<query.size()<<query.numRowsAffected()<<res.count();
+            if(!query.next()){
+                // 鎻掑叆涓�鏉″崟浣嶄俊鎭細
+                sql = QString("insert into company_info (name,code,鏈烘瀯绫诲瀷,涓昏涓氬姟娲诲姩,琛屼笟浠ｇ爜,鍗曚綅娉ㄥ唽鍦板強鍖哄煙,"
+                              "鍖哄煙浠ｇ爜,鍩庝埂浠ｇ爜,鍗曚綅瑙勬ā,浠庝笟鏈熸湯浜烘暟,娉曞畾浠ｈ〃浜�,鎵ц浼氳鏍囧噯绫诲埆,闀块�斿尯鍙�,鍥哄畾鐢佃瘽,閭斂缂栫爜,"
+                              "鐢靛瓙閭,缃戝潃) values ('%1','%2','%3','%4','%5','%6','%7','%8','%9','%10','%11','%12','%13','%14','%15','%16','%17')").arg(ui->label_name->text())
+                        .arg(ui->label_creditCode->text()).arg(ui->label_comType->text()).arg(ui->label_business->text()).arg(ui->label_businessCode->text()).arg(ui->label_addr->text())
+                        .arg(ui->label_areaCode->text()).arg(ui->label_townCode->text()).arg(ui->label_scale->text()).arg(ui->label_people->text()).arg(ui->label_representative->text())
+                        .arg(ui->label_standardType->text()).arg(ui->label_trunkCode->text()).arg(ui->label_fixedTel->text()).arg(ui->label_postCode->text()).arg(ui->label_email->text())
+                        .arg(ui->label_webSite->text());
+                qDebug()<<"com_insert sql:"<<sql;
+                if(query.exec(sql)){
+                    qDebug()<<"insert com ok";
+                }else{
+                    qDebug()<<"insert com fail";
+                }
+
+            }else{
+                g_comId = query.value(0).toInt();
+            }
+        }else{
+            qDebug()<<"fail sql"<<__FUNCTION__;
+        }
+    }
+    sql = QString("select id,name from company_info");
+    if(query.exec(sql)){
+        qDebug()<<"size:"<<query.size();
+        while(query.next()){
+            int id = query.value(0).toInt();
+            QString name = query.value(1).toString();
+            qDebug()<<"com select:"<<id<<name;
+            m_com[name] = id;
+            ui->comboBox->addItem(name);
+        }
+    }
+
+}
+
+void CoverInfo::on_comboBox_currentIndexChanged(const QString &arg1)
+{
+    QString sql = QString("select * from company_info where name='%1'").arg(arg1);
+    QSqlQuery query;
+    if(query.exec(sql)){
+        qDebug()<<"鍒囨崲鏌ヨ鎴愬姛:"<<arg1;
+        while (query.next()) {
+            qDebug()<<"鍒囨崲鏌ヨ鎴愬姛鏌ヨ鍒扮洰鏍囧崟浣�:"<<arg1;
+            g_comId = query.value(0).toInt();
+            ui->label_name->setText(query.value(1).toString());
+            ui->label_creditCode->setText(query.value(2).toString());
+            ui->label_comType->setText(query.value(3).toString());
+            ui->label_business->setText(query.value(4).toString());
+            ui->label_businessCode->setText(query.value(5).toString());
+            ui->label_addr->setText(query.value(6).toString());
+            ui->label_areaCode->setText(query.value(7).toString());
+            ui->label_townCode->setText(query.value(8).toString());
+            ui->label_scale->setText(query.value(9).toString());
+            ui->label_people->setText(query.value(10).toString());
+            ui->label_representative->setText(query.value(11).toString());
+            ui->label_standardType->setText(query.value(12).toString());
+            ui->label_trunkCode->setText(query.value(13).toString());
+            ui->label_fixedTel->setText(query.value(14).toString());
+            ui->label_postCode->setText(query.value(15).toString());
+            ui->label_email->setText(query.value(16).toString());
+            ui->label_webSite->setText(query.value(17).toString());
+            break;
+        }
+    }else{
+        qDebug()<<"鍒囨崲鏌ヨ澶辫触:"<<arg1;
+    }
+}
diff --git a/internal_system_v1/coverinfo.h b/internal_system_v1/coverinfo.h
index 214fcb4..a6f5a75 100644
--- a/internal_system_v1/coverinfo.h
+++ b/internal_system_v1/coverinfo.h
@@ -17,8 +17,13 @@
     explicit CoverInfo(QWidget *parent = 0);
     ~CoverInfo();
     void readInfo();
+    void readDataFromSQL();
+private slots:
+    void on_comboBox_currentIndexChanged(const QString &arg1);
+
 private:
     Ui::CoverInfo *ui;
+    QMap<QString,int> m_com;
 };
 
 #endif // COVERINFO_H
diff --git a/internal_system_v1/problemcount.cpp b/internal_system_v1/problemcount.cpp
index d2caeda..6d0edef 100644
--- a/internal_system_v1/problemcount.cpp
+++ b/internal_system_v1/problemcount.cpp
@@ -5,13 +5,15 @@
 #include <QPushButton>
 #include <QSqlQuery>
 
+extern int g_comId;
+
 ProblemCount::ProblemCount(QWidget *parent) :
     QMainWindow(parent),
     ui(new Ui::ProblemCount)
 {
     ui->setupUi(this);
     ui->tableWidget->setColumnWidth(0,300);
-    m_comId = 1;
+    m_comId = g_comId;
     for(int i=0;i<ui->tableWidget->rowCount();++i){
         QPushButton *btn = new QPushButton("涓婁紶",this);
         ui->tableWidget->setCellWidget(i,3,btn);
@@ -71,7 +73,7 @@
         values += QString("('%1','%2',%3,'%4',%5),").arg(ui->tableWidget->item(i,0)->text())
                 .arg(ui->tableWidget->item(i,1)->text()).arg(ui->tableWidget->item(i,2)->text().toInt())
                 .arg(ui->tableWidget->item(i,4)->text())
-                .arg(m_comId);
+                .arg(g_comId);
     }
     values = values.left(values.length()-1);
     QString sql = QString("insert into problem_count (kpi_name,code,num,evidences,com_id) values %1").arg(values);
diff --git a/internal_system_v1/problemmoney.cpp b/internal_system_v1/problemmoney.cpp
index 7f5fce5..0ce6c88 100644
--- a/internal_system_v1/problemmoney.cpp
+++ b/internal_system_v1/problemmoney.cpp
@@ -4,13 +4,15 @@
 #include <QDebug>
 #include <QSqlQuery>
 
+extern int g_comId;
+
 ProblemMoney::ProblemMoney(QWidget *parent) :
     QMainWindow(parent),
     ui(new Ui::ProblemMoney)
 {
     ui->setupUi(this);
     ui->tableWidget->setColumnWidth(0,300);
-    m_comId = 1;
+    m_comId = g_comId;
     for(int i=0;i<ui->tableWidget->rowCount();++i){
         QPushButton *btn = new QPushButton("涓婁紶",this);
         ui->tableWidget->setCellWidget(i,3,btn);
@@ -37,7 +39,7 @@
         values += QString("('%1','%2',%3,'%4',%5),").arg(ui->tableWidget->item(i,0)->text())
                 .arg(ui->tableWidget->item(i,1)->text()).arg(ui->tableWidget->item(i,2)->text().toInt())
                 .arg(ui->tableWidget->item(i,4)->text())
-                .arg(m_comId);
+                .arg(g_comId);
     }
     values = values.left(values.length()-1);
     QString sql = QString("insert into problem_money (kpi_name,code,num,evidences,com_id) values %1").arg(values);
diff --git a/internal_system_v1/problemnotmoney.cpp b/internal_system_v1/problemnotmoney.cpp
index e5072a1..991a697 100644
--- a/internal_system_v1/problemnotmoney.cpp
+++ b/internal_system_v1/problemnotmoney.cpp
@@ -6,13 +6,15 @@
 #include <QSqlQuery>
 #include <QDebug>
 
+extern int g_comId;
+
 ProblemNotMoney::ProblemNotMoney(QWidget *parent) :
     QMainWindow(parent),
     ui(new Ui::ProblemNotMoney)
 {
     ui->setupUi(this);
     ui->tableWidget->setColumnWidth(0,300);
-    m_comId = 1;
+    m_comId = g_comId;
     for(int i=0;i<ui->tableWidget->rowCount();++i){
         QPushButton *btn = new QPushButton("涓婁紶",this);
         ui->tableWidget->setCellWidget(i,3,btn);
@@ -51,7 +53,7 @@
         values += QString("('%1','%2',%3,'%4',%5),").arg(ui->tableWidget->item(i,0)->text())
                 .arg(ui->tableWidget->item(i,1)->text()).arg(ui->tableWidget->item(i,2)->text().toInt())
                 .arg(ui->tableWidget->item(i,4)->text())
-                .arg(m_comId);
+                .arg(g_comId);
     }
     values = values.left(values.length()-1);
     QString sql = QString("insert into problem_no_money (kpi_name,code,num,evidences,com_id) values %1").arg(values);
diff --git a/internal_system_v1/problemrectification.cpp b/internal_system_v1/problemrectification.cpp
index 8452de3..957da44 100644
--- a/internal_system_v1/problemrectification.cpp
+++ b/internal_system_v1/problemrectification.cpp
@@ -6,13 +6,15 @@
 #include <QSqlQuery>
 #include <QDebug>
 
+extern int g_comId;
+
 ProblemRectification::ProblemRectification(QWidget *parent) :
     QMainWindow(parent),
     ui(new Ui::ProblemRectification)
 {
     ui->setupUi(this);
     ui->tableWidget->setColumnWidth(0,300);
-    m_comId = 1;
+    m_comId = g_comId;
     for(int i=0;i<ui->tableWidget->rowCount();++i){
         QPushButton *btn = new QPushButton("涓婁紶",this);
         ui->tableWidget->setCellWidget(i,3,btn);
@@ -51,7 +53,7 @@
         values += QString("('%1','%2',%3,'%4',%5),").arg(ui->tableWidget->item(i,0)->text())
                 .arg(ui->tableWidget->item(i,1)->text()).arg(ui->tableWidget->item(i,2)->text().toInt())
                 .arg(ui->tableWidget->item(i,4)->text())
-                .arg(m_comId);
+                .arg(g_comId);
     }
     values = values.left(values.length()-1);
     QString sql = QString("insert into problem_rectification (kpi_name,code,num,evidences,com_id) values %1").arg(values);
diff --git a/internal_system_v1/punish.cpp b/internal_system_v1/punish.cpp
index 225bdb0..e634983 100644
--- a/internal_system_v1/punish.cpp
+++ b/internal_system_v1/punish.cpp
@@ -4,13 +4,15 @@
 #include <QSqlQuery>
 #include <QDebug>
 
+extern int g_comId;
+
 Punish::Punish(QWidget *parent) :
     QMainWindow(parent),
     ui(new Ui::Punish)
 {
     ui->setupUi(this);
     ui->tableWidget->setColumnWidth(0,320);
-    m_comId = 1;
+    m_comId = g_comId;
 }
 
 Punish::~Punish()
@@ -36,7 +38,7 @@
     for(int i=0;i<ui->tableWidget->rowCount();++i){
         values += QString("('%1','%2',%3,%4),").arg(ui->tableWidget->item(i,0)->text())
                 .arg(ui->tableWidget->item(i,1)->text()).arg(ui->tableWidget->item(i,2)->text().toInt())
-                .arg(m_comId);
+                .arg(g_comId);
     }
     values = values.left(values.length()-1);
     QString sql = QString("insert into punish (kpi_name,code,num,com_id) values %1").arg(values);
diff --git a/internal_system_v1/searchinfo.cpp b/internal_system_v1/searchinfo.cpp
index 8b6ab54..4b6e206 100644
--- a/internal_system_v1/searchinfo.cpp
+++ b/internal_system_v1/searchinfo.cpp
@@ -57,7 +57,26 @@
         qDebug()<<"create file_up_info fail..."<<query.lastError().text();
     }
 
-    sql = "create table company_info (id INTEGER PRIMARY key AUTOINCREMENT, name varchar(30), code varchar(30))";
+    sql = "CREATE TABLE company_info (\
+            id       INTEGER      PRIMARY KEY AUTOINCREMENT,\
+            name     VARCHAR (30),\
+            code     VARCHAR (30),\
+            鏈烘瀯绫诲瀷     TEXT,\
+            涓昏涓氬姟娲诲姩   TEXT,\
+            琛屼笟浠ｇ爜     TEXT,\
+            鍗曚綅娉ㄥ唽鍦板強鍖哄煙 TEXT,\
+            鍖哄煙浠ｇ爜     TEXT,\
+            鍩庝埂浠ｇ爜     TEXT,\
+            鍗曚綅瑙勬ā     TEXT,\
+            浠庝笟鏈熸湯浜烘暟   TEXT,\
+            娉曞畾浠ｈ〃浜�    TEXT,\
+            鎵ц浼氳鏍囧噯绫诲埆 TEXT,\
+            闀块�斿尯鍙�     TEXT,\
+            鍥哄畾鐢佃瘽     TEXT,\
+            閭斂缂栫爜     TEXT,\
+            鐢靛瓙閭     TEXT,\
+            缃戝潃       TEXT\
+        )";
     if(query.exec(sql))
     {
         qDebug()<<"create company_info ok...";
diff --git a/internal_system_v1/searchinfo.ui b/internal_system_v1/searchinfo.ui
index e09b2a3..2b8ed2b 100644
--- a/internal_system_v1/searchinfo.ui
+++ b/internal_system_v1/searchinfo.ui
@@ -147,6 +147,22 @@
         </spacer>
        </item>
        <item>
+        <widget class="QLabel" name="label_4">
+         <property name="text">
+          <string>鍗曚綅鍚嶇О:</string>
+         </property>
+        </widget>
+       </item>
+       <item>
+        <widget class="QComboBox" name="comboBox_2">
+         <item>
+          <property name="text">
+           <string>鍏徃鍚嶇О</string>
+          </property>
+         </item>
+        </widget>
+       </item>
+       <item>
         <widget class="QPushButton" name="pushButton">
          <property name="text">
           <string>鏌ヨ</string>

--
Gitblit v1.8.0