package com.by4cloud.platformx.business.mapper;
|
|
import com.baomidou.dynamic.datasource.annotation.DS;
|
import com.by4cloud.platformx.business.vo.CustBankVo;
|
import com.by4cloud.platformx.business.vo.CustInfoVo;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.List;
|
|
@Mapper
|
@DS("druid_bip_view")
|
public interface BipViewMapper {
|
|
@Select("select certificate_id, cust_name,legal_person,registration_address from mdm_send.mdm_cust_base_info_tra_send WHERE is_deleted = '0' and cust_name = #{companyName}")
|
CustInfoVo selectBaseInfoByCustName(String companyName);
|
|
@Select("SELECT mcbats.bank_account,mcbats.bank_name FROM mdm_send.mdm_cust_bank_account_tra_send AS mcbats WHERE is_deleted = '0' and holder_name = #{companyName}")
|
List<CustBankVo> selectBankByCustName(String companyName);
|
}
|
