1 def __dealwith_order(msg) :
 2     orderstr = msg.text.lower()#不区分大小写
 3     orderstr = orderstr[len(orderHeader):]
 4     if orderstr == "1" :
 5         bot.registered.enable(auto_accept_friends)
 6         msg.reply(\'自动接收好友请求已开启\')
 7     elif orderstr == "2" :
 8         bot.registered.disable(auto_accept_friends)
 9         msg.reply(\'自动接收好友请求已关闭\')
10     elif orderstr == "3" :
11         if t.is_alive() :
12             if t.is_pause() :
13                 msg.reply(\'后台线程已挂起\')
14             else :
15                 msg.reply(\'后台线程运行正常\')
16         else :
17             msg.reply(\'后台线程已退出\')
18     elif orderstr == "4" :
19         t.resume()
20         msg.reply(\'后台线程已恢复\')
21     elif orderstr == "5" :
22         t.pause()
23         msg.reply(\'后台线程已挂起\')
24     elif orderstr == "6" :
25         restartTimer() 
26         msg.reply(\'后台线程已重启\')
27     elif orderstr.startswith("7 ") :
28         global timerInterval
29         timerInterval = int(orderstr[2:].strip())
30         restartTimer() 
31         msg.reply(\'后台线程刷新间隔已修改：{0}\'.format(timerInterval))
32     else :
33         msg.reply(\'指令：order+序号\n1、开启自动接收好友请求\n2、关闭自动接收好友请求\n3、查看后台线程是否活跃\n4、恢复后台线程\n5、挂起后台线程\n6、重新启动后台线程\n\')

 1 def WriteSheetRow(wbk, sheet, rowValueList, rowIndex, isBold):
 2     i = 1
 3     for svalue in rowValueList :
 4         if isBold :
 5             sheet[GetCellKey(rowIndex, i)] = svalue
 6             sheet[GetCellKey(rowIndex, i)].font = openpyxl.styles.Font(bold = True)
 7         else:
 8             sheet[GetCellKey(rowIndex, i)] = svalue
 9         i = i + 1
10 
11     #写入单独已用户名为标签的sheet
12     name = rowValueList[0]
13     subsheet = None
14     if name not in names :
15         subsheet = wbk.create_sheet(name)
16         WriteSheetTitle(subsheet)
17         FixedSheetWidth(subsheet)
18         names.append(name)
19     else :
20         subsheet = wbk[name]
21 
22     j = 1
23     rowIndex = subsheet.max_row + 1
24     for svalue in rowValueList:
25         if isBold :
26             subsheet[GetCellKey(rowIndex, j)] = svalue
27         else:
28             subsheet[GetCellKey(rowIndex, j)] = svalue
29         j = j + 1

 1 # -*- coding: UTF-8 -*-
 2 
 3 import time
 4 import threading
 5 
 6 class Timer(threading.Thread):
 7     def __init__(self, fun, seconds):
 8         self.__runTime = seconds
 9         self.__runfun = fun
10         self.__elapsed = 0.0 #流失的时间
11         self.__flag = threading.Event()     # 用于暂停线程的标识
12         self.__flag.set()       # 设置为True
13         self.__running = threading.Event()      # 用于停止线程的标识
14         self.__running.set()      # 将running设置为True
15         threading.Thread.__init__(self)
16         print("initialize Timer completed!")
17 
18     def run(self):
19         while self.__running.isSet():
20             self.__flag.wait()      # 为True时立即返回, 为False时阻塞直到内部的标识位为True后返回
21             time.sleep(0.1) #100ms检测一次退出状态
22             self.__elapsed = self.__elapsed + 0.1
23             if self.__elapsed > self.__runTime :
24                 self.__elapsed = 0.0
25                 self.__runfun()
26 
27     def pause(self):
28         self.__flag.clear()     # 设置为False, 让线程阻塞
29 
30     def is_pause(self) :
31         return  self.__flag.isSet() == False
32 
33     def resume(self):
34         self.__flag.set()    # 设置为True, 让线程停止阻塞
35 
36     def stop(self):
37         self.__flag.set()       # 将线程从暂停状态恢复, 如何已经暂停的话
38         self.__running.clear()        # 设置为False
39         self.__elapsed = 0.0