/** 立项单 默认单据类型**/
DELETE FROM T_BAS_BILLTYPE WHERE FID = 1112145494488858624;
INSERT INTO T_BAS_BILLTYPE(FID,FISSYSPRESET,FDOCUMENTSTATUS,FDEFWNREPORTTEMPLATE,FISDEFAULT,FDEFPRINTTEMPLATE,FCONTROLPRINTCOUNT,FMASTERID,FSTATUS,FBILLFORMID,FMAXPRINTCOUNT,FBILLCODERULEID,FBILLINITSETTING,FNUMBER,FCREATETIME,FLAYOUTSOLUTION,FPARASETTINGXML,FMODIFIERID,FENABLE,FMODIFYTIME,FPRINTAFTERAUDIT,FCREATORID) VALUES (1112145494488858624,'0','0',NULL,'1',' ','0',1112145494488858624,'C','er_applyprojectbill',1,' ',' ','er_applyprojectbill_BT_S',{ts'2018-08-08 18:08:08'},'18YFYCMXCXDW',NULL,1,'1',{ts'2018-08-08 18:08:08'},'0',1);

DELETE FROM T_BAS_BILLTYPE_l WHERE FPKID = '1GL5L685IDIZ';
INSERT INTO T_BAS_BILLTYPE_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1112145494488858624,'1GL5L685IDIZ','zh_CN',' ','立项申请');
DELETE FROM T_BAS_BILLTYPE_l WHERE FPKID = '1GL5L685IDJ+';
INSERT INTO T_BAS_BILLTYPE_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1112145494488858624,'1GL5L685IDJ+','zh_TW',' ','立項申請');

DELETE FROM T_BAS_BILLTYPE WHERE FID = 1117174738913894400;
INSERT INTO T_BAS_BILLTYPE(FID,FISSYSPRESET,FDOCUMENTSTATUS,FDEFWNREPORTTEMPLATE,FISDEFAULT,FDEFPRINTTEMPLATE,FCONTROLPRINTCOUNT,FMASTERID,FSTATUS,FBILLFORMID,FMAXPRINTCOUNT,FBILLCODERULEID,FBILLINITSETTING,FNUMBER,FCREATETIME,FLAYOUTSOLUTION,FPARASETTINGXML,FMODIFIERID,FENABLE,FMODIFYTIME,FPRINTAFTERAUDIT,FCREATORID) VALUES (1117174738913894400,'0','0',NULL,'0',' ','0',1117174738913894400,'C','er_applyprojectbill',1,' ',' ','er_changeprojectbill_BT_S',{ts'2018-08-08 18:08:08'},'1GM01GFI155S',NULL,1,'1',{ts'2018-08-08 18:08:08'},'0',1);

DELETE FROM T_BAS_BILLTYPE_L WHERE FPKID = '1H79=6U1=Q+J';
INSERT INTO T_BAS_BILLTYPE_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1117174738913894400,'1H79=6U1=Q+J','zh_CN',' ','立项变更');
DELETE FROM T_BAS_BILLTYPE_L WHERE FPKID = '1H79=6U1=Q+K';
INSERT INTO T_BAS_BILLTYPE_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1117174738913894400,'1H79=6U1=Q+K','zh_TW',' ','立項變更');


/** 立项单 费用单据类型**/
DELETE FROM t_er_billtype WHERE FNAME = '立项单';
DELETE FROM t_er_billtype WHERE FID = 1113073729136716800;
INSERT INTO t_er_billtype(FID,FCREATEORGID,FORGID,FMASTERID,FSTATUS,FCTRLSTRATEGY,FNAME,FNUMBER,FBILLNUMBER,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FISPRESET) VALUES (1113073729136716800,0,0,1113073729136716800,'C',' ','立项单','er_applyprojectbill','er_applyprojectbill',{ts'2018-08-08 18:08:08'},'1',1,{ts'2018-08-08 18:08:08'},1,1);

DELETE FROM t_er_billtype_l WHERE FID = 1113073729136716800;
INSERT INTO t_er_billtype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1113073729136716800,'11130737291367168','zh_CN','立项单');

/** 立项单 编号规则**/
DELETE FROM t_cr_coderule WHERE FID = '1GL6/8QKNQHJ';
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','1GL6/8QKNQHJ','0',NULL,'0',{ts'2018-08-08 18:08:08'},'er_applyprojectbill','1','0','0','1',NULL,'0','1GL6/8QKNQHJ','-','1',NULL,'0','C','1GL5RYTHGFED',' ','0',1,'1',{ts'2018-08-08 18:08:08'},1);
DELETE FROM t_cr_coderule WHERE FID = '1HE90MWD5TB4';
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','1','1HE90MWD5TB4','0',NULL,'0',{ts'2018-08-08 18:08:08'},'er_applyprojectbill','1','0','0','1',NULL,'0','1HE90MWD5TB4','-','1',NULL,'0','C','1HE8WXEXYZ1H',' ','0',1,'1',{ts'2018-08-08 18:08:08'},1);

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1GL6/8S1OCKS';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1GL6/8QKNQHJ',1,'2','-','1','1GL6/8S1OCKS',1,'1',' ',1,8,'1','yyyyMMdd',' ','1','bizdate','1',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1GL6/8S1OCKT';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1GL6/8QKNQHJ',1,'16','-','0','1GL6/8S1OCKT',1,'1',' ',2,6,'1',' ',' ','1',' ','1',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1GL6/8S1OCKR';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1GL6/8QKNQHJ',1,'1',' ','0','1GL6/8S1OCKR',1,'1','1',0,8,'1','LXSQ',' ','1',' ','0',' ');

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1HEBJXOZ0559';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1HE90MWD5TB4',1,'1',' ','0','1HEBJXOZ0559',1,'1','1',0,8,'1','LXBG',' ','1',' ','0',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1HEBJXOZ055=';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1HE90MWD5TB4',1,'2','-','1','1HEBJXOZ055=',1,'1',' ',1,8,'1','yyyyMMdd',' ','1','bizdate','1',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1HEBJXOZ055A';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1HE90MWD5TB4',1,'16','-','0','1HEBJXOZ055A',1,'1',' ',2,6,'1',' ',' ','1',' ','1',' ');


DELETE FROM t_cr_coderule_l WHERE FPKID = '1GL6/8QK8SEM';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1GL6/8QKNQHJ','1GL6/8QK8SEM','zh_CN','立项单');
DELETE FROM t_cr_coderule_l WHERE FPKID = '1HE90MWD5UOO';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1HE90MWD5TB4','1HE90MWD5UOO','zh_CN','立项变更单');

/** 编号规则适用条件属性 **/
DELETE FROM t_cr_appcondpro WHERE FID = '1HEB9EPX+9A4';
INSERT INTO t_cr_appcondpro(FID,FBIZOBJECTID,FNUMBER) VALUES ('1HEB9EPX+9A4','er_applyprojectbill','ischange');

DELETE FROM t_cr_appcondpro_l WHERE FPKID = '1HEB9EPX+=NN';
INSERT INTO t_cr_appcondpro_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('1HEB9EPX+9A4','1HEB9EPX+=NN','zh_CN',' ','是否变更');
DELETE FROM t_cr_appcondpro_l WHERE FPKID = '1HEB9EPX+=NO';
INSERT INTO t_cr_appcondpro_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('1HEB9EPX+9A4','1HEB9EPX+=NO','zh_TW',' ','是否變更');
/** 编号规则适用条件属性值 **/
DELETE FROM t_cr_appcondprovalue WHERE FID = '1HEBD8Q=99D7';
INSERT INTO t_cr_appcondprovalue(FID,FVALUE,FAPPCONDPROID) VALUES ('1HEBD8Q=99D7','false','1HEB9EPX+9A4');
DELETE FROM t_cr_appcondprovalue WHERE FID = '1HEBFS2IXNRP';
INSERT INTO t_cr_appcondprovalue(FID,FVALUE,FAPPCONDPROID) VALUES ('1HEBFS2IXNRP','true','1HEB9EPX+9A4');

DELETE FROM t_cr_appcondprovalue_l WHERE FPKID = '1HEBD8Q=9=QQ';
INSERT INTO t_cr_appcondprovalue_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('1HEBD8Q=99D7','1HEBD8Q=9=QQ','zh_CN',' ','否');
DELETE FROM t_cr_appcondprovalue_l WHERE FPKID = '1HEBD8Q=9=QR';
INSERT INTO t_cr_appcondprovalue_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('1HEBD8Q=99D7','1HEBD8Q=9=QR','zh_TW',' ','否');
DELETE FROM t_cr_appcondprovalue_l WHERE FPKID = '1HEBFS2IXP37';
INSERT INTO t_cr_appcondprovalue_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('1HEBFS2IXNRP','1HEBFS2IXP37','zh_CN',' ','是');
DELETE FROM t_cr_appcondprovalue_l WHERE FPKID = '1HEBFS2IXP38';
INSERT INTO t_cr_appcondprovalue_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('1HEBFS2IXNRP','1HEBFS2IXP38','zh_TW',' ','是');
/** 编号规则适用条件基础资料列表**/
DELETE FROM T_CR_AppCondition WHERE FENTRYID = '1HEBJTGCZ7V1';
INSERT INTO T_CR_AppCondition(FID,FPROPERTY,FENTRYID,FSEQ,FPROPERTYVALUE) VALUES ('1HE90MWD5TB4','1HEB9EPX+9A4','1HEBJTGCZ7V1',1,'1HEBFS2IXNRP');
DELETE FROM T_CR_AppCondition WHERE FENTRYID = '1HVV25TA8120';
INSERT INTO T_CR_AppCondition(FID,FPROPERTY,FENTRYID,FSEQ,FPROPERTYVALUE) VALUES ('1GL6/8QKNQHJ','1HEB9EPX+9A4','1HVV25TA8120',1,'1HEBD8Q=99D7');

/** 立项单 对公费用下 特殊数据权限 **/
DELETE FROM t_perm_operationrule WHERE FID = '1HW/SGEV1L87';
INSERT INTO t_perm_operationrule(FID,FOPERATIONKEY,FRULE,FENABLED,FOPERATIONTYPE,FISPRESET,FBIZAPPID,FDESCRIPTION,FISPUBLIC,FENTITYTYPEID,FNAME) VALUES ('1HW/SGEV1L87','view','{"filterRow":[{"id":"1JF4USQTJY70","leftBracket":"","compareType":"103","fieldName":"applier.number","rightBracket":"","logic":"1","value":[{"id":"1JF4USQTK1L2","value":""}],"baseDataIds":[]},{"id":"1JF4USQTJY71","leftBracket":"","compareType":"103","fieldName":"creator.number","rightBracket":"","logic":"1","value":[{"id":"1JF4USQTK1L3","value":""}],"baseDataIds":[]},{"id":"1JF4USQTJY72","leftBracket":"","compareType":"953718393159160832","fieldName":"creator.number","rightBracket":"","logic":"0","value":[{"id":"1JF4USQTK1L4","value":""}],"baseDataIds":[]}],"forList":false}','1','view','0','1GARA29DA8+R',' ','0','er_applyprojectbill','立项单特殊数据查看权限');

DELETE FROM t_perm_operationruleobj WHERE FID = '1HW/T10X7JSB';
INSERT INTO t_perm_operationruleobj(FID,FOPERATIONRULEID,FBIZAPPID,FSEQ,FOBJENABLED,FENTITYTYPEID) VALUES ('1HW/T10X7JSB','1HW/SGEV1L87','1GARA29DA8+R',0,'1','er_applyprojectbill');

DELETE FROM t_perm_operationrule_l WHERE FPKID = '1HW/SGEUYAX/';
INSERT INTO t_perm_operationrule_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('1HW/SGEV1L87','1HW/SGEUYAX/','zh_CN',' ','立项单特殊数据查看权限');