def getPersonID(self, event):
self.m_staticText1.SetLabel(u'Edytowanie Autora')
t = self.m_choice1.GetStringSelection()
a = cDatabase.getUserNameID(self.session)
self.tmp = a[t]
data = cDatabase.getUserDialog(self.session, self.tmp)
"""Dodaje wszystkie nazwy uczelni i ustawia wartość z wybranego rekordu"""
m_comboBox1Choices = cDatabase.getCollegeName(self.session)
self.m_comboBox1.Clear()
self.m_comboBox1.AppendItems(m_comboBox1Choices)
self.m_comboBox1.SetValue(data[0])
"""Dodaje wszystkie nazwy wydziałów i ustawia wartość z wybranego rekordu"""
m_comboBox2Choices = cDatabase.getFacultyName(self.session)
self.m_comboBox2.Clear()
self.m_comboBox2.AppendItems(m_comboBox2Choices)
self.m_comboBox2.SetValue(data[1])
"""Dodaje wszystkie nazwy instytutów i ustawia wartość z wybranego rekordu"""
m_comboBox3Choices = cDatabase.getInstituteName(self.session)
self.m_comboBox3.Clear()
self.m_comboBox3.AppendItems(m_comboBox3Choices)
self.m_comboBox3.SetValue(data[2])
self.m_textCtrl3.SetValue(data[3])
self.m_textCtrl4.SetValue(data[4])
self.m_textCtrl41.SetValue(data[5])
self.m_textCtrl2.SetValue(str(data[6]))
self.m_button1.Show()
self.m_button7.Show()
self.m_button2.Hide()
def clear(self):
"""Aktualizacja kontrolki z nazwami uczelni"""
m_comboBox1Choices = cDatabase.getCollegeName(self.session)
self.m_comboBox1.Clear()
self.m_comboBox1.AppendItems(m_comboBox1Choices)
# self.cb1.SetSelection( 0 )
"""Aktualizacja kontrolki z nazwami wydziałów"""
m_comboBox2Choices = cDatabase.getFacultyName(self.session)
self.m_comboBox2.Clear()
self.m_comboBox2.AppendItems(m_comboBox2Choices)
# self.cb2.SetSelection( 0 )
"""Aktualizacja kontrolki z nazwami instytutów"""
m_comboBox3Choices = cDatabase.getInstituteName(self.session)
self.m_comboBox3.Clear()
self.m_comboBox3.AppendItems(m_comboBox3Choices)
# self.cb3.SetSelection( 0 )
self.m_textCtrl3.SetValue('')
self.m_textCtrl4.SetValue('')
self.m_textCtrl41.SetValue('')
self.m_textCtrl2.SetValue('')
def __init__( self ):
wx.Dialog.__init__ ( self, None, id = wx.ID_ANY, title = u"Zarządzanie Autorami", pos = wx.DefaultPosition, size = wx.Size( 350,330 ), style = wx.DEFAULT_DIALOG_STYLE )
self.session = cDatabase.connectDatabase()
ico = wx.Icon('icon/autor.ico', wx.BITMAP_TYPE_ICO)
self.SetIcon(ico)
self.SetSizeHintsSz( wx.DefaultSize, wx.DefaultSize )
bSizer1 = wx.BoxSizer( wx.VERTICAL )
bSizer2 = wx.BoxSizer( wx.VERTICAL )
# self.st1 =
self.m_staticText1 = wx.StaticText( self, wx.ID_ANY, u"Dodawanie Autora", wx.DefaultPosition, wx.DefaultSize, wx.ALIGN_CENTRE|wx.ST_NO_AUTORESIZE )
self.m_staticText1.Wrap( -1 )
bSizer2.Add( self.m_staticText1, 0, wx.EXPAND|wx.ALL, 5 )
bSizer1.Add( bSizer2, 0, wx.EXPAND, 5 )
bSizer3 = wx.BoxSizer( wx.VERTICAL )
bSizer9 = wx.BoxSizer( wx.HORIZONTAL )
self.m_staticText2 = wx.StaticText( self, wx.ID_ANY, u"Edytuj Autora:", wx.DefaultPosition, wx.DefaultSize, 0 )
self.m_staticText2.Wrap( -1 )
bSizer9.Add( self.m_staticText2, 1, wx.ALL, 5 )
self.m_choice1Choices = cDatabase.getUserName(self.session)
self.m_choice1 = wx.Choice( self, wx.ID_ANY, wx.DefaultPosition, wx.Size( 220,-1 ), self.m_choice1Choices, 0 )
# self.m_choice1.SetSelection( 0 )
bSizer9.Add( self.m_choice1, 0, wx.BOTTOM|wx.RIGHT|wx.LEFT, 5 )
bSizer3.Add( bSizer9, 1, wx.EXPAND, 5 )
# bSizer111 = wx.BoxSizer( wx.VERTICAL )
#
# self.m_button6 = wx.Button( self, wx.ID_ANY, u"Wybierz", wx.DefaultPosition, wx.DefaultSize, 0 )
# bSizer111.Add( self.m_button6, 0, wx.ALIGN_RIGHT|wx.BOTTOM|wx.RIGHT|wx.LEFT, 5 )
#
#
# bSizer3.Add( bSizer111, 1, wx.EXPAND, 5 )
bSizer1.Add( bSizer3, 0, wx.EXPAND|wx.ALIGN_CENTER_HORIZONTAL, 5 )
bSizer13 = wx.BoxSizer( wx.HORIZONTAL )
self.m_staticText6 = wx.StaticText( self, wx.ID_ANY, u"Afiliacja:", wx.DefaultPosition, wx.DefaultSize, 0 )
self.m_staticText6.Wrap( -1 )
bSizer13.Add( self.m_staticText6, 1, wx.ALL, 5 )
m_comboBox1Choices = cDatabase.getCollegeName(self.session)
self.m_comboBox1 = wx.ComboBox( self, wx.ID_ANY, wx.EmptyString, wx.DefaultPosition, wx.Size( 220,-1 ), m_comboBox1Choices, 0 )
bSizer13.Add( self.m_comboBox1, 0, wx.BOTTOM|wx.RIGHT|wx.LEFT, 5 )
bSizer1.Add( bSizer13, 0, wx.EXPAND, 5 )
bSizer16 = wx.BoxSizer( wx.HORIZONTAL )
self.m_staticText7 = wx.StaticText( self, wx.ID_ANY, u"Wydział/Dział:", wx.DefaultPosition, wx.DefaultSize, 0 )
self.m_staticText7.Wrap( -1 )
bSizer16.Add( self.m_staticText7, 1, wx.ALL, 5 )
m_comboBox2Choices = cDatabase.getFacultyName(self.session)
self.m_comboBox2 = wx.ComboBox( self, wx.ID_ANY, wx.EmptyString, wx.DefaultPosition, wx.Size( 220,-1 ), m_comboBox2Choices, 0 )
bSizer16.Add( self.m_comboBox2, 0, wx.BOTTOM|wx.RIGHT|wx.LEFT, 5 )
bSizer1.Add( bSizer16, 0, wx.EXPAND, 5 )
bSizer17 = wx.BoxSizer( wx.HORIZONTAL )
self.m_staticText8 = wx.StaticText( self, wx.ID_ANY, u"Instytut/Stanowisko:", wx.DefaultPosition, wx.DefaultSize, 0 )
self.m_staticText8.Wrap( -1 )
bSizer17.Add( self.m_staticText8, 1, wx.ALL, 5 )
m_comboBox3Choices = cDatabase.getInstituteName(self.session)
self.m_comboBox3 = wx.ComboBox( self, wx.ID_ANY, wx.EmptyString, wx.DefaultPosition, wx.Size( 220,-1 ), m_comboBox3Choices, 0 )
bSizer17.Add( self.m_comboBox3, 0, wx.BOTTOM|wx.RIGHT|wx.LEFT, 5 )
bSizer1.Add( bSizer17, 0, wx.EXPAND, 5 )
bSizer4 = wx.BoxSizer( wx.HORIZONTAL )
self.m_staticText3 = wx.StaticText( self, wx.ID_ANY, u"Imię:", wx.DefaultPosition, wx.DefaultSize, 0 )
self.m_staticText3.Wrap( -1 )
bSizer4.Add( self.m_staticText3, 1, wx.ALL, 5 )
self.m_textCtrl3 = wx.TextCtrl( self, wx.ID_ANY, wx.EmptyString, wx.DefaultPosition, wx.Size( 220,-1 ), 0 )
bSizer4.Add( self.m_textCtrl3, 0, wx.BOTTOM|wx.RIGHT|wx.LEFT, 5 )
bSizer1.Add( bSizer4, 0, wx.ALIGN_CENTER_HORIZONTAL|wx.EXPAND, 5 )
bSizer5 = wx.BoxSizer( wx.HORIZONTAL )
self.m_staticText4 = wx.StaticText( self, wx.ID_ANY, u"Nazwisko:", wx.DefaultPosition, wx.DefaultSize, 0 )
self.m_staticText4.Wrap( -1 )
bSizer5.Add( self.m_staticText4, 1, wx.ALL, 5 )
self.m_textCtrl4 = wx.TextCtrl( self, wx.ID_ANY, wx.EmptyString, wx.DefaultPosition, wx.Size( 220,-1 ), 0 )
bSizer5.Add( self.m_textCtrl4, 0, wx.BOTTOM|wx.RIGHT|wx.LEFT, 5 )
bSizer1.Add( bSizer5, 0, wx.EXPAND, 5 )
bSizer12 = wx.BoxSizer( wx.HORIZONTAL )
self.m_staticText5 = wx.StaticText( self, wx.ID_ANY, u"Filtr:", wx.DefaultPosition, wx.DefaultSize, 0 )
self.m_staticText5.Wrap( -1 )
bSizer12.Add( self.m_staticText5, 1, wx.ALL, 5 )
self.m_textCtrl41 = wx.TextCtrl( self, wx.ID_ANY, wx.EmptyString, wx.DefaultPosition, wx.Size( 220,-1 ), 0 )
self.m_textCtrl41.SetToolTipString( u"Format filtru: A Wójcik, A Wojcik, A WOJCIK" )
bSizer12.Add( self.m_textCtrl41, 0, wx.BOTTOM|wx.RIGHT|wx.LEFT, 5 )
bSizer1.Add( bSizer12, 0, wx.EXPAND, 5 )
bSizer55 = wx.BoxSizer( wx.HORIZONTAL )
# self.m_staticText55 = wx.StaticText( self, wx.ID_ANY, u"Notatki:", wx.DefaultPosition, wx.DefaultSize, 0 )
# self.m_staticText55.Wrap( -1 )
# bSizer55.Add( self.m_staticText55, 1, wx.ALL, 5 )
self.m_textCtrl2 = wx.TextCtrl( self, wx.ID_ANY, wx.EmptyString, wx.DefaultPosition, wx.Size( -1,50 ), wx.TE_MULTILINE )
self.m_textCtrl2.SetToolTipString( u"Notatki do autora" )
bSizer55.Add( self.m_textCtrl2, 1, wx.ALL|wx.EXPAND, 5 )
bSizer1.Add( bSizer55, 0, wx.EXPAND, 5 )
bSizer11 = wx.BoxSizer( wx.HORIZONTAL )
self.m_button2 = wx.Button( self, wx.ID_ANY, u"Dodaj", wx.DefaultPosition, wx.DefaultSize, 0 )
bSizer11.Add( self.m_button2, 0, wx.EXPAND|wx.ALL, 5 )
self.m_button1 = wx.Button( self, wx.ID_ANY, u"Zatwierdź", wx.DefaultPosition, wx.DefaultSize, 0 )
bSizer11.Add( self.m_button1, 0, wx.EXPAND|wx.ALL, 5 )
self.m_button7 = wx.Button( self, wx.ID_ANY, u"Usuń", wx.DefaultPosition, wx.DefaultSize, 0 )
bSizer11.Add( self.m_button7, 0, wx.RIGHT|wx.ALL, 5 )
self.m_button4 = wx.Button( self, wx.ID_ANY, u"Anuluj", wx.DefaultPosition, wx.DefaultSize, 0 )
bSizer11.Add( self.m_button4, 0, wx.RIGHT|wx.ALL, 5 )
bSizer1.Add( bSizer11, 0, wx.ALIGN_RIGHT, 5 )
self.SetSizer( bSizer1 )
self.Layout()
self.Centre( wx.BOTH )
self.m_button1.Hide()
self.m_button7.Hide()
###################################################
## Bind
###################################################
# self.m_button6.Bind(wx.EVT_BUTTON, self.getPersonID)
self.m_button1.Bind(wx.EVT_BUTTON, self.editPersonID)
self.m_button2.Bind(wx.EVT_BUTTON, self.getUserData)
self.m_button4.Bind(wx.EVT_BUTTON, self.cancel)
self.m_button7.Bind(wx.EVT_BUTTON, self.deletePerson)
self.m_choice1.Bind(wx.EVT_CHOICE, self.getPersonID)
