--删除旧的调出和调入单编码规则
DELETE from t_cr_coderule where fid = '2/9ZK4VFGAH9';
DELETE from t_cr_coderule_l where fid = '2/9ZK4VFGAH9';
DELETE from t_cr_coderuleentry where fid = '2/9ZK4VFGAH9';

DELETE from t_cr_coderule where fid = '2/9ZGRCBTTQ9';
DELETE from t_cr_coderule_l where fid = '2/9ZGRCBTTQ9';
DELETE from t_cr_coderuleentry where fid = '2/9ZGRCBTTQ9';

--新的调入编码规则
DELETE from t_cr_coderule where fid = '2BHY+EW00NBW';
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) VALUES ( '2BHY+EW00NBW','2BHXQ=84W510','hdm_transferinbill','-','1','2',' ',' ','1','C', 0,{ts'2022-03-31 09:48:25'},1213757520569454592,{ts'2022-03-31 09:48:25'},'2BHY+EW00NBW','0','1','0','0','0','0','1','0','0','1');
DELETE from t_cr_coderule_l where fid = '2BHY+EW00NBW';
INSERT INTO t_cr_coderule_l(FPKID, FID, FLOCALEID, FNAME) VALUES ('2BHY+EW00TE6','2BHY+EW00NBW','zh_CN','调入申请');
DELETE from t_cr_coderuleentry where fid = '2BHY+EW00NBW';
INSERT t_cr_coderuleentry(FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('2BHY+EXI1=F2','2BHY+EW00NBW',0,'1','1',' ','TRI',' ',8,1,1,' ','0','1','1','0',' ','1');
INSERT t_cr_coderuleentry(FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('2BHY+EXI1=F3','2BHY+EW00NBW',1,'9',' ',' ','yyyyMMdd',' ',8,1,1,' ','1','1','1','1','-','1');
INSERT t_cr_coderuleentry(FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('2BHY+EXI1=F4','2BHY+EW00NBW',2,'16',' ',' ',' ',' ',5,1,1,' ','1','1','1','0','-','1');

--新的调出编码规则
DELETE from t_cr_coderule where fid = '2BHYVQIK2V0H';
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) VALUES ( '2BHYVQIK2V0H','2BHYN5CB/EF9','hdm_transferoutbill','-','1','2',' ',' ','1','C', 0,{ts'2022-03-31 09:57:46'},1213757520569454592,{ts'2022-03-31 09:57:46'},'2BHYVQIK2V0H','0','1','0','0','0','0','1','0','0','1');
DELETE from t_cr_coderule_l where fid = '2BHYVQIK2V0H';
INSERT INTO t_cr_coderule_l(FPKID, FID, FLOCALEID, FNAME) VALUES ('2BHYVQIK3/2T','2BHYVQIK2V0H','zh_CN','调出申请');
DELETE from t_cr_coderuleentry where fid = '2BHYVQIK2V0H';
INSERT t_cr_coderuleentry(FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('2BHYVQJ7GRD2','2BHYVQIK2V0H',0,'1','1',' ','TRO',' ',8,1,1,' ','0','1','1','0',' ','1');
INSERT t_cr_coderuleentry(FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('2BHYVQJ7GRD3','2BHYVQIK2V0H',1,'9',' ',' ','yyyyMMdd',' ',8,1,1,' ','1','1','1','1','-','1');
INSERT t_cr_coderuleentry(FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('2BHYVQJ7GRD4','2BHYVQIK2V0H',2,'16',' ',' ',' ',' ',5,1,1,' ','1','1','1','0','-','1');
