查询历史版本信息

lxw

2022-07-23 3816bf22816f27a85bb392b1bddd115208c33ee7

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
package com.whyc.service;
 
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.whyc.dto.Response;
import com.whyc.mapper.ProductBomHistoryMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
 
import java.util.List;
 
@Service
public class ProductBomHistoryService {
    @Autowired(required = false)
    private ProductBomHistoryMapper mapper;
    //根据子件名称和母料编号查询历史版本记录
    public Response getBomByPCodeAndSName(int pcode, int sname) {
        QueryWrapper wrapper=new QueryWrapper();
        wrapper.eq("parent_code",pcode);
        wrapper.eq("sub_code",sname);
        wrapper.orderByAsc("s_version");
        List list=mapper.selectList(wrapper);
        return new Response().setII(1,list.size()>0?true:false,list,"返回数据");
    }
}