def case_add(request): if request.method == 'POST': case_name = request.POST['case_name'] prj_id = request.POST['prj_id'] project = Project.objects.get(prj_id=prj_id) description = request.POST['description'] content = request.POST['content'] case = Case(case_name=case_name, project=project, description=description, content=content) case.save() return HttpResponseRedirect("/base/case/") prj_list = Project.objects.all() return render(request, "base/case/add.html", {"prj_list": prj_list})
def case_update(request): if request.method == 'POST': raw_data = request.POST.getlist('excelData') prj_id = request.POST.getlist('prj_id') raw_delete = request.POST.getlist('deleteList') raw_merge = request.POST.getlist('mergeList') raw_unmerge = request.POST.getlist('unmergeList') for data in raw_data: case_list = data.split(",") if case_list[13] == u'': case = Case(case_sort=int(case_list[0]), case_locate=case_list[1], case_name=case_list[2], case_pre=case_list[3], case_type=case_list[4], case_func=case_list[5], case_expect=case_list[6], case_result=case_list[7], case_level=case_list[8], case_creator=case_list[9], case_executor=case_list[10], case_time=case_list[11], case_content=case_list[12], project_id=int(prj_id[0])) case.save() else: Case.objects.filter(case_id=int(case_list[13])).update( case_sort=int(case_list[0]), case_locate=case_list[1], case_name=case_list[2], case_pre=case_list[3], case_type=case_list[4], case_func=case_list[5], case_expect=case_list[6], case_result=case_list[7], case_level=case_list[8], case_creator=case_list[9], case_executor=case_list[10], case_time=case_list[11], case_content=case_list[12], project_id=int(prj_id[0])) #Case.objects.filter(case_id=case_id).update(case_name=case_name,case_pre=case_pre,case_type=case_type,case_func=case_func,case_expect=case_expect,case_result=case_result,case_level=case_level,case_creator=case_creator,case_executor=case_executor,case_time=case_time,case_content=case_content) if len(raw_delete) > 0: for item in raw_delete: delete_list = item.split(",") if delete_list[13] == u'': pass else: Case.objects.filter(case_id=int(delete_list[13])).delete() if len(raw_merge) > 0: for temp_merge in json.loads(raw_merge[0]): merge = Merge(cell_range=temp_merge, project_id=int(prj_id[0])) merge.save() if len(raw_unmerge) > 0: for temp_unmerge in json.loads(raw_unmerge[0]): Merge.objects.filter(project_id=int(prj_id[0])).filter( cell_range=temp_unmerge).delete() return HttpResponseRedirect(("/base/case/?prj_id=%s") % prj_id[0])