/// <summary>
/// 获取设备
/// </summary>
/// <param name="decies"></param>
public static void GetDevices(out List <Device> decies)
{
decies = new List <Device>();
if (HaveDb())
{
SQLiteDataReader reader = null;
try
{
string sql = "select * from device";
reader = SqLiteHelper.ExcuteReader(SqLiteHelper.Open(_dbPath), sql);
while (reader.Read())
{
Device device = new Device();
device.Id = EvaluationHelper.ObjectToInt(reader["did"]);
device.Ip = EvaluationHelper.ObjectToString(reader["ip"]);
device.Name = EvaluationHelper.ObjectToString(reader["name"]);
device.Type = EvaluationHelper.ObjectToInt(reader["type"]);
device.IsHaveVideo = EvaluationHelper.ObjectToInt(reader["video"]);
device.Generation = EvaluationHelper.ObjectToInt(reader["generation"]);
device.Extension.Number = EvaluationHelper.ObjectToString(reader["extno"]);
device.PanelNum = EvaluationHelper.ObjectToInt(reader["panelnum"]);
//device.StateString = "离线";
//device.StateString = "通话中";
device.StateString = "空闲";
//device.StateString = "呼叫中";
decies.Add(device);
}
}
catch (Exception ex)
{
LogHelper.MainLog(ex.Message);
}
finally
{
if (reader != null)
{
reader.Close();
}
}
}
}
/// <summary>
/// 获取日志
/// </summary>
/// <param name="type">日志类型</param>
/// <param name="logs"></param>
public static void GetLogs(LogTypeEnum type, out List <LogMessage> logs)
{
logs = new List <LogMessage>();
if (HaveDb())
{
int num = 0;
switch (type)
{
case LogTypeEnum.System: //系统日志10
num = 10;
break;
case LogTypeEnum.Operation: //操作日志11
num = 11;
break;
case LogTypeEnum.Call: //呼叫日志12
num = 12;
break;
case LogTypeEnum.Video: //视频日志13
num = 13;
break;
case LogTypeEnum.Alarm: //报警日志14
num = 14;
break;
case LogTypeEnum.OrdinaryMsg: //普通消息
num = 15;
break;
case LogTypeEnum.MissedCalled: //未接来电16
num = 16;
break;
case LogTypeEnum.PanelMsg: //面板消息17
num = 17;
break;
}
if (num != 0)
{
SQLiteDataReader reader = null;
try
{
string sql = "select * from log where logtype=@type order by RowID DESC";
reader = SqLiteHelper.ExcuteReader(SqLiteHelper.Open(_dbPath), sql, new SQLiteParameter("@type", num));
while (reader.Read())
{
LogMessage log = new LogMessage();
log.LogTime = EvaluationHelper.ObjectToDateTime(reader["logtime"]);
log.LogMsg = EvaluationHelper.ObjectToString(reader["logmsg"]);
log.LogType = EvaluationHelper.ObjectToInt(reader["logtype"]);
log.OperaterId = EvaluationHelper.ObjectToString(reader["username"]);
log.FromNo = EvaluationHelper.ObjectToString(reader["caller"]);
log.PanelNum = EvaluationHelper.ObjectToInt(reader["callpanel"]);
logs.Add(log);
}
}
catch (Exception ex)
{
LogHelper.MainLog(ex.Message);
}
finally
{
if (reader != null)
{
reader.Close();
}
}
}
}
}
