package com.mandi.basicconfig.mapper;

import org.apache.ibatis.annotations.Select;

import com.mandi.basicconfig.persist.Ncck;
import com.mandi.basicconfig.persist.Ncdepart;
import com.mandi.basicconfig.persist.Nchj;
import com.mandi.basicconfig.persist.Nchw;
import com.mandi.basicconfig.persist.Nccrklx;
import com.mandi.basicconfig.persist.Nckh;
import com.mandi.basicconfig.persist.Ncwl;
import com.mandi.basicconfig.persist.Ncworker;
import com.mandi.basicconfig.persist.Ncbzlx;
import com.mandi.basicconfig.persist.Ncywdy;
import com.mandi.basicconfig.persist.Nczt;

public interface NczsjMapper {
	
	@Select("select name,depotNo as code from repertory where pkid=#{pkid} ")
	public Ncck getNcckbyPkid(String pkid);
	
	@Select("select top 1 a.code code,a.name name,c.bianhao yktcode,c.name yktname from nc_depart a LEFT JOIN nc_depart_nexus b on a.pkid=b.pkid LEFT JOIN depart c on b.departNo=c.bianhao where a.code=#{code} ")
	public Ncdepart getNcdepartbyCode(String code);
	
	@Select("SELECT top 1 code,name from nc_hj where code=#{code} ")
	public Nchj getNchjbyCode(String code);
	
	@Select("SELECT code,name from nc_hw where pkid=#{pkid} ")
	public Nchw getNchwbyPkid(String pkid);
	
	@Select("SELECT top 1 companyNo code,name from company where companyNo=#{code}")
	public Nckh getNckhbyCode(String code);
	
	@Select("SELECT top 1 materielNo code,name from materiel where materielNo=#{code} ")
	public Ncwl getNcwlbyCode(String code);
	
	@Select("SELECT top 1 gonghao yktcode,name,nc_code code from enterworker where nc_code=#{code} ")
	public Ncworker getNcworkerbyCode(String code);
	
	@Select("SELECT top 1  code,name from nc_bzlx where code=#{code} ")
	public Ncbzlx getNczpbzbyCode(String code);
	
	@Select("SELECT top 1  code,name from nc_zt where code=#{code} ")
	public Nczt getNcztbyCode(String code);
	
	@Select("SELECT top 1 a.code,a.name,c.bianhao yktCode,c.name yktName  from nc_ywdy a LEFT JOIN nc_ywdy_nexus b on a.pkid=b.pkid LEFT JOIN depart c on b.sdepartNo=c.bianhao where a.code=#{code} ")
	public Ncywdy getNcywdybyCode(String code);
	
	@Select("select top 1 * from nc_crklx where code=#{code} ")
	public Nccrklx getNcjylxbycode(String code);
	
}