-- 核定人员范围 编码规则
DELETE FROM T_CR_CodeRule WHERE FID = '3HHO8FE0=872';
INSERT INTO T_CR_CodeRule(FFILTERCONDITION,FISMATCHCODERULE,FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FISCHECKCODE,FID,FCTRLMODE,FSPLITSIGN,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID,FCONDITIONDESC) VALUES (' ','0',' ','2','1','0','3HHO8FE0=872','0','0',{ts'2023-08-18  00:00:00'},'hpdi_verrange','1','0','0','1','0','3HHO8FE0=872','1',' ','0','C','3HHNOG5YJT5V',' ','1',1632628417327399936,'0',{ts'2023-08-18  00:00:00'},0,' '); 
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '3HHO8FE0=AKC';
INSERT INTO T_CR_CodeRule_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3HHO8FE0=872','3HHO8FE0=AKC','zh_CN','核定人员范围_编码'); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '3HHO=4BMO7PG';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3HHO8FE0=872',1,'1',' ','0','3HHO=4BMO7PG',1,'1','1',0,8,'1','HPDIR','1',' ',' ','0',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '3HHO=4BMO7PH';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3HHO8FE0=872',1,'9',' ','1','3HHO=4BMO7PH',1,'1',' ',1,8,'1','yyyyMMdd','1',' ',' ','0',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '3HHO=4BMO7PI';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3HHO8FE0=872',1,'16',' ','0','3HHO=4BMO7PI',1,'1',' ',2,4,'1',' ','1',' ',' ','0',' '); 



DELETE FROM T_CR_CodeRule WHERE FID = '3IFQBF/A7OQT';
INSERT INTO T_CR_CodeRule(FFILTERCONDITION,FISMATCHCODERULE,FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FISCHECKCODE,FID,FCTRLMODE,FSPLITSIGN,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID,FCONDITIONDESC) VALUES (' ','0',' ','2','1','0','3IFQBF/A7OQT','0','0',{ts'2023-08-29  00:00:00'},'hpdi_verrangepolicy','1','0','0','1','0','3IFQBF/A7OQT','1',' ','0','C','3IFQ9OR+LBKP',' ','1',1632628417327399936,'0',{ts'2023-08-29  00:00:00'},0,' '); 
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '3IFQBF/A7O1J';
INSERT INTO T_CR_CodeRule_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3IFQBF/A7OQT','3IFQBF/A7O1J','zh_CN','核定人员范围策略_编码'); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '3IGDIO57QQ0I';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3IFQBF/A7OQT',1,'1',' ','0','3IGDIO57QQ0I',1,'1','1',0,8,'1','HPDIP','1',' ',' ','0',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '3IGDIO57QQ0J';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3IFQBF/A7OQT',1,'9',' ','1','3IGDIO57QQ0J',1,'1',' ',1,8,'1','yyyyMMdd','1',' ',' ','0',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '3IGDIO57QQ0K';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3IFQBF/A7OQT',1,'16',' ','0','3IGDIO57QQ0K',1,'1',' ',2,4,'1',' ','1',' ',' ','0',' '); 