-- 删除之前的横道标签设置
delete from t_msplan_crosscontent where fentryid in(select fentryid from t_msplan_crossset where fid in (1454315249627873280,1562486173987861504,1453509389225828352,1454246881835208704,1454313679582445568));


--甘特图数据源
DELETE FROM t_msplan_crosscontent WHERE FDETAILID = 1621632955640201216;
INSERT INTO t_msplan_crosscontent(FENTRYCROSSFCDESCONE,FLABELFLAG,FCVIEWID,FLTYPEONE,FLABELFORMAT,FENTRYFLAGCONNECTOR,FLTYPE,FLABELTYPE,FLABELFORMATONE,FENTRYCROSSFLAGDETAILCONT,FDETAILID,FCSVIEWSCHEMEID,FSEQ,FLTYPEONEWO,FLABELKIND,FENTRYFLAGDETAILCONNECTOR,FCVIEWALIAS,FCUSTOMIMPL,FLABELDESC,FENTRYID,FLBLTYPE,FENTRYCROSSFLAGCONTENT,FLABELFORMATTWO,FLABELTYPETWO,FENTRYCROSSFLAGDETAILDESC,FLABELTYPEONE,FLABELCONNECTOR,FLABLESEAT,FENTRYCROSSFCONE,FENTRYCROSSFLAGCONTENTDES,FLBLFORMAT,FENTRYFLAGCONNECTORONE) VALUES (' ','billno,customer.name',1503467625210996736,' ',' ',' ',' ',' ',' ',' ',1621632955640201216,' ',1,' ','1',' ','检修工作中心',0,'单据头.单据编号,单据头.客户编码.名称',1454246882346887172,' ',' ',' ',' ',' ',' ','|','1',' ',' ',' ',' '); 
DELETE FROM t_msplan_crosscontent WHERE FDETAILID = 1621632955640201217;
INSERT INTO t_msplan_crosscontent(FENTRYCROSSFCDESCONE,FLABELFLAG,FCVIEWID,FLTYPEONE,FLABELFORMAT,FENTRYFLAGCONNECTOR,FLTYPE,FLABELTYPE,FLABELFORMATONE,FENTRYCROSSFLAGDETAILCONT,FDETAILID,FCSVIEWSCHEMEID,FSEQ,FLTYPEONEWO,FLABELKIND,FENTRYFLAGDETAILCONNECTOR,FCVIEWALIAS,FCUSTOMIMPL,FLABELDESC,FENTRYID,FLBLTYPE,FENTRYCROSSFLAGCONTENT,FLABELFORMATTWO,FLABELTYPETWO,FENTRYCROSSFLAGDETAILDESC,FLABELTYPEONE,FLABELCONNECTOR,FLABLESEAT,FENTRYCROSSFCONE,FENTRYCROSSFLAGCONTENTDES,FLBLFORMAT,FENTRYFLAGCONNECTORONE) VALUES (' ','estiapproachtime,estideparttime,repaircycle',1503467625210996736,' ',' ',' ',' ',' ',' ',' ',1621632955640201217,' ',2,' ','1',' ','检修工作中心',0,'单据头.预计进场时间,单据头.预计离场时间,单据头.计划检修周期',1454246882346887172,'1,1, ',' ',' ',' ',' ',' ',',','6',' ',' ','yyyy-MM-dd,yyyy-MM-dd, ',' '); 
DELETE FROM t_msplan_crosscontent WHERE FDETAILID = 1621632955640201218;
INSERT INTO t_msplan_crosscontent(FENTRYCROSSFCDESCONE,FLABELFLAG,FCVIEWID,FLTYPEONE,FLABELFORMAT,FENTRYFLAGCONNECTOR,FLTYPE,FLABELTYPE,FLABELFORMATONE,FENTRYCROSSFLAGDETAILCONT,FDETAILID,FCSVIEWSCHEMEID,FSEQ,FLTYPEONEWO,FLABELKIND,FENTRYFLAGDETAILCONNECTOR,FCVIEWALIAS,FCUSTOMIMPL,FLABELDESC,FENTRYID,FLBLTYPE,FENTRYCROSSFLAGCONTENT,FLABELFORMATTWO,FLABELTYPETWO,FENTRYCROSSFLAGDETAILDESC,FLABELTYPEONE,FLABELCONNECTOR,FLABLESEAT,FENTRYCROSSFCONE,FENTRYCROSSFLAGCONTENTDES,FLBLFORMAT,FENTRYFLAGCONNECTORONE) VALUES (' ','billno,customer.name',1503462016008873984,' ',' ',' ',' ',' ',' ',' ',1621632955640201218,' ',1,' ','1',' ','检修工作中心',0,'单据头.单据编号,单据头.客户编码.名称',1454192508429931520,' ',' ',' ',' ',' ',' ','|','1',' ',' ',' ',' '); 
DELETE FROM t_msplan_crosscontent WHERE FDETAILID = 1621632955640201219;
INSERT INTO t_msplan_crosscontent(FENTRYCROSSFCDESCONE,FLABELFLAG,FCVIEWID,FLTYPEONE,FLABELFORMAT,FENTRYFLAGCONNECTOR,FLTYPE,FLABELTYPE,FLABELFORMATONE,FENTRYCROSSFLAGDETAILCONT,FDETAILID,FCSVIEWSCHEMEID,FSEQ,FLTYPEONEWO,FLABELKIND,FENTRYFLAGDETAILCONNECTOR,FCVIEWALIAS,FCUSTOMIMPL,FLABELDESC,FENTRYID,FLBLTYPE,FENTRYCROSSFLAGCONTENT,FLABELFORMATTWO,FLABELTYPETWO,FENTRYCROSSFLAGDETAILDESC,FLABELTYPEONE,FLABELCONNECTOR,FLABLESEAT,FENTRYCROSSFCONE,FENTRYCROSSFLAGCONTENTDES,FLBLFORMAT,FENTRYFLAGCONNECTORONE) VALUES (' ','estiapproachtime,estideparttime,repaircycle',1503462016008873984,' ',' ',' ',' ',' ',' ',' ',1621632955640201219,' ',2,' ','1',' ','检修工作中心',0,'单据头.预计进场时间,单据头.预计离场时间,单据头.计划检修周期',1454192508429931520,'1,1, ',' ',' ',' ',' ',' ',',','6',' ',' ','yyyy-MM-dd,yyyy-MM-dd, ',' '); 
DELETE FROM t_msplan_crosscontent WHERE FDETAILID = 1621632955640201220;
INSERT INTO t_msplan_crosscontent(FENTRYCROSSFCDESCONE,FLABELFLAG,FCVIEWID,FLTYPEONE,FLABELFORMAT,FENTRYFLAGCONNECTOR,FLTYPE,FLABELTYPE,FLABELFORMATONE,FENTRYCROSSFLAGDETAILCONT,FDETAILID,FCSVIEWSCHEMEID,FSEQ,FLTYPEONEWO,FLABELKIND,FENTRYFLAGDETAILCONNECTOR,FCVIEWALIAS,FCUSTOMIMPL,FLABELDESC,FENTRYID,FLBLTYPE,FENTRYCROSSFLAGCONTENT,FLABELFORMATTWO,FLABELTYPETWO,FENTRYCROSSFLAGDETAILDESC,FLABELTYPEONE,FLABELCONNECTOR,FLABLESEAT,FENTRYCROSSFCONE,FENTRYCROSSFLAGCONTENTDES,FLBLFORMAT,FENTRYFLAGCONNECTORONE) VALUES (' ','billno,customer.name',1503467625210996736,' ',' ',' ',' ',' ',' ',' ',1621632955640201220,' ',1,' ','1',' ','检修工作中心',0,'单据头.单据编号,单据头.客户编码.名称',1562486174180798468,' ',' ',' ',' ',' ',' ','|','1',' ',' ',' ',' '); 
DELETE FROM t_msplan_crosscontent WHERE FDETAILID = 1621632955640201221;
INSERT INTO t_msplan_crosscontent(FENTRYCROSSFCDESCONE,FLABELFLAG,FCVIEWID,FLTYPEONE,FLABELFORMAT,FENTRYFLAGCONNECTOR,FLTYPE,FLABELTYPE,FLABELFORMATONE,FENTRYCROSSFLAGDETAILCONT,FDETAILID,FCSVIEWSCHEMEID,FSEQ,FLTYPEONEWO,FLABELKIND,FENTRYFLAGDETAILCONNECTOR,FCVIEWALIAS,FCUSTOMIMPL,FLABELDESC,FENTRYID,FLBLTYPE,FENTRYCROSSFLAGCONTENT,FLABELFORMATTWO,FLABELTYPETWO,FENTRYCROSSFLAGDETAILDESC,FLABELTYPEONE,FLABELCONNECTOR,FLABLESEAT,FENTRYCROSSFCONE,FENTRYCROSSFLAGCONTENTDES,FLBLFORMAT,FENTRYFLAGCONNECTORONE) VALUES (' ','estiapproachtime,estideparttime,repaircycle',1503467625210996736,' ',' ',' ',' ',' ',' ',' ',1621632955640201221,' ',2,' ','1',' ','检修工作中心',0,'单据头.预计进场时间,单据头.预计离场时间,单据头.计划检修周期',1562486174180798468,'1,1, ',' ',' ',' ',' ',' ',',','6',' ',' ','yyyy-MM-dd,yyyy-MM-dd, ',' '); 
DELETE FROM t_msplan_crosscontent WHERE FDETAILID = 1621632955640201224;
INSERT INTO t_msplan_crosscontent(FENTRYCROSSFCDESCONE,FLABELFLAG,FCVIEWID,FLTYPEONE,FLABELFORMAT,FENTRYFLAGCONNECTOR,FLTYPE,FLABELTYPE,FLABELFORMATONE,FENTRYCROSSFLAGDETAILCONT,FDETAILID,FCSVIEWSCHEMEID,FSEQ,FLTYPEONEWO,FLABELKIND,FENTRYFLAGDETAILCONNECTOR,FCVIEWALIAS,FCUSTOMIMPL,FLABELDESC,FENTRYID,FLBLTYPE,FENTRYCROSSFLAGCONTENT,FLABELFORMATTWO,FLABELTYPETWO,FENTRYCROSSFLAGDETAILDESC,FLABELTYPEONE,FLABELCONNECTOR,FLABLESEAT,FENTRYCROSSFCONE,FENTRYCROSSFLAGCONTENTDES,FLBLFORMAT,FENTRYFLAGCONNECTORONE) VALUES (' ','billno,customer.name',1503462563030001664,' ',' ',' ',' ',' ',' ',' ',1621632955640201224,' ',1,' ','1',' ','检修工作中心',0,'单据头.单据编号,单据头.客户编码.名称',1454313679691498500,' ',' ',' ',' ',' ',' ','|','1',' ',' ',' ',' '); 
DELETE FROM t_msplan_crosscontent WHERE FDETAILID = 1621632955640201225;
INSERT INTO t_msplan_crosscontent(FENTRYCROSSFCDESCONE,FLABELFLAG,FCVIEWID,FLTYPEONE,FLABELFORMAT,FENTRYFLAGCONNECTOR,FLTYPE,FLABELTYPE,FLABELFORMATONE,FENTRYCROSSFLAGDETAILCONT,FDETAILID,FCSVIEWSCHEMEID,FSEQ,FLTYPEONEWO,FLABELKIND,FENTRYFLAGDETAILCONNECTOR,FCVIEWALIAS,FCUSTOMIMPL,FLABELDESC,FENTRYID,FLBLTYPE,FENTRYCROSSFLAGCONTENT,FLABELFORMATTWO,FLABELTYPETWO,FENTRYCROSSFLAGDETAILDESC,FLABELTYPEONE,FLABELCONNECTOR,FLABLESEAT,FENTRYCROSSFCONE,FENTRYCROSSFLAGCONTENTDES,FLBLFORMAT,FENTRYFLAGCONNECTORONE) VALUES (' ','estiapproachtime,estideparttime,repaircycle',1503462563030001664,' ',' ',' ',' ',' ',' ',' ',1621632955640201225,' ',2,' ','1',' ','检修工作中心',0,'单据头.预计进场时间,单据头.预计离场时间,单据头.计划检修周期',1454313679691498500,'1,1, ',' ',' ',' ',' ',' ',',','6',' ',' ','yyyy-MM-dd,yyyy-MM-dd, ',' '); 
DELETE FROM t_msplan_crosscontent WHERE FDETAILID = 1621632955640201226;
INSERT INTO t_msplan_crosscontent(FENTRYCROSSFCDESCONE,FLABELFLAG,FCVIEWID,FLTYPEONE,FLABELFORMAT,FENTRYFLAGCONNECTOR,FLTYPE,FLABELTYPE,FLABELFORMATONE,FENTRYCROSSFLAGDETAILCONT,FDETAILID,FCSVIEWSCHEMEID,FSEQ,FLTYPEONEWO,FLABELKIND,FENTRYFLAGDETAILCONNECTOR,FCVIEWALIAS,FCUSTOMIMPL,FLABELDESC,FENTRYID,FLBLTYPE,FENTRYCROSSFLAGCONTENT,FLABELFORMATTWO,FLABELTYPETWO,FENTRYCROSSFLAGDETAILDESC,FLABELTYPEONE,FLABELCONNECTOR,FLABLESEAT,FENTRYCROSSFCONE,FENTRYCROSSFLAGCONTENTDES,FLBLFORMAT,FENTRYFLAGCONNECTORONE) VALUES (' ','billno,customer.name',1503469288588077056,' ',' ',' ',' ',' ',' ',' ',1621632955640201226,' ',1,' ','1',' ','检修工作中心',0,'单据头.单据编号,单据头.客户编码.名称',1454315249720148996,' ',' ',' ',' ',' ',' ','|','1',' ',' ',' ',' '); 
DELETE FROM t_msplan_crosscontent WHERE FDETAILID = 1621632955640201227;
INSERT INTO t_msplan_crosscontent(FENTRYCROSSFCDESCONE,FLABELFLAG,FCVIEWID,FLTYPEONE,FLABELFORMAT,FENTRYFLAGCONNECTOR,FLTYPE,FLABELTYPE,FLABELFORMATONE,FENTRYCROSSFLAGDETAILCONT,FDETAILID,FCSVIEWSCHEMEID,FSEQ,FLTYPEONEWO,FLABELKIND,FENTRYFLAGDETAILCONNECTOR,FCVIEWALIAS,FCUSTOMIMPL,FLABELDESC,FENTRYID,FLBLTYPE,FENTRYCROSSFLAGCONTENT,FLABELFORMATTWO,FLABELTYPETWO,FENTRYCROSSFLAGDETAILDESC,FLABELTYPEONE,FLABELCONNECTOR,FLABLESEAT,FENTRYCROSSFCONE,FENTRYCROSSFLAGCONTENTDES,FLBLFORMAT,FENTRYFLAGCONNECTORONE) VALUES (' ','estiapproachtime,estideparttime,repaircycle',1503469288588077056,' ',' ',' ',' ',' ',' ',' ',1621632955640201227,' ',2,' ','1',' ','检修工作中心',0,'单据头.预计进场时间,单据头.预计离场时间,单据头.计划检修周期',1454315249720148996,'1,1, ',' ',' ',' ',' ',' ',',','6',' ',' ','yyyy-MM-dd,yyyy-MM-dd, ',' '); 



--设置预制数据为预设数据
update t_msplan_gttsource set fispreset ='1',fischange='1' where fid in (1454315249627873280,1562486173987861504,1453509389225828352,1454246881835208704,1454313679582445568);
