From 2ff68802d432b0a0358814e0c1820b95a2a92e03 Mon Sep 17 00:00:00 2001 From: huanghongfa <18228131219@163.com> Date: 星期六, 20 二月 2021 09:50:33 +0800 Subject: [PATCH] all --- springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/dtos/user/EexcelUserDTO.java | 40 +++++++++++++++++++++++++++++++++++++++- 1 files changed, 39 insertions(+), 1 deletions(-) diff --git a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/dtos/user/EexcelUserDTO.java b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/dtos/user/EexcelUserDTO.java index 2ee562d..b2effc1 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/dtos/user/EexcelUserDTO.java +++ b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/dtos/user/EexcelUserDTO.java @@ -1,99 +1,137 @@ package com.panzhihua.common.model.dtos.user; +import com.alibaba.excel.annotation.ExcelIgnore; +import com.alibaba.excel.annotation.ExcelProperty; +import lombok.Data; + /** * @program: springcloud_k8s_panzhihuazhihuishequ * @description: 居民信息excel导入 * @author: huang.hongfa weixin hhf9596 qq 959656820 * @create: 2021-02-04 16:06 **/ +@Data public class EexcelUserDTO { /** * 序号 */ - private Integer order; + @ExcelProperty("序号") + private String order; /** * 门牌号 */ + @ExcelProperty("门牌号") private String doorNumber; /** * 是否租住 */ + @ExcelProperty("是否租住") private String isRent; /** * 姓名 */ + @ExcelProperty("姓名") private String name; /** * 民族 */ + @ExcelProperty("民族") private String nation; /** * 政治面貌 */ + @ExcelProperty("政治面貌") private String politicalOutlook; /** * 婚姻状态 */ + @ExcelProperty("婚姻状态") private String maritalStatus; /** * 联系方式 */ + @ExcelProperty("联系方式") private String phone; /** * 文化程度 */ + @ExcelProperty("文化程度") private String education; /** * 身份证 */ + @ExcelProperty("身份证") private String idCard; /** * 工作单位(学校) */ + @ExcelProperty("工作单位(学校)") private String company; /** * 户口所在地 */ + @ExcelProperty("户口所在地") private String residence; /** * 目前是否在攀枝花 */ + @ExcelProperty("目前是否在攀枝花") private String isPanZhiHua; /** * 近一个月离(返)攀情况 */ + @ExcelProperty("近一个月离(返)攀情况") private String situation; /** * 是否有与疑似或确诊病例密切接触史 */ + @ExcelProperty("是否有与疑似或确诊病例密切接触史") private String isContact; /** * 特殊情况(重大过往病史或者孕妇) */ + @ExcelProperty("特殊情况(重大过往病史或者孕妇") private String major; /** * 退役军人 */ + @ExcelProperty("退役军人") private String soldier; + /** + * 残疾人 + */ + @ExcelProperty("残疾人") + private String disability; /** * 低保户 */ + @ExcelProperty("低保户") private String lowIncomeHouseholds; /** * 低收入人员 */ + @ExcelProperty("低收入人员") private String lowIncomePeople; /** * 高龄老人 */ + @ExcelProperty("高龄老人") private String oldPeople; /** *特服家庭 */ + @ExcelProperty("特服家庭") private String specialServiceFamily; /** *重点人员 */ + @ExcelProperty("重点人员") private String keyPersonnel; + /** + * 房屋编码 + */ + @ExcelIgnore + private String houseCode; + } -- Gitblit v1.7.1