From 809562f45f703f99f9f75618428cef59a6458799 Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期一, 30 三月 2026 17:39:05 +0800
Subject: [PATCH] yys 1.设备导入,人员导入

---
 src/main/java/com/ruoyi/device/execl/DeviceLedgerExeclDto.java |   36 +++++++++++++++++++++---------------
 1 files changed, 21 insertions(+), 15 deletions(-)

diff --git a/src/main/java/com/ruoyi/device/execl/DeviceLedgerExeclDto.java b/src/main/java/com/ruoyi/device/execl/DeviceLedgerExeclDto.java
index 576bef0..01906d6 100644
--- a/src/main/java/com/ruoyi/device/execl/DeviceLedgerExeclDto.java
+++ b/src/main/java/com/ruoyi/device/execl/DeviceLedgerExeclDto.java
@@ -1,12 +1,14 @@
 package com.ruoyi.device.execl;
 
-import com.baomidou.mybatisplus.annotation.FieldFill;
-import com.baomidou.mybatisplus.annotation.TableField;
+import com.fasterxml.jackson.annotation.JsonFormat;
 import com.ruoyi.framework.aspectj.lang.annotation.Excel;
+import io.swagger.annotations.ApiModelProperty;
 import lombok.Data;
+import org.springframework.format.annotation.DateTimeFormat;
 
 import java.math.BigDecimal;
-import java.time.LocalDateTime;
+import java.time.LocalDate;
+import java.util.Date;
 
 @Data
 public class DeviceLedgerExeclDto {
@@ -17,6 +19,18 @@
      */
     @Excel(name = "璁惧鍚嶇О" ,sort = 1)
     private String deviceName;
+
+    /**
+     * 璁惧绫诲瀷
+     */
+    @Excel(name = "璁惧绫诲瀷",sort = 0,combo = {"鐢熶骇璁惧","鍔炲叕璁惧","妫�鏌ヨ澶�","杩愯緭璁惧","鍏朵粬璁惧"})
+    private String type;
+
+    @ApiModelProperty("璁″垝杩愯鏃堕棿")
+    @JsonFormat(pattern = "yyyy-MM-dd")
+    @DateTimeFormat(pattern = "yyyy-MM-dd")
+    @Excel(name = "璁″垝杩愯鏃堕棿",sort = 10,dateFormat = "yyyy-MM-dd")
+    private Date planRuntimeTime;
 
     /**
      * 瑙勬牸鍨嬪彿
@@ -39,8 +53,8 @@
     /**
      * 鏁伴噺
      */
-    @Excel(name = "鏁伴噺",sort = 5)
-    private BigDecimal number;
+    @Excel(name = "鏁伴噺",sort = 5, type = Excel.Type.EXPORT)
+    private BigDecimal number = BigDecimal.ONE;
 
     /**
      * 鍚◣鍗曚环
@@ -51,7 +65,7 @@
     /**
      * 鍚◣鎬讳环
      */
-    @Excel(name = "鍚◣鎬讳环",sort = 7)
+    @Excel(name = "鍚◣鎬讳环",sort = 7, type = Excel.Type.EXPORT)
     private BigDecimal taxIncludingPriceTotal;
 
     /**
@@ -63,16 +77,8 @@
     /**
      * 涓嶅惈绋庢�讳环
      */
-    @Excel(name = "涓嶅惈绋庢�讳环",sort = 9)
+    @Excel(name = "涓嶅惈绋庢�讳环",sort = 9, type = Excel.Type.EXPORT)
     private BigDecimal unTaxIncludingPriceTotal;
-
-    /**
-     * 褰曞叆鏃堕棿
-     *
-     */
-    @Excel(name = "褰曞叆鏃堕棿",sort = 10)
-    private LocalDateTime createTime;
-
 
 
     /**

--
Gitblit v1.9.3