def client_add_project(request, cid):
    form = ProjectForm()
    client = get_object_or_404(Client, cid=cid)
    bc_list = BusinessContact.objects.filter(cid=client)    #获取客户方所有业务联系人
    result = {}
    if request.method == "POST":
        pname = request.POST.get('pname')
        pm = request.POST.get('pm')
        person_in_charge = request.POST.get('person_in_charge')
        pcreatetime = request.POST.get('pcreatetime')
        pdeadline = request.POST.get('pdeadline')
        premark = request.POST.get('premark')

        project = Project.objects.filter(pname=pname, cid=client)    #同一个客户不可添加同名项目
        if project.exists() == 0:
            # 不存在名字为pname的项目,则可添加一个名字为pname的新项目
            new_project = Project()
            new_project.cid = client
            new_project.pname = pname
            new_project.cname = client.cname
            new_project.pm = pm
            new_project.person_in_charge = person_in_charge
            new_project.pcreatetime = pcreatetime
            new_project.pdeadline = pdeadline
            new_project.premark = premark
            new_project.save()
            result['status'] = 'success'
            myurl = "/clients/{cid}/detail".format(cid=cid)
            #print(new_project)
            #myurl = "http://47.94.224.242:1973/clients/{cid}/detail".format(cid=cid)
            return HttpResponseRedirect(myurl)

        else:
            #print("!!!!!!!!!!!This project already existed!!!!!!!!")
            result['status'] = 'error'
    else:
        #print("!!!!!!!!!!!GET!!!!!!!!")
        pass
    return render(request, 'clients/client_add_project.html', {'bc_list':bc_list,'form': form,'client':client,'result':result})
def addProjectToDatabase(request):
    if request.method == "POST":
        pname = request.POST.get('pname')
        pm = request.POST.get('pm')
        pdeadline = request.POST.get('pdeadline')
        pcreatetime = request.POST.get('pcreatetime')
        premark = request.POST.get('premark')
        person_in_charge = request.POST.get('person_in_charge')
        pdetail = request.POST.get('pdetail')
        cid_num = request.POST.get('cid')
        try:
            client = Client.objects.get(cid=cid_num)
        except:
            return HttpResponseRedirect('/project_info_list/')
        else:
            # filter得到的是一个list,而不是一个object
            project = Project.objects.filter(pname=pname, cid=client)
            if project.exists() == 0:
                cid = client
                new_project = Project()
                new_project.cid = cid
                new_project.pname = pname
                new_project.pm = pm
                new_project.pdeadline = pdeadline
                new_project.pcreatetime = pcreatetime
                new_project.premark = premark
                new_project.pdetail = pdetail
                new_project.person_in_charge = person_in_charge
                new_project.save()

            else:
                print("!!!!!!!!!!!This project already existed!!!!!!!!")

    else:
        print("!!!!!!!!!!!GET!!!!!!!!")

    # 重定向
    return HttpResponseRedirect('/project_info_list/')