using Magicodes.ExporterAndImporter.Core; using Magicodes.ExporterAndImporter.Excel; namespace Entity.Dto; [ExcelExporter(Name = "充电订单", TableStyle = OfficeOpenXml.Table.TableStyles.None, AutoFitAllColumn = true)] public class ChargeOrderDto { /// /// Desc:订单编号 /// Default: /// Nullable:True /// [ExporterHeader(DisplayName = "订单编号", IsBold = true)] public string Sn { get; set; } /// /// Desc:电池编号 /// Default: /// Nullable:True /// [ExporterHeader(DisplayName = "电池编号", IsBold = true)] public string BatteryNo { get; set; } /// /// Desc:启动报文状态;0-初始化;1-启动成功 /// Default:0 /// Nullable:True /// [ExporterHeader(DisplayName = "启动报文状态", IsBold = true)] public string CmdStatusDisplay { get { return CmdStatus switch { 0 => "初始化", 1 => "启动成功", _ => "未知" }; } } /// /// Desc:启动报文状态;0-初始化;1-启动成功 /// Default:0 /// Nullable:True /// [ExporterHeader(IsIgnore = true)] public int? CmdStatus { get; set; } /// /// Desc:充电机编号 /// Default: /// Nullable:True /// [ExporterHeader(DisplayName = "充电机编号", IsBold = true)] public string ChargerNo { get; set; } /// /// Desc:充电枪编号 /// Default: /// Nullable:True /// [ExporterHeader(DisplayName = "充电枪编号", IsBold = true)] public string ChargerGunNo { get; set; } /// /// 0:站内充电 1:站外充电 /// [ExporterHeader(DisplayName = "充电位置", IsBold = true)] public string ChargeModeDisplay { get { return ChargeMode switch { 0 => "站内充电", 1 => "站外充电", _ => "未知" }; } } /// /// 0:站内充电 1:站外充电 /// [ExporterHeader(IsIgnore = true)] public int ChargeMode { get; set; } /// /// 1:站控启动 2:本地启动 /// [ExporterHeader(DisplayName = "启动方式", IsBold = true)] public string StartModeDisplay { get { return StartMode switch { 1 => "站控启动", 2 => "本地启动", _ => "未知" }; } } /// /// 1:站控启动 2:本地启动 /// [ExporterHeader(IsIgnore = true)] public int StartMode { get; set; } /// /// 充电开始时间 /// [ExporterHeader(DisplayName = "充电开始时间", IsBold = true,Width = 30, Format = "yyyy-MM-dd HH:mm:ss", AutoCenterColumn = true)] public DateTime? StartTime { get; set; } /// /// Desc:充电结束时间 /// Default: /// Nullable:True /// [ExporterHeader(DisplayName = "充电结束时间", IsBold = true,Width = 30, Format = "yyyy-MM-dd HH:mm:ss", AutoCenterColumn = true)] public DateTime? EndTime { get; set; } /// /// Desc:充电开始soc /// Default: /// Nullable:True /// [ExporterHeader(DisplayName = "充电开始soc", IsBold = true)] public int? StartSoc { get; set; } /// /// Desc:充电结束soc /// Default: /// Nullable:True /// [ExporterHeader(DisplayName = "充电结束soc", IsBold = true)] public int? StopSoc { get; set; } /// /// Desc:充电时长 /// Default: /// Nullable:True /// [ExporterHeader(DisplayName = "充电时长", IsBold = true)] public int ChargeTimeCount { get; set; } /// /// Desc:充电电量 /// Default: /// Nullable:True /// [ExporterHeader(DisplayName = "充电电量", IsBold = true)] public decimal? ElecCount { get; set; } /// /// Desc:充电开始交流表电量 /// Default: /// Nullable:True /// [ExporterHeader(DisplayName = "充电开始交流表电量", IsBold = true)] public decimal? StartAcElec { get; set; } /// /// Desc:充电结束交流表电量 /// Default: /// Nullable:True /// [ExporterHeader(DisplayName = "充电结束交流表电量", IsBold = true)] public decimal? StopAcElec { get; set; } /// /// Desc:充电开始直流表电量 /// Default: /// Nullable:True /// [ExporterHeader(DisplayName = "充电开始直流表电量", IsBold = true)] public decimal? StartDcElec { get; set; } /// /// Desc:充电结束直流表电量 /// Default: /// Nullable:True /// [ExporterHeader(DisplayName = "充电结束直流表电量", IsBold = true)] public decimal? StopDcElec { get; set; } /// /// Desc:停止原因;0:满电自动停止;1-人工停止 /// Default:0 /// Nullable:True /// [ExporterHeader(DisplayName = "停止原因", IsBold = true)] public string StopReasonDisplay { get { return StopReason switch { 0 => "满电自动停止", 1 => "人工停止", _ => "未知" }; } } /// /// Desc:停止原因;0:满电自动停止;1-人工停止 /// Default:0 /// Nullable:True /// [ExporterHeader(IsIgnore = true)] public int? StopReason { get; set; } /// /// Desc:尖时段电量 /// Default: /// Nullable:True /// [ExporterHeader(DisplayName = "尖时段电量", IsBold = true)] public decimal? SharpElecCount { get; set; } /// /// Desc:峰时段电量 /// Default: /// Nullable:True /// [ExporterHeader(DisplayName = "峰时段电量", IsBold = true)] public decimal? PeakElecCount { get; set; } /// /// Desc:平时段电量 /// Default: /// Nullable:True /// [ExporterHeader(DisplayName = "平时段电量", IsBold = true)] public decimal? FlatElecCount { get; set; } /// /// Desc:谷时段电量 /// Default: /// Nullable:True /// [ExporterHeader(DisplayName = "谷时段电量", IsBold = true)] public decimal? ValleyElecCount { get; set; } /// /// Desc:尖时段交流电量 /// Default: /// Nullable:True /// [ExporterHeader(DisplayName = "尖时段交流电量", IsBold = true)] public decimal? ACSharpElecCount { get; set; } /// /// Desc:峰时段交流电量 /// Default: /// Nullable:True /// [ExporterHeader(DisplayName = "峰时段交流电量", IsBold = true)] public decimal? ACPeakElecCount { get; set; } /// /// Desc:平时段交流电量 /// Default: /// Nullable:True /// [ExporterHeader(DisplayName = "平时段交流电量", IsBold = true)] public decimal? ACFlatElecCount { get; set; } /// /// Desc:谷时段交流电量 /// Default: /// Nullable:True /// [ExporterHeader(DisplayName = "谷时段交流电量", IsBold = true)] public decimal? ACValleyElecCount { get; set; } /// /// Desc:电价版本号 /// Default: /// Nullable:True /// [ExporterHeader(DisplayName = "电价版本号", IsBold = true)] public string ElecPriceModelVersion { get; set; } /// /// Desc:换电订单编号 /// Default: /// Nullable:True /// [ExporterHeader(DisplayName = "换电订单编号", IsBold = true)] public string SwapOrderSn { get; set; } /// /// Desc:上传云平台状态;0-未上传;1-已上传 /// Default:0 /// Nullable:True /// [ExporterHeader(DisplayName = "上传云平台状态", IsBold = true)] public string CloudReportStatusDisplay { get { return CloudReportStatus switch { 0 => "未上传", 1 => "已上传", _ => "未知" }; } } [ExporterHeader(IsIgnore = true)] public int? CloudReportStatus { get; set; } /// /// Desc:创建人 /// Default: /// Nullable:True /// [ExporterHeader(DisplayName = "创建人", IsBold = true)] public string CreatedBy { get; set; } /// /// Desc:创建时间 /// Default:CURRENT_TIMESTAMP /// Nullable:True /// [ExporterHeader(DisplayName = "创建时间", IsBold = true,Width = 30, Format = "yyyy-MM-dd HH:mm:ss", AutoCenterColumn = true)] public DateTime? CreatedTime { get; set; } /// /// Desc:更新人 /// Default: /// Nullable:True /// [ExporterHeader(DisplayName = "更新人", IsBold = true,Width = 25)] public string UpdatedBy { get; set; } /// /// Desc:更新时间 /// Default:CURRENT_TIMESTAMP /// Nullable:True /// [ExporterHeader(DisplayName = "更新时间", IsBold = true,Width = 30, Format = "yyyy-MM-dd HH:mm:ss", AutoCenterColumn = true)] public DateTime? UpdatedTime { get; set; } /// /// 云平台充电订单 /// [ExporterHeader(DisplayName = "云平台充电订单", IsBold = true)] public string? CloudChargeOrder { get; set; } /// /// Desc:是否可以上传云平台 /// Default: /// Nullable:True /// [ExporterHeader(DisplayName = "是否可以上传云平台", IsBold = true)] public string CanUploadDisplay { get { return CanUpload switch { 0 => "不可用", 1 => "可以", _ => "未知" }; } } /// /// Desc:是否可以上传云平台 /// Default: /// Nullable:True /// [ExporterHeader(IsIgnore = true)] public int? CanUpload { get; set; } }