9d7aeeaab3f8baee112286391cb06597ba73a7a1.svn-base 2.5 KB
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;
	}
	
}