package com.matrix.system.hive.dao;
|
|
import com.matrix.system.hive.bean.SysStoreInfo;
|
import com.matrix.system.hive.pojo.StoreInOutRecordVO;
|
import org.apache.ibatis.annotations.Param;
|
|
import com.matrix.core.pojo.PaginationVO;
|
|
import java.util.List;
|
|
/**
|
*
|
*
|
* @date 2016-07-17 10:23
|
*/
|
|
public interface SysStoreInfoDao {
|
public int insert(SysStoreInfo sysStoreInfo);
|
|
public void batchInsert(@Param("list") List<SysStoreInfo> list);
|
|
public int update(SysStoreInfo sysStoreInfo);
|
|
public int deleteByIds(@Param("list") List<Long> list);
|
|
public int deleteById(Long iD);
|
|
public List<SysStoreInfo> selectInPage(@Param("record") SysStoreInfo sysStoreInfo,
|
@Param("pageVo") PaginationVO pageVo);
|
|
public List<SysStoreInfo> selectCountInPage(@Param("record") SysStoreInfo sysStoreInfo,
|
@Param("pageVo") PaginationVO pageVo);
|
|
public List<SysStoreInfo> selectByModel(@Param("record") SysStoreInfo sysStoreInfo);
|
|
public int selectTotalRecord(@Param("record") SysStoreInfo sysStoreInfo);
|
|
public int selectCountTotalRecord(@Param("record") SysStoreInfo sysStoreInfo);
|
|
public SysStoreInfo selectById(Long iD);
|
|
public SysStoreInfo getStoreByGoodsId(SysStoreInfo sysStoreInfo);
|
|
/**
|
* 根据商品 与仓库id 出库
|
*/
|
public int updateGoodsCk(@Param("id") Long id, @Param("goodId") Long goodId, @Param("count") int Count);
|
|
/**
|
* 根据批次和仓库id查询库存
|
*
|
* @author jiangyouyao
|
* @return
|
*/
|
public SysStoreInfo selectStoInfo(@Param("batch") String batch, @Param("storeId") Long storeId);
|
|
public List<SysStoreInfo> selectStoInfoSimple(@Param("skuId") Long skuId, @Param("storeId")Long checkStoreid);
|
public int countDetail(Long skuId);
|
|
public List<SysStoreInfo> selectStoInfoBySku(@Param("skuId")Long skuId, @Param("storeId") Long shopId);
|
|
/**
|
* 查询仓库中库存大于0的
|
* @param storeId
|
* @return
|
*/
|
public List<SysStoreInfo> selectByStoreId(@Param("storeId")Long storeId);
|
|
|
List<StoreInOutRecordVO> findStoreInOutRecord(@Param("record")StoreInOutRecordVO storeInOut, @Param("pageVo")PaginationVO pageVo);
|
|
Integer findStoreInOutTotal(@Param("record")StoreInOutRecordVO inOutRecordVO);
|
}
|
