| | |
|---|
| | | ,"plus_lock_his","tb_lock_his_"+lockId,his); |
|---|
| | | //获取锁的信息 |
|---|
| | | LockInf linf=linfMapper.getlinfBylockId(lockId); |
|---|
| | | |
|---|
| | | //当前日期 |
|---|
| | | String nowFormat = new SimpleDateFormat("yyyyMMddHHmmss").format(new Date()); |
|---|
| | | String excelName = "bl-"+nowFormat; |
|---|
| | |
|---|
| | | row1.setHeightInPoints(20.0f); |
|---|
| | | row1.createCell(0).setCellValue("所属机房："+linf.getStationName()); |
|---|
| | | row1.createCell(1).setCellValue("锁的名称："+linf.getLockName()); |
|---|
| | | row1.createCell(2).setCellValue("锁的类型：实体锁"); |
|---|
| | | rowNumSheet++; |
|---|
| | | |
|---|
| | | Row row2 = sheet.createRow(rowNumSheet); |
|---|
| | | row2.setHeightInPoints(20.0f); |
|---|
| | | switch (linf.getLockState()){ |
|---|
| | | case -1:row2.createCell(0).setCellValue("锁的状态：未安装");break; |
|---|
| | | case 0:row2.createCell(0).setCellValue("锁的状态：闭锁");break; |
|---|
| | | case 1:row2.createCell(0).setCellValue("锁的状态：开锁");break; |
|---|
| | | } |
|---|
