提交

username@email.com

2025-05-15 6fe02a16e55f17e45a3997171e1b2284d45af25b

 CY_ECommercePlatform/CY.WebForm/Global.asax.cs

@@ -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

        }