Example #1
0
 public async Task <TNL_DeviceInfo> SaveDeviceInfo(TNL_DeviceInfo DeviceInfo)
 {
     return(await _baseRepository.InsertAsync(DeviceInfo));
 }
Example #2
0
        public async Task Run(UploadOriginData originData)
        {
            //首先判断是否存在数据包体,要不浪费
            if (originData.uploadEntitys.Count <= 0) return;
            using var dbContext = new EFContext();
            using var trans = await dbContext.Database.BeginTransactionAsync();
            foreach (var Clight in originData.uploadEntitys)//针对多通道进行
            {
                var uploadPropertys = Clight.Value;
                //关键判断是否存在IMEI号,如果存在,则认为是通电数据
                if (!uploadPropertys.ContainsKey(NBRAC.DeviceType)) return;
                try
                {
                    var upets = uploadPropertys;
                    //如果组织信息变动,则发送
                    TransmitData transmitData = null;
                    var NowDate = DateTime.Now;
                    //经纬度
                    double longitude = 0;
                    double latitude = 0;
                    //物理地址
                    var PhysicalAddress = string.Join(string.Empty, from d in originData.addressDomain
                                                                    select d.ToString("X")).PadLeft(12, '0');
                    #region 设备信息表
                    #region 获取设备信息主表
                    //设备表
                    TNL_DeviceInfo OrigindeviceInfo = dbContext.TNL_DeviceInfos.AsNoTracking().FirstOrDefault(d => d.DeviceAddress == PhysicalAddress);
                    //单灯表
                    TNL_TunnelLight light = await dbContext.TNL_TunnelLights
                                                           .AsNoTracking()
                                                           .FirstOrDefaultAsync(d => d.LightPhysicalAddress_TX == PhysicalAddress);
                    #endregion
                    //只需要找我要的寄存器地址就行了
                    if (OrigindeviceInfo == null)
                        OrigindeviceInfo = new TNL_DeviceInfo();
                    if (upets.ContainsKey(NBRAC.DeviceType))//DeviceType
                    {
                        OrigindeviceInfo.DeviceType = string.Join(string.Empty, from d in upets[NBRAC.DeviceType].MemeroyData
                                                                                select d.ToString("X2"));
                    }
                    if (upets.ContainsKey(NBRAC.HDVersion))//HDVersion
                    {
                        //OrigindeviceInfo.HDVersion = int.Parse(string.Join(string.Empty, from d in upets[NBRAC.HDVersion].MemeroyData
                        //                                                                 select d.ToString("X2")), NumberStyles.HexNumber)
                        //                                                           .ToString();
                        var HDVersionHex = upets[NBRAC.HDVersion].MemeroyData;
                        OrigindeviceInfo.HDVersion = HDVersionHex[0] + "." + HDVersionHex[1];
                    }
                    if (upets.ContainsKey(NBRAC.Version))//Version
                    {
                        var VersionHex = upets[NBRAC.Version].MemeroyData;
                        OrigindeviceInfo.Version = VersionHex[0] + "." + VersionHex[1];
                        //OrigindeviceInfo.Version = int.Parse(string.Join(string.Empty, from d in upets[NBRAC.Version].MemeroyData
                        //                                                               select d.ToString("X2")), NumberStyles.HexNumber)
                        //                                                           .ToString();

                    }
                    if (upets.ContainsKey(NBRAC.GPSInfo))//GPSInfo
                    {
                        //OrigindeviceInfo.GPSInfo = string.Join(string.Empty, from d in upets[NBRAC.GPSInfo].MemeroyData
                        //                                                     select d.ToString("X2"));
                        var GpsHex = string.Join(string.Empty, from d in uploadPropertys[NBRAC.GPSInfo].MemeroyData
                                                               select d.ToString("X2"));
                        try
                        {

                            var longitudeHex = GpsHex.Substring(0, 8);
                            var latitudeHex = GpsHex.Substring(8);
                            longitude = int.Parse(longitudeHex, NumberStyles.HexNumber) / 1000000.0;
                            latitude = int.Parse(latitudeHex, NumberStyles.HexNumber) / 1000000.0;
                            if (Math.Abs(longitude) > 0.01 && Math.Abs(latitude) > 0.01)//绝对值有效,才存入经纬度信息里
                            {
                                var pointInfo = Led.Tools.MapHelper.Nema2Google(new MapHelper.PointInfo(longitude, latitude));
                                //pointInfo.Lat = Math.Round(pointInfo.Lat, 8);
                                //pointInfo.Lon = Math.Round(pointInfo.Lon, 8);
                                OrigindeviceInfo.GPSInfo = pointInfo.Lon + "," + pointInfo.Lat;
                            }
                        }
                        catch (Exception)
                        { }

                    }
                    if (upets.ContainsKey(NBRAC.ReportInterval))//ReportInterval
                    {
                        OrigindeviceInfo.ReportInterval = int.Parse(string.Join(string.Empty, from d in upets[NBRAC.ReportInterval].MemeroyData
                                                                                              select d.ToString()));
                    }
                    if (upets.ContainsKey(NBRAC.TAVersion))//TAVersion
                    {
                        OrigindeviceInfo.TAVersion = int.Parse(string.Join(string.Empty, from d in upets[NBRAC.TAVersion].MemeroyData
                                                                                         select d.ToString("X2")), NumberStyles.HexNumber)
                                                                                  .ToString();
                    }
                    if (upets.ContainsKey(NBRAC.IMEI))//IMEI
                    {
                        OrigindeviceInfo.IMEI = Encoding.ASCII.GetString(upets[NBRAC.IMEI].MemeroyData);
                    }
                    if (upets.ContainsKey(NBRAC.IMSI))//IMSI
                    {
                        OrigindeviceInfo.IMSI = Encoding.ASCII.GetString(upets[NBRAC.IMSI].MemeroyData);
                    }
                    if (upets.ContainsKey(NBRAC.ICCID))//ICCID
                    {
                        OrigindeviceInfo.ICCID = Encoding.ASCII.GetString(upets[NBRAC.ICCID].MemeroyData);
                    }
                    if (upets.ContainsKey(NBRAC.BAND))//BAND
                    {
                        OrigindeviceInfo.BAND = int.Parse(string.Join(string.Empty, from d in upets[NBRAC.BAND].MemeroyData
                                                                                    select d.ToString("X2")), NumberStyles.HexNumber)
                                                        .ToString();
                    }
                    if (upets.ContainsKey(NBRAC.CELLID))//CELLID
                    {
                        OrigindeviceInfo.CELLID = string.Join(string.Empty, from d in upets[NBRAC.CELLID].MemeroyData
                                                                            select d.ToString("X2"));
                    }
                    if (upets.ContainsKey(NBRAC.RSSI))//RSSI
                    {
                        OrigindeviceInfo.RSSI = string.Join(string.Empty, from d in upets[NBRAC.RSSI].MemeroyData
                                                                          select d.ToString("X2"));
                    }
                    if (upets.ContainsKey(NBRAC.RSRP))//RSRP
                    {
                        OrigindeviceInfo.RSRP = string.Join(string.Empty, from d in upets[NBRAC.RSRP].MemeroyData
                                                                          select d.ToString("X2"));
                    }
                    if (upets.ContainsKey(NBRAC.UTC))//UTC
                    {
                        OrigindeviceInfo.UTC = string.Join(string.Empty, from d in upets[NBRAC.UTC].MemeroyData
                                                                         select d.ToString("X2"));
                    }
                    if (upets.ContainsKey(NBRAC.APN))//APN
                    {
                        OrigindeviceInfo.APN = Encoding.ASCII.GetString(upets[NBRAC.APN].MemeroyData);
                    }
                    if (upets.ContainsKey(NBRAC.IP))//Ip
                    {

                        OrigindeviceInfo.IP = Encoding.ASCII.GetString(upets[NBRAC.IP].MemeroyData);
                        //deviceInfo.IP = string.Join(string.Empty, from d in upets[NBRAC.IP].MemeroyData
                        //                                          select d.ToString());
                    }
                    if (upets.ContainsKey(NBRAC.Server))//Server
                    {
                        OrigindeviceInfo.Server = string.Join(string.Empty, from d in upets[NBRAC.Server].MemeroyData
                                                                            select d.ToString() + ".").TrimEnd('.');
                    }
                    if (upets.ContainsKey(NBRAC.Port))//Port
                    {
                        OrigindeviceInfo.Port = int.Parse(string.Join(string.Empty, from d in upets[NBRAC.Port].MemeroyData
                                                                                    select d.ToString("X2")), NumberStyles.HexNumber)
                                                                              .ToString();

                    }
                    if (upets.ContainsKey(NBRAC.Group0))//Group0
                    {
                        OrigindeviceInfo.Group0 = int.Parse(string.Join(string.Empty, from d in upets[NBRAC.Group0].MemeroyData
                                                                                      select d.ToString("X2")), NumberStyles.HexNumber);
                    }
                    if (upets.ContainsKey(NBRAC.Group1))//Group1
                    {
                        OrigindeviceInfo.Group1 = int.Parse(string.Join(string.Empty, from d in upets[NBRAC.Group1].MemeroyData
                                                                                      select d.ToString("X2")), NumberStyles.HexNumber);
                    }
                    if (upets.ContainsKey(NBRAC.Group2))//Group2
                    {
                        OrigindeviceInfo.Group2 = int.Parse(string.Join(string.Empty, from d in upets[NBRAC.Group2].MemeroyData
                                                                                      select d.ToString("X2")), NumberStyles.HexNumber);
                    }
                    if (upets.ContainsKey(NBRAC.Group3))//Group3
                    {
                        OrigindeviceInfo.Group3 = int.Parse(string.Join(string.Empty, from d in upets[NBRAC.Group3].MemeroyData
                                                                                      select d.ToString("X2")), NumberStyles.HexNumber);
                    }
                    if (upets.ContainsKey(NBRAC.Group4))//Group4
                    {
                        OrigindeviceInfo.Group4 = int.Parse(string.Join(string.Empty, from d in upets[NBRAC.Group4].MemeroyData
                                                                                      select d.ToString("X2")), NumberStyles.HexNumber);
                    }
                    if (upets.ContainsKey(NBRAC.Group5))//Group5
                    {
                        OrigindeviceInfo.Group5 = int.Parse(string.Join(string.Empty, from d in upets[NBRAC.Group5].MemeroyData
                                                                                      select d.ToString("X2")), NumberStyles.HexNumber);
                    }
                    if (upets.ContainsKey(NBRAC.Group6))//Group6
                    {
                        OrigindeviceInfo.Group6 = int.Parse(string.Join(string.Empty, from d in upets[NBRAC.Group6].MemeroyData
                                                                                      select d.ToString("X2")), NumberStyles.HexNumber);
                    }
                    if (upets.ContainsKey(NBRAC.Group7))//Group7
                    {
                        OrigindeviceInfo.Group7 = int.Parse(string.Join(string.Empty, from d in upets[NBRAC.Group7].MemeroyData
                                                                                      select d.ToString("X2")), NumberStyles.HexNumber);
                    }
                    if (originData.hasAddress)
                    {
                        OrigindeviceInfo.DeviceAddress = string.Join(string.Empty, from d in originData.addressDomain
                                                                                   select d.ToString("X")).PadLeft(12, '0');
                    }

                    //OrigindeviceInfo.ChannelNumber = uploadPropertys[NBRAC.IMEI].ChannelNumber;
                    OrigindeviceInfo.ChannelNumber = 0;
                    OrigindeviceInfo.LocalDate = NowDate;
                    OrigindeviceInfo.SampTime = NowDate;
                    if (OrigindeviceInfo.ID > 0)
                    {
                        #region 弃用
                        //deviceInfo.LocalDate = NowDate;
                        //deviceInfo.SampTime = NowDate;
                        //deviceInfo.DeviceType = OrigindeviceInfo.DeviceType;
                        //deviceInfo.HDVersion = OrigindeviceInfo.HDVersion;
                        //deviceInfo.Version = OrigindeviceInfo.Version;
                        //if (Math.Abs(longitude) > 0.01 && Math.Abs(latitude) > 0.01)//绝对值有效,才存入经纬度信息里
                        //    deviceInfo.GPSInfo = OrigindeviceInfo.GPSInfo;
                        //deviceInfo.ReportInterval = OrigindeviceInfo.ReportInterval;
                        //deviceInfo.TAVersion = OrigindeviceInfo.TAVersion;
                        //deviceInfo.IMEI = OrigindeviceInfo.IMEI;
                        //deviceInfo.IMSI = OrigindeviceInfo.IMSI;
                        //deviceInfo.ICCID = OrigindeviceInfo.ICCID;
                        //deviceInfo.BAND = OrigindeviceInfo.BAND;
                        //deviceInfo.CELLID = OrigindeviceInfo.CELLID;
                        //deviceInfo.RSSI = OrigindeviceInfo.RSSI;
                        //deviceInfo.RSRP = OrigindeviceInfo.RSRP;
                        //deviceInfo.UTC = OrigindeviceInfo.UTC;
                        //deviceInfo.APN = OrigindeviceInfo.APN;
                        //deviceInfo.IP = OrigindeviceInfo.IP;
                        //deviceInfo.Server = OrigindeviceInfo.Server;
                        //deviceInfo.Port = OrigindeviceInfo.Port;
                        //deviceInfo.DeviceAddress = OrigindeviceInfo.DeviceAddress;
                        //deviceInfo.ChannelNumber = OrigindeviceInfo.ChannelNumber;
                        //deviceInfo.Group0 = OrigindeviceInfo.Group0;
                        //deviceInfo.Group1 = OrigindeviceInfo.Group1;
                        //deviceInfo.Group2 = OrigindeviceInfo.Group2;
                        //deviceInfo.Group3 = OrigindeviceInfo.Group3;
                        //deviceInfo.Group4 = OrigindeviceInfo.Group4;
                        //deviceInfo.Group5 = OrigindeviceInfo.Group5;
                        //deviceInfo.Group6 = OrigindeviceInfo.Group6;
                        //deviceInfo.Group7 = OrigindeviceInfo.Group7;
                        #endregion

                        dbContext.TNL_DeviceInfos.Update(OrigindeviceInfo);
                    }
                    else
                    {
                        await dbContext.TNL_DeviceInfos.AddAsync(OrigindeviceInfo);
                    }
                    #endregion

                    #region 单灯表
                    var LightType = 0;//默认单灯
                    if (upets.ContainsKey(NBRAC.LightType))//单双灯类型
                    {
                        var lightTypeNumber = int.Parse(string.Join(string.Empty, from d in upets[NBRAC.LightType].MemeroyData
                                                                                  select d.ToString("X2")), NumberStyles.HexNumber);
                        if (lightTypeNumber > 1)
                        {
                            LightType = 1;//双灯
                        }
                    }
                    if (light == null)
                    {
                        light = new TNL_TunnelLight();
                        #region 赋值单灯信息
                        //var lightKey = await DBHelper.GetDataKey("TNL_TunnelLight", "TunnelLight_ID");
                        //if (lightKey != 0) light.TunnelLight_ID = lightKey;
                        //else light.TunnelLight_ID = 1000001;
                        //light.TunnelLight_ID = 0;
                        ////light.TunnelSection_ID = 1;
                        ////light.TunnelGateway_ID = 0;
                        ////light.Tunnel_ID = 0;
                        ////if (originData.hasAddress)
                        ////{
                        ////    light.LightPhysicalAddress_TX = PhysicalAddress.PadLeft(12, '0');
                        ////}
                        ////else
                        ////{
                        ////    light.LightPhysicalAddress_TX = "000000000000";
                        ////}
                        ////light.LightLocationNumber_NR = 0;
                        //light.LightType_TX = null;
                        //light.PowerType_TX = null;
                        //light.VoltageHighValue_NR = null;
                        //light.VoltageLowValue_NR = null;
                        //light.CurrentHighValue_NR = null;
                        //light.CurrentLowValue_NR = null;
                        //light.Longitude = null;
                        //light.Latitude = null;
                        ////light.LightUsage_NR = 2;
                        //light.Mileage_TX = null;
                        //light.PowerModel_TX = null;
                        //light.PowerManufacturer_TX = null;
                        //light.LightModel_TX = null;
                        //light.LightManufacturer_TX = null;
                        ////light.GroupNumber_TX = ",,";
                        ////light.LightFunction_NR = 0;
                        ////light.LightSource_NR = 0;
                        ////light.LampType_NR = 0;
                        //light.PoleNumber_TX = null;
                        //light.PoleManufacturers_TX = null;
                        //light.FlangeSize_TX = null;
                        //light.BasicFrameSize_TX = null;
                        //light.CableType_NR = null;
                        //light.PowerPhase_NR = null;
                        ////light.DimmingFactor_NR = 1;
                        ////light.DefaultDimmingValue_NR = 100;
                        ////light.PowerOnDimmingValue_NR = 100;
                        ////light.MaximumDimmingValue_NR = 100;
                        ////light.MinimumDimmingValue_NR = 0;
                        //light.PowerGroundingType_NR = null;
                        //light.NorminalPower_NR = null;
                        //light.LightColor_NR = null;
                        //light.PoleHieght_NR = null;
                        //light.InstallationDate_DT = NowDate;
                        ////light.Active_YN = '1';
                        ////light.EnablePIRFunction_YN = '0';
                        ////light.PIRLastTimeMinutesOfDimming_NR = 30;
                        ////light.PIRRestoreTime_NR = 5;
                        ////light.PIRGroupNumber_NR = 1;
                        ////light.PIRIdleDimmingValue_NR = 30;
                        ////light.PIRDimmingValue_NR = 100;
                        ////light.PIRTTL_NR = 0;
                        ////light.LightConfig_ID = 0;
                        ////light.LightTimeControl_ID = 0;
                        //light.Longitude2 = null;
                        //light.Latitude2 = null;
                        //light.StorageInterval_NR = null;
                        //light.SamplingInterval_NR = null;
                        ////light.PIRSensorPlan_ID = 0;
                        //light.OID = null;
                        ////light.SampleDate = NowDate;
                        //light.RecDateTime = NowDate;
                        //light.LastUID = null;
                        //light.InfoLink = null;
                        //light.TemperatureHigh_NR = null;
                        //light.TemperatureLow_NR = null;
                        ////light.IsIot = 1;
                        ////light.IMEI = OrigindeviceInfo.IMEI;
                        ////light.IMSI = OrigindeviceInfo.IMSI;
                        ////light.ICCID = OrigindeviceInfo.ICCID;
                        //light.DeviceId = deviceEntity.ID;
                        //light.Scheme_ID = null;
                        ////light.ChannelNumber = upets[NBRAC.IMEI].ChannelNumber;
                        //light.RTCTimeDimmingPlan_ID = null;
                        //await dbContext.AddAsync(light);
                        #endregion

                        SqlParameter[] Param =
                      {
                        new SqlParameter("@P_GatewayPAddress", System.Data.SqlDbType.VarChar){ Value="1"},
                        new SqlParameter("@P_LightPAddress", System.Data.SqlDbType.VarChar){ Value=PhysicalAddress},
                        new SqlParameter("@P_longitude", System.Data.SqlDbType.Float){ Value=0},
                        new SqlParameter("@P_latitude", System.Data.SqlDbType.Float){ Value=0},
                        new SqlParameter("@P_RecDateTime", System.Data.SqlDbType.DateTime){ Value=NowDate},
                        new SqlParameter("@P_ChannelNumber", System.Data.SqlDbType.Int){ Value= Clight.Key},
                        new SqlParameter("@P_LightID", System.Data.SqlDbType.Int){ Value=0,Direction=ParameterDirection.Output},
                        new SqlParameter("@P_Msg", System.Data.SqlDbType.VarChar){ Value=string.Empty,Direction=ParameterDirection.Output},
                        };
                        var result = await dbContext.Database.ExecuteSqlCommandAsync("GPS_InsertDataDoubleLight @P_GatewayPAddress,@P_LightPAddress,@P_longitude,@P_latitude,@P_RecDateTime,@P_ChannelNumber,@P_LightID OUTPUT,@P_Msg OUTPUT", Param);
                        int lightid = Convert.ToInt32(Param[6].Value);
                        light = await dbContext.TNL_TunnelLights.AsNoTracking().FirstOrDefaultAsync(d => d.TunnelLight_ID == lightid);
                        if (light != null)
                        {
                            light.IMEI = OrigindeviceInfo.IMEI;
                            light.IMSI = OrigindeviceInfo.IMSI;
                            light.ICCID = OrigindeviceInfo.ICCID;
                            light.ChannelNumber = upets[NBRAC.DeviceType].ChannelNumber;
                            dbContext.Update(light);
                        }
                    }
                    else
                    {
                        if (originData.hasAddress)
                        {
                            light.LightPhysicalAddress_TX = PhysicalAddress;
                        }
                        else
                        {
                            light.LightPhysicalAddress_TX = "000000000000";
                        }
                        light.IMEI = OrigindeviceInfo.IMEI;
                        light.IMSI = OrigindeviceInfo.IMSI;
                        light.ICCID = OrigindeviceInfo.ICCID;
                        light.ChannelNumber = upets[NBRAC.DeviceType].ChannelNumber;
                        light.LightUsage_NR = LightType;
                        dbContext.Update(light);


                    }
                    OrigindeviceInfo.TunnelLight_ID = light.TunnelLight_ID;
                    //OrigindeviceInfo.TunnelLight_ID = 183;


                    //以下判断分组信息,如果不一致,则下发初始化信息。
                    #region 更新分组信息
                    if (upets.ContainsKey(NBRAC.Group0) ||
                        upets.ContainsKey(NBRAC.Group1) ||
                        upets.ContainsKey(NBRAC.Group2) ||
                        upets.ContainsKey(NBRAC.Group3) ||
                        upets.ContainsKey(NBRAC.Group4) ||
                        upets.ContainsKey(NBRAC.Group5) ||
                        upets.ContainsKey(NBRAC.Group6) ||
                        upets.ContainsKey(NBRAC.Group7))
                    {
                        ////暂时先不放开
                        //if (light.TunnelSection_ID != OrigindeviceInfo.Group0
                        // || light.TunnelSection_ID != OrigindeviceInfo.Group1
                        // || light.TunnelSection_ID != OrigindeviceInfo.Group2
                        // || light.TunnelSection_ID != OrigindeviceInfo.Group3
                        // || light.TunnelSection_ID != OrigindeviceInfo.Group4
                        // || light.TunnelSection_ID != OrigindeviceInfo.Group5
                        // || light.TunnelSection_ID != OrigindeviceInfo.Group6
                        // || light.TunnelSection_ID != OrigindeviceInfo.Group7)//如果分组信息不一样,那么则发送初始化信息过去
                        //{
                        //    #region 组装数据
                        //    //MoonsHelper
                        //    var rtc_guid = Guid.NewGuid();
                        //    rtc_guid.ToString().ToUpper();
                        //    //string GUID = string.Join("", guid.ToByteArray().Select(d => d.ToString("X2")));
                        //    var gval0 = TransmitHelper.GetGroupHex(deviceInfo.Group0);
                        //    var gval1 = TransmitHelper.GetGroupHex(deviceInfo.Group1);
                        //    var gval2 = TransmitHelper.GetGroupHex(deviceInfo.Group2);
                        //    var gval3 = TransmitHelper.GetGroupHex(deviceInfo.Group3);
                        //    var gval4 = TransmitHelper.GetGroupHex(deviceInfo.Group4);
                        //    var gval5 = TransmitHelper.GetGroupHex(deviceInfo.Group5);
                        //    var gval6 = TransmitHelper.GetGroupHex(deviceInfo.Group6);
                        //    var gval7 = TransmitHelper.GetGroupHex(deviceInfo.Group7);
                        //    gval0 = TransmitHelper.MergeBytes(gval0.Length, 4, gval0);
                        //    gval1 = TransmitHelper.MergeBytes(gval1.Length, 4, gval1);
                        //    gval2 = TransmitHelper.MergeBytes(gval2.Length, 4, gval2);
                        //    gval3 = TransmitHelper.MergeBytes(gval3.Length, 4, gval3);
                        //    gval4 = TransmitHelper.MergeBytes(gval4.Length, 4, gval4);
                        //    gval5 = TransmitHelper.MergeBytes(gval5.Length, 4, gval5);
                        //    gval6 = TransmitHelper.MergeBytes(gval6.Length, 4, gval6);
                        //    gval7 = TransmitHelper.MergeBytes(gval7.Length, 4, gval7);
                        //    List<byte> GroupBytes = new List<byte>();
                        //    GroupBytes.AddRange(new byte[] { NBRAC.Group0, upets[NBRAC.Group0].ChannelNumber, 0x04 }.Concat(gval0));
                        //    GroupBytes.AddRange(new byte[] { NBRAC.Group1, upets[NBRAC.Group1].ChannelNumber, 0x04 }.Concat(gval1));
                        //    GroupBytes.AddRange(new byte[] { NBRAC.Group2, upets[NBRAC.Group2].ChannelNumber, 0x04 }.Concat(gval2));
                        //    GroupBytes.AddRange(new byte[] { NBRAC.Group3, upets[NBRAC.Group3].ChannelNumber, 0x04 }.Concat(gval3));
                        //    GroupBytes.AddRange(new byte[] { NBRAC.Group4, upets[NBRAC.Group4].ChannelNumber, 0x04 }.Concat(gval4));
                        //    GroupBytes.AddRange(new byte[] { NBRAC.Group5, upets[NBRAC.Group5].ChannelNumber, 0x04 }.Concat(gval5));
                        //    GroupBytes.AddRange(new byte[] { NBRAC.Group6, upets[NBRAC.Group6].ChannelNumber, 0x04 }.Concat(gval6));
                        //    GroupBytes.AddRange(new byte[] { NBRAC.Group7, upets[NBRAC.Group7].ChannelNumber, 0x04 }.Concat(gval7));
                        //    #endregion

                        //    var TransmitHex = TransmitHelper.SendNBComand(rtc_guid.ToByteArray(), GroupBytes.ToArray());
                        //    transmitData = new TransmitData
                        //    {
                        //        Topic = AppSetting.LightTopicBefore + deviceInfo.IMEI,
                        //        CommandCode = DataHelper.BytesToHexStr(new byte[] { 0x04 }),
                        //        MesssageID = int.Parse(string.Join(string.Empty, from d in originData.messsageId select d.ToString())),
                        //        Data = TransmitHex,
                        //        UUID = rtc_guid
                        //    };
                        //}
                    }
                    #endregion
                    #endregion

                    #region 当前单灯表
                    var lightalm = await dbContext.TNL_TunnelLightAlms.FirstOrDefaultAsync(d => d.TunnelLight_ID == light.TunnelLight_ID);
                    //lightalm.TunnelLight_ID = summary.TunnelLight_ID;
                    if (lightalm == null)
                    {
                        lightalm = new TNL_TunnelLightAlm();
                        lightalm.AlmLevel_ID = 0;
                        lightalm.TunnelLight_ID = light.TunnelLight_ID;
                        lightalm.SampTime_DT = NowDate;
                        lightalm.ChannelNumber = light.ChannelNumber;
                        lightalm.LocalDate = NowDate;
                        lightalm.DataSource = 0;
                        lightalm.RemoteEndPoint = OrigindeviceInfo.IP;
                        //lightalm.Signal_NR = summary.Signal_NR;
                        lightalm.Version = OrigindeviceInfo.Version;
                        lightalm.IMEI = OrigindeviceInfo.IMEI;
                        lightalm.IMSI = OrigindeviceInfo.IMSI;
                        lightalm.ICCID = OrigindeviceInfo.ICCID;
                        lightalm.bandNo = int.Parse(OrigindeviceInfo.BAND);
                        //lightalm.State = OrigindeviceInfo.;
                        if (Math.Abs(longitude) > 0.01 && Math.Abs(latitude) > 0.01)//绝对值有效,才存入经纬度信息里
                            lightalm.GpsInfo = OrigindeviceInfo.GPSInfo;
                        lightalm.FirmwareVersion_NR = int.Parse(OrigindeviceInfo.Version.Replace(".", string.Empty));
                        //lightalm.PhotoCell = summary.poho;
                        //lightalm.InspectSuccess_DT = NowDate;
                        //lightalm.IsDay = summary.IsDay.ToString();
                        //lightalm.LightningCount = summary.LightningCount.ToString();
                        //lightalm.upUID = summary.upk;
                        //lightalm.CSQ = deviceInfo.csq;                   
                        await dbContext.AddAsync(lightalm);
                    }
                    else
                    {
                        lightalm.AlmLevel_ID = 0;
                        lightalm.TunnelLight_ID = light.TunnelLight_ID;
                        lightalm.SampTime_DT = NowDate;
                        lightalm.ChannelNumber = light.ChannelNumber;
                        lightalm.LocalDate = NowDate;
                        lightalm.DataSource = 0;
                        lightalm.RemoteEndPoint = OrigindeviceInfo.IP;
                        //lightalm.Signal_NR = summary.Signal_NR;
                        lightalm.Version = OrigindeviceInfo.Version;
                        lightalm.bandNo = int.Parse(OrigindeviceInfo.BAND);
                        //lightalm.State = OrigindeviceInfo.;
                        lightalm.GpsInfo = OrigindeviceInfo.GPSInfo;
                        lightalm.FirmwareVersion_NR = int.Parse(OrigindeviceInfo.Version.Replace(".", string.Empty));
                        //lightalm.PhotoCell = summary.poho;
                        //lightalm.InspectSuccess_DT = NowDate;
                        //lightalm.IsDay = summary.IsDay.ToString();
                        //lightalm.LightningCount = summary.LightningCount.ToString();
                        //lightalm.upUID = summary.upk;
                        //lightalm.CSQ = deviceInfo.csq;                   
                        dbContext.Update(lightalm);
                    }
                    #endregion

                    await dbContext.SaveChangesAsync();
                    await trans.CommitAsync();

                    //发送数据
                    try
                    {
                        //先把数据入库,再发送到设备上
                        if (transmitData != null) await TransmitContext.GetInstance().GetTransmitSchedule().Run(transmitData);

                        //校时
                        #region RTC校时
                        await Task.Delay(1000);
                        Guid guid = Guid.NewGuid();
                        DateTime NowTime = DateTime.Now;
                        var year = NowTime.Year.ToString("X4");
                        var month = NowTime.Month.ToString("X2");
                        var day = NowTime.Day.ToString("X2");
                        var week = ((int)NowTime.DayOfWeek).ToString("X2");
                        var hour = NowTime.Hour.ToString("X2");
                        var minute = NowTime.Minute.ToString("X2");
                        var second = NowTime.Second.ToString("X2");
                        var RTCHex = year + month + day + week + hour + minute + second;
                        var RTCBytes = HexFormatHelper.StringConvertHexBytes(RTCHex);
                        var RTCTransmitHex = TransmitHelper.SendNBComand(guid.ToByteArray(), RTCBytes, (byte)NBCommondCode.DateSync);
                        var RTCtransmitData = new TransmitData
                        {
                            Topic = AppSetting.LightTopicBefore + OrigindeviceInfo.IMEI,
                            CommandCode = DataHelper.BytesToHexStr(new byte[] { (byte)NBCommondCode.DateSync }),
                            MesssageID = int.Parse(string.Join(string.Empty, from d in originData.messsageId select d.ToString())),
                            Data = RTCTransmitHex,
                            UUID = guid
                        };
                        await TransmitContext.GetInstance().GetTransmitSchedule().Run(RTCtransmitData);
                        #endregion
                    }
                    catch (Exception e)
                    {
                        throw new ArgumentException("发送错误", e);
                    }

                }
                catch (ArgumentException ex)
                {
                    logger.Error("下发设备信息错误: " + ex.ToString());
                }
                catch (Exception ex)
                {
                    await trans.RollbackAsync();
                    logger.Error("Devcie Error:" + this.GetType().FullName + " " + ex.ToString());
                    throw;
                }

            }
        }
Example #3
0
        public async Task Run(UploadOriginData originData)
        {
            if (originData.uploadEntitys.Count <= 0)
            {
                return;
            }
            try
            {
                using var dbContext = new EFContext();
                using var trans     = await dbContext.Database.BeginTransactionAsync();

                try
                {
                    //UPLogger.Show("进来了,数据是" + originData.uploadEntitys.Count + "个。");
                    foreach (var Clight in originData.uploadEntitys)//针对多通道进行
                    {
                        var uploadPropertys = Clight.Value;
                        if (uploadPropertys.ContainsKey(NBRAC.DeviceType))
                        {
                            return;
                        }
                        //if (!uploadPropertys.ContainsKey(NBRAC.DimmingFeature)) return;
                        //logger.Info("进来了哦");

                        await Task.Delay(1000);

                        var Now = DateTime.Now;
                        //经纬度
                        double longitude = 0;
                        double latitude  = 0;

                        TNL_History_Summary summary = new TNL_History_Summary();
                        summary.Partition_ID = long.Parse(Now.ToString("yyyyMMddHHmmss"));

                        var keyObj = await DataBaseHelper.GetKey("TNL_History_Summary", "History_ID");

                        if (keyObj != 0)
                        {
                            summary.History_ID = keyObj;
                        }
                        else
                        {
                            summary.History_ID = 1000001;
                        }

                        var DeviceAddress = string.Join("", from d in originData.addressDomain select d.ToString("X")).PadLeft(12, '0');
                        var DeviceInfo    = await(from d in dbContext.TNL_DeviceInfos
                                                  where d.DeviceAddress == DeviceAddress
                                                  select d).AsNoTracking().FirstOrDefaultAsync();
                        var lightInfo = await(from d in dbContext.TNL_TunnelLights
                                              where d.LightPhysicalAddress_TX == DeviceAddress &&
                                              d.ChannelNumber == Clight.Key
                                              select d).AsNoTracking().FirstOrDefaultAsync();
                        //var lightInfo = await dbContext.TNL_TunnelLights
                        // .AsNoTracking()
                        // .FirstOrDefaultAsync(d => d.IMEI.Contains(DeviceAddress));
                        if (lightInfo == null)
                        {
                            SqlParameter[] Param =
                            {
                                new SqlParameter("@P_GatewayPAddress", System.Data.SqlDbType.VarChar)
                                {
                                    Value = "1"
                                },
                                new SqlParameter("@P_LightPAddress",   System.Data.SqlDbType.VarChar)
                                {
                                    Value = DeviceAddress
                                },
                                new SqlParameter("@P_longitude",       System.Data.SqlDbType.Float)
                                {
                                    Value = 0
                                },
                                new SqlParameter("@P_latitude",        System.Data.SqlDbType.Float)
                                {
                                    Value = 0
                                },
                                new SqlParameter("@P_RecDateTime",     System.Data.SqlDbType.DateTime)
                                {
                                    Value = Now
                                },
                                new SqlParameter("@P_ChannelNumber",   System.Data.SqlDbType.Int)
                                {
                                    Value = Clight.Key
                                },
                                new SqlParameter("@P_LightID",         System.Data.SqlDbType.Int)
                                {
                                    Value = 0,                         Direction = ParameterDirection.Output
                                },
                                new SqlParameter("@P_Msg",             System.Data.SqlDbType.VarChar)
                                {
                                    Value = string.Empty,              Direction = ParameterDirection.Output
                                },
                            };
                            var result = await dbContext.Database.ExecuteSqlCommandAsync("GPS_InsertDataDoubleLight @P_GatewayPAddress,@P_LightPAddress,@P_longitude,@P_latitude,@P_RecDateTime,@P_ChannelNumber,@P_LightID OUTPUT,@P_Msg OUTPUT", Param);

                            int lightid = Convert.ToInt32(Param[6].Value);
                            lightInfo = await dbContext.TNL_TunnelLights.AsNoTracking().FirstOrDefaultAsync(d => d.TunnelLight_ID == lightid);

                            //UPLogger.Show($"light发现了是空的:{lightInfo.TunnelLight_ID}");
                        }
                        //logger.Info("lightInfo");

                        if (DeviceInfo == null)//如果没发现设备信息
                        {
                            DeviceInfo = new TNL_DeviceInfo();
                            DeviceInfo.TunnelLight_ID = lightInfo.TunnelLight_ID;
                            DeviceInfo.DeviceAddress  = DeviceAddress;
                            //originData
                            //DeviceInfo.IMEI
                            DeviceInfo.LocalDate     = Now;
                            DeviceInfo.SampTime      = Now;
                            DeviceInfo.ChannelNumber = uploadPropertys[NBRAC.DimmingFeature].ChannelNumber;
                            await dbContext.TNL_DeviceInfos.AddAsync(DeviceInfo);
                        }
                        else
                        {
                            lightInfo.IMEI  = DeviceInfo.IMEI;
                            lightInfo.IMSI  = DeviceInfo.IMSI;
                            lightInfo.ICCID = DeviceInfo.ICCID;
                        }

                        //logger.Info("DeviceInfo");
                        #region 插入历史信息表
                        if (lightInfo != null)
                        {
                            summary.TunnelLight_ID = lightInfo.TunnelLight_ID;
                        }
                        else
                        {
                            summary.TunnelLight_ID = 0; //没找到这个灯具:DeviceInfo被删除、单灯表被删除
                        }
                        summary.SampTime_DT = Now;
                        //TNL_DeviceInfo DeviceInfo = new TNL_DeviceInfo();
                        //if (lightInfo != null)
                        //{
                        //    DeviceInfo = await dbContext.TNL_DeviceInfos
                        //                          .AsNoTracking()
                        //                          .FirstOrDefaultAsync(d => d.IMEI == lightInfo.IMEI);
                        //}
                        summary.AlmLevel_ID = 0;
                        if (uploadPropertys.ContainsKey(NBRAC.DimmingFeature))
                        {
                            summary.DimmingFeatureValue_NR = Math.Round(int.Parse(string.Join(string.Empty,
                                                                                              from d in uploadPropertys[NBRAC.DimmingFeature].MemeroyData
                                                                                              select d.ToString("X2")), NumberStyles.HexNumber) / 2.55, 0);
                        }
                        if (uploadPropertys.ContainsKey(NBRAC.VoltageFeature))
                        {
                            summary.VoltageFeatureValue_NR = Math.Round(int.Parse(string.Join(string.Empty,
                                                                                              from d in uploadPropertys[NBRAC.VoltageFeature].MemeroyData
                                                                                              select d.ToString("X2")), NumberStyles.HexNumber) * 0.1, 2);
                        }
                        if (uploadPropertys.ContainsKey(NBRAC.CurrentFeature))
                        {
                            summary.CurrentFeatureValue_NR = int.Parse(string.Join(string.Empty,
                                                                                   from d in uploadPropertys[NBRAC.CurrentFeature].MemeroyData
                                                                                   select d.ToString("X2")), NumberStyles.HexNumber);
                        }
                        if (uploadPropertys.ContainsKey(NBRAC.PowerFeature))
                        {
                            summary.PowerFeatureValue_NR = Math.Round(int.Parse(string.Join(string.Empty,
                                                                                            from d in uploadPropertys[NBRAC.PowerFeature].MemeroyData
                                                                                            select d.ToString("X2")), NumberStyles.HexNumber) * 0.1, 2);
                        }
                        if (uploadPropertys.ContainsKey(NBRAC.PowerFactor))
                        {
                            summary.PowerFactor_NR = Math.Round(int.Parse(string.Join(string.Empty,
                                                                                      from d in uploadPropertys[NBRAC.PowerFactor].MemeroyData
                                                                                      select d.ToString("X2")), NumberStyles.HexNumber) * 0.1, 2);
                        }
                        if (uploadPropertys.ContainsKey(NBRAC.PowerConsumption))
                        {
                            summary.PowerConsumption_NR = Math.Round(int.Parse(string.Join(string.Empty,
                                                                                           from d in uploadPropertys[NBRAC.PowerConsumption].MemeroyData
                                                                                           select d.ToString("X2")), NumberStyles.HexNumber) * 0.1, 2);
                        }
                        if (uploadPropertys.ContainsKey(NBRAC.WorkingTimeInMinute))
                        {
                            summary.WorkingTimeInMinute_NR = int.Parse(string.Join(string.Empty,
                                                                                   from d in uploadPropertys[NBRAC.WorkingTimeInMinute].MemeroyData
                                                                                   select d.ToString("X2")), NumberStyles.HexNumber);
                        }
                        if (uploadPropertys.ContainsKey(NBRAC.Temperature))
                        {
                            summary.Temperature_NR = Math.Round(int.Parse(string.Join(string.Empty,
                                                                                      from d in uploadPropertys[NBRAC.Temperature].MemeroyData
                                                                                      select d.ToString("X2")), NumberStyles.HexNumber) * 0.1, 2);
                        }
                        if (uploadPropertys.ContainsKey(NBRAC.LuminousIntensity))
                        {
                            summary.LuminousIntensity_NR = int.Parse(string.Join(string.Empty,
                                                                                 from d in uploadPropertys[NBRAC.LuminousIntensity].MemeroyData
                                                                                 select d.ToString("X2")), NumberStyles.HexNumber);
                        }

                        if (uploadPropertys.ContainsKey(NBRAC.GPSInfo))//GPSInfo
                        {
                            var GpsHex = string.Join(string.Empty, from d in uploadPropertys[NBRAC.GPSInfo].MemeroyData
                                                     select d.ToString("X2"));
                            var longitudeHex = GpsHex.Substring(0, 8);
                            var latitudeHex  = GpsHex.Substring(8);

                            longitude = int.Parse(longitudeHex, NumberStyles.HexNumber) / 1000000.0;
                            latitude  = int.Parse(latitudeHex, NumberStyles.HexNumber) / 1000000.0;
                            if (Math.Abs(longitude) > 0.01 && Math.Abs(latitude) > 0.01)//绝对值有效,才存入经纬度信息里
                            {
                                var pointInfo = Led.Tools.MapHelper.Nema2Google(new MapHelper.PointInfo(longitude, latitude));

                                //pointInfo.Lat = Math.Round(pointInfo.Lat, 8);
                                //pointInfo.Lon = Math.Round(pointInfo.Lon, 8);
                                lightInfo.Longitude  = pointInfo.Lon;
                                lightInfo.Longitude2 = pointInfo.Lon;
                                lightInfo.Latitude   = pointInfo.Lat;
                                lightInfo.Latitude2  = pointInfo.Lat;
                                summary.GpsInfo      = pointInfo.Lon + "," + pointInfo.Lat;
                            }
                        }
                        dbContext.Update(lightInfo);
                        summary.VehicleFlow_NR     = 0;
                        summary.VehicleSpeed_NR    = 0;
                        summary.FirmwareVersion_NR = 0;
                        summary.ChannelNumber      = uploadPropertys[NBRAC.DimmingFeature].ChannelNumber;
                        summary.LocalDate          = Now;
                        //summary.TimeZone_CD = new object();
                        //summary.LightningCount = new object();
                        //summary.IsDay = new object();
                        summary.DataSource = 0;
                        summary.Address    = null;
                        //summary.Signal_NR = new object();
                        summary.FirmwareVersion_NR = int.Parse((DeviceInfo.Version?.Replace(".", string.Empty) ?? "0"));
                        summary.RemoteEndPoint     = DeviceInfo.IP;
                        summary.Version            = DeviceInfo.Version;
                        summary.IMEI   = DeviceInfo.IMEI;
                        summary.IMSI   = DeviceInfo.IMSI;
                        summary.ICCID  = DeviceInfo.ICCID;
                        summary.bandNo = int.Parse(DeviceInfo.BAND ?? "0");
                        //summary.GpsInfo = DeviceInfo.GPSInfo;
                        summary.State      = 0;
                        summary.UploadData = DataHelper.BytesToHexStr(originData.OriginData);
                        //summary.CSQ = ;
                        await dbContext.TNL_History_Summarys.AddAsync(summary);

                        //UPLogger.Show($"历史表走完!");

                        //logger.Info("TNL_History_Summarys");
                        #endregion

                        #region 插入当前状态表
                        var lightalm = await dbContext.TNL_TunnelLightAlms.FirstOrDefaultAsync(d => d.TunnelLight_ID == summary.TunnelLight_ID);

                        //lightalm.TunnelLight_ID = summary.TunnelLight_ID;
                        bool Added = lightalm != null ? false : true;
                        if (Added)
                        {
                            lightalm = new TNL_TunnelLightAlm();
                        }
                        lightalm.TunnelLight_ID         = lightInfo.TunnelLight_ID;
                        lightalm.AlmLevel_ID            = summary.AlmLevel_ID;
                        lightalm.DimmingFeatureValue_NR = summary.DimmingFeatureValue_NR;
                        lightalm.CurrentFeatureValue_NR = summary.CurrentFeatureValue_NR;
                        lightalm.VoltageFeatureValue_NR = summary.VoltageFeatureValue_NR;
                        lightalm.PowerFeatureValue_NR   = summary.PowerFeatureValue_NR;
                        lightalm.LuminousIntensity_NR   = summary.LuminousIntensity_NR;
                        lightalm.Temperature_NR         = summary.Temperature_NR;
                        lightalm.PowerConsumption_NR    = summary.PowerConsumption_NR;
                        lightalm.WorkingTimeInMinute_NR = summary.WorkingTimeInMinute_NR;
                        lightalm.VehicleFlow_NR         = summary.VehicleFlow_NR;
                        lightalm.VehicleSpeed_NR        = summary.VehicleSpeed_NR;
                        lightalm.FirmwareVersion_NR     = summary.FirmwareVersion_NR;
                        lightalm.SampTime_DT            = summary.SampTime_DT;
                        lightalm.PowerFactor_NR         = summary.PowerFactor_NR;
                        lightalm.ChannelNumber          = summary.ChannelNumber;
                        lightalm.LocalDate      = summary.LocalDate;
                        lightalm.DataSource     = summary.DataSource;
                        lightalm.RemoteEndPoint = summary.RemoteEndPoint;
                        lightalm.Signal_NR      = summary.Signal_NR;
                        lightalm.Version        = summary.Version;
                        //lightalm.IMEI = summary.IMEI;
                        //lightalm.IMSI = summary.IMSI;
                        //lightalm.ICCID = summary.ICCID;
                        lightalm.bandNo = summary.bandNo;
                        lightalm.State  = summary.State;
                        if (Math.Abs(longitude) > 0.01 && Math.Abs(latitude) > 0.01)//绝对值有效,才存入经纬度信息里
                        {
                            lightalm.GpsInfo = summary.GpsInfo;
                        }
                        //lightalm.TimePlan = summary.time;
                        //lightalm.PhotoCell = summary.poho;
                        lightalm.InspectSuccess_DT = Now;
                        lightalm.IsDay             = summary.IsDay;
                        lightalm.LightningCount    = summary.LightningCount;
                        //lightalm.upUID = summary.upk;
                        lightalm.CSQ = summary.CSQ;
                        if (Added)
                        {
                            dbContext.Add(lightalm);
                        }
                        else
                        {
                            dbContext.Update(lightalm);
                        }
                        //logger.Info("lightalm");
                        #endregion

                        #region 插入告警数据
                        if (uploadPropertys.ContainsKey(NBRAC.AlarmInfo))
                        {
                            TNL_AlarmInfo alarmInfo    = new TNL_AlarmInfo();
                            var           hexAlarmInfo = string.Join(string.Empty,
                                                                     from d in uploadPropertys[NBRAC.AlarmInfo].MemeroyData
                                                                     select d.ToString());
                            alarmInfo.AlarmInfo = int.Parse(hexAlarmInfo, NumberStyles.HexNumber).ToString().PadLeft(8, '0');
                            char[] alarmsstatus = Convert.ToString(int.Parse(hexAlarmInfo), 2)
                                                  .PadLeft(30, '0')
                                                  .Reverse()
                                                  .ToArray();
                            //var alarms = uploadPropertys[NBRAC.AlarmInfo].MemeroyData;
                            //char[] alarmsstatus = alarmInfo.AlarmInfo.Reverse().ToArray();
                            if (alarmsstatus != null && alarmsstatus.Length > 5)
                            {
                                alarmInfo.Alarm0 = int.Parse(alarmsstatus[NBRAC.Alarm0].ToString());
                                alarmInfo.Alarm1 = int.Parse(alarmsstatus[NBRAC.Alarm1].ToString());
                                alarmInfo.Alarm2 = int.Parse(alarmsstatus[NBRAC.Alarm2].ToString());
                                alarmInfo.Alarm3 = int.Parse(alarmsstatus[NBRAC.Alarm3].ToString());
                                alarmInfo.Alarm4 = int.Parse(alarmsstatus[NBRAC.Alarm4].ToString());
                                alarmInfo.Alarm5 = int.Parse(alarmsstatus[NBRAC.Alarm5].ToString());
                                alarmInfo.Alarm6 = int.Parse(alarmsstatus[NBRAC.Alarm6].ToString());
                            }

                            if (alarmInfo.Alarm0 != 0 ||
                                alarmInfo.Alarm1 != 0 ||
                                alarmInfo.Alarm2 != 0 ||
                                alarmInfo.Alarm3 != 0 ||
                                alarmInfo.Alarm4 != 0 ||
                                alarmInfo.Alarm5 != 0 ||
                                alarmInfo.Alarm6 != 0)
                            {
                                alarmInfo.DeviceAddress          = DeviceAddress;
                                alarmInfo.TunnelLight_ID         = lightInfo.TunnelLight_ID;
                                alarmInfo.DimmingFeatureValue_NR = summary.DimmingFeatureValue_NR;
                                alarmInfo.VoltageFeatureValue_NR = summary.VoltageFeatureValue_NR;
                                alarmInfo.CurrentFeatureValue_NR = summary.CurrentFeatureValue_NR;
                                alarmInfo.PowerFeatureValue_NR   = summary.PowerFeatureValue_NR;
                                alarmInfo.PowerFactor            = summary.PowerFactor_NR;
                                alarmInfo.PowerConsumption_NR    = summary.PowerConsumption_NR;
                                alarmInfo.WorkingTimeInMinute_NR = summary.WorkingTimeInMinute_NR;
                                alarmInfo.Temperature_NR         = summary.Temperature_NR;
                                alarmInfo.WorkingTimeInMinute_NR = summary.WorkingTimeInMinute_NR;
                                alarmInfo.LuminousIntensity_NR   = summary.LuminousIntensity_NR;
                                alarmInfo.LocalDate = Now;
                                alarmInfo.SampTime  = Now;
                                await dbContext.TNL_AlarmInfos.AddAsync(alarmInfo);
                            }
                            //UPLogger.Show($"告警走完!");
                            //logger.Info("alarmInfo");
                        }
                        #endregion
                    }
                    await dbContext.SaveChangesAsync();

                    await trans.CommitAsync();
                }
                catch
                {
                    await trans.RollbackAsync();

                    throw;
                }
            }
            catch (Exception ex)
            {
                //logger.Info(ex.Message);
                logger.Error(this.GetType().FullName + " " + ex.ToString());
                throw;
            }
        }