| | |
| | | |
| | | #endregion |
| | | |
| | | #region Query |
| | | #region Get |
| | | |
| | | #region MonitorDataSet |
| | | |
| | | /// <summary> |
| | | /// 查询监测数据集 |
| | | /// </summary> |
| | | public List<Model.MonitorDataSet> QueryMonitorDataSet(long projectId, long sceneId) |
| | | public List<Model.MonitorDataSet> GetMonitorDataSet(long projectId, long sceneId) |
| | | { |
| | | if (projectId < 1) |
| | | return default; |
| | |
| | | if (dateFolderInfos == null || dateFolderInfos.Count() < 1) |
| | | return default; |
| | | |
| | | var MonitorDataSetCount = _monitorDataSetSummary.QueryMonitorDataSetCount(projectId, sceneId); |
| | | var MonitorDataSetCount = _monitorDataSetSummary.GetMonitorDataSetCount(projectId, sceneId); |
| | | var MonitorDataSetList = new List<Model.MonitorDataSet>(MonitorDataSetCount); |
| | | foreach (var dateFolderInfo in dateFolderInfos) |
| | | { |
| | |
| | | var monitorPointId = montiorDataSetFolderInfo.MonitorPointId; |
| | | var year = montiorDataSetFolderInfo.Year; |
| | | var month = montiorDataSetFolderInfo.Month; |
| | | var MonitorDataSet = QueryMonitorDataSet(projectId, sceneId, monitorPointId, year, month); |
| | | var MonitorDataSet = GetMonitorDataSet(projectId, sceneId, monitorPointId, year, month); |
| | | if (MonitorDataSet != null) |
| | | MonitorDataSetList.Add(MonitorDataSet); |
| | | } |
| | |
| | | /// <summary> |
| | | /// 查询监测数据集 |
| | | /// </summary> |
| | | public List<Model.MonitorDataSet> QueryMonitorDataSet(long projectId, long sceneId, long monitorPointId) |
| | | public List<Model.MonitorDataSet> GetMonitorDataSet(long projectId, long sceneId, long monitorPointId) |
| | | { |
| | | if (projectId < 1) |
| | | return default; |
| | |
| | | continue; |
| | | var year = montiorDataSetFolderInfo.Year; |
| | | var month = montiorDataSetFolderInfo.Month; |
| | | var MonitorDataSet = QueryMonitorDataSet(projectId, sceneId, monitorPointId, year, month); |
| | | var MonitorDataSet = GetMonitorDataSet(projectId, sceneId, monitorPointId, year, month); |
| | | if (MonitorDataSet != null) |
| | | MonitorDataSetList.Add(MonitorDataSet); |
| | | } |
| | |
| | | /// <summary> |
| | | /// 查询监测数据集 |
| | | /// </summary> |
| | | public Model.MonitorDataSet QueryMonitorDataSet(long projectId, long sceneId, long monitorPointId, int year, int month) |
| | | public Model.MonitorDataSet GetMonitorDataSet(long projectId, long sceneId, long monitorPointId, int year, int month) |
| | | { |
| | | if (projectId < 1) |
| | | return default; |
| | |
| | | if (signalRecordPacketFileInfos == null || signalRecordPacketFileInfos.Count < 1) |
| | | return default; |
| | | |
| | | var signalRecordPacketCount = _monitorDataSetSummary.QuerySignalRecordPacketCount(projectId, sceneId, monitorPointId, year, month); |
| | | var signalRecordPacketCount = _monitorDataSetSummary.GetSignalRecordPacketCount(projectId, sceneId, monitorPointId, year, month); |
| | | if (signalRecordPacketCount < 1) |
| | | return default; |
| | | |
| | |
| | | foreach (var signalRecordFile in signalRecordPacketFileInfos) |
| | | { |
| | | var signalId = signalRecordFile.SignalId; |
| | | var signalRecordPacket = QuerySignalRecordPacket(projectId, sceneId, monitorPointId, signalId, year, month); |
| | | var signalRecordPacket = GetSignalRecordPacket(projectId, sceneId, monitorPointId, signalId, year, month); |
| | | if (signalRecordPacket != null) |
| | | { |
| | | MonitorDataSet.PacketList.Add(signalRecordPacket); |
| | |
| | | /// <summary> |
| | | /// 查询信号记录包 |
| | | /// </summary> |
| | | public Model.SignalRecordPacket QuerySignalRecordPacket(long projectId, long sceneId, long monitorPointId, long signalId) |
| | | public Model.SignalRecordPacket GetSignalRecordPacket(long projectId, long sceneId, long monitorPointId, long signalId) |
| | | { |
| | | if (projectId < 1) |
| | | return default; |
| | |
| | | if (dateFolderInfos == null || dateFolderInfos.Count() < 1) |
| | | return default; |
| | | |
| | | var signalRecordCount = _monitorDataSetSummary.QuerySignalRecordCount(projectId, sceneId, monitorPointId, signalId); |
| | | var signalRecordCount = _monitorDataSetSummary.GetSignalRecordCount(projectId, sceneId, monitorPointId, signalId); |
| | | if (signalRecordCount < 1) |
| | | return default; |
| | | |
| | |
| | | /// <summary> |
| | | /// 查询信号记录包 |
| | | /// </summary> |
| | | public Model.SignalRecordPacket QuerySignalRecordPacket(long projectId, long sceneId, long monitorPointId, long signalId, int year, int month) |
| | | public Model.SignalRecordPacket GetSignalRecordPacket(long projectId, long sceneId, long monitorPointId, long signalId, int year, int month) |
| | | { |
| | | if (projectId < 1) |
| | | return default; |
| | |
| | | var valid = this.GetSignalRecordPacketFile(projectId, sceneId, monitorPointId, signalId, year, month, out string filePath); |
| | | if (!valid) |
| | | return default; |
| | | var signalRecordCount = _monitorDataSetSummary.QuerySignalRecordCount(projectId, sceneId, monitorPointId, signalId, year, month); |
| | | var signalRecordCount = _monitorDataSetSummary.GetSignalRecordCount(projectId, sceneId, monitorPointId, signalId, year, month); |
| | | if (signalRecordCount < 1) |
| | | return default; |
| | | |
| | |
| | | /// <summary> |
| | | /// 查询信号记录 |
| | | /// </summary> |
| | | public List<Model.SignalRecord> QuerySignalRecord(long projectId, long sceneId, long monitorPointId, long signalId, int year, int month) |
| | | public List<Model.SignalRecord> GetSignalRecord(long projectId, long sceneId, long monitorPointId, long signalId, int year, int month) |
| | | { |
| | | if (projectId < 1) |
| | | return default; |
| | |
| | | var valid = this.GetSignalRecordPacketFile(projectId, sceneId, monitorPointId, signalId, year, month, out string filePath); |
| | | if (!valid) |
| | | return default; |
| | | var signalRecordCount = _monitorDataSetSummary.QuerySignalRecordCount(projectId, sceneId, monitorPointId, signalId, year, month); |
| | | var signalRecordCount = _monitorDataSetSummary.GetSignalRecordCount(projectId, sceneId, monitorPointId, signalId, year, month); |
| | | if (signalRecordCount < 1) |
| | | return default; |
| | | |
| | |
| | | |
| | | var model = new Model.MonitorDataSetSummary(); |
| | | model.MonitorPointId = monitorPointId; |
| | | model.SignalId = signalId; |
| | | model.Year = year; |
| | | model.Month = month; |
| | | model.MinTime = signalRecords.Min(x => x.Time); |