-- 删除原有的编码规则数据
DELETE FROM T_CR_CodeRule WHERE FID = '1CWLWUAR1D4U';
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '1CWLWUAR19F0';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '1CWLWUE67R9T';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '1CWLWUE67R9U';

-- 预置新的编码规则数据
DELETE FROM T_CR_CodeRule WHERE FID = '1FICO5H3QEFL';
INSERT INTO T_CR_CodeRule(FID,FCTRLMODE,FSPLITSIGN,FEXAMPLE,FDISABLEDATE,FAPPMODE,FISADDVIEW,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FISUPDATERECOVER,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('1FICO5H3QEFL','1','-',' ',NULL,'2','1','1FICO5H3QEFL','C','1FICCEL=CGXU',NULL,' ',{ts'2021-03-03  10:22:48'},'fpm_subjectmember','1',0,'1',{ts'2021-03-03  10:22:48'},0,NULL); 

DELETE FROM T_CR_CodeRule_L WHERE FPKID = '1FICO5H3PJST';
INSERT INTO T_CR_CodeRule_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('1FICO5H3QEFL','1FICO5H3PJST','zh_CN','计划科目编码规则'); 
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '1FICO5H3PJSS';
INSERT INTO T_CR_CodeRule_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('1FICO5H3QEFL','1FICO5H3PJSS','zh_TW','計劃科目編碼規則'); 

DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '1FICO5HOGXLO';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1FICO5H3QEFL',1,'1',' ','0','1FICO5HOGXLO',1,'1','1',0,8,'1','AC',' ','1',' ','0',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '1FICO5HOGXLP';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1FICO5H3QEFL',1,'8','-','0','1FICO5HOGXLP',1,'1','3',1,8,'1',' ',' ','1','bodysysmanage.number','1',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '1FICO5HOGXLQ';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1FICO5H3QEFL',1,'16','-','0','1FICO5HOGXLQ',1,'1',' ',2,3,'1',' ',' ','1',' ','1',' '); 
