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 org.apache.ibatis.annotations.Update;
import java.util.List;
/**
* ClassName: TjOrderYcxmMapper
* Description:
* date: 2025/1/21 15:37
*
* @author zjh
*/
@Mapper
public interface TjOrderYcxmMapper extends BaseMapper {
@Delete("DELETE FROM tj_order_ycxm WHERE tjh=#{tjh}")
void delOrderYcXmJyByTjh(String tjh);
@Select("select * FROM tj_order_ycxm WHERE tjh=#{tjNumber}")
List selectListByTjh(String tjNumber);
@Select("select * FROM tj_order_ycxm WHERE tjh=#{tjNum} and deleted=1")
List zongjianyishengHuiFuyichangxiangmu(String tjNum);
@Update("update tj_order_ycxm a set" +
" a.deleted=0 " +
" where a.id=id")
int zongjianyishengHuiFuyichangxiangmuanniu(String id);
@Delete("delete from tj_order_ycxm a where a.id=id")
int zongjianyishengCheDiShanChuyichangxiangmuanniu(String id);
}