package com.consum.base.service; import com.walker.jdbc.service.BaseServiceImpl; import org.apache.commons.lang3.StringUtils; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import java.util.List; /** * @ClassName LGoodsUserRecordServiceImpl * @Date 2023/11/2 * @Description * @Version 1.0 **/ @Service @Transactional(rollbackFor = Exception.class) public class LGoodsUserRecordServiceImpl extends BaseServiceImpl { /** * 设置为非最新 */ private static String updSetNotLast = "update L_GOODS_USER_RECORD set LAST_RECORD = 0 where LAST_RECORD=1 and WH_GOODS_ID in( "; public int updSetNotLast(List outGoodsIds) { return this.update(updSetNotLast + StringUtils.join(outGoodsIds, ",") + ")", new String[]{}); } }