#include "problemmoney.h" #include "ui_problemmoney.h" #include <QPushButton> #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 = 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),").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); } values = values.left(values.length()-1); QString sql = QString("insert into problem_money (kpi_name,code,num,evidences,com_id) values %1").arg(values); qDebug()<<sql; QSqlQuery query; if(query.exec(sql)){ qDebug()<<"OK sql"<<__FUNCTION__; }else{ qDebug()<<"fail sql"<<__FUNCTION__; } }