金蝶系统组织架构封存sql使用

原创已于 2022-12-02 20:32:31 修改 · 735 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#sql #数据库 #java

收录于

于 2022-12-02 17:55:07 首次发布

金蝶EAS BOS开发同时被 2 个专栏收录

40 篇文章

订阅专栏

oracle

8 篇文章

订阅专栏

本文介绍了一种通过SQL语句实现批量更新和查询的方法，包括如何针对不同表（如t_org_admin、T_ORG_CostCenter和T_ORG_BaseUnit）进行数据封存状态的查询及更新操作。此外还提供了一个复杂查询示例，用于筛选符合特定条件的部门信息。

select FIsSealUp from t_org_admin where fnumber in ('XXXX')
select FIsSealUp from T_ORG_CostCenter where fnumber in ('XXXX')
select FIsOUSealUp from T_ORG_BaseUnit where fnumber in ('XXX')

update t_org_admin set FIsSealUp=1 where fnumber in ('XXXX');
update T_ORG_CostCenter set FIsSealUp=1 where fnumber in ('XXXX');
update T_ORG_BaseUnit set FIsOUSealUp=1 where fnumber in ('XXX');

select fnumber,fname_l2,flongnumber from t_org_admin where fnumber not in (select deptcode from tj_hr_department where eff_status='A')
and FIsSealUp=0
and fnumber not in (select fnumber from t_org_company)
and fname_l2 not like '%公共%'
order by flongnumber