/// <summary> /// Submit Nodes /// </summary> protected void SubmitNodes(object sender, SubmitEventArgs e) { try { var columns = new List <ACVFilterInfo>(); foreach (var sNode in e.RootNode.Children) { var column = new ACVFilterInfo(); column.ColName = sNode.Text; column.FilterItem = sNode.Attributes["filterItem"].ToString(); var filterType = Int32.Parse(sNode.Attributes["filterType"].ToString()); column.FilterType = Enum.IsDefined(typeof(EnmActiveValuesFiteType), filterType) ? (EnmActiveValuesFiteType)filterType : EnmActiveValuesFiteType.NodeName; var nodeType = Int32.Parse(sNode.Attributes["vNodeType"].ToString()); column.NodeType = Enum.IsDefined(typeof(EnmNodeType), nodeType) ? (EnmNodeType)nodeType : EnmNodeType.Null; column.DevName = sNode.Attributes["devName"].ToString(); column.IsNew = Boolean.Parse(sNode.Attributes["isNew"].ToString()); columns.Add(column); } if (columns.Count > 0 && LscsComboBox.SelectedItem != null) { var nodeId = LscsComboBox.SelectedItem.Value; var ids = WebUtility.ItemSplit(nodeId); if (ids.Length != 2) { WebUtility.ShowNotify(EnmErrType.Warning, "获取客户端参数时发生错误,数据保存失败!"); return; } var lscId = Int32.Parse(ids[0]); var groupId = Int32.Parse(ids[1]); var lscEntity = new BLsc(); var lsc = lscEntity.GetLsc(lscId); if (lsc == null) { WebUtility.ShowNotify(EnmErrType.Warning, "无法获取客户端信息,数据保存失败!"); return; } var userData = UserData; var lscUser = userData.LscUsers.Find(lui => { return(lui.LscID == lsc.LscID); }); if (lscUser == null) { WebUtility.ShowNotify(EnmErrType.Warning, "无法获取用户信息,数据保存失败!"); return; } var connectionString = WebUtility.CreateLscConnectionString(lsc); var reportSettingEntity = new BSetting(); columns = reportSettingEntity.UpdateLSCActiveValuesFilterCols(connectionString, lscUser.UID, columns); reportSettingEntity.UpdateCSCActiveValuesFilterCols(lscUser.LscID, lscUser.UID, columns); lscUser.ActiveValuesFiterItem = columns; WebUtility.ShowNotify(EnmErrType.Info, "数据已保存成功!"); } } catch (Exception err) { WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name); WebUtility.ShowMessage(EnmErrType.Error, err.Message); } }
/// <summary> /// UDGSettingWestPanelSubmitNodes /// </summary> protected void UDGSettingWestPanelSubmitNodes(object sender, SubmitEventArgs e) { try { var lscId = LscID; var udGroupID = UDGroupID; var lscEntity = new BLsc(); var lsc = lscEntity.GetLsc(lscId); if (lsc == null) { WebUtility.ShowNotify(EnmErrType.Warning, "无法获取客户端信息,数据保存失败!"); return; } var userData = UserData; var lscUser = userData.LscUsers.Find(lu => { return(lu.LscID == lsc.LscID); }); if (lscUser == null) { WebUtility.ShowNotify(EnmErrType.Warning, "无法获取用户信息,数据保存失败!"); return; } var cacheKey = WebUtility.GetCacheKeyName(userData, "udg-setting-devs"); var devNodes = HttpRuntime.Cache[cacheKey] as List <GroupTreeInfo>; if (devNodes == null) { WebUtility.ShowNotify(EnmErrType.Warning, "无法获取关联设备,数据保存失败!"); return; } var group = new UDGroupInfo(); group.LscID = lscId; group.UserID = lscUser.UserID; group.UDGroupID = udGroupID; group.UDGroupName = UDGroupName.Text; group.UDGroupNodes = new List <UDGroupTreeInfo>(); group.Enabled = true; AddUDGSettingWestPanelSubmitNodes(devNodes, group, e.RootNode); var groupEntity = new BGroup(); string connectionString = WebUtility.CreateLscConnectionString(lsc); group = groupEntity.SaveLSCUDGroupTreeNodes(connectionString, group); groupEntity.SaveCSCUDGroupTreeNodes(group); lscUser.UDGroups.RemoveAll(udg => { return(udg.UDGroupID == group.UDGroupID); }); lscUser.UDGroups.Add(group); UDGroupID = group.UDGroupID; WebUtility.ShowNotify(EnmErrType.Info, "数据已保存成功!"); } catch (Exception err) { WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name); WebUtility.ShowMessage(EnmErrType.Error, err.Message); } }
public string GetLscStates() { var userData = UserData; var lscEntity = new BLsc(); var newStates = new List <LscInfo>(); foreach (var lscUser in userData.LscUsers) { var lsc = lscEntity.GetLsc(lscUser.LscID); if (lsc == null) { continue; } if (lsc.Connected) { continue; } newStates.Add(lsc); } if (newStates.Count == 0) { Session.Remove("LscStates"); return(string.Empty); } var oldStates = new List <LscInfo>(); if (Session["LscStates"] != null) { oldStates = Newtonsoft.Json.JsonConvert.DeserializeObject <List <LscInfo> >(Session["LscStates"].ToString()); } var messages = new List <string>(); var show = false; foreach (var dc in newStates.OrderByDescending(d => d.ChangedTime)) { if (!oldStates.Any(o => o.LscID == dc.LscID && o.ChangedTime == dc.ChangedTime)) { show = true; } messages.Add(string.Format("{0}<br/>[{1}] 服务器通信中断", WebUtility.GetDateString(dc.ChangedTime), dc.LscName)); } Session["LscStates"] = Newtonsoft.Json.JsonConvert.SerializeObject(newStates); return(show ? Newtonsoft.Json.JsonConvert.SerializeObject(messages) : string.Empty); }
public void UpdateMarker(int olscId, int ostaId, int lscId, int staId, int mapType, double lng, double lat, string address) { try { var lscEntity = new BLsc(); var lsc = lscEntity.GetLsc(lscId); if (lsc == null) { WebUtility.ShowNotify(EnmErrType.Warning, "无法获取客户端信息,数据更新失败!"); return; } var otherEntity = new BOther(); var enmMapType = Enum.IsDefined(typeof(EnmMapType), mapType) ? (EnmMapType)mapType : EnmMapType.GPS; var connectionString = WebUtility.CreateLscConnectionString(lsc); otherEntity.UpdateMarker(olscId, ostaId, lscId, staId, enmMapType, lng, lat, address); otherEntity.UpdateLocalMarker(connectionString, ostaId, staId, enmMapType, lng, lat, address); } catch (Exception err) { WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name); WebUtility.ShowMessage(EnmErrType.Error, err.Message); } }
/// <summary> /// Add data to cache. /// </summary> private List <Report113Entity> AddDataToCache() { var userData = UserData; var cacheKey1 = WebUtility.GetCacheKeyName(userData, "kpi-report-113"); var cacheKey2 = WebUtility.GetCacheKeyName(userData, "kpi-report-113-02"); HttpRuntime.Cache.Remove(cacheKey1); HttpRuntime.Cache.Remove(cacheKey2); var lscIds = new List <int>(); 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]); lscIds.Add(lscId); } } else { lscIds.AddRange(userData.LscUsers.Select(l => l.LscID)); } if (lscIds.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 otherEntity = new BOther(); var lscEntity = new BLsc(); var source1 = new List <Report113Entity>(); var source2 = new Dictionary <String, List <DeviceInfo> >(); 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(otherEntity.GetLscParam()); } foreach (var id in lscIds) { var lsc = lscEntity.GetLsc(id); if (lsc == null) { continue; } var devices1 = otherEntity.GetDevices(lsc.LscID).FindAll(d => staTypes.ContainsKey(d.StaTypeID) && devTypes.ContainsKey(d.DevTypeID)); var devices2 = Report113Entity.GetDevices(lsc.LscID, lsc.LscName, WebUtility.CreateLscConnectionString(lsc)); var record = new Report113Entity { LscID = lsc.LscID, LscName = lsc.LscName, ThisCount = devices1.Count, LastCount = devices2.Count }; if (virtualData) { var parm = lscParms.Find(l => l.LscID == lsc.LscID); if (parm != null && parm.ElecDevTNumber != WebUtility.DefaultInt32) { record.ThisCount = parm.ElecDevTNumber; } } source1.Add(record); source2[String.Format("{0}-ThisCount", lsc.LscID)] = devices1; source2[String.Format("{0}-LastCount", lsc.LscID)] = devices2; } if (source1.Count > 0) { source1.Add(new Report113Entity { 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); }
/// <summary> /// Add data to cache. /// </summary> private List <Report014Entity> AddDataToCache() { var userData = UserData; var cacheKey = WebUtility.GetCacheKeyName(userData, "kpi-report-014"); HttpRuntime.Cache.Remove(cacheKey); var lscIds = new List <int>(); 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]); lscIds.Add(lscId); } } else { lscIds.AddRange(userData.LscUsers.Select(l => l.LscID)); } if (lscIds.Count == 0) { return(null); } var lscEntity = new BLsc(); var result = new List <Report014Entity>(); foreach (var id in lscIds) { var lsc = lscEntity.GetLsc(id); if (lsc == null) { continue; } var parm = Report014Entity.GetLscParam(lsc.LscID, WebUtility.CreateLscConnectionString(lsc)); var record = new Report014Entity { LscID = lsc.LscID, LscName = lsc.LscName, ThisCount = parm != null ? parm.StaMNumber : 0, LastCount = parm != null ? parm.StaTNumber : 0, }; result.Add(record); } if (result.Count > 0) { result.Add(new Report014Entity { LscID = -100, LscName = "汇总(平均值)", ThisCount = (Int32)result.Average(r => r.ThisCount), LastCount = (Int32)result.Average(r => r.LastCount) }); } var cacheDuration = Int32.Parse(WebConfigurationManager.AppSettings["DefaultCacheDuration"]); HttpRuntime.Cache.Insert(cacheKey, result, null, Cache.NoAbsoluteExpiration, TimeSpan.FromSeconds(cacheDuration), CacheItemPriority.Default, null); return(result); }
/// <summary> /// Add data to cache. /// </summary> private List <Report117Entity> AddDataToCache() { var userData = UserData; var cacheKey1 = WebUtility.GetCacheKeyName(userData, "kpi-report-117"); var cacheKey2 = WebUtility.GetCacheKeyName(userData, "kpi-report-117-02"); HttpRuntime.Cache.Remove(cacheKey1); HttpRuntime.Cache.Remove(cacheKey2); var lscIds = new List <int>(); 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]); lscIds.Add(lscId); } } else { lscIds.AddRange(userData.LscUsers.Select(l => l.LscID)); } if (lscIds.Count == 0) { return(null); } var fromTime = DateTime.Parse(BeginFromDate.Text); var toTime = DateTime.Parse(BeginToDate.Text); 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 otherEntity = new BOther(); var lscEntity = new BLsc(); var source1 = new List <Report117Entity>(); var source2 = new Dictionary <String, List <StationInfo> >(); foreach (var id in lscIds) { var lsc = lscEntity.GetLsc(id); if (lsc == null) { continue; } var stations = new Dictionary <Int32, String>(); var bats = otherEntity.GetBatStaticCount(lsc.LscID, fromTime, toTime, null, null, 1d / 24d, Int32.MaxValue); if (bats != null && bats.Count > 0) { var devices = otherEntity.GetDevices(lsc.LscID).FindAll(d => staTypes.ContainsKey(d.StaTypeID) && devTypes.ContainsKey(d.DevTypeID)); var temp = from dev in devices join bat in bats on new { dev.LscID, dev.DevID } equals new { LscID = bat.ID, DevID = bat.Value } select dev; foreach (var t in temp) { stations[t.StaID] = t.StaName; } } var stations1 = otherEntity.GetStations(lsc.LscID).FindAll(s => stations.ContainsKey(s.StaID)); var stations2 = Report117Entity.GetStations(lsc.LscID, lsc.LscName, WebUtility.CreateLscConnectionString(lsc)); var record = new Report117Entity { LscID = lsc.LscID, LscName = lsc.LscName, ThisCount = stations1.Count, LastCount = stations2.Count }; source1.Add(record); source2[String.Format("{0}-ThisCount", lsc.LscID)] = stations1; source2[String.Format("{0}-LastCount", lsc.LscID)] = stations2; } if (source1.Count > 0) { source1.Add(new Report117Entity { 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); }
/// <summary> /// Add Events To Cache /// </summary> /// <returns>Operating Events</returns> private List <AcEventInfo> AddEventsToCache() { var userData = UserData; var cacheKey = WebUtility.GetCacheKeyName(userData, "netking-events"); HttpRuntime.Cache.Remove(cacheKey); var lscIds = new List <int>(); 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]); lscIds.Add(lscId); } } else { lscIds.AddRange(userData.LscUsers.Select(l => l.LscID)); } if (lscIds.Count == 0) { return(null); } var types = new Dictionary <Int32, String>(); foreach (var dt in EventTypeMultiCombo.SelectedItems) { types[Int32.Parse(dt.Value)] = dt.Text; } var ctype = Convert.ToInt32(CountTypeComboBox.SelectedItem.Value); var fromTime = DateTime.Parse(FromDate.Text); var toTime = DateTime.Parse(ToDate.Text); var lscEntity = new BLsc(); var otherEntity = new BOther(); var result = new List <AcEventInfo>(); foreach (var id in lscIds) { var lsc = lscEntity.GetLsc(id); if (lsc == null) { continue; } List <AcEventInfo> temp = null; switch (ctype) { case 0: temp = otherEntity.GetPubAlertEvent(lsc.LscID, lsc.LscName, WebUtility.CreateLscConnectionString(lsc), fromTime, toTime); break; case 1: temp = otherEntity.GetPubGeneralEvent(lsc.LscID, lsc.LscName, WebUtility.CreateLscConnectionString(lsc), fromTime, toTime); break; case 2: temp = otherEntity.GetPubInvalidCardEvent(lsc.LscID, lsc.LscName, WebUtility.CreateLscConnectionString(lsc), fromTime, toTime); break; case 3: temp = otherEntity.GetPubValidCardEvent(lsc.LscID, lsc.LscName, WebUtility.CreateLscConnectionString(lsc), fromTime, toTime); break; default: break; } if (temp != null) { if (types.Count > 0) { temp = temp.FindAll(t => types.ContainsKey(t.MessageID)); } result.AddRange(temp); } } var cacheDuration = Int32.Parse(WebConfigurationManager.AppSettings["DefaultCacheDuration"]); HttpRuntime.Cache.Insert(cacheKey, result, null, Cache.NoAbsoluteExpiration, TimeSpan.FromSeconds(cacheDuration), CacheItemPriority.Default, null); return(result); }
protected void gvLsc_RowCommand(object sender, GridViewCommandEventArgs e) { try { if (String.IsNullOrEmpty(e.CommandArgument.ToString())) { return; } var lscId = Int32.Parse(e.CommandArgument.ToString()); var lscEntity = new BLsc(); switch (e.CommandName) { case "Select": LscIDTextBox.Text = String.Empty; LscNameTextBox.Text = String.Empty; LscIPTextBox.Text = String.Empty; LscPortTextBox.Text = String.Empty; LscUIDTextBox.Text = String.Empty; LscPwdTextBox.Attributes["value"] = String.Empty; BeatIntervalTextBox.Text = String.Empty; BeatDelayTextBox.Text = String.Empty; DBIPTextBox.Text = String.Empty; DBPortTextBox.Text = String.Empty; DBNameTextBox.Text = String.Empty; DBUIDTextBox.Text = String.Empty; DBPwdTextBox.Attributes["value"] = String.Empty; HisDBIPTextBox.Text = String.Empty; HisDBPortTextBox.Text = String.Empty; HisDBNameTextBox.Text = String.Empty; HisDBUIDTextBox.Text = String.Empty; HisDBPwdTextBox.Attributes["value"] = String.Empty; EnabledCheckBox.Checked = false; LscIDTextBox.Enabled = false; TitleLabel.Text = "编辑记录"; UpdateBtn.Visible = true; SaveBtn.Visible = false; var lsc = lscEntity.GetLsc(lscId); if (lsc != null) { LscIDTextBox.Text = lsc.LscID.ToString(); LscNameTextBox.Text = lsc.LscName; LscIPTextBox.Text = lsc.LscIP; LscPortTextBox.Text = lsc.LscPort.ToString(); LscUIDTextBox.Text = lsc.LscUID; LscPwdTextBox.Attributes["value"] = lsc.LscPwd; BeatIntervalTextBox.Text = lsc.BeatInterval.ToString(); BeatDelayTextBox.Text = lsc.BeatDelay.ToString(); DBIPTextBox.Text = lsc.DBServer; DBPortTextBox.Text = lsc.DBPort.ToString(); DBNameTextBox.Text = lsc.DBName; DBUIDTextBox.Text = lsc.DBUID; DBPwdTextBox.Attributes["value"] = lsc.DBPwd; HisDBIPTextBox.Text = lsc.HisDBServer; HisDBPortTextBox.Text = lsc.HisDBPort.ToString(); HisDBNameTextBox.Text = lsc.HisDBName; HisDBUIDTextBox.Text = lsc.HisDBUID; HisDBPwdTextBox.Attributes["value"] = lsc.HisDBPwd; EnabledCheckBox.Checked = lsc.Enabled; } ModalPopupExtender.Show(); break; case "Del": lscEntity.DelLsc(lscId); var lscs = lscEntity.GetLscs(); gvLsc.DataSource = lscs; gvLsc.SelectedIndex = -1; gvLsc.DataBind(); break; default: break; } } catch (Exception err) { handleError(err.Message); } }
/// <summary> /// Add data to cache. /// </summary> private List <Report110Entity> AddDataToCache() { var userData = UserData; var cacheKey1 = WebUtility.GetCacheKeyName(userData, "kpi-report-110"); var cacheKey2 = WebUtility.GetCacheKeyName(userData, "kpi-report-110-02"); HttpRuntime.Cache.Remove(cacheKey1); HttpRuntime.Cache.Remove(cacheKey2); var lscIds = new List <int>(); 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]); lscIds.Add(lscId); } } else { lscIds.AddRange(userData.LscUsers.Select(l => l.LscID)); } if (lscIds.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(BeginDate.Text); var toTime = DateTime.Parse(EndDate.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 lscEntity = new BLsc(); var nodeEntity = new BNode(); var source1 = new List <Report110Entity>(); var source2 = new Dictionary <String, List <StationInfo> >(); foreach (var id in lscIds) { var lsc = lscEntity.GetLsc(id); if (lsc == null) { continue; } //var instance = new Dictionary<string, NodeInfo>(); //var nodes = nodeEntity.GetNodes(lsc.LscID, EnmNodeType.Aic, texts.ToArray(), auxSets.ToArray(), null); //foreach (var node in nodes) { // instance[String.Format("{0}-{1}", node.LscID, node.StaID)] = node; //} var stations = new BOther().GetStations(lsc.LscID).FindAll(s => staTypes.ContainsKey(s.StaTypeID)); var values = nodeEntity.GetMaxHisAIV(lsc.LscID, fromTime, toTime); //var temp = from n in instance.Values // join s in stations on new { n.LscID, n.StaID } equals new { s.LscID,s.StaID} // join v in values on new { n.LscID, n.NodeID } equals new { v.LscID, v.NodeID } // select new { // Station = s, // Node = n, // Value = v.Value // }; var temp = from s in stations join v in values on new { s.LscID, s.StaID } equals new { v.LscID, StaID = v.NodeID } select new { Station = s, Value = v.Value }; var correct = temp.Where(n => n.Value >= 1); source2[String.Format("{0}-CorrectCount", source1.Count)] = correct.Any() ? correct.Select(n => n.Station).ToList() : new List <StationInfo>(); source2[String.Format("{0}-AllCount", source1.Count)] = temp.Any() ? temp.Select(n => n.Station).ToList() : new List <StationInfo>(); source1.Add(new Report110Entity { LscID = lsc.LscID, LscName = lsc.LscName, CorrectCount = correct.Count(), AllCount = temp.Count() }); } 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); }
/// <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); }
/// <summary> /// Add data to cache. /// </summary> private List <Report010Entity> AddDataToCache() { var userData = UserData; var cacheKey = WebUtility.GetCacheKeyName(userData, "kpi-report-010"); HttpRuntime.Cache.Remove(cacheKey); var lscIds = new List <int>(); 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]); lscIds.Add(lscId); } } else { lscIds.AddRange(userData.LscUsers.Select(l => l.LscID)); } if (lscIds.Count == 0) { return(null); } var fromTime = DateTime.Parse(BeginFromDate.Text); var toTime = DateTime.Parse(BeginToDate.Text); 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 lscEntity = new BLsc(); var otherEntity = new BOther(); var result = new List <Report010Entity>(); foreach (var id in lscIds) { var lsc = lscEntity.GetLsc(id); if (lsc == null) { continue; } var bats = otherEntity.GetBatStaticCount(lsc.LscID, fromTime, toTime, null, null, 1d / 24d, Int32.MaxValue); var devices = otherEntity.GetDevices(lsc.LscID).FindAll(d => devTypes.ContainsKey(d.AlmDevTypeID)); var batDev = from dev in devices join bat in bats on new { dev.DevID } equals new { DevID = bat.Value } select dev; var parm = Report010Entity.GetLscParam(lsc.LscID, WebUtility.CreateLscConnectionString(lsc)); result.Add(new Report010Entity { LscID = lsc.LscID, LscName = lsc.LscName, ThisCount = batDev == null ? 0 : (fRadio.Checked ? batDev.GroupBy(d => d.StaID).Count() : batDev.GroupBy(d => d.Area3ID).Count()), LastCount = parm != null ? parm.StaTNumber : 0 }); } if (result.Count > 0) { result.Add(new Report010Entity { 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); }
/// <summary> /// Add data to cache. /// </summary> private List <Report007Entity> AddDataToCache() { var userData = UserData; var cacheKey = WebUtility.GetCacheKeyName(userData, "kpi-report-007"); HttpRuntime.Cache.Remove(cacheKey); var lscIds = new List <int>(); 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]); lscIds.Add(lscId); } } else { lscIds.AddRange(userData.LscUsers.Select(l => l.LscID)); } if (lscIds.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 lscEntity = new BLsc(); var otherEntity = new BOther(); var result = new List <Report007Entity>(); foreach (var id in lscIds) { var lsc = lscEntity.GetLsc(id); if (lsc == null) { continue; } var devices = otherEntity.GetDevices(lsc.LscID).FindAll(d => devTypes.ContainsKey(d.AlmDevTypeID)); var parm = Report007Entity.GetLscParam(lsc.LscID, WebUtility.CreateLscConnectionString(lsc)); result.Add(new Report007Entity { LscID = lsc.LscID, LscName = lsc.LscName, ThisCount = devices.Count, LastCount = parm != null && parm.ElecDevTNumber != WebUtility.DefaultInt32 ? parm.ElecDevTNumber : 0 }); } if (result.Count > 0) { result.Add(new Report007Entity { 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); }
/// <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); }