CmSite.cs 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel.DataAnnotations;
  4. using System.ComponentModel.DataAnnotations.Schema;
  5. using Newtonsoft.Json;
  6. namespace FMSAdmin.Entities {
  7. public partial class CmSite {
  8. public CmSite() {
  9. BemsAlarmSetting = new HashSet<BemsAlarmSetting>();
  10. BemsChartInfo = new HashSet<BemsChartInfo>();
  11. BemsEnergyConfigPercentMonth = new HashSet<BemsEnergyConfigPercentMonth>();
  12. BemsEnergyConfigPercentWeek = new HashSet<BemsEnergyConfigPercentWeek>();
  13. BemsMeasureSchedule = new HashSet<BemsMeasureSchedule>();
  14. BemsNoticePrice = new HashSet<BemsNoticePrice>();
  15. BemsPeakHistory = new HashSet<BemsPeakHistory>();
  16. BemsPeopleIncrease = new HashSet<BemsPeopleIncrease>();
  17. BemsRentalRate = new HashSet<BemsRentalRate>();
  18. BemsSitePrice = new HashSet<BemsSitePrice>();
  19. BemsSitePriceHistory = new HashSet<BemsSitePriceHistory>();
  20. BemsWeatherHourly = new HashSet<BemsWeatherHourly>();
  21. CmBuilding = new HashSet<CmBuilding>();
  22. CmCompany = new HashSet<CmCompany>();
  23. CmDepartment = new HashSet<CmDepartment>();
  24. CmFacilityTempSet = new HashSet<CmFacilityTempSet>();
  25. CmFile = new HashSet<CmFile>();
  26. CmHoliday = new HashSet<CmHoliday>();
  27. CmHolidayCustom = new HashSet<CmHolidayCustom>();
  28. CmMenu = new HashSet<CmMenu>();
  29. CmPatrolCourse = new HashSet<CmPatrolCourse>();
  30. CmPatrolCoursePos = new HashSet<CmPatrolCoursePos>();
  31. CmPatrolGroup = new HashSet<CmPatrolGroup>();
  32. CmPatrolHistory = new HashSet<CmPatrolHistory>();
  33. CmPatrolHistoryPos = new HashSet<CmPatrolHistoryPos>();
  34. CmPatrolPlan = new HashSet<CmPatrolPlan>();
  35. CmPatrolPos = new HashSet<CmPatrolPos>();
  36. CmPatrolSchedule = new HashSet<CmPatrolSchedule>();
  37. CmPatrolType = new HashSet<CmPatrolType>();
  38. CmUserGroup = new HashSet<CmUserGroup>();
  39. CmZoneTempHumiSet = new HashSet<CmZoneTempHumiSet>();
  40. FmsDrawing = new HashSet<FmsDrawing>();
  41. FmsLicense = new HashSet<FmsLicense>();
  42. FmsMaterial = new HashSet<FmsMaterial>();
  43. FmsMaterialCarriedForward = new HashSet<FmsMaterialCarriedForward>();
  44. FmsMaterialCodeLocation = new HashSet<FmsMaterialCodeLocation>();
  45. FmsMaterialPurchaseOrder = new HashSet<FmsMaterialPurchaseOrder>();
  46. FmsMaterialPurchaseRequest = new HashSet<FmsMaterialPurchaseRequest>();
  47. FmsMaterialRelease = new HashSet<FmsMaterialRelease>();
  48. FmsMaterialStored = new HashSet<FmsMaterialStored>();
  49. FmsMaterialTradeCompany = new HashSet<FmsMaterialTradeCompany>();
  50. FmsMaterialWarehouse = new HashSet<FmsMaterialWarehouse>();
  51. FmsReport = new HashSet<FmsReport>();
  52. FmsWorkCodeCauseClass = new HashSet<FmsWorkCodeCauseClass>();
  53. FmsWorkCodeCycleUnit = new HashSet<FmsWorkCodeCycleUnit>();
  54. FmsWorkCodeEmergency = new HashSet<FmsWorkCodeEmergency>();
  55. FmsWorkCodeHolidayWorkType = new HashSet<FmsWorkCodeHolidayWorkType>();
  56. FmsWorkCodeLegalInspectionAgency = new HashSet<FmsWorkCodeLegalInspectionAgency>();
  57. FmsWorkOrder = new HashSet<FmsWorkOrder>();
  58. FmsWorkRequest = new HashSet<FmsWorkRequest>();
  59. BemsAlarmGroupUser = new HashSet<BemsAlarmGroupUser>();
  60. FmsAccident = new HashSet<FmsAccident>();
  61. Equipments = new HashSet<FmsEquipment>();
  62. EquipmentRentInfoList = new HashSet<FmsEquipmentRentInfo>();
  63. FmsManual = new HashSet<FmsManual>();
  64. FmsManualHistory = new HashSet<FmsManualHistory>();
  65. FmsEquipmentHistory = new HashSet<FmsEquipmentHistory>();
  66. FmsAlarmPointList = new HashSet<FmsAlarmPoint>();
  67. FmsAlarmLogList = new HashSet<FmsAlarmLog>();
  68. BemsMonitoringPointHistory15minList = new HashSet<BemsMonitoringPointHistory15min>();
  69. CmRentalStatus = new HashSet<CmRentalStatus>();
  70. CmOrganizationChartStatus = new HashSet<CmOrganizationChartStatus>();
  71. CmCertificateStatus = new HashSet<CmCertificateStatus>();
  72. CmLayout = new HashSet<CmLayout>();
  73. FmsFacilityStateDetail = new HashSet<FmsFacilityStateDetail>();
  74. BemsReportHistory = new HashSet<BemsReportHistory>();
  75. FmsDailyReport = new HashSet<FmsDailyReport>();
  76. FmsMonthlyReport = new HashSet<FmsMonthlyReport>();
  77. FmsEnergyAnalysis = new HashSet<FmsEnergyAnalysis>();
  78. CmSurvey = new HashSet<CmSurvey>();
  79. }
  80. [Display(Name = "고유번호"), Key]
  81. public int SiteId { get; set; }
  82. [Display(Name = "현장 이름"), Required]
  83. [StringLength(50)]
  84. public string Name { get; set; }
  85. [Display(Name = "현장 주소 우편번호 1")]
  86. [StringLength(5)]
  87. public string AddressZip1 { get; set; }
  88. [Display(Name = "현장 주소 우편번호 2")]
  89. [StringLength(3)]
  90. public string AddressZip2 { get; set; }
  91. [Display(Name = "현장 주소 1")]
  92. [StringLength(100)]
  93. public string Address1 { get; set; }
  94. [Display(Name = "현장 주소 ")]
  95. [StringLength(100)]
  96. public string Adderss2 { get; set; }
  97. [Display(Name = "현장 전화번호")]
  98. [StringLength(24)]
  99. public string PhoneNo { get; set; }
  100. [Display(Name = "현장 홈페이지"), Column("URL")]
  101. [StringLength(100)]
  102. public string Url { get; set; }
  103. [Display(Name = "현장 세부설명")]
  104. [StringLength(1024)]
  105. public string Comment { get; set; }
  106. [Display(Name = "사용 유무")]
  107. public bool? IsUse { get; set; }
  108. [Display(Name = "정렬 번호")]
  109. public int? SortOrderNo { get; set; }
  110. [Display(Name = "데이터 생성일"), Column(TypeName = "datetime")]
  111. public DateTime? InsertedDate { get; set; }
  112. [Display(Name = "데이터 생성자 고유번호")]
  113. [StringLength(24)]
  114. public string InsertedUserId { get; set; }
  115. [Display(Name = "데이터 변경일"), Column(TypeName = "datetime")]
  116. public DateTime? UpdatedDate { get; set; }
  117. [Display(Name = "데이터 변경자 고유번호")]
  118. [StringLength(24)]
  119. public string UpdatedUserId { get; set; }
  120. [Display(Name = "(자동-true/수동-false) / 제어스케줄")]
  121. public bool? IsControlSchedule { get; set; }
  122. [Display(Name = "제어 스케쥴 시각")]
  123. public int? ScheduleCheckHour { get; set; }
  124. [Display(Name = "최대전력")]
  125. public double? MaxPeak { get; set; }
  126. [Display(Name = "위도"), Column("lat")]
  127. public double? Lat { get; set; }
  128. [Display(Name = "경도"), Column("lng")]
  129. public double? Lng { get; set; }
  130. [Display(Name = "제어스케쥴"), Column("controlSchedule")]
  131. public bool? ControlSchedule { get; set; }
  132. [Display(Name = "HDD기준온도"), Column("HDD")]
  133. [StringLength(24)]
  134. public string Hdd { get; set; }
  135. [Display(Name = "CDD기준온도"), Column("CDD")]
  136. [StringLength(24)]
  137. public string Cdd { get; set; }
  138. [Display(Name = "건축규모")]
  139. [StringLength(50)]
  140. public string BuildingSize { get; set; }
  141. [Display(Name = "연면적")]
  142. [StringLength(24)]
  143. public string GrossArea { get; set; }
  144. [Display(Name = "건축면적")]
  145. [StringLength(24)]
  146. public string BuildingArea { get; set; }
  147. [Display(Name = "용적율")]
  148. [StringLength(24)]
  149. public string FloorAreaRatio { get; set; }
  150. [Display(Name = "건폐율")]
  151. [StringLength(24)]
  152. public string BuildingCoverageRatio { get; set; }
  153. [Display(Name = "주용도")]
  154. [StringLength(10)]
  155. public string MainUse { get; set; }
  156. [Display(Name = "준공연도")]
  157. [StringLength(24)]
  158. public string CompletionDate { get; set; }
  159. [Display(Name = "용도별표준값")]
  160. [StringLength(24)]
  161. public string Standard { get; set; }
  162. [Display(Name = "주용도Index")]
  163. public int? MainUseIndex { get; set; }
  164. [Display(Name = "이미지")]
  165. public int? ImageFileId { get; set; }
  166. [ForeignKey("SiteId,ImageFileId")]
  167. public virtual CmFile ImageFile { get; set; }
  168. [Display(Name = "날씨API 시도")]
  169. public string ApiSido { get; set; }
  170. [Display(Name = "날씨API 시구군")]
  171. public string ApiSigun { get; set; }
  172. [Display(Name = "대시보드 이미지맵 X")]
  173. public int? ImageMapX { get; set; }
  174. [Display(Name = "대시보드 이미지맵 Y")]
  175. public int? ImageMapY { get; set; }
  176. [Display(Name = "설계/감리")]
  177. public string DesignSupervision { get; set; }
  178. [Display(Name = "시공사")]
  179. public string ConstructionCompany { get; set; }
  180. [Display(Name = "공사기간")]
  181. public string ConstructionPeriod { get; set; }
  182. [Display(Name = "구조")]
  183. public string Structure { get; set; }
  184. [Display(Name = "로비바닥")]
  185. public string LobbyFloor { get; set; }
  186. [Display(Name = "사무실바닥")]
  187. public string OfficeFloor { get; set; }
  188. [Display(Name = "화장실바닥")]
  189. public string ToiletFloor { get; set; }
  190. [Display(Name = "E/V홀")]
  191. public string EVHall { get; set; }
  192. [Display(Name = "주차장")]
  193. public string ParkingLot { get; set; }
  194. [Display(Name = "외벽")]
  195. public string OuterWall { get; set; }
  196. [Display(Name = "대지면적")]
  197. public string LandArea { get; set; }
  198. [Display(Name = "조경면적")]
  199. public string LandscapingArea { get; set; }
  200. [Display(Name = "건물층수")]
  201. public string BuildingFloors { get; set; }
  202. [Display(Name = "건고")]
  203. public string BuildingHeight { get; set; }
  204. [Display(Name = "전용율")]
  205. public string ConversionRate { get; set; }
  206. [Display(Name = "주차장시설")]
  207. public string ParkingFacilities { get; set; }
  208. [Display(Name = "강당시설")]
  209. public string AuditoriumFacilities { get; set; }
  210. public bool IsAdmin { get; set; }
  211. [InverseProperty("Site")]
  212. public virtual BemsEnergyDailyRegression BemsEnergyDailyRegression { get; set; }
  213. [InverseProperty("Site")]
  214. public virtual BemsPeakInfo BemsPeakInfo { get; set; }
  215. [InverseProperty("Site")]
  216. public virtual CmHolidayWeekend CmHolidayWeekend { get; set; }
  217. [JsonIgnore]
  218. [InverseProperty("Site")]
  219. public virtual ICollection<BemsAlarmSetting> BemsAlarmSetting { get; set; }
  220. [JsonIgnore]
  221. [InverseProperty("Site")]
  222. public virtual ICollection<BemsChartInfo> BemsChartInfo { get; set; }
  223. [JsonIgnore]
  224. [InverseProperty("Site")]
  225. public virtual ICollection<BemsEnergyConfigPercentMonth> BemsEnergyConfigPercentMonth { get; set; }
  226. [JsonIgnore]
  227. [InverseProperty("Site")]
  228. public virtual ICollection<BemsEnergyConfigPercentWeek> BemsEnergyConfigPercentWeek { get; set; }
  229. [JsonIgnore]
  230. [InverseProperty("Site")]
  231. public virtual ICollection<BemsMeasureSchedule> BemsMeasureSchedule { get; set; }
  232. [JsonIgnore]
  233. [InverseProperty("Site")]
  234. public virtual ICollection<BemsNoticePrice> BemsNoticePrice { get; set; }
  235. [JsonIgnore]
  236. [InverseProperty("Site")]
  237. public virtual ICollection<BemsPeakHistory> BemsPeakHistory { get; set; }
  238. [JsonIgnore]
  239. [InverseProperty("Site")]
  240. public virtual ICollection<BemsPeopleIncrease> BemsPeopleIncrease { get; set; }
  241. [JsonIgnore]
  242. [InverseProperty("Site")]
  243. public virtual ICollection<BemsRentalRate> BemsRentalRate { get; set; }
  244. [JsonIgnore]
  245. [InverseProperty("Site")]
  246. public virtual ICollection<BemsSitePrice> BemsSitePrice { get; set; }
  247. [JsonIgnore]
  248. [InverseProperty("Site")]
  249. public virtual ICollection<BemsSitePriceHistory> BemsSitePriceHistory { get; set; }
  250. [JsonIgnore]
  251. [InverseProperty("Site")]
  252. public virtual ICollection<BemsWeatherHourly> BemsWeatherHourly { get; set; }
  253. [JsonIgnore]
  254. [InverseProperty("CmSite")]
  255. public virtual ICollection<BemsReportFormat> BemsReportFormat { get; set; }
  256. [JsonIgnore]
  257. [InverseProperty("CmSite")]
  258. public virtual ICollection<CmBuilding> CmBuilding { get; set; }
  259. [JsonIgnore]
  260. [InverseProperty("Site")]
  261. public virtual ICollection<CmCompany> CmCompany { get; set; }
  262. [JsonIgnore]
  263. [InverseProperty("Site")]
  264. public virtual ICollection<CmDepartment> CmDepartment { get; set; }
  265. [JsonIgnore]
  266. [InverseProperty("Site")]
  267. public virtual ICollection<CmFacilityTempSet> CmFacilityTempSet { get; set; }
  268. [JsonIgnore]
  269. [InverseProperty("Site")]
  270. public virtual ICollection<CmFile> CmFile { get; set; }
  271. [JsonIgnore]
  272. [InverseProperty("Site")]
  273. public virtual ICollection<CmHoliday> CmHoliday { get; set; }
  274. [JsonIgnore]
  275. [InverseProperty("Site")]
  276. public virtual ICollection<CmHolidayCustom> CmHolidayCustom { get; set; }
  277. [JsonIgnore]
  278. [InverseProperty("Site")]
  279. public virtual ICollection<CmMenu> CmMenu { get; set; }
  280. [JsonIgnore]
  281. [InverseProperty("Site")]
  282. public virtual ICollection<CmPatrolCourse> CmPatrolCourse { get; set; }
  283. [JsonIgnore]
  284. [InverseProperty("Site")]
  285. public virtual ICollection<CmPatrolCoursePos> CmPatrolCoursePos { get; set; }
  286. [JsonIgnore]
  287. [InverseProperty("Site")]
  288. public virtual ICollection<CmPatrolGroup> CmPatrolGroup { get; set; }
  289. [JsonIgnore]
  290. [InverseProperty("Site")]
  291. public virtual ICollection<CmPatrolHistory> CmPatrolHistory { get; set; }
  292. [JsonIgnore]
  293. [InverseProperty("Site")]
  294. public virtual ICollection<CmPatrolHistoryPos> CmPatrolHistoryPos { get; set; }
  295. [JsonIgnore]
  296. [InverseProperty("Site")]
  297. public virtual ICollection<CmPatrolPlan> CmPatrolPlan { get; set; }
  298. [JsonIgnore]
  299. [InverseProperty("Site")]
  300. public virtual ICollection<CmPatrolPos> CmPatrolPos { get; set; }
  301. [JsonIgnore]
  302. [InverseProperty("Site")]
  303. public virtual ICollection<CmPatrolSchedule> CmPatrolSchedule { get; set; }
  304. [JsonIgnore]
  305. [InverseProperty("Site")]
  306. public virtual ICollection<CmPatrolType> CmPatrolType { get; set; }
  307. [JsonIgnore]
  308. [InverseProperty("Site")]
  309. public virtual ICollection<CmUserGroup> CmUserGroup { get; set; }
  310. [JsonIgnore]
  311. [InverseProperty("Site")]
  312. public virtual ICollection<CmZoneTempHumiSet> CmZoneTempHumiSet { get; set; }
  313. [JsonIgnore]
  314. [InverseProperty("CmSite")]
  315. public virtual ICollection<FmsDrawing> FmsDrawing { get; set; }
  316. [JsonIgnore]
  317. [InverseProperty("Site")]
  318. public virtual ICollection<FmsLicense> FmsLicense { get; set; }
  319. [JsonIgnore]
  320. [InverseProperty("CmSite")]
  321. public virtual ICollection<FmsMaterial> FmsMaterial { get; set; }
  322. [JsonIgnore]
  323. [InverseProperty("Site")]
  324. public virtual ICollection<FmsMaterialCarriedForward> FmsMaterialCarriedForward { get; set; }
  325. [JsonIgnore]
  326. [InverseProperty("Site")]
  327. public virtual ICollection<FmsMaterialCodeLocation> FmsMaterialCodeLocation { get; set; }
  328. [JsonIgnore]
  329. [InverseProperty("Site")]
  330. public virtual ICollection<FmsMaterialPurchaseOrder> FmsMaterialPurchaseOrder { get; set; }
  331. [JsonIgnore]
  332. [InverseProperty("Site")]
  333. public virtual ICollection<FmsMaterialPurchaseRequest> FmsMaterialPurchaseRequest { get; set; }
  334. [JsonIgnore]
  335. [InverseProperty("Site")]
  336. public virtual ICollection<FmsMaterialRelease> FmsMaterialRelease { get; set; }
  337. [JsonIgnore]
  338. [InverseProperty("Site")]
  339. public virtual ICollection<FmsMaterialStored> FmsMaterialStored { get; set; }
  340. [JsonIgnore]
  341. [InverseProperty("Site")]
  342. public virtual ICollection<FmsMaterialTradeCompany> FmsMaterialTradeCompany { get; set; }
  343. [JsonIgnore]
  344. [InverseProperty("Site")]
  345. public virtual ICollection<FmsMaterialWarehouse> FmsMaterialWarehouse { get; set; }
  346. [JsonIgnore]
  347. [InverseProperty("Site")]
  348. public virtual ICollection<FmsReport> FmsReport { get; set; }
  349. [JsonIgnore]
  350. [InverseProperty("Site")]
  351. public virtual ICollection<FmsWorkCodeCauseClass> FmsWorkCodeCauseClass { get; set; }
  352. [JsonIgnore]
  353. [InverseProperty("Site")]
  354. public virtual ICollection<FmsWorkCodeCycleUnit> FmsWorkCodeCycleUnit { get; set; }
  355. [JsonIgnore]
  356. [InverseProperty("Site")]
  357. public virtual ICollection<FmsWorkCodeEmergency> FmsWorkCodeEmergency { get; set; }
  358. [JsonIgnore]
  359. [InverseProperty("Site")]
  360. public virtual ICollection<FmsWorkCodeHolidayWorkType> FmsWorkCodeHolidayWorkType { get; set; }
  361. [JsonIgnore]
  362. [InverseProperty("Site")]
  363. public virtual ICollection<FmsWorkCodeLegalInspectionAgency> FmsWorkCodeLegalInspectionAgency { get; set; }
  364. [JsonIgnore]
  365. [InverseProperty("Site")]
  366. public virtual ICollection<FmsWorkOrder> FmsWorkOrder { get; set; }
  367. [JsonIgnore]
  368. [InverseProperty("Site")]
  369. public virtual ICollection<FmsWorkRequest> FmsWorkRequest { get; set; }
  370. [InverseProperty("CmSite")]
  371. public virtual ICollection<BemsAlarmGroupUser> BemsAlarmGroupUser { get; set; }
  372. [InverseProperty("CmSite")]
  373. public virtual ICollection<FmsAccident> FmsAccident { get; set; }
  374. [InverseProperty(nameof(FmsEquipment.Site))]
  375. public virtual ICollection<FmsEquipment> Equipments { get; set; }
  376. [InverseProperty(nameof(FmsEquipmentRentInfo.Site))]
  377. public virtual ICollection<FmsEquipmentRentInfo> EquipmentRentInfoList { get; set; }
  378. [InverseProperty("CmSite")]
  379. public virtual ICollection<FmsManual> FmsManual { get; set; }
  380. [InverseProperty("CmSite")]
  381. public virtual ICollection<FmsManualHistory> FmsManualHistory { get; set; }
  382. [InverseProperty("CmSite")]
  383. public virtual ICollection<FmsEquipmentHistory> FmsEquipmentHistory { get; set; }
  384. [InverseProperty("Site")]
  385. public virtual ICollection<FmsAlarmPoint> FmsAlarmPointList { get; set; }
  386. [InverseProperty("Site")]
  387. public virtual ICollection<FmsAlarmLog> FmsAlarmLogList { get; set; }
  388. [InverseProperty("Site")]
  389. public virtual ICollection<BemsMonitoringPointHistory15min> BemsMonitoringPointHistory15minList { get; set; }
  390. [InverseProperty("CmSite")]
  391. public virtual ICollection<CmRentalStatus> CmRentalStatus { get; set; }
  392. [InverseProperty("CmSite")]
  393. public virtual ICollection<CmOrganizationChartStatus> CmOrganizationChartStatus { get; set; }
  394. [InverseProperty("CmSite")]
  395. public virtual ICollection<CmCertificateStatus> CmCertificateStatus { get; set; }
  396. [InverseProperty("CmSite")]
  397. public virtual ICollection<CmLayout> CmLayout { get; set; }
  398. [JsonIgnore]
  399. [InverseProperty("CmSite")]
  400. public virtual ICollection<FmsFacilityStateDetail> FmsFacilityStateDetail { get; set; }
  401. [JsonIgnore]
  402. [InverseProperty("Site")]
  403. public virtual ICollection<BemsReportHistory> BemsReportHistory { get; set; }
  404. [JsonIgnore]
  405. [InverseProperty("Site")]
  406. public virtual ICollection<FmsDailyReport> FmsDailyReport { get; set; }
  407. [JsonIgnore]
  408. [InverseProperty("Site")]
  409. public virtual ICollection<FmsMonthlyReport> FmsMonthlyReport { get; set; }
  410. [JsonIgnore]
  411. [InverseProperty("CmSite")]
  412. public virtual ICollection<FmsEnergyAnalysis> FmsEnergyAnalysis { get; set; }
  413. [JsonIgnore]
  414. [InverseProperty("CmSite")]
  415. public virtual ICollection<CmSurvey> CmSurvey { get; set; }
  416. }
  417. }