From 4643edd644cf49fa1da8e2c5a5b69549e7a37f22 Mon Sep 17 00:00:00 2001
From: huminmin <mac@MacBook-Pro.local>
Date: 星期二, 07 四月 2026 13:04:30 +0800
Subject: [PATCH] 导入导出供应商增加供应商类型

---
 src/main/java/com/ruoyi/basic/excel/SupplierManageExcelDto.java |    4 ++++
 src/main/resources/mapper/basic/SupplierManageMapper.xml        |    2 ++
 src/main/java/com/ruoyi/basic/pojo/SupplierManage.java          |    4 ++++
 3 files changed, 10 insertions(+), 0 deletions(-)

diff --git a/src/main/java/com/ruoyi/basic/excel/SupplierManageExcelDto.java b/src/main/java/com/ruoyi/basic/excel/SupplierManageExcelDto.java
index 29e1af0..7637a7d 100644
--- a/src/main/java/com/ruoyi/basic/excel/SupplierManageExcelDto.java
+++ b/src/main/java/com/ruoyi/basic/excel/SupplierManageExcelDto.java
@@ -15,6 +15,10 @@
     @Excel(name = "渚涘簲鍟嗗悕绉�")
     private String supplierName;
 
+    @ApiModelProperty(value = "渚涘簲鍟嗙被鍨�")
+    @Excel(name = "渚涘簲鍟嗙被鍨�")
+    private String supplierType;
+
     @Excel(name = "绾崇◣浜鸿瘑鍒彿")
     private String taxpayerIdentificationNum;
 
diff --git a/src/main/java/com/ruoyi/basic/pojo/SupplierManage.java b/src/main/java/com/ruoyi/basic/pojo/SupplierManage.java
index aa33cbf..ec3fb43 100644
--- a/src/main/java/com/ruoyi/basic/pojo/SupplierManage.java
+++ b/src/main/java/com/ruoyi/basic/pojo/SupplierManage.java
@@ -40,6 +40,10 @@
     @Excel(name = "璐﹀彿")
     private String bankAccountNum;
 
+    @ApiModelProperty(value = "渚涘簲鍟嗙被鍨�")
+    @Excel(name = "渚涘簲鍟嗙被鍨�")
+    private String supplierType;
+
     @ApiModelProperty(value = "鑱旂郴浜�")
     @Excel(name = "鑱旂郴浜�")
     private String contactUserName;
diff --git a/src/main/resources/mapper/basic/SupplierManageMapper.xml b/src/main/resources/mapper/basic/SupplierManageMapper.xml
index ba7fac3..741b0e3 100644
--- a/src/main/resources/mapper/basic/SupplierManageMapper.xml
+++ b/src/main/resources/mapper/basic/SupplierManageMapper.xml
@@ -8,6 +8,7 @@
         SELECT
         T1.id,
         T1.supplier_name,
+        T1.supplier_type,
         T1.taxpayer_identification_num,
         T1.company_address,
         T1.company_phone,
@@ -40,6 +41,7 @@
         SELECT
         T1.id,
         T1.supplier_name,
+        T1.supplier_type,
         T1.taxpayer_identification_num,
         T1.company_address,
         T1.company_phone,

--
Gitblit v1.9.3