示例#1
0
        /// <summary>
        /// Add data to cache.
        /// </summary>
        private List <Report115Entity> AddDataToCache()
        {
            var userData  = UserData;
            var cacheKey1 = WebUtility.GetCacheKeyName(userData, "kpi-report-115");
            var cacheKey2 = WebUtility.GetCacheKeyName(userData, "kpi-report-115-02");

            HttpRuntime.Cache.Remove(cacheKey1);
            HttpRuntime.Cache.Remove(cacheKey2);

            var lscs = new List <LscUserInfo>();

            if (LscsComboBox.SelectedIndex > 0)
            {
                var ids = WebUtility.ItemSplit(LscsComboBox.SelectedItem.Value);
                if (ids.Length == 2)
                {
                    var lscId   = Int32.Parse(ids[0]);
                    var groupId = Int32.Parse(ids[1]);
                    var lscUser = userData.LscUsers.Find(lu => { return(lu.LscID == lscId); });
                    if (lscUser != null)
                    {
                        lscs.Add(lscUser);
                    }
                }
            }
            else
            {
                lscs.AddRange(userData.LscUsers);
            }
            if (lscs.Count == 0)
            {
                return(null);
            }

            var staTypes = new Dictionary <Int32, String>();

            foreach (var dt in StaTypeMultiCombo.SelectedItems)
            {
                staTypes[Int32.Parse(dt.Value)] = dt.Text;
            }
            if (staTypes.Count == 0)
            {
                return(null);
            }

            var fromTime = DateTime.Parse(BeginFromDate.Text);
            var toTime   = DateTime.Parse(BeginToDate.Text);

            var auxSets    = new List <String>();
            var texts      = new List <String>();
            var filterText = WebUtility.StringSplit(NodeText.Text.Trim());

            foreach (var ft in filterText)
            {
                if (String.IsNullOrEmpty(ft.Trim()))
                {
                    continue;
                }
                if (FilterList.SelectedItem.Value.Equals("1"))
                {
                    auxSets.Add(ft.Trim());
                }
                else
                {
                    texts.Add(ft.Trim());
                }
            }
            if (texts.Count == 0 && auxSets.Count == 0)
            {
                return(null);
            }

            var almNames = new List <String>();
            var almIds   = new Dictionary <String, String>();
            var almText  = WebUtility.StringSplit(AlarmNameText.Text.Trim());

            foreach (var at in almText)
            {
                if (String.IsNullOrEmpty(at.Trim()))
                {
                    continue;
                }
                if (AlmNameList.SelectedItem.Value.Equals("1"))
                {
                    almIds[at.Trim()] = null;
                }
                else
                {
                    almNames.Add(at.Trim());
                }
            }

            var nodeEntity   = new BNode();
            var otherEntity  = new BOther();
            var alarmEntity  = new BAlarm();
            var source1      = new List <Report115Entity>();
            var source2      = new Dictionary <String, List <StationInfo> >();
            var activeAlarms = WebUtility.GetUserAlarms(userData).FindAll(alarm => lscs.Any(l => l.LscID == alarm.LscID) && alarm.StartTime >= fromTime && alarm.StartTime <= toTime);

            foreach (var lsc in lscs)
            {
                var alarms = activeAlarms.FindAll(a => a.LscID == lsc.LscID);
                alarms.AddRange(alarmEntity.GetHisAlarms(lsc.LscID, lsc.LscName, userData.StandardProtocol, lsc.Group.GroupNodes, fromTime, toTime));
                if (almNames.Count > 0)
                {
                    alarms = alarms.FindAll(a => almNames.Any(n => a.AlarmName.Contains(n)));
                }
                if (almIds.Count > 0)
                {
                    alarms = alarms.FindAll(a => almIds.ContainsKey(a.AlarmID.ToString()));
                }

                var stations = otherEntity.GetStations(lsc.LscID).FindAll(s => staTypes.ContainsKey(s.StaTypeID));
                var nodes    = nodeEntity.GetNodes(lsc.LscID, EnmNodeType.Aic, texts.ToArray(), auxSets.ToArray(), null);
                var gn       = from n in nodes
                               group n by n.StaID into g
                               select new {
                    StaID = g.Key,
                    Nodes = g.ToList()
                };

                var ns = from s in stations
                         join n in gn on s.StaID equals n.StaID
                         select new {
                    Station = s,
                    Nodes   = n.Nodes
                };

                var ndWam = from alarm in alarms
                            join node in nodes on new { alarm.NodeID, alarm.NodeType } equals new { node.NodeID, node.NodeType }
                select new {
                    Node  = node,
                    Alarm = alarm
                };

                var gndWam = from na in ndWam
                             group na by na.Node.StaID into g
                             select new {
                    StaID  = g.Key,
                    Alarms = g.Select(a => a.Alarm)
                };

                var sndWam = from s in ns
                             join gw in gndWam on s.Station.StaID equals gw.StaID
                             select new {
                    Station = s.Station,
                    Nodes   = s.Nodes,
                    Alarms  = gw.Alarms
                };

                source1.Add(new Report115Entity {
                    LscID     = lsc.LscID,
                    LscName   = lsc.LscName,
                    ThisCount = sndWam.Count(),
                    LastCount = ns.Count()
                });

                source2[String.Format("{0}-ThisCount", lsc.LscID)] = sndWam.Select(s => s.Station).ToList();
                source2[String.Format("{0}-LastCount", lsc.LscID)] = ns.Select(s => s.Station).ToList();
            }

            if (source1.Count > 0)
            {
                source1.Add(new Report115Entity {
                    LscID     = -100,
                    LscName   = "汇总",
                    ThisCount = (Int32)source1.Sum(r => r.ThisCount),
                    LastCount = (Int32)source1.Sum(r => r.LastCount)
                });
            }

            int cacheDuration = Int32.Parse(WebConfigurationManager.AppSettings["DefaultCacheDuration"]);

            HttpRuntime.Cache.Insert(cacheKey1, source1, null, Cache.NoAbsoluteExpiration, TimeSpan.FromSeconds(cacheDuration), CacheItemPriority.Default, null);
            HttpRuntime.Cache.Insert(cacheKey2, source2, null, Cache.NoAbsoluteExpiration, TimeSpan.FromSeconds(cacheDuration), CacheItemPriority.Default, null);
            return(source1);
        }
示例#2
0
        /// <summary>
        /// Add data to cache.
        /// </summary>
        private List <Report004Entity> AddDataToCache()
        {
            var userData = UserData;
            var cacheKey = WebUtility.GetCacheKeyName(userData, "kpi-report-004");

            HttpRuntime.Cache.Remove(cacheKey);

            var lscs = new List <LscUserInfo>();

            if (LscsComboBox.SelectedIndex > 0)
            {
                var ids = WebUtility.ItemSplit(LscsComboBox.SelectedItem.Value);
                if (ids.Length == 2)
                {
                    var lscId   = Int32.Parse(ids[0]);
                    var groupId = Int32.Parse(ids[1]);
                    var lscUser = userData.LscUsers.Find(lu => { return(lu.LscID == lscId); });
                    if (lscUser != null)
                    {
                        lscs.Add(lscUser);
                    }
                }
            }
            else
            {
                lscs.AddRange(userData.LscUsers);
            }
            if (lscs.Count == 0)
            {
                return(null);
            }

            var fromTime = DateTime.Parse(BeginFromDate.Text);
            var toTime   = DateTime.Parse(BeginToDate.Text);
            var roads    = Convert.ToInt32(EPRoadSpinnerField.Number);

            var auxSets    = new List <String>();
            var texts      = new List <String>();
            var filterText = WebUtility.StringSplit(NodeText.Text.Trim());

            foreach (var ft in filterText)
            {
                if (String.IsNullOrEmpty(ft.Trim()))
                {
                    continue;
                }
                if (FilterList.SelectedItem.Value.Equals("1"))
                {
                    auxSets.Add(ft.Trim());
                }
                else
                {
                    texts.Add(ft.Trim());
                }
            }
            if (texts.Count == 0 && auxSets.Count == 0)
            {
                return(null);
            }

            var almNames = new List <String>();
            var almIds   = new Dictionary <String, String>();
            var almText  = WebUtility.StringSplit(AlarmNameText.Text.Trim());

            foreach (var at in almText)
            {
                if (String.IsNullOrEmpty(at.Trim()))
                {
                    continue;
                }
                if (AlmNameList.SelectedItem.Value.Equals("1"))
                {
                    almIds[at.Trim()] = null;
                }
                else
                {
                    almNames.Add(at.Trim());
                }
            }

            var nodeEntity  = new BNode();
            var nodes       = new List <NodeInfo>();
            var otherEntity = new BOther();
            var stations    = new List <StationInfo>();

            foreach (var lsc in lscs)
            {
                nodes.AddRange(nodeEntity.GetNodes(lsc.LscID, EnmNodeType.Img, texts.ToArray(), auxSets.ToArray(), null));
                stations.AddRange(otherEntity.GetStations(lsc.LscID, lsc.Group.GroupID));
            }

            var alarmEntity = new BAlarm();
            var alarms      = WebUtility.GetUserAlarms(userData).FindAll(alarm => lscs.Any(l => l.LscID == alarm.LscID) && alarm.StartTime >= fromTime && alarm.StartTime <= toTime);

            foreach (var lsc in lscs)
            {
                alarms.AddRange(alarmEntity.GetHisAlarms(lsc.LscID, lsc.LscName, userData.StandardProtocol, lsc.Group.GroupNodes, fromTime, toTime));
            }

            var ndWam = from alarm in alarms
                        join node in nodes on new { alarm.LscID, alarm.NodeID, alarm.NodeType } equals new { node.LscID, node.NodeID, node.NodeType }
            where (almNames.Count == 0 || almNames.Any(name => alarm.AlarmName.Contains(name))) && (almIds.Count == 0 || almIds.ContainsKey(alarm.AlarmID.ToString())) && string.IsNullOrEmpty(alarm.ProjName)
            select new {
                Node  = node,
                Alarm = alarm
            };

            var almGroup = from alarm in ndWam
                           group alarm by new { alarm.Node.LscID, alarm.Node.StaID } into g
                select new {
                LscID  = g.Key.LscID,
                StaID  = g.Key.StaID,
                Alarms = g.Select(a => a.Alarm)
            };

            var result = (from sta in stations
                          join ag in almGroup on new { sta.LscID, sta.StaID } equals new { ag.LscID, ag.StaID } into lt
                          from la in lt.DefaultIfEmpty()
                          orderby sta.LscID, sta.StaID
                          select new Report004Entity {
                LscID = sta.LscID,
                LscName = sta.LscName,
                Area2ID = sta.Area2ID,
                Area2Name = sta.Area2Name,
                Area3ID = sta.Area3ID,
                Area3Name = sta.Area3Name,
                StaID = sta.StaID,
                StaName = sta.StaName,
                BeginTime = fromTime,
                EndTime = toTime,
                Roads = roads,
                Alarms = la == null ? new List <AlarmInfo>() : la.Alarms.ToList()
            }).ToList();

            if (result.Count > 0)
            {
                result.Add(new Report004Entity {
                    LscID     = -100,
                    LscName   = "汇总(平均值)",
                    Area2ID   = WebUtility.DefaultInt32,
                    Area2Name = WebUtility.DefaultString,
                    Area3ID   = WebUtility.DefaultInt32,
                    Area3Name = WebUtility.DefaultString,
                    StaID     = WebUtility.DefaultInt32,
                    StaName   = WebUtility.DefaultString,
                    BeginTime = fromTime,
                    EndTime   = toTime,
                    Roads     = roads,
                    Alarms    = new List <AlarmInfo>()
                });
            }

            int cacheDuration = Int32.Parse(WebConfigurationManager.AppSettings["DefaultCacheDuration"]);

            HttpRuntime.Cache.Insert(cacheKey, result, null, Cache.NoAbsoluteExpiration, TimeSpan.FromSeconds(cacheDuration), CacheItemPriority.Default, null);
            return(result);
        }
示例#3
0
        /// <summary>
        /// Add data to cache.
        /// </summary>
        private List <Report122Entity> AddDataToCache()
        {
            var userData = UserData;
            var cacheKey = WebUtility.GetCacheKeyName(userData, "kpi-report-122");

            HttpRuntime.Cache.Remove(cacheKey);

            var lscUsers = new List <LscUserInfo>();

            if (LscsComboBox.SelectedIndex > 0)
            {
                var ids = WebUtility.ItemSplit(LscsComboBox.SelectedItem.Value);
                if (ids.Length == 2)
                {
                    var lscId   = Int32.Parse(ids[0]);
                    var groupId = Int32.Parse(ids[1]);
                    var lscUser = userData.LscUsers.Find(lu => { return(lu.LscID == lscId); });
                    if (lscUser != null)
                    {
                        lscUsers.Add(lscUser);
                    }
                }
            }
            else
            {
                lscUsers.AddRange(userData.LscUsers);
            }

            if (lscUsers.Count == 0)
            {
                return(null);
            }

            var fromTime = DateTime.Parse(BeginFromDate.Text);
            var toTime   = DateTime.Parse(BeginToDate.Text);
            var dates    = new List <string>();
            var temp     = fromTime;

            while (temp <= toTime)
            {
                dates.Add(WebUtility.GetDateString2(temp));
                temp = temp.AddDays(1);
            }

            var staTypes = new HashSet <int>();

            foreach (var dt in StaTypeMultiCombo.SelectedItems)
            {
                staTypes.Add(int.Parse(dt.Value));
            }
            if (staTypes.Count == 0)
            {
                return(null);
            }

            var alarmId = int.Parse(AlarmNameComboBox.SelectedItem.Value);

            var otherEntity = new BOther();
            var alarmEntity = new BAlarm();
            var source      = new List <Report122Entity>();

            foreach (var lu in lscUsers)
            {
                var stations = otherEntity.GetStations(lu.LscID, lu.Group.GroupID).FindAll(s => staTypes.Contains(s.StaTypeID));
                var alarms   = alarmEntity.GetHisAlarms(lu.LscID, lu.LscName, userData.StandardProtocol, lu.Group.GroupNodes, fromTime, toTime).FindAll(a => a.AlarmID == alarmId);
                var perdays  = alarms.GroupBy(a => WebUtility.GetDateString2(a.StartTime)).Select(g => new { Date = g.Key, StationKeys = new HashSet <string>(g.Select(a => a.StaName)) });

                foreach (var date in dates)
                {
                    var day = perdays.FirstOrDefault(p => p.Date.Equals(date));
                    source.Add(new Report122Entity {
                        LscID     = lu.LscID,
                        LscName   = lu.LscName,
                        Date      = date,
                        Gstations = day == null ? new List <StationInfo>() : stations.FindAll(s => day.StationKeys.Contains(s.StaName)),
                        Stations  = stations
                    });
                }
            }

            int cacheDuration = Int32.Parse(WebConfigurationManager.AppSettings["DefaultCacheDuration"]);

            HttpRuntime.Cache.Insert(cacheKey, source, null, Cache.NoAbsoluteExpiration, TimeSpan.FromSeconds(cacheDuration), CacheItemPriority.Default, null);
            return(source);
        }
示例#4
0
        /// <summary>
        /// Add data to cache.
        /// </summary>
        private List <Report104Entity> AddDataToCache()
        {
            var userData = UserData;
            var cacheKey = WebUtility.GetCacheKeyName(userData, "kpi-report-104");

            HttpRuntime.Cache.Remove(cacheKey);

            var lscs = new List <LscUserInfo>();

            if (LscsComboBox.SelectedIndex > 0)
            {
                var ids = WebUtility.ItemSplit(LscsComboBox.SelectedItem.Value);
                if (ids.Length != 2)
                {
                    return(null);
                }
                var lscId   = Int32.Parse(ids[0]);
                var groupId = Int32.Parse(ids[1]);
                var lscUser = userData.LscUsers.Find(lu => { return(lu.LscID == lscId); });
                if (lscUser == null)
                {
                    return(null);
                }
                lscs.Add(lscUser);
            }
            else
            {
                lscs.AddRange(userData.LscUsers);
            }

            var fromTime = DateTime.Parse(BeginFromDate.Text);
            var toTime   = DateTime.Parse(BeginToDate.Text);

            var texts      = new List <String>();
            var auxSets    = new List <String>();
            var filterText = WebUtility.StringSplit(NodeText.Text.Trim());

            foreach (var ft in filterText)
            {
                if (String.IsNullOrEmpty(ft.Trim()))
                {
                    continue;
                }
                if (FilterTypeList.SelectedItem.Value.Equals("1"))
                {
                    auxSets.Add(ft.Trim());
                }
                else
                {
                    texts.Add(ft.Trim());
                }
            }

            var devTypes = new Dictionary <Int32, String>();

            foreach (var dt in DevTypeMultiCombo.SelectedItems)
            {
                devTypes[Int32.Parse(dt.Value)] = dt.Text;
            }
            if (devTypes.Count == 0)
            {
                return(null);
            }

            var almNames = new List <String>();
            var almIds   = new Dictionary <String, String>();
            var almText  = WebUtility.StringSplit(AlarmNameText.Text.Trim());

            foreach (var at in almText)
            {
                if (String.IsNullOrEmpty(at.Trim()))
                {
                    continue;
                }
                if (AlmNameList.SelectedItem.Value.Equals("1"))
                {
                    almIds[at.Trim()] = null;
                }
                else
                {
                    almNames.Add(at.Trim());
                }
            }

            var otherEntity = new BOther();
            var nodeEntity  = new BNode();
            var stations    = new List <StationInfo>();
            var devices     = new List <DeviceInfo>();
            var nodes       = new List <NodeInfo>();

            foreach (var lsc in lscs)
            {
                stations.AddRange(otherEntity.GetStations(lsc.LscID, lsc.Group.GroupID).FindAll(s => s.BuildingID != WebUtility.DefaultInt32));
                devices.AddRange(otherEntity.GetDevices(lsc.LscID, lsc.Group.GroupID));
                nodes.AddRange(nodeEntity.GetNodes(lsc.LscID, EnmNodeType.Aic, texts.ToArray(), auxSets.ToArray(), devTypes.Keys.ToArray()));
            }

            if (Area2ComboBox.SelectedIndex > 0)
            {
                var area2Id = Int32.Parse(Area2ComboBox.SelectedItem.Value);
                stations = stations.FindAll(s => s.Area2ID == area2Id);
            }
            if (Area3ComboBox.SelectedIndex > 0)
            {
                var area3Id = Int32.Parse(Area3ComboBox.SelectedItem.Value);
                stations = stations.FindAll(s => s.Area3ID == area3Id);
            }
            if (stations.Count == 0)
            {
                return(null);
            }

            devices = devices.FindAll(d => devTypes.ContainsKey(d.DevTypeID));
            var devGroup = from dev in devices
                           group dev by new { dev.LscID, dev.StaID } into g
                select new {
                LscID   = g.Key.LscID,
                StaID   = g.Key.StaID,
                Devices = g.ToList()
            };

            var staWdv = from sta in stations
                         join dg in devGroup on new { sta.LscID, sta.StaID } equals new { dg.LscID, dg.StaID } into lt
            from ds in lt.DefaultIfEmpty()
            select new {
                Station = sta,
                Devices = ds == null ? new List <DeviceInfo>() : ds.Devices
            };

            var alarmEntity = new BAlarm();
            var alarms      = WebUtility.GetUserAlarms(userData).FindAll(alarm => lscs.Any(l => l.LscID == alarm.LscID) && alarm.StartTime >= fromTime && alarm.StartTime <= toTime);

            foreach (var lsc in lscs)
            {
                alarms.AddRange(alarmEntity.GetHisAlarms(lsc.LscID, lsc.LscName, userData.StandardProtocol, lsc.Group.GroupNodes, fromTime, toTime));
            }

            var ndWam = from alarm in alarms
                        join node in nodes on new { alarm.LscID, alarm.NodeID, alarm.NodeType } equals new { node.LscID, node.NodeID, node.NodeType }
            where (almNames.Count == 0 || almNames.Any(name => alarm.AlarmName.Contains(name))) && (almIds.Count == 0 || almIds.ContainsKey(alarm.AlarmID.ToString()))
            select new {
                Node  = node,
                Alarm = alarm
            };

            var almGroup = from alarm in ndWam
                           group alarm by new { alarm.Node.LscID, alarm.Node.StaID } into g
                select new {
                LscID  = g.Key.LscID,
                StaID  = g.Key.StaID,
                Alarms = g.Select(a => a.Alarm)
            };

            var staWam = from sd in staWdv
                         join ga in almGroup on new { sd.Station.LscID, sd.Station.StaID } equals new { ga.LscID, ga.StaID } into lt
            from gs in lt.DefaultIfEmpty()
            select new {
                Station = sd.Station,
                Devices = sd.Devices,
                Alarms  = gs == null ? new List <AlarmInfo>() : gs.Alarms
            };

            var result = (from sa in staWam
                          group sa by new { sa.Station.LscID, sa.Station.Area3ID, sa.Station.BuildingID } into g
                          orderby g.Key.LscID, g.Key.Area3ID, g.Key.BuildingID
                          select new Report104Entity {
                Station = g.First().Station,
                BeginTime = fromTime,
                EndTime = toTime,
                Devices = g.SelectMany(s => s.Devices).ToList(),
                Alarms = g.SelectMany(a => a.Alarms).ToList()
            }).ToList();

            int cacheDuration = Int32.Parse(WebConfigurationManager.AppSettings["DefaultCacheDuration"]);

            HttpRuntime.Cache.Insert(cacheKey, result, null, Cache.NoAbsoluteExpiration, TimeSpan.FromSeconds(cacheDuration), CacheItemPriority.Default, null);
            return(result);
        }
示例#5
0
        /// <summary>
        /// Add data to cache.
        /// </summary>
        private List <Report120Entity> AddDataToCache()
        {
            var userData = UserData;
            var cacheKey = WebUtility.GetCacheKeyName(userData, "kpi-report-120");

            HttpRuntime.Cache.Remove(cacheKey);

            var lscUsers = new List <LscUserInfo>();

            if (LscsComboBox.SelectedIndex > 0)
            {
                var ids = WebUtility.ItemSplit(LscsComboBox.SelectedItem.Value);
                if (ids.Length == 2)
                {
                    var lscId   = Int32.Parse(ids[0]);
                    var groupId = Int32.Parse(ids[1]);
                    var lscUser = userData.LscUsers.Find(lu => { return(lu.LscID == lscId); });
                    if (lscUser != null)
                    {
                        lscUsers.Add(lscUser);
                    }
                }
            }
            else
            {
                lscUsers.AddRange(userData.LscUsers);
            }

            if (lscUsers.Count == 0)
            {
                return(null);
            }

            var fromTime = DateTime.Parse(BeginFromDate.Text);
            var toTime   = DateTime.Parse(BeginToDate.Text);

            var staTypes = new HashSet <int>();

            foreach (var dt in StaTypeMultiCombo.SelectedItems)
            {
                staTypes.Add(int.Parse(dt.Value));
            }
            if (staTypes.Count == 0)
            {
                return(null);
            }

            var devTypes = new HashSet <int>();

            foreach (var dt in DevTypeMultiCombo.SelectedItems)
            {
                devTypes.Add(int.Parse(dt.Value));
            }
            if (devTypes.Count == 0)
            {
                return(null);
            }

            var alarmId = int.Parse(AlarmNameComboBox.SelectedItem.Value);

            var otherEntity = new BOther();
            var alarmEntity = new BAlarm();
            var source      = new List <Report120Entity>();

            foreach (var lu in lscUsers)
            {
                var devices       = otherEntity.GetDevices(lu.LscID, lu.Group.GroupID).FindAll(d => staTypes.Contains(d.StaTypeID) && devTypes.Contains(d.DevTypeID));
                var devkeys       = new HashSet <string>(devices.Select(d => string.Format("{0}┊{1}", d.StaName, d.DevName)));
                var alarms        = alarmEntity.GetHisAlarms(lu.LscID, lu.LscName, userData.StandardProtocol, lu.Group.GroupNodes, fromTime, toTime).FindAll(a => a.AlarmID == alarmId && devkeys.Contains(string.Format("{0}┊{1}", a.StaName, a.DevName)));
                var perNodeAlarms = alarms.GroupBy(a => new { a.StaName, a.DevName, a.NodeName }).Select(g => {
                    var first = g.First();
                    return(new Report120Node {
                        LscID = first.LscID,
                        LscName = first.LscName,
                        Area1Name = first.Area1Name,
                        Area2Name = first.Area2Name,
                        Area3Name = first.Area3Name,
                        Area4Name = first.Area4Name,
                        StaName = g.Key.StaName,
                        DevName = g.Key.DevName,
                        NodeName = g.Key.NodeName,
                        First = g.Min(c => c.StartTime),
                        Last = g.Max(c => c.StartTime)
                    });
                });

                source.Add(new Report120Entity {
                    LscID   = lu.LscID,
                    LscName = lu.LscName,
                    Nodes   = perNodeAlarms.ToList(),
                    Devices = devices
                });
            }

            int cacheDuration = Int32.Parse(WebConfigurationManager.AppSettings["DefaultCacheDuration"]);

            HttpRuntime.Cache.Insert(cacheKey, source, null, Cache.NoAbsoluteExpiration, TimeSpan.FromSeconds(cacheDuration), CacheItemPriority.Default, null);
            return(source);
        }
示例#6
0
        /// <summary>
        /// Add Data To Cache
        /// </summary>
        private DataTable AddDataToCache()
        {
            var userData  = UserData;
            var cacheKey1 = WebUtility.GetCacheKeyName(userData, "his-alarm-category-source1");
            var cacheKey2 = WebUtility.GetCacheKeyName(userData, "his-alarm-category-source2");

            HttpRuntime.Cache.Remove(cacheKey1);
            HttpRuntime.Cache.Remove(cacheKey2);

            var source1 = new DataTable();
            var source2 = new DataTable();

            var startFromTime = DateTime.Parse(BeginFromDate.Text);
            var startToTime   = DateTime.Parse(BeginToDate.Text);
            var alarmEntity   = new BAlarm();

            if (LscsComboBox.SelectedIndex == 0)
            {
                source1 = CreateCustomizeTable1(11);
                source2 = CreateCustomizeTable2(11);
                foreach (var lscUser in userData.LscUsers)
                {
                    var dr1 = source1.NewRow();
                    var dr2 = source2.NewRow();

                    dr1[1] = WebUtility.GetNodeTypeName(EnmNodeType.LSC);
                    dr2[1] = (Int32)EnmNodeType.LSC;
                    dr1[2] = lscUser.LscName;
                    dr2[2] = lscUser.LscID;

                    var filters = alarmEntity.GetHisAlarms(lscUser.LscID, lscUser.LscName, userData.StandardProtocol, lscUser.Group.GroupNodes, startFromTime, startToTime);

                    dr1[3] = filters.Count;
                    dr2[3] = filters;
                    var cntAlarms = filters.FindAll(agi => { return(agi.AlarmLevel == EnmAlarmLevel.Critical); });
                    dr1[4]    = cntAlarms.Count;
                    dr2[4]    = cntAlarms;
                    cntAlarms = filters.FindAll(agi => { return(agi.AlarmLevel == EnmAlarmLevel.Major); });
                    dr1[5]    = cntAlarms.Count;
                    dr2[5]    = cntAlarms;
                    cntAlarms = filters.FindAll(agi => { return(agi.AlarmLevel == EnmAlarmLevel.Minor); });
                    dr1[6]    = cntAlarms.Count;
                    dr2[6]    = cntAlarms;
                    cntAlarms = filters.FindAll(agi => { return(agi.AlarmLevel == EnmAlarmLevel.Hint); });
                    dr1[7]    = cntAlarms.Count;
                    dr2[7]    = cntAlarms;
                    cntAlarms = filters.FindAll(agi => { return(agi.AlarmID != 0); });
                    dr1[8]    = cntAlarms.Count;
                    dr2[8]    = cntAlarms;
                    cntAlarms = filters.FindAll(agi => { return(agi.AlarmID == 0); });
                    dr1[9]    = cntAlarms.Count;
                    dr2[9]    = cntAlarms;
                    var bz  = Convert.ToDouble(dr1[8]);
                    var fbz = Convert.ToDouble(dr1[9]);
                    var tbz = bz + fbz;
                    dr1[10] = String.Format("{0:P2}", tbz == 0 ? 1 : bz / tbz);
                    dr2[10] = null;

                    source1.Rows.Add(dr1);
                    source2.Rows.Add(dr2);
                }

                var total1 = source1.NewRow();
                var total2 = source2.NewRow();
                total1[1] = "CSC"; total2[1] = -1;
                total1[2] = "总计"; total2[2] = -1;
                for (int i = 3; i < 10; i++)
                {
                    var cnt = 0;
                    for (int j = 0; j < source1.Rows.Count; j++)
                    {
                        cnt += Convert.ToInt32(source1.Rows[j][i]);
                    }
                    total1[i] = cnt;
                    total2[i] = null;
                }

                var totalbz  = Convert.ToDouble(total1[8]);
                var totalfbz = Convert.ToDouble(total1[9]);
                var totaltbz = totalbz + totalfbz;

                total1[10] = String.Format("{0:P2}", totaltbz == 0 ? 1 : totalbz / totaltbz);
                total2[10] = null;

                source1.Rows.Add(total1);
                source2.Rows.Add(total2);
            }
            else
            {
                var ids = WebUtility.ItemSplit(LscsComboBox.SelectedItem.Value);
                if (ids.Length == 2)
                {
                    var lscId   = Int32.Parse(ids[0]);
                    var groupId = Int32.Parse(ids[1]);
                    var lscUser = userData.LscUsers.Find(lu => { return(lu.LscID == lscId); });
                    if (lscUser != null)
                    {
                        var nodeId   = 0;
                        var nodeName = lscUser.LscName;
                        var alarms   = alarmEntity.GetHisAlarms(lscUser.LscID, lscUser.LscName, userData.StandardProtocol, lscUser.Group.GroupNodes, startFromTime, startToTime);

                        var columns = lscUser.AlarmStaticFiterItem;
                        source1 = CreateCustomizeTable1(columns.Count + 8);
                        source2 = CreateCustomizeTable2(columns.Count + 8);
                        if (Area3ComboBox.SelectedIndex > 0)
                        {
                            nodeId   = Int32.Parse(Area3ComboBox.SelectedItem.Value);
                            nodeName = Area3ComboBox.SelectedItem.Text;
                            alarms   = alarms.FindAll(alarm => { return(alarm.Area3Name.Equals(nodeName)); });
                        }
                        else if (Area2ComboBox.SelectedIndex > 0)
                        {
                            nodeId   = Int32.Parse(Area2ComboBox.SelectedItem.Value);
                            nodeName = Area2ComboBox.SelectedItem.Text;
                            alarms   = alarms.FindAll(alarm => { return(alarm.Area2Name.Equals(nodeName)); });
                        }

                        var childNodes = lscUser.Group.GroupNodes.FindAll(gti => { return(gti.LastNodeID == nodeId); });
                        for (int i = 0; i < childNodes.Count; i++)
                        {
                            if (childNodes[i].NodeType == EnmNodeType.Area)
                            {
                                #region area
                                var dr1 = source1.NewRow();
                                var dr2 = source2.NewRow();

                                dr1[1] = WebUtility.GetNodeTypeName(childNodes[i].NodeType);
                                dr2[1] = (int)childNodes[i].NodeType;
                                dr1[2] = childNodes[i].NodeName;
                                dr2[2] = childNodes[i].LscID;
                                var filters = alarms.FindAll(agi => {
                                    return((childNodes[i].Remark.Equals("1") && agi.Area1Name.Equals(childNodes[i].NodeName)) ||
                                           (childNodes[i].Remark.Equals("2") && agi.Area2Name.Equals(childNodes[i].NodeName)) ||
                                           (childNodes[i].Remark.Equals("3") && agi.Area3Name.Equals(childNodes[i].NodeName)));
                                });
                                dr1[3] = filters.Count;
                                dr2[3] = filters;
                                var cntAlarms = filters.FindAll(agi => { return(agi.AlarmLevel == EnmAlarmLevel.Critical); });
                                dr1[4]    = cntAlarms.Count;
                                dr2[4]    = cntAlarms;
                                cntAlarms = filters.FindAll(agi => { return(agi.AlarmLevel == EnmAlarmLevel.Major); });
                                dr1[5]    = cntAlarms.Count;
                                dr2[5]    = cntAlarms;
                                cntAlarms = filters.FindAll(agi => { return(agi.AlarmLevel == EnmAlarmLevel.Minor); });
                                dr1[6]    = cntAlarms.Count;
                                dr2[6]    = cntAlarms;
                                cntAlarms = filters.FindAll(agi => { return(agi.AlarmLevel == EnmAlarmLevel.Hint); });
                                dr1[7]    = cntAlarms.Count;
                                dr2[7]    = cntAlarms;

                                for (int j = 0; j < columns.Count; j++)
                                {
                                    string[] items = null;
                                    switch (columns[j].FilterType)
                                    {
                                    case EnmAlarmFiterType.AlarmDeviceID:
                                        items      = WebUtility.StringSplit(columns[j].FilterItem);
                                        cntAlarms  = filters.FindAll(agi => { return(items.Contains(agi.AlarmDeviceTypeID.ToString())); });
                                        dr1[8 + j] = cntAlarms.Count;
                                        dr2[8 + j] = cntAlarms;
                                        break;

                                    case EnmAlarmFiterType.AlarmLogID:
                                        items      = WebUtility.StringSplit(columns[j].FilterItem);
                                        cntAlarms  = filters.FindAll(agi => { return(items.Contains(agi.AlarmLogTypeID.ToString())); });
                                        dr1[8 + j] = cntAlarms.Count;
                                        dr2[8 + j] = cntAlarms;
                                        break;

                                    case EnmAlarmFiterType.AlarmID:
                                        items      = WebUtility.StringSplit(columns[j].FilterItem);
                                        cntAlarms  = filters.FindAll(agi => { return(items.Contains(agi.AlarmID.ToString())); });
                                        dr1[8 + j] = cntAlarms.Count;
                                        dr2[8 + j] = cntAlarms;
                                        break;

                                    case EnmAlarmFiterType.AlarmDesc:
                                        cntAlarms  = filters.FindAll(agi => { return(agi.AlarmDesc.Contains(columns[j].FilterItem)); });
                                        dr1[8 + j] = cntAlarms.Count;
                                        dr2[8 + j] = cntAlarms;
                                        break;

                                    case EnmAlarmFiterType.NodeName:
                                        var nodeNames = WebUtility.StringSplit(columns[j].FilterItem);
                                        cntAlarms = filters.FindAll(agi => {
                                            foreach (var name in nodeNames)
                                            {
                                                if (agi.NodeName.Contains(name))
                                                {
                                                    return(true);
                                                }
                                            }
                                            return(false);
                                        });
                                        dr1[8 + j] = cntAlarms.Count;
                                        dr2[8 + j] = cntAlarms;
                                        break;

                                    case EnmAlarmFiterType.TimeShare:
                                        items = WebUtility.StringSplit(columns[j].FilterItem);
                                        if (items.Length != 2)
                                        {
                                            dr1[8 + j] = 0;
                                        }
                                        else
                                        {
                                            var minInterval = WebUtility.GetSecondFromDateTime(items[0]);
                                            var maxInterval = WebUtility.GetSecondFromDateTime(items[1]);
                                            cntAlarms = filters.FindAll(agi => {
                                                var dateInterval = DateTime.Now.Subtract(agi.StartTime).TotalSeconds;
                                                return(dateInterval >= minInterval && dateInterval <= maxInterval);
                                            });
                                            dr1[8 + j] = cntAlarms.Count;
                                            dr2[8 + j] = cntAlarms;
                                        }
                                        break;

                                    case EnmAlarmFiterType.DevName:
                                        var devNames = WebUtility.StringSplit(columns[j].FilterItem);
                                        cntAlarms = filters.FindAll(agi => {
                                            foreach (var name in devNames)
                                            {
                                                if (agi.DevName.Contains(name))
                                                {
                                                    return(true);
                                                }
                                            }
                                            return(false);
                                        });
                                        dr1[8 + j] = cntAlarms.Count;
                                        dr2[8 + j] = cntAlarms;
                                        break;

                                    default:
                                        break;
                                    }
                                }

                                source1.Rows.Add(dr1);
                                source2.Rows.Add(dr2);
                                #endregion
                            }
                            else if (childNodes[i].NodeType == EnmNodeType.Sta)
                            {
                                #region Sta
                                var dr1 = source1.NewRow();
                                var dr2 = source2.NewRow();
                                dr1[1] = WebUtility.GetNodeTypeName(childNodes[i].NodeType);
                                dr2[1] = (int)childNodes[i].NodeType;
                                dr1[2] = childNodes[i].NodeName;
                                dr2[2] = childNodes[i].LscID;
                                var filters = alarms.FindAll(agi => { return(agi.StaName.Equals(childNodes[i].NodeName)); });
                                dr1[3] = filters.Count;
                                dr2[3] = filters;
                                var cntAlarms = filters.FindAll(agi => { return(agi.AlarmLevel == EnmAlarmLevel.Critical); });
                                dr1[4]    = cntAlarms.Count;
                                dr2[4]    = cntAlarms;
                                cntAlarms = filters.FindAll(agi => { return(agi.AlarmLevel == EnmAlarmLevel.Major); });
                                dr1[5]    = cntAlarms.Count;
                                dr2[5]    = cntAlarms;
                                cntAlarms = filters.FindAll(agi => { return(agi.AlarmLevel == EnmAlarmLevel.Minor); });
                                dr1[6]    = cntAlarms.Count;
                                dr2[6]    = cntAlarms;
                                cntAlarms = filters.FindAll(agi => { return(agi.AlarmLevel == EnmAlarmLevel.Hint); });
                                dr1[7]    = cntAlarms.Count;
                                dr2[7]    = cntAlarms;

                                for (int j = 0; j < columns.Count; j++)
                                {
                                    string[] items = null;
                                    switch (columns[j].FilterType)
                                    {
                                    case EnmAlarmFiterType.AlarmDeviceID:
                                        items      = WebUtility.StringSplit(columns[j].FilterItem);
                                        cntAlarms  = filters.FindAll(agi => { return(items.Contains(agi.AlarmDeviceTypeID.ToString())); });
                                        dr1[8 + j] = cntAlarms.Count;
                                        dr2[8 + j] = cntAlarms;
                                        break;

                                    case EnmAlarmFiterType.AlarmLogID:
                                        items      = WebUtility.StringSplit(columns[j].FilterItem);
                                        cntAlarms  = filters.FindAll(agi => { return(items.Contains(agi.AlarmLogTypeID.ToString())); });
                                        dr1[8 + j] = cntAlarms.Count;
                                        dr2[8 + j] = cntAlarms;
                                        break;

                                    case EnmAlarmFiterType.AlarmID:
                                        items      = WebUtility.StringSplit(columns[j].FilterItem);
                                        cntAlarms  = filters.FindAll(agi => { return(items.Contains(agi.AlarmID.ToString())); });
                                        dr1[8 + j] = cntAlarms.Count;
                                        dr2[8 + j] = cntAlarms;
                                        break;

                                    case EnmAlarmFiterType.AlarmDesc:
                                        cntAlarms  = filters.FindAll(agi => { return(agi.AlarmDesc.Contains(columns[j].FilterItem)); });
                                        dr1[8 + j] = cntAlarms.Count;
                                        dr2[8 + j] = cntAlarms;
                                        break;

                                    case EnmAlarmFiterType.NodeName:
                                        var nodeNames = WebUtility.StringSplit(columns[j].FilterItem);
                                        cntAlarms = filters.FindAll(agi => {
                                            foreach (var name in nodeNames)
                                            {
                                                if (agi.NodeName.Contains(name))
                                                {
                                                    return(true);
                                                }
                                            }
                                            return(false);
                                        });
                                        dr1[8 + j] = cntAlarms.Count;
                                        dr2[8 + j] = cntAlarms;
                                        break;

                                    case EnmAlarmFiterType.TimeShare:
                                        items = WebUtility.StringSplit(columns[j].FilterItem);
                                        if (items.Length != 2)
                                        {
                                            dr1[8 + j] = 0;
                                        }
                                        else
                                        {
                                            var minInterval = WebUtility.GetSecondFromDateTime(items[0]);
                                            var maxInterval = WebUtility.GetSecondFromDateTime(items[1]);
                                            cntAlarms = filters.FindAll(agi => {
                                                var dateInterval = DateTime.Now.Subtract(agi.StartTime).TotalSeconds;
                                                return(dateInterval >= minInterval && dateInterval <= maxInterval);
                                            });
                                            dr1[8 + j] = cntAlarms.Count;
                                            dr2[8 + j] = cntAlarms;
                                        }
                                        break;

                                    case EnmAlarmFiterType.DevName:
                                        var devNames = WebUtility.StringSplit(columns[j].FilterItem);
                                        cntAlarms = filters.FindAll(agi => {
                                            foreach (var name in devNames)
                                            {
                                                if (agi.DevName.Contains(name))
                                                {
                                                    return(true);
                                                }
                                            }
                                            return(false);
                                        });
                                        dr1[8 + j] = cntAlarms.Count;
                                        dr2[8 + j] = cntAlarms;
                                        break;

                                    default:
                                        break;
                                    }
                                }

                                source1.Rows.Add(dr1);
                                source2.Rows.Add(dr2);
                                #endregion
                            }
                        }
                    }
                }
            }

            var cacheDuration = Int32.Parse(WebConfigurationManager.AppSettings["DefaultCacheDuration"]);
            HttpRuntime.Cache.Insert(cacheKey1, source1, null, Cache.NoAbsoluteExpiration, TimeSpan.FromSeconds(cacheDuration), CacheItemPriority.Default, null);
            HttpRuntime.Cache.Insert(cacheKey2, source2, null, Cache.NoAbsoluteExpiration, TimeSpan.FromSeconds(cacheDuration), CacheItemPriority.Default, null);
            return(source1);
        }
示例#7
0
        /// <summary>
        /// Add data to cache.
        /// </summary>
        private List <Report009Entity> AddDataToCache()
        {
            var userData = UserData;
            var cacheKey = WebUtility.GetCacheKeyName(userData, "kpi-report-009");

            HttpRuntime.Cache.Remove(cacheKey);

            var lscs = new List <LscUserInfo>();

            if (LscsComboBox.SelectedIndex > 0)
            {
                var ids = WebUtility.ItemSplit(LscsComboBox.SelectedItem.Value);
                if (ids.Length == 2)
                {
                    var lscId   = Int32.Parse(ids[0]);
                    var groupId = Int32.Parse(ids[1]);
                    var lscUser = userData.LscUsers.Find(lu => { return(lu.LscID == lscId); });
                    if (lscUser != null)
                    {
                        lscs.Add(lscUser);
                    }
                }
            }
            else
            {
                lscs.AddRange(userData.LscUsers);
            }
            if (lscs.Count == 0)
            {
                return(null);
            }

            var fromTime = DateTime.Parse(BeginFromDate.Text);
            var toTime   = DateTime.Parse(BeginToDate.Text);

            var auxSets    = new List <String>();
            var texts      = new List <String>();
            var filterText = WebUtility.StringSplit(NodeText.Text.Trim());

            foreach (var ft in filterText)
            {
                if (String.IsNullOrEmpty(ft.Trim()))
                {
                    continue;
                }
                if (FilterList.SelectedItem.Value.Equals("1"))
                {
                    auxSets.Add(ft.Trim());
                }
                else
                {
                    texts.Add(ft.Trim());
                }
            }
            if (texts.Count == 0 && auxSets.Count == 0)
            {
                return(null);
            }

            var almNames = new List <String>();
            var almIds   = new Dictionary <String, String>();
            var almText  = WebUtility.StringSplit(AlarmNameText.Text.Trim());

            foreach (var at in almText)
            {
                if (String.IsNullOrEmpty(at.Trim()))
                {
                    continue;
                }
                if (AlmNameList.SelectedItem.Value.Equals("1"))
                {
                    almIds[at.Trim()] = null;
                }
                else
                {
                    almNames.Add(at.Trim());
                }
            }

            var nodeEntity   = new BNode();
            var alarmEntity  = new BAlarm();
            var result       = new List <Report009Entity>();
            var activeAlarms = WebUtility.GetUserAlarms(userData).FindAll(alarm => lscs.Any(l => l.LscID == alarm.LscID) && alarm.StartTime >= fromTime && alarm.StartTime <= toTime);

            foreach (var lsc in lscs)
            {
                var nodes  = nodeEntity.GetNodes(lsc.LscID, EnmNodeType.Img, texts.ToArray(), auxSets.ToArray(), null);
                var alarms = alarmEntity.GetHisAlarms(lsc.LscID, lsc.LscName, userData.StandardProtocol, lsc.Group.GroupNodes, fromTime, toTime);
                alarms.AddRange(activeAlarms.FindAll(a => a.LscID == lsc.LscID));
                var ndWam = from alarm in alarms
                            join node in nodes on new { alarm.LscID, alarm.NodeID, alarm.NodeType } equals new { node.LscID, node.NodeID, node.NodeType }
                where (almNames.Count == 0 || almNames.Any(name => alarm.AlarmName.Contains(name))) && (almIds.Count == 0 || almIds.ContainsKey(alarm.AlarmID.ToString())) && string.IsNullOrEmpty(alarm.ProjName)
                select new {
                    Node  = node,
                    Alarm = alarm
                };

                result.Add(new Report009Entity {
                    LscID     = lsc.LscID,
                    LscName   = lsc.LscName,
                    ThisCount = fRadio.Checked ? ndWam.GroupBy(n => n.Node.StaID).Count() : ndWam.GroupBy(n => n.Node.Area3ID).Count(),
                    LastCount = fRadio.Checked ? nodes.GroupBy(n => n.StaID).Count() : nodes.GroupBy(n => n.Area3ID).Count()
                });
            }

            if (result.Count > 0)
            {
                result.Add(new Report009Entity {
                    LscID     = -100,
                    LscName   = "汇总(平均值)",
                    ThisCount = (Int32)result.Average(r => r.ThisCount),
                    LastCount = (Int32)result.Average(r => r.LastCount)
                });
            }

            int cacheDuration = Int32.Parse(WebConfigurationManager.AppSettings["DefaultCacheDuration"]);

            HttpRuntime.Cache.Insert(cacheKey, result, null, Cache.NoAbsoluteExpiration, TimeSpan.FromSeconds(cacheDuration), CacheItemPriority.Default, null);
            return(result);
        }
示例#8
0
        /// <summary>
        /// Add data to cache.
        /// </summary>
        private List <Report108Entity> AddDataToCache()
        {
            var userData = UserData;
            var cacheKey = WebUtility.GetCacheKeyName(userData, "kpi-report-108");

            HttpRuntime.Cache.Remove(cacheKey);

            var lscs = new List <LscUserInfo>();

            if (LscsComboBox.SelectedIndex > 0)
            {
                var ids = WebUtility.ItemSplit(LscsComboBox.SelectedItem.Value);
                if (ids.Length != 2)
                {
                    return(null);
                }
                var lscId   = Int32.Parse(ids[0]);
                var groupId = Int32.Parse(ids[1]);
                var lscUser = userData.LscUsers.Find(lu => { return(lu.LscID == lscId); });
                if (lscUser == null)
                {
                    return(null);
                }
                lscs.Add(lscUser);
            }
            else
            {
                lscs.AddRange(userData.LscUsers);
            }

            var fromTime = DateTime.Parse(BeginFromDate.Text);
            var toTime   = DateTime.Parse(BeginToDate.Text);

            var alarmNames = new Dictionary <Int32, String>();

            foreach (var item in AlarmNameMultiCombo.SelectedItems)
            {
                alarmNames[Convert.ToInt32(item.Value)] = item.Text;
            }
            if (alarmNames.Count == 0)
            {
                return(null);
            }
            var split    = ";";
            var alarmIds = String.Join(split, alarmNames.Select(n => n.Key.ToString()).ToArray());

            var otherEntity = new BOther();
            var alarmEntity = new BAlarm();
            var result      = new List <Report108Entity>();

            foreach (var lsc in lscs)
            {
                var stations = otherEntity.GetStations(lsc.LscID, lsc.Group.GroupID).FindAll(s => s.BuildingID != WebUtility.DefaultInt32);
                if (Area2ComboBox.SelectedIndex > 0)
                {
                    var area2Id = Int32.Parse(Area2ComboBox.SelectedItem.Value);
                    stations = stations.FindAll(s => s.Area2ID == area2Id);
                }
                if (Area3ComboBox.SelectedIndex > 0)
                {
                    var area3Id = Int32.Parse(Area3ComboBox.SelectedItem.Value);
                    stations = stations.FindAll(s => s.Area3ID == area3Id);
                }
                if (stations.Count == 0)
                {
                    continue;
                }

                var fsuCnt = otherEntity.GetStationFSUCnt(lsc.LscID, lsc.Group.GroupID, alarmIds, split);
                var alarms = WebUtility.GetUserAlarms(userData).FindAll(alarm => alarm.LscID == lsc.LscID && alarm.StartTime >= fromTime && alarm.StartTime <= toTime && alarmNames.ContainsKey(alarm.AlarmID));
                alarms.AddRange(alarmEntity.GetHisAlarms(lsc.LscID, lsc.LscName, userData.StandardProtocol, lsc.Group.GroupNodes, fromTime, toTime).FindAll(alarm => {
                    return(alarmNames.ContainsKey(alarm.AlarmID));
                }));

                var staWam = from alarm in alarms
                             group alarm by new { alarm.LscID, alarm.StaName } into g
                    select new {
                    LscID   = g.Key.LscID,
                    StaName = g.Key.StaName,
                    Alarms  = g
                };

                var staWfa = from sn in stations
                             join fc in fsuCnt on new { sn.LscID, sn.StaID } equals new { fc.LscID, fc.StaID } into lt1
                from fs in lt1.DefaultIfEmpty()
                join sw in staWam on new { sn.LscID, sn.StaName } equals new { sw.LscID, sw.StaName } into lt2
                from ws in lt2.DefaultIfEmpty()
                select new {
                    Station = sn,
                    FSUCnt  = fs != null ? fs.AICnt + fs.AOCnt + fs.DICnt + fs.DOCnt : 0,
                    Alarms  = ws != null?ws.Alarms.ToList() : new List <AlarmInfo>()
                };

                result.AddRange(from sf in staWfa
                                group sf by new { sf.Station.LscID, sf.Station.Area3ID, sf.Station.BuildingID } into g
                                orderby g.Key.LscID, g.Key.Area3ID, g.Key.BuildingID
                                select new Report108Entity {
                    Station   = g.First().Station,
                    BeginTime = fromTime,
                    EndTime   = toTime,
                    FSUCnt    = g.Sum(f => f.FSUCnt),
                    Alarms    = g.SelectMany(a => a.Alarms).ToList()
                });
            }

            int cacheDuration = Int32.Parse(WebConfigurationManager.AppSettings["DefaultCacheDuration"]);

            HttpRuntime.Cache.Insert(cacheKey, result, null, Cache.NoAbsoluteExpiration, TimeSpan.FromSeconds(cacheDuration), CacheItemPriority.Default, null);
            return(result);
        }
示例#9
0
        /// <summary>
        /// Add data to cache.
        /// </summary>
        private List <Report002Entity> AddDataToCache()
        {
            var userData = UserData;
            var cacheKey = WebUtility.GetCacheKeyName(userData, "kpi-report-002");

            HttpRuntime.Cache.Remove(cacheKey);

            var lscs = new List <LscUserInfo>();

            if (LscsComboBox.SelectedIndex > 0)
            {
                var ids = WebUtility.ItemSplit(LscsComboBox.SelectedItem.Value);
                if (ids.Length == 2)
                {
                    var lscId   = Int32.Parse(ids[0]);
                    var groupId = Int32.Parse(ids[1]);
                    var lscUser = userData.LscUsers.Find(lu => { return(lu.LscID == lscId); });
                    if (lscUser != null)
                    {
                        lscs.Add(lscUser);
                    }
                }
            }
            else
            {
                lscs.AddRange(userData.LscUsers);
            }
            if (lscs.Count == 0)
            {
                return(null);
            }

            var fromTime = DateTime.Parse(BeginFromDate.Text);
            var toTime   = DateTime.Parse(BeginToDate.Text);

            var auxSets    = new List <String>();
            var texts      = new List <String>();
            var filterText = WebUtility.StringSplit(NodeText.Text.Trim());

            foreach (var ft in filterText)
            {
                if (String.IsNullOrEmpty(ft.Trim()))
                {
                    continue;
                }
                if (FilterList.SelectedItem.Value.Equals("1"))
                {
                    auxSets.Add(ft.Trim());
                }
                else
                {
                    texts.Add(ft.Trim());
                }
            }
            if (texts.Count == 0 && auxSets.Count == 0)
            {
                return(null);
            }

            var pauxSets    = new List <String>();
            var ptexts      = new List <String>();
            var pfilterText = WebUtility.StringSplit(PNodeText.Text.Trim());

            foreach (var ft in pfilterText)
            {
                if (String.IsNullOrEmpty(ft.Trim()))
                {
                    continue;
                }
                if (PFilterList.SelectedItem.Value.Equals("1"))
                {
                    pauxSets.Add(ft.Trim());
                }
                else
                {
                    ptexts.Add(ft.Trim());
                }
            }
            if (ptexts.Count == 0 && pauxSets.Count == 0)
            {
                return(null);
            }

            var devTypes = new Dictionary <Int32, String>();

            foreach (var dt in DevTypeMultiCombo.SelectedItems)
            {
                devTypes[Int32.Parse(dt.Value)] = dt.Text;
            }
            if (devTypes.Count == 0)
            {
                return(null);
            }

            var almNames = new List <String>();
            var almIds   = new Dictionary <String, String>();
            var almText  = WebUtility.StringSplit(AlarmNameText.Text.Trim());

            foreach (var at in almText)
            {
                if (String.IsNullOrEmpty(at.Trim()))
                {
                    continue;
                }
                if (AlmNameList.SelectedItem.Value.Equals("1"))
                {
                    almIds[at.Trim()] = null;
                }
                else
                {
                    almNames.Add(at.Trim());
                }
            }

            var palmNames = new List <String>();
            var palmIds   = new Dictionary <String, String>();
            var palmText  = WebUtility.StringSplit(PAlarmNameText.Text.Trim());

            foreach (var at in palmText)
            {
                if (String.IsNullOrEmpty(at.Trim()))
                {
                    continue;
                }
                if (PAlmNameList.SelectedItem.Value.Equals("1"))
                {
                    palmIds[at.Trim()] = null;
                }
                else
                {
                    palmNames.Add(at.Trim());
                }
            }

            var otherEntity = new BOther();
            var nodeEntity  = new BNode();
            var devices     = new List <DeviceInfo>();
            var nodes       = new List <NodeInfo>();
            var pnodes      = new List <NodeInfo>();

            foreach (var lsc in lscs)
            {
                devices.AddRange(otherEntity.GetDevices(lsc.LscID, lsc.Group.GroupID));
                nodes.AddRange(nodeEntity.GetNodes(lsc.LscID, EnmNodeType.Img, texts.ToArray(), auxSets.ToArray(), null));
                if (ptexts.Count > 0 || pauxSets.Count > 0)
                {
                    pnodes.AddRange(nodeEntity.GetNodes(lsc.LscID, EnmNodeType.Img, ptexts.ToArray(), pauxSets.ToArray(), null));
                }
            }

            devices = devices.FindAll(d => devTypes.ContainsKey(d.AlmDevTypeID));
            var devGroup = from dev in devices
                           group dev by new { dev.LscID } into g
                select new {
                LscID   = g.Key.LscID,
                Devices = g.ToList()
            };

            var lcWdv = from lsc in lscs
                        join dg in devGroup on new { lsc.LscID } equals new { dg.LscID } into lt
            from gs in lt.DefaultIfEmpty()
            select new {
                LscID   = lsc.LscID,
                LscName = lsc.LscName,
                Devices = gs == null ? new List <DeviceInfo>() : gs.Devices
            };

            var alarmEntity = new BAlarm();
            var alarms      = WebUtility.GetUserAlarms(userData).FindAll(alarm => lscs.Any(l => l.LscID == alarm.LscID) && alarm.StartTime >= fromTime && alarm.StartTime <= toTime);

            foreach (var lsc in lscs)
            {
                alarms.AddRange(alarmEntity.GetHisAlarms(lsc.LscID, lsc.LscName, userData.StandardProtocol, lsc.Group.GroupNodes, fromTime, toTime));
            }

            var ndWam = from alarm in alarms
                        join node in nodes on new { alarm.LscID, alarm.NodeID, alarm.NodeType } equals new { node.LscID, node.NodeID, node.NodeType }
            where (almNames.Count == 0 || almNames.Any(name => alarm.AlarmName.Contains(name))) && (almIds.Count == 0 || almIds.ContainsKey(alarm.AlarmID.ToString())) && string.IsNullOrEmpty(alarm.ProjName)
            select new {
                Node  = node,
                Alarm = alarm
            };

            var pdWam = from alarm in alarms
                        join node in pnodes on new { alarm.LscID, alarm.NodeID, alarm.NodeType } equals new { node.LscID, node.NodeID, node.NodeType }
            where (palmNames.Count == 0 || palmNames.Any(name => alarm.AlarmName.Contains(name))) && (palmIds.Count == 0 || palmIds.ContainsKey(alarm.AlarmID.ToString())) && string.IsNullOrEmpty(alarm.ProjName)
            select new {
                Node  = node,
                Alarm = alarm
            };

            var almGroup = from alarm in ndWam
                           group alarm by new { alarm.Node.LscID } into g
                select new {
                LscID  = g.Key.LscID,
                Alarms = g.Select(a => a.Alarm)
            };

            var plmGroup = from alarm in pdWam
                           group alarm by new { alarm.Node.LscID } into g
                select new {
                LscID  = g.Key.LscID,
                Alarms = g.Select(a => a.Alarm)
            };

            var result = (from ld in lcWdv
                          join ag in almGroup on new { ld.LscID } equals new { ag.LscID } into lt1
                          from la in lt1.DefaultIfEmpty()
                          join pg in plmGroup on new { ld.LscID } equals new { pg.LscID } into lt2
                          from lp in lt2.DefaultIfEmpty()
                          orderby ld.LscID
                          select new Report002Entity {
                LscID = ld.LscID,
                LscName = ld.LscName,
                BeginTime = fromTime,
                EndTime = toTime,
                Devices = ld.Devices,
                Alarms = la == null ? new List <AlarmInfo>() : la.Alarms.ToList(),
                PAlarms = lp == null ? new List <AlarmInfo>() : lp.Alarms.ToList()
            }).ToList();

            if (result.Count > 0)
            {
                result.Add(new Report002Entity {
                    LscID     = -100,
                    LscName   = "汇总(平均值)",
                    BeginTime = fromTime,
                    EndTime   = toTime,
                    Devices   = new List <DeviceInfo>(),
                    Alarms    = new List <AlarmInfo>(),
                    PAlarms   = new List <AlarmInfo>()
                });
            }

            int cacheDuration = Int32.Parse(WebConfigurationManager.AppSettings["DefaultCacheDuration"]);

            HttpRuntime.Cache.Insert(cacheKey, result, null, Cache.NoAbsoluteExpiration, TimeSpan.FromSeconds(cacheDuration), CacheItemPriority.Default, null);
            return(result);
        }
示例#10
0
        /// <summary>
        /// Add data to cache.
        /// </summary>
        private List <Report111Entity> AddDataToCache()
        {
            var userData = UserData;
            var cacheKey = WebUtility.GetCacheKeyName(userData, "kpi-report-111");

            HttpRuntime.Cache.Remove(cacheKey);

            var lscs = new List <LscUserInfo>();

            if (LscsComboBox.SelectedIndex > 0)
            {
                var ids = WebUtility.ItemSplit(LscsComboBox.SelectedItem.Value);
                if (ids.Length != 2)
                {
                    return(null);
                }
                var lscId   = Int32.Parse(ids[0]);
                var groupId = Int32.Parse(ids[1]);
                var lscUser = userData.LscUsers.Find(lu => { return(lu.LscID == lscId); });
                if (lscUser == null)
                {
                    return(null);
                }
                lscs.Add(lscUser);
            }
            else
            {
                lscs.AddRange(userData.LscUsers);
            }

            var fromTime = DateTime.Parse(BeginFromDate.Text);
            var toTime   = DateTime.Parse(BeginToDate.Text);

            var texts      = new List <String>();
            var auxSets    = new List <String>();
            var filterText = WebUtility.StringSplit(NodeText.Text.Trim());

            foreach (var ft in filterText)
            {
                if (String.IsNullOrEmpty(ft.Trim()))
                {
                    continue;
                }
                if (FilterTypeList.SelectedItem.Value.Equals("1"))
                {
                    auxSets.Add(ft.Trim());
                }
                else
                {
                    texts.Add(ft.Trim());
                }
            }

            var staTypes = new Dictionary <Int32, String>();

            foreach (var dt in StaTypeMultiCombo.SelectedItems)
            {
                staTypes[Int32.Parse(dt.Value)] = dt.Text;
            }
            if (staTypes.Count == 0)
            {
                return(null);
            }

            var devTypes = new Dictionary <Int32, String>();

            foreach (var dt in DevTypeMultiCombo.SelectedItems)
            {
                devTypes[Int32.Parse(dt.Value)] = dt.Text;
            }
            if (devTypes.Count == 0)
            {
                return(null);
            }

            var almNames = new List <String>();
            var almIds   = new Dictionary <String, String>();
            var almText  = WebUtility.StringSplit(AlarmNameText.Text.Trim());

            foreach (var at in almText)
            {
                if (String.IsNullOrEmpty(at.Trim()))
                {
                    continue;
                }
                if (AlmNameList.SelectedItem.Value.Equals("1"))
                {
                    almIds[at.Trim()] = null;
                }
                else
                {
                    almNames.Add(at.Trim());
                }
            }

            var nodeEntity  = new BNode();
            var lscEntity   = new BLsc();
            var alarmEntity = new BAlarm();
            var result      = new List <Report111Entity>();

            var virtualData = WebConfigurationManager.AppSettings["Kpi-HeNan-Virtual-Enable"] != null && WebConfigurationManager.AppSettings["Kpi-HeNan-Virtual-Enable"].Equals("1");
            var lscParms    = new List <LscParamInfo>();

            if (virtualData)
            {
                lscParms.AddRange(new BOther().GetLscParam());
            }

            foreach (var l in lscs)
            {
                var lsc = lscEntity.GetLsc(l.LscID);
                if (lsc == null)
                {
                    continue;
                }

                var stations = Report111Entity.GetStations(lsc.LscID, lsc.LscName, WebUtility.CreateLscConnectionString(lsc));
                var nodes    = nodeEntity.GetNodes(lsc.LscID, EnmNodeType.Dic, texts.ToArray(), auxSets.ToArray(), devTypes.Keys.ToArray());
                if (nodes.Count == 0)
                {
                    result.Add(new Report111Entity {
                        LscID     = lsc.LscID,
                        LscName   = lsc.LscName,
                        BeginTime = fromTime,
                        EndTime   = toTime,
                        Alarms    = new List <AlarmInfo>(),
                        NodeCnt   = stations.Count
                    });
                }
                else
                {
                    var alarms = WebUtility.GetUserAlarms(userData).FindAll(alarm => alarm.LscID == lsc.LscID && alarm.StartTime >= fromTime && alarm.StartTime <= toTime);
                    alarms.AddRange(alarmEntity.GetHisAlarms(lsc.LscID, lsc.LscName, userData.StandardProtocol, l.Group.GroupNodes, fromTime, toTime));

                    var ta = alarms.FindAll(alarm => {
                        return((almNames.Count == 0 || almNames.Any(name => alarm.AlarmName.Contains(name))) &&
                               (almIds.Count == 0 || almIds.ContainsKey(alarm.AlarmID.ToString())));
                    });

                    var temp = from alarm in ta
                               join node in nodes on new { alarm.LscID, alarm.NodeID, alarm.NodeType } equals new { node.LscID, node.NodeID, node.NodeType }
                    select alarm;

                    var record = new Report111Entity {
                        LscID     = lsc.LscID,
                        LscName   = lsc.LscName,
                        BeginTime = fromTime,
                        EndTime   = toTime,
                        Alarms    = temp.ToList(),
                        NodeCnt   = stations.Count
                    };

                    if (virtualData)
                    {
                        var parm = lscParms.Find(s => s.LscID == lsc.LscID);
                        if (parm != null && parm.StaTNumber != WebUtility.DefaultInt32)
                        {
                            record.NodeCnt = parm.StaTNumber;
                        }
                    }

                    result.Add(record);
                }
            }

            int cacheDuration = Int32.Parse(WebConfigurationManager.AppSettings["DefaultCacheDuration"]);

            HttpRuntime.Cache.Insert(cacheKey, result, null, Cache.NoAbsoluteExpiration, TimeSpan.FromSeconds(cacheDuration), CacheItemPriority.Default, null);
            return(result);
        }
示例#11
0
        /// <summary>
        /// Add data to cache.
        /// </summary>
        private List <Report005Entity> AddDataToCache()
        {
            var userData = UserData;
            var cacheKey = WebUtility.GetCacheKeyName(userData, "kpi-report-005");

            HttpRuntime.Cache.Remove(cacheKey);

            var lscs = new List <LscUserInfo>();

            if (LscsComboBox.SelectedIndex > 0)
            {
                var ids = WebUtility.ItemSplit(LscsComboBox.SelectedItem.Value);
                if (ids.Length == 2)
                {
                    var lscId   = Int32.Parse(ids[0]);
                    var groupId = Int32.Parse(ids[1]);
                    var lscUser = userData.LscUsers.Find(lu => { return(lu.LscID == lscId); });
                    if (lscUser != null)
                    {
                        lscs.Add(lscUser);
                    }
                }
            }
            else
            {
                lscs.AddRange(userData.LscUsers);
            }
            if (lscs.Count == 0)
            {
                return(null);
            }

            var staTypes = new Dictionary <Int32, String>();

            foreach (var dt in StaTypeMultiCombo.SelectedItems)
            {
                staTypes[Int32.Parse(dt.Value)] = dt.Text;
            }
            if (staTypes.Count == 0)
            {
                return(null);
            }

            var fromTime = DateTime.Parse(BeginFromDate.Text);
            var toTime   = DateTime.Parse(BeginToDate.Text);

            var alarmNames = new Dictionary <Int32, String>();

            foreach (var item in AlarmNameMultiCombo.SelectedItems)
            {
                alarmNames[Convert.ToInt32(item.Value)] = item.Text;
            }
            if (alarmNames.Count == 0)
            {
                return(null);
            }
            var split    = ";";
            var alarmIds = String.Join(split, alarmNames.Select(n => n.Key.ToString()).ToArray());

            var alarmEntity = new BAlarm();
            var otherEntity = new BOther();
            var result      = new List <Report005Entity>();

            foreach (var lsc in lscs)
            {
                var fsuCnt = otherEntity.GetStationFSUCnt(lsc.LscID, lsc.Group.GroupID, alarmIds, split).FindAll(fc => staTypes.ContainsKey(fc.StaTypeID));
                var alarms = WebUtility.GetUserAlarms(userData).FindAll(alarm => alarm.LscID == lsc.LscID && alarm.StartTime >= fromTime && alarm.StartTime <= toTime && alarmNames.ContainsKey(alarm.AlarmID) && string.IsNullOrEmpty(alarm.ProjName));
                alarms.AddRange(alarmEntity.GetHisAlarms(lsc.LscID, lsc.LscName, userData.StandardProtocol, lsc.Group.GroupNodes, fromTime, toTime).FindAll(alarm => {
                    return(alarmNames.ContainsKey(alarm.AlarmID) && string.IsNullOrEmpty(alarm.ProjName));
                }));

                var temp = from alarm in alarms
                           join fct in fsuCnt on alarm.StaName equals fct.StaName
                           select alarm;

                result.Add(new Report005Entity()
                {
                    LscID     = lsc.LscID,
                    LscName   = lsc.LscName,
                    BeginTime = fromTime,
                    EndTime   = toTime,
                    FSUCnt    = fsuCnt.Sum(fc => fc.AICnt + fc.AOCnt + fc.DICnt + fc.DOCnt),
                    Alarms    = temp.ToList()
                });
            }

            if (result.Count > 0)
            {
                result.Add(new Report005Entity {
                    LscID     = -100,
                    LscName   = "汇总(平均值)",
                    BeginTime = fromTime,
                    EndTime   = toTime,
                    FSUCnt    = 0,
                    Alarms    = new List <AlarmInfo>()
                });
            }

            int cacheDuration = Int32.Parse(WebConfigurationManager.AppSettings["DefaultCacheDuration"]);

            HttpRuntime.Cache.Insert(cacheKey, result, null, Cache.NoAbsoluteExpiration, TimeSpan.FromSeconds(cacheDuration), CacheItemPriority.Default, null);
            return(result);
        }
示例#12
0
        /// <summary>
        /// Add data to cache.
        /// </summary>
        private List <Report011Entity> AddDataToCache()
        {
            var userData = UserData;
            var cacheKey = WebUtility.GetCacheKeyName(userData, "kpi-report-011");

            HttpRuntime.Cache.Remove(cacheKey);

            var lscs = new List <LscUserInfo>();

            if (LscsComboBox.SelectedIndex > 0)
            {
                var ids = WebUtility.ItemSplit(LscsComboBox.SelectedItem.Value);
                if (ids.Length == 2)
                {
                    var lscId   = Int32.Parse(ids[0]);
                    var groupId = Int32.Parse(ids[1]);
                    var lscUser = userData.LscUsers.Find(lu => { return(lu.LscID == lscId); });
                    if (lscUser != null)
                    {
                        lscs.Add(lscUser);
                    }
                }
            }
            else
            {
                lscs.AddRange(userData.LscUsers);
            }
            if (lscs.Count == 0)
            {
                return(null);
            }

            var staTypes = new Dictionary <Int32, String>();

            foreach (var dt in StaTypeMultiCombo.SelectedItems)
            {
                staTypes[Int32.Parse(dt.Value)] = dt.Text;
            }
            if (staTypes.Count == 0)
            {
                return(null);
            }

            var fromTime = DateTime.Parse(BeginFromDate.Text);
            var toTime   = DateTime.Parse(BeginToDate.Text);

            var alarmNames = new Dictionary <Int32, String>();

            foreach (var item in AlarmNameMultiCombo.SelectedItems)
            {
                alarmNames[Convert.ToInt32(item.Value)] = item.Text;
            }

            var otherEntity = new BOther();
            var nodeEntity  = new BNode();
            var lscEntity   = new BLsc();
            var alarmEntity = new BAlarm();
            var result      = new List <Report011Entity>();

            foreach (var l in lscs)
            {
                var lsc = lscEntity.GetLsc(l.LscID);
                if (lsc == null)
                {
                    continue;
                }

                var stations = otherEntity.GetStations(lsc.LscID, l.Group.GroupID).FindAll(sta => staTypes.ContainsKey(sta.StaTypeID));
                var alarms   = WebUtility.GetUserAlarms(userData).FindAll(alarm => alarm.LscID == lsc.LscID && alarm.StartTime >= fromTime && alarm.StartTime <= toTime && alarmNames.ContainsKey(alarm.AlarmID) && string.IsNullOrEmpty(alarm.ProjName));
                alarms.AddRange(alarmEntity.GetHisAlarms(lsc.LscID, lsc.LscName, userData.StandardProtocol, l.Group.GroupNodes, fromTime, toTime).FindAll(alarm => {
                    return(alarmNames.ContainsKey(alarm.AlarmID) && string.IsNullOrEmpty(alarm.ProjName));
                }));

                var nalm = from alarm in alarms
                           join sta in stations on alarm.StaName equals sta.StaName
                           select alarm;

                var parm   = Report011Entity.GetLscParam(lsc.LscID, WebUtility.CreateLscConnectionString(lsc));
                var record = new Report011Entity {
                    LscID     = lsc.LscID,
                    LscName   = lsc.LscName,
                    BeginTime = fromTime,
                    EndTime   = toTime,
                    Alarms    = nalm.Any() ? nalm.ToList() : new List <AlarmInfo>(),
                    StaCnt    = parm != null ? parm.StaMNumber : 0,
                };

                result.Add(record);
            }

            if (result.Count > 0)
            {
                result.Add(new Report011Entity {
                    LscID     = -100,
                    LscName   = "汇总(平均值)",
                    BeginTime = fromTime,
                    EndTime   = toTime,
                    Alarms    = new List <AlarmInfo>(),
                    StaCnt    = (Int32)result.Average(r => r.StaCnt)
                });
            }

            int cacheDuration = Int32.Parse(WebConfigurationManager.AppSettings["DefaultCacheDuration"]);

            HttpRuntime.Cache.Insert(cacheKey, result, null, Cache.NoAbsoluteExpiration, TimeSpan.FromSeconds(cacheDuration), CacheItemPriority.Default, null);
            return(result);
        }
示例#13
0
        /// <summary>
        /// Add Data To Cache
        /// </summary>
        private List <AlarmInfo> AddDataToCache()
        {
            var userData = UserData;
            var cacheKey = WebUtility.GetCacheKeyName(userData, "his-alarms");

            HttpRuntime.Cache.Remove(cacheKey);

            var lscUsers = new List <LscUserInfo>();

            if (LscsComboBox.SelectedIndex > 0)
            {
                var ids = WebUtility.ItemSplit(LscsComboBox.SelectedItem.Value);
                if (ids.Length == 2)
                {
                    var lscId   = Int32.Parse(ids[0]);
                    var groupId = Int32.Parse(ids[1]);
                    var lscUser = userData.LscUsers.Find(lu => { return(lu.LscID == lscId); });
                    if (lscUser != null)
                    {
                        lscUsers.Add(lscUser);
                    }
                }
            }
            else
            {
                lscUsers.AddRange(userData.LscUsers);
            }

            if (lscUsers.Count == 0)
            {
                return(null);
            }

            var alarmEntity = new BAlarm();
            var condition   = GetCondition();
            var alarms      = new List <AlarmInfo>();

            foreach (var lu in lscUsers)
            {
                alarms.AddRange(alarmEntity.GetHisAlarms(lu.LscID, lu.LscName, userData.StandardProtocol, lu.Group.GroupNodes, condition));
            }

            if (alarms.Count > 0)
            {
                alarms = (from alarm in alarms
                          where (AlarmDevComboBox.SelectedIndex == 0 || alarm.AlarmDeviceType.Equals(AlarmDevComboBox.SelectedItem.Text)) &&
                          (AlarmLogicComboBox.SelectedIndex == 0 || alarm.AlarmLogType.Equals(AlarmLogicComboBox.SelectedItem.Text)) &&
                          (AlarmNameComboBox.SelectedIndex == 0 || alarm.AlarmName.Equals(AlarmNameComboBox.SelectedItem.Text)) &&
                          (!OtherOptionsMenuItem1.Checked || alarm.ConfirmMarking == EnmConfirmMarking.NotConfirm) &&
                          (!OtherOptionsMenuItem2.Checked || alarm.ConfirmMarking != EnmConfirmMarking.NotConfirm) &&
                          (!OtherOptionsMenuItem3.Checked || alarm.AlarmID != 0) &&
                          (!OtherOptionsMenuItem4.Checked || alarm.AlarmID == 0) &&
                          (!OtherOptionsMenuItem5.Checked || String.IsNullOrEmpty(alarm.ProjName)) &&
                          (!OtherOptionsMenuItem6.Checked || !String.IsNullOrEmpty(alarm.ProjName))
                          orderby alarm.StartTime descending
                          select alarm).ToList();
            }

            int cacheDuration = Int32.Parse(WebConfigurationManager.AppSettings["DefaultCacheDuration"]);

            HttpRuntime.Cache.Insert(cacheKey, alarms, null, Cache.NoAbsoluteExpiration, TimeSpan.FromSeconds(cacheDuration), CacheItemPriority.Default, null);
            return(alarms);
        }
示例#14
0
        /// <summary>
        /// Add data to cache.
        /// </summary>
        private List <Report012Entity> AddDataToCache()
        {
            var userData = UserData;
            var cacheKey = WebUtility.GetCacheKeyName(userData, "kpi-report-012");

            HttpRuntime.Cache.Remove(cacheKey);

            var lscs = new List <LscUserInfo>();

            if (LscsComboBox.SelectedIndex > 0)
            {
                var ids = WebUtility.ItemSplit(LscsComboBox.SelectedItem.Value);
                if (ids.Length == 2)
                {
                    var lscId   = Int32.Parse(ids[0]);
                    var groupId = Int32.Parse(ids[1]);
                    var lscUser = userData.LscUsers.Find(lu => { return(lu.LscID == lscId); });
                    if (lscUser != null)
                    {
                        lscs.Add(lscUser);
                    }
                }
            }
            else
            {
                lscs.AddRange(userData.LscUsers);
            }
            if (lscs.Count == 0)
            {
                return(null);
            }

            var fromTime = DateTime.Parse(BeginFromDate.Text);
            var toTime   = DateTime.Parse(BeginToDate.Text);

            var auxSets    = new List <String>();
            var texts      = new List <String>();
            var filterText = WebUtility.StringSplit(NodeText.Text.Trim());

            foreach (var ft in filterText)
            {
                if (String.IsNullOrEmpty(ft.Trim()))
                {
                    continue;
                }
                if (FilterList.SelectedItem.Value.Equals("1"))
                {
                    auxSets.Add(ft.Trim());
                }
                else
                {
                    texts.Add(ft.Trim());
                }
            }
            if (texts.Count == 0 && auxSets.Count == 0)
            {
                return(null);
            }

            var staTypes = new Dictionary <Int32, String>();

            foreach (var dt in StaTypeMultiCombo.SelectedItems)
            {
                staTypes[Int32.Parse(dt.Value)] = dt.Text;
            }
            if (staTypes.Count == 0)
            {
                return(null);
            }

            var devTypes = new Dictionary <Int32, String>();

            foreach (var dt in DevTypeMultiCombo.SelectedItems)
            {
                devTypes[Int32.Parse(dt.Value)] = dt.Text;
            }
            if (devTypes.Count == 0)
            {
                return(null);
            }

            var almNames = new List <String>();
            var almIds   = new Dictionary <String, String>();
            var almText  = WebUtility.StringSplit(AlarmNameText.Text.Trim());

            foreach (var at in almText)
            {
                if (String.IsNullOrEmpty(at.Trim()))
                {
                    continue;
                }
                if (AlmNameList.SelectedItem.Value.Equals("1"))
                {
                    almIds[at.Trim()] = null;
                }
                else
                {
                    almNames.Add(at.Trim());
                }
            }

            var nodeEntity  = new BNode();
            var otherEntity = new BOther();
            var alarmEntity = new BAlarm();
            var result      = new List <Report012Entity>();

            foreach (var lsc in lscs)
            {
                var devices = otherEntity.GetDevices(lsc.LscID, lsc.Group.GroupID).FindAll(d => staTypes.ContainsKey(d.StaTypeID) && devTypes.ContainsKey(d.DevTypeID));
                var nodes   = nodeEntity.GetNodes(lsc.LscID, EnmNodeType.Aic, texts.ToArray(), auxSets.ToArray(), null);

                var nnodes = from node in nodes
                             join dev in devices on node.DevID equals dev.DevID
                             select node;

                var alarms = WebUtility.GetUserAlarms(userData).FindAll(alarm => alarm.LscID == lsc.LscID && alarm.StartTime >= fromTime && alarm.StartTime <= toTime);
                alarms.AddRange(alarmEntity.GetHisAlarms(lsc.LscID, lsc.LscName, userData.StandardProtocol, lsc.Group.GroupNodes, fromTime, toTime));

                var nalm = from alarm in alarms
                           join nns in nnodes on new { alarm.NodeID, alarm.NodeType } equals new { nns.NodeID, nns.NodeType }
                where (alarm.AlarmLevel == EnmAlarmLevel.Hint) && (almNames.Count == 0 || almNames.Any(name => alarm.AlarmName.Contains(name))) && (almIds.Count == 0 || almIds.ContainsKey(alarm.AlarmID.ToString())) && string.IsNullOrEmpty(alarm.ProjName)
                select alarm;

                result.Add(new Report012Entity {
                    LscID     = lsc.LscID,
                    LscName   = lsc.LscName,
                    BeginTime = fromTime,
                    EndTime   = toTime,
                    Devices   = devices,
                    Alarms    = nalm.Any() ? nalm.ToList() : new List <AlarmInfo>()
                });
            }

            if (result.Count > 0)
            {
                result.Add(new Report012Entity {
                    LscID     = -100,
                    LscName   = "汇总(平均值)",
                    BeginTime = fromTime,
                    EndTime   = toTime,
                    Devices   = new List <DeviceInfo>(),
                    Alarms    = new List <AlarmInfo>()
                });
            }

            int cacheDuration = Int32.Parse(WebConfigurationManager.AppSettings["DefaultCacheDuration"]);

            HttpRuntime.Cache.Insert(cacheKey, result, null, Cache.NoAbsoluteExpiration, TimeSpan.FromSeconds(cacheDuration), CacheItemPriority.Default, null);
            return(result);
        }