From 061f67ee25e3991ab55ae5b9cac7bde86bb422dd Mon Sep 17 00:00:00 2001 From: xuhy <3313886187@qq.com> Date: 星期三, 08 一月 2025 09:37:02 +0800 Subject: [PATCH] 订单导入 --- ruoyi-service/ruoyi-admin/src/main/java/com/ruoyi/admin/importExcel/FrozenBuckleImportDTO.java | 25 +++++++++++++++++++------ 1 files changed, 19 insertions(+), 6 deletions(-) diff --git a/ruoyi-service/ruoyi-admin/src/main/java/com/ruoyi/admin/importExcel/FrozenBuckleImportDTO.java b/ruoyi-service/ruoyi-admin/src/main/java/com/ruoyi/admin/importExcel/FrozenBuckleImportDTO.java index f763e31..f3b58d6 100644 --- a/ruoyi-service/ruoyi-admin/src/main/java/com/ruoyi/admin/importExcel/FrozenBuckleImportDTO.java +++ b/ruoyi-service/ruoyi-admin/src/main/java/com/ruoyi/admin/importExcel/FrozenBuckleImportDTO.java @@ -1,7 +1,9 @@ package com.ruoyi.admin.importExcel; import com.alibaba.excel.annotation.ExcelProperty; +import com.alibaba.excel.annotation.write.style.HeadFontStyle; import lombok.Data; +import org.apache.poi.ss.usermodel.IndexedColors; import java.io.Serializable; @@ -10,29 +12,40 @@ */ @Data public class FrozenBuckleImportDTO implements Serializable { - @ExcelProperty(value = "站点名称") + @ExcelProperty(value = "*站点名称") + @HeadFontStyle(fontName = "黑体", fontHeightInPoints = 11,color = 10) private String siteName; - @ExcelProperty(value = "服务信息") + @ExcelProperty(value = "*服务信息") + @HeadFontStyle(fontName = "黑体", fontHeightInPoints = 11,color = 10) private String serveName; - @ExcelProperty(value = "预约姓名") + @ExcelProperty(value = "*预约姓名") + @HeadFontStyle(fontName = "黑体", fontHeightInPoints = 11,color = 10) private String reservationName; - @ExcelProperty(value = "预约电话") + @ExcelProperty(value = "*预约电话") + @HeadFontStyle(fontName = "黑体", fontHeightInPoints = 11,color = 10) private String reservationPhone; @ExcelProperty(value = "省份(四川省)") + @HeadFontStyle(fontName = "黑体", fontHeightInPoints = 11) private String province; @ExcelProperty(value = "市(成都市)") + @HeadFontStyle(fontName = "黑体", fontHeightInPoints = 11) private String city; @ExcelProperty(value = "区(武侯区)") + @HeadFontStyle(fontName = "黑体", fontHeightInPoints = 11) private String area; - @ExcelProperty(value = "详细地址") + @ExcelProperty(value = "*详细地址") + @HeadFontStyle(fontName = "黑体", fontHeightInPoints = 11,color = 10) private String reservationAddress; - @ExcelProperty(value = "上门时间(2025.01.01)") + @ExcelProperty(value = "*上门时间(2024-02-28 16:00)") + @HeadFontStyle(fontName = "黑体", fontHeightInPoints = 11,color = 10) private String time; @ExcelProperty(value = "服务人员") + @HeadFontStyle(fontName = "黑体", fontHeightInPoints = 11) private String serverName; @ExcelProperty(value = "备注") + @HeadFontStyle(fontName = "黑体", fontHeightInPoints = 11) private String reservationRemark; private Integer siteId; -- Gitblit v1.7.1