package com.ltkj.hosp.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ltkj.hosp.domain.TjOrderYcxm;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * ClassName: TjOrderYcxmMapper <br/>
 * Description: <br/>
 * date: 2025/1/21 15:37<br/>
 *
 * @author zjh<br />
 */
@Mapper
public interface TjOrderYcxmMapper extends BaseMapper<TjOrderYcxm> {

    @Delete("DELETE FROM tj_order_ycxm WHERE tjh=#{tjh}")
    void delOrderYcXmJyByTjh(String tjh);


    @Select("select * FROM tj_order_ycxm WHERE tjh=#{tjNumber}")
    List<TjOrderYcxm> selectListByTjh(String tjNumber);


    @Select("select * FROM tj_order_ycxm WHERE tjh=#{tjNum} and deleted=1")
    List<TjOrderYcxm> zongjianyishengHuiFuyichangxiangmu(String tjNum);
}