def delete_member(self): try: self.FormVerify = logicVerify() self.FormVerify.setWindowModality(QtCore.Qt.ApplicationModal) self.FormVerify.show() if self.FormVerify.exec() == 1: hint = '学生姓名:{}\n联系方式:{}\n课程种类:{}\n '.format( self.meminfo_data['学生姓名'], self.meminfo_data['联系方式'], self.type2card[self.meminfo_data['课程种类']]) reply = QMessageBox.warning(self, '确认删除?', hint, QMessageBox.Yes | QMessageBox.No, QMessageBox.Yes) if reply == QMessageBox.Yes: sql = '''DELETE FROM mem_info WHERE mem_phone=\'{}\' and mem_name=\'{}\' and mem_type={}; '''.format(self.meminfo_data['联系方式'], self.meminfo_data['学生姓名'], self.meminfo_data['课程种类']) print(sql) flag = self.MySQL.DeleteFromDataBse(sql) if (flag): QMessageBox.information(self, '提示', '修改成功!', QMessageBox.Ok, QMessageBox.Ok) else: QMessageBox.information(self, '提示', '修改失败!', QMessageBox.Ok, QMessageBox.Ok) self.frash_studentList() except Exception as e: print(e)
def update_stuindo_confirm(self): try: newcishu = self.et_cichu__old.text() newcarditem = self.cb_card_old.currentText() money = self.et_money_old.text() if (newcishu == ''): QMessageBox.warning(self, u"温馨提示", u"请输入续卡次数", buttons=QMessageBox.Ok) elif (money == ''): QMessageBox.warning(self, u"温馨提示", u"请输入续卡的费用", buttons=QMessageBox.Ok) else: self.FormVerify = logicVerify() self.FormVerify.setWindowModality(QtCore.Qt.ApplicationModal) self.FormVerify.show() if self.FormVerify.exec() == 1: allcishu = self.current_cichu + int(newcishu) hint = '学生姓名:{}\n联系方式:{}\n课程种类:{}\n原有次数:{}\n' \ '增加次数:{}\n总次数:{}\n续卡金额:{}\n续卡种类:{}'.format( self.et_name_old.text(), self.et_phone_old.text(), self.cb_classitem_old.currentText(), self.current_cichu, newcishu, allcishu, self.et_money_old.text(), newcarditem ) reply = QMessageBox.warning( self, '确认信息', hint, QMessageBox.Yes | QMessageBox.No, QMessageBox.Yes) if reply == QMessageBox.Yes: sql_update_meminfo = 'UPDATE mem_info SET mem_cls_left={}, mem_cardtype=\'{}\' WHERE mem_phone=\'{}\' and mem_type={};'.format( allcishu, newcarditem, self.et_phone_old.text(), self.cb_classitem_old.currentIndex()) print(sql_update_meminfo) flag1 = self.MySQL.UpdateFromDataBse( sql_update_meminfo) self.banka_data['学生姓名'] = self.et_name_old.text() self.banka_data['学生电话'] = self.et_phone_old.text() self.banka_data['办卡续卡'] = 1 # '0'是办卡 ‘1’是续卡 self.banka_data['金额'] = self.et_money_old.text() self.banka_data['日期'] = dateweek.getCurrentYMD() flag2 = self.Insert2Banka() if (flag1 and flag2): self.clearEditAfterOldMemberUpdate() QMessageBox.information(self, '提示', '录入成功!', QMessageBox.Ok, QMessageBox.Ok) else: QMessageBox.information(self, '提示', '录入失败!', QMessageBox.Ok, QMessageBox.Ok) except Exception as e: print(e)
def on_button_verify(self): # 二级密码验证 veriWin = logicVerify() veriWin.myshow() if veriWin.exec() == 1: self.btn_remove.setEnabled(True) self.btn_confirm_2.setEnabled(True) self.lb_status.setText('当前状态:已认证') self.btn_verify.setEnabled(False)
def verify(self): try: FormVerify = logicVerify() FormVerify.setWindowModality(QtCore.Qt.ApplicationModal) FormVerify.show() if FormVerify.exec() == 1: self.bt_verify.setEnabled(False) self.bt_confrim.setEnabled(True) else: QMessageBox.information(self, '提示', '二级密码错误!', QMessageBox.Ok, QMessageBox.Ok) except Exception as e: print(e)
def modify_meminfo(self): try: self.FormVerify = logicVerify() self.FormVerify.setWindowModality(QtCore.Qt.ApplicationModal) self.FormVerify.show() if self.FormVerify.exec() == 1: self.FormModify = LogicModifyInfo(MySQL=self.MySQL, BasicInfo=self.meminfo_data) self.FormModify.setWindowModality(QtCore.Qt.ApplicationModal) self.FormModify.show() if (self.FormModify.exec() == 1): self.frash_studentList() except Exception as e: print(e)
def confrim_pic_old_update(self): try: if (self.et_phone_old.text() == ''): QMessageBox.warning(self, u"温馨提示", u"请在左侧选择学生", buttons=QMessageBox.Ok) else: self.FormVerify = logicVerify() self.FormVerify.setWindowModality(QtCore.Qt.ApplicationModal) self.FormVerify.show() if self.FormVerify.exec() == 1: hint = '学生姓名:{}\n联系方式:{}\n'.format( self.et_name_old.text(), self.et_phone_old.text()) reply = QMessageBox.warning( self, '确认信息', hint, QMessageBox.Yes | QMessageBox.No, QMessageBox.Yes) if reply == QMessageBox.Yes: sql_update_face = 'UPDATE mem_info SET mem_facefeature=\'{}\' WHERE mem_phone=\'{}\' and mem_name=\'{}\';'.format( self.meminfo_data['人脸特征'], self.et_phone_old.text(), self.et_name_old.text()) print(sql_update_face) flag1 = self.MySQL.UpdateFromDataBse(sql_update_face) if (flag1): self.clearEditAfterOldMemberUpdate() QMessageBox.information(self, '提示', '录入成功!', QMessageBox.Ok, QMessageBox.Ok) else: QMessageBox.information(self, '提示', '录入失败!', QMessageBox.Ok, QMessageBox.Ok) self.pb_confrim_pic_old.setEnabled(False) self.pb_cutlpic_old.setEnabled(False) except Exception as e: print(e)
def confrim_and_insert_new(self): try: #数据库段 self.meminfo_data['学生姓名'] = self.et_name_new.text() self.meminfo_data['学生年龄'] = self.et_age_new.text() self.meminfo_data['学生家长'] = self.et_parent_new.text() self.meminfo_data['联系方式'] = self.et_phone_new.text() self.meminfo_data['课程种类'] = self.cardtype[ self.cb_classitem_new.currentText()] self.meminfo_data['课时次数'] = self.et_cichu_new.text() self.meminfo_data['办卡种类'] = self.cb_card_new.currentText() self.banka_data['学生姓名'] = self.et_name_new.text() self.banka_data['学生电话'] = self.et_phone_new.text() self.banka_data['办卡续卡'] = 0 #'0'是办卡 ‘1’是续卡 self.banka_data['金额'] = self.et_money_new.text() self.banka_data['日期'] = dateweek.getCurrentYMD() if (self.meminfo_data['学生姓名'] == ''): QMessageBox.warning( self, u"温馨提示", u"请输入学生姓名", buttons=QMessageBox.Ok, ) elif (self.meminfo_data['学生性别'] == ''): QMessageBox.warning( self, u"温馨提示", u"请选择学生性别", buttons=QMessageBox.Ok, ) elif (self.meminfo_data['学生家长'] == ''): QMessageBox.warning( self, u"温馨提示", u"请输入学生家长姓名", buttons=QMessageBox.Ok, ) elif (self.meminfo_data['联系方式'] == ''): QMessageBox.warning( self, u"温馨提示", u"请输入联系手机号码", buttons=QMessageBox.Ok, ) elif not (self.PhoneCheck(self.meminfo_data['联系方式'])): QMessageBox.warning( self, u"温馨提示", u"请输入正确的11位手机号码", buttons=QMessageBox.Ok, ) elif (self.meminfo_data['课时次数'] == ''): QMessageBox.warning( self, u"温馨提示", u"请输入录入的课时次数", buttons=QMessageBox.Ok, ) elif (self.banka_data['金额'] == ''): QMessageBox.warning( self, u"温馨提示", u"请输入此次录入学生的办卡费用", buttons=QMessageBox.Ok, ) else: self.FormVerify = logicVerify() self.FormVerify.setWindowModality(QtCore.Qt.ApplicationModal) self.FormVerify.show() if self.FormVerify.exec() == 1: hint = '学生姓名:{}\n学生性别:{}\n学生年龄:{}\n学生家长:{}\n联系方式:{}\n课时次数:{}\n' \ '金额:{}\n课程种类:{}\n办卡种类:{}'.format( self.meminfo_data['学生姓名'], self.meminfo_data['学生性别'], self.meminfo_data['学生年龄'], self.meminfo_data['学生家长'], self.meminfo_data['联系方式'], self.meminfo_data['课时次数'], self.banka_data['金额'], self.cb_classitem_new.currentText(), self.cb_card_new.currentText() ) reply = QMessageBox.warning( self, '确认信息', hint, QMessageBox.Yes | QMessageBox.No, QMessageBox.Yes) if reply == QMessageBox.Yes: if (self.meminfo_data['人脸特征'] == ''): reply2 = QMessageBox.warning( self, '确认信息', '您还没有录入人脸图像\n确认继续录入吗?', QMessageBox.Yes | QMessageBox.No, QMessageBox.Yes) if (reply2 == QMessageBox.Yes): try: flag1 = self.Insert2Banka() flag2 = self.Insert2Meminfo() if (flag1 and flag2): QMessageBox.information( self, '提示', '录入成功!', QMessageBox.Ok, QMessageBox.Ok) self.clearEditAfterNewMemberInsert() else: QMessageBox.information( self, '提示', '录入失败!', QMessageBox.Ok, QMessageBox.Ok) except Exception as e: print(e) else: print(1) else: try: flag3 = self.Insert2Banka() flag4 = self.Insert2Meminfo() if (flag3 and flag4): QMessageBox.information( self, '提示', '录入成功!', QMessageBox.Ok, QMessageBox.Ok) self.clearEditAfterNewMemberInsert() else: QMessageBox.information( self, '提示', '录入失败!', QMessageBox.Ok, QMessageBox.Ok) except Exception as e: print(e) except Exception as e: print(e.args) traceback.print_exc() print('traceback.format_exc():\n%s' % traceback.format_exc())