466 lines
16 KiB
Transact-SQL
466 lines
16 KiB
Transact-SQL
------------------------------以下为项目现场初始化脚本----------------------------------------
|
|
|
|
--插入角色内置项
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,IsHeadRole,SortIndex)
|
|
VALUES('1184835B-73AF-47FB-9F83-20740CE2FAD7','项目经理','项目经理','0',0,10)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,SortIndex)
|
|
VALUES('A184835B-73AF-ERHM-9F83-20740CE2FAD7','项目副经理','项目副经理','0',20)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,IsHeadRole,SortIndex)
|
|
VALUES('BE489563-7C3C-4DB5-93C7-E5E9435FF76C','项目总工程师','项目总工程师','0',0,30)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,IsHeadRole,SortIndex)
|
|
VALUES('UTD74411-D95E-4CB3-B6D1-F41B4F4FB268','控制经理','控制经理','0',0,40)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,IsHeadRole,SortIndex)
|
|
VALUES('GCB64EF3-AB0A-40BC-824D-CC314598D5DC','质量经理','质量经理','0',0,50)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,IsHeadRole,SortIndex)
|
|
VALUES('3314753D-E295-4D87-B938-E8C8EF5C17BC','项目HSSE经理','项目HSSE经理','0',0,60)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,IsHeadRole,SortIndex)
|
|
VALUES('9BED9186-1FB1-4711-963F-E90D6EC1D629','设计经理','设计经理','0',0,70)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,IsHeadRole,SortIndex)
|
|
VALUES('DBEB0B79-0713-495C-8BD9-8C4330D1178A','采购经理','采购经理','0',0,80)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,IsHeadRole,SortIndex)
|
|
VALUES('22F78A47-F59C-4FE8-9C43-2DD304CB2108','施工经理','施工经理','0',0,90)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,SortIndex)
|
|
VALUES('AAE579CF-A249-4336-BAFE-7FB4D5753451','施工副经理','施工副经理','0',100)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,IsHeadRole,SortIndex)
|
|
VALUES('44AA326B-43B9-4535-9294-B2B62C7FAD25','现场HSSE经理','现场HSSE经理','0',0,110)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,IsHeadRole,SortIndex)
|
|
VALUES('TA3737E4-3677-4B7C-B6F6-D546CC2D83E0','开车经理','开车经理','0',0,120)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,IsHeadRole,SortIndex)
|
|
VALUES('552B3348-0813-46C0-828E-41CB6457FACD','行政经理','行政经理','0',0,130)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,IsHeadRole,SortIndex)
|
|
VALUES('9E1180FA-D941-4CC7-9319-BDF61D3F6A2B','财务经理','财务经理','0',0,140)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,IsHeadRole,SortIndex)
|
|
VALUES('66D2ECB4-2946-4C6E-8E4B-1C4CD096B8A5','HSSE工程师','HSSE工程师','0',0,150)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,IsHeadRole,SortIndex)
|
|
VALUES('E1D2CAAF-0564-4ED4-A5C5-1DB3C437FB1D','计划工程师','计划工程师','0',0,160)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,IsHeadRole,SortIndex)
|
|
VALUES('07565BEB-6536-4B4B-A74E-70F00D0FA11A','专业工程师','专业工程师','0',0,170)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,SortIndex)
|
|
VALUES('AAE5734F-A249-4336-BAFE-7FB4D5753451','土建工程师','土建工程师','0',180)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,SortIndex)
|
|
VALUES('AAE5734F-A249-4336-BAFE-7FB4D575WE6J','钢结构工程师','钢结构工程师','0',190)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,SortIndex)
|
|
VALUES('AAE576UJ-A249-4336-BAFE-7FB4D5WSYH51','静设备工程师','静设备工程师','0',200)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,SortIndex)
|
|
VALUES('AAE576UJ-A249-4336-E6YM-7FB4D5753451','动设备工程师','动设备工程师','0',210)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,SortIndex)
|
|
VALUES('AAE5ED8I-A249-4336-E6YM-7FB4D5753451','工业炉工程师','工业炉工程师','0',220)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,SortIndex)
|
|
VALUES('AAE578IL-A249-4336-BAFE-7FB4D5753451','配管工程师','配管工程师','0',230)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,SortIndex)
|
|
VALUES('AAE578IL-A249-EBJL-BAFE-7FB4D5753451','暖通工程师','暖通工程师','0',240)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,SortIndex)
|
|
VALUES('AAE570JA-A249-4336-BAFE-7FB4D5753451','电气工程师','电气工程师','0',250)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,SortIndex)
|
|
VALUES('AAE5757G-A249-4336-BAFE-7FB4D5753451','仪表工程师','仪表工程师','0',260)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,SortIndex)
|
|
VALUES('AAE577ID-A249-4336-BAFE-7FB4D5753451','焊接工程师','焊接工程师','0',270)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,SortIndex)
|
|
VALUES('AAE577UZ-A249-4336-BAFE-7FB4D5753451','防腐保温工程师','防腐保温工程师','0',280)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,SortIndex)
|
|
VALUES('AAE5779O-A249-4336-BAFE-7FB4D5753451','施工文档工程师','施工文档工程师','0',290)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,SortIndex)
|
|
VALUES('AAE575EM-A249-4336-BAFE-7FB4D5753451','文档管理员','文档管理员','0',300)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,SortIndex)
|
|
VALUES('02F96989-10DD-42B7-AA8B-984AF83AE93E','本部人员','本部人员','0',310)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Role(RoleId,RoleName,Def,RoleType,SortIndex)
|
|
VALUES('b28e9e8c-033b-40af-b9ed-e8685df0b6bb','公司领导','公司领导','0',320)
|
|
GO
|
|
|
|
|
|
--插入岗位数据、
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('226F36DD-9748-4103-A764-989FE0187804','项目总工程师','1', 0, 10)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('444A23CD-7BC1-4B9F-AA8A-2C475A761105','控制经理','1', 0, 20)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('88EDF2BA-8E7E-44C6-8F9B-BC04AF526092','设计经理','1', 0, 30)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('3F322FF1-85AA-49E8-9F8E-CFB4F9302C71','采购经理','1', 0, 40)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('79C7C625-7E96-4EA7-98D5-5E8DA68E32D2','行政经理','1', 0, 50)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('76C3A86B-67C9-4E15-B086-AD4ABCCA018E','财务经理','1', 0, 60)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('4CC66A56-8EAD-4BF8-9C91-A52F5E20E2F5','开车经理','1', 0, 70)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('F76549BF-60BF-4370-9071-556BFE7124FC','土建工程师','1', 0, 80)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('4CE85B38-E3C0-4E97-830F-1D0870C2FD0A','设备工程师','1', 0, 90)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('B41A4E41-7307-4756-900F-E26FD6ED33D6','配管工程师','1', 0, 100)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('D7110C67-D560-41EB-B988-CDB475B1F6A8','电气工程师','1', 0, 110)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('142AF0FA-45E0-4C85-8694-82BF9BDE25FF','仪表工程师','1', 0, 120)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('2E86E0EB-0246-48DE-8104-CD8E2E2F96F4','焊接工程师','1', 0, 130)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('B3FBBE99-E5A5-454E-B508-37AE80C33083','文档控制工程师','1', 0, 140)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('46AA7960-1D35-4D5B-8C8F-AA4C874D63C8','文档工程师','1', 0, 150)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('7A6C2F36-DAF5-4785-8792-ED0C9C6E4550','文档管理','1', 0, 160)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('3FE5DA34-1BBF-4740-9688-6FC14723CC9B','行政管理','1', 0, 170)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('2C4B7B62-0BE1-45B1-B65C-5806DF34ECDB','计划工程师','1', 0, 180)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('3A3CFCB0-0BBE-4FEB-AF14-9589E0056331','采购工程师','1', 0, 190)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('7EB5C614-47E3-474E-B071-87361FC6E2AE','质检工程师','1', 0, 200)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('2FE59316-617E-4D86-9483-AFA9E78C7711','合同工程师','1', 0, 210)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('2A1043F3-6308-40C1-9C39-3154123AE0A8','进度统计','1', 0, 220)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('A2F57FBD-3323-4C8A-881B-974C30CC754F','材料控制工程师','1', 0, 230)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('78F9D891-D4E0-46BB-8A09-A055077F832A','无损检测工程师','1', 0, 240)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('22D9C1C5-B751-43AD-AD66-247A1A3537A9','质量管理','1', 0, 250)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('727BAB7C-64A6-4417-9815-D4645B57D448','技术员','1', 0, 260)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('2AE2A7BF-B991-4AE5-A09F-8C1F88154764','项目经理','2', 0, 270)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('5AB300C3-2DFA-44E7-9A39-D13CD03E02D0','施工经理','2', 0, 280)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('8A7C2CDF-AFB5-4826-9951-343253342DAC','HSE经理','2', 1, 290)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('B940FD8F-E8AD-49E1-89E1-33594D20A89E','现场HSE经理','2', 1, 300)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('D1115B78-C9E1-43A4-8AB1-FF099CAF7BA4','HSE工程师','2', 1, 310)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('8615F559-6898-4DD6-AD39-658D203000D1','质量经理','2', 0, 320)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('E1936B0C-E9A7-4298-96AE-DE67CE7E4695','质量工程师','2', 0, 330)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('F2AAEF7B-C28C-422F-8666-88C09E718045','质检员','2', 0, 340)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('2E71A650-6D40-459A-AAC1-5FB5E00D247C','电工','2', 0, 350)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('1133CC37-61A4-4EB8-B108-1E34ED9443D1','仪表工','2', 0, 360)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('41EF8B02-2852-495E-A2BE-2EF19BA70A4F','测量工','2', 0, 370)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('19B8F2A9-28D3-4F20-867A-1B2237C2E228','焊工','2', 0, 380)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('595999E9-75A8-4064-9BD1-9EE02F236297','无损检测员','2', 0, 390)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('0BAAE40A-1FEC-4DD2-A722-32DF29A43630','起重吊装工','2', 0, 400)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('1331D109-6435-4709-9A35-65AEC7B3F06F','登高架设工','2', 0, 410)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('054E426D-4F98-40BA-80D8-7EEA008A9082','司机','2', 0, 420)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('65F02FD8-6C67-402E-9588-4DAB038A697A','混凝土工','3', 0, 430)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('48280AA2-62D6-4105-AAA7-C38471F44DA9','钢筋工','3', 0, 440)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('A7728813-2FCC-428A-9EB5-4C70A146B770','力工','3', 0, 450)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('FA155A27-E5E5-44DF-8CC3-05404F572DB8','木工','3', 0, 460)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('668CB91E-F067-42E6-95ED-FFF1BCCE4576','瓦工','3', 0, 470)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('50CC11D5-D6CB-4075-9130-06EB999A1DB7','安装工','3', 0, 480)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('D973076E-D08D-4CEC-A73F-ECAD0F0EC915','管工','3', 0, 490)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('9CEE0230-75AC-4E4A-8BF7-1EF6AF17E592','钳工','3', 0, 500)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('B93C845C-A611-4A50-9137-7428AAFA27B9','衬里工','3', 0, 510)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('EA7CCECC-54C3-4E31-BFDA-2C3824F395CF','油工','3', 0, 520)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('8F5D82FD-05D1-4EF2-B621-13EC2F7091F4','防火工','3', 0, 530)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('558124BF-B678-48EB-B7DB-22211951747B','保温工','3', 0, 540)
|
|
GO
|
|
|
|
INSERT INTO dbo.Base_Post(PostId, PostName, PostType, IsHsse, SortIndex)
|
|
VALUES('E3C20A74-9BAD-44DD-931B-9531A2A18952','防腐工','3', 0, 550)
|
|
GO
|
|
|
|
|
|
--模板类型脚本
|
|
INSERT INTO Common_FileManageType(FileCode,FileType,SortIndex)
|
|
VALUES('HSSE_ManagerRuleTemplate','HSSE管理规定',1)
|
|
GO
|
|
|
|
INSERT INTO Common_FileManageType(FileCode,FileType,SortIndex)
|
|
VALUES('HSSE_ActionPlanTemplate','HSSE实施计划',2)
|
|
GO
|
|
|
|
INSERT INTO Common_FileManageType(FileCode,FileType,SortIndex)
|
|
VALUES('HSSE_MeetingTemplate','HSSE会议',3)
|
|
GO
|
|
|
|
INSERT INTO Common_FileManageType(FileCode,FileType,SortIndex)
|
|
VALUES('HSSE_EmergencyTemplate','HSSE应急预案',4)
|
|
GO
|
|
|
|
INSERT INTO Common_FileManageType(FileCode,FileType,SortIndex)
|
|
VALUES('HSSE_EmergencyDrillTemplate','HSSE应急响应',5)
|
|
GO
|
|
|
|
INSERT INTO Common_FileManageType(FileCode,FileType,SortIndex)
|
|
VALUES('HSSE_NoticeTemplate','HSSE通知通告',6)
|
|
GO
|
|
|
|
INSERT INTO Common_FileManageType(FileCode,FileType,SortIndex)
|
|
VALUES('HSSE_ManagerWeekTemplate','HSSE安全管理周报',7)
|
|
GO
|
|
|
|
INSERT INTO Common_FileManageType(FileCode,FileType,SortIndex)
|
|
VALUES('HSSE_ManagerMonthTemplate','HSSE安全管理月报',8)
|
|
GO
|
|
|
|
INSERT INTO Common_FileManageType(FileCode,FileType,SortIndex)
|
|
VALUES('HSSE_ManagerTotalTemplate','HSSE安全工作总结',9)
|
|
GO
|
|
|
|
INSERT INTO Common_FileManageType(FileCode,FileType,SortIndex)
|
|
VALUES('HSSE_ManagerPerformanceTemplate','HSSE安全顾客评价',10)
|
|
GO
|
|
|
|
INSERT INTO Common_FileManageType(FileCode,FileType,SortIndex)
|
|
VALUES('HSSE_LicenseManagerTemplate','HSSE安全作业许可证',11)
|
|
GO
|
|
|
|
INSERT INTO Common_FileManageType(FileCode,FileType,SortIndex)
|
|
VALUES('HSSE_CheckMonthTemplate','HSSE安全月检查表',12)
|
|
GO
|
|
|
|
INSERT INTO Common_FileManageType(FileCode,FileType,SortIndex)
|
|
VALUES('HSSE_CheckMonthTotalTemplate','HSSE安全HSE月总结',13)
|
|
GO
|
|
|
|
INSERT INTO Common_FileManageType(FileCode,FileType,SortIndex)
|
|
VALUES('HSSE_AccidentTemplate','HSSE事故报告',14)
|
|
GO
|
|
|
|
INSERT INTO Common_FileManageType(FileCode,FileType,SortIndex)
|
|
VALUES('HSSE_Log','HSSE管理日志',15)
|
|
GO
|
|
|
|
INSERT INTO Common_FileManageType(FileCode,FileType,SortIndex)
|
|
VALUES('CQMS_ManagerRuleTemplate','施工质量管理规定',20)
|
|
GO
|
|
|
|
INSERT INTO Common_FileManageType(FileCode,FileType,SortIndex)
|
|
VALUES('CQMS_ConstructSolutionTemplate','质量施工方案',21)
|
|
GO
|
|
|
|
INSERT INTO Common_FileManageType(FileCode,FileType,SortIndex)
|
|
VALUES('CQMS_DrawingAuditTemplate','施工质量设计交底会议纪要',22)
|
|
GO
|
|
|
|
INSERT INTO Common_FileManageType(FileCode,FileType,SortIndex)
|
|
VALUES('CQMS_NoFourLetoffTemplate','施工质量四不放过',23)
|
|
GO
|
|
|
|
INSERT INTO Common_FileManageType(FileCode,FileType,SortIndex)
|
|
VALUES('CQMS_NonconformityNoticeTemplate','施工质量不合格品通知单',24)
|
|
GO
|
|
|
|
INSERT INTO Common_FileManageType(FileCode,FileType,SortIndex)
|
|
VALUES('CQMS_NonconformityReviewTemplate','施工质量不合格品评审和处置',25)
|
|
GO
|
|
|
|
INSERT INTO Common_FileManageType(FileCode,FileType,SortIndex)
|
|
VALUES('CQMS_MeetingTemplate','施工质量会议',26)
|
|
GO
|
|
|
|
INSERT INTO Common_FileManageType(FileCode,FileType,SortIndex)
|
|
VALUES('CQMS_NoticeTemplate','施工质量管理通知',27)
|
|
GO
|
|
|
|
INSERT INTO Common_FileManageType(FileCode,FileType,SortIndex)
|
|
VALUES('CQMS_RectifyNoticeTemplate','施工质量问题整改通知单',28)
|
|
GO
|
|
|
|
INSERT INTO Common_FileManageType(FileCode,FileType,SortIndex)
|
|
VALUES('CQMS_RepriseApplyTemplate','施工质量工程复工报告',29)
|
|
GO
|
|
|
|
INSERT INTO Common_FileManageType(FileCode,FileType,SortIndex)
|
|
VALUES('CQMS_PauseNoticeTemplate','施工质量工程暂停令',30)
|
|
GO
|
|
|
|
INSERT INTO Common_FileManageType(FileCode,FileType,SortIndex)
|
|
VALUES('CQMS_Log','施工日志',31)
|
|
GO
|
|
|
|
INSERT INTO Common_FileManageType(FileCode,FileType,SortIndex)
|
|
VALUES('EmptyWordTemplate','空Word模板',0)
|
|
GO |