
--项目变更单编码规则
DELETE FROM t_cr_coderule WHERE FID = '2AUDRM51Q0TX';
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','2AUDRM51Q0TX','0',NULL,'0',{ts'2022-03-23  00:00:00'},'pmpd_changeproject','1','0','0','1',NULL,'0','2AUDRM51Q0TX','-','1',NULL,'0','C','2AUDH=IL01AE',' ','1',13466739,'1',{ts'2022-03-29  00:00:00'},0);




DELETE FROM t_cr_coderule_l WHERE FPKID = '2AUDRM51Q1H5';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2AUDRM51Q0TX','2AUDRM51Q1H5','zh_CN','项目变更单');

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2BC=2FU/WFC9';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2AUDRM51Q0TX',1,'1',' ','0','2BC=2FU/WFC9',1,'1','1',0,8,'1','XMBG',' ','1',' ','0',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2BC=2FU/WFC=';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2AUDRM51Q0TX',1,'9','-','0','2BC=2FU/WFC=',1,'1',' ',1,8,'1','yyMMdd',' ','1',' ','1',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2BC=2FU/WFCA';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2AUDRM51Q0TX',1,'16','-','0','2BC=2FU/WFCA',1,'1',' ',2,3,'1',' ',' ','1',' ','1',' ');


--项目变更单管控策略
DELETE FROM T_BD_DefaultCtrlStrategy WHERE FID = 1383337718624304128;
INSERT INTO T_BD_DefaultCtrlStrategy(FID,FCTRLVIEW,FDEFAULTMANAGESTRATEGY,FDATATYPE,FDISABLEDATE,FMASTERID,FSTATUS,FAPPSYSTEMID,FMASTERIDFIELDNAME,FNUMBER,FDEFAULTCTRLSTRATEGY,FBASEDATAID,FCREATETIME,FUPGRADESTATUS,FENABLE,FMODIFIERID,FISSYNCDATA,FPLUGIN,FMODIFYTIME,FMASTERIDPROPNAME,FCREATORID,FISSYSTEM,FDISABLERID) VALUES (1383337718624304128,976024345958766592,'1','2',NULL,1383337718624304128,'A','064+L=UVGI9P','fmasterid',' ','5','pmpd_changeproject',{ts'2022-03-24  00:00:00'},' ','1',1,'0',' ',{ts'2022-03-24  00:00:00'},'masterid',1,'0',0);

DELETE FROM t_cr_coderule WHERE FID = '0ZO4O5B7DFFN';
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 (' ','3','1','0','0ZO4O5B7DFFN','0',NULL,'0',{ts'2020-08-03  00:00:00'},'pmpd_project','1','0','0','1',NULL,'0','0ZO4O5B7DFFN','-','1',NULL,'0','C','rl_project',' ','1',1373006876316272640,'1',{ts'2022-03-28  00:00:00'},11850374);


DELETE FROM t_cr_coderule_l WHERE FPKID = '0ZO4O5B7DHGF';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0ZO4O5B7DFFN','0ZO4O5B7DHGF','zh_CN','项目_编码规则');

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2B8IS3BVB6HW';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('0ZO4O5B7DFFN',1,'1',' ','0','2B8IS3BVB6HW',1,'1',' ',0,8,'1','XM',' ','1',' ','0',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2B8IS3BVB6HX';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('0ZO4O5B7DFFN',1,'2','-','0','2B8IS3BVB6HX',1,'1',' ',1,8,'1','yyyyMMdd',' ','1','createtime','1',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2B8IS3BVB6HY';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('0ZO4O5B7DFFN',1,'16','-','0','2B8IS3BVB6HY',1,'1',' ',2,3,'1',' ',' ','1',' ','1',' ');
