| 123456789101112131415161718192021222324252627282930 |
- using CallCenterApi.DB;
- using Quartz;
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- namespace CallCenter.QuartzService
- {
- public class CheckPointWork : QuartzJob
- {
- public CheckPointWork()
- {
- CronExpression = "0 0 0 5 * ?";//每月5号执行
- DoWork += MyWork_DoWork;
- }
- private void MyWork_DoWork(object sender, EventArgs e)
- {
- DateTime now = DateTime.Now.AddMonths(-1);
- DateTime stime = new DateTime(now.Year, now.Month, 1);
- DateTime etime = stime.AddMonths(1).AddDays(-1);
- Dictionary<string, string> paras = new Dictionary<string, string>();
- paras.Add("@sdate", stime.ToString("yyyy-MM-dd"));
- paras.Add("@edate", etime.ToString("yyyy-MM-dd"));
- DbHelperSQL.ExecuteSql("exec P_CheckPoint @sdate,@edate", paras);
- }
- }
- }
|