def login(self):
name = self.ui.lineEdit.text()
pwd = self.ui.lineEdit_2.text()
check = MyLogin.DB.getUserManager().checkUser(self.getUserType(), name, pwd)
if not check:
self.ui.lineEdit.setText('')
self.ui.lineEdit_2.setText('')
if check:
StatusManager.setLoginId1(name)
if self.getUserType()[0]=='a':
MyMainW(MyLogin.DB,self).show()
elif self.getUserType()[0]=='o':
MyOMainW(MyLogin.DB,self).show()
else:
MySMainW(MyLogin.DB,self).show()
self.hide()
def login(self):
name = self.ui.lineEdit.text()
pwd = self.ui.lineEdit_2.text()
check = MyLogin.DB.getUserManager().checkUser(self.getUserType(), name,
pwd)
if not check:
self.ui.lineEdit.setText('')
self.ui.lineEdit_2.setText('')
if check:
StatusManager.setLoginId1(name)
if self.getUserType()[0] == 'a':
MyMainW(MyLogin.DB, self).show()
elif self.getUserType()[0] == 'o':
MyOMainW(MyLogin.DB, self).show()
else:
MySMainW(MyLogin.DB, self).show()
self.hide()
def checkUser(self,userType,name,pwd):
sql = " SELECT * FROM " + userType + " WHERE name=\'%s\' AND pwd=\'%s\' AND state=0;" % (name,pwd)
# print(sql)
cur = DbManager.con.cursor()
cur.execute(sql)
data = cur.fetchone()
DbManager.con.commit()
if data == None:
return
print(data)
StatusManager.setLoginId1(data[0])
if userType[0] == 's':
StatusManager.setUserType1(1)
elif userType[0] == 'a':
StatusManager.setUserType1(2)
elif userType[0] == 'o':
StatusManager.setUserType1(3)
return True
def checkUser(self, userType, name, pwd):
sql = " SELECT * FROM " + userType + " WHERE name=\'%s\' AND pwd=\'%s\' AND state=0;" % (
name, pwd)
# print(sql)
cur = DbManager.con.cursor()
cur.execute(sql)
data = cur.fetchone()
DbManager.con.commit()
if data == None:
return
print(data)
StatusManager.setLoginId1(data[0])
if userType[0] == 's':
StatusManager.setUserType1(1)
elif userType[0] == 'a':
StatusManager.setUserType1(2)
elif userType[0] == 'o':
StatusManager.setUserType1(3)
return True
