/// <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 }));
}
}
