--实体对照数据源
DELETE FROM t_msplan_gemapping WHERE FID = 1562487314511392768;
INSERT INTO t_msplan_gemapping(FID,FCREATETIME,FMODIFIERID,FENABLE,FMODELENTITYID,FMODIFYTIME,FMASTERID,FSTATUS,FVERSIONFIELD,FCREATORID,FDATASOURCEID,FNUMBER) VALUES (1562487314511392768,{ts'2008-08-08  18:08:08'},1,'1','2WXP2WIQGLTA',{ts'2008-08-08  18:08:08'},1562487314511392768,'C','version',1,1562486173987861504,'resourceplan_prehistory_S'); 

DELETE FROM t_msplan_gemapping_L WHERE FPKID = '2WXQ0ARSXQYD';
INSERT INTO t_msplan_gemapping_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1562487314511392768,'2WXQ0ARSXQYD','zh_CN','检修主资源计划预排历史版本预设实体对照数据源'); 
DELETE FROM t_msplan_gemapping_L WHERE FPKID = '2WXQ0ARSXQYE';
INSERT INTO t_msplan_gemapping_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1562487314511392768,'2WXQ0ARSXQYE','zh_TW','檢修主資源計劃預排曆史版本預設實體對照數據源'); 


--数据源
DELETE FROM t_msplan_gttsource WHERE FID = 1562486173987861504;
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 (' ',' ',1562486173987861504,' ',' ',{ts'2008-08-08  18:08:08'},'1','mpdm_workcenter_info','estiapproachtime',1562486173987861504,' ','billno',' ','C','单据头.单据编号','resourceplan_prehistory_S','pmpd_resourceplan','0',' ',' ',1,' ',{ts'2008-08-08  18:08:08'},'单据头.预计进场时间',' ',1,'单据头.mpdm_workcenter_info'); 

DELETE FROM t_msplan_gttsource_L WHERE FPKID = '2WXPU/ONOL1T';
INSERT INTO t_msplan_gttsource_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1562486173987861504,'2WXPU/ONOL1T','zh_CN','检修主资源计划预排历史版本预设数据源'); 
DELETE FROM t_msplan_gttsource_L WHERE FPKID = '2WXPU/ONOL1U';
INSERT INTO t_msplan_gttsource_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1562486173987861504,'2WXPU/ONOL1U','zh_TW','檢修主資源計劃預排曆史版本預設數據源'); 

DELETE FROM t_msplan_souceviewscheme WHERE FPKID = 1562486174180799488;
INSERT INTO t_msplan_souceviewscheme(FID,FBASEDATAID,FPKID) VALUES (1562486173987861504,1453501701427307520,1562486174180799488); 

DELETE FROM t_msplan_entity WHERE FENTRYID = 1562486174172410880;
INSERT INTO t_msplan_entity(FGROUPENTITYID,FFILTERTEXT,FGROUPFIELDDESC,FTASKENTITYFLAGDESC,FFILTER_TAG,FTIMEFIELDDESC,FENTITYID,FUPUPGROUPFIELD,FISMAPPINGENTITY,FSEQ,FUPUPGROUPENTITYID,FVIEWID,FTIMEFIELD,FID,FGROUPFIELD,FUPGROUPENTITYID,FVIEWALIAS,FENTRYID,FUPGROUPFIELDDESC,FGANTTTYPE,FDEFAULTVIEW,FJOINFILTER,FFILTER,FTASKENTITYFLAG,FUPGROUPFIELD,FUPUPGROUPFIELDDESC) VALUES (' ',' ',' ',' ',' ',' ','mpdm_workcenter_info',' ','0',1,' ',1503467625210996736,' ',1562486173987861504,' ',' ','检修工作中心',1562486174172410880,' ','A','0','1',' ',' ',' ',' '); 

DELETE FROM t_msplan_entity_L WHERE FPKID = '2WXPU/ORA/9B';
INSERT INTO t_msplan_entity_L(FPKID,FLOCALEID,FENTRYID,FMVIEWALIAS) VALUES ('2WXPU/ORA/9B','zh_CN',1562486174172410880,'检修工作中心'); 
DELETE FROM t_msplan_entity_L WHERE FPKID = '2WXPU/ORA/9A';
INSERT INTO t_msplan_entity_L(FPKID,FLOCALEID,FENTRYID,FMVIEWALIAS) VALUES ('2WXPU/ORA/9A','zh_TW',1562486174172410880,'檢修工作中心'); 

DELETE FROM t_msplan_entity_condition WHERE FDETAILID = 1562486174172409858;
INSERT INTO t_msplan_entity_condition(FVERSIONFILED,FFIELDSORTFLAG,FDETAILID,FCENTITYID,FCFILTERTEXT,FFIELDSORT,FENTRYID,FSEQ,FCFILTER_TAG,FCFILTER) VALUES ('version',' ',1562486174172409858,'pmpd_resourceplan',' ',' ',1562486174172410880,1,'{"filterRow":[],"forList":false}',' '); 
DELETE FROM t_msplan_entity_condition WHERE FDETAILID = 1562486174172409859;
INSERT INTO t_msplan_entity_condition(FVERSIONFILED,FFIELDSORTFLAG,FDETAILID,FCENTITYID,FCFILTERTEXT,FFIELDSORT,FENTRYID,FSEQ,FCFILTER_TAG,FCFILTER) VALUES (' ','number',1562486174172409859,'mpdm_workcenter_info',' ','单据头.编码',1562486174172410880,2,' ',' '); 

DELETE FROM t_msplan_entity_relation WHERE FDETAILID = 1562486174172410881;
INSERT INTO t_msplan_entity_relation(FRENTITYID,FDETAILID,FENTRYID,FSEQ,FRENTITYFLAG,FRUPLEVELENTITYID,FRENTITYFLAGDESC,FRENTRYFLAG) VALUES ('pmpd_resourceplan',1562486174172410881,1562486174172410880,1,'entry_repair.sectionresource','mpdm_workcenter_info','检修场地时间.分段占用工作中心','entry_repair'); 


DELETE FROM t_msplan_filter WHERE FENTRYID = 1562487169363309568;
INSERT INTO t_msplan_filter(FID,FENTITYCONDFILTER,FENTITYCONDALIGNDESC,FENTITYCONDID,FENTRYID,FISUNLIMITED,FISMULTI,FENTITYCONDFILTER_TAG,FCONTROLRANGEONE,FCONTROLRANGETWO,FCONTROLRANGEFOUR,FCONTROLRANGETHREE,FSEQ,FENTITYCONDALIGN,FENTITYCONDSET) VALUES (1562486173987861504,' ','单据头.版本','mpdm_gantt_version',1562487169363309568,'0','0','{"filterRow":[{"id":"2WXQ+UKQMVZR","leftBracket":"","compareType":"17","fieldName":"versiontype.versionpage.name","rightBracket":"","logic":"0","value":[{"id":"2WXQ+UKQMWN/","value":"检修主资源预排历史版本"}],"baseDataIds":[]}],"forList":false}','1','0','0','0',3,'version','版本类型.版本对应页面.名称 在……中 检修主资源预排历史版本 '); 
DELETE FROM t_msplan_filter WHERE FENTRYID = 1562486174180798466;
INSERT INTO t_msplan_filter(FID,FENTITYCONDFILTER,FENTITYCONDALIGNDESC,FENTITYCONDID,FENTRYID,FISUNLIMITED,FISMULTI,FENTITYCONDFILTER_TAG,FCONTROLRANGEONE,FCONTROLRANGETWO,FCONTROLRANGEFOUR,FCONTROLRANGETHREE,FSEQ,FENTITYCONDALIGN,FENTITYCONDSET) VALUES (1562486173987861504,' ','检修场地时间.分段占用工作中心','mpdm_workcenter_info',1562486174180798466,'1','1','{"filterRow":[{"id":"2VFRUU4VBCQ4","leftBracket":"","compareType":"105","fieldName":"enable","rightBracket":"","logic":"0","value":[{"id":"2VFRUU4VBK3Z","value":"1"}],"baseDataIds":[]},{"id":"2VFRUU4VBCQ5","leftBracket":"","compareType":"105","fieldName":"status","rightBracket":"","logic":"0","value":[{"id":"2VFRUU4VBK4+","value":"C"}],"baseDataIds":[]}],"forList":false}','1','0','0','0',1,'entry_repair.sectionresource','使用状态 等于 可用 并且 数据状态 等于 已审核 '); 
DELETE FROM t_msplan_filter WHERE FENTRYID = 1562486174180798467;
INSERT INTO t_msplan_filter(FID,FENTITYCONDFILTER,FENTITYCONDALIGNDESC,FENTITYCONDID,FENTRYID,FISUNLIMITED,FISMULTI,FENTITYCONDFILTER_TAG,FCONTROLRANGEONE,FCONTROLRANGETWO,FCONTROLRANGEFOUR,FCONTROLRANGETHREE,FSEQ,FENTITYCONDALIGN,FENTITYCONDSET) VALUES (1562486173987861504,' ','单据头.客户编码','bd_customer',1562486174180798467,'1','1','{"filterRow":[{"id":"2UYZO8M9MKSN","leftBracket":"","compareType":"105","fieldName":"status","rightBracket":"","logic":"0","value":[{"id":"2UYZO8M9MLFX","value":"C"}],"baseDataIds":[]},{"id":"2UYZO8M9MKSO","leftBracket":"","compareType":"105","fieldName":"enable","rightBracket":"","logic":"0","value":[{"id":"2UYZO8M9MLFY","value":"1"}],"baseDataIds":[]},{"id":"2UYZO8M9MKSP","leftBracket":"","compareType":"83","fieldName":"number","rightBracket":"","logic":"0","value":[{"id":"2UYZO8M9MLFZ","value":"CUST000002"}],"baseDataIds":[]}],"forList":false}','1','0','0','0',2,'customer','数据状态 等于 已审核 并且 使用状态 等于 可用 并且 编码 不等于 CUST000002 '); 

DELETE FROM t_msplan_filterentry WHERE FDETAILID = 1562486174180799489;
INSERT INTO t_msplan_filterentry(FDETAILID,FCHILDENTITYFLAG,FTOFILTERFLAGDESC,FTOFILTERFLAG,FENTRYID,FSEQ) VALUES (1562486174180799489,'mpdm_workcenter_info','单据头..mpdm_workcenter_info','mpdm_workcenter_info',1562486174180798466,1); 



DELETE FROM t_msplan_crossset WHERE FENTRYID = 1562486174180798468;
INSERT INTO t_msplan_crossset(FID,FCROSSFLAGDETAILCONTENT,FENDDATEFILED,FCROSSFLAGDETAILDESC,FCROSSFCONE,FSTARTDATEFILED,FENTRYID,FCROSSFLAGCONTENTDESC,FCROSSFLAGCONTENT,FFLAGCONNECTOR,FFLAGDETAILCONNECTOR,FISGROUPCOUNT,FCROSSTYPEID,FCROSSOBJ,FLANDMARKSFILED,FSTARTDATEFILEDDESC,FSEQ,FCROSSFCDESCONE,FCROSSENTITYID,FENDDATEFILEDDESC,FFLAGCONNECTORONE) VALUES (1562486173987861504,'estiapproachtime,estideparttime,entry_project.projcet.number,entry_project.projcet.name','entry_repair.sectionendtime','单据头.预计进场时间,单据头.预计离场时间,关联项目编码.项目编号,关联项目编码.项目名称',' ','entry_repair.sectionstarttime',1562486174180798468,'单据头.单据编号,单据头.客户编码.名称','billno,customer.name','|',',','0',1078085411659881472,'1',' ','检修场地时间.分段占用开始时间',1,' ','pmpd_resourceplan','检修场地时间.分段占用结束时间',' '); 


DELETE FROM t_msplan_crosscontent WHERE FDETAILID = 1562486174180799490;
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 (' ','检修工作中心',1503467625210996736,' ',' ',1562486174180798468,'|',' ',' ','billno,customer.name','yyyy-MM-dd,yyyy-MM-dd, ',' ',' ','单据头.预计进场时间,单据头.预计离场时间,单据头.计划检修周期','estiapproachtime,estideparttime,repaircycle',' ',1562486174180799490,'mpdm_workcenter_info',' ','单据头.单据编号,单据头.客户编码.名称',1,' ','1,1, ',','); 

DELETE FROM t_msplan_crossmoveentry WHERE FDETAILID = 1562486174180798469;
INSERT INTO t_msplan_crossmoveentry(FPARTMOVE,FCMVIEWSCHEMEID,FDETAILID,FENTRYID,FSEQ,FENTIRETYMOVE,FTVIEWALIAS,FTVIEWID) VALUES ('0','mpdm_workcenter_info',1562486174180798469,1562486174180798468,1,'0','检修工作中心',1503467625210996736);

DELETE FROM t_msplan_person_color WHERE FENTRYID = 1562486174180799491;
INSERT INTO t_msplan_person_color(FID,FENTRYID,FREMARK,FSEQ,FCOLORCONDFILTER,FCOLORVALUE,FCOLORCONDITON,FCOLORCONDFILTER_TAG) VALUES (1562486173987861504,1562486174180799491,' ',1,' ','rgba(187, 187, 187, 1)','检修场地时间.分段占用工作中心.编码 为 为空 ','{"filterRow":[{"id":"2JQKELXSKCBT","leftBracket":"","compareType":"37","fieldName":"sectionresource.number","rightBracket":"","logic":"0","value":[{"id":"2JQKELXW86RB","value":""}],"baseDataIds":[]}],"forList":false}'); 

