package com.sunda.spmsorder.mapper;

import com.sunda.spmsorder.entity.OrderWerksDtl;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Component;

/**
 * <p>
 * 工厂请购单详情关联表 Mapper 接口
 * </p>
 *
 * @author Wayne
 * @since 2021-02-23
 */
@Component
@Mapper
public interface OrderWerksDtlMapper extends BaseMapper<OrderWerksDtl> {

    @Insert("INSERT INTO ORDER_WERKS_DTL(\n" +
            "  ROW_ID_WERKS,\n" +
            "  SPMS_WS_ID,\n" +
            "  ROW_ID_WS,\n" +
            "  PROJECT_OA_NUMBER,\n" +
            "  COUNTRY,\n" +
            "  UUID) VALUES (\n" +
            "   #{owd.rowIdWerks}, \n" +
            "   #{owd.spmsWsId}, \n" +
            "   #{owd.rowIdWs}, \n" +
            "   #{owd.projectOaNumber}, \n" +
            "   #{owd.country}, \n" +
            "   #{owd.uuid}  \n" +
            ")")
    int createOrderWerksDtl(@Param("owd") OrderWerksDtl orderWerksDtl);
}
