文件遗漏

tangxu

2024-05-13 d662c08aee9ea241eb5ef89e60eee704667ca47c

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
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
    {
 
        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(); 
            }
        }
 
 
 
 
        #endregion
 
    }
}