| | |
| | | val += ui->tableWidget->item(j,3)->text().toInt(); |
| | | } |
| | | ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val))); |
| | | ui->tableWidget->setItem(5,3,new QTableWidgetItem(QString::number(val))); // å
é¨å®¡è®¡äººåæ°é |
| | | } |
| | | |
| | | if(i==11){ // èç§° |
| | |
| | | val += ui->tableWidget->item(j,3)->text().toInt(); |
| | | } |
| | | ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val))); |
| | | |
| | | } |
| | | |
| | | if(i==20){ // ç¥è¯ç»æ |
| | |
| | | // é®é¢æ¸
åä¿¡æ¯è¡¨ å建 |
| | | createTableProblemListInfo("problem_list_info"); |
| | | |
| | | // 综åå½å
¥ä¿¡æ¯è¡¨ å建 |
| | | createTableComprehensiveEntryInfo("comprehensive_entry_info"); |
| | | |
| | | } |
| | | |
| | | // 综åå½å
¥ä¿¡æ¯è¡¨ 以ç¼ç ä½ä¸ºææ å |
| | | void SearchInfo::createTableComprehensiveEntryInfo(QString tableName){ |
| | | QString sql = QString("CREATE TABLE %1 (\ |
| | | id INTEGER PRIMARY KEY AUTOINCREMENT,\ |
| | | name VARCHAR (30),\ |
| | | _030000 TEXT,\ |
| | | _030001 TEXT,\ |
| | | _030100 TEXT,\ |
| | | _030101 TEXT,\ |
| | | _030200 TEXT,\ |
| | | _030210 TEXT,\ |
| | | _030220 TEXT,\ |
| | | _030221 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | _030222 TEXT,\ |
| | | company_type TEXT)").arg(tableName); |
| | | QSqlQuery query; |
| | | if(query.exec(sql)) |
| | | { |
| | | qDebug()<<QString("create %1 ok...").arg(tableName); |
| | | }else{ |
| | | qDebug()<<QString("create %1 fail...").arg(tableName)<<query.lastError().text(); |
| | | } |
| | | } |
| | | |
| | | |
| | | // æ´æ¹ç»æä¿¡æ¯è¡¨ |
| | | void SearchInfo::createTableRectifyResultInfo(QString tableName){ |
| | | QString sql = QString("CREATE TABLE %1 (\ |
| | |
| | | void createTableAllComInfo(QString tableName); // åä½ä¿¡æ¯è¡¨å
¨ |
| | | void createTableRectifyResultInfo(QString tableName); // æ´æ¹ç»æä¿¡æ¯è¡¨ |
| | | void createTableProblemListInfo(QString tableName); // é®é¢æ¸
åå表信æ¯è¡¨ |
| | | void createTableComprehensiveEntryInfo(QString tableName); // 综åå½å
¥ä¿¡æ¯è¡¨ |
| | | |
| | | private slots: |
| | | void on_pushButton_search_clicked(); |
| | | |