delete from SystemRightDetail where rightid =2725; / delete from SystemRightsLanguage where id =2725; / delete from SystemRights where id =2725; / delete from SystemRightToGroup where rightid =2725; / delete from SystemRightType where id =37; / delete from SystemRightGroups where id =-23; / insert into SystemRights (id,rightdesc,righttype,detachable) values (2725,'人员字段定义','37',0); / insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2725,8,'Personnel Field Definition','Personnel Field Definition'); / insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2725,9,'人員字段定義','人員字段定義'); / insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2725,7,'人员字段定义','人员字段定义'); / Delete from LeftMenuInfo where id=100152; / Delete from LeftMenuConfig where infoid=100152; / call LMConfig_U_ByInfoInsert (2,100147,3); / call LMInfo_Insert (100152,512838,'','',2,100147,3,2); / update LeftMenuInfo set mobxrouteurl = '',iconClassName = '',fullrouteurl='/spa/organization/static/index.html#/main/organization/resource' where id = 100152; / insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (44002,'人员字段定义权限','ResourceField:All',2725); / insert into SystemRightToGroup(rightid,groupid) values (2725,-23); / insert into SystemRightGroups (id,rightgroupmark, rightgroupname, rightgroupremark) values(-23,'ORGANIZATION','组织管理权限组','组织管理'); / insert into SystemRightType(id,rightTypeName,rightTypeDesc) VALUES (37,'组织管理','组织管理'); / delete from SystemRightDetail where rightid =2726; / delete from SystemRightsLanguage where id =2726; / delete from SystemRights where id =2726; / delete from SystemRightToGroup where rightid =2726; / delete from SystemRightType where id =37; / delete from SystemRightGroups where id =-23; / insert into SystemRights (id,rightdesc,righttype,detachable) values (2726,'花名册','37',0); / insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2726,8,'roster','roster'); / insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2726,9,'花名册','花名册'); / insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2726,7,'花名册','花名册'); / insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (44003,'花名册权限','Roster:All',2726); / insert into SystemRightToGroup(rightid,groupid) values (2726,-23); / insert into SystemRightGroups (id,rightgroupmark, rightgroupname, rightgroupremark) values(-23,'ORGANIZATION','组织管理权限组','组织管理'); / insert into SystemRightType(id,rightTypeName,rightTypeDesc) VALUES (37,'组织管理','组织管理'); / Delete from LeftMenuInfo where id=100171; / Delete from LeftMenuConfig where infoid=100171; / call LMConfig_U_ByInfoInsert (2,100167,2); / call LMInfo_Insert (100171,538767,'','',2,100167,2,2); / update LeftMenuInfo set mobxrouteurl = '',iconClassName = '',fullrouteurl='/spa/organization/static/index.html#/main/organization/fieldDef/resource' where id = 100171; / Delete from LeftMenuInfo where id=100174; / Delete from LeftMenuConfig where infoid=100174; / call LMConfig_U_ByInfoInsert (2,100139,3); / call LMInfo_Insert (100174,539196,'','',2,100139,3,2); / update LeftMenuInfo set mobxrouteurl = '',iconClassName = '',fullrouteurl='' where id = 100174; / Delete from LeftMenuInfo where id=100175; / Delete from LeftMenuConfig where infoid=100175; / call LMConfig_U_ByInfoInsert (2,100174,-1); / call LMInfo_Insert (100175,539197,'','',2,100174,-1,2); / update LeftMenuInfo set mobxrouteurl = '',iconClassName = '',fullrouteurl='/spa/organization/static/index.html#/main/organization/resourceBasicInfo' where id = 100175; / delete from HtmlLabelIndex where id = 539196 and ( trim(indexdesc) is null ); / insert into HtmlLabelIndex(id,indexdesc) select 539196,'人员管理' from HtmlLabelIndex where not exists (select id from HtmlLabelIndex where id = 539196 and ( trim(indexdesc) is not null )) and rownum = 1; / delete from HtmlLabelInfo where indexid = 539196 and languageid=7 and ( trim(labelname) is null ); / insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 539196 as indexid ,'人员管理' as content,7 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 539196 and languageid=7 and ( trim(labelname) is not null )) and rownum = 1; / delete from HtmlLabelInfo where indexid = 539196 and languageid=8 and ( trim(labelname) is null or length(labelname)!=lengthb(labelname) ); / insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 539196 as indexid ,'Personnel management' as content,8 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 539196 and languageid=8 and ( trim(labelname) is not null and length(labelname)=lengthb(labelname) )) and rownum = 1; / delete from HtmlLabelInfo where indexid = 539196 and languageid=9 and ( trim(labelname) is null ); / insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 539196 as indexid ,'人員管理' as content,9 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 539196 and languageid=9 and ( trim(labelname) is not null )) and rownum = 1; / delete from HtmlLabelIndex where id = 539197 and ( trim(indexdesc) is null ); / insert into HtmlLabelIndex(id,indexdesc) select 539197,'人员信息' from HtmlLabelIndex where not exists (select id from HtmlLabelIndex where id = 539197 and ( trim(indexdesc) is not null )) and rownum = 1; / delete from HtmlLabelInfo where indexid = 539197 and languageid=7 and ( trim(labelname) is null ); / insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 539197 as indexid ,'人员信息' as content,7 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 539197 and languageid=7 and ( trim(labelname) is not null )) and rownum = 1; / delete from HtmlLabelInfo where indexid = 539197 and languageid=8 and ( trim(labelname) is null or length(labelname)!=lengthb(labelname) ); / insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 539197 as indexid ,'Personnel information' as content,8 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 539197 and languageid=8 and ( trim(labelname) is not null and length(labelname)=lengthb(labelname) )) and rownum = 1; / delete from HtmlLabelInfo where indexid = 539197 and languageid=9 and ( trim(labelname) is null ); / insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 539197 as indexid ,'人員信息' as content,9 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 539197 and languageid=9 and ( trim(labelname) is not null )) and rownum = 1; /