python的tk_python tk实践

import time

from tkinter import scrolledtext

from tkinter import *

import pymssql

testdbinfo={

'server': "0.0.0",

'port': '9988',

'user': "username",

'password': 'passwd'

}

class App(Frame):

def __init__(self, master=None):

self.master = master

super().__init__(master)

master.title("卡号生成工具")

self.pack()

##创建一个菜单栏，这里我们可以把他理解成一个容器，在窗口的上方

menubar = Menu(master)

master.config(menu=menubar)

##定义一个空菜单单元

filemenu = Menu(menubar, tearoff=0)

##将上面定义的空菜单命名为`File`，放在菜单栏中，就是装入那个容器中

menubar.add_cascade(label='File', menu=filemenu)

##在`File`中加入`New`的小菜单，即我们平时看到的下拉菜单，每一个小菜单对应命令操作。

##如果点击这些单元, 就会触发`do_job`的功能

filemenu.add_command(label='生成CardNO', command=self.showcardui)

filemenu.add_command(label='账户加值', command=self.showaccountui) ##同样的在`File`中加入`Open`小菜单

filemenu.add_command(label='Save', command=None) ##同样的在`File`中加入`Save`小菜单

filemenu.add_separator() ##这里就是一条分割线

##同样的在`File`中加入`Exit`小菜单,此处对应命令为`window.quit`

filemenu.add_command(label='Exit', command=quit)

container = Frame(self)

container.pack(side="top", fill="both", expand=True)

container.grid_rowconfigure(0, weight=1)

container.grid_columnconfigure(0, weight=1)

self.cardui = CardUI(container, self)

self.cardui.grid(row=0, column=0, sticky="nsew")

self.accountui = AccountUI(container, self)

self.accountui.grid(row=0, column=0, sticky="nsew")

self.showaccountui()

def showcardui(self):

self.master.maxsize(550, 350)

self.master.update()

self.cardui.tkraise()

def showaccountui(self):

self.master.maxsize(300, 100)

self.master.update()

self.accountui.tkraise()

class CardUI(Frame):

def __init__(self, parent, root):

super().__init__(parent)

banklistframe = LabelFrame(self, width=350, height=350, text="银行列表")

banklistframe.grid(row=0, column=1, sticky=E + W)

cardnolistframe = Frame(self, width=350, height=350)

cardnolistframe.grid(row=0, column=2, sticky=E + W)

xscrollbar = Scrollbar(banklistframe, orient='horizontal')

yscrollbar = Scrollbar(banklistframe)

self.listbox = Listbox(banklistframe, height=15, yscrollcommand=yscrollbar.set, xscrollcommand=xscrollbar.set)

self.listbox.bind('<>', self.generatecardno)

self.listbox.grid(row=1, column=0, columnspan=3, ipadx=15, ipady=15, sticky=E + W)

xscrollbar.config(command=self.listbox.xview)

yscrollbar.config(command=self.listbox.yview)

xscrollbar.grid(row=2, column=0, columnspan=3, sticky=E + W)

yscrollbar.grid(row=1, column=3, sticky=S + N)

self.cardnolist = scrolledtext.ScrolledText(cardnolistframe)

self.cardnolist.grid(ipadx=15, ipady=15)

self.generatebankcardno()

def generatebankcardno(self):

bankinfos = self.excute("select bankid,name from Ppdai_Pay_Trade_Basis..Bank")

for bankinfo in bankinfos:

self.listbox.insert(END, "%s(bankid:%s)" % (bankinfo['name'], bankinfo['bankid']))

def generatecardno(self, event):

bank = self.listbox.get(self.listbox.curselection())

bankid = re.search(':(\d+)', bank).group(1)

cardbinsql = 'select CardBin,CardLength from Ppdai_Pay_Trade_Basis..BankCardBin where bankid=%s' % bankid

cardbins = self.excute(cardbinsql)

cardnos = []

for cardbin in cardbins:

cardbinlen = len(cardbin['CardBin'])

cardlength = cardbin['CardLength']

millis = int(round(time.time() * 1000))

startindex = 13 - cardlength + cardbinlen

if cardlength - cardbinlen > 13:

cardno = '%s%s' % (cardbin['CardBin'], '0' * startindex + str(millis))

else:

cardno = '%s%s' % (cardbin['CardBin'], str(millis)[startindex:])

cardnos.append(cardno)

if len(cardnos) == 0:

cardnos.append("此银行暂时没有录入卡BIN")

cardnotext = "\n".join(cardnos)

self.cardnolist.delete('1.0', END)

self.cardnolist.insert(INSERT, cardnotext)

def excute(self, sql):

server = testdbinfo.get("server")

port = testdbinfo.get("port")

user = testdbinfo.get("user")

password = testdbinfo.get("password")

db = pymssql.connect(server=server, port=port, user=user, password=password)

cursor = db.cursor(as_dict=True)

cursor.execute(sql)

query_list = cursor.fetchall()

db.commit()

db.close()

return query_list

class AccountUI(Frame):

def __init__(self, parent, root):

super().__init__(parent)

self.userid = StringVar()

frame = Frame(self)

frame.grid(row=1, column=1)

inputframe = Frame(frame)

inputframe.grid(row=0, column=0, padx=10, pady=10)

Label(inputframe, text="UserID").grid(row=0, column=0, sticky="nsew")

Entry(inputframe, textvariable=self.userid).grid(row=0, column=1, sticky="nsew")

btnfram = Frame(frame)

btnfram.grid(row=1, column=0, padx=10, pady=10)

Button(btnfram, text="PPD充值").grid(row=0, column=0, sticky="nsew")

Button(btnfram, text="CMB充值").grid(row=0, column=2, sticky="nsew")

self.grid_rowconfigure(0, weight=1)

self.grid_rowconfigure(2, weight=1)

self.grid_columnconfigure(0, weight=1)

self.grid_columnconfigure(2, weight=1)

if __name__ == '__main__':

root = Tk()

app = App(root)

root.mainloop()

cx_Freeze打包exesetup.py文件

from cx_Freeze import setup, Executable

import os

base = None

build_exe_options = {

'packages': ['tkinter', 'pymssql', '_mssql', 'decimal', 'uuid'],

'excludes': [],

# 'includes': [

# r'C:\Users\xuyulong\AppData\Local\Programs\Python\Python36-32\DLLs\tcl86t.dll',

# r'C:\Users\xuyulong\AppData\Local\Programs\Python\Python36-32\DLLs\tk86t.dll'

# ]

}

os.environ['TCL_LIBRARY'] = r'C:\Users\xuyulong\AppData\Local\Programs\Python\Python36-32\tcl\tcl8.6'

os.environ['TK_LIBRARY'] = r'C:\Users\xuyulong\AppData\Local\Programs\Python\Python36-32\tcl\tk8.6'

setup(name='',

version='0.0.1.0',

description='',

options={'build_exe': build_exe_options},

executables=[Executable('test.py', base='Win32GUI', requires=['matplotlib'])])