Esempio n. 1
0
    def gethandler(self, prg):
        print(prg)
        getdata = MS.GetData(u'Menu2.db', u'')
        if prg == '':
            return 10001
        hdrid, mbrid = getdata.getHndlr(prg)[0]

        print(hdrid, mbrid)
        mdir = getdata.gethddir(mbrid)
        print(mdir)
        return int(hdrid)
Esempio n. 2
0
 def __init__(self):
     self.MySql = MS.GetData(u'Menu2.db', u'')
     self.ToSql = MS.SetData(u'', u'',u'')
Esempio n. 3
0
    def Doit(self, event):
        getdata = MS.GetData(u'Menu2.db', u'')
        setdata = MS.SetData(u'toolbar', u'', u'')
        chkdata = getdata.GetAllTB()
        thsdata = self.getData()
        print(thsdata)
        if self.Button == "Add":
            if getdata.GetAllTB(u"where toolid = %s " % int(thsdata[0])) != []:
                wx.MessageBox(u"you must use a new code please change id")
            elif int(thsdata[0]) // 100 != self.m_spinCtrlDouble1.GetValue():
                wx.MessageBox(
                    u"your first number of code must equal with group ")
            else:
                icn = thsdata[6].split("\\")[-1]
                ihd = self.gethandler(thsdata[7].split("\\")[-1].replace(
                    ".py", ''))

                Data = [
                    int(thsdata[0]), thsdata[2], icn, thsdata[3], thsdata[4],
                    ihd, thsdata[1]
                ]
                setdata.Additem(
                    u'toolid, toolname, toolicon, shrttxt, lngtxt, handlerid, acclvlid',
                    Data)
                setdata.Table = u'access'
                if thsdata[8]:
                    disen = 0
                else:
                    disen = 1
                if thsdata[9]:
                    shwid = '0000'
                else:
                    shwid = 'FFFF'
                Data2 = [thsdata[1], 1, shwid, disen]
                setdata.Additem(u'acclvlid, userid, acclvl, disenable', Data2)
                wx.MessageBox(u"successful add Toolbar to program")

                self.AddTool(thsdata)

                ml = self.GetGrandParent()
                ml.TTC1.DeleteAllItems()
                ml.fillitem()
                ml.Refresh()

                q = self.GetParent()
                q.Close()

        elif self.Button == u"Edit":
            icn = thsdata[6].split("\\")[-1]
            ihd = self.gethandler(thsdata[7].split("\\")[-1].replace(
                ".py", ''))
            Data3 = [thsdata[2], icn, thsdata[3], thsdata[4], ihd, thsdata[1]]
            setdata.Upditem(
                u'toolname = ? , toolicon = ? , shrttxt = ? , lngtxt = ? , handlerid = ? , acclvlid = ? where  toolid = %d '
                % int(thsdata[0]), Data3)
            if thsdata[8]:
                disen = 0
            else:
                disen = 1
            if thsdata[9]:
                shwid = '0000'
            else:
                shwid = 'FFFF'
            Data4 = [1, shwid, disen]
            setdata.Table = u'access'
            setdata.Upditem(
                u'userid = ? , acclvl = ?, disenable = ? where acclvlid = "%s" '
                % thsdata[1], Data4)
            ml = self.GetGrandParent()
            ml.TTC1.DeleteAllItems()
            ml.fillitem()
            ml.Refresh()
            q = self.GetParent()
            q.Close()

        elif self.Button == u"Delete":
            setdata.Delitem(u"toolbar.toolid = %d " % int(thsdata[0]))
            setdata.Table = u"access"
            setdata.Delitem(u'access.acclvlid = "%s" ' % thsdata[1])
            ml = self.GetGrandParent()
            ml.TTC1.DeleteAllItems()
            ml.fillitem()
            ml.Refresh()
            self.DelTool(thsdata)
            q = self.GetParent()
            q.Close()

        else:
            print(u'some error here')
        event.Skip()
Esempio n. 4
0
    def __init__(self,
                 parent,
                 id=wx.ID_ANY,
                 pos=wx.DefaultPosition,
                 size=wx.Size(500, 300),
                 style=wx.TAB_TRAVERSAL,
                 name=wx.EmptyString):
        wx.Panel.__init__(self,
                          parent,
                          id=id,
                          pos=pos,
                          size=size,
                          style=style,
                          name=name)

        Vsz1 = wx.BoxSizer(wx.VERTICAL)

        Hsz1 = wx.BoxSizer(wx.HORIZONTAL)

        #self.TTC1 = wx.TreeCtrl( self, wx.ID_ANY, wx.DefaultPosition, wx.DefaultSize, wx.TR_DEFAULT_STYLE )
        #Hsz1.Add( self.TTC1, 1, wx.ALL|wx.EXPAND, 5 )
        self.TTC1 = dv.TreeListCtrl(self, wx.ID_ANY, wx.DefaultPosition,
                                    wx.DefaultSize, wx.TR_DEFAULT_STYLE)
        self.TTC1.AppendColumn(u'ID', wx.COL_WIDTH_DEFAULT, wx.ALIGN_LEFT,
                               wx.COL_RESIZABLE)
        self.TTC1.AppendColumn(u'Name', wx.COL_WIDTH_DEFAULT, wx.ALIGN_LEFT,
                               wx.COL_RESIZABLE)
        self.TTC1.AppendColumn(u'Help', wx.COL_WIDTH_DEFAULT, wx.ALIGN_LEFT,
                               wx.COL_RESIZABLE)
        self.TTC1.AppendColumn(u'Program', wx.COL_WIDTH_DEFAULT, wx.ALIGN_LEFT,
                               wx.COL_RESIZABLE)
        Hsz1.Add(self.TTC1, 1, wx.ALL | wx.EXPAND, 5)

        self.MyMenu = MS.GetData(u'Menu2.db', u'')
        self.DoMenu = MS.SetData(u'', u'', u'')

        self.fillitem()

        Vsz1.Add(Hsz1, 1, wx.EXPAND, 5)

        Hsz2 = wx.BoxSizer(wx.HORIZONTAL)

        self.btnadd = wx.Button(self, wx.ID_ANY, u"Add", wx.DefaultPosition,
                                wx.DefaultSize, 0)
        Hsz2.Add(self.btnadd, 0, wx.ALL, 5)

        self.btnedt = wx.Button(self, wx.ID_ANY, u"Edit", wx.DefaultPosition,
                                wx.DefaultSize, 0)
        Hsz2.Add(self.btnedt, 0, wx.ALL, 5)

        self.btndel = wx.Button(self, wx.ID_ANY, u"Delete", wx.DefaultPosition,
                                wx.DefaultSize, 0)
        Hsz2.Add(self.btndel, 0, wx.ALL, 5)

        Vsz1.Add(Hsz2, 0, wx.ALIGN_CENTER_HORIZONTAL, 5)

        self.SetSizer(Vsz1)
        self.Layout()

        # Connect Events
        self.TTC1.Bind(dv.EVT_TREELIST_ITEM_ACTIVATED, self.actitm)
        self.TTC1.Bind(dv.EVT_TREELIST_ITEM_CHECKED, self.actitm)
        self.TTC1.Bind(wx.EVT_TREE_ITEM_RIGHT_CLICK, self.rclkitm)
        self.btndel.Bind(wx.EVT_BUTTON, self.deltol)
        self.btnedt.Bind(wx.EVT_BUTTON, self.edttol)
        self.btnadd.Bind(wx.EVT_BUTTON, self.addtol)
Esempio n. 5
0
    def __init__(self,
                 parent,
                 id=wx.ID_ANY,
                 pos=wx.DefaultPosition,
                 size=wx.Size(500, 400),
                 style=wx.TAB_TRAVERSAL,
                 name=wx.EmptyString):
        wx.Panel.__init__(self,
                          parent,
                          id=id,
                          pos=pos,
                          size=size,
                          style=style,
                          name=name)

        Vsz1 = wx.BoxSizer(wx.VERTICAL)

        Hsz1 = wx.BoxSizer(wx.HORIZONTAL)

        GetData = MS.GetData(u'Menu2.db', u'')
        mjoin = """ left join mitem on handler.handlerid = mitem.handlerid \
                    left join menubar on mitem.mbarid = menubar.mbarid """
        self.mylist = GetData.AllHndl(ext=mjoin +
                                      " where handler.handlerid < 99000 ")
        print(self.mylist)

        self.Title = wx.StaticText(self, wx.ID_ANY,
                                   u"List of Program in Application ",
                                   wx.DefaultPosition, wx.DefaultSize, 0)
        self.Title.Wrap(-1)

        Hsz1.Add(self.Title, 0, wx.ALL, 5)

        Vsz1.Add(Hsz1, 0, wx.EXPAND, 5)

        Hsz2 = wx.BoxSizer(wx.HORIZONTAL)

        Vsz2 = wx.BoxSizer(wx.VERTICAL)

        LPro1Choices = [i[1] for i in self.mylist]
        self.LPro1 = wx.ListBox(self, wx.ID_ANY, wx.DefaultPosition,
                                wx.DefaultSize, LPro1Choices, wx.LB_ALWAYS_SB)
        Vsz2.Add(self.LPro1, 1, wx.ALL, 5)

        Hsz2.Add(Vsz2, 1, wx.EXPAND, 5)

        Vsz3 = wx.BoxSizer(wx.VERTICAL)

        Hsz10 = wx.BoxSizer(wx.HORIZONTAL)

        self.txt1 = wx.StaticText(self, wx.ID_ANY, u"Id No.",
                                  wx.DefaultPosition, wx.DefaultSize, 0)
        self.txt1.Wrap(-1)

        Hsz10.Add(self.txt1, 1, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.fld1 = wx.TextCtrl(self, wx.ID_ANY, wx.EmptyString,
                                wx.DefaultPosition, wx.DefaultSize, 0)
        Hsz10.Add(self.fld1, 1, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.txt2 = wx.StaticText(self, wx.ID_ANY, u"Prog. No.",
                                  wx.DefaultPosition, wx.DefaultSize, 0)
        self.txt2.Wrap(-1)

        Hsz10.Add(self.txt2, 1, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.fld2 = wx.TextCtrl(self, wx.ID_ANY, wx.EmptyString,
                                wx.DefaultPosition, wx.DefaultSize, 0)
        Hsz10.Add(self.fld2, 1, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        Vsz3.Add(Hsz10, 0, wx.EXPAND, 5)

        Hsz11 = wx.BoxSizer(wx.HORIZONTAL)

        self.txt3 = wx.StaticText(self, wx.ID_ANY, u"Do name",
                                  wx.DefaultPosition, wx.DefaultSize, 0)
        self.txt3.Wrap(-1)

        Hsz11.Add(self.txt3, 0, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.fld3 = wx.TextCtrl(self, wx.ID_ANY, wx.EmptyString,
                                wx.DefaultPosition, wx.DefaultSize, 0)
        Hsz11.Add(self.fld3, 1,
                  wx.ALIGN_CENTER_VERTICAL | wx.TOP | wx.BOTTOM | wx.LEFT, 5)

        self.prw = wx.Button(self, wx.ID_ANY, u"...", wx.DefaultPosition,
                             wx.DefaultSize, wx.BU_EXACTFIT)
        self.prw.SetToolTip(u"Preview")

        Hsz11.Add(self.prw, 0, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        Vsz3.Add(Hsz11, 0, wx.EXPAND, 5)

        Hsz12 = wx.BoxSizer(wx.HORIZONTAL)

        self.txt4 = wx.StaticText(self, wx.ID_ANY, u"Directory",
                                  wx.DefaultPosition, wx.DefaultSize, 0)
        self.txt4.Wrap(-1)

        Hsz12.Add(self.txt4, 0, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.fdir = wx.DirPickerCtrl(self, wx.ID_ANY, wx.EmptyString,
                                     u"Select a folder", wx.DefaultPosition,
                                     wx.DefaultSize,
                                     wx.DIRP_DEFAULT_STYLE | wx.DIRP_SMALL)
        self.fdir.SetToolTip(u"Browse")

        Hsz12.Add(self.fdir, 1, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        Vsz3.Add(Hsz12, 0, wx.EXPAND, 5)

        Hsz13 = wx.BoxSizer(wx.HORIZONTAL)

        self.txt5 = wx.StaticText(self, wx.ID_ANY, u"Parameters",
                                  wx.DefaultPosition, wx.DefaultSize, 0)
        self.txt5.Wrap(-1)

        Hsz13.Add(self.txt5, 0, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.fld5 = wx.TextCtrl(self, wx.ID_ANY, wx.EmptyString,
                                wx.DefaultPosition, wx.DefaultSize, 0)
        Hsz13.Add(self.fld5, 1, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        Vsz3.Add(Hsz13, 0, wx.EXPAND, 5)

        Hsz14 = wx.BoxSizer(wx.HORIZONTAL)

        self.box1 = wx.CheckBox(self, wx.ID_ANY, u"Public it",
                                wx.DefaultPosition, wx.DefaultSize, 0)
        Hsz14.Add(self.box1, 0, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.txt6 = wx.StaticText(self, wx.ID_ANY, u"Link:",
                                  wx.DefaultPosition, wx.DefaultSize, 0)
        self.txt6.Wrap(-1)

        Hsz14.Add(self.txt6, 0, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.fld6 = wx.TextCtrl(self, wx.ID_ANY, wx.EmptyString,
                                wx.DefaultPosition, wx.DefaultSize, 0)
        Hsz14.Add(self.fld6, 1, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        Vsz3.Add(Hsz14, 0, wx.EXPAND, 5)

        Hsz15 = wx.BoxSizer(wx.HORIZONTAL)

        self.btn1 = wx.Button(self, wx.ID_ANY, u"Open Edit",
                              wx.DefaultPosition, wx.DefaultSize, 0)
        Hsz15.Add(self.btn1, 0, wx.ALL, 5)

        self.btn2 = wx.Button(self, wx.ID_ANY, u"Add New", wx.DefaultPosition,
                              wx.DefaultSize, 0)
        Hsz15.Add(self.btn2, 0, wx.ALL, 5)

        self.btn3 = wx.Button(self, wx.ID_ANY, u"Delete", wx.DefaultPosition,
                              wx.DefaultSize, 0)
        Hsz15.Add(self.btn3, 0, wx.ALL, 5)

        Vsz3.Add(Hsz15, 0, wx.EXPAND, 5)

        Hsz2.Add(Vsz3, 1, wx.EXPAND, 5)

        Vsz1.Add(Hsz2, 1, wx.EXPAND, 5)

        Vsz4 = wx.BoxSizer(wx.VERTICAL)

        self.lin1 = wx.StaticLine(self, wx.ID_ANY, wx.DefaultPosition,
                                  wx.DefaultSize, wx.LI_HORIZONTAL)
        Vsz4.Add(self.lin1, 0, wx.EXPAND | wx.ALL, 5)

        Vsz1.Add(Vsz4, 0, wx.EXPAND, 5)

        Hsz3 = wx.BoxSizer(wx.HORIZONTAL)

        self.btn4 = wx.Button(self, wx.ID_ANY, u"Open", wx.DefaultPosition,
                              wx.DefaultSize, 0)
        self.btn4.SetToolTip(u"Open Database")

        Hsz3.Add(self.btn4, 0, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.btn5 = wx.Button(self, wx.ID_ANY, u"New", wx.DefaultPosition,
                              wx.DefaultSize, 0)
        self.btn5.SetToolTip(u"New Database")

        Hsz3.Add(self.btn5, 0, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.txt7 = wx.StaticText(self, wx.ID_ANY, u"Tabels Used",
                                  wx.DefaultPosition, wx.DefaultSize, 0)
        self.txt7.Wrap(-1)

        Hsz3.Add(self.txt7, 0, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.tbls = wx.TextCtrl(self, wx.ID_ANY, wx.EmptyString,
                                wx.DefaultPosition, wx.DefaultSize, 0)
        Hsz3.Add(self.tbls, 1, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        Vsz1.Add(Hsz3, 0, wx.EXPAND, 5)

        Hsz4 = wx.BoxSizer(wx.HORIZONTAL)

        self.txt8 = wx.StaticText(self, wx.ID_ANY, u"List Fields use",
                                  wx.DefaultPosition, wx.DefaultSize, 0)
        self.txt8.Wrap(-1)

        Hsz4.Add(self.txt8, 0, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.lflds = wx.TextCtrl(self, wx.ID_ANY, wx.EmptyString,
                                 wx.DefaultPosition, wx.DefaultSize, 0)
        Hsz4.Add(self.lflds, 1, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        Vsz1.Add(Hsz4, 0, wx.EXPAND, 5)

        Hsz5 = wx.BoxSizer(wx.HORIZONTAL)

        self.txt9 = wx.StaticText(self, wx.ID_ANY, u"action type",
                                  wx.DefaultPosition, wx.DefaultSize, 0)
        self.txt9.Wrap(-1)

        Hsz5.Add(self.txt9, 0, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        actypChoices = []
        self.actyp = wx.Choice(self, wx.ID_ANY, wx.DefaultPosition,
                               wx.DefaultSize, actypChoices, 0)
        self.actyp.SetSelection(0)
        Hsz5.Add(self.actyp, 0, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        Hsz5.Add((0, 0), 1, wx.EXPAND, 5)

        self.btn6 = wx.Button(self, wx.ID_ANY, u"Setting...",
                              wx.DefaultPosition, wx.DefaultSize, 0)
        Hsz5.Add(self.btn6, 0, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        Vsz1.Add(Hsz5, 0, wx.EXPAND, 5)

        Hsz6 = wx.BoxSizer(wx.HORIZONTAL)

        Hsz6.Add((0, 0), 1, wx.EXPAND, 5)

        self.btn7 = wx.Button(self, wx.ID_ANY, u"Cancel", wx.DefaultPosition,
                              wx.DefaultSize, 0)
        Hsz6.Add(self.btn7, 0, wx.ALL, 5)

        self.btn8 = wx.Button(self, wx.ID_ANY, u"Apply", wx.DefaultPosition,
                              wx.DefaultSize, 0)
        Hsz6.Add(self.btn8, 0, wx.ALL, 5)

        Vsz1.Add(Hsz6, 0, wx.EXPAND, 5)

        self.SetSizer(Vsz1)
        self.Layout()

        # Connect Events
        self.LPro1.Bind(wx.EVT_LISTBOX, self.lstkt)
        self.LPro1.Bind(wx.EVT_LISTBOX_DCLICK, self.chkit)
        self.prw.Bind(wx.EVT_BUTTON, self.proprw)
        self.fdir.Bind(wx.EVT_DIRPICKER_CHANGED, self.chgdir)
        self.box1.Bind(wx.EVT_CHECKBOX, self.poblic)
        self.btn1.Bind(wx.EVT_BUTTON, self.opnedit)
        self.btn2.Bind(wx.EVT_BUTTON, self.addnew)
        self.btn3.Bind(wx.EVT_BUTTON, self.delpro)
        self.btn4.Bind(wx.EVT_BUTTON, self.opndata)
        self.btn5.Bind(wx.EVT_BUTTON, self.newdata)
        self.actyp.Bind(wx.EVT_CHOICE, self.chstyp)
        self.btn6.Bind(wx.EVT_BUTTON, self.sting)
        self.btn7.Bind(wx.EVT_BUTTON, self.cancl)
        self.btn8.Bind(wx.EVT_BUTTON, self.aply)
Esempio n. 6
0
    def __init__(self,
                 parent,
                 Data=[],
                 Button=u'',
                 id=wx.ID_ANY,
                 pos=wx.DefaultPosition,
                 size=wx.Size(700, 360),
                 style=wx.TAB_TRAVERSAL,
                 name=wx.EmptyString):
        wx.Panel.__init__(self,
                          parent,
                          id=id,
                          pos=pos,
                          size=size,
                          style=style,
                          name=name)

        self.Data = Data
        print(Data)
        self.Button = Button
        self.getMData = MS.GetData(u'Menu2.db', u'')
        self.setMDate = MS.SetData(u'', u'', u'')

        Vz1 = wx.BoxSizer(wx.VERTICAL)

        self.SP1 = wx.SplitterWindow(self, wx.ID_ANY, wx.DefaultPosition,
                                     wx.DefaultSize, wx.SP_3D)
        self.SP1.Bind(wx.EVT_IDLE, self.SP1OnIdle)

        self.P1 = wx.Panel(self.SP1, wx.ID_ANY, wx.DefaultPosition,
                           wx.DefaultSize, wx.BORDER_RAISED | wx.TAB_TRAVERSAL)
        Vzp1 = wx.BoxSizer(wx.VERTICAL)

        Hzp1 = wx.WrapSizer(wx.HORIZONTAL, 0)

        if Data != []:
            self.barname = self.getMData.gBarN(Data[0])[0][0]
            self.C = self.barname[0]
        else:
            self.barname = u''
            self.C = 'P'

        self.title = wx.StaticText(self.P1, wx.ID_ANY,
                                   u"Menu Bar: " + self.barname,
                                   wx.DefaultPosition, wx.DefaultSize, 0)
        self.title.Wrap(-1)

        Hzp1.Add(self.title, 1, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.txt1a = wx.StaticText(self.P1, wx.ID_ANY, u"ID",
                                   wx.DefaultPosition, wx.Size(-1, -1), 0)
        self.txt1a.Wrap(-1)

        Hzp1.Add(
            self.txt1a, 0,
            wx.ALL | wx.ALIGN_CENTER_HORIZONTAL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.fld0 = wx.TextCtrl(self.P1, wx.ID_ANY, wx.EmptyString,
                                wx.DefaultPosition, wx.Size(50, -1), 0)
        Hzp1.Add(
            self.fld0, 0,
            wx.ALL | wx.ALIGN_CENTER_HORIZONTAL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.txt1b = wx.StaticText(self.P1, wx.ID_ANY, u"Access",
                                   wx.DefaultPosition, wx.DefaultSize, 0)
        self.txt1b.Wrap(-1)

        Hzp1.Add(self.txt1b, 0, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.fld1 = wx.TextCtrl(self.P1, wx.ID_ANY, wx.EmptyString,
                                wx.DefaultPosition, wx.Size(40, -1), 0)
        Hzp1.Add(self.fld1, 0, wx.ALL, 5)

        self.btnsrc = wx.Button(self.P1, wx.ID_ANY, u"...", wx.DefaultPosition,
                                wx.DefaultSize, wx.BU_EXACTFIT)
        Hzp1.Add(self.btnsrc, 0, wx.ALL, 5)

        Vzp1.Add(Hzp1, 0, wx.EXPAND, 5)

        Hzp2 = wx.WrapSizer(wx.HORIZONTAL, 0)

        self.txt2 = wx.StaticText(self.P1, wx.ID_ANY, u"Label",
                                  wx.DefaultPosition, wx.Size(70, -1), 0)
        self.txt2.Wrap(-1)

        Hzp2.Add(
            self.txt2, 0,
            wx.ALL | wx.ALIGN_CENTER_HORIZONTAL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.fld2 = wx.TextCtrl(self.P1, wx.ID_ANY, wx.EmptyString,
                                wx.DefaultPosition, wx.DefaultSize, 0)
        Hzp2.Add(self.fld2, 1, wx.ALL, 5)

        Vzp1.Add(Hzp2, 0, wx.EXPAND, 5)

        Hzp3 = wx.WrapSizer(wx.HORIZONTAL, 0)

        self.txt3 = wx.StaticText(self.P1, wx.ID_ANY, u"Icon",
                                  wx.DefaultPosition, wx.Size(70, -1), 0)
        self.txt3.Wrap(-1)

        Hzp3.Add(
            self.txt3, 0,
            wx.ALL | wx.ALIGN_CENTER_HORIZONTAL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.fld3 = wx.FilePickerCtrl(self.P1, wx.ID_ANY, wx.EmptyString,
                                      u"Select a file", u"*.png;*.bmp;*.jpg",
                                      wx.DefaultPosition, wx.DefaultSize,
                                      wx.FLP_DEFAULT_STYLE | wx.FLP_SMALL)
        Hzp3.Add(self.fld3, 1, wx.ALL, 5)

        # self.fld3 = wx.TextCtrl( self.P1, wx.ID_ANY, wx.EmptyString, wx.DefaultPosition, wx.DefaultSize, 0 )
        # Hzp3.Add( self.fld3, 1, wx.ALL, 5 )

        # self.btnIcn = wx.Button( self.P1, wx.ID_ANY, u"...", wx.DefaultPosition, wx.DefaultSize, wx.BU_EXACTFIT )
        # Hzp3.Add( self.btnIcn, 0, wx.ALL, 5 )

        Vzp1.Add(Hzp3, 0, wx.EXPAND, 5)

        Hzp31 = wx.WrapSizer(wx.HORIZONTAL, 0)

        self.icon = wx.StaticBitmap(
            self.P1, wx.ID_ANY,
            wx.Bitmap(ICONS_PATH + u"image.png", wx.BITMAP_TYPE_ANY),
            wx.DefaultPosition, wx.DefaultSize, 0)
        Hzp31.Add(
            self.icon, 1,
            wx.ALL | wx.ALIGN_CENTER_HORIZONTAL | wx.ALIGN_CENTER_VERTICAL, 5)

        Vzp1.Add(Hzp31, 0, wx.ALIGN_CENTER_HORIZONTAL, 5)

        Hzp4 = wx.WrapSizer(wx.HORIZONTAL, 0)

        self.txt4 = wx.StaticText(self.P1, wx.ID_ANY, u"Shorcut",
                                  wx.DefaultPosition, wx.Size(70, -1), 0)
        self.txt4.Wrap(-1)

        Hzp4.Add(
            self.txt4, 0,
            wx.ALL | wx.ALIGN_CENTER_HORIZONTAL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.fld4 = wx.TextCtrl(self.P1, wx.ID_ANY, wx.EmptyString,
                                wx.DefaultPosition, wx.DefaultSize, 0)
        Hzp4.Add(self.fld4, 1, wx.ALL, 5)

        Vzp1.Add(Hzp4, 0, wx.EXPAND, 5)

        Hzp5 = wx.WrapSizer(wx.HORIZONTAL, 0)

        self.txt5 = wx.StaticText(self.P1, wx.ID_ANY, u"Help String",
                                  wx.DefaultPosition, wx.Size(70, -1), 0)
        self.txt5.Wrap(-1)

        Hzp5.Add(
            self.txt5, 0,
            wx.ALL | wx.ALIGN_CENTER_HORIZONTAL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.fld5 = wx.TextCtrl(self.P1, wx.ID_ANY, wx.EmptyString,
                                wx.DefaultPosition, wx.DefaultSize, 0)
        Hzp5.Add(self.fld5, 1, wx.ALL, 5)

        Vzp1.Add(Hzp5, 0, wx.EXPAND, 5)

        Hzp6 = wx.WrapSizer(wx.HORIZONTAL, 0)

        self.txt6 = wx.StaticText(self.P1, wx.ID_ANY, u"Status",
                                  wx.DefaultPosition, wx.Size(70, -1), 0)
        self.txt6.Wrap(-1)

        Hzp6.Add(
            self.txt6, 0,
            wx.ALL | wx.ALIGN_CENTER_HORIZONTAL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.fld6 = wx.TextCtrl(self.P1, wx.ID_ANY, wx.EmptyString,
                                wx.DefaultPosition, wx.DefaultSize, 0)
        Hzp6.Add(self.fld6, 1, wx.ALL, 5)

        Vzp1.Add(Hzp6, 0, wx.EXPAND, 5)

        Hzp7 = wx.WrapSizer(wx.HORIZONTAL, wx.WRAPSIZER_DEFAULT_FLAGS)

        self.txt7 = wx.StaticText(self.P1, wx.ID_ANY, u"Type:",
                                  wx.DefaultPosition, wx.Size(50, -1), 0)
        self.txt7.Wrap(-1)

        Hzp7.Add(self.txt7, 0, wx.ALL, 5)

        self.rBtn1 = wx.RadioButton(self.P1, wx.ID_ANY, u"Normal",
                                    wx.DefaultPosition, wx.DefaultSize, 0)
        Hzp7.Add(self.rBtn1, 0, wx.ALL, 5)

        self.rBtn2 = wx.RadioButton(self.P1, wx.ID_ANY, u"Check",
                                    wx.DefaultPosition, wx.DefaultSize, 0)
        Hzp7.Add(self.rBtn2, 0, wx.ALL, 5)

        self.rBtn3 = wx.RadioButton(self.P1, wx.ID_ANY, u"Radio",
                                    wx.DefaultPosition, wx.DefaultSize, 0)
        Hzp7.Add(self.rBtn3, 0, wx.ALL, 5)

        self.rBtn4 = wx.RadioButton(self.P1, wx.ID_ANY, u"SubMenu",
                                    wx.DefaultPosition, wx.DefaultSize, 0)
        Hzp7.Add(self.rBtn4, 0, wx.ALL, 5)

        Vzp1.Add(Hzp7, 0, wx.EXPAND, 5)

        Hzp71 = wx.WrapSizer(wx.HORIZONTAL, 0)

        self.cBox1 = wx.CheckBox(self.P1, wx.ID_ANY, u"Disable",
                                 wx.DefaultPosition, wx.DefaultSize, 0)
        Hzp71.Add(
            self.cBox1, 0,
            wx.ALL | wx.ALIGN_CENTER_VERTICAL | wx.ALIGN_CENTER_HORIZONTAL, 5)

        self.cBox2 = wx.CheckBox(self.P1, wx.ID_ANY, u"Hidden",
                                 wx.DefaultPosition, wx.DefaultSize, 0)
        Hzp71.Add(self.cBox2, 0, wx.ALL, 5)

        Vzp1.Add(Hzp71, 0, wx.ALIGN_CENTER_HORIZONTAL, 5)

        self.P1.SetSizer(Vzp1)
        self.P1.Layout()
        Vzp1.Fit(self.P1)
        self.P2 = wx.Panel(self.SP1, wx.ID_ANY, wx.DefaultPosition,
                           wx.DefaultSize, wx.BORDER_RAISED | wx.TAB_TRAVERSAL)
        Vzp2 = wx.BoxSizer(wx.VERTICAL)

        Hzp8 = wx.WrapSizer(wx.HORIZONTAL, 0)

        self.txt8 = wx.StaticText(self.P2, wx.ID_ANY, u"Program to DO",
                                  wx.DefaultPosition, wx.DefaultSize, 0)
        self.txt8.Wrap(-1)

        Hzp8.Add(
            self.txt8, 0,
            wx.ALL | wx.ALIGN_CENTER_HORIZONTAL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.file1 = wx.FilePickerCtrl(self.P2, wx.ID_ANY, wx.EmptyString,
                                       u"Select a file", u"*.py",
                                       wx.DefaultPosition, wx.DefaultSize,
                                       wx.FLP_DEFAULT_STYLE | wx.FLP_SMALL)
        Hzp8.Add(self.file1, 1, wx.ALL, 5)

        Vzp2.Add(Hzp8, 0, wx.EXPAND, 5)

        Hzp9 = wx.WrapSizer(wx.HORIZONTAL, 0)

        self.Doprgitm = wx.TextCtrl(self.P2, wx.ID_ANY, wx.EmptyString,
                                    wx.DefaultPosition, wx.DefaultSize, 0)
        Hzp9.Add(self.Doprgitm, 1, wx.ALL, 5)

        self.pykan = wx.StaticText(self.P2, wx.ID_ANY, u"=>",
                                   wx.DefaultPosition, wx.DefaultSize, 0)
        Hzp9.Add(self.pykan, 0, wx.ALL, 5)

        self.Dsfilitm = wx.TextCtrl(self.P2, wx.ID_ANY, wx.EmptyString,
                                    wx.DefaultPosition, wx.DefaultSize, 0)
        Hzp9.Add(self.Dsfilitm, 1, wx.ALL, 5)

        Vzp2.Add(Hzp9, 0, wx.EXPAND, 5)

        Hzp10 = wx.WrapSizer(wx.HORIZONTAL, 0)

        self.btn1 = wx.Button(self.P2, wx.ID_ANY, u"Preview",
                              wx.DefaultPosition, wx.DefaultSize, 0)
        Hzp10.Add(self.btn1, 0, wx.ALL, 5)

        self.btn2 = wx.Button(self.P2, wx.ID_ANY, u"Open File",
                              wx.DefaultPosition, wx.DefaultSize, 0)
        Hzp10.Add(self.btn2, 0, wx.ALL, 5)

        self.btn3 = wx.Button(self.P2, wx.ID_ANY, u"New...",
                              wx.DefaultPosition, wx.DefaultSize, 0)
        Hzp10.Add(self.btn3, 0, wx.ALL, 5)

        Vzp2.Add(Hzp10, 0, wx.EXPAND, 5)

        Hzp11 = wx.WrapSizer(wx.HORIZONTAL, 0)

        self.btn4 = wx.Button(self.P2, wx.ID_ANY, u"Analiz...",
                              wx.DefaultPosition, wx.DefaultSize, 0)
        Hzp11.Add(self.btn4, 0, wx.ALL, 5)

        self.btn5 = wx.Button(self.P2, wx.ID_ANY, u"Parse...",
                              wx.DefaultPosition, wx.DefaultSize, 0)
        Hzp11.Add(self.btn5, 0, wx.ALL, 5)

        self.btn6 = wx.Button(self.P2, wx.ID_ANY, u"Generate1",
                              wx.DefaultPosition, wx.DefaultSize, 0)
        Hzp11.Add(self.btn6, 0, wx.ALL, 5)

        Vzp2.Add(Hzp11, 0, wx.EXPAND, 5)

        Hzpl = wx.WrapSizer(wx.HORIZONTAL, 0)

        self.line1 = wx.StaticLine(self.P2, wx.ID_ANY, wx.DefaultPosition,
                                   wx.DefaultSize, wx.LI_HORIZONTAL)
        Hzpl.Add(self.line1, 1, wx.EXPAND | wx.ALL, 5)

        Vzp2.Add(Hzpl, 0, wx.EXPAND, 5)

        Hzp12 = wx.WrapSizer(wx.HORIZONTAL, 0)

        self.txt9 = wx.StaticText(self.P2, wx.ID_ANY, u"Select Database",
                                  wx.DefaultPosition, wx.DefaultSize, 0)
        self.txt9.Wrap(-1)

        Hzp12.Add(
            self.txt9, 0,
            wx.ALL | wx.ALIGN_CENTER_HORIZONTAL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.dir1 = wx.DirPickerCtrl(self.P2, wx.ID_ANY, wx.EmptyString,
                                     u"Select a folder", wx.DefaultPosition,
                                     wx.DefaultSize,
                                     wx.DIRP_DEFAULT_STYLE | wx.DIRP_SMALL)
        Hzp12.Add(self.dir1, 1, wx.ALL, 5)

        Vzp2.Add(Hzp12, 0, wx.EXPAND, 5)

        Hzp13 = wx.WrapSizer(wx.HORIZONTAL, 0)

        self.txt10 = wx.StaticText(self.P2, wx.ID_ANY, u"Tabels and Fields",
                                   wx.DefaultPosition, wx.DefaultSize, 0)
        self.txt10.Wrap(-1)

        Hzp13.Add(self.txt10, 0, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        Lbox1Choices = []
        self.Lbox1 = wx.ListBox(self.P2, wx.ID_ANY, wx.DefaultPosition,
                                wx.DefaultSize, Lbox1Choices, 0)
        Hzp13.Add(self.Lbox1, 1, wx.ALL, 5)

        Vzp2.Add(Hzp13, 0, wx.EXPAND, 5)

        Hzp14 = wx.WrapSizer(wx.HORIZONTAL, wx.WRAPSIZER_DEFAULT_FLAGS)

        self.btn7 = wx.Button(self.P2, wx.ID_ANY, u"Analiz...",
                              wx.DefaultPosition, wx.DefaultSize, 0)
        Hzp14.Add(self.btn7, 0, wx.ALL, 5)

        self.btn8 = wx.Button(self.P2, wx.ID_ANY, u"Parse...",
                              wx.DefaultPosition, wx.DefaultSize, 0)
        Hzp14.Add(self.btn8, 0, wx.ALL, 5)

        self.btn9 = wx.Button(self.P2, wx.ID_ANY, u"Generate2",
                              wx.DefaultPosition, wx.DefaultSize, 0)
        Hzp14.Add(self.btn9, 0, wx.ALL, 5)

        Vzp2.Add(Hzp14, 1, wx.EXPAND, 5)

        self.P2.SetSizer(Vzp2)
        self.P2.Layout()
        Vzp2.Fit(self.P2)
        self.SP1.SplitVertically(self.P1, self.P2, 349)
        Vz1.Add(self.SP1, 1, wx.EXPAND, 5)

        Hz1 = wx.BoxSizer(wx.HORIZONTAL)

        self.btnA = wx.Button(self, wx.ID_ANY, u"Apply", wx.DefaultPosition,
                              wx.DefaultSize, 0)
        Hz1.Add(self.btnA, 0, wx.ALL, 5)

        self.btnS = wx.Button(self, wx.ID_ANY, u"Save ", wx.DefaultPosition,
                              wx.DefaultSize, 0)
        Hz1.Add(self.btnS, 0, wx.ALL, 5)

        self.btnR = wx.Button(self, wx.ID_ANY, u"Report", wx.DefaultPosition,
                              wx.DefaultSize, 0)
        Hz1.Add(self.btnR, 0, wx.ALL, 5)

        Vz1.Add(Hz1, 0, wx.ALIGN_CENTER_HORIZONTAL, 5)

        if self.Button == 'UpDate' or self.Button == 'Delete':
            self.putData(self.Data)

        self.SetSizer(Vz1)
        self.Layout()

        # Connect Events
        # self.btnIcn.Bind( wx.EVT_BUTTON, self.opnicn )
        self.btnsrc.Bind(wx.EVT_BUTTON, self.lstid)
        self.fld3.Bind(wx.EVT_FILEPICKER_CHANGED, self.shwicn)

        self.rBtn1.Bind(wx.EVT_RADIOBUTTON, self.typitm)
        self.rBtn2.Bind(wx.EVT_RADIOBUTTON, self.typitm)
        self.rBtn3.Bind(wx.EVT_RADIOBUTTON, self.typitm)
        self.rBtn4.Bind(wx.EVT_RADIOBUTTON, self.typitm)
        self.cBox1.Bind(wx.EVT_CHECKBOX, self.disitm)
        self.cBox2.Bind(wx.EVT_CHECKBOX, self.hiditm)
        self.file1.Bind(wx.EVT_FILEPICKER_CHANGED, self.chngfil)
        self.btn1.Bind(wx.EVT_BUTTON, self.prvw)
        self.btn2.Bind(wx.EVT_BUTTON, self.opnfil)
        self.btn3.Bind(wx.EVT_BUTTON, self.newfil)
        self.btn4.Bind(wx.EVT_BUTTON, self.anliz1)
        self.btn5.Bind(wx.EVT_BUTTON, self.pars1)
        self.btn6.Bind(wx.EVT_BUTTON, self.gnrt1)
        self.dir1.Bind(wx.EVT_DIRPICKER_CHANGED, self.dbfil)
        self.Lbox1.Bind(wx.EVT_LISTBOX, self.tblfld)
        self.btn7.Bind(wx.EVT_BUTTON, self.anliz2)
        self.btn8.Bind(wx.EVT_BUTTON, self.pars2)
        self.btn9.Bind(wx.EVT_BUTTON, self.gnrt2)
        self.btnA.Bind(wx.EVT_BUTTON, self.Aply)
        self.btnS.Bind(wx.EVT_BUTTON, self.Save)
        self.btnR.Bind(wx.EVT_BUTTON, self.Rprt)
Esempio n. 7
0
    def __init__(self,
                 parent,
                 Data,
                 Buttom,
                 title,
                 id=wx.ID_ANY,
                 pos=wx.DefaultPosition,
                 size=wx.Size(500, 235),
                 style=wx.TAB_TRAVERSAL,
                 name=wx.EmptyString):
        wx.Panel.__init__(self,
                          parent,
                          id=id,
                          pos=pos,
                          size=size,
                          style=style,
                          name=name)

        self.Data = Data
        self.GetMenu = MS.GetData(u'Menu2.db', u'')
        self.SetMenu = MS.SetData(u'', u'', u'')
        self.Action = False
        self.box1val = 1
        self.box2val = 'FFFF'
        self.oldbar = self.Data[0]

        Vsz1 = wx.BoxSizer(wx.VERTICAL)

        Vst = wx.BoxSizer(wx.VERTICAL)

        self.title = wx.StaticText(self, wx.ID_ANY, title, wx.DefaultPosition,
                                   wx.DefaultSize, 0)
        self.title.Wrap(1)
        Vst.Add(self.title, 1, wx.ALL | wx.EXPAND, 5)

        Vsz1.Add(Vst, 1, wx.EXPAND, 5)

        Hsz1 = wx.BoxSizer(wx.HORIZONTAL)

        self.txt1 = wx.StaticText(self, wx.ID_ANY, u"Bar name",
                                  wx.DefaultPosition, wx.DefaultSize, 0)
        self.txt1.Wrap(-1)

        Hsz1.Add(self.txt1, 0, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.fld1 = wx.TextCtrl(self, wx.ID_ANY, self.Data[0],
                                wx.DefaultPosition, wx.DefaultSize, 0)
        Hsz1.Add(self.fld1, 1, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.txt2 = wx.StaticText(self, wx.ID_ANY, u"ID", wx.DefaultPosition,
                                  wx.DefaultSize, 0)
        self.txt2.Wrap(-1)

        Hsz1.Add(self.txt2, 0, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.fld2 = wx.TextCtrl(self, wx.ID_ANY, self.Data[1],
                                wx.DefaultPosition, wx.Size(50, -1), 0)
        Hsz1.Add(self.fld2, 0, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.txt3 = wx.StaticText(self, wx.ID_ANY, u"Access",
                                  wx.DefaultPosition, wx.DefaultSize, 0)
        self.txt3.Wrap(-1)

        Hsz1.Add(self.txt3, 0, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.fld3 = wx.TextCtrl(self, wx.ID_ANY, self.Data[2],
                                wx.DefaultPosition, wx.Size(50, -1), 0)
        Hsz1.Add(self.fld3, 0, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.m_button24 = wx.Button(self, wx.ID_ANY, u"...",
                                    wx.DefaultPosition, wx.DefaultSize,
                                    wx.BU_EXACTFIT)
        Hsz1.Add(self.m_button24, 0, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        Vsz1.Add(Hsz1, 0, wx.EXPAND, 5)

        Hsz2 = wx.BoxSizer(wx.HORIZONTAL)

        self.txt4 = wx.StaticText(self, wx.ID_ANY, u"Directory",
                                  wx.DefaultPosition, wx.DefaultSize, 0)
        self.txt4.Wrap(-1)

        Hsz2.Add(self.txt4, 0, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.dirct = wx.DirPickerCtrl(self, wx.ID_ANY,
                                      GUI_PATH + self.Data[3][4:],
                                      u"Select a folder", wx.DefaultPosition,
                                      wx.DefaultSize,
                                      wx.DIRP_DEFAULT_STYLE | wx.DIRP_SMALL)
        Hsz2.Add(self.dirct, 1, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        Vsz1.Add(Hsz2, 0, wx.EXPAND, 5)

        Hsz3 = wx.BoxSizer(wx.HORIZONTAL)

        self.box1 = wx.CheckBox(self, wx.ID_ANY, u"Disable",
                                wx.DefaultPosition, wx.DefaultSize, 0)
        Hsz3.Add(self.box1, 0, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.box2 = wx.CheckBox(self, wx.ID_ANY, u"Hiden", wx.DefaultPosition,
                                wx.DefaultSize, 0)
        Hsz3.Add(self.box2, 0, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        if self.Data[4][0][2] == '0000':
            self.box2.SetValue(True)
        if self.Data[4][0][3] == 0:
            self.box1.SetValue(True)

        Vsz1.Add(Hsz3, 0, wx.ALIGN_CENTER_HORIZONTAL, 5)

        Hsz4 = wx.BoxSizer(wx.HORIZONTAL)

        Hsz4.Add((0, 0), 1, wx.EXPAND, 5)

        self.btn1 = wx.Button(self, wx.ID_ANY, u"Cancle", wx.DefaultPosition,
                              wx.DefaultSize, 0)
        Hsz4.Add(self.btn1, 0, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        self.btn2 = wx.Button(self, wx.ID_ANY, Buttom, wx.DefaultPosition,
                              wx.DefaultSize, 0)
        Hsz4.Add(self.btn2, 0, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

        Vsz1.Add(Hsz4, 0, wx.EXPAND, 5)

        self.SetSizer(Vsz1)
        self.Layout()

        # Connect Events
        self.m_button24.Bind(wx.EVT_BUTTON, self.srchit)
        self.dirct.Bind(wx.EVT_DIRPICKER_CHANGED, self.bardir)
        self.box1.Bind(wx.EVT_CHECKBOX, self.disbar)
        self.box2.Bind(wx.EVT_CHECKBOX, self.hidbar)
        self.btn1.Bind(wx.EVT_BUTTON, self.cancl)
        self.btn2.Bind(wx.EVT_BUTTON, self.doit)
Esempio n. 8
0
    def __init__(self,
                 parent,
                 id=wx.ID_ANY,
                 pos=wx.DefaultPosition,
                 size=wx.Size(646, 300),
                 style=wx.TAB_TRAVERSAL,
                 name=wx.EmptyString):
        wx.Panel.__init__(self,
                          parent,
                          id=id,
                          pos=pos,
                          size=size,
                          style=style,
                          name=name)

        Vsz1 = wx.BoxSizer(wx.VERTICAL)

        self.Spw1 = wx.SplitterWindow(self, wx.ID_ANY, wx.DefaultPosition,
                                      wx.DefaultSize,
                                      wx.SP_3DSASH | wx.SP_NO_XP_THEME)
        self.Spw1.Bind(wx.EVT_IDLE, self.Spw1OnIdle)

        self.pnl1 = wx.Panel(self.Spw1, wx.ID_ANY, wx.DefaultPosition,
                             wx.DefaultSize, wx.TAB_TRAVERSAL)
        Vsz2 = wx.BoxSizer(wx.VERTICAL)

        self.TLCtrl1 = wx.dataview.TreeListCtrl(
            self.pnl1, wx.ID_ANY, wx.DefaultPosition, wx.DefaultSize,
            wx.dataview.TL_CHECKBOX | wx.dataview.TL_DEFAULT_STYLE
            | wx.dataview.TL_MULTIPLE)
        self.TLCtrl1.AppendColumn(u"ID", wx.COL_WIDTH_DEFAULT, wx.ALIGN_LEFT,
                                  wx.COL_RESIZABLE)
        self.TLCtrl1.AppendColumn(u"Name", wx.COL_WIDTH_DEFAULT, wx.ALIGN_LEFT,
                                  wx.COL_RESIZABLE)
        self.TLCtrl1.AppendColumn(u"dir", wx.COL_WIDTH_DEFAULT, wx.ALIGN_LEFT,
                                  wx.COL_RESIZABLE)
        self.TLCtrl1.AppendColumn(u"access", wx.COL_WIDTH_DEFAULT,
                                  wx.ALIGN_LEFT, wx.COL_RESIZABLE)

        Vsz2.Add(self.TLCtrl1, 1, wx.EXPAND | wx.ALL, 5)

        self.MyMenu = MS.GetData(u'Menu2.db', u'')
        self.DoMenu = MS.SetData(u'', u'', u'')

        self.fillList()

        self.pnl1.SetSizer(Vsz2)
        self.pnl1.Layout()
        Vsz2.Fit(self.pnl1)
        self.pnl2 = wx.Panel(self.Spw1, wx.ID_ANY, wx.DefaultPosition,
                             wx.DefaultSize, wx.TAB_TRAVERSAL)
        Vsz3 = wx.BoxSizer(wx.VERTICAL)

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

        self.btn2 = wx.Button(self.pnl2, wx.ID_ANY, u"Edit",
                              wx.DefaultPosition, wx.DefaultSize, 0)
        Vsz3.Add(self.btn2, 0, wx.ALL, 5)

        self.btn3 = wx.Button(self.pnl2, wx.ID_ANY, u"Delete",
                              wx.DefaultPosition, wx.DefaultSize, 0)
        Vsz3.Add(self.btn3, 0, wx.ALL, 5)

        Vsz3.Add((0, 0), 1, wx.EXPAND, 5)

        self.btn4 = wx.Button(self.pnl2, wx.ID_ANY, u"Separator",
                              wx.DefaultPosition, wx.DefaultSize, 0)
        Vsz3.Add(self.btn4, 0, wx.ALL, 5)

        self.pnl2.SetSizer(Vsz3)
        self.pnl2.Layout()
        Vsz3.Fit(self.pnl2)
        self.Spw1.SplitVertically(self.pnl1, self.pnl2, 532)
        Vsz1.Add(self.Spw1, 1, wx.EXPAND, 5)

        VL = wx.BoxSizer(wx.VERTICAL)

        self.Line = wx.StaticLine(self, wx.ID_ANY, wx.DefaultPosition,
                                  wx.DefaultSize, wx.LI_HORIZONTAL)
        VL.Add(self.Line, 0, wx.EXPAND | wx.ALL, 5)

        Vsz1.Add(VL, 0, wx.EXPAND, 5)

        Hz1 = wx.BoxSizer(wx.HORIZONTAL)

        self.btna = wx.Button(self, wx.ID_ANY, u"New Bar", wx.DefaultPosition,
                              wx.DefaultSize, 0)
        Hz1.Add(self.btna, 0, wx.ALL, 5)

        self.btnb = wx.Button(self, wx.ID_ANY, u"Change Bar",
                              wx.DefaultPosition, wx.DefaultSize, 0)
        Hz1.Add(self.btnb, 0, wx.ALL, 5)

        self.btnc = wx.Button(self, wx.ID_ANY, u"Delete Bar",
                              wx.DefaultPosition, wx.DefaultSize, 0)
        Hz1.Add(self.btnc, 0, wx.ALL, 5)

        Vsz1.Add(Hz1, 0, wx.EXPAND, 5)

        self.txt = stc.StyledTextCtrl()

        self.SetSizer(Vsz1)
        self.Layout()

        # Connect Events
        self.TLCtrl1.Bind(wx.dataview.EVT_TREELIST_ITEM_CHECKED,
                          self.DoshowItm)
        self.TLCtrl1.Bind(wx.dataview.EVT_TREELIST_ITEM_CONTEXT_MENU,
                          self.Thismenu)
        self.TLCtrl1.Bind(wx.dataview.EVT_DATAVIEW_ITEM_ACTIVATED,
                          self.Thismenu)
        self.btn1.Bind(wx.EVT_BUTTON, self.Additm)
        self.btn2.Bind(wx.EVT_BUTTON, self.edititm)
        self.btn3.Bind(wx.EVT_BUTTON, self.delitm)
        self.btn4.Bind(wx.EVT_BUTTON, self.aplyit)
        self.btna.Bind(wx.EVT_BUTTON, self.Nbar)
        self.btnb.Bind(wx.EVT_BUTTON, self.Cbar)
        self.btnc.Bind(wx.EVT_BUTTON, self.Dbar)