附件的更改可以分为两种方式
- 先删后增
业务逻辑:附件可以根据业务id全部删除后再新增(新增可以是重复的附件),但是这样有明显的不足,不能特定删除某一个附件,必须重新提交需要的所有附件。
以合同的附件为例:
sysContract.setUpdateTime(DateUtils.getNowDate());
sysContract.setUpdateBy(SecurityUtils.getUsername());
sysAttachmentMapper.deleteSysAttachmentByConId(sysContract.getConId());
List<SysAttachment> addFiles = sysContract.getAttachments();
if(!CollectionUtils.isEmpty(addFiles)){
for (SysAttachment attachment : addFiles) {
attachment.setConId(sysContract.getConId());
attachment.setCreateTime(DateUtils.getNowDate());
attachment.setCreateBy(SecurityUtils.getNickName()+"("+SecurityUtils.getUsername()+")");
attachment.setUpdateBy(SecurityUtils.getNickName()+"("+SecurityUtils.getUsername()+")");
attachment.setUpdateTime(DateUtils.getNowDate());
sysAttachmentMapper.insertSysAttachment(attachment);
}
}
sysContractMapper.updateSysContract(sysContract);
}
- 判断之前的附件表单与提交的附件表单有何不同?
1)如果查询的附件含有附件Id,而增加的没有附件Id,则执行delete操作。
2)如果查询的附件与增加的附件均有附件Id,则保持不变。
3)如果查询的附件没有附件Id,增加的附件有附件Id,则执行add操作。
sysContract.setUpdateTime(DateUtils.getNowDate());
sysContract.setUpdateBy(SecurityUtils.getUsername());
List<SysAttachment> qryLists = sysAttachmentMapper.selectSysAttachmentByConId(sysContract.getConId());
List<SysAttachment> attachments = sysContract.getSysAttachments();
List<SysAttachment> delChanges = qryLists.stream().filter(del ->
{
return attachments .stream().filter(item ->
item.getAttachId() != null
&& NumberUtils.compare(item.getAttachId(), del.getAttachId()) == 0).count() <= 0;
}).collect(Collectors.toList());
for (SysAttachment delChange : delChanges) {
sysAttachmentMapper.deleteSysAttachmentById(delChange.getAttachId());
}
List<SysAttachment> addFiles = attachments.stream().filter(item -> item.getAttachId() == null).collect(Collectors.toList());
if(!CollectionUtils.isEmpty(addFiles)){
for (SysAttachment attachment : addFiles) {
attachment.setConId(sysContract.getConId());
attachment.setCreateTime(DateUtils.getNowDate());
attachment.setCreateBy(SecurityUtils.getNickName()+"("+SecurityUtils.getUsername()+")");
attachment.setUpdateBy(SecurityUtils.getNickName()+"("+SecurityUtils.getUsername()+")");
attachment.setUpdateTime(DateUtils.getNowDate());
sysAttachmentMapper.insertSysAttachment(attachment);
}
}
sysContractMapper.updateSysContract(sysContract);
}