From 01879e2d0f951ff37ba56df695668d16548070a7 Mon Sep 17 00:00:00 2001 From: wumu <mayi@mayi.com> Date: 星期五, 19 一月 2024 22:44:43 +0800 Subject: [PATCH] 0119 --- internal_system_v1/auditworkload.cpp | 19 +++++++++++++++---- 1 files changed, 15 insertions(+), 4 deletions(-) diff --git a/internal_system_v1/auditworkload.cpp b/internal_system_v1/auditworkload.cpp index 59efec3..8264d0d 100644 --- a/internal_system_v1/auditworkload.cpp +++ b/internal_system_v1/auditworkload.cpp @@ -4,7 +4,7 @@ #include <QSqlQuery> extern int g_comId; - +extern QString g_auditDate; AuditWorkload::AuditWorkload(QWidget *parent) : QMainWindow(parent), ui(new Ui::AuditWorkload) @@ -23,12 +23,12 @@ { QString values = ""; for(int i=0;i<ui->tableWidget->rowCount();++i){ - values += QString("('%1','%2',%3,%4),").arg(ui->tableWidget->item(i,0)->text()) + 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(g_comId); + .arg(g_comId).arg(g_auditDate); } values = values.left(values.length()-1); - QString sql = QString("insert into audit_workload (kpi_name,code,num,com_id) values %1").arg(values); + QString sql = QString("insert into audit_workload (kpi_name,code,num,com_id,time) values %1").arg(values); qDebug()<<sql; QSqlQuery query; if(query.exec(sql)){ @@ -36,4 +36,15 @@ }else{ qDebug()<<"fail sql"<<__FUNCTION__; } + static int cnt=1; + ui->pushButton->setText(QString("鎻愪氦--鍐呭宸ヤ綔閲廮%1娆�").arg(cnt++)); +} + +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())); + } + } } -- Gitblit v1.8.0