2025-05-13

zhaowenxuan

2025-05-13 2b2763c83e352f8ffd2ac0b5c46b60c49ee78439

 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjFlowingWaterMapper.java

@@ -6,6 +6,7 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ltkj.hosp.domain.TjFlowingWater;
import com.ltkj.hosp.domain.TjOrderDetail;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
@@ -93,4 +94,17 @@
            "AND a.pay_stasus !=0 " +
            "AND a.update_time BETWEEN #{beginTime} AND #{endTime}")
    List<Long> getFlowingWaterIdList(@Param("userId") String userId,@Param("beginTime") Date beginTime,@Param("endTime") Date endTime);

    @Delete("  delete" +
            " from tj_flowing_water" +
            " where order_id = #{order}")
    public int deleteTjFlowingWaterByOrderId(String order);

    @Delete("  delete" +
            " from tj_flowing_water" +
            " where jxbz = #{bldh}")
    void deleteTjOrderDetailByjxbz(String bldh);

    @Select("call tj_bl(#{tjh,mode=IN})")
    void getTjBlCall(@Param("tjh") String tjh);
}