# -*- coding: utf-8 -*- # author:chenke from method import select from method import week values = select() max1 = 0 for i in xrange(len(values)): max2 = max(week(values[i][2])) max1 = max(max1, max2) print range(max1)
# -*- coding: utf-8 -*- # author:chenke from xlwt import * import xlwt from method import select from method import week from method import show from method import lesson import os # 选取最大周数 values = select() max1 = 0 for i in xrange(len(values)): max2 = max(week(values[i][3])) max1 = max(max1, max2) print max1 for inputs in xrange(1, max1 + 1): # 打开excel w = Workbook() ws = w.add_sheet(u'值班') # 第一列宽 first_col = ws.col(0) first_col.width = 256 * 2 # 第二列宽 second_col = ws.col(1) second_col.width = 256 * 11 # 星期一到星期五列宽 for i in xrange(5):
C1=[] C2=[] C3=[] D1=[] D2=[] D3=[] E1=[] E2=[] E3=[] # 分发数据到对应数组 values = select() for i in xrange(len(values)): for wek in week(values[i][3]): if wek == inputs: if lesson(values[i][4]) == u'1' or lesson(values[i][4]) == u'2' or lesson(values[i][4]) == u'3' or lesson(values[i][4]) == u'4' or lesson(values[i][4]) == u'5': if values[i][4].find(u'一')!=-1: print 1 A1.append(values[i][1]+u'\n') elif values[i][4].find(u'二')!=-1: print 2 B1.append(values[i][1]+u'\n') elif values[i][4].find(u'三')!=-1: print 3 C1.append(values[i][1]+u'\n') elif values[i][4].find(u'四')!=-1: D1.append(values[i][1]+u'\n') print 4 elif values[i][4].find(u'五')!=-1:
B1 = [] B3 = [] C1 = [] C3 = [] D1 = [] D3 = [] E1 = [] E3 = [] # 分发数据到对应数组 values = select() for i in xrange(len(values)): for wek in week(values[i][2]): if wek == inputs: if lesson(values[i][3]) == u'1' or lesson( values[i][3]) == u'2' or lesson( values[i][3]) == u'3' or lesson( values[i][3]) == u'4' or lesson( values[i][3]) == u'5': if values[i][3].find(u'一') != -1: print 1 A1.append(values[i][1][0:len(values[i][1]) - 4] + u'楼' + u'\n') elif values[i][3].find(u'二') != -1: print 2 B1.append(values[i][1][0:len(values[i][1]) - 4] + u'楼' + u'\n') elif values[i][3].find(u'三') != -1: