def save_new_data(self, id_emp): db_file.getConnection() parse_str = self.dossier_choice.currentText().split('#') dossier_num = parse_str[0] db_file.save_bio_age(self.get_data(self), self.rw_glomeruli.text(), self.rw_arteries.text(), self.rw_stroma.text(), self.result_age.text(), dossier_num, id_emp, self.category) self.inform('Данные сохранены!')
def delete_emp(self): db_file.getConnection() if self.employees_list.currentItem().isSelected(): answer = self.question() if answer: note_id = self.employees_list.currentItem().text() db_file.del_emp(note_id)
def save_new_data(self, id_emp): db_file.getConnection() parse_str = self.dossier_choice.currentText().split('#') dossier_num = parse_str[0] db_file.save_dip_plane_calculation(self.get_data(self), self.rw_weight.text(), self.rw_height.text(), self.surface, dossier_num, id_emp, self.power, self.lab_result_text.text(), self.category) self.inform('Данные сохранены!')
def save_new_emp(self, mode, note_id): if (len(self.rw_name.text()) == 0 or len(self.rw_surname.text()) == 0 or len(self.rw_post.text()) == 0 or len(self.rw_right.currentText()) == 0 or len(self.rw_login_new.text()) == 0 or len(self.rw_pass_new.text()) == 0): self.warning("Заполните все поля со * !") else: db_file.getConnection() if mode == 0: login_comp = db_file.login_comparison(self.rw_login_new.text()) pass_comp = db_file.pass_comparison(self.rw_pass_new.text()) if login_comp: self.warning("Логин уже существует!\nВведите другой!") if pass_comp: self.warning("Пароль уже существует!\nВведите другой!") db_file.new_emp_note(self.rw_name.text(), self.rw_surname.text(), self.rw_patr.text(), self.rw_age.text(), self.rw_post.text(), self.rw_education.text(), self.rw_right.currentText(), self.rw_login_new.text(), self.rw_pass_new.text(), self.rw_photo.text()) self.inform('Сотрудник добавлен!') if mode == 1: db_file.edit_emp_note(note_id, self.rw_name.text(), self.rw_surname.text(), self.rw_patr.text(), self.rw_age.text(), self.rw_post.text(), self.rw_education.text(), self.rw_right.currentText(), self.rw_login_new.text(), self.rw_pass_new.text(), self.rw_photo.text()) self.inform('Данные успешно изменены!') # if __name__ == "__main__": # import sys # app = QtGui.QApplication(sys.argv) # window_main = Wind(0, -1) # window_main.show() # sys.exit(app.exec_())
def save_new_data(self, id_emp): db_file.getConnection() parse_str = self.dossier_choice.currentText().split('#') dossier_num = parse_str[0] db_file.save_alcohol_excretion(self.get_data(self), self.rw_weight.text(), self.rw_amount.text(), self.rw_alc_cont.text(), self.result_time.text(), dossier_num, id_emp, self.category) self.inform('Данные сохранены!') # if __name__ == "__main__": # import sys # app = QtGui.QApplication(sys.argv) # window_main = AlcoholExcretion(2) # window_main.show() # sys.exit(app.exec_())
def save_new_term(self): db_file.getConnection() name = db_file.term_comparison(self.rw_name.text()) if len(self.rw_name.text()) == 0 or len(self.rw_describe.toPlainText()) == 0: self.warning("Заполните все поля!") else: if name: self.warning("Термин уже существует!") else: db_file.save_term(self.rw_name.text(), self.rw_describe.toPlainText()) self.inform('Данные сохранены!') # if __name__ == "__main__": # import sys # app = QtGui.QApplication(sys.argv) # window_main = TermNew() # window_main.show() # sys.exit(app.exec_())
def save_new_data(self, id_emp): db_file.getConnection() parse_str = self.dossier_choice.currentText().split('#') dossier_num = parse_str[0] db_file.save_body_weight_determination(self.get_data(self), self.rw_height.text(), self.rw_thorax.text(), self.rw_leg.text(), self.rw_breech.text(), self.sex, self.result_weight.text(), dossier_num, id_emp, self.category) self.inform('Данные сохранены!') # if __name__ == "__main__": # import sys # app = QtGui.QApplication(sys.argv) # window_main = BodyWeight(2) # window_main.show() # sys.exit(app.exec_())
def saving_new_dossier(self): if (len(self.rw_name.text()) == 0 or len(self.rw_surname.text()) == 0 or len(self.rw_birthday.text()) == 0): self.warning("Заполните все поля!") else: parse_date_str = self.rw_birthday.text().split('.') date_year = parse_date_str[0] if len(date_year) != 4 or len(self.rw_birthday.text()) != 10: self.warning("Неправильно введена дата!\nВведите: гггг.мм.дд") else: db_file.getConnection() db_file.new_dossier(self.rw_name.text(), self.rw_surname.text(), self.rw_birthday.text()) self.inform('Дело успешно добавлено!') # if __name__ == "__main__": # import sys # app = QtGui.QApplication(sys.argv) # window_main = NewDossier() # window_main.show() # sys.exit(app.exec_())
def on_show(self): db_file.getConnection() entry_condition = db_file.entering(self.rw_login.text(), self.rw_pass.text()) if entry_condition > 0: self.current_emp_id = entry_condition right = db_file.rights_check(self.rw_login.text()) if right: self.new_worker.setEnabled(True) self.workers_list.setEnabled(True) self.param = True else: self.new_worker.setEnabled(False) self.workers_list.setEnabled(False) self.param = False self.layout_3.deleteLater() # lay_window1(self) main_window_contain(self, self.current_emp_id) #win = ModalWind(self) # #win.show() #self.setCentralWidget(win) else: self.warning("Неверный логин или пароль!" "\nПовторите ввод!")
def get_data_from_db(self): db_file.getConnection() entries = db_file.load_emp_notes() for entry in entries: self.make_item(entry)