package jnpf.elnMapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import jnpf.elnEntity.formula.ElnFormulaDefEntity;
|
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 ElnFormulaDefMapper extends BaseMapper<ElnFormulaDefEntity> {
|
|
@Insert("INSERT INTO eln_formula_def (gongshi_bianma, gongshi_mingcheng, yewu_yongtu, "
|
+ "dangqian_gongshi_banben_id, biz_enabled, beizhu, 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.gongshiBianma}, #{entity.gongshiMingcheng}, #{entity.yewuYongtu}, "
|
+ "#{entity.dangqianGongshiBanbenId}, #{entity.bizEnabled}, #{entity.beizhu}, "
|
+ "#{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, gongshi_bianma) DO NOTHING")
|
int insertIgnoreCode(@Param("entity") ElnFormulaDefEntity entity);
|
|
@Update("UPDATE eln_formula_def SET "
|
+ "gongshi_mingcheng = #{entity.gongshiMingcheng}, "
|
+ "yewu_yongtu = #{entity.yewuYongtu}, "
|
+ "dangqian_gongshi_banben_id = #{entity.dangqianGongshiBanbenId}, "
|
+ "biz_enabled = #{entity.bizEnabled}, beizhu = #{entity.beizhu}, "
|
+ "f_last_modify_user_id = #{entity.fLastModifyUserId}, "
|
+ "f_last_modify_time = #{entity.fLastModifyTime}, f_version = f_version + 1 "
|
+ "WHERE f_tenant_id = #{entity.fTenantId} AND f_id = #{entity.id} "
|
+ "AND f_version = #{expectedVersion}")
|
int updateMutableByTenantAndVersion(@Param("entity") ElnFormulaDefEntity entity,
|
@Param("expectedVersion") Integer expectedVersion);
|
}
|
