void MemberDlg::midify() { model->submitAll(); QMessageBox::information(NULL,tr("修改记录"),tr("修改完成,数据已保存!"), QMessageBox::Yes); emit updateFamilyMember(); }
void MemberDlg::deleteRecords() { QItemSelectionModel *select_mode=view->selectionModel(); QModelIndexList list = select_mode->selectedRows(); qDebug()<<"list:"<<list.size(); if(0 == list.count()) { QMessageBox::information(NULL,tr("删除记录"),tr("对不起,请选择至少一条要删除的记录!"), QMessageBox::Yes); return; } else { int ret=QMessageBox::information(NULL,tr("删除记录"),tr("您确定要删除该记录?"), QMessageBox::Yes,QMessageBox::No); if(ret==QMessageBox::No) return; QSqlTableModel tableModel; tableModel.setTable("Account"); for(int i=0; i<list.count();i++) { int MainID = model->data(model->index(list.at(i).row(),0)).toInt(); tableModel.setFilter(QString("FamilyMember = %1").arg(MainID)); tableModel.select(); tableModel.removeRows(0,tableModel.rowCount()); //先删除Account与该成员关联的记录 } model->removeRows(list.at(0).row(),list.count()); model->submitAll(); model->select(); } emit updateFamilyMember();//通知其他窗体更新 }
void MemberDlg::addMember() { int row = model->rowCount(); model->insertRow(row); model->setData(model->index(row,1),edit->text()); model->setData(model->index(row,2),1); model->submitAll(); model->select(); view->scrollToBottom(); emit updateFamilyMember(); }
void MainWindow::addMember() { MemberDlg *memberDlg = new MemberDlg("FamilyMember"); connect(memberDlg,SIGNAL(updateFamilyMember()),this,SLOT(updateMember())); memberDlg->show(); }