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 <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);
|
|
@Update("update tj_order_ycxm a set" +
|
" a.deleted=0 " +
|
" where a.id=id")
|
int zongjianyishengHuiFuyichangxiangmuanniu(String id);
|
}
|
