whycxzp
2021-04-01 ad773967efe452b595c28f7cee7e4ebd61eb5d58
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
package com.whyc.service;
 
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.whyc.dto.Response;
import com.whyc.mapper.DeviceManageMapper;
import com.whyc.pojo.DeviceMaintain;
import com.whyc.pojo.DeviceManage;
import org.springframework.stereotype.Service;
 
import javax.annotation.Resource;
import java.util.Date;
import java.util.List;
 
@Service("deviceManageService")
public class DeviceManageService {
 
    @Resource
    private DeviceManageMapper mapper;
 
    public Response add(DeviceManage deviceManage) {
        //新增入库
        deviceManage.setStatus((byte) 1);
        deviceManage.setCreateTime(new Date());
        mapper.insert(deviceManage);
        return new Response().setMsg(1,"添加成功");
    }
 
    public Response delete(Integer deviceId) {
        //逻辑删除,更改状态为0,添加报废日期
        UpdateWrapper<DeviceManage> wrapper = Wrappers.update();
        wrapper.set("status",0).set("scrap_time",new Date()).eq("device_id",deviceId);
        int update = mapper.update(null, wrapper);
        return new Response().setMsg(1,"出库报废成功");
    }
 
    public Response update(DeviceManage deviceManage) {
        mapper.updateById(deviceManage);
        return new Response().setMsg(1,"修改成功");
    }
 
    /*public Response<PageInfo<DeviceManage>> getPage(int pageNum,int pageSize) {
        *//*QueryWrapper<DeviceManage> wrapper = Wrappers.query();
        wrapper.eq("status",1);
        IPage<DeviceManage> page1 = mapper.selectPage(new Page<>(pageNum,pageSize), wrapper);*//*
        PageHelper.startPage(pageNum,pageSize,true);
        List<DeviceManage> deviceManageList = mapper.getAll();
        PageInfo<DeviceManage> deviceManagePageInfo = new PageInfo<>(deviceManageList);
        return new Response<PageInfo<DeviceManage>>().set(1,deviceManagePageInfo);
    }*/
 
    public Response<List<DeviceManage>> getList() {
        List<DeviceManage> deviceManageList= mapper.getList();
        return new Response<List<DeviceManage>>().set(1,deviceManageList);
    }
 
    public Response<PageInfo<DeviceManage>> getPageByCondition(int pageNum, int pageSize, DeviceManage deviceManage) {
        PageHelper.startPage(pageNum,pageSize);
        List<DeviceManage> deviceManageList = mapper.getAllByCondition(deviceManage);
        PageInfo<DeviceManage> deviceManagePageInfo = new PageInfo<>(deviceManageList);
        return new Response<PageInfo<DeviceManage>>().set(1,deviceManagePageInfo);
    }
 
    public Response getSite() {
        QueryWrapper<DeviceManage> wrapper = Wrappers.query();
        wrapper.select("distinct site").orderByAsc("site");
        List<DeviceManage> deviceManageList = mapper.selectList(wrapper);
        return new Response().set(1,deviceManageList);
    }
}