package org.jeecg.modules.mdc.mapper;
|
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import org.apache.ibatis.annotations.Param;
|
import org.jeecg.modules.mdc.entity.MdcPassRate;
|
|
/**
|
* @Description: 合格率表
|
* @Author: lius
|
* @Date: 2023-07-18
|
* @Version: V1.0
|
*/
|
public interface MdcPassRateMapper extends BaseMapper<MdcPassRate> {
|
|
/**
|
* 分页查询
|
*
|
* @param page
|
* @param mdcPassRate
|
* @return
|
*/
|
IPage<MdcPassRate> pageList(Page<MdcPassRate> page, @Param("mdcPassRate") MdcPassRate mdcPassRate);
|
|
/**
|
* 计算加工数量
|
*
|
* @param equipmentId
|
* @param startTime
|
* @param endTime
|
* @return
|
*/
|
Integer findProcessQuantity(@Param("equipmentId") String equipmentId, @Param("startTime") String startTime, @Param("endTime") String endTime);
|
|
/**
|
* 计算废品数量
|
*
|
* @param equipmentId
|
* @param startTime
|
* @param endTime
|
* @return
|
*/
|
Integer findUnqualifiedQuantity(@Param("equipmentId") String equipmentId, @Param("startTime") String startTime, @Param("endTime") String endTime);
|
}
|