From 7cf738d43c5d38e9a6246c7d6212d2d5bd055886 Mon Sep 17 00:00:00 2001
From: xinyb <574600396@qq.com>
Date: 星期五, 13 九月 2024 17:40:56 +0800
Subject: [PATCH] CRM邮箱配置和客户功能
---
src/com/yc/crm/mail/service/MailAccountImpl.java | 21 +++++++++++++++++----
1 files changed, 17 insertions(+), 4 deletions(-)
diff --git a/src/com/yc/crm/mail/service/MailAccountImpl.java b/src/com/yc/crm/mail/service/MailAccountImpl.java
index bd26024..d33ad55 100644
--- a/src/com/yc/crm/mail/service/MailAccountImpl.java
+++ b/src/com/yc/crm/mail/service/MailAccountImpl.java
@@ -59,9 +59,22 @@
}
sql += " smtpSSL='" + account.isSmtpSSL() + "'," + " smtpPort=" + account.getSmtpPort() + ",smtpHost=" + GridUtils.prossSqlParm(account.getSmtpHost()) + "," +
" invalid='" + account.isInvalid() + "',bisync_flag='" + account.isBiSyncFlag() + "',proxyFlag='" + account.isProxyFlag() + "'," +
- " mailType=" + account.getMailType() + ",mailStatus=" + GridUtils.prossSqlParm(account.getMailStatus()) + "," +
- " update_time=convert(varchar(19),getdate(),120) " +
+ " mailType=" + account.getMailType() + ",mailStatus=" + GridUtils.prossSqlParm(account.getMailStatus()) +
+// " ,update_time=convert(varchar(19),getdate(),120) " +
" where userCode=" + GridUtils.prossSqlParm(account.getUserCode()) + " and accountId=" + account.getAccountId();
+ sql += "select @@ROWCOUNT";
+ return jdbcTemplate.queryForObject(sql, Integer.class);
+ } catch (Exception e) {
+ throw e;
+ }
+ }
+
+ @Override
+ public Integer updateEmailTime(Integer accountId) {
+ String sql = "set nocount on\n";
+ try {
+ sql += "update t482102 set update_time=convert(varchar(19),getdate(),120) " +
+ " where accountId=" + accountId;
sql += "select @@ROWCOUNT";
return jdbcTemplate.queryForObject(sql, Integer.class);
} catch (Exception e) {
@@ -73,7 +86,7 @@
public Integer updateMailStatus(String status, Integer accountId) {
String sql = "set nocount on\n";
try {
- sql += "update t482102 set mailStatus=" + GridUtils.prossSqlParm(status) + ",update_time=convert(varchar(19),getdate(),120) " +
+ sql += "update t482102 set mailStatus=" + GridUtils.prossSqlParm(status) + //",update_time=convert(varchar(19),getdate(),120) " +
" where accountId=" + accountId;
sql += "select @@ROWCOUNT";
return jdbcTemplate.queryForObject(sql, Integer.class);
@@ -86,7 +99,7 @@
public Integer updateAliasEmail(String aliasEmail, Integer accountId) {
String sql = "set nocount on\n";
try {
- sql += "update t482102 set alias_email=" + GridUtils.prossSqlParm(aliasEmail) + ",update_time=convert(varchar(19),getdate(),120) " +
+ sql += "update t482102 set alias_email=" + GridUtils.prossSqlParm(aliasEmail) + //",update_time=convert(varchar(19),getdate(),120) " +
" where accountId=" + accountId;
sql += "select @@ROWCOUNT";
return jdbcTemplate.queryForObject(sql, Integer.class);
--
Gitblit v1.8.0