
/** 立项单 编号规则**/
DELETE FROM t_cr_coderule WHERE FID = '1GL6/8QKNQHJ';
DELETE FROM t_cr_coderule WHERE FID = '1HE90MWD5TB4';
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1GL6/8S1OCKS';
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1GL6/8S1OCKT';
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1GL6/8S1OCKR';
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1HEBJXOZ0559';
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1HEBJXOZ055=';
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1HEBJXOZ055A';
DELETE FROM t_cr_coderule_l WHERE FPKID = '1GL6/8QK8SEM';
DELETE FROM t_cr_coderule_l WHERE FPKID = '1HE90MWD5UOO';


DELETE FROM t_cr_coderule WHERE fid = '1O8TYTHVA21Y';
INSERT INTO t_cr_coderule(fexample,fappmode,fisaddview,fisappcondition,fmasterid,fisunique,fruletype,fismodifiable,fcreatetime,fbizobjectid,fisupdaterecover,fenable,fisapporg,fisserialnumber,fdisablerid,fischeckcode,fid,fsplitsign,fctrlmode,fdisabledate,fislog,fstatus,fnumber,fexamplelength,fisfast,fmodifierid,fisnonbreak,fmodifytime,fcreatorid) VALUES (' ','2','1','1','1O8TYTHVA21Y','0',NULL,'0',{ts'2021-06-09  00:00:00'},'er_applyprojectbill','0','1','0','1',NULL,'0','1O8TYTHVA21Y','-','1',NULL,'0','C','1O8TOKEBN7S7',' ','0',0,'1',{ts'2021-06-09  00:00:00'},0);
DELETE FROM t_cr_coderule WHERE fid = '1O8U7BT/R1X8';
INSERT INTO t_cr_coderule(fexample,fappmode,fisaddview,fisappcondition,fmasterid,fisunique,fruletype,fismodifiable,fcreatetime,fbizobjectid,fisupdaterecover,fenable,fisapporg,fisserialnumber,fdisablerid,fischeckcode,fid,fsplitsign,fctrlmode,fdisabledate,fislog,fstatus,fnumber,fexamplelength,fisfast,fmodifierid,fisnonbreak,fmodifytime,fcreatorid) VALUES (' ','2','1','1','1O8U7BT/R1X8','0',NULL,'0',{ts'2021-06-09  00:00:00'},'er_applyprojectbill','0','1','0','1',NULL,'0','1O8U7BT/R1X8','-','1',NULL,'0','C','1O8U3I/GW==F',' ','0',1155766321963628544,'1',{ts'2021-06-09  00:00:00'},0);

DELETE FROM t_cr_coderuleentry WHERE fentryid = '1O8TYTJBAQ54';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fstep,fcutstyle,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1O8TYTHVA21Y',1,'1',' ','0','1O8TYTJBAQ54',1,'1','1',0,'1',8,'LXSQ','1',' ',' ','0',' ');
DELETE FROM t_cr_coderuleentry WHERE fentryid = '1O8TYTJBAQ55';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fstep,fcutstyle,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1O8TYTHVA21Y',1,'2','-','1','1O8TYTJBAQ55',1,'1',' ',1,'1',8,'yyyyMMdd','1',' ','bizdate','1',' ');
DELETE FROM t_cr_coderuleentry WHERE fentryid = '1O8TYTJBAQ56';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fstep,fcutstyle,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1O8TYTHVA21Y',1,'16','-','0','1O8TYTJBAQ56',1,'1',' ',2,'1',6,' ','1',' ',' ','1',' ');

DELETE FROM t_cr_coderuleentry WHERE fentryid = '1O94H8381EOK';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fstep,fcutstyle,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1O8U7BT/R1X8',1,'1',' ','0','1O94H8381EOK',1,'1','1',0,'1',8,'LXBG','1',' ',' ','0',' ');
DELETE FROM t_cr_coderuleentry WHERE fentryid = '1O94H8381EOL';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fstep,fcutstyle,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1O8U7BT/R1X8',1,'2','-','1','1O94H8381EOL',1,'1',' ',1,'1',8,'yyyyMMdd','1',' ','bizdate','1',' ');
DELETE FROM t_cr_coderuleentry WHERE fentryid = '1O94H8381EOM';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fstep,fcutstyle,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1O8U7BT/R1X8',1,'16','-','0','1O94H8381EOM',1,'1',' ',2,'1',6,' ','1',' ',' ','1',' ');

DELETE FROM t_cr_coderule_l WHERE fpkid = '1O8TYTHVAMM4';
INSERT INTO t_cr_coderule_l(fid,fpkid,flocaleid,fname) VALUES ('1O8TYTHVA21Y','1O8TYTHVAMM4','zh_CN','立项单');
DELETE FROM t_cr_coderule_l WHERE fpkid = '1O8U7BT3D0N+';
INSERT INTO t_cr_coderule_l(fid,fpkid,flocaleid,fname) VALUES ('1O8U7BT/R1X8','1O8U7BT3D0N+','zh_CN','立项变更单');

/** 编号规则适用条件属性 **/

DELETE FROM t_cr_appcondpro WHERE FID = '1HEB9EPX+9A4';
DELETE FROM t_cr_appcondpro_l WHERE FPKID = '1HEB9EPX+=NN';
DELETE FROM t_cr_appcondpro_l WHERE FPKID = '1HEB9EPX+=NO';

DELETE FROM t_cr_appcondpro WHERE fid = '1O93QX8JE27M';
INSERT INTO t_cr_appcondpro(fid,fbizobjectid,fnumber) VALUES ('1O93QX8JE27M','er_applyprojectbill','detailtype');
DELETE FROM t_cr_appcondpro_l WHERE fpkid = '1O93QX8JDIOE';
INSERT INTO t_cr_appcondpro_l(fid,fpkid,flocaleid,fdescription,fname) VALUES ('1O93QX8JE27M','1O93QX8JDIOE','zh_CN','立项类型','立项类型');
DELETE FROM t_cr_appcondpro_l WHERE fpkid = '1O93QX8JDIOF';
INSERT INTO t_cr_appcondpro_l(fid,fpkid,flocaleid,fdescription,fname) VALUES ('1O93QX8JE27M','1O93QX8JDIOF','zh_TW','立項類型','立項類型');

/** 编号规则适用条件属性值 **/

DELETE FROM t_cr_appcondprovalue WHERE FID = '1HEBD8Q=99D7';
DELETE FROM t_cr_appcondprovalue WHERE FID = '1HEBFS2IXNRP';
DELETE FROM t_cr_appcondprovalue_l WHERE FPKID = '1HEBD8Q=9=QQ';
DELETE FROM t_cr_appcondprovalue_l WHERE FPKID = '1HEBD8Q=9=QR';
DELETE FROM t_cr_appcondprovalue_l WHERE FPKID = '1HEBFS2IXP37';
DELETE FROM t_cr_appcondprovalue_l WHERE FPKID = '1HEBFS2IXP38';


DELETE FROM t_cr_appcondprovalue WHERE fid = '1O9423KWUJ8I';
INSERT INTO t_cr_appcondprovalue(fid,fvalue,fappcondproid) VALUES ('1O9423KWUJ8I','biztype_applybill','1O93QX8JE27M');
DELETE FROM t_cr_appcondprovalue WHERE fid = '1O9456H5O82B';
INSERT INTO t_cr_appcondprovalue(fid,fvalue,fappcondproid) VALUES ('1O9456H5O82B','biztype_changebill','1O93QX8JE27M');
DELETE FROM t_cr_appcondprovalue WHERE fid = '1O947SZR=FV1';
INSERT INTO t_cr_appcondprovalue(fid,fvalue,fappcondproid) VALUES ('1O947SZR=FV1','biztype_sharebill','1O93QX8JE27M');

DELETE FROM t_cr_appcondprovalue_l WHERE fpkid = '1O9423KWU+PA';
INSERT INTO t_cr_appcondprovalue_l(fid,fpkid,flocaleid,fdescription,fname) VALUES ('1O9423KWUJ8I','1O9423KWU+PA','zh_CN','立项申请','立项申请');
DELETE FROM t_cr_appcondprovalue_l WHERE fpkid = '1O9423KWU+PB';
INSERT INTO t_cr_appcondprovalue_l(fid,fpkid,flocaleid,fdescription,fname) VALUES ('1O9423KWUJ8I','1O9423KWU+PB','zh_TW','立項申請','立項申請');

DELETE FROM t_cr_appcondprovalue_l WHERE fpkid = '1O9456H5NOJ4';
INSERT INTO t_cr_appcondprovalue_l(fid,fpkid,flocaleid,fdescription,fname) VALUES ('1O9456H5O82B','1O9456H5NOJ4','zh_CN','立项变更','立项变更');
DELETE FROM t_cr_appcondprovalue_l WHERE fpkid = '1O9456H5NOJ5';
INSERT INTO t_cr_appcondprovalue_l(fid,fpkid,flocaleid,fdescription,fname) VALUES ('1O9456H5O82B','1O9456H5NOJ5','zh_TW','立項變更','立項變更');

DELETE FROM t_cr_appcondprovalue_l WHERE fpkid = '1O947SZR9X=V';
INSERT INTO t_cr_appcondprovalue_l(fid,fpkid,flocaleid,fdescription,fname) VALUES ('1O947SZR=FV1','1O947SZR9X=V','zh_CN','立项分摊','立项分摊');
DELETE FROM t_cr_appcondprovalue_l WHERE fpkid = '1O947SZR9X=W';
INSERT INTO t_cr_appcondprovalue_l(fid,fpkid,flocaleid,fdescription,fname) VALUES ('1O947SZR=FV1','1O947SZR9X=W','zh_TW','立項分攤','立項分攤');


/** 编号规则适用条件基础资料列表**/

DELETE FROM T_CR_AppCondition WHERE FENTRYID = '1HEBJTGCZ7V1';
DELETE FROM T_CR_AppCondition WHERE FENTRYID = '1HVV25TA8120';


DELETE FROM T_CR_AppCondition WHERE fentryid = '1O94G1ZG=FIS';
INSERT INTO T_CR_AppCondition(fid,fproperty,fentryid,fseq,fpropertyvalue) VALUES ('1O8TYTHVA21Y','1O93QX8JE27M','1O94G1ZG=FIS',1,'1O9423KWUJ8I');
DELETE FROM T_CR_AppCondition WHERE fentryid = '1O94H3V9KR=+';
INSERT INTO T_CR_AppCondition(fid,fproperty,fentryid,fseq,fpropertyvalue) VALUES ('1O8U7BT/R1X8','1O93QX8JE27M','1O94H3V9KR=+',1,'1O9456H5O82B');


