Sql sql = Sqls.queryEntity(dao.sqls().get("Client.card"));
SimpleCriteria cir = Cnd.cri();
cir.where().and("spt.goods_type","=","会员卡");

    cir.where().and("spt.corp_id","=", orgId);
    cir.desc("id");

    if(seacherKey!=null && !seacherKey.equals("")){
       cir.where().and(new Static(" name like '%"+seacherKey+"%' "));
    }
    sql.setCondition(cir);
    sql.setCallback(Sqls.callback.entities());
    sql.setEntity(dao.getEntity(ShopMemberShipCard.class));
    dao.execute(sql);

    List<ShopMemberShipCard> shipCard = sql.getList(ShopMemberShipCard.class);