package com.ltkj.hosp.mapper;
|
|
import java.util.List;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.ltkj.hosp.domain.TjStandard;
|
import com.ltkj.hosp.domain.TjTollCollector;
|
import com.ltkj.hosp.domain.TjTollCollectorDetail;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Select;
|
|
/**
|
* 收费员日结Mapper接口
|
*
|
* @author ltkj_赵佳豪&李格
|
* @date 2023-03-06
|
*/
|
@Mapper
|
public interface TjTollCollectorMapper extends BaseMapper<TjTollCollector> {
|
/**
|
* 查询收费员日结
|
*
|
* @param id 收费员日结主键
|
* @return 收费员日结
|
*/
|
public TjTollCollector selectTjTollCollectorById(String id);
|
|
/**
|
* 查询收费员日结列表
|
*
|
* @param tjTollCollector 收费员日结
|
* @return 收费员日结集合
|
*/
|
public List<TjTollCollector> selectTjTollCollectorList(TjTollCollector tjTollCollector);
|
|
/**
|
* 新增收费员日结
|
*
|
* @param tjTollCollector 收费员日结
|
* @return 结果
|
*/
|
public int insertTjTollCollector(TjTollCollector tjTollCollector);
|
|
/**
|
* 修改收费员日结
|
*
|
* @param tjTollCollector 收费员日结
|
* @return 结果
|
*/
|
public int updateTjTollCollector(TjTollCollector tjTollCollector);
|
|
/**
|
* 删除收费员日结
|
*
|
* @param id 收费员日结主键
|
* @return 结果
|
*/
|
public int deleteTjTollCollectorById(String id);
|
|
/**
|
* 批量删除收费员日结
|
*
|
* @param ids 需要删除的数据主键集合
|
* @return 结果
|
*/
|
public int deleteTjTollCollectorByIds(String[] ids);
|
|
/**
|
* 批量删除结账详情
|
*
|
* @param ids 需要删除的数据主键集合
|
* @return 结果
|
*/
|
public int deleteTjTollCollectorDetailByAccountIds(String[] ids);
|
|
/**
|
* 批量新增结账详情
|
*
|
* @param tjTollCollectorDetailList 结账详情列表
|
* @return 结果
|
*/
|
public int batchTjTollCollectorDetail(List<TjTollCollectorDetail> tjTollCollectorDetailList);
|
|
|
/**
|
* 通过收费员日结主键删除结账详情信息
|
*
|
* @param id 收费员日结ID
|
* @return 结果
|
*/
|
public int deleteTjTollCollectorDetailByAccountId(String id);
|
|
@Select("SELECT id FROM tj_toll_collector WHERE deleted='0' ORDER BY create_time DESC LIMIT 1")
|
String getTjTollCollectorByLastOne();
|
|
@Select("SELECT * FROM tj_toll_collector WHERE deleted='0' and id=#{id}")
|
TjTollCollector getTjTollCollectorById(String id);
|
}
|
