def makePublic(): if request.method == 'POST': return makepublic._makepublic() elif request.method == 'GET': if request.args.get('Delete',type=str)=='Delete':#删除公示信息 excelID=request.args.get('id',type=int) Excelmap.deleteExcel(excelID) return " " elif request.args.get('View',type=str)=='View':#查看公示信息 excelID=request.args.get('id',type=int) e=Excelmap.query.filter(excelID==Excelmap.id).first() filename= os.path.basename(e.filepath) return url_for('download_excel', filename = filename) elif request.args.get('Changestatus',type=str)=='Changestatus':#改变公示状态 excelID=request.args.get('id',type=int) e=Excelmap.query.filter(excelID==Excelmap.id).first() _status=request.args.get('status',type=int) e.status=_status db.session.commit() return str(_status) elif request.args.get('act',type=str)=='updateTotal':#更新总分 engine=Engine() engine.updateTotal() return " " else: #返回excel公示列表 return Excelmap.getExcelLits()#must be a jsonify object or it will return dict is not callable
def management_handle(): if request.method == 'POST': return makepublic._makepublic()#????????? elif request.method == 'GET': if request.args.get('Delete',type=str)=='Delete':#删除某个加分项 itemID=request.args.get('itemID',type=int) Score_items.delete(itemID) return " " elif request.args.get('Delete',type=str)=='DeleteStu':#删除学生 campID=request.args.get('campID',type=str) User.delete(campID) return " " elif request.args.get('Edit',type=str)=='Edit':#编辑 id=request.args.get('id',type=str) name=request.args.get('edit_name',type=unicode) campID=request.args.get('edit_campID',type=str) grade=request.args.get('edit_grade',type=unicode) studentID=request.args.get('edit_studentID',type=str) return User.edit(id,campID,name,grade,studentID) elif request.args.get('Add',type=str)=='Add':#添加学生 name=request.args.get('add_name',type=unicode) campID=request.args.get('add_campID',type=str) grade=request.args.get('add_grade',type=unicode) studentID=request.args.get('add_studentID',type=str) user=User.get_user(campID) if user: return u"一卡通号重复" else : User.addstudent(campID,name,grade,addstudent) return u"添加成功" elif request.args.get('action',type=str)=='resetpw': campID=request.args.get('campID',type=str) user=User.get_user(campID) try: user.password=user.campID db.session.commit() return u"重置成功" except StandardError,e: return u"未知错误"