ningshuxia
2024-05-28 3805d90be3760e4881e30f28c22018f0e04b0eb2
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
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
using System.Diagnostics;
 
namespace IStation.Algorithm
{
    /// <summary>
    /// 调度分析辅助类
    /// </summary>
    public partial class AnalysisHelper
    {
 
        double _frequency_def = 50;
        double _frequency_min = 25;
        double _frequency_max = 50;
        double _frequency_space = 0.1;//频率间隔 
 
        double _head_space = 0.1;//扬程间隔 
 
        readonly DAL.SQLite.AnalysisCombine _dal_analysis_combine = new();
        readonly DAL.SQLite.AnalysisConclusion _dal_analysis_conclusion = new();
        readonly DAL.SQLite.AnalysisLog _dal_analysis_log = new();
 
 
        /// <summary>
        /// 分析泵组合(目前只分析单泵)
        /// </summary>
        /// <param name="pumps">泵列表</param>
        /// <returns></returns>
        public void AnalysisCombine(List<Model.Pump> pumps)
        {
            InsertAnaLog("开始分析泵组合");
            if (pumps == null || pumps.Count < 1)
            {
                InsertAnaLog("分析失败:没有泵数据!");
                return;
            }
            var fre_def = _frequency_def;
            var ana_pump_list = new List<AnaPump>();
            foreach (var pump in pumps)
            {
                if (pump.IsBp)
                {
                    //变频泵
                    var anaPump = new AnaPump(pump, fre_def, _frequency_min, _frequency_max, _frequency_space);
                    if (anaPump.AllowCalc)
                        ana_pump_list.Add(anaPump);
                }
                else
                {
                    //固频泵
                    var anaPump = new AnaPump(pump);
                    if (anaPump.AllowCalc)
                        ana_pump_list.Add(anaPump);
                }
            }
            if (!ana_pump_list.Any())
            {
                InsertAnaLog($"分析进度:没有泵可分析");
                return;
            }
            for (int i = 0; i < ana_pump_list.Count; i++)
            {
                var pump = ana_pump_list[i];
                var ana_frequency_items = pump.AnaFrequencyItems;
                if (ana_frequency_items == null || !ana_frequency_items.Any())
                    continue;
 
                var run_flag = RunFlagHelper.GetRunFlag(pump.Flag, pump.IsBp);
                InsertAnaLog($"分析进度:第{i + 1}台泵");
 
                var list = new List<Entity.AnalysisCombine>(pump.AnaFrequencyItems.Count);
                foreach (var freItem in ana_frequency_items)
                {
                    var scheduleCombine = new Entity.AnalysisCombine();
                    scheduleCombine.ID = Yw.YitIdHelper.NextId();
                    scheduleCombine.Pump1 = freItem.Frequency;
                    scheduleCombine.CurveQH = freItem.CurveQH.ToJson();
                    scheduleCombine.CurveQP = freItem.CurveQP.ToJson();
 
                    freItem.CurveQH.GetMinMaxPointY(out double maxHead, out double minHead);
                    scheduleCombine.MinFlow = Math.Round(freItem.CurveQH.Min, 4);
                    scheduleCombine.MaxFlow = Math.Round(freItem.CurveQH.Max, 4);
                    scheduleCombine.MaxHead = Math.Round(maxHead, 4);
                    scheduleCombine.MinHead = Math.Round(minHead, 4);
                    scheduleCombine.AnaStatus = false;
                    list.Add(scheduleCombine);
                }
                InsertAnalysisCombineList(i + 1, run_flag, list);
            }
 
            InsertAnaLog($"分析进度:{pumps.Count}台泵,分析完毕!");
        }
 
 
 
        /// <summary>
        /// 分析结论
        /// </summary>
        public void AnalysisConclusion()
        {
            InsertAnaLog($"开始分析泵组合结论!");
            _dal_analysis_conclusion.DeleteAllTable();
            var analysis_combine_table_list = _dal_analysis_combine.GetAllTableName();
            if (analysis_combine_table_list == null || !analysis_combine_table_list.Any())
            {
                InsertAnaLog($"无泵组合表!");
                return;
            }
            var tableCount = analysis_combine_table_list.Count();
            InsertAnaLog($"分析{tableCount}个组合!");
            for (int tableIndex = 0; tableIndex < tableCount; tableIndex++)
            {
                var table_name = analysis_combine_table_list[tableIndex];
                var analysis_combine_list = _dal_analysis_combine.GetNoAnalysisByTableName(table_name);
                if (analysis_combine_list == null || !analysis_combine_list.Any())
                {
                    InsertAnaLog($"分析进度:{table_name},第{tableIndex + 1}个,分析完毕");
                    continue;
                }
                var analysis_combine_list_count = analysis_combine_list.Count();
                var analysis_conclusion_list = new List<List<Entity.AnalysisConclusion>>(analysis_combine_list_count);
                var analysis_combine_ids = new List<long>(analysis_combine_list_count);
 
                for (int combineIndex = 0; combineIndex < analysis_combine_list_count; combineIndex++)
                {
                    var analysis_combine = analysis_combine_list[combineIndex];
                    var analysis_combine_id = analysis_combine.ID;
                    analysis_combine_ids.Add(analysis_combine_id);
                    var curveQH = JsonHelper.Json2Object<Curve.CurveExpress>(analysis_combine.CurveQH);
                    var curveQP = JsonHelper.Json2Object<Curve.CurveExpress>(analysis_combine.CurveQP);
                    var bol = curveQH.GetMinMaxPointY(out double maxY, out double minY);
                    if (!bol)
                        return;
                    var maxHead = Math.Ceiling(maxY);
                    var minHead = Math.Floor(minY);
 
                    var currentListCount = (int)((maxHead - minHead) / _head_space) + 1;
                    var current_analysis_conclusion_list = new List<Entity.AnalysisConclusion>(currentListCount);
                    for (double head = minHead; head <= maxHead; head += _head_space)
                    {
                        var flow = curveQH.GetInterPointLastX(head);
                        if (!flow.HasValue)
                        {
                            continue;
                        }
                        var analysis_conclusion = new Entity.AnalysisConclusion();
                        analysis_conclusion.ID = Yw.YitIdHelper.NextId();
                        analysis_conclusion.CombineID = analysis_combine_id;
                        analysis_conclusion.Pump1 = analysis_combine.Pump1;
                        analysis_conclusion.Pump2 = analysis_combine.Pump2;
                        analysis_conclusion.Head = head;
                        analysis_conclusion.Flow = flow.Value;
                        analysis_conclusion.Power = curveQP.GetFitPointY(flow.Value);
                        analysis_conclusion.UWP = PumpCalculateHelper.CalculateUWP(analysis_conclusion.Power, analysis_conclusion.Flow, analysis_conclusion.Head);
                        analysis_conclusion.WP = PumpCalculateHelper.CalculateWP(analysis_conclusion.Power, analysis_conclusion.Flow);
 
                        Round(analysis_conclusion);
                        current_analysis_conclusion_list.Add(analysis_conclusion);
                    }
                    analysis_conclusion_list.Add(current_analysis_conclusion_list);
                }
                UpdateAnaStatus(table_name, analysis_combine_ids);
                var list = analysis_conclusion_list.SelectMany(x => x.ToList()).ToList();
                var run_flag = _dal_analysis_combine.GetRunFlag(table_name);
                InsertAnalysisConclusionList(tableIndex + 1, run_flag, list);
            }
        }
 
        /// <summary>
        /// 圆整
        /// </summary> 
        private void Round(Entity.AnalysisConclusion conclusion)
        {
            conclusion.Pump1 = Math.Round(conclusion.Pump1, 1);
            conclusion.Pump2 = Math.Round(conclusion.Pump2, 1);
            conclusion.Head = Math.Round(conclusion.Head, 1);
            conclusion.Flow = Math.Round(conclusion.Flow, 1);
            conclusion.Power = Math.Round(conclusion.Power, 1);
            conclusion.WP = Math.Round(conclusion.WP, 1);
            conclusion.UWP = Math.Round(conclusion.UWP, 1);
        }
 
        /// <summary>
        /// 插入分析日志
        /// </summary> 
        private void InsertAnaLog(string info)
        {
            var entity = new Entity.AnalysisLog(info);
            _dal_analysis_log.Insert(entity);
        }
 
        /// <summary>
        /// 更新分析状态
        /// </summary>
        public bool UpdateAnaStatus(string tableName, List<long> ids)
        {
            if (ids == null || !ids.Any())
            {
                return false;
            }
            return _dal_analysis_combine.UpdateAnaStatus(tableName, ids);
        }
 
        /// <summary>
        /// 插入分析组合列表
        /// </summary> 
        public void InsertAnalysisCombineList(int index, string runFlag, List<Entity.AnalysisCombine> list)
        {
            string log;
            if (list == null || !list.Any())
            {
                log = $"{runFlag}:下标:{index},无数据";
                InsertAnaLog(log);
                return;
            }
 
            var sw = Stopwatch.StartNew();
            _dal_analysis_combine.BulkInsertsEx(runFlag, list);
            log = $"{runFlag}:下标:{index},数量:{list.Count},插入耗时:{sw.ElapsedMilliseconds / 1000}m";
            InsertAnaLog(log);
        }
 
 
        /// <summary>
        /// 插入分析结论列表
        /// </summary> 
        public void InsertAnalysisConclusionList(int index, string runFlag, List<Entity.AnalysisConclusion> list)
        {
            string log;
            if (list == null || !list.Any())
            {
                log = $"{runFlag}:下标:{index},无数据";
                InsertAnaLog(log);
                return;
            }
 
            var sw = Stopwatch.StartNew();
            _dal_analysis_conclusion.BulkInsertsEx(runFlag, list);
            log = $"分析进度:{runFlag},下标:{index},数量:{list.Count},插入耗时:{sw.ElapsedMilliseconds / 1000}m";
            InsertAnaLog(log);
        }
    }
 
 
}