jindiguanli_Code/sql/insertSql.sql

-- 新增二级菜单 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);

-- 新增视图分类 拓展人员考核
If not exists (select 1 from s_bs_uiviewtree where fid='YxWE8wuHRmKt4BHRNoV2PXdTPHE=')
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'20240515', N'', N'拓展人员考核', N'', null, N'拓展人员考核', null, N'20240515', null, null, null, null, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2024-05-15 13:41:22'}, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2024-05-15 13:41:22'}, '00000000-0000-0000-0000-000000000000CCE7AED4', 'YxWE8wuHRmKt4BHRNoV2PXdTPHE=', null, null);

-- 新增视图分类 绩效评分
If not exists (select 1 from s_bs_uiviewtree where fid='shah5ODIStK7UQ01aRJgU3dTPHE=')
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'20240419', null, N'绩效评分', null, null, N'绩效评分', null, N'20240419', null, null, null, null, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2024-04-19 19:20:31'}, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2024-04-19 19:20:38'}, '00000000-0000-0000-0000-000000000000CCE7AED4', 'shah5ODIStK7UQ01aRJgU3dTPHE=', null, null);

-- 新增二级菜单 绩效考核正态分布
If not exists (select 1 from t_bs_servicesubcategory where fid='IZGDueosTbGDhO/RAJiBY9j/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'20240501', null, null, null, null, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2024-05-01 16:28:42'}, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2024-05-01 16:28:42'}, '00000000-0000-0000-0000-000000000000CCE7AED4', 0, 'IZGDueosTbGDhO/RAJiBY9j/1C4=');

-- 新增二级菜单 拓展人员绩效考核
If not exists (select 1 from t_bs_servicesubcategory where fid='+XxCd61wRh68gLfXvH/8udj/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'20240617', null, null, null, null, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2024-05-17 17:22:51'}, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2024-05-17 17:22:51'}, '00000000-0000-0000-0000-000000000000CCE7AED4', 0, '+XxCd61wRh68gLfXvH/8udj/1C4=');

-- 新增二级菜单 拓展人员绩效考核
If not exists (select 1 from t_bs_servicesubcategory where fid='Nwyre+z1RGyiNsWhUFAeQ9j/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 
(N'eYkAAAAAPxKmKDou', null, N'拓展人员绩效考核', null, N'TZ-20240612', null, null, null, null, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2024-06-12 11:36:26'}, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2024-06-12 11:36:26'}, '00000000-0000-0000-0000-000000000000CCE7AED4', 0, 'Nwyre+z1RGyiNsWhUFAeQ9j/1C4=');

-- 新增二级菜单 正态分布
If not exists (select 1 from t_bs_servicesubcategory where fid='zqQ5FKNgT8mNHgEG8KC+Ptj/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 
(N'eYkAAAAAPxKmKDou', null, N'正态分布', null, N'ZT-20240612', null, null, null, null, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2024-06-12 11:37:06'}, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2024-06-12 11:37:06'}, '00000000-0000-0000-0000-000000000000CCE7AED4', 0, 'zqQ5FKNgT8mNHgEG8KC+Ptj/1C4=');