/// <summary>
/// 根据园区ID获取报警灯配置
/// </summary>
/// <param name="regionId"></param>
/// <returns></returns>
public List <BaseRelayConfigModel> GetAlarmLampByRegion(int regionId)
{
try
{
List <BaseRelayConfigModel> retRelayList = new List <BaseRelayConfigModel>();
BaseRelayConfigModel relay = null;
BaseRegionConfigDAL regionDal = new BaseRegionConfigDAL();
List <BaseRegionConfigModel> regionList = regionDal.GetAllRegionConfig();
List <BaseRelayConfigModel> relayList = relayDal.GetAlarmLampByRegion(regionId);
for (int i = 0; i < relayList.Count; i++)
{
relay = new BaseRelayConfigModel();
relay.control_id = relayList[i].control_id;
relay.ext3 = regionList.Where(n => n.id == relayList[i].region_id).FirstOrDefault() == null ? "" : regionList.Where(n => n.id == relayList[i].region_id).FirstOrDefault().region_code;
relay.id = relayList[i].id;
relay.region_id = relayList[i].region_id;
relay.relay_content = relayList[i].relay_content;
relay.relay_type = relayList[i].relay_type;
retRelayList.Add(relay);
}
return(retRelayList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取资产巡检列表
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="assetType"></param>
/// <param name="regionId"></param>
/// <param name="startTime"></param>
/// <param name="endTime"></param>
/// <param name="totalNumber"></param>
/// <returns></returns>
public List <RetCameraPatrolSchedule> GetAssetInspectionByPage(int pageIndex, int pageSize, int assetType, int regionId, string startTime, string endTime, out int totalNumber)
{
try
{
List <RetCameraPatrolSchedule> retList = new List <RetCameraPatrolSchedule>();
RetCameraPatrolSchedule retModel = null;
AssetInspectionQuery query = new AssetInspectionQuery();
ServScheduleTimeConfigDAL scheduleTimeConfigDal = new ServScheduleTimeConfigDAL();
BaseRegionConfigDAL baseRegionConfigDal = new BaseRegionConfigDAL();
query.assetType = assetType;
query.endTime = endTime;
query.pageIndex = pageIndex;
query.pageSize = pageSize;
query.regionId = regionId;
query.startTime = startTime;
List <ServScheduleModel> list = servScheduleDal.GetAssetInspectionPage(query, out totalNumber);
//获取全部园区配置
List <BaseRegionConfigModel> regionConfigList = baseRegionConfigDal.GetAllRegionConfig();
for (int i = 0; i < list.Count; i++)
{
retModel = new RetCameraPatrolSchedule();
retModel.content = list[i].content;
retModel.create_time = list[i].create_time;
retModel.cronTime = CSM.Utils.TimeExpression.GetCronTimeModel(list[i].period_expression);//生成时间表达式model
retModel.span_time = list[i].span_time;
#region 查询时间配置
ServScheduleTimeConfigQuery timeQuery = new ServScheduleTimeConfigQuery();
timeQuery.schedule_id = list[i].id;
timeQuery.time_type = 1;//查询开始时间
ServScheduleTimeConfigModel timeModel = scheduleTimeConfigDal.GetScheduleTimeConfigByIdAndTimeType(timeQuery).FirstOrDefault();
retModel.start_execute_time = timeModel == null ? "" : timeModel.schedule_time;
retModel.execute_date = timeModel == null ? "" : timeModel.schedule_date;
#endregion
retModel.id = list[i].id;
retModel.end_execute_time = "";
retModel.end_time = list[i].end_time;
retModel.period_expression = list[i].period_expression;
retModel.region_id = list[i].region_id;
retModel.schedule_name = list[i].schedule_name;
retModel.schedule_state = list[i].schedule_state;
retModel.schedule_type = list[i].schedule_type;
retModel.start_time = list[i].start_time;
var regionModel = regionConfigList.Where(n => n.id == list[i].region_id).FirstOrDefault();
retModel.ext10 = regionModel == null ? "" : regionModel.region_name; //备用字段10用于存储园区名称
retModel.ext7 = list[i].end_time > DateTime.Now ? "1" : "2"; //1：未过期，2：过期
retModel.ext9 = retModel.cronTime.describe; //获取表达式描述
retList.Add(retModel);
}
return(retList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取全部园区配置
/// </summary>
/// <returns></returns>
public List <BaseRegionConfigModel> GetAllShowRegion()
{
try
{
BaseRegionConfigDAL baseRegionConfigDal = new BaseRegionConfigDAL();
return(baseRegionConfigDal.GetAllRegionConfig());
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 根据条件查询设备告警
/// </summary>
/// <param name="regionId"></param>
/// <param name="areaId"></param>
/// <param name="alarmLevel"></param>
/// <param name="startTime"></param>
/// <param name="endTime"></param>
/// <param name="eventType"></param>
/// <returns></returns>
public System.IO.MemoryStream GetAllInformAlarmStream(int regionId, int areaId, int alarmLevel, string startTime, string endTime, int eventType)
{
try
{
BaseEventTypeBLL eventTypeBll = new BaseEventTypeBLL();
BaseRegionConfigDAL baseRegionConfigDal = new BaseRegionConfigDAL();
List <RetInformAlarmCustom> retList = new List <RetInformAlarmCustom>();
RetInformAlarmCustom retModel = null;
#region 拼接DataTable列头
System.Data.DataTable table = new System.Data.DataTable();
table.Columns.Add("告警编号");
table.Columns.Add("事件名称");
table.Columns.Add("告警设备");
table.Columns.Add("告警位置");
table.Columns.Add("园区名称");
table.Columns.Add("区域名称");
table.Columns.Add("告警时间");
table.Columns.Add("告警级别");
table.Columns.Add("处理状态");
#endregion
List <BaseRegionConfigModel> regionList = baseRegionConfigDal.GetAllRegionConfig();//获取所有园区配置
DefinedInformAlarmQuery query = new DefinedInformAlarmQuery();
query.alarmLevel = alarmLevel;
query.regionId = regionId;
query.areaId = areaId;
query.startTime = startTime;
query.endTime = endTime;
query.eventType = eventType;
List <InformAlarmCustom> informList = servInformAlarmDal.GetAllInformAlarmCondition(query); //分页获取设备报警记录
for (int i = 0; i < informList.Count; i++)
{
System.Data.DataRow row = table.NewRow();
row["告警编号"] = informList[i].id;
row["事件名称"] = Enum.IsDefined(typeof(EnumClass.DeviceInformAlarmType), informList[i].event_type) ? Enum.GetName(typeof(EnumClass.DeviceInformAlarmType), informList[i].event_type) : " ";
row["告警设备"] = informList[i].device_name;
row["告警位置"] = informList[i].alarm_location;
row["园区名称"] = regionList.Where(n => n.id == informList[i].region_id).FirstOrDefault() == null ? " " : regionList.Where(n => n.id == informList[i].region_id).FirstOrDefault().region_name;
row["区域名称"] = informList[i].area_name;
row["告警时间"] = informList[i].report_time.ToString();
row["告警级别"] = Enum.IsDefined(typeof(EnumClass.AlarmLevel), informList[i].alarm_level) ? Enum.GetName(typeof(EnumClass.AlarmLevel), informList[i].alarm_level) : " ";
row["处理状态"] = Enum.IsDefined(typeof(EnumClass.InformAlarmStatus), informList[i].status) ? Enum.GetName(typeof(EnumClass.InformAlarmStatus), informList[i].status) : " ";
table.Rows.Add(row);
}
System.IO.MemoryStream ms = CSM.Utils.ExcelHelper.DataTableToExcel(table, "sheet2");
return(ms);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 分页获取计划任务结果
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="regionId"></param>
/// <param name="scheduleType"></param>
/// <param name="startTime"></param>
/// <param name="endTime"></param>
/// <param name="totalNumber"></param>
/// <returns></returns>
public List <RetScheduleResult> GetScheduleResultByPage(int pageIndex, int pageSize, int regionId, int scheduleType, string startTime, string endTime, out int totalNumber)
{
try
{
List <RetScheduleResult> retResultList = new List <RetScheduleResult>();
RetScheduleResult retScheduleModel = null;
BaseRegionConfigDAL baseRegionConfigDal = new BaseRegionConfigDAL();
ServScheduleResultQuery query = new ServScheduleResultQuery();
query.endTime = endTime;
query.pageIndex = pageIndex;
query.pageSize = pageSize;
query.regionId = regionId;
query.scheduleType = scheduleType;
query.startTime = startTime;
List <ScheduleResultCustom> scheduleResultList = servScheduleResultDal.GetScheduleResultByPage(query, out totalNumber); //分页获取计划任务结果
List <BaseRegionConfigModel> regionList = baseRegionConfigDal.GetAllRegionConfig(); //获取所有园区配置
for (int i = 0; i < scheduleResultList.Count; i++)
{
retScheduleModel = new RetScheduleResult();
retScheduleModel.create_time = scheduleResultList[i].create_time;
retScheduleModel.end_time = scheduleResultList[i].end_time;
retScheduleModel.start_time = scheduleResultList[i].start_time;
retScheduleModel.id = scheduleResultList[i].id;
retScheduleModel.region_name = regionList.Where(n => n.id == scheduleResultList[i].region_id).FirstOrDefault() == null ? "--" : regionList.Where(n => n.id == scheduleResultList[i].region_id).FirstOrDefault().region_name;
retScheduleModel.result_content = scheduleResultList[i].result_content;
retScheduleModel.result_ext1 = scheduleResultList[i].result_ext1;
retScheduleModel.result_ext2 = scheduleResultList[i].result_ext2;
retScheduleModel.result_ext3 = scheduleResultList[i].result_ext3;
retScheduleModel.result_ext4 = scheduleResultList[i].result_ext4;
retScheduleModel.result_ext5 = scheduleResultList[i].result_ext5;
retScheduleModel.result_time = scheduleResultList[i].result_time;
retScheduleModel.schedule_name = scheduleResultList[i].schedule_name;
retScheduleModel.schedule_state = Enum.GetName(typeof(EnumClass.ScheduleState), scheduleResultList[i].schedule_state);
retScheduleModel.schedule_type = Enum.GetName(typeof(EnumClass.ScheduleType), scheduleResultList[i].schedule_type);
retResultList.Add(retScheduleModel);
}
return(retResultList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取本地园区ID以及名称
/// </summary>
/// <returns></returns>
public List <EnumModel> GetLocalRegion()
{
List <EnumModel> enumList = new List <EnumModel>();
EnumModel enumModel = null;
try
{
BaseRegionConfigDAL baseRegionConfig = new BaseRegionConfigDAL();
List <BaseRegionConfigModel> list = baseRegionConfig.GetBaseRegionConfigByType(0);//获取本地园区配置
foreach (BaseRegionConfigModel model in list)
{
enumModel.key = model.id;
enumModel.value = model.region_name;
enumList.Add(enumModel);
}
return(enumList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 根据查询条件分页获取设备告警
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="regionId"></param>
/// <param name="areaId"></param>
/// <param name="alarmLevel"></param>
/// <param name="startTime"></param>
/// <param name="endTime"></param>
/// <param name="eventType"></param>
/// <param name="totalNumber"></param>
/// <returns></returns>
public List <RetInformAlarmCustom> GetInformAlarmPage(int pageIndex, int pageSize, int regionId, int areaId, int alarmLevel, string startTime, string endTime, int eventType, out int totalNumber)
{
try
{
BaseEventTypeBLL eventTypeBll = new BaseEventTypeBLL();
BaseRegionConfigDAL baseRegionConfigDal = new BaseRegionConfigDAL();
List <RetInformAlarmCustom> retList = new List <RetInformAlarmCustom>();
RetInformAlarmCustom retModel = null;
//List<BaseEventTypeModel> eventTypeList = eventTypeBll.GetAllEventType();//获取所有事件类型
List <BaseRegionConfigModel> regionList = baseRegionConfigDal.GetAllRegionConfig();//获取所有园区配置
//var childEventType = eventTypeList.Where(n => n.pid == eventType);//获取所有PID为eventType的子级事件
//List<int> eventArr = new List<int>();
//if (childEventType != null)
//{
// List<BaseEventTypeModel> childEventTypeList = childEventType.ToList();
// for (int i = 0; i < childEventTypeList.Count(); i++)
// {
// eventArr.Add(childEventTypeList[i].id); //先用List<int>接收
// }
//}
DefinedInformAlarmQuery query = new DefinedInformAlarmQuery();
query.alarmLevel = alarmLevel;
query.regionId = regionId;
query.areaId = areaId;
query.startTime = startTime;
query.endTime = endTime;
//query.eventType = eventArr.Count == 0 ? null : eventArr.ToArray(); //将List<int>转化为数组int[]
query.eventType = eventType;
query.pageIndex = pageIndex;
query.pageSize = pageSize;
List <InformAlarmCustom> informList = servInformAlarmDal.GetInformAlarmPage(query, out totalNumber); //分页获取设备报警记录
for (int i = 0; i < informList.Count; i++)
{
retModel = new RetInformAlarmCustom();
retModel.alarm_level = informList[i].alarm_level;
retModel.alarm_location = informList[i].alarm_location;
retModel.area_id = informList[i].area_id;
retModel.area_name = informList[i].area_name;
retModel.content = informList[i].content;
retModel.device_code = informList[i].device_code;
retModel.device_name = informList[i].device_name;
retModel.event_type = informList[i].event_type;
//var informAlarmEvent = eventTypeList.FirstOrDefault(n => n.id == informList[i].event_type); //查询当前事件
//if (informAlarmEvent.pid == -1) //判断是否是父级事件
//{
// retModel.event_name = informAlarmEvent.event_name;
//}
//else
//{
// var rootEvent = eventTypeList.FirstOrDefault(n => n.id == informAlarmEvent.pid);//查询父级事件，目前事件只保留两级
// if (rootEvent != null) //找到父级事件
// {
// retModel.event_name = rootEvent.event_name;
// }
// else //未找到父级事件
// {
// retModel.event_name = "--";
// }
//}
retModel.event_name = Enum.IsDefined(typeof(EnumClass.DeviceInformAlarmType), informList[i].event_type) ? Enum.GetName(typeof(EnumClass.DeviceInformAlarmType), informList[i].event_type) : "--";
retModel.ext1 = informList[i].ext1;
retModel.ext2 = informList[i].ext2;
retModel.ext3 = informList[i].ext3;
retModel.ext4 = informList[i].ext4;
retModel.ext5 = informList[i].ext5;
retModel.id = informList[i].id;
retModel.region_id = informList[i].region_id;
retModel.region_name = regionList.Where(n => n.id == informList[i].region_id).FirstOrDefault() == null ? "--" : regionList.Where(n => n.id == informList[i].region_id).FirstOrDefault().region_name;
retModel.report_time = informList[i].report_time;
retModel.status = informList[i].status;
retList.Add(retModel);
}
return(retList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 处理报警数据
/// </summary>
/// <param name="alarmRecord"></param>
public void HandlePlan(ServAlarmRecordModel alarmRecord)
{
try
{
ServExecutionTimeDAL executeTimeDal = new ServExecutionTimeDAL();
ServDeviceInfoModel deviceInfo = GetDeviceInfo(alarmRecord.alarm_code);
BaseRegionConfigDAL baseRegionConfigDal = new BaseRegionConfigDAL();
if (deviceInfo != null)
{
BaseRegionConfigModel regionModel = baseRegionConfigDal.GetEntity(deviceInfo.region_id); //获取设备所在园区
int parentEventId = GetParentEvent(alarmRecord.alarm_event); //获取父级事件ID
//查找设备预案
string alarmTime = alarmRecord.alarm_time.ToLocalTime().ToString("HH:mm:ss");
var devicePlans = CheckDevicePlanIsExist(deviceInfo.id, (int)EnumClass.PlanStatus.启用, alarmTime);
DevicePlanAndTimeConfig devicePlan = devicePlans == null ? null : devicePlans.FirstOrDefault(); //目前取第一条设备预案
if (devicePlan != null)
{
#region 检验时间表达式
//if (TimeExpression.TimePointIsExistSpan(alarmRecord.alarm_time.ToLocalTime(), devicePlan.update_time, timeModel.execution_cycle))
//{
//}
//else
//{
// Log4NetHelp.Info("报警时间未在设置周期内，报警时间：" + alarmRecord.alarm_time.ToLocalTime().ToString() + " 开始时间：" + devicePlan.update_time + " 时间表达式：" + timeModel.execution_cycle);
//}
#endregion
List <ServPlanHandleItemModel> planHandleItemList = GetPlanHandleItem(devicePlan.id, (int)EnumClass.PlanType.设备预案, (int)EnumClass.PlanHandleTime.确警前);
if (planHandleItemList != null && planHandleItemList.Count != 0)
{
//执行设备预案，写入预案执行记录
PlanBLL planBll = new PlanBLL();
int planRecordId = planBll.AddPlanRecord(alarmRecord.id, devicePlan.id, (int)EnumClass.PlanType.设备预案);
if (planRecordId > 0)
{
List <ServDeviceInfoModel> camerasList = null;
string ledMessage = "";
HandleDevicePlanItem(planRecordId, parentEventId, regionModel, planHandleItemList, deviceInfo, alarmRecord, out camerasList, out ledMessage);
// Hashtable hash = HandleDevicePlanItem(planRecordId, planHandleItemList, deviceInfo, alarmRecord,out camerasList,out ledMessage);
if (hash != null && hash.Count != 0)
{
WebSocketMsgModel webMsg = new WebSocketMsgModel();
DevicePlanMsgModel devicePlanMsg = new DevicePlanMsgModel();
devicePlanMsg.hash = hash;
devicePlanMsg.alarm = alarmRecord;
devicePlanMsg.deviceInfo = deviceInfo;
// devicePlanMsg.videoTime = GetAlarmVideoTime(alarmRecord.alarm_event);
devicePlanMsg.videoTime = GetAlarmVideoTime(parentEventId);
devicePlanMsg.camerasList = camerasList;
devicePlanMsg.ledMessage = ledMessage; //用于页面显示滚动条信息
// string devicePlanMsgStr = JsonHelper.ObjectToString(devicePlanMsg);
webMsg.info = devicePlanMsg;
webMsg.type = (int)EnumClass.WebSocketMsgType.设备预案;
string param = JsonHelper.ObjectToString(webMsg);
HttpHelper.PostJsonData(SubSystemRouteBLL.GetToWebsocketRoute(), param, Encoding.UTF8);
}
}
}
else
{
//log:未找到相应设备预案处置项
Log4NetHelp.Info("未找到对应设备预案处置项：" + alarmRecord.alarm_code);
}
}
else
{
//log 未找到设备预案或者设备预案未启用
//TODO 查找事件预案
Log4NetHelp.Info("未找到当前时间段内配置的设备预案或者设备预案未启用,继续查找事件预案");
//int parentEventId = GetParentEvent(alarmRecord.alarm_event); //获取父级事件ID
if (parentEventId != -1)
{
var eventPlans = CheckEventPlanIsExist(alarmTime, parentEventId, (int)EnumClass.PlanStatus.启用, regionModel.id);
EventPlanAndTimeConfig eventPlan = eventPlans == null ? null : eventPlans.FirstOrDefault();//目前取第一条设备预案
if (eventPlan != null)
{
List <ServPlanHandleItemModel> planHandleItemList = GetPlanHandleItem(eventPlan.id, (int)EnumClass.PlanType.事件预案, (int)EnumClass.PlanHandleTime.确警前);//获取事件预案处置项
if (planHandleItemList != null && planHandleItemList.Count != 0)
{
//执行事件预案，写入预案执行记录
PlanBLL planBll = new PlanBLL();
int planRecordId = planBll.AddPlanRecord(alarmRecord.id, eventPlan.id, (int)EnumClass.PlanType.事件预案);
if (planRecordId > 0)
{
List <ServDeviceInfoModel> camerasList = null;
string ledMessage = "";
HandleEventPlanItem(planRecordId, parentEventId, regionModel, planHandleItemList, deviceInfo, alarmRecord, out camerasList, out ledMessage);
// Hashtable hash = HandleDevicePlanItem(planRecordId, planHandleItemList, deviceInfo, alarmRecord,out camerasList,out ledMessage);
if (hash != null && hash.Count != 0)
{
WebSocketMsgModel webMsg = new WebSocketMsgModel();
DevicePlanMsgModel devicePlanMsg = new DevicePlanMsgModel();
devicePlanMsg.hash = hash;
devicePlanMsg.alarm = alarmRecord;
devicePlanMsg.deviceInfo = deviceInfo;
// devicePlanMsg.videoTime = GetAlarmVideoTime(alarmRecord.alarm_event);
devicePlanMsg.videoTime = GetAlarmVideoTime(parentEventId);
devicePlanMsg.camerasList = camerasList;
devicePlanMsg.ledMessage = ledMessage; //用于页面显示滚动条信息
// string devicePlanMsgStr = JsonHelper.ObjectToString(devicePlanMsg);
webMsg.info = devicePlanMsg;
webMsg.type = (int)EnumClass.WebSocketMsgType.事件预案;
string param = JsonHelper.ObjectToString(webMsg);
HttpHelper.PostJsonData(SubSystemRouteBLL.GetToWebsocketRoute(), param, Encoding.UTF8);
}
}
}
else
{
Log4NetHelp.Info("未找到对应事件预案处置项，事件ID：" + alarmRecord.alarm_event + " 园区ID：" + regionModel.id + " 报警时间：" + alarmTime);
}
}
else
{
Log4NetHelp.Info("未找到对应事件预案，事件ID：" + alarmRecord.alarm_event + " 园区ID：" + regionModel.id + " 报警时间：" + alarmTime);
}
}
else
{
Log4NetHelp.Info("未找到对应事件，事件ID：" + alarmRecord.alarm_event);
}
}
}
else
{
//log：未找到设备alarmRecord.alarm_code
Log4NetHelp.Info("未找到设备：" + alarmRecord.alarm_code);
}
}
catch (Exception ex)
{
// Log4NetHelp.Error("业务层处理报警数据失败！" + ex.Message);
Log4NetHelp.Error("业务层处理报警数据失败！" + ex.Message);
}
}
/// <summary>
/// 分页查询获取视频巡更计划任务
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="scheduleName"></param>
/// <param name="regionId"></param>
/// <param name="scheduleType"></param>
/// <param name="scheduleState"></param>
/// <param name="validStartTime"></param>
/// <param name="validEndTime"></param>
/// <param name="totalNumber"></param>
/// <returns></returns>
public List <RetCameraPatrolSchedule> GetCameraPatrolSchedule(int pageIndex, int pageSize, string scheduleName, int regionId, int scheduleType, int scheduleState, string validStartTime, string validEndTime, out int totalNumber)
{
try
{
List <RetCameraPatrolSchedule> retList = new List <RetCameraPatrolSchedule>();
RetCameraPatrolSchedule retModel = null;
BaseRegionConfigDAL baseRegionConfigDal = new BaseRegionConfigDAL();
ServScheduleTimeConfigDAL scheduleTimeConfigDal = new ServScheduleTimeConfigDAL();
ServScheduleQuery query = new ServScheduleQuery();
query.eEndTime = validEndTime;
query.pageIndex = pageIndex;
query.pageSize = pageSize;
query.regionId = regionId;
query.scheduleName = scheduleName;
query.scheduleState = scheduleState;
query.scheduleType = scheduleType;
query.sEndTime = validStartTime;
//分页获视频巡更计划任务
List <CameraPatrolSchedule> cameraPatrolScheduleList = servScheduleDal.GetCameraPatrolScheduleByPage(query, out totalNumber);
//获取全部园区配置
List <BaseRegionConfigModel> regionConfigList = baseRegionConfigDal.GetAllRegionConfig();
//查询园区名称
for (int i = 0; i < cameraPatrolScheduleList.Count; i++)
{
retModel = new RetCameraPatrolSchedule();
retModel.content = cameraPatrolScheduleList[i].content;
retModel.create_time = cameraPatrolScheduleList[i].create_time;
retModel.span_time = cameraPatrolScheduleList[i].span_time;
retModel.cronTime = CSM.Utils.TimeExpression.GetCronTimeModel(cameraPatrolScheduleList[i].period_expression);//生成时间表达式model
#region 查询时间配置
ServScheduleTimeConfigQuery timeQuery = new ServScheduleTimeConfigQuery();
timeQuery.schedule_id = cameraPatrolScheduleList[i].id;
timeQuery.time_type = 1;//查询开始时间
ServScheduleTimeConfigModel timeModel = scheduleTimeConfigDal.GetScheduleTimeConfigByIdAndTimeType(timeQuery).FirstOrDefault();
retModel.start_execute_time = timeModel == null ? "" : timeModel.schedule_time;
retModel.execute_date = timeModel == null ? "" : timeModel.schedule_date;
#endregion
retModel.end_execute_time = "";
retModel.end_time = cameraPatrolScheduleList[i].end_time;
retModel.ext1 = cameraPatrolScheduleList[i].ext1;
// retModel.ext10 = cameraPatrolScheduleList[i].ext10;
retModel.ext2 = cameraPatrolScheduleList[i].ext2;
retModel.ext3 = cameraPatrolScheduleList[i].ext3;
retModel.ext4 = cameraPatrolScheduleList[i].ext4;
retModel.ext5 = cameraPatrolScheduleList[i].ext5;
retModel.ext6 = cameraPatrolScheduleList[i].ext6;
// retModel.ext7 = cameraPatrolScheduleList[i].ext7;
retModel.ext8 = cameraPatrolScheduleList[i].ext8;
// retModel.ext9 = cameraPatrolScheduleList[i].ext9;
retModel.group_id = cameraPatrolScheduleList[i].group_id;
retModel.group_name = cameraPatrolScheduleList[i].group_name;
retModel.id = cameraPatrolScheduleList[i].id;
retModel.period_expression = cameraPatrolScheduleList[i].period_expression;
retModel.region_id = cameraPatrolScheduleList[i].region_id;
retModel.schedule_name = cameraPatrolScheduleList[i].schedule_name;
retModel.schedule_state = cameraPatrolScheduleList[i].schedule_state;
retModel.schedule_type = cameraPatrolScheduleList[i].schedule_type;
retModel.start_time = cameraPatrolScheduleList[i].start_time;
var regionModel = regionConfigList.Where(n => n.id == cameraPatrolScheduleList[i].region_id).FirstOrDefault();
retModel.ext10 = regionModel == null ? "" : regionModel.region_name; //备用字段10用于存储园区名称
retModel.ext7 = cameraPatrolScheduleList[i].end_time > DateTime.Now ? "1" : "2"; //1：未过期，2：过期
retModel.ext9 = retModel.cronTime.describe; //获取表达式描述
retList.Add(retModel);
}
return(retList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 报警数据拼装
/// </summary>
/// <param name="sourceModel"></param>
/// <param name="eventList"></param>
/// <returns></returns>
private AlarmRecordModel TranAlarmRecord(AlarmRecordCustom sourceModel, List <BaseEventTypeModel> eventList)
{
AlarmRecordModel retModel = new AlarmRecordModel();
ServDeviceInfoDAL servDeviceInfoDal = new ServDeviceInfoDAL();
BaseRegionConfigDAL baseRegionConfigDal = new BaseRegionConfigDAL();
ServPersonInfoDAL personInfoDal = new ServPersonInfoDAL();
List <BaseRegionConfigModel> regionList = baseRegionConfigDal.GetAllRegionConfig();//获取全部园区
#region 查找事件 旧版
//if (alarmEvent == null) //判断当前事件是否存在
//{
// retModel.alarmEvent = "";
// retModel.rootEventId = -1;
//}
//else
//{
// if (alarmEvent.pid == -1) //判断是否是父级事件
// {
// retModel.alarmEvent = alarmEvent.event_name;
// retModel.rootEventId = alarmEvent.id;
// }
// else
// {
// var rootEvent = eventList.FirstOrDefault(n => n.id == alarmEvent.pid);//查询父级事件，目前事件只保留两级
// if (rootEvent != null) //找到父级事件
// {
// retModel.alarmEvent = alarmEvent.event_name + "[" + rootEvent.event_name + "]";
// retModel.rootEventId = rootEvent.id;
// }
// else //未找到父级事件
// {
// retModel.alarmEvent = "[" + rootEvent.event_name + "]";
// retModel.rootEventId = -1;
// }
// }
//}
#endregion
#region 查找事件
//var alarmEvent = eventList.FirstOrDefault(n => n.id == sourceModel.alarm_event); //查询当前事件
//if (alarmEvent == null) //判断当前事件是否存在
//{
// retModel.alarmEvent = "--";
// retModel.rootEventId = -1;
//}
//else
//{
// if (alarmEvent.pid == -1) //判断是否是父级事件
// {
// retModel.alarmEvent = alarmEvent.event_name;
// retModel.rootEventId = alarmEvent.id;
// }
// else
// {
// var rootEvent = eventList.FirstOrDefault(n => n.id == alarmEvent.pid);//查询父级事件，目前事件只保留两级
// if (rootEvent != null) //找到父级事件
// {
// retModel.alarmEvent = rootEvent.event_name;
// retModel.rootEventId = rootEvent.id;
// }
// else //未找到父级事件
// {
// retModel.alarmEvent = "--";
// retModel.rootEventId = -1;
// }
// }
//}
#endregion
#region 查找事件 新版
if (!string.IsNullOrEmpty(sourceModel.alarm_event) && sourceModel.alarm_event != "")
{
var alarmEvent = eventList.FirstOrDefault(n => n.event_code == sourceModel.alarm_event);//查找事件
if (alarmEvent != null)
{
if (alarmEvent.pid == -1)
{
retModel.alarmEvent = alarmEvent.event_name;
retModel.rootEventId = alarmEvent.id;
}
else
{
var rootEvent = eventList.FirstOrDefault(n => n.id == alarmEvent.pid);
if (rootEvent != null) //找到父级事件
{
retModel.alarmEvent = rootEvent.event_name;
retModel.rootEventId = rootEvent.id;
}
else //未找到父级事件
{
retModel.alarmEvent = "--";
retModel.rootEventId = -1;
}
}
}
else
{
retModel.alarmEvent = "--";
retModel.rootEventId = -1;
}
}
else
{
retModel.alarmEvent = "--";
retModel.rootEventId = -1;
}
#endregion
// retModel.alarmEvent = eventList.Find(n => n.id == sourceModel.alarm_event) == null ? "" : eventList.Find(n => n.id == sourceModel.alarm_event).event_name;//将事件类型ID转换为事件名称
retModel.alarmLevel = Enum.IsDefined(typeof(EnumClass.AlarmLevel), sourceModel.alarm_level) ? Enum.ToObject(typeof(EnumClass.AlarmLevel), sourceModel.alarm_level).ToString() : "";//转换报警等级
retModel.alarmLocation = sourceModel.alarm_location;
// retModel.alarmName = sourceModel.alarm_name;
retModel.alarmName = sourceModel.alarm_code;//报警名称不显示，显示设备code
retModel.alarmText = sourceModel.alarm_text;
retModel.alarmTime = sourceModel.alarm_time;
retModel.alarmCacheStatus = sourceModel.alarm_cache_status;
retModel.alarmType = sourceModel.alarm_type; //设备报警
// retModel.confirmPersonName = "";//根据ssoid查找人员 需调用sso接口
retModel.confirmPersonName = personInfoDal.GetPersonInfoBySSOId(sourceModel.confirm_person_id) == null ? "" : personInfoDal.GetPersonInfoBySSOId(sourceModel.confirm_person_id).alias;
retModel.confirmAlarmTime = sourceModel.confirm_alarm_time;
retModel.confirmAlarmText = sourceModel.confirm_alarm_text;
retModel.confirmResult = Enum.IsDefined(typeof(EnumClass.ConfirmAlarmResult), sourceModel.confirm_result) ? Enum.ToObject(typeof(EnumClass.ConfirmAlarmResult), sourceModel.confirm_result).ToString() : "";
retModel.confirmState = Enum.IsDefined(typeof(EnumClass.ConfirmAlarmState), sourceModel.confirm_state) ? Enum.ToObject(typeof(EnumClass.ConfirmAlarmState), sourceModel.confirm_state).ToString() : "";
// retModel.deviceName = servDeviceInfoDal.GetEntity(sourceModel.alarm_code) == null ? "未知：" + sourceModel.alarm_code : servDeviceInfoDal.GetEntity(sourceModel.alarm_code).device_name;//查询设备名称
retModel.deviceName = sourceModel.device_name == null ? "未知" : sourceModel.device_name;
retModel.regionName = regionList.Where(n => n.id == sourceModel.region_id).FirstOrDefault() == null ? "" : regionList.Where(n => n.id == sourceModel.region_id).FirstOrDefault().region_name;
retModel.ext1 = sourceModel.ext1;
retModel.ext2 = sourceModel.ext2;
retModel.ext3 = sourceModel.ext3;
retModel.ext4 = sourceModel.ext4;
retModel.ext5 = sourceModel.ext5;
retModel.id = sourceModel.id;
retModel.subSystem = Enum.IsDefined(typeof(EnumClass.SubSystem), sourceModel.alarm_subsystem) ? Enum.ToObject(typeof(EnumClass.SubSystem), sourceModel.alarm_subsystem).ToString() : "";//转换为子系统名称
return(retModel);
}
