| 提交 | 用户 | age | ||
| 385e2d | 1 | package com.yc.crm.mail.service; |
| X | 2 | |
| 3 | import com.yc.action.grid.GridUtils; | |
| 4 | import com.yc.crm.mail.entity.T482108Entity; | |
| 5 | import com.yc.service.BaseService; | |
| 6 | import org.apache.commons.lang3.StringUtils; | |
| 7 | import org.springframework.jdbc.core.BeanPropertyRowMapper; | |
| 8 | import org.springframework.stereotype.Service; | |
| 048b74 | 9 | import org.springframework.transaction.annotation.Transactional; |
| 385e2d | 10 | |
| X | 11 | import java.util.List; |
| 12 | ||
| 13 | /** | |
| 14 | * @BelongsProject: eCoWorksV3 | |
| 15 | * @BelongsPackage: com.yc.crm.mail.service | |
| 16 | * @author: xinyb | |
| 17 | * @CreateTime: 2024-08-08 08:56 | |
| 18 | * @Description: | |
| 19 | */ | |
| 20 | @Service | |
| 21 | public class MailQuickTextImpl extends BaseService implements MailQuickTextIfc { | |
| 048b74 | 22 | @Transactional(rollbackFor = Exception.class) |
| 385e2d | 23 | @Override |
| X | 24 | public void saveQuickText(T482108Entity quickText) { |
| 25 | String sql = "set nocount on\n"; | |
| 26 | try { | |
| f5cc47 | 27 | sql += "insert into t482108(companyId,companyName,text_Name,userCode,userName,content,sort_id,create_time,update_time) " + |
| 385e2d | 28 | "values (" + GridUtils.prossSqlParm(quickText.getCompanyId()) + "," + GridUtils.prossSqlParm(quickText.getCompanyName()) + "," + |
| X | 29 | GridUtils.prossSqlParm(quickText.getTextName()) + "," + GridUtils.prossSqlParm(quickText.getUserCode()) + "," + |
| 30 | GridUtils.prossSqlParm(quickText.getUserName()) + "," + GridUtils.prossSqlParm(quickText.getContent()) + "," + | |
| 31 | quickText.getSortId() + ",getdate(),getdate())"; | |
| 32 | jdbcTemplate.update(sql); | |
| 33 | } catch (Exception e) { | |
| 34 | throw e; | |
| 35 | } | |
| 36 | } | |
| 048b74 | 37 | @Transactional(rollbackFor = Exception.class) |
| 385e2d | 38 | @Override |
| X | 39 | public Integer updateQuickText(T482108Entity quickText) { |
| 40 | String sql = "set nocount on\n"; | |
| 41 | try { | |
| f5cc47 | 42 | sql += "update t482108 set text_Name=" + GridUtils.prossSqlParm(quickText.getTextName()) + ",content=" + GridUtils.prossSqlParm(quickText.getContent()) + |
| X | 43 | ",sort_id=" + quickText.getSortId() + ",update_time=getdate() " + |
| 44 | "where text_id=" + quickText.getTextId() + " and userCode=" + GridUtils.prossSqlParm(quickText.getUserCode()) + "\n"; | |
| 385e2d | 45 | sql += "select @@ROWCOUNT"; |
| f5cc47 | 46 | return jdbcTemplate.queryForObject(sql, Integer.class); |
| 385e2d | 47 | } catch (Exception e) { |
| X | 48 | throw e; |
| 49 | } | |
| 50 | } | |
| 51 | ||
| 52 | @Override | |
| 53 | public Integer deleteQuickText(String userCode, Integer textId) { | |
| 54 | String sql = "set nocount on\n"; | |
| 55 | try { | |
| 428443 | 56 | sql += "delete t482108 where userCode='" + userCode + "' and text_id=" + textId + "\n"; |
| 385e2d | 57 | sql += "select @@ROWCOUNT"; |
| f5cc47 | 58 | return jdbcTemplate.queryForObject(sql, Integer.class); |
| 385e2d | 59 | } catch (Exception e) { |
| X | 60 | throw e; |
| 61 | } | |
| 62 | } | |
| 63 | ||
| 64 | @Override | |
| f5cc47 | 65 | public List<T482108Entity> getMailQuickText(String userCode,String search) { |
| 385e2d | 66 | String sql = "set nocount on\n"; |
| X | 67 | try { |
| 428443 | 68 | sql += "select companyId,companyName,text_id,text_name,userCode,userName,content,sort_id,create_time,update_time " + |
| X | 69 | " from t482108 where userCode=" + GridUtils.prossSqlParm(userCode); |
| f5cc47 | 70 | if (StringUtils.isNotBlank(search)) { |
| 428443 | 71 | sql += " and Text_name like '%" + search+"%'"; |
| 385e2d | 72 | } |
| 428443 | 73 | sql += " order by text_id" + "\n"; |
| 385e2d | 74 | return jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(T482108Entity.class)); |
| X | 75 | } catch (Exception e) { |
| 76 | throw e; | |
| 77 | } | |
| 78 | } | |
| 79 | } | |
