From dcd80459e1ad3b7fc9ba6bcd581feb430f0778d3 Mon Sep 17 00:00:00 2001
From: Ben Lin <maobin001@msn.com>
Date: 星期六, 26 十月 2024 00:35:01 +0800
Subject: [PATCH] 计划任务更新

---
 Tiger.Business/Services/Base/InterfaceServiceNew.cs |  304 +++++++++++++++++++++++++++++++++----------------
 1 files changed, 203 insertions(+), 101 deletions(-)

diff --git a/Tiger.Business/Services/Base/InterfaceServiceNew.cs b/Tiger.Business/Services/Base/InterfaceServiceNew.cs
index 04ebaa3..c876b3d 100644
--- a/Tiger.Business/Services/Base/InterfaceServiceNew.cs
+++ b/Tiger.Business/Services/Base/InterfaceServiceNew.cs
@@ -5,19 +5,23 @@
 using System.Collections;
 using System.Collections.Generic;
 using System.Linq;
+using System.Security.Cryptography;
 using System.Text;
 using System.Threading;
 using System.Threading.Tasks;
 using Tiger.IBusiness;
 using Tiger.Model;
+using Tiger.Model.Entitys.MES.Position;
 using Tiger.Model.Minsun;
+using static Microsoft.CodeAnalysis.CSharp.SyntaxTokenParser;
+using static Tiger.Model.TrigArgs;
 
 namespace Tiger.Business
 {
     /// <summary>
     /// 
     /// </summary>
-    public class InterfaceServiceNew: IInterfaceService
+    public class InterfaceServiceNew : IInterfaceService
     {
         #region Sundial璁″垝璋冨害 鏃х増鏈娇鐢�
 
@@ -40,7 +44,7 @@
         public ApiAction AddJob<TJob>(TJob newEntity, TskJobParam jobParam) where TJob : class, Sundial.IJob
         {
             ApiAction apiAction = new();
-            Sundial.TriggerBuilder triggerBuilder = Sundial.Triggers.Period(jobParam.Period*60*1000).LoadFrom(new
+            Sundial.TriggerBuilder triggerBuilder = Sundial.Triggers.Period(jobParam.Period * 60 * 1000).LoadFrom(new
             {
                 TriggerId = jobParam.JobName + "_trigger1",
             });
@@ -203,20 +207,20 @@
         {
             try
             {
-	            var jobs = Biz.Db.Queryable<TSK_JOB>().IncludesAllFirstLayer().ToList();
-	            foreach (var job in jobs)
-	            {
-	                Type type = Type.GetType($"{job.AssemblyName}.{job.JobType},{job.AssemblyName}", throwOnError: true);
-	                _schedulerFactory.AddJob(type, job.JobName, Sundial.Triggers.Period(Convert.ToInt32(job.Triggers?[0].Args ?? "3") * 60 * 1000));
-	                if (job.Triggers[0]?.Status == 3)
-	                {
-	                    Work.DoAsync(() =>
-	                    {
-	                        Thread.Sleep(2000);
-	                        PauseJob(job.JobName);
-	                    });
-	                }
-	            }
+                var jobs = Biz.Db.Queryable<TSK_JOB>().IncludesAllFirstLayer().ToList();
+                foreach (var job in jobs)
+                {
+                    Type type = Type.GetType($"{job.AssemblyName}.{job.JobType},{job.AssemblyName}", throwOnError: true);
+                    _schedulerFactory.AddJob(type, job.JobName, Sundial.Triggers.Period(Convert.ToInt32(job.Triggers?[0].Args ?? "3") * 60 * 1000));
+                    if (job.Triggers[0]?.Status == 3)
+                    {
+                        Work.DoAsync(() =>
+                        {
+                            Thread.Sleep(2000);
+                            PauseJob(job.JobName);
+                        });
+                    }
+                }
             }
             catch (System.Exception ex)
             {
@@ -266,10 +270,38 @@
         /// </summary>
         public void JobInitialize()
         {
-            JobManager.Initialize();
+            JobManager.Initialize(AddJobsFromDB());
             JobManager.JobException += info => Logger.Scheduler.Error("An error just happened with a scheduled job: " + info.Exception);
-            JobManager.JobStart += info => Logger.Scheduler.Info($"{info.Name}: started");
-            JobManager.JobEnd += info => Logger.Scheduler.Info($"{info.Name}: ended ({info.Duration})");
+            JobManager.JobStart += info => Logger.Scheduler.Info($"{info.Name}: started\r\n");
+            JobManager.JobEnd += info => Logger.Scheduler.Info($"{info.Name}: ended ({info.Duration})\r\n");
+            SaveRunningStatus(); //淇濆瓨鐘舵��
+        }
+
+        private void SaveRunningStatus() {
+            TSK_TRIG trig = new TSK_TRIG();
+            foreach (var schedule in JobManager.RunningSchedules)
+            {
+                var job = Biz.Db.Queryable<TSK_JOB>().Where(q => q.JobName == schedule.Name).First();
+                if (job != null)
+                {
+                    trig = Biz.Db.Queryable<TSK_TRIG>().Where(q => q.JobId == job.ID).First();
+                    trig.Status = TSK_TRIG.Statuss.Running.GetValue();
+                    trig.StartTime = DateTime.Now;
+                }
+            }
+            var db = Biz.Db;
+            //淇濆瓨鍒版暟鎹簱
+            var dbTran = db.UseTran(() =>
+            {
+                if (trig != null)
+                {
+                    db.Updateable(trig, "system").UpdateColumns(q => new { q.Status, q.UPDATE_USER, q.UPDATE_TIME }).ExecuteCommand();
+                }
+            });
+            if (!dbTran.IsSuccess)
+            {
+                Logger.Scheduler.Trace(dbTran.ErrorException, $"浣滀笟淇濆瓨鍒版暟鎹簱寮傚父");
+            }
         }
 
         /// <summary>
@@ -279,25 +311,51 @@
         /// <param name="newEntity"></param>
         /// <param name="jobParam"></param>
         /// <returns></returns>
-        public ApiAction AddJob<TJob>(TJob newEntity, FluentJobParam jobParam) where TJob : class, IJob
+        public ApiAction AddJob<TJob>(TJob newEntity, FluentJobParam jobParam) where TJob : class, ITJob
         {
             ApiAction apiAction = new();
             try
             {
-                JobManager.AddJob<TJob>((s) => s.ToRunEvery(5).Seconds());
-                //Sundial.TriggerBuilder triggerBuilder = Sundial.Triggers.Period(jobParam.Period * 60 * 1000).LoadFrom(new
-                //{
-                //    TriggerId = jobParam.JobName + "_trigger1",
-                //});
-                //_schedulerFactory.AddJob<TJob>(jobParam.JobName, triggerBuilder);
-                //var trigger = GetJob(jobParam.JobName).GetTrigger($"{jobParam.JobName}_trigger1");
-                //TSK_JOB entity = ReturnDetail(jobParam.JobName);
-                //entity.Remark = jobParam.Remark;
-                //entity.JobType = typeof(TJob).Name;
-                //entity.JobName = jobParam.JobName;
-                //entity.TriggersWithGhost = new List<TSK_TRIG> { JsonConvert.DeserializeObject<TSK_TRIG>(JsonConvert.SerializeObject(trigger)) };
-                //entity.Triggers[0].Args = jobParam.Period.ToString();
-                //apiAction = SaveJob(entity);
+                JobManager.AddJob<TJob>((s) => GenerateSchedule(jobParam.Args, s.WithName(typeof(TJob).Name)));
+                string guid = Guid.NewGuid().ToString("N");
+                var trigger = new TSK_TRIG()
+                {
+                    JobId = guid,
+                    Args = JsonConvert.SerializeObject(jobParam.Args),
+                    Status = TSK_TRIG.Statuss.Running.GetValue(),
+                    StartTime = DateTime.Now,
+                    NumberOfRuns = 1,
+                };
+                TSK_JOB job = new()
+                {
+                    ID = guid,
+                    Remark = jobParam.Remark,
+                    JobType = typeof(TJob).Name,
+                    AssemblyName = jobParam.AssemblyName,
+                    JobName = jobParam.JobName,
+                };
+                if (Biz.Db.Queryable<TSK_JOB>().Any(q=>q.JobName == typeof(TJob).Name)) {
+                    apiAction.IsSuccessed = false;
+                    apiAction.LocaleMsg = new($"浠诲姟宸茬粡瀛樺湪");
+                    return apiAction;
+                }
+                var db = Biz.Db;
+                //淇濆瓨鍒版暟鎹簱
+                var dbTran = db.UseTran(() =>
+                {
+                    if (job != null)
+                    {
+                        db.Insertable(job, "system").ExecuteCommand();
+                    }
+                    if (trigger != null)
+                    {
+                        db.Insertable(trigger, "system").ExecuteCommand();
+                    }
+                });
+                if (!dbTran.IsSuccess)
+                {
+                    Logger.Scheduler.Trace(dbTran.ErrorException, $"娣诲姞宸ヤ綔浠诲姟鏃朵繚瀛樺埌鏁版嵁搴撳紓甯�");
+                }
                 //apiAction.Data = entity;
 
             }
@@ -309,87 +367,39 @@
         }
 
         /// <summary>
+        /// 鍒犻櫎浣滀笟
+        /// </summary>
+        /// <param name="jobname"></param>
+        public void RemovefJob(string jobname)
+        {
+            JobManager.RemoveJob(jobname);
+        }
+
+        /// <summary>
         /// 浠庢暟鎹簱鎵归噺娣诲姞浠诲姟
         /// </summary>
-        public void AddJobsFromDB()
+        public Registry AddJobsFromDB()
         {
+            // 澹版槑涓�涓猂egistry绫�
+            var registry = new Registry();
             try
             {
                 var jobs = Biz.Db.Queryable<TSK_JOB>().IncludesAllFirstLayer().ToList();
-                // 澹版槑涓�涓猂egistry绫�
-                var registry = new Registry();
                 foreach (var job in jobs)
                 {
                     Type type = Type.GetType($"{job.AssemblyName}.{job.JobType},{job.AssemblyName}", throwOnError: true);
                     dynamic _type = Activator.CreateInstance(type);
                     TrigArgs args = JsonConvert.DeserializeObject<TrigArgs>(job.Triggers[0].Args);
-                    Schedule schedule = Schedule(_type,job.JobName, registry);
-                    SpecificTimeUnit specificTimeUnit = null;
-                    TimeUnit timeUnit = null;
-                    if (args.NonReentrant == "Y") { schedule = schedule.NonReentrant(); }
-                    if (args.ToRunNow == "Y") { specificTimeUnit = schedule.ToRunNow(); }
-                    if (args.ToRunOnceIn > 0) { timeUnit = schedule.ToRunOnceIn(args.ToRunOnceIn); }
-                    else if (args.ToRunEvery >= 0) { timeUnit = schedule.ToRunEvery(args.ToRunEvery); }
-                    //鎸夋椂闂寸被鍨嬫潵杩愯
-                    switch (args.Type)
-                    {
-                        case TrigArgs.EveryType.Milliseconds:
-                            timeUnit.Milliseconds();
-                            break;
-                        case TrigArgs.EveryType.Seconds:
-                            timeUnit.Seconds();
-                            break;
-                        case TrigArgs.EveryType.Minutes:
-                            timeUnit.Minutes();
-                            break;
-                        case TrigArgs.EveryType.Hours:
-                            if (args.Minutes > 0)
-                            {
-                                timeUnit.Hours().At(args.Minutes);
-                            }
-                            else
-                            {
-                                timeUnit.Hours();
-                            }
-                            break;
-                        case TrigArgs.EveryType.Days:
-                            if (args.Hours>0 && args.Minutes > 0 )
-                            {
-                                timeUnit.Days().At(args.Hours, args.Minutes);
-                            }
-                            else
-                            {
-                                timeUnit.Days();
-                            }
-                            break;
-                        case TrigArgs.EveryType.Weeks:
-                            if (args.Hours > 0 && args.Minutes > 0)
-                            {
-                                timeUnit.Weeks().At(args.Hours, args.Minutes);
-                            }
-                            else
-                            {
-                                timeUnit.Weeks();
-                            }
-                            break;
-                        case TrigArgs.EveryType.Weekdays:
-                            if (args.Hours > 0 && args.Minutes > 0)
-                            {
-                                timeUnit.Weekdays().At(args.Hours, args.Minutes);
-                            }
-                            else
-                            {
-                                timeUnit.Weekdays();
-                            }
-                            break;
-                    }
-
+                    Schedule schedule = Schedule(_type, job.JobName, registry);
+                    //鐢熸垚璁″垝
+                    GenerateSchedule(args, schedule);
                 }
             }
             catch (System.Exception ex)
             {
                 Logger.Console.Fatal(ex, "Add Job From DB Exception");
             }
+            return registry;
         }
 
         /// <summary>
@@ -400,9 +410,100 @@
         /// <param name="JobName"></param>
         /// <param name="registry"></param>
         /// <returns></returns>
-        private Schedule Schedule<TJob>(TJob entity, string JobName, Registry registry) where TJob : class, IJob
+        private Schedule Schedule<TJob>(TJob entity, string JobName, Registry registry) where TJob : class, ITJob
         {
-            return registry.Schedule<TJob>().WithName(JobName);
+            return registry.Schedule<TJob>().WithName(typeof(TJob).Name);
+        }
+
+        /// <summary>
+        /// 鐢熸垚璁″垝
+        /// </summary>
+        /// <param name="args"></param>
+        /// <param name="schedule"></param>
+        private void GenerateSchedule(TrigArgs args, Schedule schedule)
+        {
+            SpecificTimeUnit specificTimeUnit = null;
+            TimeUnit timeUnit = null;
+            if (args.NonReentrant == "Y") { schedule = schedule.NonReentrant(); } //灏辨槸鏄惁璺熶箣鍓嶇殑杩樻病杩愯瀹岀殑璁″垝鍚屾椂杩愯銆�
+            switch (args.runType)
+            {
+                case RunType.ToRunNow:
+                    specificTimeUnit = schedule.ToRunNow(); //椹笂杩愯
+                    break;
+                case RunType.ToRunOnceAt:
+                    specificTimeUnit = schedule.ToRunOnceAt(args.ToRunOnceAtDt.AddMinutes(args.NowAddMinutes)); //杩愯涓�娆″湪鍝釜鏃堕棿,
+                    break;
+                case RunType.ToRunOnceIn:
+                    timeUnit = schedule.ToRunOnceIn(args.ToRunOnceIn); //鍦ㄥ灏戝悗杩愯涓�娆�
+                    break;
+                case RunType.ToRunEvery:
+                    timeUnit = schedule.ToRunEvery(args.ToRunEvery); //姣忛殧澶氬皯杩愯涓�鍥�
+                    break;
+            }
+            if (specificTimeUnit != null) { timeUnit = specificTimeUnit.AndEvery(args.ToRunEvery); } //姣忛殧澶氬皯杩愯涓�鍥烇紝鍔犲湪ToRunNow銆乀oRunOnceAt鍚庨潰
+            //鎸夋椂闂寸被鍨嬫潵杩愯
+            switch (args.Type)
+            {
+                case TrigArgs.EveryType.Milliseconds:
+                    timeUnit.Milliseconds();
+                    break;
+                case TrigArgs.EveryType.Seconds:
+                    timeUnit.Seconds(); //琛ㄧず鎸夌锛屽灏戠瑕佺湅鍓嶉潰Every鐨勬暟锛屾瘮濡傦細ToRunEvery(5).Seconds() 杩欎釜灏辫〃绀� 闅�5绉掕繍琛屼竴娆�
+                    break;
+                case TrigArgs.EveryType.Minutes:
+                    timeUnit.Minutes();
+                    break;
+                case TrigArgs.EveryType.Hours:
+                    if (args.Minutes > 0)
+                    {
+                        timeUnit.Hours().At(args.Minutes); //琛ㄧず鎸夋瘡灏忔椂鐨勫垎閽燂紝澶氬皯鍒嗚鐪嬪墠闈very鐨勬暟锛屾瘮濡傦細ToRunEvery(1).Hours().At(5) 杩欎釜灏辫〃绀� 闅�1灏忔椂鐨勭5鍒嗛挓杩愯涓�娆�
+                    }
+                    else
+                    {
+                        timeUnit.Hours();
+                    }
+                    break;
+                case TrigArgs.EveryType.Days:
+                    if (args.Hours > 0)
+                    {
+                        timeUnit.Days().At(args.Hours, args.Minutes); //琛ㄧず鎸夊ぉ锛屽灏戝ぉ瑕佺湅鍓嶉潰Every鐨勬暟锛屾瘮濡傦細ToRunEvery(2).Days().At(14, 15) 杩欎釜灏辫〃绀� 闅�2澶╃殑14:15杩愯涓�娆�
+                    }
+                    else
+                    {
+                        timeUnit.Days();
+                    }
+                    break;
+                case TrigArgs.EveryType.Weeks:
+                    if (args.Hours > 0)
+                    {
+                        timeUnit.Weeks().At(args.Hours, args.Minutes); //琛ㄧず鎸夊懆锛屽灏戝懆瑕佺湅鍓嶉潰Every鐨勬暟锛屾瘮濡傦細ToRunEvery(1).Weeks().At(14, 15) 杩欎釜灏辫〃绀� 闅�1鍛ㄧ殑14:15杩愯涓�娆�
+                    }
+                    else
+                    {
+                        timeUnit.Weeks();
+                    }
+                    break;
+                case TrigArgs.EveryType.Weekdays:
+                    if (args.Hours > 0 )
+                    {
+                        timeUnit.Weekdays().At(args.Hours, args.Minutes);
+                    }
+                    else
+                    {
+                        timeUnit.Weekdays();
+                    }
+                    break;
+                case TrigArgs.EveryType.Months:
+                    if (args.Days>0 && args.Hours > 0)
+                    {
+                        timeUnit.Months().On(args.Days).At(args.Hours, args.Minutes);
+                    }
+                    else
+                    {
+                        timeUnit.Months();
+                    }
+                    break;
+            }
         }
 
         /// <summary>
@@ -416,7 +517,8 @@
         /// <summary>
         /// 鍦ㄤ换鍔″畬鎴愬悗绛夊緟鎴栬�呭仠姝�
         /// </summary>
-        public void StopAndBlock() {
+        public void StopAndBlock()
+        {
             JobManager.StopAndBlock();
         }
 

--
Gitblit v1.9.3