chuanyin-group-project.git

			@@ -24,7 +24,7 @@
			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*10;//表示间隔 1个小时
			TimeTaskHelper.Instance().Interval = 1000*3000;//表示间隔 1个小时
			TimeTaskHelper.Instance().Start();
			}
			void Global_ExecuteTask(object sender, System.Timers.ElapsedEventArgs e)
			@@ -33,11 +33,15 @@

			//这里执行定时任务
			DateTime time = DateTime.Now;
			if (time.ToString("ddd HH") == "周一 00")
			#region 未完结客户例行置位


			var data = time.ToString("ddd HH");
			if (data == "周一 1")
			{

			Database DC = new Database();
			string sqlStr = "USE [ECTEST] UPDATE[dbo].[OA_CorporateClients] SET [NeedWiHu] = 'true' WHERE[Shifouwanjie] = 2";
			string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [NeedWiHu] = 'true' WHERE[Shifouwanjie] = 2";

			try
			{
			@@ -67,12 +71,17 @@


			}

			#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 = "USE [ECTEST] UPDATE[dbo].[OA_CorporateClients] SET [NeedWiHu] = 'true' WHERE[Shifouwanjie] = 1";
			string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [NeedWiHu] = 'true' WHERE[Shifouwanjie] = 1";

			try
			{
			@@ -94,13 +103,17 @@
			DC.Connection.Close();
			}
			}
			#endregion
			#region 节日提醒置位


			///以下为节日提醒
			time.AddDays(20);
			var date20days= time.AddDays(20);

			ChineseLunisolarCalendar chineseLunisolarCalendar = new ChineseLunisolarCalendar();
			int lyear = chineseLunisolarCalendar.GetYear(time);
			int lmonth = chineseLunisolarCalendar.GetMonth(time);
			int lday = chineseLunisolarCalendar.GetDayOfMonth(time);
			int lyear = chineseLunisolarCalendar.GetYear(date20days);
			int lmonth = chineseLunisolarCalendar.GetMonth(date20days);
			int lday = chineseLunisolarCalendar.GetDayOfMonth(date20days);
			//获取闰月，　0　则表示没有闰月
			int leapMonth = chineseLunisolarCalendar.GetLeapMonth(lyear);

			@@ -109,7 +122,7 @@
			{

			Database DC = new Database();
			string sqlStr = "USE [ECTEST] UPDATE[dbo].[OA_CorporateClients] SET [[JieJiaRiWiHu]] = 'true'";
			string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'true'";

			try
			{
			@@ -140,7 +153,7 @@
			{
			//中秋节提醒
			Database DC = new Database();
			string sqlStr = "USE [ECTEST] UPDATE[dbo].[OA_CorporateClients] SET [[JieJiaRiWiHu]] = 'true'";
			string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'true'";

			try
			{
			@@ -168,7 +181,7 @@
			{
			//端午节
			Database DC = new Database();
			string sqlStr = "USE [ECTEST] UPDATE[dbo].[OA_CorporateClients] SET [[JieJiaRiWiHu]] = 'true'";
			string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'true'";

			try
			{
			@@ -203,7 +216,7 @@
			{
			//中秋节提醒
			Database DC = new Database();
			string sqlStr = "USE [ECTEST] UPDATE[dbo].[OA_CorporateClients] SET [[JieJiaRiWiHu]] = 'true'";
			string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'true'";

			try
			{
			@@ -234,7 +247,7 @@
			{
			//端午节
			Database DC = new Database();
			string sqlStr = "USE [ECTEST] UPDATE[dbo].[OA_CorporateClients] SET [[JieJiaRiWiHu]] = 'true'";
			string sqlStr = " UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'true'";

			try
			{
			@@ -258,6 +271,176 @@

			}
			}
			#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

			}