def del_class(request, args):
obj = SqlHeper()
#nid = request.GET.get('nid')
nid = args[0]
print(nid)
obj.modify("delete from classes where id=%s", nid)
return redirect('/classes/')
def modal_add_class(request):
obj = SqlHeper()
title = request.POST.get('title')
if len(title):
obj.modify('insert into classes(title) value(%s)', [title])
return HttpResponse('OK')
else:
return HttpResponse('标题不能为空')
def add_class(request):
obj = SqlHeper()
if request.method == 'GET':
return render(request, 'add_class.html')
else:
v = request.POST.get('title')
if len(v) > 0:
obj.modify("insert into classes(title) value(%s)", v)
return redirect('/classes/')
else:
return render(request, 'add_class.html', {'msg': '班级名称不能为空'})
def add_student(request):
obj = SqlHeper()
if request.method == 'GET':
class_list = obj.get_list("select id,title from classes")
return render(request, 'add_student.html', {'class_list': class_list})
else:
name = request.POST.get('name')
title = request.POST.get('class_id')
obj.modify("insert into student(name,class_id) value(%s,%s)",
[name, title])
return redirect('/student/')
def modal_add_student(request):
obj = SqlHeper()
ret = {'status': True, 'msg': None}
try:
name = request.POST.get('name')
class_id = request.POST.get('class_id')
obj.modify('insert into student(name,class_id) value(%s,%s)',
[name, class_id])
except Exception as e:
ret['status'] = False
ret['msg'] = str(e)
import json
return HttpResponse(json.dumps(ret))
def modal_edit_student(request):
obj = SqlHeper()
ret = {'status': True, 'msg': None}
try:
name = request.POST.get('name')
id = request.POST.get('id')
class_id = request.POST.get('class_id')
obj.modify('update student set name=%s,class_id=%s where id=%s',
[name, class_id, id])
except Exception as e:
ret['status'] = False
ret['msg'] = str(e)
import json
ret = json.dumps(ret)
return HttpResponse(ret)
def edit_teacher(request):
if request.method == 'GET':
nid = request.GET.get('tid')
name = request.POST.get('name')
obj = SqlHeper()
teacher_info = obj.get_one('select id,name from teacher where id=%s', [
nid,
])
class_list = obj.get_list('select id,title from classes')
class_id_list = obj.get_list(
'select class_id from teacher2class where teacher_id=%s', [
nid,
])
lst = []
for item in class_id_list:
lst.append(item['class_id'])
class_id_list = lst
return render(
request, 'edit_teacher.html', {
'teacher_info': teacher_info,
'class_list': class_list,
'class_id_list': class_id_list,
'tid': nid
})
else:
nid = request.GET.get('nid')
name = request.POST.get('name')
class_id_list = request.POST.getlist('clsid')
obj = SqlHeper()
obj.modify('update teacher set name=%s where id=%s', [name, nid])
print(nid)
obj.modify('delete from teacher2class where teacher_id=%s', [
nid,
])
lst = []
for cls in class_id_list:
lst.append((nid, cls))
obj.multiple_modify(
'insert into teacher2class(teacher_id,class_id) value(%s,%s)', lst)
obj.close()
return redirect('/teacher/')
def modal_edit_class(request):
obj = SqlHeper()
ret = {'status': True, 'msg': None}
try:
nid = request.POST.get('nid')
title = request.POST.get('title')
obj.modify('update classes set title=%s where id=%s', [
title,
nid,
])
except Exception as e:
ret['status'] = False
ret['msg'] = str(e)
finally:
import json
return HttpResponse(json.dumps(ret))
def edit_class(request, *args):
obj = SqlHeper()
if request.method == 'GET':
#nid = request.GET.get('nid')
nid = args[0]
result = obj.get_one("select id,title from classes where id=%s", [nid])
title = result['title']
return render(request, "edit_class.html", {'nid': nid, 'title': title})
else:
#nid = request.POST.get('nid')
nid = args[0]
title = request.POST.get('title')
obj.modify("update classes set title=%s where id=%s", [
title,
nid,
])
return redirect('/classes/')
def edit_student(request):
obj = SqlHeper()
if request.method == 'GET':
nid = request.GET.get('nid')
sql = 'select id,title from classes'
class_list = obj.get_list(sql)
sql = 'select id,name,class_id from student where id=%s'
result = obj.get_list(sql, [
nid,
], all=False)
return render(request, "edit_student.html", {
'class_list': class_list,
'student_info': result
})
else:
nid = request.GET.get('nid')
name = request.POST.get('name')
class_id = request.POST.get('class_id')
sql = 'update student set name=%s,class_Id=%s where id=%s'
obj.modify(sql, [name, class_id, nid])
return redirect('/student/')
def del_teacher(request):
obj = SqlHeper()
nid = request.GET.get('nid')
obj.modify('delete from teacher where id = %s', nid)
return redirect(('/teacher/'))
