You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
836 lines
23 KiB
SQL
836 lines
23 KiB
SQL
delete from SystemRightDetail where rightid =2696;
|
|
/
|
|
|
|
delete from SystemRightsLanguage where id =2696;
|
|
/
|
|
|
|
delete from SystemRights where id =2696;
|
|
/
|
|
|
|
delete from SystemRightToGroup where rightid =2696;
|
|
/
|
|
|
|
delete from SystemRightType where id =37;
|
|
/
|
|
|
|
delete from SystemRightGroups where id =-23;
|
|
/
|
|
|
|
delete from SystemRightDetail where rightid =2718;
|
|
/
|
|
|
|
delete from SystemRightsLanguage where id =2718;
|
|
/
|
|
|
|
delete from SystemRights where id =2718;
|
|
/
|
|
|
|
delete from SystemRightToGroup where rightid =2718;
|
|
/
|
|
|
|
delete from SystemRightType where id =37;
|
|
/
|
|
|
|
delete from SystemRightGroups where id =-23;
|
|
/
|
|
|
|
insert into SystemRights (id,rightdesc,righttype,detachable) values (2718,'编制信息','37',1);
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2718,8,'Preparation information','Preparation information');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2718,9,'編製信息','編製信息');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2718,7,'编制信息','编制信息');
|
|
/
|
|
|
|
insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43983,'编制信息权限','Staff:All',2718);
|
|
/
|
|
|
|
insert into SystemRightToGroup(rightid,groupid) values (2718,-23);
|
|
/
|
|
|
|
insert into SystemRightGroups (id,rightgroupmark, rightgroupname, rightgroupremark) values(-23,'ORGANIZATION','组织管理权限组','组织管理');
|
|
/
|
|
|
|
insert into SystemRightType(id,rightTypeName,rightTypeDesc) VALUES (37,'组织管理','组织管理');
|
|
/
|
|
|
|
delete from SystemRightDetail where rightid =2717;
|
|
/
|
|
|
|
delete from SystemRightsLanguage where id =2717;
|
|
/
|
|
|
|
delete from SystemRights where id =2717;
|
|
/
|
|
|
|
delete from SystemRightToGroup where rightid =2717;
|
|
/
|
|
|
|
delete from SystemRightType where id =37;
|
|
/
|
|
|
|
delete from SystemRightGroups where id =-23;
|
|
/
|
|
|
|
insert into SystemRights (id,rightdesc,righttype,detachable) values (2717,'编制方案','37',1);
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2717,8,'Preparation scheme','Preparation scheme');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2717,9,'編製方案','編製方案');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2717,7,'编制方案','编制方案');
|
|
/
|
|
|
|
insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43982,'编制方案权限','StaffPlan:All',2717);
|
|
/
|
|
|
|
insert into SystemRightToGroup(rightid,groupid) values (2717,-23);
|
|
/
|
|
|
|
insert into SystemRightGroups (id,rightgroupmark, rightgroupname, rightgroupremark) values(-23,'ORGANIZATION','组织管理权限组','组织管理');
|
|
/
|
|
|
|
insert into SystemRightType(id,rightTypeName,rightTypeDesc) VALUES (37,'组织管理','组织管理');
|
|
/
|
|
|
|
delete from SystemRightDetail where rightid =2716;
|
|
/
|
|
|
|
delete from SystemRightsLanguage where id =2716;
|
|
/
|
|
|
|
delete from SystemRights where id =2716;
|
|
/
|
|
|
|
delete from SystemRightToGroup where rightid =2716;
|
|
/
|
|
|
|
delete from SystemRightType where id =37;
|
|
/
|
|
|
|
delete from SystemRightGroups where id =-23;
|
|
/
|
|
|
|
insert into SystemRights (id,rightdesc,righttype,detachable) values (2716,'组织透视','37',1);
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2716,8,'Tissue Perspective','Tissue Perspective');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2716,9,'組織透視','組織透視');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2716,7,'组织透视','组织透视');
|
|
/
|
|
|
|
insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43994,'组织透视权限','OrgPerspective:All',2716);
|
|
/
|
|
|
|
insert into SystemRightToGroup(rightid,groupid) values (2716,-23);
|
|
/
|
|
|
|
insert into SystemRightGroups (id,rightgroupmark, rightgroupname, rightgroupremark) values(-23,'ORGANIZATION','组织管理权限组','组织管理');
|
|
/
|
|
|
|
insert into SystemRightType(id,rightTypeName,rightTypeDesc) VALUES (37,'组织管理','组织管理');
|
|
/
|
|
|
|
delete from SystemRightDetail where rightid =2715;
|
|
/
|
|
|
|
delete from SystemRightsLanguage where id =2715;
|
|
/
|
|
|
|
delete from SystemRights where id =2715;
|
|
/
|
|
|
|
delete from SystemRightToGroup where rightid =2715;
|
|
/
|
|
|
|
delete from SystemRightType where id =37;
|
|
/
|
|
|
|
delete from SystemRightGroups where id =-23;
|
|
/
|
|
|
|
insert into SystemRights (id,rightdesc,righttype,detachable) values (2715,'组织架构图','37',1);
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2715,8,'Organization chart','Organization chart');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2715,9,'組織架構圖','組織架構圖');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2715,7,'组织架构图','组织架构图');
|
|
/
|
|
|
|
insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43993,'组织架构图权限','OrgChart:All',2715);
|
|
/
|
|
|
|
insert into SystemRightToGroup(rightid,groupid) values (2715,-23);
|
|
/
|
|
|
|
insert into SystemRightGroups (id,rightgroupmark, rightgroupname, rightgroupremark) values(-23,'ORGANIZATION','组织管理权限组','组织管理');
|
|
/
|
|
|
|
insert into SystemRightType(id,rightTypeName,rightTypeDesc) VALUES (37,'组织管理','组织管理');
|
|
/
|
|
|
|
delete from SystemRightDetail where rightid =2714;
|
|
/
|
|
|
|
delete from SystemRightsLanguage where id =2714;
|
|
/
|
|
|
|
delete from SystemRights where id =2714;
|
|
/
|
|
|
|
delete from SystemRightToGroup where rightid =2714;
|
|
/
|
|
|
|
delete from SystemRightType where id =37;
|
|
/
|
|
|
|
delete from SystemRightGroups where id =-23;
|
|
/
|
|
|
|
insert into SystemRights (id,rightdesc,righttype,detachable) values (2714,'组织数据导入','37',0);
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2714,8,'Organization data import','Organization data import');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2714,9,'組織數據導入','組織數據導入');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2714,7,'组织数据导入','组织数据导入');
|
|
/
|
|
|
|
insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43998,'组织数据导入权限','DataImport:All',2714);
|
|
/
|
|
|
|
insert into SystemRightToGroup(rightid,groupid) values (2714,-23);
|
|
/
|
|
|
|
insert into SystemRightGroups (id,rightgroupmark, rightgroupname, rightgroupremark) values(-23,'ORGANIZATION','组织管理权限组','组织管理');
|
|
/
|
|
|
|
insert into SystemRightType(id,rightTypeName,rightTypeDesc) VALUES (37,'组织管理','组织管理');
|
|
/
|
|
|
|
delete from SystemRightDetail where rightid =2713;
|
|
/
|
|
|
|
delete from SystemRightsLanguage where id =2713;
|
|
/
|
|
|
|
delete from SystemRights where id =2713;
|
|
/
|
|
|
|
delete from SystemRightToGroup where rightid =2713;
|
|
/
|
|
|
|
delete from SystemRightType where id =37;
|
|
/
|
|
|
|
delete from SystemRightGroups where id =-23;
|
|
/
|
|
|
|
insert into SystemRights (id,rightdesc,righttype,detachable) values (2713,'岗位管理','37',1);
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2713,8,'Post management','Post management');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2713,9,'崗位管理','崗位管理');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2713,7,'岗位管理','岗位管理');
|
|
/
|
|
|
|
insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43981,'岗位管理权限','Job:All',2713);
|
|
/
|
|
|
|
insert into SystemRightToGroup(rightid,groupid) values (2713,-23);
|
|
/
|
|
|
|
insert into SystemRightGroups (id,rightgroupmark, rightgroupname, rightgroupremark) values(-23,'ORGANIZATION','组织管理权限组','组织管理');
|
|
/
|
|
|
|
insert into SystemRightType(id,rightTypeName,rightTypeDesc) VALUES (37,'组织管理','组织管理');
|
|
/
|
|
|
|
delete from SystemRightDetail where rightid =2712;
|
|
/
|
|
|
|
delete from SystemRightsLanguage where id =2712;
|
|
/
|
|
|
|
delete from SystemRights where id =2712;
|
|
/
|
|
|
|
delete from SystemRightToGroup where rightid =2712;
|
|
/
|
|
|
|
delete from SystemRightType where id =37;
|
|
/
|
|
|
|
delete from SystemRightGroups where id =-23;
|
|
/
|
|
|
|
insert into SystemRights (id,rightdesc,righttype,detachable) values (2712,'部门管理','37',1);
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2712,8,'Department management','Department management');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2712,9,'部門管理','部門管理');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2712,7,'部门管理','部门管理');
|
|
/
|
|
|
|
insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43980,'部门管理权限','Department:All',2712);
|
|
/
|
|
|
|
insert into SystemRightToGroup(rightid,groupid) values (2712,-23);
|
|
/
|
|
|
|
insert into SystemRightGroups (id,rightgroupmark, rightgroupname, rightgroupremark) values(-23,'ORGANIZATION','组织管理权限组','组织管理');
|
|
/
|
|
|
|
insert into SystemRightType(id,rightTypeName,rightTypeDesc) VALUES (37,'组织管理','组织管理');
|
|
/
|
|
|
|
delete from SystemRightDetail where rightid =2711;
|
|
/
|
|
|
|
delete from SystemRightsLanguage where id =2711;
|
|
/
|
|
|
|
delete from SystemRights where id =2711;
|
|
/
|
|
|
|
delete from SystemRightToGroup where rightid =2711;
|
|
/
|
|
|
|
delete from SystemRightType where id =37;
|
|
/
|
|
|
|
delete from SystemRightGroups where id =-23;
|
|
/
|
|
|
|
insert into SystemRights (id,rightdesc,righttype,detachable) values (2711,'分部管理','37',1);
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2711,8,'Segment management','Segment management');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2711,9,'分部管理','分部管理');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2711,7,'分部管理','分部管理');
|
|
/
|
|
|
|
insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43979,'分部管理权限','Company:All',2711);
|
|
/
|
|
|
|
insert into SystemRightToGroup(rightid,groupid) values (2711,-23);
|
|
/
|
|
|
|
insert into SystemRightGroups (id,rightgroupmark, rightgroupname, rightgroupremark) values(-23,'ORGANIZATION','组织管理权限组','组织管理');
|
|
/
|
|
|
|
insert into SystemRightType(id,rightTypeName,rightTypeDesc) VALUES (37,'组织管理','组织管理');
|
|
/
|
|
|
|
delete from SystemRightDetail where rightid =2710;
|
|
/
|
|
|
|
delete from SystemRightsLanguage where id =2710;
|
|
/
|
|
|
|
delete from SystemRights where id =2710;
|
|
/
|
|
|
|
delete from SystemRightToGroup where rightid =2710;
|
|
/
|
|
|
|
delete from SystemRightType where id =37;
|
|
/
|
|
|
|
delete from SystemRightGroups where id =-23;
|
|
/
|
|
|
|
insert into SystemRights (id,rightdesc,righttype,detachable) values (2710,'集团管理','37',0);
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2710,8,'Group management','Group management');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2710,9,'集團管理','集團管理');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2710,7,'集团管理','集团管理');
|
|
/
|
|
|
|
insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43978,'集团管理权限','Group:All',2710);
|
|
/
|
|
|
|
insert into SystemRightToGroup(rightid,groupid) values (2710,-23);
|
|
/
|
|
|
|
insert into SystemRightGroups (id,rightgroupmark, rightgroupname, rightgroupremark) values(-23,'ORGANIZATION','组织管理权限组','组织管理');
|
|
/
|
|
|
|
insert into SystemRightType(id,rightTypeName,rightTypeDesc) VALUES (37,'组织管理','组织管理');
|
|
/
|
|
|
|
delete from SystemRightDetail where rightid =2709;
|
|
/
|
|
|
|
delete from SystemRightsLanguage where id =2709;
|
|
/
|
|
|
|
delete from SystemRights where id =2709;
|
|
/
|
|
|
|
delete from SystemRightToGroup where rightid =2709;
|
|
/
|
|
|
|
delete from SystemRightType where id =37;
|
|
/
|
|
|
|
delete from SystemRightGroups where id =-23;
|
|
/
|
|
|
|
insert into SystemRights (id,rightdesc,righttype,detachable) values (2709,'职务管理','37',0);
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2709,8,'Job management','Job management');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2709,9,'職務管理','職務管理');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2709,7,'职务管理','职务管理');
|
|
/
|
|
|
|
insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43977,'职务信息权限','PostInfo:All',2709);
|
|
/
|
|
|
|
insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43976,'职务分类权限','Post:All',2709);
|
|
/
|
|
|
|
insert into SystemRightToGroup(rightid,groupid) values (2709,-23);
|
|
/
|
|
|
|
insert into SystemRightGroups (id,rightgroupmark, rightgroupname, rightgroupremark) values(-23,'ORGANIZATION','组织管理权限组','组织管理');
|
|
/
|
|
|
|
insert into SystemRightType(id,rightTypeName,rightTypeDesc) VALUES (37,'组织管理','组织管理');
|
|
/
|
|
|
|
delete from SystemRightDetail where rightid =2708;
|
|
/
|
|
|
|
delete from SystemRightsLanguage where id =2708;
|
|
/
|
|
|
|
delete from SystemRights where id =2708;
|
|
/
|
|
|
|
delete from SystemRightToGroup where rightid =2708;
|
|
/
|
|
|
|
delete from SystemRightType where id =37;
|
|
/
|
|
|
|
delete from SystemRightGroups where id =-23;
|
|
/
|
|
|
|
insert into SystemRights (id,rightdesc,righttype,detachable) values (2708,'岗位序列','37',0);
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2708,8,'Position sequence','Position sequence');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2708,9,'崗位序列','崗位序列');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2708,7,'岗位序列','岗位序列');
|
|
/
|
|
|
|
insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43975,'岗位序列权限','Sequence:All',2708);
|
|
/
|
|
|
|
insert into SystemRightToGroup(rightid,groupid) values (2708,-23);
|
|
/
|
|
|
|
insert into SystemRightGroups (id,rightgroupmark, rightgroupname, rightgroupremark) values(-23,'ORGANIZATION','组织管理权限组','组织管理');
|
|
/
|
|
|
|
insert into SystemRightType(id,rightTypeName,rightTypeDesc) VALUES (37,'组织管理','组织管理');
|
|
/
|
|
|
|
delete from SystemRightDetail where rightid =2707;
|
|
/
|
|
|
|
delete from SystemRightsLanguage where id =2707;
|
|
/
|
|
|
|
delete from SystemRights where id =2707;
|
|
/
|
|
|
|
delete from SystemRightToGroup where rightid =2707;
|
|
/
|
|
|
|
delete from SystemRightType where id =37;
|
|
/
|
|
|
|
delete from SystemRightGroups where id =-23;
|
|
/
|
|
|
|
insert into SystemRights (id,rightdesc,righttype,detachable) values (2707,'职级','37',0);
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2707,8,'Rank','Rank');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2707,9,'職級','職級');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2707,7,'职级','职级');
|
|
/
|
|
|
|
insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43974,'职级权限','Grade:All',2707);
|
|
/
|
|
|
|
insert into SystemRightToGroup(rightid,groupid) values (2707,-23);
|
|
/
|
|
|
|
insert into SystemRightGroups (id,rightgroupmark, rightgroupname, rightgroupremark) values(-23,'ORGANIZATION','组织管理权限组','组织管理');
|
|
/
|
|
|
|
insert into SystemRightType(id,rightTypeName,rightTypeDesc) VALUES (37,'组织管理','组织管理');
|
|
/
|
|
|
|
delete from SystemRightDetail where rightid =2706;
|
|
/
|
|
|
|
delete from SystemRightsLanguage where id =2706;
|
|
/
|
|
|
|
delete from SystemRights where id =2706;
|
|
/
|
|
|
|
delete from SystemRightToGroup where rightid =2706;
|
|
/
|
|
|
|
delete from SystemRightType where id =37;
|
|
/
|
|
|
|
delete from SystemRightGroups where id =-23;
|
|
/
|
|
|
|
insert into SystemRights (id,rightdesc,righttype,detachable) values (2706,'职等','37',0);
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2706,8,'grade of positions','grade of positions');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2706,9,'職等','職等');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2706,7,'职等','职等');
|
|
/
|
|
|
|
insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43973,'职等权限','Level:All',2706);
|
|
/
|
|
|
|
insert into SystemRightToGroup(rightid,groupid) values (2706,-23);
|
|
/
|
|
|
|
insert into SystemRightGroups (id,rightgroupmark, rightgroupname, rightgroupremark) values(-23,'ORGANIZATION','组织管理权限组','组织管理');
|
|
/
|
|
|
|
insert into SystemRightType(id,rightTypeName,rightTypeDesc) VALUES (37,'组织管理','组织管理');
|
|
/
|
|
|
|
delete from SystemRightDetail where rightid =2705;
|
|
/
|
|
|
|
delete from SystemRightsLanguage where id =2705;
|
|
/
|
|
|
|
delete from SystemRights where id =2705;
|
|
/
|
|
|
|
delete from SystemRightToGroup where rightid =2705;
|
|
/
|
|
|
|
delete from SystemRightType where id =37;
|
|
/
|
|
|
|
delete from SystemRightGroups where id =-23;
|
|
/
|
|
|
|
insert into SystemRights (id,rightdesc,righttype,detachable) values (2705,'等级方案','37',0);
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2705,8,'Grade scheme','Grade scheme');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2705,9,'等級方案','等級方案');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2705,7,'等级方案','等级方案');
|
|
/
|
|
|
|
insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43972,'等级方案权限','Scheme:All',2705);
|
|
/
|
|
|
|
insert into SystemRightToGroup(rightid,groupid) values (2705,-23);
|
|
/
|
|
|
|
insert into SystemRightGroups (id,rightgroupmark, rightgroupname, rightgroupremark) values(-23,'ORGANIZATION','组织管理权限组','组织管理');
|
|
/
|
|
|
|
insert into SystemRightType(id,rightTypeName,rightTypeDesc) VALUES (37,'组织管理','组织管理');
|
|
/
|
|
|
|
delete from SystemRightDetail where rightid =2721;
|
|
/
|
|
|
|
delete from SystemRightsLanguage where id =2721;
|
|
/
|
|
|
|
delete from SystemRights where id =2721;
|
|
/
|
|
|
|
delete from SystemRightToGroup where rightid =2721;
|
|
/
|
|
|
|
delete from SystemRightType where id =37;
|
|
/
|
|
|
|
delete from SystemRightGroups where id =-23;
|
|
/
|
|
|
|
insert into SystemRights (id,rightdesc,righttype,detachable) values (2721,'岗位字段定义','37',0);
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2721,8,'Position field definition','Position field definition');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2721,9,'崗位字段定義','崗位字段定義');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2721,7,'岗位字段定义','岗位字段定义');
|
|
/
|
|
|
|
insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43997,'岗位字段定义权限','PostField:All',2721);
|
|
/
|
|
|
|
insert into SystemRightToGroup(rightid,groupid) values (2721,-23);
|
|
/
|
|
|
|
insert into SystemRightGroups (id,rightgroupmark, rightgroupname, rightgroupremark) values(-23,'ORGANIZATION','组织管理权限组','组织管理');
|
|
/
|
|
|
|
insert into SystemRightType(id,rightTypeName,rightTypeDesc) VALUES (37,'组织管理','组织管理');
|
|
/
|
|
|
|
delete from SystemRightDetail where rightid =2720;
|
|
/
|
|
|
|
delete from SystemRightsLanguage where id =2720;
|
|
/
|
|
|
|
delete from SystemRights where id =2720;
|
|
/
|
|
|
|
delete from SystemRightToGroup where rightid =2720;
|
|
/
|
|
|
|
delete from SystemRightType where id =37;
|
|
/
|
|
|
|
delete from SystemRightGroups where id =-23;
|
|
/
|
|
|
|
insert into SystemRights (id,rightdesc,righttype,detachable) values (2720,'部门字段定义','37',0);
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2720,8,'Department field definition','Department field definition');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2720,9,'部門字段定義','部門字段定義');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2720,7,'部门字段定义','部门字段定义');
|
|
/
|
|
|
|
insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43996,'部门字段定义权限','DepartmentField:All',2720);
|
|
/
|
|
|
|
insert into SystemRightToGroup(rightid,groupid) values (2720,-23);
|
|
/
|
|
|
|
insert into SystemRightGroups (id,rightgroupmark, rightgroupname, rightgroupremark) values(-23,'ORGANIZATION','组织管理权限组','组织管理');
|
|
/
|
|
|
|
insert into SystemRightType(id,rightTypeName,rightTypeDesc) VALUES (37,'组织管理','组织管理');
|
|
/
|
|
|
|
delete from SystemRightDetail where rightid =2719;
|
|
/
|
|
|
|
delete from SystemRightsLanguage where id =2719;
|
|
/
|
|
|
|
delete from SystemRights where id =2719;
|
|
/
|
|
|
|
delete from SystemRightToGroup where rightid =2719;
|
|
/
|
|
|
|
delete from SystemRightType where id =37;
|
|
/
|
|
|
|
delete from SystemRightGroups where id =-23;
|
|
/
|
|
|
|
insert into SystemRights (id,rightdesc,righttype,detachable) values (2719,'分部字段定义','37',0);
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2719,8,'Partial field definition','Partial field definition');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2719,9,'分部字段定義','分部字段定義');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2719,7,'分部字段定义','分部字段定义');
|
|
/
|
|
|
|
insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43995,'分部字段定义权限','CompanyField:All',2719);
|
|
/
|
|
|
|
insert into SystemRightToGroup(rightid,groupid) values (2719,-23);
|
|
/
|
|
|
|
insert into SystemRightGroups (id,rightgroupmark, rightgroupname, rightgroupremark) values(-23,'ORGANIZATION','组织管理权限组','组织管理');
|
|
/
|
|
|
|
insert into SystemRightType(id,rightTypeName,rightTypeDesc) VALUES (37,'组织管理','组织管理');
|
|
/
|
|
|
|
delete from SystemRightDetail where rightid =2722;
|
|
/
|
|
|
|
delete from SystemRightsLanguage where id =2722;
|
|
/
|
|
|
|
delete from SystemRights where id =2722;
|
|
/
|
|
|
|
delete from SystemRightToGroup where rightid =2722;
|
|
/
|
|
|
|
delete from SystemRightType where id =37;
|
|
/
|
|
|
|
delete from SystemRightGroups where id =-23;
|
|
/
|
|
|
|
insert into SystemRights (id,rightdesc,righttype,detachable) values (2722,'人员信息','37',0);
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2722,8,'Personnel information','Personnel information');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2722,9,'人員信息','人員信息');
|
|
/
|
|
|
|
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2722,7,'人员信息','人员信息');
|
|
/
|
|
|
|
insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (43999,'人员信息权限','ResourceBasicInfo:All',2722);
|
|
/
|
|
|
|
insert into SystemRightToGroup(rightid,groupid) values (2722,-23);
|
|
/
|
|
|
|
insert into SystemRightGroups (id,rightgroupmark, rightgroupname, rightgroupremark) values(-23,'ORGANIZATION','组织管理权限组','组织管理');
|
|
/
|
|
|
|
insert into SystemRightType(id,rightTypeName,rightTypeDesc) VALUES (37,'组织管理','组织管理');
|
|
/
|
|
|
|
Delete from LeftMenuInfo where id=100163;
|
|
/
|
|
|
|
Delete from LeftMenuConfig where infoid=100163;
|
|
/
|
|
|
|
call LMConfig_U_ByInfoInsert (2,100162,-1);
|
|
/
|
|
|
|
call LMInfo_Insert (100163,538759,'','',2,100162,-1,2);
|
|
/
|
|
|
|
update LeftMenuInfo set mobxrouteurl = '',iconClassName = '',fullrouteurl='/spa/hrm/static4engine/engine.html#/hrmengine/subNumberSet' where id = 100163;
|
|
/
|
|
|
|
Delete from LeftMenuInfo where id=100164;
|
|
/
|
|
|
|
Delete from LeftMenuConfig where infoid=100164;
|
|
/
|
|
|
|
call LMConfig_U_ByInfoInsert (2,100162,0);
|
|
/
|
|
|
|
call LMInfo_Insert (100164,530289,'','',2,100162,0,2);
|
|
/
|
|
|
|
update LeftMenuInfo set mobxrouteurl = '',iconClassName = '',fullrouteurl='/spa/hrm/static4engine/engine.html#/hrmengine/deptNumberSet' where id = 100164;
|
|
/
|
|
|
|
Delete from LeftMenuInfo where id=100166;
|
|
/
|
|
|
|
Delete from LeftMenuConfig where infoid=100166;
|
|
/
|
|
|
|
call LMConfig_U_ByInfoInsert (2,100162,2);
|
|
/
|
|
|
|
call LMInfo_Insert (100166,538764,'','',2,100162,2,2);
|
|
/
|
|
|
|
update LeftMenuInfo set mobxrouteurl = '',iconClassName = '',fullrouteurl='/spa/hrm/static4engine/engine.html#/hrmengine/resourceNumberSet' where id = 100166;
|
|
/
|
|
|
|
Delete from LeftMenuInfo where id=100165;
|
|
/
|
|
|
|
Delete from LeftMenuConfig where infoid=100165;
|
|
/
|
|
|
|
call LMConfig_U_ByInfoInsert (2,100162,1);
|
|
/
|
|
|
|
call LMInfo_Insert (100165,538763,'','',2,100162,1,2);
|
|
/
|
|
|
|
update LeftMenuInfo set mobxrouteurl = '',iconClassName = '',fullrouteurl='/spa/hrm/static4engine/engine.html#/hrmengine/postNumberSet' where id = 100165;
|
|
/ |