-- 新增二级菜单 OA待办集成
If not exists (select 1 from t_bs_servicesubcategory where fid='iFtAIrcsS0aySCzV7L8F2tj/1C4=')
insert into t_bs_servicesubcategory(FServiceCategoryID, FName_l1, FName_l2, FName_l3, FNumber, FDescription_l1, FDescription_l2, FDescription_l3, FSimpleName, FCreatorID, FCreateTime, FLastUpdateUserID, FLastUpdateTime, FControlUnitID, FIndex, FID)
 values 
('8zxZxwccQMy14rB+1iXTHaYoOi4=', null, N'OA待办', null, N'OA待办', null, null, null, null, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2024-04-26 17:53:19'}, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2024-04-26 17:53:19'}, '00000000-0000-0000-0000-000000000000CCE7AED4', 0, 'iFtAIrcsS0aySCzV7L8F2tj/1C4=');

-- 新增视图分类 OA待办集成
If not exists (select 1 from s_bs_uiviewtree where fid='fVOWoQPJRqSgmqbeXFPjo3dTPHE=')
insert into s_bs_uiviewtree(FIsLeaf, FLevel, FLongNumber, FDisplayName_l1, FDisplayName_l2, FDisplayName_l3, FName_l1, FName_l2, FName_l3, FNumber, FDescription_l1, FDescription_l2, FDescription_l3, FSimpleName, FCreatorID, FCreateTime, FLastUpdateUserID, FLastUpdateTime, FControlUnitID, FID, FParentID, FIndex)
 values 
(1, 1, N'OA待办集成', N'', N'OA待办集成', N'', null, N'OA待办集成', null, N'OA待办集成', null, null, null, null, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2024-05-16 17:11:12'}, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2024-05-16 17:11:12'}, '00000000-0000-0000-0000-000000000000CCE7AED4', 'fVOWoQPJRqSgmqbeXFPjo3dTPHE=', null, null);

-- 新增视图分类 项目经营奖金
If not exists (select 1 from s_bs_uiviewtree where fid='MdwAAAAECyp3Uzxx')
insert into s_bs_uiviewtree(FIsLeaf, FLevel, FLongNumber, FDisplayName_l1, FDisplayName_l2, FDisplayName_l3, FName_l1, FName_l2, FName_l3, FNumber, FDescription_l1, FDescription_l2, FDescription_l3, FSimpleName, FCreatorID, FCreateTime, FLastUpdateUserID, FLastUpdateTime, FControlUnitID, FID, FParentID, FIndex)
 values 
(1, 1, N'101', N'', N'项目经营奖金', N'', null, N'项目经营奖金', null, N'101', null, null, null, null, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2024-04-19 11:40:37'}, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2024-04-19 11:40:37'}, '00000000-0000-0000-0000-000000000000CCE7AED4', N'MdwAAAAECyp3Uzxx', null, null);

-- 新增二级菜单 项目经营奖金（员工自助）
If not exists (select 1 from t_bs_servicesubcategory where fid='vhMW+b/cS9OAqYphTS2Ypdj/1C4=')
insert into t_bs_servicesubcategory(FServiceCategoryID, FName_l1, FName_l2, FName_l3, FNumber, FDescription_l1, FDescription_l2, FDescription_l3, FSimpleName, FCreatorID, FCreateTime, FLastUpdateUserID, FLastUpdateTime, FControlUnitID, FIndex, FID)
 values 
('5mGQU3WGQ+6dmhwiREYwEaYoOi4=', null, N'项目经营奖金', null, N'项目经营奖金', null, null, null, null, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2024-05-07 17:47:51'}, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2024-05-07 17:47:51'}, '00000000-0000-0000-0000-000000000000CCE7AED4', 0, 'vhMW+b/cS9OAqYphTS2Ypdj/1C4=');

-- 新增二级菜单 项目经营奖金（专业应用）
If not exists (select 1 from t_bs_servicesubcategory where fid='B4LsRtmGSg60IuuOrnpBk9j/1C4=')
insert into t_bs_servicesubcategory(FServiceCategoryID, FName_l1, FName_l2, FName_l3, FNumber, FDescription_l1, FDescription_l2, FDescription_l3, FSimpleName, FCreatorID, FCreateTime, FLastUpdateUserID, FLastUpdateTime, FControlUnitID, FIndex, FID)
 values 
('Z4Ap5CbeQR+EAYEy/OZtWKYoOi4=', null, N'项目奖金核算', null, N'项目奖金核算', null, null, null, null, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2024-04-25 17:47:54'}, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2024-04-25 17:47:54'}, '00000000-0000-0000-0000-000000000000CCE7AED4', 0, 'B4LsRtmGSg60IuuOrnpBk9j/1C4=');

-- 新增结构配置方案 项目经营奖金
If not exists (select 1 from t_hr_structureconfigscheme where fid='MdwAAAAEB0CaHcZP')
insert into t_hr_structureconfigscheme(FName_l1, FName_l2, FName_l3, FNumber, FDescription_l1, FDescription_l2, FDescription_l3, FSimpleName, FCreatorID, FCreateTime, FLastUpdateUserID, FLastUpdateTime, FControlUnitID, FID, FIsPreset, FSqlImplClass, FPreSqlImplClass, FFieldImplClass)
 values 
(null, N'项目经营奖金核算', null, N'Custom_103', null, null, null, null, '/cn/jGiRQRetygAP1YAJEBO33n8=', {ts'2024-04-17 14:16:22'}, '/cn/jGiRQRetygAP1YAJEBO33n8=', {ts'2024-04-17 14:16:22'}, '00000000-0000-0000-0000-000000000000CCE7AED4', N'MdwAAAAEB0CaHcZP', 0, null, null, null);