导入导出供应商增加供应商类型

huminmin

2026-04-07 4643edd644cf49fa1da8e2c5a5b69549e7a37f22

导入导出供应商增加供应商类型

 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;


 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;

 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,