245 lines
26 KiB
Transact-SQL
245 lines
26 KiB
Transact-SQL
INSERT INTO dbo.Sys_User(UserId,Account,Password,UserName,IsPost)
|
|
VALUES ('AF17168B-87BD-466E-1111-F0A0A1158F9B','gly','EDE6B81F7043D328B1F1661FA011BCAB','管理员',1)
|
|
GO
|
|
|
|
/***********系统设置**********/
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('9CFD72D1-F57A-462F-A870-597C54A9B473','系统设置','System setup','',10,'0')
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('B93AAD69-009D-405B-9569-92E1675B8213','角色管理','Role management','SysManage/RoleList.aspx',10,'9CFD72D1-F57A-462F-A870-597C54A9B473')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('D2708D39-F502-4B89-9D8A-DC97BA0F1966','B93AAD69-009D-405B-9569-92E1675B8213','增加','Add',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('1BB0F442-3E3F-4B66-94AD-C7ACFF44EEF4','B93AAD69-009D-405B-9569-92E1675B8213','修改','Modify',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('FDB8C0E7-26D5-48E1-A42B-3E8529C7E6C9','B93AAD69-009D-405B-9569-92E1675B8213','删除','Delete',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('F483EB23-473B-4916-82AF-C8C7955640D6','B93AAD69-009D-405B-9569-92E1675B8213','保存','Save',4)
|
|
GO
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('07E9AAA4-8577-4821-B0C1-0756935A004E','用户','User','SysManage/UserList.aspx',20,'9CFD72D1-F57A-462F-A870-597C54A9B473')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('015705A3-491E-44F6-A169-5AECF1AAE48A','07E9AAA4-8577-4821-B0C1-0756935A004E','增加','Add',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('88B12BD2-77F0-4CA7-9783-61EDBD8EBCD1','07E9AAA4-8577-4821-B0C1-0756935A004E','修改','Modify',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('0529DC3C-0252-4F84-B4AA-4546CF37355A','07E9AAA4-8577-4821-B0C1-0756935A004E','删除','Delete',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('62711BD5-0A6C-4C48-9F79-326A2DCECF52','07E9AAA4-8577-4821-B0C1-0756935A004E','保存','Save',4)
|
|
GO
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('2156BDB2-3D48-4B95-BC45-9E5B2619B8F5','修改密码','Modify password','SysManage/UpdatePassword.aspx',30,'9CFD72D1-F57A-462F-A870-597C54A9B473')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('1465574E-0817-4263-A687-C3C975A38E58','2156BDB2-3D48-4B95-BC45-9E5B2619B8F5','修改密码','Change Password',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('DCE2D4AA-99EB-4492-B03E-C7F843C87396','2156BDB2-3D48-4B95-BC45-9E5B2619B8F5','重置密码','Reset Password',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('D7F53462-7A28-47F5-BE6E-2DEF3BC72DE4','2156BDB2-3D48-4B95-BC45-9E5B2619B8F5','保存','Save',3)
|
|
GO
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('D2C1FC96-CF5C-4D12-9DF2-101F9478EBCE','角色授权','Role authorization','SysManage/RolePower.aspx',40,'9CFD72D1-F57A-462F-A870-597C54A9B473')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('C608B5AF-D597-4DB4-BD45-878935DCBDC9','D2C1FC96-CF5C-4D12-9DF2-101F9478EBCE','保存','Save',1)
|
|
GO
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('D4EC02EB-89C6-43AB-8EE0-FCAE1728697A','数据备份','Data backup','SysManage/DataBackup.aspx',50,'9CFD72D1-F57A-462F-A870-597C54A9B473')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('A3C261AE-9835-4BC7-9433-AA3FDA1C29A8','D4EC02EB-89C6-43AB-8EE0-FCAE1728697A','数据备份','Data Backup',1)
|
|
GO
|
|
--INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
--VALUES('A5114D5B-868E-4F73-966C-B2085894BE3C','系统设置','System set','SysManage/SysSet.aspx',60,'9CFD72D1-F57A-462F-A870-597C54A9B473')
|
|
--INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('A8798B9A-7701-4532-97B0-CA7AC2707FBD','A5114D5B-868E-4F73-966C-B2085894BE3C','保存','Save',1)
|
|
--GO
|
|
--INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
--VALUES('54B92E67-4E1D-44A9-9231-664CAF7B3E27','设置意见用户','Set up evaluation users','SysManage/UserToEMial.aspx',70,'9CFD72D1-F57A-462F-A870-597C54A9B473')
|
|
--INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('D191CBDE-D7CC-40F4-874D-070075FE668C','54B92E67-4E1D-44A9-9231-664CAF7B3E27','保存','Save',1)
|
|
--GO
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('E317A98D-85B8-4AF0-8C1A-0D39D119401E','日志管理','Log management','SysManage/LogList.aspx',80,'9CFD72D1-F57A-462F-A870-597C54A9B473')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('7D5E67FC-93DC-4F9F-A98F-B15B241FF815','E317A98D-85B8-4AF0-8C1A-0D39D119401E','查看','View',1)
|
|
GO
|
|
/*******基础信息*********/
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('C15CE253-C8E2-4E9A-9082-C758265CB0E7','基础信息','Basic information','',20,'0')
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('13B6A924-A887-49CF-8F9E-46A2BE1BD098','部门','Department','BaseInfo/Department.aspx',10,'C15CE253-C8E2-4E9A-9082-C758265CB0E7')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('609071D9-5B76-473B-93C6-271609E7E70C','13B6A924-A887-49CF-8F9E-46A2BE1BD098','增加','Add',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('AE82CF3D-5097-4A82-8C8F-E003D9888AA0','13B6A924-A887-49CF-8F9E-46A2BE1BD098','修改','Modify',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('C36E941F-2246-4DD0-823C-605AE77CBC0E','13B6A924-A887-49CF-8F9E-46A2BE1BD098','删除','Delete',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('E995C9F1-1163-4465-BC98-33CD1DB7AFE5','13B6A924-A887-49CF-8F9E-46A2BE1BD098','保存','Save',4)
|
|
GO
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('BD69406B-D99B-4595-9246-A5D319627111','专业类别','Discipline Category','BaseInfo/DisciplineCategory.aspx',20,'C15CE253-C8E2-4E9A-9082-C758265CB0E7')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('0260BF05-E979-4C71-8BF8-15D21BFBAE0B','BD69406B-D99B-4595-9246-A5D319627111','增加','Add',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('588CEC7C-4FCD-451C-8624-CFBC386C7C06','BD69406B-D99B-4595-9246-A5D319627111','修改','Modify',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('FE51F283-EE98-4231-A361-DCDDA31EF054','BD69406B-D99B-4595-9246-A5D319627111','删除','Delete',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('4F812C0E-0C47-496F-BE19-9A637BB3B5D3','BD69406B-D99B-4595-9246-A5D319627111','保存','Save',4)
|
|
GO
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('50E1351A-9D3C-4E23-A005-12537DF1574C','专业','Discipline','BaseInfo/Discipline.aspx',30,'C15CE253-C8E2-4E9A-9082-C758265CB0E7')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('C15E54C0-1D0B-4DAF-A32B-20AD430D725B','50E1351A-9D3C-4E23-A005-12537DF1574C','增加','Add',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('649E8BC7-164F-4A1E-8D44-9982C8287BFE','50E1351A-9D3C-4E23-A005-12537DF1574C','修改','Modify',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('69A3319C-8716-40F8-B953-494E49A20470','50E1351A-9D3C-4E23-A005-12537DF1574C','删除','Delete',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('5B80171B-C50C-459E-B585-6EBC5A00103B','50E1351A-9D3C-4E23-A005-12537DF1574C','保存','Save',4)
|
|
GO
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('DC7D58FF-37B3-4C01-B75E-74E5B9990D4D','承包商','Contractor List','BaseInfo/ContractorList.aspx',40,'C15CE253-C8E2-4E9A-9082-C758265CB0E7')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('CB631393-ABB7-4486-A4ED-142A8AD6909A','DC7D58FF-37B3-4C01-B75E-74E5B9990D4D','增加','Add',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('E4C25159-13B2-41F6-B4C2-3EB92BAAB86C','DC7D58FF-37B3-4C01-B75E-74E5B9990D4D','修改','Modify',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('B845129E-71B9-4A49-BD78-B3BD16353365','DC7D58FF-37B3-4C01-B75E-74E5B9990D4D','删除','Delete',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('3B81B8EF-3085-478B-873D-4ACEB99EC608','DC7D58FF-37B3-4C01-B75E-74E5B9990D4D','保存','Save',4)
|
|
GO
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('4466DC8D-C7E5-4C21-9A94-EE2985C4BEDD','价格方案','Price Scheme','BaseInfo/PriceScheme.aspx',50,'C15CE253-C8E2-4E9A-9082-C758265CB0E7')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('33F57A39-B9C8-4833-82D8-BEE1F87F4397','4466DC8D-C7E5-4C21-9A94-EE2985C4BEDD','增加','Add',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('1A44B09A-79B0-42A6-A20A-8A562B4093D6','4466DC8D-C7E5-4C21-9A94-EE2985C4BEDD','修改','Modify',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('1A6CFD46-2E13-4744-8DF5-B5253C836118','4466DC8D-C7E5-4C21-9A94-EE2985C4BEDD','删除','Delete',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('D9F9C924-373E-4AB1-AB33-BDF50B044077','4466DC8D-C7E5-4C21-9A94-EE2985C4BEDD','保存','Save',4)
|
|
GO
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('86A7E90B-148C-4B01-B57C-3C4F1549BDC9','Item','Item','BaseInfo/Item.aspx',60,'C15CE253-C8E2-4E9A-9082-C758265CB0E7')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('E62D9FC0-4499-46DF-BB0C-A619C48A3E62','86A7E90B-148C-4B01-B57C-3C4F1549BDC9','增加','Add',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('AEEB1DAB-FCCB-4658-8B0C-4BF55550D477','86A7E90B-148C-4B01-B57C-3C4F1549BDC9','修改','Modify',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('E31F835D-62CA-485A-9FA3-CFCF4C8768BC','86A7E90B-148C-4B01-B57C-3C4F1549BDC9','删除','Delete',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('3A3BDDCA-325D-4502-A46F-AA848C708241','86A7E90B-148C-4B01-B57C-3C4F1549BDC9','保存','Save',4)
|
|
GO
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('957FC9B6-15E4-4596-9ED1-EBA49CC8BA7B','币种','Currency','BaseInfo/Currency.aspx',70,'C15CE253-C8E2-4E9A-9082-C758265CB0E7')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('8D5104B3-854D-49A0-9EBE-CEAE7D9EA9F1','957FC9B6-15E4-4596-9ED1-EBA49CC8BA7B','增加','Add',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('07653759-5635-428F-8166-FD7A5F526F6B','957FC9B6-15E4-4596-9ED1-EBA49CC8BA7B','修改','Modify',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('CC72C041-DBC6-46BA-BE2A-7C494772966F','957FC9B6-15E4-4596-9ED1-EBA49CC8BA7B','删除','Delete',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('3A416647-EE17-4CC2-8799-08BE2D6FC1F8','957FC9B6-15E4-4596-9ED1-EBA49CC8BA7B','保存','Save',4)
|
|
GO
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('B84B1E21-5E73-4C67-8D33-853C7ED6E01C','合同类型','FO Type','BaseInfo/FOType.aspx',80,'C15CE253-C8E2-4E9A-9082-C758265CB0E7')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('F02663DA-90AE-4533-A3AF-2AA9FAA1EC0F','B84B1E21-5E73-4C67-8D33-853C7ED6E01C','增加','Add',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('EB71E700-ABD6-4810-8D22-EB56CD7FA4D4','B84B1E21-5E73-4C67-8D33-853C7ED6E01C','修改','Modify',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('88ABDF07-EC9F-41FF-A84A-090C8779FAE4','B84B1E21-5E73-4C67-8D33-853C7ED6E01C','删除','Delete',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('60C39A22-1AF5-4361-8A95-48019D1C26E1','B84B1E21-5E73-4C67-8D33-853C7ED6E01C','保存','Save',4)
|
|
GO
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('A68CA4E2-6555-49A3-8B78-7A54499306C7','类型','Type','BaseInfo/Type.aspx',90,'C15CE253-C8E2-4E9A-9082-C758265CB0E7')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('1F57288A-FB3B-4F8E-8A85-03B1CD6E3D6E','A68CA4E2-6555-49A3-8B78-7A54499306C7','增加','Add',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('80C66664-2746-456B-AB31-B7F326B77D5B','A68CA4E2-6555-49A3-8B78-7A54499306C7','修改','Modify',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('002A57F4-1A0A-4394-9500-52C2888C6A0F','A68CA4E2-6555-49A3-8B78-7A54499306C7','删除','Delete',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('C6127CFC-DA52-40AF-B861-136C0435F58C','A68CA4E2-6555-49A3-8B78-7A54499306C7','保存','Save',4)
|
|
GO
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('093AC2A7-3E27-4752-BA78-016A4E67DB80','Requisitioner','Requisitioner','BaseInfo/Requisitioner.aspx',100,'C15CE253-C8E2-4E9A-9082-C758265CB0E7')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('C733ECDF-5BA9-423C-9666-6C3BE3F71FA8','093AC2A7-3E27-4752-BA78-016A4E67DB80','增加','Add',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('D6CE7096-D084-4368-83E8-6DC9179A5E09','093AC2A7-3E27-4752-BA78-016A4E67DB80','修改','Modify',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('EB1ACC3D-D5CE-4A65-BBE0-C44CF1B05B9A','093AC2A7-3E27-4752-BA78-016A4E67DB80','删除','Delete',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('757D8149-C33A-41EA-A765-72E28A60156A','093AC2A7-3E27-4752-BA78-016A4E67DB80','保存','Save',4)
|
|
GO
|
|
|
|
/******FC******/
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('21FCD41E-2E96-4DE0-8F5F-BDD0C967134F','EMC Contracts','EMC Contracts','',30,'0')
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('1F13D624-91E5-42FD-95F2-E77F0AF7B744','FC list','FC list','SES/SESRelatedData.aspx',10,'21FCD41E-2E96-4DE0-8F5F-BDD0C967134F')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('39D39F7A-50AA-4C9F-9DFE-840FDBC9DB9D','1F13D624-91E5-42FD-95F2-E77F0AF7B744','增加','Add',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('914D3126-B4B2-43D7-96D7-1FC664173D66','1F13D624-91E5-42FD-95F2-E77F0AF7B744','修改','Modify',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('EA50238C-6162-4DAE-9584-6E52EB4E21F6','1F13D624-91E5-42FD-95F2-E77F0AF7B744','删除','Delete',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('C1008236-B818-4A5D-8704-3B1578DB2B50','1F13D624-91E5-42FD-95F2-E77F0AF7B744','保存','Save',4)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('BFDD741E-FBA6-486B-B6B4-E5EC87309306','1F13D624-91E5-42FD-95F2-E77F0AF7B744','查看','View',5)
|
|
GO
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('DD0C9412-5BED-4B1B-8F20-B0770593F603','SES report','SES report','SES/SESReport.aspx',20,'21FCD41E-2E96-4DE0-8F5F-BDD0C967134F')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('528CD682-435C-4797-8898-59F19F2AEB3C','DD0C9412-5BED-4B1B-8F20-B0770593F603','导入','Import',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('3A716A5B-A667-4730-ADB9-007DAE038D0A','DD0C9412-5BED-4B1B-8F20-B0770593F603','查看','View',2)
|
|
GO
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('AAF9B6EA-4CD4-4923-81DE-46E5FDB99B2C','一次性项目登记','One time contracts','SES/OneTimeContracts.aspx',30,'21FCD41E-2E96-4DE0-8F5F-BDD0C967134F')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('37945991-011E-4ED5-ACCF-74654D15A23D','AAF9B6EA-4CD4-4923-81DE-46E5FDB99B2C','增加','Add',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('28EBA23F-C482-47A8-AFAA-5121999B1324','AAF9B6EA-4CD4-4923-81DE-46E5FDB99B2C','修改','Modify',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('7372A12A-6607-4EEC-9860-29CB272204B2','AAF9B6EA-4CD4-4923-81DE-46E5FDB99B2C','删除','Delete',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('561F8EAA-FADA-49BD-87FD-3F057CDD124C','AAF9B6EA-4CD4-4923-81DE-46E5FDB99B2C','保存','Save',4)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('7E21FBBC-2788-4D9A-8EC0-EA775DB2A0BD','AAF9B6EA-4CD4-4923-81DE-46E5FDB99B2C','查看','View',5)
|
|
GO
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('A0E90E04-B5F4-4A7A-BD77-F509D9C27C32','CT销售合同','CT sales contracts','SES/CTSalesContracts.aspx',40,'21FCD41E-2E96-4DE0-8F5F-BDD0C967134F')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('A1858128-FE59-4CEC-8E28-12EAB524D240','A0E90E04-B5F4-4A7A-BD77-F509D9C27C32','增加','Add',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('AE9CADBF-655B-455A-B466-77051488F5C2','A0E90E04-B5F4-4A7A-BD77-F509D9C27C32','修改','Modify',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('11E973AD-68BA-46FC-A83C-1C6CA26215EA','A0E90E04-B5F4-4A7A-BD77-F509D9C27C32','删除','Delete',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('662B20AC-D294-4C41-953D-12B9918BE5F0','A0E90E04-B5F4-4A7A-BD77-F509D9C27C32','保存','Save',4)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('CE422619-ED8D-461F-9FBD-73E2CD883FAA','A0E90E04-B5F4-4A7A-BD77-F509D9C27C32','查看','View',5)
|
|
GO
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('C4BDD8A5-131C-47AE-855A-01E50F004046','SSR Collection','SSR collection','SES/SSR.aspx',50,'21FCD41E-2E96-4DE0-8F5F-BDD0C967134F')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('9A8A940D-7338-44E5-818B-B5BEFC35ED27','C4BDD8A5-131C-47AE-855A-01E50F004046','增加','Add',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('D9064650-F363-4529-8018-95FFF059110D','C4BDD8A5-131C-47AE-855A-01E50F004046','修改','Modify',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('F90C6554-8D5C-4B03-A038-09DDE08D0689','C4BDD8A5-131C-47AE-855A-01E50F004046','删除','Delete',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('7A90E59A-5AA5-47C2-91B2-0BB775FAA406','C4BDD8A5-131C-47AE-855A-01E50F004046','保存','Save',4)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('F535532B-64E7-4EDE-A0E8-8FC39B1B112B','C4BDD8A5-131C-47AE-855A-01E50F004046','查看','View',5)
|
|
GO
|
|
--INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
--VALUES('81BAD734-E2DA-4152-A572-57B61B1FEC8F','SES Evaluate','SES Evaluate','SES/SESEvaluateList.aspx',40,'21FCD41E-2E96-4DE0-8F5F-BDD0C967134F')
|
|
--GO
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('FF41ACB4-9C3A-4ADD-AE05-53A0187613C4','CPT','CPT','',40,'0')
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('E6986481-ADDA-46F7-B0DA-3103BAA30250','CPT','CPT','CPT/SESReportToCPT.aspx',10,'FF41ACB4-9C3A-4ADD-AE05-53A0187613C4')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
|
VALUES('E5CB4AB8-C45D-4531-848C-773780DBDD8D','E6986481-ADDA-46F7-B0DA-3103BAA30250','导入','Import',1)
|
|
GO
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('3F20031E-F769-4950-AA89-C9EB0BFB95E8','CPT List','CPT List','CPT/CPTReportList.aspx',20,'FF41ACB4-9C3A-4ADD-AE05-53A0187613C4')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
|
VALUES('8B42C544-A2A5-4BCC-B026-5BCA89DC5755','3F20031E-F769-4950-AA89-C9EB0BFB95E8','查看','View',1)
|
|
GO
|
|
|
|
/**********KPI**********/
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('E4388014-A363-435A-BE07-014C3A29FD5B','KPI','KPI','',60,'0')
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('155F6FE5-8528-486A-8741-80AE7AA570FC','KPI','KPI','KPI/KPI.aspx',10,'E4388014-A363-435A-BE07-014C3A29FD5B')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
|
VALUES('B0241E60-516D-4C6F-9B9D-BB3A3B0F1B8C','155F6FE5-8528-486A-8741-80AE7AA570FC','查看','View',1)
|
|
GO
|
|
|
|
/*********Evaluation************/
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('A84F4EFE-60C9-4CD2-88E4-AE50ED023E13','Evaluation','Evaluation','',70,'0')
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('4896C1B7-CBE9-4384-83C5-2AC86A837D09','评价','Evaluation','Evaluation/Evaluation.aspx',10,'A84F4EFE-60C9-4CD2-88E4-AE50ED023E13')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('ECE418B5-A0EB-4FEE-8059-29B1134B7A00','4896C1B7-CBE9-4384-83C5-2AC86A837D09','评价','Evaluation',1)
|
|
GO
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('31BEB4CC-3C7D-4987-8F3F-30343E26BA41','文件管理','Files Management','Evaluation/FilesManagement.aspx',20,'A84F4EFE-60C9-4CD2-88E4-AE50ED023E13')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
|
VALUES('26E9DD77-4EC6-4C86-AF12-623CED063BED','31BEB4CC-3C7D-4987-8F3F-30343E26BA41','查看','View',1)
|
|
GO
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('DD0202E2-0EBD-41A3-AA81-33684B8DE014','评价报告','Evaluation Report','Evaluation/EvaluationReport.aspx',30,'A84F4EFE-60C9-4CD2-88E4-AE50ED023E13')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
|
VALUES('77E27E3A-4FD5-4920-B1BC-8D6709E39ACF','DD0202E2-0EBD-41A3-AA81-33684B8DE014','查看','View',1)
|
|
GO
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('C274C52B-5B66-46A5-BF20-4B6ECE296148','评价报告导出','Export Details','Evaluation/ExportDetails.aspx',40,'A84F4EFE-60C9-4CD2-88E4-AE50ED023E13')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
|
VALUES('6149BBC2-B573-415C-A962-6B6A429944A0','C274C52B-5B66-46A5-BF20-4B6ECE296148','导出','Export',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
|
VALUES('16C3FCCA-F6BD-44B5-909D-CF7C385EC297','C274C52B-5B66-46A5-BF20-4B6ECE296148','查看','View',2)
|
|
GO
|
|
/***********邮件************/
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('14948277-1C18-4C2F-A825-09B82D9A5CB8','Send Email','Send Email','',80,'0')
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('DDEA5462-2064-4610-B829-A941E4FB744A','Send Email Pop','Send Email Pop','SendEmail/SendEmailPop.aspx',10,'14948277-1C18-4C2F-A825-09B82D9A5CB8')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
|
VALUES('A4498E67-A1F8-4C38-9637-23BB7619DBB6','DDEA5462-2064-4610-B829-A941E4FB744A','保存','Save',1)
|
|
GO
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('56AE06A3-DA93-4FB3-8CDB-310054A703A8','Send Email Log','Send Email Log','SendEmail/SendEmailLog.aspx',20,'14948277-1C18-4C2F-A825-09B82D9A5CB8')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
|
VALUES('5C466358-C9CA-445F-B595-7C2DB4E91096','56AE06A3-DA93-4FB3-8CDB-310054A703A8','查看','View',1)
|
|
GO
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('EB857D75-A90E-472E-BCC6-F6CF54EEB549','Send Email Template','Send Email Template','SendEmail/SendEmailTemplateList.aspx',30,'14948277-1C18-4C2F-A825-09B82D9A5CB8')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
|
VALUES('8B4CDDCB-A3FA-4E57-BD4D-E52973F1ECF4','EB857D75-A90E-472E-BCC6-F6CF54EEB549','增加','Add',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
|
VALUES('26CE6917-EADF-4DB1-9EF8-D3A5F7C0E5D2','EB857D75-A90E-472E-BCC6-F6CF54EEB549','修改','Modify',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
|
VALUES('B5D08D94-0BBB-4D1B-A277-EEAF5D10DA51','EB857D75-A90E-472E-BCC6-F6CF54EEB549','删除','Delete',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
|
VALUES('9BCFAFFE-AE24-4AAC-8645-652F53DD098A','EB857D75-A90E-472E-BCC6-F6CF54EEB549','保存','Save',4)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
|
VALUES('DFEF4FE6-41A9-4A8C-A0A0-56760FDD9962','EB857D75-A90E-472E-BCC6-F6CF54EEB549','查看','View',5)
|
|
GO
|
|
INSERT INTO Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu)
|
|
VALUES('6D7D7BFC-57CD-40D5-BF4C-66C53C26B833','Send Email','Send Email','SendEmail/SendEmail.aspx',40,'14948277-1C18-4C2F-A825-09B82D9A5CB8')
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
|
VALUES('EA6D0C19-725A-4192-8174-CDE93BE21797','6D7D7BFC-57CD-40D5-BF4C-66C53C26B833','发送','Send',1)
|
|
|
|
|
|
|
|
|