delete from SystemRightDetail where rightid =2725
GO
delete from SystemRightsLanguage where id =2725
GO
delete from SystemRights where id =2725
GO
delete from SystemRightToGroup where rightid =2725
GO
delete from SystemRightType where id =37
GO
delete from SystemRightGroups where id =-23
GO
insert into SystemRights (id,rightdesc,righttype,detachable) values (2725,'人员字段定义','37',0)
GO
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2725,8,'Personnel Field Definition','Personnel Field Definition')
GO
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2725,9,'人員字段定義','人員字段定義')
GO
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2725,7,'人员字段定义','人员字段定义')
GO

insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (44002,'人员字段定义权限','ResourceField:All',2725)
GO

insert into SystemRightToGroup(rightid,groupid) values (2725,-23)
GO
insert into SystemRightGroups (id,rightgroupmark, rightgroupname, rightgroupremark) values(-23,'ORGANIZATION','组织管理权限组','组织管理')
GO
insert into SystemRightType(id,rightTypeName,rightTypeDesc) VALUES (37,'组织管理','组织管理')
GO

delete from SystemRightDetail where rightid =2726
GO
delete from SystemRightsLanguage where id =2726
GO
delete from SystemRights where id =2726
GO
delete from SystemRightToGroup where rightid =2726
GO
delete from SystemRightType where id =37
GO
delete from SystemRightGroups where id =-23
GO
insert into SystemRights (id,rightdesc,righttype,detachable) values (2726,'花名册','37',0)
GO
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2726,8,'roster','roster')
GO
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2726,9,'花名册','花名册')
GO
insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values (2726,7,'花名册','花名册')
GO

insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values (44003,'花名册权限','Roster:All',2726)
GO

insert into SystemRightToGroup(rightid,groupid) values (2726,-23)
GO
insert into SystemRightGroups (id,rightgroupmark, rightgroupname, rightgroupremark) values(-23,'ORGANIZATION','组织管理权限组','组织管理')
GO
insert into SystemRightType(id,rightTypeName,rightTypeDesc) VALUES (37,'组织管理','组织管理')
GO

Delete from LeftMenuInfo where id=100152
GO
Delete from LeftMenuConfig where infoid=100152
GO
EXECUTE LMConfig_U_ByInfoInsert 2,100147,3
GO
EXECUTE LMInfo_Insert 100152,512838,'','',2,100147,3,2
GO
update LeftMenuInfo set mobxrouteurl = '',iconClassName = '',fullrouteurl='/spa/organization/static/index.html#/main/organization/resource' where id = 100152
GO

Delete from LeftMenuInfo where id=100171
GO
Delete from LeftMenuConfig where infoid=100171
GO
EXECUTE LMConfig_U_ByInfoInsert 2,100167,2
GO
EXECUTE LMInfo_Insert 100171,538767,'','',2,100167,2,2
GO
update LeftMenuInfo set mobxrouteurl = '',iconClassName = '',fullrouteurl='/spa/organization/static/index.html#/main/organization/fieldDef/resource' where id = 100171
GO

Delete from LeftMenuInfo where id=100174
GO
Delete from LeftMenuConfig where infoid=100174
GO
EXECUTE LMConfig_U_ByInfoInsert 2,100139,3
GO
EXECUTE LMInfo_Insert 100174,539196,'','',2,100139,3,2
GO
update LeftMenuInfo set mobxrouteurl = '',iconClassName = '',fullrouteurl='' where id = 100174
GO

Delete from LeftMenuInfo where id=100175
GO
Delete from LeftMenuConfig where infoid=100175
GO
EXECUTE LMConfig_U_ByInfoInsert 2,100174,-1
GO
EXECUTE LMInfo_Insert 100175,539197,'','',2,100174,-1,2
GO
update LeftMenuInfo set mobxrouteurl = '',iconClassName = '',fullrouteurl='/spa/organization/static/index.html#/main/organization/resourceBasicInfo' where id = 100175
GO

delete from HtmlLabelIndex where id = 539196 and ( indexdesc is null or indexdesc = '' )
GO
insert into HtmlLabelIndex(id,indexdesc) select top 1 539196,'人员管理' from HtmlLabelIndex where not exists (select id from HtmlLabelIndex where id = 539196 and ( indexdesc is not null and indexdesc <> '' ))
GO
delete from HtmlLabelInfo where indexid = 539196 and languageid=7 and ( labelname is null or labelname = '' )
GO
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select top 1 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 ( labelname is not null and labelname <> '' ))
GO
delete from HtmlLabelInfo where indexid = 539196 and languageid=8 and ( labelname is null or labelname = '' or labelname like '%[吖-座]%' )
GO
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select top 1 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 ( labelname is not null and labelname <> '' and labelname not like '%[吖-座]%' ))
GO
delete from HtmlLabelInfo where indexid = 539196 and languageid=9 and ( labelname is null or labelname = '' )
GO
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select top 1 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 ( labelname is not null and labelname <> '' ))
GO



delete from HtmlLabelIndex where id = 539197 and ( indexdesc is null or indexdesc = '' )
GO
insert into HtmlLabelIndex(id,indexdesc) select top 1 539197,'人员信息' from HtmlLabelIndex where not exists (select id from HtmlLabelIndex where id = 539197 and ( indexdesc is not null and indexdesc <> '' ))
GO
delete from HtmlLabelInfo where indexid = 539197 and languageid=7 and ( labelname is null or labelname = '' )
GO
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select top 1 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 ( labelname is not null and labelname <> '' ))
GO
delete from HtmlLabelInfo where indexid = 539197 and languageid=8 and ( labelname is null or labelname = '' or labelname like '%[吖-座]%' )
GO
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select top 1 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 ( labelname is not null and labelname <> '' and labelname not like '%[吖-座]%' ))
GO
delete from HtmlLabelInfo where indexid = 539197 and languageid=9 and ( labelname is null or labelname = '' )
GO
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select top 1 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 ( labelname is not null and labelname <> '' ))
GO