| | |
| | | #include <QDebug> |
| | | #include <QSqlQuery> |
| | | |
| | | extern int g_comId; |
| | | |
| | | AuditWorkload::AuditWorkload(QWidget *parent) : |
| | | QMainWindow(parent), |
| | | ui(new Ui::AuditWorkload) |
| | | { |
| | | ui->setupUi(this); |
| | | ui->tableWidget->setColumnWidth(0,260); |
| | | m_comId = 1; |
| | | m_comId = g_comId; |
| | | } |
| | | |
| | | AuditWorkload::~AuditWorkload() |
| | |
| | | for(int i=0;i<ui->tableWidget->rowCount();++i){ |
| | | values += QString("('%1','%2',%3,%4),").arg(ui->tableWidget->item(i,0)->text()) |
| | | .arg(ui->tableWidget->item(i,1)->text()).arg(ui->tableWidget->item(i,2)->text().toInt()) |
| | | .arg(m_comId); |
| | | .arg(g_comId); |
| | | } |
| | | values = values.left(values.length()-1); |
| | | QString sql = QString("insert into audit_workload (kpi_name,code,num,com_id) values %1").arg(values); |