/// <summary> /// 获取事件预案信息 /// </summary> /// <param name="eventPlanId"></param> /// <param name="planType"></param> /// <returns></returns> public EventPlanRelationInfo GetEventPlanInfo(int eventPlanId, int planType) { try { //获取预案信息 ServEventPlanModel entity = servEventPlanDAL.GetEntity(eventPlanId); //获取时间信息 ServExecutionTimeModel ServExecutionTime = servExecutionTimeDAL.GetTimeEntity(eventPlanId, planType); //获取处置项信息 List <ServPlanHandleItemModel> PlanHandleItemList = servPlanHandleItemDAL.GetPlanHandleItem(eventPlanId, planType); //预案确警前处置项 List <ServPlanHandleItemModel> defaultPlanHandleItemList = new List <ServPlanHandleItemModel>(); //预案确警后处置项 List <ServPlanHandleItemModel> cnfirmPlanHandleItemList = new List <ServPlanHandleItemModel>(); //预案确警前责任人关联表 List <ServPlanPersonModel> defaultPersonList = new List <ServPlanPersonModel>(); //预案确警后责任人关联表 List <ServPlanPersonModel> cnfirmPlanPersonList = new List <ServPlanPersonModel>(); if (PlanHandleItemList.Count() > 0) { for (var i = 0; i < PlanHandleItemList.Count(); i++) { if (PlanHandleItemList[i].item_type == (int)CSM.Common.EnumClass.EventPlanDefaultOptions.通知其他负责人 && PlanHandleItemList[i].confirm_type == (int)CSM.Common.EnumClass.PlanHandleTime.确警前) { defaultPersonList = servPlanPersonDAL.GetPlanPersonInfo(PlanHandleItemList[i].id); } else if (PlanHandleItemList[i].item_type == (int)CSM.Common.EnumClass.EventPlanConfirmOptions.通知其他负责人 && PlanHandleItemList[i].confirm_type == (int)CSM.Common.EnumClass.PlanHandleTime.确警后) { cnfirmPlanPersonList = servPlanPersonDAL.GetPlanPersonInfo(PlanHandleItemList[i].id); } if (PlanHandleItemList[i].confirm_type == (int)CSM.Common.EnumClass.PlanHandleTime.确警前) { defaultPlanHandleItemList.Add(PlanHandleItemList[i]); } else if (PlanHandleItemList[i].confirm_type == (int)CSM.Common.EnumClass.PlanHandleTime.确警后) { cnfirmPlanHandleItemList.Add(PlanHandleItemList[i]); } } } EventPlanRelationInfo model = new EventPlanRelationInfo(); model.entity = entity; model.servExecutionTime = ServExecutionTime; model.defaultPlanHandleItemList = defaultPlanHandleItemList; model.cnfirmPlanHandleItemList = cnfirmPlanHandleItemList; model.cnfirmPlanPersonList = cnfirmPlanPersonList; model.defaultPersonList = defaultPersonList; return(model); } catch (Exception ex) { throw ex; } }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model"></param> public int UpdateServExecutionTimeById(ServExecutionTimeModel model) { try { int result = mapContext.Update("UpdateServExecutionTimeById", model); return(result); } catch (Exception ex) { throw ex; } }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="entity"></param> public int AddEntity(ServExecutionTimeModel entity) { try { int id = (int)mapContext.Insert("InsertServExecutionTime", entity); return(id); } catch (Exception ex) { throw ex; } }
/// <summary> /// 根据id查询 /// </summary> /// <param name="id"></param> /// <returns></returns> public ServExecutionTimeModel GetEntity(int id) { try { ServExecutionTimeModel ExecutionTimeInfo = mapContext.QueryForObject <ServExecutionTimeModel>("GetServExecutionTimeById", id); return(ExecutionTimeInfo); } catch (Exception ex) { throw ex; } }
public ServExecutionTimeModel GetTimeEntity(int eventPlanId, int planType) { try { ServExecutionTimeQuery query = new ServExecutionTimeQuery(); query.relate_id = eventPlanId; query.type = planType; ServExecutionTimeModel ExecutionTimeInfo = mapContext.QueryForObject <ServExecutionTimeModel>("GetTimeInfoById", query); return(ExecutionTimeInfo); } catch (Exception ex) { throw ex; } }
/// <summary> /// 修改预案信息 /// </summary> /// <param name="entity">预案信息</param> /// <param name="servExecutionTime">时间</param> /// <param name="defaultPlanHandleItemList">默认处置项</param> /// <param name="cnfirmPlanHandleItemList">确认处置项</param> /// <param name="defaultPersonList">默认处置项通知其他责任人</param> /// <param name="cnfirmPlanPersonList">确认处置项通知其他责任人</param> /// <returns></returns> public bool UpdateEventPlanInfo(ServEventPlanModel entity, ServExecutionTimeModel servExecutionTime, List <ServPlanHandleItemModel> defaultPlanHandleItemList, List <ServPlanHandleItemModel> cnfirmPlanHandleItemList, List <ServPlanPersonModel> defaultPersonList, List <ServPlanPersonModel> cnfirmPlanPersonList) { bool result = false; try { EventPlanRelationInfo eventPlanRelationInfo = new EventPlanRelationInfo(); eventPlanRelationInfo.entity = entity; eventPlanRelationInfo.servExecutionTime = servExecutionTime; eventPlanRelationInfo.defaultPlanHandleItemList = defaultPlanHandleItemList; eventPlanRelationInfo.cnfirmPlanHandleItemList = cnfirmPlanHandleItemList; eventPlanRelationInfo.cnfirmPlanPersonList = cnfirmPlanPersonList; eventPlanRelationInfo.defaultPersonList = defaultPersonList; result = servEventPlanDAL.UpdateEventPlan(eventPlanRelationInfo); return(result); } catch (Exception ex) { throw ex; } }
/// <summary> /// 修改预案信息 /// </summary> /// <param name="entity">预案信息</param> /// <param name="defaultPlanHandleItemList">默认处置项</param> /// <param name="cnfirmPlanHandleItemList">确认处置项</param> /// <param name="defaultPersonList">默认处置项通知其他责任人</param> /// <param name="cnfirmPlanPersonList">确认处置项通知其他责任人</param> /// <param name="servPlanHandleItemCameraList">关联摄像头</param> /// <returns></returns> public bool UpdateDevicePlanInfo(ServDevicePlanModel entity, ServExecutionTimeModel executionTimeInfo, List <ServPlanHandleItemModel> defaultPlanHandleItemList, List <ServPlanHandleItemModel> cnfirmPlanHandleItemList, List <ServPlanPersonModel> defaultPersonList, List <ServPlanPersonModel> cnfirmPlanPersonList, List <ServPlanHandleItemCameraModel> servPlanHandleItemCameraList) { bool result = false; try { DevicePlanRelationInfoModel devicePlanRelationInfoModel = new DevicePlanRelationInfoModel(); devicePlanRelationInfoModel.entity = entity; devicePlanRelationInfoModel.servExecutionTime = executionTimeInfo; devicePlanRelationInfoModel.defaultPlanHandleItemList = defaultPlanHandleItemList; devicePlanRelationInfoModel.cnfirmPlanHandleItemList = cnfirmPlanHandleItemList; devicePlanRelationInfoModel.cnfirmPlanPersonList = cnfirmPlanPersonList; devicePlanRelationInfoModel.defaultPersonList = defaultPersonList; devicePlanRelationInfoModel.servPlanHandleItemCameraList = servPlanHandleItemCameraList; result = servDevicePlanDAL.UpdateDevicePlan(devicePlanRelationInfoModel); return(result); } catch (Exception ex) { throw ex; } }
/// <summary> /// 批量添加预案信息 /// </summary> /// <param name="entity">预案信息</param> /// <param name="defaultPlanHandleItemList">默认处置项</param> /// <param name="cnfirmPlanHandleItemList">确认处置项</param> /// <param name="defaultPersonList">默认处置项通知其他责任人</param> /// <param name="cnfirmPlanPersonList">确认处置项通知其他责任人</param> /// <param name="servPlanHandleItemCameraList">关联摄像头</param> /// <returns></returns> public bool BatchAddDevicePlanData(List <ServDevicePlanModel> entity, ServExecutionTimeModel servExecutionTime, List <ServPlanHandleItemModel> defaultPlanHandleItemList, List <ServPlanHandleItemModel> cnfirmPlanHandleItemList, List <ServPlanPersonModel> defaultPersonList, List <ServPlanPersonModel> cnfirmPlanPersonList, List <ServPlanHandleItemCameraModel> servPlanHandleItemCameraList) { bool result = false; try { DevicePlanRelationInfoModel devicePlanRelationInfoModel = new DevicePlanRelationInfoModel(); devicePlanRelationInfoModel.servExecutionTime = servExecutionTime; devicePlanRelationInfoModel.entityList = entity; devicePlanRelationInfoModel.defaultPlanHandleItemList = defaultPlanHandleItemList; devicePlanRelationInfoModel.cnfirmPlanHandleItemList = cnfirmPlanHandleItemList; devicePlanRelationInfoModel.cnfirmPlanPersonList = cnfirmPlanPersonList; devicePlanRelationInfoModel.defaultPersonList = defaultPersonList; devicePlanRelationInfoModel.servPlanHandleItemCameraList = servPlanHandleItemCameraList; result = servDevicePlanDAL.BatchAddDevicePlanData(devicePlanRelationInfoModel); return(result); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取预案信息 /// </summary> /// <param name="devicePlanId"></param> /// <param name="planType"></param> /// <returns></returns> public DevicePlanRelationInfoModel GetDevicePlanInfo(int devicePlanId, int planType) { try { //获取预案信息 ServDevicePlanModel entity = servDevicePlanDAL.GetEntity(devicePlanId); //园区信息 BaseRegionConfigModel regionInfo = baseRegionConfigDAL.GetRegionConfigInfo(entity.device_id); //获取时间信息 ServExecutionTimeModel ServExecutionTime = servExecutionTimeDAL.GetTimeEntity(devicePlanId, planType); //获取处置项信息 List <ServPlanHandleItemModel> PlanHandleItemList = servPlanHandleItemDAL.GetPlanHandleItem(devicePlanId, planType); //预案确警前处置项 List <ServPlanHandleItemModel> defaultPlanHandleItemList = new List <ServPlanHandleItemModel>(); //预案确警后处置项 List <ServPlanHandleItemModel> cnfirmPlanHandleItemList = new List <ServPlanHandleItemModel>(); //预案确警前责任人关联表 List <ServPlanPersonModel> defaultPersonList = new List <ServPlanPersonModel>(); //预案确警后责任人关联表 List <ServPlanPersonModel> cnfirmPlanPersonList = new List <ServPlanPersonModel>(); //获取关联摄像头信息 List <ServPlanHandleItemCameraModel> servPlanHandleItemCameraList = new List <ServPlanHandleItemCameraModel>(); if (PlanHandleItemList.Count() > 0) { for (var i = 0; i < PlanHandleItemList.Count(); i++) { if (PlanHandleItemList[i].item_type == (int)CSM.Common.EnumClass.DevicePlanDefaultOptions.通知其他负责人 && PlanHandleItemList[i].confirm_type == (int)CSM.Common.EnumClass.PlanHandleTime.确警前) { defaultPersonList = servPlanPersonDAL.GetPlanPersonInfo(PlanHandleItemList[i].id); } else if (PlanHandleItemList[i].item_type == (int)CSM.Common.EnumClass.DevicePlanConfirmOptions.通知其他负责人 && PlanHandleItemList[i].confirm_type == (int)CSM.Common.EnumClass.PlanHandleTime.确警后) { cnfirmPlanPersonList = servPlanPersonDAL.GetPlanPersonInfo(PlanHandleItemList[i].id); } else if (PlanHandleItemList[i].item_type == (int)CSM.Common.EnumClass.DevicePlanDefaultOptions.关联摄像头) { servPlanHandleItemCameraList = servPlanHandleItemCameraDAL.GetPlanHandleItemCamera(PlanHandleItemList[i].id); } if (PlanHandleItemList[i].confirm_type == (int)CSM.Common.EnumClass.PlanHandleTime.确警前) { defaultPlanHandleItemList.Add(PlanHandleItemList[i]); } else if (PlanHandleItemList[i].confirm_type == (int)CSM.Common.EnumClass.PlanHandleTime.确警后) { cnfirmPlanHandleItemList.Add(PlanHandleItemList[i]); } } } DevicePlanRelationInfoModel model = new DevicePlanRelationInfoModel(); model.entity = entity; model.servExecutionTime = ServExecutionTime; model.BaseRegionConfigInfo = regionInfo; model.defaultPlanHandleItemList = defaultPlanHandleItemList; model.cnfirmPlanHandleItemList = cnfirmPlanHandleItemList; model.cnfirmPlanPersonList = cnfirmPlanPersonList; model.defaultPersonList = defaultPersonList; model.servPlanHandleItemCameraList = servPlanHandleItemCameraList; return(model); } catch (Exception ex) { throw ex; } }
public bool UpdateEntity(int id, ServExecutionTimeModel newentity) { throw new NotImplementedException(); }