void mySqlRelationalDelegate::setModelData(QWidget *editor, QAbstractItemModel *model, const QModelIndex &index) const { if (!index.isValid()) return; QSqlRelationalTableModel *sqlModel = qobject_cast<QSqlRelationalTableModel *>(model); QSortFilterProxyModel* proxyModel = NULL; if (!sqlModel ) { proxyModel = qobject_cast<QSortFilterProxyModel *>(model); if (proxyModel) sqlModel = qobject_cast<QSqlRelationalTableModel *>(proxyModel->sourceModel()); } QSqlTableModel *childModel = sqlModel ? sqlModel->relationModel(index.column()) : 0; QComboBox *combo = qobject_cast<QComboBox *>(editor); if (!sqlModel || !childModel || !combo) { QItemDelegate::setModelData(editor, model, index); return; } int currentItem = combo->currentIndex(); int childColIndex = childModel->fieldIndex(sqlModel->relation(index.column()).displayColumn()); int childEditIndex = childModel->fieldIndex(sqlModel->relation(index.column()).indexColumn()); if (proxyModel) { proxyModel->setData(index, childModel->data(childModel->index(currentItem, childColIndex), Qt::DisplayRole), Qt::DisplayRole); proxyModel->setData(index, childModel->data(childModel->index(currentItem, childEditIndex), Qt::EditRole), Qt::EditRole); } else { sqlModel->setData(index, childModel->data(childModel->index(currentItem, childColIndex), Qt::DisplayRole), Qt::DisplayRole); sqlModel->setData(index, childModel->data(childModel->index(currentItem, childEditIndex), Qt::EditRole), Qt::EditRole); } }
void MainWindow::importData() { int exam_id; QString dataFileName = QFileDialog::getOpenFileName(this,tr("Import Data From a CSV File"),QDir::homePath(),tr("CSV File (*.csv)")); if(dataFileName.isEmpty()) return; QFile dataFile(dataFileName); if(!dataFile.open(QIODevice::ReadOnly)) { QMessageBox::critical(this,tr("Open File Failed"),tr("Cannot open selected file"));; return; } QSqlTableModel* student = m_scoreView->studentListModel(); QSqlTableModel* exam = m_scoreView->examListModel(); QSqlRelationalTableModel* score = m_scoreView->scoreListModel(); QFileInfo tmp(dataFileName); QString exam_name = tmp.baseName(); exam->setFilter(QString("name = \'%1\'").arg(exam_name)); if(exam->rowCount() == 1) { QSqlRecord rq = exam->record(0); exam_id = rq.value("id").toInt(); } else { exam->insertRow(0); exam->setData(exam->index(0,Global::Exam_Name),exam_name); exam->submitAll(); exam->setFilter(QString("name = \'%1\'").arg(exam_name)); QSqlRecord rq = exam->record(0); exam_id = rq.value("id").toInt(); } QHash<QString,int> studentMap; for(int row = 0;row < student->rowCount();++row) studentMap.insert(student->data(student->index(row,1)).toString(),student->data(student->index(row,0)).toInt()); QTextStream in(&dataFile); QString record = in.readLine(); QStringList candidate_seps; candidate_seps << ";" << "," << "\t" << " "; QString real_sep; bool is_legal = false; QStringList cols; foreach(real_sep, candidate_seps) { cols = record.split(real_sep); if(cols.size() == 11) { is_legal = true; break; } }
void simplePerson::setData(QString idx, QString tableName) { QSqlTableModel model; model.setTable(tableName); model.setFilter(QString("id = %1").arg(idx)); model.select(); id = model.data(model.index(0,0)).toString(); surname = model.data(model.index(0,1)).toString(); name = model.data(model.index(0,2)).toString(); patronimic = model.data(model.index(0,3)).toString();; }
void QSqlQueryModel_snippets() { { //! [16] QSqlQueryModel *model = new QSqlQueryModel; model->setQuery("SELECT name, salary FROM employee"); model->setHeaderData(0, Qt::Horizontal, tr("Name")); model->setHeaderData(1, Qt::Horizontal, tr("Salary")); //! [17] QTableView *view = new QTableView; //! [17] //! [18] view->setModel(model); //! [18] //! [19] view->show(); //! [16] //! [19] //! [20] view->setEditTriggers(QAbstractItemView::NoEditTriggers); //! [20] } //! [21] QSqlTableModel model; model.setTable("employee"); model.select(); int salary = model.record(4).value("salary").toInt(); //! [21] Q_UNUSED(salary); { //! [22] int salary = model.data(model.index(4, 2)).toInt(); //! [22] Q_UNUSED(salary); } for (int row = 0; row < model.rowCount(); ++row) { for (int col = 0; col < model.columnCount(); ++col) { qDebug() << model.data(model.index(row, col)); } } }
int FacturationIO::getrowoffacturation(QSqlTableModel & modelfacturation,const QString & factureid) { int row = 0; for ( int i = 0; i < modelfacturation.rowCount(); ++i) { if (modelfacturation.data(modelfacturation.index(i,ID_FACTURE),Qt::DisplayRole).toString() == factureid) { row = i; } } return row; }
void MySqlRelationDelegate::setModelData(QWidget *editor, QAbstractItemModel *model, const QModelIndex &index) const { if (!index.isValid()) return; QSqlRelationalTableModel *sqlModel = qobject_cast<QSqlRelationalTableModel *>(model); QSqlTableModel *childModel = sqlModel ? sqlModel->relationModel(index.column()) : 0; QComboBox *combo = qobject_cast<QComboBox *>(editor); if (!sqlModel || !childModel || !combo) { if (HandbookDialog::m_record.fieldName(index.column()).contains("IS_", Qt::CaseSensitive)) { QCheckBox * checkBox = qobject_cast<QCheckBox *>(editor); sqlModel->setData(index, checkBox->isChecked(), Qt::DisplayRole); sqlModel->setData(index, checkBox->isChecked(), Qt::EditRole); return; } else if (HandbookDialog::m_record.fieldName(index.column()).contains("DATE_", Qt::CaseSensitive)) { QDateEdit * dateEdit = qobject_cast<QDateEdit *>(editor); sqlModel->setData(index, dateEdit->date().toString("yyyy-MM-dd"), Qt::DisplayRole); sqlModel->setData(index, dateEdit->date().toString("yyyy-MM-dd"), Qt::EditRole); return; } else { QItemDelegate::setModelData(editor, model, index); return; } } int currentItem = combo->currentIndex(); int childColIndex = childModel->fieldIndex(sqlModel->relation(index.column()).displayColumn()); int childEditIndex = childModel->fieldIndex(sqlModel->relation(index.column()).indexColumn()); sqlModel->setData(index, childModel->data(childModel->index(currentItem, childColIndex), Qt::DisplayRole), Qt::DisplayRole); sqlModel->setData(index, childModel->data(childModel->index(currentItem, childEditIndex), Qt::EditRole), Qt::EditRole); }
void MainWindow::on_currencyComboBox_currentIndexChanged(int index) { int row = ui->assetsTable->currentIndex().row(); QVariant current_value = model->data(model->index(row, currency_column_index), Qt::DisplayRole); QSqlTableModel *childModel = model->relationModel(currency_column_index); int childColIndex = childModel->fieldIndex("code"); QVariant new_value = childModel->data(childModel->index(index, childColIndex), Qt::DisplayRole); if(current_value != new_value) { mapper->submit(); } }
void partner::setUpdate(QString idt) { QSqlTableModel model; model.setTable("Partner"); model.setFilter(QString("id = %1").arg(idt)); model.select(); id = model.data(model.index(0,0)).toInt(); ui->nameEdit->setText(model.data(model.index(0,1)).toString()); ui->surnameEdit->setText(model.data(model.index(0,2)).toString()); ui->patronimicEdit->setText(model.data(model.index(0,3)).toString()); ui->passportEdit->setText(model.data(model.index(0,4)).toString()); ui->phoneEdit->setText(model.data(model.index(0,5)).toString()); mode = updateMode; }
void SelectLiftDlg::on_pushBtnSel_clicked() { int curRow = ui->tableView->currentIndex().row(); if(curRow<0) { QMessageBox::warning(this,"警告","请先选择电梯!",QMessageBox::Yes); return; } QSqlTableModel *modelTable = new QSqlTableModel(this); modelTable->setTable("tableLift"); modelTable->select(); for(int i=0;i<modelTable->columnCount();i++) { QModelIndex index = modelTable->index(curRow,i); arrValues.push_back(modelTable->data(index).toString()); } accept(); }
void MainWindow::slotBtnReadCard() { std::string strTxtbrwInfos = ""; QString strQTxtbrwInfos; #ifdef USE_CH375 if(ch375rw.bIsOpened) { ch375rw.Read(0x00,48); Sleep(TIME_DELAY); UCHAR *chData = ch375rw.Read(0x00,48); if(chData==NULL) { return; } strTxtbrwInfos = "卡号:"+ch375rw.strCardID+"\n"; switch(int(chData[1]))//卡类型 { case 0x01://用户卡 { strTxtbrwInfos += "卡类型:用户卡\n"; dsUserCard.chars2DS(chData); break; } case 0x2://普通管理人卡 strTxtbrwInfos += "卡类型:普通管理人卡\n"; break; case 0x3://高级管理人卡 strTxtbrwInfos += "卡类型:高级管理人卡\n"; break; case 0x04://黑名单(启禁用卡) { strTxtbrwInfos += "卡类型:启禁用卡\n"; dsEnableCard.chars2DS(chData); if(dsEnableCard.structEnableCard.EnableType==0x01)//按卡号 { strTxtbrwInfos += "启禁用类型:按卡号\n"; } if(dsEnableCard.structEnableCard.EnableType==0x02)//按房号 { strTxtbrwInfos += "启禁用类型:按房号\n"; } std::string strLimitCardType=""; if(dsEnableCard.structEnableCard.LimitCardType==0x01) { strLimitCardType="用户卡"; } if(dsEnableCard.structEnableCard.LimitCardType==0x02) { strLimitCardType="管理人卡"; } int nLiftNum = dsEnableCard.structEnableCard.LiftNum; strTxtbrwInfos += "可用电梯:"+TypeConvert::intNormal2stdstring(nLiftNum)+"\n"; if(dsEnableCard.structEnableCard.Num1[0]==0x00) { std::string strIsEnable1=""; if(dsEnableCard.structEnableCard.IsEnable1==0x01) { strIsEnable1="启用"; } if(dsEnableCard.structEnableCard.IsEnable1==0x02) { strIsEnable1="禁用"; } std::string strNum1=""; for(int i=0;i<4;i++) { int nNum1=dsEnableCard.structEnableCard.Num1[i]; strNum1 += TypeConvert::intDec2stdstring(nNum1); } if(dsEnableCard.structEnableCard.EnableType==0x01) { strTxtbrwInfos += strLimitCardType+"卡号:"+ strNum1.substr(3,5)+" "+strIsEnable1+"\n"; } if(dsEnableCard.structEnableCard.EnableType==0x02) { strTxtbrwInfos += "房号:"+strNum1.substr(4,4)+" "+strIsEnable1+"\n"; } } if(dsEnableCard.structEnableCard.Num2[0]==0x00) { std::string strIsEnable2=""; if(dsEnableCard.structEnableCard.IsEnable2==0x01) { strIsEnable2="启用"; } if(dsEnableCard.structEnableCard.IsEnable2==0x02) { strIsEnable2="禁用"; } std::string strNum2=""; for(int i=0;i<4;i++) { int nNum2=dsEnableCard.structEnableCard.Num2[i]; strNum2 += TypeConvert::intDec2stdstring(nNum2); } if(dsEnableCard.structEnableCard.EnableType==0x01) { strTxtbrwInfos += strLimitCardType+"卡号:"+ strNum2.substr(3,5)+" "+strIsEnable2+"\n"; } if(dsEnableCard.structEnableCard.EnableType==0x02) { strTxtbrwInfos += "房号:"+strNum2.substr(4,4)+" "+strIsEnable2+"\n"; } } if(dsEnableCard.structEnableCard.Num3[0]==0x00) { std::string strIsEnable3=""; if(dsEnableCard.structEnableCard.IsEnable3==0x01) { strIsEnable3="启用"; } if(dsEnableCard.structEnableCard.IsEnable3==0x02) { strIsEnable3="禁用"; } std::string strNum3=""; for(int i=0;i<4;i++) { int nNum3=dsEnableCard.structEnableCard.Num3[i]; strNum3 += TypeConvert::intDec2stdstring(nNum3); } if(dsEnableCard.structEnableCard.EnableType==0x01) { strTxtbrwInfos += strLimitCardType+"卡号:"+ strNum3.substr(3,5)+" "+strIsEnable3+"\n"; } if(dsEnableCard.structEnableCard.EnableType==0x02) { strTxtbrwInfos += "房号:"+strNum3.substr(4,4)+" "+strIsEnable3+"\n"; } } if(dsEnableCard.structEnableCard.Num4[0]==0x00) { std::string strIsEnable4=""; if(dsEnableCard.structEnableCard.IsEnable4==0x01) { strIsEnable4="启用"; } if(dsEnableCard.structEnableCard.IsEnable4==0x02) { strIsEnable4="禁用"; } std::string strNum4=""; for(int i=0;i<4;i++) { int nNum4=dsEnableCard.structEnableCard.Num4[i]; strNum4 += TypeConvert::intDec2stdstring(nNum4); } if(dsEnableCard.structEnableCard.EnableType==0x01) { strTxtbrwInfos += strLimitCardType+"卡号:"+ strNum4.substr(3,5)+" "+strIsEnable4+"\n"; } if(dsEnableCard.structEnableCard.EnableType==0x02) { strTxtbrwInfos += "房号:"+strNum4.substr(4,4)+" "+strIsEnable4+"\n"; } } break; } case 0x06://时间矫正卡 { strTxtbrwInfos += "卡类型:时间矫正卡\n"; dsTimeSet.chars2DS(chData); switch(dsTimeSet.structTimeSet.TimeSetType) { case SetType::SetControlerTime: { strTxtbrwInfos += "时间卡功能:控制器时间设置\n"; std::vector<std::string> vectorDateTime; for(int i=0;i<6;i++) { int nTemp=dsTimeSet.structTimeSet.ControlerTime[i]; vectorDateTime.push_back(TypeConvert::intHex2stdstring(nTemp)); } std::string strDateTime = vectorDateTime[0]+ vectorDateTime[1]+"-"+ vectorDateTime[2]+"-"+vectorDateTime[3]+" "+ vectorDateTime[4]+":"+vectorDateTime[5]; strTxtbrwInfos += "控制器时间:"+strDateTime+"\n"; break; } case SetType::SetKeyResponseTime: { strTxtbrwInfos += "时间卡功能:按钮响应时间设置\n"; float fTimeOne= float(dsTimeSet.structTimeSet.SingleSelectTime)/10; short sTimeMul=dsTimeSet.structTimeSet.MultiSelectTime; std::string strTimeOne=TypeConvert::float2stdstring(fTimeOne); std::string strTimeMul=TypeConvert::intDec2stdstring(sTimeMul); strTxtbrwInfos += "单选按键响应时间:"+strTimeOne+"秒\n"+ "多选按键响应时间:"+strTimeMul+"秒\n"; break; } case SetType::SetVisitorResponseTime: { strTxtbrwInfos += "时间卡功能:访客按钮响应时间设置\n"; int nHI=dsTimeSet.structTimeSet.VisitorTime[0]; int nLO=dsTimeSet.structTimeSet.VisitorTime[1]; int nTimeVisit=nHI*256+nLO; std::string strTimeVisit = TypeConvert::intNormal2stdstring(nTimeVisit); strTxtbrwInfos += "访客按键响应时间:"+strTimeVisit+"秒\n"; break; } } break; } case 0x7://电梯运行卡 { strTxtbrwInfos += "卡类型:电梯运行卡\n"; break; } case 0x08://系统开关卡 { strTxtbrwInfos += "卡类型:系统开关卡\n"; dsSysSwitchCard.chars2DS(chData); switch (dsSysSwitchCard.structSysSwitchCard.SwitchCardType) { case SWCardType::SysSwitch: { strTxtbrwInfos+="开关卡分类:系统开关卡\n"; break; } case SWCardType::LayerSwitch: { strTxtbrwInfos+="开关卡分类:分层开关卡\n"; if(dsSysSwitchCard.structSysSwitchCard.SwitchFlag==0x11) { strTxtbrwInfos+="开关标识:开放\n"; } if(dsSysSwitchCard.structSysSwitchCard.SwitchFlag==0x22) { strTxtbrwInfos+="开关标识:关闭\n"; } //电梯编号 int nLiftNum=0; for(int i=0;i<32;i++) { for(int j=0;j<8;j++) { if ( (dsSysSwitchCard.structSysSwitchCard.LiftNum[i] & (1<<j)) == pow(2,j) ) { nLiftNum=i*8+(j+1); break; } } } strTxtbrwInfos+="可用电梯号:"+TypeConvert::intNormal2stdstring(nLiftNum)+"\n"; //受控楼层 strTxtbrwInfos+="受控楼层:"; strTxtbrwInfos+="A门:"; for(int i=0;i<6;i++) { for(int j=0;j<8;j++) { if ( (dsSysSwitchCard.structSysSwitchCard.FloorsA[i]&(1<<j)) == pow(2,j) ) { int nFloor = i*8+(j+1); strTxtbrwInfos+=TypeConvert::intNormal2stdstring(nFloor)+","; } } } strTxtbrwInfos.erase(strTxtbrwInfos.end()-1); strTxtbrwInfos+="\n"; break; } case SWCardType::PublicFloorsSet: { strTxtbrwInfos+="开关卡分类:公共楼层设置卡\n"; if(dsSysSwitchCard.structSysSwitchCard.SwitchFlag==0x11) { strTxtbrwInfos+="开关标识:开放\n"; } if(dsSysSwitchCard.structSysSwitchCard.SwitchFlag==0x22) { strTxtbrwInfos+="开关标识:关闭\n"; } //电梯编号 int nLiftNum=1; for(int i=0;i<32;i++) { for(int j=0;j<8;j++) { if ( (dsSysSwitchCard.structSysSwitchCard.LiftNum[i]&(1<<j)) == pow(2,j) ) { nLiftNum=i*8+(j+1); } } } strTxtbrwInfos+="可用电梯号:"+TypeConvert::intNormal2stdstring(nLiftNum)+"\n"; //受控楼层 strTxtbrwInfos+="受控楼层:"; strTxtbrwInfos+="A门:"; for(int i=0;i<6;i++) { for(int j=0;j<8;j++) { if ( (dsSysSwitchCard.structSysSwitchCard.FloorsA[i]&(1<<j)) == pow(2,j) ) { int nFloor = i*8+(j+1); strTxtbrwInfos+=TypeConvert::intNormal2stdstring(nFloor)+","; } } } strTxtbrwInfos.erase(strTxtbrwInfos.end()-1); strTxtbrwInfos+="\n"; break; } default: break; } break; } case 0x0A://通讯地址设定卡 { strTxtbrwInfos += "卡类型:通讯地址设定卡\n"; int nAddr = chData[2]; strTxtbrwInfos += "地址:"+TypeConvert::intNormal2stdstring(nAddr)+"\n"; break; } case 0x0B://清内存卡 { strTxtbrwInfos += "卡类型:清内存卡\n"; break; } default: { strTxtbrwInfos += "此卡为新卡\n"; break; } } } else { strTxtbrwInfos = "请插入读卡器!"; } ch375rw.Beep(1); strQTxtbrwInfos=QString::fromStdString(strTxtbrwInfos); #endif static int countClick=0; countClick++; switch(countClick) { case 1: { strQTxtbrwInfos="用户卡\n"; std::vector<QString> arrFiledsUsrCards; arrFiledsUsrCards.push_back("卡号"); arrFiledsUsrCards.push_back("业主姓名"); arrFiledsUsrCards.push_back("业主门牌"); arrFiledsUsrCards.push_back("联系电话"); arrFiledsUsrCards.push_back("限制日期"); arrFiledsUsrCards.push_back("可用电梯"); arrFiledsUsrCards.push_back("可用楼层"); arrFiledsUsrCards.push_back("房间编号"); QSqlTableModel *modelTableUsrCard = new QSqlTableModel(this); modelTableUsrCard->setTable("tableUsrCard"); modelTableUsrCard->select(); int rowLast = modelTableUsrCard->rowCount()-1; for(int i=0;i<8;i++) { QModelIndex indexModelLast = modelTableUsrCard->index(rowLast,i); QString strUsrCardLast = modelTableUsrCard->data(indexModelLast).toString(); strQTxtbrwInfos += arrFiledsUsrCards[i] + ":"+strUsrCardLast+"\n"; } break; } case 2: { strQTxtbrwInfos="此卡为新卡!\n"; break; } } txtbrwInfos->setText(strQTxtbrwInfos); }
void TableEditor::removeSelectedRows() { int currentTab = tabWidget->currentIndex(); QTableView *tv = agentsTable; QSqlTableModel *stm = agentsModel; QString table = "agents"; int idColumn = 0; if (currentTab == 1) { tv = determinationsTable; stm = determinationsModel; table = "determinations"; } else if (currentTab == 2) { tv = imagesTable; stm = imagesModel; table = "images"; idColumn = 20; } else if (currentTab == 3) { tv = taxaTable; stm = taxaModel; table = "taxa"; idColumn = 1; } else if (currentTab == 4) { tv = organismsTable; stm = organismsModel; table = "organisms"; } else if (currentTab == 5) { tv = sensuTable; stm = sensuModel; table = "sensu"; } QItemSelectionModel *selected = tv->selectionModel(); QModelIndexList rowList = selected->selectedIndexes(); for (int i = rowList.count()-1; i >= 0; i--) { stm->removeRow(rowList.at(i).row(), rowList.at(i).parent()); QString identifier; if (table == "determinations") { QString orgID = stm->data(stm->index(rowList.at(i).row(),0),Qt::DisplayRole).toString(); QString date = stm->data(stm->index(rowList.at(i).row(),2),Qt::DisplayRole).toString(); QString tsnID = stm->data(stm->index(rowList.at(i).row(),4),Qt::DisplayRole).toString(); QString source = stm->data(stm->index(rowList.at(i).row(),5),Qt::DisplayRole).toString(); reversions.append("INSERT OR REPLACE INTO determinations SELECT * FROM pub_determinations " "WHERE dsw_identified = '" + orgID + "' AND " "dwc_dateIdentified = '" + date + "' AND " "tsnID = '" + tsnID + "' AND " "nameAccordingToID = '" + source + "' LIMIT 1"); } else { identifier = stm->data(stm->index(rowList.at(i).row(),idColumn),Qt::DisplayRole).toString(); reversions.append("INSERT OR REPLACE INTO " + table + " SELECT * FROM pub_" + table + " WHERE dcterms_identifier = '" + identifier + "' LIMIT 1"); } } }