def updateRecordscoldfoil(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())) coldfoild = DTO.ColdFoil() coldfoild.setIdColdFoil(fila[0]) coldfoild.setProveedor(str(fila[1])) coldfoild.setAncho(float(fila[2])) dialog = editarColdFoil.vEditarColdFoil() dialog.ui.leProveedorColdFoil.setText(coldfoild.getProveedor()) dialog.ui.dsbAnchoColdFoil.setValue(coldfoild.getAncho()) dialog.exec_() except Exception as e: MostrarError(str(e.message)) else: if dialog.editarColdFoil is not None: if (dialog.aceptado): coldfoild.setProveedor( dialog.ui.leProveedorColdFoil.text()) coldfoild.setAncho(dialog.ui.dsbAnchoColdFoil.value()) DAO.ColdFoil(coldfoild).modificarColdFoil() self.cargarviewcoldfoil()
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()