public CustomerManager getCustomerManager(String countyGuid, String week) { String hql = "from CustomerManagerDuty t where t.ovld = true and t.county.guid = ? and t.week = ?"; CustomerManagerDuty duty = dao.getSingleResultByHQL(CustomerManagerDuty.class, hql, countyGuid, week); return duty == null ? null : duty.getManager(); }