Exemplo n.º 1
0
        public async Task <List <T1_SystemEvent> > GetSystemEvent(string ip, DateTime start, DateTime end, string name, CustomSystemType systemtype)
        {
            List <T_SystemEvent> list = new List <T_SystemEvent>();

            if (name.Trim() == "" && systemtype == CustomSystemType.None)
            {
                list = await _databaseComponent.Query <T_SystemEvent>(ip, null, "(EventTime >= @0 and EventTime <= @1)", new object[] { start, end, });
            }
            else if (name.Trim() != "" && systemtype == CustomSystemType.None)
            {
                list = await _databaseComponent.Query <T_SystemEvent>(ip, null, "((EventTime >= @0 and EventTime <= @1) and Remarks like '%'+ @2+ '%')", new object[] { start, end, name });
            }
            else if (name.Trim() == "" && systemtype != CustomSystemType.None)
            {
                list = await _databaseComponent.Query <T_SystemEvent>(ip, null, "((EventTime >= @0 and EventTime <= @1) and Type = @2)", new object[] { start, end, ((int)systemtype) });
            }
            else
            {
                list = await _databaseComponent.Query <T_SystemEvent>(ip, null, "((EventTime >= @0 and EventTime <= @1) and Remarks like '%'+ @2+ '%' and Type = @3)", new object[] { start, end, name, ((short)systemtype).ToString() });
            }
            return(list.Select(p => ClassCopyHelper.AutoCopy <T_SystemEvent, T1_SystemEvent>(p)).ToList());
        }
Exemplo n.º 2
0
        public async Task <List <T1_OperateRecord> > GetOperateRecord(string ip, DateTime start, DateTime end, string name, UserOperateType operateType)
        {
            List <T_OperateRecord> list = new List <T_OperateRecord>();

            if (name.Trim() == "" && operateType == UserOperateType.None)
            {
                list = await _databaseComponent.Query <T_OperateRecord>(ip, null, "(OperateTime >= @0 and OperateTime <= @1)", new object[] { start, end, });
            }
            else if (name.Trim() != "" && operateType == UserOperateType.None)
            {
                list = await _databaseComponent.Query <T_OperateRecord>(ip, null, "((OperateTime >= @0 and OperateTime <= @1) and T_User_Name like '%'+ @2+ '%')", new object[] { start, end, name });
            }
            else if (name.Trim() == "" && operateType != UserOperateType.None)
            {
                list = await _databaseComponent.Query <T_OperateRecord>(ip, null, "((OperateTime >= @0 and OperateTime <= @1) and UserOperateType = @2)", new object[] { start, end, ((short)operateType) });
            }
            else
            {
                list = await _databaseComponent.Query <T_OperateRecord>(ip, null, "((OperateTime >= @0 and OperateTime <= @1) and T_User_Name like '%'+ @2+ '%' and UserOperateType = @3)", new object[] { start, end, name, ((short)operateType).ToString() });
            }
            return(list.Select(p => ClassCopyHelper.AutoCopy <T_OperateRecord, T1_OperateRecord>(p)).ToList());
        }
Exemplo n.º 3
0
        public async Task AddData(ItemTreeItemViewModel item, DateTime start, DateTime end)
        {
            string selectedip = item.ServerIP;

            #region 测点
            if (item != null)
            {
                try
                {
                    WaitInfo = "获取数据中";
                    Status   = ViewModelStatus.Querying;
                    if (item.T_Item.ItemType == (int)ChannelType.WirelessVibrationChannelInfo)
                    {
                        var result = await _databaseComponent.GetHistoryData <D_WirelessVibrationSlot>(selectedip, item.T_Item.Guid, new string[] { "ACQDatetime", "Result", "Unit", "AlarmGrade", "IsValidWave", "RecordLab", "RPM" }, start, end, null, null);

                        result = result.Where(p => p.IsValidWave == true).ToList();
                        if (result == null || result.Count == 0)
                        {
                            return;
                        }
                        BaseDivfreChannelToken channeltoken = new BaseDivfreChannelToken()
                        {
                            DisplayName   = item.BaseAlarmSignal.DeviceItemName,
                            IP            = selectedip,
                            Guid          = item.T_Item.Guid,
                            DataContracts = result.Select(p => ClassCopyHelper.AutoCopy <D_WirelessVibrationSlot, D1_WirelessVibrationSlot>(p) as IBaseAlarmSlot).ToList(),
                        };
                        foreach (var color in DefaultColors.SeriesForBlackBackgroundWpf)
                        {
                            if (!ColorList.Contains(color))
                            {
                                ColorList.Add(color);
                                channeltoken.SolidColorBrush = new SolidColorBrush(color);
                                break;
                            }
                        }
                        amsReplayVM.AddChannel(channeltoken);
                        timeDomainVM.AddChannel(channeltoken);
                        frequencyDomainVM.AddChannel(channeltoken);
                        powerSpectrumVM.AddChannel(channeltoken);
                        powerSpectrumDensityVM.AddChannel(channeltoken);
                        alarmPointTrendVM.AddChannel(channeltoken);
                        orthoDataVM.AddChannel(channeltoken);

                        offDesignConditionVM.AddChannel(channeltoken);
                    }
                    else if (item.T_Item.ItemType == (int)ChannelType.WirelessScalarChannelInfo)
                    {
                        var result = await _databaseComponent.GetHistoryData <D_WirelessScalarSlot>(selectedip, item.T_Item.Guid, new string[] { "ACQDatetime", "Result", "Unit", "AlarmGrade" }, start, end, null, null);

                        if (result == null || result.Count == 0)
                        {
                            return;
                        }
                        BaseAlarmChannelToken channeltoken = new BaseAlarmChannelToken()
                        {
                            DisplayName   = item.BaseAlarmSignal.DeviceItemName,
                            IP            = selectedip,
                            Guid          = item.T_Item.Guid,
                            DataContracts = result.Select(p => ClassCopyHelper.AutoCopy <D_WirelessScalarSlot, D1_WirelessScalarSlot>(p) as IBaseAlarmSlot).ToList(),
                        };
                        foreach (var color in DefaultColors.SeriesForBlackBackgroundWpf)
                        {
                            if (!ColorList.Contains(color))
                            {
                                ColorList.Add(color);
                                channeltoken.SolidColorBrush = new SolidColorBrush(color);
                                break;
                            }
                        }
                        amsReplayVM.AddChannel(channeltoken);
                        timeDomainVM.IsVisible      = false;
                        frequencyDomainVM.IsVisible = false;
                    }
                }
                catch (Exception ex)
                {
                    _eventAggregator.GetEvent <ThrowExceptionEvent>().Publish(Tuple.Create <string, Exception>("数据回放-测点查询", ex));
                }
                finally
                {
                    Status = ViewModelStatus.None;
                }
            }
            #endregion
        }
Exemplo n.º 4
0
        //统一返回基础类型
        public async Task <List <IBaseAlarmSlot> > GetUniformHistoryData(int itemType, string ip, Guid guid, string[] columns, DateTime startTime, DateTime endTime, string condition, object[] args)
        {
            return(await Task.Run(() =>
            {
                var client = new DataProvider(ip, LocalSetting.ServerPort, LocalSetting.MajorVersion, LocalSetting.MinorVersion);
                string errorMessage = null;
                switch (itemType)
                {
                case (int)ChannelType.IEPEChannelInfo:
                    {
                        var historyResult = client.QueryHistorySampleData <D_IEPESlot>(new Guid[] { guid }, columns, startTime, endTime, condition, args);

                        //先判断是不是OK
                        if (historyResult.IsOK)
                        {
                            return historyResult.ResponseItem.OrderBy(p => p.ACQDatetime).Select(p => ClassCopyHelper.AutoCopy <D_IEPESlot, D1_IEPESlot>(p) as IBaseAlarmSlot).ToList();
                        }
                        else
                        {
                            errorMessage = historyResult.ErrorMessage;
                        }
                        break;
                    }

                case (int)ChannelType.EddyCurrentDisplacementChannelInfo:
                    {
                        var historyResult = client.QueryHistorySampleData <D_EddyCurrentDisplacementSlot>(new Guid[] { guid }, columns, startTime, endTime, condition, args);

                        //先判断是不是OK
                        if (historyResult.IsOK)
                        {
                            return historyResult.ResponseItem.OrderBy(p => p.ACQDatetime).Select(p => ClassCopyHelper.AutoCopy <D_EddyCurrentDisplacementSlot, D1_EddyCurrentDisplacementSlot>(p) as IBaseAlarmSlot).ToList();
                        }
                        else
                        {
                            errorMessage = historyResult.ErrorMessage;
                        }
                        break;
                    }

                case (int)ChannelType.EddyCurrentKeyPhaseChannelInfo:
                    {
                        var historyResult = client.QueryHistorySampleData <D_EddyCurrentKeyPhaseSlot>(new Guid[] { guid }, columns, startTime, endTime, condition, args);

                        //先判断是不是OK
                        if (historyResult.IsOK)
                        {
                            return historyResult.ResponseItem.OrderBy(p => p.ACQDatetime).Select(p => ClassCopyHelper.AutoCopy <D_EddyCurrentKeyPhaseSlot, D1_EddyCurrentKeyPhaseSlot>(p) as IBaseAlarmSlot).ToList();
                        }
                        break;
                    }

                case (int)ChannelType.DigitTachometerChannelInfo:
                    {
                        var historyResult = client.QueryHistorySampleData <D_DigitTachometerSlot>(new Guid[] { guid }, columns, startTime, endTime, condition, args);

                        //先判断是不是OK
                        if (historyResult.IsOK)
                        {
                            return historyResult.ResponseItem.OrderBy(p => p.ACQDatetime).Select(p => ClassCopyHelper.AutoCopy <D_DigitTachometerSlot, D1_DigitTachometerSlot>(p) as IBaseAlarmSlot).ToList();
                        }
                        break;
                    }

                case (int)ChannelType.AnalogRransducerInChannelInfo:
                    {
                        var historyResult = client.QueryHistorySampleData <D_AnalogRransducerInSlot>(new Guid[] { guid }, columns, startTime, endTime, condition, args);

                        //先判断是不是OK
                        if (historyResult.IsOK)
                        {
                            return historyResult.ResponseItem.OrderBy(p => p.ACQDatetime).Select(p => ClassCopyHelper.AutoCopy <D_AnalogRransducerInSlot, D1_AnalogRransducerInSlot>(p) as IBaseAlarmSlot).ToList();
                        }
                        break;
                    }

                case (int)ChannelType.RelayChannelInfo:
                    {
                        var historyResult = client.QueryHistorySampleData <D_RelaySlot>(new Guid[] { guid }, columns, startTime, endTime, condition, args);

                        //先判断是不是OK
                        if (historyResult.IsOK)
                        {
                            return historyResult.ResponseItem.OrderBy(p => p.ACQDatetime).Select(p => ClassCopyHelper.AutoCopy <D_RelaySlot, D1_RelaySlot>(p) as IBaseAlarmSlot).ToList();
                        }
                        break;
                    }

                case (int)ChannelType.DigitRransducerInChannelInfo:
                    {
                        var historyResult = client.QueryHistorySampleData <D_DigitRransducerInSlot>(new Guid[] { guid }, columns, startTime, endTime, condition, args);

                        //先判断是不是OK
                        if (historyResult.IsOK)
                        {
                            return historyResult.ResponseItem.OrderBy(p => p.ACQDatetime).Select(p => ClassCopyHelper.AutoCopy <D_DigitRransducerInSlot, D1_DigitRransducerInSlot>(p) as IBaseAlarmSlot).ToList();
                        }
                        break;
                    }

                case (int)ChannelType.DigitRransducerOutChannelInfo:
                    {
                        var historyResult = client.QueryHistorySampleData <D_DigitRransducerOutSlot>(new Guid[] { guid }, columns, startTime, endTime, condition, args);

                        //先判断是不是OK
                        if (historyResult.IsOK)
                        {
                            return historyResult.ResponseItem.OrderBy(p => p.ACQDatetime).Select(p => ClassCopyHelper.AutoCopy <D_DigitRransducerOutSlot, D1_DigitRransducerOutSlot>(p) as IBaseAlarmSlot).ToList();
                        }
                        break;
                    }

                case (int)ChannelType.AnalogRransducerOutChannelInfo:
                    {
                        var historyResult = client.QueryHistorySampleData <D_AnalogRransducerOutSlot>(new Guid[] { guid }, columns, startTime, endTime, condition, args);

                        //先判断是不是OK
                        if (historyResult.IsOK)
                        {
                            return historyResult.ResponseItem.OrderBy(p => p.ACQDatetime).Select(p => ClassCopyHelper.AutoCopy <D_AnalogRransducerOutSlot, D1_AnalogRransducerOutSlot>(p) as IBaseAlarmSlot).ToList();
                        }
                        break;
                    }

                case (int)ChannelType.WirelessVibrationChannelInfo:
                    {
                        var historyResult = client.QueryHistorySampleData <D_WirelessVibrationSlot>(new Guid[] { guid }, columns, startTime, endTime, condition, args);

                        //先判断是不是OK
                        if (historyResult.IsOK)
                        {
                            return historyResult.ResponseItem.OrderBy(p => p.ACQDatetime).Select(p => ClassCopyHelper.AutoCopy <D_WirelessVibrationSlot, D1_WirelessVibrationSlot>(p) as IBaseAlarmSlot).ToList();
                        }
                        break;
                    }

                case (int)ChannelType.WirelessScalarChannelInfo:
                    {
                        var historyResult = client.QueryHistorySampleData <D_WirelessScalarSlot>(new Guid[] { guid }, columns, startTime, endTime, condition, args);

                        //先判断是不是OK
                        if (historyResult.IsOK)
                        {
                            return historyResult.ResponseItem.OrderBy(p => p.ACQDatetime).Select(p => ClassCopyHelper.AutoCopy <D_WirelessScalarSlot, D1_WirelessScalarSlot>(p) as IBaseAlarmSlot).ToList();
                        }
                        break;
                    }

                default: return null;
                }
                if (errorMessage != null)
                {
                    EventAggregatorService.Instance.EventAggregator.GetEvent <ThrowExceptionEvent>().Publish(Tuple.Create <string, Exception>("数据库操作", new Exception(errorMessage)));
                }
                return null;
            }));
        }
Exemplo n.º 5
0
        private async Task AMSTrackChanged(IEnumerable <BaseWaveChannelToken> tokens)
        {
            try
            {
                if (tokens == null)
                {
                    return;
                }

                var unValidTokens = tokens.Where(o => o.CurrentIndex == -1);
                foreach (var token in unValidTokens)
                {
                    token.VData = null;
                }

                var validTokens = tokens.Where(o => o.CurrentIndex != -1).ToArray();

                if (validTokens.Length == 0)
                {
                    return;
                }

                //var globalIndexes = validTokens.Select(o => o.DataContracts[o.CurrentIndex].ChannelGlobalIndex).ToArray();
                //var ids = validTokens.Select(o => o.DataContracts[o.CurrentIndex].id).ToArray();
                //var date = validTokens.Select(o => o.DataContracts[o.CurrentIndex].ACQDatetime).First();

                List <IWaveformData> result = new List <IWaveformData>();
                foreach (var token in validTokens)
                {
                    if (token is BaseDivfreChannelToken)
                    {
                        var divtoken = token as BaseDivfreChannelToken;

                        List <D_WirelessVibrationSlot_Waveform> data = null;
                        if (divtoken.CurrentIndex != -1 && (divtoken.DataContracts[divtoken.CurrentIndex] as IBaseDivfreSlot).IsValidWave.Value == true)//修正拖动太快,CurrentIndex一直在变
                        {
                            data = await _databaseComponent.GetHistoryData <D_WirelessVibrationSlot_Waveform>(divtoken.IP, divtoken.Guid, new string[] { "WaveData", "SampleFre", "SamplePoint", "WaveUnit" }, divtoken.DataContracts[divtoken.CurrentIndex].ACQDatetime.AddSeconds(-1), divtoken.DataContracts[divtoken.CurrentIndex].ACQDatetime.AddSeconds(20), "(RecordLab = @0)", new object[] { divtoken.DataContracts[divtoken.CurrentIndex].RecordLab });
                        }
                        else
                        {
                            token.VData = null;
                        }
                        if (data != null && data.Count > 0)
                        {
                            result.Add(ClassCopyHelper.AutoCopy <D_WirelessVibrationSlot_Waveform, WirelessVibrationSlotData_Waveform>(data[0]));
                        }
                        else
                        {
                            token.VData = null;
                        }
                    }
                }

                await Task.Run(() => Parallel.For(0, result.Count, i =>
                {
                    VibrationData vdata = new VibrationData();
                    vdata.Waveform      = Algorithm.ByteToSingle(result[i].WaveData);
                    vdata.SampleFre     = result[i].SampleFre ?? 0;
                    vdata.SamplePoint   = result[i].SamplePoint ?? 0;
                    vdata.Unit          = result[i].WaveUnit;

                    var paras = Algorithm.CalculatePara(vdata.Waveform);
                    if (paras != null)
                    {
                        vdata.RMSValue       = paras[0];
                        vdata.PeakValue      = paras[1];
                        vdata.PeakPeakValue  = paras[2];
                        vdata.Slope          = paras[3];
                        vdata.Kurtosis       = paras[4];
                        vdata.KurtosisValue  = paras[5];
                        vdata.WaveIndex      = paras[6];
                        vdata.PeakIndex      = paras[7];
                        vdata.ImpulsionIndex = paras[8];
                        vdata.RootAmplitude  = paras[9];
                        vdata.ToleranceIndex = paras[10];
                    }

                    double sampleFre = vdata.SampleFre;
                    if (vdata.Trigger == TriggerType.Angle)
                    {
                        if (vdata.RPM > 0 && vdata.TeethNumber > 0)
                        {
                            sampleFre = vdata.RPM *vdata.TeethNumber / 60;
                        }
                    }

                    int length = (int)(vdata.SamplePoint / 2.56) + 1;
                    if (vdata.Frequency == null || vdata.Frequency.Length != length)
                    {
                        vdata.Frequency = new double[length];
                    }
                    double frequencyInterval = sampleFre / vdata.SamplePoint;
                    for (int j = 0; j < length; j++)
                    {
                        vdata.Frequency[j] = frequencyInterval *j;
                    }
                    var output = Algorithm.Instance.FFT2AndPhaseAction(vdata.Waveform, vdata.SamplePoint);
                    if (output != null)
                    {
                        vdata.Amplitude = output[0].Take(length).ToArray();
                        vdata.Phase     = output[1].Take(length).ToArray();
                    }
                    validTokens[i].VData = vdata;
                }));

                timeDomainVM.ChangeChannelData(tokens);
                frequencyDomainVM.ChangeChannelData(tokens);
            }
            catch (Exception ex)
            {
                _eventAggregator.GetEvent <ThrowExceptionEvent>().Publish(Tuple.Create <string, Exception>("数据回放-TrackChanged", ex));
            }
        }