package com.mandi.fendan.mapper;
|
|
import java.util.List;
|
import java.util.Map;
|
|
import org.apache.ibatis.annotations.Delete;
|
import org.apache.ibatis.annotations.Insert;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
import org.apache.ibatis.annotations.Update;
|
|
import com.mandi.basicconfig.persist.Ncywdy;
|
import com.mandi.fendan.persist.Fd_Company;
|
import com.mandi.fendan.persist.Fd_Company_Ywdy;
|
|
public interface Fd_CompanyMapper{
|
@Select("select a.* from fd_company a where a.id=#{id}")
|
public Fd_Company get(String id);
|
@Select("select a.* from fd_company a where a.companyNo=#{companyNo}")
|
public Fd_Company getByCompanyNo(String companyNo);
|
|
@Select("select top 1 a.* from fd_company a where a.hasSPR=#{hasSPR}")
|
public Fd_Company getFdcbyhasSPR(boolean hasSPR);
|
|
@Delete("delete from fd_company where id=#{id}")
|
public int del(String id);
|
@Delete("delete from fd_company where companyNo=#{companyNo}")
|
public int delByCompanyNo(String companyNo);
|
|
@Update("update fd_company set cname=#{cname},companyNo=#{companyNo},ctime=#{ctime},hdpinyin=#{hdpinyin},name=#{name},note=#{note},pinyin=#{pinyin},hasSPR=#{hasSPR} where id=#{id} ")
|
public int update(Fd_Company fd_company);
|
@Insert("insert into fd_company (id,cname,companyNo,ctime,hdpinyin,name,note,pinyin,hasSPR) values (#{id},#{cname},#{companyNo},#{ctime},#{hdpinyin},#{name},#{note},#{pinyin},#{hasSPR})")
|
public int insert(Fd_Company fd_company);
|
|
/**
|
* 列表分页查询
|
* @param mp
|
* @return
|
*/
|
public List<Fd_Company> getList1(Map<String, Object> mp);
|
public List<Fd_Company> getList(Map<String, Object> mp);
|
public int getPages(Map<String, Object> mp);
|
|
@Select("select * from fd_company ")
|
public List<Fd_Company> getall();
|
|
@Select("select * from fd_company_ywdy where companyNo=#{companyNo}")
|
public List<Fd_Company_Ywdy> getcynexuslist(String companyNo);
|
@Select("select b.code code,b.name name from fd_company_ywdy a LEFT JOIN nc_ywdy b on a.ywdyNo=b.code where companyNo=#{companyNo} ")
|
public List<Ncywdy> getncYwdylist(String companyNo);
|
@Delete("delete from fd_company_ywdy where companyNo=#{companyNo}")
|
public int delCYnexus(String companyNo);
|
@Insert("insert into fd_company_ywdy (companyNo,ywdyNo) values (#{companyNo},#{ywdyNo})")
|
public int insertCYnexus(@Param("companyNo")String companyNo,@Param("ywdyNo") String ywdyNo);
|
|
}
|
