--横道设置删除尚需横道
delete from t_msplan_crossset  where fid in (1447877269409307648,1565156743573519360,1423370724491428864,1438494107356890112,1419530514422837248,1437668778363098112,1437663285385139200,1406532930871768064,1447881632072670208,1566033785072498688) and fcrosstypeid=1078161020498919424;
--横道标签设置日期格式化修改
update t_msplan_crosscontent set flabelformattwo ='yyyy-MM-dd HH:mm:ss,yyyy-MM-dd HH:mm:ss' where fentrycrossflagdetailcont ='planstartdate,planenddate';
update t_msplan_crosscontent set flabelformattwo ='yyyy-MM-dd HH:mm:ss' where fentrycrossflagdetailcont ='planstartdate';

--样式方案 尚需横道高度修改成8
update t_msplan_jvwschcross set fheight =8 where fentryid =1406548060833637380;

--数据源名称修改
DELETE FROM t_msplan_gttsource_l WHERE FPKID = '2DRJMDNNJ092';
INSERT INTO t_msplan_gttsource_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1406532930871768064,'2DRJMDNNJ092','zh_CN','项目计划进度预发布数据源');
DELETE FROM t_msplan_gttsource_l WHERE FPKID = '2DRJMDNNJ093';
INSERT INTO t_msplan_gttsource_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1406532930871768064,'2DRJMDNNJ093','zh_TW','項目計劃進度預發布數據源');
DELETE FROM t_msplan_gttsource_l WHERE FPKID = '2HKP6ROO5M4E';
INSERT INTO t_msplan_gttsource_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1437663285385139200,'2HKP6ROO5M4E','zh_CN','主计划预发布数据源');
DELETE FROM t_msplan_gttsource_l WHERE FPKID = '2HKP6ROO5M4F';
INSERT INTO t_msplan_gttsource_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1437663285385139200,'2HKP6ROO5M4F','zh_TW','主計劃預發布數據源');




DELETE FROM t_msplan_entity WHERE FENTRYID = 1565156743607073792;
INSERT INTO t_msplan_entity(FGROUPENTITYID,FFILTERTEXT,FGROUPFIELDDESC,FTASKENTITYFLAGDESC,FFILTER_TAG,FTIMEFIELDDESC,FENTITYID,FUPUPGROUPFIELD,FISMAPPINGENTITY,FSEQ,FUPUPGROUPENTITYID,FVIEWID,FTIMEFIELD,FGROUPFIELD,FUPGROUPENTITYID,FID,FVIEWALIAS,FENTRYID,FUPGROUPFIELDDESC,FGANTTTYPE,FDEFAULTVIEW,FJOINFILTER,FFILTER,FTASKENTITYFLAG,FUPGROUPFIELD,FUPUPGROUPFIELDDESC) VALUES ('pmts_wbs',' ',' ',' ',' ',' ','pmts_task',' ','0',1,' ',1498427393998589952,' ',' ','pmpd_project',1565156743573519360,'项目任务分解',1565156743607073792,' ','B','0','1',' ',' ',' ',' ');
DELETE FROM t_msplan_entity WHERE FENTRYID = 1566033785122830336;
INSERT INTO t_msplan_entity(FGROUPENTITYID,FFILTERTEXT,FGROUPFIELDDESC,FTASKENTITYFLAGDESC,FFILTER_TAG,FTIMEFIELDDESC,FENTITYID,FUPUPGROUPFIELD,FISMAPPINGENTITY,FSEQ,FUPUPGROUPENTITYID,FVIEWID,FTIMEFIELD,FGROUPFIELD,FUPGROUPENTITYID,FID,FVIEWALIAS,FENTRYID,FUPGROUPFIELDDESC,FGANTTTYPE,FDEFAULTVIEW,FJOINFILTER,FFILTER,FTASKENTITYFLAG,FUPGROUPFIELD,FUPUPGROUPFIELDDESC) VALUES ('pmts_wbs',' ',' ',' ',' ',' ','pmts_task',' ','0',1,' ',1498426799808320512,' ',' ','pmpd_project',1566033785072498688,'项目任务分解',1566033785122830336,' ','B','0','1',' ',' ',' ',' ');

DELETE FROM T_MSPLAN_ENTITY_L WHERE FPKID = '2X8HTE0NV8C+';
INSERT INTO T_MSPLAN_ENTITY_L(FPKID,FLOCALEID,FENTRYID,FMVIEWALIAS) VALUES ('2X8HTE0NV8C+','zh_TW',1565156743607073792,'項目任務分解');
DELETE FROM T_MSPLAN_ENTITY_L WHERE FPKID = '2X8HTE0NV8C/';
INSERT INTO T_MSPLAN_ENTITY_L(FPKID,FLOCALEID,FENTRYID,FMVIEWALIAS) VALUES ('2X8HTE0NV8C/','zh_CN',1565156743607073792,'项目任务分解');
DELETE FROM T_MSPLAN_ENTITY_L WHERE FPKID = '2XBPODI61W=+';
INSERT INTO T_MSPLAN_ENTITY_L(FPKID,FLOCALEID,FENTRYID,FMVIEWALIAS) VALUES ('2XBPODI61W=+','zh_TW',1566033785122830336,'項目任務分解');
DELETE FROM T_MSPLAN_ENTITY_L WHERE FPKID = '2XBPODI61W=/';
INSERT INTO T_MSPLAN_ENTITY_L(FPKID,FLOCALEID,FENTRYID,FMVIEWALIAS) VALUES ('2XBPODI61W=/','zh_CN',1566033785122830336,'项目任务分解');



DELETE FROM t_msplan_fentryety WHERE FENTRYID = 1565156743607073796;
INSERT INTO t_msplan_fentryety(FID,FENTRYFIELDALIGN,FENTRYFIELDFLAG,FENTRYID,FSEQ,FENTRYFIELDNAME,FENTRYENTITYNAME) VALUES (1565156743573519360,'任务编码','number',1565156743607073796,1,'单据头.任务编码','pmts_task');
DELETE FROM t_msplan_fentryety WHERE FENTRYID = 1565156743607073797;
INSERT INTO t_msplan_fentryety(FID,FENTRYFIELDALIGN,FENTRYFIELDFLAG,FENTRYID,FSEQ,FENTRYFIELDNAME,FENTRYENTITYNAME) VALUES (1565156743573519360,'任务名称','name',1565156743607073797,2,'单据头.任务名称','pmts_task');
DELETE FROM t_msplan_fentryety WHERE FENTRYID = 1565156743607073798;
INSERT INTO t_msplan_fentryety(FID,FENTRYFIELDALIGN,FENTRYFIELDFLAG,FENTRYID,FSEQ,FENTRYFIELDNAME,FENTRYENTITYNAME) VALUES (1565156743573519360,'计划工期','plantime',1565156743607073798,3,'单据头.计划工期','pmts_task');
DELETE FROM t_msplan_fentryety WHERE FENTRYID = 1565156743607073799;
INSERT INTO t_msplan_fentryety(FID,FENTRYFIELDALIGN,FENTRYFIELDFLAG,FENTRYID,FSEQ,FENTRYFIELDNAME,FENTRYENTITYNAME) VALUES (1565156743573519360,'计划开始时间','planstartdate',1565156743607073799,4,'单据头.计划开始时间','pmts_task');
DELETE FROM t_msplan_fentryety WHERE FENTRYID = 1565156743607073800;
INSERT INTO t_msplan_fentryety(FID,FENTRYFIELDALIGN,FENTRYFIELDFLAG,FENTRYID,FSEQ,FENTRYFIELDNAME,FENTRYENTITYNAME) VALUES (1565156743573519360,'计划完成时间','planenddate',1565156743607073800,5,'单据头.计划完成时间','pmts_task');
DELETE FROM t_msplan_fentryety WHERE FENTRYID = 1566033785122830340;
INSERT INTO t_msplan_fentryety(FID,FENTRYFIELDALIGN,FENTRYFIELDFLAG,FENTRYID,FSEQ,FENTRYFIELDNAME,FENTRYENTITYNAME) VALUES (1566033785072498688,'任务编码','number',1566033785122830340,1,'单据头.任务编码','pmts_task');
DELETE FROM t_msplan_fentryety WHERE FENTRYID = 1566033785122830341;
INSERT INTO t_msplan_fentryety(FID,FENTRYFIELDALIGN,FENTRYFIELDFLAG,FENTRYID,FSEQ,FENTRYFIELDNAME,FENTRYENTITYNAME) VALUES (1566033785072498688,'任务名称','name',1566033785122830341,2,'单据头.任务名称','pmts_task');
DELETE FROM t_msplan_fentryety WHERE FENTRYID = 1566033785122830342;
INSERT INTO t_msplan_fentryety(FID,FENTRYFIELDALIGN,FENTRYFIELDFLAG,FENTRYID,FSEQ,FENTRYFIELDNAME,FENTRYENTITYNAME) VALUES (1566033785072498688,'计划工期','plantime',1566033785122830342,3,'单据头.计划工期','pmts_task');
DELETE FROM t_msplan_fentryety WHERE FENTRYID = 1566033785122830343;
INSERT INTO t_msplan_fentryety(FID,FENTRYFIELDALIGN,FENTRYFIELDFLAG,FENTRYID,FSEQ,FENTRYFIELDNAME,FENTRYENTITYNAME) VALUES (1566033785072498688,'计划开始时间','planstartdate',1566033785122830343,4,'单据头.计划开始时间','pmts_task');
DELETE FROM t_msplan_fentryety WHERE FENTRYID = 1566033785122830344;
INSERT INTO t_msplan_fentryety(FID,FENTRYFIELDALIGN,FENTRYFIELDFLAG,FENTRYID,FSEQ,FENTRYFIELDNAME,FENTRYENTITYNAME) VALUES (1566033785072498688,'计划完成时间','planenddate',1566033785122830344,5,'单据头.计划完成时间','pmts_task');


DELETE FROM t_msplan_fentryety_l WHERE FPKID = '2X8HTE0NV8C0';
INSERT INTO t_msplan_fentryety_l(FENTRYFIELDALIGN,FPKID,FLOCALEID,FENTRYID) VALUES ('任務編碼','2X8HTE0NV8C0','zh_TW',1565156743607073796);
DELETE FROM t_msplan_fentryety_l WHERE FPKID = '2X8HTE0NV8C1';
INSERT INTO t_msplan_fentryety_l(FENTRYFIELDALIGN,FPKID,FLOCALEID,FENTRYID) VALUES ('任务编码','2X8HTE0NV8C1','zh_CN',1565156743607073796);
DELETE FROM t_msplan_fentryety_l WHERE FPKID = '2X8HTE0NV8C2';
INSERT INTO t_msplan_fentryety_l(FENTRYFIELDALIGN,FPKID,FLOCALEID,FENTRYID) VALUES ('任務名稱','2X8HTE0NV8C2','zh_TW',1565156743607073797);
DELETE FROM t_msplan_fentryety_l WHERE FPKID = '2X8HTE0NV8C3';
INSERT INTO t_msplan_fentryety_l(FENTRYFIELDALIGN,FPKID,FLOCALEID,FENTRYID) VALUES ('任务名称','2X8HTE0NV8C3','zh_CN',1565156743607073797);
DELETE FROM t_msplan_fentryety_l WHERE FPKID = '2X8HTE0NV8C4';
INSERT INTO t_msplan_fentryety_l(FENTRYFIELDALIGN,FPKID,FLOCALEID,FENTRYID) VALUES ('計劃工期','2X8HTE0NV8C4','zh_TW',1565156743607073798);
DELETE FROM t_msplan_fentryety_l WHERE FPKID = '2X8HTE0NV8C5';
INSERT INTO t_msplan_fentryety_l(FENTRYFIELDALIGN,FPKID,FLOCALEID,FENTRYID) VALUES ('计划工期','2X8HTE0NV8C5','zh_CN',1565156743607073798);
DELETE FROM t_msplan_fentryety_l WHERE FPKID = '2X8HTE0NV8C6';
INSERT INTO t_msplan_fentryety_l(FENTRYFIELDALIGN,FPKID,FLOCALEID,FENTRYID) VALUES ('計劃開始時間','2X8HTE0NV8C6','zh_TW',1565156743607073799);
DELETE FROM t_msplan_fentryety_l WHERE FPKID = '2X8HTE0NV8C7';
INSERT INTO t_msplan_fentryety_l(FENTRYFIELDALIGN,FPKID,FLOCALEID,FENTRYID) VALUES ('计划开始时间','2X8HTE0NV8C7','zh_CN',1565156743607073799);
DELETE FROM t_msplan_fentryety_l WHERE FPKID = '2X8HTE0NV8C8';
INSERT INTO t_msplan_fentryety_l(FENTRYFIELDALIGN,FPKID,FLOCALEID,FENTRYID) VALUES ('計劃完成時間','2X8HTE0NV8C8','zh_TW',1565156743607073800);
DELETE FROM t_msplan_fentryety_l WHERE FPKID = '2X8HTE0NV8C9';
INSERT INTO t_msplan_fentryety_l(FENTRYFIELDALIGN,FPKID,FLOCALEID,FENTRYID) VALUES ('计划完成时间','2X8HTE0NV8C9','zh_CN',1565156743607073800);
DELETE FROM t_msplan_fentryety_l WHERE FPKID = '2XBPODI61W=0';
INSERT INTO t_msplan_fentryety_l(FENTRYFIELDALIGN,FPKID,FLOCALEID,FENTRYID) VALUES ('任務編碼','2XBPODI61W=0','zh_TW',1566033785122830340);
DELETE FROM t_msplan_fentryety_l WHERE FPKID = '2XBPODI61W=1';
INSERT INTO t_msplan_fentryety_l(FENTRYFIELDALIGN,FPKID,FLOCALEID,FENTRYID) VALUES ('任务编码','2XBPODI61W=1','zh_CN',1566033785122830340);
DELETE FROM t_msplan_fentryety_l WHERE FPKID = '2XBPODI61W=2';
INSERT INTO t_msplan_fentryety_l(FENTRYFIELDALIGN,FPKID,FLOCALEID,FENTRYID) VALUES ('任務名稱','2XBPODI61W=2','zh_TW',1566033785122830341);
DELETE FROM t_msplan_fentryety_l WHERE FPKID = '2XBPODI61W=3';
INSERT INTO t_msplan_fentryety_l(FENTRYFIELDALIGN,FPKID,FLOCALEID,FENTRYID) VALUES ('任务名称','2XBPODI61W=3','zh_CN',1566033785122830341);
DELETE FROM t_msplan_fentryety_l WHERE FPKID = '2XBPODI61W=4';
INSERT INTO t_msplan_fentryety_l(FENTRYFIELDALIGN,FPKID,FLOCALEID,FENTRYID) VALUES ('計劃工期','2XBPODI61W=4','zh_TW',1566033785122830342);
DELETE FROM t_msplan_fentryety_l WHERE FPKID = '2XBPODI61W=5';
INSERT INTO t_msplan_fentryety_l(FENTRYFIELDALIGN,FPKID,FLOCALEID,FENTRYID) VALUES ('计划工期','2XBPODI61W=5','zh_CN',1566033785122830342);
DELETE FROM t_msplan_fentryety_l WHERE FPKID = '2XBPODI61W=6';
INSERT INTO t_msplan_fentryety_l(FENTRYFIELDALIGN,FPKID,FLOCALEID,FENTRYID) VALUES ('計劃開始時間','2XBPODI61W=6','zh_TW',1566033785122830343);
DELETE FROM t_msplan_fentryety_l WHERE FPKID = '2XBPODI61W=7';
INSERT INTO t_msplan_fentryety_l(FENTRYFIELDALIGN,FPKID,FLOCALEID,FENTRYID) VALUES ('计划开始时间','2XBPODI61W=7','zh_CN',1566033785122830343);
DELETE FROM t_msplan_fentryety_l WHERE FPKID = '2XBPODI61W=8';
INSERT INTO t_msplan_fentryety_l(FENTRYFIELDALIGN,FPKID,FLOCALEID,FENTRYID) VALUES ('計劃完成時間','2XBPODI61W=8','zh_TW',1566033785122830344);
DELETE FROM t_msplan_fentryety_l WHERE FPKID = '2XBPODI61W=9';
INSERT INTO t_msplan_fentryety_l(FENTRYFIELDALIGN,FPKID,FLOCALEID,FENTRYID) VALUES ('计划完成时间','2XBPODI61W=9','zh_CN',1566033785122830344);


DELETE FROM t_msplan_filter WHERE FENTRYID = 1565156743607072784;
INSERT INTO t_msplan_filter(FENTITYCONDFILTER,FID,FENTITYCONDALIGNDESC,FENTITYCONDID,FENTRYID,FISUNLIMITED,FISMULTI,FENTITYCONDFILTER_TAG,FCONTROLRANGEONE,FCONTROLRANGETWO,FCONTROLRANGEFOUR,FCONTROLRANGETHREE,FSEQ,FENTITYCONDALIGN,FENTITYCONDSET) VALUES (' ',1565156743573519360,'单据头.项目号','pmpd_project',1565156743607072784,'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 = 1566033785122831374;
INSERT INTO t_msplan_filter(FENTITYCONDFILTER,FID,FENTITYCONDALIGNDESC,FENTITYCONDID,FENTRYID,FISUNLIMITED,FISMULTI,FENTITYCONDFILTER_TAG,FCONTROLRANGEONE,FCONTROLRANGETWO,FCONTROLRANGEFOUR,FCONTROLRANGETHREE,FSEQ,FENTITYCONDALIGN,FENTITYCONDSET) VALUES (' ',1566033785072498688,'单据头.项目号','pmpd_project',1566033785122831374,'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 = 1566033785122831375;
INSERT INTO t_msplan_filter(FENTITYCONDFILTER,FID,FENTITYCONDALIGNDESC,FENTITYCONDID,FENTRYID,FISUNLIMITED,FISMULTI,FENTITYCONDFILTER_TAG,FCONTROLRANGEONE,FCONTROLRANGETWO,FCONTROLRANGEFOUR,FCONTROLRANGETHREE,FSEQ,FENTITYCONDALIGN,FENTITYCONDSET) VALUES (' ',1566033785072498688,'单据头.项目计划类型','fmm_plantype',1566033785122831375,'0','0','{"filterRow":[{"id":"2IUSTW777GSG","leftBracket":"","compareType":"67","fieldName":"number","rightBracket":"","logic":"0","value":[{"id":"2IUSTW777G37","value":"MASTERPLAN_S"}],"baseDataIds":[]}],"forList":false}','1','0','0','0',2,'plantype','编码 等于 MASTERPLAN_S ');
DELETE FROM t_msplan_filter WHERE FENTRYID = 1566033785122831376;
INSERT INTO t_msplan_filter(FENTITYCONDFILTER,FID,FENTITYCONDALIGNDESC,FENTITYCONDID,FENTRYID,FISUNLIMITED,FISMULTI,FENTITYCONDFILTER_TAG,FCONTROLRANGEONE,FCONTROLRANGETWO,FCONTROLRANGEFOUR,FCONTROLRANGETHREE,FSEQ,FENTITYCONDALIGN,FENTITYCONDSET) VALUES (' ',1566033785072498688,'单据头.计划区域','fmm_planningarea',1566033785122831376,'1','1',' ','1','0','0','0',3,'planarea',' ');
DELETE FROM t_msplan_filter WHERE FENTRYID = 1566033785122831377;
INSERT INTO t_msplan_filter(FENTITYCONDFILTER,FID,FENTITYCONDALIGNDESC,FENTITYCONDID,FENTRYID,FISUNLIMITED,FISMULTI,FENTITYCONDFILTER_TAG,FCONTROLRANGEONE,FCONTROLRANGETWO,FCONTROLRANGEFOUR,FCONTROLRANGETHREE,FSEQ,FENTITYCONDALIGN,FENTITYCONDSET) VALUES (' ',1566033785072498688,'单据头.行业','mpdm_professiona',1566033785122831377,'1','1',' ','1','0','0','0',4,'trade',' ');


DELETE FROM t_msplan_filterentry WHERE FDETAILID = 1565156743607073802;
INSERT INTO t_msplan_filterentry(FDETAILID,FCHILDENTITYFLAG,FTOFILTERFLAGDESC,FTOFILTERFLAG,FENTRYID,FSEQ) VALUES (1565156743607073802,'pmts_wbs','单据头.项目号','projectnum',1565156743607072784,1);
DELETE FROM t_msplan_filterentry WHERE FDETAILID = 1565156743607073803;
INSERT INTO t_msplan_filterentry(FDETAILID,FCHILDENTITYFLAG,FTOFILTERFLAGDESC,FTOFILTERFLAG,FENTRYID,FSEQ) VALUES (1565156743607073803,'pmpd_project','单据头.pmpd_project','pmpd_project',1565156743607072784,2);
DELETE FROM t_msplan_filterentry WHERE FDETAILID = 1566033785122830346;
INSERT INTO t_msplan_filterentry(FDETAILID,FCHILDENTITYFLAG,FTOFILTERFLAGDESC,FTOFILTERFLAG,FENTRYID,FSEQ) VALUES (1566033785122830346,'pmts_wbs','单据头.项目号','projectnum',1566033785122831374,1);
DELETE FROM t_msplan_filterentry WHERE FDETAILID = 1566033785122830347;
INSERT INTO t_msplan_filterentry(FDETAILID,FCHILDENTITYFLAG,FTOFILTERFLAGDESC,FTOFILTERFLAG,FENTRYID,FSEQ) VALUES (1566033785122830347,'pmpd_project','单据头.pmpd_project','pmpd_project',1566033785122831374,2);
DELETE FROM t_msplan_filterentry WHERE FDETAILID = 1566033785122830348;
INSERT INTO t_msplan_filterentry(FDETAILID,FCHILDENTITYFLAG,FTOFILTERFLAGDESC,FTOFILTERFLAG,FENTRYID,FSEQ) VALUES (1566033785122830348,'pmts_wbs','单据头.项目计划类型','plantype',1566033785122831375,1);
DELETE FROM t_msplan_filterentry WHERE FDETAILID = 1566033785122830349;
INSERT INTO t_msplan_filterentry(FDETAILID,FCHILDENTITYFLAG,FTOFILTERFLAGDESC,FTOFILTERFLAG,FENTRYID,FSEQ) VALUES (1566033785122830349,'pmts_wbs','单据头.计划区域','planarea',1566033785122831376,1);
DELETE FROM t_msplan_filterentry WHERE FDETAILID = 1566033785122830350;
INSERT INTO t_msplan_filterentry(FDETAILID,FCHILDENTITYFLAG,FTOFILTERFLAGDESC,FTOFILTERFLAG,FENTRYID,FSEQ) VALUES (1566033785122830350,'pmts_wbs','单据头.行业','profession',1566033785122831377,1);



DELETE FROM t_msplan_crossset WHERE FENTRYID = 1565156743607072790;
INSERT INTO t_msplan_crossset(FCROSSFLAGDETAILCONTENT,FID,FENDDATEFILED,FCROSSFLAGDETAILDESC,FCROSSFCONE,FSTARTDATEFILED,FENTRYID,FCROSSFLAGCONTENTDESC,FCROSSFLAGCONTENT,FFLAGCONNECTOR,FFLAGDETAILCONNECTOR,FISGROUPCOUNT,FCROSSTYPEID,FCROSSOBJ,FLANDMARKSFILED,FSTARTDATEFILEDDESC,FSEQ,FCROSSFCDESCONE,FCROSSENTITYID,FENDDATEFILEDDESC,FFLAGCONNECTORONE) VALUES ('planstartdate',1565156743573519360,'planenddate','单据头.计划开始时间',' ','planstartdate',1565156743607072790,'单据头.任务名称','name','-','~','0',0,'2',' ','单据头.计划开始时间',3,' ','pmts_task','单据头.计划完成时间',' ');
DELETE FROM t_msplan_crossset WHERE FENTRYID = 1565156743607072791;
INSERT INTO t_msplan_crossset(FCROSSFLAGDETAILCONTENT,FID,FENDDATEFILED,FCROSSFLAGDETAILDESC,FCROSSFCONE,FSTARTDATEFILED,FENTRYID,FCROSSFLAGCONTENTDESC,FCROSSFLAGCONTENT,FFLAGCONNECTOR,FFLAGDETAILCONNECTOR,FISGROUPCOUNT,FCROSSTYPEID,FCROSSOBJ,FLANDMARKSFILED,FSTARTDATEFILEDDESC,FSEQ,FCROSSFCDESCONE,FCROSSENTITYID,FENDDATEFILEDDESC,FFLAGCONNECTORONE) VALUES (' ',1565156743573519360,'bsenddate',' ',' ','bsstartdate',1565156743607072791,' ',' ',' ',' ','0',1078161460598849536,'1',' ','单据头.基线计划开始时间',4,' ','pmts_task','单据头.基线计划完成时间',' ');
DELETE FROM t_msplan_crossset WHERE FENTRYID = 1565156743607072792;
INSERT INTO t_msplan_crossset(FCROSSFLAGDETAILCONTENT,FID,FENDDATEFILED,FCROSSFLAGDETAILDESC,FCROSSFCONE,FSTARTDATEFILED,FENTRYID,FCROSSFLAGCONTENTDESC,FCROSSFLAGCONTENT,FFLAGCONNECTOR,FFLAGDETAILCONNECTOR,FISGROUPCOUNT,FCROSSTYPEID,FCROSSOBJ,FLANDMARKSFILED,FSTARTDATEFILEDDESC,FSEQ,FCROSSFCDESCONE,FCROSSENTITYID,FENDDATEFILEDDESC,FFLAGCONNECTORONE) VALUES (' ',1565156743573519360,'planenddate',' ',' ','planstartdate',1565156743607072792,' ',' ',' ',' ','0',1078186295450442752,'3',' ','单据头.计划开始时间',5,' ','pmts_task','单据头.计划完成时间',' ');
DELETE FROM t_msplan_crossset WHERE FENTRYID = 1565156743607072787;
INSERT INTO t_msplan_crossset(FCROSSFLAGDETAILCONTENT,FID,FENDDATEFILED,FCROSSFLAGDETAILDESC,FCROSSFCONE,FSTARTDATEFILED,FENTRYID,FCROSSFLAGCONTENTDESC,FCROSSFLAGCONTENT,FFLAGCONNECTOR,FFLAGDETAILCONNECTOR,FISGROUPCOUNT,FCROSSTYPEID,FCROSSOBJ,FLANDMARKSFILED,FSTARTDATEFILEDDESC,FSEQ,FCROSSFCDESCONE,FCROSSENTITYID,FENDDATEFILEDDESC,FFLAGCONNECTORONE) VALUES ('planstartdate,planenddate',1565156743573519360,'planenddate','单据头.计划开始时间,单据头.计划完成时间',' ','planstartdate',1565156743607072787,'单据头.任务名称','name','-','~','0',1078085411659881472,'1',' ','单据头.计划开始时间',1,' ','pmts_task','单据头.计划完成时间',' ');
DELETE FROM t_msplan_crossset WHERE FENTRYID = 1565156743607072788;
INSERT INTO t_msplan_crossset(FCROSSFLAGDETAILCONTENT,FID,FENDDATEFILED,FCROSSFLAGDETAILDESC,FCROSSFCONE,FSTARTDATEFILED,FENTRYID,FCROSSFLAGCONTENTDESC,FCROSSFLAGCONTENT,FFLAGCONNECTOR,FFLAGDETAILCONNECTOR,FISGROUPCOUNT,FCROSSTYPEID,FCROSSOBJ,FLANDMARKSFILED,FSTARTDATEFILEDDESC,FSEQ,FCROSSFCDESCONE,FCROSSENTITYID,FENDDATEFILEDDESC,FFLAGCONNECTORONE) VALUES (' ',1565156743573519360,'actualdate',' ',' ','actualstartdate',1565156743607072788,' ',' ',' ',' ','0',1078160656248782848,'1',' ','单据头.实际开始时间',2,' ','pmts_task','单据头.实际时间',' ');
DELETE FROM t_msplan_crossset WHERE FENTRYID = 1565156743607072793;
INSERT INTO t_msplan_crossset(FCROSSFLAGDETAILCONTENT,FID,FENDDATEFILED,FCROSSFLAGDETAILDESC,FCROSSFCONE,FSTARTDATEFILED,FENTRYID,FCROSSFLAGCONTENTDESC,FCROSSFLAGCONTENT,FFLAGCONNECTOR,FFLAGDETAILCONNECTOR,FISGROUPCOUNT,FCROSSTYPEID,FCROSSOBJ,FLANDMARKSFILED,FSTARTDATEFILEDDESC,FSEQ,FCROSSFCDESCONE,FCROSSENTITYID,FENDDATEFILEDDESC,FFLAGCONNECTORONE) VALUES (' ',1565156743573519360,'planenddate',' ',' ','planstartdate',1565156743607072793,' ',' ',' ',' ','0',1458549640033997824,'6',' ','单据头.计划开始时间',6,' ','pmts_task','单据头.计划完成时间',' ');
DELETE FROM t_msplan_crossset WHERE FENTRYID = 1565156743607072794;
INSERT INTO t_msplan_crossset(FCROSSFLAGDETAILCONTENT,FID,FENDDATEFILED,FCROSSFLAGDETAILDESC,FCROSSFCONE,FSTARTDATEFILED,FENTRYID,FCROSSFLAGCONTENTDESC,FCROSSFLAGCONTENT,FFLAGCONNECTOR,FFLAGDETAILCONNECTOR,FISGROUPCOUNT,FCROSSTYPEID,FCROSSOBJ,FLANDMARKSFILED,FSTARTDATEFILEDDESC,FSEQ,FCROSSFCDESCONE,FCROSSENTITYID,FENDDATEFILEDDESC,FFLAGCONNECTORONE) VALUES (' ',1565156743573519360,'planenddate',' ',' ','planstartdate',1565156743607072794,' ',' ',' ',' ','0',1078083769187212288,'1',' ','单据头.计划开始时间',7,' ','pmts_task','单据头.计划完成时间',' ');
DELETE FROM t_msplan_crossset WHERE FENTRYID = 1566033785122831378;
INSERT INTO t_msplan_crossset(FCROSSFLAGDETAILCONTENT,FID,FENDDATEFILED,FCROSSFLAGDETAILDESC,FCROSSFCONE,FSTARTDATEFILED,FENTRYID,FCROSSFLAGCONTENTDESC,FCROSSFLAGCONTENT,FFLAGCONNECTOR,FFLAGDETAILCONNECTOR,FISGROUPCOUNT,FCROSSTYPEID,FCROSSOBJ,FLANDMARKSFILED,FSTARTDATEFILEDDESC,FSEQ,FCROSSFCDESCONE,FCROSSENTITYID,FENDDATEFILEDDESC,FFLAGCONNECTORONE) VALUES ('planstartdate,planenddate',1566033785072498688,'planenddate','单据头.计划开始时间,单据头.计划完成时间',' ','planstartdate',1566033785122831378,'单据头.任务名称','name','-','~','0',1078085411659881472,'1',' ','单据头.计划开始时间',1,' ','pmts_task','单据头.计划完成时间',' ');
DELETE FROM t_msplan_crossset WHERE FENTRYID = 1566033785122831379;
INSERT INTO t_msplan_crossset(FCROSSFLAGDETAILCONTENT,FID,FENDDATEFILED,FCROSSFLAGDETAILDESC,FCROSSFCONE,FSTARTDATEFILED,FENTRYID,FCROSSFLAGCONTENTDESC,FCROSSFLAGCONTENT,FFLAGCONNECTOR,FFLAGDETAILCONNECTOR,FISGROUPCOUNT,FCROSSTYPEID,FCROSSOBJ,FLANDMARKSFILED,FSTARTDATEFILEDDESC,FSEQ,FCROSSFCDESCONE,FCROSSENTITYID,FENDDATEFILEDDESC,FFLAGCONNECTORONE) VALUES (' ',1566033785072498688,'actualdate',' ',' ','actualstartdate',1566033785122831379,' ',' ',' ',' ','0',1078160656248782848,'1',' ','单据头.实际开始时间',2,' ','pmts_task','单据头.实际时间',' ');
DELETE FROM t_msplan_crossset WHERE FENTRYID = 1566033785122831381;
INSERT INTO t_msplan_crossset(FCROSSFLAGDETAILCONTENT,FID,FENDDATEFILED,FCROSSFLAGDETAILDESC,FCROSSFCONE,FSTARTDATEFILED,FENTRYID,FCROSSFLAGCONTENTDESC,FCROSSFLAGCONTENT,FFLAGCONNECTOR,FFLAGDETAILCONNECTOR,FISGROUPCOUNT,FCROSSTYPEID,FCROSSOBJ,FLANDMARKSFILED,FSTARTDATEFILEDDESC,FSEQ,FCROSSFCDESCONE,FCROSSENTITYID,FENDDATEFILEDDESC,FFLAGCONNECTORONE) VALUES ('planstartdate',1566033785072498688,'planenddate','单据头.计划开始时间',' ','planstartdate',1566033785122831381,'单据头.任务名称','name','-','~','0',0,'2',' ','单据头.计划开始时间',3,' ','pmts_task','单据头.计划完成时间',' ');
DELETE FROM t_msplan_crossset WHERE FENTRYID = 1566033785122831382;
INSERT INTO t_msplan_crossset(FCROSSFLAGDETAILCONTENT,FID,FENDDATEFILED,FCROSSFLAGDETAILDESC,FCROSSFCONE,FSTARTDATEFILED,FENTRYID,FCROSSFLAGCONTENTDESC,FCROSSFLAGCONTENT,FFLAGCONNECTOR,FFLAGDETAILCONNECTOR,FISGROUPCOUNT,FCROSSTYPEID,FCROSSOBJ,FLANDMARKSFILED,FSTARTDATEFILEDDESC,FSEQ,FCROSSFCDESCONE,FCROSSENTITYID,FENDDATEFILEDDESC,FFLAGCONNECTORONE) VALUES (' ',1566033785072498688,'bsenddate',' ',' ','bsstartdate',1566033785122831382,' ',' ',' ',' ','0',1078161460598849536,'1',' ','单据头.基线计划开始时间',4,' ','pmts_task','单据头.基线计划完成时间',' ');
DELETE FROM t_msplan_crossset WHERE FENTRYID = 1566033785122831383;
INSERT INTO t_msplan_crossset(FCROSSFLAGDETAILCONTENT,FID,FENDDATEFILED,FCROSSFLAGDETAILDESC,FCROSSFCONE,FSTARTDATEFILED,FENTRYID,FCROSSFLAGCONTENTDESC,FCROSSFLAGCONTENT,FFLAGCONNECTOR,FFLAGDETAILCONNECTOR,FISGROUPCOUNT,FCROSSTYPEID,FCROSSOBJ,FLANDMARKSFILED,FSTARTDATEFILEDDESC,FSEQ,FCROSSFCDESCONE,FCROSSENTITYID,FENDDATEFILEDDESC,FFLAGCONNECTORONE) VALUES (' ',1566033785072498688,'planenddate',' ',' ','planstartdate',1566033785122831383,' ',' ',' ',' ','0',1078186295450442752,'3',' ','单据头.计划开始时间',5,' ','pmts_task','单据头.计划完成时间',' ');
DELETE FROM t_msplan_crossset WHERE FENTRYID = 1566033785122831384;
INSERT INTO t_msplan_crossset(FCROSSFLAGDETAILCONTENT,FID,FENDDATEFILED,FCROSSFLAGDETAILDESC,FCROSSFCONE,FSTARTDATEFILED,FENTRYID,FCROSSFLAGCONTENTDESC,FCROSSFLAGCONTENT,FFLAGCONNECTOR,FFLAGDETAILCONNECTOR,FISGROUPCOUNT,FCROSSTYPEID,FCROSSOBJ,FLANDMARKSFILED,FSTARTDATEFILEDDESC,FSEQ,FCROSSFCDESCONE,FCROSSENTITYID,FENDDATEFILEDDESC,FFLAGCONNECTORONE) VALUES (' ',1566033785072498688,'planenddate',' ',' ','planstartdate',1566033785122831384,' ',' ',' ',' ','0',1458549640033997824,'6',' ','单据头.计划开始时间',6,' ','pmts_task','单据头.计划完成时间',' ');
DELETE FROM t_msplan_crossset WHERE FENTRYID = 1566033785122831385;
INSERT INTO t_msplan_crossset(FCROSSFLAGDETAILCONTENT,FID,FENDDATEFILED,FCROSSFLAGDETAILDESC,FCROSSFCONE,FSTARTDATEFILED,FENTRYID,FCROSSFLAGCONTENTDESC,FCROSSFLAGCONTENT,FFLAGCONNECTOR,FFLAGDETAILCONNECTOR,FISGROUPCOUNT,FCROSSTYPEID,FCROSSOBJ,FLANDMARKSFILED,FSTARTDATEFILEDDESC,FSEQ,FCROSSFCDESCONE,FCROSSENTITYID,FENDDATEFILEDDESC,FFLAGCONNECTORONE) VALUES (' ',1566033785072498688,'planenddate',' ',' ','planstartdate',1566033785122831385,' ',' ',' ',' ','0',1078083769187212288,'1',' ','单据头.计划开始时间',7,' ','pmts_task','单据头.计划完成时间',' ');



DELETE FROM t_msplan_crosscontent WHERE FDETAILID = 1566033785122830351;
INSERT INTO t_msplan_crosscontent(FENTRYCROSSFCDESCONE,FCVIEWALIAS,FCVIEWID,FLTYPEONE,FLABELFORMAT,FENTRYID,FENTRYFLAGCONNECTOR,FLTYPE,FLABELTYPE,FENTRYCROSSFLAGCONTENT,FLABELFORMATTWO,FLABELTYPETWO,FLABELFORMATONE,FENTRYCROSSFLAGDETAILDESC,FENTRYCROSSFLAGDETAILCONT,FLABELTYPEONE,FDETAILID,FCSVIEWSCHEMEID,FENTRYCROSSFCONE,FENTRYCROSSFLAGCONTENTDES,FSEQ,FENTRYFLAGCONNECTORONE,FLTYPEONEWO,FENTRYFLAGDETAILCONNECTOR) VALUES (' ','项目任务分解',1498426799808320512,' ',' ',1566033785122831378,' ',' ',' ','name','yyyy-MM-dd HH:mm:ss,yyyy-MM-dd HH:mm:ss',' ',' ','单据头.计划开始时间,单据头.计划完成时间','planstartdate,planenddate',' ',1566033785122830351,' ',' ','单据头.任务名称',1,' ','1,1',' ');
DELETE FROM t_msplan_crosscontent WHERE FDETAILID = 1566033785122830353;
INSERT INTO t_msplan_crosscontent(FENTRYCROSSFCDESCONE,FCVIEWALIAS,FCVIEWID,FLTYPEONE,FLABELFORMAT,FENTRYID,FENTRYFLAGCONNECTOR,FLTYPE,FLABELTYPE,FENTRYCROSSFLAGCONTENT,FLABELFORMATTWO,FLABELTYPETWO,FLABELFORMATONE,FENTRYCROSSFLAGDETAILDESC,FENTRYCROSSFLAGDETAILCONT,FLABELTYPEONE,FDETAILID,FCSVIEWSCHEMEID,FENTRYCROSSFCONE,FENTRYCROSSFLAGCONTENTDES,FSEQ,FENTRYFLAGCONNECTORONE,FLTYPEONEWO,FENTRYFLAGDETAILCONNECTOR) VALUES (' ','项目任务分解',1498426799808320512,' ',' ',1566033785122831381,' ',' ',' ','name','yyyy-MM-dd HH:mm:ss',' ',' ','单据头.计划开始时间','planstartdate',' ',1566033785122830353,' ',' ','单据头.任务名称',1,' ','1',' ');
DELETE FROM t_msplan_crosscontent WHERE FDETAILID = 1565156743607073806;
INSERT INTO t_msplan_crosscontent(FENTRYCROSSFCDESCONE,FCVIEWALIAS,FCVIEWID,FLTYPEONE,FLABELFORMAT,FENTRYID,FENTRYFLAGCONNECTOR,FLTYPE,FLABELTYPE,FENTRYCROSSFLAGCONTENT,FLABELFORMATTWO,FLABELTYPETWO,FLABELFORMATONE,FENTRYCROSSFLAGDETAILDESC,FENTRYCROSSFLAGDETAILCONT,FLABELTYPEONE,FDETAILID,FCSVIEWSCHEMEID,FENTRYCROSSFCONE,FENTRYCROSSFLAGCONTENTDES,FSEQ,FENTRYFLAGCONNECTORONE,FLTYPEONEWO,FENTRYFLAGDETAILCONNECTOR) VALUES (' ','项目任务分解',1498427393998589952,' ',' ',1565156743607072787,' ',' ',' ','name','yyyy-MM-dd HH:mm:ss,yyyy-MM-dd HH:mm:ss',' ',' ','单据头.计划开始时间,单据头.计划完成时间','planstartdate,planenddate',' ',1565156743607073806,' ',' ','单据头.任务名称',1,' ','1,1',' ');
DELETE FROM t_msplan_crosscontent WHERE FDETAILID = 1565156743607073808;
INSERT INTO t_msplan_crosscontent(FENTRYCROSSFCDESCONE,FCVIEWALIAS,FCVIEWID,FLTYPEONE,FLABELFORMAT,FENTRYID,FENTRYFLAGCONNECTOR,FLTYPE,FLABELTYPE,FENTRYCROSSFLAGCONTENT,FLABELFORMATTWO,FLABELTYPETWO,FLABELFORMATONE,FENTRYCROSSFLAGDETAILDESC,FENTRYCROSSFLAGDETAILCONT,FLABELTYPEONE,FDETAILID,FCSVIEWSCHEMEID,FENTRYCROSSFCONE,FENTRYCROSSFLAGCONTENTDES,FSEQ,FENTRYFLAGCONNECTORONE,FLTYPEONEWO,FENTRYFLAGDETAILCONNECTOR) VALUES (' ','项目任务分解',1498427393998589952,' ',' ',1565156743607072790,' ',' ',' ','name','yyyy-MM-dd HH:mm:ss',' ',' ','单据头.计划开始时间','planstartdate',' ',1565156743607073808,' ',' ','单据头.任务名称',1,' ','1',' ');
DELETE FROM t_msplan_crosscontent WHERE FDETAILID = 1565156743607073807;
INSERT INTO t_msplan_crosscontent(FENTRYCROSSFCDESCONE,FCVIEWALIAS,FCVIEWID,FLTYPEONE,FLABELFORMAT,FENTRYID,FENTRYFLAGCONNECTOR,FLTYPE,FLABELTYPE,FENTRYCROSSFLAGCONTENT,FLABELFORMATTWO,FLABELTYPETWO,FLABELFORMATONE,FENTRYCROSSFLAGDETAILDESC,FENTRYCROSSFLAGDETAILCONT,FLABELTYPEONE,FDETAILID,FCSVIEWSCHEMEID,FENTRYCROSSFCONE,FENTRYCROSSFLAGCONTENTDES,FSEQ,FENTRYFLAGCONNECTORONE,FLTYPEONEWO,FENTRYFLAGDETAILCONNECTOR) VALUES ('单据头.实际完成百分比(%)','项目任务分解',1498427393998589952,'2',' ',1565156743607072788,' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',1565156743607073807,' ','finishpercent',' ',1,' ',' ',' ');
DELETE FROM t_msplan_crosscontent WHERE FDETAILID = 1565156743607073809;
INSERT INTO t_msplan_crosscontent(FENTRYCROSSFCDESCONE,FCVIEWALIAS,FCVIEWID,FLTYPEONE,FLABELFORMAT,FENTRYID,FENTRYFLAGCONNECTOR,FLTYPE,FLABELTYPE,FENTRYCROSSFLAGCONTENT,FLABELFORMATTWO,FLABELTYPETWO,FLABELFORMATONE,FENTRYCROSSFLAGDETAILDESC,FENTRYCROSSFLAGDETAILCONT,FLABELTYPEONE,FDETAILID,FCSVIEWSCHEMEID,FENTRYCROSSFCONE,FENTRYCROSSFLAGCONTENTDES,FSEQ,FENTRYFLAGCONNECTORONE,FLTYPEONEWO,FENTRYFLAGDETAILCONNECTOR) VALUES ('单据头.实际完成百分比(%)','项目任务分解',1498427393998589952,'2',' ',1565156743607072794,' ',' ',' ',' ',' ',' ','%',' ',' ',' ',1565156743607073809,' ','finishpercent',' ',1,' ',' ',' ');
DELETE FROM t_msplan_crosscontent WHERE FDETAILID = 1566033785122830352;
INSERT INTO t_msplan_crosscontent(FENTRYCROSSFCDESCONE,FCVIEWALIAS,FCVIEWID,FLTYPEONE,FLABELFORMAT,FENTRYID,FENTRYFLAGCONNECTOR,FLTYPE,FLABELTYPE,FENTRYCROSSFLAGCONTENT,FLABELFORMATTWO,FLABELTYPETWO,FLABELFORMATONE,FENTRYCROSSFLAGDETAILDESC,FENTRYCROSSFLAGDETAILCONT,FLABELTYPEONE,FDETAILID,FCSVIEWSCHEMEID,FENTRYCROSSFCONE,FENTRYCROSSFLAGCONTENTDES,FSEQ,FENTRYFLAGCONNECTORONE,FLTYPEONEWO,FENTRYFLAGDETAILCONNECTOR) VALUES ('单据头.实际完成百分比(%)','项目任务分解',1498426799808320512,'2',' ',1566033785122831379,' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',1566033785122830352,' ','finishpercent',' ',1,' ',' ',' ');
DELETE FROM t_msplan_crosscontent WHERE FDETAILID = 1566033785122830354;
INSERT INTO t_msplan_crosscontent(FENTRYCROSSFCDESCONE,FCVIEWALIAS,FCVIEWID,FLTYPEONE,FLABELFORMAT,FENTRYID,FENTRYFLAGCONNECTOR,FLTYPE,FLABELTYPE,FENTRYCROSSFLAGCONTENT,FLABELFORMATTWO,FLABELTYPETWO,FLABELFORMATONE,FENTRYCROSSFLAGDETAILDESC,FENTRYCROSSFLAGDETAILCONT,FLABELTYPEONE,FDETAILID,FCSVIEWSCHEMEID,FENTRYCROSSFCONE,FENTRYCROSSFLAGCONTENTDES,FSEQ,FENTRYFLAGCONNECTORONE,FLTYPEONEWO,FENTRYFLAGDETAILCONNECTOR) VALUES ('单据头.实际完成百分比(%)','项目任务分解',1498426799808320512,'2',' ',1566033785122831385,' ',' ',' ',' ',' ',' ','%',' ',' ',' ',1566033785122830354,' ','finishpercent',' ',1,' ',' ',' ');


DELETE FROM t_msplan_crossmoveentry WHERE FDETAILID = 1565156743607072795;
INSERT INTO t_msplan_crossmoveentry(FPARTMOVE,FCMVIEWSCHEMEID,FDETAILID,FENTRYID,FSEQ,FENTIRETYMOVE,FTVIEWALIAS,FTVIEWID) VALUES ('1',' ',1565156743607072795,1565156743607072794,1,'0','项目任务分解',1498427393998589952);
DELETE FROM t_msplan_crossmoveentry WHERE FDETAILID = 1566033785122831386;
INSERT INTO t_msplan_crossmoveentry(FPARTMOVE,FCMVIEWSCHEMEID,FDETAILID,FENTRYID,FSEQ,FENTIRETYMOVE,FTVIEWALIAS,FTVIEWID) VALUES ('1',' ',1566033785122831386,1566033785122831378,1,'1','项目任务分解',1498426799808320512);
DELETE FROM t_msplan_crossmoveentry WHERE FDETAILID = 1566033785122831387;
INSERT INTO t_msplan_crossmoveentry(FPARTMOVE,FCMVIEWSCHEMEID,FDETAILID,FENTRYID,FSEQ,FENTIRETYMOVE,FTVIEWALIAS,FTVIEWID) VALUES ('1',' ',1566033785122831387,1566033785122831379,1,'1','项目任务分解',1498426799808320512);
DELETE FROM t_msplan_crossmoveentry WHERE FDETAILID = 1566033785122831388;
INSERT INTO t_msplan_crossmoveentry(FPARTMOVE,FCMVIEWSCHEMEID,FDETAILID,FENTRYID,FSEQ,FENTIRETYMOVE,FTVIEWALIAS,FTVIEWID) VALUES ('0',' ',1566033785122831388,1566033785122831381,1,'1','项目任务分解',1498426799808320512);
DELETE FROM t_msplan_crossmoveentry WHERE FDETAILID = 1566033785122831389;
INSERT INTO t_msplan_crossmoveentry(FPARTMOVE,FCMVIEWSCHEMEID,FDETAILID,FENTRYID,FSEQ,FENTIRETYMOVE,FTVIEWALIAS,FTVIEWID) VALUES ('1',' ',1566033785122831389,1566033785122831385,1,'0','项目任务分解',1498426799808320512);


DELETE FROM t_msplan_souceviewscheme WHERE FPKID = 1565156743607073801;
INSERT INTO t_msplan_souceviewscheme(FID,FBASEDATAID,FPKID) VALUES (1565156743573519360,1406548060632265728,1565156743607073801);
DELETE FROM t_msplan_souceviewscheme WHERE FPKID = 1566033785122830345;
INSERT INTO t_msplan_souceviewscheme(FID,FBASEDATAID,FPKID) VALUES (1566033785072498688,1406548060632265728,1566033785122830345);

DELETE FROM t_msplan_gttsource WHERE FID = 1565156743573519360;
INSERT INTO t_msplan_gttsource(FPOSTRALATIONFLAG,FGTENTITYID,FMASTERID,FHIGHCOLORVALUE,FPOSTENTITY,FCREATETIME,FENABLE,FPRERALATIONFLAG,FTTIMEFIELD,FID,FRALATIONENTITYID,FHIGHLIGHTGROUPFLAG,FENTITYLAYOUTID,FSTATUS,FHIGHLIGHTGROUP,FNUMBER,FTASKENTITYID,FDATAMODELMUTL,FPRERALATION,FPOSTRALATION,FMODIFIERID,FPREENTITY,FMODIFYTIME,FTTIMEFIELDDESC,FPOSTRALATIONNAME,FCREATORID,FPRERALATIONNAME) VALUES ('postpositiontaskentry',' ',1565156743573519360,' ','postpositiontask',{ts'2022-11-30  00:00:00'},'1','prepositiontaskentry','planstartdate',1565156743573519360,'pmts_task',' ',' ','C',' ','taskplanrelease_S','pmts_task','0','taskrelation','taskrelationtwo',1545846199758652416,'prepositiontask',{ts'2022-12-03  00:00:00'},'单据头.计划开始时间','后置作业关系',1545846199758652416,'前置作业关系');
DELETE FROM t_msplan_gttsource WHERE FID = 1566033785072498688;
INSERT INTO t_msplan_gttsource(FPOSTRALATIONFLAG,FGTENTITYID,FMASTERID,FHIGHCOLORVALUE,FPOSTENTITY,FCREATETIME,FENABLE,FPRERALATIONFLAG,FTTIMEFIELD,FID,FRALATIONENTITYID,FHIGHLIGHTGROUPFLAG,FENTITYLAYOUTID,FSTATUS,FHIGHLIGHTGROUP,FNUMBER,FTASKENTITYID,FDATAMODELMUTL,FPRERALATION,FPOSTRALATION,FMODIFIERID,FPREENTITY,FMODIFYTIME,FTTIMEFIELDDESC,FPOSTRALATIONNAME,FCREATORID,FPRERALATIONNAME) VALUES ('postpositiontaskentry',' ',1566033785072498688,' ','postpositiontask',{ts'2022-12-01  00:00:00'},'1','prepositiontaskentry','planstartdate',1566033785072498688,'pmts_task',' ',' ','C',' ','masterrelease_S','pmts_task','0','taskrelation','taskrelationtwo',1545846199758652416,'prepositiontask',{ts'2022-12-03  00:00:00'},'单据头.计划开始时间','后置作业关系',1545846199758652416,'前置作业关系');

DELETE FROM t_msplan_gttsource_l WHERE FPKID = '2X8HTE0NV8BW';
INSERT INTO t_msplan_gttsource_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1565156743573519360,'2X8HTE0NV8BW','zh_CN','项目计划进度数据源');
DELETE FROM t_msplan_gttsource_l WHERE FPKID = '2X8HTE0NV8BX';
INSERT INTO t_msplan_gttsource_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1565156743573519360,'2X8HTE0NV8BX','zh_TW','項目計劃進度數據源');
DELETE FROM t_msplan_gttsource_l WHERE FPKID = '2XBPODI2FG2E';
INSERT INTO t_msplan_gttsource_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1566033785072498688,'2XBPODI2FG2E','zh_CN','主计划数据源');
DELETE FROM t_msplan_gttsource_l WHERE FPKID = '2XBPODI2FG2F';
INSERT INTO t_msplan_gttsource_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1566033785072498688,'2XBPODI2FG2F','zh_TW','主計劃數據源');




--实体对照数据源
DELETE FROM t_msplan_gemapping WHERE FID = 1565156271789815808;
INSERT INTO t_msplan_gemapping(FID,FCREATETIME,FMODIFIERID,FENABLE,FMODELENTITYID,FMODIFYTIME,FMASTERID,FSTATUS,FVERSIONFIELD,FCREATORID,FDATASOURCEID,FNUMBER) VALUES (1565156271789815808,{ts'2022-11-30  00:00:00'},1545846199758652416,'1','2X8C8DOHS79I',{ts'2022-12-01  00:00:00'},1565156271789815808,'C','version',1545846199758652416,1565156743573519360,'taskplan_release_S');
DELETE FROM t_msplan_gemapping WHERE FID = 1566035614703401984;
INSERT INTO t_msplan_gemapping(FID,FCREATETIME,FMODIFIERID,FENABLE,FMODELENTITYID,FMODIFYTIME,FMASTERID,FSTATUS,FVERSIONFIELD,FCREATORID,FDATASOURCEID,FNUMBER) VALUES (1566035614703401984,{ts'2022-12-01  00:00:00'},1545846199758652416,'1','2XBLJXFQBR41',{ts'2022-12-01  00:00:00'},1566035614703401984,'C','version',1545846199758652416,1566033785072498688,'masterrelease_S');

DELETE FROM t_msplan_gemapping_l WHERE FPKID = '2X8HQ++3D=Y5';
INSERT INTO t_msplan_gemapping_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1565156271789815808,'2X8HQ++3D=Y5','zh_CN','项目计划进度发布实体对照数据源');
DELETE FROM t_msplan_gemapping_l WHERE FPKID = '2X8HQ++3D=Y6';
INSERT INTO t_msplan_gemapping_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1565156271789815808,'2X8HQ++3D=Y6','zh_TW','項目計劃進度發布實體對照數據源');
DELETE FROM t_msplan_gemapping_l WHERE FPKID = '2XBQ/QGEVQCW';
INSERT INTO t_msplan_gemapping_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1566035614703401984,'2XBQ/QGEVQCW','zh_CN','主计划发布实体对照数据源');
DELETE FROM t_msplan_gemapping_l WHERE FPKID = '2XBQ/QGEVQCX';
INSERT INTO t_msplan_gemapping_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1566035614703401984,'2XBQ/QGEVQCX','zh_TW','主計劃發布實體對照數據源');


DELETE FROM t_msplan_entity_condition WHERE FDETAILID = 1565156743607072770;
INSERT INTO t_msplan_entity_condition(FVERSIONFILED,FFIELDSORTFLAG,FDETAILID,FCENTITYID,FCFILTERTEXT,FFIELDSORT,FENTRYID,FSEQ,FCFILTER_TAG,FCFILTER) VALUES ('version','orderno,number',1565156743607072770,'pmts_task','发布状态 等于 已发布 ','单据头.序号,单据头.任务编码',1565156743607073792,1,'{"filterRow":[{"id":"2X8I2L+GALM=","leftBracket":"","compareType":"105","fieldName":"releasestatus","rightBracket":"","logic":"0","value":[{"id":"2X8I2L+GAM=J","value":"1"}],"baseDataIds":[]}],"forList":false}',' ');
DELETE FROM t_msplan_entity_condition WHERE FDETAILID = 1565156743607072771;
INSERT INTO t_msplan_entity_condition(FVERSIONFILED,FFIELDSORTFLAG,FDETAILID,FCENTITYID,FCFILTERTEXT,FFIELDSORT,FENTRYID,FSEQ,FCFILTER_TAG,FCFILTER) VALUES ('version','number',1565156743607072771,'pmts_wbs','发布状态 等于 已发布 ','单据头.WBS编码',1565156743607073792,2,'{"filterRow":[{"id":"2XAOI9IHMR1G","leftBracket":"","compareType":"105","fieldName":"releasestatus","rightBracket":"","logic":"0","value":[{"id":"2XAOI9IHMQD7","value":"1"}],"baseDataIds":[]}],"forList":false}',' ');
DELETE FROM t_msplan_entity_condition WHERE FDETAILID = 1566033785122831360;
INSERT INTO t_msplan_entity_condition(FVERSIONFILED,FFIELDSORTFLAG,FDETAILID,FCENTITYID,FCFILTERTEXT,FFIELDSORT,FENTRYID,FSEQ,FCFILTER_TAG,FCFILTER) VALUES ('version','orderno,number',1566033785122831360,'pmts_task','发布状态 等于 已发布 ','单据头.序号,单据头.任务编码',1566033785122830336,1,'{"filterRow":[{"id":"2XBPMYWY7JZY","leftBracket":"","compareType":"105","fieldName":"releasestatus","rightBracket":"","logic":"0","value":[{"id":"2XBPMYWY7J=O","value":"1"}],"baseDataIds":[]}],"forList":false}',' ');
DELETE FROM t_msplan_entity_condition WHERE FDETAILID = 1566033785122831361;
INSERT INTO t_msplan_entity_condition(FVERSIONFILED,FFIELDSORTFLAG,FDETAILID,FCENTITYID,FCFILTERTEXT,FFIELDSORT,FENTRYID,FSEQ,FCFILTER_TAG,FCFILTER) VALUES ('version','number',1566033785122831361,'pmts_wbs','发布状态 等于 已发布 ','单据头.WBS编码',1566033785122830336,2,'{"filterRow":[{"id":"2XBPNEN5Z219","leftBracket":"","compareType":"105","fieldName":"releasestatus","rightBracket":"","logic":"0","value":[{"id":"2XBPNEN5Z1D/","value":"1"}],"baseDataIds":[]}],"forList":false}',' ');


DELETE FROM t_msplan_entity_relation WHERE FDETAILID = 1565156743607073793;
INSERT INTO t_msplan_entity_relation(FRENTITYID,FDETAILID,FENTRYID,FSEQ,FRENTITYFLAG,FRUPLEVELENTITYID,FRENTITYFLAGDESC,FRENTRYFLAG) VALUES ('pmts_task',1565156743607073793,1565156743607073792,1,'wbs','pmts_wbs','单据头.WBS',' ');
DELETE FROM t_msplan_entity_relation WHERE FDETAILID = 1565156743607073794;
INSERT INTO t_msplan_entity_relation(FRENTITYID,FDETAILID,FENTRYID,FSEQ,FRENTITYFLAG,FRUPLEVELENTITYID,FRENTITYFLAGDESC,FRENTRYFLAG) VALUES ('pmts_wbs',1565156743607073794,1565156743607073792,2,'projectnum','pmpd_project','单据头.项目号',' ');
DELETE FROM t_msplan_entity_relation WHERE FDETAILID = 1565156743607073795;
INSERT INTO t_msplan_entity_relation(FRENTITYID,FDETAILID,FENTRYID,FSEQ,FRENTITYFLAG,FRUPLEVELENTITYID,FRENTITYFLAGDESC,FRENTRYFLAG) VALUES ('pmts_task',1565156743607073795,1565156743607073792,3,'projectnum','pmpd_project','单据头.项目号',' ');
DELETE FROM t_msplan_entity_relation WHERE FDETAILID = 1566033785122830337;
INSERT INTO t_msplan_entity_relation(FRENTITYID,FDETAILID,FENTRYID,FSEQ,FRENTITYFLAG,FRUPLEVELENTITYID,FRENTITYFLAGDESC,FRENTRYFLAG) VALUES ('pmts_task',1566033785122830337,1566033785122830336,1,'wbs','pmts_wbs','单据头.WBS',' ');
DELETE FROM t_msplan_entity_relation WHERE FDETAILID = 1566033785122830338;
INSERT INTO t_msplan_entity_relation(FRENTITYID,FDETAILID,FENTRYID,FSEQ,FRENTITYFLAG,FRUPLEVELENTITYID,FRENTITYFLAGDESC,FRENTRYFLAG) VALUES ('pmts_wbs',1566033785122830338,1566033785122830336,2,'projectnum','pmpd_project','单据头.项目号',' ');
DELETE FROM t_msplan_entity_relation WHERE FDETAILID = 1566033785122830339;
INSERT INTO t_msplan_entity_relation(FRENTITYID,FDETAILID,FENTRYID,FSEQ,FRENTITYFLAG,FRUPLEVELENTITYID,FRENTITYFLAGDESC,FRENTRYFLAG) VALUES ('pmts_task',1566033785122830339,1566033785122830336,3,'projectnum','pmpd_project','单据头.项目号',' ');



