package com.huigou.topsun.sap.suppliers.repository;

import com.huigou.topsun.sap.suppliers.domain.SuppliersInfo;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

/**
 * @Auther: lxh
 * @Date: 2024/03/01
 * @Description:
 */
public interface SuppliersInfoRepository extends JpaRepository<SuppliersInfo,String> {

   // SapPurchaseOrder findAllByEbeln(String ebeln);
   // @Query(" select t.* from sap_suppliers_info t where 1=1 and apply_type='-1' and status in (1,3) and id= #{id}")
  //  List<SuppliersInfo> findDeletedById(String id);

    List<SuppliersInfo> findByPartner(String partner);

    /**
     * 根据供应商税号查询供应商信息
     * @param stenr
     * @return
     */
    List<SuppliersInfo> findByStenr(String stenr);
}
