def fetchexp(self):
model = modelFile.Model()
model.connect2db()
result = model.show_work_exp(self.currentID)
self.rowindex = 0
self.record = []
if len(result) == 0:
t1 = QLineEdit()
t2 = QLineEdit()
t3 = QLineEdit()
t4 = QLineEdit()
t5 = QPushButton("添加")
t5.setFixedWidth(150)
t5.setFixedHeight(30)
t5.setObjectName(str(self.rowindex))
t5.clicked.connect(self.add_exp_tuple)
self.grid.addWidget(t1, self.rowindex + 3, 1)
self.grid.addWidget(t2, self.rowindex + 3, 2)
self.grid.addWidget(t3, self.rowindex + 3, 3)
self.grid.addWidget(t4, self.rowindex + 3, 4)
self.grid.addWidget(t5, self.rowindex + 3, 5)
self.record.append([t1, t2, t3, t4, t5])
return
for item in result:
work_place = item[1]
title = item[2]
start_day = str(item[3])
end_day = str(item[4])
t1 = QLineEdit(work_place)
t2 = QLineEdit(title)
t3 = QLineEdit(start_day)
t4 = QLineEdit(end_day)
t5 = QPushButton("更新")
t5.setObjectName(str(self.rowindex))
t5.setFixedWidth(100)
t5.setFixedHeight(30)
t5.clicked.connect(self.updateLine)
t6 = QPushButton("删除")
t6.setObjectName(str(self.rowindex))
t6.setFixedWidth(100)
t6.setFixedHeight(30)
t6.clicked.connect(self.delete_tuple)
self.grid.addWidget(t1, self.rowindex + 3, 1)
self.grid.addWidget(t2, self.rowindex + 3, 2)
self.grid.addWidget(t3, self.rowindex + 3, 3)
self.grid.addWidget(t4, self.rowindex + 3, 4)
self.grid.addWidget(t5, self.rowindex + 3, 5)
self.grid.addWidget(t6, self.rowindex + 3, 6)
self.rowindex += 1
self.record.append([t1, t2, t3, t4, t5, t6])
self.grid.addWidget(self.updateBtn, self.rowindex + 3, 1)
def upload(self):
# 参数二是默认的打开路径设置文件扩展名过滤,注意用双分号间隔
file_, filetype = QFileDialog.getOpenFileName(
self, "选取文件", "/Users/mohaitao/Desktop/pics",
"All Files (*);;Image Files (*.jpg)")
print(file_)
model = modelFile.Model()
model.connect2db()
model.updatePortrait(self.currentID, file_)
QMessageBox.information(self, "提醒", "头像修改成功!", QMessageBox.Yes)
self.fetchinfo()
def updateGrp(self):
sender = self.sender()
rowindex = int(sender.objectName())
fri_mail = self.record[rowindex][1].text()
grp_name = self.record[rowindex][3].text()
print(fri_mail, grp_name)
model = modelFile.Model()
model.connect2db()
model.updateGrp(self.currentID, fri_mail, grp_name)
self.showfriends()
def bottomAddGrp(self):
grp_name, ok = QInputDialog.getText(self, "新增分组", "请输入新的分组名:",
QLineEdit.Normal, "这是默认值")
if not ok:
return
model = modelFile.Model()
model.connect2db()
result = model.existGrp(grp_name)
if len(result) != 0:
QMessageBox.information(self, "分组信息", "这个分组已存在哦", QMessageBox.Yes)
return
model.addGrp(self.currentID, grp_name)
self.showfriends()
def updateLine(self):
model = modelFile.Model()
model.connect2db()
sender = self.sender()
rowindex = sender.objectName()
rowindex = int(rowindex)
workplace = self.record[rowindex][0].text()
title = self.record[rowindex][1].text()
startdate = self.record[rowindex][2].text()
enddate = self.record[rowindex][3].text()
model.update_work_exp(self.currentID, workplace, title, startdate,
enddate)
self.fetchexp()
def modifyinfo(self):
# 邮箱是不能修改的，通过邮箱定位tuple，进行更新
name, gender, birth, address = \
self.nametxt.text(), self.gendertxt.currentText(), \
self.birthtxt.text(), self.addresstxt.text()
print(name, gender, birth, address)
model = modelFile.Model()
model.connect2db()
status = model.modifyinfo(name, gender, birth, address,
str(self.currentID))
if status == 0:
QMessageBox.information(self, "提醒", "修改成功!", QMessageBox.Yes,
QMessageBox.Yes)
self.fetchinfo()
def bottomDeGrp(self):
grp_name, ok = QInputDialog.getText(self, "删除分组", "请输入删除的分组名:",
QLineEdit.Normal, "这是默认值")
if not ok:
return
if grp_name == "默认分组":
return
model = modelFile.Model()
model.connect2db()
status = model.chGrp(self.currentID, grp_name)
if status == 1:
QMessageBox.information(self, "分组信息", "没有这个分组诶", QMessageBox.Yes)
if status == 0:
QMessageBox.information(self, "分组信息", "修改成功", QMessageBox.Yes)
self.showfriends()
def updateLine(self):
model = modelFile.Model()
model.connect2db()
sender = self.sender()
rowindex = sender.objectName()
rowindex = int(rowindex)
level = self.record[rowindex][0].text()
school = self.record[rowindex][1].text()
degree = self.record[rowindex][2].text()
startdate = self.record[rowindex][3].text()
enddate = self.record[rowindex][4].text()
model.update_edu_exp(self.currentID, level, school, degree, startdate, enddate)
self.fetchexp()
def showfriends(self):
model = modelFile.Model()
model.connect2db()
friends = model.showfriends(self.currentID)
self.row = 0
self.record = []
if len(friends) == 0:
self.grid.addWidget(self.searchBtn, self.row + 3, 1)
self.grid.addWidget(self.addGrpBtn, self.row + 3, 2)
return
for item in friends:
fri_email = item[1]
grp_name = item[2]
fri_info = model.usrinfo(fri_email)
fri_name = fri_info[0]
fri_addr = fri_info[4]
t1 = QLabel(fri_name)
t2 = QLabel(fri_email)
t3 = QLabel(fri_addr)
t4 = QLineEdit(grp_name)
t5 = QPushButton("修改分组")
t5.setObjectName(str(self.row))
t5.setFixedWidth(100)
t5.setFixedHeight(30)
t5.clicked.connect(self.updateGrp)
t6 = QPushButton("删除")
t6.setObjectName(str(self.row))
t6.setFixedWidth(100)
t6.setFixedHeight(30)
t6.clicked.connect(self.deleteFri)
self.grid.addWidget(t1, self.row + 3, 1)
self.grid.addWidget(t2, self.row + 3, 2)
self.grid.addWidget(t3, self.row + 3, 3)
self.grid.addWidget(t4, self.row + 3, 4)
self.grid.addWidget(t5, self.row + 3, 5)
self.grid.addWidget(t6, self.row + 3, 6)
self.row += 1
self.record.append([t1, t2, t3, t4, t5, t6])
self.grid.addWidget(self.searchBtn, self.row + 3, 1)
self.grid.addWidget(self.addGrpBtn, self.row + 3, 2)
self.grid.addWidget(self.deGrpBtn, self.row + 3, 3)
def fetchinfo(self):
model = modelFile.Model()
model.connect2db()
info = model.usrinfo(self.currentID)
name, gender, birth, email, address, imgPath = \
info[0], info[1], info[2], info[3], info[4], info[6]
"""设置部件的文本内容"""
self.nametxt.setText(name)
self.gendertxt.setCurrentText(gender)
self.birthtxt.setDate(QDate.fromString(str(birth), 1))
self.emailtxt.setText(email)
self.addresstxt.setText(address)
pix = QPixmap(imgPath)
icon = QIcon()
icon.addPixmap(pix, QIcon.Normal, QIcon.Off)
self.imgLB.setIcon(icon)
self.imgLB.setIconSize(QSize(240, 240))
def modelsignup(self):
name = self.nameLineEdit.text()
email = self.emailLineEdit.text()
passwd = self.passLineEdit.text()
model = modelFile.Model()
model.connect2db()
if model.checkemail(email):
model.signup(name, None, None, email, None, passwd)
print(
QMessageBox.information(self, "提醒", "您已成功注册账号!",
QMessageBox.Yes, QMessageBox.Yes))
self.signal.emit(name)
else:
print(
QMessageBox.warning(self, "警告", "该账号已存在,请重新输入",
QMessageBox.Yes, QMessageBox.Yes))
print("该邮箱已被注册")
def delete_tuple(self):
# 删除的时候需要获取信号源的行坐标
sender = self.sender()
rowindex = sender.objectName()
rowindex = int(rowindex)
level = self.record[rowindex][0].text()
model = modelFile.Model()
model.connect2db()
model.delete_edu_exp(self.currentID, level)
# 删除所有控件！
print("will delete", self.record[rowindex][0].text())
for row in range(len(self.record)):
for col in range(7):
self.record[row][col].deleteLater()
self.fetchexp()
def bottomAdd(self):
fri_email, ok = QInputDialog.getText(self, "搜索好友", "请输入好友的email",
QLineEdit.Normal, "*****@*****.**")
if not ok:
return
if fri_email == self.currentID:
QMessageBox.information(self, "提醒", "你输入了自己的email...",
QMessageBox.Yes)
return
model = modelFile.Model()
model.connect2db()
grp = model.findGrp(self.currentID, fri_email)
if len(grp) != 0:
QMessageBox.information(self, "提醒", "ta已经是你的好友啦", QMessageBox.Yes)
return
fri_info = model.usrinfo(fri_email)
if len(fri_info) == 0:
QMessageBox.information(self, "没有诶", "该用户还未注册哦", QMessageBox.Yes)
return
model.addFriend(self.currentID, fri_email)
self.showfriends()
def deleteFri(self):
model = modelFile.Model()
model.connect2db()
sender = self.sender()
rowindex = sender.objectName()
rowindex = int(rowindex)
name = self.record[rowindex][0].text()
fri_email = self.record[rowindex][1].text()
reply = QMessageBox.warning(self, "取消关注", "确定取消关注{}吗？".format(name),
QMessageBox.Yes | QMessageBox.No)
if reply == 65536:
return
model.deleteFriend(self.currentID, fri_email)
# 删除所有控件！
for row in range(len(self.record)):
for col in range(6):
self.record[row][col].deleteLater()
self.showfriends()
def bottomAdd(self):
model = modelFile.Model()
model.connect2db()
self.t1 = QLineEdit()
self.t2 = QLineEdit()
self.t3 = QLineEdit()
self.t4 = QLineEdit()
self.t5 = QPushButton("添加")
self.t5.setFixedWidth(150)
self.t5.setFixedHeight(30)
self.t5.setObjectName(str(self.rowindex))
self.t5.clicked.connect(self.add_exp_tuple)
self.grid.addWidget(self.t1, self.rowindex + 3, 1)
self.grid.addWidget(self.t2, self.rowindex + 3, 2)
self.grid.addWidget(self.t3, self.rowindex + 3, 3)
self.grid.addWidget(self.t4, self.rowindex + 3, 4)
self.grid.addWidget(self.t5, self.rowindex + 3, 5)
self.record.append([self.t1, self.t2, self.t3, self.t4, self.t5])
self.rowindex += 1
def delete_tuple(self):
model = modelFile.Model()
model.connect2db()
sender = self.sender()
rowindex = sender.objectName()
rowindex = int(rowindex)
workplace = self.record[rowindex][0].text()
title = self.record[rowindex][1].text()
print("chosen", workplace)
model.delete_work_exp(self.currentID, workplace, title)
# 删除所有控件！
print("will delete", self.record[rowindex][0].text())
for row in range(len(self.record)):
for col in range(6):
self.record[row][col].deleteLater()
self.fetchexp()
def modelsignin(self):
email = self.emailLineEdit.text()
passwd = self.passLineEdit.text()
model = modelFile.Model()
model.connect2db()
loginstatus = model.signin(email, passwd)
#print("Checking!")
if loginstatus == 1:
#账号不存在
print(QMessageBox.warning(
self, "警告", "账号不存在!", QMessageBox.Yes, QMessageBox.Yes))
elif loginstatus == 2:
#登陆成功
print(QMessageBox.information(
self, "提醒", "登陆成功!", QMessageBox.Yes, QMessageBox.Yes))
return email
elif loginstatus == 3:
#密码错误
print(QMessageBox.warning(
self, "警告", "密码错误!", QMessageBox.Yes, QMessageBox.Yes))
def add2db(self):
sender = self.sender()
rowindex = sender.objectName()
rowindex = int(rowindex)
level = self.record[rowindex][0].text()
school = self.record[rowindex][1].text()
degree = self.record[rowindex][2].text()
startDate = self.record[rowindex][3].text()
endDate = self.record[rowindex][4].text()
model = modelFile.Model()
model.connect2db()
model.add_edu_work(self.currentID, level, school, degree, startDate, endDate)
for row in range(len(self.record)-1):
for col in range(7):
print(row, col)
self.record[row][col].deleteLater()
for col in range(6):
self.record[len(self.record)-1][col].deleteLater()
self.fetchexp()
def add_exp_tuple(self):
sender = self.sender()
rowindex = sender.objectName()
rowindex = int(rowindex)
workplace = self.record[rowindex][0].text()
title = self.record[rowindex][1].text()
startdate = self.record[rowindex][2].text()
enddate = self.record[rowindex][3].text()
model = modelFile.Model()
model.connect2db()
model.add_work_exp(self.currentID, workplace, title, startdate,
enddate)
# 删除所有控件！
for row in range(len(self.record) - 1):
for col in range(6):
print(row, col)
self.record[row][col].deleteLater()
for col in range(5):
self.record[len(self.record) - 1][col].deleteLater()
self.fetchexp()
def showfriends(self):
model = modelFile.Model()
model.connect2db()
model.showfriends(self.currentID)
def __init__(self):
self.model = modelFile.Model()
