在NC系统中,做了离职是不能反操作的,但是可以通过如下SQL进行修改。脚本如下,请根据实际情况做适配(无开发经验建议不要随意操作,否则后果自负)
select * from hi_psnjob where begindate='2019-06-12' and pk_psndoc =(select pk_psndoc from bd_psndoc where code ='GF2018003')
--update hi_psnjob set trnstype ='3', poststat ='Y', endflag ='N',ismainjob='Y',lastflag ='Y' where begindate='2019-06-12' and pk_psndoc =(select pk_psndoc from bd_psndoc where code ='GF2018003')
select * from hi_psnorg where pk_psndoc =(select pk_psndoc from bd_psndoc where code ='GF2018003')
--update hi_psnorg set lastflag = 'Y', endflag='N',enddate='' where pk_psndoc =(select pk_psndoc from bd_psndoc where code ='GF2018003')