package org.jeecg.modules.eam.mapper;
|
|
import java.util.List;
|
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
import org.jeecg.modules.eam.entity.SysFileName;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import org.jeecg.modules.eam.model.DepartVo;
|
import org.jeecg.modules.eam.vo.SysFileNameVo;
|
|
/**
|
* @Description: 文件名称管理
|
* @Author: jeecg-boot
|
* @Date: 2023-11-03
|
* @Version: V1.0
|
*/
|
public interface SysFileNameMapper extends BaseMapper<SysFileName> {
|
|
|
/**
|
* 通过单据类型获取单据编码
|
* qsw 2023-11-3
|
*/
|
@Select("select t1.id as receipts,t1.id as maintenanceOrderUda3,t1.num as receiptsNum,t2.item_text as receiptsName,t1.num as receiptsNum2,t2.item_text as receiptsName2 from sys_file_name t1 left join (SELECT * FROM v_sys_dict WHERE dict_code = 'sys_file_name') t2 on t2.item_value = t1.name where t1.version_status = '2' and t1.name =#{name}")
|
List<SysFileNameVo> getSysFileName(@Param("name")String name);
|
|
}
|
