DELETE from t_cr_coderule where fid = '2W6A26AU0+4H';
INSERT INTO t_cr_coderule(FID, FNUMBER, FBIZOBJECTID, FSPLITSIGN, FCTRLMODE, FAPPMODE, FEXAMPLE, FEXAMPLELENGTH, FENABLE, FSTATUS, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FMASTERID, FISUPDATERECOVER, FISNONBREAK, FISCHECKCODE, FISAPPCONDITION, FISAPPORG, FISLOG, FISSERIALNUMBER, FISUNIQUE, FISMODIFIABLE, FISADDVIEW, FFILTERCONDITION, FCONDITIONDESC, FISFAST) VALUES ( '2W6A26AU0+4H','2W6=ZFNHHV4C','hom_employeeno',' ','1','2',' ',' ','1','C', 0,{ts'2022-11-18 15:21:58'},1632499274866591744,{ts'2023-03-07 10:59:34'},'2W6A26AU0+4H','0','1','0','0','0','0','1','0','0','1','{"filterRow":[{"id":"33W5AF3X+=Q/","leftBracket":"","compareType":"17","fieldName":"onbrdbill.laborreltype.number","rightBracket":"","logic":"0","value":[{"id":"33W5AF3X+AD9","value":"1010_S"}],"baseDataIds":[{"id":"33W5AF3X+=Q0","value":"1010"}]}],"forList":false}','正式员工','1');
DELETE from t_cr_coderule_l where fid = '2W6A26AU0+4H';
INSERT INTO t_cr_coderule_l(FPKID, FID, FLOCALEID, FNAME) VALUES ('2W6A26AU++Q/','2W6A26AU0+4H','zh_CN','正式员工工号编码规则');
DELETE from t_cr_coderuleentry where fid = '2W6A26AU0+4H';
INSERT INTO t_cr_coderuleentry(FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT,FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('3/1O6+4XG9N+','2W6A26AU0+4H',0,'1','1',' ','EM',' ',8,1,1,' ','0','1','1','0',' ','1');
INSERT INTO t_cr_coderuleentry(FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT,FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('3/1O6+4XG9N/','2W6A26AU0+4H',1,'9',' ',' ','yyyyMMdd',' ',8,1,1,' ','0','1','1','1',' ','1');
INSERT INTO t_cr_coderuleentry(FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT,FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('3/1O6+4XG9N0','2W6A26AU0+4H',2,'16',' ',' ',' ',' ',3,1,1,' ','0','1','1','0',' ','1');


DELETE from t_cr_coderule where fid = '2WMYZ4EA/TV2';
INSERT INTO t_cr_coderule(FID, FNUMBER, FBIZOBJECTID, FSPLITSIGN, FCTRLMODE, FAPPMODE, FEXAMPLE, FEXAMPLELENGTH, FENABLE, FSTATUS, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FMASTERID, FISUPDATERECOVER, FISNONBREAK, FISCHECKCODE, FISAPPCONDITION, FISAPPORG, FISLOG, FISSERIALNUMBER, FISUNIQUE, FISMODIFIABLE, FISADDVIEW, FFILTERCONDITION, FCONDITIONDESC, FISFAST) VALUES ( '2WMYZ4EA/TV2','2WMYX9W1XD8P','hom_employeeno',' ','1','2',' ',' ','1','C', 0,{ts'2022-11-23 17:16:26'},1337677634284329984,{ts'2023-01-03 13:49:37'},'2WMYZ4EA/TV2','0','1','0','0','0','0','1','0','0','1','{"filterRow":[{"id":"3+9TRSQGGGT7","leftBracket":"","compareType":"67","fieldName":"onbrdbill.laborreltype.number","rightBracket":"","logic":"0","value":[{"id":"3+9TRSQGGESF","value":"1020_S"}],"baseDataIds":[{"id":"3+9TRSQGGGT8","value":"1020"}]}],"forList":false}','实习','1');
DELETE from t_cr_coderule_l where fid = '2WMYZ4EA/TV2';
INSERT INTO t_cr_coderule_l(FPKID, FID, FLOCALEID, FNAME) VALUES ('2WMYZ4EDN7CC','2WMYZ4EA/TV2','zh_CN','实习生工号编码规则');
DELETE from t_cr_coderuleentry where fid = '2WMYZ4EA/TV2';
INSERT INTO t_cr_coderuleentry(FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('3+9TS5SWQMVF','2WMYZ4EA/TV2',0,'1','1',' ','I',' ',8,1,1,' ','0','1','1','0',' ','1');
INSERT INTO t_cr_coderuleentry(FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('3+9TS5SWQMVG','2WMYZ4EA/TV2',1,'9',' ',' ','yyyyMMdd',' ',8,1,1,' ','0','1','1','1',' ','1');
INSERT INTO t_cr_coderuleentry(FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('3+9TS5SWQMVH','2WMYZ4EA/TV2',2,'16',' ',' ',' ',' ',3,1,1,' ','0','1','1','0',' ','1');
