因为岗位类型不是固定的,不适合在实体类里面修改,如下:
/**
* 岗位类型 字典项
*/
@Excel(name = "岗位类型")
private String dutyType;
字典表的实体类:
/** 字典名称 */
@Excel(name = "字典名称")
private String typeName;
/** 字典键值 */
@Excel(name = "字典值")
private String itemValue;
应该在controller层里面直接调用字典项的值
/**
* 导出员工
*/
@Log(title = "员工管理", businessType = BusinessType.EXPORT)
@RequiresPermissions("basic:employee:export")
@PostMapping("/export")
@ResponseBody
public AjaxResult export(FdEmployee employee) {
List<FdEmployee> list = employeeService.selectEmployeeList(employee);
for (FdEmployee e : list) {
SysDictData sysDict=new SysDictData();//字典数据表实例化
sysDict.setTypeName("岗位类型");//给字典名称赋值为"岗位类型"
sysDict.setItemValue(e.getDutyType());//获取"岗位类型"中的值,赋值给字典值
e.setDutyType(dictDataService.selectDictName(sysDict));//查询字典表内容赋值给岗位类型
}
ExcelUtil<FdEmployee> util = new ExcelUtil<FdEmployee>(FdEmployee.class);
return util.exportExcel(list, "员工信息");
}