public List<Schedule> getSchedules(Date beginDate, Date endDate) { return getDb() .findAllByWhere( Schedule.class, "workDate >= '" + DateUtils.getDateString( beginDate, new SimpleDateFormat("yyyy-MM-dd", Locale.CHINA)) + "' and workDate <= '" + DateUtils.getDateString(endDate, new SimpleDateFormat("yyyy-MM-dd", Locale.CHINA)) + "'"); }
public List<Schedule> getSchedules(int employeeId, Date startDate, Date endDate) { return getDb() .findAllByWhere( Schedule.class, "employeeID = " + employeeId + " and workDate >= '" + DateUtils.getDateString( startDate, new SimpleDateFormat("yyyy-MM-dd", Locale.CHINA)) + "' and workDate <= '" + DateUtils.getDateString(endDate, new SimpleDateFormat("yyyy-MM-dd", Locale.CHINA)) + "'"); }
public List<Schedule> getSchedulesByWorkDate(int employeeId, Date workDate) { return getDb() .findAllByWhere( Schedule.class, "employeeID = " + employeeId + " and workDate like '" + DateUtils.getDateString( workDate, new SimpleDateFormat("yyyy-MM-dd", Locale.CHINA)) + "%'"); }