def cargarviewcoldfoil(self):
self.modelcoldfoil = QtSql.QSqlTableModel(self)
self.modelcoldfoil.setTable("cold_foil")
listaref = self.cadenadereferencias(
DAO.ColdFoilFicha().leerColdFoilEnFicha(self.edicion))
self.modelcoldfoil.setFilter("idColdFoil in {0}".format(listaref))
self.modelcoldfoil.setEditStrategy(QtSql.QSqlTableModel.OnManualSubmit)
self.modelcoldfoil.select()
self.ui.viewColdFoil.setModel(self.modelcoldfoil)
self.ui.viewColdFoil.hideColumn(0)
pass
def deleteRecordscoldfoil(self):
try:
fila = []
for col in range(self.modelcoldfoil.columnCount()):
index = self.modelcoldfoil.index(
self.ui.viewColdFoil.currentIndex().row(), col)
fila.append(str(self.modelcoldfoil.data(index).toString()))
coldfoil = DTO.ColdFoil()
coldfoil.setIdColdFoil(fila[0])
DAO.ColdFoilFicha().eliminarReferencia(fila[0], self.edicion)
DAO.ColdFoil(coldfoil).eliminarColdFoil()
except Exception as e:
MostrarError(str(e.message))
else:
self.modelcoldfoil.submitAll()
def insertRecordscoldfoil(self):
try:
coldfoil = DTO.ColdFoil()
coldfoil.setProveedor(self.ui.leProveedorColdFoilMod.text())
coldfoil.setAncho(self.ui.dsbAnchoColdFoilMod.value())
DAO.ColdFoil(coldfoil).ingresarColdFoil()
"crear referencia de forma inmediata"
cff = DAO.ColdFoilFicha()
cff.setIdFicha(self.edicion)
cff.setIdColdFoil(DAO.ColdFoil().idUltimoColdFoil())
cff.insertarColdFoilFicha()
self.cargarviewcoldfoil()
except Exception as e:
MostrarError(str(e.message))
else:
self.modelcoldfoil.submitAll()
