/// <summary> /// 新增自定义设备类型 /// </summary> /// <param name="deviceDefined"></param> /// <returns></returns> public int AddDeviceDefined(ServDefinedDeviceModel deviceDefined) { try { //判断所选的基础设备类型是否被绑定 int num = servDeviceDefinedDAL.VerificationBaseDeviceTypeByTypeIdAndIndustryId(deviceDefined); if (num != 0) { return(2);//基础设备类型已被绑定 } //添加自定义设备类型 int definedID = servDeviceDefinedDAL.AddEntity(deviceDefined); if (definedID != 0) { return(1);//添加成功 } else { return(3);//添加失败 } } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取25D未注册设备列表 /// </summary> /// <param name="region_id"></param> /// <param name="industry_id"></param> /// <returns></returns> public List <DeviceInfoCustom> GetDeviceInfoAndIconUrlToRegister25d(int region_id, int industry_id) { try { ServDefinedDeviceModel model = new ServDefinedDeviceModel(); model.industry_id = industry_id; model.base_device_type_id = region_id; //取出25D未注册设备 List <ServDeviceInfoModel> deviceList = servDeviceInfoDAL.Get25DUnRegisterDevice(model); DeviceInfoCustom deviceInfoCustomTree = new DeviceInfoCustom(); List <DeviceInfoCustom> deviceInfoCustomTreeList = new List <DeviceInfoCustom>(); //加入树结构中 for (int i = 0; i < deviceList.Count; i++) { deviceInfoCustomTree = new DeviceInfoCustom(); deviceInfoCustomTree.pid = 0; deviceInfoCustomTree.id = deviceList[i].id; deviceInfoCustomTree.device_name = deviceList[i].device_name; deviceInfoCustomTreeList.Add(deviceInfoCustomTree); } deviceInfoCustomTree = new DeviceInfoCustom(); deviceInfoCustomTree.pid = -1; deviceInfoCustomTree.id = 0; deviceInfoCustomTree.device_name = "25D未注册设备"; deviceInfoCustomTreeList.Add(deviceInfoCustomTree); return(deviceInfoCustomTreeList); } catch (Exception) { throw; } }
/// <summary> /// 设备修改 /// </summary> /// <param name="deviceID">设备id</param> /// <param name="device_name">设备名称</param> /// <param name="device_code">设备编码</param> /// <param name="device_type">设备类型</param> /// <param name="subsystem_id">子系统</param> /// <param name="device_status">设备状态</param> /// <param name="cover_range">覆盖角度</param> /// <param name="camera_towards">设备朝向</param> /// <param name="visual_range">覆盖角度</param> /// <param name="is_inbuilding">是否楼内</param> /// <param name="lonLat">2D坐标</param> /// <param name="lonLat25D">25D坐标</param> /// <param name="isParts">是否复合设备</param> /// <param name="regionID">园区id</param> /// <param name="jishihuifang">及时回放</param> /// <param name="duolubofang">多路播放</param> /// <param name="shangdaqiang">上大墙</param> /// <param name="lishihuifang">历史回放</param> /// <param name="deviceTempID">设备临时表id</param> /// <param name="industryId">行业id</param> /// <returns></returns> public JsonResult UpdateDevice2D(int deviceID, string device_name, string device_code, int device_type, int subsystem_id, int device_status, int cover_range, int camera_towards, int visual_range, int is_inbuilding, string lonLat, string lonLat25D, int isParts, int regionID, string jishihuifang, string duolubofang, string shangdaqiang, string lishihuifang, int industryId) { try { ServDeviceInfoQuery deviceInfo = new ServDeviceInfoQuery(); deviceInfo.id = deviceID; deviceInfo.device_code = device_code; deviceInfo.is_parts = isParts; deviceInfo.device_name = device_name; deviceInfo.device_type = device_type; deviceInfo.subsystem_id = subsystem_id; deviceInfo.longitude = lonLat.Split(',')[1]; deviceInfo.latitude = lonLat.Split(',')[0]; deviceInfo.local_longitude = lonLat25D.Split(',')[1]; deviceInfo.local_latitude = lonLat25D.Split(',')[0]; if (deviceInfo.local_latitude == "" || deviceInfo.local_longitude == "" || deviceInfo.local_latitude == "null" || deviceInfo.local_longitude == "null" || deviceInfo.local_latitude == "undefined" || deviceInfo.local_longitude == "undefined") { deviceInfo.local_latitude = null; deviceInfo.local_longitude = null; } deviceInfo.search_code = ""; deviceInfo.device_status = device_status; deviceInfo.update_status_time = ""; deviceInfo.cover_range = cover_range; deviceInfo.camera_towards = camera_towards; deviceInfo.visual_range = visual_range; deviceInfo.asset_code = ""; deviceInfo.org_id = 0; deviceInfo.manufactor = ""; deviceInfo.asset_model = ""; deviceInfo.create_time = ""; deviceInfo.guarantee_time = ""; deviceInfo.asset_status = 0; deviceInfo.asset_ip = ""; deviceInfo.port = ""; deviceInfo.mac_code = ""; deviceInfo.serial_number = ""; deviceInfo.manager_id = 0; deviceInfo.is_inbuilding = is_inbuilding; deviceInfo.room_id = 0; deviceInfo.region_id = regionID; deviceInfo.area_id = 0; deviceInfo.ext1 = jishihuifang; deviceInfo.ext2 = duolubofang; deviceInfo.ext3 = shangdaqiang; deviceInfo.ext4 = lishihuifang; //根据设备类型查询设备图标地址 ServDefinedDeviceModel definedDevice = mapRegisterBLL.GetDeviceIcon(industryId, device_type); string path = definedDevice == null ? "" : definedDevice.normal_image; bool result = mapRegisterBLL.UpdateDeviceInfo2D(deviceInfo); return(Json(new { result = result, iconPath = path })); } catch (Exception ex) { return(Json(new { state = 1, message = ex.Message })); } }
/// <summary> /// 根据基础设备类型id查询设备设备图标路径 /// </summary> /// <param name="path"></param> /// <param name="deviceTypeID"></param> /// <returns></returns> public ServDefinedDeviceModel GetDeviceIcon(int industryId, int deviceTypeID) { DefinedDeviceToolCustom query = new DefinedDeviceToolCustom(); query.industry_id = industryId; query.device_typeid = deviceTypeID; ServDefinedDeviceModel definedDevice = servDefinedDeviceDAL.GetDefinedDeviceByIndusryIdAndBaseDeviceTypeId(query); return(definedDevice); }
/// <summary> /// 查询所有未注册的25D设备 /// </summary> /// <param name="model"></param> /// <returns></returns> public List <ServDeviceInfoModel> Get25DUnRegisterDevice(ServDefinedDeviceModel model) { try { return(mapContext.QueryForList <ServDeviceInfoModel>("Get25DUnRegisterDevice", model).ToList()); } catch (Exception ex) { throw ex; } }
/// <summary> /// 修改子节点显示或隐藏 /// </summary> /// <param name="model"></param> /// <returns></returns> public int UpdateChildDeviceEnable(ServDefinedDeviceModel model) { try { return(mapContext.Update("UpdateChildDeviceEnable", model)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 根据行业id和基础设备类型id验证该基础设备类型是否被绑定(修改) /// </summary> /// <param name="query"></param> /// <returns></returns> public int VerificationBaseDeviceTypeByTypeIdAndIndustryIdAndDefinedId(ServDefinedDeviceModel query) { try { return(mapContext.QueryForObject <int>("VerificationBaseDeviceTypeByTypeIdAndIndustryIdAndDefinedId", query)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 修改 /// </summary> /// <param name="model"></param> /// <returns></returns> public int UpdateDeviceDefinedById(ServDefinedDeviceModel model) { try { int result = mapContext.Update("UpdateDeviceDefined", model); return(result); } catch (Exception ex) { throw ex; } }
public int AddEntity(ServDefinedDeviceModel entity) { try { int id = (int)mapContext.Insert("InsertDeviceDefined", entity); return(id); } catch (Exception ex) { throw ex; } }
/// <summary> /// 根据id获取自定义设备类型 /// </summary> /// <param name="deviceDefinedID"></param> /// <returns></returns> public ServDefinedDeviceModel GetDeviceDefinedByID(int deviceDefinedID) { try { ServDefinedDeviceModel DefinedCustomModel = servDeviceDefinedDAL.GetEntity(deviceDefinedID); return(DefinedCustomModel); } catch (Exception ex) { throw ex; } }
/// <summary> /// 查询所有的设备和图标地址联合 /// </summary> /// <param name="region_id">园区id</param> /// <returns></returns> public List <DeviceInfoCustom> GetDeviceInfoAndIconUrl(ServDefinedDeviceModel model) { try { //string sql = IBatisHelper.GetRuntimeSql(this.mapContext, "GetDeviceInfoAndIconUrl", model);//获取SQL语句 List <DeviceInfoCustom> deviceList = mapContext.QueryForList <DeviceInfoCustom>("GetDeviceInfoAndIconUrl", model).ToList(); return(deviceList); } catch (Exception ex) { throw ex; } }
///// <summary> ///// 得到ServDeviceInfo设备表中所有的数据 ///// </summary> ///// <returns></returns> //public List<CSM.Model.ServDeviceInfoModel> GetEntities() //{ // try // { // CSM.Model.QueryModel.ServDeviceInfoQuery servDeviceInfoQuery = new Model.QueryModel.ServDeviceInfoQuery(); // return servDeviceInfoDAL.GetEntities(servDeviceInfoQuery); // } // catch (Exception ex) // { // throw ex; // } //} /// <summary> /// 获取所有的设备和图标地址联合 /// </summary> /// <returns></returns> public List <DeviceInfoCustom> GetDeviceInfoAndIconUrl(int region_id, int industry_id) { try { ServDefinedDeviceModel model = new ServDefinedDeviceModel();//要传园区id和行业ID,所以这个数据库只能传一个条件查询,所以借用这个BaseIndustryDeviceModel model.industry_id = industry_id; model.base_device_type_id = region_id; List <DeviceInfoCustom> deviceList = servDeviceInfoDAL.GetDeviceInfoAndIconUrl(model); return(deviceList); } catch (Exception ex) { throw ex; } }
/// <summary> /// 修改自定义设备类型 /// </summary> /// <param name="deviceDefined"></param> /// <returns></returns> public int UpdateDeviceDefined(ServDefinedDeviceModel deviceDefined) { try { //判断所选的基础设备类型是否被绑定 int num = servDeviceDefinedDAL.VerificationBaseDeviceTypeByTypeIdAndIndustryIdAndDefinedId(deviceDefined); if (num != 0) { return(2);//基础设备类型已被绑定 } //判断节点下是否有子节点如果有则不能绑定基础设备类型 List <ServDefinedDeviceModel> deviceList = servDeviceDefinedDAL.GetDefinedDeviceByPid(deviceDefined.id); if (deviceList.Count != 0) { if (deviceDefined.base_device_type_id != 0) { return(4);//有子节点无法绑定基础设备类型 } } //如果隐藏的是父节点则顺带隐藏父节点下的子节点 if (deviceDefined.pid == 0) { num = servDeviceDefinedDAL.UpdateChildDeviceEnable(deviceDefined); } num = servDeviceDefinedDAL.UpdateDeviceDefinedById(deviceDefined); if (num != 0) { return(1);//修改成功 } else { return(3);//修改失败 } } catch (Exception ex) { throw ex; } }
public bool UpdateEntity(int id, ServDefinedDeviceModel newentity) { throw new NotImplementedException(); }
/// <summary> /// 设备注册2D /// </summary> /// <param name="device_name">设备名称</param> /// <param name="device_code">设备编码</param> /// <param name="device_type">设备类型</param> /// <param name="subsystem_id">子系统</param> /// <param name="device_status">设备状态</param> /// <param name="cover_range">覆盖角度</param> /// <param name="camera_towards">设备朝向</param> /// <param name="visual_range">覆盖角度</param> /// <param name="is_inbuilding">是否楼内</param> /// <param name="lonLat">坐标</param> /// <param name="isParts">是否复合设备</param> /// <param name="regionID">园区id</param> /// <param name="jishihuifang">及时回放</param> /// <param name="duolubofang">多路播放</param> /// <param name="shangdaqiang">上大墙</param> /// <param name="lishihuifang">历史回放</param> /// <param name="deviceTempID">设备临时表id</param> /// <param name="industryId">行业id</param> /// <returns></returns> public JsonResult AddDevice2D(string device_name, string device_code, int device_type, int subsystem_id, int device_status, int cover_range, int camera_towards, int visual_range, int is_inbuilding, string lonLat, int isParts, int regionID, string jishihuifang, string duolubofang, string shangdaqiang, string lishihuifang, int deviceTempID, int industryId) { try { ServDeviceInfoQuery deviceInfo = new ServDeviceInfoQuery(); if (device_code != "") { //验证设备code是否已经存在 ServDeviceInfoModel deviceInfoModel = mapRegisterBLL.GetDeviceInfoByDeviceCode(device_code); if (deviceInfoModel != null) { return(Json(new { state = 2, message = "该设备code已存在" })); } deviceInfo.device_code = device_code; } else { deviceInfo.device_code = device_code; } deviceInfo.is_parts = isParts; deviceInfo.device_name = device_name; deviceInfo.device_type = device_type; deviceInfo.subsystem_id = subsystem_id; deviceInfo.longitude = lonLat.Split(',')[1]; deviceInfo.latitude = lonLat.Split(',')[0]; deviceInfo.register_time = DateTime.Now.ToString(); deviceInfo.search_code = ""; deviceInfo.local_longitude = null; deviceInfo.local_latitude = null; deviceInfo.device_status = device_status; deviceInfo.update_status_time = ""; deviceInfo.cover_range = cover_range; deviceInfo.camera_towards = camera_towards; deviceInfo.visual_range = visual_range; deviceInfo.asset_code = ""; deviceInfo.org_id = 0; deviceInfo.manufactor = ""; deviceInfo.asset_model = ""; deviceInfo.create_time = ""; deviceInfo.guarantee_time = ""; deviceInfo.asset_status = 0; deviceInfo.asset_ip = ""; deviceInfo.port = ""; deviceInfo.mac_code = ""; deviceInfo.serial_number = ""; deviceInfo.manager_id = 0; deviceInfo.is_inbuilding = is_inbuilding; deviceInfo.room_id = 0; deviceInfo.region_id = regionID; deviceInfo.area_id = 0; deviceInfo.ext1 = jishihuifang; deviceInfo.ext2 = duolubofang; deviceInfo.ext3 = shangdaqiang; deviceInfo.ext4 = lishihuifang; //根据设备类型查询设备图标地址 ServDefinedDeviceModel definedDevice = mapRegisterBLL.GetDeviceIcon(industryId, device_type); string path = definedDevice == null ? "" : definedDevice.normal_image; ServDeviceInfoModel model = mapRegisterBLL.AddDevice2D(deviceInfo, deviceTempID); return(Json(new { id = model.id, device_code = model.device_code, iconPath = path })); } catch (Exception ex) { return(Json(new { state = 1, message = ex.Message })); } }