Package com.cordys.cpc.bsf.busobject

Examples of com.cordys.cpc.bsf.busobject.QueryObject.addParameter()

351
352
353
354
355
356
357
358
359
360
361
    public static BusObjectIterator<com.cordys.demo.servicedesk.dao.CALLS> getNextCallsObjects(int CALLID, com.cordys.cpc.bsf.query.Cursor cursor)
    {
        String queryText = "select * from \"CALLS\" where (\"CALLID\" > :CALLID) order by \"CALLID\" asc";
        QueryObject query = new QueryObject(queryText);
        query.addParameter("CALLID", "CALLS.CALLID", QueryObject.PARAM_INT, new Integer(CALLID));
        query.setResultClass(CALLS.class);
        query.setCursor(cursor);
        return query.getObjects();
    }

View Full Code Here
361
362
363
364
365
366
367
368
369
370
371
    public static BusObjectIterator<com.cordys.demo.servicedesk.dao.CALLS> getPreviousCallsObjects(int CALLID, com.cordys.cpc.bsf.query.Cursor cursor)
    {
        String queryText = "select * from \"CALLS\" where (\"CALLID\" < :CALLID) order by \"CALLID\" desc";
        QueryObject query = new QueryObject(queryText);
        query.addParameter("CALLID", "CALLS.CALLID", QueryObject.PARAM_INT, new Integer(CALLID));
        query.setResultClass(CALLS.class);
        query.setCursor(cursor);
        return query.getObjects();
    }

View Full Code Here
157
158
159
160
161
162
163
164
165
166
167
    }
    public BusObjectIterator<CALLSOLUTIONS> loadCALLSOLUTIONSObjects()
    {
        String queryText = "select * from \"CALLSOLUTIONS\" where \"SOLUTIONID\" = :SOLUTIONID";
        QueryObject query = new QueryObject(queryText);
        query.addParameter("SOLUTIONID", "CALLSOLUTIONS.SOLUTIONID", QueryObject.PARAM_INT, new Integer(getSOLUTIONID()));
        query.setResultClass(CALLSOLUTIONS.class);
        return query.getObjects();
    }


View Full Code Here
177
178
179
180
181
182
183
184
185
186
187
    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 (\"SOLUTIONID\" > :SOLUTIONID) order by \"SOLUTIONID\" asc";
        QueryObject query = new QueryObject(queryText);
        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
187
188
189
190
191
192
193
194
195
196
197
    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 (\"SOLUTIONID\" < :SOLUTIONID) order by \"SOLUTIONID\" desc";
        QueryObject query = new QueryObject(queryText);
        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
197
198
199
200
201
202
203
204
205
206
207
    public static com.cordys.demo.servicedesk.dao.SOLUTIONS getSolutionsObject(int SOLUTIONID)
    {
        String queryText = "select * from \"SOLUTIONS\" where \"SOLUTIONID\" = :SOLUTIONID";
        QueryObject query = new QueryObject(queryText);
        query.addParameter("SOLUTIONID", "SOLUTIONS.SOLUTIONID", QueryObject.PARAM_INT, new Integer(SOLUTIONID));
        query.setResultClass(SOLUTIONS.class);
        return (SOLUTIONS)query.getObject();
    }

    public static BusObjectIterator<com.cordys.demo.servicedesk.dao.SOLUTIONS> getSolutionsObjects(int fromSOLUTIONID, int toSOLUTIONID, com.cordys.cpc.bsf.query.Cursor cursor)
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
   
  private static BusObjectIterator<BusObject> getOrgTableInfo(String tableName , Class<?> classObj)
  {
    String queryText = "SELECT * FROM "+tableName+" WHERE TENANTID = :TENANTID";
    QueryObject query = new QueryObject(queryText);
    query.addParameter("TENANTID", tableName+".TENANTID", QueryObject.PARAM_STRING, BSF.getOrganization());
    query.setResultClass(classObj);
   
    return query.getObjects();
  }

View Full Code Here
151
152
153
154
155
156
157
158
159
160
161
    }
    public CALLS loadCALLIDObject()
    {
        String queryText = "select * from \"CALLS\" where \"CALLID\" = :CALLID";
        QueryObject query = new QueryObject(queryText);
        query.addParameter("CALLID", "CALLS.CALLID", QueryObject.PARAM_INT, new Integer(getCALLID()));
        query.setResultClass(CALLS.class);
        return (CALLS)query.getObject();
    }


View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
      String orgUserDN = "cn="+UserName+",cn=organizational users,"+orgDN;

      String queryText = "SELECT  CALLID,SOLUTIONID  FROM CALLSOLUTIONS WHERE TENANTID=:TENANTID AND CALLID IN (SELECT CALLID FROM CALLS WHERE CONTACT=:CONTACT AND TENANTID=:TENANTID)";
      QueryObject query = new QueryObject(queryText);

      query.addParameter("TENANTID", "CALLSOLUTIONS.TENANTID",QueryObject.PARAM_STRING, orgDN);
      query.addParameter("CONTACT", "CALLS.CONTACT",QueryObject.PARAM_STRING, orgUserDN);

      query.setResultClass(CALLSOLUTIONS.class);

      BusObjectIterator<BusObject> busObjectIterator = query.getObjects();
View Full Code Here
177
178
179
180
181
182
183
184
185
186
187
    }
    public SOLUTIONS loadSOLUTIONIDObject()
    {
        String queryText = "select * from \"SOLUTIONS\" where \"SOLUTIONID\" = :SOLUTIONID";
        QueryObject query = new QueryObject(queryText);
        query.addParameter("SOLUTIONID", "SOLUTIONS.SOLUTIONID", QueryObject.PARAM_INT, new Integer(getSOLUTIONID()));
        query.setResultClass(SOLUTIONS.class);
        return (SOLUTIONS)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.