<%@ WebHandler Language="C#" Class="AlarmLogHandler" %>
|
|
using System;
|
using System.Web;
|
using Model;
|
using Dao;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Data;
|
using Common;
|
using System.Text;
|
|
public class AlarmLogHandler : PageHandler<SysUser>
|
{
|
|
public override JsonPageResult ProcessRequestInternal(PageContext<Model.SysUser> context)
|
{
|
string action = context.GetString("action");
|
|
switch (action)
|
{
|
case "getTopAlarmList":
|
return GetTopAlarmList(context);
|
case "getUnrestoredAlarmList":
|
return GetUnrestoredAlarmList(context);
|
case "loadAlarmLogList":
|
return LoadAlarmLogList(context);
|
default:
|
throw new Exception("Invalid Action=" + action);
|
}
|
}
|
|
private GwAlarmDao _Dao = new GwAlarmDao();
|
|
private JsonPageResult LoadAlarmLogList(PageContext<SysUser> context)
|
{
|
int recordCount = 0;
|
int pageSize = context.GetInt("pageSize", 20);
|
int pageIndex = context.GetInt("pageIndex", 1);
|
|
using (GwAlarmDao dao = new GwAlarmDao())
|
{
|
StringBuilder sb = new StringBuilder();
|
|
DataTable table = dao.GetTopAlarmLog(1000, out recordCount, pageIndex, pageSize);
|
|
foreach (DataRow row in table.Rows)
|
{
|
DataRowReader reader = new DataRowReader(row);
|
|
sb.Append("<tr>");
|
|
sb.AppendFormat("<td>{0}</td>", reader.GetString("ALARM_ID"));
|
sb.AppendFormat("<td>{0}</td>", reader.GetString("ALARM_TYPE"));
|
sb.AppendFormat("<td>{0}</td>", reader.GetString("ALARM_CONTENT"));
|
sb.AppendFormat("<td>{0}</td>", reader.GetDateTime("ALARM_TIME").ToString("yy-MM-dd HH:mm:ss"));
|
|
if (reader.GetInt("RESTORE_FLAG") == 1)
|
{
|
sb.AppendFormat("<td>{0}</td>", "<span class='label label-primary'>已经恢复</span>");
|
sb.AppendFormat("<td>{0}</td>", reader.GetDateTime("RESTORE_TIME").ToString("yy-MM-dd HH:mm:ss"));
|
sb.AppendFormat("<td>{0}</td>", reader.GetString("RESTORE_CONTENT"));
|
}
|
else
|
{
|
sb.AppendFormat(@"<td colspan=""3""><span class='label label-warning'>未恢复</span></td>");
|
}
|
|
sb.Append("</tr>");
|
}
|
|
return new JsonPageResult(true, new { Table = sb.ToString(), TotalCount = recordCount });
|
}
|
}
|
|
private JsonPageResult GetUnrestoredAlarmList(PageContext<SysUser> context)
|
{
|
|
return new JsonPageResult(true, _Dao.GetUnrestoredAlarmLog());
|
}
|
|
private JsonPageResult GetTopAlarmList(PageContext<SysUser> context)
|
{
|
return new JsonPageResult(true, _Dao.GetTopAlarmLog(50));
|
}
|
|
public decimal Divide(decimal v, decimal total)
|
{
|
if (total == 0)
|
{
|
return 0;
|
}
|
|
return Math.Round(v / total, 2);
|
}
|
}
|