遗漏提交

duheng

2025-02-11 7e0414c91a51219a92515c90ccb803ebade5613a

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
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using SqlSugar;
 
namespace IStation.DAL
{
    public class WaterPredictRecord
    {
        private static Dictionary<int, ConnectionConfig> _connectionConfigDict = new Dictionary<int, ConnectionConfig>();
 
        public static ISqlSugarClient CreateConnection(int year)
        {
            if (_connectionConfigDict.ContainsKey(year))
            {
                return new SqlSugarClient(_connectionConfigDict[year]);
            }
 
            var root_directory = System.Configuration.ConfigurationManager.AppSettings["WaterPredictDsPath"];
            if (System.IO.File.Exists(root_directory) || !System.IO.Directory.Exists(root_directory))
            {
                throw new Exception($"缺少WaterPredictDsPath配置");
            }
            var dsName = string.Format("WaterPredict{0}.db", year);
 
            var filePath = Path.Combine(root_directory, dsName);
            if (!System.IO.File.Exists(filePath))
            {
                throw new Exception($"缺少db文件:" + dsName);
            }
 
            var connectionConfig = new ConnectionConfig()
            {
                DbType = SqlSugar.DbType.Sqlite,
                ConnectionString = "Data Source=" + filePath,// + ";Version=3;",
                IsAutoCloseConnection = true,//是否自动关闭
            };
 
            _connectionConfigDict[year] = connectionConfig;
            ISqlSugarClient conn = new SqlSugarClient(connectionConfig);
            return conn;
        }
 
        #region Query
 
        /// <summary>
        ///  查询num条
        /// </summary>
        public List<IStation.Model.WaterPredictRecord> GetLast(int num)
        {
            using (ISqlSugarClient db = CreateConnection(DateTime.Now.Year))
            {
                return db.Queryable<IStation.Model.WaterPredictRecord>().Take(num).ToList();
            }
        }
 
        /// <summary>
        ///  查询num条
        /// </summary>
        public IStation.Model.WaterPredictRecord GetBySingleHour(DateTime time)
        {
            using (ISqlSugarClient db = CreateConnection(time.Year))
            {
                return db.Queryable<IStation.Model.WaterPredictRecord>().Where(x => x.DayHour == IStation.Model.WaterPredictRecord.ConvertIntDay(time)).First();
            }
        }
 
        /// <summary>
        ///  查询num条
        /// </summary>
        public List<IStation.Model.WaterPredictRecord> GetByHourRangle(DateTime start_time, DateTime end_time)
        {
            using (ISqlSugarClient db = CreateConnection(start_time.Year))
            {
                return db.Queryable<IStation.Model.WaterPredictRecord>().Where(x =>
                x.DayHour >= IStation.Model.WaterPredictRecord.ConvertIntDay(start_time)
                && x.DayHour < IStation.Model.WaterPredictRecord.ConvertIntDay(end_time)
                ).ToList();
            }
        }
 
        #endregion Query
    }
}