lpf
/
CNCEC_SUBQHSE_WUHUAN
2
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
CNCEC_SUBQHSE_WUHUAN/DataBase/ConstInitData.sql

1454 lines
74 KiB
Transact-SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

-- 系统环境常量
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId) --月报上报时间
VALUES('E909CD49-9081-443F-8B40-24F098272B3D','MonthReprotDate','10',1,'SysSet')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId) --季报上报时间 第一季月
VALUES('0686A181-F820-4F13-BE6D-738C9D50D63E','QuarterReprotMonth_1','3',2,'SysSet')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId) --季报上报时间 第一季日
VALUES('F1FA467C-A1EA-4B51-BE4B-D5A3B6925AF7','QuarterReprotDate_1','26',3,'SysSet')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId) --季报上报时间 第二季月
VALUES('D899B811-9EAC-44D4-93C2-42F212B2A080','QuarterReprotMonth_2','6',4,'SysSet')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId) --季报上报时间 第二季日
VALUES('804C1BE3-1F3D-48E9-A4E3-51E641EA120C','QuarterReprotDate_2','26',5,'SysSet')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId) --季报上报时间 第三季月
VALUES('63CCF760-3E42-4DD4-AA37-5AB845C411A4','QuarterReprotMonth_3','9',6,'SysSet')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId) --季报上报时间 第三季日
VALUES('41C0C3ED-31A2-4DE0-89FC-B91E28A8EA5F','QuarterReprotDate_3','26',7,'SysSet')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId) --季报上报时间 第四季月
VALUES('E4148C94-EA99-44B0-9444-C29B70C77C72','QuarterReprotMonth_4','12',8,'SysSet')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId) --季报上报时间 第四季日
VALUES('1EC24125-AA73-4F02-9F35-AF51277E042F','QuarterReprotDate_4','26',9,'SysSet')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId) --半年上报时间 上半年月
VALUES('145917FB-CDE9-42FF-A69F-7F19672344F2','HalfYearMonth_1','6',10,'SysSet')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId) --半年上报时间 上半年日
VALUES('543EFFC0-E121-4A61-95E7-96B555B80E2E','HalfYearDate_1','26',11,'SysSet')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId) --半年上报时间 下半年月
VALUES('1D1B7E14-6A5E-436C-A65B-87C09124D6A1','HalfYearMonth_2','12',12,'SysSet')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId) --半年上报时间 下半年日
VALUES('060DA304-75A5-4D8C-90EE-AB7B117677F5','HalfYearDate_2','26',13,'SysSet')
GO
--是/否
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('D7B5EE3F-C070-403D-9287-E25F281229D6','True','是',1,'0001')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('C067159D-EC24-40DC-93C8-C0FF5DA89020','False','否',2,'0001')
GO
-- 性别：男/女
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('6DE626DA-BCF5-464C-9449-54DF5F47EA7B','1','男',1,'0002')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('A7092032-559E-4EC1-9104-305B80F0ECC4','2','女',2,'0002')
GO
/**********婚姻状况***************/
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('A8A7F64D-39FA-4F0D-A828-7725D3BAD57F0','未婚','未婚',1,'0003')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('D2CA2922-924D-414F-9200-2589C0C6D431','已婚','已婚',2,'0003')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('0F0FDE76-38DF-47ED-90F5-B461EB8CDC4E','离异','离异',3,'0003')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('CB28CD02-D12A-4BC1-A124-91BE69F8B2D2','丧偶','丧偶',4,'0003')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('82B95ECB-CC1B-4CD0-A827-DF7C6FCCF63F','未说明','未说明',5,'0003')
GO
/**********文化程度**************/
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('F5704416-9C41-4AA2-939C-260337BCC872','博士及以上','博士及以上',1,'0004')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('74DE6396-D363-4F1E-962B-0C2D547181F9','研究生','研究生',2,'0004')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('DDE9EC0C-6D77-4E8A-82EF-2D1F5F4FC0D2','本科','本科',3,'0004')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('AC53F279-BCD3-4183-90FF-BEEBB05BBDBE','专科','专科',4,'0004')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('3616391D-13EF-4CFC-868F-4AA708190D72','高中','高中',5,'0004')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('6CE18362-38C3-44EE-A0F9-9446BF9B9138','初中','初中',6,'0004')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('CBC32930-4D99-41EE-992F-A352FEF640D5','小学及以下','小学及以下',7,'0004')
GO
/******民族*****/
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('4B420968-C6B9-4E1F-BF7D-C2076D1D0C10','汉族','汉族',1,'0005')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('C3DFF299-7530-43A3-8706-7F8A16A0AD36','回族','回族',2,'0005')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('CE9A8CDA-897D-4614-B784-70C23FA9CA44','壮族','壮族',3,'0005')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('3C199EC7-5EA4-41B4-97CD-64F947883F99','回族','回族',4,'0005')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('250752A7-8648-414E-B79A-719865CC97AF','苗族','苗族',5,'0005')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('56C99737-1E2D-41E6-8700-A10E6A0AF489','维吾尔族','维吾尔族',6,'0005')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('FFC3FACB-F135-48A9-B411-4BABD5390172','土家族','土家族',7,'0005')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('2DA95986-8660-4747-A56F-C307B644708B','彝族','彝族',8,'0005')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('628E5432-BAB1-40A3-AF74-943CEEA555E9','蒙古族','蒙古族',9,'0005')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('525B6E87-3B61-43AA-A0E3-41EB74F84612','藏族','藏族',10,'0005')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('1A2380C8-8E39-4417-8922-4E4FDCAF12EB','布依族','布依族',11,'0005')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('D5F0EE71-FBE0-4768-8125-7B6C84AB5BD4','侗族','侗族',12,'0005')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('01F69357-6224-4A45-B1B8-E14458EB2FA2','瑶族','瑶族',13,'0005')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('5B5932FD-4B25-4A8D-85E3-A26D13B842C5','朝鲜族','朝鲜族',14,'0005')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('CA953687-04B5-447E-8AE5-8B55862F8B7D','白族','白族',15,'0005')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('04B20FBC-405D-488D-B648-020298573D09','其他','其他',16,'0005')
GO
/*****危险源辅助方法******/
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('9E394C78-2C3A-4809-8DD8-AEBEA1604A29','I','I',1,'0006')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('F9C65328-E823-4980-AD63-5DDD86AD9D5F','Ⅱ','Ⅱ',2,'0006')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('36F14107-686E-4C20-89C2-C47BC2AED713','Ⅲ','Ⅲ',3,'0006')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('619EB90A-BE4C-44D0-BDF5-0382D759ED9A','Ⅳ','Ⅳ',4,'0006')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('AEC1885D-6282-4580-940E-E4046517B0E0','Ⅴ','Ⅴ',5,'0006')
GO
/****危险级别****/
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('8D97C51C-6253-4276-9498-71563CE1D350','1','1级',1,'0007')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('3276B596-6A70-404A-A654-452694C0BAAB','2','2级',2,'0007')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('C5BE90E8-4EFC-441C-8795-D5FBA457CFEB','3','3级',3,'0007')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('650A321B-8EC7-449D-9C2F-A1EAB7449BE0','4','4级',4,'0007')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('46C35A27-5DDC-417A-BEEC-A20E8CB865DF','5','5级',5,'0007')
GO
/****年份****/
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('08512BB0-18AC-4AB6-A71C-AA6A382FEA51','2010','2010年',2010,'0008')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('E63DB0F1-B129-4152-A642-E0829C6FCF92','2011','2011年',2011,'0008')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('D60217FE-D9D8-4E2A-9FDA-F966E7003C4B','2012','2012年',2012,'0008')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('D35DFE6A-8186-4150-A0AE-02320D36DC5A','2013','2013年',2013,'0008')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('8EB3A33A-2DC5-4F9B-8CA8-900B3F5D87AD','2014','2014年',2014,'0008')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('8F8149A1-EA63-4457-8A07-60BE31D7AEE6','2015','2015年',2015,'0008')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('47C58759-8652-46CD-A296-852266711566','2016','2016年',2016,'0008')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('E3D1C073-321A-4785-AE2B-F0F3EA6B2EC0','2017','2017年',2017,'0008')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('5E73DEEA-4B99-4FD0-8628-FCB2C6140363','2018','2018年',2018,'0008')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('3D26B11E-9F1C-48F4-8B27-A8BC7FA95C53','2019','2019年',2019,'0008')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('04BCEBAC-AD96-42EA-B94E-90C005FC7307','2020','2020年',2020,'0008')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('658AAE9C-0044-46F6-94BD-D059627150DA','2021','2021年',2021,'0008')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('6CB345EC-6EC3-4D17-B4EE-C9E4102384E2','2022','2022年',2022,'0008')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('3D77FEB7-C350-4089-928B-3469C89CE547','2023','2023年',2023,'0008')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('4669EBF8-5972-4AF4-9F09-A7D6DB2C97A5','2024','2024年',2024,'0008')
GO
/****月份****/
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('E697CE9C-2289-47DA-AF97-057049E47AB6','1','一月',1,'0009')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('E03462B1-2703-4F86-BA95-C01DB4502138','2','二月',2,'0009')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('04F15D49-5429-481A-8C0A-39D51C5180FB','3','三月',3,'0009')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('D8EDF396-5D5D-45B1-9576-B35D16F52370','4','四月',4,'0009')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('D2CBFB4A-DBA5-4FB1-B6D0-D0FB13023641','5','五月',5,'0009')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('0A7FB9F8-9E82-4ABD-848D-279259946974','6','六月',6,'0009')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('A50FB247-CCF3-48B8-BF8D-0F21B6C415B1','7','七月',7,'0009')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('35F53EA8-682D-4CCA-A4DA-5C1031585164','8','八月',8,'0009')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('30D2F23C-18E3-40C5-8280-44A09D3BDFAC','9','九月',9,'0009')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('11D33104-F761-4B12-B557-130469849D5F','10','十月',10,'0009')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('7A6A21EC-7635-4D01-B3A0-8B42B8B44006','11','十一月',11,'0009')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('6E65A6D5-75AE-4157-81E5-C349CC3B1ECD','12','十二月',12,'0009')
GO
/****半年****/
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('BB0FF7F0-75D3-44EF-9AFE-9707071D7CB7','1','上半年',1,'0010')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('F64492AD-EA56-4EAC-BBD8-D8ED9F8C7369','2','下半年',2,'0010')
GO
/*季度*/
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('19A7BC42-78B6-484B-8908-02202273A7A6','1','第一季度',1,'0011')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('A39205E4-8AE4-4A3B-9A65-B8F27BC6D6CE','2','第二季度',2,'0011')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('782EE135-17B0-44B5-A1F3-6F4A9F18B67D','3','第三季度',3,'0011')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('492A97EC-00F7-4208-8C7E-029353F3B5B8','4','第四季度',4,'0011')
GO
/****事故类型****/
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('D250CC08-9F3B-45D2-AB95-16BCE27D257C','总计','总计',1,'0012')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('E51259BE-CC49-435E-85B2-023CC5F54282','物体打击','物体打击',2,'0012')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('C2D42132-0255-4F7B-A6D5-E3EC7838ED0E','车辆伤害','车辆伤害',3,'0012')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('F8DBADCF-A398-4EDD-9D38-7E6303A62986','机具伤害','机具伤害',4,'0012')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('2273B380-D754-46AB-8026-FAD118008A63','起重伤害','起重伤害',5,'0012')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('A78D769E-7A05-4A28-83C1-A66783CC13F8','触电','触电',6,'0012')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('289A7C7E-01E9-4DCB-8141-3A8BA015B8FA','淹溺','淹溺',7,'0012')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('785BE436-DBA8-4984-8C47-AB0047F4809C','火灾','火灾',8,'0012')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('3CF31D4F-1593-4EFE-949C-343E4199453A','灼伤','灼伤',9,'0012')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('BBBA0610-E54D-4A34-A130-7244770B80E2','高处坠落','高处坠落',10,'0012')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('AF5BA76F-AFAC-4ED7-A650-A65193CA5E2F','坍塌','坍塌',11,'0012')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('2B9A2D72-0125-47A5-8C1E-09BF43EE1E74','冒顶片邦','冒顶片邦',12,'0012')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('A684F545-1B48-4787-A3E6-DE67FEBD2D21','放炮','放炮',13,'0012')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('9E8CAAFD-4F33-4EF6-A6E4-BAFCD85AEE15','物理爆炸','物理爆炸',14,'0012')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('F9F416C0-CEDB-4608-BC96-D164CBF7D7BB','化学爆炸','化学爆炸',15,'0012')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('0B6F24A1-65C4-4572-A629-B90E93063128','中毒、窒息','中毒、窒息',16,'0012')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('8807BF35-0591-4414-A2E9-9BA1801DDE37','其他','其他',17,'0012')
GO
/****角色类别****/
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('BAEC82D6-682C-4969-8EDE-9E7742F541D9','1','一般角色',1,'0013')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('519A687C-4A88-4DDA-BFB0-4EA11ABDF849','2','管理角色',2,'0013')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('BA1A1EC2-BEC1-450D-948E-E9502049A97F','3','领导角色',3,'0013')
GO
-- 资源上传审核状态：未审核，未通过，已通过
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('25DC9192-7B97-45BC-9F8A-9E8BA79EFE67','1','未审核',1,'UploadResources')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('762A484D-31A2-4146-9093-4BBAAD01E129','2','未采用',2,'UploadResources')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('A504D7B0-F830-4A71-AEF1-FAC8A069E522','3','已采用',3,'UploadResources')
GO
/*报表类型*/
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('F89AECC1-1247-4B7B-A5E0-D85F22440727','1','月报',1,'ReportType')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('3DAF4D61-6DFC-40C6-B704-F51EF0458E1B','2','季报',2,'ReportType')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('9DA87838-3CC5-40DF-8315-E0272CF62613','3','半年报',3,'ReportType')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('30751E5D-96BB-4A30-B5E1-89FF65362574','4','快报',4,'ReportType')
GO
--打印报表
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('4C57E704-DB54-479F-B946-010049D0DE0C','1','百万工时安全统计月报',1,'Report')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('C7D60BE0-2C52-49FF-B0E2-F0D8D3B2CA10','2','职工伤亡事故原因分析报',2,'Report')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('B03ACB80-0F6C-4A19-BCD1-BC1FAA601BD0','3','安全生产数据季报',3,'Report')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('B6020919-CB6D-42BF-84D2-538A3B06135F','4','应急演练开展情况季报',4,'Report')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('F077DC71-E050-42D3-B58A-10F0C2757406','5','应急演练工作计划半年报',5,'Report')
GO
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('A9187195-BED4-4C02-8CD5-D3FFD132A401','6','项目现场百万工时安全统计月报',6,'Report')
GO
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('F402D196-891E-45A7-B160-DF9D0EA131F4','7','项目现场职工伤亡事故原因分析',7,'Report')
GO
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('EDCEED08-93DE-483B-89C8-3C33BC2297BE','8','项目现场安全生产数据季报',8,'Report')
GO
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('70A69D64-1CF4-4342-9C32-5F26645C4491','9','项目现场应急演练开展情况季报',9,'Report')
GO
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('2831174B-B9D5-4291-B59F-48FF32DF5861','10','项目现场应急演练工作计划半年报表',10,'Report')
GO
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('1C939B14-75F8-450C-9359-13186A279E43','11','培训记录',11,'Report')
GO
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
Values('782C896E-8CE7-4C15-99B0-EF3E3542C82D','12','环境危险源辨识与评价',12,'Report')
GO
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
Values('7A702DDF-5274-4E32-AF08-F096B72E1A0D','13','环境危险源辨识与评价(重要环境因素)',13,'Report')
GO
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
Values('92FFAFA4-4037-4F52-B8C3-F63E032CE5C0','14','职业健康安全危险源辨识与评价',14,'Report')
GO
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
Values('CDB21652-8053-4AC9-9691-650E04F4A716','15','职业健康安全危险源辨识与评价(重大危险源)',15,'Report')
GO
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
Values('005434A8-2FCA-43B2-925A-D7321C029F8C','16','HSSE日志暨管理数据收集',16,'Report')
GO
INSERT dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES ('8713A053-4039-433C-B8B6-3B5A9283B184','23','分包商上传周报',23,'Report')
GO
/*图表类型*/
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('8F1A3DCA-879E-46AF-92BC-D68CFF4A8CF6','Column','柱形图',1,'ChartType')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('4CCBC24C-7931-4BC5-9AE5-DB8286257386','Line','折线图',2,'ChartType')
GO
--INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
--VALUES('03BBB623-EF4B-464A-BACE-EA451AC8CC07','Pie','饼形图',3,'ChartType')
--GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('7CDF872A-6819-44EA-8070-9F7C604A9FDD','StackedArea','堆积面积图',4,'ChartType')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('A746604F-2533-46B8-872C-66EDF352A614','StackedArea100','百分比堆积面积图',5,'ChartType')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('1E30C420-E84B-4222-A7FA-F6765AE3C73F','StepLine','阶梯线图',6,'ChartType')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('B4E4D6E2-E257-480E-93ED-8F46FCBFF811','Stock','股价图',7,'ChartType')
GO
/*资源上报状态*/
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('ED557D0A-9B48-4767-AAC9-3A7A4AF9848C','1','本单位',1,'UpState')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('B0AC388C-2999-4F6F-8CCA-E9FBC6F39441','2','待上报',2,'UpState')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('289F0414-41A8-4708-A239-F76A6BA86957','3','已上报',3,'UpState')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('7384A538-5F3C-4D10-89FE-F28505FEAE50','4','上报失败',4,'UpState')
GO
/*监督检查评价类型*/
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('D607C894-0032-4D1B-B28D-A441F1534195','1','综合评价',1,'CheckRectType')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('10A79A34-774D-4EC8-B56B-66716FD5386C','2','单项评价',2,'CheckRectType')
GO
--检查菜单
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId) VALUES('1','1','HSSE实施计划及管理规定',1,'sysMenu')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId) VALUES('2','2','HSSE培训与现场人员管理',2,'sysMenu')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId) VALUES('3','3','HSSE资质审核',3,'sysMenu')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId) VALUES('4','4','安全作业许可证管理',4,'sysMenu')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId) VALUES('5','5','HSSE危险源辨识与评价',5,'sysMenu')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId) VALUES('6','6','施工方案/HSSE方案审查',6,'sysMenu')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId) VALUES('7','7','HSSE检查管理',7,'sysMenu')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId) VALUES('8','8','HSSE会议管理',8,'sysMenu')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId) VALUES('9','9','HSSE费用及物资管理',9,'sysMenu')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId) VALUES('10','10','HSSE行政管理',10,'sysMenu')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId) VALUES('11','11','HSSE应急响应管理',11,'sysMenu')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId) VALUES('12','12','HSSE信息管理',12,'sysMenu')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId) VALUES('13','13','HSSE事故处理及预防',13,'sysMenu')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId) VALUES('14','14','HSSE管理工作报告',14,'sysMenu')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId) VALUES('15','15','HSSE绩效评价管理',15,'sysMenu')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId) VALUES('16','16','HSSE法律法规辨识',16,'sysMenu')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId) VALUES('17','17','定稿文件管理',17,'sysMenu')
GO
--菜单类型
/*本部*/
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('E2FB2C1D-E024-493F-B9E6-2088AC3E6CCC','Menu_SysSet','系统设置',1,'MenuType_S')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('AEC481C4-EED9-4401-B62E-D6EE33B26F5C','Menu_Project','项目清单',2,'MenuType_S')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('6729DE71-E4C1-44D2-8273-BA55634A01D3','Menu_DigData','大数据中心',3,'MenuType_S')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('4084B058-E380-4F8F-810D-9795FE58CC45','Menu_Server','总部检查',4,'MenuType_S')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('5F0ECF4B-6784-4AE9-A26E-CBD0DE9F6AF6','Menu_Notice','通知管理',5,'MenuType_S')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('31D3317B-95EE-442C-9639-FB2BEC41D060','Menu_Person','员工管理',6,'MenuType_S')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('9467A0BA-53D6-4183-9995-AEC63C9E1B26','Menu_ZHGL','综合管理',7,'MenuType_S')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('F194DD4F-A365-458F-AE6C-10E8CE900323','Menu_Party','视频监控',8,'MenuType_S')
GO
--INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
--VALUES('3D0920E1-8A98-4930-BA97-98FDF2FD1A6E','Menu_Party','党建群团',9,'MenuType_S')
--GO
/*项目*/
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('D097252D-B42A-4CAE-9030-A5C351057ABD','Menu_ProjectSet','项目设置',1,'MenuType_P')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('CF2CA03F-84B3-432E-AEAC-4ECF7890D6D7','Menu_PZHGL','施工管理',2,'MenuType_P')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('E116D85E-6215-4299-9EEA-FBC46B0E6163','Menu_CQMS','质量管理',3,'MenuType_P')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('B4F6F0B8-C7AD-421A-9BE3-DCC70EB39A8C','Menu_JDGL','进度/计划',4,'MenuType_P')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('35282E20-81AB-4DA2-80F2-8F136776642D','Menu_HSSE','HSE管理',5,'MenuType_P')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('CE689095-841F-4714-A2B4-BF72D13E2B94','Menu_HJGL','焊接管理',6,'MenuType_P')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('7AD04F82-91B3-4579-993C-8C8FAC503864','Menu_TestRun','试车管理',7,'MenuType_P')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('126FB0AC-521C-4145-86FC-B507D83B7646','Menu_Change','变更管理',8,'MenuType_P')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('C0457DFF-AAA3-4019-AC9B-34BF22BF3A0E','Menu_DocControl','文控管理',9,'MenuType_P')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('0B13D4A9-E047-4C18-AD68-8D3724D4F0A8','Menu_Attendance','现场考勤',10,'MenuType_P')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('85CF0BBF-A3F3-42DF-89DC-CE9A4886BCA1','Menu_Video','视频监控',11,'MenuType_P')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('4F835AC7-9FD8-443D-A5A6-F557AA5A2221','Menu_Transfer','移交管理',12,'MenuType_P')
GO
--项目类型
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('07C853E4-BF3A-437E-90A1-44A45211E5E4','1','EPC',1,'ProjectType')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('3753DAE7-C2CF-4C31-B970-4FB5B88C9DA4','2','EPCM',2,'ProjectType')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('05C4234A-86EA-49D0-B868-BF7218746331','3','PMC',3,'ProjectType')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('C361419D-EE17-4480-AB21-DF1438BF4D14','4','其他',4,'ProjectType')
GO
--项目单位类型
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('D95611A1-731C-4C28-B914-856DB6300692','1','总包',1,'ProjectUnitType')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('12729AD0-9CDB-41D8-B088-12D23DB7608C','2','施工分包',2,'ProjectUnitType')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('06BD8FC6-C044-42E3-BACB-A276E1A6F062','3','监理',3,'ProjectUnitType')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('6E93D814-74CF-4447-A537-A1762B6E8401','4','业主',4,'ProjectUnitType')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('ACB6DD56-D788-4BBA-AA7E-9E3CB7573918','5','其他',5,'ProjectUnitType')
GO
--标牌类型
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('F0A37E9B-779C-4F59-A639-C3010960CE4B','1','组织机构',1,'SignType')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('6C4A41DF-A330-4FB1-AB52-12FC93531204','2','操作规程',2,'SignType')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('C294C6C3-3F5F-406B-974E-A60A328090D6','3','标识标牌',3,'SignType')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('7D95A06F-F6ED-4AAA-AC89-1D21037FF9E2','4','防护规范图集',4,'SignType')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('4D54AD76-05D9-4014-A509-0AA37156D598','5','文明施工形象',5,'SignType')
GO
--常量表:天气数据
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('96D3669D-9496-4BAB-9EC3-B2A835AD6285','1','晴',1,'Weather')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('985A299C-E63F-46B9-A533-A5CFACBFF430','2','多云',2,'Weather')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('61174112-CA6B-46C6-8751-C6E31DB1C1F0','3','阴',3,'Weather')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('C3A2DDFE-CFC3-4ECE-B2FD-6688965DE684','4','阵雨',4,'Weather')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('E4EF7E95-1CA7-4462-8762-1177E5B617A3','5','雷阵雨',5,'Weather')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('79739C15-08CC-4F94-A486-AF3E88BB6981','6','雨夹雪',6,'Weather')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('454AAE20-A665-47AA-A7B1-40A405874753','7','小雨',7,'Weather')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('91EFD90C-6380-4DFA-B4EE-7AF4CAA79669','8','中雨',8,'Weather')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('9F9736ED-B8C0-455E-85DE-138522416C52','9','大雨',9,'Weather')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('B0639D12-530D-42C0-827D-D90A70561A00','10','暴雨',10,'Weather')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('A71E625C-1A48-40C2-B012-9C3CDA705244','11','阵雪',11,'Weather')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('B2E53A18-462C-4081-AE25-7E578C96B11B','12','小雪',12,'Weather')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('F72F69AE-2955-4A36-88AD-0DEC30510F31','13','中雪',13,'Weather')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('22A603C1-2E8B-4948-8200-7429A3C285D8','14','大雪',14,'Weather')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('8A6BD09C-5ED7-4BEF-A16E-A0103FAC06FD','15','暴雪',15,'Weather')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('14EE260C-7055-4779-98FB-A05315B8E3DD','16','雾',16,'Weather')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('552AD25B-9029-46E3-9D27-32262F9DBF75','17','沙尘暴',17,'Weather')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('D62673F3-C602-441E-A340-4731811C9019','18','浮尘',18,'Weather')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('BFA7547B-3732-4BBD-A972-A6FF8322E57E','19','扬沙',19,'Weather')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('46797BDA-AF10-46F1-91D5-7B91B21BD951','20','霾',20,'Weather')
GO
--常量表:处理措施
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('3DB4A7BE-A9AC-47E9-9C63-E3804F6782A9','1','当场纠正',1,'HandleStep')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('A875A010-92E6-49DD-9825-20B50101FA5D','2','口头警告',2,'HandleStep')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('ACAC4FB5-4466-4089-A059-71A7A5572288','3','隐患整改通知单',3,'HandleStep')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('4957AD1E-9BE5-4A7F-8E16-3B7D02BFB895','4','HSSE处罚通知单',4,'HandleStep')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('A661BAF8-6F61-4DB7-B152-FC3339F11E6D','5','限时整改',5,'HandleStep')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('70E31BBD-C01B-4D7F-8F0E-D1E56B84B091','6','其他',6,'HandleStep')
GO
--常量表:危险源对应工作阶段
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('B840CF8F-ED62-4F2D-9140-0E552015A9D6','1','地基处理、打桩',1,'WorkStage')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('145E6655-B0F5-48D9-AFA0-7BF5D13ECE85','2','基础、钢筋混凝土结构',2,'WorkStage')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('C3BFD8C6-E951-4549-8FE5-AF06AD933688','3','建筑工程',3,'WorkStage')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('415F4593-53E1-4610-9964-7D9129D87425','4','地下管道',4,'WorkStage')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('4950110D-6ACE-4144-BFE4-3988FC1E1D1C','5','钢结构',5,'WorkStage')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('8105CFF5-5986-4361-B700-406C2536D9DA','6','设备、机械、管道安装',6,'WorkStage')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('9D927E44-CB2B-48EE-B07F-8EEC8A8F58C8','7','电气仪表安装',7,'WorkStage')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('E9305293-B2BB-4E03-87EF-0B8485AA50A7','8','防腐保温防火',8,'WorkStage')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('C5737F60-9B4D-41AE-964F-8566FBF85B09','9','吹扫、试车',9,'WorkStage')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('6D93F7B7-CE7C-4DFE-86E0-FFC7ADACA20E','10','检修作业',10,'WorkStage')
GO
--常量表:环境危险源类型
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('E8784339-4589-44BC-A7B1-56B6841A978C','01','噪声类',1,'EnvironmentalType')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('0E868857-C504-4695-88F1-9A3E26E2CEE5','02','扬尘类',2,'EnvironmentalType')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('BBE8A43F-7338-47F4-8E94-5C87FBC66DCA','03','污水排放类',3,'EnvironmentalType')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('26D4409C-D81B-4EA1-B91E-8E0FD2782CE6','04','资源能源类',4,'EnvironmentalType')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('17ED987F-2236-410B-8C80-45AACE417AB1','05','固废物类',5,'EnvironmentalType')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('0C5A1360-FBA9-4972-9382-41087BF7E117','06','遗洒类',6,'EnvironmentalType')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('EC40FEC8-96BA-4BC9-8EA7-69140CD289A2','07','泄漏类',7,'EnvironmentalType')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('1226FA6E-2D8E-4545-8E79-139872B88BDA','08','光污染类',8,'EnvironmentalType')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('D08B8589-95D5-4C12-8112-EEFF99897FFA','09','有毒有害气体',9,'EnvironmentalType')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('618BBBF5-9388-44F4-9B1E-7A30DB14B7D3','10','废气类',10,'EnvironmentalType')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('BDF50C6B-E16B-48B3-96BC-C615FCAC62E3','11','异味类',11,'EnvironmentalType')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('4AEF82F9-C227-4205-8484-8F940B4C75D6','12','突发事件',12,'EnvironmentalType')
GO
--常量表:环境危险源小类型
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('F820F010-FF7E-4DBE-ABDC-80FCC28136D4','1','能源资源类',1,'EnvironmentalSmallType')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('4D15B20D-975B-44FE-B2FB-97F557A38DB8','2','污染类',2,'EnvironmentalSmallType')
GO
--常量表:危险性较大的工程清单类型
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('A39208D9-5CF8-464A-A97E-A3614AC1CC0A','1','基坑支护、降水工程',1,'LargerHazardType')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('7F7FFA9D-DB53-4791-9F4A-801AD974866C','2','土方开挖工程',2,'LargerHazardType')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('C9317182-DB5A-4217-AFF3-B87775DEB81A','3','模板工程及支撑体系',3,'LargerHazardType')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('6253E62B-BD9E-4863-A892-0465BBCBE57B','4','起重吊装及安装拆卸工程',4,'LargerHazardType')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('334139FF-749A-4E0C-9FD9-F35FB88E54A8','5','脚手架工程',5,'LargerHazardType')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('308C7203-A289-4B44-9940-C603559DF024','6','拆除、爆破工程',6,'LargerHazardType')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('6CA96A4C-3FB8-46CC-BAA6-6C45E3FF659C','7','其它',7,'LargerHazardType')
GO
---事故伤害类型
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('53591CA9-1B8E-4031-AC56-D156DC907170','1','死亡',1,'Accident')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('1A185805-22AA-4FB0-A2F2-F5A553CF9919','2','重伤',2,'Accident')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('C619C405-374D-4BEB-B5E8-F14107B79120','3','轻伤',3,'Accident')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('F17300B0-4465-40EB-8672-8929F4249A25','1','施工单位调查报告',1,'AccidentReport')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('11275CA4-C215-4446-997F-07F0B7C139C0','2','总包方调查报告',2,'AccidentReport')
GO
INSERT INTO Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES ('3FA9824D-9382-4139-AF5C-0EE91A1F39CA','1','奖励',1,'RewardOrPunish')
GO
INSERT INTO Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES ('D13B379C-DCE9-403E-89B8-EBEEDD551052','3','处罚',2,'RewardOrPunish')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('4725617A-C91B-43D7-80C2-C4441A233BF6','1','PPE违章',1,'ViolationName')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('70A3FB1F-DB72-499E-92DF-2F10A7C0F4DB','2','其它违章',2,'ViolationName')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('EE7C7078-3675-4358-9721-912CC7BD69DE','1','安全带',1,'ViolationType')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('5FB257CB-B797-4712-A99F-2D8C1A7C604A','2','工作服',2,'ViolationType')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('514C4CD0-51DF-4DCA-8544-F4A65572CB9B','3','劳保鞋',3,'ViolationType')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('DD8AD9C3-4662-4F0E-AD43-32D7DA5CCEB2','4','安全帽',4,'ViolationType')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('CE193F13-B66E-4E59-AABB-2485635312FF','5','护目镜',5,'ViolationType')
GO
--常量表:岗位类型
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('0B705F90-BB2B-4C22-A336-90C0B677A95A','1','一般管理岗位',1,'PostType')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('89164C32-F817-4082-B646-F950769C91C4','2','特种作业人员',2,'PostType')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('67B9987E-38B2-42C3-B0A7-678426DD0E93','3','一般作业岗位',3,'PostType')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('6CDB171F-59C9-4B60-92FE-2AFFDF115D6D','4','特种管理人员',4,'PostType')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('808E3E1D-37CB-4E9B-A7A8-55D6B5CF44C7','5','特种设备作业人员',5,'PostType')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('919A66A8-31F1-4A0E-BC6A-43D3C298748F','1','地基处理',1,'CNProfessional')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('20E8B2C4-4558-4D43-BAF9-8491FD084E31','2','打桩',2,'CNProfessional')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('8BF8B210-0A4D-42DB-99D1-AB048096101D','3','基坑支护与降水工程',3,'CNProfessional')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('F522C5C5-5CF3-496D-8525-D9EB47824359','4','土方开挖工程',4,'CNProfessional')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('71DA9BF5-8361-4779-A4CB-5FF0D6953FCD','5','模板工程',5,'CNProfessional')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('19423BF8-5DD8-4D1E-8B00-E7609C7294D3','6','基础施工',6,'CNProfessional')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('65084AC5-4DF1-4C00-8B52-A3D3BA86A805','7','钢筋混凝土结构',7,'CNProfessional')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('D299251C-DF2C-470F-A312-6ED86E6640CC','8','地下管道',8,'CNProfessional')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('9B045E0B-8F43-4EC6-A4A6-042301921D16','9','钢结构',9,'CNProfessional')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('FD7178A6-87DE-44E1-950A-FEAFB7876C10','10','设备安装',10,'CNProfessional')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('06CDB55E-D01C-455E-8BE0-2008791D2631','11','大型起重吊装工程',11,'CNProfessional')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('4C61E43B-2FEC-4DE9-A465-359D4CE1C0E3','12','脚手架工程',12,'CNProfessional')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('A1C5C018-AB81-4A90-9E4D-0732F0369529','13','机械安装',13,'CNProfessional')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('63FE38FA-4B28-444E-9AB6-0E0079655CE5','14','管道安装',14,'CNProfessional')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('D8360FBA-C1A6-4D6B-8FF4-A52309AAB646','15','电气仪表安装',15,'CNProfessional')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('AB8ACCB5-414D-4D2F-901D-155BB677B849','16','防腐保温防火',16,'CNProfessional')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('D8B14844-9FD6-422B-B61F-45185C105E03','17','拆除',17,'CNProfessional')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('84E6BF94-5EBA-4B4B-B733-16D57AF6D4EF','18','爆破工程',18,'CNProfessional')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('577500B4-FACE-45C0-9BFA-6B63A4B72FB3','19','试压',19,'CNProfessional')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('4A561C7F-932F-44B7-9B84-A7F2595B5C9C','20','吹扫',20,'CNProfessional')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('D135FDFA-7AAA-448A-9A92-7FA8CDF32431','21','试车',21,'CNProfessional')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('156689CE-E4C7-4563-BC84-4C1841C8752C','22','试车方案',22,'CNProfessional')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('4ACE9E4C-8529-4DE5-A9B3-5F47543E8D95','23','无损检测',23,'CNProfessional')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('27CFC82A-A0B8-4BA8-8E52-01554E903A56','90','全部标准',24,'CNProfessional')
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('3C03AC5D-3AE8-46AC-A946-72A1C9583431','91','其它',91,'CNProfessional')
GO
GO
--施工方案类型
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('E4A1B5BE-EFF4-42AC-A59C-CE1B2010F788','1','施工方案审查',1,'InvestigateType')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('4F8BB7DD-E94F-405D-B050-CB0B5CB74DE8','2','HSSE方案审查',2,'InvestigateType')
GO
--常量表:企业安全管理资料考核类型
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('48A8C791-50EB-449A-B350-0FF77F4D8D44','1','月报',1,'SafetyDataCheckType')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('C0451870-70F6-4823-A1B3-9B49CA42B91B','2','季报',2,'SafetyDataCheckType')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('69B934E2-A377-4509-BE3D-C344FDA13E4C','3','定时报',3,'SafetyDataCheckType')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('5C08FF81-AD70-4391-A42B-01688BD3AD15','4','开工后报',4,'SafetyDataCheckType')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('01E3D64E-A302-429F-B22B-ADF5B650A73B','5','半年报',5,'SafetyDataCheckType')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('3C8DEDE0-E6C5-41C0-9113-9FD2DEEC3FC2','6','其他',6,'SafetyDataCheckType')
GO
--常量表其他检查类型
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('B15975E8-867B-42C8-8D99-570E9D3DA6E9','6','无证上岗',1,'ViolationTypeOther')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('7E82B247-B419-47E4-AD19-205DB2BD7C5B','7','车辆违章',2,'ViolationTypeOther')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('407E76ED-E334-41FC-86EC-BB0E8EB5CE39','8','用电',3,'ViolationTypeOther')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('49245CD9-EBB4-497C-A083-62B83BA5A1E8','9','动土',4,'ViolationTypeOther')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('779B1C38-198E-421F-B93E-306E82168BEC','10','动火',5,'ViolationTypeOther')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('894BFF6F-4EBB-4E63-87DB-CF324FC38AF1','11','脚手架',6,'ViolationTypeOther')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('BBB85FF5-873A-455D-A077-860EA0A3329F','12','高处作业',7,'ViolationTypeOther')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('EE89D46A-A513-43BD-9024-6C30BC0BE8BD','13','吊装',8,'ViolationTypeOther')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('A296D1E0-0F95-4601-8636-F5D48ADD6A3B','14','射线',9,'ViolationTypeOther')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('6EA4E1F2-392C-4D8B-AEC7-E8AB1E18900B','15','受限空间',10,'ViolationTypeOther')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('7A963C66-C3A8-4517-AD87-56BD90DD50C8','16','气瓶',11,'ViolationTypeOther')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('4D8CADD9-F976-414D-87EB-6B17454DDF52','17','危险物品',12,'ViolationTypeOther')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('10A08BDF-88BF-481C-AA93-548E8081B34F','18','特种设备',13,'ViolationTypeOther')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('B90B14C5-5F52-461C-9824-D1CED893BE93','19','环境保护',14,'ViolationTypeOther')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('F2E6994A-E6F0-45B2-9754-D875C1F4F2E6','20','消防安全',15,'ViolationTypeOther')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('60E933E5-9142-4C8A-A3C0-0B6AD04E09D0','21','文明施工',16,'ViolationTypeOther')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('31AB3064-54FC-4881-8518-1DEA628EBD21','22','职业卫生',17,'ViolationTypeOther')
GO
--常量表应急演练类型
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('4B7CB6A5-0223-4C3C-BA6B-9C8CF6E3E358','1','综合演练现场',1,'DrillRecordType')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('DDF67DFE-6CC3-425F-ACAF-C9965BE278A0','2','综合演练桌面',2,'DrillRecordType')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('AE42B48F-CDCB-4536-8798-81C430A0BC5A','3','专项演练现场',3,'DrillRecordType')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('E07F28DD-8072-4B58-8F22-005E89290489','4','专项演练桌面',4,'DrillRecordType')
GO
--五环管理月报内容项
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('DFB42D2F-1CA2-4E21-AABB-BBE1FBE75F5C','MonthReportCEdit1.aspx','1 项目概况',1,'MonthReportCItem')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('2CA1F0E6-37FE-4267-85EB-E07764D5BE80','MonthReportCEdit2.aspx','2 本月项目现场HSE人力投入情况',2,'MonthReportCItem')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('D8141695-CD8C-4724-98A5-C5DD015FA917','MonthReportCEdit3.aspx','3 本月项目现场HSE人工日统计',3,'MonthReportCItem')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('244E173B-43D8-4D37-B4BE-FFBAF6EC18B7','MonthReportCEdit4.aspx','4 本月项目HSE现场管理',4,'MonthReportCItem')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('890B9A0E-DA44-471A-92BD-E7150E4FFC7C','MonthReportCEdit5.aspx','5 本月项目HSE内业管理',5,'MonthReportCItem')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('7EC9E717-5869-4B16-8D38-7CD156C0330A','MonthReportCEdit6.aspx','6 本月项目HSE费用管理',6,'MonthReportCItem')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('80488E9F-5289-4A77-A7E8-0B13FEF14ABA','MonthReportCEdit7.aspx','7 HSE事故/事件描述',7,'MonthReportCItem')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('FC2F863C-248D-424C-998D-9FC00B55C13D','MonthReportCEdit8.aspx','8 其他工作情况',8,'MonthReportCItem')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('C11BB760-8C4D-489F-8FA3-324BD0CBEB38','MonthReportCEdit9.aspx','9 下月工作计划',9,'MonthReportCItem')
GO
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('671D47D7-511A-404C-B864-3179483F3579','MonthReportCEdit10.aspx','10 存在的主要问题及改进措施、 需要项目经理、项目主管、公司相关部门、业主协调解决事宜',10,'MonthReportCItem')
GO
--常量表:东华管理月报内容项
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('FF36D1CA-E87F-430C-9D9F-5ADF5629F656','MonthReportDEdit1.aspx','1 安委会会议纪要',1,'MonthReportDItem')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('967B0FD2-A834-48E0-9CD2-A645B439FEC1','MonthReportDEdit2.aspx','2 安全生产数据在线月报',2,'MonthReportDItem')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('5BEBEE49-0256-477B-A100-57F7C3581679','MonthReportDEdit3.aspx','3 月总结',3,'MonthReportDItem')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('A5EC533A-40B8-4AAE-8064-997553585A28','MonthReportDEdit4.aspx','4 环境与职业健康月报表',4,'MonthReportDItem')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('503A902F-73F8-4467-8976-470BD0EAB8CD','MonthReportDEdit5.aspx','5 安全工程师每日巡查记录表',5,'MonthReportDItem')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('8DC49F74-9F25-4EED-9B07-9AD8A1378FF1','MonthReportDEdit6.aspx','6 违规记录汇总表',6,'MonthReportDItem')
GO
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('69C20627-27C1-4EF1-9F9C-29032F98B17D','MonthReportDEdit7.aspx','7 施工单位月安全考核表',7,'MonthReportDItem')
GO
--常量表:人工时月报是否按平均数取值
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('CF93B8A3-16EB-4872-9859-C10ECE287E11','1','人工时月报是否按平均数取值',1,'IsMonthReportGetAVG')
GO
--管理月报冻结日期
INSERT INTO dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('D1D8A032-2803-496E-B4F2-7A8637F74520','6','管理月报冻结日期',1,'MonthReportFreezeDay')
GO
--是否可自动执行插件
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('71EF5F88-575B-483D-8A6C-96E4A40A3BEA','0','是否自动提取集团数据',1,'Synchronization')
GO
--是否固定流程
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('4DABA60A-00A9-44B0-8EC0-CFF27AC525E1','0','是否固定流程',1,'MenuFlowOperate')
GO
--是否与博晟数据提取
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('9F2FCD13-10E0-4CB2-80E8-CC2CBB91E031','0','是否与博晟数据提取',1,'ChangeData')
GO
--常量表-作业票
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('F10AD877-DD48-4D92-AD66-64210E516C64','2E58D4F1-2FF1-450E-8A00-1CE3BBCF8D4B','动火作业票',1,'LicenseType')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('21F0402D-1A1E-4E03-915D-8914029BE957','DA1CAE8E-B5BF-4AC0-9996-AF6CAA412CA9','高处作业票',2,'LicenseType')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('C96C6527-6078-4E50-8B31-40D731DE8CCA','AEC9166D-1C91-45F0-8BFE-D3D0479A28C7','受限空间作业票',3,'LicenseType')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('D5B893A3-9896-4246-959C-64AB8B168025','F72FF20B-D3EB-46A5-97F7-C99B2473A140','射线作业票',4,'LicenseType')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('41F9D0A5-B3C7-4409-88E3-DA729D2AE1A8','4E607E83-41FC-4F49-B26F-A21CFE38328F','断路（占道）作业票',5,'LicenseType')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('89BC9EA1-19E3-4DC4-84F7-4D87678B5794','755C6AC9-2E38-4D4F-AF33-33CB1744A907','动土作业票',6,'LicenseType')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('AA5C7DDF-88F1-48EB-8C43-6E5903AA6A39','7BBAE649-7B00-4475-A911-BFE3A37AC55B','夜间施工作业票',7,'LicenseType')
INSERT INTO dbo.Sys_Const(ID, ConstValue, ConstText, SortIndex, GroupId)
VALUES('FA801286-038C-43DE-9AA8-7B300DA4FB94','A1BE3AB6-9D4A-41E7-8870-E73423165451','吊装作业票',8,'LicenseType')
GO
--delete from Sys_Const where GroupId='LicenseType'
INSERT [dbo].[Sys_Const] ([ID], [ConstValue], [ConstText], [SortIndex], [GroupId])
VALUES (N'0cb5eb3a-326a-417d-981b-025a4071d0c8', N'3|20', N'员工绩效考核第一季度生成时间', 1, N'PersonQuarterCheck')
GO
INSERT [dbo].[Sys_Const] ([ID], [ConstValue], [ConstText], [SortIndex], [GroupId])
VALUES (N'd6a1011b-bd00-41d6-bda9-12e1b3310001', N'6|20', N'员工绩效考核第二季度生成时间', 2, N'PersonQuarterCheck')
GO
INSERT [dbo].[Sys_Const] ([ID], [ConstValue], [ConstText], [SortIndex], [GroupId])
VALUES (N'7e9653ca-9285-4f04-b243-3df8e4d16892', N'9|20', N'员工绩效考核第三季度生成时间', 3, N'PersonQuarterCheck')
GO
INSERT [dbo].[Sys_Const] ([ID], [ConstValue], [ConstText], [SortIndex], [GroupId])
VALUES (N'cae21271-5fb0-41e5-9994-64bb2a351ce7', N'12|20', N'员工绩效考核第四季度生成时间', 4, N'PersonQuarterCheck')
GO
----安全数据（月报）汇总
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('BCECA3D5-95A6-48A1-AD91-C573CC9634AD',1,'赛鼎公司项目现场员工总数（含外聘）',1,'HSEData','人')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('6C56F114-7C6C-4C4A-B5B0-77B9297D5AB3',2,'赛鼎公司项目现场外聘人员总数',2,'HSEData','人')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('8BBAEE58-ABC5-4CEF-9150-EB88392D22E5',3,'赛鼎公司项目现场外籍人员总数',3,'HSEData','人')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('D98C74B6-2059-4A87-A634-F806A48FAD91',4,'赛鼎公司项目现场专职HSE管理人员总数',4,'HSEData','人')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('CC621066-CDFC-4D86-8644-D6B641749DD2',5,'分包单位项目现场总人数',5,'HSEData','人')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('F5D9C858-5112-42F9-A58C-18FFB14A7E98',6,'分包单位项目现场专职HSE管理人员总数',6,'HSEData','人')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('18542091-DE52-4E16-9F4E-0AE2B93C4B1F',7,'安全人工时',7,'HSEData','人工时')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('D60BFA58-8DD8-47CD-888D-3B1CE56339DB',8,'轻伤',8,'HSEData','人次')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('0BD4B7A3-9E0B-4431-9C4D-9D9FE93CFA2B',8,'重伤',9,'HSEData','人次')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('6307B03A-2C20-4B7C-8520-93F5D16D2A42',8,'死亡',10,'HSEData','人次')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('8D9AC667-092F-40C7-B2D7-5E6EC497643B',8,'中毒及职业伤害事故',11,'HSEData','人次')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('03D86F2C-EE72-4CA3-A81F-E039F7CAF105',9,'未遂事故',12,'HSEData','起')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('90065EC2-5918-453A-AA7F-0214420784D9',10,'火灾事故',13,'HSEData','起')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('2D9EAD34-91C4-41F6-BE59-496A639D7CAB',11,'重大火灾事故',14,'HSEData','起')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('24215767-962F-48F8-8BE7-84316F579DD0',12,'机械设备事故',15,'HSEData','起')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('FE118710-130D-4AF5-B4ED-8959ED4EB8F3',13,'重大机械设备事故',16,'HSEData','起')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('5E79077E-4128-42C1-8D66-8892004B2D2C',14,'重大环境影响事故',17,'HSEData','起')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('9979ED17-B271-43F8-91DE-5BB16CACFF46',15,'其它事故',18,'HSEData','起')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('96A17851-B6DC-4D3A-80B8-9DA2D5F70D4F',16,'特种、大型、特殊施工机具设备',19,'HSEData','台')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('FC65D20A-20ED-4001-A5F4-FDB933E666BB',17,'安全生产费用',20,'HSEData','万元')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('A8860F32-B24C-4545-BF31-6BE91F43C6DD',18,'项目现场员工入场安全培训人数',21,'HSEData','人次')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('3B16B09C-FC08-4B33-A538-05A9A2F7FF40',19,'项目现场安委会次数',22,'HSEData','次')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('E876A5BF-DAC2-448C-8A79-36CB613061A2',20,'项目现场周安全例会次数',23,'HSEData','次')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('D2569738-53DE-4098-9B93-3F1B8C2751F2',21,'项目现场专题安全会议次数',24,'HSEData','次')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('8460BF2D-A8E5-4912-8010-27C334AC1C14',22,'日常巡检',25,'HSEData','次')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('45020D83-D5CD-460B-BDD1-765539E946E0',23,'周联合检查',26,'HSEData','次')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('D1809A97-B77D-4C3A-BECE-8025460E7C1A',24,'专项检查',27,'HSEData','次')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('7D050330-B700-439C-8958-1D71B3C424B3',25,'月综合HSE检查',28,'HSEData','次')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('8870FCFC-3F09-4353-A1A9-25428D4CAB61',26,'隐患整改单（一般）',29,'HSEData','份')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('9E866CCC-B1CF-44A5-AE39-3A54E1A72559',27,'隐患整改单（一般）整改完成数量',30,'HSEData','份')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('C21E72BF-2259-4BA3-938B-B47C019A13DA',28,'隐患整改单（较大）',31,'HSEData','份')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('2F36CDC3-6122-43B6-B993-AEA751FCA1C9',29,'隐患整改单（较大）整改完成数量',32,'HSEData','份')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('60AB202F-9F3E-4EC1-9ECB-BF11B395C1E1',30,'隐患整改单（重大）',33,'HSEData','份')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('3704F4F7-C51E-42B0-A82F-8E7E3DF82ED5',31,'隐患整改单（重大）整改完成数量',34,'HSEData','份')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('7B75ACB0-EB44-4169-A20F-0B36FA0F2640',32,'停工令',35,'HSEData','份')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('0177393D-B9F6-4F08-AB32-6426DA596873',33,'奖励',36,'HSEData','万元')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('1D42E164-DC55-475E-8D00-6473C0C91FAA',34,'处罚',37,'HSEData','万元')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('88CDA85C-DA39-4D8E-9C88-94D48431F587',35,'本月正在施工危险性较大分部分项工程数',38,'HSEData','个')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('A3862FA0-265B-4B61-89BC-30C819F5E348',36,'本月正在施工的超过一定规模的危险性较大分部分项工程数',39,'HSEData','个')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('19C14DB9-9AD0-4FF7-897C-6D21042436FE',37,'应急演练',40,'HSEData','次')
GO
--施工标准规范类别
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VAlUES('0E27C28B-BEAC-416F-8991-5E14E829EDD9','综合','综合',1,'StandardType')
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VAlUES('275A6AA5-2490-46C7-A1A0-AFDB820A5891','土建','土建',2,'StandardType')
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VAlUES('08B1664A-614F-4EC4-88C6-260AE04B26FE','设备','设备',3,'StandardType')
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VAlUES('B4808887-EF60-4B9F-915A-ACBB88034CA7','现场制作常压容器','现场制作常压容器',4,'StandardType')
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VAlUES('BFE99743-00D3-4902-B5D8-3DA90E4D56CD','工业管道及给排水管道','工业管道及给排水管道',5,'StandardType')
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VAlUES('3FF0562F-B0BD-458E-A5C6-CD37FBF68FB4','焊接及检验','焊接及检验',6,'StandardType')
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VAlUES('574BFB5F-B479-4671-B790-45AE284B3402','防腐绝热','防腐绝热',7,'StandardType')
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VAlUES('472F52A4-A994-46BF-892C-29C9E4E33C69','电气','电气',8,'StandardType')
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VAlUES('F5BA37FF-0E85-4DA4-A059-0A76D1DD0854','电信','电信',9,'StandardType')
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VAlUES('BB901677-F91B-4A62-A94E-CD4831047067','仪表','仪表',10,'StandardType')
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VAlUES('6902A276-11B9-4A4C-B996-2E219D32400A','HSE','HSE',11,'StandardType')
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VAlUES('25CAAEEC-915A-400E-ACB6-0AB8D8076B8D','开车','开车',12,'StandardType')
GO
--施工标准规范状态
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VAlUES('42DEF4A7-43CE-472A-843C-CDB4E6C18305','现行','现行',1,'StandardStatus')
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VAlUES('2E2E6F22-D3F7-40DA-AC02-0CA1C1B48A5D','作废','作废',2,'StandardStatus')
GO
--施工标准规范使用级别
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VAlUES('ED4EFE55-95BD-4CBB-80DE-0B92579023BA','A','A',1,'StandardLevel')
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VAlUES('368F75FF-0BDA-4F32-A90F-D690C4EDB81B','B','B',2,'StandardLevel')
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VAlUES('B7BEE5B9-8D87-4587-B5F3-1059C566DF1C','C','C',3,'StandardLevel')
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
VAlUES('DB220842-8E8A-4AA8-8FC4-D0F51446E5E9','D','D',4,'StandardLevel')
GO
--菜单类型
/*本部*/
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('E2FB2C1D-E024-493F-B9E6-2088AC3E6CCC','Menu_SysSet','系统设置',1,'MenuType_S')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('AEC481C4-EED9-4401-B62E-D6EE33B26F5C','Menu_Notice','通知管理',2,'MenuType_S')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('6729DE71-E4C1-44D2-8273-BA55634A01D3','Menu_Person','员工管理',3,'MenuType_S')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('4084B058-E380-4F8F-810D-9795FE58CC45','Menu_Project','项目清单',4,'MenuType_S')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('5F0ECF4B-6784-4AE9-A26E-CBD0DE9F6AF6','Menu_Server','本部检查',5,'MenuType_S')
GO
--INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
--VALUES('31D3317B-95EE-442C-9639-FB2BEC41D060','Menu_HTGL','合同管理',6,'MenuType_S')
--GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('9467A0BA-53D6-4183-9995-AEC63C9E1B26','Menu_DigData','大数据中心',7,'MenuType_S')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('F194DD4F-A365-458F-AE6C-10E8CE900323','Menu_ZHGL','综合管理',8,'MenuType_S')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('3D0920E1-8A98-4930-BA97-98FDF2FD1A6E','Menu_Party','党建群团',9,'MenuType_S')
GO
/*项目*/
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('D097252D-B42A-4CAE-9030-A5C351057ABD','Menu_ProjectSet','项目设置',1,'MenuType_P')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('E116D85E-6215-4299-9EEA-FBC46B0E6163','Menu_CQMS','质量管理',2,'MenuType_P')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('35282E20-81AB-4DA2-80F2-8F136776642D','Menu_HSSE','安全管理',3,'MenuType_P')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('B4F6F0B8-C7AD-421A-9BE3-DCC70EB39A8C','Menu_JDGL','进度管理',4,'MenuType_P')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('CE689095-841F-4714-A2B4-BF72D13E2B94','Menu_HJGL','焊接管理',5,'MenuType_P')
GO
--INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
--VALUES('7AD04F82-91B3-4579-993C-8C8FAC503864','Menu_PHTGL','合同管理',6,'MenuType_P')
--GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('CF2CA03F-84B3-432E-AEAC-4ECF7890D6D7','Menu_TestRun','试车管理',7,'MenuType_P')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('85CF0BBF-A3F3-42DF-89DC-CE9A4886BCA1','Menu_PZHGL','综合管理',8,'MenuType_P')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('0B13D4A9-E047-4C18-AD68-8D3724D4F0A8','Menu_DigitalSite','数字工地',9,'MenuType_P')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
VALUES('69B856E6-E385-4771-9341-23E7416C46F1','Menu_PDigData','大数据中心',9,'MenuType_P')
GO
----安全数据（月报）汇总
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('BCECA3D5-95A6-48A1-AD91-C573CC9634AD',1,'赛鼎公司项目现场员工总数（含外聘）',1,'HSEData','人')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('6C56F114-7C6C-4C4A-B5B0-77B9297D5AB3',2,'赛鼎公司项目现场外聘人员总数',2,'HSEData','人')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('8BBAEE58-ABC5-4CEF-9150-EB88392D22E5',3,'赛鼎公司项目现场外籍人员总数',3,'HSEData','人')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('D98C74B6-2059-4A87-A634-F806A48FAD91',4,'赛鼎公司项目现场专职HSE管理人员总数',4,'HSEData','人')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('CC621066-CDFC-4D86-8644-D6B641749DD2',5,'分包单位项目现场总人数',5,'HSEData','人')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('F5D9C858-5112-42F9-A58C-18FFB14A7E98',6,'分包单位项目现场专职HSE管理人员总数',6,'HSEData','人')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('18542091-DE52-4E16-9F4E-0AE2B93C4B1F',7,'安全人工时',7,'HSEData','人工时')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('D60BFA58-8DD8-47CD-888D-3B1CE56339DB',8,'轻伤',8,'HSEData','人次')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('0BD4B7A3-9E0B-4431-9C4D-9D9FE93CFA2B',8,'重伤',9,'HSEData','人次')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('6307B03A-2C20-4B7C-8520-93F5D16D2A42',8,'死亡',10,'HSEData','人次')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('8D9AC667-092F-40C7-B2D7-5E6EC497643B',8,'中毒及职业伤害事故',11,'HSEData','人次')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('03D86F2C-EE72-4CA3-A81F-E039F7CAF105',9,'未遂事故',12,'HSEData','起')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('90065EC2-5918-453A-AA7F-0214420784D9',10,'火灾事故',13,'HSEData','起')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('2D9EAD34-91C4-41F6-BE59-496A639D7CAB',11,'重大火灾事故',14,'HSEData','起')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('24215767-962F-48F8-8BE7-84316F579DD0',12,'机械设备事故',15,'HSEData','起')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('FE118710-130D-4AF5-B4ED-8959ED4EB8F3',13,'重大机械设备事故',16,'HSEData','起')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('5E79077E-4128-42C1-8D66-8892004B2D2C',14,'重大环境影响事故',17,'HSEData','起')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('9979ED17-B271-43F8-91DE-5BB16CACFF46',15,'其它事故',18,'HSEData','起')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('96A17851-B6DC-4D3A-80B8-9DA2D5F70D4F',16,'特种、大型、特殊施工机具设备',19,'HSEData','台')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('FC65D20A-20ED-4001-A5F4-FDB933E666BB',17,'安全生产费用',20,'HSEData','万元')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('A8860F32-B24C-4545-BF31-6BE91F43C6DD',18,'项目现场员工入场安全培训人数',21,'HSEData','人次')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('3B16B09C-FC08-4B33-A538-05A9A2F7FF40',19,'项目现场安委会次数',22,'HSEData','次')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('E876A5BF-DAC2-448C-8A79-36CB613061A2',20,'项目现场周安全例会次数',23,'HSEData','次')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('D2569738-53DE-4098-9B93-3F1B8C2751F2',21,'项目现场专题安全会议次数',24,'HSEData','次')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('8460BF2D-A8E5-4912-8010-27C334AC1C14',22,'日常巡检',25,'HSEData','次')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('45020D83-D5CD-460B-BDD1-765539E946E0',23,'周联合检查',26,'HSEData','次')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('D1809A97-B77D-4C3A-BECE-8025460E7C1A',24,'专项检查',27,'HSEData','次')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('7D050330-B700-439C-8958-1D71B3C424B3',25,'月综合HSE检查',28,'HSEData','次')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('8870FCFC-3F09-4353-A1A9-25428D4CAB61',26,'隐患整改单（一般）',29,'HSEData','份')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('9E866CCC-B1CF-44A5-AE39-3A54E1A72559',27,'隐患整改单（一般）整改完成数量',30,'HSEData','份')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('C21E72BF-2259-4BA3-938B-B47C019A13DA',28,'隐患整改单（较大）',31,'HSEData','份')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('2F36CDC3-6122-43B6-B993-AEA751FCA1C9',29,'隐患整改单（较大）整改完成数量',32,'HSEData','份')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('60AB202F-9F3E-4EC1-9ECB-BF11B395C1E1',30,'隐患整改单（重大）',33,'HSEData','份')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('3704F4F7-C51E-42B0-A82F-8E7E3DF82ED5',31,'隐患整改单（重大）整改完成数量',34,'HSEData','份')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('7B75ACB0-EB44-4169-A20F-0B36FA0F2640',32,'停工令',35,'HSEData','份')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('0177393D-B9F6-4F08-AB32-6426DA596873',33,'奖励',36,'HSEData','万元')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('1D42E164-DC55-475E-8D00-6473C0C91FAA',34,'处罚',37,'HSEData','万元')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('88CDA85C-DA39-4D8E-9C88-94D48431F587',35,'本月正在施工危险性较大分部分项工程数',38,'HSEData','个')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('A3862FA0-265B-4B61-89BC-30C819F5E348',36,'本月正在施工的超过一定规模的危险性较大分部分项工程数',39,'HSEData','个')
GO
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId,Remark)
VALUES('19C14DB9-9AD0-4FF7-897C-6D21042436FE',37,'应急演练',40,'HSEData','次')
GO
Reference in New Issue View Git Blame Copy Permalink