
--检修工单完工事件关闭跨行业协调单
DELETE FROM t_evt_event WHERE FID = 1484112500357070848;
INSERT INTO t_evt_event(FID,FMODIFYDATE,FTYPE,FISPREINSDATA,FSCENE,FOPERATION,FCREATEDATE,FENTITY,FOPERNUMBER,FSTATUS,FNUMBER,FMODIFIER,FSOURCE,FNUMBERVIEW,FISMODIFIED,FCREATER) VALUES (1484112500357070848,{ts'2018-08-08  00:00:00'},'cosmic','1','operate','完工',{ts'2018-08-08  00:00:00'},'pom_mroorder','endwork','1','pom_mroorder.endwork',1404334569729074176,'064+TL0DU6T9','pom_mroorder.endwork','1',1404334569729074176); 

DELETE FROM t_evt_event_l WHERE FPKID = '2N=80DFE58L=';
INSERT INTO t_evt_event_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1484112500357070848,'2N=80DFE58L=','zh_CN',' ','检修工单.完工'); 


DELETE FROM t_evt_subscription WHERE FID = 1484113614221626368;
INSERT INTO t_evt_subscription(FID,FMODIFYDATE,FISPREINSDATA,FCONDITION,FSERVICENUMBER,FCREATEDATE,FSEQUENCE,FEXECUTORVALUE,FISCONCURRENT,FSTATUS,FNOTIFYTEXT,FSERVICE,FNUMBER,FSERVICECONFIG,FEXPRESSION,FMODIFIER,FEVENT,FERRORNOTIFY,FEVENTNUMBER,FISMODIFIED,FTIMINGSTRATEGY,FEXECUTOR,FERRORSTRATEGY,FCREATER) VALUES (1484113614221626368,{ts'2018-08-08  00:00:00'},'0',' ','executeOperation',{ts'2018-08-08  00:00:00'},0,' ','1','1',' ',915117758415374336,'pom_mroorder.endwork.executeOperation','{"relationdesc":"执行目标实体操作。关系描述：跨行业协调单是检修工单的BOTP下游实体","optype":"cosmic","entityrange":"anyentity","relationtype":"downStream","operationname":"关闭","filtergridap":"{\"filterRow\":[],\"forList\":false}","evententity":"pom_mroorder","operation":"workclose","targetentity":"pom_coordination"}',' ',1404334569729074176,1484112500357070848,' ','pom_mroorder.endwork','1',' ',' ','retry',1404334569729074176); 

DELETE FROM t_evt_subscription_l WHERE FPKID = '2N=88I+YCVN9';
INSERT INTO t_evt_subscription_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1484113614221626368,'2N=88I+YCVN9','zh_CN','检修工单.完工.执行操作'); 



