コード例 #1
0
ファイル: mysql51.py プロジェクト: liluisjose1/Simulacion
    def __init__( self, parent ):
        wx.Dialog.__init__ ( self, parent, id = wx.ID_ANY, title = u"CRUD Productos", pos = wx.DefaultPosition, size = wx.Size( 760,460 ), style = wx.DEFAULT_DIALOG_STYLE )
        
        #self.SetSizeHints( wx.DefaultSize, wx.DefaultSize )
        #Clase Padre formulario superior
        self.frm_padre=parent
        sizer0 = wx.GridSizer( 0, 2, 0, 0 ) #agregado para colocar una celda del grid derecho para img
        sizer1 = wx.BoxSizer( wx.VERTICAL )
 
        fgSizer1 = wx.FlexGridSizer( 8, 2, 0, 0 )
        fgSizer1.SetFlexibleDirection( wx.BOTH )
        fgSizer1.SetNonFlexibleGrowMode( wx.FLEX_GROWMODE_SPECIFIED )
        self.m_staticText1 = wx.StaticText( self, wx.ID_ANY, u"ACCION", wx.DefaultPosition, wx.DefaultSize, 0 )
        self.m_staticText1.Wrap( -1 )
        fgSizer1.Add( self.m_staticText1, 0, wx.ALL, 5 )
        self.lbl1 = wx.StaticText( self, wx.ID_ANY, "", wx.DefaultPosition, wx.DefaultSize, 0 )
        self.lbl1.Wrap( -1 )
        fgSizer1.Add( self.lbl1, 0, wx.ALL, 5 )
        self.m_staticText6 = wx.StaticText( self, wx.ID_ANY, u"Id. Producto", wx.DefaultPosition, wx.DefaultSize, 0 )
        self.m_staticText6.Wrap( -1 )
        fgSizer1.Add( self.m_staticText6, 0, wx.ALL, 5 )
        
        self.txt1 = wx.TextCtrl( self, wx.ID_ANY, wx.EmptyString, wx.DefaultPosition, wx.DefaultSize, 0 )
        fgSizer1.Add( self.txt1, 0, wx.ALL, 5 )
        
        self.m_staticText7 = wx.StaticText( self, wx.ID_ANY, u"Descripcion", wx.DefaultPosition, wx.DefaultSize, 0 )
        self.m_staticText7.Wrap( -1 )
        fgSizer1.Add( self.m_staticText7, 0, wx.ALL, 5 )
        
        self.txt2 = wx.TextCtrl( self, wx.ID_ANY, wx.EmptyString, wx.DefaultPosition, wx.Size( 300,-1 ), 0 )
        fgSizer1.Add( self.txt2, 0, wx.ALL, 5 )
        
        self.m_staticText8 = wx.StaticText( self, wx.ID_ANY, u"Barcode", wx.DefaultPosition, wx.DefaultSize, 0 )
        self.m_staticText8.Wrap( -1 )
        fgSizer1.Add( self.m_staticText8, 0, wx.ALL, 5 )
        
        self.txt3 = wx.TextCtrl( self, wx.ID_ANY, wx.EmptyString, wx.DefaultPosition, wx.DefaultSize, 0 )
        fgSizer1.Add( self.txt3, 0, wx.ALL, 5 )
        
        self.m_staticText9 = wx.StaticText( self, wx.ID_ANY, u"Costo", wx.DefaultPosition, wx.DefaultSize, 0 )
        self.m_staticText9.Wrap( -1 )
        fgSizer1.Add( self.m_staticText9, 0, wx.ALL, 5 )
        
        self.txt4 = wx.TextCtrl( self, wx.ID_ANY, wx.EmptyString, wx.DefaultPosition, wx.DefaultSize, 0 )
        fgSizer1.Add( self.txt4, 0, wx.ALL, 5 )
        
        self.m_staticText10 = wx.StaticText( self, wx.ID_ANY, u"Precio", wx.DefaultPosition, wx.DefaultSize, 0 )
        self.m_staticText10.Wrap( -1 )
        fgSizer1.Add( self.m_staticText10, 0, wx.ALL, 5 )
        
        self.txt5 = wx.TextCtrl( self, wx.ID_ANY, wx.EmptyString, wx.DefaultPosition, wx.DefaultSize, 0 )
        fgSizer1.Add( self.txt5, 0, wx.ALL, 5 )
       
        self.m_staticText11 = wx.StaticText( self, wx.ID_ANY, u"Categoria", wx.DefaultPosition, wx.DefaultSize, 0 )
        self.m_staticText11.Wrap( -1 )
        fgSizer1.Add( self.m_staticText11, 0, wx.ALL, 5 )
        
        OpcionCat = ['Seleccionar']
        self.cbCat = wx.ComboBox( self, wx.ID_ANY, u"", wx.DefaultPosition, wx.DefaultSize, OpcionCat, 0 )
        fgSizer1.Add( self.cbCat, 0, wx.ALL, 5 )
        
        self.m_staticText12 = wx.StaticText( self, wx.ID_ANY, u"Inactivo", wx.DefaultPosition, wx.DefaultSize, 0 )
        self.m_staticText12.Wrap( -1 )
        fgSizer1.Add( self.m_staticText12, 0, wx.ALL, 5 )
        
        self.checkInactivo = wx.CheckBox( self, wx.ID_ANY, u"Checkear Inactivo", wx.DefaultPosition, wx.DefaultSize, 0 )
        fgSizer1.Add( self.checkInactivo, 0, wx.ALL, 5 )
        
        
        sizer1.Add( fgSizer1, 1, wx.EXPAND, 5 )
       

        fgSizer2 = wx.FlexGridSizer( 0, 3, 0, 0 )
        fgSizer2.SetFlexibleDirection( wx.BOTH )
        fgSizer2.SetNonFlexibleGrowMode( wx.FLEX_GROWMODE_SPECIFIED )
        fgSizer2.Add( ( 50, 0), 1, wx.EXPAND, 5 )
        
        self.btn1 = wx.Button( self, wx.ID_ANY, u"Aceptar", wx.DefaultPosition, wx.DefaultSize, 0 )
        fgSizer2.Add( self.btn1, 0, wx.ALL, 5 )
        
        self.btn4 = wx.Button( self, wx.ID_ANY, u"Salir", wx.DefaultPosition, wx.DefaultSize, 0 )
        fgSizer2.Add( self.btn4, 0, wx.ALL, 5 )
        
        
        sizer1.Add( fgSizer2, 1, wx.EXPAND, 5 )
        sizer0.Add( sizer1, 1, wx.EXPAND, 5 )
        #sizer imagen
        sizer_img = wx.FlexGridSizer( 3, 1, 0, 0 )
        sizer_img.SetFlexibleDirection( wx.BOTH )
        sizer_img.SetNonFlexibleGrowMode( wx.FLEX_GROWMODE_SPECIFIED )
       
        self.ruta='imgs/blank_img.png'  
        self.img = wx.StaticBitmap( self, wx.ID_ANY, wx.NullBitmap, wx.DefaultPosition, wx.DefaultSize, 0 )
        sizer_img.Add( self.img, 0, wx.ALL, 5 )
        sizer0.Add( sizer_img, 1, wx.EXPAND, 5 )
        self.btn_buscar_img = wx.Button( self, wx.ID_ANY, u"Buscar Img", wx.DefaultPosition, wx.DefaultSize, 0 )
        sizer_img.Add( self.btn_buscar_img, 0, wx.ALL, 5 )
        #Maximo tamaño de imagen
        self.PhotoMaxSize=400
        #fin buscar imagen

        self.SetSizer(sizer0 )
        self.Layout()
        
        self.Centre( wx.BOTH )
        
        # Connect Events
        self.btn1.Bind( wx.EVT_BUTTON, self.btnAceptar )
        self.btn4.Bind( wx.EVT_BUTTON, self.btnSalir )
        self.cbCat.Bind( wx.EVT_COMBOBOX, self.CatSeleccion )
        self.checkInactivo.Bind( wx.EVT_CHECKBOX, self.chkInactivar )
        self.btn_buscar_img.Bind( wx.EVT_BUTTON, self.BuscarImg )  #evento buscar img
        #base de datos
        self.db = mysqlclass3.Database("ventas") #Instanciar la conexion a la Bd.
        #Evento mostrar datos
        
        #MODAL PARA mensajes
        self.dial = wx.MessageDialog(None, 'DATOS GUARDADOS', 'Info', wx.OK|wx.CENTRE)
        #cargar imagen por defecto
        self.VerImagen(self.ruta)
コード例 #2
0
ファイル: mysql51.py プロジェクト: liluisjose1/Simulacion
    def __init__( self, parent ):
        self.title="Listar Productos, Busqueda por Descripcion"
        wx.Frame.__init__ ( self, parent, id = wx.ID_ANY, title = self.title, pos = wx.DefaultPosition, size = wx.Size( 610,500 ), style = wx.DEFAULT_FRAME_STYLE|wx.TAB_TRAVERSAL )
        
        self.SetSizeHintsSz( wx.DefaultSize, wx.DefaultSize )
        
        fgSizer1 = wx.FlexGridSizer( 3, 1, 0, 0 )
        fgSizer1.SetFlexibleDirection( wx.BOTH )
        fgSizer1.SetNonFlexibleGrowMode( wx.FLEX_GROWMODE_SPECIFIED )
        
        fgSizer2 = wx.FlexGridSizer( 0, 3, 0, 0 )
        fgSizer2.SetFlexibleDirection( wx.BOTH )
        fgSizer2.SetNonFlexibleGrowMode( wx.FLEX_GROWMODE_SPECIFIED )
        
        self.m_staticText1 = wx.StaticText( self, wx.ID_ANY, u"Buscar", wx.DefaultPosition, wx.DefaultSize, 0 )
        self.m_staticText1.Wrap( -1 )
        fgSizer2.Add( self.m_staticText1, 0, wx.ALL, 5 )
        
        self.txt_Busqueda = wx.TextCtrl( self, wx.ID_ANY, wx.EmptyString,  wx.DefaultPosition, wx.Size( 250,-1 ), 0 )
        fgSizer2.Add(self.txt_Busqueda , 0, wx.ALL, 5 )
        
        self.btn_Buscar = wx.Button( self, wx.ID_ANY, u"Buscar", wx.DefaultPosition, wx.DefaultSize, 0 )
        fgSizer2.Add( self.btn_Buscar, 0, wx.ALL, 5 )
        
        
        fgSizer1.Add( fgSizer2, 1, wx.EXPAND, 5 )
        
        fgSizer3 = wx.FlexGridSizer( 1, 2, 0, 0 )
        fgSizer3.SetFlexibleDirection( wx.BOTH )
        fgSizer3.SetNonFlexibleGrowMode( wx.FLEX_GROWMODE_SPECIFIED )

        self.listctrl = wx.ListCtrl( self, wx.ID_ANY,  wx.Point( 10,10 ), wx.Size( 600,200 ), wx.LC_REPORT|wx.SUNKEN_BORDER )
        fgSizer3.Add( self.listctrl, 0, wx.ALL, 5 )
        fgSizer1.Add( fgSizer3, 1, wx.EXPAND, 5 )
        #Agregar un sizer de 1 fila 4 col
        fgSizer4 = wx.FlexGridSizer( 1, 4, 0, 0 )
        fgSizer4.SetFlexibleDirection( wx.BOTH )
        fgSizer4.SetNonFlexibleGrowMode( wx.FLEX_GROWMODE_SPECIFIED )
        #Botones para mantenimiento
        self.btn_Insertar = wx.Button( self, wx.ID_ANY, u"Insertar", wx.DefaultPosition, wx.DefaultSize, 0 )
        fgSizer4.Add( self.btn_Insertar, 0, wx.ALL, 5 )  
        self.btn_Ver = wx.Button( self, wx.ID_ANY, u"Ver", wx.DefaultPosition, wx.DefaultSize, 0 )
        fgSizer4.Add( self.btn_Ver, 0, wx.ALL, 5 )  
        self.btn_Editar = wx.Button( self, wx.ID_ANY, u"Editar", wx.DefaultPosition, wx.DefaultSize, 0 )
        fgSizer4.Add( self.btn_Editar, 0, wx.ALL, 5 )          
        self.btn_Eliminar = wx.Button( self, wx.ID_ANY, u"Eliminar", wx.DefaultPosition, wx.DefaultSize, 0 )
        fgSizer4.Add( self.btn_Eliminar, 0, wx.ALL, 5 )          
        fgSizer1.Add( fgSizer4, 1, wx.EXPAND, 5 )
        
        self.SetSizer( fgSizer1 )
        self.Layout()
        
        self.Centre( wx.BOTH )
        
        # Connect Events
        self.btn_Buscar.Bind( wx.EVT_BUTTON, self.Buscar )
        self.txt_Busqueda.Bind( wx.EVT_TEXT, self.Busqueda )
        self.listctrl.Bind(wx.EVT_LIST_ITEM_SELECTED, self.Seleccionar)
        self.btn_Insertar.Bind( wx.EVT_BUTTON, self.Insertar )
        self.btn_Ver.Bind( wx.EVT_BUTTON, self.Ver )
        self.btn_Editar.Bind( wx.EVT_BUTTON, self.Editar )
        self.btn_Eliminar.Bind( wx.EVT_BUTTON, self.Eliminar )
        #Conexion Bd
        self.db = mysqlclass3.Database("ventas") #Instanciar la conexion a la Bd.
        #definir valor de item2
        self.item ='' 
        self.item2 ='' 
        #Evento cargar datos de encabezado a la lista y se definen las columnas que lleva el control
        self.listctrl.InsertColumn(0, 'Id', width=100)
        self.listctrl.InsertColumn(1, 'Barcode', width=150)
        self.listctrl.InsertColumn(2, 'Descripcion', width=350)
        self.Cargar()
コード例 #3
0
ファイル: mysql3.py プロジェクト: liluisjose1/Simulacion
    def __init__(self, parent):
        wx.Dialog.__init__(self,
                           parent,
                           id=wx.ID_ANY,
                           title=u"CRUD Productos",
                           pos=wx.DefaultPosition,
                           size=wx.Size(-1, 320),
                           style=wx.DEFAULT_DIALOG_STYLE)

        #self.SetSizeHints( wx.DefaultSize, wx.DefaultSize )
        #Clase Padre formulario superior
        self.frm_padre = parent

        btn2 = wx.BoxSizer(wx.VERTICAL)

        fgSizer1 = wx.FlexGridSizer(7, 2, 0, 0)
        fgSizer1.SetFlexibleDirection(wx.BOTH)
        fgSizer1.SetNonFlexibleGrowMode(wx.FLEX_GROWMODE_SPECIFIED)
        self.m_staticText1 = wx.StaticText(self, wx.ID_ANY, u"ACCION",
                                           wx.DefaultPosition, wx.DefaultSize,
                                           0)
        self.m_staticText1.Wrap(-1)
        fgSizer1.Add(self.m_staticText1, 0, wx.ALL, 5)
        self.lbl1 = wx.StaticText(self, wx.ID_ANY, "", wx.DefaultPosition,
                                  wx.DefaultSize, 0)
        self.lbl1.Wrap(-1)
        fgSizer1.Add(self.lbl1, 0, wx.ALL, 5)
        self.m_staticText6 = wx.StaticText(self, wx.ID_ANY, u"Id. Producto",
                                           wx.DefaultPosition, wx.DefaultSize,
                                           0)
        self.m_staticText6.Wrap(-1)
        fgSizer1.Add(self.m_staticText6, 0, wx.ALL, 5)

        self.txt1 = wx.TextCtrl(self, wx.ID_ANY, wx.EmptyString,
                                wx.DefaultPosition, wx.DefaultSize, 0)
        fgSizer1.Add(self.txt1, 0, wx.ALL, 5)

        self.m_staticText7 = wx.StaticText(self, wx.ID_ANY, u"Descripcion",
                                           wx.DefaultPosition, wx.DefaultSize,
                                           0)
        self.m_staticText7.Wrap(-1)
        fgSizer1.Add(self.m_staticText7, 0, wx.ALL, 5)

        self.txt2 = wx.TextCtrl(self, wx.ID_ANY, wx.EmptyString,
                                wx.DefaultPosition, wx.Size(300, -1), 0)
        fgSizer1.Add(self.txt2, 0, wx.ALL, 5)

        self.m_staticText8 = wx.StaticText(self, wx.ID_ANY, u"Barcode",
                                           wx.DefaultPosition, wx.DefaultSize,
                                           0)
        self.m_staticText8.Wrap(-1)
        fgSizer1.Add(self.m_staticText8, 0, wx.ALL, 5)

        self.txt3 = wx.TextCtrl(self, wx.ID_ANY, wx.EmptyString,
                                wx.DefaultPosition, wx.Size(160, -1), 0)
        fgSizer1.Add(self.txt3, 0, wx.ALL, 5)

        self.m_staticText9 = wx.StaticText(self, wx.ID_ANY, u"Costo",
                                           wx.DefaultPosition, wx.DefaultSize,
                                           0)
        self.m_staticText9.Wrap(-1)
        fgSizer1.Add(self.m_staticText9, 0, wx.ALL, 5)

        self.txt4 = wx.TextCtrl(self, wx.ID_ANY, wx.EmptyString,
                                wx.DefaultPosition, wx.DefaultSize, 0)
        fgSizer1.Add(self.txt4, 0, wx.ALL, 5)

        self.m_staticText10 = wx.StaticText(self, wx.ID_ANY, u"Precio",
                                            wx.DefaultPosition, wx.DefaultSize,
                                            0)
        self.m_staticText10.Wrap(-1)
        fgSizer1.Add(self.m_staticText10, 0, wx.ALL, 5)

        self.txt5 = wx.TextCtrl(self, wx.ID_ANY, wx.EmptyString,
                                wx.DefaultPosition, wx.DefaultSize, 0)
        fgSizer1.Add(self.txt5, 0, wx.ALL, 5)

        self.m_staticText81 = wx.StaticText(self, wx.ID_ANY, u"Categoria",
                                            wx.DefaultPosition, wx.DefaultSize,
                                            0)
        self.m_staticText81.Wrap(-1)
        fgSizer1.Add(self.m_staticText81, 0, wx.ALL, 5)

        m_comboBox1Choices = [u"0", u"1"]
        self.m_comboBox1 = wx.ComboBox(self, wx.ID_ANY,
                                       u"Combo!", wx.DefaultPosition,
                                       wx.Size(300, -1), m_comboBox1Choices, 0)
        fgSizer1.Add(self.m_comboBox1, 0, wx.ALL, 5)

        btn2.Add(fgSizer1, 1, wx.EXPAND, 5)

        fgSizer2 = wx.FlexGridSizer(0, 3, 0, 0)
        fgSizer2.SetFlexibleDirection(wx.BOTH)
        fgSizer2.SetNonFlexibleGrowMode(wx.FLEX_GROWMODE_SPECIFIED)

        fgSizer2.Add((50, 0), 1, wx.EXPAND, 5)

        self.btn1 = wx.Button(self, wx.ID_ANY, u"Aceptar", wx.DefaultPosition,
                              wx.DefaultSize, 0)
        fgSizer2.Add(self.btn1, 0, wx.ALL, 5)

        self.btn4 = wx.Button(self, wx.ID_ANY, u"Salir", wx.DefaultPosition,
                              wx.DefaultSize, 0)
        fgSizer2.Add(self.btn4, 0, wx.ALL, 5)

        btn2.Add(fgSizer2, 1, wx.EXPAND, 5)

        self.SetSizer(btn2)
        self.Layout()

        self.Centre(wx.BOTH)

        # Connect Events
        self.btn1.Bind(wx.EVT_BUTTON, self.btnAceptar)
        self.btn4.Bind(wx.EVT_BUTTON, self.btnSalir)
        #base de datos
        self.db = mysqlclass3.Database(
            "ventas")  #Instanciar la conexion a la Bd.
        #Evento mostrar datos

        #MODAL PARA mensajes
        self.dial = wx.MessageDialog(None, 'CONSULTA CORRECTA', 'Info',
                                     wx.OK | wx.CENTRE)
コード例 #4
0
ファイル: categorias.py プロジェクト: liluisjose1/Simulacion
    def __init__(self, parent):
        wx.Dialog.__init__(self,
                           parent,
                           id=wx.ID_ANY,
                           title=wx.EmptyString,
                           pos=wx.DefaultPosition,
                           size=wx.Size(376, 189),
                           style=wx.DEFAULT_DIALOG_STYLE)
        self.frm_padre = parent
        #self.SetSizeHints( wx.DefaultSize, wx.DefaultSize )

        fgSizer1 = wx.FlexGridSizer(5, 3, 0, 0)
        fgSizer1.SetFlexibleDirection(wx.BOTH)
        fgSizer1.SetNonFlexibleGrowMode(wx.FLEX_GROWMODE_SPECIFIED)

        fgSizer1.Add((10, 0), 1, wx.EXPAND, 5)

        self.lbl1 = wx.StaticText(self, wx.ID_ANY, wx.EmptyString,
                                  wx.DefaultPosition, wx.DefaultSize, 0)
        self.lbl1.Wrap(-1)
        fgSizer1.Add(self.lbl1, 0, wx.ALL, 5)

        fgSizer1.Add((10, 0), 1, wx.EXPAND, 5)

        fgSizer1.Add((10, 0), 1, wx.EXPAND, 5)

        self.m_staticText1 = wx.StaticText(self, wx.ID_ANY, u"id Categoria",
                                           wx.DefaultPosition, wx.DefaultSize,
                                           0)
        self.m_staticText1.Wrap(-1)
        fgSizer1.Add(self.m_staticText1, 0, wx.ALL, 5)

        self.m_textCtrl1 = wx.TextCtrl(self, wx.ID_ANY, wx.EmptyString,
                                       wx.DefaultPosition, wx.DefaultSize, 0)
        fgSizer1.Add(self.m_textCtrl1, 0, wx.ALL, 5)

        fgSizer1.Add((10, 0), 1, wx.EXPAND, 5)

        self.m_staticText11 = wx.StaticText(self, wx.ID_ANY, u"Nombre",
                                            wx.DefaultPosition, wx.DefaultSize,
                                            0)
        self.m_staticText11.Wrap(-1)
        fgSizer1.Add(self.m_staticText11, 0, wx.ALL, 5)

        self.m_textCtrl2 = wx.TextCtrl(self, wx.ID_ANY, wx.EmptyString,
                                       wx.DefaultPosition, wx.Size(200, -1), 0)
        fgSizer1.Add(self.m_textCtrl2, 0, wx.ALL, 5)

        fgSizer1.Add((10, 0), 1, wx.EXPAND, 5)

        self.m_button1 = wx.Button(self, wx.ID_ANY, u"Guardar",
                                   wx.DefaultPosition, wx.DefaultSize, 0)
        fgSizer1.Add(self.m_button1, 0, wx.ALL, 5)

        self.m_button11 = wx.Button(self, wx.ID_ANY, u"Salir",
                                    wx.DefaultPosition, wx.DefaultSize, 0)
        fgSizer1.Add(self.m_button11, 0, wx.ALL, 5)

        self.SetSizer(fgSizer1)
        self.Layout()
        #self.id_producto=''
        self.Centre(wx.BOTH)
        self.db = mysqlclass3.Database(
            "ventas")  #Instanciar la conexion a la Bd.
        # Connect Events
        self.m_button1.Bind(wx.EVT_BUTTON, self.Guardar)
        self.m_button11.Bind(wx.EVT_BUTTON, self.Salir)
        #MODAL PARA mensajes
        self.dial = wx.MessageDialog(None, 'EXITO', 'Info', wx.OK | wx.CENTRE)
コード例 #5
0
ファイル: mysql5.py プロジェクト: liluisjose1/Simulacion
 def __init__( self, parent ):
     wx.Dialog.__init__ ( self, parent, id = wx.ID_ANY, title = wx.EmptyString, pos = wx.DefaultPosition, size = wx.Size( 556,98 ), style = wx.DEFAULT_DIALOG_STYLE )
     self.frm_padre=parent
     #self.SetSizeHints( wx.DefaultSize, wx.DefaultSize )
     
     fgSizer1 = wx.FlexGridSizer( 3, 3, 0, 0 )
     fgSizer1.SetFlexibleDirection( wx.BOTH )
     fgSizer1.SetNonFlexibleGrowMode( wx.FLEX_GROWMODE_SPECIFIED )
     
     
     fgSizer1.Add( ( 20, 20), 1, wx.EXPAND, 5 )
     
     
     fgSizer1.Add( ( 20, 20), 1, wx.EXPAND, 5 )
     
     
     fgSizer1.Add( ( 20, 20), 1, wx.EXPAND, 5 )
     
     bSizer1 = wx.BoxSizer( wx.HORIZONTAL )
     
     
     bSizer1.Add( ( 30, 30), 1, wx.EXPAND, 5 )
     
     self.m_staticText1 = wx.StaticText( self, wx.ID_ANY, u"Seguro que deseas eliminar id", wx.DefaultPosition, wx.DefaultSize, 0 )
     self.m_staticText1.Wrap( -1 )
     bSizer1.Add( self.m_staticText1, 0, wx.ALL, 5 )
     
     self.m_textCtrl1 = wx.TextCtrl( self, wx.ID_ANY, wx.EmptyString, wx.DefaultPosition, wx.DefaultSize, 0 )
     bSizer1.Add( self.m_textCtrl1, 0, wx.ALL, 5 )
     
     
     bSizer1.Add( ( 30, 30), 1, wx.EXPAND, 5 )
     
     
     fgSizer1.Add( bSizer1, 1, wx.EXPAND, 5 )
     
     bSizer2 = wx.BoxSizer( wx.HORIZONTAL )
     
     self.m_button1 = wx.Button( self, wx.ID_ANY, u"Aceptar", wx.DefaultPosition, wx.DefaultSize, 0 )
     bSizer2.Add( self.m_button1, 0, wx.ALL, 5 )
     
     self.m_button2 = wx.Button( self, wx.ID_ANY, u"Cerrar", wx.DefaultPosition, wx.DefaultSize, 0 )
     bSizer2.Add( self.m_button2, 0, wx.ALL, 5 )
     
     
     fgSizer1.Add( bSizer2, 1, wx.EXPAND, 5 )
     
     
     self.SetSizer( fgSizer1 )
     self.Layout()
     
     self.Centre( wx.BOTH )
     # Connect Events
     self.m_button1.Bind( wx.EVT_BUTTON, self.Aceptar )
     self.m_button2.Bind( wx.EVT_BUTTON, self.Cerrar )
     #base de datos
     self.db = mysqlclass3.Database("ventas") #Instanciar la conexion a la Bd.
     #Evento mostrar datos
     
     #MODAL PARA mensajes
     self.dial = wx.MessageDialog(None, 'Eliminado con exito', 'Info', wx.OK|wx.CENTRE)