Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- from tkinter import *
- import sqlite3
- import os
- pol = 0
- Okulist=0
- Lor=0
- Hirurg=0
- Ortoped=0
- fio = 0
- def bd():
- global pol
- global Okulist
- global Lor
- global Hirurg
- global Ortoped
- global fio
- if os.path.isfile('mydatabase.db'):
- conn = sqlite3.connect("mydatabase.db")
- cursor = conn.cursor()
- cursor.execute('select * from Bolka')
- all = cursor.fetchall()
- else:
- conn = sqlite3.connect("mydatabase.db")
- cursor = conn.cursor()
- cursor.execute("""CREATE TABLE Bolka
- (pol integer, fio TEXT, lor integer, hirurg integer, ortoped integer, okulist integer)
- """)
- ap='''insert into Bolka values(?, ?, ?, ?, ?, ?)'''
- cursor.execute(ap, (pol, fio, Lor, Hirurg, Ortoped, Okulist))
- conn.commit()
- pol = 0
- Okulist=0
- Lor=0
- Hirurg=0
- Ortoped=0
- fio = 0
- def test():
- global pol
- global Okulist
- global Lor
- global Hirurg
- global Ortoped
- global fio
- fio = textbox1.get()
- if var.get() == 1:
- pol = 1
- if var.get() == 2:
- pol = 2
- if varcheck1.get() == 1:
- Okulist = 1
- if varcheck2.get() == 1:
- Hirurg = 1
- if varcheck3.get() == 1:
- Lor = 1
- if varcheck4.get() == 1:
- Ortoped = 1
- bd()
- window = Tk()
- window.title("Врачи")
- window.geometry("500x350")
- lbl=Label(window, text="Запись к врачам", font = "Arial 15")
- lbl.place(relx=0.05, rely=0.05)
- var = IntVar()
- var.set(0)
- r1 = Radiobutton(window, text="М", variable=var, value=1)
- r2 = Radiobutton(window, text="Ж", variable=var, value=2)
- r1.place(relx=0.1, rely=0.15)
- r2.place(relx=0.2, rely=0.15)
- lbl2=Label(window, text="ФИО пациента: ", font = "Arial 15")
- lbl2.place(relx=0, rely=0.3)
- textbox1 = Entry(window, width = 30)
- textbox1.place(relx=0.3, rely=0.31)
- lbl2=Label(window, text="Выбор врачей: ", font = "Arial 15")
- lbl2.place(relx=0, rely=0.5)
- varcheck1 = IntVar()
- varcheck2 = IntVar()
- varcheck3 = IntVar()
- varcheck4= IntVar()
- varcheck1.set(0)
- varcheck2.set(0)
- varcheck3.set(0)
- varcheck4.set(0)
- check1 = Checkbutton(window, text = "Окулист", variable = varcheck1, onvalue=1, offvalue = 0)
- check2 = Checkbutton(window, text = "Хирург", variable =varcheck2, onvalue=1, offvalue = 0)
- check3 = Checkbutton(window, text = "Лор", variable = varcheck3, onvalue=1, offvalue = 0)
- check4 = Checkbutton(window, text = "Ортопед" , variable = varcheck4, onvalue=1, offvalue = 0)
- check1.place(relx=0, rely=0.6)
- check2.place(relx=0, rely=0.7)
- check3.place(relx=0.2, rely=0.6)
- check4.place(relx=0.2, rely=0.7)
- def vivod():
- print("База:")
- if os.path.isfile('mydatabase.db'):
- conn = sqlite3.connect("mydatabase.db")
- cursor = conn.cursor()
- cursor.execute('''SELECT * FROM Bolka''')
- results=cursor.fetchall()
- for results_unit in results:
- print(results_unit)
- print()
- conn.commit()
- conn.close()
- else:
- print("Нет базы")
- button2 = Button(window, text = "Записаться", command = test, font = 15)
- button2.place(relx=0.45, rely=0.8)
- button3 = Button(window, text = "Вывести базу", command = vivod, font = 15)
- button3.place(relx=0.68, rely=0.05)
- varcheck1.set(0)
- varcheck2.set(0)
- varcheck3.set(0)
- varcheck4.set(0)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement