| | |
| | | @Select("select certificate_id, cust_name,legal_person,registration_address,cust_code,country,custclass from mdm_send.mdm_cust_base_info_tra_send WHERE is_deleted = '0' and cust_name = #{companyName}") |
| | | CustInfoVo selectBaseInfoByCustName(String companyName); |
| | | |
| | | @Select("select certificate_id, cust_name,legal_person,registration_address,cust_code,country,custclass from mdm_send.mdm_cust_base_info_tra_send WHERE is_deleted = '0' and certificate_id = #{companyName}") |
| | | CustInfoVo selectBaseInfoByCertId(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); |
| | | |