API链接水量预测数据库

tangxu

2024-05-13 242858765900c0f755598635da932921f194e8c3

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
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
using IStation.CalcModel;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
 
namespace IStation.DAL
{
    /// <summary>
    /// 数据库访问基类
    /// </summary> 
    public partial class AnaProject  
    {
 
        /// <summary>
        /// 构造函数
        /// </summary>
        public AnaProject()
        {
 
        }
 
 
 
        /// <summary>
        /// 数据库连接
        /// </summary>
        public virtual ISqlSugarClient Connection
        {
            get
            {
                var connection = CreateConnection();
                return connection;
            }
        }
        public static ISqlSugarClient CreateConnection()
        {
            var path = System.IO.Path.Combine(IStation.DataFolderHelper.GetRootPath(), "AnaProject.db");
            if (!System.IO.File.Exists(path))
            {
                throw new Exception($"缺少Project.db文件");
            }
 
            ConnectionConfig connectionConfig = new ConnectionConfig()
            {
                DbType = SqlSugar.DbType.Sqlite,
                ConnectionString = "Data Source=" + path,// + ";Version=3;",
                IsAutoCloseConnection = true,//是否自动关闭
            };
            ISqlSugarClient conn = new SqlSugarClient(connectionConfig);
            return conn;
        }
        #region Insert
 
        /// <summary>
        /// 插入指定对象到数据库中
        /// </summary>
        public long Insert(IStation.CalcModel.AnaPrj result_prj, IStation.CalcModel.AnaRequest ana_request)
        {
            IStation.Entity.AnaProjectEntity entity = new Entity.AnaProjectEntity();
            entity.PrjID = result_prj.ID;
            entity.StartTime = result_prj.StartTime;
            entity.EndTime = result_prj.EndTime;
            entity.CreateTime = DateTime.Now;
            entity.TotalFlow = (int)ana_request.TotalFlow取水总量;
            entity.CalcOptType = (int)ana_request.CalcOptType;
 
            SnowFlakeSingle.WorkId = 1;
 
            using (ISqlSugarClient db = Connection)
            {
                return db.Insertable(entity).ExecuteReturnSnowflakeId();
            }
        }
 
        /// <summary>
        /// 插入指定对象到数据库中
        /// </summary>
        public long Insert(IStation.CalcModel.AnaPrj result_prj, IStation.CalcModel.AnaRequestBase ana_request)
        {
            IStation.Entity.AnaProjectEntity entity = new Entity.AnaProjectEntity();
            entity.PrjID = result_prj.ID;
            entity.StartTime = result_prj.StartTime;
            entity.EndTime = result_prj.EndTime;
            entity.CreateTime = DateTime.Now;
            entity.TotalFlow = (int)ana_request.TotalFlow取水总量;
            entity.CalcOptType = (int)ana_request.CalcOptType;
 
            SnowFlakeSingle.WorkId = 1;
 
            using (ISqlSugarClient db = Connection)
            {
                return db.Insertable(entity).ExecuteReturnSnowflakeId();
            }
        }
 
        #endregion
 
 
 
        #region Query
 
        /// <summary>
        /// 返回数据库所有的对象集合
        /// </summary>
        public List<Entity.AnaProjectEntity> GetAll()
        {
            using (ISqlSugarClient db = Connection)
            {
                return db.Queryable<Entity.AnaProjectEntity>()?.ToList();
            }
        }
 
        /// <summary>
        /// 查询数据库,返回指定ID的对象
        /// </summary>
        public Entity.AnaProjectEntity GetByPrjID(string prj_id)
        {
            using (ISqlSugarClient db = Connection)
            {
                return db.Queryable<Entity.AnaProjectEntity>().Single(x => x.PrjID == prj_id);
            }
        }
 
        public Entity.AnaProjectEntity GetLastRecord()
        {
            using (ISqlSugarClient db = Connection)
            {
                return db.Queryable<Entity.AnaProjectEntity>().OrderByDescending(i => i.ID).Take(1).First();
            }
        }
 
 
        #endregion
 
 
 
 
 
    }
}