insert into t_board (
title, contents, beginDate, endDate, statusCode, plantSeq, serverName, createId, updateId, createDateTime, updateDatetime
) values (
#{title},
#{contents},
#{beginDate},
#{endDate},
#{statusCode},
#{plantSeq},
#{serverName},
#{createId},
#{updateId},
now(),
now()
)
update t_board set
title=#{title},
contents=#{contents},
beginDate=#{beginDate},
endDate=#{endDate},
statusCode=#{statusCode},
attach=#{attach},
serverName=#{serverName},
plantSeq=#{plantSeq}, updateId=#{updateId}, updateDatetime=now()
where seq=#{seq}
update t_notice set
title=#{title},
contents=#{contents},
link=#{link},
syear=#{syear},
smonth=#{smonth},
eyear=#{eyear},
emonth=#{emonth},
startDate=#{startDate},
endDate=#{endDate},
repeatCode=#{repeatCode},
statusCode=#{statusCode},
updateId=#{updateId}, updateDatetime=now()
where seq=#{seq}
insert into t_notice (
title, contents, link, startDate, endDate, syear, smonth, eyear, emonth, repeatCode, statusCode, createId, updateId, createDateTime, updateDatetime
) values (
#{title},
#{contents},
#{link},
#{startDate},
#{endDate},
#{syear},
#{smonth},
#{eyear},
#{emonth},
#{repeatCode},
#{statusCode},
#{createId},
#{updateId},
now(),
now()
)