def cargarviewfilmmi(self): self.modelfilmi = QtSql.QSqlTableModel(self) self.modelfilmi.setTable("film_micronaje") listaref = self.cadenadereferencias( DAO.FilmMiFicha().leerFilmMiEnFicha(self.edicion)) self.modelfilmi.setFilter("idFilmMi in {0}".format(listaref)) self.modelfilmi.setEditStrategy(QtSql.QSqlTableModel.OnManualSubmit) self.modelfilmi.select() self.ui.viewFilmmi.setModel(self.modelfilmi) self.ui.viewFilmmi.hideColumn(0) pass
def deleteRecordsfilmmi(self): try: fila = [] for col in range(self.modelfilmi.columnCount()): index = self.modelfilmi.index( self.ui.viewFilmmi.currentIndex().row(), col) fila.append(str(self.modelfilmi.data(index).toString())) filmi = DTO.FilmMicronaje() filmi.setIdFilmMi(fila[0]) DAO.FilmMiFicha().eliminarReferencia(fila[0], self.edicion) DAO.FilmMicronaje(filmi).eliminarFilmMi() except Exception as e: MostrarError(str(e.message)) else: self.modelfilmi.submitAll()
def insertRecordsfilmmi(self): try: filmi = DTO.FilmMicronaje() filmi.setProveedor(self.ui.leProveedorFilmMiMod.text()) filmi.setAncho(self.ui.dsbAnchoFilmMiMod.value()) DAO.FilmMicronaje(filmi).ingresarFilmMi() "crear referencia de forma inmediata" ff = DAO.FilmMiFicha() ff.setIdFicha(self.edicion) ff.setIdFilmMi(DAO.FilmMicronaje().idUltimoFilmMi()) ff.insertarFilmMiFicha() self.cargarviewfilmmi() except Exception as e: MostrarError(str(e.message)) else: self.modelfilmi.submitAll()