Machine.cs 5.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222
  1. namespace EVCB_OCPP.Domain.Models.Database
  2. {
  3. using Microsoft.EntityFrameworkCore;
  4. using System;
  5. using System.Collections.Generic;
  6. using System.ComponentModel.DataAnnotations;
  7. using System.ComponentModel.DataAnnotations.Schema;
  8. /// <summary>
  9. /// 樁的基本檔
  10. /// </summary>
  11. [Table("Machine")]
  12. [Index(nameof(ChargeBoxId), IsUnique = true)]
  13. public partial class Machine
  14. {
  15. public Machine()
  16. {
  17. Id = Guid.NewGuid().ToString();
  18. ChargePointSerialNumber = string.Empty;
  19. ChargeBoxSerialNumber = string.Empty;
  20. ChargePointModel = string.Empty;
  21. ChargePointVendor = string.Empty;
  22. Iccid = string.Empty;
  23. Imsi = string.Empty;
  24. MeterType = string.Empty;
  25. MeterSerialNumber = string.Empty;
  26. CreatedBy = string.Empty;
  27. Comment = string.Empty;
  28. HeartbeatUpdatedOn = new DateTime(1991, 1, 1);
  29. }
  30. [Key]
  31. [StringLength(36)]
  32. public string Id { get; set; }
  33. /// <summary>
  34. /// ChargeBoxId
  35. /// </summary>
  36. [StringLength(50)]
  37. public string ChargeBoxId { get; set; }
  38. /// <summary>
  39. /// chargePointSerialNumber
  40. /// </summary>
  41. [StringLength(25)]
  42. public string ChargePointSerialNumber { get; set; }
  43. /// <summary>
  44. /// chargeBoxSerialNumber
  45. /// </summary>
  46. [StringLength(25)]
  47. public string ChargeBoxSerialNumber { get; set; }
  48. /// <summary>
  49. /// chargePointModel
  50. /// </summary>
  51. [StringLength(20)]
  52. public string ChargePointModel { get; set; }
  53. /// <summary>
  54. /// chargePointVendor
  55. /// </summary>
  56. [StringLength(20)]
  57. public string ChargePointVendor { get; set; }
  58. /// <summary>
  59. /// iccid
  60. /// </summary>
  61. [StringLength(20)]
  62. public string Iccid { get; set; }
  63. /// <summary>
  64. /// imsi
  65. /// </summary>
  66. [StringLength(20)]
  67. public string Imsi { get; set; }
  68. /// <summary>
  69. /// MeterType
  70. /// </summary>
  71. [StringLength(25)]
  72. public string MeterType { get; set; }
  73. /// <summary>
  74. /// meterSerialNumber
  75. /// </summary>
  76. [StringLength(25)]
  77. public string MeterSerialNumber { get; set; }
  78. /// <summary>
  79. /// 建立時間
  80. /// </summary>
  81. public DateTime CreatedOn { get; set; }
  82. /// <summary>
  83. /// 建立者
  84. /// </summary>
  85. [StringLength(50)]
  86. public string CreatedBy { get; set; }
  87. /// <summary>
  88. /// 描述
  89. /// </summary>
  90. [StringLength(100)]
  91. public string Comment { get; set; }
  92. /// <summary>
  93. /// 客戶id
  94. /// </summary>
  95. public Guid CustomerId { get; set; }
  96. /// <summary>
  97. /// 充電槍個數
  98. /// </summary>
  99. public int GunAmt { get; set; }
  100. /// <summary>
  101. /// 心跳包更新時間
  102. /// </summary>
  103. public DateTime HeartbeatUpdatedOn { get; set; }
  104. /// <summary>
  105. /// 機器回報的韌體版本編號
  106. /// </summary>
  107. public int? FW_VersionReport { get; set; }
  108. /// <summary>
  109. /// 機器被指派的韌體版本編號
  110. /// </summary>
  111. public int? FW_AssignedVersion { get; set; }
  112. /// <summary>
  113. /// 是否在線
  114. /// </summary>
  115. public bool Online { get; set; }
  116. /// <summary>
  117. /// 電樁連線方式
  118. /// 0:unknown
  119. /// 1:1.6J with http
  120. /// 2:1.6J with https
  121. /// </summary>
  122. public int ConnectionType { get; set; }
  123. [ForeignKey("CustomerId")]
  124. public virtual Customer Customer { get; set; }
  125. /// <summary>
  126. /// 斷網時間
  127. /// </summary>
  128. public DateTime? OfflineOn { get; set; }
  129. /// <summary>
  130. /// firmwareVersion
  131. /// </summary>
  132. [StringLength(50)]
  133. public string FW_CurrentVersion { get; set; }
  134. [DataType("decimal(6 ,2)")]
  135. public decimal RatedPower { set; get; }
  136. /// <summary>
  137. /// ConnectorType
  138. /// </summary>
  139. [StringLength(50)]
  140. public string ConnectorType { get; set; }
  141. /// <summary>
  142. /// ConnectorPowerType
  143. /// </summary>
  144. [StringLength(50)]
  145. public string ConnectorPowerType { get; set; }
  146. [DataType("decimal(10 ,6)")]
  147. public decimal Latitude { set; get; }
  148. [DataType("decimal(10 ,6)")]
  149. public decimal Longitude { set; get; }
  150. /// <summary>
  151. /// VendorId
  152. /// </summary>
  153. [StringLength(50)]
  154. public string VendorId { get; set; }
  155. /// <summary>
  156. /// ModelName
  157. /// </summary>
  158. [StringLength(50)]
  159. public string ModelName { get; set; }
  160. /// <summary>
  161. /// Board Versions
  162. /// </summary>
  163. public string BoardVersions { get; set; }
  164. public bool IsDelete { set; get; }
  165. /// <summary>
  166. /// TTIA樁號代號
  167. /// </summary>
  168. public int TTIATag { set; get; }
  169. }
  170. }