在 Tkinter 应用中跨 Frame 传递变量的实用指南

import tkinter as tk
import tkinter.ttk as ttk
import customtkinter as ctk  # 假设使用了 customtkinter，如果没有，请替换为 tkinter

# 模拟数据库查询
def query_db(sql):
    # 实际应用中应该连接到数据库并执行查询
    # 这里为了演示，返回一些模拟数据
    if "Companies" in sql and "LIKE" in sql:
        query = sql.split("LIKE '%")[1].split("%'")[0]
        results = [
            ("Company A", "Tech", "12345", "Active"),
            ("Company B", "Finance", "67890", "Inactive"),
            ("Company C", "Tech", "54321", "Active"),
        ]
        # 根据查询词过滤结果
        filtered_results = [row for row in results if query.lower() in row[0].lower()]
        return filtered_results
    return []

class SearchFrame(ctk.CTkFrame):
    def __init__(self, parent, controller):
        ctk.CTkFrame.__init__(self, parent)
        self.controller = controller  # 保存controller的引用
        self.title = ctk.CTkLabel(self, text="Search")
        self.title.pack()

        self.searchBar = ctk.CTkEntry(self)
        self.searchBar.pack()

        self.searchBtn = ctk.CTkButton(self, text="Search", command=lambda: self.search(self.searchBar.get()))
        self.searchBtn.pack()

    def search(self, query):
        sql = f"SELECT * FROM Companies WHERE Name LIKE '%{query}%'"
        results = query_db(sql)  # 使用模拟的数据库查询函数
        self.controller.show_frame(SearchResultsFrame)
        self.controller.frames[SearchResultsFrame].populate_page(results)


class SearchResultsFrame(ctk.CTkFrame):
    def __init__(self, parent, controller):
        ctk.CTkFrame.__init__(self, parent)
        self.controller = controller
        self.title = ctk.CTkLabel(self, text='Search Results')
        self.title.pack()

        self.companies_title = ctk.CTkLabel(self, text='Companies:')
        self.companies_title.pack()

        ### Display results in a TreeView using these columns:
        self.searchResults_columns = [
            'Name',
            'Industry',
            'Postcode',
            'Status'
        ]

        ### Create the TreeView using the above columns and then format for display:
        self.searchResults_tree = ttk.Treeview(self, columns=self.searchResults_columns, show='headings')

        self.treeFormat(self.searchResults_columns, self.searchResults_tree)
        self.searchResults_tree.pack(expand=True, fill='both')

        self.home_btn = ctk.CTkButton(self, text="Home", command=lambda: controller.show_frame(DashboardFrame))
        self.home_btn.pack()

    def populate_page(self, results):
        # 清空 Treeview
        for item in self.searchResults_tree.get_children():
            self.searchResults_tree.delete(item)

        # 填充 Treeview
        for row in results:
            self.searchResults_tree.insert("", tk.END, values=row)

    def treeFormat(self, columns, tree):
        for col in columns:
            tree.heading(col, text=col)
            tree.column(col, width=100)

class DashboardFrame(ctk.CTkFrame):  # 添加DashboardFrame
    def __init__(self, parent, controller):
        ctk.CTkFrame.__init__(self, parent)
        self.controller = controller
        label = ctk.CTkLabel(self, text="Dashboard")
        label.pack(padx=10, pady=10)
        button = ctk.CTkButton(self, text="Go to Search",
                                    command=lambda: controller.show_frame(SearchFrame))
        button.pack()

class App(tk.Tk):
    def __init__(self, *args, **kwargs):
        tk.Tk.__init__(self, *args, **kwargs)
        self.geometry("800x600")  # 设置窗口大小

        container = tk.Frame(self)
        container.pack(side="top", fill="both", expand=True)
        container.grid_rowconfigure(0, weight=1)
        container.grid_columnconfigure(0, weight=1)

        self.frames = {}

        for F in (DashboardFrame, SearchFrame, SearchResultsFrame):
            frame = F(container, self)
            self.frames[F] = frame
            frame.grid(row=0, column=0, sticky="nsew")

        self.show_frame(DashboardFrame)

    def show_frame(self, cont):
        frame = self.frames[cont]
        frame.tkraise()

if __name__ == "__main__":
    app = App()
    app.mainloop()