Domovská stránka Prehľadávať Pomoc
Prihlásiť sa
liuwei
/
jindiguanli_Code
1
0
Fork 0
Súbory Issues 0 Pull requesty 0 Wiki
Branch: master
Branche Tagy
jindiguanli_...
/
sql
/
insertSql.sql

insertSql.sql 8.9 KB
Permanentný odkaz História Raw

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071 
  1. -- 新增二级菜单 OA待办集成
    2. 

  2. If not exists (select 1 from t_bs_servicesubcategory where fid='iFtAIrcsS0aySCzV7L8F2tj/1C4=')
    3. 

  3. 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)
    4. 

  4.  values 
    5. 

  5. ('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=');
    6. 

  6. 

  7. -- 新增视图分类 OA待办集成
    8. 

  8. If not exists (select 1 from s_bs_uiviewtree where fid='fVOWoQPJRqSgmqbeXFPjo3dTPHE=')
    9. 

  9. 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)
    10. 

  10.  values 
    11. 

  11. (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);
    12. 

  12. 

  13. -- 新增视图分类 项目经营奖金
    14. 

  14. If not exists (select 1 from s_bs_uiviewtree where fid='MdwAAAAECyp3Uzxx')
    15. 

  15. 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)
    16. 

  16.  values 
    17. 

  17. (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);
    18. 

  18. 

  19. -- 新增二级菜单 项目经营奖金（员工自助）
    20. 

  20. If not exists (select 1 from t_bs_servicesubcategory where fid='vhMW+b/cS9OAqYphTS2Ypdj/1C4=')
    21. 

  21. 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)
    22. 

  22.  values 
    23. 

  23. ('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=');
    24. 

  24. 

  25. -- 新增二级菜单 项目经营奖金（专业应用）
    26. 

  26. If not exists (select 1 from t_bs_servicesubcategory where fid='B4LsRtmGSg60IuuOrnpBk9j/1C4=')
    27. 

  27. 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)
    28. 

  28.  values 
    29. 

  29. ('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=');
    30. 

  30. 

  31. -- 新增结构配置方案 项目经营奖金
    32. 

  32. If not exists (select 1 from t_hr_structureconfigscheme where fid='MdwAAAAEB0CaHcZP')
    33. 

  33. 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)
    34. 

  34.  values 
    35. 

  35. (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);
    36. 

  36. 

  37. -- 新增视图分类 拓展人员考核
    38. 

  38. If not exists (select 1 from s_bs_uiviewtree where fid='YxWE8wuHRmKt4BHRNoV2PXdTPHE=')
    39. 

  39. 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)
    40. 

  40.  values 
    41. 

  41. (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);
    42. 

  42. 

  43. -- 新增视图分类 绩效评分
    44. 

  44. If not exists (select 1 from s_bs_uiviewtree where fid='shah5ODIStK7UQ01aRJgU3dTPHE=')
    45. 

  45. 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)
    46. 

  46.  values 
    47. 

  47. (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);
    48. 

  48. 

  49. -- 新增二级菜单 绩效考核正态分布
    50. 

  50. If not exists (select 1 from t_bs_servicesubcategory where fid='IZGDueosTbGDhO/RAJiBY9j/1C4=')
    51. 

  51. 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)
    52. 

  52.  values 
    53. 

  53. ('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=');
    54. 

  54. 

  55. -- 新增二级菜单 拓展人员绩效考核
    56. 

  56. If not exists (select 1 from t_bs_servicesubcategory where fid='+XxCd61wRh68gLfXvH/8udj/1C4=')
    57. 

  57. 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)
    58. 

  58.  values 
    59. 

  59. ('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=');
    60. 

  60. 

  61. -- 新增二级菜单 拓展人员绩效考核
    62. 

  62. If not exists (select 1 from t_bs_servicesubcategory where fid='Nwyre+z1RGyiNsWhUFAeQ9j/1C4=')
    63. 

  63. 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)
    64. 

  64.  values 
    65. 

  65. (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=');
    66. 

  66. 

  67. -- 新增二级菜单 正态分布
    68. 

  68. If not exists (select 1 from t_bs_servicesubcategory where fid='zqQ5FKNgT8mNHgEG8KC+Ptj/1C4=')
    69. 

  69. 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)
    70. 

  70.  values 
    71. 

  71. (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=');
    72.