package jnpf.elnMapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import jnpf.elnEntity.formula.ElnTemplateFormulaBindingEntity;
|
import org.apache.ibatis.annotations.Insert;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Update;
|
|
@Mapper
|
public interface ElnTemplateFormulaBindingMapper
|
extends BaseMapper<ElnTemplateFormulaBindingEntity> {
|
|
@Insert("INSERT INTO eln_template_formula_binding (muban_id, gongshi_dingyi_id, "
|
+ "gongshi_banben_id, canshu_yingshe, jieguo_bangding_id, "
|
+ "bangding_zhuangtai, tuopu_xuhao, caozuo_bianma, "
|
+ "jieguo_suo_kuaizhao, "
|
+ "laiyuan_gongshi_bangding_id, daoqi_shijian, zhuangtai_yuanyin, f_id, "
|
+ "f_tenant_id, f_version, f_creator_user_id, f_creator_time, "
|
+ "f_last_modify_user_id, f_last_modify_time, f_delete_user_id, "
|
+ "f_delete_time, f_delete_mark) VALUES (#{entity.mubanId}, "
|
+ "#{entity.gongshiDingyiId}, #{entity.gongshiBanbenId}, "
|
+ "#{entity.canshuYingshe,jdbcType=OTHER,typeHandler="
|
+ "jnpf.elnEntity.formula.ElnTemplateFormulaBindingEntity$ParameterMappingTypeHandler}, "
|
+ "#{entity.jieguoBangdingId}, #{entity.bangdingZhuangtai}, "
|
+ "#{entity.tuopuXuhao}, #{entity.caozuoBianma}, "
|
+ "#{entity.jieguoSuoKuaizhao,jdbcType=OTHER,typeHandler="
|
+ "jnpf.elnEntity.formula.ElnTemplateFormulaBindingEntity$ControlSnapshotListTypeHandler}, "
|
+ "#{entity.laiyuanGongshiBangdingId}, #{entity.daoqiShijian}, "
|
+ "#{entity.zhuangtaiYuanyin}, #{entity.id}, #{entity.fTenantId}, "
|
+ "#{entity.fVersion}, #{entity.fCreatorUserId}, #{entity.fCreatorTime}, "
|
+ "#{entity.fLastModifyUserId}, #{entity.fLastModifyTime}, "
|
+ "#{entity.fDeleteUserId}, #{entity.fDeleteTime}, #{entity.fDeleteMark}) "
|
+ "ON CONFLICT (f_tenant_id, muban_id, caozuo_bianma) DO NOTHING")
|
int insertIfAbsent(@Param("entity") ElnTemplateFormulaBindingEntity entity);
|
|
@Update("UPDATE eln_template_formula_binding SET "
|
+ "gongshi_dingyi_id = #{entity.gongshiDingyiId}, "
|
+ "gongshi_banben_id = #{entity.gongshiBanbenId}, "
|
+ "canshu_yingshe = #{entity.canshuYingshe,jdbcType=OTHER,typeHandler="
|
+ "jnpf.elnEntity.formula.ElnTemplateFormulaBindingEntity$ParameterMappingTypeHandler}, "
|
+ "jieguo_bangding_id = #{entity.jieguoBangdingId}, "
|
+ "caozuo_bianma = #{entity.caozuoBianma}, "
|
+ "bangding_zhuangtai = #{targetStatus}, "
|
+ "zhuangtai_yuanyin = #{reason}, "
|
+ "f_version = #{expectedVersion} + 1 "
|
+ "WHERE f_tenant_id = #{entity.fTenantId} "
|
+ "AND f_id = #{entity.id} "
|
+ "AND f_version = #{expectedVersion} "
|
+ "AND bangding_zhuangtai = #{entity.bangdingZhuangtai}")
|
int updateStatus(@Param("entity") ElnTemplateFormulaBindingEntity entity,
|
@Param("expectedVersion") int expectedVersion,
|
@Param("targetStatus") String targetStatus,
|
@Param("reason") String reason);
|
}
|
