package jnpf.limsMapper;
|
|
import jnpf.base.mapper.SuperMapper;
|
import jnpf.limsEntity.LimsWendingxingJianceZhixingVo;
|
import jnpf.limsEntity.LimsWendingxingKaocaJihuaZhouqiEntity;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Result;
|
import org.apache.ibatis.annotations.Results;
|
import org.apache.ibatis.annotations.Select;
|
|
@Mapper
|
public interface LimsWendingxingKaocaJihuaZhouqiMapper
|
extends SuperMapper<LimsWendingxingKaocaJihuaZhouqiEntity> {
|
|
/**
|
* 查询已完成取样且允许继续执行的稳定性周期数据。
|
*/
|
@Select("SELECT a.f_id AS id, a.kaoca_jihua_id, a.zhouqi, a.zhouqi_danwei, "
|
+ "a.pihao, a.shiqu_shuliang, a.yangpin_danwei, a.jiancha_xiangmu_ids, "
|
+ "a.jiancha_xiangmu_mingcheng, b.yangpin_mingcheng, "
|
+ "b.yangpin_bianhao, b.guige, "
|
+ "b.changqi_fangzhi_tiaojian, b.fenlei AS leixin, b.zhiliang_biaozhun, "
|
+ "b.quyangren, b.quyang_riqi, c.zhiliang_biaozhun_id,c.yangpin_id "
|
+ "FROM lims_wendingxing_kaoca_jihua_zhouqi a "
|
+ "INNER JOIN lims_wendingxing_quyangdan b ON a.kaoca_jihua_id = b.jihua_id "
|
+ "INNER JOIN lims_wendingxing_kaoca_jihua c ON a.kaoca_jihua_id = c.f_id "
|
+ "WHERE a.shifou_jixu_zhixing = 'yes' "
|
+ "AND a.pihao = b.pihao AND a.f_id = #{jihuaZhouqiId} LIMIT 1")
|
@Results(id = "wendingxingJianceZhixingResult", value = {
|
@Result(column = "id", property = "id", id = true),
|
@Result(column = "kaoca_jihua_id", property = "kaocaJihuaId"),
|
@Result(column = "zhouqi", property = "zhouqi"),
|
@Result(column = "zhouqi_danwei", property = "zhouqiDanwei"),
|
@Result(column = "pihao", property = "pihao"),
|
@Result(column = "shiqu_shuliang", property = "shiquShuliang"),
|
@Result(column = "yangpin_danwei", property = "yangpinDanwei"),
|
@Result(column = "jiancha_xiangmu_ids", property = "jianchaXiangmuIds"),
|
@Result(column = "jiancha_xiangmu_mingcheng", property = "jianchaXiangmuMingcheng"),
|
@Result(column = "yangpin_mingcheng", property = "yangpinMingcheng"),
|
@Result(column = "yangpin_id", property = "yangpinId"),
|
@Result(column = "yangpin_bianhao", property = "yangpinBianhao"),
|
@Result(column = "guige", property = "guige"),
|
@Result(column = "changqi_fangzhi_tiaojian", property = "changqiFangzhiTiaojian"),
|
@Result(column = "leixin", property = "leixin"),
|
@Result(column = "zhiliang_biaozhun", property = "zhiliangBiaozhun"),
|
@Result(column = "zhiliang_biaozhun_id", property = "zhiliangBiaozhunId"),
|
@Result(column = "quyangren", property = "quyangren"),
|
@Result(column = "quyang_riqi", property = "quyangRiqi")
|
})
|
LimsWendingxingJianceZhixingVo selectJianceZhixing(@Param("jihuaZhouqiId") String jihuaZhouqiId);
|
}
|
