@Override
public void updateWorkTime(WorkTime workTime) {
String sql =
"update KGADE.T_ADE_WORKTIME set COMPANY_ID=?, NAME=?,BEGIN_TIME=?,END_TIME=?,FOLLOWING_DAY=? where ID=?";
jdbcTemplate.update(
sql,
workTime.getCompanyId(),
workTime.getName(),
workTime.getBeginTime(),
workTime.getEndTime(),
workTime.isFollowingDay(),
workTime.getId());
}
@Override
public void saveWorkTime(WorkTime workTime) {
String sql =
"insert into KGADE.T_ADE_WORKTIME(ID,COMPANY_ID,NAME,BEGIN_TIME,END_TIME,FOLLOWING_DAY,SYSTEM) "
+ "VALUES(?,?,?,?,?,?,?)";
jdbcTemplate.update(
sql,
workTime.getId(),
workTime.getCompanyId(),
workTime.getName(),
workTime.getBeginTime(),
workTime.getEndTime(),
workTime.isFollowingDay(),
workTime.isSystem());
}