// 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})...");
|
//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 = 10 * 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();
|
|
var list = new IStation.Service.ScheduleRequest().GetAll();
|
|
Export2Excel(list);
|
bool Export2Excel(List<IStation.Model.ScheduleRequest> list)
|
{
|
|
HSSFWorkbook theBook = new HSSFWorkbook();
|
var theSheet1 = theBook.CreateSheet("Sheet1");
|
|
IRow rowTile = theSheet1.CreateRow(0);
|
|
rowTile.CreateCell(0).SetCellValue("时间");
|
rowTile.CreateCell(1).SetCellValue("目标流量");
|
rowTile.CreateCell(2).SetCellValue("目标压力");
|
|
|
var count = list.Count();
|
for (int i = 1; i < count; i++)
|
{
|
var x = list[i];
|
var row = theSheet1.CreateRow(i);
|
row.CreateCell(0).SetCellValue(x.ReceptionTime.ToString("G"));
|
row.CreateCell(1).SetCellValue(x.TargetFlow2);
|
row.CreateCell(2).SetCellValue(x.TargetPressure2);
|
}
|
|
var root_folder = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "问题排查");
|
if (!Directory.Exists(root_folder))
|
{
|
Directory.CreateDirectory(root_folder);
|
}
|
var file_name = root_folder + "\\" + $"调度数据.xls";
|
theSheet1.ForceFormulaRecalculation = true;
|
using (FileStream fs = File.OpenWrite(file_name))
|
{
|
theBook.Write(fs);
|
}
|
|
return true;
|
}
|
Console.ReadKey();
|
