--支援工卡预制编码规则
DELETE FROM t_cr_coderule WHERE FID = '2I=J7JFJA7R4';
INSERT INTO t_cr_coderule(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FRULETYPE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FDISABLERID,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FDISABLEDATE,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','2I=J7JFJA7R4','0',NULL,'0',{ts'2018-08-08  00:00:00'},'pom_mrosupportcrad','1','0','0','0',NULL,'0','2I=J7JFJA7R4','-','1',NULL,'0','C','2I=J41TMO8HP',' ','0',1,'0',{ts'2018-08-08  00:00:00'},1); 

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2I=KUV2I6VL6';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FISVISABLE,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2I=J7JFJA7R4',1,'1',' ','0','2I=KUV2I6VL6','1',1,'1','1',0,8,'ZYGK',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2I=KUV2I6VL7';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FISVISABLE,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2I=J7JFJA7R4',1,'9','-','0','2I=KUV2I6VL7','1',1,'1',' ',1,8,'yyyyMMdd',' ','1',' ','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2I=KUV2I6VL8';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FISVISABLE,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2I=J7JFJA7R4',1,'10','-','0','2I=KUV2I6VL8','1',1,'1',' ',2,8,' ',' ','1',' ','1',' '); 

DELETE FROM t_cr_coderule_l WHERE FPKID = '2I=J7JFJA71W';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2I=J7JFJA7R4','2I=J7JFJA71W','zh_CN','支援工卡'); 

--零部件工卡预制编码规则
DELETE FROM t_cr_coderule WHERE FID = '2I=KRCI72HR3';
INSERT INTO t_cr_coderule(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FRULETYPE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FDISABLERID,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FDISABLEDATE,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','2I=KRCI72HR3','0',NULL,'0',{ts'2018-08-08  00:00:00'},'pom_mropartcard','1','0','0','0',NULL,'0','2I=KRCI72HR3','-','1',NULL,'0','C','2I=KNE/Z5RM0',' ','0',1,'0',{ts'2018-08-08  00:00:00'},1); 

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2I=KT5ET1J/2';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FISVISABLE,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2I=KRCI72HR3',1,'1',' ','0','2I=KT5ET1J/2','1',1,'1','1',0,8,'LBJGK',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2I=KT5ET1J/3';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FISVISABLE,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2I=KRCI72HR3',1,'9','-','0','2I=KT5ET1J/3','1',1,'1',' ',1,8,'yyyyMMdd',' ','1',' ','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2I=KT5ET1J/4';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FISVISABLE,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2I=KRCI72HR3',1,'10','-','0','2I=KT5ET1J/4','1',1,'1',' ',2,8,' ',' ','1',' ','1',' '); 

DELETE FROM t_cr_coderule_l WHERE FPKID = '2I=KRCI72IEC';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2I=KRCI72HR3','2I=KRCI72IEC','zh_CN','零部件工卡'); 
