コード例 #1
0
  /**
   * 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();
  }
コード例 #2
0
  /**
   * 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();
  }