| | |
| | | #include <QDebug> |
| | | #include <QSqlQuery> |
| | | |
| | | extern int g_comId; |
| | | AuditProject::AuditProject(QWidget *parent) : |
| | | QMainWindow(parent), |
| | | ui(new Ui::AuditProject) |
| | |
| | | } |
| | | } |
| | | ui->tableWidget->setColumnWidth(0,300); |
| | | m_comId = 1; // 单位id |
| | | m_comId = g_comId; // 单位id |
| | | |
| | | } |
| | | |
| | |
| | | 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); |
| | | } |
| | | //qDebug()<<values; |
| | | values = values.left(values.length()-1); |
| | |
| | | qDebug()<<"fail sql"<<__FUNCTION__; |
| | | } |
| | | } |
| | | |
| | | 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())); |
| | | } |
| | | } |
| | | } |