From 07a2f9c762efb3be3a29e2e8cc7004d4164cc9d8 Mon Sep 17 00:00:00 2001
From: fei <791364011@qq.com>
Date: 星期一, 22 十二月 2025 20:15:58 +0800
Subject: [PATCH] 修改了对应代码

---
 archiveManager/src/main/java/com/ruoyi/domain/ArchiveRecords.java |   75 +++++++++++++++++++++++++++----------
 1 files changed, 54 insertions(+), 21 deletions(-)

diff --git a/archiveManager/src/main/java/com/ruoyi/domain/ArchiveRecords.java b/archiveManager/src/main/java/com/ruoyi/domain/ArchiveRecords.java
index 5aed5c0..a2346dd 100644
--- a/archiveManager/src/main/java/com/ruoyi/domain/ArchiveRecords.java
+++ b/archiveManager/src/main/java/com/ruoyi/domain/ArchiveRecords.java
@@ -10,6 +10,7 @@
 import org.apache.commons.lang3.builder.ToStringStyle;
 import com.ruoyi.common.annotation.Excel;
 import com.ruoyi.common.core.domain.BaseEntity;
+import org.apache.poi.ss.usermodel.IndexedColors;
 
 /**
  * 妗f璁板綍瀵硅薄 archive_records
@@ -25,13 +26,16 @@
     @TableId(type = IdType.AUTO)
 
     private Long id;
+    @TableField(exist = false)
 
+    @Excel(name = "搴忓彿", headerColor = IndexedColors.BLACK, width = 8)
+    private String num;
     /** 妗f鍙� */
-    @Excel(name = "妗f鍙�")
+    @Excel(name = "妗f鍙�", headerColor = IndexedColors.RED, width = 6)
     private String recordId;
 
     /** 鍙戦棶鍙� */
-    @Excel(name = "鍙戦棶鍙�")
+    @Excel(name = "鍙戞枃鍙�", headerColor = IndexedColors.RED, width = 10)
     private String inquiryNumber;
 
     public String getEveryProjectName() {
@@ -42,82 +46,101 @@
         this.everyProjectName = everyProjectName;
     }
 
-    @Excel(name = "姣忎釜妗堝嵎灞炰簬鐨勯」鐩悕绉�")
+  //  @Excel(name = "椤圭洰鍚嶇О", headerColor = IndexedColors.BLACK)
 
     private String everyProjectName;
     /** 妗堝嵎棰樺悕 */
-    @Excel(name = "妗堝嵎棰樺悕")
+    @Excel(name = "妗堝嵎棰樺悕", headerColor = IndexedColors.RED, width = 10)
     private String caseTitle;
 
     /** 鍏紑灞炴�� */
-    @Excel(name = "鍏紑灞炴��")
+    @Excel(name = "鍏紑灞炴��", headerColor = IndexedColors.BLACK, width = 8)
     private String publicAttribute;
 
     /** 缂栧埗鍗曚綅 */
-    @Excel(name = "缂栧埗鍗曚綅")
+    @Excel(name = "缂栧埗鍗曚綅", headerColor = IndexedColors.BLACK, width = 8)
     private String preparationUnit;
 
     /** 缂栧埗鏃ユ湡 */
     @JsonFormat(pattern = "yyyy-MM-dd")
-    @Excel(name = "缂栧埗鏃ユ湡", width = 30, dateFormat = "yyyy-MM-dd")
+    @Excel(name = "缂栧埗鏃ユ湡", width = 11, dateFormat = "yyyy-MM-dd", headerColor = IndexedColors.BLACK)
     private Date preparationDate;
 
     /** 淇濈鏈熼檺 */
-    @Excel(name = "淇濈鏈熼檺")
+    @Excel(name = "淇濈鏈熼檺", headerColor = IndexedColors.BLACK , width = 8)
     private String retentionPeriod;
 
     /** 瀵嗙骇 */
-    @Excel(name = "瀵嗙骇")
+    @Excel(name = "瀵嗙骇", headerColor = IndexedColors.BLACK, width = 6)
+
     private String securityClassification;
 
-    @Excel(name = "妗堝嵎鐘舵��")
+//    @Excel(name = "妗堝嵎鐘舵��")
     private String recordStatus;
 
     /** 妗堝嵎椤垫暟 */
-    @Excel(name = "妗堝嵎椤垫暟")
+    @Excel(name = "妗堝嵎椤垫暟", headerColor = IndexedColors.BLACK, width = 8)
     private Long pageCount;
 
     /** 绔嬫鍙� */
-    @Excel(name = "绔嬫鍙�")
+    @Excel(name = "绔嬫鍙�", headerColor = IndexedColors.BLACK, width = 8)
     private String filingNumber;
 
     /** 寤鸿鍗曚綅 */
-    @Excel(name = "寤鸿鍗曚綅")
+    @Excel(name = "寤鸿鍗曚綅", headerColor = IndexedColors.RED, width = 10)
     private String constructionUnit;
 
     /** 寤鸿鍦板潃 */
-    @Excel(name = "寤鸿鍦板潃")
+    @Excel(name = "寤鸿鍦板潃", headerColor = IndexedColors.RED, width = 9)
     private String constructionAddress;
 
     /** 寤鸿椤圭洰鍚嶇О */
-    @Excel(name = "寤鸿椤圭洰鍚嶇О")
+    @Excel(name = "寤鸿椤圭洰鍚嶇О", headerColor = IndexedColors.RED, width = 14)
     private String projectName;
 
     /** 椤圭洰缂栧彿 */
-    @Excel(name = "椤圭洰缂栧彿")
+    @Excel(name = "椤圭洰缂栧彿", headerColor = IndexedColors.BLACK, width = 8)
     private String projectNumber;
 
     /** 鎵弿鍔犲伐鍏徃 */
-    @Excel(name = "鎵弿鍔犲伐鍏徃")
+    @Excel(name = "鎵弿鍔犲伐鍏徃", headerColor = IndexedColors.BLACK, width = 12)
     private String scanningCompany;
 
     /** 妗f绠�(瀹�)鍙� */
-    @Excel(name = "妗f绠�(瀹�)鍙�")
+    @Excel(name = "妗f绠�(瀹�)鍙�", headerColor = IndexedColors.BLACK, width = 14)
     private String archiveRoomNumber;
 
     /** 缂╁井鍙� */
-    @Excel(name = "缂╁井鍙�")
+    @Excel(name = "缂╁井鍙�", headerColor = IndexedColors.BLACK, width = 8)
     private String microfilmNumber;
 
     /** 澶囨敞 */
-    @Excel(name = "澶囨敞")
+    @Excel(name = "澶囨敞", headerColor = IndexedColors.BLACK, width = 8)
     private String remarks;
 
+    @TableField(exist = false)
+    private String categoryNumberStart;
 
+    public String getCategoryNumberStart() {
+        return categoryNumberStart;
+    }
 
+    public void setCategoryNumberStart(String categoryNumberStart) {
+        this.categoryNumberStart = categoryNumberStart;
+    }
 
+    public String getCategoryNumberEnd() {
+        return categoryNumberEnd;
+    }
+
+    public void setCategoryNumberEnd(String categoryNumberEnd) {
+        this.categoryNumberEnd = categoryNumberEnd;
+    }
+
+    @TableField(exist = false)
+    private String categoryNumberEnd;
     /** 鍘嗗彶鐩稿叧鍙戞枃鍙� */
-    @Excel(name = "鍘嗗彶鐩稿叧鍙戞枃鍙�")
+    @Excel(name = "鍘嗗彶鐩稿叧鍙戞枃鍙�", headerColor = IndexedColors.RED, width = 14)
     private String historicalReferenceNumber;
 
     @TableField(exist = false)
@@ -390,6 +413,16 @@
         return historicalReferenceNumber;
     }
 
+    public void setNum(String num) 
+    {
+        this.num = num;
+    }
+
+    public String getNum() 
+    {
+        return num;
+    }
+
     @Override
     public String toString() {
         return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)

--
Gitblit v1.9.1