delete from t_msplan_entity_condition where fentryid in(select fentryid from t_msplan_entity where fid =1406532930871768064);
delete from t_msplan_entity_relation where fentryid in(select fentryid from t_msplan_entity where fid =1406532930871768064);
delete from t_msplan_filterentry where fentryid in(select fentryid from t_msplan_filter where fid =1406532930871768064);
delete from t_msplan_entity where fid =1406532930871768064;
delete from t_msplan_filter where fid =1406532930871768064;



DELETE FROM t_msplan_entity WHERE FENTRYID = 1448405437132118016;
INSERT INTO t_msplan_entity(FGROUPFIELD,FUPGROUPENTITYID,FID,FGROUPENTITYID,FFILTERTEXT,FGROUPFIELDDESC,FENTRYID,FUPGROUPFIELDDESC,FGANTTTYPE,FDEFAULTVIEW,FFILTER_TAG,FJOINFILTER,FFILTER,FTIMEFIELDDESC,FENTITYID,FUPUPGROUPFIELD,FISMAPPINGENTITY,FSEQ,FUPUPGROUPENTITYID,FUPGROUPFIELD,FUPUPGROUPFIELDDESC,FTIMEFIELD) VALUES (' ','pmpd_project',1406532930871768064,'pmts_wbs',' ',' ',1448405437132118016,' ','B','0',' ','1',' ',' ','pmts_task',' ','0',1,' ',' ',' ',' ');


DELETE FROM t_msplan_entity_condition WHERE FDETAILID = 1456702546717463552;
INSERT INTO t_msplan_entity_condition(FFIELDSORTFLAG,FVERSIONFILED,FDETAILID,FCENTITYID,FCFILTERTEXT,FFIELDSORT,FENTRYID,FSEQ,FCFILTER_TAG,FCFILTER) VALUES ('number','version',1456702546717463552,'pmts_wbs','版本.版本号 为 为空 ','单据头.WBS编码',1448405437132118016,2,'{"filterRow":[{"id":"2JXX9VY28T/O","leftBracket":"","compareType":"37","fieldName":"version.number","rightBracket":"","logic":"0","value":[{"id":"2JXX9VY280DD","value":""}],"baseDataIds":[]}],"forList":false}',' ');
DELETE FROM t_msplan_entity_condition WHERE FDETAILID = 1448405437132119040;
INSERT INTO t_msplan_entity_condition(FFIELDSORTFLAG,FVERSIONFILED,FDETAILID,FCENTITYID,FCFILTERTEXT,FFIELDSORT,FENTRYID,FSEQ,FCFILTER_TAG,FCFILTER) VALUES ('orderno','version',1448405437132119040,'pmts_task','版本.版本号 为 为空 ','单据头.序号',1448405437132118016,1,'{"filterRow":[{"id":"2IX5A0PTLGCK","leftBracket":"","compareType":"37","fieldName":"version.number","rightBracket":"","logic":"0","value":[{"id":"2IX5A0PTLFPA","value":""}],"baseDataIds":[]}],"forList":false}',' ');


DELETE FROM t_msplan_entity_relation WHERE FDETAILID = 1462930974005270528;
INSERT INTO t_msplan_entity_relation(FRENTITYID,FDETAILID,FENTRYID,FSEQ,FRENTITYFLAG,FRUPLEVELENTITYID,FRENTITYFLAGDESC,FRENTRYFLAG) VALUES ('pmts_task',1462930974005270528,1448405437132118016,1,'wbs','pmts_wbs','单据头.WBS',' ');
DELETE FROM t_msplan_entity_relation WHERE FDETAILID = 1465313259430163456;
INSERT INTO t_msplan_entity_relation(FRENTITYID,FDETAILID,FENTRYID,FSEQ,FRENTITYFLAG,FRUPLEVELENTITYID,FRENTITYFLAGDESC,FRENTRYFLAG) VALUES ('pmts_wbs',1465313259430163456,1448405437132118016,2,'projectnum','pmpd_project','单据头.项目号',' ');
DELETE FROM t_msplan_entity_relation WHERE FDETAILID = 1465313259430163457;
INSERT INTO t_msplan_entity_relation(FRENTITYID,FDETAILID,FENTRYID,FSEQ,FRENTITYFLAG,FRUPLEVELENTITYID,FRENTITYFLAGDESC,FRENTRYFLAG) VALUES ('pmts_task',1465313259430163457,1448405437132118016,3,'projectnum','pmpd_project','单据头.项目号',' ');

DELETE FROM t_msplan_filter WHERE FENTRYID = 1406532931173803029;
INSERT INTO t_msplan_filter(FID,FENTITYCONDFILTER,FENTITYCONDALIGNDESC,FENTITYCONDID,FENTRYID,FISUNLIMITED,FISMULTI,FENTITYCONDFILTER_TAG,FCONTROLRANGEONE,FCONTROLRANGETWO,FCONTROLRANGEFOUR,FCONTROLRANGETHREE,FSEQ,FENTITYCONDALIGN,FENTITYCONDSET) VALUES (1406532930871768064,' ','单据头.项目号','pmpd_project',1406532931173803029,'0','0','{"filterRow":[{"id":"2DK=7D6Q0L7B","leftBracket":"","compareType":"105","fieldName":"status","rightBracket":"","logic":"0","value":[{"id":"2DK=7D6TO023","value":"C"}],"baseDataIds":[]}],"forList":false}','1','0','0','0',1,'projectnum','数据状态 等于 已审核 ');
DELETE FROM t_msplan_filter WHERE FENTRYID = 1423745801896606720;
INSERT INTO t_msplan_filter(FID,FENTITYCONDFILTER,FENTITYCONDALIGNDESC,FENTITYCONDID,FENTRYID,FISUNLIMITED,FISMULTI,FENTITYCONDFILTER_TAG,FCONTROLRANGEONE,FCONTROLRANGETWO,FCONTROLRANGEFOUR,FCONTROLRANGETHREE,FSEQ,FENTITYCONDALIGN,FENTITYCONDSET) VALUES (1406532930871768064,' ','单据头.项目计划类型','fmm_plantype',1423745801896606720,'1','0','{"filterRow":[{"id":"2K+IJ4RA2P+E","leftBracket":"","compareType":"105","fieldName":"status","rightBracket":"","logic":"0","value":[{"id":"2K+IJ4RKZ5YO","value":"C"}],"baseDataIds":[]}],"forList":false}','1','0','0','0',2,'plantype','数据状态 等于 已审核 ');


DELETE FROM t_msplan_filterentry WHERE FDETAILID = 1455142789909120000;
INSERT INTO t_msplan_filterentry(FDETAILID,FCHILDENTITYFLAG,FTOFILTERFLAGDESC,FTOFILTERFLAG,FENTRYID,FSEQ) VALUES (1455142789909120000,'pmts_wbs','单据头.项目计划类型','plantype',1423745801896606720,1);

DELETE FROM t_msplan_filterentry WHERE FDETAILID = 1406532931173757961;
INSERT INTO t_msplan_filterentry(FDETAILID,FCHILDENTITYFLAG,FTOFILTERFLAGDESC,FTOFILTERFLAG,FENTRYID,FSEQ) VALUES (1406532931173757961,'pmts_wbs','单据头.项目号','projectnum',1406532931173803029,1);
DELETE FROM t_msplan_filterentry WHERE FDETAILID = 1447814876973046784;
INSERT INTO t_msplan_filterentry(FDETAILID,FCHILDENTITYFLAG,FTOFILTERFLAGDESC,FTOFILTERFLAG,FENTRYID,FSEQ) VALUES (1447814876973046784,'pmpd_project','单据头.pmpd_project','pmpd_project',1406532931173803029,2);
