From 3f2b7d45f9abe9c767e564b5ef045b69664d52c9 Mon Sep 17 00:00:00 2001
From: xinyb <574600396@qq.com>
Date: 星期二, 27 八月 2024 08:59:12 +0800
Subject: [PATCH] CRM邮件附件功能
---
src/com/yc/service/upload/AttachmentIfc.java | 1 +
src/com/yc/service/upload/AttachmentImpl.java | 21 +++++++++++++++++++++
2 files changed, 22 insertions(+), 0 deletions(-)
diff --git a/src/com/yc/service/upload/AttachmentIfc.java b/src/com/yc/service/upload/AttachmentIfc.java
index e3e6125..31cf08e 100644
--- a/src/com/yc/service/upload/AttachmentIfc.java
+++ b/src/com/yc/service/upload/AttachmentIfc.java
@@ -17,6 +17,7 @@
String rowId, String docCode);
public List<AttachmentEntity> getAttachmentEntityList(String unid, String type);
+ public List<AttachmentEntity> getAttachmentEntityList(String unid);
public AttachmentEntity getAttachmentEntity(String unid, Integer seq, String type);
public AttachmentEntity getAttachmentEntity(String unid, String seq);
diff --git a/src/com/yc/service/upload/AttachmentImpl.java b/src/com/yc/service/upload/AttachmentImpl.java
index 22bb0de..d66ec50 100644
--- a/src/com/yc/service/upload/AttachmentImpl.java
+++ b/src/com/yc/service/upload/AttachmentImpl.java
@@ -304,6 +304,26 @@
}
@Override
+ public List<AttachmentEntity> getAttachmentEntityList(String unid) {
+ String sql = " set nocount on \n"
+ + " declare @unid varchar(50) = " + GridUtils.prossSqlParm(unid) + " \n";
+ sql += " select UNID,seq,DocCode,RowId,FieldId,FormId, \n"
+ + " PhysicalPath,PhysicalFile,OriginalFileName,FileSize,FileType, \n"
+ + " AuthorCode,AuthorName,SmallPicPath,UploadTime, \n"
+ + " DownNums,ViewNums,UpdateNums ,\n"
+ + " LastUpdateTime,isSetPermission,LastFileName,LastFileSize, \n"
+ + " LastAuthorCode,LastAuthorName,LastFileType,OriginalPicture \n"
+ + " from _sys_Attachment \n"
+ + " where unid = @unid \n";
+ List<Map<String, Object>> list = this.jdbcTemplate.queryForList(sql);
+ List<AttachmentEntity> attachmentList = new ArrayList<AttachmentEntity>();
+ for (int i = 0; list != null && i < list.size(); i++) {
+ attachmentList.add(getAttachmentEntity(list.get(i)));
+ }
+ return attachmentList;
+ }
+
+ @Override
public AttachmentEntity getAttachmentEntity(String unid, Integer seq, String type) {
String sql = "set nocount on \n"
+ " declare @unid varchar(50) = "+GridUtils.prossSqlParm(unid)+" \n";
@@ -415,6 +435,7 @@
: (String) map.get("LastAuthorName"));
attachmentEntity.setLastFileType(map.get("LastFileType") == null ? ""
: (String) map.get("LastFileType"));
+ attachmentEntity.setOriginalPicture(map.get("OriginalPicture") == null ? null : (byte[]) map.get("OriginalPicture"));
} catch (Exception e) {
throw e;
}
--
Gitblit v1.8.0