Exemple #1
0
 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