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);
|
}
|
}
|