-
Notifications
You must be signed in to change notification settings - Fork 71
/
Copy pathdbc2excel_main.py
151 lines (129 loc) · 6.54 KB
/
dbc2excel_main.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
#!/usr/bin/env python
import wx
import dbc2excel as d2e
class MyFrame(wx.Frame):
""" We simply derive a new class of Frame. """
def __init__(self, parent, title):
wx.Frame.__init__(self, parent, title=title, size=(600, 500))
self.path = ''
#self.SetSizeHints(wx.DefaultSize, wx.DefaultSize)
#self.control = wx.TextCtrl(self, style=wx.TE_MULTILINE)
##excel生成条件变量
self.if_sig_desc = True
self.if_sig_val_desc = True
self.val_description_max_number = 70
self.if_start_val = True
self.if_recv_send = True
self.if_asc_sort = True
#静态文字
self.quote = wx.StaticText(self, label="\n", pos=(420, 260))
#控制台窗口
self.logger = wx.TextCtrl(self, pos=(5, 300), size=(580, 130), style=wx.TE_MULTILINE | wx.TE_READONLY)
# A button
self.button =wx.Button(self, label="生成Excel文件", pos=(10, 150),size=(200,100))
self.Bind(wx.EVT_BUTTON, self.create_excel,self.button)
# B button
b = wx.Button(self,-1,u"选择dbc文件",pos=(10, 20),size=(200,100))
self.Bind(wx.EVT_BUTTON, self.select_file_button, b)
# c button 增加图片
#pic = wx.Image("./source/a.bmp", wx.BITMAP_TYPE_BMP).ConvertToBitmap()
#c = wx.BitmapButton(self,-1,pic,pos=(250, 20),size=(290,150))
#self.Bind(wx.EVT_BUTTON, self.select_file_button, b)
#增加复选框
#panel = wx.Panel(self) # 创建画板，控件容器
#信号描述
HEIGHT = 25
OFFSET = 20
k = 1
self.check1 = wx.CheckBox(self, -1, '生成信号描述', pos=(250, HEIGHT), size=(100, -1))
self.Bind(wx.EVT_CHECKBOX, self.SigDescEvtCheckBox, self.check1)
self.check1.Set3StateValue(True)
self.check2 = wx.CheckBox(self, -1, '生成信号值描述', pos=(250, HEIGHT + k * OFFSET), size=(100, -1))
self.Bind(wx.EVT_CHECKBOX, self.SigValDescEvtCheckBox, self.check2)
self.check2.Set3StateValue(True)
k += 1
#最大信号值描述长度
self.check3 = wx.CheckBox(self, -1, '生成初始值', pos=(250, HEIGHT + k * OFFSET), size=(100, -1))
self.Bind(wx.EVT_CHECKBOX, self.StartValEvtCheckBox, self.check3)
self.check3.Set3StateValue(True)
k += 1
self.check4 = wx.CheckBox(self, -1, '生成发送方和接收方', pos=(250, HEIGHT + k * OFFSET), size=(150, -1))
self.Bind(wx.EVT_CHECKBOX, self.RecvSndEvtCheckBox, self.check4)
self.check4.Set3StateValue(True)
k += 1
self.check5 = wx.CheckBox(self, -1, '升序排序(取消勾选降序)', pos=(250, HEIGHT + k * OFFSET), size=(150, -1))
self.Bind(wx.EVT_CHECKBOX, self.SortEvtCheckBox, self.check5)
self.check5.Set3StateValue(True)
k += 1
self.quote = wx.StaticText(self, label="信号值描述最大文本长度\n", pos=(250, HEIGHT + k * OFFSET), size = (140, 20))
self.text1 = wx.TextCtrl(self, wx.ID_ANY, "70",pos=(400, HEIGHT + k * OFFSET), size=(100, 20), style=wx.TE_LEFT)
#print(self.text1.Value)
k += 1
# Setting up the menu.
filemenu = wx.Menu()
# wx.ID_ABOUT and wx.ID_EXIT are standard IDs provided by wxWidgets.
# wx.ID_ABOUT and wx.ID_EXIT are standard ids provided by wxWidgets.
menuAbout = filemenu.Append(wx.ID_ABOUT, "&关于"," Information about this program")
menuExit = filemenu.Append(wx.ID_EXIT,"E&xit"," Terminate the program")
# Creating the menubar.
menuBar = wx.MenuBar()
menuBar.Append(filemenu,"&文件") # Adding the "filemenu" to the MenuBar
self.SetMenuBar(menuBar) # Adding the MenuBar to the Frame content.
# Set events.
self.Bind(wx.EVT_MENU, self.OnAbout, menuAbout)
self.Bind(wx.EVT_MENU, self.OnExit, menuExit)
self.logger.AppendText("Dbc转Excel工具仍在不断完善中\n***如果转换时间过长或无法转换，尝试取消勾选上方的选项再进行生成***\n有任何问题请在下面网址留言\nhttps://blog.csdn.net/hhlenergystory/article/details/80443454\n")
self.Show(True)
#响应事件
def SigDescEvtCheckBox(self,event):
self.if_sig_desc = not self.if_sig_desc
#print(self.if_sig_desc)
def SigValDescEvtCheckBox(self,event):
self.if_sig_val_desc = not self.if_sig_val_desc
#print(self.if_sig_val_desc)
def StartValEvtCheckBox(self,event):
self.if_start_val = not self.if_start_val
#print(self.if_start_val)
def RecvSndEvtCheckBox(self,event):
self.if_recv_send = not self.if_recv_send
#print(self.if_recv_send)
def SortEvtCheckBox(self,event):
self.if_asc_sort = not self.if_asc_sort
def OnAbout(self, e):
# A message dialog box with an OK button. wx.OK is a standard ID in wxWidgets.
dlg = wx.MessageDialog(self, "DBC转Excel工具\nBY黄洪磊 i2347\nV0.4\n有任何问题请发送dbc文件至int.honglei.huang@uaes.com", "关于", wx.OK)
dlg.ShowModal() # Show it
dlg.Destroy() # finally destroy it when finished.
def OnExit(self, e):
self.Close(True) # Close the frame.
def create_excel(self, event):
self.logger.AppendText(" \n载入DBC文件完成\n" )
dbc = d2e.DbcLoad(self.path)
self.logger.AppendText(" 生成文件中！稍等... \n")
if(str(self.text1.Value).isdigit()):
self.val_description_max_number = int(self.text1.Value)
#print(self.val_description_max_number)
dbc.dbc2excel(self.path,self.if_sig_desc,self.if_sig_val_desc,self.val_description_max_number,self.if_start_val,self.if_recv_send,self.if_asc_sort)
self.logger.AppendText(" 文件转换完成\n")
def select_file_button(self, event):
filesFilter = "Dicom (*.dbc)|*.dbc|" "All files (*.*)|*.*"
fileDialog = wx.FileDialog(self, message="选择单个文件", wildcard=filesFilter, style=wx.FD_OPEN)
dialogResult = fileDialog.ShowModal()
if dialogResult != wx.ID_OK:
return
self.path = fileDialog.GetPath()
self.logger.SetLabel('>>>选择文件：'+self.path)
def OnEraseBack(self,event):
dc = event.GetDC()
if not dc:
dc = wx.ClientDC(self)
rect = self.GetUpdateRegion().GetBox()
dc.SetClippingRect(rect)
dc.Clear()
bmp = wx.Bitmap("a.jpg")
dc.DrawBitmap(bmp, 0, 0)
#################
if __name__ == "__main__":
app = wx.App(False)
frame = MyFrame(None, 'DBC转Excel工具')
app.MainLoop()