def modal_add_class(request):
title = request.POST.get('title')
if len(title) > 0:
sqlheper.modify('insert into class(title) values(%s)', [title, ])
return HttpResponse('ok')
else:
return HttpResponse('班级标题不能为空')
def modal_add_student(request):
ret = {'status':True,'message':None}
try:
name = request.POST.get('name')
class_id = request.POST.get('class_id')
sqlheper.modify('insert into student(name,class_id) values(%s,%s)', [name, class_id, ])
except Exception as e:
ret['status'] = False
ret['message'] = str(e)
return HttpResponse(json.dumps(ret))
def modal_edit_student(request):
ret = {'status':True,'message':None}
try:
nid = request.POST.get('nid')
name = request.POST.get('name')
class_id = request.POST.get('class_id')
sqlheper.modify('update student set name=%s,class_id=%s where id=%s', [name, class_id, nid, ])
except Exception as e:
ret['status'] = False
ret['message'] = str(e)
return HttpResponse(json.dumps(ret))
def modal_edit_class(request):
ret = {'status' : True, 'message': None}
try:
nid = request.POST.get('nid')
content = request.POST.get('content')
sqlheper.modify('update class set title=%s where id=%s', [content, nid, ])
except Exception as e:
ret['status'] = False
ret['message'] = "处理异常"
return HttpResponse(json.dumps(ret))
def edit_student(request):
if request.method == "GET":
nid = request.GET.get('nid')
class_list = sqlheper.get_list("select id,title from class", [])
current_student_info = sqlheper.get_one('select id,name,class_id from student where id=%s', [nid, ])
return render(request, "edit_student.html",{'class_list':class_list,'current_student_info':current_student_info})
else:
nid = request.GET.get('nid')
name = request.POST.get('name')
class_id = request.POST.get('class_id')
sqlheper.modify('update student set name=%s,class_id=%s where id=%s', [name, class_id, nid])
return redirect('/students/')
def del_student(request):
nid = request.GET.get('nid')
sqlheper.modify('delete from student where id=%s', [nid, ])
return redirect('/students/')