/**
* 根据用户的id进行删除资源权限
* @param roleId
*/
public void removeByroleId(String roleId){
String hql="delete from BaseOperateRoleResTbRt t where t.roleId='"+roleId+"'";
varchar 类型的一定要加上
'’
Session session=this.getSession(); //获取session
Query query=session.createQuery(hql); //执行
query.executeUpdate(); //更新
this.releaseSession(session); //释放session 注意一定要用这个方法
}
//根据学校Id取出 校长 和 设备管理员
public List<BaseUser> getUserListBySchoolIdAndRoleCode(String schoolId, String roleCode){
String hql=" from BaseUser t where t.schoolId=:schoolId";
if(isNotEmpty(roleCode)){
hql=hql+" and t.defaultRoleCode=:defaultRoleCode";
}else{
hql=hql+" and (t.defaultRoleCode='role.schoolMaster' or t.defaultRoleCode='role.deviceManager')";
}
hql=hql+" order by t.modTime";
Session session=this.getSession();
Query q=session.createQuery(hql);
q.setParameter("schoolId", schoolId);
if(isNotEmpty(roleCode)){
q.setParameter("defaultRoleCode", roleCode);
}
List<BaseUser> list=q.list();
this.releaseSession(session);
return list;
}
