/* * Copyright (c) 2018-2025, ztt All rights reserved. * * Redistribution and use in source and binary forms, with or without * modification, are permitted provided that the following conditions are met: * * Redistributions of source code must retain the above copyright notice, * this list of conditions and the following disclaimer. * Redistributions in binary form must reproduce the above copyright * notice, this list of conditions and the following disclaimer in the * documentation and/or other materials provided with the distribution. * Neither the name of the pig4cloud.com developer nor the names of its * contributors may be used to endorse or promote products derived from * this software without specific prior written permission. * Author: ztt */ package com.chinaztt.mes.warehouse.mapper; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.chinaztt.mes.warehouse.dto.CheckDetailDTO; import com.chinaztt.mes.warehouse.dto.CheckMainDTO; import com.chinaztt.mes.warehouse.entity.CheckDetail; import com.chinaztt.mes.warehouse.entity.CheckMain; import com.chinaztt.ztt.common.core.util.R; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import java.util.List; /** * 盘点明细表 * * @author sunxl * @date 2020-12-01 13:42:14 */ @Mapper public interface CheckDetailMapper extends BaseMapper { /** * 盘点主表保存 * @param checkMainDTO * @return */ CheckDetail getCheckDetail(@Param("ew")CheckMainDTO checkMainDTO); /** * 盘点明细展示 * @param gen * @param page * @return */ IPage> getCheckDetailPage(Page page,@Param("ew") QueryWrapper gen); /** * 根据id展示 * @param id * @return */ CheckDetailDTO getCheckDetailById(Long id); /** * 根据盘点号查询库存明细 * @param page * @param checkMain * @return */ IPage> findCheckDetailByNo(Page page, @Param("ew")CheckMain checkMain); /** * 根据盘点编号、零件、库位和批次号查询对应的库存明细 * @param checkDetailDTO * @return */ CheckDetailDTO getCheckDetailByNo( @Param("ew")CheckDetailDTO checkDetailDTO); /** * 盘点差异报告 * @param gen * @param page * @return */ IPage> getCheckDetailByPage(Page page, @Param("ew")QueryWrapper gen); }