泵状态更新

Shuxia Ning

2025-02-13 2f1cbec203dcff25df7a5c2b51b13ec558f2c3db

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
// See https://aka.ms/new-console-template for more information
 
 
using IStation;
using NPOI.HSSF.UserModel;
using NPOI.SS.Formula.Functions;
using NPOI.SS.UserModel;
 
var dt_now = DateTime.Now;
var dt_next = new DateTime(dt_now.Year, dt_now.Month, dt_now.Day, dt_now.Hour, dt_now.Minute + 1, 0);
var dt_space = dt_next - dt_now;
Console.WriteLine($"初始化({dt_space.TotalSeconds}s)...");
Thread.Sleep(dt_space);
IStation.Service.MonitorRecord _service_monitor_record = new();
IStation.Settings.ParasHelper.DataBase.SQLite.AnalysisConnectString = "DataSource=" + IStation.Settings.ParasHelper.LocalFile.DataFolderDirectory + "\\analysis.db";
IStation.Settings.ParasHelper.DataBase.SQLite.ScheduleConnectString = "DataSource=" + IStation.Settings.ParasHelper.LocalFile.DataFolderDirectory + "\\schedule.db";
IStation.Settings.ParasHelper.DataBase.SQLite.HydraulicConnectString = "DataSource=" + IStation.Settings.ParasHelper.LocalFile.DataFolderDirectory + "\\hydraulic.db";
IStation.Settings.ParasHelper.DataBase.SQLite.MonitorConnectString = "DataSource=" + IStation.Settings.ParasHelper.LocalFile.DataFolderDirectory + "\\monitor.db";
IStation.Settings.ParasHelper.Save();
 
Console.WriteLine("启动实时数据采集...");
var timer = new System.Timers.Timer();
timer.Interval = 50 * 1000;
timer.Elapsed += (s, e) =>
{
    dt_now = DateTime.Now;
    var dt_now_str = dt_now.ToString("G");
    var get_msg = GlobalHelper.GetMonitorRecordList(dt_now, out List<IStation.Model.MonitorRecord> monitor_record_list, false);
    if (!string.IsNullOrEmpty(get_msg))
    {
        Console.WriteLine($"{dt_now_str}:{get_msg}");
    }
    else
    {
        var bol = _service_monitor_record.Inserts(monitor_record_list);
        if (bol)
        {
            Console.WriteLine($"{dt_now_str}:采集成功!");
        }
        else
        {
            Console.WriteLine($"{dt_now_str}:采集失败!");
        }
    }
};
timer.AutoReset = true;
timer.Start();
Console.ReadKey();