| | |
| | | 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 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 |
| | | //逻辑删除,更改状态为0,添加报废日期 |
| | | UpdateWrapper<DeviceManage> wrapper = Wrappers.update(); |
| | | wrapper.set("status",0).eq("device_id",deviceId); |
| | | wrapper.set("status",0).set("scrap_time",new Date()).eq("device_id",deviceId); |
| | | int update = mapper.update(null, wrapper); |
| | | return new Response().setMsg(1,"出库报废成功"); |
| | | } |
| | |
| | | return new Response().setMsg(1,"修改成功"); |
| | | } |
| | | |
| | | public Response<PageInfo<DeviceManage>> getPage(int pageNum,int pageSize) { |
| | | /*QueryWrapper<DeviceManage> wrapper = Wrappers.query(); |
| | | /*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,false); |
| | | 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); |
| | | } |
| | | } |