| | |
|---|
| | | 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 cust_name = #{companyName}") |
|---|
| | | @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 holder_name = #{companyName}") |
|---|
| | | CustBankVo selectBankByCustName(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); |
|---|
| | | } |
|---|
