def Onequdtoday( self, event ): mkt.mktequd(todaydate) app = wx.App() frame = dialogover.MyDialogover(parent=None) frame.Show() app.MainLoop() event.Skip()
def Onequdtoday(self, event):
mkt.mktequd(todaydate)
app = wx.App()
frame = dialogover.MyDialogover(parent=None)
frame.Show()
app.MainLoop()
event.Skip()
def check_mktequd(tradetime):
#mkt_mktequd = `mkt_mktequd`
cursor.execute(
"""SELECT distinct(tradeDate) FROM mkt_mktequd where tradeDate=%s
""", (tradetime))
counttoday, i = 0, 0
counttoday += cursor.rowcount
print counttoday
while (counttoday == 0 and i < 2):
inputtradetime = timecheck.chgtimefor(tradetime)
mkt.mktequd(inputtradetime)
cursor.execute(
"""SELECT distinct(tradeDate) FROM mkt_mktequd where tradeDate=%s
""", (tradetime))
counttoday += cursor.rowcount
#print counttoday
if counttoday == 0:
tradetime = timecheck.getyesday(tradetime)
cursor.execute(
"""SELECT distinct(tradeDate) FROM mkt_mktequd where tradeDate=%s
""", (tradetime))
if cursor.rowcount > 0:
break
#print tradetime
i += 1
return tradetime
def Onmktequdtoday( self, event ):
todaydate = time.strftime('%Y%m%d')
mkt.mktequd(todaydate)
app = wx.App()
frame = dialogover.MyDialogover(parent=None)
frame.Show()
app.MainLoop()
event.Skip()
def Onmktequdtoday(self, event):
todaydate = time.strftime('%Y%m%d')
mkt.mktequd(todaydate)
app = wx.App()
frame = dialogover.MyDialogover(parent=None)
frame.Show()
app.MainLoop()
event.Skip()
def Onmktequdoneday( self, event ): inputdate=self.m_textCtrl74.GetValue() #print inputdate mkt.mktequd(inputdate) #print "over" app = wx.App() frame = dialogover.MyDialogover(parent=None) frame.Show() app.MainLoop() event.Skip()
def Onmktequdoneday(self, event):
inputdate = self.m_textCtrl74.GetValue()
#print inputdate
mkt.mktequd(inputdate)
#print "over"
app = wx.App()
frame = dialogover.MyDialogover(parent=None)
frame.Show()
app.MainLoop()
event.Skip()
def Onmktequdpreday( self, event ):
now_time = datetime.datetime.now()
yes_time = now_time + datetime.timedelta(days=-1)
yes_time_nyr = yes_time.strftime('%Y%m%d')
mkt.mktequd(yes_time_nyr)
app = wx.App()
frame = dialogover.MyDialogover(parent=None)
frame.Show()
app.MainLoop()
event.Skip()
def Onmktequdpreday(self, event):
now_time = datetime.datetime.now()
yes_time = now_time + datetime.timedelta(days=-1)
yes_time_nyr = yes_time.strftime('%Y%m%d')
mkt.mktequd(yes_time_nyr)
app = wx.App()
frame = dialogover.MyDialogover(parent=None)
frame.Show()
app.MainLoop()
event.Skip()
def upmktall():
mkt.mktequd(todaydate)
mkt.mktfutd(todaydate)
mkt.mktidxd(todaydate)
mkt.mktblockd(todaydate)
mkt.mktrepod(todaydate)
mkt.mktbondd(todaydate)
#mkt.mkthkequd(todaydate)
mkt.mktfundd(todaydate)
mkt.mktoptd(todaydate)
mkt.mktall(todaydate)
mkt.mktindex(todaydate)
#mkt.mktequd(todaydate)
#mkt.mktbondd('20160406')
def check_mktequd(tradetime):
#mkt_mktequd = `mkt_mktequd`
cursor.execute("""SELECT distinct(tradeDate) FROM mkt_mktequd where tradeDate=%s
""",(tradetime))
counttoday,i = 0,0
counttoday += cursor.rowcount
print counttoday
while (counttoday == 0 and i < 2):
inputtradetime = timecheck.chgtimefor(tradetime)
mkt.mktequd(inputtradetime)
cursor.execute("""SELECT distinct(tradeDate) FROM mkt_mktequd where tradeDate=%s
""",(tradetime))
counttoday += cursor.rowcount
#print counttoday
if counttoday == 0 :
tradetime = timecheck.getyesday(tradetime)
cursor.execute("""SELECT distinct(tradeDate) FROM mkt_mktequd where tradeDate=%s
""",(tradetime))
if cursor.rowcount > 0:
break
#print tradetime
i += 1
return tradetime
def __init__( self, parent ):
#定义获取数据
tradetime = timecheck.getweekday(todaydate,'1530')
#cursor.execute("""SELECT distinct(tradeDate) FROM mkt_mktequd group by tradeDate order by tradeDate desc
# """)
cursor.execute("""SELECT distinct(tradeDate) FROM mkt_mktequd where tradeDate=%s
""",(tradetime))
#tradetimesql = cursor.fetchone()
#print tradetime
#print tradetimesql[0]
#if tradetime != tradetimesql[0] :
counttoday = 0
i = 0
counttoday += cursor.rowcount
print counttoday
while (counttoday == 0 and i < 2):
'''
app = wx.App()
frame1 = dialoging.MyDialoging(parent=None)
frame1.Show()
app.MainLoop()'''
#print tradetime
inputtradetime = timecheck.chgtimefor(tradetime)
#print inputtradetime
mkt.mktequd(inputtradetime)
cursor.execute("""SELECT distinct(tradeDate) FROM mkt_mktequd where tradeDate=%s
""",(tradetime))
counttoday += cursor.rowcount
print counttoday
if counttoday == 0 :
tradetime = timecheck.getyesday(tradetime)
cursor.execute("""SELECT distinct(tradeDate) FROM mkt_mktequd where tradeDate=%s
""",(tradetime))
if cursor.rowcount > 0:
break
print tradetime
i += 1
'''app = wx.App()
#frame1.Close()
frame = dialogover.MyDialogover(parent=None)
frame.Show()
app.MainLoop()'''
cursor.execute("""select ticker,secShortName,openPrice,highestPrice,lowestPrice,preClosePrice,closePrice,turnoverVol,turnoverValue,dealAmount,
turnoverRate,negMarketValue,marketValue,PE,PE1,PB,tradeDate
from mkt_mktequd where tradeDate = %s
order by ticker asc
limit 50
""",(tradetime))
datacode = cursor.fetchall()
count = cursor.rowcount
global data
data = [[] for i in range(count)]
k=0
for datalist in datacode:
for j in range(0,17):
data[k].append(datalist[j])
k=k+1
#将ticker的显示数前面补0
for i in range(0,count):
data[i][0]= "%06d" % data[i][0]
global colLabels
colLabels =[u"股票代码",u"股票名称",u"今日开盘价",u"最高价",u"最低价",u"昨日收盘价",u"今日收盘价",u"成交量",u"成交金额",u"成交笔数",
u"日换手率",u"流通市值",u"总市值",u"滚动市盈率",u"市盈率",u"市净率",u"交易日期",u"所属行业",u"概念板块"]
#print len(colLabels)
global colnum,dataSortBigger,dataSortSmaller
colnum = len(data[0])
#print colnum
dataSortBigger = [[]for i in range(colnum)]
dataSortSmaller = [[]for i in range(colnum)]
for i in range(0,colnum):
sortMin(data,i,dataSortBigger[i])
sortMax(data,i,dataSortSmaller[i])
#print dataSortBigger
wx.Frame.__init__ ( self, parent, id = wx.ID_ANY, title = u"沪深股票日行情", pos = wx.DefaultPosition, size = wx.Size( 716,508 ), style = wx.DEFAULT_FRAME_STYLE|wx.TAB_TRAVERSAL )
#id = frame.GetId()
self.SetSizeHintsSz( wx.DefaultSize, wx.DefaultSize )
self.m_menubar1 = wx.MenuBar( 0 )
self.m_menuupdb = wx.Menu()
self.m_menuupdb.AppendSeparator()
self.m_menuItemdb = wx.MenuItem( self.m_menuupdb, wx.ID_ANY, u"选择更新数据库", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menuupdb.AppendItem( self.m_menuItemdb )
self.m_menuupdb.AppendSeparator()
self.m_menubar1.Append( self.m_menuupdb, u"更新数据库" )
self.m_menuanal = wx.Menu()
self.m_menuanal.AppendSeparator()
self.m_menuItemanal1 = wx.MenuItem( self.m_menuanal, wx.ID_ANY, u"报价分析", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menuanal.AppendItem( self.m_menuItemanal1 )
self.m_menuItemanal2 = wx.MenuItem( self.m_menuanal, wx.ID_ANY, u"即时分析", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menuanal.AppendItem( self.m_menuItemanal2 )
self.m_menuItemanal3 = wx.MenuItem( self.m_menuanal, wx.ID_ANY, u"技术分析", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menuanal.AppendItem( self.m_menuItemanal3 )
self.m_menuItemanal4 = wx.MenuItem( self.m_menuanal, wx.ID_ANY, u"报表分析", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menuanal.AppendItem( self.m_menuItemanal4 )
self.m_menuanal.AppendSeparator()
self.m_menubar1.Append( self.m_menuanal, u"分析" )
self.m_menuday = wx.Menu()
self.m_menuday.AppendSeparator()
self.m_menu11 = wx.Menu()
self.m_menuItem79 = wx.MenuItem( self.m_menu11, wx.ID_ANY, u"全部沪深股", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu11.AppendItem( self.m_menuItem79 )
self.m_menuItem4711 = wx.MenuItem( self.m_menu11, wx.ID_ANY, u"A股", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu11.AppendItem( self.m_menuItem4711 )
self.m_menuItem481 = wx.MenuItem( self.m_menu11, wx.ID_ANY, u"中小板", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu11.AppendItem( self.m_menuItem481 )
self.m_menuItem491 = wx.MenuItem( self.m_menu11, wx.ID_ANY, u"创业板", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu11.AppendItem( self.m_menuItem491 )
self.m_menuItem501 = wx.MenuItem( self.m_menu11, wx.ID_ANY, u"B股", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu11.AppendItem( self.m_menuItem501 )
self.m_menuItem511 = wx.MenuItem( self.m_menu11, wx.ID_ANY, u"三板", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu11.AppendItem( self.m_menuItem511 )
self.m_menuday.AppendSubMenu( self.m_menu11, u"沪深股" )
self.m_menu51 = wx.Menu()
self.m_menuItem86 = wx.MenuItem( self.m_menu51, wx.ID_ANY, u"全部基金", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu51.AppendItem( self.m_menuItem86 )
self.m_menuItem461 = wx.MenuItem( self.m_menu51, wx.ID_ANY, u"LOF", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu51.AppendItem( self.m_menuItem461 )
self.m_menuItem531 = wx.MenuItem( self.m_menu51, wx.ID_ANY, u"ETF", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu51.AppendItem( self.m_menuItem531 )
self.m_menuItem541 = wx.MenuItem( self.m_menu51, wx.ID_ANY, u"上证基金", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu51.AppendItem( self.m_menuItem541 )
self.m_menuItem551 = wx.MenuItem( self.m_menu51, wx.ID_ANY, u"深证基金", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu51.AppendItem( self.m_menuItem551 )
self.m_menuday.AppendSubMenu( self.m_menu51, u"基金" )
self.m_menu251 = wx.Menu()
self.m_menuItem87 = wx.MenuItem( self.m_menu251, wx.ID_ANY, u"全部债券", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu251.AppendItem( self.m_menuItem87 )
self.m_menuItem92 = wx.MenuItem( self.m_menu251, wx.ID_ANY, u"银行间债券", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu251.AppendItem( self.m_menuItem92 )
self.m_menuItem93 = wx.MenuItem( self.m_menu251, wx.ID_ANY, u"上证债券", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu251.AppendItem( self.m_menuItem93 )
self.m_menuItem94 = wx.MenuItem( self.m_menu251, wx.ID_ANY, u"深证债券", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu251.AppendItem( self.m_menuItem94 )
self.m_menuday.AppendSubMenu( self.m_menu251, u"债券" )
self.m_menu261 = wx.Menu()
self.m_menuItem88 = wx.MenuItem( self.m_menu261, wx.ID_ANY, u"全部期货", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu261.AppendItem( self.m_menuItem88 )
self.m_menuItem95 = wx.MenuItem( self.m_menu261, wx.ID_ANY, u"中金所", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu261.AppendItem( self.m_menuItem95 )
self.m_menuItem96 = wx.MenuItem( self.m_menu261, wx.ID_ANY, u"上海期货", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu261.AppendItem( self.m_menuItem96 )
self.m_menuItem97 = wx.MenuItem( self.m_menu261, wx.ID_ANY, u"大连商品", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu261.AppendItem( self.m_menuItem97 )
self.m_menuItem98 = wx.MenuItem( self.m_menu261, wx.ID_ANY, u"郑州商品", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu261.AppendItem( self.m_menuItem98 )
self.m_menuday.AppendSubMenu( self.m_menu261, u"期货" )
self.m_menu241 = wx.Menu()
self.m_menuItem89 = wx.MenuItem( self.m_menu241, wx.ID_ANY, u"全部期权", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu241.AppendItem( self.m_menuItem89 )
self.m_menuItem99 = wx.MenuItem( self.m_menu241, wx.ID_ANY, u"上证期权", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu241.AppendItem( self.m_menuItem99 )
self.m_menuItem100 = wx.MenuItem( self.m_menu241, wx.ID_ANY, u"期权标的", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu241.AppendItem( self.m_menuItem100 )
self.m_menuday.AppendSubMenu( self.m_menu241, u"期权" )
self.m_menu221 = wx.Menu()
self.m_menuday.AppendSubMenu( self.m_menu221, u"港股" )
self.m_menuday.AppendSeparator()
self.m_menubar1.Append( self.m_menuday, u"日行情显示" )
self.m_menureal = wx.Menu()
self.m_menureal.AppendSeparator()
self.m_menuItem110 = wx.MenuItem( self.m_menureal, wx.ID_ANY, u"大盘指数实时行情", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menureal.AppendItem( self.m_menuItem110 )
self.m_menu1 = wx.Menu()
self.m_menuItem791 = wx.MenuItem( self.m_menu1, wx.ID_ANY, u"全部沪深股", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu1.AppendItem( self.m_menuItem791 )
self.m_menuItem471 = wx.MenuItem( self.m_menu1, wx.ID_ANY, u"A股", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu1.AppendItem( self.m_menuItem471 )
self.m_menuItem48 = wx.MenuItem( self.m_menu1, wx.ID_ANY, u"中小板", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu1.AppendItem( self.m_menuItem48 )
self.m_menuItem49 = wx.MenuItem( self.m_menu1, wx.ID_ANY, u"创业板", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu1.AppendItem( self.m_menuItem49 )
self.m_menuItem50 = wx.MenuItem( self.m_menu1, wx.ID_ANY, u"B股", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu1.AppendItem( self.m_menuItem50 )
self.m_menuItem51 = wx.MenuItem( self.m_menu1, wx.ID_ANY, u"三板", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu1.AppendItem( self.m_menuItem51 )
self.m_menureal.AppendSubMenu( self.m_menu1, u"沪深股" )
self.m_menu5 = wx.Menu()
self.m_menuItem861 = wx.MenuItem( self.m_menu5, wx.ID_ANY, u"全部基金", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu5.AppendItem( self.m_menuItem861 )
self.m_menuItem46 = wx.MenuItem( self.m_menu5, wx.ID_ANY, u"LOF", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu5.AppendItem( self.m_menuItem46 )
self.m_menuItem53 = wx.MenuItem( self.m_menu5, wx.ID_ANY, u"ETF", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu5.AppendItem( self.m_menuItem53 )
self.m_menuItem54 = wx.MenuItem( self.m_menu5, wx.ID_ANY, u"上证基金", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu5.AppendItem( self.m_menuItem54 )
self.m_menuItem55 = wx.MenuItem( self.m_menu5, wx.ID_ANY, u"深证基金", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu5.AppendItem( self.m_menuItem55 )
self.m_menureal.AppendSubMenu( self.m_menu5, u"基金" )
self.m_menu25 = wx.Menu()
self.m_menuItem871 = wx.MenuItem( self.m_menu25, wx.ID_ANY, u"全部债券", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu25.AppendItem( self.m_menuItem871 )
self.m_menuItem921 = wx.MenuItem( self.m_menu25, wx.ID_ANY, u"银行间债券", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu25.AppendItem( self.m_menuItem921 )
self.m_menuItem931 = wx.MenuItem( self.m_menu25, wx.ID_ANY, u"上证债券", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu25.AppendItem( self.m_menuItem931 )
self.m_menuItem941 = wx.MenuItem( self.m_menu25, wx.ID_ANY, u"深证债券", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu25.AppendItem( self.m_menuItem941 )
self.m_menureal.AppendSubMenu( self.m_menu25, u"债券" )
self.m_menu26 = wx.Menu()
self.m_menuItem881 = wx.MenuItem( self.m_menu26, wx.ID_ANY, u"全部期货", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu26.AppendItem( self.m_menuItem881 )
self.m_menuItem951 = wx.MenuItem( self.m_menu26, wx.ID_ANY, u"中金所", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu26.AppendItem( self.m_menuItem951 )
self.m_menuItem961 = wx.MenuItem( self.m_menu26, wx.ID_ANY, u"上海期货", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu26.AppendItem( self.m_menuItem961 )
self.m_menuItem971 = wx.MenuItem( self.m_menu26, wx.ID_ANY, u"大连商品", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu26.AppendItem( self.m_menuItem971 )
self.m_menuItem981 = wx.MenuItem( self.m_menu26, wx.ID_ANY, u"郑州商品", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu26.AppendItem( self.m_menuItem981 )
self.m_menureal.AppendSubMenu( self.m_menu26, u"期货" )
self.m_menu24 = wx.Menu()
self.m_menuItem891 = wx.MenuItem( self.m_menu24, wx.ID_ANY, u"全部期权", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu24.AppendItem( self.m_menuItem891 )
self.m_menuItem991 = wx.MenuItem( self.m_menu24, wx.ID_ANY, u"上证期权", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu24.AppendItem( self.m_menuItem991 )
self.m_menuItem1001 = wx.MenuItem( self.m_menu24, wx.ID_ANY, u"期权标的", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu24.AppendItem( self.m_menuItem1001 )
self.m_menureal.AppendSubMenu( self.m_menu24, u"期权" )
self.m_menu22 = wx.Menu()
self.m_menureal.AppendSubMenu( self.m_menu22, u"港股" )
self.m_menureal.AppendSeparator()
self.m_menubar1.Append( self.m_menureal, u"实时行情显示" )
self.m_menuboard = wx.Menu()
self.m_menuboard.AppendSeparator()
self.m_menu211 = wx.Menu()
self.m_menuItem106 = wx.MenuItem( self.m_menu211, wx.ID_ANY, u"全部行业板块", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu211.AppendItem( self.m_menuItem106 )
self.m_menuboard.AppendSubMenu( self.m_menu211, u"行业板块" )
self.m_menu171 = wx.Menu()
self.m_menuItem107 = wx.MenuItem( self.m_menu171, wx.ID_ANY, u"全部地区板块", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu171.AppendItem( self.m_menuItem107 )
self.m_menuboard.AppendSubMenu( self.m_menu171, u"地区板块" )
self.m_menu161 = wx.Menu()
self.m_menuItem108 = wx.MenuItem( self.m_menu161, wx.ID_ANY, u"全部指数", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu161.AppendItem( self.m_menuItem108 )
'''
self.m_menuItem110 = wx.MenuItem( self.m_menu161, wx.ID_ANY, u"大盘指数", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu161.AppendItem( self.m_menuItem110 )
'''
self.m_menuboard.AppendSubMenu( self.m_menu161, u"指数板块" )
self.m_menu81 = wx.Menu()
self.m_menuItem109 = wx.MenuItem( self.m_menu81, wx.ID_ANY, u"全部概念板块", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu81.AppendItem( self.m_menuItem109 )
self.m_menuboard.AppendSubMenu( self.m_menu81, u"概念板块" )
self.m_menuboard.AppendSeparator()
self.m_menubar1.Append( self.m_menuboard, u"板块" )
self.m_menutools = wx.Menu()
self.m_menutools.AppendSeparator()
self.child1 = self.m_menutools.Append(-1,u'公式管理器','there are lots of formulas')
self.child2 = self.m_menutools.Append(-1,u'模板管理器','there are lots of templates')
self.m_menutools.AppendSeparator()
self.m_menubar1.Append(self.m_menutools, u'工具')
'''self.menu4 = wx.Menu()
self.child3 = wx.MenuItem(self.menu4,1,u'&个股数据\tF10')
self.menu4.AppendItem(child3)
self.menu4.AppendSeparator()
self.child4 = wx.Menu()
self.child4_1=self.child4.Append(-1,u'更新所有')
self.child4_2=self.child4.Append(-1,u'更新SZ板块')
self.child4_3=self.child4.Append(-1,u'更新SH板块')
#注意区别的是，这里用appendmenu而不是appenditem
self.menu4.AppendMenu(-1,u'更新个股资料',self.child4)
self.m_menubar1.Append(self.menu4,u'微系统')
self.SetMenuBar( self.m_menubar1 )
'''
self.m_menu18 = wx.Menu()
self.m_menu18.AppendSeparator()
self.m_menuItem942 = wx.MenuItem( self.m_menu18, wx.ID_ANY, u"个股数据\tF10", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu18.AppendItem( self.m_menuItem942 )
self.m_menu17 = wx.Menu()
self.m_menuItem952 = wx.MenuItem( self.m_menu17, wx.ID_ANY, u"更新所有", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu17.AppendItem( self.m_menuItem952 )
self.m_menuItem962 = wx.MenuItem( self.m_menu17, wx.ID_ANY, u"更新SZ板块", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu17.AppendItem( self.m_menuItem962 )
self.m_menuItem972 = wx.MenuItem( self.m_menu17, wx.ID_ANY, u"更新SH板块", wx.EmptyString, wx.ITEM_NORMAL )
self.m_menu17.AppendItem( self.m_menuItem972 )
self.m_menu18.AppendSubMenu( self.m_menu17, u"更新个股资料" )
self.m_menubar1.Append( self.m_menu18, u"微系统" )
self.SetMenuBar( self.m_menubar1 )
bSizer6 = wx.BoxSizer( wx.VERTICAL )
self.m_panel2 = wx.Panel( self, wx.ID_ANY, wx.DefaultPosition, wx.DefaultSize, wx.TAB_TRAVERSAL )
bSizer1 = wx.BoxSizer( wx.VERTICAL )
self.m_staticline33 = wx.StaticLine( self.m_panel2, wx.ID_ANY, wx.DefaultPosition, wx.DefaultSize, wx.LI_HORIZONTAL )
bSizer1.Add( self.m_staticline33, 0, wx.EXPAND |wx.ALL, 5 )
fgSizer14 = wx.FlexGridSizer( 1, 1, 0, 0 )
fgSizer14.SetFlexibleDirection( wx.BOTH )
fgSizer14.SetNonFlexibleGrowMode( wx.FLEX_GROWMODE_SPECIFIED )
########################
#创建网格表
self.grid = wx.grid.Grid(self.m_panel2, wx.ID_ANY, wx.DefaultPosition, wx.DefaultSize, 0)
self.table = TestTable(data,colLabels)
self.grid.SetTable(self.table, True)
self.grid.EnableEditing( False )
self.grid.EnableGridLines( True )
self.grid.EnableDragGridSize( True )
#self.grid.SetColSize( 8, 100 )
#self.grid.AutoSizeColumns()
#self.grid.AutoSizeRows()
self.grid.SetDefaultCellAlignment( wx.ALIGN_LEFT, wx.ALIGN_TOP )
fgSizer14.Add( self.grid, 1, wx.ALL|wx.EXPAND, 5 )
bSizer1.Add( fgSizer14, 1, wx.EXPAND, 5 )
#########################
self.m_staticline17 = wx.StaticLine( self.m_panel2, wx.ID_ANY, wx.DefaultPosition, wx.DefaultSize, wx.LI_HORIZONTAL )
bSizer1.Add( self.m_staticline17, 0, wx.EXPAND |wx.ALL, 5 )
self.m_panel2.SetSizer( bSizer1 )
self.m_panel2.Layout()
bSizer1.Fit( self.m_panel2 )
bSizer6.Add( self.m_panel2, 1, wx.EXPAND |wx.ALL, 5 )
self.SetSizer( bSizer6 )
self.Layout()
self.Centre( wx.BOTH )
# Connect Events
self.Bind( wx.EVT_MENU, self.OnUpdata, id = self.m_menuItemdb.GetId() )
self.Bind( wx.EVT_MENU, self.Onbaojia, id = self.m_menuItemanal1.GetId() )
self.Bind( wx.EVT_MENU, self.Onjishi, id = self.m_menuItemanal2.GetId() )
self.Bind( wx.EVT_MENU, self.Onjishu, id = self.m_menuItemanal3.GetId() )
self.Bind( wx.EVT_MENU, self.Onbaobiao, id = self.m_menuItemanal4.GetId() )
self.Bind( wx.EVT_MENU, self.OnMktEqud, id = self.m_menuItem79.GetId() )
self.Bind( wx.EVT_MENU, self.OnAshare, id = self.m_menuItem4711.GetId() )
self.Bind( wx.EVT_MENU, self.OnSME, id = self.m_menuItem481.GetId() )
self.Bind( wx.EVT_MENU, self.OnGEM, id = self.m_menuItem491.GetId() )
self.Bind( wx.EVT_MENU, self.OnBShare, id = self.m_menuItem501.GetId() )
self.Bind( wx.EVT_MENU, self.On3Board, id = self.m_menuItem511.GetId() )
self.Bind( wx.EVT_MENU, self.OnMktFund, id = self.m_menuItem86.GetId() )
self.Bind( wx.EVT_MENU, self.OnMktBondd, id = self.m_menuItem87.GetId() )
self.Bind( wx.EVT_MENU, self.OnMktFutd, id = self.m_menuItem88.GetId() )
self.Bind( wx.EVT_MENU, self.OnMktOptd, id = self.m_menuItem89.GetId() )
self.Bind( wx.EVT_MENU, self.OnMktIndex, id = self.m_menuItem110.GetId() )
self.Bind( wx.EVT_MENU, self.OnMktIdxd, id = self.m_menuItem108.GetId() )
self.Bind( wx.EVT_MENU, self.OnTypeIndustry, id = self.m_menuItem106.GetId() )
self.Bind( wx.EVT_MENU, self.OnTyeArea, id = self.m_menuItem107.GetId() )
self.Bind( wx.EVT_MENU, self.OnTypeConcept, id = self.m_menuItem109.GetId() )
self.Bind(wx.EVT_MENU,self.OnChild1,self.child1)
self.Bind(wx.EVT_MENU,self.OnChild2,self.child2)
self.Bind( wx.EVT_MENU, self.OnChild3, id = self.m_menuItem942.GetId() )
self.Bind( wx.EVT_MENU, self.OnChild4_1, id = self.m_menuItem952.GetId() )
self.grid.Bind(wx.grid.EVT_GRID_LABEL_LEFT_CLICK,lambda evt,dataSortBigger=dataSortBigger,colLabels=colLabels:self.OnLeftClick(evt,dataSortBigger,colLabels))
self.grid.Bind(wx.grid.EVT_GRID_LABEL_RIGHT_CLICK,lambda evt,dataSortSmaller=dataSortSmaller,colLabels=colLabels:self.OnRightClick(evt,dataSortSmaller,colLabels))