摘要：def get_baseboard_sn(self):# 获取硬盘序列号c = wmi.WMI# 硬盘序列号sn = c.Win32_DiskDrive[0].SerialNumber.strip # 硬盘序列号return sndef create_subw
门店会员管理系统V1.0
目的：掌握控件的布局，左右，上下结构，掌握treeview控件的使用，绑定事件，掌握子窗体的调用，本想引入日历控件，但发现编译后运行起来不显示，查了说要打包的时候打包本地目录啥的，
后续有空再研究。
功能：
****1：会员管理 ****
新增、删除、修改，为会员充值，消费。
2：消费项目自定义，可以扩展为积分消费等，请自行扩展。
3：充值、消费查询
4：用户管理 考虑到可能一家门店有不同的店员需要管理，当然也可以弄权限，我没弄，有兴趣的自己去扩展
5：hashlib 实现简单的软件注册功能，绑定每台电脑的SN号
6：。。。。请自行扩展
先看一下整个系统：
默认用户名：admin,密码：123456
如果没注册的话，操作按钮将不可用。
全局功能模块来一张
1：会员管理
新增时有考虑到会员密码，做消费的时候可能需要会员输入密码验证之类的。
支持项目自定义
2：报表管理
分充值，消费，但充值和消费放在同一张表中，只是用类型区分，还有日报，月报，方便老板查看当日业绩，当月业绩
3：用户管理新增，删除，修改用户目前没实现权限控制，但够用就行4：软件注册软件本身没什么作用，做注册是为了做着玩的。破解也是很简单的。以下为代码：
import tkinter as tk
from tkinter import ttk
from tkinter import messagebox
from tkcalendar import DateEntry
import sqlite3
import hashlib
import time
import wmi
import win32com.client as win32
from PIL import Image, ImageTk
from datetime import datetime
from tkinter import simpledialog
class LoginWindow:
def init(self):
self.window = tk.Tk
self.window.title("用户登录")
# 初始化数据库
self.conn = sqlite3.connect('barbershop.db')
self.create_tables
# 设置窗口大小
window_width = 300
window_height = 180
# 获取屏幕尺寸screen_width = self.window.winfo_screenwidthscreen_height = self.window.winfo_screenheight# 计算居中坐标x = (screen_width - window_width) // 2y = (screen_height - window_height) // 2# 应用几何布局 (格式: "宽x高±X±Y")self.window.geometry(f"{window_width}x{window_height}+{x}+{y}")self.window.resizable(False, False) # 禁止调整窗口大小# self.window.attributes('-toolwindow', 1) # 适用于Windows系统 隐藏最大化按钮，但可能保留最小化按钮# self.window.overrideredirect(True) # 移除标题栏和系统按钮# 创建界面布局self.create_widgetsdef create_tables(self):"""创建数据库表结构"""cursor = self.conn.cursor# sql = """# Delete from sys_mstr# """# cursor.execute(sql)# self.conn.commit# 数据库注册表c = wmi.WMIsn = c.Win32_DiskDrive[0].SerialNumber.strip # 硬盘序列号cursor.execute('''CREATE TABLE IF NOT EXISTS sys_mstr ( sys_sn TEXT PRIMARY KEY , sys_pwd TEXT, reg_date TEXT)''')sql = """INSERT OR IGNORE INTO sys_mstr ( sys_sn, sys_pwd,reg_date) VALUES (?, ?, ?)"""params = (sn, '', datetime.now.strftime("%Y-%m-%d %H:%M:%S"))cursor.execute(sql, params)self.conn.commit# 初始化用户表 user_mstr 初始化管理员帐号admin,密码:666666cursor.execute('''CREATE TABLE IF NOT EXISTS User_mstr ( user_id TEXT PRIMARY KEY , user_name TEXT , user_password TEXT , reg_date TEXT )''')sql = """INSERT OR IGNORE INTO user_mstr ( user_id, user_name, user_password,reg_date) VALUES (?, ?, ?,?)"""password='666666'#hashed_password = hashlib.sha256(password.encode).hexdigestparams = ('admin', '管理员', password, datetime.now.strftime("%Y-%m-%d %H:%M:%S"))cursor.execute(sql, params)self.conn.commitdef create_widgets(self):#ttk.Label(self.window, text="门店会员管理系统",anchor="center" ,font = ("微软雅黑", 14, "bold"), foreground = "#333333", background = "#F5F0E0").grid(row=0, column=1,sticky="sw")# 用户名ttk.Label(self.window, text="用户名:",font = ("微软雅黑", 12)).grid(row=1, column=0, padx=10, pady=10)self.username_entry = ttk.Entry(self.window,font = ("微软雅黑", 12))self.username_entry.grid(row=1, column=1, padx=10, pady=10)self.username_entry.focus # 用户名获取焦点# 先设为默认方便调试，后续正式启用的时候要放空，让用户输self.username_entry.insert(0, 'admin')# 密码ttk.Label(self.window, text="密 码:",font = ("微软雅黑", 12)).grid(row=2, column=0, padx=10, pady=10)self.password_entry = ttk.Entry(self.window, font = ("微软雅黑", 12),show="*")self.password_entry.grid(row=2, column=1, padx=10, pady=10)# 先设为默认方便调试，后续正式启用的时候要放空，让用户输self.password_entry.insert(0, '666666')# 按钮容器 Framebutton_frame = ttk.Frame(self.window)button_frame.grid(row=3, column=1, sticky=tk.E, padx=10, pady=10)# 取消按钮cancel_btn = ttk.Button( button_frame, text="取消" ,command=self.window.destroy) # 直接关闭窗口cancel_btn.pack(side=tk.RIGHT, padx=5)# 登录按钮login_btn = ttk.Button(button_frame,text="登录",command=self.login) # 绑定点击事件“登录”时跳转loginlogin_btn.pack(side=tk.RIGHT)# 初始密码提示# ttk.Label(self.window, text="提示:管理员初始密码为‘666666’").grid(row=4, column=0, padx=10, pady=10)def login(self):userid = self.username_entry.getuserpassword = self.password_entry.get# 简单验证if not userid or not userpassword:messagebox.showerror("错误", "用户名和密码不能为空")return# 执行查询用户表中用户名和密码，验证是否合法登录try:cursor = self.conn.cursorcursor.execute("SELECT user_id ,user_password FROM user_mstr where user_id=?",(userid,))# 获取单条结果（唯一用户）result = cursor.fetchoneprint(result)if result:user_id,user_password = resultif userid == user_id and userpassword == user_password:self.window.destroy # 关闭登录窗口root = tk.Tk # 创建主窗口# self.conn.close # 打开主界面前，关闭游标接MemberSystem(root) # 打开主界面else:messagebox.showerror("提示", "用户名或密码错误")else:messagebox.showerror("提示", "用户名不存在")except sqlite3.Error as e:messagebox.showerror("错误", f"数据库查询失败: {str(e)}")finally:cursor.close # 关闭游标def run(self):self.window.mainloopclass MemberSystem:
def init(self,root):
# 初始化数据库
self.conn = sqlite3.connect('barbershop.db')
self.create_tables
# 主窗口设置
self.root = root
self.root.title("门店会员管理系统-Author: Running ver:1.0")
self.root.geometry("1100x600")
self.root.state('zoomed') # 最大化窗口
# 创建左右布局
self.create_left_menu
self.create_right_content
self.init_styles
self.systime
def systime(self):
"实时刷新显示日期时间"
current_time = time.strftime('%Y-%m-%d %H:%M:%S')
self.root.title("门店会员管理系统-Author: Running ver:1.0;当前时间:" + current_time )
self.root.after(1000, self.systime)
def get_baseboard_sn(self):# 获取硬盘序列号c = wmi.WMI# 硬盘序列号sn = c.Win32_DiskDrive[0].SerialNumber.strip # 硬盘序列号return sndef create_subwindow(self):# 创建子窗口subwindow = tk.Toplevel(self.root)# 计算居中位置self.root.update_idletasks # 强制更新窗口几何信息parent_x = self.root.winfo_xparent_y = self.root.winfo_yparent_width = self.root.winfo_widthparent_height = self.root.winfo_heightchild_width = 420 # 子窗口固定宽度child_height = 100 # 子窗口固定高度# 计算子窗口左上角坐标x = parent_x + (parent_width - child_width) // 2y = parent_y + (parent_height - child_height) // 2# 设置子窗口位置subwindow.geometry(f"+{x}+{y}")subwindow.configure(bg='#d3fbfb')subwindow.resizable(width=False, height=False)subwindow.attributes("-toolwindow", 2)return subwindowdef Open_regdit(self):"""打开弹出窗口的注册界面"""winNew = self.create_subwindowwinNew.title('软件注册->')# 放2个标签Label 和2个单行输入框entryl_user = tk.Label(winNew, text='序列号:', font=('宋体', 12), bg='#d3fbfb')l_psw = tk.Label(winNew, text='注册码:', font=('宋体', 12), bg='#d3fbfb')l_label = tk.Label(winNew, text='', font=('宋体', 18), bg='#d3fbfb')add_entry_userid = tk.StringVaradd_entry_userid = tk.Entry(winNew, textvariable=add_entry_userid, width=40, font=('宋体', 12), state=tk.NORMAL)add_entry_psw = tk.StringVaradd_entry_psw = tk.Entry(winNew, textvariable=add_entry_psw, width=40, font=('宋体', 12))add_entry_userid.insert(0, self.get_baseboard_sn)# 控件布局l_user.grid(row=0, column=1)l_psw.grid(row=1, column=1)l_label.grid(row=3,column=1)add_entry_userid.grid(row=0, column=2)add_entry_psw.grid(row=1, column=2)# 获取系统自动生成的序列号和注册码SNsys_temp = self.get_baseboard_snMDsys = hashlib.md5SNsys = 'lqw' + SNsys_tempMDsys.update(SNsys.encode(encoding='utf-8'))MDsys.hexdigestdef Regdit:# 获取用户输入的序列号和注册码和系统的进行比较SN = add_entry_userid.getMD = add_entry_psw.get# print('用户序列号'+SN+'用户注册码:'+MD)# print('系统序列号'+SNsys+'系统注册码:'+MDsys.hexdigest)if MD == '':messagebox.showinfo('提示', '请输入注册码!')returnelif SN == '':messagebox.showinfo('提示', '序列号不能为空!')returnelif SN != SNsys_temp:messagebox.showinfo('提示', '序列号错误!')returnelif MD != MDsys.hexdigest:messagebox.showinfo('提示', '序列号和注册码不匹配,注册失败!')return# 写入配置文件JSONif not MD or not SN:messagebox.showerror("提示", "请填写完整的注册信息!")returntry:cursor = self.conn.cursorsql = """UPDATE sys_mstr SET sys_pwd=?, reg_date=?WHERE sys_sn=?"""parms = (MD, datetime.now.strftime("%Y-%m-%d %H:%M:%S"), SN)cursor.execute(sql, parms)self.conn.commitmessagebox.showinfo('提示', '注册成功,感谢您的使用!')winNew.destroyexcept sqlite3.IntegrityError:messagebox.showerror("错误", "注册失败请联系作者!")def exit:winNew.destroy# 放两个按钮b_submit = tk.Button(winNew, text='注 册', command=Regdit, bg='#d3fbfb')b_cancel = tk.Button(winNew, text='退 出', command=exit, bg='#d3fbfb')# b_submit.grid(row=3, column=1,padx=25)# b_cancel.grid(row=3, column=2,padx=45)b_submit.place(relx=0.3, y=50, relheight=0.30, width=60)b_cancel.place(relx=0.6, y=50, relheight=0.30, width=60)def create_tables(self):"""创建数据库表结构"""cursor = self.conn.cursor# 服务项目表cursor.execute('''CREATE TABLE IF NOT EXISTS trans_set ( trans_id TEXT PRIMARY KEY , trans_name TEXT, trans_price REAL DEFAULT 0.0,trans_remark TEXT, date TEXT)''')# 会员信息表cursor.execute('''CREATE TABLE IF NOT EXISTS members ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, phone TEXT UNIQUE NOT NULL, password TEXT DEFAULT '', balance REAL DEFAULT 0.0 , points INTEGER DEFAULT 0, remark TEXT DEFAULT '',reg_date TEXT)''')# 交易记录表cursor.execute('''CREATE TABLE IF NOT EXISTS transactions ( id INTEGER PRIMARY KEY AUTOINCREMENT, member_id INTEGER, amount REAL, type TEXT, description TEXT, date TEXT)''')self.conn.commitdef init_styles(self):"""初始化Treeview样式"""self.style = ttk.Style# 常规行样式self.style.configure("Treeview",font=("微软雅黑", 12), # 字体设置foreground="#333333", # 文字颜色 黑background="#FFFFFF", # 背景色rowheight=25) # 行高# 标题栏样式# "coral" 珊瑚色（柔和的橙红色）,"tomato" 番茄红（比红色更温暖）,"salmon" 三文鱼粉（浅橙粉色）"orangered" ,橙红色（高饱和度）"chocolate" 巧克力色（深棕色）self.style.configure("Treeview.Heading",font=("微软雅黑", 14, "bold"), # 加粗字体foreground="darkslategray", # 文字颜色background="#F5F0E0", # 标题背景色relief="flat") # 扁平化样式# 选中项样式self.style.map("Treeview",background=[('selected', '#0078D7')], # 选中背景色foreground=[('selected', 'white')]) # 选中文字颜色# 滚动条样式self.style.configure("Vertical.TScrollbar",background="lightgray", # 滚动条颜色troughcolor="white", # 滚动条轨道颜色arrowsize=25 # 箭头大小)def create_calendar(self):global cal# 创建日期选择框cal = DateEntry(self.top_right_frame,width=12,date_pattern="yyyy-mm-dd", background="darkblue", foreground="white")#cal.grid(row=0, column=0)def create_left_menu(self):"""创建左侧菜单树"""# 左侧框架（导航栏）self.left_frame = ttk.Frame(self.root, width=200)self.left_frame.pack(side=tk.LEFT, fill=tk.Y, padx=5, pady=5)self.tree = ttk.Treeview(self.left_frame, show='tree headings',style="Treeview")# 设置列（使用默认的 #0 列）self.tree.heading("#0", text="系统菜单") # 设置列标题self.tree.column("#0", width=200, anchor="w") # 设置列宽和对齐方式self.tree.pack(expand=True, fill="both")# 定义主菜单和子菜单的映射关系menu_hierarchy = {"会员管理": ["会员查询", "会员充值","会员消费"],"报表查询": ["充值查询", "消费查询", "充消日报","充消月报"],"用户管理": ["用户查询","权限设置", "角色分配"],"参数设置": ["项目设置", "折扣规则","软件注册"],"系统日志": ["操作日志", "登录日志", "错误日志"],"退出系统": # 没有子菜单}menu_descriptions = {"会员管理": "管理会员的增删改查操作","会员查询": "根据条件查询会员信息","会员充值": "为会员账户进行充值操作","会员消费": "记录会员消费记录","报表查询": "查看各类统计报表","充值查询": "查询充值历史记录","消费查询": "查询消费历史记录","充消日报": "生成每日统计报表","充消月报": "生成月度汇总报表","参数设置": "系统参数配置","项目设置": "管理提供的服务项目","折扣规则": "配置会员折扣规则","软件注册": "支持作者创作请注册","用户管理": "管理后台用户和权限","用户查询": "根据条件查询会员信息","权限设置": "配置用户权限","角色分配": "分配用户角色","系统日志": "查看系统操作记录","操作日志": "查看用户操作日志","登录日志": "查看用户登录记录","错误日志": "查看系统错误信息","退出系统": "退出应用程序"}for main_menu, sub_menus in menu_hierarchy.items:main_menu_id = self.tree.insert("", "end", text=main_menu, values=(menu_descriptions.get(main_menu, "暂无描述"),)) #values=(main_menu),# 为该主菜单插入子菜单for sub_menu in sub_menus:self.tree.insert(main_menu_id, "end", text=sub_menu, values=(menu_descriptions.get(sub_menu, "暂无描述"),)) # values=(sub_menu),) ,# 绑定菜单点击事件self.tree.bind(">", self.on_menu_select)self.tree.bind("", self.on_menu_click)def create_right_content(self):"""创建右侧内容区域"""global info_label,title_label,btn_add,btn_delete,btn_modify,btn_recharge,btn_consume,search_entryself.right_frame = ttk.Frame(self.root)self.right_frame.pack(side="right", expand=True, fill="both")#将右侧区域分为上下两部分# 右上的子区域self.top_right_frame = tk.Frame(self.right_frame,height=5)self.top_right_frame.pack(side=tk.TOP, fill=tk.X) # 上方扩展填充#self.create_calendar# 右上区域的查找区域ttk.Label(self.top_right_frame, text="模糊查找:").grid(row=0, column=1)search_entry = ttk.Entry(self.top_right_frame, width=30)search_entry.grid(row=0, column=2, padx=5)search_entry.bind('', self.search_member)info_label = ttk.Label(self.top_right_frame, text="菜单功能:",font=("微软雅黑", 10,"bold"),foreground="blue",background="#F5F0E0") # 操作信息提示labelinfo_label.grid(row=0, column=9)# 右上区域的操作按钮# 1. 用 Pillow 加载并调整图像大小# pil_image = Image.open("image/logo2.gif") # 替换为你的图标路径# target_size = (32, 32) # 设定目标尺寸 (宽度, 高度)# resized_image = pil_image.resize(target_size, Image.LANCZOS) # 高质量缩放# # 2. 转换为 Tkinter 可用的 PhotoImage# icon = ImageTk.PhotoImage(resized_image)if self.top_right_frame.winfo_exists:btn_add = ttk.Button(self.top_right_frame, text="新增", command=self.show_add_member)btn_delete = ttk.Button(self.top_right_frame, text="删除", command=self.show_del_member)btn_modify = ttk.Button(self.top_right_frame, text="修改", command=self.show_mod_member)btn_recharge = ttk.Button(self.top_right_frame, text="充值", command=self.show_recharge)btn_consume = ttk.Button(self.top_right_frame, text="消费", command=self.show_consume)btn_rc = ttk.Button(self.top_right_frame, text="交易记录", command=self.show_transactions)# 添加横线separator = ttk.Separator(self.right_frame, orient=tk.HORIZONTAL)separator.pack(fill=tk.X, pady=1) # pady 控制横线上下间距# 右下的子区域,一开始显示主界面 show_bottom_right_frame_mainself.show_bottom_right_frame_maindef show_bottom_right_frame_main(self):# 右下的子区域,系统一进来的时候显示“欢迎界面之类”或加载图片 加载图片（仅支持 GIF、PGM/PPM）self.bottom_right_frame = tk.Frame(self.right_frame, bg="#F5F0E0", height=450)if self.bottom_right_frame.winfo_exists:self.image = tk.PhotoImage(file="image/logo.gif") # 替换为你的图片路径# 将图片添加到 Label 组件title_label = ttk.Label(self.bottom_right_frame, text="欢迎使用门店会员管理系统V1.0", anchor="center",font=("微软雅黑", 40, "bold"), foreground="#333333", background="#F5F0E0")title_label.grid(row=0, column=0, sticky="nsew")img_label = ttk.Label(self.bottom_right_frame, image=self.image)img_label.grid(row=1,column=0, sticky="nsew")self.bottom_right_frame.pack(side=tk.BOTTOM, fill=tk.BOTH, expand=True) # 下方扩展填充def resize_image(self, event):# 计算缩放后尺寸（保留20px边距）new_width = event.width - 20new_height = int(event.height * 0.7) # 图片占窗口高度的70%resized_img = self.original_image.resize((new_width, new_height),Image.Resampling.LANCZOS # 高质量缩放)self.image = ImageTk.PhotoImage(resized_img)self.img_label.configure(image=self.image)def on_double_click(self, event):"""双击行触发打开修改函数窗口show_mod_member"""self.show_mod_memberdef on_menu_click(self, event):region = self.tree.identify_region(event.x, event.y)if region == "heading":column = self.tree.identify_column(event.x)print(f"点击了左侧树的标题行")elif region == "cell":# 处理数据行点击逻辑item = self.tree.identify_row(event.y)print(f"点击了左侧树的数据行：{item}")def on_menu_select(self, event):"""菜单选择事件处理"""#print(create_yn)# 获取菜单文本和描述（values 的第一个元素）item = self.tree.selectionmenu_text = self.tree.item(item, "text")menu_desc = self.tree.item(item, "values")info_label.config(text="菜单功能:"+f"{menu_desc}") # 更新右侧 Labelself.menu_actions = {"会员管理": {"add": lambda: self.show_add_member, # 绑定会员删除函数"delete": lambda: self.show_del_member,"modify": lambda: self.show_mod_member},"用户管理": {"add": lambda: print("新增用户"),"delete": lambda: print("删除用户"),"modify": lambda: print("修改用户")},"项目设置": {"add": lambda: self.show_add_trans_item,"delete": lambda: self.show_del_trans_item,"modify": lambda: self.show_mod_trans_item}}actions = self.menu_actions.get(menu_text, {})# 动态更新按钮属性# left_text2 = menu_text[:2] 取菜单text的前2位if menu_text=="会员管理" or menu_text=="用户管理" or menu_text=="项目设置":self.update_buttons(add_text = f"新增{menu_text[:2]}",add_cmd = actions.get("add", lambda: print("无操作")),del_text = f"删除{menu_text[:2]}",del_cmd = actions.get("delete", lambda: print("无操作")),modify_text = f"修改{menu_text[:2]}",modify_cmd = actions.get("modify", lambda: print("无操作")))# 清空右下侧区域self.clear_widget # 函数 clear_widget# 连接注册表判断软件是否已经注册，不注册的话，按钮不可点击，注册后可设置按钮可点击操作cursor = self.conn.cursorSN = self.get_baseboard_sncursor.execute("SELECT sys_pwd FROM sys_mstr where sys_sn=?",(SN,))for item in cursor.fetchone:sys_pwd = itemif not sys_pwd:info_label.config(text="提示:当前软件未注册,相关操作按钮不可用!")btn_add.config(state=tk.DISABLED)btn_delete.config(state=tk.DISABLED)btn_modify.config(state=tk.DISABLED)btn_recharge.config(state=tk.DISABLED)btn_consume.config(state=tk.DISABLED)else:btn_add.config(state=tk.NORMAL)btn_delete.config(state=tk.NORMAL)btn_modify.config(state=tk.NORMAL)btn_recharge.config(state=tk.NORMAL)btn_consume.config(state=tk.NORMAL)cursor.close# 根据菜单显示不同内容print(menu_text)btn_add.grid_removebtn_delete.grid_removebtn_modify.grid_removebtn_recharge.grid_remove # 隐藏右上的"充值"按钮btn_consume.grid_remove # 隐藏右上的"消费"按钮# cal.grid_remove # 隐藏右上的日历控件if menu_text == "会员管理" or menu_text == "用户管理" or menu_text=="报表查询" or menu_text=="参数设置" or menu_text=="系统日志":self.bottom_right_frame.destroy #先销毁右下显示界面self.show_bottom_right_frame_main # 再显示主界面elif menu_text=="会员查询" or menu_text=="会员充值" or menu_text=="会员消费":btn_add.grid(row=0, column=3, padx=5) # 显示右上的"新增会员"按钮btn_delete.grid(row=0, column=4, padx=5) # 显示右上的"删除会员"按钮btn_modify.grid(row=0, column=5, padx=5) # 显示右上的"修改会员"按钮btn_recharge.grid(row=0, column=6, padx=5) # 显示右上的"充值"按钮btn_consume.grid(row=0, column=7, padx=5) # 显示右上的"消费"按钮self.show_member_management # 显示全部会员列表elif menu_text == "充消日报" or menu_text == "充消月报":btn_add.grid_remove # 隐藏右上的"新增会员"按钮btn_delete.grid_remove # 隐藏右上的"删除会员"按钮btn_modify.grid_remove # 隐藏右上的"修改会员"按钮btn_recharge.grid_remove # 隐藏右上的"充值"按钮btn_consume.grid_remove # 隐藏右上的"消费"按钮self.create_calendar # 显示日历控件cal.grid(row=0, column=0)elif menu_text=="用户查询" or menu_text=="权限设置" or menu_text=="角色分配":btn_add.grid(row=0, column=3, padx=5) # 显示右上的"新增会员"按钮btn_delete.grid(row=0, column=4, padx=5) # 显示右上的"删除会员"按钮btn_modify.grid(row=0, column=5, padx=5) # 显示右上的"修改会员"按钮btn_recharge.grid_remove # 隐藏右上的"充值"按钮btn_consume.grid_remove # 隐藏右上的"消费"按钮self.show_user_management # 显示全部用户列表elif menu_text == "项目设置":btn_add.grid(row=0, column=3, padx=5) # 显示右上的"新增项目"按钮btn_delete.grid(row=0, column=4, padx=5) # 显示右上的"删除项目"按钮btn_modify.grid(row=0, column=5, padx=5) # 显示右上的"修改项目"按钮btn_recharge.grid_remove # 隐藏右上的"充值"按钮btn_consume.grid_remove # 隐藏右上的"消费"按钮self.show_trans_items # 显示服务项目列表elif menu_text =="充值查询" or menu_text =="消费查询":self.show_trans_listelif menu_text =="软件注册":self.Open_regditelif menu_text == "退出系统":self.root.destroyelse:btn_recharge.grid_removebtn_consume.grid_removemessagebox.showinfo("提示", f"此菜单功能正在开发中")def clear_widget(self):for widget in self.bottom_right_frame.winfo_children:widget.destroydef update_buttons(self, add_text, add_cmd, del_text, del_cmd, modify_text, modify_cmd):"""安全更新按钮属性和命令"""# 检查控件是否存在if btn_add.winfo_exists and btn_add is not None:btn_add.config(text=add_text, command=add_cmd)if btn_delete.winfo_exists and btn_delete is not None:btn_delete.config(text=del_text, command=del_cmd)if btn_modify.winfo_exists and btn_modify is not None:btn_modify.config(text=modify_text, command=modify_cmd会员管理相关def show_member_management(self):"""加载会员列表"""global columns,treecolumns = ('会员ID','姓名','电话','余额','密码','备注','注册日期')tree = ttk.Treeview(self.bottom_right_frame, columns=columns, show="headings")# 绑定双击事件# self.tree.bind("", self.on_double_click)# 设置列标题和宽度for col in columns:tree.heading(col, text=col)tree.column(col, width=50,anchor="center") # 列居中对齐# 删除行数据for row in tree.get_children:tree.delete(row)# 连接表查询出数据cursor = self.conn.cursorcursor.execute("SELECT id, name, phone, balance , password ,remark , reg_date FROM members")# 添加数据for member in cursor.fetchall:id, name, phone, balance, password, remark, reg_date = membertree.insert('',tk.END,values=(id,name,phone,balance,'******',remark,reg_date),tags='')#tree.insert('', tk.END, values=member)tree.pack(side=tk.LEFT,expand=True, fill=tk.BOTH)#添加滚动条scrollbar = ttk.Scrollbar(self.bottom_right_frame, orient=tk.VERTICAL, command=tree.yview,style="Vertical.TScrollbar")tree.configure(yscrollcommand=scrollbar.set)scrollbar.pack(side=tk.RIGHT, fill=tk.Y)# 绑定双击事件tree.bind("", self.on_double_click)def show_add_member(self):"""显示添加会员窗口"""self.add_window = tk.Toplevel(self.root)self.add_window.title("添加新会员")self.add_window.resizable(False, False) # 禁止调整窗口大小ttk.Label(self.add_window, text="姓名:").grid(row=0, column=0, padx=5,pady=5)self.name_entry = ttk.Entry(self.add_window,width=20)self.name_entry.grid(row=0, column=1)ttk.Label(self.add_window, text="电话:").grid(row=1, column=0, padx=5,pady=5)self.phone_entry = ttk.Entry(self.add_window,width=20)self.phone_entry.grid(row=1, column=1)ttk.Label(self.add_window, text="密码:").grid(row=2, column=0, padx=5,pady=5)self.password_entry = ttk.Entry(self.add_window,width=20)self.password_entry.grid(row=2, column=1)ttk.Button(self.add_window, text="保存", command=self.save_member).grid(row=3, column=0,columnspan=2, pady=10)# 计算居中位置self.root.update_idletasks # 强制更新窗口几何信息parent_x = self.root.winfo_xparent_y = self.root.winfo_yparent_width = self.root.winfo_widthparent_height = self.root.winfo_heightchild_width = 200 # 子窗口固定宽度child_height = 150 # 子窗口固定高度# 计算子窗口左上角坐标x = parent_x + (parent_width - child_width) // 2y = parent_y + (parent_height - child_height) // 2# 设置子窗口位置self.add_window.geometry(f"+{x}+{y}")def save_member(self):"""处理保存新会员信息"""name = self.name_entry.getphone = self.phone_entry.getpassword = self.password_entry.getif not name or not phone:messagebox.showerror("错误","请填写完整信息")returntry:cursor = self.conn.cursorsql = """INSERT INTO members (name, phone, password,reg_date) VALUES (?, ?, ?,?)"""params = ( name,phone,password,datetime.now.strftime("%Y-%m-%d %H:%M:%S") )cursor.execute(sql,params)self.conn.commitself.add_window.destroymessagebox.showinfo("成功","会员添加成功")self.load_members # 添加成功后刷新会员列表except sqlite3.IntegrityError:messagebox.showerror("错误","该电话号码已存在")def show_del_member(self):"""显示删除会员窗口"""#messagebox.showinfo("提示", "该功能尚未提供")selected = tree.focusif not selected:messagebox.showerror("错误", "请先选择会员")returnamount = tree.item(selected)['values'][3] # 余额if float(amount) > 0.0:messagebox.showerror("错误", "会员还有可用余额不可删除")returntry:member_id = tree.item(selected)['values'][0]cursor = self.conn.cursorsql='''Delete FROM members WHERE id = ? '''cursor.execute(sql,(member_id,))self.conn.commitself.load_membersmessagebox.showinfo("成功","会员删除成功")except sqlite3.IntegrityError:messagebox.showerror("错误","会员删除失败")returndef show_mod_member(self):"""显示修改会员窗口"""selected = tree.focusif not selected:messagebox.showerror("错误", "请先选择会员")returnname = tree.item(selected)['values'][1] #姓名phone = tree.item(selected)['values'][2] # 电话acount = tree.item(selected)['values'][3] # 余额能改？业务尚不明确password = tree.item(selected)['values'][4] # 密码self.mod_window = tk.Toplevel(self.root)self.mod_window.title("修改会员信息")self.mod_window.resizable(False, False) # 禁止调整窗口大小ttk.Label(self.mod_window, text="姓名:").grid(row=0, column=0, padx=5, pady=5)self.name_entry = ttk.Entry(self.mod_window, textvariable=name, width=20)self.name_entry.grid(row=0, column=1)ttk.Label(self.mod_window, text="电话:").grid(row=1, column=0, padx=5, pady=5)self.phone_entry = ttk.Entry(self.mod_window, textvariable=phone, width=20)self.phone_entry.grid(row=1, column=1)ttk.Label(self.mod_window, text="密码:").grid(row=2, column=0, padx=5, pady=5)self.password_entry = ttk.Entry(self.mod_window, textvariable=password, width=20)self.password_entry.grid(row=2, column=1)# 姓名，电话，密码赋值self.name_entry.insert(0,name)self.phone_entry.insert(0,phone)self.password_entry.insert(0,password)ttk.Button(self.mod_window, text="保存", command=self.update_member).grid(row=3, column=0, columnspan=2, pady=10)# 计算居中位置self.root.update_idletasks # 强制更新窗口几何信息parent_x = self.root.winfo_xparent_y = self.root.winfo_yparent_width = self.root.winfo_widthparent_height = self.root.winfo_heightchild_width = 200 # 子窗口固定宽度child_height = 150 # 子窗口固定高度# 计算子窗口左上角坐标x = parent_x + (parent_width - child_width) // 2y = parent_y + (parent_height - child_height) // 2# 设置子窗口位置self.mod_window.geometry(f"+{x}+{y}")def update_member(self):"""处理修改的会员信息"""selected = tree.focusid = tree.item(selected)['values'][0] # 会员IDname = self.name_entry.getphone = self.phone_entry.getpassword = self.password_entry.getif not name or not phone:messagebox.showerror("错误","请填写完整信息")returntry:cursor = self.conn.cursorsql = """UPDATE members SET name=?, phone=?, password=?, reg_date=?WHERE id=?"""parms = ( name, phone,password,datetime.now.strftime("%Y-%m-%d %H:%M:%S"),id )cursor.execute(sql,parms)self.conn.commitself.mod_window.destroyself.load_members # 修改成功后刷新会员列表messagebox.showinfo("成功","会员修改成功")except sqlite3.IntegrityError:messagebox.showerror("错误","该电话号码已存在")def load_members(self):"""加载会员列表"""for row in tree.get_children:tree.delete(row)cursor = self.conn.cursorcursor.execute("SELECT id, name, phone, balance,'******',remark,reg_date FROM members")for member in cursor.fetchall:tree.insert('', tk.END, values=member)def reload_members(self):"""刷新会员列表"""for item in self.trans_tree.get_children:self.trans_tree.delete(item)for member in self.members:self.trans_tree.insert("", "end", values=(member["id"],member["name"],member["balance"]))def search_member(self, event=None):"""搜索会员 模糊查找，根据ID，姓名，电话"""query = search_entry.getcursor = self.conn.cursorcursor.execute("SELECT id, name, phone, balance FROM members WHERE name LIKE ? OR phone LIKE ?",(f'%{query}%',f'%{query}%'))tree.delete(*tree.get_children)for item in cursor.fetchall:tree.insert('', tk.END,values=item)def search_trans(self, event=None):"""搜索会员 模糊查找，根据ID，姓名，电话"""query = search_entry.getcursor = self.conn.cursorcursor.execute("SELECT member_id, name, phone,amount, type, description, date ""FROM transactions,members where transactions.member_id = members.id ""and name like ? or phone like ? or description like ?",(f'%{query}%', f'%{query}%',f'%{query}%'))tree.delete(*tree.get_children)for item in cursor.fetchall:tree.insert('', tk.END,values=item)def cancel_member(self):self.add_window.destroy# 服务项目设置相关=================def show_trans_items(self):"""加载服务项目列表"""global columns,treecolumns = ('项目ID','项目名称','项目价格','备注')tree = ttk.Treeview(self.bottom_right_frame, columns=columns, show="headings")# 设置列标题和宽度for col in columns:tree.heading(col, text=col)tree.column(col, width=50,anchor="center") # 列居中对齐# 删除行数据for row in tree.get_children:tree.delete(row)# 连接表查询出数据cursor = self.conn.cursorcursor.execute("SELECT trans_id, trans_name, trans_price,trans_remark FROM trans_set")# 添加数据for trans_item in cursor.fetchall:trans_id, trans_name, trans_price, trans_remark = trans_itemtree.insert('',tk.END,values=trans_item,tags='')tree.pack(side=tk.LEFT,expand=True, fill=tk.BOTH)#添加滚动条scrollbar = ttk.Scrollbar(self.bottom_right_frame, orient=tk.VERTICAL, command=tree.yview,style="Vertical.TScrollbar")tree.configure(yscrollcommand=scrollbar.set)scrollbar.pack(side=tk.RIGHT, fill=tk.Y)def show_add_trans_item(self):"""显示添加服务项目窗口"""self.add_window = tk.Toplevel(self.root)self.add_window.title("添加新项目")self.add_window.resizable(False, False) # 禁止调整窗口大小ttk.Label(self.add_window, text="项目ID:").grid(row=0, column=0, padx=5,pady=5)self.id_entry = ttk.Entry(self.add_window,width=20)self.id_entry.grid(row=0, column=1)ttk.Label(self.add_window, text="项目名称:").grid(row=1, column=0, padx=5,pady=5)self.name_entry = ttk.Entry(self.add_window,width=20)self.name_entry.grid(row=1, column=1)ttk.Label(self.add_window, text="项目价格:").grid(row=2, column=0, padx=5,pady=5)self.price_entry = ttk.Entry(self.add_window,width=20)self.price_entry.grid(row=2, column=1)ttk.Label(self.add_window, text="项目备注:").grid(row=3, column=0, padx=5,pady=5)self.remark_entry = ttk.Entry(self.add_window,width=20)self.remark_entry.grid(row=3, column=1)ttk.Button(self.add_window, text="保存", command=self.save_trans_item).grid(row=4,column=0,columnspan=2, pady=10)# 计算居中位置self.root.update_idletasks # 强制更新窗口几何信息parent_x = self.root.winfo_xparent_y = self.root.winfo_yparent_width = self.root.winfo_widthparent_height = self.root.winfo_heightchild_width = 200 # 子窗口固定宽度child_height = 200 # 子窗口固定高度# 计算子窗口左上角坐标x = parent_x + (parent_width - child_width) // 2y = parent_y + (parent_height - child_height) // 2# 设置子窗口位置self.add_window.geometry(f"+{x}+{y}")def save_trans_item(self):"""处理保存新项目信息"""trans_id = self.id_entry.gettrans_name = self.name_entry.gettrans_price = self.price_entry.gettrans_remark = self.remark_entry.getif not trans_id or not trans_name or not trans_price :messagebox.showerror("错误","请填写项目ID/项目名称/项目价格")returntry:cursor = self.conn.cursorsql = """INSERT INTO trans_set (trans_id, trans_name, trans_price,trans_remark) VALUES (?, ?, ?,?)"""params = ( trans_id,trans_name,trans_price,trans_remark )cursor.execute(sql,params)self.conn.commitself.add_window.destroymessagebox.showinfo("成功","项目添加成功")self.load_trans_items # 添加成功后刷新项目列表except sqlite3.IntegrityError:messagebox.showerror("错误","项目添加失败,请检查是否项目ID重复")def load_trans_items(self):"""加载项目列表"""for row in tree.get_children:tree.delete(row)cursor = self.conn.cursorcursor.execute("SELECT trans_id, trans_name, trans_price, trans_remark FROM trans_set")for trans_item in cursor.fetchall:tree.insert('', tk.END, values=trans_item)# 会员充值相关=================def show_recharge(self):"""显示充值窗口"""# 获取菜单文本和描述（values 的第一个元素）item = self.tree.selectionmenu_text = self.tree.item(item, "text")if menu_text != "会员充值":messagebox.showinfo("提示", "请先在左边菜单选择:会员管理->会员充值 才能操作")returnselected = tree.focusif not selected:messagebox.showerror("错误","请先选择会员")returnself.recharge_window = tk.Toplevel(self.root)self.recharge_window.title("会员充值")ttk.Label(self.recharge_window, text="充值金额:").grid(row=0, column=0, padx=5,pady=5)self.amount_entry = ttk.Entry(self.recharge_window)self.amount_entry.grid(row=0, column=1)ttk.Button(self.recharge_window, text="确认充值", command=self.process_recharge).grid(row=1, columnspan=2,pady=10)# 计算居中位置self.root.update_idletasks # 强制更新窗口几何信息parent_x = self.root.winfo_xparent_y = self.root.winfo_yparent_width = self.root.winfo_widthparent_height = self.root.winfo_heightchild_width = 200 # 子窗口固定宽度child_height = 200 # 子窗口固定高度# 计算子窗口左上角坐标x = parent_x + (parent_width - child_width) // 2y = parent_y + (parent_height - child_height) // 2# 设置子窗口位置self.recharge_window.geometry(f"+{x}+{y}")def process_recharge(self):"""处理充值操作"""try:amount =float(self.amount_entry.get)if amount 会员消费 才能操作")returnselected = tree.focusif not selected:messagebox.showerror("错误","请先选择会员")returnself.consume_window = tk.Toplevel(self.root)self.consume_window.title("会员消费")# 消费项目选择ttk.Label(self.consume_window, text="消费项目:").grid(row=0, column=0, padx=5, pady=5)#services = ["剪发","烫发","染发","护理","肩颈","美容","其他"]services =# 连接表查询出数据cursor = self.conn.cursorservices = # 存储 Combobox 展示的名称price_dict = {} # 名称到价格的映射# 添加数据try:cursor.execute("SELECT trans_name, trans_price FROM trans_set")rows = cursor.fetchall# 构建名称列表和价格字典for row in rows:service_name = rowservice_price = rowservices.append(service_name)price_dict[service_name] = service_price # 名称作为键，价格作为值finally:cursor.closeself.service_var = tk.StringVarself.service_menu = ttk.Combobox(self.consume_window, textvariable=self.service_var, values=services)self.service_menu.grid(row=0, column=1)# 绑定选择事件#self.service_menu.bind(">", self._update_price)ttk.Label(self.consume_window, text="消费金额:").grid(row=1, column=0, padx=5,pady=5)self.consume_amount = ttk.Entry(self.consume_window)self.consume_amount.grid(row=1, column=1)ttk.Button(self.consume_window, text="确认消费", command=self.process_consume).grid(row=2, columnspan=2, pady=10)# 计算居中位置self.root.update_idletasks # 强制更新窗口几何信息parent_x = self.root.winfo_xparent_y = self.root.winfo_yparent_width = self.root.winfo_widthparent_height = self.root.winfo_heightchild_width = 200 # 子窗口固定宽度child_height = 200 # 子窗口固定高度# 计算子窗口左上角坐标x = parent_x + (parent_width - child_width) // 2y = parent_y + (parent_height - child_height) // 2# 设置子窗口位置self.consume_window.geometry(f"+{x}+{y}")def _update_price(self, event):"价格更新函数"price_dict={}selected_service = self.service_var.get # 获取选中的服务名称price_dict = selected_serviceprint(price_dict)price = price_dict.get(selected_service, "")# 清空并更新消费金额输入框self.consume_amount.delete(0, tk.END)self.consume_amount.insert(0, price)def process_consume(self):"""处理消费操作"""try:amount = float(self.consume_amount.get)if amount ', self.search_trans)columns = ('用户ID','姓名','电话','金额','类型','描述','注册日期')tree = ttk.Treeview(self.bottom_right_frame, columns=columns, show="headings")# 设置列标题和宽度for col in columns:tree.heading(col, text=col)tree.column(col, width=50,anchor="center") # 列居中对齐# 删除行数据for row in tree.get_children:tree.delete(row)# 连接表查询出数据cursor = self.conn.cursorcursor.execute("SELECT distinct member_id, name, phone,amount, type, description, date ""FROM members , transactions where transactions.member_id = members.id ")# 添加数据for trans in cursor.fetchall:member_id, name, phone,amount, type, description,date = transtree.insert('',tk.END,values=(member_id, name, phone,amount, type, description,date))tree.pack(side=tk.LEFT,expand=True, fill="both")#添加滚动条scrollbar = ttk.Scrollbar(self.bottom_right_frame, orient=tk.VERTICAL, command=tree.yview,style="Vertical.TScrollbar")tree.configure(yscrollcommand=scrollbar.set)scrollbar.pack(side=tk.RIGHT, fill=tk.Y)# 用户管理相关=================def show_user_management(self):"""加载用户列表"""columns = ('用户ID','姓名','密码','注册日期')tree = ttk.Treeview(self.bottom_right_frame, columns=columns, show="headings")# 设置列标题和宽度for col in columns:tree.heading(col, text=col)tree.column(col, width=50,anchor="center") # 列居中对齐# 删除行数据for row in tree.get_children:tree.delete(row)# 连接表查询出数据cursor = self.conn.cursorcursor.execute("SELECT user_id, user_name, '******' ,reg_date FROM user_mstr")# 添加数据for users in cursor.fetchall:user_id, user_name, user_password, reg_date = userstree.insert('',tk.END,values=(user_id,user_name,user_password,reg_date))#tree.insert('', tk.END, values=member)tree.pack(side=tk.LEFT,expand=True, fill="both")#添加滚动条scrollbar = ttk.Scrollbar(self.bottom_right_frame, orient=tk.VERTICAL, command=tree.yview,style="Vertical.TScrollbar")tree.configure(yscrollcommand=scrollbar.set)scrollbar.pack(side=tk.RIGHT, fill=tk.Y) 来源：珊瑚的VLOG
免责声明：本站系转载，并不代表本网赞同其观点和对其真实性负责。如涉及作品内容、版权和其它问题，请在30日内与本站联系，我们将在第一时间删除内容!
