/** * <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; }
/** * <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); }