Example #1
0
 private Xfactcutpaydetl[] getRecordsByWhere() throws XfactcutpaydetlDaoException {
   XfactcutpaydetlDao detlDao = XfactcutpaydetlDaoFactory.create();
   String sql =
       "billstatus = "
           + XFBillStatus.BILLSTATUS_CORE_SUCCESS
           + " and clientname like '%"
           + detlRecord.getClientname()
           + "%' "
           + " and contractno like '%"
           + detlRecord.getContractno()
           + "%' "
           + " order by journalno";
   return detlDao.findByDynamicWhere(sql, null);
 }