package org.jeecg.modules.arj.service.impl;
|
|
import cn.hutool.core.util.StrUtil;
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import org.jeecg.modules.arj.service.JianbjCheckService;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
import org.jeecg.modules.arj.entity.JianbjCheck;
|
import org.jeecg.modules.arj.mapper.JianbjCheckMapper;
|
|
import java.util.List;
|
|
/**
|
* 剪板机抽检;(jianbj_check)表服务实现类
|
* @author : http://www.chiner.pro
|
* @date : 2022-11-22
|
*/
|
@Service
|
public class JianbjCheckServiceImpl extends ServiceImpl<JianbjCheckMapper , JianbjCheck> implements JianbjCheckService {
|
@Autowired
|
private JianbjCheckMapper jianbjCheckMapper;
|
|
/**
|
* 通过ID查询单条数据
|
*
|
* @param id 主键
|
* @return 实例对象
|
*/
|
public JianbjCheck queryById(String id){
|
return jianbjCheckMapper.selectById(id);
|
}
|
|
/**
|
* 分页查询
|
*
|
* @param jianbjCheck 筛选条件
|
* @param current 当前页码
|
* @param size 每页大小
|
* @return
|
*/
|
public Page<JianbjCheck> paginQuery(JianbjCheck jianbjCheck, long current, long size){
|
//1. 构建动态查询条件
|
LambdaQueryWrapper<JianbjCheck> queryWrapper = new LambdaQueryWrapper<>();
|
if(StrUtil.isNotBlank(jianbjCheck.getCjffCheckThree())){
|
queryWrapper.eq(JianbjCheck::getCjffCheckThree, jianbjCheck.getCjffCheckThree());
|
}
|
if(StrUtil.isNotBlank(jianbjCheck.getCjffCheckTwo())){
|
queryWrapper.eq(JianbjCheck::getCjffCheckTwo, jianbjCheck.getCjffCheckTwo());
|
}
|
if(StrUtil.isNotBlank(jianbjCheck.getCjffCheckOne())){
|
queryWrapper.eq(JianbjCheck::getCjffCheckOne, jianbjCheck.getCjffCheckOne());
|
}
|
if(StrUtil.isNotBlank(jianbjCheck.getCjffFre())){
|
queryWrapper.eq(JianbjCheck::getCjffFre, jianbjCheck.getCjffFre());
|
}
|
if(StrUtil.isNotBlank(jianbjCheck.getCjffNum())){
|
queryWrapper.eq(JianbjCheck::getCjffNum, jianbjCheck.getCjffNum());
|
}
|
if(StrUtil.isNotBlank(jianbjCheck.getCreatedBy())){
|
queryWrapper.eq(JianbjCheck::getCreatedBy, jianbjCheck.getCreatedBy());
|
}
|
if(StrUtil.isNotBlank(jianbjCheck.getUpdatedBy())){
|
queryWrapper.eq(JianbjCheck::getUpdatedBy, jianbjCheck.getUpdatedBy());
|
}
|
if(StrUtil.isNotBlank(jianbjCheck.getHeadId())){
|
queryWrapper.eq(JianbjCheck::getHeadId, jianbjCheck.getHeadId());
|
}
|
//2. 执行分页查询
|
Page<JianbjCheck> pagin = new Page<>(current , size , true);
|
IPage<JianbjCheck> selectResult = jianbjCheckMapper.selectByPage(pagin , queryWrapper);
|
pagin.setPages(selectResult.getPages());
|
pagin.setTotal(selectResult.getTotal());
|
pagin.setRecords(selectResult.getRecords());
|
//3. 返回结果
|
return pagin;
|
}
|
|
/**
|
* 新增数据
|
*
|
* @param jianbjCheck 实例对象
|
* @return 实例对象
|
*/
|
public JianbjCheck insert(JianbjCheck jianbjCheck){
|
|
jianbjCheckMapper.insert(jianbjCheck);
|
return jianbjCheck;
|
}
|
|
/**
|
* 更新数据
|
*
|
* @param jianbjCheck 实例对象
|
* @return 实例对象
|
*/
|
public JianbjCheck update(JianbjCheck jianbjCheck){
|
int k = jianbjCheckMapper.updateById(jianbjCheck);
|
return jianbjCheck;
|
}
|
|
/**
|
* 通过主键删除数据
|
*
|
* @param id 主键
|
* @return 是否成功
|
*/
|
public boolean deleteById(String id){
|
int total = jianbjCheckMapper.deleteById(id);
|
return total > 0;
|
}
|
|
@Override
|
public List<JianbjCheck> queryByHeadId(String headId) {
|
QueryWrapper<JianbjCheck> q = new QueryWrapper<>();
|
q.eq("head_id",headId);
|
return jianbjCheckMapper.selectList(q);
|
|
}
|
|
}
|
