From 73c8452a479ea83d4e9d28a7c66c019d9955d194 Mon Sep 17 00:00:00 2001
From: xinyb <574600396@qq.com>
Date: 星期日, 29 九月 2024 15:28:51 +0800
Subject: [PATCH] CRM邮箱删除和待处理功能
---
src/com/yc/crm/mail/service/MailImpl.java | 5 +++--
1 files changed, 3 insertions(+), 2 deletions(-)
diff --git a/src/com/yc/crm/mail/service/MailImpl.java b/src/com/yc/crm/mail/service/MailImpl.java
index 48a224d..6508b19 100644
--- a/src/com/yc/crm/mail/service/MailImpl.java
+++ b/src/com/yc/crm/mail/service/MailImpl.java
@@ -159,7 +159,7 @@
String sql = "set nocount on\n";
try {
sql += "declare @docCode varchar(200) ='" + docCode + "' \n";
- sql += "update t482101H deleteFlag=1 where userCode =" + GridUtils.prossSqlParm(userCode) +
+ sql += "update t482101H set delete_flag=1 where userCode =" + GridUtils.prossSqlParm(userCode) +
" and docCode in (select list from GetInStr(@docCode))\n";//鏍囪鍒犻櫎
sql += " select @@ROWCOUNT";
return jdbcTemplate.queryForObject(sql, Integer.class);
@@ -174,7 +174,7 @@
String sql = "set nocount on\n";
try {
sql += "declare @docCode varchar(200) ='" + docCode + "' \n";
- sql += "update t482101H deleteFlag=1 where userCode =" + GridUtils.prossSqlParm(userCode) +
+ sql += "update t482101H set delete_flag=1 where userCode =" + GridUtils.prossSqlParm(userCode) +
" and docCode in (select list from GetInStr(@docCode))\n";//鏍囪鍒犻櫎
sql += " select @@ROWCOUNT";
return jdbcTemplate.queryForObject(sql, Integer.class);
@@ -221,6 +221,7 @@
"read_Flag,(case when (isnull(handle_time,'') <> '' and isnull(handle_time,'') < getdate()) then 1 else 0 end) as handle," +
"handle_time,sender_time,receiving_time from t482101H ";
sql += " where userCode=" + GridUtils.prossSqlParm(userCode);
+ sql += " and isnull(delete_Flag,0) = 0 ";//鏈垹闄ょ殑
sql += " and mailType=" + mailType;//0锛氳崏绋跨 1锛氭敹浠剁 2锛氬彂浠剁
if (StringUtils.isNotBlank(email)) {
if (mailType == 1) {
--
Gitblit v1.8.0