OPMS/02-系統分析、設計階段/DBScript/20141014/insertIntoSysAndInsertPro.sql

--插入專案權限模組的參數
INSERT INTO dbo.OTB_SYS_SystemSetting
        ( OrganizationID ,
          SettingItem ,
          SettingDescription ,
          SettingValue ,
          Memo ,
          Effective ,
          CreateUser ,
          CreateDate ,
          ModifyUser ,
          ModifyDate
        )
VALUES  ( 'Origtek' , -- OrganizationID - varchar(50)
          N'PrjAuthMod' , -- SettingItem - nvarchar(50)
          N'專案權限模組' , -- SettingDescription - nvarchar(100)
          N'DEV;PRJ;' , -- SettingValue - nvarchar(400)
          '' , -- Memo - text
          'Y' , -- Effective - char(1)
          'apadmin' , -- CreateUser - varchar(50)
          GETDATE(), -- CreateDate - datetime
          'apadmin' , -- ModifyUser - varchar(50)
          GETDATE()  -- ModifyDate - datetime
        )
        
  --插入專案程式授權瀏覽程式
INSERT INTO  dbo.OTB_SYS_ProgramList
        ( OrganizationID ,
          ProgramID ,
          LanguageID ,
          ProgramName ,
          ModuleID ,
          FilePath ,
          ImgPath ,
          AllowRight ,
          OrderByValue ,
          ProgramType ,
          BackgroundCSS ,
          GroupTag ,
          Effective ,
          ShowInList ,
          MainTableName ,
          Memo ,
          CreateUser ,
          CreateDate ,
          ModifyUser ,
          ModifyDate
        )
VALUES  ( 'Origtek' , -- OrganizationID - varchar(50)
          N'WorkAuthorizePrograms' , -- ProgramID - nvarchar(200)
          N'zh-TW' , -- LanguageID - nvarchar(50)
          N'專案程式授權瀏覽' , -- ProgramName - nvarchar(100)
          'PRJ' , -- ModuleID - varchar(10)
          N'Page/PRJ/WorkAuthorizePrograms.aspx' , -- FilePath - nvarchar(500)
          N'setting2' , -- ImgPath - nvarchar(500)
          'Upd|Save|Qry|View                                                                                                                                                                                       ' , -- AllowRight - char(200)
          (SELECT COUNT(0)+1 FROM dbo.OTB_SYS_ProgramList WHERE ModuleID='PRJ') , -- OrderByValue - int
          'P' , -- ProgramType - varchar(1)
          'blue-box' , -- BackgroundCSS - varchar(50)
          N'' , -- GroupTag - nvarchar(200)
          'Y' , -- Effective - char(1)
          'Y' , -- ShowInList - char(1)
          'OTB_PRJ_WorkAuthorize' , -- MainTableName - varchar(50)
          '' , -- Memo - text
          'apadmin' , -- CreateUser - varchar(50)
          GETDATE() , -- CreateDate - datetime
          'apadmin' , -- ModifyUser - varchar(50)
          GETDATE()  -- ModifyDate - datetime
        )


--插入專案程式授權瀏覽權限

INSERT INTO dbo.OTB_SYS_Authorize
        ( OrganizationID ,
          RuleID ,
          ProgramID ,
          AllowRight ,
          Memo ,
          CreateUser ,
          CreateDate ,
          ModifyUser ,
          ModifyDate
        )
VALUES  ( 'Origtek' , -- OrganizationID - varchar(50)
          'Admin' , -- RuleID - varchar(20)
          'WorkAuthorizePrograms' , -- ProgramID - varchar(200)
          'Save|Upd|Qry|View                                                                                                                                                                                       ' , -- AllowRight - char(200)
          '' , -- Memo - text
          'apadmin' , -- CreateUser - varchar(50)
          GETDATE() , -- CreateDate - datetime
          'apadmin' , -- ModifyUser - varchar(50)
          GETDATE()  -- ModifyDate - datetime
        )

--插入專案複製權限程式
INSERT INTO  dbo.OTB_SYS_ProgramList
        ( OrganizationID ,
          ProgramID ,
          LanguageID ,
          ProgramName ,
          ModuleID ,
          FilePath ,
          ImgPath ,
          AllowRight ,
          OrderByValue ,
          ProgramType ,
          BackgroundCSS ,
          GroupTag ,
          Effective ,
          ShowInList ,
          MainTableName ,
          Memo ,
          CreateUser ,
          CreateDate ,
          ModifyUser ,
          ModifyDate
        )
VALUES  ( 'Origtek' , -- OrganizationID - varchar(50)
          N'PrjCopyRight_Pop' , -- ProgramID - nvarchar(200)
          N'zh-TW' , -- LanguageID - nvarchar(50)
          N'專案複製權限' , -- ProgramName - nvarchar(100)
          'PRJ' , -- ModuleID - varchar(10)
          N'Page/Utl/PrjCopyRight_Pop.aspx' , -- FilePath - nvarchar(500)
          N'setting2' , -- ImgPath - nvarchar(500)
          'View|Upd',
          (SELECT COUNT(0)+1 FROM dbo.OTB_SYS_ProgramList WHERE ModuleID='PRJ') , -- OrderByValue - int
          'S' , -- ProgramType - varchar(1)
          '-box' , -- BackgroundCSS - varchar(50)
          N'PrjCopyRight' , -- GroupTag - nvarchar(200)
          'Y' , -- Effective - char(1)
          'N' , -- ShowInList - char(1)
          '' , -- MainTableName - varchar(50)
          '' , -- Memo - text
          'apadmin' , -- CreateUser - varchar(50)
          GETDATE() , -- CreateDate - datetime
          'apadmin' , -- ModifyUser - varchar(50)
          GETDATE()  -- ModifyDate - datetime
        )


--插入案複製權限權限

INSERT INTO dbo.OTB_SYS_Authorize
        ( OrganizationID ,
          RuleID ,
          ProgramID ,
          AllowRight ,
          Memo ,
          CreateUser ,
          CreateDate ,
          ModifyUser ,
          ModifyDate
        )
VALUES  ( 'Origtek' , -- OrganizationID - varchar(50)
          'Admin' , -- RuleID - varchar(20)
          'PrjCopyRight_Pop' , -- ProgramID - varchar(200)
          'View|Upd',
          '' , -- Memo - text
          'apadmin' , -- CreateUser - varchar(50)
          GETDATE() , -- CreateDate - datetime
          'apadmin' , -- ModifyUser - varchar(50)
          GETDATE()  -- ModifyDate - datetime
        )