package com.project.system.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.project.system.domain.SysOrderNo;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Update;
|
|
import java.util.Date;
|
|
/**
|
* 订单编号Mapper接口
|
*
|
* @author manton
|
* @date 2023-03-07
|
*/
|
public interface SysOrderNoMapper extends BaseMapper<SysOrderNo>
|
{
|
|
@Update("update sys_order_no set current_no = CASE WHEN exact_date=#{exactDate} THEN current_no+1 ELSE #{INIT_CURRENT_NUMBER} END," +
|
" exact_date=#{exactDate}, update_time=#{updateTime} where id = #{id}")
|
Boolean updateCurrentNo(@Param("id") Long id,
|
@Param("exactDate") String exactDate,
|
@Param("updateTime") Date updateTime,
|
@Param("INIT_CURRENT_NUMBER") Integer INIT_CURRENT_NUMBER);
|
|
}
|
