初始化

lixiaojun

2022-07-27 96887ec041ba8ddb170c75c1492fc210735ecb37

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
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using SqlSugar;
 
 
namespace IStation.DAL
{
    /// <summary>
    /// 月监测记录
    /// </summary>
    public partial class MonitorMonthRecord : CorpDAL<Entity.MonitorMonthRecord>
    {
        /// <summary>
        /// 
        /// </summary>
        public override ConnectionConfig ConnectionConfig
        {
            get { return ConfigHelper.MonitorRecordConnectionConfig; }
        }
 
        /// <summary>
        /// 通过 MonitorPointID 获取
        /// </summary>
        public List<Entity.MonitorMonthRecord> GetByMonitorPointID(long CorpID, long MonitorPointID)
        {
            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Queryable<Entity.MonitorMonthRecord>()
                    .Where(x => x.CorpID == CorpID && x.MonitorPointID == MonitorPointID)
                    .OrderBy(x => x.DataTime, OrderByType.Asc).ToList();
            }
        }
 
        /// <summary>
        /// 通过 MonitorPointID 获取某年的数据
        /// </summary>
        public List<Entity.MonitorMonthRecord> GetByMonitorPointIDOfYear(long CorpID, long MonitorPointID, int Year)
        {
            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Queryable<Entity.MonitorMonthRecord>()
                    .Where(x => x.CorpID == CorpID && x.MonitorPointID == MonitorPointID&&x.DataYear==Year)
                    .OrderBy(x => x.DataTime, OrderByType.Asc).ToList();
            }
        }
 
        /// <summary>
        /// 通过 MonitorPointID 获取某月的数据
        /// </summary>
        public List<Entity.MonitorMonthRecord> GetByMonitorPointIDOfMonth(long CorpID, long MonitorPointID, int Year,int Month)
        {
            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Queryable<Entity.MonitorMonthRecord>()
                    .Where(x => x.CorpID == CorpID && x.MonitorPointID == MonitorPointID && x.DataYear == Year&&x.DataMonth==Month)
                    .OrderBy(x => x.DataTime, OrderByType.Asc).ToList();
            }
        }
 
        /// <summary>
        /// 通过 MonitorPointID 获取年区间的数据
        /// </summary>
        public List<Entity.MonitorMonthRecord> GetByMonitorPointIDOfYearRange(long CorpID, long MonitorPointID, int StartYear,int EndYear) 
        {
            if(StartYear > EndYear)
                return default;
            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Queryable<Entity.MonitorMonthRecord>()
                    .Where(x => x.CorpID == CorpID && x.MonitorPointID == MonitorPointID && x.DataYear>=StartYear&&x.DataYear<=EndYear)
                    .OrderBy(x => x.DataTime, OrderByType.Asc).ToList();
            }
        }
 
        /// <summary>
        /// 通过 MonitorPointID 获取月区间的数据
        /// </summary>
        public List<Entity.MonitorMonthRecord> GetByMonitorPointIDOfMonthRange(long CorpID, long MonitorPointID, int StartYear, int StartMonth, int EndYear , int EndMonth)
        {
            if (StartYear > EndYear)
                return default;
 
            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Queryable<Entity.MonitorMonthRecord>()
                            .Where(x => x.CorpID == CorpID && x.MonitorPointID == MonitorPointID)
                            .Where(x => (x.DataYear > StartYear && x.DataYear < EndYear)
                                || (x.DataYear == StartYear && x.DataYear < EndYear && x.DataMonth >= StartMonth)
                                || (x.DataYear == EndYear && x.DataYear > StartYear && x.DataMonth <= EndMonth)
                                || (x.DataYear == StartYear && x.DataYear == EndYear && x.DataMonth >= StartMonth && x.DataMonth <= EndMonth))
                        .OrderBy(x => x.DataTime, OrderByType.Asc).ToList();
            }
        }
 
        /// <summary>
        /// 通过 SignalID 获取月区间的数据
        /// </summary>
        public List<Entity.MonitorMonthRecord> GetBySignalIDOfMonthRange(long CorpID, long MonitorPointID,long SignalID, int StartYear, int StartMonth, int EndYear, int EndMonth)
        {
            if (StartYear > EndYear)
                return default;
 
            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Queryable<Entity.MonitorMonthRecord>()
                            .Where(x=>x.CorpID==CorpID&&x.MonitorPointID==MonitorPointID&&x.SignalID==SignalID)
                            .Where(x => (x.DataYear > StartYear && x.DataYear < EndYear)
                                || (x.DataYear == StartYear&&x.DataYear<EndYear && x.DataMonth >= StartMonth) 
                                || (x.DataYear == EndYear&&x.DataYear>StartYear && x.DataMonth <= EndMonth)
                                ||(x.DataYear==StartYear&&x.DataYear==EndYear&&x.DataMonth>=StartMonth&&x.DataMonth<=EndMonth))
                        .OrderBy(x => x.DataTime, OrderByType.Asc).ToList();
            }
        }
 
 
 
 
    }
}