查询历史版本信息

lxw

2022-07-23 3816bf22816f27a85bb392b1bddd115208c33ee7

查询历史版本信息

 src/main/java/com/whyc/controller/ProductBomHistoryController.java

New file
@@ -0,0 +1,25 @@
package com.whyc.controller;

import com.whyc.dto.Response;
import com.whyc.service.ProductBomHistoryService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;

@Api(tags = "文档历史信息管理")
@RestController
@RequestMapping("productBomHistory")
public class ProductBomHistoryController {
    @Autowired
    private ProductBomHistoryService service;

    @ApiOperation(value = "根据子件名称和母料编号查询历史版本记录")
    @GetMapping("getBomByPCodeAndSName")
    public Response getBomByPCodeAndSName(@RequestParam int pcode, @RequestParam int sname){
        return service.getBomByPCodeAndSName(pcode,sname);
    }
}

 src/main/java/com/whyc/mapper/ProductBomHistoryMapper.java

New file
@@ -0,0 +1,7 @@
package com.whyc.mapper;


import com.whyc.pojo.ProductBomHistory;

public interface ProductBomHistoryMapper extends CustomMapper<ProductBomHistory> {
}

 src/main/java/com/whyc/service/ProductBomHistoryService.java

New file
@@ -0,0 +1,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,"返回数据");
    }
}