def __init__(self, parent, id, title, orig, lastPath): super().__init__(parent, id, title, orig, wx.DLG_SZE(parent,wx.Size(160,184)), wx.CAPTION|wx.DIALOG_MODAL) wx.StaticText(self, -1, "Port Pin", wx.DLG_PNT(self,wx.Point(10,10)), wx.DLG_SZE(self,wx.Size(21,9)), wx.ALIGN_LEFT) self.lastPath = lastPath names = PortInfo.keys() names.sort() self.listbox = wx.ListBox(self, 100, wx.DLG_PNT(self,wx.Point(10,20)), wx.DLG_SZE(self,wx.Size(46,90)), names, wx.LB_SINGLE) self.stimulusfile = wx.StaticText(self, -1, "Stimulus File", wx.DLG_PNT(self,wx.Point(10,114)), wx.DLG_SZE(self,wx.Size(36,9)), wx.ALIGN_LEFT) self.stimulusfile.Enable(0) self.filename = wx.TextCtrl(self, 101, "", wx.DLG_PNT(self,wx.Point(10,123)), wx.DLG_SZE(self,wx.Size(100,13)), wx.TE_PROCESS_ENTER) self.filename.Enable(0) self.browse = wx.Button(self, 102, "Browse", wx.DLG_PNT(self,wx.Point(116,123)), wx.DLG_SZE(self,wx.Size(32,12))) self.browse.Enable(0) wx.StaticBox(self, -1, "Port Pin Info", wx.DLG_PNT(self,wx.Point(60,10)), wx.DLG_SZE(self,wx.Size(90,100))) self.pininfo = wx.StaticText(self, 103, "", wx.DLG_PNT(self,wx.Point(62,21)), wx.DLG_SZE(self,wx.Size(86,85)), wx.ALIGN_LEFT|wx.ST_NO_AUTORESIZE) wx.StaticLine(self, -1, wx.DLG_PNT(self,wx.Point(5,145)), wx.DLG_SZE(self,wx.Size(148,2)), wx.LI_HORIZONTAL) self.okbutton = wx.Button(self, wx.ID_OK, "OK", wx.DLG_PNT(self,wx.Point(34, 152)), wx.DLG_SZE(self,wx.Size(32,12))) self.okbutton.Enable(0) wx.Button(self, wx.ID_CANCEL, "Cancel", wx.DLG_PNT(self,wx.Point(86, 152)), wx.DLG_SZE(self,wx.Size(32,12))) self.Bind(wx.EVT_LISTBOX,self.OnListBox,id=100) #EVT_LISTBOX(self, 100, self.OnListBox) self.Bind(wx.EVT_LISTBOX_DCLICK,self.OnListBoxDoubleClick,id=100) #EVT_LISTBOX_DCLICK(self, 100, self.OnListBoxDoubleClick) self.Bind(wx.EVT_BUTTON,self.OnBrowse,id=102) #EVT_BUTTON(self, 102, self.OnBrowse) self.Bind(wx.EVT_TEXT_ENTER,self.OnTextEnter,id=101) #EVT_TEXT_ENTER(self, 101, self.OnTextEnter) self.Bind(wx.EVT_BUTTON,self.OnOk,id=wx.ID_OK) #EVT_BUTTON(self, wx.ID_OK, self.OnOk)
def __init__(self, parent, id, size=wx.DefaultSize): wx.Panel.__init__(self, parent, id) self.panel = wx.Panel(self, -1, wx.DLG_PNT(self, wx.Point(0, 0)), self.GetClientSize()) # self.Text = wx.TextCtrl(self.panel, -1, "", wx.DLG_PNT(self.panel, wx.Point(0,0)), wx.Size(0,0), wx.TE_AUTO_URL | wx.TE_MULTILINE | wx.TE_READONLY | wx.TE_WORDWRAP) self.Text = wx.TextCtrl( self.panel, -1, "", wx.DLG_PNT(self.panel, wx.Point(0, 0)), wx.Size(0, 0), wx.TE_AUTO_URL | wx.TE_MULTILINE | wx.TE_READONLY | wx.HSCROLL) self.button = wx.Button(self.panel, 1003, "Clear Log") self.button.SetPosition((0, -20)) self.msgBox = wx.StaticText(self.panel, -1, "", (0, 0)) self.Bind(wx.EVT_BUTTON, self.OnClearLog, self.button) self.Bind(wx.EVT_SIZE, self.OnSize)
def __init__(self, parent): wx.Panel.__init__(self, parent) self.list = wx.ListBox(self, -1, wx.DLG_PNT(self, 10, 10), wx.DLG_SZE(self, 100, 100), []) self.Bind(wx.EVT_LISTBOX, self.OnSelect, self.list) self.Bind(wx.EVT_LISTBOX_DCLICK, self.OnDClick, self.list) wx.Button(self, -1, "Try it!", wx.DLG_PNT(self, 120, 10)).SetDefault() self.Bind(wx.EVT_BUTTON, self.OnDClick) self.text = wx.TextCtrl(self, -1, "", wx.DLG_PNT(self, 10, 115), wx.DLG_SZE(self, 200, 50), wx.TE_MULTILINE | wx.TE_READONLY) for item in theTests: self.list.Append(item[0])
def __init__(self, prnt, cnt): wx.Dialog.__init__(self, id=wx.NewId(), name='', parent=prnt, pos=wx.Point(10, 50), size=wx.DefaultSize, style=wx.DEFAULT_FRAME_STYLE, title=ttl) self.SetIcon(wx.Icon(cfg.path_img+"/null.ico", wx.BITMAP_TYPE_ICO)) #self.SetFont(wx.Font(12, wx.SWISS, wx.NORMAL, wx.NORMAL, False)) self.cnt = cnt self.SetTitle(cnt[0]) Nid = wx.NewId() self.CnAz=prnt.CnAz #self.font=self.GetFont() self.__FRM__ = prnt.__MDI__ self.__MDI__ = wx.GetApp().GetPhasisMdi() self.font=self.__MDI__.font self.SetFont(self.font) self.pnl = wx.Panel(id=wx.NewId(), name='panel', parent=self, pos=wx.Point(0, 0)) self.pnl.SetFont(self.font) self.lc = wx.ListCtrl(self.pnl , Nid, wx.DLG_PNT(self, 5,5), wx.DLG_SZE(self.pnl , 335,110), wx.LC_REPORT|wx.LC_HRULES|wx.LC_VRULES) self.lc.InsertColumn(0, _("Codide")) self.lc.InsertColumn(1, _("Descrizione")) self.lc.SetColumnWidth(0, wx.DLG_SZE(self, 70,-1).width) self.lc.SetColumnWidth(1, wx.DLG_SZE(self, 300,-1).width) #self.lc.SetFont(self.font) rowlc=0 cod = self.cnt[4] descriz = self.cnt[5] if cod=="": sql = """ select * from piacon where descriz like "%s" order by descriz desc """ valueSql = '%' + cod + '%' else : sql = """ select * from piacon where cod like "%s" order by descriz desc """ valueSql = '%' + descriz + '%' try: cr = self.CnAz.cursor () cr.execute(sql % valueSql) rows = cr.fetchall() for row in rows: for rowlc in range(1): row_lc = self.lc.GetItemCount() cod = str(row[0]) descriz = str(row[1]) self.lc.InsertStringItem(rowlc, cod) self.lc.SetStringItem(rowlc, 1, descriz) self.lc.SetItemData(0,0) except StandardError, msg: self.__FRM__.MsgErr("SrcPiaC"," Fnd Error %s " % (msg))
def __init__(self, parent, title=""): wx.Frame.__init__(self, parent) self.SetTitle(title) # self.Text = wx.TextCtrl(self.panel, -1, "", wx.DLG_PNT(self, wx.Point(0,0)), wx.Size(0,0), wx.TE_AUTO_URL | wx.TE_MULTILINE | wx.TE_READONLY | wx.TE_WORDWRAP) self.Text = wx.TextCtrl( self, -1, "", wx.DLG_PNT(self, wx.Point(0, 0)), wx.Size(0, 0), wx.TE_AUTO_URL | wx.TE_MULTILINE | wx.TE_READONLY | wx.HSCROLL) self.button = wx.Button(self, 1003, "Clear Log") self.button.SetPosition((0, -20)) self.msgBox = wx.StaticText(self, -1, " ", (0, 0)) self.Bind(wx.EVT_BUTTON, self.OnClearLog, self.button) self.Bind(wx.EVT_SIZE, self.OnSize) self.Bind(wx.EVT_CLOSE, self.OnCloseWindow)
def __init__(self, parent, id, title): # First, call the base class' __init__ method to create the frame wx.Frame.__init__(self, parent, id, title, (100, 100), (160, 100)) # Associate some events with methods of this class self.Bind(wx.EVT_SIZE, self.OnSize) self.Bind(wx.EVT_MOVE, self.OnMove) self.Bind(wx.EVT_CLOSE, self.OnCloseWindow) # Add a panel and some controls to display the size and position panel = wx.Panel(self, -1) wx.StaticText(panel, -1, "Size:", wx.DLG_PNT(panel, (4, 4)), wx.DefaultSize) wx.StaticText(panel, -1, "Pos:", wx.DLG_PNT(panel, (4, 16)), wx.DefaultSize) self.sizeCtrl = wx.TextCtrl(panel, -1, "", wx.DLG_PNT(panel, (24, 4)), wx.DLG_SZE(panel, (36, -1)), wx.TE_READONLY) self.posCtrl = wx.TextCtrl(panel, -1, "", wx.DLG_PNT(panel, (24, 16)), wx.DLG_SZE(panel, (36, -1)), wx.TE_READONLY)
def __init__(self, prnt, cnt): wx.Dialog.__init__(self, id=wx.NewId(), name='', parent=prnt, pos=wx.Point(10, 50), size=wx.DefaultSize, style=wx.DEFAULT_FRAME_STYLE, title=ttl) self.SetIcon(wx.Icon(cfg.path_img+"/null.ico", wx.BITMAP_TYPE_ICO)) #self.SetFont(wx.Font(12, wx.SWISS, wx.NORMAL, wx.NORMAL, False)) self.cnt = cnt #self.SetTitle(cnt[0]) Nid = wx.NewId() self.CnAz=prnt.CnAz #self.font=self.GetFont() #self.__FRM__ = prnt self.__MDI__ = wx.GetApp().GetPhasisMdi() self.font=self.__MDI__.font self.SetFont(self.font) self.pnl = wx.Panel(id=wx.NewId(), name='panel', parent=self, pos=wx.Point(0, 0)) self.pnl.SetFont(self.font) self.annoc = self.__MDI__.GetAnnoC() self.lc = wx.ListCtrl(self.pnl , Nid, wx.DLG_PNT(self, 5,5), wx.DLG_SZE(self.pnl , 335,110), wx.LC_REPORT|wx.LC_HRULES|wx.LC_VRULES) self.lc.InsertColumn(0, _("Num. Doc.")) self.lc.InsertColumn(1, _("Data")) self.lc.InsertColumn(2, _("Rag. Sociale")) self.lc.SetColumnWidth(0, wx.DLG_SZE(self, 50,-1).width) self.lc.SetColumnWidth(1, wx.DLG_SZE(self, 70,-1).width) self.lc.SetColumnWidth(2, wx.DLG_SZE(self, 120,-1).width) #self.lc.SetFont(self.font) # < diegom rowlc = 0 tbl = self.cnt[0] tipoDoc= self.cnt[1] rag_soc1 = cnt[3] rag_soc2 = cnt[4] cod_cf = cnt[5] anno = self.annoc #valueSql= tbl,tipoDoc if tbl=="ordi1": if rag_soc1=="": sql = """ SELECT * FROM "%s" WHERE tipo_ord = "%s" AND anno = "%s" ORDER BY rag_soc1 DESC """ valueSql= tbl,tipoDoc,anno else: sql = """ SELECT * FROM "%s" WHERE tipo_ord = "%s" AND rag_soc1 like "%s" AND rag_soc2 like "%s" AND cod_cf like "%s" AND anno = "%s" ORDER BY rag_soc1 DESC """ valueSql= tbl,tipoDoc,rag_soc1,rag_soc2,cod_cf,anno if tbl=="docu1": if rag_soc1=="": sql = """ SELECT * FROM "%s" WHERE tipo_doc = "%s" AND anno = "%s" ORDER BY rag_soc1 DESC """ valueSql= tbl,tipoDoc,anno else: sql = """ SELECT * FROM "%s" WHERE tipo_ord = "%s" AND rag_soc1 like "%s" AND rag_soc2 like "%s" AND cod_cf like "%s" AND anno = "%s" ORDER BY rag_soc1 DESC """ valueSql= tbl,tipoDoc,rag_soc1,rag_soc2,cod_cf,anno # > diegom try: cr = self.CnAz.cursor () cr.execute(sql % valueSql) rows = cr.fetchall() for row in rows: for rowlc in range(1): if tbl=="ordi1": row_lc = self.lc.GetItemCount() num=str(row[2]) data = str(row[3]) rag_soc1 = row[5] self.lc.InsertStringItem(rowlc, num) self.lc.SetStringItem(rowlc, 1, data) self.lc.SetStringItem(rowlc, 2, rag_soc1) self.lc.SetItemData(0,0) row_lc = self.lc.GetItemCount() if tbl=="docu1": num=str(row[2]) data = str(row[3]) rag_soc1 = row[5] self.lc.InsertStringItem(rowlc, num) self.lc.SetStringItem(rowlc, 1, data) self.lc.SetStringItem(rowlc, 2, rag_soc1) self.lc.SetItemData(0,0) row_lc = self.lc.GetItemCount() #num=str(row[2]) except StandardError, msg: #self.__FRM__.MsgErr("SrcTabG"," Fnd Error %s " % (msg)) print "Error SrcScad"
class SrcScad(wx.Dialog): def __init__(self, prnt, cnt): wx.Dialog.__init__(self, id=wx.NewId(), name='', parent=prnt, pos=wx.Point(10, 50), size=wx.DefaultSize, style=wx.DEFAULT_FRAME_STYLE, title=ttl) self.SetIcon(wx.Icon(cfg.path_img+"/null.ico", wx.BITMAP_TYPE_ICO)) #self.SetFont(wx.Font(12, wx.SWISS, wx.NORMAL, wx.NORMAL, False)) self.cnt = cnt #self.SetTitle(cnt[0]) Nid = wx.NewId() self.CnAz=prnt.CnAz #self.font=self.GetFont() #self.__FRM__ = prnt self.__MDI__ = wx.GetApp().GetPhasisMdi() self.font=self.__MDI__.font self.SetFont(self.font) self.pnl = wx.Panel(id=wx.NewId(), name='panel', parent=self, pos=wx.Point(0, 0)) self.pnl.SetFont(self.font) self.annoc = self.__MDI__.GetAnnoC() self.lc = wx.ListCtrl(self.pnl , Nid, wx.DLG_PNT(self, 5,5), wx.DLG_SZE(self.pnl , 335,110), wx.LC_REPORT|wx.LC_HRULES|wx.LC_VRULES) self.lc.InsertColumn(0, _("Num. Doc.")) self.lc.InsertColumn(1, _("Data")) self.lc.InsertColumn(2, _("Rag. Sociale")) self.lc.SetColumnWidth(0, wx.DLG_SZE(self, 50,-1).width) self.lc.SetColumnWidth(1, wx.DLG_SZE(self, 70,-1).width) self.lc.SetColumnWidth(2, wx.DLG_SZE(self, 120,-1).width) #self.lc.SetFont(self.font) # < diegom rowlc = 0 tbl = self.cnt[0] tipoDoc= self.cnt[1] rag_soc1 = cnt[3] rag_soc2 = cnt[4] cod_cf = cnt[5] anno = self.annoc #valueSql= tbl,tipoDoc if tbl=="ordi1": if rag_soc1=="": sql = """ SELECT * FROM "%s" WHERE tipo_ord = "%s" AND anno = "%s" ORDER BY rag_soc1 DESC """ valueSql= tbl,tipoDoc,anno else: sql = """ SELECT * FROM "%s" WHERE tipo_ord = "%s" AND rag_soc1 like "%s" AND rag_soc2 like "%s" AND cod_cf like "%s" AND anno = "%s" ORDER BY rag_soc1 DESC """ valueSql= tbl,tipoDoc,rag_soc1,rag_soc2,cod_cf,anno if tbl=="docu1": if rag_soc1=="": sql = """ SELECT * FROM "%s" WHERE tipo_doc = "%s" AND anno = "%s" ORDER BY rag_soc1 DESC """ valueSql= tbl,tipoDoc,anno else: sql = """ SELECT * FROM "%s" WHERE tipo_ord = "%s" AND rag_soc1 like "%s" AND rag_soc2 like "%s" AND cod_cf like "%s" AND anno = "%s" ORDER BY rag_soc1 DESC """ valueSql= tbl,tipoDoc,rag_soc1,rag_soc2,cod_cf,anno # > diegom try: cr = self.CnAz.cursor () cr.execute(sql % valueSql) rows = cr.fetchall() for row in rows: for rowlc in range(1): if tbl=="ordi1": row_lc = self.lc.GetItemCount() num=str(row[2]) data = str(row[3]) rag_soc1 = row[5] self.lc.InsertStringItem(rowlc, num) self.lc.SetStringItem(rowlc, 1, data) self.lc.SetStringItem(rowlc, 2, rag_soc1) self.lc.SetItemData(0,0) row_lc = self.lc.GetItemCount() if tbl=="docu1": num=str(row[2]) data = str(row[3]) rag_soc1 = row[5] self.lc.InsertStringItem(rowlc, num) self.lc.SetStringItem(rowlc, 1, data) self.lc.SetStringItem(rowlc, 2, rag_soc1) self.lc.SetItemData(0,0) row_lc = self.lc.GetItemCount() #num=str(row[2]) except StandardError, msg: #self.__FRM__.MsgErr("SrcTabG"," Fnd Error %s " % (msg)) print "Error SrcScad" self.CnAz.commit() self.currentItem = 0 wx.StaticLine(self.pnl , -1, wx.DLG_PNT(self.pnl , 5,115), wx.DLG_SZE(self.pnl , 300,-1)) #self.pnl.SetFont(self.font) self.ok = wx.Button(self.pnl , Nid, cfg.vcconf, wx.DLG_PNT(self.pnl , 195,120), wx.DLG_SZE(self.pnl,cfg.btnSzeLH,cfg.btnSzeV)) self.canc=wx.Button(self.pnl , Nid, cfg.vccanc, wx.DLG_PNT(self.pnl , 255,120), wx.DLG_SZE(self.pnl,cfg.btnSzeLH,cfg.btnSzeV)) for x in self.pnl.GetChildren(): x.SetFont(self.font) self.canc.SetFocus() #self.SetFont(self.font) box_sizer = wx.BoxSizer(wx.VERTICAL) box_sizer.Add(self.pnl, 0, wx.EXPAND|wx.ALL,0) self.SetAutoLayout(1) self.SetSizer(box_sizer) box_sizer.Fit(self) self.canc.Bind(wx.EVT_BUTTON, self.Close) self.Bind(wx.EVT_CLOSE, self.Close) self.ok.Bind(wx.EVT_BUTTON, self.Ok) self.lc.Bind(wx.EVT_LEFT_DCLICK, self.DblClick) self.lc.Bind(wx.EVT_LIST_ITEM_SELECTED, self.OnListSelect) self.lc.Bind(wx.EVT_LIST_ITEM_ACTIVATED, self.DblClick)
def __init__(self, prnt, cnt): wx.Dialog.__init__(self, id=wx.NewId(), name='', parent=prnt, pos=wx.Point(10, 50), size=wx.DefaultSize, style=wx.DEFAULT_FRAME_STYLE, title=ttl) self.SetIcon(wx.Icon(cfg.path_img + "/null.ico", wx.BITMAP_TYPE_ICO)) png = wx.Image((cfg.path_img + "cerca19x19.png"), wx.BITMAP_TYPE_PNG).ConvertToBitmap() #self.SetFont(wx.Font(12, wx.SWISS, wx.NORMAL, wx.NORMAL, False)) self.cnt = cnt self.ttl = ttl self.tblart = self.cnt[0] self.CnAz = prnt.CnAz #self.font = self.GetFont() self.__FRM__ = prnt.__MDI__ self.__MDI__ = wx.GetApp().GetPhasisMdi() self.font = self.__MDI__.font self.SetFont(self.font) self.pnl = wx.Panel(id=wx.NewId(), name='panel', parent=self, pos=wx.Point(0, 0)) self.pnl.SetFont(self.font) self.lc = wx.ListCtrl(self.pnl, -1, wx.DLG_PNT(self, 5, 5), wx.DLG_SZE(self.pnl, 335, 110), wx.LC_REPORT | wx.LC_HRULES | wx.LC_VRULES) self.lc.InsertColumn(0, _("Codice")) self.lc.InsertColumn(1, _("Descriz")) self.lc.InsertColumn(2, _("UM")) self.lc.InsertColumn(3, _("TG")) self.lc.InsertColumn(1, _("Descriz")) self.lc.InsertColumn(2, _("UM")) self.lc.InsertColumn(3, _("TG")) self.lc.InsertColumn(4, _("Prezzo1")) self.lc.InsertColumn(5, _("Prezzo2")) self.lc.InsertColumn(6, _("Costo")) self.lc.InsertColumn(7, _("BarCode")) self.lc.SetColumnWidth(0, wx.DLG_SZE(self, 65, -1).width) self.lc.SetColumnWidth(1, wx.DLG_SZE(self, 150, -1).width) self.lc.SetColumnWidth(2, wx.DLG_SZE(self, 20, -1).width) self.lc.SetColumnWidth(3, wx.DLG_SZE(self, 20, -1).width) self.lc.SetColumnWidth(4, wx.DLG_SZE(self, 60, -1).width) self.lc.SetColumnWidth(5, wx.DLG_SZE(self, 60, -1).width) self.lc.SetColumnWidth(6, wx.DLG_SZE(self, 60, -1).width) self.lc.SetColumnWidth(7, wx.DLG_SZE(self, 0, -1).width) wx.StaticLine(self.pnl, -1, wx.DLG_PNT(self.pnl, 5, 115), wx.DLG_SZE(self.pnl, 300, -1)) #self.pnl.SetFont(self.font) self.ok = wx.Button(self.pnl, -1, cfg.vcconf, wx.DLG_PNT(self.pnl, 195, 120), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) self.canc = wx.Button(self.pnl, -1, cfg.vccanc, wx.DLG_PNT(self.pnl, 255, 120), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) self.descriz_art = wx.TextCtrl( self.pnl, -1, "", wx.DLG_PNT(self.pnl, 5, 120), wx.DLG_SZE(self.pnl, 85, cfg.DIMFONTDEFAULT), wx.TE_PROCESS_ENTER) self.descriz_art.SetFont(self.font) self.cdescriz_art = wx.BitmapButton( self.pnl, -1, png, wx.DLG_PNT(self.pnl, 95, 120), wx.DLG_SZE(self.pnl, cfg.btnSzeSH, cfg.btnSzeV)) #self.cdescriz_art=wx.Button(self.pnl , -1, "Cerca", #wx.DLG_PNT(self.pnl , 95,120), #wx.DLG_SZE(self.pnl,cfg.btnSzeLH,cfg.btnSzeV)) for x in self.pnl.GetChildren(): x.SetFont(self.font) self.canc.SetFocus() #self.SetFont(self.font) box_sizer = wx.BoxSizer(wx.VERTICAL) box_sizer.Add(self.pnl, 0, wx.EXPAND | wx.ALL, 0) self.SetAutoLayout(1) self.SetSizer(box_sizer) box_sizer.Fit(self) self.canc.Bind(wx.EVT_BUTTON, self.Close) self.Bind(wx.EVT_CLOSE, self.Close) self.ok.Bind(wx.EVT_BUTTON, self.Ok) self.cdescriz_art.Bind(wx.EVT_BUTTON, self.OnListSelectDesc) self.lc.Bind(wx.EVT_LEFT_DCLICK, self.DblClick) self.lc.Bind(wx.EVT_LIST_ITEM_SELECTED, self.OnListSelect) self.lc.Bind(wx.EVT_LIST_ITEM_ACTIVATED, self.DblClick) self.descriz_art.Bind(wx.EVT_TEXT_ENTER, self.OnListSelectDesc) val = self.cnt[2].GetValue().upper() cod = self.cnt[1].GetValue().upper() valore = [val, cod] self.Start(valore)
def __init__(self, prnt, cnt): wx.MiniFrame.__init__(self, id=wx.NewId(), name='', parent=prnt, pos=wx.Point(0, 0), style=wx.DEFAULT_FRAME_STYLE, title=ttl) self.SetIcon(wx.Icon(cfg.path_img+"/null.ico", wx.BITMAP_TYPE_ICO)) #self.SetFont(wx.Font(12, wx.SWISS, wx.NORMAL, wx.NORMAL, False)) self.cnt = cnt self.tcpart = cnt[0] Nid = wx.NewId() self.CnAz = prnt.CnAz #self.font = self.GetFont() self.__FRM__ = prnt.__FRM__ self.__MDI__ = wx.GetApp().GetPhasisMdi() self.font=self.__MDI__.font self.SetFont(self.font) self.pnl = wx.Panel(id = wx.NewId(), name = 'panel', parent = self, pos = wx.Point(0, 0)) self.pnl.SetFont(self.font) self.lc = wx.ListCtrl(self.pnl , Nid, wx.DLG_PNT(self, 5,5), wx.DLG_SZE(self.pnl , 335,110), wx.LC_REPORT|wx.LC_HRULES|wx.LC_VRULES) self.lc.InsertColumn(0, _("Codice")) self.lc.InsertColumn(1, _("Rag. Soc.1 Cognome")) self.lc.InsertColumn(2, _("Rag. Soc.2 Nome")) self.lc.InsertColumn(3, _("Indirizzo")) self.lc.InsertColumn(4, _("Telefono")) self.lc.InsertColumn(5, _("Ufficio")) self.lc.InsertColumn(6, _("Fax")) self.lc.SetColumnWidth(0, wx.DLG_SZE(self, 30,-1).width) self.lc.SetColumnWidth(1, wx.DLG_SZE(self, 70,-1).width) self.lc.SetColumnWidth(2, wx.DLG_SZE(self, 70,-1).width) self.lc.SetColumnWidth(3, wx.DLG_SZE(self, 100,-1).width) self.lc.SetColumnWidth(4, wx.DLG_SZE(self, 60,-1).width) self.lc.SetColumnWidth(5, wx.DLG_SZE(self, 60,-1).width) self.lc.SetColumnWidth(6, wx.DLG_SZE(self, 60,-1).width) #self.lc.SetFont(self.font) rowlc=0 codcf = self.cnt[4].GetValue() val=self.cnt[2].GetValue().upper() sql = """ SELECT * FROM tblcf WHERE rag_soc1 like '%s' AND t_cpart = '%s' AND CODCF = '%s' ORDER BY rag_soc1 DESC """ valueSql = '%'+val.title()+'%', self.tcpart, int(codcf) try: cr = self.CnAz.cursor () cr.execute(sql % valueSql) rows = cr.fetchall() for row in rows: for rowlc in range(1): row_lc = self.lc.GetItemCount() t_cpart = str(row[0]) cod = str(row[1]) ragsoc1 = str(row[3]).title() ragsoc2 = str(row[4]).title() indiriz = str(row[6]).title() tel_abi = str(row[12]) tel_uff = str(row[13]) fax = str(row[14]) self.lc.InsertStringItem(rowlc, cod) self.lc.SetStringItem(rowlc, 1, ragsoc1) self.lc.SetStringItem(rowlc, 2, ragsoc2) self.lc.SetStringItem(rowlc, 3, indiriz) self.lc.SetStringItem(rowlc, 4, tel_abi) self.lc.SetStringItem(rowlc, 5, tel_uff) self.lc.SetStringItem(rowlc, 6, fax) self.lc.SetItemData(1,0) except StandardError, msg: self.__FRM__.MsgErr("scrtblcf"," Cerca tblcf Error %s" % (msg))
def __init__(self, prnt, cnt): wx.Dialog.__init__(self, id = wx.NewId(), name = '', parent = prnt, pos = wx.Point(10, 50), size = wx.DefaultSize, style = wx.DEFAULT_FRAME_STYLE, title = ttl) self.SetIcon(wx.Icon(cfg.path_img+"/null.ico", wx.BITMAP_TYPE_ICO)) #self.SetFont(wx.Font(12, wx.SWISS, wx.NORMAL, wx.NORMAL, False)) #self.font = wx.Font(12, wx.SWISS, wx.NORMAL, wx.NORMAL, False)#self.GetFont() #self.font=wx.SystemSettings_GetFont(wx.SYS_DEFAULT_GUI_FONT) #y=wx.ScreenDC().MaxY() #if y>=1200 : numfont=16 #elif y>=1024 : numfont=14 #else : numfont=12 #if cfg.FONTFISSO!=0 : numfont=cfg.FONTFISSO #self.font.SetPointSize(numfont) #self.SetFont(self.font) self.__MDI__=wx.GetApp().GetPhasisMdi() self.font=self.__MDI__.font self.SetFont(self.font) self.cnt = cnt tcpart = cnt[0] if (tcpart=="Z"): fdb.CnDBAZ self.tblanag = "aziende" if (tcpart=="C" or tcpart=="F" or tcpart=="V" or tcpart=="T"): self.CnAz = prnt.CnAz self.tblanag = "anag" if (tcpart=="A"): self.CnAz = prnt.CnAz self.tblanag = "agenti" self.tcpart = tcpart Nid = wx.NewId() #self.font = self.GetFont() self.__FRM__ = prnt.__MDI__ self.pnl = wx.Panel(id = wx.NewId(), name = 'panel', parent = self, pos = wx.Point(0, 0)) self.pnl.SetFont(self.font) self.lc = wx.ListCtrl(self.pnl , Nid, wx.DLG_PNT(self, 5,5), wx.DLG_SZE(self.pnl , 335,110), wx.LC_REPORT|wx.LC_HRULES|wx.LC_VRULES) self.lc.SetFont(self.font) self.lc.InsertColumn(0, _("Codice")) self.lc.InsertColumn(1, _("Rag. Soc.1 Cognome")) self.lc.InsertColumn(2, _("Rag. Soc.2 Nome")) self.lc.InsertColumn(3, _("Indirizzo")) self.lc.InsertColumn(4, _("Telefono")) self.lc.InsertColumn(5, _("Mobile")) self.lc.InsertColumn(6, _("Ufficio")) self.lc.InsertColumn(7, _("Fax")) self.lc.SetColumnWidth(0, wx.DLG_SZE(self, 30,-1).width) self.lc.SetColumnWidth(1, wx.DLG_SZE(self, 70,-1).width) self.lc.SetColumnWidth(2, wx.DLG_SZE(self, 70,-1).width) self.lc.SetColumnWidth(3, wx.DLG_SZE(self, 100,-1).width) self.lc.SetColumnWidth(4, wx.DLG_SZE(self, 60,-1).width) self.lc.SetColumnWidth(5, wx.DLG_SZE(self, 60,-1).width) self.lc.SetColumnWidth(6, wx.DLG_SZE(self, 60,-1).width) self.lc.SetColumnWidth(7, wx.DLG_SZE(self, 0,-1).width) #self.lc.SetFont(self.font) rowlc = 0 cod = self.cnt[1].GetValue().upper() val = self.cnt[2].GetValue().upper() valueSql = '%'+val.title()+'%', self.tcpart ## Funzione cerca if self.tblanag=='agenti' : sql = """ SELECT * FROM agenti WHERE rag_soc1 like '%s' AND t_cpart = '%s' ORDER BY rag_soc1 DESC """ elif self.tblanag=='aziende' : sql = """ SELECT * FROM aziende WHERE rag_soc1 like '%s' AND t_cpart = '%s' ORDER BY rag_soc1 DESC """ else: sql = """ SELECT * FROM anag WHERE rag_soc1 like '%s' AND t_cpart = '%s' ORDER BY rag_soc1 DESC """ try: if self.tcpart=="Z" :cr = fdb.CnDBAZ.cursor () else: cr = self.CnAz.cursor () cr.execute(sql % valueSql) rows = cr.fetchall() for row in rows: for rowlc in range(1): row_lc = self.lc.GetItemCount() t_cpart = str(row[0]) cod = str(row[1]) ragsoc1 = str(row[3]).title() ragsoc2 = str(row[4]).title() indiriz = str(row[6]).title() tel_abi = str(row[18]) tel_uff = str(row[19]) mobile = str(row[20]) fax = str(row[21]) self.lc.InsertStringItem(rowlc, cod) self.lc.SetStringItem(rowlc, 1, ragsoc1) self.lc.SetStringItem(rowlc, 2, ragsoc2) self.lc.SetStringItem(rowlc, 3, indiriz) self.lc.SetStringItem(rowlc, 4, tel_abi) self.lc.SetStringItem(rowlc, 5, mobile) self.lc.SetStringItem(rowlc, 6, tel_abi) self.lc.SetStringItem(rowlc, 7, fax) self.lc.SetItemData(0,0) #self.lc.SetItemFont(rowlc,self.font) except StandardError, msg: self.__FRM__.MsgErr("SrcAnag"," Cerca Error %s" % (msg))
class SrcOrdBuoni(wx.Dialog): def __init__(self, prnt, cnt): wx.Dialog.__init__(self, id=wx.NewId(), name='', parent=prnt, pos=wx.Point(10, 50), size=wx.DefaultSize, style=wx.DEFAULT_FRAME_STYLE, title=ttl) #self.SetIcon(wx.Icon(cfg.path_img+"/null.ico", wx.BITMAP_TYPE_ICO)) #self.SetFont(wx.Font(12, wx.SWISS, wx.NORMAL, wx.NORMAL, False)) self.cnt = cnt #self.tipo_ord = cnt[0] #print self.cnt vTIPO_ORD = cnt[0].GetValue() anno = cnt[1].GetValue() num_ord = cnt[2].GetValue() data_doc = cnt[3].GetValue() #stt_doc = cnt[5] Nid = wx.NewId() self.CnAz = prnt.CnAz #self.font = self.GetFont() self.__FRM__ = prnt.__MDI__ self.__MDI__ = wx.GetApp().GetPhasisMdi() self.font=self.__MDI__.font self.SetFont(self.font) self.pnl = wx.Panel(id=wx.NewId(), name='panel', parent=self, pos=wx.Point(0, 0), size = wx.DLG_SZE(self,540/2,260/2)) #, #size=wx.Size(540, 260)) self.pnl.SetFont(self.font) self.lc = wx.ListCtrl(self.pnl , Nid, wx.DLG_PNT(self, 5,5), wx.DLG_SZE(self.pnl , 300,100), wx.LC_REPORT|wx.LC_HRULES|wx.LC_VRULES) self.lc.InsertColumn(0, _("Tipo Ord")) self.lc.InsertColumn(1, _("Num Ord")) self.lc.InsertColumn(2, _("Data Ord")) self.lc.InsertColumn(3, _("Rag. Soc.1 Cognome")) self.lc.InsertColumn(4, _("Rag. Soc.2 Nome")) self.lc.SetColumnWidth(0, wx.DLG_SZE(self, 20,-1).width) self.lc.SetColumnWidth(1, wx.DLG_SZE(self, 40,-1).width) self.lc.SetColumnWidth(2, wx.DLG_SZE(self, 60,-1).width) self.lc.SetColumnWidth(3, wx.DLG_SZE(self, 95,-1).width) self.lc.SetColumnWidth(4, wx.DLG_SZE(self, 90,-1).width) #self.lc.SetFont(self.font) rowlc=0 val="" #if data_doc!="" : sql = """ select * from ordi1 where tipo_ord = "%s" and anno = "%s" """ valueSql = vTIPO_ORD, anno #print sql % valueSql #elif num_ord=="" and stt_doc=="" : # sql = """ select * from docu1 # where num_ord like "%s" and tipo_ord = "%s" # and anno = "%s" """ # valueSql = '%%', vTIPO_ORD, anno try: cr = self.CnAz.cursor () cr.execute(sql % valueSql) rows = cr.fetchall() for row in rows: for rowlc in range(1): #print row row_lc = self.lc.GetItemCount() num_ord = str(row[2]) vsdata = str(row[16]) data_doc = str(row[3]) ragsoc1 = str(row[5]).title() ragsoc2 = str(row[6]).title() tipo_ord = str(row[0]) anno = str(row[1]) self.lc.InsertStringItem(rowlc,tipo_ord) self.lc.SetStringItem(rowlc, 1, num_ord) self.lc.SetStringItem(rowlc, 2, data_doc) self.lc.SetStringItem(rowlc, 3, ragsoc1) self.lc.SetStringItem(rowlc, 4, ragsoc2) self.lc.SetItemData(0,0) except StandardError, msg: self.__FRM__.MsgErr("srcdoc"," SrcOrdBuoni Error %s" % (msg)) self.CnAz.commit() self.currentItem = 0 wx.StaticLine(self.pnl , -1, wx.DLG_PNT(self.pnl , 5,115), wx.DLG_SZE(self.pnl , 300,-1)) wx.StaticLine(self.pnl , -1, wx.DLG_PNT(self.pnl , 5,115), wx.DLG_SZE(self.pnl , 300,-1)) self.ok = wx.Button(self.pnl , Nid, cfg.vcconf, wx.DLG_PNT(self.pnl , 195,120), wx.DLG_SZE(self.pnl,cfg.btnSzeMH,cfg.btnSzeV)) self.canc=wx.Button(self.pnl , Nid, cfg.vccanc, wx.DLG_PNT(self.pnl , 255,120), wx.DLG_SZE(self.pnl,cfg.btnSzeMH,cfg.btnSzeV)) self.canc.SetFocus() #self.SetFont(self.font) for x in self.pnl.GetChildren(): x.SetFont(self.font) box_sizer = wx.BoxSizer(wx.VERTICAL) box_sizer.Add(self.pnl, 0, wx.EXPAND|wx.ALL,0) self.SetAutoLayout(1) self.SetSizer(box_sizer) box_sizer.Fit(self) self.canc.Bind(wx.EVT_BUTTON, self.Close) self.ok.Bind(wx.EVT_BUTTON, self.Ok) self.lc.Bind(wx.EVT_LEFT_DCLICK, self.DblClick) self.lc.Bind(wx.EVT_LIST_ITEM_ACTIVATED, self.LstAct) self.lc.Bind(wx.EVT_LIST_ITEM_SELECTED, self.LstSlct) self.Bind(wx.EVT_CLOSE, self.Close)
def __init__(self, prnt, cnt): wx.Dialog.__init__(self, id=wx.NewId(), name='', parent=prnt, pos=wx.Point(10, 50), size=wx.DefaultSize, style=wx.DEFAULT_FRAME_STYLE, title=ttl) #self.SetIcon(wx.Icon(cfg.path_img+"/null.ico", wx.BITMAP_TYPE_ICO)) #self.SetFont(wx.Font(12, wx.SWISS, wx.NORMAL, wx.NORMAL, False)) self.cnt = cnt #self.tipo_doc = cnt[0] #print self.cnt vTIPO_SCAD = cnt[0].GetValue() anno = cnt[1] data_scad_int = cnt[2] data_scad_int_A = cnt[6] vCF = cnt[4] num_doc = cnt[5] print "srcscadr" #data_doc = cnt[3].GetValue() #stt_doc = cnt[5] Nid = wx.NewId() self.CnAz = prnt.CnAz #self.font = self.GetFont() self.__FRM__ = prnt.__MDI__ self.__MDI__ = wx.GetApp().GetPhasisMdi() self.font = self.__MDI__.font self.SetFont(self.font) self.pnl = wx.Panel(id=wx.NewId(), name='panel', parent=self, pos=wx.Point(0, 0), size=wx.DLG_SZE(self, 540 / 2, 260 / 2)) #, #size=wx.Size(540, 260)) self.pnl.SetFont(self.font) self.lc = wx.ListCtrl(self.pnl, Nid, wx.DLG_PNT(self, 5, 5), wx.DLG_SZE(self.pnl, 300, 100), wx.LC_REPORT | wx.LC_HRULES | wx.LC_VRULES) self.lc.InsertColumn(0, _("Data Scad")) self.lc.InsertColumn(1, _("Anno")) self.lc.InsertColumn(2, _("Tipo Scad")) self.lc.InsertColumn(3, _("Rag. Soc.1 Cognome")) self.lc.InsertColumn(4, _("Rag. Soc.2 Nome")) self.lc.InsertColumn(5, _("Num. Scad.")) self.lc.SetColumnWidth(0, wx.DLG_SZE(self, 40, -1).width) self.lc.SetColumnWidth(1, wx.DLG_SZE(self, 20, -1).width) self.lc.SetColumnWidth(2, wx.DLG_SZE(self, 60, -1).width) self.lc.SetColumnWidth(3, wx.DLG_SZE(self, 95, -1).width) self.lc.SetColumnWidth(4, wx.DLG_SZE(self, 90, -1).width) self.lc.SetColumnWidth(5, wx.DLG_SZE(self, 30, -1).width) #self.lc.SetFont(self.font) rowlc = 0 val = "" sql = """ select * from scad where tipo_scad = "%s" and t_cpart = "%s" and data_scad_int >= "%s" and data_scad_int <= "%s" order by data_scad_int desc """ valueSql = vTIPO_SCAD, vCF, int(data_scad_int), int(data_scad_int_A) try: cr = self.CnAz.cursor() cr.execute(sql % valueSql) rows = cr.fetchall() for row in rows: for rowlc in range(1): row_lc = self.lc.GetItemCount() data_scad = str(row[2]) anno = str(row[1]) tipo_scad = str(row[3]) ragsoc1 = str(row[7]).title() ragsoc2 = str(row[8]).title() num_scad = str(row[0]) self.lc.InsertStringItem(rowlc, data_scad) self.lc.SetStringItem(rowlc, 1, anno) self.lc.SetStringItem(rowlc, 2, tipo_scad) self.lc.SetStringItem(rowlc, 3, ragsoc1) self.lc.SetStringItem(rowlc, 4, ragsoc2) self.lc.SetStringItem(rowlc, 5, num_scad) self.lc.SetItemData(0, 0) except StandardError, msg: self.__FRM__.MsgErr("srcscadr", " srcscad Error %s" % (msg))
def __init__(self, prnt, cnt): self.win = wx.ScrolledWindow.__init__(self, parent=prnt, id=-1, size=wx.DefaultSize) self.SetScrollbars(1, 1, 100, 100) ##### self.FitInside() ###### png = wx.Image((cfg.path_img + "cerca19x19.png"), wx.BITMAP_TYPE_PNG).ConvertToBitmap() #wx.Frame.__init__(self, id = wx.NewId(), name = '', # parent = prnt, pos = wx.Point(0, 0), # style = wx.DEFAULT_FRAME_STYLE , title = cnt[0]) #self.SetIcon(wx.Icon(cfg.path_img+"/null.ico", wx.BITMAP_TYPE_ICO)) #self.SetFont(wx.Font(12, wx.SWISS, wx.NORMAL, wx.NORMAL, False)) self.cnt = cnt Nid = wx.NewId() self.ttl = cnt[0] self.tipodoc = cnt[1] self.tcpart = "C" #self.ottl = "Gestione Documenti" self.tbl = "docu1" self.tblart = "articoli" self.rec = cnt[2] self.AggMenu = cnt[3] self.IDMENU = cnt[4] self.CMD = cnt[5] #self.SetClientSize(wx.Size(600, 400)) #self.font = self.GetFont() self.__MDI__ = wx.GetApp().GetPhasisMdi() self.font = self.__MDI__.font self.SetFont(self.font) self.CnAz = self.__MDI__.GetConnAZ() self.annoc = self.__MDI__.GetAnnoC() self.datacon = self.__MDI__.GetDataC() self.pnl = wx.Panel(id=wx.NewId(), name='panel', parent=self, pos=wx.Point(0, 0), style=wx.SIMPLE_BORDER | wx.TAB_TRAVERSAL) #, size = wx.Size(680, 400)) self.pnl.SetFont(self.font) self.lc = wx.ListCtrl(self.pnl, Nid, wx.DLG_PNT(self, 5, 5), wx.DLG_SZE(self.pnl, 335, 120), wx.LC_REPORT | wx.LC_HRULES | wx.LC_VRULES) wx.StaticLine(self.pnl, -1, wx.DLG_PNT(self.pnl, 5, 130), wx.DLG_SZE(self.pnl, 335, -1)) wx.StaticText(self.pnl, -1, _("Rag. Soc.:"), wx.DLG_PNT(self, 25, 142)) self.rs = wx.TextCtrl(self.pnl, Nid, "", wx.DLG_PNT(self.pnl, 70, 140), wx.DLG_SZE(self.pnl, 100, cfg.DIMFONTDEFAULT), wx.TE_PROCESS_ENTER) self.crs = wx.BitmapButton( self.pnl, -1, png, #wx.Button(self.pnl , Nid, "...", wx.DLG_PNT(self.pnl, 175, 140), wx.DLG_SZE(self.pnl, 12, 12)) wx.StaticText(self.pnl, -1, _("Cod. Articolo:"), wx.DLG_PNT(self, 25, 157)) self.cod = wx.TextCtrl(self.pnl, Nid, "", wx.DLG_PNT(self.pnl, 70, 155), wx.DLG_SZE(self.pnl, 100, cfg.DIMFONTDEFAULT), wx.TE_PROCESS_ENTER) self.ccod = wx.BitmapButton( self.pnl, -1, png, #wx.Button(self.pnl , Nid, "...", wx.DLG_PNT(self.pnl, 175, 155), wx.DLG_SZE(self.pnl, 12, 12)) self.TIPO_DOC = wx.ComboBox( self.pnl, Nid, "", wx.DLG_PNT(self.pnl, 210, 140), wx.DLG_SZE(self.pnl, 125, -1), [], wx.CB_DROPDOWN | wx.CB_SORT | wx.TE_PROCESS_ENTER) self.vTIPO_DOC = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 275, 90)) self.rbEVA = wx.RadioButton(self.pnl, Nid, cfg.vcEVA, wx.DLG_PNT(self.pnl, 210, 155), wx.DLG_SZE(self.pnl, 60, 10), wx.RB_GROUP) self.rbNOEVA = wx.RadioButton(self.pnl, Nid, cfg.vcNOEVA, wx.DLG_PNT(self.pnl, 275, 155), wx.DLG_SZE(self.pnl, 65, 10)) self.stt_doc = wx.TextCtrl(self.pnl, -1, "E", wx.DLG_PNT(self.pnl, 285, 137)) self.ok = wx.Button(self.pnl, Nid, cfg.vcok, wx.DLG_PNT(self.pnl, 210, 170), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) self.canc = wx.Button(self.pnl, Nid, cfg.vccanc, wx.DLG_PNT(self.pnl, 275, 170), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) self.canc.SetFocus() for x in self.pnl.GetChildren(): x.SetFont(self.font) #self.SetFont(self.font) #box_sizer = wx.BoxSizer(wx.VERTICAL) #box_sizer.Add(self.pnl, 0, wx.EXPAND|wx.ALL,0) #self.SetAutoLayout(1) #self.SetSizer(box_sizer) #box_sizer.Fit(self) box = wx.GridSizer(1, 1) box.Add(self.pnl, 0, wx.ALIGN_CENTER | wx.ALL, 10) self.SetSizer(box) box.Fit(self) self.canc.Bind(wx.EVT_BUTTON, self.Close) self.Bind(wx.EVT_CLOSE, self.Close) self.ok.Bind(wx.EVT_BUTTON, self.Ok) self.lc.Bind(wx.EVT_LEFT_DCLICK, self.DblClick) #self.lc.Bind(wx.EVT_LIST_KEY_DOWN, self.DblClick) self.ccod.Bind(wx.EVT_BUTTON, self.FndDoc) self.crs.Bind(wx.EVT_BUTTON, self.FndDoc) self.lc.Bind(wx.EVT_LIST_ITEM_ACTIVATED, self.LstAct) self.lc.Bind(wx.EVT_LIST_ITEM_SELECTED, self.LstSlct) #self.Bind(wx.EVT_LIST_COL_CLICK, self.OnColClick) self.cod.Bind(wx.EVT_TEXT_ENTER, self.FndDoc) self.rs.Bind(wx.EVT_TEXT_ENTER, self.FndDoc) self.TIPO_DOC.Bind(wx.EVT_COMBOBOX, self.SelTIPO_DOC) self.rbEVA.Bind(wx.EVT_RADIOBUTTON, self.RadioB) self.rbNOEVA.Bind(wx.EVT_RADIOBUTTON, self.RadioB) self.vTIPO_DOC.SetValue(cfg.tipodoc_lst) self.SelCOMBO(self) self.Start(self)
def __init__(self, prnt, cnt): wx.Dialog.__init__(self, id=wx.NewId(), name='', parent=prnt, pos=wx.Point(10, 50), size=wx.DefaultSize, style=wx.DEFAULT_FRAME_STYLE, title=ttl) self.SetIcon(wx.Icon(cfg.path_img + "/null.ico", wx.BITMAP_TYPE_ICO)) #self.SetFont(wx.Font(12, wx.SWISS, wx.NORMAL, wx.NORMAL, False)) self.cnt = cnt ctesto = cnt[0] Nid = wx.NewId() #self.font=self.GetFont() self.__MDI__ = wx.GetApp().GetPhasisMdi() self.font = self.__MDI__.font self.SetFont(self.font) self.pnl = wx.Panel(id=100, name='panel', parent=self, pos=wx.Point(0, 0)) #, size=wx.Size(680, 400)) #testo wdim = 0 x 40 caratteri # wdim = 95 x 70 caratteri wdim = 10 self.pnl.SetFont(self.font) self.dtesto = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self, 5, 5), wx.DLG_SZE(self.pnl, 120 + wdim, 100), wx.TE_MULTILINE) self.dtesto.SetFont(self.font) wx.StaticLine(self.pnl, -1, wx.DLG_PNT(self.pnl, 5, 115), wx.DLG_SZE(self.pnl, 115 + wdim, -1)) self.ok = wx.Button(self.pnl, -1, cfg.vcconf, wx.DLG_PNT(self.pnl, 30 + wdim, 120), wx.DLG_SZE(self.pnl, cfg.btnSzeMH, cfg.btnSzeV)) self.ok.SetFont(self.font) self.canc = wx.Button(self.pnl, -1, cfg.vccanc, wx.DLG_PNT(self.pnl, 80 + wdim, 120), wx.DLG_SZE(self.pnl, cfg.btnSzeMH, cfg.btnSzeV)) self.canc.SetFont(self.font) self.canc.SetFocus() #self.SetFont(self.font) box_sizer = wx.BoxSizer(wx.VERTICAL) box_sizer.Add(self.pnl, 0, wx.EXPAND | wx.ALL, 0) self.SetAutoLayout(1) self.SetSizer(box_sizer) box_sizer.Fit(self) self.canc.Bind(wx.EVT_BUTTON, self.Close) self.ok.Bind(wx.EVT_BUTTON, self.Ok) #self.Bind(wx.EVT_LEFT_DCLICK, self.DblClick, self.ctesto) self.Bind(wx.EVT_CLOSE, self.Close)
def __init__(self, prnt, cnt): self.win = wx.ScrolledWindow.__init__(self, parent=prnt, id=-1, size=wx.DefaultSize) self.SetScrollbars(1, 1, 100, 100) ##### self.FitInside() ###### #wx.Dialog.__init__(self, id=wx.NewId(), name='', # parent=prnt, pos=wx.Point(0, 0), size=wx.DefaultSize, # style=wx.DEFAULT_FRAME_STYLE, title=cnt[0]) #self.SetIcon(wx.Icon(cfg.path_img+"/null.ico", wx.BITMAP_TYPE_ICO)) #self.SetFont(wx.Font(12, wx.SWISS, wx.NORMAL, wx.NORMAL, False)) #self.SetClientSize(wx.Size(400, 200)) #self.Center(wx.BOTH) self.rec = cnt[2] self.AggMenu = cnt[3] self.IDMENU = cnt[4] self.ttl = cnt[0] Nid = wx.NewId() self.__MDI__ = wx.GetApp().GetPhasisMdi() self.font = self.__MDI__.font self.SetFont(self.font) self.CnAz = self.__MDI__.GetConnAZ() self.annoc = self.__MDI__.GetAnnoC() self.datacon = self.__MDI__.GetDataC() self.dzDatiAzienda = self.__MDI__.dzDatiAzienda self.pnl = wx.Panel( id=wx.NewId(), name='panel', parent=self, pos=wx.Point(0, 0), size=wx.DLG_SZE(self, 680 / 2, 370 / 2), #size=wx.Size(680, 370), style=wx.SIMPLE_BORDER | wx.TAB_TRAVERSAL) #self.font=self.GetFont() self.pnl.SetFont(self.font) self.label1 = wx.StaticText(self.pnl, -1, '', wx.DLG_PNT(self.pnl, 20, 15)) self.label2 = wx.StaticText(self.pnl, -1, '', wx.DLG_PNT(self.pnl, 20, 25)) self.label3 = wx.StaticText(self.pnl, -1, '', wx.DLG_PNT(self.pnl, 20, 35)) self.label4 = wx.StaticText(self.pnl, -1, '', wx.DLG_PNT(self.pnl, 20, 45)) self.label5 = wx.StaticText(self.pnl, -1, '', wx.DLG_PNT(self.pnl, 20, 55)) wx.StaticLine(self.pnl, -1, wx.DLG_PNT(self.pnl, 5, 80), wx.DLG_SZE(self.pnl, 150, -1)) self.conf = wx.Button(self.pnl, -1, cfg.vcconf, wx.DLG_PNT(self, 15, 90), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) self.canc = wx.Button(self.pnl, -1, cfg.vccanc, wx.DLG_PNT(self, 85, 90), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) for x in self.pnl.GetChildren(): x.SetFont(self.font) #self.SetFont(self.font) #box_sizer = wx.BoxSizer(wx.VERTICAL) #box_sizer.Add(self.pnl, 0, wx.EXPAND|wx.ALL,0) #self.SetAutoLayout(1) #self.SetSizer(box_sizer) #box_sizer.Fit(self) box = wx.GridSizer(1, 1) box.Add(self.pnl, 0, wx.ALIGN_CENTER | wx.ALL, 10) self.SetSizer(box) box.Fit(self) self.Bind(wx.EVT_CLOSE, self.Close) self.canc.Bind(wx.EVT_BUTTON, self.Close) self.conf.Bind(wx.EVT_BUTTON, self.Conferma) self.Start(self)
def __init__(self, prnt, cnt): wx.Dialog.__init__(self, id=wx.NewId(), name='', parent=prnt, pos=wx.Point(10, 50), size=wx.DefaultSize, style=wx.DEFAULT_FRAME_STYLE, title=ttl) self.SetIcon(wx.Icon(cfg.path_img + "/null.ico", wx.BITMAP_TYPE_ICO)) #self.SetFont(wx.Font(12, wx.SWISS, wx.NORMAL, wx.NORMAL, False)) self.cnt = cnt self.SetTitle(cnt[0]) Nid = wx.NewId() self.CnAz = prnt.CnAz #self.font=self.GetFont() self.__FRM__ = prnt self.__MDI__ = wx.GetApp().GetPhasisMdi() self.font = self.__MDI__.font self.SetFont(self.font) self.pnl = wx.Panel(id=wx.NewId(), name='panel', parent=self, pos=wx.Point(0, 0)) self.pnl.SetFont(self.font) self.lc = wx.ListCtrl(self.pnl, Nid, wx.DLG_PNT(self, 5, 5), wx.DLG_SZE(self.pnl, 335, 110), wx.LC_REPORT | wx.LC_HRULES | wx.LC_VRULES) self.lc.InsertColumn(0, _("Valore")) self.lc.InsertColumn(1, _("Descrizione")) self.lc.InsertColumn(2, "") self.lc.SetColumnWidth(0, wx.DLG_SZE(self, 70, -1).width) self.lc.SetColumnWidth(1, wx.DLG_SZE(self, 300, -1).width) self.lc.SetColumnWidth(2, wx.DLG_SZE(self, 0, -1).width) #self.lc.SetFont(self.font) # < diegom rowlc = 0 cod = self.cnt[4] if cod == "ZONA": sql = " SELECT * FROM zona WHERE cod = '%s' ORDER BY descriz DESC " else: sql = " SELECT * FROM tabgen WHERE cod = '%s' ORDER BY descriz DESC " # > diegom try: cr = self.CnAz.cursor() cr.execute(sql % cod) rows = cr.fetchall() for row in rows: for rowlc in range(1): row_lc = self.lc.GetItemCount() cod = str(row[0]) valore = row[1] descriz = row[2] self.lc.InsertStringItem(rowlc, valore) self.lc.SetStringItem(rowlc, 1, descriz) self.lc.SetStringItem(rowlc, 2, cod) self.lc.SetItemData(0, 0) except StandardError, msg: self.__FRM__.MsgErr("SrcTabG", " Fnd Error %s " % (msg))
class SrcTabG(wx.Dialog): def __init__(self, prnt, cnt): wx.Dialog.__init__(self, id=wx.NewId(), name='', parent=prnt, pos=wx.Point(10, 50), size=wx.DefaultSize, style=wx.DEFAULT_FRAME_STYLE, title=ttl) self.SetIcon(wx.Icon(cfg.path_img + "/null.ico", wx.BITMAP_TYPE_ICO)) #self.SetFont(wx.Font(12, wx.SWISS, wx.NORMAL, wx.NORMAL, False)) self.cnt = cnt self.SetTitle(cnt[0]) Nid = wx.NewId() self.CnAz = prnt.CnAz #self.font=self.GetFont() self.__FRM__ = prnt self.__MDI__ = wx.GetApp().GetPhasisMdi() self.font = self.__MDI__.font self.SetFont(self.font) self.pnl = wx.Panel(id=wx.NewId(), name='panel', parent=self, pos=wx.Point(0, 0)) self.pnl.SetFont(self.font) self.lc = wx.ListCtrl(self.pnl, Nid, wx.DLG_PNT(self, 5, 5), wx.DLG_SZE(self.pnl, 335, 110), wx.LC_REPORT | wx.LC_HRULES | wx.LC_VRULES) self.lc.InsertColumn(0, _("Valore")) self.lc.InsertColumn(1, _("Descrizione")) self.lc.InsertColumn(2, "") self.lc.SetColumnWidth(0, wx.DLG_SZE(self, 70, -1).width) self.lc.SetColumnWidth(1, wx.DLG_SZE(self, 300, -1).width) self.lc.SetColumnWidth(2, wx.DLG_SZE(self, 0, -1).width) #self.lc.SetFont(self.font) # < diegom rowlc = 0 cod = self.cnt[4] if cod == "ZONA": sql = " SELECT * FROM zona WHERE cod = '%s' ORDER BY descriz DESC " else: sql = " SELECT * FROM tabgen WHERE cod = '%s' ORDER BY descriz DESC " # > diegom try: cr = self.CnAz.cursor() cr.execute(sql % cod) rows = cr.fetchall() for row in rows: for rowlc in range(1): row_lc = self.lc.GetItemCount() cod = str(row[0]) valore = row[1] descriz = row[2] self.lc.InsertStringItem(rowlc, valore) self.lc.SetStringItem(rowlc, 1, descriz) self.lc.SetStringItem(rowlc, 2, cod) self.lc.SetItemData(0, 0) except StandardError, msg: self.__FRM__.MsgErr("SrcTabG", " Fnd Error %s " % (msg)) self.CnAz.commit() self.currentItem = 0 wx.StaticLine(self.pnl, -1, wx.DLG_PNT(self.pnl, 5, 115), wx.DLG_SZE(self.pnl, 300, -1)) #self.pnl.SetFont(self.font) self.ok = wx.Button(self.pnl, Nid, cfg.vcconf, wx.DLG_PNT(self.pnl, 195, 120), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) self.canc = wx.Button(self.pnl, Nid, cfg.vccanc, wx.DLG_PNT(self.pnl, 255, 120), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) for x in self.pnl.GetChildren(): x.SetFont(self.font) self.canc.SetFocus() #self.SetFont(self.font) box_sizer = wx.BoxSizer(wx.VERTICAL) box_sizer.Add(self.pnl, 0, wx.EXPAND | wx.ALL, 0) self.SetAutoLayout(1) self.SetSizer(box_sizer) box_sizer.Fit(self) self.canc.Bind(wx.EVT_BUTTON, self.Close) self.Bind(wx.EVT_CLOSE, self.Close) self.ok.Bind(wx.EVT_BUTTON, self.Ok) self.lc.Bind(wx.EVT_LEFT_DCLICK, self.DblClick) self.lc.Bind(wx.EVT_LIST_ITEM_SELECTED, self.OnListSelect) self.lc.Bind(wx.EVT_LIST_ITEM_ACTIVATED, self.DblClick)
def __init__(self, prnt, cnt): self.win = wx.ScrolledWindow.__init__(self, parent=prnt, id=-1, size=wx.DefaultSize) self.SetScrollbars(1, 1, 100, 100) ##### self.FitInside() ###### png = wx.Image((cfg.path_img + "cerca19x19.png"), wx.BITMAP_TYPE_PNG).ConvertToBitmap() self.ttl = cnt[0] tcpart = cnt[1].upper() #self.tblanag="aziende" self.tcpart = tcpart self.rec = cnt[2] self.AggMenu = cnt[3] self.IDMENU = cnt[4] self.__MDI__ = wx.GetApp().GetPhasisMdi() self.font = self.__MDI__.font self.SetFont(self.font) #self.font=self.GetFont() self.color = self.GetBackgroundColour() #self.tblage="agenti" Nid = wx.NewId() self.pnl = wx.Panel( id=wx.NewId(), name='panel', parent=self, pos=wx.Point(0, 0), size=wx.DLG_SZE(self, 680 / 2, 370 / 2), #size=wx.Size(680, 370), style=wx.SIMPLE_BORDER | wx.TAB_TRAVERSAL) self.pnl.SetFont(self.font) self.ntbk = wx.Notebook( id=wx.NewId(), name='notebook', parent=self.pnl, pos=wx.DLG_PNT(self.pnl, 10 / 2, 120 / 2), #pos=wx.Point(10, 120), size=wx.DLG_SZE(self.pnl, cfg.NTBKH1TUTTI / 2, cfg.NTBKV1TUTTI / 2), style=0) #size=wx.Size(cfg.NTBKH1TUTTI,cfg.NTBKV1TUTTI),style=0) self.ntbk.SetFont(self.font) self.pnl1 = wx.Panel(id=wx.NewId(), name='panel0', parent=self.ntbk, pos=wx.Point(0, 0), size=wx.DLG_SZE(self.pnl, 600 / 2, 220 / 2)) #size=wx.Size(600, 220)) self.pnl1.SetFont(self.font) self.pnl2 = wx.Panel(id=wx.NewId(), name='panel1', parent=self.ntbk, pos=wx.Point(0, 0), size=wx.DLG_SZE(self.pnl, 600 / 2, 220 / 2)) #size=wx.Size(600, 220)) self.pnl2.SetFont(self.font) self.pnl0 = wx.Panel(id=wx.NewId(), name='panel2', parent=self.ntbk, pos=wx.Point(0, 0), size=wx.DLG_SZE(self.pnl, 600 / 2, 220 / 2)) #size=wx.Size(600, 220)) self.pnl0.SetFont(self.font) self.ntbk.AddPage(imageId=-1, page=self.pnl0, select=True, text=_(' Sede Legale')) self.ntbk.AddPage(imageId=-1, page=self.pnl1, select=False, text=_(' Sede Ammnistrativa ')) self.ntbk.AddPage(imageId=-1, page=self.pnl2, select=False, text=_(' Contabile ed Altro')) #self.pnl.SetFont(self.font) #self.pnl1.SetFont(self.font) #self.pnl2.SetFont(self.font) #self.pnl0.SetFont(self.font) #self.ntbk.SetFont(self.font) self.t_cpart = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 275, 37)) self.lcodcf = wx.StaticText(self.pnl, -1, _("Codice :"), wx.DLG_PNT(self.pnl, 5, 7)) self.lcodcf.SetFont(self.font) self.codcf = wx.TextCtrl(self.pnl, Nid, "", wx.DLG_PNT(self.pnl, 45, 5), wx.DLG_SZE(self.pnl, 60, cfg.DIMFONTDEFAULT)) self.codcf.SetFont(self.font) self.ccodcf = wx.BitmapButton( self.pnl, -1, png, #wx.Button(self.pnl, Nid, "...", wx.DLG_PNT(self.pnl, 110, 5), wx.DLG_SZE(self.pnl, cfg.btnSzeSH, cfg.btnSzeV)) self.lragsoc1 = wx.StaticText(self.pnl, -1, _("Rag. Sociale ( Cognome ) :"), wx.DLG_PNT(self.pnl, 5, 22)) self.lragsoc1.SetFont(self.font) self.ragsoc1 = wx.TextCtrl( self.pnl, Nid, "", wx.DLG_PNT(self.pnl, 5, 35), wx.DLG_SZE(self.pnl, 120, cfg.DIMFONTDEFAULT), wx.TE_PROCESS_ENTER) self.ragsoc1.SetFont(self.font) self.cragsoc1 = wx.BitmapButton( self.pnl, -1, png, #wx.Button(self.pnl, Nid, "...", wx.DLG_PNT(self.pnl, 130, 35), wx.DLG_SZE(self.pnl, cfg.btnSzeSH, cfg.btnSzeV)) wx.StaticText(self.pnl, -1, _("( Nome ) :"), wx.DLG_PNT(self.pnl, 150, 22)).SetFont(self.font) self.ragsoc2 = wx.TextCtrl( self.pnl, Nid, "", wx.DLG_PNT(self.pnl, 150, 35), wx.DLG_SZE(self.pnl, 110, cfg.DIMFONTDEFAULT)) self.ragsoc2.SetFont(self.font) wx.StaticText(self.pnl0, -1, _("Indirizzo :"), wx.DLG_PNT(self.pnl0, 5, 7)).SetFont(self.font) self.indiriz = wx.TextCtrl( self.pnl0, Nid, "", wx.DLG_PNT(self.pnl0, 45, 5), wx.DLG_SZE(self.pnl0, 210, cfg.DIMFONTDEFAULT)) self.indiriz.SetFont(self.font) wx.StaticText(self.pnl0, -1, _("Citta` :"), wx.DLG_PNT(self.pnl0, 5, 22)).SetFont(self.font) self.zona = wx.TextCtrl(self.pnl0, Nid, "", wx.DLG_PNT(self.pnl0, 45, 20), wx.DLG_SZE(self.pnl0, 100, cfg.DIMFONTDEFAULT)) self.zona.SetFont(self.font) wx.StaticText(self.pnl0, -1, _("CAP :"), wx.DLG_PNT(self.pnl0, 150, 22)).SetFont(self.font) self.cap = wx.TextCtrl(self.pnl0, Nid, "", wx.DLG_PNT(self.pnl0, 175, 20), wx.DLG_SZE(self.pnl0, 35, cfg.DIMFONTDEFAULT)) self.cap.SetFont(self.font) wx.StaticText(self.pnl0, -1, _("PR :"), wx.DLG_PNT(self.pnl0, 215, 22)).SetFont(self.font) self.pr = wx.TextCtrl(self.pnl0, Nid, "", wx.DLG_PNT(self.pnl0, 235, 20), wx.DLG_SZE(self.pnl0, 20, cfg.DIMFONTDEFAULT)) self.pr.SetFont(self.font) self.ltabi = wx.StaticText(self.pnl0, -1, _("Telefono :"), wx.DLG_PNT(self.pnl0, 5, 37)) self.ltabi.SetFont(self.font) self.tabi = wx.TextCtrl(self.pnl0, Nid, "", wx.DLG_PNT(self.pnl0, 45, 35), wx.DLG_SZE(self.pnl0, 85, cfg.DIMFONTDEFAULT)) self.tabi.SetFont(self.font) wx.StaticText(self.pnl0, -1, _("Fax :"), wx.DLG_PNT(self.pnl0, 140, 37)) self.fax = wx.TextCtrl(self.pnl0, Nid, "", wx.DLG_PNT(self.pnl0, 170, 35), wx.DLG_SZE(self.pnl0, 85, -1)) self.fax.SetFont(self.font) #self.lmob = wx.StaticText(self.pnl0, -1, "Mobile :", # wx.DLG_PNT(self.pnl0, 140,37)) #self.lmob.SetFont(self.font) #self.mob = wx.TextCtrl(self.pnl0, Nid, "", # wx.DLG_PNT(self.pnl0, 170, 35), wx.DLG_SZE(self.pnl0, 85,cfg.DIMFONTDEFAULT)) #self.mob.SetFont(self.font) wx.StaticText(self.pnl0, -1, _("Localita` :"), wx.DLG_PNT(self.pnl0, 5, 52)).SetFont(self.font) self.localit = wx.TextCtrl( self.pnl0, Nid, "", wx.DLG_PNT(self.pnl0, 45, 50), wx.DLG_SZE(self.pnl0, 85, cfg.DIMFONTDEFAULT)) self.localit.SetFont(self.font) wx.StaticText(self.pnl0, -1, _("Stato :"), wx.DLG_PNT(self.pnl0, 140, 52)).SetFont(self.font) self.stato = wx.TextCtrl(self.pnl0, Nid, "", wx.DLG_PNT(self.pnl0, 170, 50), wx.DLG_SZE(self.pnl0, 85, cfg.DIMFONTDEFAULT)) self.stato.SetFont(self.font) wx.StaticText(self.pnl0, -1, _(" EMail :"), wx.DLG_PNT(self.pnl0, 5, 67)).SetFont(self.font) self.email = wx.TextCtrl( self.pnl0, Nid, "", wx.DLG_PNT(self.pnl0, 45, 65), wx.DLG_SZE(self.pnl0, 120, cfg.DIMFONTDEFAULT)) self.email.SetFont(self.font) wx.StaticText(self.pnl0, -1, _(" Url :"), wx.DLG_PNT(self.pnl0, 5, 82)).SetFont(self.font) self.web = wx.TextCtrl(self.pnl0, Nid, "", wx.DLG_PNT(self.pnl0, 45, 80), wx.DLG_SZE(self.pnl0, 120, cfg.DIMFONTDEFAULT)) self.web.SetFont(self.font) wx.StaticText(self.pnl1, -1, _("Indirizzo :"), wx.DLG_PNT(self.pnl1, 5, 7)).SetFont(self.font) self.indiriz1 = wx.TextCtrl( self.pnl1, Nid, "", wx.DLG_PNT(self.pnl1, 45, 5), wx.DLG_SZE(self.pnl1, 210, cfg.DIMFONTDEFAULT)) self.indiriz1.SetFont(self.font) wx.StaticText(self.pnl1, -1, _("Citta`:"), wx.DLG_PNT(self.pnl1, 5, 22)).SetFont(self.font) self.zona1 = wx.TextCtrl( self.pnl1, Nid, "", wx.DLG_PNT(self.pnl1, 45, 20), wx.DLG_SZE(self.pnl1, 100, cfg.DIMFONTDEFAULT)) self.zona1.SetFont(self.font) wx.StaticText(self.pnl1, -1, _("CAP :"), wx.DLG_PNT(self.pnl1, 150, 22)).SetFont(self.font) self.cap1 = wx.TextCtrl(self.pnl1, Nid, "", wx.DLG_PNT(self.pnl1, 175, 20), wx.DLG_SZE(self.pnl1, 35, cfg.DIMFONTDEFAULT)) self.cap1.SetFont(self.font) wx.StaticText(self.pnl1, -1, _("PR :"), wx.DLG_PNT(self.pnl1, 215, 22)).SetFont(self.font) self.pr1 = wx.TextCtrl(self.pnl1, Nid, "", wx.DLG_PNT(self.pnl1, 235, 20), wx.DLG_SZE(self.pnl1, 20, cfg.DIMFONTDEFAULT)) self.pr1.SetFont(self.font) wx.StaticText(self.pnl1, -1, _("Localita` :"), wx.DLG_PNT(self.pnl1, 5, 37)).SetFont(self.font) self.localit1 = wx.TextCtrl( self.pnl1, Nid, "", wx.DLG_PNT(self.pnl1, 45, 35), wx.DLG_SZE(self.pnl1, 85, cfg.DIMFONTDEFAULT)) self.localit1.SetFont(self.font) wx.StaticText(self.pnl1, -1, _("Stato :"), wx.DLG_PNT(self.pnl1, 140, 37)).SetFont(self.font) self.stato1 = wx.TextCtrl( self.pnl1, Nid, "", wx.DLG_PNT(self.pnl1, 170, 35), wx.DLG_SZE(self.pnl1, 85, cfg.DIMFONTDEFAULT)) self.stato1.SetFont(self.font) self.ltuff = wx.StaticText(self.pnl1, -1, _("Telefono :"), wx.DLG_PNT(self.pnl1, 5, 52)) self.ltuff.SetFont(self.font) self.tuff = wx.TextCtrl(self.pnl1, Nid, "", wx.DLG_PNT(self.pnl1, 45, 50), wx.DLG_SZE(self.pnl1, 85, cfg.DIMFONTDEFAULT)) self.tuff.SetFont(self.font) #wx.StaticText(self.pnl1, -1, "Fax :", wx.DLG_PNT(self.pnl1, 140,52)).SetFont(self.font) #self.fax = wx.TextCtrl(self.pnl1, Nid, "", # wx.DLG_PNT(self.pnl1, 170, 50), wx.DLG_SZE(self.pnl1, 85,cfg.DIMFONTDEFAULT)) #self.fax.SetFont(self.font) wx.StaticText(self.pnl1, -1, _("Mobile :"), wx.DLG_PNT(self.pnl1, 140, 52)) self.mob = wx.TextCtrl(self.pnl1, Nid, "", wx.DLG_PNT(self.pnl1, 170, 50), wx.DLG_SZE(self.pnl1, 85, -1)) wx.StaticText(self.pnl2, -1, _("P.IVA :"), wx.DLG_PNT(self.pnl2, 5, 22)).SetFont(self.font) self.piva = wx.TextCtrl(self.pnl2, Nid, "", wx.DLG_PNT(self.pnl2, 35, 20), wx.DLG_SZE(self.pnl2, 85, cfg.DIMFONTDEFAULT)) self.piva.SetFont(self.font) wx.StaticText(self.pnl2, -1, _("C.F. :"), wx.DLG_PNT(self.pnl2, 140, 22)).SetFont(self.font) self.codfisc = wx.TextCtrl( self.pnl2, Nid, "", wx.DLG_PNT(self.pnl2, 165, 20), wx.DLG_SZE(self.pnl2, 85, cfg.DIMFONTDEFAULT)) self.codfisc.SetFont(self.font) wx.StaticText(self.pnl2, -1, _("Paese:"), wx.DLG_PNT(self.pnl2, 5, 40)) self.paese = wx.TextCtrl(self.pnl2, Nid, "", wx.DLG_PNT(self.pnl2, 5, 50), wx.DLG_SZE(self.pnl2, 20, -1)) wx.StaticText(self.pnl2, -1, _("Cod.C:"), wx.DLG_PNT(self.pnl2, 28, 40)) self.cod_c = wx.TextCtrl(self.pnl2, Nid, "", wx.DLG_PNT(self.pnl2, 28, 50), wx.DLG_SZE(self.pnl2, 20, -1)) wx.StaticText(self.pnl2, -1, _("CIN:"), wx.DLG_PNT(self.pnl2, 51, 40)) self.cin = wx.TextCtrl(self.pnl2, Nid, "", wx.DLG_PNT(self.pnl2, 52, 50), wx.DLG_SZE(self.pnl2, 10, -1)) wx.StaticText(self.pnl2, -1, _(" ABI :"), wx.DLG_PNT(self.pnl2, 70, 40)) self.abi = wx.TextCtrl(self.pnl2, Nid, "", wx.DLG_PNT(self.pnl2, 70, 50), wx.DLG_SZE(self.pnl2, 40, -1)) wx.StaticText(self.pnl2, -1, _(" CAB :"), wx.DLG_PNT(self.pnl2, 115, 40)) self.cab = wx.TextCtrl(self.pnl2, Nid, "", wx.DLG_PNT(self.pnl2, 115, 50), wx.DLG_SZE(self.pnl2, 40, -1)) wx.StaticText(self.pnl2, -1, _(" C/C:"), wx.DLG_PNT(self.pnl2, 160, 40)) self.ncc = wx.TextCtrl(self.pnl2, Nid, "", wx.DLG_PNT(self.pnl2, 160, 50), wx.DLG_SZE(self.pnl2, 80, -1)) wx.StaticText(self.pnl2, -1, _(" Banca :"), wx.DLG_PNT(self.pnl2, 5, 65)) self.banca = wx.TextCtrl(self.pnl2, Nid, "", wx.DLG_PNT(self.pnl2, 5, 75), wx.DLG_SZE(self.pnl2, 235, -1)) wx.StaticText(self.pnl2, -1, _("Riferimento Azienda:"), wx.DLG_PNT(self.pnl2, 10, 95)).SetFont(self.font) self.nsrif = wx.TextCtrl( self.pnl2, Nid, "", wx.DLG_PNT(self.pnl2, 90, 95), wx.DLG_SZE(self.pnl2, 120, cfg.DIMFONTDEFAULT)) self.nsrif.SetFont(self.font) self.new = wx.Button(self.pnl, Nid, cfg.vcnew, wx.DLG_PNT(self.pnl, 285, 20), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) self.new.SetFont(self.font) self.ok = wx.Button(self.pnl, Nid, cfg.vcok, wx.DLG_PNT(self.pnl, 285, 20), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) self.ok.SetFont(self.font) self.inte = wx.Button(self.pnl, Nid, cfg.vcint, wx.DLG_PNT(self.pnl, 285, 35), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) self.inte.SetFont(self.font) self.canc = wx.Button(self.pnl, Nid, cfg.vccanc, wx.DLG_PNT(self.pnl, 285, 35), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) self.canc.SetFont(self.font) self.modi = wx.Button(self.pnl, Nid, cfg.vcmodi, wx.DLG_PNT(self.pnl, 285, 50), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) self.modi.SetFont(self.font) self.dele = wx.Button(self.pnl, Nid, cfg.vcdele, wx.DLG_PNT(self.pnl, 285, 50), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) self.dele.SetFont(self.font) self.stampa = wx.Button( self.pnl, Nid, cfg.vcstampa, wx.DLG_PNT(self.pnl, 285, 65), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) self.stampa.SetFont(self.font) #self.SetFont(self.font) #box_sizer = wx.BoxSizer(wx.VERTICAL) #box_sizer.Add(self.pnl, 0, wx.EXPAND|wx.ALL,0) #self.SetAutoLayout(1) #self.SetSizer(box_sizer) #box_sizer.Fit(self) box = wx.GridSizer(1, 1) box.Add(self.pnl, 0, wx.ALIGN_CENTER | wx.ALL, 10) self.SetSizer(box) box.Fit(self) self.ok.Bind(wx.EVT_BUTTON, self.Save) self.new.Bind(wx.EVT_BUTTON, self.New) self.inte.Bind(wx.EVT_BUTTON, self.IntAnag) self.modi.Bind(wx.EVT_BUTTON, self.Modi) self.canc.Bind(wx.EVT_BUTTON, self.Close) self.dele.Bind(wx.EVT_BUTTON, self.CntrDele) self.ccodcf.Bind(wx.EVT_BUTTON, self.FndCodCF) self.cragsoc1.Bind(wx.EVT_BUTTON, self.FndAnag) self.codcf.Bind(wx.EVT_TEXT_ENTER, self.FndCodCF) self.ragsoc1.Bind(wx.EVT_TEXT_ENTER, self.FndAnag) self.ragsoc1.Bind(wx.EVT_CHAR, self.EvtChar) self.indiriz.Bind(wx.EVT_TEXT_ENTER, self.zonaSF) self.zona.Bind(wx.EVT_TEXT_ENTER, self.capSF) self.cap.Bind(wx.EVT_TEXT_ENTER, self.prSF) self.pr.Bind(wx.EVT_TEXT_ENTER, self.localitSF) self.localit.Bind(wx.EVT_TEXT_ENTER, self.tabiSF) self.tabi.Bind(wx.EVT_TEXT_ENTER, self.mobSF) self.mob.Bind(wx.EVT_TEXT_ENTER, self.pivaSF) self.piva.Bind(wx.EVT_TEXT_ENTER, self.codfiscSF) self.ragsoc2.Bind(wx.EVT_TEXT_ENTER, self.FndAnagIs) ## EVT_KILL escluso per assertion failed: (GTK_WIDGET_HAS_FOCUS (entry)) ##self.cap.Bind(wx.EVT_KILL_FOCUS, self.KillFcs_cap) ##self.tabi.Bind(wx.EVT_KILL_FOCUS, self.KillFcs_tabi) ##self.mob.Bind(wx.EVT_KILL_FOCUS, self.KillFcs_mob) ##self.tuff.Bind(wx.EVT_KILL_FOCUS, self.KillFcs_tuff) ##self.fax.Bind(wx.EVT_KILL_FOCUS, self.KillFcs_fax) ##self.piva.Bind(wx.EVT_KILL_FOCUS, self.KillFcs_piva) ##self.codfisc.Bind(wx.EVT_KILL_FOCUS, self.KillFcs_codfisc) ##self.pr.Bind(wx.EVT_KILL_FOCUS, self.KillFcs_pr) self.stampa.Bind(wx.EVT_BUTTON, self.Stampa) self.Bind(wx.EVT_CLOSE, self.Close) self.AT_Aziende() self.Start(self)
def __init__(self, prnt, cnt): self.win = wx.ScrolledWindow.__init__(self, parent=prnt, id=-1, size=wx.DefaultSize) self.SetScrollbars(1, 1, 100, 100) ##### self.FitInside() ###### png = wx.Image((cfg.path_img + "cerca19x19.png"), wx.BITMAP_TYPE_PNG).ConvertToBitmap() #wx.Frame.__init__(self, id=wx.NewId(), name='', # parent=prnt, pos=wx.Point(0, 0), # style=wx.DEFAULT_FRAME_STYLE , title=cnt[0]) #self.SetIcon(wx.Icon(cfg.path_img+"/null.ico", wx.BITMAP_TYPE_ICO)) #self.SetFont(wx.Font(12, wx.SWISS, wx.NORMAL, wx.NORMAL, False)) #self.SetClientSize(wx.Size(600, 400)) self.cnt = cnt Nid = wx.NewId() self.ttl = cnt[0] self.tipoord = cnt[1] self.tcpart = "M" #self.ottl="Gestione Movimenti" self.tbl = "movmag" self.tblart = "articoli" self.rec = cnt[2] self.AggMenu = cnt[3] self.IDMENU = cnt[4] #self.font=self.GetFont() self.color = self.GetBackgroundColour() Nid = wx.NewId() self.__MDI__ = wx.GetApp().GetPhasisMdi() self.font = self.__MDI__.font self.SetFont(self.font) self.CnAz = self.__MDI__.GetConnAZ() self.annoc = self.__MDI__.GetAnnoC() self.datacon = self.__MDI__.GetDataC() self.dzDatiAzienda = self.__MDI__.dzDatiAzienda self.pnl = wx.Panel( id=wx.NewId(), name='panel', parent=self, pos=wx.Point(0, 0), size=wx.DLG_SZE(self, 600 / 2, 400 / 2), #size=wx.Size(600, 400), style=wx.SIMPLE_BORDER | wx.TAB_TRAVERSAL) self.pnl.SetFont(self.font) self.lc = wx.ListCtrl(self.pnl, Nid, wx.DLG_PNT(self, 5, 5), wx.DLG_SZE(self.pnl, 335, 130), wx.LC_REPORT | wx.LC_HRULES | wx.LC_VRULES) wx.StaticLine(self.pnl, -1, wx.DLG_PNT(self.pnl, 5, 140), wx.DLG_SZE(self.pnl, 335, -1)) wx.StaticText(self.pnl, -1, _("Cod. Articolo:"), wx.DLG_PNT(self, 15, 152)) self.cod = wx.TextCtrl(self.pnl, Nid, "", wx.DLG_PNT(self.pnl, 70, 150), wx.DLG_SZE(self.pnl, 100, cfg.DIMFONTDEFAULT), wx.TE_PROCESS_ENTER) self.ccod = wx.BitmapButton( self.pnl, -1, png, #wx.Button(self.pnl , Nid, "...", wx.DLG_PNT(self.pnl, 175, 150), wx.DLG_SZE(self.pnl, 12, 12)) self.canc = wx.Button(self.pnl, Nid, cfg.vccanc, wx.DLG_PNT(self.pnl, 210, 150), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) self.int = wx.Button(self.pnl, Nid, cfg.vcint, wx.DLG_PNT(self.pnl, 275, 150), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) self.canc.SetFocus() self.stampa = wx.Button( self.pnl, Nid, cfg.vcstampa, wx.DLG_PNT(self.pnl, 275, 165), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) #self.SetFont(self.font) for x in self.pnl.GetChildren(): x.SetFont(self.font) #box_sizer = wx.BoxSizer(wx.VERTICAL) #box_sizer.Add(self.pnl, 0, wx.EXPAND|wx.ALL,0) #self.SetAutoLayout(1) #self.SetSizer(box_sizer) #box_sizer.Fit(self) box = wx.GridSizer(1, 1) box.Add(self.pnl, 0, wx.ALIGN_CENTER | wx.ALL, 10) self.SetSizer(box) box.Fit(self) self.canc.Bind(wx.EVT_BUTTON, self.Close) self.Bind(wx.EVT_CLOSE, self.Close) self.int.Bind(wx.EVT_BUTTON, self.Start) self.stampa.Bind(wx.EVT_BUTTON, self.Stampa) self.ccod.Bind(wx.EVT_BUTTON, self.FndInv) self.lc.Bind(wx.EVT_LIST_ITEM_SELECTED, self.OnListSelect) self.lc.Bind(wx.EVT_LIST_ITEM_ACTIVATED, self.LstAct) self.cod.Bind(wx.EVT_TEXT_ENTER, self.FndInv) self.Start(self)
class LstScad(wx.ScrolledWindow): def __init__(self, prnt, cnt): self.win = wx.ScrolledWindow.__init__(self, parent=prnt, id=-1, size=wx.DefaultSize) self.SetScrollbars(1, 1, 100, 100) ##### self.FitInside() ###### png = wx.Image((cfg.path_img + "cerca19x19.png"), wx.BITMAP_TYPE_PNG).ConvertToBitmap() #wx.Frame.__init__(self, id=wx.NewId(), name='', # parent=prnt, pos=wx.Point(0, 0), # style=wx.DEFAULT_FRAME_STYLE , title=cnt[0]) #self.SetIcon(wx.Icon(cfg.path_img+"/null.ico", wx.BITMAP_TYPE_ICO)) #self.SetFont(wx.Font(12, wx.SWISS, wx.NORMAL, wx.NORMAL, False)) self.cnt = cnt Nid = wx.NewId() self.ttl = cnt[0] self.tipoord = cnt[1] self.tcpart = "C" #self.ottl="Gestione Movimenti" self.tbl = "scad" #self.tblart="articoli" self.rec = cnt[2] self.AggMenu = cnt[3] self.IDMENU = cnt[4] self.CMD = cnt[5] #self.font=self.GetFont() #self.SetClientSize(wx.Size(680, 400)) self.__MDI__ = wx.GetApp().GetPhasisMdi() self.font = self.__MDI__.font self.SetFont(self.font) self.CnAz = self.__MDI__.GetConnAZ() self.annoc = self.__MDI__.GetAnnoC() self.datacon = self.__MDI__.GetDataC() self.dzDatiAzienda = self.__MDI__.dzDatiAzienda self.pnl = wx.Panel( id=wx.NewId(), name='panel1', parent=self, pos=wx.Point(0, 0), size=wx.DLG_SZE(self, 680 / 2, 400 / 2), #size=wx.Size(680, 400), style=wx.SIMPLE_BORDER | wx.TAB_TRAVERSAL) self.pnl.SetFont(self.font) btnSzeL = wx.DLG_SZE(self.pnl, 70, 16) btnSzeM = wx.DLG_SZE(self.pnl, 80, 16) btnSzeM1 = wx.DLG_SZE(self.pnl, 60, 16) btnSzeS = wx.DLG_SZE(self.pnl, 16, 16) btnSzeD = wx.DLG_SZE(self.pnl, 60, 14) #self.pnl.SetFont(self.font) data_att_int = self.datacon.split("/") data_att_int = str(data_att_int[2]) + str(data_att_int[1]) + str( data_att_int[0]) valueSql = int(data_att_int) sql = """ select data_scad,data_scad_int from scad where data_scad_int<='%s' and stt_scad!='S' and stt_scad!='Z'""" try: cr = self.CnAz.cursor() cr.execute(sql % valueSql) row = cr.fetchone() if row: self.CnAz.commit() sql = """ update scad set stt_scad='Z' where data_scad_int<='%s' and stt_scad!='S' and stt_scad!='Z' """ cr.execute(sql % valueSql) dlg = wx.MessageDialog(self, "Aggiornamento Scadenzario ......", "Aggiornamento Tabella Scadenzario ", wx.ID_OK | wx.ICON_INFORMATION) if dlg.ShowModal() == wx.ID_OK: dlg.Destroy() wx.GetApp().GetPhasisMdi().CloseTabObj(self) self.CnAz.commit() except StandardError, msg: print "Scadenzario", " New Error %s" % (msg) self.lc = wx.ListCtrl(self.pnl, -1, wx.DLG_PNT(self, 5, 5), wx.DLG_SZE(self.pnl, 335, 110), wx.LC_REPORT | wx.LC_HRULES | wx.LC_VRULES) wx.StaticLine(self.pnl, -1, wx.DLG_PNT(self.pnl, 5, 120), wx.DLG_SZE(self.pnl, 335, -1)) # < diegom linea 1 #wx.StaticText(self.pnl , -1, _("Tipologia Scad.:"), #wx.DLG_PNT(self, 25,147)) self.lscad = wx.StaticText(self.pnl, -1, "Num. :", wx.DLG_PNT(self.pnl, 5, 127)) self.num_scad = wx.TextCtrl( self.pnl, -1, "", wx.DLG_PNT(self.pnl, 27, 125), wx.DLG_SZE(self.pnl, 35, cfg.DIMFONTDEFAULT), wx.ALIGN_RIGHT | wx.TE_PROCESS_ENTER) self.cnum_scad = wx.BitmapButton( self.pnl, -1, png, wx.DLG_PNT(self.pnl, 64, 125), wx.DLG_SZE(self.pnl, cfg.btnSzeSH, cfg.btnSzeV), wx.TE_PROCESS_ENTER) self.ldata_scad = wx.StaticText(self.pnl, -1, _("Scad.:"), wx.DLG_PNT(self.pnl, 66, 127)) self.ldata_scad.SetFont(self.font) self.data_scad = masked.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 85, 125), wx.DLG_SZE(self.pnl, 40, cfg.DIMFONTDEFAULT), wx.ALIGN_RIGHT, autoformat='EUDATEDDMMYYYY/') self.vdata_scad = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 85, 125)) self.cdata_scad = wx.BitmapButton( self.pnl, -1, png, wx.DLG_PNT(self.pnl, 146, 125), wx.DLG_SZE(self.pnl, cfg.btnSzeSH, cfg.btnSzeV), wx.TE_PROCESS_ENTER) self.TIPO_SCAD = wx.ComboBox(self.pnl, 300, "", wx.DLG_PNT(self.pnl, 157, 125), wx.DLG_SZE(self.pnl, 90, -1), [], wx.CB_DROPDOWN | wx.CB_SORT) self.vTIPO_SCAD = wx.TextCtrl( self.pnl, -1, "", wx.DLG_PNT(self.pnl, 157, 125), wx.DLG_SZE(self.pnl, 0, cfg.DIMFONTDEFAULT), wx.TE_PROCESS_ENTER) self.cTIPO_SCAD = wx.BitmapButton( self.pnl, -1, png, wx.DLG_PNT(self.pnl, 250, 125), wx.DLG_SZE(self.pnl, cfg.btnSzeSH, cfg.btnSzeV), wx.TE_PROCESS_ENTER) self.all = wx.Button(self.pnl, Nid, cfg.vcall, wx.DLG_PNT(self.pnl, 269, 125), wx.DLG_SZE(self.pnl, cfg.btnSzeM1H, cfg.btnSzeV)) # < diegom linea 2 #wx.StaticText(self.pnl, -1, "Pagamento :", #wx.DLG_PNT(self.pnl, 155,147)) wx.StaticText(self.pnl, -1, "Controp.:", wx.DLG_PNT(self.pnl, 5, 142)) self.CF = wx.ComboBox(self.pnl, Nid, "", wx.DLG_PNT(self.pnl, 35, 140), wx.DLG_SZE(self.pnl, 50, -1), [], wx.CB_DROPDOWN | wx.CB_SORT) self.vCF = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 35, 140)) self.lc1odcf = wx.StaticText(self.pnl, -1, "Cod.", wx.DLG_PNT(self.pnl, 90, 142)) self.codcf = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 107, 140), wx.DLG_SZE(self.pnl, 40, cfg.DIMFONTDEFAULT)) self.lragsoc1 = wx.StaticText(self.pnl, -1, "Rag.Soc.1:", wx.DLG_PNT(self.pnl, 150, 142)) self.ragsoc1 = wx.TextCtrl( self.pnl, Nid, "", wx.DLG_PNT(self.pnl, 187, 140), wx.DLG_SZE(self.pnl, 80, cfg.DIMFONTDEFAULT), wx.TE_PROCESS_ENTER) self.cragsoc1 = wx.BitmapButton( self.pnl, -1, png, wx.DLG_PNT(self.pnl, 269, 140), # < diegom linea 3 wx.DLG_SZE(self.pnl, cfg.btnSzeSH, cfg.btnSzeV)) self.lragsoc2 = wx.StaticText(self.pnl, -1, "Rag. Soc.2:", wx.DLG_PNT(self.pnl, 5, 157)) self.ragsoc2 = wx.TextCtrl( self.pnl, -1, "", wx.DLG_PNT(self.pnl, 42, 155), wx.DLG_SZE(self.pnl, 90, cfg.DIMFONTDEFAULT)) self.ragsoc4 = wx.TextCtrl( self.pnl, -1, "", wx.DLG_PNT(self.pnl, 42, 155), wx.DLG_SZE(self.pnl, 90, cfg.DIMFONTDEFAULT)) self.PAGAM = wx.ComboBox(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 140, 155), wx.DLG_SZE(self.pnl, 120, -1), [], wx.CB_DROPDOWN | wx.CB_SORT) self.vPAGAM = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 140, 155)) # < diegom linea 4 self.ltipodoc = wx.StaticText(self.pnl, -1, "Tipo Documento.:", wx.DLG_PNT(self.pnl, 5, 172)) self.TIPO_DOC = wx.ComboBox(self.pnl, 300, "", wx.DLG_PNT(self.pnl, 63, 170), wx.DLG_SZE(self.pnl, 110, -1), [], wx.CB_DROPDOWN | wx.CB_SORT) self.vTIPO_DOC = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 63, 172)) self.stt_doc1 = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 63, 170)) self.stt_doc2 = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 63, 170)) self.ldoc = wx.StaticText(self.pnl, -1, "N.Doc.:", wx.DLG_PNT(self.pnl, 176, 172)) self.num_doc = wx.TextCtrl( self.pnl, -1, "", wx.DLG_PNT(self.pnl, 198, 170), wx.DLG_SZE(self.pnl, 30, cfg.DIMFONTDEFAULT), wx.ALIGN_RIGHT | wx.TE_PROCESS_ENTER) self.cnum_doc = wx.BitmapButton( self.pnl, -1, png, wx.DLG_PNT(self.pnl, 230, 170), wx.DLG_SZE(self.pnl, cfg.btnSzeSH, cfg.btnSzeV)) self.vnum_doc = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 230, 170)) self.rbREG = wx.RadioButton(self.pnl, -1, "Registrato", wx.DLG_PNT(self.pnl, 269, 155), wx.DLG_SZE(self.pnl, 60, 10)) self.rbSALD = wx.RadioButton(self.pnl, -1, "Saldato", wx.DLG_PNT(self.pnl, 310, 155), wx.DLG_SZE(self.pnl, 60, 10)) self.rbSCAD = wx.RadioButton(self.pnl, -1, "Scaduti", wx.DLG_PNT(self.pnl, 269, 170), wx.DLG_SZE(self.pnl, 60, 10)) self.rbALL = wx.RadioButton(self.pnl, -1, "Tutti", wx.DLG_PNT(self.pnl, 310, 170), wx.DLG_SZE(self.pnl, 60, 10)) # < diegom linea 5 wx.StaticText(self.pnl, -1, "Totale Entrate", wx.DLG_PNT(self.pnl, 5, 187)) self.tot_E = wx.StaticText(self.pnl, -1, "0,00", wx.DLG_PNT(self.pnl, 55, 187), wx.DLG_SZE(self.pnl, 55, 10)) wx.StaticText(self.pnl, -1, "Saldo Totale:", wx.DLG_PNT(self.pnl, 110, 187)) self.tot_sald_E = wx.StaticText(self.pnl, -1, "0,00", wx.DLG_PNT(self.pnl, 160, 187), wx.DLG_SZE(self.pnl, 60, 10)) wx.StaticText(self.pnl, -1, "Da Saldare:", wx.DLG_PNT(self.pnl, 216, 187)) self.tot_nsald_E = wx.StaticText(self.pnl, -1, "0,00", wx.DLG_PNT(self.pnl, 265, 187), wx.DLG_SZE(self.pnl, 60, 10)) wx.StaticText(self.pnl, -1, "Totale Uscite:", wx.DLG_PNT(self.pnl, 5, 200)) self.tot_U = wx.StaticText(self.pnl, -1, "0,00", wx.DLG_PNT(self.pnl, 55, 200), wx.DLG_SZE(self.pnl, 55, 10)) wx.StaticText(self.pnl, -1, "Saldo Totale:", wx.DLG_PNT(self.pnl, 110, 200)) self.tot_sald_U = wx.StaticText(self.pnl, -1, "0,00", wx.DLG_PNT(self.pnl, 160, 200), wx.DLG_SZE(self.pnl, 60, 10)) wx.StaticText(self.pnl, -1, "Da Saldare:", wx.DLG_PNT(self.pnl, 216, 200)) self.tot_nsald_U = wx.StaticText(self.pnl, -1, "0,00", wx.DLG_PNT(self.pnl, 265, 200), wx.DLG_SZE(self.pnl, 60, 10)) # pulsanti self.ok = wx.Button(self.pnl, -1, cfg.vcok, wx.DLG_PNT(self.pnl, 295, 125), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) self.canc = wx.Button(self.pnl, -1, cfg.vccanc, wx.DLG_PNT(self.pnl, 295, 140), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) self.inte = wx.Button(self.pnl, -1, cfg.vcint, wx.DLG_PNT(self.pnl, 295, 140), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) self.stampa = wx.Button( self.pnl, -1, cfg.vcstampa, wx.DLG_PNT(self.pnl, 295, 155), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) wx.StaticText(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 5, 195)) for x in self.pnl.GetChildren(): x.SetFont(self.font) self.canc.SetFocus() #self.SetFont(self.font) #box_sizer = wx.BoxSizer(wx.VERTICAL) #box_sizer.Add(self.pnl, 0, wx.EXPAND|wx.ALL,0) #self.SetAutoLayout(1) #self.SetSizer(box_sizer) #box_sizer.Fit(self) box = wx.GridSizer(1, 1) box.Add(self.pnl, 0, wx.ALIGN_CENTER | wx.ALL, 10) self.SetSizer(box) box.Fit(self) self.TIPO_SCAD.Bind(wx.EVT_COMBOBOX, self.SelCOMBOtiposcadev) self.CF.Bind(wx.EVT_COMBOBOX, self.SelCOMBOcfev) self.PAGAM.Bind(wx.EVT_COMBOBOX, self.SelPAGAMev) self.TIPO_DOC.Bind(wx.EVT_COMBOBOX, self.SelCOMBOtipodocev) self.canc.Bind(wx.EVT_BUTTON, self.Close) self.inte.Bind(wx.EVT_BUTTON, self.Start) self.cragsoc1.Bind(wx.EVT_BUTTON, self.FndAnag) self.Bind(wx.EVT_CLOSE, self.Close) self.ok.Bind(wx.EVT_BUTTON, self.Ok) self.lc.Bind(wx.EVT_LEFT_DCLICK, self.DblClick) self.stampa.Bind(wx.EVT_BUTTON, self.Stampa) #self.cTIPO_SCAD.Bind(wx.EVT_BUTTON, self.FndSelGen) self.all.Bind(wx.EVT_BUTTON, self.FndSelScadAll) self.cTIPO_SCAD.Bind(wx.EVT_BUTTON, self.FndSelScad) self.cnum_scad.Bind(wx.EVT_BUTTON, self.FndSelScad) self.cdata_scad.Bind(wx.EVT_BUTTON, self.FndSelScad) self.cnum_doc.Bind(wx.EVT_BUTTON, self.FndSelScad) #self.cnum_scad.Bind(wx.EVT_BUTTON, self.FndSelCod) #self.cdata_scad.Bind(wx.EVT_BUTTON, self.FndSelDataScad) self.lc.Bind(wx.EVT_LIST_ITEM_ACTIVATED, self.LstAct) self.lc.Bind(wx.EVT_LIST_ITEM_SELECTED, self.LstSlct) self.Start(self)
def __init__(self, prnt, cnt): self.win = wx.ScrolledWindow.__init__(self, parent=prnt, id=-1, size=wx.DefaultSize) self.SetScrollbars(1, 1, 100, 100) ##### self.FitInside() ###### png = wx.Image((cfg.path_img + "cerca19x19.png"), wx.BITMAP_TYPE_PNG).ConvertToBitmap() #wx.Frame.__init__(self, id = wx.NewId(), name = '', # parent = prnt, pos = wx.Point(0, 0), # style = wx.DEFAULT_FRAME_STYLE , title = cnt[0]) #self.SetIcon(wx.Icon(cfg.path_img+"/null.ico", wx.BITMAP_TYPE_ICO)) #self.SetFont(wx.Font(12, wx.SWISS, wx.NORMAL, wx.NORMAL, False)) self.ttl = cnt[0] self.tcpart = "C" self.tblart = "articoli" self.AggMenu = cnt[3] self.IDMENU = cnt[4] #self.SetClientSize(wx.Size(680, 425)) #self.font = self.GetFont() self.color = self.GetBackgroundColour() Nid = wx.NewId() self.__MDI__ = wx.GetApp().GetPhasisMdi() self.font = self.__MDI__.font self.SetFont(self.font) self.CnAz = self.__MDI__.GetConnAZ() self.annoc = self.__MDI__.GetAnnoC() self.datacon = self.__MDI__.GetDataC() self.dzDatiAzienda = self.__MDI__.dzDatiAzienda #self.pnl = wx.Panel(id = wx.NewId(), name = '', #parent = self, pos = wx.Point(0, 0), size = wx.Size(420, 150)) self.pnl = wx.Panel(id=wx.NewId(), name='', parent=self, pos=wx.Point(0, 0), style=wx.SIMPLE_BORDER | wx.TAB_TRAVERSAL) #, size = wx.Size(680, 420)) self.pnl.SetFont(self.font) self.lnumdoc = wx.StaticText(self.pnl, -1, _("Numero DDT :"), wx.DLG_PNT(self.pnl, 7, 12)) self.num_doc = wx.TextCtrl( self.pnl, Nid, "", wx.DLG_PNT(self.pnl, 65, 10), wx.DLG_SZE(self.pnl, 60, cfg.DIMFONTDEFAULT), wx.TE_PROCESS_ENTER) self.cnum_doc = wx.BitmapButton( self.pnl, -1, png, #wx.Button(self.pnl, Nid, "...", wx.DLG_PNT(self.pnl, 130, 10), wx.DLG_SZE(self.pnl, cfg.btnSzeSH, cfg.btnSzeV)) self.data_doc = wx.TextCtrl(self.pnl, Nid, "", wx.DLG_PNT(self.pnl, 264, 5)) self.codcf = wx.TextCtrl(self.pnl, Nid, "", wx.DLG_PNT(self.pnl, 30, 25)) self.lragsoc1 = wx.StaticText(self.pnl, -1, _("Rag. Sociale1 ( Cognome ) :"), wx.DLG_PNT(self.pnl, 7, 25)) self.ragsoc1 = wx.TextCtrl( self.pnl, Nid, "", wx.DLG_PNT(self.pnl, 5, 35), wx.DLG_SZE(self.pnl, 120, cfg.DIMFONTDEFAULT), wx.TE_PROCESS_ENTER) self.cragsoc1 = wx.BitmapButton( self.pnl, -1, png, #wx.Button(self.pnl, Nid, "...", wx.DLG_PNT(self.pnl, 130, 35), wx.DLG_SZE(self.pnl, cfg.btnSzeSH, cfg.btnSzeV)) self.ragsoc2 = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 7, 162)) self.stato = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 7, 162)) self.localit = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 7, 162)) wx.StaticText(self.pnl, -1, _("Indirizzo :"), wx.DLG_PNT(self.pnl, 10, 52)) self.indiriz = wx.TextCtrl( self.pnl, Nid, "", wx.DLG_PNT(self.pnl, 45, 50), wx.DLG_SZE(self.pnl, 218, cfg.DIMFONTDEFAULT)) wx.StaticText(self.pnl, -1, _("Citta' :"), wx.DLG_PNT(self.pnl, 10, 69)) self.zona = wx.TextCtrl(self.pnl, Nid, "", wx.DLG_PNT(self.pnl, 45, 67), wx.DLG_SZE(self.pnl, 100, cfg.DIMFONTDEFAULT)) wx.StaticText(self.pnl, -1, _("CAP :"), wx.DLG_PNT(self.pnl, 150, 69)) self.cap = wx.TextCtrl(self.pnl, Nid, "", wx.DLG_PNT(self.pnl, 180, 67), wx.DLG_SZE(self.pnl, 35, cfg.DIMFONTDEFAULT)) wx.StaticText(self.pnl, -1, _("PR :"), wx.DLG_PNT(self.pnl, 225, 69)) self.pr = wx.TextCtrl(self.pnl, Nid, "", wx.DLG_PNT(self.pnl, 243, 67), wx.DLG_SZE(self.pnl, 20, cfg.DIMFONTDEFAULT)) self.codage = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 7, 162)) self.vPAGAM = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 7, 162)) self.vTIPO_DOC = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 7, 162)) self.TIPO_DOC = wx.TextCtrl(self.pnl, -1, "B1", wx.DLG_PNT(self.pnl, 7, 162)) self.lgendoc = wx.StaticText(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 7, 162)) self.lc = wx.ListCtrl(self.pnl, Nid, wx.DLG_PNT(self.pnl, 5, 85), wx.DLG_SZE(self.pnl, 323, 70), wx.LC_REPORT | wx.LC_HRULES | wx.LC_VRULES) #wx.StaticLine(self.pnl, -1, wx.DLG_PNT(self.pnl, 5,155), # wx.DLG_SZE(self.pnl, 283,-1)) #self.importo = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 262,172)) self.ltotale = wx.StaticText(self.pnl, -1, _("Totale Documento:"), wx.DLG_PNT(self.pnl, 185, 162)) #self.ltotale.SetFont(self.font) #self.ltotale.SetForegroundColour(wx.Colour(128, 128, 128)) self.totale = wx.TextCtrl(self.pnl, Nid, "0,00", wx.DLG_PNT(self.pnl, 262, 160), wx.DLG_SZE(self.pnl, 65, cfg.DIMFONTDEFAULT), wx.ALIGN_RIGHT) #self.totale.SetFont(self.font) self.stt_doc1 = wx.TextCtrl(self.pnl, -1, "E", wx.DLG_PNT(self.pnl, 5, 160)) self.stt_doc2 = wx.TextCtrl(self.pnl, -1, "E", wx.DLG_PNT(self.pnl, 5, 170)) self.vCONSEG = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 5, 170)) self.vTRASP = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 5, 170)) self.vVETT = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 5, 170)) self.nsrif = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 5, 170)) self.vsrif = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 5, 170)) self.note = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 5, 170)) self.vIMBAL = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 5, 170)) self.vASPET = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 5, 170)) self.tot_colli = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 5, 170)) self.tot_peso = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 5, 170)) self.data_tra = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 5, 170)) self.ora_tra = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 5, 170)) self.scf1 = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 5, 170)) self.anno = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 5, 170)) self.val = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 5, 170)) #self.ok = wx.Button(self.pnl, Nid, cfg.vcok, # wx.DLG_PNT(self.pnl, 120,10), btnSzeL ) self.int = wx.Button( self.pnl, Nid, cfg.vcint, wx.DLG_PNT(self.pnl, 275, 10), ## wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) self.canc = wx.Button(self.pnl, Nid, cfg.vccanc, wx.DLG_PNT(self.pnl, 275, 10), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) self.okanag = wx.Button( self.pnl, Nid, cfg.vcconf, wx.DLG_PNT(self.pnl, 275, 25), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) self.okndoc = wx.Button( self.pnl, Nid, cfg.vcconf, wx.DLG_PNT(self.pnl, 275, 25), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) for x in self.pnl.GetChildren(): x.SetFont(self.font) self.pnl.Fit() box = wx.GridSizer(1, 1) box.Add(self.pnl, 0, wx.ALIGN_CENTER | wx.ALL, 10) self.SetSizer(box) box.Fit(self) self.ragsoc1.Bind(wx.EVT_TEXT_ENTER, self.FndAnag) self.cragsoc1.Bind(wx.EVT_BUTTON, self.FndAnag) self.num_doc.Bind(wx.EVT_TEXT_ENTER, self.FndDoc) self.cnum_doc.Bind(wx.EVT_BUTTON, self.FndDoc) self.canc.Bind(wx.EVT_BUTTON, self.Close) self.int.Bind(wx.EVT_BUTTON, self.Start) self.okanag.Bind(wx.EVT_BUTTON, self.OkGDoc) self.okndoc.Bind(wx.EVT_BUTTON, self.OkGDoc) self.Bind(wx.EVT_CLOSE, self.Close) self.Start(self)
def __init__(self, prnt, cnt): wx.Dialog.__init__(self, id=wx.NewId(), name='', parent=prnt, pos=wx.Point(10, 50), size=wx.DefaultSize, style=wx.DEFAULT_FRAME_STYLE, title=ttl) #self.SetIcon(wx.Icon(cfg.path_img+"/null.ico", wx.BITMAP_TYPE_ICO)) #self.SetFont(wx.Font(12, wx.SWISS, wx.NORMAL, wx.NORMAL, False)) self.cnt = cnt #self.tipo_ord = cnt[0] #print self.cnt vTIPO_ORD = cnt[0].GetValue() anno = cnt[1].GetValue() num_ord = cnt[2].GetValue() data_doc = cnt[3].GetValue() #stt_doc = cnt[5] Nid = wx.NewId() self.CnAz = prnt.CnAz #self.font = self.GetFont() self.__FRM__ = prnt.__MDI__ self.__MDI__ = wx.GetApp().GetPhasisMdi() self.font=self.__MDI__.font self.SetFont(self.font) self.pnl = wx.Panel(id=wx.NewId(), name='panel', parent=self, pos=wx.Point(0, 0), size = wx.DLG_SZE(self,540/2,260/2)) #, #size=wx.Size(540, 260)) self.pnl.SetFont(self.font) self.lc = wx.ListCtrl(self.pnl , Nid, wx.DLG_PNT(self, 5,5), wx.DLG_SZE(self.pnl , 300,100), wx.LC_REPORT|wx.LC_HRULES|wx.LC_VRULES) self.lc.InsertColumn(0, _("Tipo Ord")) self.lc.InsertColumn(1, _("Num Ord")) self.lc.InsertColumn(2, _("Data Ord")) self.lc.InsertColumn(3, _("Rag. Soc.1 Cognome")) self.lc.InsertColumn(4, _("Rag. Soc.2 Nome")) self.lc.SetColumnWidth(0, wx.DLG_SZE(self, 20,-1).width) self.lc.SetColumnWidth(1, wx.DLG_SZE(self, 40,-1).width) self.lc.SetColumnWidth(2, wx.DLG_SZE(self, 60,-1).width) self.lc.SetColumnWidth(3, wx.DLG_SZE(self, 95,-1).width) self.lc.SetColumnWidth(4, wx.DLG_SZE(self, 90,-1).width) #self.lc.SetFont(self.font) rowlc=0 val="" #if data_doc!="" : sql = """ select * from ordi1 where tipo_ord = "%s" and anno = "%s" """ valueSql = vTIPO_ORD, anno #print sql % valueSql #elif num_ord=="" and stt_doc=="" : # sql = """ select * from docu1 # where num_ord like "%s" and tipo_ord = "%s" # and anno = "%s" """ # valueSql = '%%', vTIPO_ORD, anno try: cr = self.CnAz.cursor () cr.execute(sql % valueSql) rows = cr.fetchall() for row in rows: for rowlc in range(1): #print row row_lc = self.lc.GetItemCount() num_ord = str(row[2]) vsdata = str(row[16]) data_doc = str(row[3]) ragsoc1 = str(row[5]).title() ragsoc2 = str(row[6]).title() tipo_ord = str(row[0]) anno = str(row[1]) self.lc.InsertStringItem(rowlc,tipo_ord) self.lc.SetStringItem(rowlc, 1, num_ord) self.lc.SetStringItem(rowlc, 2, data_doc) self.lc.SetStringItem(rowlc, 3, ragsoc1) self.lc.SetStringItem(rowlc, 4, ragsoc2) self.lc.SetItemData(0,0) except StandardError, msg: self.__FRM__.MsgErr("srcdoc"," SrcOrdBuoni Error %s" % (msg))
def __init__(self, prnt, cnt): wx.Dialog.__init__(self, id=wx.NewId(), name='', parent=prnt, pos=wx.Point(10, 50), size=wx.DefaultSize, style=wx.DEFAULT_FRAME_STYLE, title=ttl) self.SetIcon(wx.Icon(cfg.path_img + "/null.ico", wx.BITMAP_TYPE_ICO)) #self.SetFont(wx.Font(12, wx.SWISS, wx.NORMAL, wx.NORMAL, False)) png = wx.Image((cfg.path_img + "cerca19x19.png"), wx.BITMAP_TYPE_PNG).ConvertToBitmap() self.cnt = cnt self.ttl = ttl Nid = wx.NewId() self.CnAz = prnt.CnAz #self.font=self.GetFont() self.annoc = prnt.annoc self.datacon = prnt.datacon self.CnAz = prnt.CnAz self.font = self.GetFont() self.__FRM__ = prnt.__MDI__ self.__CMD__ = prnt.__MDI__.CMD self.__MDI__ = wx.GetApp().GetPhasisMdi() self.font = self.__MDI__.font self.SetFont(self.font) self.pnl = wx.Panel(id=wx.NewId(), name='panel', parent=self, pos=wx.Point(0, 0)) self.pnl.SetFont(self.font) self.lbcodart = wx.StaticText(self.pnl, -1, _("Codice :"), wx.DLG_PNT(self.pnl, 5, 7)) self.lbcodart.SetFont(self.font) self.codart = wx.TextCtrl(self.pnl, Nid, "", wx.DLG_PNT(self.pnl, 55, 5), wx.DLG_SZE(self.pnl, 60, cfg.DIMFONTDEFAULT)) self.codart.SetFont(self.font) self.ccodart = wx.BitmapButton( self.pnl, -1, png, #wx.Button(self.pnl, Nid, "...", wx.DLG_PNT(self.pnl, 120, 5), wx.DLG_SZE(self.pnl, cfg.btnSzeSH, cfg.btnSzeV)) wx.StaticText(self.pnl, -1, _("BarCode :"), wx.DLG_PNT(self.pnl, 140, 7)).SetFont(self.font) self.codbar = wx.TextCtrl(self.pnl, Nid, "", wx.DLG_PNT(self.pnl, 180, 5), wx.DLG_SZE(self.pnl, 75, cfg.DIMFONTDEFAULT)) self.codbar.SetFont(self.font) self.ccodbar = wx.BitmapButton( self.pnl, -1, png, #wx.Button(self.pnl, Nid, "...", wx.DLG_PNT(self.pnl, 260, 5), wx.DLG_SZE(self.pnl, cfg.btnSzeSH, cfg.btnSzeV)) wx.StaticText(self.pnl, -1, _("Descrizione :"), wx.DLG_PNT(self.pnl, 5, 22)).SetFont(self.font) self.descriz = wx.TextCtrl( self.pnl, Nid, "", wx.DLG_PNT(self.pnl, 55, 20), wx.DLG_SZE(self.pnl, 200, cfg.DIMFONTDEFAULT)) self.descriz.SetFont(self.font) self.cdescriz = wx.BitmapButton( self.pnl, -1, png, #wx.Button(self.pnl, Nid, "...", wx.DLG_PNT(self.pnl, 260, 20), wx.DLG_SZE(self.pnl, cfg.btnSzeSH, cfg.btnSzeV)) wx.StaticText(self.pnl, -1, _("Costo :"), wx.DLG_PNT(self.pnl, 5, 37)).SetFont(self.font) self.costo = wx.TextCtrl(self.pnl, Nid, "", wx.DLG_PNT(self.pnl, 55, 35), wx.DLG_SZE(self.pnl, 58, cfg.DIMFONTDEFAULT), wx.ALIGN_RIGHT) self.costo.SetFont(self.font) wx.StaticText(self.pnl, -1, _("Prezzo :"), wx.DLG_PNT(self.pnl, 115, 37)).SetFont(self.font) self.prezzo1 = wx.TextCtrl( self.pnl, Nid, "", wx.DLG_PNT(self.pnl, 155, 35), wx.DLG_SZE(self.pnl, 58, cfg.DIMFONTDEFAULT), wx.ALIGN_RIGHT) self.prezzo1.SetFont(self.font) self.lbum = wx.StaticText(self.pnl, -1, _("UM :"), wx.DLG_PNT(self.pnl, 240, 37)) self.lbum.SetFont(self.font) wx.StaticText(self.pnl, -1, _("Q.ta` Dare :"), wx.DLG_PNT(self.pnl, 5, 52)).SetFont(self.font) self.qt_car = wx.TextCtrl(self.pnl, Nid, "", wx.DLG_PNT(self.pnl, 55, 50), wx.DLG_SZE(self.pnl, 40, cfg.DIMFONTDEFAULT), wx.ALIGN_RIGHT) self.qt_car.SetFont(self.font) wx.StaticText(self.pnl, -1, _("Q.ta` Avere :"), wx.DLG_PNT(self.pnl, 100, 52)).SetFont(self.font) self.qt_sca = wx.TextCtrl(self.pnl, Nid, "", wx.DLG_PNT(self.pnl, 140, 50), wx.DLG_SZE(self.pnl, 40, cfg.DIMFONTDEFAULT), wx.ALIGN_RIGHT) self.qt_sca.SetFont(self.font) wx.StaticText(self.pnl, -1, _("Q.ta` Saldo :"), wx.DLG_PNT(self.pnl, 187, 52)).SetFont(self.font) self.qt_sal = wx.TextCtrl(self.pnl, Nid, "", wx.DLG_PNT(self.pnl, 230, 50), wx.DLG_SZE(self.pnl, 40, cfg.DIMFONTDEFAULT), wx.ALIGN_RIGHT) self.qt_sal.SetFont(self.font) self.lc = wx.ListCtrl(self.pnl, Nid, wx.DLG_PNT(self.pnl, 5, 80), wx.DLG_SZE(self.pnl, 330, 50), wx.LC_REPORT | wx.LC_HRULES | wx.LC_VRULES) self.lc.SetFont(self.font) wx.StaticLine(self.pnl, -1, wx.DLG_PNT(self.pnl, 5, 145), wx.DLG_SZE(self.pnl, 340, -1)) #self.pnl.SetFont(self.font) self.ok = wx.Button(self.pnl, Nid, cfg.vcconf, wx.DLG_PNT(self.pnl, 195, 160), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) self.ok.SetFont(self.font) self.canc = wx.Button(self.pnl, Nid, cfg.vccanc, wx.DLG_PNT(self.pnl, 255, 160), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) self.canc.SetFont(self.font) self.canc.SetFocus() #self.SetFont(self.font) box_sizer = wx.BoxSizer(wx.VERTICAL) box_sizer.Add(self.pnl, 0, wx.EXPAND | wx.ALL, 0) self.SetAutoLayout(1) self.SetSizer(box_sizer) box_sizer.Fit(self) self.canc.Bind(wx.EVT_BUTTON, self.Close) self.Bind(wx.EVT_CLOSE, self.Close) self.ok.Bind(wx.EVT_BUTTON, self.Ok) self.lc.Bind(wx.EVT_LEFT_DCLICK, self.DblClick) self.lc.Bind(wx.EVT_LIST_ITEM_ACTIVATED, self.LstAct) self.lc.Bind(wx.EVT_LIST_ITEM_SELECTED, self.LstSlct) self.Start(self)
class SrcTblCF(wx.MiniFrame): def __init__(self, prnt, cnt): wx.MiniFrame.__init__(self, id=wx.NewId(), name='', parent=prnt, pos=wx.Point(0, 0), style=wx.DEFAULT_FRAME_STYLE, title=ttl) self.SetIcon(wx.Icon(cfg.path_img+"/null.ico", wx.BITMAP_TYPE_ICO)) #self.SetFont(wx.Font(12, wx.SWISS, wx.NORMAL, wx.NORMAL, False)) self.cnt = cnt self.tcpart = cnt[0] Nid = wx.NewId() self.CnAz = prnt.CnAz #self.font = self.GetFont() self.__FRM__ = prnt.__FRM__ self.__MDI__ = wx.GetApp().GetPhasisMdi() self.font=self.__MDI__.font self.SetFont(self.font) self.pnl = wx.Panel(id = wx.NewId(), name = 'panel', parent = self, pos = wx.Point(0, 0)) self.pnl.SetFont(self.font) self.lc = wx.ListCtrl(self.pnl , Nid, wx.DLG_PNT(self, 5,5), wx.DLG_SZE(self.pnl , 335,110), wx.LC_REPORT|wx.LC_HRULES|wx.LC_VRULES) self.lc.InsertColumn(0, _("Codice")) self.lc.InsertColumn(1, _("Rag. Soc.1 Cognome")) self.lc.InsertColumn(2, _("Rag. Soc.2 Nome")) self.lc.InsertColumn(3, _("Indirizzo")) self.lc.InsertColumn(4, _("Telefono")) self.lc.InsertColumn(5, _("Ufficio")) self.lc.InsertColumn(6, _("Fax")) self.lc.SetColumnWidth(0, wx.DLG_SZE(self, 30,-1).width) self.lc.SetColumnWidth(1, wx.DLG_SZE(self, 70,-1).width) self.lc.SetColumnWidth(2, wx.DLG_SZE(self, 70,-1).width) self.lc.SetColumnWidth(3, wx.DLG_SZE(self, 100,-1).width) self.lc.SetColumnWidth(4, wx.DLG_SZE(self, 60,-1).width) self.lc.SetColumnWidth(5, wx.DLG_SZE(self, 60,-1).width) self.lc.SetColumnWidth(6, wx.DLG_SZE(self, 60,-1).width) #self.lc.SetFont(self.font) rowlc=0 codcf = self.cnt[4].GetValue() val=self.cnt[2].GetValue().upper() sql = """ SELECT * FROM tblcf WHERE rag_soc1 like '%s' AND t_cpart = '%s' AND CODCF = '%s' ORDER BY rag_soc1 DESC """ valueSql = '%'+val.title()+'%', self.tcpart, int(codcf) try: cr = self.CnAz.cursor () cr.execute(sql % valueSql) rows = cr.fetchall() for row in rows: for rowlc in range(1): row_lc = self.lc.GetItemCount() t_cpart = str(row[0]) cod = str(row[1]) ragsoc1 = str(row[3]).title() ragsoc2 = str(row[4]).title() indiriz = str(row[6]).title() tel_abi = str(row[12]) tel_uff = str(row[13]) fax = str(row[14]) self.lc.InsertStringItem(rowlc, cod) self.lc.SetStringItem(rowlc, 1, ragsoc1) self.lc.SetStringItem(rowlc, 2, ragsoc2) self.lc.SetStringItem(rowlc, 3, indiriz) self.lc.SetStringItem(rowlc, 4, tel_abi) self.lc.SetStringItem(rowlc, 5, tel_uff) self.lc.SetStringItem(rowlc, 6, fax) self.lc.SetItemData(1,0) except StandardError, msg: self.__FRM__.MsgErr("scrtblcf"," Cerca tblcf Error %s" % (msg)) self.CnAz.commit() self.currentItem = 0 wx.StaticLine(self.pnl , -1, wx.DLG_PNT(self.pnl , 5,115), wx.DLG_SZE(self.pnl , 300,-1)) self.ok = wx.Button(self.pnl , Nid, cfg.vcconf, wx.DLG_PNT(self.pnl , 195,120), wx.DLG_SZE(self.pnl,cfg.btnSzeLH,cfg.btnSzeV)) self.canc = wx.Button(self.pnl , Nid, cfg.vccanc, wx.DLG_PNT(self.pnl , 255,120), wx.DLG_SZE(self.pnl,cfg.btnSzeLH,cfg.btnSzeV)) for x in self.pnl.GetChildren(): x.SetFont(self.font) self.canc.SetFocus() #self.SetFont(self.font) box_sizer = wx.BoxSizer(wx.VERTICAL) box_sizer.Add(self.pnl, 0, wx.EXPAND|wx.ALL,0) self.SetAutoLayout(1) self.SetSizer(box_sizer) box_sizer.Fit(self) self.canc.Bind(wx.EVT_BUTTON, self.Close) self.ok.Bind(wx.EVT_BUTTON, self.Ok) self.lc.Bind(wx.EVT_LEFT_DCLICK, self.DblClick) self.lc.Bind(wx.EVT_LIST_ITEM_ACTIVATED, self.LstAct) self.lc.Bind(wx.EVT_LIST_ITEM_SELECTED, self.LstSlct) self.Bind(wx.EVT_CLOSE, self.Close)
class srcmovconr(wx.Dialog): def __init__(self, prnt, cnt): wx.Dialog.__init__(self, id=wx.NewId(), name='', parent=prnt, pos=wx.Point(10, 50), size=wx.DefaultSize, style=wx.DEFAULT_FRAME_STYLE, title=ttl) #self.SetIcon(wx.Icon(cfg.path_img+"/null.ico", wx.BITMAP_TYPE_ICO)) #self.SetFont(wx.Font(12, wx.SWISS, wx.NORMAL, wx.NORMAL, False)) print "srcmovconr" self.cnt = cnt #self.tipo_doc = cnt[0] #print self.cnt anno = cnt[0] data_int = cnt[1] data_int_A = cnt[5] vCF = cnt[3] num_doc = cnt[4].GetValue() #data_doc = cnt[3].GetValue() #stt_doc = cnt[5] Nid = wx.NewId() self.CnAz = prnt.CnAz #self.font = self.GetFont() self.__FRM__ = prnt.__MDI__ self.__MDI__ = wx.GetApp().GetPhasisMdi() self.font = self.__MDI__.font self.SetFont(self.font) self.pnl = wx.Panel(id=wx.NewId(), name='panel', parent=self, pos=wx.Point(0, 0), size=wx.DLG_SZE(self, 540 / 2, 260 / 2)) #, #size=wx.Size(540, 260)) self.pnl.SetFont(self.font) self.lc = wx.ListCtrl(self.pnl, Nid, wx.DLG_PNT(self, 5, 5), wx.DLG_SZE(self.pnl, 300, 100), wx.LC_REPORT | wx.LC_HRULES | wx.LC_VRULES) self.lc.InsertColumn(0, _("Data Mov")) self.lc.InsertColumn(1, _("Anno")) self.lc.InsertColumn(2, _("Num. Mov.")) self.lc.InsertColumn(3, _("D/A")) self.lc.InsertColumn(4, _("Importo")) self.lc.InsertColumn(5, _("Cod.")) self.lc.InsertColumn(6, _("Causale")) self.lc.InsertColumn(7, _("Cod.")) self.lc.InsertColumn(8, _("Operazione")) self.lc.InsertColumn(9, _("Controp.")) self.lc.InsertColumn(10, _("Totale Doc.")) self.lc.SetColumnWidth(0, wx.DLG_SZE(self, 45, -1).width) self.lc.SetColumnWidth(1, wx.DLG_SZE(self, 25, -1).width) self.lc.SetColumnWidth(2, wx.DLG_SZE(self, 45, -1).width) self.lc.SetColumnWidth(3, wx.DLG_SZE(self, 20, -1).width) self.lc.SetColumnWidth(4, wx.DLG_SZE(self, 55, -1).width) self.lc.SetColumnWidth(5, wx.DLG_SZE(self, 25, -1).width) self.lc.SetColumnWidth(6, wx.DLG_SZE(self, 80, -1).width) self.lc.SetColumnWidth(7, wx.DLG_SZE(self, 25, -1).width) self.lc.SetColumnWidth(8, wx.DLG_SZE(self, 80, -1).width) self.lc.SetColumnWidth(9, wx.DLG_SZE(self, 50, -1).width) self.lc.SetColumnWidth(10, wx.DLG_SZE(self, 55, -1).width) #self.lc.SetFont(self.font) rowlc = 0 val = "" sql = """ select * from movcon where t_cpart = "%s" and data_int >= "%s" and data_int <= "%s" order by data_int asc """ valueSql = vCF, int(data_int), int(data_int_A) try: cr = self.CnAz.cursor() cr.execute(sql % valueSql) rows = cr.fetchall() for row in rows: for rowlc in range(1): row_lc = self.lc.GetItemCount() data_mov = str(row[12]) if data_mov == " / / ": data_mov = str(row[2]) anno = str(row[0]) num_mov = str(row[1]) DA = str(row[17]) importo = str(row[8]) codcau = str(row[6]) causale = str(row[7]) codop = str(row[15]) operazione = str(row[29]) t_cpart = str(row[31]) totale = str(row[16]) self.lc.InsertStringItem(rowlc, data_mov) self.lc.SetStringItem(rowlc, 1, anno) self.lc.SetStringItem(rowlc, 2, num_mov) self.lc.SetStringItem(rowlc, 3, DA) self.lc.SetStringItem(rowlc, 4, importo) self.lc.SetStringItem(rowlc, 5, codcau) self.lc.SetStringItem(rowlc, 6, causale) self.lc.SetStringItem(rowlc, 7, codop) self.lc.SetStringItem(rowlc, 8, operazione) self.lc.SetStringItem(rowlc, 9, t_cpart) self.lc.SetStringItem(rowlc, 10, totale) self.lc.SetItemData(0, 0) except StandardError, msg: self.__FRM__.MsgErr("srcmovconr", " srcmovconr Error %s" % (msg)) self.CnAz.commit() self.currentItem = 0 wx.StaticLine(self.pnl, -1, wx.DLG_PNT(self.pnl, 5, 115), wx.DLG_SZE(self.pnl, 300, -1)) wx.StaticLine(self.pnl, -1, wx.DLG_PNT(self.pnl, 5, 115), wx.DLG_SZE(self.pnl, 300, -1)) self.ok = wx.Button(self.pnl, Nid, cfg.vcconf, wx.DLG_PNT(self.pnl, 195, 120), wx.DLG_SZE(self.pnl, cfg.btnSzeMH, cfg.btnSzeV)) self.canc = wx.Button(self.pnl, Nid, cfg.vccanc, wx.DLG_PNT(self.pnl, 255, 120), wx.DLG_SZE(self.pnl, cfg.btnSzeMH, cfg.btnSzeV)) self.canc.SetFocus() for x in self.pnl.GetChildren(): x.SetFont(self.font) box_sizer = wx.BoxSizer(wx.VERTICAL) box_sizer.Add(self.pnl, 0, wx.EXPAND | wx.ALL, 0) self.SetAutoLayout(1) self.SetSizer(box_sizer) box_sizer.Fit(self) self.canc.Bind(wx.EVT_BUTTON, self.Close) self.ok.Bind(wx.EVT_BUTTON, self.Ok) self.lc.Bind(wx.EVT_LEFT_DCLICK, self.DblClick) self.lc.Bind(wx.EVT_LIST_ITEM_ACTIVATED, self.LstAct) self.lc.Bind(wx.EVT_LIST_ITEM_SELECTED, self.LstSlct) self.Bind(wx.EVT_CLOSE, self.Close)
def __init__(self, prnt, cnt): print "kkkkkkkkkkkkkkkkk" self.win=wx.ScrolledWindow.__init__(self, parent=prnt, id=-1,size = wx.DefaultSize) self.SetScrollbars(1,1,100,100) ##### self.FitInside() ###### png = wx.Image((cfg.path_img + "cerca19x19.png"), wx.BITMAP_TYPE_PNG).ConvertToBitmap() #wx.Frame.__init__(self, id = wx.NewId(), name = '', # parent = prnt, pos = wx.Point(0, 0), # style = wx.DEFAULT_FRAME_STYLE , title = ttl) #self.SetIcon(wx.Icon(cfg.path_img + "/null.ico", wx.BITMAP_TYPE_ICO)) #self.SetFont(wx.Font(12, wx.SWISS, wx.NORMAL, wx.NORMAL, False)) self.cnt = cnt #self.SetClientSize(wx.Size(680, 410)) Nid = wx.NewId() self.ttl = cnt[0] self.tcpart = cnt[1][0].upper() self.esport = 0 if (self.tcpart=="C"):self.ttl = _("Anagrafica Clienti") if (self.tcpart=="F"):self.ttl = _("Anagrafica Fornitori") if (self.tcpart=="V"):self.ttl = _("Anagrafica Vettori") if (self.tcpart=="A"):self.ttl = _("Anagrafica Agenti") if (self.tcpart=="T"):self.ttl = _("Anagrafica Tecnici") if (self.tcpart=="C" or self.tcpart=="F" or self.tcpart=="V" or self.tcpart=="T"): self.tblanag = "anag" if (self.tcpart=="A"): self.tblanag = "agenti" self.rec = cnt[2] self.AggMenu = cnt[3] self.IDMENU = cnt[4] self.CMD = cnt[5] self.__MDI__ = wx.GetApp().GetPhasisMdi() self.font=self.__MDI__.font self.SetFont(self.font) self.CnAz = self.__MDI__.GetConnAZ() self.annoc = self.__MDI__.GetAnnoC() self.datacon = self.__MDI__.GetDataC() self.dzDatiAzienda = self.__MDI__.dzDatiAzienda #self.font = self.GetFont() self.sAGE = _("Sgegli l'Agente") self.pnl = wx.Panel(id = wx.NewId(), name = 'panel', parent = self, pos = wx.Point(0, 0), size = wx.DLG_SZE(self,680/2,400/2), #size = wx.Size(680, 400), style = wx.SIMPLE_BORDER | wx.TAB_TRAVERSAL ) self.pnl.SetFont(self.font) self.lc = wx.ListCtrl(self.pnl , Nid, wx.DLG_PNT(self, 5,5), wx.DLG_SZE(self.pnl , 335,110), wx.LC_REPORT | wx.LC_HRULES | wx.LC_VRULES) wx.StaticLine(self.pnl , -1, wx.DLG_PNT(self.pnl , 5,120), wx.DLG_SZE(self.pnl , 335,-1)) wx.StaticText(self.pnl , -1, _("Rag. Soc.:"), wx.DLG_PNT(self.pnl, 5,127)) self.rs = wx.TextCtrl(self.pnl , Nid, "", wx.DLG_PNT(self.pnl , 50,125), wx.DLG_SZE(self.pnl , 100, cfg.DIMFONTDEFAULT), wx.TE_PROCESS_ENTER) self.crs = wx.BitmapButton(self.pnl, -1, png,#wx.Button(self.pnl , Nid, "...", wx.DLG_PNT(self.pnl , 155,125), wx.DLG_SZE(self.pnl , 12,12)) wx.StaticText(self.pnl , -1, _("Localita` :"), wx.DLG_PNT(self.pnl, 5,142)) self.loc = wx.TextCtrl(self.pnl , Nid, "", wx.DLG_PNT(self.pnl , 50,140), wx.DLG_SZE(self.pnl , 100, cfg.DIMFONTDEFAULT), wx.TE_PROCESS_ENTER) self.cloc = wx.BitmapButton(self.pnl, -1, png,#wx.Button(self.pnl , Nid, "...", wx.DLG_PNT(self.pnl , 155,140), wx.DLG_SZE(self.pnl , 12,12)) wx.StaticText(self.pnl , -1, _("Telefono :"), wx.DLG_PNT(self.pnl, 5,157)) self.tel = wx.TextCtrl(self.pnl , Nid, "", wx.DLG_PNT(self.pnl , 50,155), wx.DLG_SZE(self.pnl , 80, cfg.DIMFONTDEFAULT), wx.TE_PROCESS_ENTER) self.ctel = wx.BitmapButton(self.pnl, -1, png,#wx.Button(self.pnl , Nid, "...", wx.DLG_PNT(self.pnl , 135,155), wx.DLG_SZE(self.pnl , 12,12)) self.all = wx.Button(self.pnl , Nid, cfg.vcall, wx.DLG_PNT(self.pnl , 170,125), wx.DLG_SZE(self.pnl,cfg.btnSzeM1H,cfg.btnSzeV)) self.ok = wx.Button(self.pnl , Nid, cfg.vcok, wx.DLG_PNT(self.pnl , 193,125), wx.DLG_SZE(self.pnl,cfg.btnSzeLH,cfg.btnSzeV)) self.int = wx.Button(self.pnl, Nid, cfg.vcint, wx.DLG_PNT(self.pnl, 247,125), wx.DLG_SZE(self.pnl,cfg.btnSzeLH,cfg.btnSzeV)) self.canc = wx.Button(self.pnl , Nid, cfg.vccanc, wx.DLG_PNT(self.pnl , 247,125), wx.DLG_SZE(self.pnl,cfg.btnSzeLH,cfg.btnSzeV)) self.stampa = wx.Button(self.pnl, Nid, cfg.vcstampa, wx.DLG_PNT(self.pnl, 300,125), wx.DLG_SZE(self.pnl,cfg.btnSzeMH,cfg.btnSzeV)) self.exp = wx.Button(self.pnl , Nid, cfg.vcexp, wx.DLG_PNT(self.pnl , 300,140), wx.DLG_SZE(self.pnl,cfg.btnSzeMH,cfg.btnSzeV)) self.rbCONFER = wx.RadioButton(self.pnl, Nid, cfg.vcCONF, wx.DLG_PNT(self.pnl, 180,140), wx.DLG_SZE(self.pnl, 50,10), wx.RB_GROUP ) self.rbPREVIS = wx.RadioButton(self.pnl, Nid, cfg.vcPREV, wx.DLG_PNT(self.pnl, 235,140), wx.DLG_SZE(self.pnl, 50,10)) self.precon = wx.TextCtrl(self.pnl, -1, "C", wx.DLG_PNT(self.pnl, 280,100)) wx.StaticText(self.pnl , -1, _("Rif.:"), wx.DLG_PNT(self.pnl, 155,157)) self.nsrif = wx.TextCtrl(self.pnl , Nid, "", wx.DLG_PNT(self.pnl , 170,155), wx.DLG_SZE(self.pnl , 80, cfg.DIMFONTDEFAULT)) self.AGE = wx.ComboBox(self.pnl, Nid,_("Agente"), wx.DLG_PNT(self.pnl, 255,155), wx.DLG_SZE(self.pnl, 85,-1), [],wx.CB_DROPDOWN | wx.CB_SORT ) self.vAGE = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 275,90)) wx.StaticText(self.pnl , -1, _("Note :"), wx.DLG_PNT(self.pnl, 5,172)) self.note = wx.TextCtrl(self.pnl , Nid, "", wx.DLG_PNT(self.pnl , 50,170), wx.DLG_SZE(self.pnl , 80, cfg.DIMFONTDEFAULT)) self.cnote = wx.BitmapButton(self.pnl, -1, png,#wx.Button(self.pnl , Nid, "...", wx.DLG_PNT(self.pnl , 135,170),wx.DLG_SZE(self.pnl , 12,12)) self.lpiva = wx.StaticText(self.pnl , -1, _("P.IVA :"), wx.DLG_PNT(self.pnl, 155,172)) self.piva = wx.TextCtrl(self.pnl , Nid, "", wx.DLG_PNT(self.pnl , 180,170), wx.DLG_SZE(self.pnl , 70, cfg.DIMFONTDEFAULT)) self.cpiva = wx.BitmapButton(self.pnl, -1, png,#wx.Button(self.pnl , Nid, "...", wx.DLG_PNT(self.pnl , 255,170), wx.DLG_SZE(self.pnl , 12,12)) self.lcap = wx.StaticText(self.pnl , -1, _("CAP :"), wx.DLG_PNT(self.pnl, 272,172)) self.cap = wx.TextCtrl(self.pnl , Nid, "", wx.DLG_PNT(self.pnl , 293,170), wx.DLG_SZE(self.pnl , 30, cfg.DIMFONTDEFAULT)) self.ccap = wx.BitmapButton(self.pnl, -1, png,#wx.Button(self.pnl , Nid, "...", wx.DLG_PNT(self.pnl , 327,170), wx.DLG_SZE(self.pnl , 12,12)) for x in self.pnl.GetChildren(): x.SetFont(self.font) self.lcap.Enable(False) self.lpiva.Enable(False) self.piva.Enable(False) self.cpiva.Enable(False) self.cap.Enable(False) self.ccap.Enable(False) #self.Fit() #self.SetFont(self.font) #box_sizer = wx.BoxSizer(wx.VERTICAL) #box_sizer.Add(self.pnl, 0, wx.EXPAND|wx.ALL,0) #self.SetAutoLayout(1) #self.SetSizer(box_sizer) #box_sizer.Fit(self) box = wx.GridSizer(1, 1) box.Add(self.pnl, 0, wx.ALIGN_CENTER|wx.ALL,10) self.SetSizer(box) box.Fit(self) self.AGE.Bind(wx.EVT_COMBOBOX, self.SelAGE) self.canc.Bind(wx.EVT_BUTTON, self.Close) self.all.Bind(wx.EVT_BUTTON, self.FndSelAll) self.int.Bind(wx.EVT_BUTTON, self.FndInt) self.Bind(wx.EVT_CLOSE, self.Close) self.ok.Bind(wx.EVT_BUTTON, self.Ok) self.lc.Bind(wx.EVT_LEFT_DCLICK, self.DblClick) #self.lc.Bind(wx.EVT_LIST_KEY_DOWN, self.DblClick) self.crs.Bind(wx.EVT_BUTTON, self.FndAnag) self.cloc.Bind(wx.EVT_BUTTON, self.FndAnag) self.ctel.Bind(wx.EVT_BUTTON, self.FndAnag) self.cnote.Bind(wx.EVT_BUTTON, self.FndAnag) self.rbCONFER.Bind(wx.EVT_RADIOBUTTON, self.RadioB) self.rbPREVIS.Bind(wx.EVT_RADIOBUTTON, self.RadioB) self.lc.Bind(wx.EVT_LIST_ITEM_ACTIVATED, self.LstAct) self.lc.Bind(wx.EVT_LIST_ITEM_SELECTED, self.LstSlct) self.rs.Bind(wx.EVT_TEXT_ENTER, self.FndAnag) self.loc.Bind(wx.EVT_TEXT_ENTER, self.FndAnag) self.nsrif.Bind(wx.EVT_TEXT_ENTER, self.FndAnag) self.tel.Bind(wx.EVT_TEXT_ENTER, self.FndAnag) self.note.Bind(wx.EVT_TEXT_ENTER, self.FndAnag) self.stampa.Bind(wx.EVT_BUTTON, self.Stampa) self.exp.Bind(wx.EVT_BUTTON, self.ExpAnag) self.canc.SetFocus() self.Start(self)
def __init__(self, prnt, cnt): wx.Dialog.__init__(self, id=wx.NewId(), name='', parent=prnt, pos=wx.Point(10, 50), size=wx.DefaultSize, style=wx.DEFAULT_FRAME_STYLE, title=ttl) #self.SetIcon(wx.Icon(cfg.path_img+"/null.ico", wx.BITMAP_TYPE_ICO)) #self.SetFont(wx.Font(12, wx.SWISS, wx.NORMAL, wx.NORMAL, False)) print "srcmovconr" self.cnt = cnt #self.tipo_doc = cnt[0] #print self.cnt anno = cnt[0] data_int = cnt[1] data_int_A = cnt[5] vCF = cnt[3] num_doc = cnt[4].GetValue() #data_doc = cnt[3].GetValue() #stt_doc = cnt[5] Nid = wx.NewId() self.CnAz = prnt.CnAz #self.font = self.GetFont() self.__FRM__ = prnt.__MDI__ self.__MDI__ = wx.GetApp().GetPhasisMdi() self.font = self.__MDI__.font self.SetFont(self.font) self.pnl = wx.Panel(id=wx.NewId(), name='panel', parent=self, pos=wx.Point(0, 0), size=wx.DLG_SZE(self, 540 / 2, 260 / 2)) #, #size=wx.Size(540, 260)) self.pnl.SetFont(self.font) self.lc = wx.ListCtrl(self.pnl, Nid, wx.DLG_PNT(self, 5, 5), wx.DLG_SZE(self.pnl, 300, 100), wx.LC_REPORT | wx.LC_HRULES | wx.LC_VRULES) self.lc.InsertColumn(0, _("Data Mov")) self.lc.InsertColumn(1, _("Anno")) self.lc.InsertColumn(2, _("Num. Mov.")) self.lc.InsertColumn(3, _("D/A")) self.lc.InsertColumn(4, _("Importo")) self.lc.InsertColumn(5, _("Cod.")) self.lc.InsertColumn(6, _("Causale")) self.lc.InsertColumn(7, _("Cod.")) self.lc.InsertColumn(8, _("Operazione")) self.lc.InsertColumn(9, _("Controp.")) self.lc.InsertColumn(10, _("Totale Doc.")) self.lc.SetColumnWidth(0, wx.DLG_SZE(self, 45, -1).width) self.lc.SetColumnWidth(1, wx.DLG_SZE(self, 25, -1).width) self.lc.SetColumnWidth(2, wx.DLG_SZE(self, 45, -1).width) self.lc.SetColumnWidth(3, wx.DLG_SZE(self, 20, -1).width) self.lc.SetColumnWidth(4, wx.DLG_SZE(self, 55, -1).width) self.lc.SetColumnWidth(5, wx.DLG_SZE(self, 25, -1).width) self.lc.SetColumnWidth(6, wx.DLG_SZE(self, 80, -1).width) self.lc.SetColumnWidth(7, wx.DLG_SZE(self, 25, -1).width) self.lc.SetColumnWidth(8, wx.DLG_SZE(self, 80, -1).width) self.lc.SetColumnWidth(9, wx.DLG_SZE(self, 50, -1).width) self.lc.SetColumnWidth(10, wx.DLG_SZE(self, 55, -1).width) #self.lc.SetFont(self.font) rowlc = 0 val = "" sql = """ select * from movcon where t_cpart = "%s" and data_int >= "%s" and data_int <= "%s" order by data_int asc """ valueSql = vCF, int(data_int), int(data_int_A) try: cr = self.CnAz.cursor() cr.execute(sql % valueSql) rows = cr.fetchall() for row in rows: for rowlc in range(1): row_lc = self.lc.GetItemCount() data_mov = str(row[12]) if data_mov == " / / ": data_mov = str(row[2]) anno = str(row[0]) num_mov = str(row[1]) DA = str(row[17]) importo = str(row[8]) codcau = str(row[6]) causale = str(row[7]) codop = str(row[15]) operazione = str(row[29]) t_cpart = str(row[31]) totale = str(row[16]) self.lc.InsertStringItem(rowlc, data_mov) self.lc.SetStringItem(rowlc, 1, anno) self.lc.SetStringItem(rowlc, 2, num_mov) self.lc.SetStringItem(rowlc, 3, DA) self.lc.SetStringItem(rowlc, 4, importo) self.lc.SetStringItem(rowlc, 5, codcau) self.lc.SetStringItem(rowlc, 6, causale) self.lc.SetStringItem(rowlc, 7, codop) self.lc.SetStringItem(rowlc, 8, operazione) self.lc.SetStringItem(rowlc, 9, t_cpart) self.lc.SetStringItem(rowlc, 10, totale) self.lc.SetItemData(0, 0) except StandardError, msg: self.__FRM__.MsgErr("srcmovconr", " srcmovconr Error %s" % (msg))
def __init__(self, prnt, cnt): self.win = wx.ScrolledWindow.__init__(self, parent=prnt, id=-1, size=wx.DefaultSize) self.SetScrollbars(1, 1, 100, 100) ##### self.FitInside() ###### png = wx.Image((cfg.path_img + "cerca19x19.png"), wx.BITMAP_TYPE_PNG).ConvertToBitmap() #wx.Dialog.__init__(self, id=wx.NewId(), name='', # parent=prnt, pos=wx.Point(10, 50), size=wx.DefaultSize, # style=wx.DEFAULT_FRAME_STYLE, title=cnt[0]) #self.SetIcon(wx.Icon(cfg.path_img+"/null.ico", wx.BITMAP_TYPE_ICO)) #self.SetFont(wx.Font(12, wx.SWISS, wx.NORMAL, wx.NORMAL, False)) self.cnt = cnt self.ttl = cnt[0] self.rec = cnt[2] self.AggMenu = cnt[3] self.IDMENU = cnt[4] #self.font=self.GetFont() self.vCodTblG = cnt[1] Nid = wx.NewId() self.__MDI__ = wx.GetApp().GetPhasisMdi() self.font = self.__MDI__.font self.SetFont(self.font) self.CnAz = self.__MDI__.GetConnAZ() self.pnl = wx.Panel(id=wx.NewId(), name='panel', parent=self, pos=wx.Point(0, 0), style=wx.SIMPLE_BORDER | wx.TAB_TRAVERSAL) self.pnl.SetFont(self.font) self.titolo = wx.StaticText(self.pnl, -1, _("Aggiungi Scadenze"), wx.DLG_PNT(self.pnl, 5, 7)) self.titolo.SetFont(self.font) wx.StaticText(self.pnl, -1, "Controp.:", wx.DLG_PNT(self.pnl, 5, 27)) self.CF = wx.ComboBox(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 50, 25), wx.DLG_SZE(self.pnl, 50, -1), [], wx.CB_DROPDOWN | wx.CB_SORT) self.vCF = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 35, 25)) self.valore = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 50, 25), wx.DLG_SZE(self.pnl, 60, cfg.DIMFONTDEFAULT)) self.valore.SetFont(self.font) self.lcodgen = wx.StaticText(self.pnl, -1, _("Codic :"), wx.DLG_PNT(self.pnl, 140, 17)) self.lcodgen.SetFont(self.font) self.codgen = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 185, 15), wx.DLG_SZE(self.pnl, 60, cfg.DIMFONTDEFAULT)) self.codgen.SetFont(self.font) self.ldescriz = wx.StaticText(self.pnl, -1, _("Descrizione :"), wx.DLG_PNT(self.pnl, 5, 47)) self.ldescriz.SetFont(self.font) self.descriz = wx.TextCtrl( self.pnl, Nid, "", wx.DLG_PNT(self.pnl, 50, 45), wx.DLG_SZE(self.pnl, 180, cfg.DIMFONTDEFAULT)) self.descriz.SetFont(self.font) self.cdescriz = wx.BitmapButton( self.pnl, -1, png, #wx.Button(self.pnl, Nid, "...", wx.DLG_PNT(self.pnl, 233, 45), wx.DLG_SZE(self.pnl, cfg.btnSzeSH, cfg.btnSzeV)) self.new = wx.Button(self.pnl, Nid, cfg.vcnew, wx.DLG_PNT(self.pnl, 285, 20), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) self.new.SetFont(self.font) self.ok = wx.Button(self.pnl, Nid, cfg.vcok, wx.DLG_PNT(self.pnl, 285, 20), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) self.ok.SetFont(self.font) self.inte = wx.Button(self.pnl, Nid, cfg.vcint, wx.DLG_PNT(self.pnl, 285, 35), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) self.inte.SetFont(self.font) self.canc = wx.Button(self.pnl, Nid, cfg.vccanc, wx.DLG_PNT(self.pnl, 285, 35), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) self.canc.SetFont(self.font) self.modi = wx.Button(self.pnl, Nid, cfg.vcmodi, wx.DLG_PNT(self.pnl, 285, 50), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) self.modi.SetFont(self.font) self.dele = wx.Button(self.pnl, Nid, cfg.vcdele, wx.DLG_PNT(self.pnl, 285, 50), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) self.dele.SetFont(self.font) self.stampa = wx.Button( self.pnl, Nid, cfg.vcstampa, wx.DLG_PNT(self.pnl, 285, 65), wx.DLG_SZE(self.pnl, cfg.btnSzeLH, cfg.btnSzeV)) self.stampa.SetFont(self.font) #self.SetFont(self.font) #box_sizer = wx.BoxSizer(wx.VERTICAL) #box_sizer.Add(self.pnl, 0, wx.EXPAND|wx.ALL,0) #self.SetAutoLayout(1) #self.SetSizer(box_sizer) #box_sizer.Fit(self) box = wx.GridSizer(1, 1) box.Add(self.pnl, 0, wx.ALIGN_CENTER | wx.ALL, 10) self.SetSizer(box) box.Fit(self) self.CF.Bind(wx.EVT_COMBOBOX, self.SelCOMBOcfev) self.ok.Bind(wx.EVT_BUTTON, self.Save) self.new.Bind(wx.EVT_BUTTON, self.New) self.inte.Bind(wx.EVT_BUTTON, self.Intscadenze) self.modi.Bind(wx.EVT_BUTTON, self.Modi) self.canc.Bind(wx.EVT_BUTTON, self.Close) self.dele.Bind(wx.EVT_BUTTON, self.CntrDele) self.descriz.Bind(wx.EVT_TEXT_ENTER, self.FndDescriz) self.cdescriz.Bind(wx.EVT_BUTTON, self.FndDescriz) self.stampa.Bind(wx.EVT_BUTTON, self.Stampa) self.Bind(wx.EVT_CLOSE, self.Close) self.Start(self)
def __init__(self, prnt, cnt): self.win=wx.ScrolledWindow.__init__(self, parent=prnt, id=-1,size = wx.DefaultSize) self.SetScrollbars(1,1,100,100) ##### self.FitInside() ###### png = wx.Image((cfg.path_img + "cerca19x19.png"), wx.BITMAP_TYPE_PNG).ConvertToBitmap() #wx.Frame.__init__(self, id=wx.NewId(), name='', # parent=prnt, pos=wx.Point(0, 0), # style=wx.DEFAULT_FRAME_STYLE , title=cnt[0]) #self.SetIcon(wx.Icon(cfg.path_img+"/null.ico", wx.BITMAP_TYPE_ICO)) #self.SetFont(wx.Font(12, wx.SWISS, wx.NORMAL, wx.NORMAL, False)) self.cnt = cnt Nid = wx.NewId() self.ttl=cnt[0] self.tipoord =cnt[1] self.tcpart="C" #self.ottl="Gestione Movimenti" self.tbl="movcon" self.tblart="articoli" self.rec=cnt[2] self.AggMenu=cnt[3] self.IDMENU=cnt[4] self.CMD=cnt[5] #self.font=self.GetFont() #self.SetClientSize(wx.Size(680, 400)) self.__MDI__= wx.GetApp().GetPhasisMdi() self.font=self.__MDI__.font self.SetFont(self.font) self.CnAz=self.__MDI__.GetConnAZ() self.annoc=self.__MDI__.GetAnnoC() self.datacon= self.__MDI__.GetDataC() self.dzDatiAzienda= self.__MDI__.dzDatiAzienda self.pnl = wx.Panel(id=wx.NewId(), name='panel1', parent=self, pos=wx.Point(0, 0), size = wx.DLG_SZE(self,680/2,400/2), #size=wx.Size(680, 400), style = wx.SIMPLE_BORDER | wx.TAB_TRAVERSAL) self.pnl.SetFont(self.font) btnSzeL = wx.DLG_SZE(self.pnl, 70,16) btnSzeM = wx.DLG_SZE(self.pnl, 80,16) btnSzeM1 = wx.DLG_SZE(self.pnl, 60,16) btnSzeS = wx.DLG_SZE(self.pnl, 16,16) btnSzeD = wx.DLG_SZE(self.pnl, 60,14) #self.pnl.SetFont(self.font) self.lc = wx.ListCtrl(self.pnl , Nid, wx.DLG_PNT(self, 5,5), wx.DLG_SZE(self.pnl , 335,130), wx.LC_REPORT|wx.LC_HRULES|wx.LC_VRULES) wx.StaticLine(self.pnl , -1, wx.DLG_PNT(self.pnl , 5,140), wx.DLG_SZE(self.pnl , 335,-1)) wx.StaticText(self.pnl, -1, "Contropartita :", wx.DLG_PNT(self.pnl, 10,152)) self.CF = wx.ComboBox(self.pnl, Nid,"", wx.DLG_PNT(self.pnl, 65,150), wx.DLG_SZE(self.pnl, 60,-1), [], wx.CB_DROPDOWN | wx.CB_SORT ) self.vCF = wx.TextCtrl(self.pnl, -1, "", wx.DLG_PNT(self.pnl, 65,150)) self.lc1odcf = wx.StaticText(self.pnl, -1, "Cod.", wx.DLG_PNT(self.pnl, 135,152)) self.codcf = wx.TextCtrl(self.pnl , Nid, "", wx.DLG_PNT(self.pnl , 180,150), wx.DLG_SZE(self.pnl , 40, cfg.DIMFONTDEFAULT),wx.TE_PROCESS_ENTER) self.ccodcf = wx.BitmapButton(self.pnl, -1, png,#wx.Button(self.pnl , -1, "...", wx.DLG_PNT(self.pnl , 225,150), wx.DLG_SZE(self.pnl , 12,12),wx.TE_PROCESS_ENTER) wx.StaticText(self.pnl , -1, _("Rag Soc.:"), wx.DLG_PNT(self, 25,172)) self.ragsoc1 = wx.TextCtrl(self.pnl , Nid, "", wx.DLG_PNT(self.pnl , 65,170), wx.DLG_SZE(self.pnl , 100, cfg.DIMFONTDEFAULT),wx.TE_PROCESS_ENTER) self.cragsoc1 = wx.BitmapButton(self.pnl, -1, png,#wx.Button(self.pnl , -1, "...", wx.DLG_PNT(self.pnl , 170,170), wx.DLG_SZE(self.pnl , 12,12),wx.TE_PROCESS_ENTER) wx.StaticText(self.pnl , -1, "", wx.DLG_PNT(self, 25,190)) self.ok = wx.Button(self.pnl , -1, cfg.vcok, wx.DLG_PNT(self.pnl , 300,150), wx.DLG_SZE(self.pnl,cfg.btnSzeLH,cfg.btnSzeV)) self.canc = wx.Button(self.pnl , -1, cfg.vccanc, wx.DLG_PNT(self.pnl , 300,165), wx.DLG_SZE(self.pnl,cfg.btnSzeLH,cfg.btnSzeV)) self.inte = wx.Button(self.pnl , -1, cfg.vcint, wx.DLG_PNT(self.pnl , 300,165), wx.DLG_SZE(self.pnl,cfg.btnSzeLH,cfg.btnSzeV)) self.stampa = wx.Button(self.pnl, -1, cfg.vcstampa, wx.DLG_PNT(self.pnl, 300,180), wx.DLG_SZE(self.pnl,cfg.btnSzeLH,cfg.btnSzeV)) for x in self.pnl.GetChildren(): x.SetFont(self.font) self.canc.SetFocus() #self.SetFont(self.font) #box_sizer = wx.BoxSizer(wx.VERTICAL) #box_sizer.Add(self.pnl, 0, wx.EXPAND|wx.ALL,0) #self.SetAutoLayout(1) #self.SetSizer(box_sizer) #box_sizer.Fit(self) box = wx.GridSizer(1, 1) box.Add(self.pnl, 0, wx.ALIGN_CENTER|wx.ALL,10) self.SetSizer(box) box.Fit(self) self.canc.Bind(wx.EVT_BUTTON, self.Close) self.inte.Bind(wx.EVT_BUTTON, self.Start) self.Bind(wx.EVT_CLOSE, self.Close) self.ok.Bind(wx.EVT_BUTTON, self.Ok) self.lc.Bind(wx.EVT_LEFT_DCLICK, self.DblClick) self.stampa.Bind(wx.EVT_BUTTON, self.Stampa) self.cragsoc1.Bind(wx.EVT_BUTTON, self.FndAnag) self.ragsoc1.Bind(wx.EVT_TEXT_ENTER, self.FndAnag) self.CF.Bind(wx.EVT_COMBOBOX, self.SelCOMBOcfev) #self.cragsoc1.Bind(wx.EVT_BUTTON, self.FndMov) #self.ragsoc1.Bind(wx.EVT_TEXT_ENTER, self.FndMov) self.ccodcf.Bind(wx.EVT_BUTTON, self.FndMov) self.codcf.Bind(wx.EVT_TEXT_ENTER, self.FndMov) self.lc.Bind(wx.EVT_LIST_ITEM_ACTIVATED, self.LstAct) self.lc.Bind(wx.EVT_LIST_ITEM_SELECTED, self.LstSlct) self.Start(self)