# Python+SQLite## 医院住院信息管理软件

import tkinter as tk
from tkinter import ttk
from sqlite3 import connect
from tkinter import messagebox  # import this to fix messagebox error
import pickle



class PopupDialog(tk.Toplevel):
	def __init__(self, parent):
		super().__init__()
		self.title('查询信息如下')
		self.parent = parent  # 显式地保留父窗口
		self.conn = connect(parent.hos)
		self.curd = self.conn.cursor()
		row1 = tk.Frame(self)
		row1.pack(fill="x")
		tbl_name = parent.l1.get()
		a = parent.l2.get()
		if a != '*':
			a_split = a.split(",")
			self.tree = ttk.Treeview(row1, show="headings", height=18, columns=a_split)
			for i in a_split:
				self.tree.column(i, width=150)
				self.tree.heading(i, text=i)
		else:
			self.curd.execute("SELECT * FROM {}".format(tbl_name))
			col_name_list = [tuples[0] for tuples in self.curd.description]
			self.tree = ttk.Treeview(row1, show="headings", height=18, columns=col_name_list)
			for i in col_name_list:
				self.tree.column(i, width=150)
				self.tree.heading(i, text=i)

		if parent.l3.get() == "":
			b = "select " + a + " from " + tbl_name
		else:
			b = "select " + a + " from " + tbl_name + " where " + parent.l3.get()

		print(b)
		for row in self.curd.execute(b):
			self.tree.insert("", 'end', values=row)
			self.tree.pack()


class MyApp(tk.Toplevel):
	def __init__(self, parent):
		super().__init__()
		#self.parent = parent
		self.title('住院信息查询界面')
		self.geometry('640x320')
		self.row1 = tk.Frame(self)
		self.l1 = tk.Entry(self.row1, width=58)
		self.row2 = tk.Frame(self)
		self.l2 = tk.Entry(self.row2, width=58)
		self.row3 = tk.Frame(self)
		self.l3 = tk.Entry(self.row3, width=45)
		self.r3 = tk.Button(self.row3, text='查询', width=12, command=self.select_table)
		self.row4 = tk.Frame(self)
		self.l4 = tk.Entry(self.row4, width=45)
		self.r4 = tk.Button(self.row4, text='插入', width=12, command=self.insert_into)
		self.row5 = tk.Frame(self)
		self.l5 = tk.Entry(self.row5, width=58)
		self.row6 = tk.Frame(self)
		self.l6 = tk.Entry(self.row6, width=45)
		self.r6 = tk.Button(self.row6, text='修改', width=12, command=self.update_record)
		self.row7 = tk.Frame(self)
		self.l7 = tk.Entry(self.row7, width=45)
		self.r7 = tk.Button(self.row7, text='删除', width=12, command=self.delete_record)
		self.departlist = [('呼吸科', '0001'), ('血液科', '0002'), ('血管内科', '0003'), ('风湿免疫科', '0004'), ('消化科', '1001'),
		('传染科', '1007'), ('肾内科', '1158'), ('普外科', '1560'), ('神经内科', '7412'), ('心胸外科', '7745'), ('内分泌科', '3023'),
		('肛肠外科', '8895'), ('神经外科', '2012'), ('骨科', '4560'),
		('泌尿外科', '7788'), ('妇科', '6566'), ('皮肤科', '9961'), ('儿科', '2710'), ('眼科', '6