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/'))