def onFileRead(self, filePath):
if filePath:
try:
lines = DailyDataDAL.readAll(filePath)
dailyData = DailyDataDAL.parse(lines, TimeUtil.getToday())
DailyDataDAL.persistAll(dailyData)
newDailyData = DailyDataDAL.fetchAllByDate(TimeUtil.getToday())
self.buyerPanel.updateGrid(newDailyData.toStringList())
wx.MessageBox("导入数据成功", "导入数据", style=wx.OK | wx.ICON_EXCLAMATION)
except:
wx.MessageBox("导入数据失败，请检测数据格式", "导入数据", style=wx.OK | wx.ICON_EXCLAMATION)
def onSearchDate(self, evt):
dailyData = DailyDataDAL.fetchAllByDate(self.dateInput.GetValue())
scoreSum = 0
for (userName, scores) in dailyData.dailyScore.items():
scoreSum -= ScoreCalculation.calculateTotal(scores)
self.score.SetLabel(str(scoreSum))
def displayTodayData(self):
sizer = wx.GridBagSizer(4, 4)
today = TimeUtil.getToday()
# Load buyer data
dailyData = DailyDataDAL.fetchAllByDate(today)
# set data into data grid
self.data = UserGridData()
self.data.InsertRows(dailyData.toStringList())
self.grid = wx.grid.Grid(self, size=(500, 300))
self.grid.SetTable(self.data)
self.grid.AutoSize()
sizer.Add(self.grid, pos=(1, 1), span=(3, 3), flag=wx.EXPAND | wx.TOP, border=5)
searchText = wx.StaticText(self, label='名称')
sizer.Add(searchText, pos=(4, 1), flag=wx.EXPAND, border=5)
self.searchInput = wx.TextCtrl(self, style=wx.TE_PROCESS_ENTER)
self.Bind(wx.EVT_TEXT_ENTER, self.onSearchName, self.searchInput)
sizer.Add(self.searchInput, pos=(4, 2),
flag=wx.EXPAND | wx.LEFT | wx.RIGHT, border=5)
self.searchBtn = wx.Button(self, label='查找', size=(100, 20))
sizer.Add(self.searchBtn, pos=(4, 3))
self.searchBtn.Enable(True)
self.Bind(wx.EVT_BUTTON, self.onSearchName, self.searchBtn)
sizer.AddGrowableRow(1)
self.vBox.Add(sizer, wx.ALIGN_BOTTOM, 10)
def onSearchDate(self, evt):
dailyData = DailyDataDAL.fetchAllByDate(self.dateInput.GetValue())
self.updateGrid(dailyData.toStringList())
def onSearchName(self, evt):
dailyData = DailyDataDAL.fetchByNameDate(self.dateInput.GetValue(), self.searchInput.GetValue())
self.updateGrid(dailyData.toStringList())