308a9d7185b584d2735bf18f17737e69f54cccdb.svn-base
3.9 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
package com.espeed.service.impl;
import java.util.List;
import com.espeed.dao.YxyUnsubscribeInfoDao;
import com.espeed.pojo.YxyUnsubscribeInfo;
import com.espeed.service.YxyUnsubscribeInfoService;
import com.espeed.vo.PageBean;
/**
* 程序名称: EspeedMail_时速邮箱
* 程序版本: V1.0
* 作 者: 深圳市科飞时速网络技术有限公司(0755-88843776)
* 版权所有: 深圳市科飞时速网络技术有限公司
* 技术支持: Tech@21gmail.com
* 单元名称: 退订service实现类(营销游)
* 开始时间: 2013.12.09
* 程 序 员: 谢勇
* 最后修改:
* 备 注: 如需修改请通知程序员
*/
public class YxyUnsubscribeInfoServiceImpl implements YxyUnsubscribeInfoService{
/**查询用户所有退订地址*/
public List<Object> findAllUnEmali(String loginid, String domain)throws Exception {
String sql="select unsubscribe_email from yxy_unsubscribe_info where unsubscribe_loginid='"+loginid+"' and unsubscribe_domain='"+domain+"'";
List<Object> list=yxyunsubscribeinfodao.findBySqlQuery(sql);
return list;
}
/**条件查询用户退订地址(分页)*/
public List<YxyUnsubscribeInfo> findUnCondition(String loginid,String domain, PageBean pb, int condition, String conditionvalue)throws Exception {
String hql="from YxyUnsubscribeInfo where unsubscribe_loginid='"+loginid+"' and unsubscribe_domain='"+domain+"'";
String hqlcount="select count(*) from YxyUnsubscribeInfo where unsubscribe_loginid='"+loginid+"' and unsubscribe_domain='"+domain+"'";
if(condition==1){//搜索查询
hql+=" and unsubscribe_email like '%"+conditionvalue+"%'";
hqlcount+=" and unsubscribe_email like '%"+conditionvalue+"%'";
}
hql+=" order by unsubscribe_date desc";
hqlcount+=" order by unsubscribe_date desc";
return yxyunsubscribeinfodao.findByHqlPage(hql, hqlcount, pb);
}
/**删除退订地址*/
public void delUnsubscribe(String unidstr) throws Exception {
String hql="delete YxyUnsubscribeInfo where unsubscribe_id in("+unidstr+")";
yxyunsubscribeinfodao.updateByHql(hql);
}
/**添加退订地址*/
public void addUnsubscribe(YxyUnsubscribeInfo o) throws Exception {
yxyunsubscribeinfodao.addPojo(o);
}
/**编辑退订地址*/
public void updateUnsubscribe(YxyUnsubscribeInfo o) throws Exception {
String hql="update YxyUnsubscribeInfo set unsubscribe_email='"+o.getUnsubscribe_email()+"', unsubscribe_body='"+o.getUnsubscribe_body()+"' where unsubscribe_id="+o.getUnsubscribe_id();
yxyunsubscribeinfodao.updateByHql(hql);
}
/**查询退订地址(根据邮件UID)*/
public List<YxyUnsubscribeInfo> findUnByUID(String loginid,String domain, String mailuid) throws Exception {
String hql="from YxyUnsubscribeInfo where unsubscribe_loginid='"+loginid+"' and unsubscribe_domain='"+domain+"' and unsubscribe_mail_uid='"+mailuid+"'";
return yxyunsubscribeinfodao.findByHql(hql);
}
/**查询用户所有退订地址(对象)*/
public List<YxyUnsubscribeInfo> findAllUnInfo(String loginid, String domain)throws Exception {
String hql="from YxyUnsubscribeInfo where unsubscribe_loginid='"+loginid+"' and unsubscribe_domain='"+domain+"'";
return yxyunsubscribeinfodao.findByHql(hql);
}
/**查询退订地址是否已存在*/
public int findisexits(String loginid, String domain, String email)
throws Exception {
String hql = "from YxyUnsubscribeInfo where unsubscribe_loginid = '"+loginid+"' and unsubscribe_domain = '"+domain+"' and unsubscribe_issys = 1 and unsubscribe_email = '"+email+"'";
List<YxyUnsubscribeInfo> list = yxyunsubscribeinfodao.findByHql(hql);
if(list.size() > 0)
{
//表示存在
return 0;
}else{
//表示不存在
return 1;
}
}
private YxyUnsubscribeInfoDao yxyunsubscribeinfodao;//退订dao
public YxyUnsubscribeInfoDao getYxyunsubscribeinfodao() {
return yxyunsubscribeinfodao;
}
public void setYxyunsubscribeinfodao(YxyUnsubscribeInfoDao yxyunsubscribeinfodao) {
this.yxyunsubscribeinfodao = yxyunsubscribeinfodao;
}
}