fwOA获取当前用户信息及常用数据库表

灰太狼 2021-09-24 19:28 995阅读 0赞

## 一、 获取当前用户信息 ##

User user = HrmUserVarify.getUser(request, response);//获取用户信息
    int userId=user.getUID();//用户id
    //out.println("userId="+userId);
    int department=user.getUserDepartment();//用户所在部门

注：https://www.codeleading.com/article/5580720811

### 二、修改用户密码 ###

*  [泛微OA-测试环境更新所有密码为1][OA-_1]

update  hrmresource set password= 'C4CA4238A0B923820DCC509A6F75849B'

*  [泛微OA-测试机更改sysadmin密码为1][OA-_sysadmin_1]

update HrmResourceManager set password = 'C4CA4238A0B923820DCC509A6F75849B' 
    where loginid = 'sysadmin'

### 三、 常用数据库表 ###

1.  人力资源相关

<table> 
 <thead> 
  <tr> 
   <th>表名</th> 
   <th>说明</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>HrmResource</td> 
   <td>人力资源基本信息表</td> 
  </tr> 
  <tr> 
   <td>HrmDepartment</td> 
   <td>人力资源部门表</td> 
  </tr> 
  <tr> 
   <td>hrmroles</td> 
   <td>角色信息表</td> 
  </tr> 
  <tr> 
   <td>hrmrolemembers</td> 
   <td>角色人员</td> 
  </tr> 
  <tr> 
   <td>hrmjobtitles</td> 
   <td>人力资源岗位表</td> 
  </tr> 
 </tbody> 
</table>

1.  流程相关

<table> 
 <thead> 
  <tr> 
   <th>表名</th> 
   <th>说明</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>workflow_requestbase</td> 
   <td>请求基本信息</td> 
  </tr> 
  <tr> 
   <td>workflow_currentoperator</td> 
   <td>请求节点操作人</td> 
  </tr> 
  <tr> 
   <td>workflow_requestlog</td> 
   <td>请求签字意见</td> 
  </tr> 
  <tr> 
   <td>workflow_nownode</td> 
   <td>请求当前节点</td> 
  </tr> 
  <tr> 
   <td>workflow_nodebase</td> 
   <td>节点信息</td> 
  </tr> 
 </tbody> 
</table>

注：https://blog.csdn.net/qq\_35152742/article/details/103820093

[OA-_1]: https://blog.csdn.net/weixin_42188827/article/details/89332746
[OA-_sysadmin_1]: https://blog.csdn.net/weixin_42188827/article/details/89393984