def dept_add(request): """ 添加部门 :param request: :return: """ if request.method == 'GET': # 展示所有部门名称,用于显示上级部门下拉选择框 departments = Department.objects.filter(is_delete=0) return render(request, 'dept/deptAdd.html', {'departments': departments}) if request.method == 'POST': msg = { 'code': 0, 'msg': '请求成功' } data = request.POST.dict() # 获取部门编号 d_id = data.get('d_id') # 查询是否已存在此部门 department = Department.objects.filter(d_id=d_id) # 如果存在, 则更改部门信息 if department: department = department.first() else: # 不存在此部门,则新增一个部门 department = Department() # 保存部门信息 department.department = data.get('department') department.department_num = data.get('department_num') department.higher_id = data.get('higher_id') department.description = data.get('description') department.save() return JsonResponse(msg)
def import_data(request): rb = xlrd.open_workbook('D:\pydata\prepod_goda.xlsx') sheet = rb.sheet_by_index(0) ins = Institute.objects.all()[0] n = sheet.nrows s = 'sdads' for rownum in range(sheet.nrows): row = sheet.row_values(rownum) d = row[0].strip() t = row[1].strip() g = row[2].strip() dep = Department() tech = Teacher() group = Group() db_d = Department.objects.filter(name=d) if (db_d.count() == 0): dep.name = d dep.institute = ins dep.save() else: dep = db_d[0] db_t = Teacher.objects.filter(last_name=t) if (db_t.count() == 0): tech.last_name = t tech.department = dep tech.save() else: tech = db_t[0] db_g = Group.objects.filter(name=g) if (db_g.count() == 0): group.name = g group.department = dep group.save() else: group = db_g[0] group.teachers.add(tech) group.save() return HttpResponse("OK " + s)
from app.models import Department, Person, Project, ProjectGrp, TaskTime, ProjectType # using unicode as the password coding yun_hua = User(username='******', email='*****@*****.**', password=make_password('hello')) yonghua_xu = User(username='******', email='*****@*****.**', password=make_password('hello')) yinye_fan = User(username='******', email='*****@*****.**', password=make_password('hello')) admin = User(username='******', email='*****@*****.**', password=make_password('hello')) yun_hua.save() yonghua_xu.save() yinye_fan.save() admin.save() # yun_hua = User.objects.get(username='******') engineering = Department(dept_id=600800, name='技术工程部', summary='Engineering') engineering.save() admin_dept = Department(dept_id=600310, name='行政部', summary='Admin') admin_dept.save() # engineering = Department.objects.get(dept_id='600800') person1 = Person(user=yun_hua, employee_id=149, privilege=1, department=engineering) person1.save() person2 = Person(user=yonghua_xu, employee_id=61, privilege=1, department=engineering) person2.save() person3 = Person(user=yinye_fan, employee_id=99, privilege=1, department=engineering) person3.save() person_admin = Person(user=admin, employee_id=0, privilege=1, department=engineering) person_admin.save() type1 = ProjectType(typename='FA', summary='客户项目')