EquipmentExcel2.java 2.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596
  1. package com.persagy.proxy.adm.model;
  2. import org.apache.poi.ss.usermodel.Font;
  3. import com.alibaba.excel.annotation.ExcelProperty;
  4. import com.alibaba.excel.annotation.write.style.ColumnWidth;
  5. import com.alibaba.excel.annotation.write.style.HeadFontStyle;
  6. import lombok.Getter;
  7. import lombok.Setter;
  8. /**
  9. * @version
  10. * @description 不在空间内的设备数据导出实体类
  11. * @company persagy
  12. * @author zhangqiankun
  13. * @since 2020年11月26日: 下午12:30:39
  14. */
  15. @Getter
  16. @Setter
  17. @HeadFontStyle(color = Font.COLOR_NORMAL)
  18. public class EquipmentExcel2 {
  19. @ColumnWidth(10)
  20. @ExcelProperty(value = "序号", index=0)
  21. private String index;
  22. @ColumnWidth(25)
  23. @ExcelProperty(value = "项目名称", index=1)
  24. private String projectName;
  25. @ColumnWidth(20)
  26. @ExcelProperty(value = "建筑", index=2)
  27. private String buildName;
  28. @ColumnWidth(20)
  29. @ExcelProperty(value = "楼层", index=3)
  30. private String floorName;
  31. @ColumnWidth(10)
  32. @ExcelProperty(value = "系统编码", index=4)
  33. private String systemCode;
  34. @ColumnWidth(20)
  35. @ExcelProperty(value = "系统名称", index=5)
  36. private String systemName;
  37. @ColumnWidth(10)
  38. @ExcelProperty(value = "设备类型编码", index=6)
  39. private String equipCode;
  40. @ColumnWidth(20)
  41. @ExcelProperty(value = "设备类型名称", index=7)
  42. private String equipName;
  43. @ColumnWidth(50)
  44. @ExcelProperty(value = "设备ID", index=8)
  45. private String equipId;
  46. @ColumnWidth(50)
  47. @ExcelProperty(value = "BIMID", index=9)
  48. private String bimId;
  49. @ColumnWidth(20)
  50. @ExcelProperty(value = "本地编码", index=10)
  51. private String localId;
  52. @ColumnWidth(20)
  53. @ExcelProperty(value = "本地名称", index=11)
  54. private String localName;
  55. @ColumnWidth(10)
  56. @ExcelProperty(value = "【信息点】应绑点位总数", index=12)
  57. private String needPointCount;
  58. @ColumnWidth(10)
  59. @ExcelProperty(value = "【信息点】已绑点位总数", index=13)
  60. private String nowPointCount;
  61. @ColumnWidth(10)
  62. @ExcelProperty(value = "【信息点】静态应绑点", index=14)
  63. private String needStaticPointCount;
  64. @ColumnWidth(10)
  65. @ExcelProperty(value = "【信息点】静态已绑点", index=15)
  66. private String nowStaticPointCount;
  67. @ColumnWidth(10)
  68. @ExcelProperty(value = "【信息点】动态应绑点", index=16)
  69. private String needDynamicPointCount;
  70. @ColumnWidth(10)
  71. @ExcelProperty(value = "【信息点】动态已绑点", index=17)
  72. private String nowDynamicPointCount;
  73. }