package com.zioinfo.mes.spec.mapper;

import com.zioinfo.mes.spec.MesSpec;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface SpecMapper {
    List<MesSpec> findAll(@Param("itemCode") String itemCode,
                          @Param("inspectionType") String inspectionType);
    MesSpec findById(@Param("id") Long id);
    MesSpec findByCode(@Param("specCode") String specCode);
    int countByCode(@Param("specCode") String specCode, @Param("excludeId") Long excludeId);
    int insert(MesSpec s);
    int update(MesSpec s);
    int delete(@Param("id") Long id);
}
