#include "auditproject.h" #include "ui_auditproject.h" #include <QDebug> #include <QSqlQuery> #pragma execution_character_set("utf-8") extern int g_comId; extern QString g_auditDate; AuditProject::AuditProject(QWidget *parent) : QMainWindow(parent), ui(new Ui::AuditProject) { ui->setupUi(this); for(int i=0;i<ui->tableWidget->rowCount()-1;++i){ for(int j=0;j<ui->tableWidget->columnCount()-1;++j){ auto item = ui->tableWidget->item(i,j); item->setFlags(item->flags() & (~Qt::ItemIsEditable)); } } ui->tableWidget->setColumnWidth(0,300); m_comId = g_comId; // å•ä½id } AuditProject::~AuditProject() { delete ui; } void AuditProject::on_tableWidget_clicked(const QModelIndex &index) { if(index.row() < 9){ int sum = 0; for(int i=1;i<9;++i){ sum += ui->tableWidget->item(i,2)->text().toInt(); } ui->tableWidget->setItem(0,2,new QTableWidgetItem(QString::number(sum))); } } void AuditProject::on_pushButton_clicked() { // 冿¬¡ç»Ÿè®¡ä¸€æŠŠ int sum = 0; for(int i=1;i<9;++i){ sum += ui->tableWidget->item(i,2)->text().toInt(); } ui->tableWidget->setItem(0,2,new QTableWidgetItem(QString::number(sum))); 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(g_comId).arg(g_auditDate); } //qDebug()<<values; values = values.left(values.length()-1); //qDebug()<<values; QString sql = QString("insert into audit_project (kpi_name,code,num,com_id,time) values %1").arg(values); qDebug()<<sql; QSqlQuery query; if(query.exec(sql)){ qDebug()<<"OK sql"<<__FUNCTION__; }else{ qDebug()<<"fail sql"<<__FUNCTION__; } static int cnt=1; ui->pushButton->setText(QString("æäº¤--审计项目_%1次").arg(cnt++)); } 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())); } } // 冿¬¡ç»Ÿè®¡ä¸€æŠŠ int sum = 0; for(int i=1;i<9;++i){ sum += ui->tableWidget->item(i,2)->text().toInt(); } ui->tableWidget->setItem(0,2,new QTableWidgetItem(QString::number(sum))); }