181 lines
12 KiB
SQL
181 lines
12 KiB
SQL
delete from HtmlLabelIndex where id = 547469 and ( trim(indexdesc) is null ) ;
|
|
/
|
|
|
|
insert into HtmlLabelIndex(id,indexdesc) select 547469,'冻结数不能大于剩余编制数！' from HtmlLabelIndex where not exists (select id from HtmlLabelIndex where id = 547469 and ( trim(indexdesc) is not null )) and rownum = 1 ;
|
|
/
|
|
|
|
delete from HtmlLabelInfo where indexid = 547469 and languageid=7 and ( trim(labelname) is null ) ;
|
|
/
|
|
|
|
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 547469 as indexid ,'冻结数不能大于剩余编制数！' as content,7 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547469 and languageid=7 and ( trim(labelname) is not null )) and rownum = 1 ;
|
|
/
|
|
|
|
delete from HtmlLabelInfo where indexid = 547469 and languageid=8 and ( trim(labelname) is null or length(labelname)!=lengthb(labelname) ) ;
|
|
/
|
|
|
|
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 547469 as indexid ,'The frozen number cannot be greater than the remaining prepare number!' as content,8 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547469 and languageid=8 and ( trim(labelname) is not null and length(labelname)=lengthb(labelname) )) and rownum = 1 ;
|
|
/
|
|
|
|
delete from HtmlLabelInfo where indexid = 547469 and languageid=9 and ( trim(labelname) is null ) ;
|
|
/
|
|
|
|
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 547469 as indexid ,'凍結數不能大於剩餘編製數！' as content,9 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547469 and languageid=9 and ( trim(labelname) is not null )) and rownum = 1 ;
|
|
/
|
|
|
|
delete from HtmlModuleLabel where indexId = 547469 and moduleCode = 'HRM' and type = 'label' ;
|
|
/
|
|
|
|
insert into HtmlModuleLabel(type,moduleCode,indexId) values ('label','HRM',547469) ;
|
|
/
|
|
|
|
delete from HtmlLabelIndex where id = 547470 and ( trim(indexdesc) is null ) ;
|
|
/
|
|
|
|
insert into HtmlLabelIndex(id,indexdesc) select 547470,'强控策略下请先释放当前冻结数后再完成入职操作' from HtmlLabelIndex where not exists (select id from HtmlLabelIndex where id = 547470 and ( trim(indexdesc) is not null )) and rownum = 1 ;
|
|
/
|
|
|
|
delete from HtmlLabelInfo where indexid = 547470 and languageid=7 and ( trim(labelname) is null ) ;
|
|
/
|
|
|
|
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 547470 as indexid ,'强控策略下请先释放当前冻结数后再完成入职操作' as content,7 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547470 and languageid=7 and ( trim(labelname) is not null )) and rownum = 1 ;
|
|
/
|
|
|
|
delete from HtmlLabelInfo where indexid = 547470 and languageid=8 and ( trim(labelname) is null or length(labelname)!=lengthb(labelname) ) ;
|
|
/
|
|
|
|
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 547470 as indexid ,'Under the strong control strategy, please release the current frozen amount before completing the onboarding operation' as content,8 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547470 and languageid=8 and ( trim(labelname) is not null and length(labelname)=lengthb(labelname) )) and rownum = 1 ;
|
|
/
|
|
|
|
delete from HtmlLabelInfo where indexid = 547470 and languageid=9 and ( trim(labelname) is null ) ;
|
|
/
|
|
|
|
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 547470 as indexid ,'強控策略下請先釋放當前凍結數后再完成入職操作' as content,9 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547470 and languageid=9 and ( trim(labelname) is not null )) and rownum = 1 ;
|
|
/
|
|
|
|
delete from HtmlModuleLabel where indexId = 547470 and moduleCode = 'HRM' and type = 'label' ;
|
|
/
|
|
|
|
insert into HtmlModuleLabel(type,moduleCode,indexId) values ('label','HRM',547470) ;
|
|
/
|
|
|
|
delete from HtmlLabelIndex where id = 547471 and ( trim(indexdesc) is null ) ;
|
|
/
|
|
|
|
insert into HtmlLabelIndex(id,indexdesc) select 547471,'强控策略下不容许超编' from HtmlLabelIndex where not exists (select id from HtmlLabelIndex where id = 547471 and ( trim(indexdesc) is not null )) and rownum = 1 ;
|
|
/
|
|
|
|
delete from HtmlLabelInfo where indexid = 547471 and languageid=7 and ( trim(labelname) is null ) ;
|
|
/
|
|
|
|
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 547471 as indexid ,'强控策略下不容许超编' as content,7 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547471 and languageid=7 and ( trim(labelname) is not null )) and rownum = 1 ;
|
|
/
|
|
|
|
delete from HtmlLabelInfo where indexid = 547471 and languageid=8 and ( trim(labelname) is null or length(labelname)!=lengthb(labelname) ) ;
|
|
/
|
|
|
|
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 547471 as indexid ,'Overloading is not allowed under the strong control strategy' as content,8 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547471 and languageid=8 and ( trim(labelname) is not null and length(labelname)=lengthb(labelname) )) and rownum = 1 ;
|
|
/
|
|
|
|
delete from HtmlLabelInfo where indexid = 547471 and languageid=9 and ( trim(labelname) is null ) ;
|
|
/
|
|
|
|
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 547471 as indexid ,'強控策略下不容許超編' as content,9 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547471 and languageid=9 and ( trim(labelname) is not null )) and rownum = 1 ;
|
|
/
|
|
|
|
delete from HtmlModuleLabel where indexId = 547471 and moduleCode = 'HRM' and type = 'label' ;
|
|
/
|
|
|
|
insert into HtmlModuleLabel(type,moduleCode,indexId) values ('label','HRM',547471) ;
|
|
/
|
|
|
|
delete from HtmlLabelIndex where id = 547472 and ( trim(indexdesc) is null ) ;
|
|
/
|
|
|
|
insert into HtmlLabelIndex(id,indexdesc) select 547472,'调整数量不可大于在编数' from HtmlLabelIndex where not exists (select id from HtmlLabelIndex where id = 547472 and ( trim(indexdesc) is not null )) and rownum = 1 ;
|
|
/
|
|
|
|
delete from HtmlLabelInfo where indexid = 547472 and languageid=7 and ( trim(labelname) is null ) ;
|
|
/
|
|
|
|
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 547472 as indexid ,'调整数量不可大于在编数' as content,7 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547472 and languageid=7 and ( trim(labelname) is not null )) and rownum = 1 ;
|
|
/
|
|
|
|
delete from HtmlLabelInfo where indexid = 547472 and languageid=8 and ( trim(labelname) is null or length(labelname)!=lengthb(labelname) ) ;
|
|
/
|
|
|
|
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 547472 as indexid ,'The adjustment quantity cannot be greater than the current number' as content,8 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547472 and languageid=8 and ( trim(labelname) is not null and length(labelname)=lengthb(labelname) )) and rownum = 1 ;
|
|
/
|
|
|
|
delete from HtmlLabelInfo where indexid = 547472 and languageid=9 and ( trim(labelname) is null ) ;
|
|
/
|
|
|
|
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 547472 as indexid ,'調整數量不可大於在編數' as content,9 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547472 and languageid=9 and ( trim(labelname) is not null )) and rownum = 1 ;
|
|
/
|
|
|
|
delete from HtmlModuleLabel where indexId = 547472 and moduleCode = 'HRM' and type = 'label' ;
|
|
/
|
|
|
|
insert into HtmlModuleLabel(type,moduleCode,indexId) values ('label','HRM',547472) ;
|
|
/
|
|
|
|
delete from HtmlLabelIndex where id = 547474 and ( trim(indexdesc) is null ) ;
|
|
/
|
|
|
|
insert into HtmlLabelIndex(id,indexdesc) select 547474,'未查询到对应编制方案下的组织编制信息' from HtmlLabelIndex where not exists (select id from HtmlLabelIndex where id = 547474 and ( trim(indexdesc) is not null )) and rownum = 1 ;
|
|
/
|
|
|
|
delete from HtmlLabelInfo where indexid = 547474 and languageid=7 and ( trim(labelname) is null ) ;
|
|
/
|
|
|
|
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 547474 as indexid ,'未查询到对应编制方案下的组织编制信息' as content,7 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547474 and languageid=7 and ( trim(labelname) is not null )) and rownum = 1 ;
|
|
/
|
|
|
|
delete from HtmlLabelInfo where indexid = 547474 and languageid=8 and ( trim(labelname) is null or length(labelname)!=lengthb(labelname) ) ;
|
|
/
|
|
|
|
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 547474 as indexid ,'The organization''s prepare information under the corresponding prepare scheme is not Query' as content,8 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547474 and languageid=8 and ( trim(labelname) is not null and length(labelname)=lengthb(labelname) )) and rownum = 1 ;
|
|
/
|
|
|
|
delete from HtmlLabelInfo where indexid = 547474 and languageid=9 and ( trim(labelname) is null ) ;
|
|
/
|
|
|
|
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 547474 as indexid ,'未查詢到對應編製方案下的組織編製信息' as content,9 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547474 and languageid=9 and ( trim(labelname) is not null )) and rownum = 1 ;
|
|
/
|
|
|
|
delete from HtmlModuleLabel where indexId = 547474 and moduleCode = 'HRM' and type = 'label' ;
|
|
/
|
|
|
|
insert into HtmlModuleLabel(type,moduleCode,indexId) values ('label','HRM',547474) ;
|
|
/
|
|
|
|
delete from HtmlLabelIndex where id = 547949 and ( trim(indexdesc) is null ) ;
|
|
/
|
|
|
|
insert into HtmlLabelIndex(id,indexdesc) select 547949,'当前冻结数为0,无需释放' from HtmlLabelIndex where not exists (select id from HtmlLabelIndex where id = 547949 and ( trim(indexdesc) is not null )) and rownum = 1 ;
|
|
/
|
|
|
|
delete from HtmlLabelInfo where indexid = 547949 and languageid=7 and ( trim(labelname) is null ) ;
|
|
/
|
|
|
|
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 547949 as indexid ,'当前冻结数为0,无需释放' as content,7 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547949 and languageid=7 and ( trim(labelname) is not null )) and rownum = 1 ;
|
|
/
|
|
|
|
delete from HtmlLabelInfo where indexid = 547949 and languageid=8 and ( trim(labelname) is null or length(labelname)!=lengthb(labelname) ) ;
|
|
/
|
|
|
|
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 547949 as indexid ,'The current frozen number is 0, no need to release it' as content,8 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547949 and languageid=8 and ( trim(labelname) is not null and length(labelname)=lengthb(labelname) )) and rownum = 1 ;
|
|
/
|
|
|
|
delete from HtmlLabelInfo where indexid = 547949 and languageid=9 and ( trim(labelname) is null ) ;
|
|
/
|
|
|
|
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 547949 as indexid ,'當前凍結數為0,無需釋放' as content,9 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547949 and languageid=9 and ( trim(labelname) is not null )) and rownum = 1 ;
|
|
/
|
|
|
|
delete from HtmlModuleLabel where indexId = 547949 and moduleCode = 'HRM' and type = 'label' ;
|
|
/
|
|
|
|
insert into HtmlModuleLabel(type,moduleCode,indexId) values ('label','HRM',547949) ;
|
|
/
|
|
|