tangxu
2024-01-09 ddc2780231ea76be74fadb7486401a3d0d17b101
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
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
namespace Yw.Service
{
    /// <summary>
    /// 指标评价记录
    /// </summary>
    public partial class HealthQuotaEvaluationRecord
    {
        #region 最近一条记录
 
        /// <summary>
        /// 获取最近一条记录
        /// </summary>
        public Model.HealthQuotaEvaluationRecord GetLastRecord(long SignalID)
        {
            var redisHelper = new HealthQuotaEvaluationRecordCacheHelper();
            var record = redisHelper.GetLastRecord(SignalID);
            return record;
        }
 
        /// <summary>
        /// 获取最近一条记录
        /// </summary>
        public List<Model.HealthQuotaEvaluationRecord> GetLastRecord(IEnumerable<long> SignalIds)
        {
            if (SignalIds == null || !SignalIds.Any())
                return default;
            var redisHelper = new HealthQuotaEvaluationRecordCacheHelper();
            var records = redisHelper.GetLastRecord(SignalIds);
            return records;
        }
 
 
        #endregion
 
        #region 查询
 
        /// <summary>
        /// 通过 SignalID 获取某一时刻数据
        /// </summary>
        public Model.HealthQuotaEvaluationRecord GetBySignalIDOfTime(long SignalID, DateTime Time)
        {
            var dal = new DAL.HealthQuotaEvaluationRecord();
            var entity = dal.GetBySignalIDOfTime(SignalID, Time);
            return Entity2Model(entity);
        }
 
        /// <summary>
        /// 通过 SignalID 获取某天的数据
        /// </summary>
        public List<Model.HealthQuotaEvaluationRecord> GetBySignalIDOfDay(long SignalID, DateTime Day)
        {
            var dal = new DAL.HealthQuotaEvaluationRecord();
            var entity_list = dal.GetBySignalIDOfDay(SignalID, Day);
            return Entity2Models(entity_list);
        }
 
        /// <summary>
        /// 通过 SignalID 获取日期区间内的数据
        /// </summary>
        public List<Model.HealthQuotaEvaluationRecord> GetBySignalIDOfDayRange(long SignalID, DateTime StartDay, DateTime EndDay)
        {
            if (StartDay.Date > EndDay.Date)
                return default;
            var dal = new DAL.HealthQuotaEvaluationRecord();
            var entity_list = dal.GetBySignalIDOfDayRange(SignalID, StartDay, EndDay);
            return Entity2Models(entity_list);
        }
 
        /// <summary>
        /// 通过 SignalID 获取时间区间内的数据
        /// </summary>
        public List<Model.HealthQuotaEvaluationRecord> GetBySignalIDOfTimeRange(long SignalID, DateTime StartTime, DateTime EndTime)
        {
            if (StartTime > EndTime)
                return default;
            var dal = new DAL.HealthQuotaEvaluationRecord();
            var entity_list = dal.GetBySignalIDOfTimeRange(SignalID, StartTime, EndTime);
            return Entity2Models(entity_list);
        }
 
        /// <summary>
        /// 通过 SignalID 获取时间区间内的步长填充数据
        /// </summary>
        public List<Model.HealthQuotaEvaluationStepRecord> GetStepFillBySignalIDOfTimeRange(long SignalID, DateTime StartTime, DateTime EndTime, int Step)
        {
            if (StartTime > EndTime)
                return default;
            var dal = new DAL.HealthQuotaEvaluationRecord();
            var entity_list = dal.GetStepFillBySignalIDOfTimeRange(SignalID, StartTime, EndTime, Step);
            return Entity2Models(entity_list);
        }
 
        #endregion
 
        #region Insert
 
        /// <summary>
        /// 插入一条
        /// </summary>
        public bool Insert(Model.HealthQuotaEvaluationRecord model)
        {
            if (model == null)
                return default;
            var dal = new DAL.HealthQuotaEvaluationRecord();
            var entity = Model2Entity(model);
            var bol = dal.InsertOrUpdate(entity);
            return bol;
        }
 
        /// <summary>
        /// 插入多条
        /// </summary>
        public bool Inserts(List<Model.HealthQuotaEvaluationRecord> list)
        {
            if (list == null || !list.Any())
                return default;
            var dal = new DAL.HealthQuotaEvaluationRecord();
            var entity_list = Model2Entities(list);
            var bol = dal.InsertOrUpdate(entity_list);
            return bol;
        }
 
        /// <summary>
        /// 插入最近一条记录
        /// </summary>
        public bool InsertLastRecord(Model.HealthQuotaEvaluationRecord model)
        {
            if (model == null)
                return default;
            var dal = new DAL.HealthQuotaEvaluationRecord();
            var entity = Model2Entity(model);
            var bol = dal.InsertOrUpdate(entity);
            if (bol)
            {
                var redisHelper = new HealthQuotaEvaluationRecordCacheHelper();
                redisHelper.SetLastRecord(model);
            }
            return bol;
        }
 
        /// <summary>
        /// 插入最近多条记录
        /// </summary>
        public bool InsertsLastRecord(List<Model.HealthQuotaEvaluationRecord> list)
        {
            if (list == null || list.Count < 1)
                return default;
            var dal = new DAL.HealthQuotaEvaluationRecord();
            var entityList = Model2Entities(list);
            var bol = dal.InsertOrUpdate(entityList);
            if (bol)
            {
                var redisHelper = new HealthQuotaEvaluationRecordCacheHelper();
                redisHelper.SetLastRecord(list);
            }
 
            return bol;
        }
 
 
        #endregion
 
    }
}