/// <summary>
/// 数据库基础表数据导出到json文件
/// </summary>
/// <param name="tableName">指定表名称</param>
/// <param name="path">存放路径</param>
/// <returns></returns>
public async Task <string> ExportTable(string tableName, string path)
{
string outPaths = string.Empty;
Dictionary <string, string> dic = new Dictionary <string, string>();
switch (tableName.ToLower())
{
case "user":
dic.Add(typeof(User).Name, JsonHelper.JSON(await _userSvc.Query()));
break;
case "dept":
dic.Add(typeof(Dept).Name, JsonHelper.JSON(await _deptSvc.Query()));
break;
case "role":
dic.Add(typeof(Role).Name, JsonHelper.JSON(await _roleSvc.Query()));
break;
case "menu":
dic.Add(typeof(Menu).Name, JsonHelper.JSON(await _menuSvc.Query()));
break;
case "tasksqz":
dic.Add(typeof(TasksQz).Name, JsonHelper.JSON(await _tasksQzSvc.Query()));
break;
default:
dic.Add(typeof(User).Name, JsonHelper.JSON(await _userSvc.Query()));
dic.Add(typeof(Dept).Name, JsonHelper.JSON(await _deptSvc.Query()));
dic.Add(typeof(Role).Name, JsonHelper.JSON(await _roleSvc.Query()));
dic.Add(typeof(Menu).Name, JsonHelper.JSON(await _menuSvc.Query()));
dic.Add(typeof(TasksQz).Name, JsonHelper.JSON(await _tasksQzSvc.Query()));
break;
}
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
foreach (var item in dic)
{
string filePath = Path.Combine(path, $@"{item.Key}.json");
using (FileStream fs = new FileStream(filePath, FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.ReadWrite))
{
fs.SetLength(0); //清空文件内容
using (StreamWriter sw = new StreamWriter(fs, Encoding.UTF8))
{
sw.WriteLine(item.Value);
}
}
outPaths += $"表{item.Key}-数据生成：{filePath} || ";
}
return(outPaths[0..^ 4]);
public static void UseQuartzJobMildd(this IApplicationBuilder app, ITasksQzSvc tasksQzSvc, ISchedulerCenter schedulerCenter)
{
if (app == null)
{
throw new ArgumentNullException(nameof(app));
}
try
{
if (Appsettings.App("Middleware", "QuartzNetJob", "Enabled").ToBoolReq())
{
var allQzServices = tasksQzSvc.Query().Result;
foreach (var item in allQzServices)
{
if (item.JobStatus == JobStatus.运行中)
{
var ResuleModel = schedulerCenter.AddScheduleJobAsync(item).Result;
if (ResuleModel.Success)
{
Console.WriteLine($"QuartzNetJob{item.JobName}启动成功！");
}
else
{
Console.WriteLine($"QuartzNetJob{item.JobName}启动失败！错误信息：{ResuleModel.Message}");
}
}
}
}
}
catch (Exception e)
{
log.Error($"An error was reported when starting the job service.\n{e.Message}");
throw;
}
}
public async Task <object> GetTasksQz(string ids, string jobName = "")
{
var data = await _tasksQzSvc.Query();
if (!string.IsNullOrEmpty(ids))
{
data = data.Where(a => ids.SplitInt(",").Contains(a.Id)).ToList();
}
if (!string.IsNullOrEmpty(jobName))
{
data = data.Where(a => a.JobName != null && a.JobName.Contains(jobName)).ToList();
}
if (data.Count > 0)
{
foreach (var item in data)
{
item.Triggers = await _schedulerCenter.GetTaskStaus(item);
}
}
return(new MessageModel <List <TasksQz> >()
{
Message = "获取成功",
Success = true,
Response = data
});
}