DELETE FROM t_warn_earlywarn WHERE FNUMBER like 'src_%' or FNUMBER like 'tnd_%';
DELETE FROM t_warn_earlywarn_l WHERE FID IN (select fid from t_warn_earlywarn WHERE FNUMBER like 'src_%' or FNUMBER like 'tnd_%');

DELETE FROM t_warn_earlywarn WHERE FID = '1271756115268605952';
INSERT INTO t_warn_earlywarn(FID,FVERSION,FTYPE,FISV,FCREATEDATE,FDATASOURCETYPE,FDATA,FINHERITPATH,FMASTERID,FPARENTID,FDATASOURCEID,FNUMBER,FCONDITIONFORMID,FENABLED,FBIZAPPID,FLEAF,FCREATORID) VALUES ('1271756115268605952',1634805143108,'0','kingdee',{ts'2021-10-21  00:00:00'},'bill',' ','1271756115268605952','1271756115268605952',' ','src_negotiatebill','src_negotiate_tender',' ','0','0DUM2+6E41IA','1',13466739); 
DELETE FROM t_warn_earlywarn WHERE FID = '1271761682955507712';
INSERT INTO t_warn_earlywarn(FID,FVERSION,FTYPE,FISV,FCREATEDATE,FDATASOURCETYPE,FDATA,FINHERITPATH,FMASTERID,FPARENTID,FDATASOURCEID,FNUMBER,FCONDITIONFORMID,FENABLED,FBIZAPPID,FLEAF,FCREATORID) VALUES ('1271761682955507712',1634805806719,'0','kingdee',{ts'2021-10-21  00:00:00'},'bill',' ','1271761682955507712','1271761682955507712',' ','src_project','src_tender_supplier',' ','0','0DUM2+6E41IA','1',13466739); 
DELETE FROM t_warn_earlywarn WHERE FID = '1271769009917842432';
INSERT INTO t_warn_earlywarn(FID,FVERSION,FTYPE,FISV,FCREATEDATE,FDATASOURCETYPE,FDATA,FINHERITPATH,FMASTERID,FPARENTID,FDATASOURCEID,FNUMBER,FCONDITIONFORMID,FENABLED,FBIZAPPID,FLEAF,FCREATORID) VALUES ('1271769009917842432',1634806680146,'0','kingdee',{ts'2021-10-21  00:00:00'},'bill',' ','1271769009917842432','1271769009917842432',' ','tnd_tenderbill','tnd_tender_stoptime',' ','0','0DUMFA=HL9S1','1',13466739); 
DELETE FROM t_warn_earlywarn WHERE FID = '1271771594280195072';
INSERT INTO t_warn_earlywarn(FID,FVERSION,FTYPE,FISV,FCREATEDATE,FDATASOURCETYPE,FDATA,FINHERITPATH,FMASTERID,FPARENTID,FDATASOURCEID,FNUMBER,FCONDITIONFORMID,FENABLED,FBIZAPPID,FLEAF,FCREATORID) VALUES ('1271771594280195072',1634806988225,'0','kingdee',{ts'2021-10-21  00:00:00'},'bill',' ','1271771594280195072','1271771594280195072',' ','tnd_quotebill','tnd_quote_stoptime',' ','0','0DUMFA=HL9S1','1',13466739); 

DELETE FROM t_warn_earlywarn_l WHERE FPKID = '2+6V51E3SLHA';
INSERT INTO t_warn_earlywarn_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1271756115268605952','2+6V51E3SLHA','zh_CN','<?xml version="1.0" encoding="UTF-8"?>

<EarlyWarnMetadata/>
','议价回标情况提醒'); 
DELETE FROM t_warn_earlywarn_l WHERE FPKID = '2+6V51EHCVZZ';
INSERT INTO t_warn_earlywarn_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1271756115268605952','2+6V51EHCVZZ','en_US','<?xml version="1.0" encoding="UTF-8"?>

<EarlyWarnMetadata/>
',' '); 
DELETE FROM t_warn_earlywarn_l WHERE FPKID = '2+6V51EH=99C';
INSERT INTO t_warn_earlywarn_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1271756115268605952','2+6V51EH=99C','zh_TW','<?xml version="1.0" encoding="UTF-8"?>

<EarlyWarnMetadata>
  <WarnElement>
    <EarlyWarnElement>
      <Name>議價回標情況提醒</Name>
    </EarlyWarnElement>
  </WarnElement>
</EarlyWarnMetadata>
','議價回標情況提醒'); 
DELETE FROM t_warn_earlywarn_l WHERE FPKID = '2+6W6M7M4NUY';
INSERT INTO t_warn_earlywarn_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1271761682955507712','2+6W6M7M4NUY','zh_CN','<?xml version="1.0" encoding="UTF-8"?>

<EarlyWarnMetadata/>
','项目回标情况提醒'); 
DELETE FROM t_warn_earlywarn_l WHERE FPKID = '2+6W6M7PVOR0';
INSERT INTO t_warn_earlywarn_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1271761682955507712','2+6W6M7PVOR0','en_US','<?xml version="1.0" encoding="UTF-8"?>

<EarlyWarnMetadata/>
',' '); 
DELETE FROM t_warn_earlywarn_l WHERE FPKID = '2+6W6M7TDH7Z';
INSERT INTO t_warn_earlywarn_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1271761682955507712','2+6W6M7TDH7Z','zh_TW','<?xml version="1.0" encoding="UTF-8"?>

<EarlyWarnMetadata>
  <WarnElement>
    <EarlyWarnElement>
      <Name>項目回標情況提醒</Name>
    </EarlyWarnElement>
  </WarnElement>
</EarlyWarnMetadata>
','項目回標情況提醒'); 
DELETE FROM t_warn_earlywarn_l WHERE FPKID = '2+6XK/FIP27=';
INSERT INTO t_warn_earlywarn_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1271769009917842432','2+6XK/FIP27=','zh_CN','<?xml version="1.0" encoding="UTF-8"?>

<EarlyWarnMetadata/>
','投标截止时间即将到期提醒'); 
DELETE FROM t_warn_earlywarn_l WHERE FPKID = '2+6XK/FILGHP';
INSERT INTO t_warn_earlywarn_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1271769009917842432','2+6XK/FILGHP','en_US','<?xml version="1.0" encoding="UTF-8"?>

<EarlyWarnMetadata/>
',' '); 
DELETE FROM t_warn_earlywarn_l WHERE FPKID = '2+6XK/FMAHDT';
INSERT INTO t_warn_earlywarn_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1271769009917842432','2+6XK/FMAHDT','zh_TW','<?xml version="1.0" encoding="UTF-8"?>

<EarlyWarnMetadata>
  <WarnElement>
    <EarlyWarnElement>
      <Name>投標截止時間即將到期提醒</Name>
    </EarlyWarnElement>
  </WarnElement>
</EarlyWarnMetadata>
','投標截止時間即將到期提醒'); 
DELETE FROM t_warn_earlywarn_l WHERE FPKID = '2+6Y0UXHGF01';
INSERT INTO t_warn_earlywarn_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1271771594280195072','2+6Y0UXHGF01','zh_CN','<?xml version="1.0" encoding="UTF-8"?>

<EarlyWarnMetadata/>
','报价截止时间即将到期提醒'); 
DELETE FROM t_warn_earlywarn_l WHERE FPKID = '2+6Y0UXHCUAG';
INSERT INTO t_warn_earlywarn_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1271771594280195072','2+6Y0UXHCUAG','en_US','<?xml version="1.0" encoding="UTF-8"?>

<EarlyWarnMetadata/>
',' '); 
DELETE FROM t_warn_earlywarn_l WHERE FPKID = '2+6Y0UXHGF02';
INSERT INTO t_warn_earlywarn_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1271771594280195072','2+6Y0UXHGF02','zh_TW','<?xml version="1.0" encoding="UTF-8"?>

<EarlyWarnMetadata>
  <WarnElement>
    <EarlyWarnElement>
      <Name>報價截止時間即將到期提醒</Name>
    </EarlyWarnElement>
  </WarnElement>
</EarlyWarnMetadata>
','報價截止時間即將到期提醒'); 
