package com.yuanchu.mom.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.yuanchu.mom.dto.CostStatisticsDto;
|
import com.yuanchu.mom.dto.DevListDto;
|
import com.yuanchu.mom.dto.SampleOrderDto;
|
import com.yuanchu.mom.dto.SampleProductDto2;
|
import com.yuanchu.mom.pojo.InsOrder;
|
import com.yuanchu.mom.vo.SampleDefectsFatherVo;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.util.List;
|
import java.util.Map;
|
import java.util.Set;
|
|
/**
|
* @author gaoaoy
|
* @description 针对表【ins_order(检验下单)】的数据库操作Mapper
|
* @createDate 2024-03-12 16:17:55
|
* @Entity com.yuanchu.mom.pojo.InsOrder
|
*/
|
public interface InsOrderMapper extends BaseMapper<InsOrder> {
|
|
//获取检验下单数据
|
IPage<SampleOrderDto> selectInsOrderPage(IPage<InsOrder> page, QueryWrapper<SampleOrderDto> ew, String laboratory);
|
|
//修改检验下单数据
|
int upInsOrderParameter(InsOrder itemParameter);
|
|
String getLaboratoryCode(String name);
|
|
IPage<SampleProductDto2> selectSampleAndProductByOrderId(IPage<SampleProductDto2> page, QueryWrapper<SampleProductDto2> ew,Integer id);
|
|
IPage<CostStatisticsDto> selectCostStatistics(IPage<CostStatisticsDto> page, QueryWrapper<CostStatisticsDto> ew);
|
|
List<CostStatisticsDto> selectCostStatistics2(@Param("ew") QueryWrapper<CostStatisticsDto> ew);
|
|
List<DevListDto> selectDeviceList(Set<String> names);
|
|
List<SampleDefectsFatherVo> selectSampleDefects(Page page, @Param("inspectionItems") String inspectionItems, @Param("orderNumber") String orderNumber);
|
|
Long getCount(@Param("inspectionItems") String inspectionItems, @Param("orderNumber") String orderNumber);
|
|
String getEnumLabelByValue(String value);
|
|
int updateStatus( Integer id);
|
|
String selLaboratoryCode(String laboratory);
|
|
List<Map<Integer, Object>> selectReportModelByOrderId(@Param("id") Integer id, @Param("laboratory") String laboratory);
|
|
String seldepLimsId(int depLimsId);
|
|
InsOrder selectById2(Integer id);
|
}
|
