花城-智慧社区
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
huanghongfa
2021-07-24 2c8b9868fe8c45320eb18fd5d6b51ec770c30610 
 springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/UserDao.java


@@ -23,14 +23,12 @@


import com.panzhihua.common.model.vos.user.UpdateUserArchivesVO;


import com.panzhihua.service_user.model.dos.SysUserDO;


import com.panzhihua.service_user.model.dtos.DataKanbanDTO;


import org.apache.ibatis.annotations.Mapper;


import org.apache.ibatis.annotations.Param;


import org.apache.ibatis.annotations.Select;


import org.apache.ibatis.annotations.Update;


import org.apache.ibatis.annotations.*;


import org.springframework.web.bind.annotation.RequestParam;




import java.util.Date;


import java.util.List;


import java.util.Map;




/**


 * @program: springcloud_k8s_panzhihuazhihuishequ


@@ -412,7 +410,22 @@


            "</script>")


    void passResetUser(@Param("gridMemberDTO") EventGridMemberPassResetDTO gridMemberDTO);




//    @Update("update lc_compare_code_member set local_grid_member_id = #{userId},grid_member_name = #{userName} where id = #{lcMemberId}")


//    void addLcMember(@Param("lcMemberId") Long lcMemberId,@Param("userId") Long userId,@Param("userName") Long userName);


    @Update("update lc_compare_code_member set local_grid_member_id = #{userId},grid_member_name = #{userName} where id = #{lcMemberId}")


    void addLcMember(@Param("lcMemberId") Long lcMemberId,@Param("userId") Long userId,@Param("userName") String userName);




    @Update("update lc_compare_code_member set local_grid_member_id = null,grid_member_name = null where local_grid_member_id = #{gridMemberId}")


    void delLcMember(@Param("gridMemberId") Long gridMemberId);




    @Select("select id,village_id,act_id from com_mng_building where id = #{buildingId}")


    Map<String,Long> getBuilding(@Param("buildingId") Long buildingId);




    @Delete("delete from event_grid_member_building_relation where grid_member_id = #{gridMemberId}")


    void delGridMemberRelation(@Param("gridMemberId") Long gridMemberId);




    @Select("select id from lc_compare_code_member where local_grid_member_id = #{gridMemberId}")


    Long getLcMemberId(@Param("gridMemberId") Long gridMemberId);




    @Select("select count(id) from event_grid_member_relation where grid_member_id = #{userId}")


    Integer getGridIsOk(@Param("userId") Long userId);




}