コード例 #1
0
def enquiryResult(request, model_name):
    '''
    没有被调用
    '''
    enq=Enquiry(str(model_name))
    cpcd={
              ">":"__gt",
              ">=":"__gte",
              "<":"__lt",
              "<=":"__lte",
              "=":"__exact",
              "contains":"__contains",
              "in":"__in",
              "isnull":"__isnull",                            
        }
    where={}
    if request.method=="POST":
        if request.POST.has_key("lstWhere"):
            tstr=request.POST.get("lstWhere")
         
        if request.POST.has_key("lstWhere"):
            tstr=request.POST.get("lstWhere")
            tmp=tstr.split("\n")           
            
            for x in tmp[0:len(tmp)-1]:
                val=x.split()
                lk=val[0].encode("ascii")
                rk=val[1].encode("ascii")
                if len(val)>2:
                    va=val[2].encode("ascii")
                else:
                    va=""
                if va.find(",")>0:
                    va=va.split(",")
                if rk=="isnull":
                    va=True
                    
                where[lk+cpcd[rk]]=va               
        table=str(model_name)
        n=enq.Search(table,**where)       
      
        c = Context({
        'values': n
        })
        if len(n)>0:
            return HttpResponse("sucess")
        else:
            return HttpResponse("fail")
    else:
        return HttpResponse("fail")
コード例 #2
0
def enquiryResult(request, model_name):
    #p = get_object_or_404(Poll, pk=poll_id)
    #return render_to_response('polls/detail.html', {'poll': p})

    enq = Enquiry(str(model_name))

    #tt=enq.Search(poll_id)
    #return render_to_response(tt)
    cpcd = {
        ">": "__gt",
        ">=": "__gte",
        "<": "__lt",
        "<=": "__lte",
        "=": "__exact",
        "contains": "__contains",
        "in": "__in",
        "isnull": "__isnull",
    }
    where = {}
    if request.method == "POST":
        #print request.POST.items()
        if request.POST.has_key("lstWhere"):
            tstr = request.POST.get("lstWhere")

        if request.POST.has_key("lstWhere"):
            tstr = request.POST.get("lstWhere")
            tmp = tstr.split("\n")

            for x in tmp[0:len(tmp) - 1]:
                val = x.split()
                lk = val[0].encode("ascii")
                rk = val[1].encode("ascii")
                if len(val) > 2:
                    va = val[2].encode("ascii")
                else:
                    va = ""
                if va.find(",") > 0:
                    va = va.split(",")
                if rk == "isnull":
                    va = True

                where[lk + cpcd[rk]] = va

        #print where
    # t = loader.get_template('polls/return.html')

    #return HttpResponse(t.render(c))\

        table = str(model_name)
        n = enq.Search(table, **where)

        c = Context({'values': n})
        #print 'N:',n

        #print getJSResponse(smart_str(n))
        #b={header:["colum1","column2"],data:[["1","1"],["2","2"],["3","3"]]}
        #n=enq.objListToJsonObj()
        #print n
        #return getJSResponse(smart_str(simplejson.dumps(n)))
        if len(n) > 0:
            return HttpResponse("sucess")
        else:
            return HttpResponse("fail")
        #return HttpResponse(t.render(c))
        #return HttpResponse("ab")
    else:
        #return HttpResponse(request)
        return HttpResponse("fail")