| | |
| | | import com.baomidou.dynamic.datasource.annotation.DS; |
| | | import com.by4cloud.platformx.business.vo.CustBankVo; |
| | | import com.by4cloud.platformx.business.vo.CustInfoVo; |
| | | import com.by4cloud.platformx.business.vo.OrgInfoVo; |
| | | 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,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 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); |
| | | |
| | | @Select("select org_code,org_name,org_level from mdm_send.mdp_organize_tra_send WHERE is_deleted = '0' and org_name = #{companyName} ") |
| | | List<OrgInfoVo> selectOrgByName(String partyA); |
| | | } |