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