From 4284431e6755e854a7de7afb2ef09e461d3e72eb Mon Sep 17 00:00:00 2001
From: xinyb <574600396@qq.com>
Date: 星期三, 04 九月 2024 17:44:54 +0800
Subject: [PATCH] CRM邮件功能优化
---
src/com/yc/crm/mail/service/MailQuickTextImpl.java | 10 +++++-----
1 files changed, 5 insertions(+), 5 deletions(-)
diff --git a/src/com/yc/crm/mail/service/MailQuickTextImpl.java b/src/com/yc/crm/mail/service/MailQuickTextImpl.java
index b2afff8..29b5859 100644
--- a/src/com/yc/crm/mail/service/MailQuickTextImpl.java
+++ b/src/com/yc/crm/mail/service/MailQuickTextImpl.java
@@ -51,7 +51,7 @@
public Integer deleteQuickText(String userCode, Integer textId) {
String sql = "set nocount on\n";
try {
- sql += "delete t482108 where userCode='" + userCode + "' and textId=" + textId + "\n";
+ sql += "delete t482108 where userCode='" + userCode + "' and text_id=" + textId + "\n";
sql += "select @@ROWCOUNT";
return jdbcTemplate.queryForObject(sql, Integer.class);
} catch (Exception e) {
@@ -63,12 +63,12 @@
public List<T482108Entity> getMailQuickText(String userCode,String search) {
String sql = "set nocount on\n";
try {
- sql += "select companyId,companyName,textId,textName,userCode,userName,content,sortId,createTime,updateTime" +
- "from t482108 where userCode=" + GridUtils.prossSqlParm(userCode);
+ sql += "select companyId,companyName,text_id,text_name,userCode,userName,content,sort_id,create_time,update_time " +
+ " from t482108 where userCode=" + GridUtils.prossSqlParm(userCode);
if (StringUtils.isNotBlank(search)) {
- sql += " and TextName like '%" + search+"%'";
+ sql += " and Text_name like '%" + search+"%'";
}
- sql += " order by textId" + "\n";
+ sql += " order by text_id" + "\n";
return jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(T482108Entity.class));
} catch (Exception e) {
throw e;
--
Gitblit v1.8.0