insertSql.sql 1.5 KB

123456789101112131415
  1. -- 新增二级菜单 OA待办集成
  2. If not exists (select 1 from t_bs_servicesubcategory where fid='iFtAIrcsS0aySCzV7L8F2tj/1C4=')
  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. values
  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. -- 新增视图分类 OA待办集成
  7. If not exists (select 1 from s_bs_uiviewtree where fid='fVOWoQPJRqSgmqbeXFPjo3dTPHE=')
  8. 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)
  9. values
  10. (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);