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