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