| | |
| | | import com.iplatform.milvus.EventVo; |
| | | import com.walker.jdbc.service.BaseServiceImpl; |
| | | import org.springframework.jdbc.core.RowMapper; |
| | | import org.springframework.jdbc.core.namedparam.MapSqlParameterSource; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.sql.ResultSet; |
| | | import java.sql.SQLException; |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | @Service |
| | | public class EventServiceImpl extends BaseServiceImpl { |
| | | |
| | | private final EventVoMapper eventVoMapper = new EventVoMapper(); |
| | | |
| | | /** |
| | | * 根据工单id集合,返回这些工单对象(历史工单基本信息) |
| | | * @param ids |
| | | * @return |
| | | * @date 2024-03-31 |
| | | */ |
| | | public List<EventVo> queryEventWhereIn(List<Long> ids){ |
| | | MapSqlParameterSource parameterSource = new MapSqlParameterSource(); |
| | | parameterSource.addValue("ids", ids); |
| | | return this.sqlListObjectWhereIn("select * from event_history where id in (:ids)", eventVoMapper, parameterSource); |
| | | } |
| | | |
| | | public List<EventVo> queryEventAll(Long existId){ |
| | | if(existId == null){ |
| | | return this.select("select * from event_history order by id asc", new Object[]{}, this.eventVoMapper); |