package com.ruoyi.system.mapper;
|
|
import java.util.List;
|
import org.apache.ibatis.annotations.Param;
|
import com.ruoyi.system.domain.TTest;
|
import com.ruoyi.system.domain.TTestBattery;
|
import com.ruoyi.system.domain.TTestBatteryField;
|
import com.ruoyi.system.domain.TTestResult;
|
import com.ruoyi.system.domain.TTestWarningThreshold;
|
|
/** 测试管理数据访问接口。 */
|
public interface TTestMapper
|
{
|
TTest selectTestById(Long testId);
|
List<TTest> selectTestList(TTest test);
|
TTest selectTestByName(String testName);
|
int insertTest(TTest test);
|
int updateTest(TTest test);
|
int updateTestStatus(@Param("testId") Long testId, @Param("status") String status, @Param("updateBy") String updateBy);
|
int deleteTestById(@Param("testId") Long testId, @Param("updateBy") String updateBy);
|
int deleteTestBatteriesByTestId(@Param("testId") Long testId, @Param("updateBy") String updateBy);
|
int deleteTestFieldsByTestId(@Param("testId") Long testId, @Param("updateBy") String updateBy);
|
int deleteTestThresholdsByTestId(@Param("testId") Long testId, @Param("updateBy") String updateBy);
|
int insertTestBattery(TTestBattery battery);
|
int insertTestBatteryField(TTestBatteryField field);
|
int insertTestThreshold(TTestWarningThreshold threshold);
|
List<TTestBattery> selectTestBatteries(Long testId);
|
List<TTestBatteryField> selectTestBatteryFields(Long testId);
|
List<TTestWarningThreshold> selectTestThresholds(Long testId);
|
List<TTestResult> selectTestResults(TTestResult result);
|
int countTestingByBatteryNo(@Param("batteryNo") String batteryNo, @Param("testId") Long testId);
|
int countTestingByCabinetChannel(@Param("cabinetId") Long cabinetId, @Param("channelNo") Integer channelNo, @Param("testId") Long testId);
|
int countTestBatteryRelation(@Param("testId") Long testId, @Param("relationId") Long relationId);
|
int countTestBatteryFields(@Param("testId") Long testId, @Param("relationId") Long relationId, @Param("fieldName") String fieldName);
|
int countTestThreshold(@Param("testId") Long testId, @Param("thresholdType") String thresholdType, @Param("thresholdId") Long thresholdId);
|
int countTestTypeEnabled(Long testTypeId);
|
int countUserEnabled(Long userId);
|
int countBatteryInEnabledGroup(@Param("groupId") Long groupId, @Param("batteryNo") String batteryNo);
|
int countCabinetEnabled(Long cabinetId);
|
int countCollectorEnabled(@Param("collectorId") Long collectorId, @Param("cabinetId") Long cabinetId);
|
}
|