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())