Page 274 - MDP2020-3
P. 274

268
                      |    인천전자마이스터고등학교  ·············································································································



                            def  executeEnter(evt2):

                                    global  query2,  sqlDex
                                    #    여기에  nfc  태그  비교
                                    query2 = "UPDATE data SET Status = '재실' WHERE No = "  + str(num) +  ";"
                                    sqlDex  =  True
                                    examWindow.quit()

                                    examWindow.destroy()


                            def  executeBusiness(evt2):
                                    global  query2,  sqlDex
                                    #    여기에  nfc  태그  비교

                            query2 = "UPDATE data SET Status = '출장' WHERE No = "  + str(num) +  ";"
                                    sqlDex  =  True
                                    examWindow.quit()
                                    examWindow.destroy()



                            def  executeSemiExit(evt2):
                                    global  query2,  sqlDex
                                    #    여기에  nfc  태그  비교
                            query2 = "UPDATE data SET Status = '외출' WHERE No = "  + str(num) +  ";"
                                    sqlDex  =  True

                                    examWindow.quit()
                                    examWindow.destroy()


                            def  executeExit(evt2):
                                    global  query2,  sqlDex

                                    #    여기에  nfc  태그  비교
                            query2 = "UPDATE data SET Status = '퇴근' WHERE No = "  + str(num) +  ";"
                                    sqlDex  =  True
                                    examWindow.quit()
                                    examWindow.destroy()



                            def  closeExecute():
                                    examWindow.quit()
                                    examWindow.destroy()



                            r4c.set(str(personNums[num  -  1]['Name']))


                            pngLabel   =   Label(examWindow,    width=200,     height=200,     relief="solid",
            bg="white")
   269   270   271   272   273   274   275   276   277   278   279