/** * This is fucntion searchHoSoNoiGui Version: 1.0 * * <p>History: DATE AUTHOR DESCRIPTION ------------------------------------------------- * 3-March-2013 Nam Dinh Create new * * @param PortletRequest request, CongChuc canBoNoiGui, long[] thuTucGuiIds * @return QueryResult<HoSoLienThong> */ public QueryResult<HoSoLienThong> searchHoSoNoiGui( PortletRequest request, CongChuc canBoNoiGui, long[] thuTucGuiIds) { String tenCongDanHoacMaBienNhan = ParamUtil.getString(request, HSLTFields.tenCongDanORMaBienNhanKhiGui); String sql = "SELECT * FROM CMON_HOSOLIENTHONG " + SQLBuilder.WHERE_HOLDER; DynamicSQLBuilder sqlBuilder = new DynamicSQLBuilder(sql, request); sqlBuilder.eq("CANBOGUIID", canBoNoiGui.getId()); sqlBuilder.in("THUTUCGUIID", thuTucGuiIds); sqlBuilder.dynIntegerEQ("TRANGTHAILIENTHONG", HSLTFields.trangThaiLienThong); // La ma Bien Nhan if (IsNumeral.check(tenCongDanHoacMaBienNhan)) { sqlBuilder.stringLeft("MASOBIENNHANGUI", tenCongDanHoacMaBienNhan); // La ten cong dan nop } else if (!tenCongDanHoacMaBienNhan.isEmpty()) { sqlBuilder.stringRight("HOTENCONGDANNOP", tenCongDanHoacMaBienNhan); } sqlBuilder.eq("DAXOA", 0); sqlBuilder.orderDESC("NGAYSUA"); SearchHelper<HoSoLienThong> helper = new SearchHelper<HoSoLienThong>(this, sqlBuilder); helper.createQuery().addEntity(HoSoLienThong.class.getSimpleName(), HoSoLienThongImpl.class); return helper.search(); }
/** * This is fucntion searchHoSoNoiNhan Version: 1.0 * * <p>History: DATE AUTHOR DESCRIPTION ------------------------------------------------- * 3-March-2013 Nam Dinh Create new * * @param PortletRequest request, CongChuc canBoNoiNhan, long[] thuTucNhanIds * @return QueryResult<HoSoLienThong> */ public QueryResult<HoSoLienThong> searchHoSoNoiNhan( PortletRequest request, CongChuc canBoNoiNhan, long[] thuTucNhanIds) { DynamicSQLBuilder sqlBuilder = new DynamicSQLBuilder( CustomSQLUtil.get("org.oep.cmon.dao.hosolienthong.searchHoSoNoiNhan"), request); sqlBuilder.in("THUTUCNHANID", thuTucNhanIds); sqlBuilder.dynLongEQ("COQUANGUIID", HSLTFields.coQuanGuiId); sqlBuilder.dynIntegerEQ("TRANGTHAILIENTHONG", HSLTFields.trangThaiLienThong); sqlBuilder.eq("DAXOA", 0); sqlBuilder.orderDESC("NGAYSUA"); SearchHelper<HoSoLienThong> helper = new SearchHelper<HoSoLienThong>(this, sqlBuilder); helper .createQuery() .addEntity(HoSoLienThong.class.getSimpleName(), HoSoLienThongImpl.class) .setInteger("TTLT_CHO_TIEP_NHAN", HSLTBusinessUtil.TTLT_CHO_TIEP_NHAN) .setLong("canBoNhanId", canBoNoiNhan.getId()); return helper.search(); }