Beispiel #1
0
  /**
   * <br>
   * [機 能] 削除処理 <br>
   * [解 説] ホリデーテンプレート削除を行います <br>
   * [備 考]
   *
   * @param paramMdl パラメータ情報
   * @param con コネクション
   * @return boolean 更新結果
   * @throws SQLException SQL実行時例外
   */
  public boolean execDataTran(Man027knParamModel paramMdl, Connection con) throws SQLException {

    boolean commitFlg = false;
    CmnHolidayTemplateDao holiDao = new CmnHolidayTemplateDao(con);

    int[] sids = paramMdl.getMan023hltSid();

    try {
      holiDao.delete(sids);
      commitFlg = true;
    } catch (SQLException e) {
      log__.error("休日テンプレートの削除に失敗", e);
      throw e;
    } finally {
      if (commitFlg) {
        con.commit();
      } else {
        JDBCUtil.rollback(con);
      }
    }

    return commitFlg;
  }
Beispiel #2
0
  /**
   * <br>
   * [機 能] 初期表示画面情報を設定します <br>
   * [解 説] <br>
   * [備 考]
   *
   * @param paramMdl パラメータ情報
   * @param reqMdl リクエスト情報
   * @param con コネクション
   * @throws SQLException SQL実行時例外
   */
  public void setInitData(Man027knParamModel paramMdl, RequestModel reqMdl, Connection con)
      throws SQLException {

    CmnHolidayTemplateDao htDao = new CmnHolidayTemplateDao(con);
    List<Man023HolidayTemplateModel> viewList = new ArrayList<Man023HolidayTemplateModel>();

    List<CmnHolidayTemplateModel> holidayList = null;
    holidayList = htDao.selectSortedHoliday(paramMdl.getMan023hltSid());

    for (Object obj : holidayList) {
      CmnHolidayTemplateModel model = (CmnHolidayTemplateModel) obj;
      Man023HolidayTemplateModel viewModel = new Man023HolidayTemplateModel();

      // 「テンプレートSID」作成
      int tmpSid = model.getHltSid();
      viewModel.setHltSid(tmpSid);

      // 「休日文字列」作成
      int hltExflg = model.getHltExflg();
      String dspString = "";
      GsMessage gsMsg = new GsMessage(reqMdl);
      if (hltExflg == CmnHolidayTemplateModel.HLT_EXFLG_NORMAL) {
        dspString =
            model.getHltDateMonth()
                + gsMsg.getMessage("cmn.month")
                + model.getHltDateDay()
                + gsMsg.getMessage("cmn.day");
      } else {
        dspString =
            model.getHltExMonth()
                + gsMsg.getMessage("cmn.month")
                + MaintenanceUtil.getWeek(model.getHltExWeekMonth(), reqMdl)
                + MaintenanceUtil.getYoubi(model.getHltExDayWeek(), reqMdl);
      }
      viewModel.setViewDate(dspString);

      // 「休日名文字列」作成
      String holiday = "";
      holiday = model.getHltName();
      viewModel.setHltName(holiday);

      viewModel.setHltExflg(model.getHltExflg());
      // リストへセット
      UDate date = new UDate();
      date.setTime(0);
      if (model.getHltExflg() == 0) {
        date.setYear(Integer.parseInt(paramMdl.getMan020DspYear()));
        date.setMonth(model.getHltDateMonth());
        date.setDay(model.getHltDateDay());
        viewModel.setHltDateMonth(model.getHltDateMonth());

      } else {
        date.setYear(Integer.parseInt(paramMdl.getMan020DspYear()));

        boolean result =
            MaintenanceUtil.isAccurateWeekOfMonth(
                date, MaintenanceUtil.getIntYoubiForCalendar(model.getHltExDayWeek()));
        if (result) {
          date.setWeek(model.getHltExWeekMonth());
        } else {
          date.setWeek(model.getHltExWeekMonth() + 1);
        }

        date.setDayOfWeek(MaintenanceUtil.getIntYoubiForCalendar(model.getHltExDayWeek()));
        date.setMonth(model.getHltExMonth());
        viewModel.setHltExMonth(model.getHltExMonth());
      }
      viewModel.setDate(Integer.parseInt(date.getDateString()));
      viewList.add(viewModel);
    }
    Man023HolidayTemplateModel[] viewArray =
        (Man023HolidayTemplateModel[])
            viewList.toArray(new Man023HolidayTemplateModel[viewList.size()]);

    Arrays.sort(viewArray);
    paramMdl.setMan023TemplateList(viewArray);
  }