update t_cs set
procStatus=#{procStatus},
procMemo=#{procMemo},
procType=#{procType},
csType=#{csType},
updateId=#{updateId},
updateDatetime=now()
where seq=#{seq}
update t_cs_upload set
csSeq=#{csSeq},
fileType=#{fileType},
fileName=#{fileName}
where seq=#{seq}
delete from t_cs_upload where seq=#{seq}
insert into t_cs (
plantSeq, pcsIdx, timetableSeq, inputDate, inputHms, csType, procType, procStatus, procMemo,
pcsFaultStr, batteryFaultStr, updateId, updateDatetime, createId, createDatetime
) values (
#{plantSeq}, #{pcsIdx}, #{timetableSeq}, #{inputDate}, #{inputHms}, #{csType}, #{procType}, #{procStatus}, #{procMemo},
#{pcsFaultStr}, #{batteryFaultStr}, #{updateId}, now(), #{createId}, now()
)
insert into t_cs_upload (
csSeq, fileType, fileName
) values (
#{csSeq}, #{fileType}, #{fileName}
)
insert into t_sms ( plantSeq, title, receiver, sender, result, createId, createDatetime)
values ( #{plantSeq}, #{title}, #{receiver}, #{sender}, #{result}, #{createId}, now() )