eed2a2b428af043cd98af53e5a32ef2cf7ce4617.svn-base
5.5 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
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
package com.espeed.dao.impl;
import java.util.List;
import com.espeed.dao.YxySendMailMasterBaseDao;
import com.espeed.pojo.YxySendMailMasterBase;
import com.espeed.vo.PageBean;
/**
* 程序名称: EspeedMail_时速邮箱
* 程序版本: V1.0
* 作 者: 深圳市科飞时速网络技术有限公司(0755-88843776)
* 版权所有: 深圳市科飞时速网络技术有限公司
* 技术支持: Tech@21gmail.com
* 单元名称: 邮件基本信息DAO(营销游)
* 开始时间: 2013.12.09
* 程 序 员: 谢勇
* 最后修改:
* 备 注: 如需修改请通知程序员
*/
public class YxySendMailMasterBaseDaoImpl extends HibernateBaseDAOImpl<YxySendMailMasterBase, Long> implements YxySendMailMasterBaseDao{
/**实体插入*/
public int addPojo(YxySendMailMasterBase o)throws Exception{
return super.add(o);
}
/**实体编辑*/
public void updatePojo(YxySendMailMasterBase o)throws Exception{
super.update(o);
}
/**HQL查询*/
public List<YxySendMailMasterBase> findByHql(String hql)throws Exception{
return super.getAll(hql);
}
/**指定条记录*/
public List<YxySendMailMasterBase> findByHqlSet(String hql,int num)throws Exception{
return super.findBySet(hql, num);
}
/**HQL查询分页*/
public List<YxySendMailMasterBase> findByHqlPage(String hql,String hqlcount,PageBean pb)throws Exception{
return super.findByPage(hql, hqlcount, pb);
}
/**SQL查询*/
public List<Object> findBySqlQuery(String sql)throws Exception{
return super.findBySql(sql);
}
/**HQL更新*/
public void updateByHql(String hql)throws Exception{
super.updateorDelByHql(hql);
}
/**HQL数量查询*/
public int findByHqlCount(String hql)throws Exception{
return super.count(hql);
}
// /**添加邮件信息返回ID*/
// public int addMaster(YxySendMailMasterBase o) throws Exception {
//
// return super.add(o);
// }
// /**分页查询待发邮件列表(根据状态)*/
// public List<YxySendMailMasterBase> findByStatus(int status, PageBean pb,String loginid,String domain) throws Exception {
// String hql="";
// String hqlCount="";
// if(loginid.equals("all")){
// hql="from YxySendMailMasterBase where status="+status +" and user_domain='"+domain+"' order by create_time desc";
// hqlCount="select count(send_mail_id) from YxySendMailMasterBase where status="+status +" and user_domain='"+domain+"' order by create_time desc";
// }else{
// hql="from YxySendMailMasterBase where status="+status +" and user_loginid='"+loginid+"' and user_domain='"+domain+"' order by create_time desc";
// hqlCount="select count(send_mail_id) from YxySendMailMasterBase where status="+status +" and user_loginid='"+loginid+"' and user_domain='"+domain+"' order by create_time desc";
// }
// return super.findByPage(hql, hqlCount,pb);
// }
//
// /**分页查询待发邮件列表(根据类别)*/
// public List<YxySendMailMasterBase> findByType(int typeID, PageBean pb,String loginid, String domain) throws Exception {
// String hql="from YxySendMailMasterBase where folder_id="+typeID +" and status=1 and user_loginid='"+loginid+"' and user_domain='"+domain+"' order by create_time desc";
// String hqlCount="select count(send_mail_id) from YxySendMailMasterBase where folder_id="+typeID +" and status=1 and user_loginid='"+loginid+"' and user_domain='"+domain+"' order by create_time desc";
// return super.findByPage(hql, hqlCount,pb);
// }
// /**查询邮件详细信息(根据邮件ID)*/
// public YxySendMailMasterBase findMasterBaseByID(int mailID)
// throws Exception {
// String hql="from YxySendMailMasterBase where send_mail_id="+mailID;
// List<YxySendMailMasterBase> resultList=super.getAll(hql);
// if(resultList.size()>0){
// return resultList.get(0);
// }else{
// return null;
// }
// }
// /**更新base表为已发送状态*/
// public void updateMasterBase(String sql) throws Exception {
// super.updateorDelBySql(sql);
// }
// /**通过邮件ID删除邮件*/
// public void delMailByID(int mailID) throws Exception {
// String sql="delete YxySendMailMasterBase where send_mail_id="+mailID;
// super.updateorDelBySql(sql);
// }
//
//
// /**根据状态查询邮件量*/
// public List findMailNumByStatus(String loginid, String domain, int status)
// throws Exception {
// String sql="select sum(send_num) from yxy_send_mail_master_base where user_loginid='"+loginid+"' and user_domain='"+domain+"' and status="+status;
// return super.findBySql(sql);
// }
//
// /**查询邮件信息*/
// public YxySendMailMasterBase findMail(String loginid, String domain,
// String mailUID) throws Exception {
// String hql="from YxySendMailMasterBase where user_loginid='"+loginid+"' and user_domain='"+domain+"' and mail_uid='"+mailUID+"'";
// List<YxySendMailMasterBase> result=super.getAll(hql);
// if(result.size()>0){
// return result.get(0);
// }else{
// return null;
// }
//
// }
//
// /**查询该类别下的邮件*/
// public List<YxySendMailMasterBase> findByTypeAll(int typeID,String loginid, String domain) throws Exception {
// String hql="from YxySendMailMasterBase where folder_id="+typeID +" and user_loginid='"+loginid+"' and user_domain='"+domain+"' order by create_time desc";
// return super.getAll(hql);
// }
// /**查询所有已发邮件*/
// public List<YxySendMailMasterBase> findBySendMail() throws Exception {
// String hql="from YxySendMailMasterBase where status=1";
// return super.getAll(hql);
// }
// /**更新邮件列表点击量*/
// public void updateBaseClick(List<YxySendMailMasterBase> o) throws Exception {
// super.updatePiBase(o);
//
// }
}