From e55e2ed1ceb92334c4f839642b3e68d8f4dceba6 Mon Sep 17 00:00:00 2001
From: wumu <mayi@mayi.com>
Date: 星期二, 19 九月 2023 00:16:13 +0800
Subject: [PATCH] 0919
---
internal_system_v1/searchinfo.cpp | 17 ++
internal_system_v1/problemnotmoney.cpp | 9 +
internal_system_v1/coverinfo.ui | 16 ++
internal_system_v1/punish.h | 3
internal_system_v1/auditproject.cpp | 9 +
internal_system_v1/clientmainwindow.cpp | 149 ++++++++++++++++++
internal_system_v1/problemcount.h | 3
internal_system_v1/punish.cpp | 9 +
internal_system_v1/problemrectification.cpp | 9 +
internal_system_v1/clientmainwindow.ui | 10 +
internal_system_v1/problemmoney.h | 3
internal_system_v1/auditworkload.h | 6
internal_system_v1/caseclue.cpp | 9 +
internal_system_v1/auditworkload.cpp | 9 +
internal_system_v1/clientmainwindow.h | 14 +
internal_system_v1/coverinfo.cpp | 159 +++++++++++++++++++
internal_system_v1/caseclue.h | 3
internal_system_v1/searchinfo.h | 4
internal_system_v1/coverinfo.h | 4
internal_system_v1/problemrectification.h | 3
internal_system_v1/problemcount.cpp | 9 +
internal_system_v1/problemnotmoney.h | 3
internal_system_v1/problemmoney.cpp | 9 +
internal_system_v1/auditproject.h | 5
internal_system_v1/searchinfo.ui | 6
25 files changed, 475 insertions(+), 5 deletions(-)
diff --git a/internal_system_v1/auditproject.cpp b/internal_system_v1/auditproject.cpp
index 0595766..98faaef 100644
--- a/internal_system_v1/auditproject.cpp
+++ b/internal_system_v1/auditproject.cpp
@@ -65,3 +65,12 @@
qDebug()<<"fail sql"<<__FUNCTION__;
}
}
+
+void AuditProject::showData(QVariantList vlist)
+{
+ for(int i=0;i<vlist.size();++i){
+ if(vlist.at(i).isValid()){
+ ui->tableWidget->setItem(i,2,new QTableWidgetItem(vlist.at(i).toString()));
+ }
+ }
+}
diff --git a/internal_system_v1/auditproject.h b/internal_system_v1/auditproject.h
index 9f0648e..3917704 100644
--- a/internal_system_v1/auditproject.h
+++ b/internal_system_v1/auditproject.h
@@ -2,6 +2,7 @@
#define AUDITPROJECT_H
#include <QMainWindow>
+#include <QVariantList>
namespace Ui {
class AuditProject;
@@ -15,11 +16,13 @@
explicit AuditProject(QWidget *parent = 0);
~AuditProject();
-private slots:
+public slots:
void on_tableWidget_clicked(const QModelIndex &index);
void on_pushButton_clicked();
+ void showData(QVariantList vlist);
+
private:
Ui::AuditProject *ui;
int m_comId;
diff --git a/internal_system_v1/auditworkload.cpp b/internal_system_v1/auditworkload.cpp
index 59efec3..46f7204 100644
--- a/internal_system_v1/auditworkload.cpp
+++ b/internal_system_v1/auditworkload.cpp
@@ -37,3 +37,12 @@
qDebug()<<"fail sql"<<__FUNCTION__;
}
}
+
+void AuditWorkload::showData(QVariantList vlist)
+{
+ for(int i=0;i<vlist.size();++i){
+ if(vlist.at(i).isValid()){
+ ui->tableWidget->setItem(i,2,new QTableWidgetItem(vlist.at(i).toString()));
+ }
+ }
+}
diff --git a/internal_system_v1/auditworkload.h b/internal_system_v1/auditworkload.h
index b9c91d5..f618d4e 100644
--- a/internal_system_v1/auditworkload.h
+++ b/internal_system_v1/auditworkload.h
@@ -2,6 +2,7 @@
#define AUDITWORKLOAD_H
#include <QMainWindow>
+#include <QVariantList>
namespace Ui {
class AuditWorkload;
@@ -15,9 +16,12 @@
explicit AuditWorkload(QWidget *parent = 0);
~AuditWorkload();
-private slots:
+public slots:
void on_pushButton_clicked();
+ void showData(QVariantList vlist);
+
+
private:
Ui::AuditWorkload *ui;
int m_comId;
diff --git a/internal_system_v1/caseclue.cpp b/internal_system_v1/caseclue.cpp
index 762be7e..0c74352 100644
--- a/internal_system_v1/caseclue.cpp
+++ b/internal_system_v1/caseclue.cpp
@@ -38,3 +38,12 @@
qDebug()<<"fail sql"<<__FUNCTION__;
}
}
+
+void CaseClue::showData(QVariantList vlist)
+{
+ for(int i=0;i<vlist.size();++i){
+ if(vlist.at(i).isValid()){
+ ui->tableWidget->setItem(i,3,new QTableWidgetItem(vlist.at(i).toString()));
+ }
+ }
+}
diff --git a/internal_system_v1/caseclue.h b/internal_system_v1/caseclue.h
index 200afdc..e1e27cd 100644
--- a/internal_system_v1/caseclue.h
+++ b/internal_system_v1/caseclue.h
@@ -2,6 +2,7 @@
#define CASECLUE_H
#include <QMainWindow>
+#include <QVariantList>
namespace Ui {
class CaseClue;
@@ -18,6 +19,8 @@
private slots:
void on_pushButton_clicked();
+ void showData(QVariantList vlist);
+
private:
Ui::CaseClue *ui;
int m_comId;
diff --git a/internal_system_v1/clientmainwindow.cpp b/internal_system_v1/clientmainwindow.cpp
index 5a4c0e5..122a61c 100644
--- a/internal_system_v1/clientmainwindow.cpp
+++ b/internal_system_v1/clientmainwindow.cpp
@@ -2,6 +2,11 @@
#include "ui_clientmainwindow.h"
#include <QDebug>
#include <QFileDialog>
+#include <QMessageBox>
+#include <QSqlQuery>
+#include <QSqlRecord>
+
+extern int g_comId;
ClientMainWindow::ClientMainWindow(QWidget *parent) :
QMainWindow(parent),
@@ -54,8 +59,118 @@
// 闅愯棌鎺夋煇涓�夐」
ui->tabWidget->removeTab(3); // OK
+ // 鍏宠仈鍚勪釜鍔熻兘妲�
+ connect(m_coverInfo,SIGNAL(sendComName(QString)),m_searchInfo,SLOT(addComName(QString)));
+
+ connect(this,SIGNAL(sendDataToAuditProject(QVariantList)),m_auditPro,SLOT(showData(QVariantList)));
+ connect(this,SIGNAL(sendDataToAuditWorkLoad(QVariantList)),m_auditworkload,SLOT(showData(QVariantList)));
+ connect(this,SIGNAL(sendDataToProblemMoney(QVariantList)),m_problemMon,SLOT(showData(QVariantList)));
+ connect(this,SIGNAL(sendDataToProblemCount(QVariantList)),m_problemCnt,SLOT(showData(QVariantList)));
+ connect(this,SIGNAL(sendDataToProblemRectification(QVariantList)),m_probleRect,SLOT(showData(QVariantList)));
+ connect(this,SIGNAL(sendDataToProblemNoMoney(QVariantList)),m_problemNotMon,SLOT(showData(QVariantList)));
+ connect(this,SIGNAL(sendDataToPunish(QVariantList)),m_punish,SLOT(showData(QVariantList)));
+ connect(this,SIGNAL(sendDataToCaseClue(QVariantList)),m_caseClue,SLOT(showData(QVariantList)));
+}
+
+void ClientMainWindow::readDataFromExcel(QString path)
+{
+ QAxObject excel("Excel.Application");
+ excel.setProperty("Visible",false);
+ excel.setProperty("DisplayAlerts",false);
+ qDebug()<<"open:"<<path;
+ qDebug()<<"excel:"<<excel.className();
+ QAxObject * wbs = excel.querySubObject("WorkBooks");
+ QAxObject * wb = wbs->querySubObject("Open(QString&)",path);
+ //QAxObject* pWorkBook = excel.querySubObject("ActiveWorkBook");
+ //QAxObject* pWorkSheets = pWorkBook->querySubObject("Sheets");//鑾峰彇宸ヤ綔琛�
+ QAxObject * shs = wb->querySubObject("Sheets"); // WorkSheets 涔熷彲浠�
+ int cnt = shs->property("Count").toInt();
+ qDebug()<<"cnt="<<cnt;
+ for(int i=0;i<cnt;++i){
+ QAxObject * sheet = shs->querySubObject("Item(int)", i+1);
+ QString sheetName = sheet->property("Name").toString();
+ qDebug()<<"sh name:"<<sheetName;
+ QAxObject *usedRange = sheet->querySubObject("UsedRange");
+ int rows = usedRange->querySubObject("Rows")->property("Count").toInt();
+ int columns = usedRange->querySubObject("Columns")->property("Count").toInt();
+ qDebug()<<"r--c:"<<rows<<columns;
+ QVariant val = usedRange->dynamicCall("Value"); // 鎷垮埌浜岀淮琛ㄦ牸
+ QVariantList valRows = val.toList();
+ // 鍏徃鍚嶃�佺粺涓�淇＄敤浠ｇ爜
+ QVariant uniCode = valRows[5].toList().at(1);
+ QVariant comName = valRows[6].toList().at(1);
+ if(comName.isValid()){
+ if(!readDataFromSQL(comName.toString())){
+ QMessageBox::information(this,"瀵煎叆涓柇","璇风‘璁ゅ叕鍙稿熀鏈俊鎭凡缁忓瓨鍦�");
+ return;
+ }
+ qDebug()<<comName<<g_comId;
+ }
+
+ // 瀹¤椤圭洰
+ QVariantList audit_project;
+ for(int i=10;i<20;++i){
+ audit_project.append(valRows[i].toList().at(4));
+ }
+ qDebug()<<audit_project;
+
+ // 瀹¤宸ヤ綔閲�
+ QVariantList audit_workload;
+ for(int i=20;i<21;++i){
+ audit_workload.append(valRows[i].toList().at(4));
+ }
+
+ // 闂閲戦
+ QVariantList problem_money;
+ for(int i=21;i<32;++i){
+ problem_money.append(valRows[i].toList().at(4));
+ }
+
+ // 闂涓暟
+ QVariantList problem_count;
+ for(int i=32;i<39;++i){
+ problem_count.append(valRows[i].toList().at(4));
+ }
+
+ // 闂鏁存敼(閲戦绫�)
+ QVariantList problem_rectification;
+ for(int i=39;i<46;++i){
+ problem_rectification.append(valRows[i].toList().at(4));
+ }
+
+ // 闂鏁存敼(闈為噾棰濈被)
+ QVariantList problem_nomoney;
+ for(int i=46;i<51;++i){
+ problem_nomoney.append(valRows[i].toList().at(4));
+ }
+
+ // 澶勫垎
+ QVariantList punish;
+ for(int i=51;i<55;++i){
+ punish.append(valRows[i].toList().at(4));
+ }
+
+ // 妗堜欢绾跨储
+ QVariantList case_clue;
+ for(int i=55;i<57;++i){
+ case_clue.append(valRows[i].toList().at(4));
+ }
+ qDebug()<<case_clue;
+
+ emit sendDataToAuditProject(audit_project);
+ emit sendDataToAuditWorkLoad(audit_workload);
+ emit sendDataToProblemMoney(problem_money);
+ emit sendDataToProblemCount(problem_count);
+ emit sendDataToProblemRectification(problem_rectification);
+ emit sendDataToProblemNoMoney(problem_nomoney);
+ emit sendDataToPunish(punish);
+ emit sendDataToCaseClue(case_clue);
+
+ }
+ wbs->dynamicCall("Close()");
+ excel.dynamicCall("Quit(void)");
}
void ClientMainWindow::on_pushButton_auditPro_clicked()
@@ -131,3 +246,37 @@
ui->listWidget->addItem(f);
}
}
+
+void ClientMainWindow::on_pushButton_importExcel_clicked()
+{
+ QString path = QFileDialog::getOpenFileName(this,"閫夋嫨琛ㄦ牸:鍗曚綅鍐呴儴瀹¤涓氬姟鎯呭喌琛�","./","excel(*涓氬姟鎯呭喌琛�*.xls)");
+ qDebug()<<"path:"<<path;
+ if(path.size() > 1){
+ readDataFromExcel(path);
+ }
+}
+
+bool ClientMainWindow::readDataFromSQL(QString name)
+{
+ QSqlQuery query;
+ QString sql;
+ if(name.size() > 1){
+ sql = QString("select id,name from company_info where name='%1'").arg(name);
+ 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()){
+ QMessageBox::information(this,"瀵煎叆澶辫触","鍏徃鍚嶄笉瀛樺湪搴撲腑锛岃鍏堝鍏ュ熀鏈俊鎭〃");
+ }else{
+ g_comId = query.value(0).toInt();
+ return true;
+ }
+ }else{
+ qDebug()<<"fail sql"<<__FUNCTION__;
+ }
+ }
+ return false;
+
+}
diff --git a/internal_system_v1/clientmainwindow.h b/internal_system_v1/clientmainwindow.h
index 53aed5b..e553eb7 100644
--- a/internal_system_v1/clientmainwindow.h
+++ b/internal_system_v1/clientmainwindow.h
@@ -28,6 +28,8 @@
~ClientMainWindow();
void initUi();
+ void readDataFromExcel(QString path);
+ bool readDataFromSQL(QString name);
private slots:
void on_pushButton_auditPro_clicked();
@@ -51,6 +53,18 @@
void on_pushButton_openXlsxFile_clicked();
+ void on_pushButton_importExcel_clicked();
+
+signals:
+ void sendDataToAuditProject(QVariantList);
+ void sendDataToAuditWorkLoad(QVariantList);
+ void sendDataToProblemMoney(QVariantList);
+ void sendDataToProblemCount(QVariantList);
+ void sendDataToProblemRectification(QVariantList);
+ void sendDataToProblemNoMoney(QVariantList);
+ void sendDataToPunish(QVariantList);
+ void sendDataToCaseClue(QVariantList);
+
private:
Ui::ClientMainWindow *ui;
AuditProject *m_auditPro;
diff --git a/internal_system_v1/clientmainwindow.ui b/internal_system_v1/clientmainwindow.ui
index 53c5cf8..ac24bd1 100644
--- a/internal_system_v1/clientmainwindow.ui
+++ b/internal_system_v1/clientmainwindow.ui
@@ -35,6 +35,16 @@
<item>
<layout class="QVBoxLayout" name="verticalLayout">
<item>
+ <widget class="QPushButton" name="pushButton_importExcel">
+ <property name="styleSheet">
+ <string notr="true">background-color: rgb(0, 170, 255);</string>
+ </property>
+ <property name="text">
+ <string>瀵煎叆琛ㄦ牸</string>
+ </property>
+ </widget>
+ </item>
+ <item>
<widget class="QPushButton" name="pushButton_auditPro">
<property name="minimumSize">
<size>
diff --git a/internal_system_v1/coverinfo.cpp b/internal_system_v1/coverinfo.cpp
index 90569ed..f211e18 100644
--- a/internal_system_v1/coverinfo.cpp
+++ b/internal_system_v1/coverinfo.cpp
@@ -2,6 +2,7 @@
#include "ui_coverinfo.h"
#include <QDebug>
#include <QDirIterator>
+#include <QFileDialog>
#include <QSqlQuery>
#include <QSqlRecord>
@@ -30,6 +31,17 @@
// ui->label_creditCode->setText(cc);
QString dirPath = "./debug/Data";
+ QString dirPathRelease = "./release/Data";
+ QString dirPathData = "./Data";
+ QDir dir(dirPathData);
+ if(dir.exists()){
+ dirPath = dirPathData; // 瀛樺湪鍒欒鐩�
+ }
+
+ QDir dirRe(dirPathRelease);
+ if(dirRe.exists()){
+ dirPath = dirPathRelease;
+ }
QStringList list;
QDirIterator it(dirPath, {"*.xls","*.xlsx"}, QDir::Files | QDir::NoSymLinks | QDir::NoDotAndDotDot, QDirIterator::Subdirectories);
while(it.hasNext())
@@ -221,11 +233,145 @@
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);
+ bool isInBox = false;
+ for(int i=0;i<ui->comboBox->count();++i){
+ if(ui->comboBox->itemText(i) == name){
+ isInBox = true;
+ break;
+ }
+ }
+ if(!isInBox){
+ m_com[name] = id;
+ ui->comboBox->addItem(name);
+ emit sendComName(name);
+ ui->comboBox->setCurrentText(name);
+ }
}
}
+}
+
+void CoverInfo::readExcelFromPath(QString path)
+{
+ QAxObject excel("Excel.Application");
+ excel.setProperty("Visible",false);
+ excel.setProperty("DisplayAlerts",false);
+ qDebug()<<"open:"<<path;
+ qDebug()<<"excel:"<<excel.className();
+ QAxObject * wbs = excel.querySubObject("WorkBooks");
+ QAxObject * wb = wbs->querySubObject("Open(QString&)",path);
+ //QAxObject* pWorkBook = excel.querySubObject("ActiveWorkBook");
+ //QAxObject* pWorkSheets = pWorkBook->querySubObject("Sheets");//鑾峰彇宸ヤ綔琛�
+ QAxObject * shs = wb->querySubObject("Sheets"); // WorkSheets 涔熷彲浠�
+ int cnt = shs->property("Count").toInt();
+ qDebug()<<"cnt="<<cnt;
+ for(int i=0;i<cnt;++i){
+ QAxObject * sheet = shs->querySubObject("Item(int)", i+1);
+ QString sheetName = sheet->property("Name").toString();
+ qDebug()<<"sh name:"<<sheetName;
+ QAxObject *usedRange = sheet->querySubObject("UsedRange");
+ int rows = usedRange->querySubObject("Rows")->property("Count").toInt();
+ int columns = usedRange->querySubObject("Columns")->property("Count").toInt();
+ qDebug()<<"r--c:"<<rows<<columns;
+ QVariant val = usedRange->dynamicCall("Value"); // 鎷垮埌浜岀淮琛ㄦ牸
+ QVariantList valRows = val.toList();
+ // 缁熶竴淇＄敤浠ｇ爜
+ QVariant uniCode = valRows[9].toList().at(3);
+ if(uniCode.isValid()){
+ ui->label_creditCode->setText(uniCode.toString());
+ }
+ // 鍗曚綅鍚嶇О
+ QVariant name = valRows[9].toList().at(8);
+ if(name.isValid()){
+ ui->label_name->setText(name.toString());
+ }
+ // 鏈烘瀯绫诲瀷
+ QVariant comType = valRows[12].toList().at(3);
+ if(comType.isValid()){
+ ui->label_comType->setText(comType.toString());
+ }
+ // 涓昏涓氬姟娲诲姩
+ QString business;
+ QVariant first = valRows[18].toList().at(2);
+ if(first.isValid()){
+ business.append(first.toString());
+ }
+ QVariant sec = valRows[18].toList().at(5);
+ if(sec.isValid()){
+ business += "銆�";
+ business.append(sec.toString());
+ }
+ QVariant third = valRows[18].toList().at(8);
+ if(third.isValid()){
+ business += "銆�";
+ business.append(third.toString());
+ }
+ if(business.size() > 0){
+ ui->label_business->setText(business);
+ }
+ // 涓氬姟浠ｇ爜
+ QVariant busCode = valRows[19].toList().at(4);
+ if(busCode.isValid()){
+ ui->label_businessCode->setText(busCode.toString());
+ }
+ // 娉ㄥ唽鍦板潃
+ QString addr="";
+ QVariant province = valRows[21].toList().at(1); // 鐪佷唤
+ QVariant city = valRows[21].toList().at(4); // 鍩庡競
+ QVariant district = valRows[21].toList().at(7); // 绠¤緰鍖�
+ QVariant village = valRows[22].toList().at(2); // 涔￠晣
+ QVariant street = valRows[22].toList().at(4); // 琛楅亾
+ QVariant Sub = valRows[23].toList().at(2); // 琛楅亾鍔炰簨澶�
+ QVariant committee = valRows[25].toList().at(3); // 灞呭浼�
+ //qDebug()<<province<<city<<district<<village<<street<<Sub<<committee;
+ if(province.isValid()) addr += province.toString();
+ if(city.isValid()) addr += city.toString();
+ if(district.isValid()) addr += district.toString();
+ if(village.isValid()) addr += village.toString();
+ if(street.isValid()) addr += street.toString();
+ if(Sub.isValid()) addr += Sub.toString();
+ if(committee.isValid()) addr += committee.toString();
+ if(addr.size()>10)ui->label_addr->setText(addr);
+ // 鍖哄煙浠ｇ爜
+ QVariant areaCode = valRows[24].toList().at(2);
+ if(areaCode.isValid()) ui->label_areaCode->setText(areaCode.toString());
+ // 鍩庝埂浠ｇ爜
+ QVariant townCode = valRows[24].toList().at(6);
+ if(townCode.isValid()) ui->label_townCode->setText(townCode.toString());
+ // 鍗曚綅瑙勬ā
+ QVariant scale = valRows[25].toList().at(3);
+ if(scale.isValid()) ui->label_scale->setText(scale.toString());
+ // 浠庝笟浜烘暟
+ QVariant people = valRows[26].toList().at(6);
+ if(people.isValid()) ui->label_people->setText(people.toString());
+ // 娉曚汉
+ QVariant representative = valRows[27].toList().at(4);
+ if(representative.isValid()) ui->label_representative->setText(representative.toString());
+ // 浼氳鏍囧噯绫诲埆 standardType
+ QVariant standardType = valRows[27].toList().at(8);
+ if(standardType.isValid()) ui->label_standardType->setText(standardType.toString());
+ // 闀块�斿尯鍙�
+ QVariant trunkCode = valRows[31].toList().at(2);
+ if(trunkCode.isValid()) ui->label_trunkCode->setText(trunkCode.toString());
+ // 鍥哄畾鐢佃瘽
+ QVariant fixedTel = valRows[32].toList().at(2);
+ if(fixedTel.isValid()) ui->label_fixedTel->setText(fixedTel.toString());
+ // 閭斂缂栫爜
+ QVariant postCode = valRows[33].toList().at(2);
+ if(postCode.isValid()) ui->label_postCode->setText(postCode.toString());
+ // 鐢靛瓙閭
+ QVariant email = valRows[30].toList().at(5);
+ if(email.isValid()) ui->label_email->setText(email.toString());
+ // 缃戝潃
+ QVariant webSite = valRows[32].toList().at(5);
+ if(webSite.isValid()) ui->label_webSite->setText(webSite.toString());
+
+ // 濡傛灉鍗曚綅鏄柊澧炲姞鐨勶紝寰楀啓鍏ュ埌鏁版嵁搴撲腑淇濆瓨璧锋潵
+ readDataFromSQL(); // 鍐嶆璋冪敤API 纭鏁版嵁杩涘埌琛ㄤ腑
+
+ }
+ wbs->dynamicCall("Close()");
+ excel.dynamicCall("Quit(void)");
}
void CoverInfo::on_comboBox_currentIndexChanged(const QString &arg1)
@@ -260,3 +406,12 @@
qDebug()<<"鍒囨崲鏌ヨ澶辫触:"<<arg1;
}
}
+
+void CoverInfo::on_pushButton_importExcel_clicked()
+{
+ QString path = QFileDialog::getOpenFileName(this,"閫夋嫨琛ㄦ牸:鍗曚綅鍙婂唴閮ㄥ璁℃満鏋勫熀鏈儏鍐佃〃","./","excel(*鍩烘湰鎯呭喌琛�*.xls)");
+ qDebug()<<"path:"<<path;
+ if(path.size() > 1){
+ readExcelFromPath(path);
+ }
+}
diff --git a/internal_system_v1/coverinfo.h b/internal_system_v1/coverinfo.h
index a6f5a75..be90e2d 100644
--- a/internal_system_v1/coverinfo.h
+++ b/internal_system_v1/coverinfo.h
@@ -18,9 +18,13 @@
~CoverInfo();
void readInfo();
void readDataFromSQL();
+ void readExcelFromPath(QString path);
private slots:
void on_comboBox_currentIndexChanged(const QString &arg1);
+ void on_pushButton_importExcel_clicked();
+signals:
+ void sendComName(QString); // 鍙戦�佹柊澧炲叕鍙稿悕缁欐悳绱㈢晫闈�
private:
Ui::CoverInfo *ui;
QMap<QString,int> m_com;
diff --git a/internal_system_v1/coverinfo.ui b/internal_system_v1/coverinfo.ui
index 0dd41ca..c532617 100644
--- a/internal_system_v1/coverinfo.ui
+++ b/internal_system_v1/coverinfo.ui
@@ -922,6 +922,22 @@
</property>
</item>
</widget>
+ <widget class="QPushButton" name="pushButton_importExcel">
+ <property name="geometry">
+ <rect>
+ <x>670</x>
+ <y>70</y>
+ <width>291</width>
+ <height>28</height>
+ </rect>
+ </property>
+ <property name="styleSheet">
+ <string notr="true">background-color: rgb(0, 170, 255);</string>
+ </property>
+ <property name="text">
+ <string>鎵嬪姩瀵煎叆</string>
+ </property>
+ </widget>
</widget>
<widget class="QMenuBar" name="menubar">
<property name="geometry">
diff --git a/internal_system_v1/problemcount.cpp b/internal_system_v1/problemcount.cpp
index 6d0edef..ecaae45 100644
--- a/internal_system_v1/problemcount.cpp
+++ b/internal_system_v1/problemcount.cpp
@@ -85,3 +85,12 @@
qDebug()<<"fail sql"<<__FUNCTION__;
}
}
+
+void ProblemCount::showData(QVariantList vlist)
+{
+ for(int i=0;i<vlist.size();++i){
+ if(vlist.at(i).isValid()){
+ ui->tableWidget->setItem(i,2,new QTableWidgetItem(vlist.at(i).toString()));
+ }
+ }
+}
diff --git a/internal_system_v1/problemcount.h b/internal_system_v1/problemcount.h
index 2cf0cd0..3c75f9d 100644
--- a/internal_system_v1/problemcount.h
+++ b/internal_system_v1/problemcount.h
@@ -2,6 +2,7 @@
#define PROBLEMCOUNT_H
#include <QMainWindow>
+#include <QVariantList>
namespace Ui {
class ProblemCount;
@@ -22,6 +23,8 @@
void on_pushButton_clicked();
+ void showData(QVariantList vlist);
+
private:
Ui::ProblemCount *ui;
int m_comId;
diff --git a/internal_system_v1/problemmoney.cpp b/internal_system_v1/problemmoney.cpp
index 0ce6c88..0abd52f 100644
--- a/internal_system_v1/problemmoney.cpp
+++ b/internal_system_v1/problemmoney.cpp
@@ -51,3 +51,12 @@
qDebug()<<"fail sql"<<__FUNCTION__;
}
}
+
+void ProblemMoney::showData(QVariantList vlist)
+{
+ for(int i=0;i<vlist.size();++i){
+ if(vlist.at(i).isValid()){
+ ui->tableWidget->setItem(i,2,new QTableWidgetItem(vlist.at(i).toString()));
+ }
+ }
+}
diff --git a/internal_system_v1/problemmoney.h b/internal_system_v1/problemmoney.h
index 8e8fece..84ccd40 100644
--- a/internal_system_v1/problemmoney.h
+++ b/internal_system_v1/problemmoney.h
@@ -3,6 +3,7 @@
#include <QMainWindow>
#include <QFileDialog>
+#include <QVariantList>
namespace Ui {
class ProblemMoney;
@@ -19,6 +20,8 @@
private slots:
void on_pushButton_clicked();
+ void showData(QVariantList vlist);
+
private:
Ui::ProblemMoney *ui;
int m_comId;
diff --git a/internal_system_v1/problemnotmoney.cpp b/internal_system_v1/problemnotmoney.cpp
index 991a697..cd322ae 100644
--- a/internal_system_v1/problemnotmoney.cpp
+++ b/internal_system_v1/problemnotmoney.cpp
@@ -65,3 +65,12 @@
qDebug()<<"fail sql"<<__FUNCTION__;
}
}
+
+void ProblemNotMoney::showData(QVariantList vlist)
+{
+ for(int i=0;i<vlist.size();++i){
+ if(vlist.at(i).isValid()){
+ ui->tableWidget->setItem(i,2,new QTableWidgetItem(vlist.at(i).toString()));
+ }
+ }
+}
diff --git a/internal_system_v1/problemnotmoney.h b/internal_system_v1/problemnotmoney.h
index a76e4e8..686f58c 100644
--- a/internal_system_v1/problemnotmoney.h
+++ b/internal_system_v1/problemnotmoney.h
@@ -2,6 +2,7 @@
#define PROBLEMNOTMONEY_H
#include <QMainWindow>
+#include <QVariantList>
namespace Ui {
class ProblemNotMoney;
@@ -20,6 +21,8 @@
void on_pushButton_clicked();
+ void showData(QVariantList vlist);
+
private:
Ui::ProblemNotMoney *ui;
int m_comId;
diff --git a/internal_system_v1/problemrectification.cpp b/internal_system_v1/problemrectification.cpp
index 957da44..3f47b83 100644
--- a/internal_system_v1/problemrectification.cpp
+++ b/internal_system_v1/problemrectification.cpp
@@ -65,3 +65,12 @@
qDebug()<<"fail sql"<<__FUNCTION__;
}
}
+
+void ProblemRectification::showData(QVariantList vlist)
+{
+ for(int i=0;i<vlist.size();++i){
+ if(vlist.at(i).isValid()){
+ ui->tableWidget->setItem(i,2,new QTableWidgetItem(vlist.at(i).toString()));
+ }
+ }
+}
diff --git a/internal_system_v1/problemrectification.h b/internal_system_v1/problemrectification.h
index 0828873..b704ed4 100644
--- a/internal_system_v1/problemrectification.h
+++ b/internal_system_v1/problemrectification.h
@@ -2,6 +2,7 @@
#define PROBLEMRECTIFICATION_H
#include <QMainWindow>
+#include <QVariantList>
namespace Ui {
class ProblemRectification;
@@ -20,6 +21,8 @@
void on_pushButton_clicked();
+ void showData(QVariantList vlist);
+
private:
Ui::ProblemRectification *ui;
int m_comId;
diff --git a/internal_system_v1/punish.cpp b/internal_system_v1/punish.cpp
index e634983..67a16a0 100644
--- a/internal_system_v1/punish.cpp
+++ b/internal_system_v1/punish.cpp
@@ -50,3 +50,12 @@
qDebug()<<"fail sql"<<__FUNCTION__;
}
}
+
+void Punish::showData(QVariantList vlist)
+{
+ for(int i=0;i<vlist.size();++i){
+ if(vlist.at(i).isValid()){
+ ui->tableWidget->setItem(i,2,new QTableWidgetItem(vlist.at(i).toString()));
+ }
+ }
+}
diff --git a/internal_system_v1/punish.h b/internal_system_v1/punish.h
index b431ce3..30998b6 100644
--- a/internal_system_v1/punish.h
+++ b/internal_system_v1/punish.h
@@ -2,6 +2,7 @@
#define PUNISH_H
#include <QMainWindow>
+#include <QVariantList>
namespace Ui {
class Punish;
@@ -20,6 +21,8 @@
void on_pushButton_clicked();
+ void showData(QVariantList vlist);
+
private:
Ui::Punish *ui;
int m_comId;
diff --git a/internal_system_v1/searchinfo.cpp b/internal_system_v1/searchinfo.cpp
index 4d2c9d9..b0aa27e 100644
--- a/internal_system_v1/searchinfo.cpp
+++ b/internal_system_v1/searchinfo.cpp
@@ -403,7 +403,7 @@
}
//wb->dynamicCall("Save()"); // 鑻ユ枃浠跺凡瀛樺湪锛屽垯鐩存帴淇濆瓨
//wb->dynamicCall("SaveAs(const QString&)", str); // 淇濆瓨宸ヤ綔绨匡紝鑻ユ枃浠朵笉瀛樺湪锛屽垯甯﹀悕瀛椾繚瀛�
- if(ui->lineEdit_excel_save->text() > 1){
+ if(ui->lineEdit_excel_save->text().size() > 1){
wb->dynamicCall("SaveAs(const QString&)", ui->lineEdit_excel_save->text()); // 淇濆瓨宸ヤ綔绨匡紝鑻ユ枃浠朵笉瀛樺湪锛屽垯甯﹀悕瀛椾繚瀛�
qDebug()<<"淇濆瓨鍒版柊鏂囦欢涓�";
}else{
@@ -421,6 +421,7 @@
void SearchInfo::on_comboBox_currentIndexChanged(const QString &arg1)
{
m_model->setHorizontalHeaderLabels(m_labels[arg1]);
+
}
void SearchInfo::on_toolButton_seleceExcel_clicked()
@@ -435,3 +436,17 @@
QString newPath = paths.at(0)+"_"+ui->comboBox_company->currentText()+"."+paths.at(1);
ui->lineEdit_excel_save->setText(newPath);
}
+
+void SearchInfo::on_comboBox_company_currentIndexChanged(const QString &arg1)
+{
+ if(ui->lineEdit_excel_save->text().size() > 5){
+ QStringList paths = ui->label_excel_path->text().split(".");
+ QString newPath = paths.at(0)+"_"+arg1+"."+paths.at(1);
+ ui->lineEdit_excel_save->setText(newPath);
+ }
+}
+
+void SearchInfo::addComName(QString name)
+{
+ ui->comboBox_company->addItem(name);
+}
diff --git a/internal_system_v1/searchinfo.h b/internal_system_v1/searchinfo.h
index c3e6872..6513d12 100644
--- a/internal_system_v1/searchinfo.h
+++ b/internal_system_v1/searchinfo.h
@@ -35,6 +35,10 @@
void on_toolButton_seleceExcel_clicked();
+ void on_comboBox_company_currentIndexChanged(const QString &arg1);
+
+ void addComName(QString name);
+
private:
Ui::SearchInfo *ui;
QSqlDatabase m_db;
diff --git a/internal_system_v1/searchinfo.ui b/internal_system_v1/searchinfo.ui
index 69daa75..b854ea5 100644
--- a/internal_system_v1/searchinfo.ui
+++ b/internal_system_v1/searchinfo.ui
@@ -103,6 +103,9 @@
</item>
<item>
<widget class="QPushButton" name="pushButton_export">
+ <property name="styleSheet">
+ <string notr="true">background-color: rgb(170, 255, 127);</string>
+ </property>
<property name="text">
<string>瀵煎嚭琛ㄦ牸</string>
</property>
@@ -141,6 +144,9 @@
<layout class="QHBoxLayout" name="horizontalLayout_2">
<item>
<widget class="QToolButton" name="toolButton_seleceExcel">
+ <property name="styleSheet">
+ <string notr="true">background-color: rgb(170, 255, 127);</string>
+ </property>
<property name="text">
<string>閫夋嫨琛ㄦ牸妯℃澘</string>
</property>
--
Gitblit v1.8.0