protected void OnStoreRefresh(object sender, StoreRefreshDataEventArgs e) { try { var start = Int32.Parse(e.Parameters["start"]); var limit = Int32.Parse(e.Parameters["limit"]); var end = start + limit; var data = new List <object>(limit); var userData = UserData; var cacheKey = WebUtility.GetCacheKeyName(userData, "energy-detail-data"); var details = HttpRuntime.Cache[cacheKey] as List <EnergyDetailInfo>; if (details == null) { details = AddDataToCache(); } if (details != null && details.Count > 0) { if (end > details.Count) { end = details.Count; } for (int i = start; i < end; i++) { data.Add(details[i]); } } e.Total = (details != null ? details.Count : 0); MainStore.DataSource = data; MainStore.DataBind(); } catch (Exception err) { WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name); WebUtility.ShowMessage(EnmErrType.Error, err.Message); } }
/// <summary> /// Store Refresh /// </summary> protected void OnMainStoreRefresh(object sender, StoreRefreshDataEventArgs e) { try { var start = Int32.Parse(e.Parameters["start"]); var limit = Int32.Parse(e.Parameters["limit"]); var end = start + limit; var data = new List <object>(limit); var cacheKey = WebUtility.GetCacheKeyName(UserData, "kpi-report-002"); var result = HttpRuntime.Cache[cacheKey] as List <Report002Entity>; if (result == null) { result = AddDataToCache(); } if (result != null && result.Count > 0) { if (end > result.Count) { end = result.Count; } for (int i = start; i < end; i++) { var devcnt = 0; var fm = 0d; var interval = 0d; var pinterval = 0d; if (result[i].LscID == -100) { devcnt = result.Sum(r => r.Devices.Count) / (result.Count - 1); fm = devcnt * result[i].EndTime.Subtract(result[i].BeginTime).TotalMinutes; interval = result.Sum(r => r.Alarms.Sum(alarm => (alarm.EndTime == WebUtility.DefaultDateTime ? result[i].EndTime : alarm.EndTime).Subtract(alarm.StartTime).TotalMinutes)) / (result.Count - 1); pinterval = result.Sum(r => r.PAlarms.Sum(alarm => (alarm.EndTime == WebUtility.DefaultDateTime ? result[i].EndTime : alarm.EndTime).Subtract(alarm.StartTime).TotalMinutes)) / (result.Count - 1); } else { devcnt = result[i].Devices.Count; fm = devcnt * result[i].EndTime.Subtract(result[i].BeginTime).TotalMinutes; interval = result[i].Alarms.Sum(alarm => (alarm.EndTime == WebUtility.DefaultDateTime ? result[i].EndTime : alarm.EndTime).Subtract(alarm.StartTime).TotalMinutes); pinterval = result[i].PAlarms.Sum(alarm => (alarm.EndTime == WebUtility.DefaultDateTime ? result[i].EndTime : alarm.EndTime).Subtract(alarm.StartTime).TotalMinutes); } data.Add(new { ID = i + 1, LscID = result[i].LscID, LscName = result[i].LscName, DevCnt = devcnt, Interval = Math.Round(interval, 2), PInterval = Math.Round(pinterval, 2), Rate = String.Format("{0:P2}", fm != 0 ? (1 - (interval + pinterval) / fm) : 1) }); } } e.Total = (result != null ? result.Count : 0); MainStore.DataSource = data; MainStore.DataBind(); } catch (Exception err) { WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name); WebUtility.ShowMessage(EnmErrType.Error, err.Message); } }
/// <summary> /// Store Refresh /// </summary> protected void OnMainStoreRefresh(object sender, StoreRefreshDataEventArgs e) { try { var start = Int32.Parse(e.Parameters["start"]); var limit = Int32.Parse(e.Parameters["limit"]); var end = start + limit; var data = new List <object>(limit); var cacheKey = WebUtility.GetCacheKeyName(UserData, "kpi-report-106"); var result = HttpRuntime.Cache[cacheKey] as List <Report106Entity>; if (result == null) { result = AddDataToCache(); } if (result != null && result.Count > 0) { if (end > result.Count) { end = result.Count; } for (int i = start; i < end; i++) { var fm = result[i].Nodes.Count * result[i].EndTime.Subtract(result[i].BeginTime).TotalMinutes; var interval = result[i].Alarms.Sum(alarm => (alarm.EndTime == WebUtility.DefaultDateTime || alarm.EndTime > result[i].EndTime ? result[i].EndTime : alarm.EndTime).Subtract(alarm.StartTime).TotalMinutes); data.Add(new { ID = i + 1, LscID = result[i].Station.LscID, LscName = result[i].Station.LscName, Area1Name = result[i].Station.Area1Name, Area2Name = result[i].Station.Area2Name, Area3ID = result[i].Station.Area3ID, Area3Name = result[i].Station.Area3Name, BuildingID = result[i].Station.BuildingID, BuildingName = result[i].Station.BuildingName == WebUtility.DefaultString ? "--" : result[i].Station.BuildingName, NodeCnt = result[i].Nodes.Count, AlarmCnt = result[i].Alarms.Count, Interval = Math.Round(interval, 2), Rate = String.Format("{0:P2}", fm != 0 ? (1 - interval / fm) : 1) }); } } e.Total = (result != null ? result.Count : 0); MainStore.DataSource = data; MainStore.DataBind(); } catch (Exception err) { WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name); WebUtility.ShowMessage(EnmErrType.Error, err.Message); } }
/// <summary> /// Store Refresh /// </summary> protected void OnMainStoreRefresh(object sender, StoreRefreshDataEventArgs e) { try { var start = Int32.Parse(e.Parameters["start"]); var limit = Int32.Parse(e.Parameters["limit"]); var end = start + limit; var data = new List <object>(limit); var cacheKey = WebUtility.GetCacheKeyName(UserData, "kpi-report-102"); var result = HttpRuntime.Cache[cacheKey] as List <Report102Entity>; if (result == null) { result = AddDataToCache(); } if (result != null && result.Count > 0) { if (end > result.Count) { end = result.Count; } for (int i = start; i < end; i++) { data.Add(new { ID = i + 1, LscID = result[i].Station.LscID, LscName = result[i].Station.LscName, Area1Name = result[i].Station.Area1Name, Area2Name = result[i].Station.Area2Name, Area3ID = result[i].Station.Area3ID, Area3Name = result[i].Station.Area3Name, BuildingID = result[i].Station.BuildingID, BuildingName = result[i].Station.BuildingName == WebUtility.DefaultString ? "--" : result[i].Station.BuildingName, FillCapacity = Math.Round(result[i].FillCapacity, 2), CurrentCapacity = Math.Round(result[i].CurrentCapacity, 2), DesignCapacity = result[i].DesignCapacity, RedundanceCapacity = result[i].RedundanceCapacity, Rate = String.Format("{0:P2}", result[i].DesignCapacity - result[i].RedundanceCapacity != 0 ? (result[i].FillCapacity + result[i].CurrentCapacity) / (result[i].DesignCapacity - result[i].RedundanceCapacity) : 1) }); } } e.Total = (result != null ? result.Count : 0); MainStore.DataSource = data; MainStore.DataBind(); } catch (Exception err) { WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name); WebUtility.ShowMessage(EnmErrType.Error, err.Message); } }
/// <summary> /// Store Refresh /// </summary> protected void OnMainStoreRefresh(object sender, StoreRefreshDataEventArgs e) { try { var start = Int32.Parse(e.Parameters["start"]); var limit = Int32.Parse(e.Parameters["limit"]); var end = start + limit; var data = new List <object>(limit); var cacheKey = WebUtility.GetCacheKeyName(UserData, "kpi-oil-engine-report"); var result = HttpRuntime.Cache[cacheKey] as List <OilEngineEntity>; if (result == null) { result = AddDataToCache(); } if (result != null && result.Count > 0) { if (end > result.Count) { end = result.Count; } for (int i = start; i < end; i++) { data.Add(new { ID = i + 1, LscID = result[i].Station.LscID, LscName = result[i].Station.LscName, Area2ID = result[i].Station.Area2ID, Area2Name = result[i].Station.Area2Name, Area3ID = result[i].Station.Area3ID, Area3Name = result[i].Station.Area3Name, StaID = result[i].Station.StaID, StaName = result[i].Station.StaName, PowerOff = result[i].SNodes.Sum(s => s.Divs.Count(d => d.Value == GJ)), OffInterval = result[i].SNodes.Sum(s => s.Interval), PowerOn = result[i].YNodes.Sum(y => y.Divs.Count(d => d.Value == GJ)), OnInterval = result[i].YNodes.Sum(y => y.Interval) }); } } e.Total = (result != null ? result.Count : 0); MainStore.DataSource = data; MainStore.DataBind(); } catch (Exception err) { WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name); WebUtility.ShowMessage(EnmErrType.Error, err.Message); } }
/// <summary> /// Operating Events Refresh /// </summary> protected void OnMainStoreRefresh(object sender, StoreRefreshDataEventArgs e) { try { var start = Int32.Parse(e.Parameters["start"]); var limit = Int32.Parse(e.Parameters["limit"]); var end = start + limit; var data = new List <object>(limit); var cacheKey = WebUtility.GetCacheKeyName(UserData, "netking-events"); var events = HttpRuntime.Cache[cacheKey] as List <AcEventInfo>; if (events == null) { events = AddEventsToCache(); } if (events != null && events.Count > 0) { if (end > events.Count) { end = events.Count; } for (int i = start; i < end; i++) { data.Add(new { ID = i + 1, LscID = events[i].LscId, LscName = events[i].LscName, NetGroupID = events[i].NetGroupID, NetGroupName = events[i].NetGroupName, PointName = events[i].PointName, UserID = events[i].UserID, UserName = events[i].UserName, Department = events[i].Department, MessageID = events[i].MessageID, Message = events[i].Message, EventTime = WebUtility.GetDateString(events[i].EventTime) }); } } e.Total = (events != null ? events.Count : 0); MainStore.DataSource = data; MainStore.DataBind(); } catch (Exception err) { WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name); WebUtility.ShowMessage(EnmErrType.Error, err.Message); } }
/// <summary> /// Grid Refresh /// </summary> protected void OnMainStoreRefresh(object sender, StoreRefreshDataEventArgs e) { try { var start = Int32.Parse(e.Parameters["start"]); var limit = Int32.Parse(e.Parameters["limit"]); var end = start + limit; var data = new List <object>(limit); var cacheKey = WebUtility.GetCacheKeyName(UserData, "projects"); var datas = HttpRuntime.Cache[cacheKey] as List <ProjectInfo>; if (datas == null) { datas = AddDataToCache(); } if (datas != null && datas.Count > 0) { if (end > datas.Count) { end = datas.Count; } for (int i = start; i < end; i++) { data.Add(new { ID = i + 1, LscID = datas[i].LscID, LscName = datas[i].LscName, ProjectId = datas[i].ProjectId, ProjectName = datas[i].ProjectName, BeginTime = WebUtility.GetDateString(datas[i].BeginTime), EndTime = WebUtility.GetDateString(datas[i].EndTime), Responsible = datas[i].Responsible, ContactPhone = datas[i].ContactPhone, Company = datas[i].Company, Comment = datas[i].Comment, Enabled = datas[i].Enabled }); } } e.Total = (datas != null ? datas.Count : 0); MainStore.DataSource = data; MainStore.DataBind(); } catch (Exception err) { WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name); WebUtility.ShowMessage(EnmErrType.Error, err.Message); } }
protected void MainStoreRefresh(object sender, StoreRefreshDataEventArgs e) { try { var start = Int32.Parse(e.Parameters["start"]); var limit = Int32.Parse(e.Parameters["limit"]); var end = start + limit; var length = MainGridPanel.ColumnModel.Columns.Count; var data = CreateCustomizeTable(0); var cacheKey = WebUtility.GetCacheKeyName(UserData, "energy-005-report"); var result = HttpRuntime.Cache[cacheKey] as List <EnergyInfo05>; if (result == null) { result = AddDataToCache(); } if (result != null && result.Count > 0) { if (end > result.Count) { end = result.Count; } data = CreateCustomizeTable(7); for (int i = start; i < end; i++) { var current = result[i]; var row = data.NewRow(); row[0] = current.Period; row[1] = current.A; row[2] = current.B; row[3] = current.AValue; row[4] = current.BValue; row[5] = current.AValue - current.BValue; row[6] = String.Format("{0:P2}", result[i].BValue != 0 ? (result[i].AValue - result[i].BValue) / result[i].BValue : 1); data.Rows.Add(row); } } e.Total = (result != null ? result.Count : 0); MainStore.DataSource = data; MainStore.DataBind(); } catch (Exception err) { WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name); WebUtility.ShowMessage(EnmErrType.Error, err.Message); } }
/// <summary> /// Store Refresh /// </summary> protected void OnMainStoreRefresh(object sender, StoreRefreshDataEventArgs e) { try { var start = Int32.Parse(e.Parameters["start"]); var limit = Int32.Parse(e.Parameters["limit"]); var end = start + limit; var data = new List <object>(limit); var cacheKey = WebUtility.GetCacheKeyName(UserData, "kpi-report-122"); var result = HttpRuntime.Cache[cacheKey] as List <Report122Entity>; if (result == null) { result = AddDataToCache(); } if (result != null && result.Count > 0) { if (end > result.Count) { end = result.Count; } for (int i = start; i < end; i++) { data.Add(new { ID = i + 1, LscID = result[i].LscID, LscName = result[i].LscName, Date = result[i].Date, Count = result[i].Gstations.Count, TotalCount = result[i].Stations.Count, Rate = String.Format("{0:P2}", result[i].Stations.Count != 0 ? (1 - (double)result[i].Gstations.Count / (double)result[i].Stations.Count) : 1) }); } } e.Total = (result != null ? result.Count : 0); MainStore.DataSource = data; MainStore.DataBind(); } catch (Exception err) { WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name); WebUtility.ShowMessage(EnmErrType.Error, err.Message); } }
protected void MainStoreRefresh(object sender, StoreRefreshDataEventArgs e) { try { var start = Int32.Parse(e.Parameters["start"]); var limit = Int32.Parse(e.Parameters["limit"]); var end = start + limit; var data = new List <object>(limit); var cacheKey = WebUtility.GetCacheKeyName(UserData, "energy-003-report"); var result = HttpRuntime.Cache[cacheKey] as List <EnergyInfo03>; if (result == null) { result = AddDataToCache(); } if (result != null && result.Count > 0) { if (end > result.Count) { end = result.Count; } for (int i = start; i < end; i++) { data.Add(new { Key = result[i].Key, Current = result[i].Current, Period = result[i].Period, Value = result[i].Value, TValue = result[i].TValue, CValue = result[i].Value - result[i].TValue, Rate = String.Format("{0:P2}", result[i].TValue != 0 ? (result[i].Value - result[i].TValue) / result[i].TValue : 1) }); } } e.Total = (result != null ? result.Count : 0); MainStore.DataSource = data; MainStore.DataBind(); } catch (Exception err) { WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name); WebUtility.ShowMessage(EnmErrType.Error, err.Message); } }