品牌分类删除，同时删除引用分类商品关系

yujian

2019-04-26 63ef162b62ddfd6c7ad8b4f3e66075c3f01de621

品牌分类删除，同时删除引用分类商品关系

 fanli/src/main/java/com/yeshi/fanli/dao/mybatis/brand/BrandClassShopMapper.java

@@ -9,6 +9,15 @@

public interface BrandClassShopMapper extends BaseMapper<BrandClassShop>{
    
	
    /**
     * 根据分类id批量删除
     * @param list
     * @return
     */
    int deleteBatchByClassId(List<Long> list);
	
	
    /**
     * 查询有效
     * @param start

 fanli/src/main/java/com/yeshi/fanli/mapping/brand/BrandClassShopMapper.xml

@@ -80,6 +80,13 @@
    </set> where bcs_id = #{id,jdbcType=BIGINT}
  </update>
  
  
   <delete id="deleteBatchByClassId" parameterType="java.util.List">
        delete from yeshi_ec_brand_class_shop WHERE bcs_cid in
        <foreach collection="list" item="item" open="(" close=")"
            separator=",">#{item}</foreach>
   </delete>
  
  <select id="listEffective" resultMap="BaseResultMap">
      SELECT * FROM  yeshi_ec_brand_class_shop b
    LEFT JOIN `yeshi_ec_taobao_shop_info` p ON b.`bcs_shop_id` = p.`tsi_id`

 fanli/src/main/java/com/yeshi/fanli/service/impl/brand/BrandClassServiceImpl.java

@@ -13,6 +13,7 @@
import com.yeshi.fanli.entity.bus.clazz.GoodsClass;

import com.yeshi.fanli.exception.brand.BrandClassException;

import com.yeshi.fanli.service.inter.brand.BrandClassService;

import com.yeshi.fanli.service.inter.brand.BrandClassShopService;

import com.yeshi.fanli.service.inter.goods.GoodsClassService;



@Service

@@ -24,6 +25,9 @@
    @Resource

    private GoodsClassService goodsClassService;



    @Resource

    private BrandClassShopService brandClassShopService;

	
    @Override

    public List<BrandClass> listEffective() {

        return brandClassMapper.listEffective();

@@ -110,6 +114,9 @@
    

    @Override

    public int deleteBatchByPrimaryKey(List<Long> list) {

        // 删除已匹配的分类关系

        brandClassShopService.deleteBatchByClassId(list);

		
        return brandClassMapper.deleteBatchByPrimaryKey(list);

    }




 fanli/src/main/java/com/yeshi/fanli/service/impl/brand/BrandClassShopServiceImpl.java

@@ -212,6 +212,14 @@
        }

    }

    

    @Override

    public void deleteBatchByClassId(List<Long> list) {

        if (list == null || list.size() == 0) {

            return;

        }

        brandClassShopMapper.deleteBatchByClassId(list);

    }

	
    

    @Override

    public void updateOrder(Long id, Integer moveType) throws BrandClassShopException, Exception{


 fanli/src/main/java/com/yeshi/fanli/service/inter/brand/BrandClassShopService.java

@@ -92,5 +92,11 @@
     * @param shopId

     */

    public void addClick(Long shopId);



    /**

     * 根据分类id进行删除

     * @param list

     */

    public void deleteBatchByClassId(List<Long> list);

    

}