public List<ShopDianpu> findbymiaosha(long id, List<Object> list)

            throws Exception {

        String hql="from ShopDianpu where dianput.id="+id+" and shop.zhuangtai='1' and LENGTH(huodong)>5 and shop.id not in (:list) order by shop.rexiaoshezhi desc,shop.dianleipaixu asc";

        Query createQuery = getSession().createQuery(hql);

        createQuery.setParameterList("list", list);

        return createQuery.list();

    }