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);
}
}
