package com.ruoyi.station.mapper;
|
|
import java.util.List;
|
import com.ruoyi.station.domain.MjWorkOrder;
|
|
/**
|
* 工单Mapper接口
|
*
|
* @author ruoyi
|
* @date 2020-08-10
|
*/
|
public interface MjWorkOrderMapper
|
{
|
/**
|
* 查询工单
|
*
|
* @param id 工单ID
|
* @return 工单
|
*/
|
public MjWorkOrder selectMjWorkOrderById(String id);
|
|
/**
|
* 查询工单列表
|
*
|
* @param mjWorkOrder 工单
|
* @return 工单集合
|
*/
|
public List<MjWorkOrder> selectMjWorkOrderList(MjWorkOrder mjWorkOrder);
|
|
/**
|
* 新增工单
|
*
|
* @param mjWorkOrder 工单
|
* @return 结果
|
*/
|
public int insertMjWorkOrder(MjWorkOrder mjWorkOrder);
|
|
/**
|
* 修改工单
|
*
|
* @param mjWorkOrder 工单
|
* @return 结果
|
*/
|
public int updateMjWorkOrder(MjWorkOrder mjWorkOrder);
|
|
/**
|
* 删除工单
|
*
|
* @param id 工单ID
|
* @return 结果
|
*/
|
public int deleteMjWorkOrderById(String id);
|
|
/**
|
* 批量删除工单
|
*
|
* @param ids 需要删除的数据ID
|
* @return 结果
|
*/
|
public int deleteMjWorkOrderByIds(String[] ids);
|
|
/**
|
* 根据当前时间获取有效工单
|
* @return
|
*/
|
public List<MjWorkOrder> selectMjWorkOrderByDate();
|
|
/**
|
* 根据当前时间获取失效工单
|
* @return
|
*/
|
public List<MjWorkOrder> selectMjWorkOrderByDateForInvalid();
|
|
/**
|
* 根据获取用户id获取有效工单
|
* @param userId
|
* @return
|
*/
|
public MjWorkOrder selectValidOrderByUserId(Long userId);
|
|
/**
|
* 临时授权统计
|
* @return
|
*/
|
int selectCountTemporary();
|
|
/**
|
* 工作票授权统计
|
* @return
|
*/
|
int selectCountERP();
|
|
/**
|
* 检查工作票号是否重复
|
* @param orderNo
|
* @return
|
*/
|
public Integer checkOrderNoRepeat(String orderNo);
|
|
public Integer selectOrderCountByYear(String yearTime);
|
|
String getOrderName(String orderId);
|
}
|
