def v_completedexp(request): stuid = utils.getCookie(request, "stuid") if (stuid is None) or stuid == "": return getloginResponse(request) stuname = utils.getCookie(request, "stuname") page = utils.getParam(request, "page") if (page is None) or page == "": page = 1 else: page = int(page) count = TeachingService.getCountPageByStu(stuid, CONSTANTS.TEACHING_IS_STOP) countpage = 0 i = 0 if count > 0: if count % 10 > 0: i = 1 countpage = count / 10 + i teachingRunList = TeachingService.getTeachingByStu(stuid, CONSTANTS.TEACHING_IS_STOP, page) experimentList = ExperimentService.getAllExperiment() # 获取用于菜单的实验列表 experimentMenuList = [] for experiment in experimentList: experimentTemp = experiment.copy() experimentName = experimentTemp["name"] if len(experimentName) > 8: experimentName = experimentName[0:10] + "..." experimentTemp["name"] = experimentName experimentMenuList.append(experimentTemp) teachingCount = getTeachingCount(stuid) return render(request, "completedexp.html", {"teachingList": teachingRunList, "countpage": countpage, "experimentMenuList": experimentMenuList, "experimentList": experimentList, "teachingCount": teachingCount, "stuname": stuname})
def v_studentmanagement(request): adminid = utils.getCookie(request, "adminid") if adminid == "" or adminid is None: return getloginResponse(request) issuperadmin = utils.getCookie(request, "issuperadmin") adminname = utils.getCookie(request, "adminname") stunum = utils.getParam(request, "searchnum") name = utils.getParam(request, "searchname") page = utils.getParam(request, "page") if (page is None) or page == "": page = 1 else: page = int(page) if (stunum == "" or stunum is None) and (name == "" or name is None): count = StudentService.getCountStudent() countpage = 0 i = 0 if count > 0: if count % 10 > 0: i = 1 countpage = count / 10 + i studentList = StudentService.getAllStudent(page) else: count = StudentService.getCountStudentByNameAndNumber(name, stunum) countpage = 0 i = 0 if count > 0: if count % 10 > 0: i = 1 countpage = count / 10 + i studentList = StudentService.getManyStudentByNameAndNumber( name, stunum, page) for student in studentList: filterinfo = FilterInfoService.getFilterInfoById(student.filterinfoid) student.registyear = filterinfo.registyear student.major = filterinfo.major student.classname = filterinfo.classname param = "?" if stunum != "": param = param + "searchnum=" + stunum if name != "": if param != "?": param = param + "&" param = param + "searchname=" + name if param == "?": param = "" return render( request, "studentmanagement.html", { "studentList": studentList, "stunum": stunum, "searchname": name, "adminname": adminname, "countpage": countpage, "issuperadmin": issuperadmin })
def expoperation(request, id): stuid = utils.getCookie(request, "stuid") if (stuid is None) or stuid == "": return getloginResponse(request) stuname = utils.getCookie(request, "stuname") stunumber = StudentService.getStudentById(stuid).number if id == '1': return render(request, "experiment/experiment1/expoperation.html", { "stuname": stuname, "stunumber": stunumber }) elif id == '2': return render(request, "experiment/experiment2/expoperation.html", { "stuname": stuname, "stunumber": stunumber }) elif id == '3': return render(request, "experiment/experiment3/expoperation.html", { "stuname": stuname, "stunumber": stunumber }) elif id == '4': return render(request, "experiment/experiment4/expoperation.html", { "stuname": stuname, "stunumber": stunumber }) elif id == '5': return render(request, "experiment/experiment5/expoperation.html", { "stuname": stuname, "stunumber": stunumber }) elif id == '6': return render(request, "experiment/experiment6/expoperation.html", { "stuname": stuname, "stunumber": stunumber }) elif id == '7': return render(request, "experiment/experiment7/expoperation.html", { "stuname": stuname, "stunumber": stunumber }) elif id == '8': return render(request, "experiment/experiment8/expoperation.html", { "stuname": stuname, "stunumber": stunumber }) elif id == '9': return render(request, "experiment/experiment9/expoperation.html", { "stuname": stuname, "stunumber": stunumber }) elif id == '10': return render(request, "experiment/experiment10/expoperation.html", { "stuname": stuname, "stunumber": stunumber })
def image_draw(request): stuid = utils.getCookie(request, "stuid") if (stuid is None) or stuid == "": return getloginResponse(request) stuname = utils.getCookie(request, "stuname") stunumber = StudentService.getStudentById(stuid).number return render(request, "experiment/image_draw.html", { "stuname": stuname, "stunumber": stunumber })
def v_approval(request): teacherid = utils.getCookie(request, "teacherid") if (teacherid is None) or teacherid == "": return getloginResponse(request) teachingid = utils.getParam(request, "teachingid") teachername = utils.getCookie(request, "teachername") reportList = ReportService.getReportByTeachingid(int(teachingid)) return render(request, "approval.html", { "reportList": reportList, "teachername": teachername })
def v_adminmanagement(request): adminid = utils.getCookie(request, "adminid") if adminid == "" or adminid is None: return getloginResponse(request) issuperadmin = utils.getCookie(request, "issuperadmin") if issuperadmin != "1" or issuperadmin is None: return getloginResponse(request) adminList = AdminService.getAllAdmin() return render(request, "adminmanagement.html", { "issuperadmin": issuperadmin, "adminList": adminList })
def setBasicInformation(request): adminid = utils.getCookie(request, "adminid") if adminid == "" or adminid is None: return getloginResponse(request) filterInfoList = FilterInfoService.getFilterInfoList(None) issuperadmin = utils.getCookie(request, "issuperadmin") adminname = utils.getCookie(request, "adminname") return render( request, "set_basic_information.html", { "filterInfoList": filterInfoList, "issuperadmin": issuperadmin, "adminname": adminname })
def uploadData(request): teacherid = utils.getCookie(request, "teacherid") if (teacherid is None) or teacherid == "": responseReturn = Response(-2, "请登录") return HttpResponse(responseReturn.__str__()) teachingid = utils.getParam(request, "teachingid") file = request.FILES.get('file', None) if file is None: return HttpResponse( "<script>if(confirm('上传的文件为空')){history.go(-1);location.reload()}else{history.go(-1);location.reload()}</script>" ) filename = file.name filesuffix = os.path.splitext(filename)[1] if filesuffix != ".xsl" and filesuffix != ".xlsx": return HttpResponse( "<script>if(confirm('实验数据必须为excel')){history.go(-1);location.reload()}else{history.go(-1);location.reload()}</script>" ) filename = str(uuid.uuid1()) + filesuffix fp = open(os.path.join(CONSTANTS.DATAURL_PRE, filename), 'wb+') for chunk in file.chunks(): # 分块写入文件 fp.write(chunk) fp.close() TeachingService.uploadData(teachingid, filename) return HttpResponse( "<script>if(confirm('上传成功')){history.go(-1);location.reload()}else{history.go(-1);location.reload()}</script>" )
def uploadVideo(request): teacherid = utils.getCookie(request, "teacherid") if (teacherid is None) or teacherid == "": responseReturn = Response(-2, "请登录") return HttpResponse(responseReturn.__str__()) experimentid = utils.getParam(request, "experimentid") file = request.FILES.get('file', None) name = utils.getParam(request, "name") if experimentid == "": responseReturn = Response(-1, "请选择实验!") return HttpResponse(responseReturn.__str__()) if file is None: responseReturn = Response(-1, "上传文件为空!") return HttpResponse(responseReturn.__str__()) filename = file.name filesuffix = os.path.splitext(filename)[1] if filesuffix != ".mp4" and filesuffix != ".rmvb": responseReturn = Response(-1, "视屏格式应为MP4、rmvb!") return HttpResponse(responseReturn.__str__()) filename = str(uuid.uuid1()) + filesuffix fp = open(os.path.join(CONSTANTS.EXPERIMENTVIDEOURL_PRE, filename), 'wb+') for chunk in file.chunks(): # 分块写入文件 fp.write(chunk) fp.close() videoid = VideoService.saveVideo(name, filename, experimentid) if videoid is None: responseReturn = Response(-1, "上传失败,请重试!") return HttpResponse(responseReturn.__str__()) video = {"id": videoid, "name": name, "url": filename} responseReturn = Response(None, None) responseReturn.setRes(json.dumps(video)) return HttpResponse(responseReturn.__str__())
def updateExperimentTemplate(request): teacherid = utils.getCookie(request, "teacherid") if (teacherid is None) or teacherid == "": responseReturn = Response(-2, "请登录") return HttpResponse(responseReturn.__str__()) experimentid = utils.getParam(request, "experimentid") file = request.FILES.get('file', None) if file is None: return HttpResponse( "<script>if(confirm('上传的文件为空')){history.go(-1);location.reload()}else{history.go(-1);location.reload()}</script>" ) filename = file.name filesuffix = os.path.splitext(filename)[1] if filesuffix != ".doc" and filesuffix != ".docx": return HttpResponse( "<script>if(confirm('模板必须为word格式')){history.go(-1);location.reload()}else{history.go(-1);location.reload()}</script>" ) filename = str(uuid.uuid1()) + filesuffix fp = open(os.path.join(CONSTANTS.TEMPLATEURL_PRE, filename), 'wb+') for chunk in file.chunks(): # 分块写入文件 fp.write(chunk) fp.close() templateid = TemplateService.addTemplate(experimentid, filename) ExperimentService.updateExperimentTamplate(experimentid, templateid) return HttpResponse( "<script>if(confirm('上传成功')){history.go(-1);location.reload()}else{history.go(-1);location.reload()}</script>" )
def delFilterInfo(request): adminid = utils.getCookie(request, "adminid") if adminid == "" or adminid is None: responseReturn = Response(-2, "请登录") return HttpResponse(responseReturn.__str__()) filterid = utils.getParam(request, "filterid") if filterid == "" or filterid is None: responseReturn = Response(-1, "请选择一个班级") return HttpResponse(responseReturn.__str__()) filterinfo = FilterInfoService.getFilterInfoById(filterid) if filterinfo is None: responseReturn = Response(-1, "此班级不存在~") return HttpResponse(responseReturn.__str__()) count = StudentService.getCountStudentByFilterInfo(filterid) if count > 0: responseReturn = Response(-1, "该班级下还有同学,不能删除哦~") return HttpResponse(responseReturn.__str__()) filterdelinfo = FilterInfoService.delFilterInfo(filterid) if filterdelinfo is None: responseReturn = Response(-1, "删除失败,请重试!") return HttpResponse(responseReturn.__str__()) responseReturn = Response(None, None) return HttpResponse(responseReturn.__str__())
def addFilterInfo(request): adminid = utils.getCookie(request, "adminid") if adminid == "" or adminid is None: responseReturn = Response(-2, "请登录") return HttpResponse(responseReturn.__str__()) registyear = utils.getParam(request, "registyear") major = utils.getParam(request, "major") classname = utils.getParam(request, "classname") if registyear is None or registyear == "": responseReturn = Response(-1, "请输入入学年份~") return HttpResponse(responseReturn.__str__()) if major is None or major == "": responseReturn = Response(-1, "请输入专业~") return HttpResponse(responseReturn.__str__()) if classname is None or classname == "": responseReturn = Response(-1, "请输入班级~") return HttpResponse(responseReturn.__str__()) filterinfo = FilterInfoService.getFilterInfo(registyear, major, classname) if filterinfo is None: filterinfoid = FilterInfoService.addFilterInfo(registyear, major, classname) responseReturn = Response(None, None) return HttpResponse(responseReturn.__str__()) else: responseReturn = Response(-1, "已有此班级,请重新输入~") return HttpResponse(responseReturn.__str__())
def getStudentByFilterInfoId(request): teacherid = utils.getCookie(request, "teacherid") if (teacherid is None) or teacherid == "": responseReturn = Response(-2, "请登录") return HttpResponse(responseReturn.__str__()) filterid = utils.getParam(request, "filterid") if (filterid == "" or filterid is None): responseReturn = Response(-1, "请选择班级!") return HttpResponse(responseReturn.__str__()) filterinfo = FilterInfoService.getFilterInfoById(filterid) if filterinfo is None: responseReturn = Response(-1, "班级不存在!") return HttpResponse(responseReturn.__str__()) studentList = StudentService.getStudentListByFilterInfo(filterid) if studentList is None: responseReturn = Response(-1, "此班级没有学生!") return HttpResponse(responseReturn.__str__()) studentDictList = [] for student in studentList: dict = model_to_dict(student) del dict["isdelete"] del dict["createtime"] del dict["updatetime"] dict["registyear"] = filterinfo.registyear dict["major"] = filterinfo.major dict["classname"] = filterinfo.classname studentDictList.append(dict) studentDictListStr = json.dumps(studentDictList, ensure_ascii=False) responseReturn = Response(None, None) responseReturn.setRes(studentDictListStr) return HttpResponse(responseReturn.__str__())
def getListTemplate(request): adminid = utils.getCookie(request, "adminid") if adminid == "" or adminid is None: return getloginResponse(request) type = utils.getParam(request, "type") if type is None or type == "": responseReturn = Response("-1", "!") return HttpResponse(responseReturn.__str__()) templateaddr = "" filename = "" if type == CONSTANTS.ADD_USER_TYPE_STUDENT: templateaddr = CONSTANTS.ADDUSERTEMPLATEURL_PRE + "student.xlsx" filename = "学生名单模板" elif type == CONSTANTS.ADD_USER_TYPE_TEACHER: templateaddr = CONSTANTS.ADDUSERTEMPLATEURL_PRE + "teacher.xlsx" filename = "教师名单模板" elif type == CONSTANTS.ADD_USER_TYPE_ADMIN: templateaddr = CONSTANTS.ADDUSERTEMPLATEURL_PRE + "admin.xlsx" filename = "管理员名单模板" if os.path.exists(templateaddr) != True: return HttpResponse("未找到文件") file = open(templateaddr, "rb") response = FileResponse(file) response['Content-Type'] = 'application/octet-stream' response['Content-Disposition'] = 'attachment;filename="%s"' % ( urlquote(filename + '.xlsx')) return response
def deleteTeachingByid(request): teacherid = utils.getCookie(request, "teacherid") if (teacherid is None) or teacherid == "": responseReturn = Response(-2, "请登录") return HttpResponse(responseReturn.__str__()) teachingid = utils.getParam(request, "teachingid") TeachingService.deleteTeachingByid(teachingid) responseReturn = Response(None, None) return HttpResponse(responseReturn.__str__())
def resetTeacherPwd(request): adminid = utils.getCookie(request, "adminid") if adminid == "" or adminid is None: responseReturn = Response(-2, "请登录") return HttpResponse(responseReturn.__str__()) teacherid = utils.getParam(request, "teacherid") TeacherService.resetPassword(teacherid) responseReturn = Response(None, None) return HttpResponse(responseReturn.__str__())
def deleteStudentByid(request): adminid = utils.getCookie(request, "adminid") if adminid == "" or adminid is None: responseReturn = Response(-2, "请登录") return HttpResponse(responseReturn.__str__()) stuid = utils.getParam(request, "studentid") StudentService.deleteStudent(stuid) responseReturn = Response(None, None) return HttpResponse(responseReturn.__str__())
def v_teachermanagement(request): adminid = utils.getCookie(request, "adminid") if adminid == "" or adminid is None: return getloginResponse(request) issuperadmin = utils.getCookie(request, "issuperadmin") teachernum = utils.getParam(request, "searchnum") teachername = utils.getParam(request, "searchname") adminname = utils.getCookie(request, "adminname") page = utils.getParam(request, "page") if (page is None) or page == "": page = 1 else: page = int(page) if (teachernum == "" or teachernum is None) and (teachername == "" or teachername is None): count = TeacherService.getCountTeacher(None, None) countpage = 0 i = 0 if count > 0: if count % 10 > 0: i = 1 countpage = count / 10 + i teacherList = TeacherService.getTeacherByPage(None, None, page) else: count = TeacherService.getCountTeacher(teachername, teachernum) countpage = 0 i = 0 if count > 0: if count % 10 > 0: i = 1 countpage = count / 10 + i teacherList = TeacherService.getTeacherByPage(teachername, teachernum, page) return render( request, "teachermanagement.html", { "teacherList": teacherList, "issuperadmin": issuperadmin, "stunum": teachernum, "countpage": countpage, "searchname": teachername, "adminname": adminname })
def v_allexperiment(request): stuid = utils.getCookie(request, "stuid") if (stuid is None) or stuid == "": return getloginResponse(request) stuname = utils.getCookie(request, "stuname") teachingCount = getTeachingCount(stuid) experimentList = ExperimentService.getAllExperiment() # 获取用于菜单的实验列表 experimentMenuList = [] for experiment in experimentList: experimentTemp = experiment.copy() experimentName = experimentTemp["name"] if len(experimentName) > 8: experimentName = experimentName[0:10] + "..." experimentTemp["name"] = experimentName experimentMenuList.append(experimentTemp) return render(request, "allexp.html", {"experimentList": experimentList, "experimentMenuList": experimentMenuList, "teachingCount": teachingCount, "stuname": stuname})
def updateTeachingDeadline(request): teacherid = utils.getCookie(request, "teacherid") if (teacherid is None) or teacherid == "": responseReturn = Response(-2, "请登录") return HttpResponse(responseReturn.__str__()) teachingid = utils.getParam(request, "teachingid") deadlinestr = utils.getParam(request, "deadline") + " 00:00:00" deadline = datetime.datetime.strptime(deadlinestr, "%Y-%m-%d %H:%M:%S") TeachingService.updateTeachingDeadlineById(teachingid, deadline) responseReturn = Response(None, None) return HttpResponse(responseReturn.__str__())
def deleteAdminByid(request): adminid = utils.getCookie(request, "adminid") if adminid == "" or adminid is None: responseReturn = Response(-2, "请登录") return HttpResponse(responseReturn.__str__()) issuperadmin = utils.getCookie(request, "issuperadmin") if issuperadmin != "1" or issuperadmin is None: responseReturn = Response("-1", "您不是超级管理员,没有删除管理员的权限!") return HttpResponse(responseReturn.__str__()) deleteadminid = utils.getParam(request, "adminid") deleteAdmin = AdminService.getAdminById(deleteadminid) count = TeachingService.getCountByTea(deleteAdmin.teacherid) if count > 0: responseReturn = Response("-1", "该教师下有未删除的实验教学") return HttpResponse(responseReturn.__str__()) admin = AdminService.deleteAmin(deleteadminid) if admin is None: responseReturn = Response("-1", "删除失败!") return HttpResponse(responseReturn.__str__()) responseReturn = Response(None, None) return HttpResponse(responseReturn.__str__())
def deleteTeacherByid(request): adminid = utils.getCookie(request, "adminid") if adminid == "" or adminid is None: responseReturn = Response(-2, "请登录") return HttpResponse(responseReturn.__str__()) teacherid = utils.getParam(request, "teacherid") count = TeachingService.getCountByTea(teacherid) if count > 0: responseReturn = Response("-1", "该教师下有未删除的实验教学") return HttpResponse(responseReturn.__str__()) TeacherService.deleteTeacher(teacherid) responseReturn = Response(None, None) return HttpResponse(responseReturn.__str__())
def v_adduser(request): adminid = utils.getCookie(request, "adminid") if adminid == "" or adminid is None: return getloginResponse(request) issuperadmin = utils.getCookie(request, "issuperadmin") adminname = utils.getCookie(request, "adminname") filterInfoList = FilterInfoService.getFilterInfoList(None) filterInfoDictList = [] for filterinfo in filterInfoList: dict = model_to_dict(filterinfo) del dict["isdelete"] del dict["createtime"] del dict["updatetime"] filterInfoDictList.append(dict) filterInfoListstr = json.dumps(filterInfoDictList, ensure_ascii=False) return render( request, "adduser.html", { "issuperadmin": issuperadmin, "adminname": adminname, "filterInfoList": filterInfoList, "filterInfoListstr": filterInfoListstr })
def addBatchAdmin(request): adminid = utils.getCookie(request, "adminid") if adminid == "" or adminid is None: return getloginResponse(request) file = request.FILES.get('file', None) if file is None: return HttpResponse( "<script>if(confirm('请选择你要上传的管理员名单!')){history.go(-1);location.reload()}else{history.go(-1);location.reload()}</script>" ) adminfilename = file.name adminlistfilesuffix = os.path.splitext(adminfilename)[1] if adminlistfilesuffix != ".xsl" and adminlistfilesuffix != ".xlsx": return HttpResponse( "<script>if(confirm('管理员名单必须为excel格式!')){history.go(-1);location.reload()}else{history.go(-1);location.reload()}</script>" ) adminfilename = str(uuid.uuid1()) + adminlistfilesuffix fp = open(os.path.join(CONSTANTS.STUDENTLISTURL_PRE + adminfilename), 'wb+') for chunk in file.chunks(): # 分块写入文件 fp.write(chunk) fp.close() adminlist = getAdminListByExcel(adminfilename) for admin in adminlist: teacher = TeacherService.getTeacherByNumber(admin["number"]) teachername = admin["name"] teachernum = admin["number"] if teacher is None: teacherid = TeacherService.addTeacher(teachername, teachernum) teacher = TeacherService.getTeacherById(teacherid) if teacher.name != admin["name"]: return HttpResponse( "<script>if(confirm('教师姓名" + admin["name"] + "与教师编号" + admin["number"] + "不符,请确认!')){history.go(-1);location.reload()}else{history.go(-1);location.reload()}</script>" ) adminobj = AdminService.getAdminByTeacherId(teacher.id) if adminobj is not None: return HttpResponse( "<script>if(confirm('此教师" + admin["number"] + "已经设置过管理员!')){history.go(-1);location.reload()}else{history.go(-1);location.reload()}</script>" ) adminid = AdminService.addAdmin(teacher.id) return HttpResponse( "<script>if(confirm('添加成功!')){history.go(-1);location.reload()}else{history.go(-1);location.reload()}</script>" )
def v_addexp(request): teacherid = utils.getCookie(request, "teacherid") if (teacherid is None) or teacherid == "": return getloginResponse(request) teachername = utils.getCookie(request, "teachername") teachingCount = getTeachingCount(teacherid) experimentList = ExperimentService.getAllExperiment() # 获取用于菜单的实验列表 experimentMenuList = [] for experiment in experimentList: experimentTemp = experiment.copy() experimentName = experimentTemp["name"] if len(experimentName) > 8: experimentName = experimentName[0:10] + "..." experimentTemp["name"] = experimentName experimentMenuList.append(experimentTemp) filterInfoList = FilterInfoService.getFilterInfoList(None) filterInfoDictList = [] for filterinfo in filterInfoList: dict = model_to_dict(filterinfo) del dict["isdelete"] del dict["createtime"] del dict["updatetime"] filterInfoDictList.append(dict) filterInfoListstr = json.dumps(filterInfoDictList, ensure_ascii=False) response = render( request, "addexp.html", { "teachingCount": teachingCount, "experimentList": experimentList, "experimentMenuList": experimentMenuList, "teachername": teachername, "filterInfoListstr": filterInfoListstr }) return response
def scoreReport(request): teacherid = utils.getCookie(request, "teacherid") if (teacherid is None) or teacherid == "": responseReturn = Response(-2, "请登录") return HttpResponse(responseReturn.__str__()) reportid = utils.getParam(request, "reportid") scorestr = utils.getParam(request, "score") if scorestr == "" or scorestr == "0": responseReturn = Response(-1, "打分异常") response = HttpResponse(responseReturn.__str__()) return response score = int(scorestr) ReportService.scoreReport(reportid, score) responseReturn = Response(None, None) return HttpResponse(responseReturn.__str__())
def updateTeachingVideo(request): teacherid = utils.getCookie(request, "teacherid") if (teacherid is None) or teacherid == "": responseReturn = Response(-2, "请登录") return HttpResponse(responseReturn.__str__()) teachingid = utils.getParam(request, "teachingid") videos = utils.getParam(request, "videos") if teachingid == "" or teachingid is None: responseReturn = Response(-1, "操作有误,请重试") return HttpResponse(responseReturn.__str__()) if videos == "" or videos is None: responseReturn = Response(-1, "更换的视频不能为空") return HttpResponse(responseReturn.__str__()) TeachingService.updateTeachingVideoById(teachingid, videos) responseReturn = Response(None, None) return HttpResponse(responseReturn.__str__())
def addTeacher(request): adminid = utils.getCookie(request, "adminid") if adminid == "" or adminid is None: responseReturn = Response(-2, "请登录") return HttpResponse(responseReturn.__str__()) teachernum = utils.getParam(request, "teachernum") teachername = utils.getParam(request, "teachername") if (teachername == "" or teachernum == ""): responseReturn = Response("-1", "填写的信息不能为空!") return HttpResponse(responseReturn.__str__()) teacher = TeacherService.getTeacherByNumber(teachernum) if teacher is not None: responseReturn = Response("-1", "此教师已经存在!") return HttpResponse(responseReturn.__str__()) TeacherService.addTeacher(teachername, teachernum) responseReturn = Response(None, None) return HttpResponse(responseReturn.__str__())
def addStudent(request): adminid = utils.getCookie(request, "adminid") if adminid == "" or adminid is None: responseReturn = Response(-2, "请登录") return HttpResponse(responseReturn.__str__()) studentnum = utils.getParam(request, "studentnum") studentname = utils.getParam(request, "studentname") filterinfoid = utils.getParam(request, "filterinfoid") if (studentname == "" or studentnum == "" or filterinfoid == ""): responseReturn = Response("-1", "填写的信息不能为空!") return HttpResponse(responseReturn.__str__()) student = StudentService.getStudentByNum(studentnum) if student is not None: responseReturn = Response("-1", "此学生已经存在!") return HttpResponse(responseReturn.__str__()) StudentService.addStudent(studentname, studentnum, filterinfoid) responseReturn = Response(None, None) return HttpResponse(responseReturn.__str__())
def getStudentListByExcel(filename): teacherid = utils.getCookie(request, "teacherid") if (teacherid is None) or teacherid == "": responseReturn = Response(-2, "请登录") return HttpResponse(responseReturn.__str__()) studentlist = [] book = xlrd.open_workbook(CONSTANTS.STUDENTLISTURL_PRE + filename) sheet0 = book.sheet_by_index(0) nrows = sheet0.nrows # 获取行总数 for i in range(nrows): if i == 0: continue row_data = sheet0.row_values(i) student = { "name": sheet0.cell_value(i, 0), "number": str(int(sheet0.cell_value(i, 1))), } studentlist.append(student) return studentlist