package com.zy.asrs.mapper;
|
|
import com.zy.asrs.entity.LocCheck;
|
import com.baomidou.mybatisplus.mapper.BaseMapper;
|
import com.zy.asrs.entity.LocOwner;
|
import com.zy.asrs.entity.ManLocDetl;
|
import org.apache.ibatis.annotations.Delete;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.springframework.stereotype.Repository;
|
|
import java.util.List;
|
|
@Mapper
|
@Repository
|
public interface LocCheckMapper extends BaseMapper<LocCheck> {
|
|
List<ManLocDetl> getAutoLocDetl();
|
|
List<ManLocDetl> getCountLocDetl(@Param("count") int count);
|
|
List<ManLocDetl> getMatnrCountLocDetl(@Param("count") int count,@Param("matnr") String matnr);
|
|
List<ManLocDetl> getLocCountLocDetl(@Param("count") int count,@Param("loc_no") String locno);
|
|
@Delete("DELETE FROM man_loc_check")
|
boolean deleteAll();
|
|
List<String> getLocCount();
|
|
List<LocOwner> getOwnerCount();
|
|
List<ManLocDetl> getOwnerCountLocDetl(int count, String owner);
|
}
|
