Advertisement
Guest User

Untitled

a guest
Jun 24th, 2019
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.40 KB | None | 0 0
  1. from tkinter import *
  2. import sqlite3
  3. import os
  4.  
  5. pol = 0
  6. Okulist=0
  7. Lor=0
  8. Hirurg=0
  9. Ortoped=0
  10. fio = 0
  11. def bd():
  12. global pol
  13. global Okulist
  14. global Lor
  15. global Hirurg
  16. global Ortoped
  17. global fio
  18. if os.path.isfile('mydatabase.db'):
  19. conn = sqlite3.connect("mydatabase.db")
  20. cursor = conn.cursor()
  21. cursor.execute('select * from Bolka')
  22. all = cursor.fetchall()
  23. else:
  24. conn = sqlite3.connect("mydatabase.db")
  25. cursor = conn.cursor()
  26. cursor.execute("""CREATE TABLE Bolka
  27. (pol integer, fio TEXT, lor integer, hirurg integer, ortoped integer, okulist integer)
  28. """)
  29.  
  30. ap='''insert into Bolka values(?, ?, ?, ?, ?, ?)'''
  31. cursor.execute(ap, (pol, fio, Lor, Hirurg, Ortoped, Okulist))
  32. conn.commit()
  33. pol = 0
  34. Okulist=0
  35. Lor=0
  36. Hirurg=0
  37. Ortoped=0
  38. fio = 0
  39. def test():
  40. global pol
  41. global Okulist
  42. global Lor
  43. global Hirurg
  44. global Ortoped
  45. global fio
  46. fio = textbox1.get()
  47. if var.get() == 1:
  48. pol = 1
  49. if var.get() == 2:
  50. pol = 2
  51. if varcheck1.get() == 1:
  52. Okulist = 1
  53. if varcheck2.get() == 1:
  54. Hirurg = 1
  55. if varcheck3.get() == 1:
  56. Lor = 1
  57. if varcheck4.get() == 1:
  58. Ortoped = 1
  59. bd()
  60.  
  61. window = Tk()
  62. window.title("Врачи")
  63. window.geometry("500x350")
  64. lbl=Label(window, text="Запись к врачам", font = "Arial 15")
  65. lbl.place(relx=0.05, rely=0.05)
  66. var = IntVar()
  67. var.set(0)
  68. r1 = Radiobutton(window, text="М", variable=var, value=1)
  69. r2 = Radiobutton(window, text="Ж", variable=var, value=2)
  70. r1.place(relx=0.1, rely=0.15)
  71. r2.place(relx=0.2, rely=0.15)
  72. lbl2=Label(window, text="ФИО пациента: ", font = "Arial 15")
  73. lbl2.place(relx=0, rely=0.3)
  74. textbox1 = Entry(window, width = 30)
  75. textbox1.place(relx=0.3, rely=0.31)
  76. lbl2=Label(window, text="Выбор врачей: ", font = "Arial 15")
  77. lbl2.place(relx=0, rely=0.5)
  78. varcheck1 = IntVar()
  79. varcheck2 = IntVar()
  80. varcheck3 = IntVar()
  81. varcheck4= IntVar()
  82. varcheck1.set(0)
  83. varcheck2.set(0)
  84. varcheck3.set(0)
  85. varcheck4.set(0)
  86. check1 = Checkbutton(window, text = "Окулист", variable = varcheck1, onvalue=1, offvalue = 0)
  87. check2 = Checkbutton(window, text = "Хирург", variable =varcheck2, onvalue=1, offvalue = 0)
  88. check3 = Checkbutton(window, text = "Лор", variable = varcheck3, onvalue=1, offvalue = 0)
  89. check4 = Checkbutton(window, text = "Ортопед" , variable = varcheck4, onvalue=1, offvalue = 0)
  90. check1.place(relx=0, rely=0.6)
  91. check2.place(relx=0, rely=0.7)
  92. check3.place(relx=0.2, rely=0.6)
  93. check4.place(relx=0.2, rely=0.7)
  94. def vivod():
  95. print("База:")
  96. if os.path.isfile('mydatabase.db'):
  97. conn = sqlite3.connect("mydatabase.db")
  98. cursor = conn.cursor()
  99. cursor.execute('''SELECT * FROM Bolka''')
  100. results=cursor.fetchall()
  101. for results_unit in results:
  102. print(results_unit)
  103. print()
  104. conn.commit()
  105. conn.close()
  106. else:
  107. print("Нет базы")
  108.  
  109. button2 = Button(window, text = "Записаться", command = test, font = 15)
  110. button2.place(relx=0.45, rely=0.8)
  111. button3 = Button(window, text = "Вывести базу", command = vivod, font = 15)
  112. button3.place(relx=0.68, rely=0.05)
  113. varcheck1.set(0)
  114. varcheck2.set(0)
  115. varcheck3.set(0)
  116. varcheck4.set(0)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement