public Cardinfo findCardinfoByCardCode(String cardcode) { String hql = "from Cardinfo x where x.cardcode = ?"; List params = new ArrayList(); params.add(cardcode); Cardinfo xx = new Cardinfo(); List cardinfoList = publicDao.find(hql, params); if (cardinfoList != null && cardinfoList.size() > 0) { xx = (Cardinfo) cardinfoList.get(0); } return xx; }
/** * 根据临时表id,处理单id 查询变动表数据集合 * * @param bodyId * @param headId * @return */ public List findRecordsBybodyId(String bodyId, String headId) { List list = new ArrayList(); String sql = "from Recordhistory re where re.zcId = ? and re.pkId = ?"; list = publicDao.find(sql, new Object[] {bodyId, headId}); return list; }
/** * 根据处理单ID查询该处理单下所有卡片信息 * * @param id */ public List findLcCardtempsBySheadId(String id) { Long[] strs = new Long[1]; strs[0] = Long.valueOf(id); return publicDao.find("from LcCardtemp o where o.kpxzid = ?", strs); }