| 提交 | 用户 | 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.T482109Entity; | |
| 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; | |
| 9 | ||
| 10 | import java.util.List; | |
| 11 | ||
| 12 | /** | |
| 13 | * @BelongsProject: eCoWorksV3 | |
| 14 | * @BelongsPackage: com.yc.crm.mail.service | |
| 15 | * @author: xinyb | |
| 16 | * @CreateTime: 2024-08-15 15:11 | |
| 17 | * @Description: | |
| 18 | */ | |
| 19 | @Service | |
| 20 | public class MailSignatureImpl extends BaseService implements MailSignatureIfc { | |
| 21 | @Override | |
| 22 | public void saveSignature(T482109Entity Signature) { | |
| 23 | String sql = "set nocount on\n"; | |
| 24 | try { | |
| 25 | sql += "insert into t482109(companyId,companyName,userCode,userName,sign_name,sign_content,create_time,update_time) values(" + | |
| 26 | GridUtils.prossSqlParm(Signature.getCompanyId()) + "," + GridUtils.prossSqlParm(Signature.getCompanyName()) + "," + | |
| 27 | GridUtils.prossSqlParm(Signature.getUserCode()) + "," + GridUtils.prossSqlParm(Signature.getUserName()) + "," + | |
| 28 | GridUtils.prossSqlParm(Signature.getSignName()) + "," + GridUtils.prossSqlParm(Signature.getSignContent()) + "," + | |
| 29 | "getdate(),getdate())"; | |
| 30 | jdbcTemplate.update(sql); | |
| 31 | } catch (Exception e) { | |
| 32 | throw e; | |
| 33 | } | |
| 34 | } | |
| 35 | ||
| 36 | @Override | |
| 37 | public Integer updateSignature(T482109Entity Signature) { | |
| 38 | String sql = "set nocount on\n"; | |
| 39 | try { | |
| 40 | sql += "update t482109 set sign_name=" + GridUtils.prossSqlParm(Signature.getSignName()) + ",sign_content=" + GridUtils.prossSqlParm(Signature.getSignContent()) + "," + | |
| f5cc47 | 41 | "update_time=getdate() where sign_id=" + Signature.getSignId()+ " and userCode=" + GridUtils.prossSqlParm(Signature.getUserCode()) + "\n"; |
| 385e2d | 42 | sql += "select @@ROWCOUNT"; |
| X | 43 | return jdbcTemplate.queryForObject(sql, Integer.class); |
| 44 | } catch (Exception e) { | |
| 45 | throw e; | |
| 46 | } | |
| 47 | } | |
| 48 | ||
| 49 | @Override | |
| f5cc47 | 50 | public Integer deleteSignature(String userCode,Integer sigId) { |
| 385e2d | 51 | String sql = "set nocount on\n"; |
| X | 52 | try { |
| 428443 | 53 | sql += "delete t482109 where sign_id=" + sigId+ " and userCode='" + userCode + "'\n"; |
| 385e2d | 54 | sql += "select @@ROWCOUNT"; |
| X | 55 | return jdbcTemplate.queryForObject(sql, Integer.class); |
| 56 | } catch (Exception e) { | |
| 57 | throw e; | |
| 58 | } | |
| 59 | } | |
| 60 | ||
| 61 | @Override | |
| f5cc47 | 62 | public List<T482109Entity> getSignature(String userCode,String search) { |
| 385e2d | 63 | String sql = "set nocount on\n"; |
| X | 64 | try { |
| f5cc47 | 65 | sql += "select companyId,companyName,sign_id,userCode,userName,sign_name,sign_content,create_time,update_time " + |
| X | 66 | "from t482109 where userCode="+GridUtils.prossSqlParm(userCode); |
| 67 | if (StringUtils.isNotBlank(search)) { | |
| 68 | sql += " and sign_name like '%" + search +"%'"; | |
| 385e2d | 69 | } |
| X | 70 | sql += " order by sign_id \n"; |
| 71 | return jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(T482109Entity.class)); | |
| 72 | } catch (Exception e) { | |
| 73 | throw e; | |
| 74 | } | |
| 75 | } | |
| 76 | } | |
