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()