using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Web;
|
using System.Web.Security;
|
using System.Web.SessionState;
|
using System.Web.Routing;
|
using CY.WebForm.Helper;
|
using CY.BLL;
|
using System.Data.SqlClient;
|
using CY.SQLDAL;
|
using CY.Infrastructure.Logging;
|
using System.Data;
|
using System.Globalization;
|
|
namespace CY.WebForm
|
{
|
public class Global : System.Web.HttpApplication
|
{
|
|
void Application_Start(object sender, EventArgs e)
|
{
|
// 在应用程序启动时运行的代码
|
log4net.Config.XmlConfigurator.Configure(new System.IO.FileInfo(Server.MapPath("~/config/log4net.config")));
|
// 在应用程序启动时运行的代码
|
TimeTaskHelper.Instance().ExecuteTask += new System.Timers.ElapsedEventHandler(Global_ExecuteTask);
|
TimeTaskHelper.Instance().Interval = 1000*3000;//表示间隔 1个小时
|
TimeTaskHelper.Instance().Start();
|
}
|
void Global_ExecuteTask(object sender, System.Timers.ElapsedEventArgs e)
|
{
|
//在这里编写需要定时执行的逻辑代码
|
|
//这里执行定时任务
|
DateTime time = DateTime.Now;
|
#region 未完结客户例行置位
|
|
|
var data = time.ToString("ddd HH");
|
if (data == "周一 1")
|
{
|
|
Database DC = new Database();
|
string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [NeedWiHu] = 'true' WHERE[Shifouwanjie] = 2";
|
|
try
|
{
|
SqlCommand myCmd = new SqlCommand(sqlStr, DC.Connection);
|
//SqlDataAdapter myDa = new SqlDataAdapter(myCmd);
|
int a = myCmd.ExecuteNonQuery();
|
//myDa.Dispose();
|
|
|
}
|
catch (Exception ee)
|
{
|
new Log4NetAdapter().Log("周一执行为完结客户 提醒设置失败 错误：" + ee.Message);
|
|
}
|
finally
|
{
|
if (DC.Connection.State != System.Data.ConnectionState.Closed)
|
DC.Connection.Close();
|
}
|
|
|
|
|
|
|
|
|
}
|
|
#endregion
|
#region 已完结客户维护置位
|
|
|
string strtime = time.ToString("MM dd HH");
|
if (strtime == "01 01 01" || strtime == "04 01 01" || strtime == "07 01 01" || strtime == "10 01 01")
|
{
|
//1 、4、7、10月 1号1点，刷新 已完结订单的维护提醒
|
Database DC = new Database();
|
string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [NeedWiHu] = 'true' WHERE[Shifouwanjie] = 1";
|
|
try
|
{
|
SqlCommand myCmd = new SqlCommand(sqlStr, DC.Connection);
|
//SqlDataAdapter myDa = new SqlDataAdapter(myCmd);
|
int a = myCmd.ExecuteNonQuery();
|
//myDa.Dispose();
|
|
|
}
|
catch (Exception ee)
|
{
|
new Log4NetAdapter().Log("完结订单客户3个月一次提醒错误 提醒设置失败 错误：" + ee.Message);
|
|
}
|
finally
|
{
|
if (DC.Connection.State != System.Data.ConnectionState.Closed)
|
DC.Connection.Close();
|
}
|
}
|
#endregion
|
#region 节日提醒置位
|
|
|
///以下为节日提醒
|
var date20days= time.AddDays(20);
|
|
ChineseLunisolarCalendar chineseLunisolarCalendar = new ChineseLunisolarCalendar();
|
int lyear = chineseLunisolarCalendar.GetYear(date20days);
|
int lmonth = chineseLunisolarCalendar.GetMonth(date20days);
|
int lday = chineseLunisolarCalendar.GetDayOfMonth(date20days);
|
//获取闰月， 0 则表示没有闰月
|
int leapMonth = chineseLunisolarCalendar.GetLeapMonth(lyear);
|
|
|
if(lmonth==1&&lday==1&& time.Hour==1)
|
{
|
|
Database DC = new Database();
|
string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'true'";
|
|
try
|
{
|
SqlCommand myCmd = new SqlCommand(sqlStr, DC.Connection);
|
//SqlDataAdapter myDa = new SqlDataAdapter(myCmd);
|
int a = myCmd.ExecuteNonQuery();
|
//myDa.Dispose();
|
|
|
}
|
catch (Exception ee)
|
{
|
new Log4NetAdapter().Log("春节设置提醒错误 错误：" + ee.Message);
|
|
}
|
finally
|
{
|
if (DC.Connection.State != System.Data.ConnectionState.Closed)
|
DC.Connection.Close();
|
}
|
|
//春节提醒
|
}
|
if (leapMonth == 0)
|
{
|
//没有闰月
|
if (lmonth == 8 && lday == 15&&time.Hour==1)
|
{
|
//中秋节提醒
|
Database DC = new Database();
|
string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'true'";
|
|
try
|
{
|
SqlCommand myCmd = new SqlCommand(sqlStr, DC.Connection);
|
//SqlDataAdapter myDa = new SqlDataAdapter(myCmd);
|
int a = myCmd.ExecuteNonQuery();
|
//myDa.Dispose();
|
|
|
}
|
catch (Exception ee)
|
{
|
new Log4NetAdapter().Log("中秋节提醒错误 错误：" + ee.Message);
|
|
}
|
finally
|
{
|
if (DC.Connection.State != System.Data.ConnectionState.Closed)
|
DC.Connection.Close();
|
}
|
|
}
|
|
if (lmonth == 5 && lday == 5 && time.Hour == 1)
|
{
|
//端午节
|
Database DC = new Database();
|
string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'true'";
|
|
try
|
{
|
SqlCommand myCmd = new SqlCommand(sqlStr, DC.Connection);
|
//SqlDataAdapter myDa = new SqlDataAdapter(myCmd);
|
int a = myCmd.ExecuteNonQuery();
|
//myDa.Dispose();
|
|
|
}
|
catch (Exception ee)
|
{
|
new Log4NetAdapter().Log("端午节设置提醒错误 错误：" + ee.Message);
|
|
}
|
finally
|
{
|
if (DC.Connection.State != System.Data.ConnectionState.Closed)
|
DC.Connection.Close();
|
}
|
|
}
|
}
|
else
|
{
|
//有闰月
|
//没有闰月
|
int ms = 8;
|
if (leapMonth < 8)
|
ms++;
|
if (lmonth == ms && lday == 15 && time.Hour == 1)
|
{
|
//中秋节提醒
|
Database DC = new Database();
|
string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'true'";
|
|
try
|
{
|
SqlCommand myCmd = new SqlCommand(sqlStr, DC.Connection);
|
//SqlDataAdapter myDa = new SqlDataAdapter(myCmd);
|
int a = myCmd.ExecuteNonQuery();
|
//myDa.Dispose();
|
|
|
}
|
catch (Exception ee)
|
{
|
new Log4NetAdapter().Log("中秋节设置提醒错误 错误：" + ee.Message);
|
|
}
|
finally
|
{
|
if (DC.Connection.State != System.Data.ConnectionState.Closed)
|
DC.Connection.Close();
|
}
|
|
}
|
|
ms = 5;
|
if (leapMonth < 5)
|
ms++;
|
if (lmonth == ms && lday == 5 && time.Hour == 1)
|
{
|
//端午节
|
Database DC = new Database();
|
string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'true'";
|
|
try
|
{
|
SqlCommand myCmd = new SqlCommand(sqlStr, DC.Connection);
|
//SqlDataAdapter myDa = new SqlDataAdapter(myCmd);
|
int a = myCmd.ExecuteNonQuery();
|
//myDa.Dispose();
|
|
|
}
|
catch (Exception ee)
|
{
|
new Log4NetAdapter().Log("端午节设置提醒错误 错误：" + ee.Message);
|
|
}
|
finally
|
{
|
if (DC.Connection.State != System.Data.ConnectionState.Closed)
|
DC.Connection.Close();
|
}
|
|
}
|
}
|
#endregion
|
#region 节日提醒过期置位取消
|
///以下为节日提醒
|
|
|
ChineseLunisolarCalendar chineseLunisolarCalendar2 = new ChineseLunisolarCalendar();
|
lyear = chineseLunisolarCalendar2.GetYear(time);
|
lmonth = chineseLunisolarCalendar2.GetMonth(time);
|
lday = chineseLunisolarCalendar2.GetDayOfMonth(time);
|
//获取闰月， 0 则表示没有闰月
|
leapMonth = chineseLunisolarCalendar.GetLeapMonth(lyear);
|
|
|
if (lmonth == 1 && lday == 1 && time.Hour == 1)
|
{
|
|
Database DC = new Database();
|
string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'false'";
|
|
try
|
{
|
SqlCommand myCmd = new SqlCommand(sqlStr, DC.Connection);
|
//SqlDataAdapter myDa = new SqlDataAdapter(myCmd);
|
int a = myCmd.ExecuteNonQuery();
|
//myDa.Dispose();
|
|
|
}
|
catch (Exception ee)
|
{
|
new Log4NetAdapter().Log("春节设置提醒错误 错误：" + ee.Message);
|
|
}
|
finally
|
{
|
if (DC.Connection.State != System.Data.ConnectionState.Closed)
|
DC.Connection.Close();
|
}
|
|
//春节提醒
|
}
|
|
if (leapMonth == 0)
|
{
|
//没有闰月
|
if (lmonth == 8 && lday == 15 && time.Hour == 1)
|
{
|
//中秋节提醒
|
Database DC = new Database();
|
string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'false'";
|
|
try
|
{
|
SqlCommand myCmd = new SqlCommand(sqlStr, DC.Connection);
|
//SqlDataAdapter myDa = new SqlDataAdapter(myCmd);
|
int a = myCmd.ExecuteNonQuery();
|
//myDa.Dispose();
|
|
|
}
|
catch (Exception ee)
|
{
|
new Log4NetAdapter().Log("中秋节提醒错误 错误：" + ee.Message);
|
|
}
|
finally
|
{
|
if (DC.Connection.State != System.Data.ConnectionState.Closed)
|
DC.Connection.Close();
|
}
|
|
}
|
|
if (lmonth == 5 && lday == 5 && time.Hour == 1)
|
{
|
//端午节
|
Database DC = new Database();
|
string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'false'";
|
|
try
|
{
|
SqlCommand myCmd = new SqlCommand(sqlStr, DC.Connection);
|
//SqlDataAdapter myDa = new SqlDataAdapter(myCmd);
|
int a = myCmd.ExecuteNonQuery();
|
//myDa.Dispose();
|
|
|
}
|
catch (Exception ee)
|
{
|
new Log4NetAdapter().Log("端午节设置提醒错误 错误：" + ee.Message);
|
|
}
|
finally
|
{
|
if (DC.Connection.State != System.Data.ConnectionState.Closed)
|
DC.Connection.Close();
|
}
|
|
}
|
}
|
else
|
{
|
//有闰月
|
|
int ms = 8;
|
if (leapMonth < 8)
|
ms++;
|
if (lmonth == ms && lday == 15 && time.Hour == 1)
|
{
|
//中秋节提醒
|
Database DC = new Database();
|
string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'false'";
|
|
try
|
{
|
SqlCommand myCmd = new SqlCommand(sqlStr, DC.Connection);
|
//SqlDataAdapter myDa = new SqlDataAdapter(myCmd);
|
int a = myCmd.ExecuteNonQuery();
|
//myDa.Dispose();
|
|
|
}
|
catch (Exception ee)
|
{
|
new Log4NetAdapter().Log("中秋节设置提醒错误 错误：" + ee.Message);
|
|
}
|
finally
|
{
|
if (DC.Connection.State != System.Data.ConnectionState.Closed)
|
DC.Connection.Close();
|
}
|
|
}
|
|
ms = 5;
|
if (leapMonth < 5)
|
ms++;
|
if (lmonth == ms && lday == 5 && time.Hour == 1)
|
{
|
//端午节
|
Database DC = new Database();
|
string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'false'";
|
|
try
|
{
|
SqlCommand myCmd = new SqlCommand(sqlStr, DC.Connection);
|
//SqlDataAdapter myDa = new SqlDataAdapter(myCmd);
|
int a = myCmd.ExecuteNonQuery();
|
//myDa.Dispose();
|
|
|
}
|
catch (Exception ee)
|
{
|
new Log4NetAdapter().Log("端午节设置提醒错误 错误：" + ee.Message);
|
|
}
|
finally
|
{
|
if (DC.Connection.State != System.Data.ConnectionState.Closed)
|
DC.Connection.Close();
|
}
|
|
}
|
}
|
|
|
#endregion
|
|
}
|
|
protected void Application_BeginRequest(Object sender, EventArgs e)
|
{
|
|
}
|
|
void Application_End(object sender, EventArgs e)
|
{
|
// 在应用程序关闭时运行的代码
|
|
}
|
|
void Application_Error(object sender, EventArgs e)
|
{
|
// 在出现未处理的错误时运行的代码
|
|
}
|
|
void Session_Start(object sender, EventArgs e)
|
{
|
// 在新会话启动时运行的代码
|
|
}
|
|
void Session_End(object sender, EventArgs e)
|
{
|
// 在会话结束时运行的代码。
|
// 注意: 只有在 Web.config 文件中的 sessionstate 模式设置为
|
// InProc 时，才会引发 Session_End 事件。如果会话模式设置为 StateServer
|
// 或 SQLServer，则不会引发该事件。
|
|
}
|
|
}
|
}
|
