/// <summary> /// 根据园区id获取视频配置 /// </summary> /// <param name="regionId"></param> /// <returns></returns> public VideoConfigCustom GetVideoConfigByRegionId(int regionId) { try { BaseRegionExtendConfigQuery query = new BaseRegionExtendConfigQuery(); query.region_id = regionId; query.config_type = (int)RegionExtendConfigType.视频配置; List <BaseRegionExtendConfigModel> extList = baseRegionExtendConfigDAL.GetRegionExtendConfigByRegionIdAndConfigType(query); VideoConfigCustom custom = new VideoConfigCustom(); if (extList.Count > 0) { custom.regionId = regionId; string str = extList[0].ext1; XmlDocument myXmlDoc = new XmlDocument(); myXmlDoc.LoadXml(str); custom.videoPlatform = Convert.ToInt32(myXmlDoc.SelectSingleNode("root/videoPlatform").InnerText); custom.serverIP = myXmlDoc.SelectSingleNode("root/serverIP").InnerText; custom.userName = myXmlDoc.SelectSingleNode("root/userName").InnerText; custom.userPwd = myXmlDoc.SelectSingleNode("root/userPwd").InnerText; } return(custom); } catch (Exception ex) { throw ex; } }
/// <summary> /// 根据园区ID和类型获取大屏配置 /// </summary> /// <returns></returns> public List <EnumModel> GetGalleryConfigByRegion(int regionId) { try { List <EnumModel> enumList = new List <EnumModel>(); EnumModel enumModel = null; BaseRegionExtendConfigQuery query = new BaseRegionExtendConfigQuery(); BaseRegionExtendConfigDAL dal = new BaseRegionExtendConfigDAL(); query.config_type = (int)EnumClass.RegionExtendConfigType.大屏; query.region_id = regionId; List <BaseRegionExtendConfigModel> list = dal.GetRegionExtendConfigByRegionIdAndConfigType(query); foreach (BaseRegionExtendConfigModel model in list) { enumModel = new EnumModel(); enumModel.key = model.id; enumModel.value = model.ext1; //取屏的编号 enumList.Add(enumModel); } return(enumList); } catch (Exception ex) { throw ex; } }
/// <summary> /// 根据园区ID和园区名称获取应急电话配置 /// </summary> /// <param name="regionId"></param> /// <param name="regionName"></param> /// <returns></returns> public List <EmergencyPhoneTree> GetPhoneByRegionId(int regionId, string regionName) { try { List <EmergencyPhoneTree> treeList = new List <EmergencyPhoneTree>(); BaseRegionExtendConfigDAL regionDal = new BaseRegionExtendConfigDAL(); BaseRegionExtendConfigQuery query = new BaseRegionExtendConfigQuery(); query.config_type = (int)EnumClass.RegionExtendConfigType.应急电话; query.region_id = regionId; List <BaseRegionExtendConfigModel> regionConfigList = regionDal.GetRegionExtendConfigByRegionIdAndConfigType(query); int circle = 1;//定义循环变量起始值 //赋值根节点 EmergencyPhoneTree ztree = new EmergencyPhoneTree(); ztree.id = -1; ztree.name = regionName; ztree.phone = ""; ztree.pid = -2; treeList.Add(ztree); //添加子节点 if (regionConfigList != null && regionConfigList.Count > 0) { BaseRegionExtendConfigModel model = regionConfigList.FirstOrDefault(); List <EmergencyPhoneCustom> customList = TranXMLToObj(model.ext20);//将应急电话xml转化为对象 for (int i = 0; i < customList.Count; i++) { //将节点加入treeList集合 EmergencyPhoneTree tree = new EmergencyPhoneTree(); tree.id = circle; tree.name = customList[i].groupName; tree.phone = ""; tree.pid = -1; treeList.Add(tree); circle++; //将子节点加入treeList集合 for (int j = 0; j < customList[i].phoneList.Count; j++) { EmergencyPhoneTree trees = new EmergencyPhoneTree(); trees.id = circle; trees.pid = tree.id; trees.name = customList[i].phoneList[j].phoneName; trees.phone = customList[i].phoneList[j].phoneNum; treeList.Add(trees); circle++; } } } return(treeList); } catch (Exception ex) { throw ex; } }
/// <summary> /// 根据园区ID和配置类型获取当前第一条配置 /// </summary> /// <param name="regionId"></param> /// <param name="type"></param> /// <returns></returns> public BaseRegionExtendConfigModel GetFirstRegionExtendConfigByRegionIdAndType(int regionId, int type) { try { BaseRegionExtendConfigDAL regionExtendConfigDal = new BaseRegionExtendConfigDAL(); BaseRegionExtendConfigQuery query = new BaseRegionExtendConfigQuery(); query.config_type = type; query.region_id = regionId; BaseRegionExtendConfigModel regionExtendConfig = regionExtendConfigDal.GetRegionExtendConfigByRegionIdAndConfigType(query).FirstOrDefault(); return(regionExtendConfig); } catch (Exception ex) { throw ex; } }
/// <summary> /// 修改地图配置 /// </summary> /// <param name="videoConfig">地图配置</param> /// <param name="path"></param> /// <returns></returns> public bool UpdateVideoConfig(VideoConfigCustom videoConfig) { try { bool result = false; StringBuilder builder = new StringBuilder(); builder.Append("<?xml version = '1.0' encoding='utf-8'?><root><videoPlatform>" + videoConfig.videoPlatform + "</videoPlatform><serverIP>" + videoConfig.serverIP + "</serverIP><userName>" + videoConfig.userName + "</userName><userPwd>" + videoConfig.userPwd + "</userPwd></root>"); string videoStr = builder.ToString(); BaseRegionExtendConfigModel model = new BaseRegionExtendConfigModel(); model.region_id = videoConfig.regionId; model.config_type = (int)RegionExtendConfigType.视频配置; model.ext1 = videoStr; //根据园区id和配置类型查找配置 BaseRegionExtendConfigQuery query = new BaseRegionExtendConfigQuery(); query.region_id = videoConfig.regionId; query.config_type = (int)RegionExtendConfigType.视频配置; List <BaseRegionExtendConfigModel> extlist = baseRegionExtendConfigDAL.GetRegionExtendConfigByRegionIdAndConfigType(query); int num = 0; //修改 if (extlist.Count > 0) { num = baseRegionExtendConfigDAL.UpdateRegionExtendConfigByRegionIdAndConfigType(model); } else { //新增 num = baseRegionExtendConfigDAL.AddEntity(model); } if (num != 0) { result = true; } return(result); } catch (Exception ex) { throw ex; } }
/// <summary> /// 更新应急电话配置 /// </summary> /// <param name="regionId"></param> /// <param name="info"></param> /// <returns></returns> public bool UpdatePhoneByRegionId(int regionId, string info) { try { List <EmergencyPhoneCustom> list = new List <EmergencyPhoneCustom>(); string xml = TranObjToXml(list); BaseRegionExtendConfigDAL regionDal = new BaseRegionExtendConfigDAL(); BaseRegionExtendConfigQuery query = new BaseRegionExtendConfigQuery(); query.config_type = (int)EnumClass.RegionExtendConfigType.应急电话; query.region_id = regionId; List <BaseRegionExtendConfigModel> regionConfigList = regionDal.GetRegionExtendConfigByRegionIdAndConfigType(query); int res = 0; if (regionConfigList != null && regionConfigList.Count > 0) { //含有该园区配置则进行修改 BaseRegionExtendConfigModel telePhoneConfig = regionConfigList.FirstOrDefault(); telePhoneConfig.config_type = (int)EnumClass.RegionExtendConfigType.应急电话; telePhoneConfig.ext20 = xml; telePhoneConfig.region_id = regionId; res = regionDal.UpdateEntity(telePhoneConfig); } else { //未含有该园区配置进行新增 BaseRegionExtendConfigModel telePhoneConfig = new BaseRegionExtendConfigModel(); telePhoneConfig.config_type = (int)EnumClass.RegionExtendConfigType.应急电话; telePhoneConfig.ext20 = xml; telePhoneConfig.region_id = regionId; res = regionDal.AddEntity(telePhoneConfig); } return(res > 0 ? true : false); } catch (Exception ex) { throw ex; } }
/// <summary> /// 通过园区获取园区应急电话配置 /// </summary> /// <param name="regionId"></param> /// <returns></returns> public List <EmergencyPhoneCustom> GetEmergencyConfig(int regionId, out int configId) { try { List <EmergencyPhoneCustom> customList = new List <EmergencyPhoneCustom>(); BaseRegionExtendConfigDAL regionDal = new BaseRegionExtendConfigDAL(); BaseRegionExtendConfigQuery query = new BaseRegionExtendConfigQuery(); query.config_type = (int)EnumClass.RegionExtendConfigType.应急电话; query.region_id = regionId; configId = -1; List <BaseRegionExtendConfigModel> regionConfigList = regionDal.GetRegionExtendConfigByRegionIdAndConfigType(query); if (regionConfigList != null && regionConfigList.Count > 0) { BaseRegionExtendConfigModel model = regionConfigList.FirstOrDefault(); configId = model.id; customList = TranXMLToObj(model.ext20);//将应急电话xml转化为对象 } return(customList); } catch (Exception ex) { throw ex; } }