| | |
| | | package com.consum.base.service; |
| | | |
| | | import com.walker.jdbc.service.BaseServiceImpl; |
| | | import org.springframework.stereotype.Service; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | import java.util.ArrayList; |
| | | import java.util.List; |
| | | import org.apache.commons.lang3.StringUtils; |
| | | import org.springframework.stereotype.Service; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | /** |
| | | * @ClassName LGoodsUserRecordServiceImpl |
| | |
| | | /** |
| | | * 设置为非最新 |
| | | */ |
| | | private static String updSetNotLast = "update L_GOODS_USER_RECORD set LAST_RECORD = 0 where WH_GOODS_ID in(?) and LAST_RECORD=1"; |
| | | 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<Long> outGoodsIds) { |
| | | ArrayList<Object> params = new ArrayList<>(); |
| | | params.add(outGoodsIds); |
| | | return this.update(updSetNotLast, params.toArray()); |
| | | return this.update(updSetNotLast + StringUtils.join(outGoodsIds, ",") + ")", new String[]{}); |
| | | } |
| | | |
| | | /** |