| | |
| | | "insert into blade_attach(id,tenant_id,link,domain,name,original_name,extension,attach_size,create_user,deptid," + |
| | | "create_time,update_user,update_time,status,is_deleted,type,cardid"; |
| | | if (noticeId != null) { |
| | | s1 += ",notice_id"; |
| | | s1 += ",notice_id"+")" +"values(" + "'" + attach.getId() + "'" + "," + |
| | | "'" + attach.getTenantId() + "'" + "," + |
| | | "'" + imgurl + "'" + "," + |
| | | "'" + ip + "'" + "," + |
| | | "'" + split[2] + "'" + "," + |
| | | "'" + attach.getOriginalName() + "'" + "," + |
| | | "'" + attach.getExtension() + "'" + "," + |
| | | "'" + attach.getAttachSize() + "'" + "," + |
| | | "'" + attach.getCreateUser() + "'" + "," + |
| | | "'" + attach.getDeptid() + "'" + "," + |
| | | "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()) + "'" + "," + |
| | | "'" + attach.getUpdateUser() + "'" + "," + |
| | | "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()) + "'" + "," + |
| | | "'" + attach.getStatus() + "'" + "," + |
| | | "'" + attach.getIsDeleted() + "'" + "," + |
| | | "'" + attach.getType() + "'" + "," + |
| | | "'" + cardid + "'"; |
| | | } else { |
| | | s1 += ") " + |
| | | "values(" + "'" + attach.getId() + "'" + "," + |
| | |
| | | "'" + cardid + "'"; |
| | | } |
| | | if (noticeId != null) { |
| | | s1 += "'" + noticeId + "'" + ")"; |
| | | s1 += ","+"'" + noticeId + "'" + ")"; |
| | | } else { |
| | | s1 += ")"; |
| | | } |