def deletestudent(request): nid = request.GET.get('nid') sqlhepr = SqlHeper() sqlhepr.delete_data("delete from students where id=%s", [ nid, ]) sqlhepr.commit_data() return redirect('/students/')
def deleteclass(request): nid = request.GET.get('nid') sqlhepr = SqlHeper() sqlhepr.delete_data("delete from classes where id=%s", [ nid, ]) sqlhepr.commit_data() sqlhepr.close_data() return redirect('/classes/')
def modal_deleteclass(request): sqlhepr = SqlHeper() nid = request.POST.get('nid') sqlhepr.delete_data("delete from classes where id=%s", [ nid, ]) sqlhepr.commit_data() sqlhepr.close_data() data = {} data['status'] = 'success' return JsonResponse(data)
def editor_tearch(request): sqlhepr = SqlHeper() context = {} if request.method == 'POST': t_id = request.GET.get('t_id') #的到的是字符串 t2c_id = request.POST.get('t_c_ids') # 转化为列表 import re compile = re.compile('\d+') t2c_id = compile.findall(t2c_id) editor_class_ids = request.POST.getlist('editor_class_ids') t_name = request.POST.get('t_name') t_c = list(map(lambda x: (t_id, x), editor_class_ids)) sqlhepr.updata_data("update tearchs set tname=%s where id=%s", [t_name, t_id]) for i in t2c_id: sqlhepr.delete_data("delete from tearch2class where id=%s ", [i]) sqlhepr.commit_data() sqlhepr.updata_many_data( "insert into tearch2class (tearch_id,class_id)value(%s,%s)", t_c) sqlhepr.commit_data() sqlhepr.close_data() return redirect('/tearchs/') else: tid = request.GET.get('tid') tearch_name = sqlhepr.select_one_data( "select tname from tearchs where id=%s ", [tid]) current_class_list = sqlhepr.select_all_data( "select id ,class_id from tearch2class where tearch_id=%s", [tid]) tearch_class_ids = list(map(lambda x: x['id'], current_class_list)) current_class_ids = list( map(lambda x: x.get('class_id'), current_class_list)) class_list = sqlhepr.select_all_data("select id,title from classes ", []) sqlhepr.close_data() context['tearch_name'] = tearch_name context['current_class_ids'] = current_class_ids context['class_list'] = class_list context['tearch_class_ids'] = tearch_class_ids context['t_id'] = tid return render(request, 'editor_tearch.html', context)