package com.xzx.gc.system.service;
|
|
import com.xzx.gc.entity.OrderStorageInfo;
|
import com.xzx.gc.system.mapper.OrderStorageInfoMapper;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
import tk.mybatis.mapper.entity.Example;
|
|
import java.util.List;
|
|
@Service
|
@Transactional
|
public class OrderStorageService {
|
|
@Autowired
|
private OrderStorageInfoMapper orderStorageInfoMapper;
|
|
public void add(OrderStorageInfo orderStorageInfo){
|
|
orderStorageInfoMapper.insertSelective(orderStorageInfo);
|
}
|
|
public List<OrderStorageInfo> findByStorageType(Short storageType){
|
OrderStorageInfo orderStorageInfo=new OrderStorageInfo();
|
orderStorageInfo.setSysStorageType(storageType);
|
return orderStorageInfoMapper.select(orderStorageInfo);
|
}
|
|
public List<OrderStorageInfo> findByStorageTypeByTime(Short storageType){
|
Example example=new Example(OrderStorageInfo.class);
|
Example.Criteria criteria = example.createCriteria();
|
criteria.andEqualTo("sysStorageType",storageType);
|
criteria.andCondition("DATE_FORMAT(storage_time,'%Y-%m-%d')=date_sub(CURRENT_DATE(), interval 1 day)");
|
return orderStorageInfoMapper.selectByExample(example);
|
}
|
}
|
