DalCommon.cs 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487
  1. /* ==============================================================================
  2. * 功能描述:DalCommon
  3. * 创 建 者:Garrett
  4. * 创建日期:2018/5/28 17:17:45
  5. * ==============================================================================*/
  6. using System;
  7. using System.Collections.Generic;
  8. using System.Linq;
  9. using System.Text;
  10. using System.Text.RegularExpressions;
  11. using System.Threading.Tasks;
  12. using Autodesk.Revit.DB;
  13. using Newtonsoft.Json.Linq;
  14. using SAGA.DotNetUtils;
  15. using SAGA.DotNetUtils.Extend;
  16. using SAGA.DotNetUtils.Logger;
  17. using SAGA.MBI.Calc;
  18. using SAGA.MBI.Common;
  19. using SAGA.MBI.Extend;
  20. using SAGA.MBI.JsonConvert;
  21. using SAGA.MBI.Model;
  22. using SAGA.MBI.Tools;
  23. using SAGA.RevitUtils.Extends;
  24. using SAGA.MBI.RequestData;
  25. namespace SAGA.MBI.DataArrange
  26. {
  27. /// <summary>
  28. /// DalCommon
  29. /// </summary>
  30. public class DalCommon
  31. {
  32. /// <summary>
  33. /// 获取设备的信息,同时根据bimid,请求云平台id
  34. /// </summary>
  35. /// <param name="elem"></param>
  36. /// <returns></returns>
  37. public static MRevitEquipBase GetEquipmentQueryId(Element elem)
  38. {
  39. if (elem == null) return null;
  40. MRevitEquipBase equipment = null;
  41. //空间
  42. if (elem.IsSpace())
  43. {
  44. equipment = DalSpace.GetSpaceQueryId(elem);
  45. }
  46. else
  47. {
  48. if (elem is FamilyInstance fi)
  49. {
  50. //信标
  51. if (fi.IsBeacon())
  52. {
  53. equipment = DalBeacon.GetBeaconQueryId(fi);
  54. }
  55. else
  56. {
  57. string familyCode = fi.GetFamilyCode();
  58. //Code的位数为4,判定为设备,6位是部件
  59. if (familyCode.IsNotNullEmptyExt())
  60. {
  61. if (fi.IsEquipment())
  62. equipment = DalEquip.GetEquipmentnQueryId(fi);
  63. else if (fi.IsEquipmentPart())
  64. equipment = DalEquipPart.GetEquipPartQueryId(fi);
  65. }
  66. }
  67. }
  68. }
  69. return equipment ?? GetDefaultEquipBase(elem);
  70. }
  71. /// <summary>
  72. /// 获取设备的信息,不请求云平台id
  73. /// </summary>
  74. /// <param name="elem"></param>
  75. /// <returns></returns>
  76. public static MRevitEquipBase GetEquipmentBase(Element elem)
  77. {
  78. MRevitEquipBase equipment = GetDefaultEquipBase(elem);
  79. if (equipment == null) return null;
  80. //空间
  81. if (elem.IsSpace())
  82. {
  83. equipment = DalSpace.GetSpace(elem);
  84. }
  85. else
  86. {
  87. if (elem is FamilyInstance fi)
  88. {
  89. //信标
  90. if (fi.IsBeacon())
  91. {
  92. equipment = DalBeacon.GetBeacon(fi);
  93. }
  94. else
  95. {
  96. string familyCode = fi.GetFamilyCode();
  97. equipment.RevitCode = familyCode;
  98. //Code的位数为4,判定为设备,6位是部件
  99. if (familyCode.IsNotNullEmptyExt())
  100. {
  101. MEquipmentFamily family = CommonTool.GetEquipFamily(familyCode);
  102. if (family != null)
  103. {
  104. if (fi.IsEquipment())
  105. equipment = DalEquip.GetEquipment(fi);
  106. else if (fi.IsEquipmentPart())
  107. equipment = DalEquipPart.GetEquipPart(fi);
  108. }
  109. }
  110. }
  111. }
  112. }
  113. return equipment;
  114. }
  115. /// <summary>
  116. /// 获取无法识别的模型实体类
  117. /// </summary>
  118. /// <param name="elem"></param>
  119. /// <returns></returns>
  120. public static MRevitEquipBase GetDefaultEquipBase(Element elem)
  121. {
  122. if (elem == null) return null;
  123. MRevitEquipBaseNull mode = new MRevitEquipBaseNull();
  124. mode.BimID = elem.Id.ToString();
  125. var family = elem.GetFamily();
  126. if (family != null)
  127. {
  128. mode.Name = family.Name;
  129. mode.PreviewImage = family.GetPreviewImage(new System.Drawing.Size(200, 200));
  130. }
  131. else
  132. {
  133. mode.Name = elem.Name;
  134. }
  135. return mode;
  136. }
  137. /// <summary>
  138. /// 删除云端的岗位数据,
  139. /// 包括所有的设备,部件,信标,空间
  140. /// </summary>
  141. /// <param name="floorId"></param>
  142. public static bool DelFloorCloudData(string floorId)
  143. {
  144. try
  145. {
  146. var list = DownLoadCouldData(floorId);
  147. list.ForEach(t => t.DelObject());
  148. return true;
  149. }
  150. catch (Exception e)
  151. {
  152. Console.WriteLine(e);
  153. }
  154. return false;
  155. }
  156. /// <summary>
  157. /// 更新bimid
  158. /// </summary>
  159. /// <param name="id">岗位id</param>
  160. /// <param name="bimid"></param>
  161. /// <returns></returns>
  162. public static bool UpdateBimId(string id, string bimid)
  163. {
  164. //保留,清除BIMID
  165. JObject jObject = new JObject();
  166. JArray jArray = CommonTool.GetPropertyJArray(bimid);
  167. jObject.Add("BIMID", jArray);
  168. JObject infos = jObject;
  169. return CommonConvert.UpdateInfosSigle(id, infos);
  170. }
  171. /// <summary>
  172. /// 获取云平台所有revit相关的数据
  173. /// </summary>
  174. public static List<MRevitEquipBase> DownLoadCouldData(string floorId, string[] type = null)
  175. {
  176. List<MRevitEquipBase> list = new List<MRevitEquipBase>();
  177. if (type == null)
  178. type = new[] { "Eq", "Ec", "VOBc", "Si" };
  179. var goodhandTypes = new[] { "Eq", "Ec", "VOBc" };
  180. var bygoodhandQuerys = type.Where(t => goodhandTypes.Contains(t)).ToArray();
  181. if (bygoodhandQuerys.Any())
  182. {
  183. //通过goodhand后台查询的数据,设备,部件,信标
  184. list.AddRange(CommonConvert.FloorQuery_GoodHand(floorId, bygoodhandQuerys));
  185. }
  186. var bySubsetQuerys = type.Where(t => !goodhandTypes.Contains(t)).ToArray();
  187. if (bySubsetQuerys.Any())
  188. {
  189. //通过subset_query查询的数据,空间,业务空间
  190. list.AddRange(CommonConvert.FloorQuery_SubSet(floorId,bySubsetQuerys));
  191. }
  192. return list;
  193. }
  194. /// <summary>
  195. /// 下载云平台的数据
  196. /// </summary>
  197. public static CalcContext DownLoadCouldData(MFloor floor, string[] type = null)
  198. {
  199. var floorId = floor.Id;
  200. CalcContext context = new CalcContext(floor);
  201. var list = DownLoadCouldData(floorId, type);
  202. list.ForEach(context.Add);
  203. return context;
  204. }
  205. /// <summary>
  206. /// 下载云平台的数据,使用BIMId里面的楼层标记,确定楼层,BIMId中包含所属楼层信息
  207. /// </summary>
  208. public static CalcContext DownLoadFloorDataByBIMFloorInfo(MFloor floor)
  209. {
  210. var floorId = floor.Id;
  211. CalcContext context = new CalcContext(floor);
  212. var list = DownLoadFloorDataByBIMFloorInfo(floorId);
  213. list.ForEach(context.Add);
  214. return context;
  215. }
  216. /// <summary>
  217. /// 下载云平台的数据,使用BIMId里面的楼层标记,确定楼层
  218. /// </summary>
  219. public static List<MRevitEquipBase> DownLoadFloorDataByBIMFloorInfo(string floorId, string[] type = null)
  220. {
  221. List<MRevitEquipBase> list = new List<MRevitEquipBase>();
  222. if (type == null)
  223. type = new[] { "Eq", "Ec", "VOBc", "Si" };
  224. var json = CommonRequest.DownLoadFloorDataByBIMFloorInfo(floorId, type);
  225. if (!json.IsRequestHasItem()) return list;
  226. JObject jObject = JObject.Parse(json);
  227. foreach (JObject jobjItem in jObject["Content"])
  228. {
  229. var mode = CommonConvert.JsonToEquipBase(floorId, jobjItem);
  230. list.Add(mode);
  231. }
  232. return list;
  233. }
  234. /// <summary>
  235. /// 删除对应云平台的对象,目前支持:元空间,设备,部件,信标
  236. /// </summary>
  237. //public static void DelByBimId(string floorId, string bimId)
  238. public static bool Delete(string cloudId)
  239. {
  240. //空间
  241. if (Regex.IsMatch(cloudId, @"Si\S*"))
  242. {
  243. var rlt = new RltEquipInSpace(null, cloudId) { Operator = DocumentChangedOperator.Delete };
  244. rlt.DelObject();
  245. //删除空间
  246. return SpaceConvert.DelSpace(cloudId);
  247. }
  248. //设备
  249. if (Regex.IsMatch(cloudId, @"Eq\S*"))
  250. {
  251. var rlt = new RltEquipInSpace(cloudId, null) { Operator = DocumentChangedOperator.Delete };
  252. rlt.DelObject(); //删除空间
  253. return EquipmentConvert.DelEquipment(cloudId);
  254. }
  255. // 部件
  256. if (Regex.IsMatch(cloudId, @"Ec\S*"))
  257. {
  258. var rlt = new RltEquipInSpace(cloudId, null) { Operator = DocumentChangedOperator.Delete };
  259. rlt.DelObject();
  260. return EquipmentPartConvert.DelEquipmentPart(cloudId);
  261. }
  262. //信标
  263. if (Regex.IsMatch(cloudId, @"VOBc\S*"))
  264. {
  265. var rltbeaconinsp = new RltBeaconinElementSp(cloudId, null) { Operator = DocumentChangedOperator.Delete };
  266. rltbeaconinsp.DelObject();
  267. return BeaconConvert.Delete(cloudId);
  268. }
  269. return false;
  270. }
  271. /// <summary>
  272. /// 获取未指定楼层的设备
  273. /// </summary>
  274. /// <param name="floorId"></param>
  275. /// <returns></returns>
  276. public static List<MRevitEquipBase> GetUndefineFloorEquipBases(string floorId)
  277. {
  278. string buildingId = DalProjectTree.GetBuildingIdByFloor(floorId);
  279. return CommonConvert.QueryOutsideObject(null, buildingId, "", RelationConst.EquipinFloorGraphId,
  280. RelationConst.EquipinFloorRelationType, -1, new[] { "Eq", "Ec" });
  281. }
  282. /// <summary>
  283. /// 批量更新Infos
  284. /// </summary>
  285. /// <param name="datas"></param>
  286. public static void BatchUpdate(IEnumerable<MRevitEquipBase> datas)
  287. {
  288. var criterias = new JArray();
  289. foreach (MRevitEquipBase data in datas)
  290. {
  291. if (data.Operator == DocumentChangedOperator.Modified)
  292. {
  293. if (data.Id.IsNullOrEmpty()) continue;
  294. JObject criteria = CommonConvert.GetUpdateInfosJObject(data.Id, data.GetInfosJObject());
  295. criterias.Add(criteria);
  296. }
  297. else
  298. {
  299. data.AddorUpdateObject();
  300. }
  301. }
  302. if (criterias.Count > 0)
  303. CommonRequest.BatchUpdate(criterias);
  304. }
  305. /// <summary>
  306. /// 批量更新关系
  307. /// </summary>
  308. /// <param name="relations"></param>
  309. public static void BetchUpdateRelation(IEnumerable<MGraphRelationBase> relations)
  310. {
  311. JArray criteriasAdd = new JArray();
  312. JArray criteriasDel = new JArray();
  313. string graphId = null, relationType = null;
  314. foreach (MGraphRelationBase relation in relations)
  315. {
  316. if (relation.GraphId.IsNullOrEmpty() || relation.RelationType.IsNullOrEmpty())
  317. continue;
  318. if (graphId.IsNullOrEmpty())
  319. {
  320. graphId = RelationRequest.GetCurrentGraphId(relation.GraphId);
  321. relationType = relation.RelationType;
  322. }
  323. if (graphId == null || relation.FromId == null || relation.ToId == null) continue;
  324. JObject jObject = new JObject();
  325. jObject.Add("from_id", relation.FromId);
  326. jObject.Add("to_id", relation.ToId);
  327. jObject.Add("graph_id", graphId);
  328. jObject.Add("rel_type", relationType);
  329. switch (relation.Operator)
  330. {
  331. case DocumentChangedOperator.Add:
  332. criteriasAdd.Add(jObject);
  333. break;
  334. case DocumentChangedOperator.Delete:
  335. criteriasDel.Add(jObject);
  336. break;
  337. }
  338. }
  339. JObject relJObject;
  340. if (criteriasAdd.Any())
  341. {
  342. relJObject = new JObject();
  343. relJObject.Add("criterias", criteriasAdd);
  344. RelationRequest.AddRelation(relJObject);
  345. }
  346. if (criteriasDel.Any())
  347. {
  348. relJObject = new JObject();
  349. relJObject.Add("criterias", criteriasDel);
  350. RelationRequest.DeleteRelation(relJObject);
  351. }
  352. }
  353. /// <summary>
  354. /// 获取mbi数据信息
  355. /// </summary>
  356. /// <param name="floorId"></param>
  357. /// <param name="type"></param>
  358. /// <returns></returns>
  359. public static List<JObject> GetMBIDatas(string floorId, string[] type = null)
  360. {
  361. List<JObject> list = new List<JObject>();
  362. if (type == null)
  363. type = new[] { "Eq", "Ec", "VOBc", "Si" };
  364. var typelist = type.ToList();
  365. string spacetype = "Si";
  366. //空间
  367. if (typelist.Contains(spacetype))
  368. {
  369. #region 获取空间数据
  370. string json = SpaceRequest.GetFloorSpaceInfos(floorId);
  371. if (json.IsRequestHasItem())
  372. {
  373. JObject jObject = JObject.Parse(json);
  374. foreach (JObject jobjItem in jObject["Content"])
  375. {
  376. list.Add(jobjItem);
  377. }
  378. }
  379. #endregion
  380. typelist.Remove(spacetype);
  381. }
  382. //其它
  383. if (typelist.Any())
  384. {
  385. var json = CommonRequest.FloorQuery_GoodHand(floorId, type);
  386. #region 获取除空间外的数据
  387. if (json.IsRequestHasItem())
  388. {
  389. JObject jObject = JObject.Parse(json);
  390. foreach (JObject jobjItem in jObject["Content"])
  391. {
  392. list.Add(jobjItem);
  393. }
  394. }
  395. #endregion
  396. }
  397. return list;
  398. }
  399. /// <summary>
  400. /// 根据对象id获取mbi数据
  401. /// </summary>
  402. /// <param name="id"></param>
  403. /// <returns></returns>
  404. public static JObject GetMBIData(string id)
  405. {
  406. try
  407. {
  408. var result = CommonRequest.QueryObjectById(id);
  409. if (!result.IsRequestHasItem())
  410. {
  411. return null;
  412. }
  413. return (JObject)JObject.Parse(result)["Content"][0];
  414. }
  415. catch (Exception ex)
  416. {
  417. return null;
  418. }
  419. }
  420. private static List<MRevitEquipBase> m_AllRevitObjects = null;
  421. /// <summary>
  422. /// 在缓存中通过bimid查找
  423. /// 如果查找不到,重新加载缓存
  424. /// </summary>
  425. /// <param name="bimId"></param>
  426. /// <returns></returns>
  427. public static MRevitEquipBase QueryObjectByBIMID(string bimId)
  428. {
  429. MRevitEquipBase rbase = null;
  430. if (m_AllRevitObjects != null)
  431. {
  432. rbase = m_AllRevitObjects?.FirstOrDefault(t => t.BimID == bimId);
  433. }
  434. if (rbase == null)
  435. {
  436. string floorId = bimId.GetFloorId();
  437. string buildingId = DalProjectTree.GetBuildingIdByFloor(floorId);
  438. m_AllRevitObjects = CommonConvert.CacheAllData(buildingId);
  439. rbase = m_AllRevitObjects.FirstOrDefault(t => t.BimID == bimId);
  440. }
  441. return rbase;
  442. }
  443. /// <summary>
  444. /// 缓存所有Revit数据,除了信标
  445. /// </summary>
  446. /// <param name="buildingId"></param>
  447. /// <returns></returns>
  448. public static List<MRevitEquipBase> GetAllDutys(string buildingId)
  449. {
  450. return CommonConvert.CacheAllData(buildingId);
  451. }
  452. /// <summary>
  453. /// 由BimID查询CloudID
  454. /// </summary>
  455. /// <param name="bimId"></param>
  456. /// <returns></returns>
  457. public static string QueryDutyIdByBIMID(string bimId)
  458. {
  459. return QueryObjectByBIMID(bimId)?.Id;
  460. }
  461. /// <summary>
  462. /// 由id查询岗位信息
  463. /// </summary>
  464. /// <param name="id"></param>
  465. /// <returns></returns>
  466. public static MRevitEquipBase QueryObjectById(string id)
  467. {
  468. return CommonConvert.QueryObjectById(id);
  469. }
  470. }
  471. }