package zy.cloud.wms.manager.mapper;

import org.apache.ibatis.annotations.*;
import zy.cloud.wms.manager.entity.CustOrder;
import com.baomidou.mybatisplus.mapper.BaseMapper;
import org.springframework.stereotype.Repository;

@Mapper
@Repository
public interface CustOrderMapper extends BaseMapper<CustOrder> {

    int updateStatus(@Param("number") String number, @Param("status") Integer status);

    @Insert("insert into man_cust_order_log select * from man_cust_order where number=#{number}")
    int saveLog(String number);

    @Update("delete from man_cust_order where number=#{number}")
    int delete(@Param("number") String number);

    @Update("update man_cust_order_log set qty = #{qty} where number=#{number} and user_code=#{userCode}")
    int updateQty(@Param("number") String number, @Param("userCode") String userCode, @Param("qty") Double qty);

}