目的:导出时必须和输入的数字格式一样
思路:在实体类中添加一个新的类,并且getset一下,然后在controller层导出内容里面输入根式转化的相关代码。
实体类:
/**
* 合同总额
* @author QK
*
*/
/*@Excel(name = "合同总额")*/
private Double contractSum;
@Excel(name = "合同总额")
private String contractSumS;//新增的内容
/**
* 发票金额
* @author QK
*
*/
/*@Excel(name = "发票金额")*/
private Double invoiceSum;
@Excel(name = "发票金额")
private String invoiceSumS;//新增的内容
controller层,导出内容:重点是for循环里面的内容
@Log(title = "项目发票明细管理", businessType = BusinessType.EXPORT)
@RequiresPermissions("contract:invoicer:export")
@PostMapping("/export")
@ResponseBody
public AjaxResult export(FdContractInvoicer contractInvoicer) {
List<FdContractInvoicer> list = contractInvoicerService.selectContractInvoicerList(contractInvoicer);
for (FdContractInvoicer c : list) {
String str = new BigDecimal(c.getContractSum().toString()).toString();
c.setContractSumS(str);
String str2 = new BigDecimal(c.getInvoiceSum().toString()).toString();
c.setInvoiceSumS(str2);
}
ExcelUtil<FdContractInvoicer> util = new ExcelUtil<FdContractInvoicer>(FdContractInvoicer.class);
return util.exportExcel(list, "项目发票明细");
}
eidt修改页面回显时,要添加以下内容:
<script th:inline="javascript">
var paymentr = [[${paymentr}]];
$("#contractSum").val(paymentr.contractSum);
$("#invoiceSum").val(paymentr.invoiceSum);
</script>
上面的代码是写在以下代码块之外的:
<script type="text/javascript">
</script>