Examples of QueryObject


Examples of com.cordys.cpc.bsf.busobject.QueryObject

    }

    public static BusObjectIterator<com.cordys.demo.servicedesk.dao.SOLUTIONS> getSolutionsObjects(int fromSOLUTIONID, int toSOLUTIONID, com.cordys.cpc.bsf.query.Cursor cursor)
    {
        String queryText = "select * from \"SOLUTIONS\" where \"SOLUTIONID\" between :fromSOLUTIONID and :toSOLUTIONID";
        QueryObject query = new QueryObject(queryText);
        query.addParameter("fromSOLUTIONID", "SOLUTIONS.SOLUTIONID", QueryObject.PARAM_INT, new Integer(fromSOLUTIONID));
        query.addParameter("toSOLUTIONID", "SOLUTIONS.SOLUTIONID", QueryObject.PARAM_INT, new Integer(toSOLUTIONID));
        query.setResultClass(SOLUTIONS.class);
        query.setCursor(cursor);
        return query.getObjects();
    }
View Full Code Here

Examples of com.cordys.cpc.bsf.busobject.QueryObject

    }

    public static BusObjectIterator<com.cordys.demo.servicedesk.dao.SOLUTIONS> getSolutionsObjects(int fromSOLUTIONID, int toSOLUTIONID)
    {
        String queryText = "select * from \"SOLUTIONS\" where \"SOLUTIONID\" between :fromSOLUTIONID and :toSOLUTIONID";
        QueryObject query = new QueryObject(queryText);
        query.addParameter("fromSOLUTIONID", "SOLUTIONS.SOLUTIONID", QueryObject.PARAM_INT, new Integer(fromSOLUTIONID));
        query.addParameter("toSOLUTIONID", "SOLUTIONS.SOLUTIONID", QueryObject.PARAM_INT, new Integer(toSOLUTIONID));
        query.setResultClass(SOLUTIONS.class);
        return query.getObjects();
    }
View Full Code Here

Examples of com.cordys.cpc.bsf.busobject.QueryObject

    }
    public static com.cordys.demo.servicedesk.dao.PARAMETERS getParametersObject()
    {
      /* in the first read automatic object will be created */           
        String queryText = "select * from \"PARAMETERS\"";
        QueryObject query = new QueryObject(queryText);
        query.setResultClass(PARAMETERS.class);
        Boolean manTransaction = false;
        if (null == (PARAMETERS)query.getObject())
          { 
              if (! BSF.getTransactionStarted())
              {
                BSF.startTransaction("GetParameters");
                manTransaction = true;
             
            PARAMETERS par = new PARAMETERS();
            par.setAPPLICATIONID(0);
            par.setTRANSACTIONCODE("");
            par.setTENANTID("ISV");
            par.insert();
            if  (manTransaction)
            {
              BSF.commitTransaction("GetParameters");
           
            return par;
          }
        return (PARAMETERS) query.getObject();
    }
View Full Code Here

Examples of com.cordys.cpc.bsf.busobject.QueryObject

    }

    public static BusObjectIterator<com.cordys.demo.servicedesk.dao.PRODUCTS> getProductsObjects()
    {
        String queryText = "select * from \"PRODUCTS\" where \"TENANTID\"= :TENANTID";
         QueryObject query = new QueryObject(queryText);
         query.addParameter("TENANTID", "PRODUCTS.TENANTID", QueryObject.PARAM_STRING,BSF.getOrganization());
         query.setResultClass(PRODUCTS.class);
         return query.getObjects();
    }
View Full Code Here

Examples of com.cordys.cpc.bsf.busobject.QueryObject

      super.onBeforeUpdate();
    }
    public static com.cordys.demo.servicedesk.dao.SOLUTIONS getSolutionsObject(int SOLUTIONID)
    {
        String queryText = "select * from \"SOLUTIONS\" where \"TENANTID\"= :TENANTID and \"SOLUTIONID\" = :SOLUTIONID";
        QueryObject query = new QueryObject(queryText);
        query.addParameter("TENANTID", "SOLUTIONS.TENANTID", QueryObject.PARAM_STRING,BSF.getOrganization());
        query.addParameter("SOLUTIONID", "SOLUTIONS.SOLUTIONID", QueryObject.PARAM_INT, new Integer(SOLUTIONID));
        query.setResultClass(SOLUTIONS.class);
        return (SOLUTIONS)query.getObject();
    }
View Full Code Here

Examples of com.cordys.cpc.bsf.busobject.QueryObject

    }

    public static BusObjectIterator<com.cordys.demo.servicedesk.dao.SOLUTIONS> getSolutionsObjects(int fromSOLUTIONID, int toSOLUTIONID)
    {
        String queryText = "select * from \"SOLUTIONS\" where \"TENANTID\"= :TENANTID and \"SOLUTIONID\" between :fromSOLUTIONID and :toSOLUTIONID";
        QueryObject query = new QueryObject(queryText);
        query.addParameter("TENANTID", "SOLUTIONS.TENANTID", QueryObject.PARAM_STRING,BSF.getOrganization());
        query.addParameter("fromSOLUTIONID", "SOLUTIONS.SOLUTIONID", QueryObject.PARAM_INT, new Integer(fromSOLUTIONID));
        query.addParameter("toSOLUTIONID", "SOLUTIONS.SOLUTIONID", QueryObject.PARAM_INT, new Integer(toSOLUTIONID));
        query.setResultClass(SOLUTIONS.class);
        return query.getObjects();
    }
View Full Code Here

Examples of com.cordys.cpc.bsf.busobject.QueryObject

    }

    public static BusObjectIterator<com.cordys.demo.servicedesk.dao.SOLUTIONS> getNextSolutionsObjects(int SOLUTIONID, com.cordys.cpc.bsf.query.Cursor cursor)
    {
        String queryText = "select * from \"SOLUTIONS\" where \"TENANTID\"= :TENANTID and (\"SOLUTIONID\" > :SOLUTIONID) order by \"SOLUTIONID\" asc";
        QueryObject query = new QueryObject(queryText);
        query.addParameter("TENANTID", "SOLUTIONS.TENANTID", QueryObject.PARAM_STRING,BSF.getOrganization());
        query.addParameter("SOLUTIONID", "SOLUTIONS.SOLUTIONID", QueryObject.PARAM_INT, new Integer(SOLUTIONID));
        query.setResultClass(SOLUTIONS.class);
        query.setCursor(cursor);
        return query.getObjects();
    }
View Full Code Here

Examples of com.cordys.cpc.bsf.busobject.QueryObject

    }

    public static BusObjectIterator<com.cordys.demo.servicedesk.dao.SOLUTIONS> getPreviousSolutionsObjects(int SOLUTIONID, com.cordys.cpc.bsf.query.Cursor cursor)
    {
        String queryText = "select * from \"SOLUTIONS\" where \"TENANTID\"= :TENANTID and (\"SOLUTIONID\" < :SOLUTIONID) order by \"SOLUTIONID\" desc";
        QueryObject query = new QueryObject(queryText);
        query.addParameter("TENANTID", "SOLUTIONS.TENANTID", QueryObject.PARAM_STRING,BSF.getOrganization());
        query.addParameter("SOLUTIONID", "SOLUTIONS.SOLUTIONID", QueryObject.PARAM_INT, new Integer(SOLUTIONID));
        query.setResultClass(SOLUTIONS.class);
        query.setCursor(cursor);
        return query.getObjects();
    }
View Full Code Here

Examples of com.cordys.cpc.bsf.busobject.QueryObject

        return getMultiRelationObjects(REL_CALLSOLUTIONSObjects);
    }
    public BusObjectIterator<CALLSOLUTIONS> loadCALLSOLUTIONSObjects()
    {
        String queryText = "select * from \"CALLSOLUTIONS\" where \"CALLID\" = :CALLID";
        QueryObject query = new QueryObject(queryText);
        query.addParameter("CALLID", "CALLSOLUTIONS.CALLID", QueryObject.PARAM_INT, new Integer(getCALLID()));
        query.setResultClass(CALLSOLUTIONS.class);
        return query.getObjects();
    }
View Full Code Here

Examples of com.cordys.cpc.bsf.busobject.QueryObject

    }

    public static com.cordys.demo.servicedesk.dao.CALLS getCallsObject(int CALLID)
    {
        String queryText = "select * from \"CALLS\" where \"CALLID\" = :CALLID";
        QueryObject query = new QueryObject(queryText);
        query.addParameter("CALLID", "CALLS.CALLID", QueryObject.PARAM_INT, new Integer(CALLID));
        query.setResultClass(CALLS.class);
        return (CALLS)query.getObject();
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.