Package com.cordys.cpc.bsf.busobject

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

235
236
237
238
239
240
241
242
243
244
245
    public static BusObjectIterator<com.cordys.demo.servicedesk.dao.CALLSOLUTIONS> getCallsolutionsObjects(int fromSOLUTIONID, int toSOLUTIONID, int fromCALLID, int toCALLID)
    {
        String queryText = "select * from \"CALLSOLUTIONS\" where \"SOLUTIONID\" between :fromSOLUTIONID and :toSOLUTIONID and \"CALLID\" between :fromCALLID and :toCALLID";
        QueryObject query = new QueryObject(queryText);
        query.addParameter("fromSOLUTIONID", "CALLSOLUTIONS.SOLUTIONID", QueryObject.PARAM_INT, new Integer(fromSOLUTIONID));
        query.addParameter("toSOLUTIONID", "CALLSOLUTIONS.SOLUTIONID", QueryObject.PARAM_INT, new Integer(toSOLUTIONID));
        query.addParameter("fromCALLID", "CALLSOLUTIONS.CALLID", QueryObject.PARAM_INT, new Integer(fromCALLID));
        query.addParameter("toCALLID", "CALLSOLUTIONS.CALLID", QueryObject.PARAM_INT, new Integer(toCALLID));
        query.setResultClass(CALLSOLUTIONS.class);
        return query.getObjects();
    }
View Full Code Here
236
237
238
239
240
241
242
243
244
245
246
    {
        String queryText = "select * from \"CALLSOLUTIONS\" where \"SOLUTIONID\" between :fromSOLUTIONID and :toSOLUTIONID and \"CALLID\" between :fromCALLID and :toCALLID";
        QueryObject query = new QueryObject(queryText);
        query.addParameter("fromSOLUTIONID", "CALLSOLUTIONS.SOLUTIONID", QueryObject.PARAM_INT, new Integer(fromSOLUTIONID));
        query.addParameter("toSOLUTIONID", "CALLSOLUTIONS.SOLUTIONID", QueryObject.PARAM_INT, new Integer(toSOLUTIONID));
        query.addParameter("fromCALLID", "CALLSOLUTIONS.CALLID", QueryObject.PARAM_INT, new Integer(fromCALLID));
        query.addParameter("toCALLID", "CALLSOLUTIONS.CALLID", QueryObject.PARAM_INT, new Integer(toCALLID));
        query.setResultClass(CALLSOLUTIONS.class);
        return query.getObjects();
    }

View Full Code Here
237
238
239
240
241
242
243
244
245
246
247
        String queryText = "select * from \"CALLSOLUTIONS\" where \"SOLUTIONID\" between :fromSOLUTIONID and :toSOLUTIONID and \"CALLID\" between :fromCALLID and :toCALLID";
        QueryObject query = new QueryObject(queryText);
        query.addParameter("fromSOLUTIONID", "CALLSOLUTIONS.SOLUTIONID", QueryObject.PARAM_INT, new Integer(fromSOLUTIONID));
        query.addParameter("toSOLUTIONID", "CALLSOLUTIONS.SOLUTIONID", QueryObject.PARAM_INT, new Integer(toSOLUTIONID));
        query.addParameter("fromCALLID", "CALLSOLUTIONS.CALLID", QueryObject.PARAM_INT, new Integer(fromCALLID));
        query.addParameter("toCALLID", "CALLSOLUTIONS.CALLID", QueryObject.PARAM_INT, new Integer(toCALLID));
        query.setResultClass(CALLSOLUTIONS.class);
        return query.getObjects();
    }

    public static BusObjectIterator<com.cordys.demo.servicedesk.dao.CALLSOLUTIONS> getCallsolutionsObjectsForCallid(int CALLID)
View Full Code Here
246
247
248
249
250
251
252
253
254
255
256
    public static BusObjectIterator<com.cordys.demo.servicedesk.dao.CALLSOLUTIONS> getCallsolutionsObjectsForCallid(int CALLID)
    {
        String queryText = "select * from \"CALLSOLUTIONS\" where \"CALLID\" = :CALLID";
        QueryObject query = new QueryObject(queryText);
        query.addParameter("CALLID", "CALLSOLUTIONS.CALLID", QueryObject.PARAM_INT, new Integer(CALLID));
        query.setResultClass(CALLSOLUTIONS.class);
        return query.getObjects();
    }

    public static BusObjectIterator<com.cordys.demo.servicedesk.dao.CALLSOLUTIONS> getCallsolutionsObjectsForSolutionid(int SOLUTIONID)
View Full Code Here
255
256
257
258
259
260
261
262
263
264
265
    public static BusObjectIterator<com.cordys.demo.servicedesk.dao.CALLSOLUTIONS> getCallsolutionsObjectsForSolutionid(int SOLUTIONID)
    {
        String queryText = "select * from \"CALLSOLUTIONS\" where \"SOLUTIONID\" = :SOLUTIONID";
        QueryObject query = new QueryObject(queryText);
        query.addParameter("SOLUTIONID", "CALLSOLUTIONS.SOLUTIONID", QueryObject.PARAM_INT, new Integer(SOLUTIONID));
        query.setResultClass(CALLSOLUTIONS.class);
        return query.getObjects();
    }

    public static BusObjectIterator<com.cordys.demo.servicedesk.dao.CALLSOLUTIONS> getNextCallsolutionsObjects(int SOLUTIONID, int CALLID, com.cordys.cpc.bsf.query.Cursor cursor)
View Full Code Here
264
265
266
267
268
269
270
271
272
273
274
    public static BusObjectIterator<com.cordys.demo.servicedesk.dao.CALLSOLUTIONS> getNextCallsolutionsObjects(int SOLUTIONID, int CALLID, com.cordys.cpc.bsf.query.Cursor cursor)
    {
        String queryText = "select * from \"CALLSOLUTIONS\" where (\"SOLUTIONID\" > :SOLUTIONID) or (\"SOLUTIONID\" = :SOLUTIONID and \"CALLID\" > :CALLID) order by \"SOLUTIONID\" asc, \"CALLID\" asc";
        QueryObject query = new QueryObject(queryText);
        query.addParameter("SOLUTIONID", "CALLSOLUTIONS.SOLUTIONID", QueryObject.PARAM_INT, new Integer(SOLUTIONID));
        query.addParameter("CALLID", "CALLSOLUTIONS.CALLID", QueryObject.PARAM_INT, new Integer(CALLID));
        query.setResultClass(CALLSOLUTIONS.class);
        query.setCursor(cursor);
        return query.getObjects();
    }
View Full Code Here
265
266
267
268
269
270
271
272
273
274
275
    public static BusObjectIterator<com.cordys.demo.servicedesk.dao.CALLSOLUTIONS> getNextCallsolutionsObjects(int SOLUTIONID, int CALLID, com.cordys.cpc.bsf.query.Cursor cursor)
    {
        String queryText = "select * from \"CALLSOLUTIONS\" where (\"SOLUTIONID\" > :SOLUTIONID) or (\"SOLUTIONID\" = :SOLUTIONID and \"CALLID\" > :CALLID) order by \"SOLUTIONID\" asc, \"CALLID\" asc";
        QueryObject query = new QueryObject(queryText);
        query.addParameter("SOLUTIONID", "CALLSOLUTIONS.SOLUTIONID", QueryObject.PARAM_INT, new Integer(SOLUTIONID));
        query.addParameter("CALLID", "CALLSOLUTIONS.CALLID", QueryObject.PARAM_INT, new Integer(CALLID));
        query.setResultClass(CALLSOLUTIONS.class);
        query.setCursor(cursor);
        return query.getObjects();
    }

View Full Code Here
275
276
277
278
279
280
281
282
283
284
285
    public static BusObjectIterator<com.cordys.demo.servicedesk.dao.CALLSOLUTIONS> getPreviousCallsolutionsObjects(int SOLUTIONID, int CALLID, com.cordys.cpc.bsf.query.Cursor cursor)
    {
        String queryText = "select * from \"CALLSOLUTIONS\" where (\"SOLUTIONID\" < :SOLUTIONID) or (\"SOLUTIONID\" = :SOLUTIONID and \"CALLID\" < :CALLID) order by \"SOLUTIONID\" desc, \"CALLID\" desc";
        QueryObject query = new QueryObject(queryText);
        query.addParameter("SOLUTIONID", "CALLSOLUTIONS.SOLUTIONID", QueryObject.PARAM_INT, new Integer(SOLUTIONID));
        query.addParameter("CALLID", "CALLSOLUTIONS.CALLID", QueryObject.PARAM_INT, new Integer(CALLID));
        query.setResultClass(CALLSOLUTIONS.class);
        query.setCursor(cursor);
        return query.getObjects();
    }
View Full Code Here
276
277
278
279
280
281
282
283
284
285
286
    public static BusObjectIterator<com.cordys.demo.servicedesk.dao.CALLSOLUTIONS> getPreviousCallsolutionsObjects(int SOLUTIONID, int CALLID, com.cordys.cpc.bsf.query.Cursor cursor)
    {
        String queryText = "select * from \"CALLSOLUTIONS\" where (\"SOLUTIONID\" < :SOLUTIONID) or (\"SOLUTIONID\" = :SOLUTIONID and \"CALLID\" < :CALLID) order by \"SOLUTIONID\" desc, \"CALLID\" desc";
        QueryObject query = new QueryObject(queryText);
        query.addParameter("SOLUTIONID", "CALLSOLUTIONS.SOLUTIONID", QueryObject.PARAM_INT, new Integer(SOLUTIONID));
        query.addParameter("CALLID", "CALLSOLUTIONS.CALLID", QueryObject.PARAM_INT, new Integer(CALLID));
        query.setResultClass(CALLSOLUTIONS.class);
        query.setCursor(cursor);
        return query.getObjects();
    }

View Full Code Here
132
133
134
135
136
137
138
139
140
141
142
 
   public static com.cordys.demo.servicedesk.dao.CALLS getCallsObject(int CALLID)
    {
        String queryText = "select * from \"CALLS\" where \"TENANTID\"= :TENANTID and  \"CALLID\" = :CALLID";
        QueryObject query = new QueryObject(queryText);
        query.addParameter("TENANTID", "CALLS.TENANTID", QueryObject.PARAM_STRING,BSF.getOrganization());   /* fill tenent! */
        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.