From e77bddbba9af4535e0c51058c1708987a5512f0c Mon Sep 17 00:00:00 2001 From: wumu <mayi@mayi.com> Date: 星期二, 19 九月 2023 23:21:11 +0800 Subject: [PATCH] 0919-2 --- internal_system_v1/problemmoney.cpp | 48 ++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 48 insertions(+), 0 deletions(-) diff --git a/internal_system_v1/problemmoney.cpp b/internal_system_v1/problemmoney.cpp index 06a7d6a..b55a4fb 100644 --- a/internal_system_v1/problemmoney.cpp +++ b/internal_system_v1/problemmoney.cpp @@ -1,5 +1,11 @@ #include "problemmoney.h" #include "ui_problemmoney.h" +#include <QPushButton> +#include <QDebug> +#include <QSqlQuery> + +extern int g_comId; +extern QString g_auditDate; ProblemMoney::ProblemMoney(QWidget *parent) : QMainWindow(parent), @@ -7,9 +13,51 @@ { ui->setupUi(this); ui->tableWidget->setColumnWidth(0,300); + m_comId = g_comId; + for(int i=0;i<ui->tableWidget->rowCount();++i){ + QPushButton *btn = new QPushButton("涓婁紶",this); + ui->tableWidget->setCellWidget(i,3,btn); + connect(btn,&QPushButton::clicked,this,[=]{ + QStringList files = QFileDialog::getOpenFileNames(); + QString str; + for(auto f:files){ + str += f + " "; + } + ui->tableWidget->setItem(i,4,new QTableWidgetItem(str)); + }); + } } ProblemMoney::~ProblemMoney() { delete ui; } + +void ProblemMoney::on_pushButton_clicked() +{ + QString values = ""; + for(int i=0;i<ui->tableWidget->rowCount();++i){ + values += QString("('%1','%2',%3,'%4',%5,'%6'),").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(g_comId).arg(g_auditDate); + } + values = values.left(values.length()-1); + QString sql = QString("insert into problem_money (kpi_name,code,num,evidences,com_id,time) values %1").arg(values); + qDebug()<<sql; + QSqlQuery query; + if(query.exec(sql)){ + qDebug()<<"OK sql"<<__FUNCTION__; + }else{ + 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())); + } + } +} -- Gitblit v1.8.0