From 1d72d19a9b7b6de6169e232fce5b026265f8375f Mon Sep 17 00:00:00 2001
From: huminmin <mac@MacBook-Pro.local>
Date: 星期四, 23 四月 2026 14:09:09 +0800
Subject: [PATCH] 导出销售台账送货单
---
src/main/java/com/ruoyi/sales/service/impl/SalesLedgerServiceImpl.java | 14 +++++++-------
1 files changed, 7 insertions(+), 7 deletions(-)
diff --git a/src/main/java/com/ruoyi/sales/service/impl/SalesLedgerServiceImpl.java b/src/main/java/com/ruoyi/sales/service/impl/SalesLedgerServiceImpl.java
index 3b6ea8c..d9649ca 100644
--- a/src/main/java/com/ruoyi/sales/service/impl/SalesLedgerServiceImpl.java
+++ b/src/main/java/com/ruoyi/sales/service/impl/SalesLedgerServiceImpl.java
@@ -240,7 +240,6 @@
response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(fileName, "UTF-8"));
response.setHeader("Access-Control-Expose-Headers", "Content-Disposition");
- // 鍥哄畾浣跨敤 XSSFWorkbook
XSSFWorkbook workbook = new XSSFWorkbook();
for (SalesLedger ledger : ledgerList) {
@@ -254,7 +253,6 @@
sheet.setColumnWidth(5, 4500);
sheet.setColumnWidth(6, 3500);
- // 鏍峰紡
CellStyle companyTitle = createBaseStyle(workbook, "瀹嬩綋", (short) 20, true, true);
CellStyle billTitle = createBaseStyle(workbook, "瀹嬩綋", (short) 18, true, true);
CellStyle headerStyle = createBorderStyle(workbook, "瀹嬩綋", (short) 12, true, true);
@@ -294,14 +292,17 @@
Row row7 = sheet.createRow(7);
row7.createCell(0).setCellValue("璐х墿璇︾粏淇℃伅锛�");
- // 琛ㄥご
int tableStart = 8;
Row headerRow = sheet.createRow(tableStart);
String[] headers = {"搴忓彿", "鐗╂枡缂栧彿", "鍝佸悕/瑙勬牸", "鍗曚綅", "鏁伴噺", "璁㈠崟鍙�", "鍏卞洓鑱�"};
for (int i = 0; i < headers.length; i++) {
Cell hc = headerRow.createCell(i);
hc.setCellValue(headers[i]);
- hc.setCellStyle(i == 6 ? noBorder : headerStyle);
+ if (i == 6) {
+ hc.setCellStyle(dashStyle);
+ } else {
+ hc.setCellStyle(headerStyle);
+ }
}
// 鏌ヨ鍟嗗搧
@@ -319,12 +320,11 @@
int minDataRow = 5;
int totalNeedRow = Math.max(minDataRow, fourNames.length);
- // 鏁版嵁琛� + 鍥哄畾鍥涜仈琛�
for (int i = 0; i < totalNeedRow; i++) {
SalesLedgerProduct p = i < productList.size() ? productList.get(i) : null;
Row dataRow = sheet.createRow(currentRow);
- // 鍓�6鍒楄祴鍊�
+ // 鍓�6鍒�
if (p != null) {
String materialCode = "";
if (p.getProductModelId() != null) {
@@ -350,7 +350,7 @@
dataRow.getCell(c).setCellStyle(dataCenterStyle);
}
- // 鍏卞洓鑱斿垪
+ // 绗�7鍒楋細鍏卞洓鑱斿尯鍩�
Cell fourCell = dataRow.createCell(6);
if (i < fourNames.length) {
fourCell.setCellValue(fourNames[i]);
--
Gitblit v1.9.3