def lossUser(self,cardid): try: #更新卡片及用户状态 cardmodel = Card() noid = cardmodel.getNoId(cardid) sql = 'update card set `stat` = 4 where noid = "'+str(noid['noid'])+'"' self._cursor.execute(sql) #更新用户状态及操作时间 carddata = cardmodel.queryCard(noid['noid']) uid = carddata['uid'] sql = 'update customer set `stat` = 2,actdate=UNIX_TIMESTAMP() where id='+str(uid) self._cursor.execute(sql) self._conn.commit() return True except: return False