//历史数据 查询
public static DataTable GetHistoricData(DateTime TheBegin, DateTime TheEnd, string tableName)
{
string begin = TheBegin.ToString("yyyy-MM-dd HH:mm:ss");
string end = TheEnd.ToString("yyyy-MM-dd HH:mm:ss");
string sql = string.Format("select * from {0} where ( Dtime>#{1}# and Dtime<#{2}# ) order by Dtime", tableName, begin, end);
return(AccessDbHelper.ExecuteSql_GetTable(sql));
}
//历史事件 查询
public static DataTable GetAlermHistoricEvent(DateTime BeginTime, DateTime EndTime)
{
string begin = BeginTime.ToString("yyyy-MM-dd HH:mm:ss");
string end = EndTime.ToString("yyyy-MM-dd HH:mm:ss");
string sql = string.Format("select * from Alarm_History_Table where ( SaveTime>#{0}# and SaveTime<#{1}# ) order by SaveTime desc", begin, end);
DataTable AlarmTable = AccessDbHelper.ExecuteSql_GetTable(sql);
if (AlarmTable != null && AlarmTable.Columns.Count > 0)
{
//移除不相关的列
AlarmTable.Columns.Remove("KeyId");
//修改表格 列名
AlarmTable.Columns["MessageStr"].ColumnName = Model_Data.Language.Desc.EventInfo;
AlarmTable.Columns["SaveTime"].ColumnName = Model_Data.Language.Desc.EventTime;
}
return(AlarmTable);
}