9d7aeeaab3f8baee112286391cb06597ba73a7a1.svn-base
2.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
package yxy.timer.method;
import java.util.List;
import yxy.timer.service.YxySendMailMasterService;
public class MailTimerSet {
@SuppressWarnings("static-access")
private void mailset(){
try {
System.out.println("整理点读功能!");
String sql="select mail_uid from yxy_send_mail_master_base where isokread=0";
List<Object> objlist=yxysendmailmasterservice.findbysql(sql);
if(objlist.size()>0){
for(int i=0;i<objlist.size();i++){
String mailuid=objlist.get(i).toString();
//查询点读
String sql1="select count(*) from yxy_reading_info where yxy_reading_mailuid='"+mailuid+"'";
List<Object> objlist1=yxysendmailmasterservice.findbysql(sql1);
int count=Integer.parseInt(objlist1.get(0).toString());
String sql2="update yxy_send_mail_master_base set reading_tol="+count+",isokread=1 where mail_uid='"+mailuid+"'";
yxysendmailmasterservice.updatebysql(sql2);
}
System.out.println("整理点读功能循环结束!");
}else{
System.out.println("整理点读功能,结束没有了!");
}
// System.out.println("更新邮件状态进来了...");
// List<YxySendMailMaster> masterList=yxysendmailmasterservice.findByStatus();
// //更新的邮件集合
// List<YxySendMailMaster> updateList=new ArrayList<YxySendMailMaster>();
// //当前时间
// SimpleDateFormat df=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
// String nowDate=df.format(new Date());
//
// //判断发送时间是否是在之前一个小时
// long timernum=0;
// for(int i=0;i<masterList.size();i++){
// if(masterList.get(i).getResult_remark()!=null&&!masterList.get(i).getResult_remark().equals("")){
// timernum=DateFormat.minutes(masterList.get(i).getResult_remark(),nowDate);
// //是否大于一个小时了
// if(timernum>60){
// masterList.get(i).setIsuse(0);
// masterList.get(i).setResult_remark(nowDate);
// updateList.add(masterList.get(i));
// }
// }
// }
// yxysendmailmasterservice.updateMaster(updateList);
//
// System.out.println("更新邮件状态完成了...");
} catch (Exception e) {
e.printStackTrace();
System.out.println("更新邮件状态异常了...");
}
}
private YxySendMailMasterService yxysendmailmasterservice;
public YxySendMailMasterService getYxysendmailmasterservice() {
return yxysendmailmasterservice;
}
public void setYxysendmailmasterservice(
YxySendMailMasterService yxysendmailmasterservice) {
this.yxysendmailmasterservice = yxysendmailmasterservice;
}
}