def insert_room(self):
session = DBSession()
oids = [
office['id'] for office in self.offices
if office['name'] == self.office_name_var.get()
]
try:
room = Room(room_number=self.room_number_var.get(),
bed_number=int(self.room_bed_number_var.get()),
oid=oids[0])
session.add(room)
session.commit()
messagebox.showinfo('成功', '新建病房成功!')
except Exception as _:
messagebox.showerror('失败', '新建病房失败，病房可能已存在或科室选择错误')
session.close()
self.refresh_table()
def search_for_office(self):
office_name = self.office_variable.get()
session = DBSession()
office: Optional[Office] = session.query(Office).filter(
Office.office_name == office_name).first()
if office:
office_dict = {
'id': office.id,
'office_name': office.office_name,
'office_address': office.office_address,
'office_telephone': office.office_telephone
}
messagebox.showinfo(
'医生',
'\n'.join(map(lambda i: f'{i[0]}: {i[1]}',
office_dict.items())))
else:
messagebox.showerror('错误', '找不到科室!')
session.close()
def refresh_table(self):
for item in self.tb.get_children():
self.tb.delete(item)
session = DBSession()
offices: List[Office] = session.query(Office).filter().all()
self.offices = [{
'id': office.id,
'office_name': office.office_name,
'office_address': office.office_address,
'office_telephone': office.office_telephone
} for office in offices]
session.close()
for office in self.offices:
self.tb.insert("", 0, values=[
office['id'],
office['office_name'],
office['office_address'],
office['office_telephone'],
])
def register(self):
username = self.username_var.get()
password = self.password_var.get()
m = hashlib.md5()
m.update(password.encode())
pass_hash = m.hexdigest()
session = DBSession()
login_dao = Login_dao(
username=username,
password=pass_hash
)
try:
session.add(login_dao)
session.commit()
except:
messagebox.showerror("错误", "用户名已存在或不可为空!")
else:
messagebox.showinfo("成功", f"用户{username}已注册成功!")
finally:
session.close()
def insert_doctor(self):
session = DBSession()
oids = [
office['id'] for office in self.offices
if office['name'] == self.office_name_var.get()
]
gender = self.gender_var.get()
try:
room = Doctor(work_number=self.work_number_var.get(),
name=self.name_var.get(),
gender=gender,
age=self.age_var.get(),
title=self.title_var.get(),
oid=oids[0])
session.add(room)
session.commit()
messagebox.showinfo('成功', '新建医生成功!')
except Exception as _:
messagebox.showerror('失败', '新建医生失败，医生可能已存在')
session.close()
self.refresh_table()
def change(self):
session = DBSession()
oids = [
office['id'] for office in self.offices
if office['name'] == self.office_name_var.get()
]
num = self.room_number_var.get()
room: Optional[Room] = session.query(Room).filter_by(
room_number=num).first()
try:
if room:
room.bed_number = int(self.room_bed_number_var.get())
room.oid = oids[0]
session.commit()
messagebox.showinfo('成功', '病房信息修改成功!')
else:
messagebox.showerror('错误', '找不到病房！')
except Exception as _:
messagebox.showinfo('失败', '病房信息修改失败')
session.close()
self.refresh_table()
def search_for_doctor(self):
doctor_work_num = self.doctor_variable.get()
session = DBSession()
doctor: Optional[Tuple] = session.query(
Doctor, Office.office_name).join(Office).filter(
Doctor.work_number == doctor_work_num).first()
if doctor:
doctor_dict = {
'id': doctor[0].id,
'work_number': doctor[0].work_number,
'name': doctor[0].name,
'gender': '男' if doctor[0].gender else '女',
'age': doctor[0].age,
'title': doctor[0].title,
'office_name': doctor[1]
}
messagebox.showinfo(
'医生',
'\n'.join(map(lambda i: f'{i[0]}: {i[1]}',
doctor_dict.items())))
else:
messagebox.showerror('错误', '找不到医生!')
session.close()
def refresh_table(self):
for item in self.tb.get_children():
self.tb.delete(item)
session = DBSession()
rooms: List[Tuple] = session.query(
Room, Office.office_name).join(Office).filter().all()
self.rooms = [{
'id': room[0].id,
'room_number': room[0].room_number,
'bed_number': room[0].bed_number,
'office_name': room[1]
} for room in rooms]
session.commit()
session.close()
print(self.rooms)
for room in self.rooms:
self.tb.insert("",
0,
values=[
room['id'],
room['room_number'],
room['bed_number'],
room['office_name'],
])
def change(self):
session = DBSession()
oids = [
office['id'] for office in self.offices
if office['name'] == self.office_name_var.get()
]
gender = self.gender_var.get()
doctor: Doctor = session.query(Doctor).filter_by(
work_number=self.work_number_var.get()).first()
try:
if doctor:
doctor.name = self.name_var.get()
doctor.gender = gender
doctor.age = self.age_var.get()
doctor.title = self.title_var.get()
doctor.oid = oids[0]
session.commit()
messagebox.showinfo('成功', '修改医生信息成功!')
else:
messagebox.showerror('错误', '找不到医生')
except Exception as _:
messagebox.showinfo('失败', '新建医生失败')
session.close()
self.refresh_table()
def __init__(self, root: Tk):
self.patients = []
# 数据库查询所有科室
session = DBSession()
offices: List[Office] = session.query(Office).filter().all()
doctors: List[Doctor] = session.query(Doctor).filter().all()
rooms: List[Room] = session.query(Room).filter().all()
self.offices = [{
'id': office.id,
'name': office.office_name
} for office in offices]
# 查询所有医生
self.doctors = [{
'id': doctor.id,
'name': doctor.name
} for doctor in doctors]
# 查询所有病房
self.rooms = [{
'id': room.id,
'room_number': room.room_number
} for room in rooms]
session.close()
self.root = root
self.page = Frame(self.root)
self.page.pack()
self.root.title('病人管理')
self.root.geometry('500x480')
# 姓名Frame
name_frame = Frame(self.page)
name_frame.pack(side=TOP)
name_label = Label(name_frame, text='姓名')
name_label.pack(side=LEFT)
self.name_var = StringVar()
name_entry = Entry(name_frame, textvariable=self.name_var)
name_entry.pack(side=LEFT)
# 病历号Frame
history_number_frame = Frame(self.page)
history_number_frame.pack(side=TOP)
history_number_label = Label(history_number_frame, text='病历号')
history_number_label.pack(side=LEFT)
self.history_number_var = StringVar()
history_number_entry = Entry(history_number_frame,
textvariable=self.history_number_var)
history_number_entry.pack(side=LEFT)
# 性别Frame
gender_frame = Frame(self.page)
gender_frame.pack(side=TOP)
gender_label = Label(gender_frame, text='性别')
gender_label.pack(side=LEFT)
self.gender_var = IntVar()
r1 = Radiobutton(gender_frame,
variable=self.gender_var,
value=0,
text="女")
r2 = Radiobutton(gender_frame,
variable=self.gender_var,
value=1,
text="男")
r1.pack(side=LEFT)
r2.pack(side=LEFT)
# 年龄Frame
age_frame = Frame(self.page)
age_frame.pack(side=TOP)
age_label = Label(age_frame, text='年龄')
age_label.pack(side=LEFT)
self.age_var = StringVar()
age_entry = Entry(age_frame, textvariable=self.age_var)
age_entry.pack(side=LEFT)
# 主治医生Frame
doctor_frame = Frame(self.page)
doctor_frame.pack(side=TOP)
doctor_label = Label(doctor_frame, text='主治医生')
doctor_label.pack(side=LEFT)
self.doctor_var = StringVar()
self.doctor_com = ttk.Combobox(doctor_frame,
textvariable=self.doctor_var)
self.doctor_com['value'] = [doctor['name'] for doctor in self.doctors]
self.doctor_com.pack(side=LEFT)
# 所属科室Frame
office_name_frame = Frame(self.page)
office_name_frame.pack(side=TOP)
office_name_label = Label(office_name_frame, text='科室')
office_name_label.pack(side=LEFT)
self.office_name_var = StringVar()
self.office_name_com = ttk.Combobox(office_name_frame,
textvariable=self.office_name_var)
self.office_name_com['value'] = [
office['name'] for office in self.offices
]
self.office_name_com.pack(side=LEFT)
# 病房号Frame
room_frame = Frame(self.page)
room_frame.pack(side=TOP)
room_label = Label(room_frame, text='病房号')
room_label.pack(side=LEFT)
self.room_var = StringVar()
self.room_com = ttk.Combobox(room_frame, textvariable=self.room_var)
self.room_com['value'] = [room['room_number'] for room in self.rooms]
self.room_com.pack(side=LEFT)
# 诊断Frame
dig_frame = Frame(self.page)
dig_frame.pack(side=TOP)
dig_label = Label(dig_frame, text='诊断')
dig_label.pack(side=LEFT)
self.dig_var = StringVar()
dig_entry = Entry(dig_frame, textvariable=self.dig_var)
dig_entry.pack(side=LEFT)
# 提交按钮
btn_frame = Frame(self.page)
commit_button = Button(btn_frame,
text='提交',
command=self.insert_patient)
commit_button.pack(side=LEFT)
commit_button = Button(btn_frame, text='修改', command=self.change)
commit_button.pack(side=LEFT)
btn_frame.pack(side=TOP)
# 表格
self.tb = ttk.Treeview(self.page,
columns=('0', '1', '2', '3', '4', '5', '6', '7',
'8'),
show="headings")
self.tb.column("0", width=50, anchor='center')
self.tb.column("1", width=50, anchor='center')
self.tb.column("2", width=80, anchor='center')
self.tb.column("3", width=80, anchor='center')
self.tb.column("4", width=80, anchor='center')
self.tb.column("5", width=80, anchor='center')
self.tb.column("6", width=80, anchor='center')
self.tb.column("7", width=80, anchor='center')
self.tb.column("8", width=80, anchor='center')
self.tb.heading("0", text="id")
self.tb.heading("1", text="医生")
self.tb.heading("2", text="房号")
self.tb.heading("3", text="科室")
self.tb.heading("4", text="病例号")
self.tb.heading("5", text="姓名")
self.tb.heading("6", text="性别")
self.tb.heading("7", text="年龄")
self.tb.heading("8", text="诊断结果")
self.tb.bind('<ButtonRelease-1>', self.tb_bind)
self.tb.pack(side=TOP)
self.refresh_table()
# 返回
return_button = Button(self.page, text='返回', command=self.back)
return_button.pack(side=TOP)
def __init__(self, root: Tk):
self.rooms = []
# 数据库查询所有科室
session = DBSession()
offices: List[Office] = session.query(Office).filter().all()
self.offices = [{
'id': office.id,
'name': office.office_name
} for office in offices]
self.root = root
self.page = Frame(self.root)
self.page.pack()
self.root.title('病房管理')
self.root.geometry('260x360')
# 病房号Frame
room_number_frame = Frame(self.page)
room_number_frame.pack(side=TOP)
room_number_label = Label(room_number_frame, text='病房号')
room_number_label.pack(side=LEFT)
self.room_number_var = StringVar()
room_number_entry = Entry(room_number_frame,
textvariable=self.room_number_var)
room_number_entry.pack(side=LEFT)
# 床位数Frame
room_bed_number_frame = Frame(self.page)
room_bed_number_frame.pack(side=TOP)
room_bed_number_label = Label(room_bed_number_frame, text='床位数')
room_bed_number_label.pack(side=LEFT)
self.room_bed_number_var = StringVar()
room_bed_number_entry = Entry(room_bed_number_frame,
textvariable=self.room_bed_number_var)
room_bed_number_entry.pack(side=LEFT)
# 所属科室Frame
office_name_frame = Frame(self.page)
office_name_frame.pack(side=TOP)
office_name_label = Label(office_name_frame, text='所属科室')
office_name_label.pack(side=LEFT)
self.office_name_var = StringVar()
self.office_name_com = ttk.Combobox(office_name_frame,
textvariable=self.office_name_var)
self.office_name_com['value'] = [
office['name'] for office in self.offices
]
self.office_name_com.pack(side=LEFT)
# 提交按钮
btn_frame = Frame(self.page)
commit_button = Button(btn_frame, text='提交', command=self.insert_room)
commit_button.pack(side=LEFT)
commit_button = Button(btn_frame, text='修改', command=self.change)
commit_button.pack(side=LEFT)
btn_frame.pack(side=TOP)
# 表格
self.tb = ttk.Treeview(self.page,
columns=('0', '1', '2', '3'),
show="headings")
self.tb.column("0", width=50, anchor='center')
self.tb.column("1", width=50, anchor='center')
self.tb.column("2", width=80, anchor='center')
self.tb.column("3", width=80, anchor='center')
self.tb.heading("0", text="id")
self.tb.heading("1", text="病房号")
self.tb.heading("2", text="床位数")
self.tb.heading("3", text="所属科室")
self.tb.bind('<ButtonRelease-1>', self.tb_bind)
self.tb.pack(side=TOP)
# self.refresh_table()
# 返回按钮
return_button = Button(self.page, text='返回', command=self.back)
return_button.pack(side=TOP)
self.refresh_table()
def __init__(self, root: Tk):
self.doctors = []
# 数据库查询所有科室
session = DBSession()
offices: List[Office] = session.query(Office).filter().all()
self.offices = [{
'id': office.id,
'name': office.office_name
} for office in offices]
self.root = root
self.page = Frame(self.root)
self.page.pack()
self.root.title('医生管理')
self.root.geometry('500x430')
# 工号Frame
work_number_frame = Frame(self.page)
work_number_frame.pack(side=TOP)
work_number_label = Label(work_number_frame, text='工号')
work_number_label.pack(side=LEFT)
self.work_number_var = StringVar()
work_number_entry = Entry(work_number_frame,
textvariable=self.work_number_var)
work_number_entry.pack(side=LEFT)
# 姓名Frame
name_frame = Frame(self.page)
name_frame.pack(side=TOP)
name_label = Label(name_frame, text='姓名')
name_label.pack(side=LEFT)
self.name_var = StringVar()
name_entry = Entry(name_frame, textvariable=self.name_var)
name_entry.pack(side=LEFT)
# 性别Frame
gender_frame = Frame(self.page)
gender_frame.pack(side=TOP)
gender_label = Label(gender_frame, text='性别')
gender_label.pack(side=LEFT)
self.gender_var = IntVar()
r1 = Radiobutton(gender_frame,
variable=self.gender_var,
value=0,
text="女")
r2 = Radiobutton(gender_frame,
variable=self.gender_var,
value=1,
text="男")
r1.pack(side=LEFT)
r2.pack(side=LEFT)
# 年龄Frame
age_frame = Frame(self.page)
age_frame.pack(side=TOP)
age_label = Label(age_frame, text='年龄')
age_label.pack(side=LEFT)
self.age_var = StringVar()
age_entry = Entry(age_frame, textvariable=self.age_var)
age_entry.pack(side=LEFT)
# 职称Frame
title_frame = Frame(self.page)
title_frame.pack(side=TOP)
title_label = Label(title_frame, text='职称')
title_label.pack(side=LEFT)
self.title_var = StringVar()
self.title_com = ttk.Combobox(title_frame, textvariable=self.title_var)
self.title_com['value'] = ['主任', '副主任', '主治医师', '副院长', '院长']
self.title_com.pack(side=LEFT)
# 所属科室Frame
office_name_frame = Frame(self.page)
office_name_frame.pack(side=TOP)
office_name_label = Label(office_name_frame, text='科室')
office_name_label.pack(side=LEFT)
self.office_name_var = StringVar()
self.office_name_com = ttk.Combobox(office_name_frame,
textvariable=self.office_name_var)
self.office_name_com['value'] = [
office['name'] for office in self.offices
]
self.office_name_com.pack(side=LEFT)
# 提交按钮
btn_frame = Frame(self.page)
commit_button = Button(btn_frame,
text='提交',
command=self.insert_doctor)
commit_button.pack(side=LEFT)
commit_button = Button(btn_frame, text='修改', command=self.change)
commit_button.pack(side=LEFT)
btn_frame.pack(side=TOP)
# 表格
self.tb = ttk.Treeview(self.page,
columns=('0', '1', '2', '3', '4', '5', '6'),
show="headings")
self.tb.column("0", width=50, anchor='center')
self.tb.column("1", width=50, anchor='center')
self.tb.column("2", width=80, anchor='center')
self.tb.column("3", width=80, anchor='center')
self.tb.column("4", width=80, anchor='center')
self.tb.column("5", width=80, anchor='center')
self.tb.column("6", width=80, anchor='center')
self.tb.heading("0", text="id")
self.tb.heading("1", text="工号")
self.tb.heading("2", text="姓名")
self.tb.heading("3", text="性别")
self.tb.heading("4", text="年龄")
self.tb.heading("5", text="职称")
self.tb.heading("6", text="科室")
self.tb.bind('<ButtonRelease-1>', self.tb_bind)
self.tb.pack(side=TOP)
self.refresh_table()
# 返回
return_button = Button(self.page, text='返回', command=self.back)
return_button.pack(side=TOP)