添加包机组修改和查询所有的用户修改

whyclxw

2025-04-27 bb33419d03c906aec77c858d3addf0b434369d4b

添加包机组修改和查询所有的用户修改

 src/main/java/com/whyc/service/BaojigroupService.java

@@ -45,22 +45,36 @@
            BaojigroupUsr baojiusr=new BaojigroupUsr();
            baojiusr.setUid(uinf.getUid());
            baojiusr.setBaojiId(baojiId);
            list.add(baojiusr);
        }
        bjUsrmapper.insertBatchSomeColumn(list);
    }
    //添加包机组
    @Transactional
    public Response addBaoji(String baojiName) {
        Baojigroup baoji=new Baojigroup();
        baoji.setBaojiName(baojiName);
        int bl=mapper.insert(baoji);
        if(bl>0){
            //将内置用户加入到包机组下
            QueryWrapper wrapper=new QueryWrapper();
            wrapper.eq("baoji_name",baojiName);
            baoji=mapper.selectOne(wrapper);
            insertNeiZhi(baoji.getId());
        //验证包机组名是否重复
        //将内置用户加入到包机组下
        QueryWrapper wrapper=new QueryWrapper();
        wrapper.eq("baoji_name",baojiName);
        wrapper.last("limit 1");
        Baojigroup baoji=mapper.selectOne(wrapper);
        if(baoji!=null){
            return new Response().set(0,false,"包机组已存在");
        }else{
            baoji=new Baojigroup();
            baoji.setBaojiName(baojiName);
            int bl=mapper.insert(baoji);
            if(bl>0){
                //将内置用户加入到包机组下
                QueryWrapper wrapper1=new QueryWrapper();
                wrapper1.eq("baoji_name",baojiName);
                wrapper1.last("limit 1");
                baoji=mapper.selectOne(wrapper1);
                insertNeiZhi(baoji.getId());
            }
            return new Response().set(1,bl>0,"添加包机组成功");
        }
        return new Response().set(1,bl>0,"添加包机组成功");

    }
    //编辑包机组
    public Response updateBaoji(Integer id, String baojiName) {

 src/main/resources/mapper/UserInfMapper.xml

@@ -24,6 +24,7 @@
    <select id="getAllUser" resultType="UserInf">
        select distinct tb_user_inf.uid,tb_user_inf.uname,urole,create_time,real_name,address,phone_number from plus_user.tb_user_inf
        <where>
            tb_user_inf.uid>100
            <if test="uname!=null">
                and uname LIKE CONCAT('%',#{uname},'%')
            </if>